APPS.ZX_TCM_GEO_JUR_PKG dependencies on ZX_JURISDICTIONS_GT

Line 1372: INSERT INTO zx_jurisdictions_gt

1368: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1369: END IF;
1370: ELSIF l_jurisdiction_rec_tmp_tbl.count > 1 THEN
1371: FOR n in l_jurisdiction_rec_tmp_tbl.first..l_jurisdiction_rec_tmp_tbl.last LOOP
1372: INSERT INTO zx_jurisdictions_gt
1373: (TAX_JURISDICTION_ID,
1374: TAX_JURISDICTION_CODE,
1375: TAX_REGIME_CODE,
1376: TAX,

Line 1386: FROM zx_jurisdictions_gt

1382: l_jurisdiction_rec_tmp_tbl(n).tax,
1383: l_jurisdiction_rec_tmp_tbl(n).precedence_level
1384: FROM dual
1385: WHERE NOT EXISTS (SELECT '1'
1386: FROM zx_jurisdictions_gt
1387: WHERE tax_jurisdiction_code = l_jurisdiction_rec_tmp_tbl(n).tax_jurisdiction_code
1388: AND tax_regime_code = l_jurisdiction_rec_tmp_tbl(n).tax_regime_code
1389: AND tax = l_jurisdiction_rec_tmp_tbl(n).tax
1390: );

Line 1397: l_log_msg := 'R: Inserted into zx_jurisdictions_gt table)' ;

1393: x_jurisdictions_found := 'Y';
1394:
1395: -- Logging Infra: Statement level: "R" means "R"eturned value to a caller
1396: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1397: l_log_msg := 'R: Inserted into zx_jurisdictions_gt table)' ;
1398: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1399: END IF;
1400: ELSIF l_jurisdiction_rec_tmp_tbl.count = 0 THEN
1401: x_jurisdictions_found := 'N';