[Home] [Help]
2751:
2752: -- R12 Funds Management Uptake : This is the main cursor to fetch records from ap extracts
2753: -- for all eligible invoice distribution id's. This cursor fetches data for Standard Invoices
2754: -- and prepayments. Note : For prepayments there will be multiple lines for each invoice
2755: -- distribution as data is fetched from AP_PREPAY_APP_DISTS.
2756: -- Note : This cursor fetches only the AP dist record ,it doesnt fetch associated
2757: -- PO/RELEASE that has to be unreserved.
2758:
2759: /* Bug 5203226 : AP's amount calculation logic for all type of invoices
2862: ,'NONREC_TAX',apext.po_distribution_id
2863: , NULL) ap_po_distribution_id,
2864: apext.aid_accounting_date gl_date,
2865: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2866: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2867: -- validation.
2868: DECODE(p_bc_mode,'C'
2869: ,DECODE(apext.AID_LINE_TYPE_LOOKUP_CODE
2870: ,'PREPAY','STANDARD'
2956: WHERE encumbrance_type_KEY = 'Invoices') encumbrance_type_id,
2957: AID.PERIOD_NAME period_name,
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
3136: l_stdinvoice_exists := 'N';
3137:
3138: FOR i in 1..g_ap_line_type_lkup.count LOOP
3139: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
3140: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
3141: -- validation.
3142: IF g_ap_line_type_lkup(i) = 'PREPAY' AND p_bc_mode <> 'C' THEN
3143: l_prepay_exists := 'Y';
3144: ELSE