[Home] [Help]
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:
1160: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is
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,
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:
7492: cursor c_fnd_curr_precision(cp_currency_code fnd_currencies.currency_code%type) is