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_EVENT_CLASSES_F_PKG dependencies on XLA_EVENT_CLASSES_TL

Line 127: INSERT INTO xla_event_classes_tl

123: ,x_last_updated_by
124: ,x_last_update_login)
125: ;
126:
127: INSERT INTO xla_event_classes_tl
128: (creation_date
129: ,entity_code
130: ,event_class_code
131: ,name

Line 157: FROM xla_event_classes_tl t

153: FROM fnd_languages l
154: WHERE l.installed_flag IN ('I', 'B')
155: AND NOT EXISTS
156: (SELECT NULL
157: FROM xla_event_classes_tl t
158: WHERE t.application_id = x_application_id
159: AND t.entity_code = x_entity_code
160: AND t.event_class_code = x_event_class_code
161: AND t.language = l.language_code);

Line 211: FROM xla_event_classes_tl

207: SELECT source_lang
208: ,name
209: ,description
210: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
211: FROM xla_event_classes_tl
212: WHERE application_id = X_application_id
213: AND entity_code = X_entity_code
214: AND event_class_code = X_event_class_code
215: AND USERENV('LANG') IN (language ,source_lang)

Line 319: UPDATE xla_event_classes_tl

315: IF (SQL%NOTFOUND) THEN
316: RAISE NO_DATA_FOUND;
317: END IF;
318:
319: UPDATE xla_event_classes_tl
320: SET
321: last_update_date = x_last_update_date
322: ,name = X_name
323: ,description = X_description

Line 369: DELETE FROM xla_event_classes_tl

365: p_module => l_log_module,
366: p_level => C_LEVEL_PROCEDURE);
367: END IF;
368:
369: DELETE FROM xla_event_classes_tl
370: WHERE application_id = x_application_id
371: AND entity_code = x_entity_code
372: AND event_class_code = x_event_class_code;
373:

Line 417: DELETE FROM xla_event_classes_tl T

413: p_module => l_log_module,
414: p_level => C_LEVEL_PROCEDURE);
415: END IF;
416:
417: DELETE FROM xla_event_classes_tl T
418: WHERE NOT EXISTS
419: (SELECT NULL
420: FROM xla_event_classes_b b
421: WHERE b.application_id = t.application_id

Line 425: UPDATE xla_event_classes_tl t

421: WHERE b.application_id = t.application_id
422: AND b.entity_code = t.entity_code
423: AND b.event_class_code = t.event_class_code);
424:
425: UPDATE xla_event_classes_tl t
426: SET (name
427: ,description)
428: = (SELECT b.name
429: ,b.description

Line 430: FROM xla_event_classes_tl b

426: SET (name
427: ,description)
428: = (SELECT b.name
429: ,b.description
430: FROM xla_event_classes_tl b
431: WHERE b.application_id = t.application_id
432: AND b.entity_code = t.entity_code
433: AND b.event_class_code = t.event_class_code
434: AND b.language = t.source_lang)

Line 443: FROM xla_event_classes_tl subb

439: IN (SELECT subt.application_id
440: ,subt.entity_code
441: ,subt.event_class_code
442: ,subt.language
443: FROM xla_event_classes_tl subb
444: ,xla_event_classes_tl subt
445: WHERE subb.application_id = subt.application_id
446: AND subb.entity_code = subt.entity_code
447: AND subb.event_class_code = subt.event_class_code

Line 444: ,xla_event_classes_tl subt

440: ,subt.entity_code
441: ,subt.event_class_code
442: ,subt.language
443: FROM xla_event_classes_tl subb
444: ,xla_event_classes_tl subt
445: WHERE subb.application_id = subt.application_id
446: AND subb.entity_code = subt.entity_code
447: AND subb.event_class_code = subt.event_class_code
448: AND subb.language = subt.source_lang

Line 458: INSERT INTO xla_event_classes_tl

454: AND subt.description IS NULL)
455: ))
456: ;
457:
458: INSERT INTO xla_event_classes_tl
459: (creation_date
460: ,entity_code
461: ,event_class_code
462: ,name

Line 484: FROM xla_event_classes_tl b

480: ,b.last_update_login
481: ,b.created_by
482: ,l.language_code
483: ,b.source_lang
484: FROM xla_event_classes_tl b
485: ,fnd_languages l
486: WHERE l.installed_flag IN ('I', 'B')
487: AND b.language = userenv('LANG')
488: AND NOT EXISTS

Line 490: FROM xla_event_classes_tl t

486: WHERE l.installed_flag IN ('I', 'B')
487: AND b.language = userenv('LANG')
488: AND NOT EXISTS
489: (SELECT NULL
490: FROM xla_event_classes_tl t
491: WHERE t.application_id = b.application_id
492: AND t.entity_code = b.entity_code
493: AND t.event_class_code = b.event_class_code
494: AND t.language = l.language_code);

Line 664: FROM xla_event_classes_tl

660:
661: BEGIN
662: SELECT last_updated_by, last_update_date
663: INTO db_luby, db_ludate
664: FROM xla_event_classes_tl
665: WHERE application_id = l_application_id
666: AND entity_code = p_entity_code
667: AND event_class_code = p_event_class_code
668: AND language = userenv('LANG');

Line 672: UPDATE xla_event_classes_tl

668: AND language = userenv('LANG');
669:
670: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
671: db_ludate, p_custom_mode)) then
672: UPDATE xla_event_classes_tl
673: SET name = p_name
674: ,description = p_description
675: ,last_update_date = f_ludate
676: ,last_updated_by = f_luby