/* Formatted on 06-Jul-18 3:11:52 PM (QP5 v5.149.1003.31008) */
DECLARE
P_PARTY_ID NUMBER;
P_VENDOR_ID NUMBER;
P_LOOKUP_CODE VARCHAR2 (32767);
P_EXP_DATE DATE;
P_CERT_NUM VARCHAR2 (32767);
P_CERT_AGENCY VARCHAR2 (32767);
P_EXT_ATTR_1 VARCHAR2 (32767);
P_CLASS_STATUS VARCHAR2 (32767);
P_REQUEST_ID NUMBER;
X_CLASSIFICATION_ID NUMBER;
X_STATUS VARCHAR2 (32767);
X_EXCEPTION_MSG VARCHAR2 (32767);
BEGIN
P_PARTY_ID := NULL;
P_VENDOR_ID := NULL;
P_LOOKUP_CODE := NULL;
P_EXP_DATE := NULL;
P_CERT_NUM := NULL;
P_CERT_AGENCY := NULL;
P_EXT_ATTR_1 := NULL;
P_CLASS_STATUS := NULL;
P_REQUEST_ID := NULL;
X_CLASSIFICATION_ID := NULL;
X_STATUS := NULL;
X_EXCEPTION_MSG := NULL;
APPS.POS_SUPP_CLASSIFICATION_PKG.ADD_BUS_CLASS_ATTR (P_PARTY_ID,
P_VENDOR_ID,
P_LOOKUP_CODE,
P_EXP_DATE,
P_CERT_NUM,
P_CERT_AGENCY,
P_EXT_ATTR_1,
P_CLASS_STATUS,
P_REQUEST_ID,
X_CLASSIFICATION_ID,
X_STATUS,
X_EXCEPTION_MSG);
COMMIT;
END;
DECLARE
P_PARTY_ID NUMBER;
P_VENDOR_ID NUMBER;
P_LOOKUP_CODE VARCHAR2 (32767);
P_EXP_DATE DATE;
P_CERT_NUM VARCHAR2 (32767);
P_CERT_AGENCY VARCHAR2 (32767);
P_EXT_ATTR_1 VARCHAR2 (32767);
P_CLASS_STATUS VARCHAR2 (32767);
P_REQUEST_ID NUMBER;
X_CLASSIFICATION_ID NUMBER;
X_STATUS VARCHAR2 (32767);
X_EXCEPTION_MSG VARCHAR2 (32767);
BEGIN
P_PARTY_ID := NULL;
P_VENDOR_ID := NULL;
P_LOOKUP_CODE := NULL;
P_EXP_DATE := NULL;
P_CERT_NUM := NULL;
P_CERT_AGENCY := NULL;
P_EXT_ATTR_1 := NULL;
P_CLASS_STATUS := NULL;
P_REQUEST_ID := NULL;
X_CLASSIFICATION_ID := NULL;
X_STATUS := NULL;
X_EXCEPTION_MSG := NULL;
APPS.POS_SUPP_CLASSIFICATION_PKG.ADD_BUS_CLASS_ATTR (P_PARTY_ID,
P_VENDOR_ID,
P_LOOKUP_CODE,
P_EXP_DATE,
P_CERT_NUM,
P_CERT_AGENCY,
P_EXT_ATTR_1,
P_CLASS_STATUS,
P_REQUEST_ID,
X_CLASSIFICATION_ID,
X_STATUS,
X_EXCEPTION_MSG);
COMMIT;
END;