[Home] [Help]
1415: -- ---------------------------------------------------------
1416:
1417: -- --------------------------------------------------------
1418: -- STAGE:20 - Purchasing.
1419: -- Standard purchasing and Releases are okay as they are
1420: -- Entered.
1421: -- REQ - Becomes PO or release will have AWARD SET ID
1422: -- copied from REQ. We need to create ADLS for that PO
1423: -- So that ADLS are in SYNCH with PO.
1514: FOR i in 1..g_set_of_books_id_tab.count LOOP
1515:
1516: -- ---------------------------------------------------------------
1517: -- STAGE:30 - AP Invoice.
1518: -- Standard AP invoice/credit memo/debit memo are okay as they are
1519: -- Entered.
1520: -- CASE 1 - PO - Becomes AP will have AWARD SET ID
1521: -- copied from PO. We need to create ADLS for that AP
1522: -- So that ADLS are in SYNCH with AP.
2275: apd.po_distribution_id IS NULL) OR
2276: apd.line_type_lookup_code <> 'PREPAY' );
2277:
2278: -- R12 Funds Management Uptake : This is the main cursor to fetch records from ap extracts
2279: -- for all eligible invoice distribution id's. This cursor fetches data for Standard Invoices
2280: -- and prepayments. Note : For prepayments there will be multiple lines for each invoice
2281: -- distribution as data is fetched from AP_PREPAY_APP_DISTS.
2282: -- Note : This cursor fetches only the AP dist record ,it doesnt fetch associated
2283: -- PO/RELEASE that has to be unreserved.
2346: NULL ap_prepay_app_dist_id
2347: FROM ap_extract_invoice_dtls_bc_v apext -- Bug 5500126
2348: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
2349: AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt)
2350: -- Bug 5238282 : Prepayment application will be treated as standard invoice line for check funds
2351: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2352: -- validation.
2353: /* Commenting the following condition for Bug 5645290
2354: AND (p_mode ='C' OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_mode <>'C')) */
2708: l_prepay_exists := 'N';
2709: l_stdinvoice_exists := 'N';
2710:
2711: FOR i in 1..g_ap_line_type_lkup.count LOOP
2712: -- Prepayment application will be treated as standard invoice line for check funds
2713: -- as there will be no data in ap_prepay_app_dists table.This table is populated during invoice
2714: -- validation.
2715: IF g_ap_line_type_lkup(i) = 'PREPAY' AND p_mode <> 'C' THEN
2716: l_prepay_exists := 'Y';
2716: l_prepay_exists := 'Y';
2717: ELSE
2718: l_stdinvoice_exists := 'Y';
2719: END IF;
2720: -- Exit the loop if both prepay and standard invoices exists.
2721: IF l_prepay_exists= 'Y' AND l_stdinvoice_exists = 'Y' THEN
2722: EXIT;
2723: END IF;
2724: