create or replace PROCEDURE USP_SAVE_CUSTOMERS
(
P_CUSTOMERNAME IN VARCHAR2
, P_CONTACTPERSON IN VARCHAR2
, P_PHONE IN VARCHAR2
, P_EMAIL IN VARCHAR2
, P_ADDRESS1 IN VARCHAR2
, P_ADDRESS2 IN VARCHAR2
, P_CITY IN VARCHAR2
, P_STATE IN VARCHAR2
, P_ZIP IN VARCHAR2
, P_DESCRIPTION IN VARCHAR2
, P_ISACTIVE IN NUMBER
, P_CREATEDBY IN NUMBER
)
AS
BEGIN
INSERT INTO TBL_CUSTOMER
(
CUSTOMERNAME,
CONTACTPERSON,
PHONE,
EMAIL,
ADDRESS1,
ADDRESS2,
CITY,
STATE,
ZIP,
DESCRIPTION,
STATUS,
CREATEDBY,
MODIFIEDDATE,
MODIFIEDBY
)
VALUES
(
P_CUSTOMERNAME
, P_CONTACTPERSON
, P_PHONE
, P_EMAIL
, P_ADDRESS1
, P_ADDRESS2
, P_CITY
, P_STATE
, P_ZIP
, P_DESCRIPTION
, P_ISACTIVE
,P_CREATEDBY
,(TO_CHAR(SYSDATE))
,P_CREATEDBY
);
COMMIT ;
END USP_SAVE_CUSTOMERS;
(
P_CUSTOMERNAME IN VARCHAR2
, P_CONTACTPERSON IN VARCHAR2
, P_PHONE IN VARCHAR2
, P_EMAIL IN VARCHAR2
, P_ADDRESS1 IN VARCHAR2
, P_ADDRESS2 IN VARCHAR2
, P_CITY IN VARCHAR2
, P_STATE IN VARCHAR2
, P_ZIP IN VARCHAR2
, P_DESCRIPTION IN VARCHAR2
, P_ISACTIVE IN NUMBER
, P_CREATEDBY IN NUMBER
)
AS
BEGIN
INSERT INTO TBL_CUSTOMER
(
CUSTOMERNAME,
CONTACTPERSON,
PHONE,
EMAIL,
ADDRESS1,
ADDRESS2,
CITY,
STATE,
ZIP,
DESCRIPTION,
STATUS,
CREATEDBY,
MODIFIEDDATE,
MODIFIEDBY
)
VALUES
(
P_CUSTOMERNAME
, P_CONTACTPERSON
, P_PHONE
, P_EMAIL
, P_ADDRESS1
, P_ADDRESS2
, P_CITY
, P_STATE
, P_ZIP
, P_DESCRIPTION
, P_ISACTIVE
,P_CREATEDBY
,(TO_CHAR(SYSDATE))
,P_CREATEDBY
);
COMMIT ;
END USP_SAVE_CUSTOMERS;
No comments:
Post a Comment