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 341: INSERT INTO jtf_tasks_tl

337: END IF;
338:
339: CLOSE c;
340:
341: INSERT INTO jtf_tasks_tl
342: (task_name,
343: description,
344: created_by,
345: creation_date,

Line 366: FROM jtf_tasks_tl t

362: USERENV ('LANG')
363: FROM fnd_languages l
364: WHERE l.installed_flag IN ('I', 'B')
365: AND NOT EXISTS (SELECT NULL
366: FROM jtf_tasks_tl t
367: WHERE t.task_id = x_task_id
368: AND t.language = l.language_code);
369: OPEN c;
370: FETCH c INTO x_rowid;

Line 470: FROM jtf_tasks_tl

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

Line 941: UPDATE jtf_tasks_tl

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

Line 979: FROM jtf_tasks_tl t

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

Line 983: UPDATE jtf_tasks_tl t

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

Line 985: FROM jtf_tasks_tl b

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

Line 989: FROM jtf_tasks_tl subb, jtf_tasks_tl subt

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

Line 999: INSERT INTO jtf_tasks_tl

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

Line 1021: FROM jtf_tasks_tl b, fnd_languages l

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

Line 1025: FROM jtf_tasks_tl t

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

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

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

Line 1041: FROM fnd_languages l, jtf_tasks_tl b

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

Line 1044: ) v, jtf_tasks_tl t

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

Line 1058: update jtf_tasks_tl set

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