[Home] [Help]
2534: -- R12 Funds Management Uptake --rshaik
2535: -- ----------------------------
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
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
2545: -- 6. Finally calls pa_xla_interface_pkg.create_events to create events for project
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
2641: AND pogt.distribution_id = pobc.distribution_id
2642: AND pogt.distribution_type = pobc.distribution_type
2683: DECODE(apd.line_type_lookup_code -- Bug 5490378
2684: ,'NONREC_TAX',DECODE(apd.prepay_distribution_id,NULL,apd.line_type_lookup_code,'PREPAY')
2685: ,apd.line_type_lookup_code)
2686: FROM ap_invoice_distributions_all apd ,
2687: psa_bc_xla_events_gt xlaevt,
2688: ap_invoices_all apinv
2689: WHERE apd.bc_event_id = xlaevt.event_id
2690: AND apd.project_id IS NOT NULL
2691: AND NVL(apd.pa_addition_flag, 'X' ) <> 'T'
2887: apext.aid_period_name period_name,
2888: apext.AID_PARENT_REVERSAL_ID parent_reversal_id -- Bug 5406690
2889: FROM ap_extract_invoice_dtls_bc_v apext -- Bug 5500126
2890: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2891: AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt)
2892: AND (p_bc_mode ='C'
2893: OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_bc_mode <>'C')) -- Bug 5238282
2894: AND NOT EXISTS ( --Bug 5490378 : Filter out Tax associated with prepay lines for reserve action
2895: SELECT 1
2964: AND APPH.prepay_history_id = APAD.prepay_history_id
2965: AND AID.invoice_line_number = AIL.line_number
2966: AND AID.invoice_id = AIL.invoice_id
2967: AND AID.line_type_lookup_code IN ( 'PREPAY' ,'NONREC_TAX' ) --Bug 5490378
2968: and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt)
2969: and AID.invoice_distribution_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2970: AND p_prepay_exists = 'Y'
2971: and aid.invoice_distribution_id = apad.prepay_app_distribution_id;
2972:
7813: PROCEDURE TIEBACK_FAILED_ACCT_STATUS (p_bc_mode IN VARCHAR2 DEFAULT 'C') IS
7814:
7815: CURSOR C_PRINT_EVENT_STATUS IS
7816: SELECT event_id, b.result_code
7817: FROM PSA_BC_XLA_EVENTS_GT b;
7818:
7819: BEGIN
7820:
7821: -- Bug 5354715 : Added the "PA IMPLEMENTED IN OU" check.
7847: result_code = DECODE(substr(result_code,1,1),'F',result_code,'F172')
7848: WHERE status_code in ('P','I','A','S')
7849: AND source_event_id IN
7850: (SELECT event_id
7851: FROM PSA_BC_XLA_EVENTS_GT
7852: WHERE upper(result_code) in ('XLA_ERROR','FATAL','XLA_UNPROCESSED','XLA_NO_JOURNAL'));
7853:
7854: UPDATE pa_bc_packets a
7855: SET status_code = DECODE(p_bc_mode,'C','F','R'),
7856: result_code = DECODE(substr(result_code,1,1),'F',result_code,'F172')
7857: WHERE status_code in ('P','I','A','S')
7858: AND bc_event_id IN
7859: (SELECT event_id
7860: FROM PSA_BC_XLA_EVENTS_GT
7861: WHERE upper(result_code) in ('XLA_ERROR','FATAL','XLA_UNPROCESSED','XLA_NO_JOURNAL'));
7862:
7863: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN
7864: pa_funds_control_pkg.log_message(p_msg_token1 => 'TIEBACK_FAILED_ACCT_STATUS : End ');
8789: NULL ,
8790: NULL
8791: FROM igc_cc_interface igc,
8792: igc_cc_headers_all igchead,
8793: psa_bc_xla_events_gt pbgt,
8794: gl_period_statuses glp
8795: WHERE pbgt.event_id = igc.event_id
8796: and igc.cc_header_id = igchead.cc_header_id
8797: and igc.budget_dest_flag = 'S'