[Home] [Help]
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
2682: SELECT apd.invoice_distribution_id,
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
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
2896: FROM ap_invoice_distributions_all apd1
2897: WHERE apd1.invoice_distribution_id = apext.charge_applicable_to_dist_id
2898: AND apext.aid_line_type_lookup_code = 'NONREC_TAX'
2899: AND apext.charge_applicable_to_dist_id IS NOT NULL
2900: AND p_bc_mode <> 'C'
2958: AID.parent_reversal_id parent_reversal_id -- Bug 5406690
2959: FROM AP_PREPAY_HISTORY_ALL APPH,
2960: AP_PREPAY_APP_DISTS APAD,
2961: AP_INVOICE_LINES_ALL AIL,
2962: AP_INVOICE_DISTRIBUTIONS_ALL AID
2963: WHERE AID.bc_event_id = APPH.bc_Event_id
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
2978: SELECT apd.set_of_books_id,
2979: apd.expenditure_item_date,
2980: apd.org_id,
2981: apinv.vendor_id
2982: FROM ap_invoice_distributions_all apd,
2983: ap_invoices_all apinv
2984: WHERE apd.invoice_distribution_id = p_inv_dist_id
2985: AND apinv.invoice_id = apd.invoice_id;
2986:
3118:
3119: IF p_application_id = 200 THEN --Calling application is Payables
3120:
3121: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN
3122: pa_funds_control_pkg.log_message(p_msg_token1 => 'Fetching eligible distributions from ap_invoice_distributions_all');
3123: End if;
3124:
3125: OPEN c_proj_ap_dist;
3126: FETCH c_proj_ap_dist BULK COLLECT INTO g_ap_inv_dist_id,g_ap_line_type_lkup;
5131:
5132: /* Commented as part of Bug 5406690
5133: CURSOR C_ap_parent_reversal_dist IS --Bug 5515095
5134: SELECT parent_reversal_id
5135: FROM ap_invoice_distributions_all ap
5136: WHERE ap.invoice_distribution_id = l_doc_distribution_id
5137: AND parent_reversal_id IS NOT NULL; */
5138:
5139: l_ap_parent_dist_id ap_invoice_distributions_all.parent_reversal_id%TYPE;
5135: FROM ap_invoice_distributions_all ap
5136: WHERE ap.invoice_distribution_id = l_doc_distribution_id
5137: AND parent_reversal_id IS NOT NULL; */
5138:
5139: l_ap_parent_dist_id ap_invoice_distributions_all.parent_reversal_id%TYPE;
5140:
5141: BEGIN
5142: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>
5143: ' burden type for ap po = '||p_burden_type||' - related link -'||p_related_link);