[Home] [Help]
2856:
2857: -- R12 Funds Management Uptake : This is the main cursor to fetch records from ap extracts
2858: -- for all eligible invoice distribution id's. This cursor fetches data for Standard Invoices
2859: -- and prepayments. Note : For prepayments there will be multiple lines for each invoice
2860: -- distribution as data is fetched from AP_PREPAY_APP_DISTS.
2861: -- Note : This cursor fetches only the AP dist record ,it doesnt fetch associated
2862: -- PO/RELEASE that has to be unreserved.
2863:
2864: /* Bug 5203226 : AP's amount calculation logic for all type of invoices
2967: ,'NONREC_TAX',DECODE(apext.SELF_ASSESSED_TAX_FLAG,'Y', NULL,apext.po_distribution_id)
2968: , NULL) ap_po_distribution_id,
2969: apext.aid_accounting_date gl_date,
2970: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2971: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2972: -- validation.
2973: DECODE(p_bc_mode,'C'
2974: ,DECODE(apext.AID_LINE_TYPE_LOOKUP_CODE
2975: ,'PREPAY','STANDARD'
3156: AID.PERIOD_NAME period_name,
3157: AID.parent_reversal_id parent_reversal_id -- Bug 5406690
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
3219: WHERE encumbrance_type_KEY = 'Invoices') encumbrance_type_id,
3220: AID.PERIOD_NAME period_name,
3221: AID.parent_reversal_id parent_reversal_id
3222: FROM AP_PREPAY_HISTORY_ALL APPH,
3223: AP_PREPAY_APP_DISTS APAD,
3224: AP_INVOICE_LINES_ALL AIL,
3225: AP_SELF_ASSESSED_TAX_DIST_ALL AID
3226: WHERE AID.bc_event_id = APPH.bc_Event_id
3227: AND APPH.prepay_history_id = APAD.prepay_history_id
3415: l_stdinvoice_exists := 'N';
3416:
3417: FOR i in 1..g_ap_line_type_lkup.count LOOP
3418: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
3419: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
3420: -- validation.
3421: IF g_ap_line_type_lkup(i) = 'PREPAY' AND p_bc_mode <> 'C' THEN
3422: l_prepay_exists := 'Y';
3423: ELSE