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_TASK_TYPES_PKG dependencies on JTF_TASK_TYPES_TL

Line 126: INSERT INTO jtf_task_types_tl

122: x_workflow_type,
123: x_spares_allowed_flag,
124: x_set_actual_dates_flag
125: );
126: INSERT INTO jtf_task_types_tl
127: (task_type_id,
128: name,
129: description,
130: created_by,

Line 151: FROM jtf_task_types_tl t

147: USERENV ('LANG')
148: FROM fnd_languages l
149: WHERE l.installed_flag IN ('I', 'B')
150: AND NOT EXISTS (SELECT NULL
151: FROM jtf_task_types_tl t
152: WHERE t.task_type_id = x_task_type_id
153: AND t.language = l.language_code);
154: OPEN c;
155: FETCH c INTO x_rowid;

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

282: RAISE NO_DATA_FOUND;
283: END IF;
284:
285: -- Added Index Hint on 30/05/2006 for bug# 5213367
286: UPDATE /*+ INDEX(a JTF_TASK_TYPES_TL_U1) */ jtf_task_types_tl a
287: SET a.name = x_name,
288: a.description = x_description,
289: a.last_update_date = x_last_update_date,
290: a.last_updated_by = x_last_updated_by,

Line 306: FROM jtf_task_types_tl

302: PROCEDURE delete_row (x_task_type_id IN NUMBER)
303: IS
304: BEGIN
305: DELETE
306: FROM jtf_task_types_tl
307: WHERE task_type_id = x_task_type_id;
308:
309: IF (SQL%NOTFOUND)
310: THEN

Line 333: FROM jtf_task_types_tl t

329: /* The following delete and update statements are commented out */
330: /* as a quick workaround to fix the time-consuming table handler issue */
331: /*
332: DELETE
333: FROM jtf_task_types_tl t
334: WHERE NOT EXISTS (SELECT NULL
335: FROM jtf_task_types_b b
336: WHERE b.task_type_id = t.task_type_id);
337: UPDATE jtf_task_types_tl t

Line 337: UPDATE jtf_task_types_tl t

333: FROM jtf_task_types_tl t
334: WHERE NOT EXISTS (SELECT NULL
335: FROM jtf_task_types_b b
336: WHERE b.task_type_id = t.task_type_id);
337: UPDATE jtf_task_types_tl t
338: SET (name, description) = ( SELECT b.name, b.description
339: FROM jtf_task_types_tl b
340: WHERE b.task_type_id = t.task_type_id
341: AND b.language = t.source_lang)

Line 339: FROM jtf_task_types_tl b

335: FROM jtf_task_types_b b
336: WHERE b.task_type_id = t.task_type_id);
337: UPDATE jtf_task_types_tl t
338: SET (name, description) = ( SELECT b.name, b.description
339: FROM jtf_task_types_tl b
340: WHERE b.task_type_id = t.task_type_id
341: AND b.language = t.source_lang)
342: WHERE (t.task_type_id, t.language) IN
343: (SELECT subt.task_type_id, subt.language

Line 344: FROM jtf_task_types_tl subb, jtf_task_types_tl subt

340: WHERE b.task_type_id = t.task_type_id
341: AND b.language = t.source_lang)
342: WHERE (t.task_type_id, t.language) IN
343: (SELECT subt.task_type_id, subt.language
344: FROM jtf_task_types_tl subb, jtf_task_types_tl subt
345: WHERE subb.task_type_id = subt.task_type_id
346: AND subb.language = subt.source_lang
347: AND ( subb.name <> subt.name
348: OR subb.description <> subt.description

Line 355: INSERT INTO jtf_task_types_tl

351: OR ( subb.description IS NOT NULL
352: AND subt.description IS NULL)));
353: */
354:
355: INSERT INTO jtf_task_types_tl
356: (task_type_id,
357: name,
358: description,
359: created_by,

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

363: last_update_login,
364: language,
365: source_lang
366: )
367: SELECT /*+ INDEX(b JTF_TASK_TYPES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
368: b.task_type_id,
369: b.name,
370: b.description,
371: b.created_by,

Line 378: FROM jtf_task_types_tl b, fnd_languages l

374: b.last_update_date,
375: b.last_update_login,
376: l.language_code,
377: b.source_lang
378: FROM jtf_task_types_tl b, fnd_languages l
379: WHERE l.installed_flag IN ('I', 'B')
380: AND b.language = USERENV ('LANG')
381: AND NOT EXISTS (SELECT NULL
382: FROM jtf_task_types_tl t

Line 382: FROM jtf_task_types_tl t

378: FROM jtf_task_types_tl b, fnd_languages l
379: WHERE l.installed_flag IN ('I', 'B')
380: AND b.language = USERENV ('LANG')
381: AND NOT EXISTS (SELECT NULL
382: FROM jtf_task_types_tl t
383: WHERE t.task_type_id = b.task_type_id
384: AND t.language = l.language_code);
385: END add_language;
386:

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

398: l_user_id := 1;
399: END IF;
400:
401: -- Added Index Hint on 30/05/2006 for bug# 5213367
402: UPDATE /*+ INDEX(a JTF_TASK_TYPES_TL_U1) */ jtf_task_types_tl a
403: SET a.name = NVL (x_name, a.name),
404: a.description = NVL (x_description, a.description),
405: a.last_update_date = SYSDATE,
406: a.last_update_login = 0,

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

492: spares_allowed_flag = x_spares_allowed_flag
493: WHERE task_type_id = l_task_type_id;
494:
495: -- Added Index Hint on 30/05/2006 for bug# 5213367
496: UPDATE /*+ INDEX(a JTF_TASK_TYPES_TL_U1) */ jtf_task_types_tl a
497: SET a.name = x_name,
498: a.description = x_description,
499: a.last_update_date = sysdate,
500: a.last_updated_by = l_user_id,