APPS.PA_TRX_IMPORT dependencies on PO_DISTRIBUTIONS_ALL

Line 10106: from po_distributions_all

10102: where request_id = g_request_id
10103: and status_code = 'P'
10104: and (document_header_id, document_distribution_id) in
10105: (select po_header_id, po_distribution_id
10106: from po_distributions_all
10107: where po_distribution_id in
10108: (select po_distribution_id
10109: from ap_invoice_distributions_all inv, pa_transaction_interface_all pti
10110: where inv.invoice_id = pti.cdl_system_reference2

Line 12155: FROM po_distributions_all

12151: AND invoice_distribution_id = p_sys_ref5;
12152:
12153: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
12154: SELECT po_line_id
12155: FROM po_distributions_all
12156: WHERE po_distribution_id = p_po_dist_id;
12157:
12158: -- R12 Funds Management : This cursor can fetches both Raw and Burden Lines for commitment
12159: -- to be relieved.

Line 12270: l_po_line_id po_distributions_all.po_line_id%TYPE;

12266: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
12267: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
12268: L_RAW_BC_PACKET_ID NUMBER;
12269: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
12270: l_po_line_id po_distributions_all.po_line_id%TYPE;
12271:
12272:
12273: CURSOR c_curr_raw_pkt IS
12274: SELECT bc_packet_id

Line 13039: FROM po_distributions_all

13035: AND invoice_distribution_id = p_sys_ref5;
13036:
13037: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13038: SELECT po_line_id
13039: FROM po_distributions_all
13040: WHERE po_distribution_id = p_po_dist_id;
13041:
13042: Cursor C_Ap_Commitment Is
13043: Select bcc.Set_Of_Books_Id

Line 13119: l_po_line_id po_distributions_all.po_line_id%TYPE;

13115: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
13116: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
13117: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
13118: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
13119: l_po_line_id po_distributions_all.po_line_id%TYPE;
13120:
13121: BEGIN
13122:
13123: IF PG_DEBUG = 'Y' THEN

Line 13926: FROM po_distributions_all

13922: FROM dual;
13923:
13924: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13925: SELECT po_line_id
13926: FROM po_distributions_all
13927: WHERE po_distribution_id = p_po_dist_id;
13928:
13929: Cursor C_po_Commitment Is
13930: Select bcc.Set_Of_Books_Id

Line 14016: l_po_line_id po_distributions_all.po_line_id%TYPE;

14012:
14013: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
14014: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
14015: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
14016: l_po_line_id po_distributions_all.po_line_id%TYPE;
14017:
14018: BEGIN
14019:
14020: IF PG_DEBUG = 'Y' THEN