[Home] [Help]
1937:
1938: -- loop over original invoice's tax lines and call LTE for each tax line
1939: -- For example, if the invoice has a tax group which resulted in 3 tax lines, then
1940: -- this cursor will retrieve three racords and call the LTE three times, passing
1941: -- individual tax categories (in this case the tax group expansion will not take
1942: -- place inside the latin tax engine)
1943:
1944: Open c_inv_tax_lines(
1945: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_id_dist_tbl),
4160: l_date := sysdate;
4161:
4162: SELECT zx_lines_s.NEXTVAL
4163: INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).tax_line_id
4164: FROM dual;
4165:
4166: -- standard who columns
4167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).CREATED_BY := l_user_id ;
4168: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_new_row_num).CREATION_DATE := l_date ; -- creation_date
4949: * populate in ZX_TDS_TAX_LINES_POPU_PKG
4950: *
4951: * SELECT zx_lines_s.NEXTVAL INTO
4952: * ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4953: * p_new_row_num).tax_line_id from dual;
4954: */
4955:
4956: -- populate tax_regime_id, tax_id, tax_status_id, tax_rate_id
4957: --
5851:
5852:
5853: CURSOR sel_vat_tax_code_count IS
5854: SELECT 1
5855: FROM DUAL
5856: WHERE EXISTS ( SELECT tax_code
5857: FROM ar_vat_tax
5858: WHERE tax_code = tax_info_rec.tax_code
5859: AND set_of_books_id = sysinfo.sysparam.set_of_books_id