APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_INVOICE_LINES_ALL

Line 45: -- ap_invoice_lines_all and ap_inv_dists_update table and

41: -- Procedure delete_lines_dists
42: -- Purpose
43: -- This procedure DELETE_LINES_DISTS deletes the lines and the
44: -- the distributions that are already existing in the
45: -- ap_invoice_lines_all and ap_inv_dists_update table and
46: -- MRC lines and dists table.
47: ------------------------------------------------------------------
48: PROCEDURE Delete_Lines_Dists
49: (p_calling_sequence VARCHAR2) IS

Line 76: DELETE FROM AP_Invoice_Lines_All

72: FROM AP_Lines_Upg_Sync_Data;
73:
74:
75: FORALL i IN 1..sync_invs.COUNT
76: DELETE FROM AP_Invoice_Lines_All
77: WHERE invoice_id = sync_invs(i);
78:
79: FORALL i IN 1..sync_invs.COUNT
80: DELETE FROM AP_Inv_Dists_Target

Line 909: INSERT INTO ap_invoice_lines_all t1

905: one line per distribution and copy the distribution_line_number as the
906: invoice_line_number
907: */
908:
909: INSERT INTO ap_invoice_lines_all t1
910: (INVOICE_ID,
911: LINE_NUMBER,
912: LINE_TYPE_LOOKUP_CODE,
913: REQUESTER_ID,