[Home] [Help]
1151:
1152:
1153: -- Start add for bug#3632810
1154: CURSOR c_get_invoice_distribution is -- bug#3332988
1155: select ap_invoice_distributions_s.nextval
1156: from dual;
1157:
1158: -- start addition by ssumaith -bug# 3127834
1159:
2151: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of distribution_id'||ident_rec.po_distribution_id);
2152: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of line_number '||ident_rec.invoice_line_number);
2153: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Value of invoice_distribution_id '||ident_rec.invoice_distribution_id);
2154:
2155: select ap_invoice_distributions_s.nextval into ln_invoice_dist_id_rev from dual;
2156:
2157: For ins_reverse_dist_lines in c_inv_dist_tax_lines ( ident_rec.invoice_id, ident_rec.invoice_distribution_id)
2158: Loop
2159: jai_cmn_utils_pkg.write_fnd_log_msg('Match Tax Code','Going inside Loop of reversal');
2287: Elsif lv_discard_flag = 'Y' and ln_source = 'ERS' Then
2288: For ins_reverse_dist_lines_ers in c_inv_dist_tax_lines_ers ( inv_id , po_dist_id)
2289: Loop
2290: ln_invoice_distribution_no := ins_reverse_dist_lines_ers.distribution_line_number + 1;
2291: select ap_invoice_distributions_s.nextval into ln_invoice_dist_id_rev from dual;
2292: INSERT INTO ap_invoice_distributions_all
2293: (
2294: accounting_date,
2295: accrual_posted_flag,
3712: )
3713: VALUES
3714: (
3715: inv_id,
3716: ap_invoice_distributions_s.CURRVAL,
3717: for_dist_insertion_rec.set_of_books_id,
3718: v_batch_id,
3719: for_dist_insertion_rec.po_distribution_id,
3720: rcv_tran_id,
4934: )
4935: VALUES
4936: (
4937: inv_id,
4938: ap_invoice_distributions_s.CURRVAL,
4939: for_dist_insertion_rec.set_of_books_id,
4940: v_batch_id,
4941: for_dist_insertion_rec.po_distribution_id,
4942: rcv_tran_id,
5838: )
5839: VALUES
5840: (
5841: inv_id,
5842: ap_invoice_distributions_s.CURRVAL,
5843: for_dist_insertion_rec.set_of_books_id,
5844: v_batch_id,
5845: for_dist_insertion_rec.po_distribution_id,
5846: rcv_tran_id,
6859: )
6860: VALUES
6861: (
6862: inv_id,
6863: ap_invoice_distributions_s.CURRVAL,
6864: for_dist_insertion_rec.set_of_books_id,
6865: v_batch_id,
6866: for_dist_insertion_rec.po_distribution_id,
6867: rcv_tran_id,
7483: WHERE INVOICE_ID = inv_id)
7484: FOR UPDATE OF DISTRIBUTION_LINE_NUMBER;
7485:
7486: cursor c_get_invoice_distribution is -- bug#3332988
7487: select ap_invoice_distributions_s.nextval
7488: from dual;
7489:
7490: -- start addition by ssumaith -bug# 3127834
7491:
8978: for_dist_insertion_rec.program_application_id,
8979: for_dist_insertion_rec.program_id,
8980: for_dist_insertion_rec.program_update_date,
8981: for_dist_insertion_rec.accts_pay_code_combination_id,
8982: v_invoice_distribution_id, -- BUG#3332988 ap_invoice_distributions_s.NEXTVAL,
8983: decode(v_assets_tracking_flag, 'Y', NULL, 0),/* Modified for bug 8406404 by vumaasha */
8984: for_dist_insertion_rec.org_id, -- Bug 4863208
8985: --po_dist_id,12434160
8986: for_dist_insertion_rec.po_distribution_id, --12434160
9175: )
9176: VALUES
9177: (
9178: inv_id,
9179: ap_invoice_distributions_s.CURRVAL,
9180: for_dist_insertion_rec.set_of_books_id,
9181: v_batch_id,
9182: for_dist_insertion_rec.po_distribution_id,
9183: rcv_tran_id,
10033: )
10034: VALUES
10035: (
10036: inv_id,
10037: ap_invoice_distributions_s.CURRVAL,
10038: for_dist_insertion_rec.set_of_books_id,
10039: v_batch_id,
10040: for_dist_insertion_rec.po_distribution_id,
10041: rcv_tran_id,
10898: )
10899: VALUES
10900: (
10901: inv_id,
10902: ap_invoice_distributions_s.CURRVAL,
10903: for_dist_insertion_rec.set_of_books_id,
10904: v_batch_id,
10905: for_dist_insertion_rec.po_distribution_id,
10906: rcv_tran_id,