APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_DUPLICATE_VENDORS_ALL

Line 573: L_PROCESS AP_DUPLICATE_VENDORS_ALL.PROCESS%TYPE;

569: L_MERGING_PPSITE VARCHAR2(1);
570: L_PPSITES NUMBER;
571: STATUS VARCHAR2(1);
572: INDUSTRY VARCHAR2(1);
573: L_PROCESS AP_DUPLICATE_VENDORS_ALL.PROCESS%TYPE;
574: L_MSG_DATA VARCHAR2(2000);
575: L_MSG_COUNT NUMBER;
576: L_RETURN_STATUS VARCHAR2(1);
577: V_NEW_VENDOR_ID NUMBER;

Line 610: AP_DUPLICATE_VENDORS_ALL

606: P_PRIMARY_PAY := 'N';
607: IF (C_DUP_INVOICE_COUNT + C_DUP_RECURRING_COUNT > 0) THEN
608: IF C_KEEP_SITE_FLAG = 'Y' THEN
609: UPDATE
610: AP_DUPLICATE_VENDORS_ALL
611: SET
612: VENDOR_SITE_ID = C_VENDOR_SITE_ID
613: ,KEEP_SITE_FLAG = 'N'
614: WHERE ENTRY_ID = C_ENTRY_ID;

Line 617: AP_DUPLICATE_VENDORS_ALL

613: ,KEEP_SITE_FLAG = 'N'
614: WHERE ENTRY_ID = C_ENTRY_ID;
615: END IF;
616: UPDATE
617: AP_DUPLICATE_VENDORS_ALL
618: SET
619: PROCESS_FLAG = 'D'
620: WHERE ENTRY_ID = C_ENTRY_ID;
621: ELSE

Line 623: AP_DUPLICATE_VENDORS_ALL

619: PROCESS_FLAG = 'D'
620: WHERE ENTRY_ID = C_ENTRY_ID;
621: ELSE
622: UPDATE
623: AP_DUPLICATE_VENDORS_ALL
624: SET
625: LAST_UPDATE_DATE = SYSDATE
626: ,LAST_UPDATED_BY = P_LAST_UPDATED_BY_T
627: ,NUMBER_PAID_INVOICES = NVL(NUMBER_PAID_INVOICES

Line 785: AP_DUPLICATE_VENDORS_ALL DV,

781: DV.ORG_ID,
782: VS.VENDOR_SITE_CODE,
783: VS.PARTY_SITE_ID
784: FROM
785: AP_DUPLICATE_VENDORS_ALL DV,
786: AP_SUPPLIER_SITES_ALL VS
787: WHERE PROCESS_FLAG = 'S'
788: AND VS.VENDOR_SITE_ID = DV.DUPLICATE_VENDOR_SITE_ID
789: AND VS.ORG_ID = DV.ORG_ID) LOOP

Line 1208: AP_DUPLICATE_VENDORS_ALL

1204: ,P_NEW_VENDOR_SITE_ID => C_VENDOR_SITE_ID_PO
1205: ,P_OLD_VENDOR_ID => C_DUP_VENDOR_ID_PO
1206: ,P_OLD_VENDOR_SITE_ID => C_DUP_VENDOR_SITE_ID_PO);
1207: UPDATE
1208: AP_DUPLICATE_VENDORS_ALL
1209: SET
1210: LAST_UPDATE_DATE = SYSDATE
1211: ,LAST_UPDATED_BY = P_LAST_UPDATED_BY_T
1212: ,NUMBER_PO_HEADERS_CHANGED = NVL(NUMBER_PO_HEADERS_CHANGED