[Home] [Help]
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
2591: -- 6. Finally calls pa_xla_interface_pkg.create_events to create events for project
2729: SELECT apd.invoice_distribution_id,
2730: DECODE(apd.line_type_lookup_code -- Bug 5490378
2731: ,'NONREC_TAX',DECODE(apd.prepay_distribution_id,NULL,apd.line_type_lookup_code,'PREPAY')
2732: ,apd.line_type_lookup_code)
2733: FROM ap_invoice_distributions_all apd ,
2734: psa_bc_xla_events_gt xlaevt,
2735: ap_invoices_all apinv
2736: WHERE apd.bc_event_id = xlaevt.event_id
2737: AND apd.project_id IS NOT NULL
3021: ,NVL(AID.amount,0) - NVL(AID.amount_variance,0)
3022: - NVL(AID.quantity_variance,0) encumbrance_amount
3023: ,AID.CHARGE_APPLICABLE_TO_DIST_ID charge_applicable_to_dist_id
3024: ,'N' self_assessed_tax_flag
3025: FROM AP_INVOICE_DISTRIBUTIONS_ALL AID,
3026: PO_DISTRIBUTIONS_ALL POD,
3027: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
3028: IGC_CC_SLA_BFLOW_PRIOR_V IGC,
3029: ap_system_parameters_all ASP
3083: AND (p_bc_mode ='C'
3084: OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_bc_mode <>'C')) -- Bug 5238282
3085: AND NOT EXISTS ( --Bug 5490378 : Filter out Tax associated with prepay lines for reserve action
3086: SELECT 1
3087: FROM ap_invoice_distributions_all apd1
3088: WHERE apd1.invoice_distribution_id = apext.charge_applicable_to_dist_id
3089: AND apext.aid_line_type_lookup_code = 'NONREC_TAX'
3090: AND apext.charge_applicable_to_dist_id IS NOT NULL
3091: AND p_bc_mode <> 'C'
3158: FROM AP_PREPAY_HISTORY_ALL APPH,
3159: PSA_BC_XLA_EVENTS_GT PBXEG, --Added for bug 14752984
3160: AP_PREPAY_APP_DISTS APAD,
3161: AP_INVOICE_LINES_ALL AIL,
3162: AP_INVOICE_DISTRIBUTIONS_ALL AID
3163: WHERE AID.bc_event_id = APPH.bc_Event_id
3164: AND APPH.prepay_history_id = APAD.prepay_history_id
3165: AND AID.invoice_line_number = AIL.line_number
3166: AND AID.invoice_id = AIL.invoice_id
3241: SELECT apd.set_of_books_id,
3242: apd.expenditure_item_date,
3243: apd.org_id,
3244: apinv.vendor_id
3245: FROM ap_invoice_distributions_all apd,
3246: ap_invoices_all apinv
3247: WHERE apd.invoice_distribution_id = p_inv_dist_id
3248: AND apinv.invoice_id = apd.invoice_id
3249: UNION /*Bug 13602288 :Self Assessed Tax Changes*/
3397:
3398: IF p_application_id = 200 THEN --Calling application is Payables
3399:
3400: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN
3401: pa_funds_control_pkg.log_message(p_msg_token1 => 'Fetching eligible distributions from ap_invoice_distributions_all');
3402: End if;
3403:
3404: OPEN c_proj_ap_dist;
3405: FETCH c_proj_ap_dist BULK COLLECT INTO g_ap_inv_dist_id,g_ap_line_type_lkup;
5443:
5444: /* Commented as part of Bug 5406690
5445: CURSOR C_ap_parent_reversal_dist IS --Bug 5515095
5446: SELECT parent_reversal_id
5447: FROM ap_invoice_distributions_all ap
5448: WHERE ap.invoice_distribution_id = l_doc_distribution_id
5449: AND parent_reversal_id IS NOT NULL; */
5450:
5451: l_ap_parent_dist_id ap_invoice_distributions_all.parent_reversal_id%TYPE;
5447: FROM ap_invoice_distributions_all ap
5448: WHERE ap.invoice_distribution_id = l_doc_distribution_id
5449: AND parent_reversal_id IS NOT NULL; */
5450:
5451: l_ap_parent_dist_id ap_invoice_distributions_all.parent_reversal_id%TYPE;
5452:
5453: BEGIN
5454: PA_FUNDS_CONTROL_PKG.log_message(p_msg_token1 =>
5455: ' burden type for ap po = '||p_burden_type||' - related link -'||p_related_link);