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.JTF_TASK_TYPES_PKG dependencies on JTF_TASK_TYPES_TL

Line 120: INSERT INTO jtf_task_types_tl

116: x_last_update_login,
117: x_rule,
118: x_workflow_type
119: );
120: INSERT INTO jtf_task_types_tl
121: (task_type_id,
122: name,
123: description,
124: created_by,

Line 145: FROM jtf_task_types_tl t

141: USERENV ('LANG')
142: FROM fnd_languages l
143: WHERE l.installed_flag IN ('I', 'B')
144: AND NOT EXISTS (SELECT NULL
145: FROM jtf_task_types_tl t
146: WHERE t.task_type_id = x_task_type_id
147: AND t.language = l.language_code);
148: OPEN c;
149: FETCH c INTO x_rowid;

Line 276: UPDATE /+ INDEX(a JTF_TASK_TYPES_TL_U1) / jtf_task_types_tl a

272: RAISE NO_DATA_FOUND;
273: END IF;
274:
275: -- Added Index Hint on 30/05/2006 for bug# 5213367
276: UPDATE /*+ INDEX(a JTF_TASK_TYPES_TL_U1) */ jtf_task_types_tl a
277: SET a.name = x_name,
278: a.description = x_description,
279: a.last_update_date = x_last_update_date,
280: a.last_updated_by = x_last_updated_by,

Line 296: FROM jtf_task_types_tl

292: PROCEDURE delete_row (x_task_type_id IN NUMBER)
293: IS
294: BEGIN
295: DELETE
296: FROM jtf_task_types_tl
297: WHERE task_type_id = x_task_type_id;
298:
299: IF (SQL%NOTFOUND)
300: THEN

Line 323: FROM jtf_task_types_tl t

319: /* The following delete and update statements are commented out */
320: /* as a quick workaround to fix the time-consuming table handler issue */
321: /*
322: DELETE
323: FROM jtf_task_types_tl t
324: WHERE NOT EXISTS (SELECT NULL
325: FROM jtf_task_types_b b
326: WHERE b.task_type_id = t.task_type_id);
327: UPDATE jtf_task_types_tl t

Line 327: UPDATE jtf_task_types_tl t

323: FROM jtf_task_types_tl t
324: WHERE NOT EXISTS (SELECT NULL
325: FROM jtf_task_types_b b
326: WHERE b.task_type_id = t.task_type_id);
327: UPDATE jtf_task_types_tl t
328: SET (name, description) = ( SELECT b.name, b.description
329: FROM jtf_task_types_tl b
330: WHERE b.task_type_id = t.task_type_id
331: AND b.language = t.source_lang)

Line 329: FROM jtf_task_types_tl b

325: FROM jtf_task_types_b b
326: WHERE b.task_type_id = t.task_type_id);
327: UPDATE jtf_task_types_tl t
328: SET (name, description) = ( SELECT b.name, b.description
329: FROM jtf_task_types_tl b
330: WHERE b.task_type_id = t.task_type_id
331: AND b.language = t.source_lang)
332: WHERE (t.task_type_id, t.language) IN
333: (SELECT subt.task_type_id, subt.language

Line 334: FROM jtf_task_types_tl subb, jtf_task_types_tl subt

330: WHERE b.task_type_id = t.task_type_id
331: AND b.language = t.source_lang)
332: WHERE (t.task_type_id, t.language) IN
333: (SELECT subt.task_type_id, subt.language
334: FROM jtf_task_types_tl subb, jtf_task_types_tl subt
335: WHERE subb.task_type_id = subt.task_type_id
336: AND subb.language = subt.source_lang
337: AND ( subb.name <> subt.name
338: OR subb.description <> subt.description

Line 345: INSERT INTO jtf_task_types_tl

341: OR ( subb.description IS NOT NULL
342: AND subt.description IS NULL)));
343: */
344:
345: INSERT INTO jtf_task_types_tl
346: (task_type_id,
347: name,
348: description,
349: created_by,

Line 357: SELECT /+ INDEX(b JTF_TASK_TYPES_TL_U1) INDEX (l FND_LANGUAGES_N1) / -- Added Index Hint on 30/05/2006 for bug# 5213367

353: last_update_login,
354: language,
355: source_lang
356: )
357: SELECT /*+ INDEX(b JTF_TASK_TYPES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
358: b.task_type_id,
359: b.name,
360: b.description,
361: b.created_by,

Line 368: FROM jtf_task_types_tl b, fnd_languages l

364: b.last_update_date,
365: b.last_update_login,
366: l.language_code,
367: b.source_lang
368: FROM jtf_task_types_tl b, fnd_languages l
369: WHERE l.installed_flag IN ('I', 'B')
370: AND b.language = USERENV ('LANG')
371: AND NOT EXISTS (SELECT NULL
372: FROM jtf_task_types_tl t

Line 372: FROM jtf_task_types_tl t

368: FROM jtf_task_types_tl b, fnd_languages l
369: WHERE l.installed_flag IN ('I', 'B')
370: AND b.language = USERENV ('LANG')
371: AND NOT EXISTS (SELECT NULL
372: FROM jtf_task_types_tl t
373: WHERE t.task_type_id = b.task_type_id
374: AND t.language = l.language_code);
375: END add_language;
376:

Line 392: UPDATE /+ INDEX(a JTF_TASK_TYPES_TL_U1) / jtf_task_types_tl a

388: l_user_id := 1;
389: END IF;
390:
391: -- Added Index Hint on 30/05/2006 for bug# 5213367
392: UPDATE /*+ INDEX(a JTF_TASK_TYPES_TL_U1) */ jtf_task_types_tl a
393: SET a.name = NVL (x_name, a.name),
394: a.description = NVL (x_description, a.description),
395: a.last_update_date = SYSDATE,
396: a.last_update_login = 0,

Line 484: UPDATE /+ INDEX(a JTF_TASK_TYPES_TL_U1) / jtf_task_types_tl a

480: workflow_type = x_workflow_type
481: WHERE task_type_id = l_task_type_id;
482:
483: -- Added Index Hint on 30/05/2006 for bug# 5213367
484: UPDATE /*+ INDEX(a JTF_TASK_TYPES_TL_U1) */ jtf_task_types_tl a
485: SET a.name = x_name,
486: a.description = x_description,
487: a.last_update_date = sysdate,
488: a.last_updated_by = l_user_id,