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.

APPS.ZX_SIM_CONDITIONS_PKG dependencies on ZX_CONDITION_GROUPS_B

Line 550: zx_condition_groups_b_s.nextval

546: 'Simulate Rules and Process Results for Applicability');
547: END IF;
548:
549: Select zx_rules_b_s.nextval,
550: zx_condition_groups_b_s.nextval
551: Into l_rule_id,
552: l_cg_id
553: From Dual;
554: INSERT ALL

Line 676: zx_condition_groups_b_s.nextval

672: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
673: 'Simulate Rules and Process Results for Status Determination');
674: END IF;
675: Select zx_rules_b_s.nextval,
676: zx_condition_groups_b_s.nextval
677: Into l_rule_id,
678: l_cg_id
679: From Dual;
680:

Line 796: zx_condition_groups_b_s.nextval

792: 'Simulate Rules and Process Results for Rate Determination');
793: END IF;
794:
795: Select zx_rules_b_s.nextval,
796: zx_condition_groups_b_s.nextval
797: Into l_rule_id,
798: l_cg_id
799: From Dual;
800: INSERT ALL

Line 1123: INTO zx_condition_groups_b (

1119: 'Create Condition Groups Setup without Conditions');
1120: END IF;
1121:
1122: INSERT ALL WHEN (1=1) Then
1123: INTO zx_condition_groups_b (
1124: condition_group_id,
1125: condition_group_code,
1126: det_factor_templ_code,
1127: record_type_code,

Line 1176: zx_condition_groups_b b

1172: fnd_global.user_id created_by,
1173: sysdate last_update_date,
1174: fnd_global.user_id last_updated_by
1175: from fnd_languages l,
1176: zx_condition_groups_b b
1177: where l.installed_flag in ('I', 'B')
1178: and exists (Select NULL
1179: From zx_sim_process_results s
1180: Where s.condition_group_code = b.condition_group_code

Line 1199: UPDATE zx_condition_groups_b

1195: l_cond_cnt := 1;
1196: FOR j IN c_conditions (i.condition_group_code)
1197: LOOP
1198: IF l_cond_cnt = 1 THEN
1199: UPDATE zx_condition_groups_b
1200: SET more_than_max_cond_flag = 'N',
1201: determining_factor_class1_code = j.determining_factor_class_code,
1202: determining_factor_cq1_code = j.determining_factor_cq_code,
1203: determining_factor_code1 = j.determining_factor_code,

Line 1215: UPDATE zx_condition_groups_b

1211: value_high1 = j.value_high
1212: WHERE condition_group_code = i.condition_group_code;
1213: l_cond_cnt := l_cond_cnt + 1;
1214: ELSIF l_cond_cnt = 2 THEN
1215: UPDATE zx_condition_groups_b
1216: SET determining_factor_class2_code = j.determining_factor_class_code,
1217: determining_factor_cq2_code = j.determining_factor_cq_code,
1218: determining_factor_code2 = j.determining_factor_code,
1219: tax_parameter_code2 = j.tax_parameter_code,

Line 1230: UPDATE zx_condition_groups_b

1226: value_high2 = j.value_high
1227: WHERE condition_group_code = i.condition_group_code;
1228: l_cond_cnt := l_cond_cnt + 1;
1229: ELSIF l_cond_cnt = 3 THEN
1230: UPDATE zx_condition_groups_b
1231: SET determining_factor_class3_code = j.determining_factor_class_code,
1232: determining_factor_cq3_code = j.determining_factor_cq_code,
1233: determining_factor_code3 = j.determining_factor_code,
1234: tax_parameter_code3 = j.tax_parameter_code,

Line 1245: UPDATE zx_condition_groups_b

1241: value_high3 = j.value_high
1242: WHERE condition_group_code = i.condition_group_code;
1243: l_cond_cnt := l_cond_cnt + 1;
1244: ELSIF l_cond_cnt = 4 THEN
1245: UPDATE zx_condition_groups_b
1246: SET determining_factor_class4_code = j.determining_factor_class_code,
1247: determining_factor_cq4_code = j.determining_factor_cq_code,
1248: determining_factor_code4 = j.determining_factor_code,
1249: tax_parameter_code4 = j.tax_parameter_code,

Line 1260: UPDATE zx_condition_groups_b

1256: value_high4 = j.value_high
1257: WHERE condition_group_code = i.condition_group_code;
1258: l_cond_cnt := l_cond_cnt + 1;
1259: ELSIF l_cond_cnt = 5 THEN
1260: UPDATE zx_condition_groups_b
1261: SET determining_factor_class5_code = j.determining_factor_class_code,
1262: determining_factor_cq5_code = j.determining_factor_cq_code,
1263: determining_factor_code5 = j.determining_factor_code,
1264: tax_parameter_code5 = j.tax_parameter_code,

Line 1275: UPDATE zx_condition_groups_b

1271: value_high5 = j.value_high
1272: WHERE condition_group_code = i.condition_group_code;
1273: l_cond_cnt := l_cond_cnt + 1;
1274: ELSIF l_cond_cnt = 6 THEN
1275: UPDATE zx_condition_groups_b
1276: SET determining_factor_class6_code = j.determining_factor_class_code,
1277: determining_factor_cq6_code = j.determining_factor_cq_code,
1278: determining_factor_code6 = j.determining_factor_code,
1279: tax_parameter_code6 = j.tax_parameter_code,

Line 1290: UPDATE zx_condition_groups_b

1286: value_high6 = j.value_high
1287: WHERE condition_group_code = i.condition_group_code;
1288: l_cond_cnt := l_cond_cnt + 1;
1289: ELSIF l_cond_cnt = 7 THEN
1290: UPDATE zx_condition_groups_b
1291: SET determining_factor_class7_code = j.determining_factor_class_code,
1292: determining_factor_cq7_code = j.determining_factor_cq_code,
1293: determining_factor_code7 = j.determining_factor_code,
1294: tax_parameter_code7 = j.tax_parameter_code,

Line 1305: UPDATE zx_condition_groups_b

1301: value_high7 = j.value_high
1302: WHERE condition_group_code = i.condition_group_code;
1303: l_cond_cnt := l_cond_cnt + 1;
1304: ELSIF l_cond_cnt = 8 THEN
1305: UPDATE zx_condition_groups_b
1306: SET determining_factor_class8_code = j.determining_factor_class_code,
1307: determining_factor_cq8_code = j.determining_factor_cq_code,
1308: determining_factor_code8 = j.determining_factor_code,
1309: tax_parameter_code8 = j.tax_parameter_code,

Line 1320: UPDATE zx_condition_groups_b

1316: value_high8 = j.value_high
1317: WHERE condition_group_code = i.condition_group_code;
1318: l_cond_cnt := l_cond_cnt + 1;
1319: ELSIF l_cond_cnt = 9 THEN
1320: UPDATE zx_condition_groups_b
1321: SET determining_factor_class9_code = j.determining_factor_class_code,
1322: determining_factor_cq9_code = j.determining_factor_cq_code,
1323: determining_factor_code9 = j.determining_factor_code,
1324: tax_parameter_code9 = j.tax_parameter_code,

Line 1335: UPDATE zx_condition_groups_b

1331: value_high9 = j.value_high
1332: WHERE condition_group_code = i.condition_group_code;
1333: l_cond_cnt := l_cond_cnt + 1;
1334: ELSIF l_cond_cnt = 10 THEN
1335: UPDATE zx_condition_groups_b
1336: SET determining_factor_clas10_code = j.determining_factor_class_code,
1337: determining_factor_cq10_code = j.determining_factor_cq_code,
1338: determining_factor_code10 = j.determining_factor_code,
1339: tax_parameter_code10 = j.tax_parameter_code,