3200:
3201: UPDATE ap_invoice_distributions_all
3202: SET dist_code_combination_id = ln_dist_acct_ccid
3203: --charge_applicable_to_dist_id = ln_chargeble_acct_ccid /* Bug 13793724 -commented as the charge_applicable_to_dist_id is not dependent on ccid */
3204: WHERE invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3205: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id
3206: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where
3207: invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3208: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id); /* Bug 13617527 */
3201: UPDATE ap_invoice_distributions_all
3202: SET dist_code_combination_id = ln_dist_acct_ccid
3203: --charge_applicable_to_dist_id = ln_chargeble_acct_ccid /* Bug 13793724 -commented as the charge_applicable_to_dist_id is not dependent on ccid */
3204: WHERE invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3205: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id
3206: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where
3207: invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3208: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id); /* Bug 13617527 */
3209:
3203: --charge_applicable_to_dist_id = ln_chargeble_acct_ccid /* Bug 13793724 -commented as the charge_applicable_to_dist_id is not dependent on ccid */
3204: WHERE invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3205: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id
3206: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where
3207: invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3208: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id); /* Bug 13617527 */
3209:
3210: END LOOP;
3211: COMMIT;
3204: WHERE invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3205: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id
3206: AND distribution_line_number = (select min(distribution_line_number) from ap_invoice_distributions_all where
3207: invoice_line_number = r_jai_cmn_document_taxes.source_doc_line_id
3208: AND invoice_id = r_jai_cmn_document_taxes.source_doc_id); /* Bug 13617527 */
3209:
3210: END LOOP;
3211: COMMIT;
3212: -- Added by Qiong for reverse charge bug#16001407
5396: ( ln_invoice_id
5397: , ap_invoice_lines_rec.line_number
5398: );
5399: --update the tax line number for the filed of
5400: --jai_cmn_document_taxes.source_doc_line_id
5401: --and split each PR taxes into to two lines
5402: FOR jai_default_doc_taxes_rec IN
5403: jai_default_doc_taxes_cur
5404: ( pn_invoice_id =>ln_invoice_id
5628: ------------------------------------------------------
5629: --Eric Ma added for two records shown in Form,end
5630:
5631: SELECT
5632: jai_cmn_document_taxes_s.nextval
5633: INTO
5634: ln_doc_tax_id
5635: FROM DUAL;
5636:
6132:
6133: --insert into eric_log values (7.91,'jai_doc_taxes_rec.inc_tax_flag =''Y'' AND recoverable with project case ',sysdate);
6134:
6135: -- Insert negative line with project info
6136: -- Line number got from max jai_cmn_document_taxes.source_doc_line_id
6137: -- or max ap_invoice_lines_all.line_number
6138: ln_max_inv_line_num := Get_Max_Invoice_Line_Number(ln_invoice_id);
6139:
6140: -- deleted by eric for fixing the bug of bug#6784111 on 29-JAN,2008,begin