APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PO_BC_DISTRIBUTIONS

Line 2540: -- 2. Inserts raw records into pa_bc_packets by fetching PO/REQ data from po_bc_distributions

2536: -- Called from PSA_BC_XLA_PVT.Budgetary_control after creating events for AP/PO/REQ.
2537: -- and before It performs following tasks :
2538: -- 1. Driving table for this procedure is psa_bc_xla_events_gt .Picks all AP/PO/REQ events
2539: -- created by BCPSA FC engine.
2540: -- 2. Inserts raw records into pa_bc_packets by fetching PO/REQ data from po_bc_distributions
2541: -- and AP data from ap_invoice_distributions_all table for all events in psa_bc_xla_events_gt.
2542: -- 3. Fires populate_burden_cost procedure to Insert burden records for above raw components
2543: -- 4. Fires pa_funds_control_pkg.derive_rlmi to derive resource_list_member_id on bc packets
2544: -- 5. Fires pa_funds_control_utils.get_budegt_ccid to derive budget_ccid and budget_line_id

Line 2558: -- R12 funds management uptake : Cursor to fetch PO data from po_bc_distributions.

2554: l_return_status VARCHAR2(100);
2555: l_debug_mode VARCHAR2(10);
2556: l_err_msg_code VARCHAR2(2000);
2557:
2558: -- R12 funds management uptake : Cursor to fetch PO data from po_bc_distributions.
2559: -- This global temporary table has records for PO and also for requisition which
2560: -- needs to be unreserved
2561:
2562: CURSOR cur_po_bc_dist IS

Line 2636: FROM po_bc_distributions pobc ,

2632: -- they will point to the main doc
2633: POBC.origin_sequence_num,
2634: pobc.applied_to_dist_id_2,
2635: pa_bc_packets_s.nextval bc_packet_id -- Bug 5406690
2636: FROM po_bc_distributions pobc ,
2637: po_encumbrance_gt pogt,
2638: psa_bc_xla_events_gt xlaevt
2639: WHERE pobc.ae_event_id = xlaevt.event_id
2640: AND pobc.pa_project_id IS NOT NULL

Line 3022: FROM PO_BC_DISTRIBUTIONS ORIG

3018: ,'PO'),
3019: DECODE(ORIG.distribution_type ,'SCHEDULED',ORIG.po_release_id
3020: ,'BLANKET',ORIG.po_release_id
3021: ,ORIG.header_id)
3022: FROM PO_BC_DISTRIBUTIONS ORIG
3023: WHERE ORIG.sequence_number= p_req_origin_seq_num
3024: AND ORIG.ae_event_id = p_req_event_id;
3025:
3026: l_index NUMBER;

Line 3506: pa_funds_control_pkg.log_message(p_msg_token1 => '***Start of record-'||l_index||' records after fetching data from po_bc_distributions ***');

3502: IF pa_funds_control_pkg.g_debug_mode = 'Y' AND g_tab_doc_header_id.count<>0 THEN
3503:
3504: FOR l_index IN 1..g_tab_doc_header_id.last LOOP
3505:
3506: pa_funds_control_pkg.log_message(p_msg_token1 => '***Start of record-'||l_index||' records after fetching data from po_bc_distributions ***');
3507: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_budget_version_id = '||g_tab_budget_version_id(l_index));
3508: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_budget_line_id = '||g_tab_budget_line_id(l_index));
3509: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_budget_ccid = '||g_tab_budget_ccid(l_index));
3510: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_project_id = '||g_tab_project_id(l_index));

Line 3550: pa_funds_control_pkg.log_message(p_msg_token1 => '****End of record-'||l_index||' records after fetching data from po_bc_distributions***');

3546: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_vendor_id = '||g_tab_vendor_id(l_index));
3547: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_orig_sequence_num = '||g_tab_orig_sequence_num(l_index));
3548: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_applied_to_dist_id_2 = '||g_tab_applied_to_dist_id_2(l_index));
3549: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_bc_packet_id = '||g_tab_bc_packet_id(l_index));
3550: pa_funds_control_pkg.log_message(p_msg_token1 => '****End of record-'||l_index||' records after fetching data from po_bc_distributions***');
3551: END LOOP;
3552:
3553: End if;
3554: