eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ZX_VERTEX_TAX_SERVICE_PKG dependencies on ZX_JURISDICTIONS_GT

Line 1268: delete from zx_jurisdictions_gt;

1264: pg_exempt_reason_tab ,
1265: pg_exempt_cont_flag_tab
1266: limit C_LINES_PER_COMMIT;/*Need to limit the fetch*/
1267:
1268: delete from zx_jurisdictions_gt;
1269: l_index := 0;
1270:
1271: IF (nvl(pg_trx_id_tab.last,0) = 0) Then
1272: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1289: For ptr in 1..nvl(pg_trx_id_tab.last, 0) loop
1290:
1291: I:=ptr;
1292: -- In case of partners, since there are two calls to get_tax_jurisdictions API
1293: -- we need to delete from zx_jurisdictions_gt before each of the calls to
1294: -- get_tax_jurisdictions API
1295: -- IF pg_trx_line_id_tab(i) <> g_transaction_line_id THEN
1296: -- delete from zx_jurisdictions_gt;
1297: -- END IF;

Line 1296: -- delete from zx_jurisdictions_gt;

1292: -- In case of partners, since there are two calls to get_tax_jurisdictions API
1293: -- we need to delete from zx_jurisdictions_gt before each of the calls to
1294: -- get_tax_jurisdictions API
1295: -- IF pg_trx_line_id_tab(i) <> g_transaction_line_id THEN
1296: -- delete from zx_jurisdictions_gt;
1297: -- END IF;
1298: g_transaction_line_id := pg_trx_line_id_tab(i);
1299: g_trx_level_type := pg_trx_level_type_tab(i);
1300: g_docment_type_id := pg_doc_type_id_tab(i);

Line 1946: FROM zx_jurisdictions_gt

1942: SELECT tax_jurisdiction_code
1943: INTO x_tax_jurisdiction_code
1944: FROM (
1945: SELECT tax_jurisdiction_code
1946: FROM zx_jurisdictions_gt
1947: WHERE tax_regime_code = p_regime_code
1948: AND tax = p_tax
1949: AND substr(tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1950: AND precedence_level = (SELECT max(precedence_level)

Line 1951: FROM zx_jurisdictions_gt

1947: WHERE tax_regime_code = p_regime_code
1948: AND tax = p_tax
1949: AND substr(tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1950: AND precedence_level = (SELECT max(precedence_level)
1951: FROM zx_jurisdictions_gt
1952: WHERE tax_regime_code = p_regime_code
1953: AND substr(tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1954: AND tax = p_tax)
1955: ORDER BY tax_jurisdiction_code)

Line 3633: delete from zx_jurisdictions_gt;

3629: p_tax_lines_tbl.exempt_reason(ind) :=line_out_tab(1).fPriCiExmtRsnCd;
3630: else null;
3631: END IF;
3632:
3633: delete from zx_jurisdictions_gt;
3634: GET_TAX_JUR_CODE (p_location_id ,
3635: p_tax_lines_tbl.Situs(ind) ,
3636: p_tax_lines_tbl.Tax(ind) ,
3637: l_regime_code ,

Line 3645: delete from zx_jurisdictions_gt;

3641: );
3642:
3643: p_tax_lines_tbl.tax_jurisdiction(ind) := x_tax_jurisdiction_code;
3644:
3645: delete from zx_jurisdictions_gt;
3646:
3647: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3648: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,'tax line output ');
3649: 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)));