DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on AP_INVOICE_LINES_ALL

Line 36: *Reason - po_distribution_id is null when row is inserted in ap_invoice_lines_all.

32: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Inside trigger after update');
33: /*bug 8425058
34: *Issue - "To Insert Tax Distributions" concurrent is not firing when invoice is
35: *matched to PO using the "Quick Match" option in the invoice workbench.
36: *Reason - po_distribution_id is null when row is inserted in ap_invoice_lines_all.
37: *So the procedure ARI_T1 exits without firing the program.
38: *Fix - Call the ARI_T1 procedure from ARU_T1 when the invoice source is not ERS.*/
39:
40: jai_cmn_utils_pkg.write_fnd_log_msg('After update trigger','Value of invoice_id'||pr_new.invoice_id);

Line 268: on table ap_invoice_lines_all is created by modifying the trigger code to use ap_invoice_lines_all.

264: Object Modified For SQL Literal Changes
265:
266: 16 23-Jun-2005 Brathod, Filer Version 112.0, Bug# 4445989
267: - Trigger on the table ap_invoice_distributions_all was obsoleted and new trigger (jai_ap_ila_ari_t1)
268: on table ap_invoice_lines_all is created by modifying the trigger code to use ap_invoice_lines_all.
269: Trigger is also reponsible to submit a concurrent JAINDIST. Arguments to the concurrent is modified
270: so the call to concurrent is also modified to use invoice_line_number instead
271: of distribution_line_number
272:

Line 286: Fix:For receipt matched invoices having PO with multiple distributions, po_distribution_id would be null in ap_invoice_lines_all

282: if the count is greater than zero then only firing the concurrent program
283:
284: 19. 22-Jan-2012 Bug 16100273 by amandali
285: Issue:TAXES ARE NOT FLOWING TO RECEIPT MATCHED INVOICE IN CASE OF PO HAVING MULTIPLE DISTRIBUTIONS
286: Fix:For receipt matched invoices having PO with multiple distributions, po_distribution_id would be null in ap_invoice_lines_all
287: Hence added po_header_id condition to process the same.
288:
289: Future Dependencies For the release Of this Object:-
290: (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/

Line 316: Because for Invoice Quick Match PO, when insert ap_invoice_lines_all, po_distribution_id is null

312: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------
313:
314: 21 23-Dec-2011 Modified by Qinglei for bug#13405876
315: Added condition pr_new.po_distribution_id IS NOT NULL for ITEM_TO_RECEIPT match type.
316: Because for Invoice Quick Match PO, when insert ap_invoice_lines_all, po_distribution_id is null
317: and should not run CP "TO INSERT TAX Distributions (India - To Insert Tax Distributions)".
318: The CP will just run when updateing ap_invoice_lines_all for Invoice Quick Match PO.
319: 09-nov-12 vkaranam for bug#14472181
320: issue:Not able to generate the Debit memo matched to PO having multiple distributions

Line 318: The CP will just run when updateing ap_invoice_lines_all for Invoice Quick Match PO.

314: 21 23-Dec-2011 Modified by Qinglei for bug#13405876
315: Added condition pr_new.po_distribution_id IS NOT NULL for ITEM_TO_RECEIPT match type.
316: Because for Invoice Quick Match PO, when insert ap_invoice_lines_all, po_distribution_id is null
317: and should not run CP "TO INSERT TAX Distributions (India - To Insert Tax Distributions)".
318: The CP will just run when updateing ap_invoice_lines_all for Invoice Quick Match PO.
319: 09-nov-12 vkaranam for bug#14472181
320: issue:Not able to generate the Debit memo matched to PO having multiple distributions
321: Fix:
322: