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.XLA_DESCRIPTIONS_F_PKG dependencies on XLA_DESCRIPTIONS_TL

Line 129: INSERT INTO xla_descriptions_tl

125: ,x_last_updated_by
126: ,x_last_update_login)
127: ;
128:
129: INSERT INTO xla_descriptions_tl
130: (amb_context_code
131: ,application_id
132: ,description_type_code
133: ,description_code

Line 161: FROM xla_descriptions_tl t

157: FROM fnd_languages l
158: WHERE l.installed_flag IN ('I', 'B')
159: AND NOT EXISTS
160: (SELECT NULL
161: FROM xla_descriptions_tl t
162: WHERE t.application_id = x_application_id
163: AND t.amb_context_code = x_amb_context_code
164: AND t.description_type_code = x_description_type_code
165: AND t.description_code = x_description_code

Line 220: FROM xla_descriptions_tl

216: SELECT amb_context_code
217: ,name
218: ,description
219: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
220: FROM xla_descriptions_tl
221: WHERE application_id = X_application_id
222: AND amb_context_code = X_amb_context_code
223: AND description_type_code = X_description_type_code
224: AND description_code = X_description_code

Line 330: UPDATE xla_descriptions_tl

326: IF (SQL%NOTFOUND) THEN
327: RAISE NO_DATA_FOUND;
328: END IF;
329:
330: UPDATE xla_descriptions_tl
331: SET
332: last_update_date = x_last_update_date
333: ,name = X_name
334: ,description = X_description

Line 380: DELETE FROM xla_descriptions_tl

376: p_module => l_log_module,
377: p_level => C_LEVEL_PROCEDURE);
378: END IF;
379:
380: DELETE FROM xla_descriptions_tl
381: WHERE application_id = x_application_id
382: AND amb_context_code = x_amb_context_code
383: AND description_type_code = x_description_type_code
384: AND description_code = x_description_code;

Line 429: DELETE FROM xla_descriptions_tl T

425: p_module => l_log_module,
426: p_level => C_LEVEL_PROCEDURE);
427: END IF;
428:
429: DELETE FROM xla_descriptions_tl T
430: WHERE NOT EXISTS
431: (SELECT NULL
432: FROM xla_descriptions_b b
433: WHERE b.application_id = t.application_id

Line 438: UPDATE xla_descriptions_tl t

434: AND b.amb_context_code = t.amb_context_code
435: AND b.description_type_code = t.description_type_code
436: AND b.description_code = t.description_code);
437:
438: UPDATE xla_descriptions_tl t
439: SET (name
440: ,description)
441: = (SELECT b.name
442: ,b.description

Line 443: FROM xla_descriptions_tl b

439: SET (name
440: ,description)
441: = (SELECT b.name
442: ,b.description
443: FROM xla_descriptions_tl b
444: WHERE b.application_id = t.application_id
445: AND b.amb_context_code = t.amb_context_code
446: AND b.description_type_code = t.description_type_code
447: AND b.description_code = t.description_code

Line 459: FROM xla_descriptions_tl subb

455: ,subt.amb_context_code
456: ,subt.description_type_code
457: ,subt.description_code
458: ,subt.language
459: FROM xla_descriptions_tl subb
460: ,xla_descriptions_tl subt
461: WHERE subb.application_id = subt.application_id
462: AND subb.amb_context_code = subt.amb_context_code
463: AND subb.description_type_code = subt.description_type_code

Line 460: ,xla_descriptions_tl subt

456: ,subt.description_type_code
457: ,subt.description_code
458: ,subt.language
459: FROM xla_descriptions_tl subb
460: ,xla_descriptions_tl subt
461: WHERE subb.application_id = subt.application_id
462: AND subb.amb_context_code = subt.amb_context_code
463: AND subb.description_type_code = subt.description_type_code
464: AND subb.description_code = subt.description_code

Line 475: INSERT INTO xla_descriptions_tl

471: AND subt.description IS NULL)
472: ))
473: ;
474:
475: INSERT INTO xla_descriptions_tl
476: (amb_context_code
477: ,application_id
478: ,description_type_code
479: ,description_code

Line 503: FROM xla_descriptions_tl b

499: ,b.last_updated_by
500: ,b.last_update_login
501: ,l.language_code
502: ,b.source_lang
503: FROM xla_descriptions_tl b
504: ,fnd_languages l
505: WHERE l.installed_flag IN ('I', 'B')
506: AND b.language = userenv('LANG')
507: AND NOT EXISTS

Line 509: FROM xla_descriptions_tl t

505: WHERE l.installed_flag IN ('I', 'B')
506: AND b.language = userenv('LANG')
507: AND NOT EXISTS
508: (SELECT NULL
509: FROM xla_descriptions_tl t
510: WHERE t.application_id = b.application_id
511: AND t.amb_context_code = b.amb_context_code
512: AND t.description_type_code = b.description_type_code
513: AND t.description_code = b.description_code

Line 578: FROM xla_descriptions_tl

574:
575: BEGIN
576: SELECT last_updated_by, last_update_date
577: INTO db_luby, db_ludate
578: FROM xla_descriptions_tl
579: WHERE application_id = l_application_id
580: AND amb_context_code = p_amb_context_code
581: AND description_type_code = p_description_type_code
582: AND description_code = p_description_code

Line 587: UPDATE xla_descriptions_tl

583: AND language = userenv('LANG');
584:
585: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
586: db_ludate, p_custom_mode)) then
587: UPDATE xla_descriptions_tl
588: SET name = p_name
589: ,description = p_description
590: ,last_update_date = f_ludate
591: ,last_updated_by = f_luby