[Home] [Help]
22:
23: BEGIN
24: -- Bug 6780154. Added by Lakshmi Gopalsami
25: -- Removed the cursor and added op_distribution_id is null
26: update JAI_AP_MATCH_ERS_T
27: set po_distribution_id = pr_new.po_distribution_id
28: where invoice_id = pr_new.invoice_id
29: and invoice_line_number = pr_new.line_number
30: and po_distribution_id is null;
211:
212: 7. 15-nov-2002 cbabu for Bug# 2665306, Version# 615.1
213: Following extra condition is added to stop firing 'India - To Insert Tax distributions'
214: concurrent AND (v_source NOT IN ('ERS', 'ASBN') ) As the data gets inserted into
215: JAI_AP_MATCH_ERS_T table that gets processed through the another concurrent for
216: inserting tax distributions during pay on receipt. And debug code is added to debug whenever
217: there are any issues.
218:
219: 8. 26-NOV-2002 cbabu for Bug# 2560026, Version# 615.2
270: so the call to concurrent is also modified to use invoice_line_number instead
271: of distribution_line_number
272:
273: 17 07/12/2005 Hjujjuru for the bug 4866533 File version 120.1
274: added the who columns in the insert into table JAI_AP_MATCH_ERS_T.
275: Dependencies Due to this bug:-
276: None
277:
278: 18 29-SEP-2011 Bug #12886913
552:
553: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition 1');
554: v_rematching := 'PAY_ON_RECEIPT';
555:
556: INSERT INTO JAI_AP_MATCH_ERS_T
557: (
558: invoice_id,
559: invoice_line_number, -- Using Invoice_line_number instead of distribution_line_number for Bug# 4445989
560: po_distribution_id,
721: IF v_source = 'RTS' THEN
722: jai_cmn_utils_pkg.write_fnd_log_msg('After insert trigger','Inside condition of RTS');
723: v_receipt_code := 'RECEIPT';
724: v_rematching := 'PAY_ON_RECEIPT';
725: INSERT INTO JAI_AP_MATCH_ERS_T (
726: invoice_id, invoice_line_number, -- Bug# 4445989
727: po_distribution_id, quantity_invoiced, shipment_header_id,
728: receipt_num, receipt_code, rematching,
729: rcv_transaction_id, amount, org_id, creation_date,