APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_INVOICES_ALL

Line 256: AP_INVOICES_ALL AI

252: CURSOR L_INVOICE_MERGED_CUR IS
253: SELECT
254: AI.INVOICE_ID INVOICE_ID
255: FROM
256: AP_INVOICES_ALL AI
257: WHERE AI.INVOICE_ID = C_INVOICE_ID
258: AND EXISTS (
259: SELECT
260: 'Y'

Line 288: AP_INVOICES_ALL

284: WHERE EXISTS (
285: SELECT
286: 'Duplicates exist in ap_invoices'
287: FROM
288: AP_INVOICES_ALL
289: WHERE INVOICE_NUM = C_INVOICE_NUM
290: AND VENDOR_ID = C_VENDOR_ID
291: AND INVOICE_ID <> C_INVOICE_ID )
292: OR EXISTS (

Line 305: AP_INVOICES_ALL

301: EXCEPTION
302: WHEN NO_DATA_FOUND THEN
303: BEGIN
304: UPDATE
305: AP_INVOICES_ALL
306: SET
307: VENDOR_ID = C_VENDOR_ID
308: ,VENDOR_SITE_ID = C_VENDOR_SITE_ID
309: ,PARTY_ID = C_PARTY_ID

Line 738: AP_INVOICES_ALL AI

734: AND NOT EXISTS (
735: SELECT
736: 'Invoice Num exists as an invoice'
737: FROM
738: AP_INVOICES_ALL AI
739: WHERE AI.INVOICE_NUM = AHI.INVOICE_NUM
740: AND AI.VENDOR_ID = V_NEW_VENDOR_ID );
741: IGI_VENDOR_MERGE_GRP.MERGE_VENDOR(P_API_VERSION => 1.0
742: ,P_INIT_MSG_LIST => NULL