[Home] [Help]
1444: -- ---------------------------------------------------------
1445:
1446: -- --------------------------------------------------------
1447: -- STAGE:20 - Purchasing.
1448: -- Standard purchasing and Releases are okay as they are
1449: -- Entered.
1450: -- REQ - Becomes PO or release will have AWARD SET ID
1451: -- copied from REQ. We need to create ADLS for that PO
1452: -- So that ADLS are in SYNCH with PO.
1556: FOR i in 1..g_set_of_books_id_tab.count LOOP
1557:
1558: -- ---------------------------------------------------------------
1559: -- STAGE:30 - AP Invoice.
1560: -- Standard AP invoice/credit memo/debit memo are okay as they are
1561: -- Entered.
1562: -- CASE 1 - PO - Becomes AP will have AWARD SET ID
1563: -- copied from PO. We need to create ADLS for that AP
1564: -- So that ADLS are in SYNCH with AP.
2341: APINV.INVOICE_TYPE_LOOKUP_CODE <> 'PREPAYMENT')
2342: AND apsat.line_type_lookup_code ='NONREC_TAX';
2343:
2344: -- R12 Funds Management Uptake : This is the main cursor to fetch records from ap extracts
2345: -- for all eligible invoice distribution id's. This cursor fetches data for Standard Invoices
2346: -- and prepayments. Note : For prepayments there will be multiple lines for each invoice
2347: -- distribution as data is fetched from AP_PREPAY_APP_DISTS.
2348: -- Note : This cursor fetches only the AP dist record ,it doesnt fetch associated
2349: -- PO/RELEASE that has to be unreserved.
2456: PSA_BC_XLA_EVENTS_GT PBXEG
2457: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2458: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */
2459: AND apext.event_id = PBXEG.EVENT_ID
2460: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2461: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2462: -- validation.
2463: /* Commenting the following condition for Bug 5645290
2464: AND (p_mode ='C' OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_mode <>'C')) */
2563: PSA_BC_XLA_EVENTS_GT PBXEG
2564: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2565: /* AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) */
2566: AND apext.event_id = PBXEG.EVENT_ID
2567: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2568: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2569: -- validation.
2570: /* Commenting the following condition for Bug 5645290
2571: AND (p_mode ='C' OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_mode <>'C')) */
2979: l_prepay_exists := 'N';
2980: l_stdinvoice_exists := 'N';
2981:
2982: FOR i in 1..g_ap_line_type_lkup.count LOOP
2983: -- Prepayment application will be treated as standard invoice line for check funds
2984: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2985: -- validation.
2986: IF g_ap_line_type_lkup(i) = 'PREPAY' AND p_mode <> 'C' THEN
2987: l_prepay_exists := 'Y';
2987: l_prepay_exists := 'Y';
2988: ELSE
2989: l_stdinvoice_exists := 'Y';
2990: END IF;
2991: -- Exit the loop if both prepay and standard invoices exists.
2992: IF l_prepay_exists= 'Y' AND l_stdinvoice_exists = 'Y' THEN
2993: EXIT;
2994: END IF;
2995: