APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PO_BC_DISTRIBUTIONS

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

2582: -- Called from PSA_BC_XLA_PVT.Budgetary_control after creating events for AP/PO/REQ.
2583: -- and before It performs following tasks :
2584: -- 1. Driving table for this procedure is psa_bc_xla_events_gt .Picks all AP/PO/REQ events
2585: -- created by BCPSA FC engine.
2586: -- 2. Inserts raw records into pa_bc_packets by fetching PO/REQ data from po_bc_distributions
2587: -- and AP data from ap_invoice_distributions_all table for all events in psa_bc_xla_events_gt.
2588: -- 3. Fires populate_burden_cost procedure to Insert burden records for above raw components
2589: -- 4. Fires pa_funds_control_pkg.derive_rlmi to derive resource_list_member_id on bc packets
2590: -- 5. Fires pa_funds_control_utils.get_budegt_ccid to derive budget_ccid and budget_line_id

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

2600: l_return_status VARCHAR2(100);
2601: l_debug_mode VARCHAR2(10);
2602: l_err_msg_code VARCHAR2(2000);
2603:
2604: -- R12 funds management uptake : Cursor to fetch PO data from po_bc_distributions.
2605: -- This global temporary table has records for PO and also for requisition which
2606: -- needs to be unreserved
2607:
2608: CURSOR cur_po_bc_dist IS

Line 2682: FROM po_bc_distributions pobc ,

2678: -- they will point to the main doc
2679: POBC.origin_sequence_num,
2680: pobc.applied_to_dist_id_2,
2681: pa_bc_packets_s.nextval bc_packet_id -- Bug 5406690
2682: FROM po_bc_distributions pobc ,
2683: po_encumbrance_gt pogt,
2684: psa_bc_xla_events_gt xlaevt
2685: WHERE pobc.ae_event_id = xlaevt.event_id
2686: AND pobc.pa_project_id IS NOT NULL

Line 3294: FROM PO_BC_DISTRIBUTIONS ORIG

3290: ,'PO'),
3291: DECODE(ORIG.distribution_type ,'SCHEDULED',ORIG.po_release_id
3292: ,'BLANKET',ORIG.po_release_id
3293: ,ORIG.header_id)
3294: FROM PO_BC_DISTRIBUTIONS ORIG
3295: WHERE ORIG.sequence_number= p_req_origin_seq_num
3296: AND ORIG.ae_event_id = p_req_event_id;
3297:
3298: l_index NUMBER;

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

3784: IF pa_funds_control_pkg.g_debug_mode = 'Y' AND g_tab_doc_header_id.count<>0 THEN
3785:
3786: FOR l_index IN 1..g_tab_doc_header_id.last LOOP
3787:
3788: pa_funds_control_pkg.log_message(p_msg_token1 => '***Start of record-'||l_index||' records after fetching data from po_bc_distributions ***');
3789: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_budget_version_id = '||g_tab_budget_version_id(l_index));
3790: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_budget_line_id = '||g_tab_budget_line_id(l_index));
3791: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_budget_ccid = '||g_tab_budget_ccid(l_index));
3792: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_project_id = '||g_tab_project_id(l_index));

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

3828: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_vendor_id = '||g_tab_vendor_id(l_index));
3829: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_orig_sequence_num = '||g_tab_orig_sequence_num(l_index));
3830: 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));
3831: pa_funds_control_pkg.log_message(p_msg_token1 => 'Value of g_tab_bc_packet_id = '||g_tab_bc_packet_id(l_index));
3832: pa_funds_control_pkg.log_message(p_msg_token1 => '****End of record-'||l_index||' records after fetching data from po_bc_distributions***');
3833: END LOOP;
3834:
3835: End if;
3836: