[Home] [Help]
2749: AND bdgttype.budget_amount_code = 'C'
2750: );
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.
2802: 'AP' document_type,
2803: apext.bus_flow_inv_id document_header_id,
2804: apext.aid_invoice_line_number document_line_id,
2805: apext.aid_invoice_dist_id document_distribution_id,
2806: -- For standard invoice this is always same as document_distribution_id
2807: apext.aid_invoice_dist_id invoice_distribution_id,
2808: 'E' actual_flag,
2809: NULL result_code,
2810: 'I' status_code,
2861: ,'ACCRUAL',apext.po_distribution_id
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
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'
2871: ,apext.AID_LINE_TYPE_LOOKUP_CODE)
2872: ,apext.AID_LINE_TYPE_LOOKUP_CODE) distribution_type,
2873: DECODE(apext.AID_LINE_TYPE_LOOKUP_CODE
2874: ,'ITEM',DECODE(apext.bus_flow_po_entity_code
3135: l_prepay_exists := 'N';
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';
3143: l_prepay_exists := 'Y';
3144: ELSE
3145: l_stdinvoice_exists := 'Y';
3146: END IF;
3147: -- Exit the loop if both prepay and standard invoices exists.
3148: IF l_prepay_exists= 'Y' AND l_stdinvoice_exists = 'Y' THEN
3149: EXIT;
3150: END IF;
3151: