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.JTF_TASKS_PKG dependencies on JTF_TASKS_TL

Line 414: INSERT INTO jtf_tasks_tl

410: END IF;
411:
412: CLOSE c;
413:
414: INSERT INTO jtf_tasks_tl
415: (task_name,
416: description,
417: created_by,
418: creation_date,

Line 439: FROM jtf_tasks_tl t

435: USERENV ('LANG')
436: FROM fnd_languages l
437: WHERE l.installed_flag IN ('I', 'B')
438: AND NOT EXISTS (SELECT NULL
439: FROM jtf_tasks_tl t
440: WHERE t.task_id = x_task_id
441: AND t.language = l.language_code);
442: OPEN c;
443: FETCH c INTO x_rowid;

Line 469: FROM jtf_tasks_tl

465:
466: CURSOR c1
467: IS
468: SELECT task_name, description, DECODE (language, USERENV ('LANG'), 'Y', 'N') baselang
469: FROM jtf_tasks_tl
470: WHERE task_id = x_task_id
471: AND USERENV ('LANG') IN (language, source_lang)
472: FOR UPDATE OF task_id NOWAIT;
473:

Line 942: UPDATE jtf_tasks_tl

938: THEN
939: RAISE NO_DATA_FOUND;
940: END IF;
941:
942: UPDATE jtf_tasks_tl
943: SET task_name = l_Task_Upd_Rec.task_name,
944: description = l_Task_Upd_Rec.description,
945: last_update_date = l_Task_Upd_Rec.last_update_date,
946: last_updated_by = l_Task_Upd_Rec.last_updated_by,

Line 980: FROM jtf_tasks_tl t

976: /* as a quick workaround to fix the time-consuming table handler issue */
977: /*
978:
979: /* DELETE
980: FROM jtf_tasks_tl t
981: WHERE NOT EXISTS (SELECT NULL
982: FROM jtf_tasks_b b
983: WHERE b.task_id = t.task_id);
984: UPDATE jtf_tasks_tl t

Line 984: UPDATE jtf_tasks_tl t

980: FROM jtf_tasks_tl t
981: WHERE NOT EXISTS (SELECT NULL
982: FROM jtf_tasks_b b
983: WHERE b.task_id = t.task_id);
984: UPDATE jtf_tasks_tl t
985: SET (task_name, description) = ( SELECT b.task_name, b.description
986: FROM jtf_tasks_tl b
987: WHERE b.task_id = t.task_id
988: AND b.language = t.source_lang)

Line 986: FROM jtf_tasks_tl b

982: FROM jtf_tasks_b b
983: WHERE b.task_id = t.task_id);
984: UPDATE jtf_tasks_tl t
985: SET (task_name, description) = ( SELECT b.task_name, b.description
986: FROM jtf_tasks_tl b
987: WHERE b.task_id = t.task_id
988: AND b.language = t.source_lang)
989: WHERE (t.task_id, t.language) IN (SELECT subt.task_id, subt.language
990: FROM jtf_tasks_tl subb, jtf_tasks_tl subt

Line 990: FROM jtf_tasks_tl subb, jtf_tasks_tl subt

986: FROM jtf_tasks_tl b
987: WHERE b.task_id = t.task_id
988: AND b.language = t.source_lang)
989: WHERE (t.task_id, t.language) IN (SELECT subt.task_id, subt.language
990: FROM jtf_tasks_tl subb, jtf_tasks_tl subt
991: WHERE subb.task_id = subt.task_id
992: AND subb.language = subt.source_lang
993: AND ( subb.task_name <> subt.task_name
994: OR subb.description <> subt.description

Line 1000: INSERT INTO jtf_tasks_tl

996: AND subt.description IS NOT NULL)
997: OR ( subb.description IS NOT NULL
998: AND subt.description IS NULL)));
999:
1000: INSERT INTO jtf_tasks_tl
1001: (task_name,
1002: description,
1003: created_by,
1004: creation_date,

Line 1022: FROM jtf_tasks_tl b, fnd_languages l

1018: b.last_update_login,
1019: b.task_id,
1020: l.language_code,
1021: b.source_lang
1022: FROM jtf_tasks_tl b, fnd_languages l
1023: WHERE l.installed_flag IN ('I', 'B')
1024: AND b.language = USERENV ('LANG')
1025: AND NOT EXISTS (SELECT NULL
1026: FROM jtf_tasks_tl t

Line 1026: FROM jtf_tasks_tl t

1022: FROM jtf_tasks_tl b, fnd_languages l
1023: WHERE l.installed_flag IN ('I', 'B')
1024: AND b.language = USERENV ('LANG')
1025: AND NOT EXISTS (SELECT NULL
1026: FROM jtf_tasks_tl t
1027: WHERE t.task_id = b.task_id
1028: AND t.language = l.language_code);
1029:
1030: *** Additional fix for the same bug is to add parallel hints to insert.

Line 1033: INSERT /+ append parallel(tl) / INTO jtf_tasks_tl tl

1029:
1030: *** Additional fix for the same bug is to add parallel hints to insert.
1031: *** Replaced the original query with one below (mmmarovic on 3/7/05)
1032: */
1033: INSERT /*+ append parallel(tl) */ INTO jtf_tasks_tl tl
1034: (task_name, description, created_by, creation_date,
1035: last_updated_by, last_update_date, last_update_login,
1036: task_id, language, source_lang)
1037: SELECT /*+ parallel(v) parallel(t) use_nl(t) */ v.*

Line 1042: FROM fnd_languages l, jtf_tasks_tl b

1038: FROM ( SELECT /*+ no_merge ordered parallel(b) */
1039: b.task_name, b.description, b.created_by, b.creation_date,
1040: b.last_updated_by, b.last_update_date, b.last_update_login,
1041: b.task_id, l.language_code, b.source_lang
1042: FROM fnd_languages l, jtf_tasks_tl b
1043: WHERE l.installed_flag IN ('I', 'B')
1044: AND b.language = USERENV ('LANG')
1045: ) v, jtf_tasks_tl t
1046: WHERE t.task_id(+) = v.task_id

Line 1045: ) v, jtf_tasks_tl t

1041: b.task_id, l.language_code, b.source_lang
1042: FROM fnd_languages l, jtf_tasks_tl b
1043: WHERE l.installed_flag IN ('I', 'B')
1044: AND b.language = USERENV ('LANG')
1045: ) v, jtf_tasks_tl t
1046: WHERE t.task_id(+) = v.task_id
1047: AND t.language(+) = v.language_code
1048: AND t.task_id IS NULL;
1049:

Line 1059: update jtf_tasks_tl set

1055: x_description in varchar2,
1056: x_owner in varchar2 )
1057: as
1058: begin
1059: update jtf_tasks_tl set
1060: task_name = nvl(x_task_name,task_name),
1061: description = nvl(x_description,description),
1062: LAST_UPDATE_DATE = sysdate,
1063: LAST_UPDATEd_by = decode(x_owner,'SEED',1,0),