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_SIM_CONDITIONS_PKG dependencies on ZX_SIM_RULES_B

Line 56: INSERT INTO zx_sim_rules_b (

52: END IF;
53:
54: p_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: INSERT INTO zx_sim_rules_b (
57: sim_tax_rule_id,
58: content_owner_id,
59: tax_rule_code,
60: tax,

Line 131: from zx_sim_rules_b);

127: sysdate last_update_date,
128: last_update_login
129: FROM zx_rules_tl
130: WHERE tax_rule_id IN (select sim_tax_rule_id
131: from zx_sim_rules_b);
132:
133: IF (g_level_statement >= g_current_runtime_level ) THEN
134: FND_LOG.STRING(g_level_statement,
135: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',

Line 170: from zx_sim_rules_b);

166: numeric_result,
167: alphanumeric_result
168: FROM zx_process_results
169: WHERE tax_rule_id IN (select sim_tax_rule_id
170: from zx_sim_rules_b);
171:
172: IF (g_level_statement >= g_current_runtime_level ) THEN
173: FND_LOG.STRING(g_level_statement,
174: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_from_existing_rules',

Line 514: DELETE zx_sim_rules_b;

510: FND_LOG.STRING(g_level_statement,
511: 'ZX.PLSQL.ZX_SIM_CONDITIONS_PKG.create_sim_rules',
512: 'Delete any existing Simulated Rules, Process Results and Conditions');
513: END IF;
514: DELETE zx_sim_rules_b;
515: DELETE zx_sim_rules_tl;
516: DELETE zx_sim_process_results;
517: DELETE zx_sim_rule_conditions;
518:

Line 556: INTO zx_sim_rules_b (

552: l_cg_id
553: From Dual;
554: INSERT ALL
555: WHEN (1=1) Then
556: INTO zx_sim_rules_b (
557: sim_tax_rule_id,
558: content_owner_id,
559: tax_rule_code,
560: tax,

Line 683: INTO zx_sim_rules_b (

679: From Dual;
680:
681: INSERT ALL
682: WHEN (1=1) Then
683: INTO zx_sim_rules_b (
684: sim_tax_rule_id,
685: content_owner_id,
686: tax_rule_code,
687: tax,

Line 802: INTO zx_sim_rules_b (

798: l_cg_id
799: From Dual;
800: INSERT ALL
801: WHEN (1=1) Then
802: INTO zx_sim_rules_b (
803: sim_tax_rule_id,
804: content_owner_id,
805: tax_rule_code,
806: tax,

Line 934: zx_sim_rules_b b

930: fnd_global.user_id created_by,
931: sysdate last_update_date,
932: fnd_global.user_id last_updated_by
933: from fnd_languages l,
934: zx_sim_rules_b b
935: where l.installed_flag in ('I', 'B')
936: and not exists
937: (select NULL
938: from zx_sim_rules_tl t

Line 1032: FROM zx_sim_rules_b

1028: sysdate,
1029: fnd_global.user_id,
1030: sysdate)
1031: SELECT det_factor_templ_code
1032: FROM zx_sim_rules_b
1033: WHERE simulated_flag = 'Y'
1034: GROUP BY det_factor_templ_code;
1035:
1036: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1063: From zx_sim_rules_b s

1059: from fnd_languages l,
1060: zx_det_factor_templ_b b
1061: where l.installed_flag in ('I', 'B')
1062: and exists (Select NULL
1063: From zx_sim_rules_b s
1064: Where s.det_factor_templ_code = b.det_factor_templ_code
1065: And s.simulated_flag = 'Y')
1066: and not exists (Select NULL
1067: From zx_det_factor_templ_tl t

Line 1110: zx_sim_rules_b r

1106: FROM zx_sim_rule_conditions cond,
1107: (select det_factor_templ_code,
1108: condition_group_code
1109: from zx_sim_process_results p,
1110: zx_sim_rules_b r
1111: where p.sim_tax_rule_id = r.sim_tax_rule_id
1112: group by condition_group_code, det_factor_templ_code) rule
1113: WHERE cond.condition_group_code = rule.condition_group_code
1114: AND simulated_flag = 'Y';

Line 1146: FROM zx_sim_rules_b rule,

1142: fnd_global.user_id,
1143: sysdate)
1144: SELECT condition_group_code,
1145: det_factor_templ_code
1146: FROM zx_sim_rules_b rule,
1147: zx_sim_process_results result
1148: WHERE result.sim_tax_rule_id = rule.sim_tax_rule_id
1149: AND result.simulated_flag = 'Y'
1150: GROUP BY condition_group_code, det_factor_templ_code;

Line 1440: FROM zx_sim_rules_b

1436: fnd_global.user_id created_by,
1437: sysdate creation_date,
1438: fnd_global.user_id last_updated_by,
1439: sysdate last_update_date
1440: FROM zx_sim_rules_b
1441: WHERE simulated_flag = 'Y';
1442:
1443: IF (g_level_statement >= g_current_runtime_level ) THEN
1444: FND_LOG.STRING(g_level_statement,

Line 1470: From zx_sim_rules_b s

1466: from fnd_languages l,
1467: zx_rules_b b
1468: where l.installed_flag in ('I', 'B')
1469: and exists (Select NULL
1470: From zx_sim_rules_b s
1471: Where s.sim_tax_rule_id = b.tax_rule_id
1472: And s.simulated_flag = 'Y')
1473: and not exists (Select NULL
1474: From zx_rules_tl t

Line 1486: From zx_sim_rules_b sim

1482: END IF;
1483:
1484: UPDATE zx_rules_b
1485: SET priority = (Select sim.priority
1486: From zx_sim_rules_b sim
1487: Where sim.sim_tax_rule_id = zx_rules_b.tax_rule_id)
1488: WHERE tax_rule_id IN (Select sim_tax_rule_id
1489: From zx_sim_rules_b sim
1490: Where sim.priority <> zx_rules_b.priority

Line 1489: From zx_sim_rules_b sim

1485: SET priority = (Select sim.priority
1486: From zx_sim_rules_b sim
1487: Where sim.sim_tax_rule_id = zx_rules_b.tax_rule_id)
1488: WHERE tax_rule_id IN (Select sim_tax_rule_id
1489: From zx_sim_rules_b sim
1490: Where sim.priority <> zx_rules_b.priority
1491: And sim.simulated_flag <> 'Y');
1492:
1493: IF (g_level_statement >= g_current_runtime_level ) THEN

Line 1532: FROM zx_sim_rules_b rule,

1528: fnd_global.user_id created_by,
1529: sysdate creation_date,
1530: fnd_global.user_id last_updated_by,
1531: sysdate last_update_date
1532: FROM zx_sim_rules_b rule,
1533: zx_sim_process_results result
1534: WHERE result.sim_tax_rule_id = rule.sim_tax_rule_id
1535: AND result.simulated_flag = 'Y';
1536: