[Home] [Help]
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.
2284:
2285: /* AP's amount calculation logic for all type of invoices
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')) */
2355: /* Adding for Bug 5645290*/
2399: NULL inv_dist_reference_2,
2400: APAD.prepay_app_dist_id ap_prepay_app_dist_id
2401: -- Last col. will be used in Synch_gms_gl_packets ...
2402: FROM AP_PREPAY_HISTORY_ALL APPH,
2403: AP_PREPAY_APP_DISTS APAD,
2404: AP_INVOICE_LINES_ALL AIL,
2405: AP_INVOICE_DISTRIBUTIONS_ALL AID
2406: WHERE AID.bc_event_id = APPH.bc_Event_id
2407: AND APPH.prepay_history_id = APAD.prepay_history_id
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';
2717: ELSE
8235: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: glbcrec.source_distribution_type:'|| glbcrec.source_distribution_type,'C');
8236: END IF;
8237:
8238: If glbcrec.source_distribution_type = 'AP_PREPAY' then
8239: -- This is reqd. as we cannot access ap_prepay_app_dists here .. autonomous ..
8240:
8241: IF g_debug = 'Y' THEN
8242: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: Derive prepay dist id ','C');
8243: END IF;
8248: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: g_ap_prepay_app_dist_id(x)'||g_ap_prepay_app_dist_id(x),'C');
8249: END IF;
8250:
8251: IF g_ap_prepay_app_dist_id(x) = glbcrec.source_distribution_id_num_1 then
8252: -- basically, if ap_prepay_app_dists.ap_prepay_dist_id is same as in gl
8253: -- assign ap_prepay_app_dists.invoice_distribution_id to l_dist_id
8254:
8255: l_dist_id := g_doc_dist_id_tab(x);
8256:
8249: END IF;
8250:
8251: IF g_ap_prepay_app_dist_id(x) = glbcrec.source_distribution_id_num_1 then
8252: -- basically, if ap_prepay_app_dists.ap_prepay_dist_id is same as in gl
8253: -- assign ap_prepay_app_dists.invoice_distribution_id to l_dist_id
8254:
8255: l_dist_id := g_doc_dist_id_tab(x);
8256:
8257: If g_debug = 'Y' THEN
8287: and (( gbc.document_distribution_id = glbcrec.source_distribution_id_num_1
8288: AND glbcrec.source_distribution_type <> 'AP_PREPAY') OR
8289: (glbcrec.source_distribution_type = 'AP_PREPAY' AND -- Bug 5561741
8290: gbc.document_distribution_id = l_dist_id
8291: -- Following cannot be used as ap_prepay_app_dists not visible ..autonomous ..
8292: -- (SELECT APAD.PREPAY_APP_DISTRIBUTION_ID
8293: -- FROM ap_prepay_app_dists APAD
8294: -- WHERE APAD.PREPAY_APP_DIST_ID = glbcrec.source_distribution_id_num_1 )
8295: ))
8289: (glbcrec.source_distribution_type = 'AP_PREPAY' AND -- Bug 5561741
8290: gbc.document_distribution_id = l_dist_id
8291: -- Following cannot be used as ap_prepay_app_dists not visible ..autonomous ..
8292: -- (SELECT APAD.PREPAY_APP_DISTRIBUTION_ID
8293: -- FROM ap_prepay_app_dists APAD
8294: -- WHERE APAD.PREPAY_APP_DIST_ID = glbcrec.source_distribution_id_num_1 )
8295: ))
8296: and gbc.document_type = decode(glbcrec.encumbrance_type_key,'Commitment','REQ'
8297: ,'Obligation','PO'