APPS.JTF_STATE_RULES_PKG dependencies on JTF_STATE_RULES_TL

Line 92: INSERT INTO jtf_state_rules_tl

88: x_last_update_login,
89: 1,
90: x_application_id
91: );
92: INSERT INTO jtf_state_rules_tl
93: (rule_id,
94: rule_name,
95: created_by,
96: creation_date,

Line 115: FROM jtf_state_rules_tl t

111: USERENV ('LANG')
112: FROM fnd_languages l
113: WHERE l.installed_flag IN ('I', 'B')
114: AND NOT EXISTS (SELECT NULL
115: FROM jtf_state_rules_tl t
116: WHERE t.rule_id = x_rule_id
117: AND t.language = l.language_code);
118: OPEN c;
119: FETCH c INTO x_rowid;

Line 220: UPDATE jtf_state_rules_tl

216: THEN
217: RAISE NO_DATA_FOUND;
218: END IF;
219:
220: UPDATE jtf_state_rules_tl
221: SET rule_name = x_rule_name,
222: last_update_date = x_last_update_date,
223: last_updated_by = x_last_updated_by,
224: last_update_login = x_last_update_login,

Line 239: FROM jtf_state_rules_tl

235: PROCEDURE delete_row (x_rule_id IN NUMBER)
236: IS
237: BEGIN
238: DELETE
239: FROM jtf_state_rules_tl
240: WHERE rule_id = x_rule_id;
241:
242: IF (SQL%NOTFOUND)
243: THEN

Line 261: FROM jtf_state_rules_tl t

257: PROCEDURE add_language
258: IS
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

Line 265: UPDATE jtf_state_rules_tl t

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
268: WHERE b.rule_id = t.rule_id
269: AND b.language = t.source_lang)

Line 267: FROM jtf_state_rules_tl b

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
268: WHERE b.rule_id = t.rule_id
269: AND b.language = t.source_lang)
270: WHERE (t.rule_id, t.language) IN
271: (SELECT subt.rule_id, subt.language

Line 272: FROM jtf_state_rules_tl subb, jtf_state_rules_tl subt

268: WHERE b.rule_id = t.rule_id
269: AND b.language = t.source_lang)
270: WHERE (t.rule_id, t.language) IN
271: (SELECT subt.rule_id, subt.language
272: FROM jtf_state_rules_tl subb, jtf_state_rules_tl subt
273: WHERE subb.rule_id = subt.rule_id
274: AND subb.language = subt.source_lang
275: AND (subb.rule_name <> subt.rule_name));
276: INSERT INTO jtf_state_rules_tl

Line 276: INSERT INTO jtf_state_rules_tl

272: FROM jtf_state_rules_tl subb, jtf_state_rules_tl subt
273: WHERE subb.rule_id = subt.rule_id
274: AND subb.language = subt.source_lang
275: AND (subb.rule_name <> subt.rule_name));
276: INSERT INTO jtf_state_rules_tl
277: (rule_id,
278: rule_name,
279: created_by,
280: creation_date,

Line 296: FROM jtf_state_rules_tl b, fnd_languages l

292: b.last_update_date,
293: b.last_update_login,
294: l.language_code,
295: b.source_lang
296: FROM jtf_state_rules_tl b, fnd_languages l
297: WHERE l.installed_flag IN ('I', 'B')
298: AND b.language = USERENV ('LANG')
299: AND NOT EXISTS (SELECT NULL
300: FROM jtf_state_rules_tl t

Line 300: FROM jtf_state_rules_tl t

296: FROM jtf_state_rules_tl b, fnd_languages l
297: WHERE l.installed_flag IN ('I', 'B')
298: AND b.language = USERENV ('LANG')
299: AND NOT EXISTS (SELECT NULL
300: FROM jtf_state_rules_tl t
301: WHERE t.rule_id = b.rule_id
302: AND t.language = l.language_code);
303: END add_language;
304:

Line 318: UPDATE jtf_state_rules_tl

314: THEN
315: l_user_id := 1;
316: END IF;
317:
318: UPDATE jtf_state_rules_tl
319: SET rule_name = NVL (x_rule_name, rule_name),
320: last_update_date = SYSDATE,
321: last_update_login = 0,
322: source_lang = USERENV ('LANG'),