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_ENTITY_TYPES_F_PKG dependencies on XLA_ENTITY_TYPES_TL

Line 126: INSERT INTO xla_entity_types_tl

122: ,x_last_updated_by
123: ,x_last_update_login)
124: ;
125:
126: INSERT INTO xla_entity_types_tl
127: (created_by
128: ,last_update_date
129: ,last_updated_by
130: ,last_update_login

Line 154: FROM xla_entity_types_tl t

150: FROM fnd_languages l
151: WHERE l.installed_flag IN ('I', 'B')
152: AND NOT EXISTS
153: (SELECT NULL
154: FROM xla_entity_types_tl t
155: WHERE t.application_id = x_application_id
156: AND t.entity_code = x_entity_code
157: AND t.language = l.language_code);
158:

Line 207: FROM xla_entity_types_tl

203: SELECT created_by
204: ,name
205: ,description
206: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
207: FROM xla_entity_types_tl
208: WHERE application_id = X_application_id
209: AND entity_code = X_entity_code
210: AND USERENV('LANG') IN (language ,source_lang)
211: FOR UPDATE OF application_id NOWAIT;

Line 314: UPDATE xla_entity_types_tl

310: IF (SQL%NOTFOUND) THEN
311: RAISE NO_DATA_FOUND;
312: END IF;
313:
314: UPDATE xla_entity_types_tl
315: SET
316: last_update_date = x_last_update_date
317: ,name = X_name
318: ,description = X_description

Line 360: DELETE FROM xla_entity_types_tl

356: p_module => l_log_module,
357: p_level => C_LEVEL_PROCEDURE);
358: END IF;
359:
360: DELETE FROM xla_entity_types_tl
361: WHERE application_id = x_application_id
362: AND entity_code = x_entity_code;
363:
364:

Line 406: DELETE FROM xla_entity_types_tl T

402: p_module => l_log_module,
403: p_level => C_LEVEL_PROCEDURE);
404: END IF;
405:
406: DELETE FROM xla_entity_types_tl T
407: WHERE NOT EXISTS
408: (SELECT NULL
409: FROM xla_entity_types_b b
410: WHERE b.application_id = t.application_id

Line 413: UPDATE xla_entity_types_tl t

409: FROM xla_entity_types_b b
410: WHERE b.application_id = t.application_id
411: AND b.entity_code = t.entity_code);
412:
413: UPDATE xla_entity_types_tl t
414: SET (name
415: ,description)
416: = (SELECT b.name
417: ,b.description

Line 418: FROM xla_entity_types_tl b

414: SET (name
415: ,description)
416: = (SELECT b.name
417: ,b.description
418: FROM xla_entity_types_tl b
419: WHERE b.application_id = t.application_id
420: AND b.entity_code = t.entity_code
421: AND b.language = t.source_lang)
422: WHERE (t.application_id

Line 428: FROM xla_entity_types_tl subb

424: ,t.language)
425: IN (SELECT subt.application_id
426: ,subt.entity_code
427: ,subt.language
428: FROM xla_entity_types_tl subb
429: ,xla_entity_types_tl subt
430: WHERE subb.application_id = subt.application_id
431: AND subb.entity_code = subt.entity_code
432: AND subb.language = subt.source_lang

Line 429: ,xla_entity_types_tl subt

425: IN (SELECT subt.application_id
426: ,subt.entity_code
427: ,subt.language
428: FROM xla_entity_types_tl subb
429: ,xla_entity_types_tl subt
430: WHERE subb.application_id = subt.application_id
431: AND subb.entity_code = subt.entity_code
432: AND subb.language = subt.source_lang
433: AND (SUBB.name <> SUBT.name

Line 442: INSERT INTO xla_entity_types_tl

438: AND subt.description IS NULL)
439: ))
440: ;
441:
442: INSERT INTO xla_entity_types_tl
443: (created_by
444: ,last_update_date
445: ,last_updated_by
446: ,last_update_login

Line 466: FROM xla_entity_types_tl b

462: ,b.description
463: ,b.creation_date
464: ,l.language_code
465: ,b.source_lang
466: FROM xla_entity_types_tl b
467: ,fnd_languages l
468: WHERE l.installed_flag IN ('I', 'B')
469: AND b.language = userenv('LANG')
470: AND NOT EXISTS

Line 472: FROM xla_entity_types_tl t

468: WHERE l.installed_flag IN ('I', 'B')
469: AND b.language = userenv('LANG')
470: AND NOT EXISTS
471: (SELECT NULL
472: FROM xla_entity_types_tl t
473: WHERE t.application_id = b.application_id
474: AND t.entity_code = b.entity_code
475: AND t.language = l.language_code);
476:

Line 644: FROM xla_entity_types_tl

640:
641: BEGIN
642: SELECT last_updated_by, last_update_date
643: INTO db_luby, db_ludate
644: FROM xla_entity_types_tl
645: WHERE application_id = l_application_id
646: AND entity_code = p_entity_code
647: AND language = userenv('LANG');
648:

Line 651: UPDATE xla_entity_types_tl

647: AND language = userenv('LANG');
648:
649: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
650: db_ludate, p_custom_mode)) then
651: UPDATE xla_entity_types_tl
652: SET name = p_name
653: ,description = p_description
654: ,last_update_date = f_ludate
655: ,last_updated_by = f_luby