APPS.JTF_STATE_RULES_PKG dependencies on JTF_STATE_RULES_B

Line 35: FROM jtf_state_rules_b

31: IS
32: CURSOR c
33: IS
34: SELECT ROWID
35: FROM jtf_state_rules_b
36: WHERE rule_id = x_rule_id;
37: BEGIN
38: INSERT INTO jtf_state_rules_b (
39: rule_id,

Line 38: INSERT INTO jtf_state_rules_b (

34: SELECT ROWID
35: FROM jtf_state_rules_b
36: WHERE rule_id = x_rule_id;
37: BEGIN
38: INSERT INTO jtf_state_rules_b (
39: rule_id,
40: state_type,
41: attribute1,
42: attribute2,

Line 190: UPDATE jtf_state_rules_b

186: x_application_id IN NUMBER
187: )
188: IS
189: BEGIN
190: UPDATE jtf_state_rules_b
191: SET state_type = x_state_type,
192: object_version_number = x_object_version_number + 1,
193: attribute1 = x_attribute1,
194: attribute2 = x_attribute2,

Line 248: FROM jtf_state_rules_b

244: RAISE NO_DATA_FOUND;
245: END IF;
246:
247: DELETE
248: FROM jtf_state_rules_b
249: WHERE rule_id = x_rule_id;
250:
251: IF (SQL%NOTFOUND)
252: THEN

Line 263: FROM jtf_state_rules_b b

259: BEGIN
260: DELETE
261: FROM jtf_state_rules_tl t
262: WHERE NOT EXISTS (SELECT NULL
263: FROM jtf_state_rules_b b
264: WHERE b.rule_id = t.rule_id);
265: UPDATE jtf_state_rules_tl t
266: SET (rule_name) = ( SELECT b.rule_name
267: FROM jtf_state_rules_tl b