[Home] [Help]
10438: a.budget_version_id
10439: from pa_bc_packets a,
10440: pa_transaction_interface b, -- moac changes
10441: ap_invoice_distributions c,
10442: po_distributions d
10443: where a.txn_interface_id = b.txn_interface_id
10444: and a.document_header_id = d.po_header_id
10445: and a.document_distribution_id = d.po_distribution_id
10446: and c.invoice_id = b.cdl_system_reference2
10463: a.budget_version_id
10464: from pa_bc_packets a,
10465: pa_transaction_interface b,
10466: ap_self_assessed_tax_dist c,
10467: po_distributions d
10468: where a.txn_interface_id = b.txn_interface_id
10469: and a.document_header_id = d.po_header_id
10470: and a.document_distribution_id = d.po_distribution_id
10471: and c.invoice_id = b.cdl_system_reference2
10920: where request_id = g_request_id
10921: and status_code = 'P'
10922: and (document_header_id, document_distribution_id) in
10923: (select po_header_id, po_distribution_id
10924: from po_distributions_all
10925: where po_distribution_id in
10926: (select po_distribution_id
10927: from ap_invoice_distributions_all inv, pa_transaction_interface_all pti
10928: where inv.invoice_id = pti.cdl_system_reference2
11237: Select nvl(accrue_on_receipt_flag,'N'),
11238: po_header_id
11239: Into l_acc_flag,
11240: l_po_hdr_id
11241: from Po_distributions
11242: where po_distribution_id = l_po_dist_id;
11243:
11244: IF PG_DEBUG = 'Y' THEN
11245: log_message('log_message: ' || 'Receipt Acc Flag = ' || l_acc_flag || ' Po Hdr = ' || l_po_hdr_id);
11651:
11652: select sum(nvl(accounted_dr,0)-nvl(accounted_cr,0)),SUM(POD.rate)/SUM(1)
11653: into l_pkt_summ,l_pkt_rate
11654: from pa_bc_packets bcc,
11655: po_distributions pod --Added for Bug#3693974
11656: where pod.po_header_id = p_sys_ref2
11657: and pod.po_distribution_id = p_sys_ref3
11658: and ((
11659: bcc.document_type = 'PO'
11678:
11679: select sum(nvl(accounted_dr,0)-nvl(accounted_cr,0)),SUM(POD.rate)/SUM(1)
11680: into l_com_summ,l_com_rate
11681: from pa_bc_commitments bcc,
11682: po_distributions pod --Added for Bug#3693974
11683: where pod.po_header_id = p_sys_ref2
11684: and pod.po_distribution_id = p_sys_ref3
11685: and ((
11686: bcc.document_type = 'PO'
13057: AND invoice_distribution_id = p_sys_ref5;
13058:
13059: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13060: SELECT po_line_id
13061: FROM po_distributions_all
13062: WHERE po_distribution_id = p_po_dist_id;
13063:
13064: CURSOR c_get_vendor_id IS
13065: SELECT a.vendor_id
13185: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
13186: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
13187: L_RAW_BC_PACKET_ID NUMBER;
13188: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
13189: l_po_line_id po_distributions_all.po_line_id%TYPE;
13190: l_vendor_id ap_invoices_all.vendor_id%TYPE; /*bug 13601768*/
13191:
13192: CURSOR c_curr_raw_pkt IS
13193: SELECT bc_packet_id
13970: AND invoice_distribution_id = p_sys_ref5 ;
13971:
13972: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
13973: SELECT po_line_id
13974: FROM po_distributions_all
13975: WHERE po_distribution_id = p_po_dist_id;
13976:
13977: /*bug 13601768*/
13978: CURSOR c_get_vendor_id IS
14064: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
14065: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
14066: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
14067: l_po_dist_id ap_invoice_distributions.po_distribution_id%TYPE;
14068: l_po_line_id po_distributions_all.po_line_id%TYPE;
14069: l_vendor_id ap_invoices_all.vendor_id%TYPE; /*bug 13601768*/
14070:
14071: BEGIN
14072:
14882: FROM dual;
14883:
14884: CURSOR c_get_po_LINE_id (p_po_dist_id NUMBER) IS
14885: SELECT po_line_id
14886: FROM po_distributions_all
14887: WHERE po_distribution_id = p_po_dist_id;
14888:
14889: -- Added for 13966205
14890: CURSOR C_GET_EI_DATE IS
14919: ,bcc.packet_id
14920: ,bcc.bc_commitment_id
14921: ,bcc.vendor_id
14922: From Pa_Bc_Commitments_all bcc,
14923: po_distributions pod
14924: -- R12 Funds management Uptake : For fixing performance issues removing the code for CC which is obsolete for R12
14925: -- Modifying code to use Index on document_header_id and document_distribution_id of bc commitments
14926: where bcc.document_header_id = pod.po_header_id
14927: and bcc.document_distribution_id = pod.po_distribution_id
14964: ,bcc.vendor_id
14965: -- R12 Funds management Uptake : For fixing performance issues removing the code for CC which is obsolete for R12
14966: -- Modifying code to use Index on document_header_id and document_distribution_id of bc commitments
14967: From Pa_Bc_packets bcc,
14968: po_distributions pod
14969: where bcc.document_header_id = pod.po_header_id
14970: and bcc.document_distribution_id = pod.po_distribution_id
14971: and bcc.project_id = pod.project_id -- Bug# 4479105
14972: and bcc.task_id = pod.task_id --Bug# 4479105
14982:
14983: l_rec_bc_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_commitments
14984: l_rec_pkt_comm_exists VARCHAR2(1); -- Variable to identify whether commitment record exists in pa_bc_packets
14985: l_Raw_Bc_Packet_Id pa_bc_packets.bc_packet_id%TYPE;
14986: l_po_line_id po_distributions_all.po_line_id%TYPE;
14987: l_expenditure_item_date pa_expenditure_items_all.expenditure_item_date%TYPE; -- Aded for 16451280
14988:
14989: BEGIN
14990: