APPS.AP_LINES_UPGRADE_SYNC_PKG dependencies on AP_INVOICE_LINES_ALL

Line 24: -- ap_invoice_lines_all and ap_inv_dists_update table and

20: -- Procedure delete_lines_dists
21: -- Purpose
22: -- This procedure DELETE_LINES_DISTS deletes the lines and the
23: -- the distributions that are already existing in the
24: -- ap_invoice_lines_all and ap_inv_dists_update table and
25: -- MRC lines and dists table.
26: ------------------------------------------------------------------
27: PROCEDURE Delete_Lines_Dists
28: (p_calling_sequence VARCHAR2) IS

Line 55: DELETE FROM AP_Invoice_Lines_All

51: FROM AP_Lines_Upg_Sync_Data;
52:
53:
54: FORALL i IN 1..sync_invs.COUNT
55: DELETE FROM AP_Invoice_Lines_All
56: WHERE invoice_id = sync_invs(i);
57:
58: FORALL i IN 1..sync_invs.COUNT
59: DELETE FROM AP_Inv_Dists_Target

Line 888: INSERT INTO ap_invoice_lines_all t1

884: one line per distribution and copy the distribution_line_number as the
885: invoice_line_number
886: */
887:
888: INSERT INTO ap_invoice_lines_all t1
889: (INVOICE_ID,
890: LINE_NUMBER,
891: LINE_TYPE_LOOKUP_CODE,
892: REQUESTER_ID,