DBA Data[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_JURISDICTIONS_GT

Line 1326: -- we need to delete from zx_jurisdictions_gt before each of the calls to

1322: For ptr in 1..nvl(pg_trx_id_tab.last, 0) loop
1323:
1324: I:=ptr;
1325: -- In case of partners, since there are two calls to get_tax_jurisdictions API
1326: -- we need to delete from zx_jurisdictions_gt before each of the calls to
1327: -- get_tax_jurisdictions API
1328: -- IF pg_trx_line_id_tab(i) <> g_transaction_line_id THEN
1329: -- delete from zx_jurisdictions_gt;
1330: -- END IF;

Line 1329: -- delete from zx_jurisdictions_gt;

1325: -- In case of partners, since there are two calls to get_tax_jurisdictions API
1326: -- we need to delete from zx_jurisdictions_gt before each of the calls to
1327: -- get_tax_jurisdictions API
1328: -- IF pg_trx_line_id_tab(i) <> g_transaction_line_id THEN
1329: -- delete from zx_jurisdictions_gt;
1330: -- END IF;
1331: g_transaction_line_id := pg_trx_line_id_tab(i);
1332: g_trx_level_type := pg_trx_level_type_tab(i);
1333: g_docment_type_id := pg_doc_type_id_tab(i);

Line 1886: FROM zx_jurisdictions_gt

1882: SELECT tax_jurisdiction_code
1883: INTO x_tax_jurisdiction_code
1884: FROM (
1885: SELECT tax_jurisdiction_code
1886: FROM zx_jurisdictions_gt
1887: WHERE tax_regime_code = p_regime_code
1888: AND tax = p_tax
1889: AND substr(tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1890: AND precedence_level = (SELECT max(precedence_level)

Line 1891: FROM zx_jurisdictions_gt

1887: WHERE tax_regime_code = p_regime_code
1888: AND tax = p_tax
1889: AND substr(tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1890: AND precedence_level = (SELECT max(precedence_level)
1891: FROM zx_jurisdictions_gt
1892: WHERE tax_regime_code = p_regime_code
1893: AND substr(tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1894: AND tax = p_tax)
1895: ORDER BY tax_jurisdiction_code)

Line 3535: delete from zx_jurisdictions_gt;

3531: p_tax_lines_tbl.exempt_reason(ind) :=line_out_tab(1).fPriCiExmtRsnCd;
3532: else null;
3533: END IF;
3534:
3535: delete from zx_jurisdictions_gt;
3536: GET_TAX_JUR_CODE (p_location_id ,
3537: p_tax_lines_tbl.Situs(ind) ,
3538: p_tax_lines_tbl.Tax(ind) ,
3539: l_regime_code ,

Line 3547: delete from zx_jurisdictions_gt;

3543: );
3544:
3545: p_tax_lines_tbl.tax_jurisdiction(ind) := x_tax_jurisdiction_code;
3546:
3547: delete from zx_jurisdictions_gt;
3548:
3549: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3550: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'tax line output ');
3551: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'p_tax_lines_tbl.document_type_id('||ind||') = '|| to_char(p_tax_lines_tbl.document_type_id(ind)));