APPS.ZX_TCM_GEO_JUR_PKG dependencies on ZX_JURISDICTIONS_GT

Line 1168: INSERT INTO zx_jurisdictions_gt

1164: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1165: END IF;
1166: ELSIF l_jurisdiction_rec_tmp_tbl.count > 1 THEN
1167: FOR n in l_jurisdiction_rec_tmp_tbl.first..l_jurisdiction_rec_tmp_tbl.last LOOP
1168: INSERT INTO zx_jurisdictions_gt
1169: (TAX_JURISDICTION_ID,
1170: TAX_JURISDICTION_CODE,
1171: TAX_REGIME_CODE,
1172: TAX,

Line 1182: FROM zx_jurisdictions_gt

1178: l_jurisdiction_rec_tmp_tbl(n).tax,
1179: l_jurisdiction_rec_tmp_tbl(n).precedence_level
1180: FROM dual
1181: WHERE NOT EXISTS (SELECT '1'
1182: FROM zx_jurisdictions_gt
1183: WHERE tax_jurisdiction_id = l_jurisdiction_rec_tmp_tbl(n).tax_jurisdiction_id);
1184:
1185: END LOOP;
1186: x_jurisdictions_found := 'Y';

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

1186: x_jurisdictions_found := 'Y';
1187:
1188: -- Logging Infra: Statement level: "R" means "R"eturned value to a caller
1189: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1190: l_log_msg := 'R: Inserted into zx_jurisdictions_gt table)' ;
1191: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1192: END IF;
1193: ELSIF l_jurisdiction_rec_tmp_tbl.count = 0 THEN
1194: x_jurisdictions_found := 'N';