APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_SUPPLIERS

Line 579: V_NEW_VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE;

575: L_MSG_COUNT NUMBER;
576: L_RETURN_STATUS VARCHAR2(1);
577: V_NEW_VENDOR_ID NUMBER;
578: V_OLD_VENDOR_ID NUMBER;
579: V_NEW_VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE;
580: V_OLD_VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE;
581: V_DUP_HIST_INVOICE VARCHAR2(50);
582: V_INV_NUM_LENGTH NUMBER;
583: V_OLD_VENDOR_NUM_LENGTH NUMBER;

Line 580: V_OLD_VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE;

576: L_RETURN_STATUS VARCHAR2(1);
577: V_NEW_VENDOR_ID NUMBER;
578: V_OLD_VENDOR_ID NUMBER;
579: V_NEW_VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE;
580: V_OLD_VENDOR_NAME AP_SUPPLIERS.VENDOR_NAME%TYPE;
581: V_DUP_HIST_INVOICE VARCHAR2(50);
582: V_INV_NUM_LENGTH NUMBER;
583: V_OLD_VENDOR_NUM_LENGTH NUMBER;
584: V_NEW_VENDOR_NUM_LENGTH NUMBER;

Line 674: AP_SUPPLIERS PV1,

670: LENGTH(PV2.SEGMENT1)
671: INTO V_OLD_VENDOR_NAME,V_OLD_VENDOR_NUM,V_OLD_VENDOR_NUM_LENGTH,
672: V_NEW_VENDOR_NAME,V_NEW_VENDOR_NUM,V_NEW_VENDOR_NUM_LENGTH
673: FROM
674: AP_SUPPLIERS PV1,
675: AP_SUPPLIERS PV2
676: WHERE PV1.VENDOR_ID = V_OLD_VENDOR_ID
677: AND PV2.VENDOR_ID = V_NEW_VENDOR_ID;
678: OPEN C_DUP_HISTORY;

Line 675: AP_SUPPLIERS PV2

671: INTO V_OLD_VENDOR_NAME,V_OLD_VENDOR_NUM,V_OLD_VENDOR_NUM_LENGTH,
672: V_NEW_VENDOR_NAME,V_NEW_VENDOR_NUM,V_NEW_VENDOR_NUM_LENGTH
673: FROM
674: AP_SUPPLIERS PV1,
675: AP_SUPPLIERS PV2
676: WHERE PV1.VENDOR_ID = V_OLD_VENDOR_ID
677: AND PV2.VENDOR_ID = V_NEW_VENDOR_ID;
678: OPEN C_DUP_HISTORY;
679: LOOP

Line 801: AP_SUPPLIERS

797: AND NVL(INACTIVE_DATE
798: ,SYSDATE + 1) > sysdate;
799: IF L_NUMBER_OF_OTHER_SITES = 0 THEN
800: UPDATE
801: AP_SUPPLIERS
802: SET
803: END_DATE_ACTIVE = SYSDATE
804: ,LAST_UPDATE_DATE = SYSDATE
805: ,LAST_UPDATED_BY = P_LAST_UPDATED_BY_T