APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_DUPLICATE_VENDORS

Line 15: AP_DUPLICATE_VENDORS

11:
12: FUNCTION CUSTOM_INIT RETURN BOOLEAN IS
13: BEGIN
14: UPDATE
15: AP_DUPLICATE_VENDORS
16: SET
17: PROCESS_FLAG = 'S'
18: WHERE PROCESS_FLAG = 'N';
19: RETURN (TRUE);

Line 145: AP_DUPLICATE_VENDORS

141: AP_VENDOR_PARTY_MERGE_PKG.OTHER_PRODUCTS_VENDORMERGE;
142: MO_GLOBAL.SET_POLICY_CONTEXT('M'
143: ,NULL);
144: UPDATE
145: AP_DUPLICATE_VENDORS
146: SET
147: PROCESS_FLAG = 'Y'
148: WHERE PROCESS_FLAG = 'S';
149: UPDATE

Line 150: AP_DUPLICATE_VENDORS

146: SET
147: PROCESS_FLAG = 'Y'
148: WHERE PROCESS_FLAG = 'S';
149: UPDATE
150: AP_DUPLICATE_VENDORS
151: SET
152: PROCESS_FLAG = 'N'
153: WHERE PROCESS_FLAG = 'D';
154: IF (P_DEBUG_SWITCH = 'Y') THEN

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

Line 1324: AP_DUPLICATE_VENDORS

1320: DUPLICATE_VENDOR_ID,
1321: DUPLICATE_VENDOR_SITE_ID,
1322: ORG_ID
1323: FROM
1324: AP_DUPLICATE_VENDORS
1325: WHERE PROCESS_FLAG = 'S') LOOP
1326: SELECT
1327: TAX_REPORTING_SITE_FLAG,
1328: INACTIVE_DATE