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_CLASS_GRPS_F_PKG dependencies on XLA_EVENT_CLASS_GRPS_TL

Line 123: INSERT INTO xla_event_class_grps_tl

119: ,x_last_updated_by
120: ,x_last_update_login)
121: ;
122:
123: INSERT INTO xla_event_class_grps_tl
124: (application_id
125: ,event_class_group_code
126: ,name
127: ,description

Line 151: FROM xla_event_class_grps_tl t

147: FROM fnd_languages l
148: WHERE l.installed_flag IN ('I', 'B')
149: AND NOT EXISTS
150: (SELECT NULL
151: FROM xla_event_class_grps_tl t
152: WHERE t.application_id = x_application_id
153: AND t.event_class_group_code = x_event_class_group_code
154: AND t.language = l.language_code);
155:

Line 202: FROM xla_event_class_grps_tl

198: SELECT application_id
199: ,name
200: ,description
201: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
202: FROM xla_event_class_grps_tl
203: WHERE application_id = X_application_id
204: AND event_class_group_code = X_event_class_group_code
205: AND USERENV('LANG') IN (language ,source_lang)
206: FOR UPDATE OF application_id NOWAIT;

Line 309: UPDATE xla_event_class_grps_tl

305: IF (SQL%NOTFOUND) THEN
306: RAISE NO_DATA_FOUND;
307: END IF;
308:
309: UPDATE xla_event_class_grps_tl
310: SET
311: last_update_date = x_last_update_date
312: ,name = X_name
313: ,description = X_description

Line 357: DELETE FROM xla_event_class_grps_tl

353: p_module => l_log_module,
354: p_level => C_LEVEL_PROCEDURE);
355: END IF;
356:
357: DELETE FROM xla_event_class_grps_tl
358: WHERE application_id = x_application_id
359: AND event_class_group_code = x_event_class_group_code;
360:
361:

Line 406: DELETE FROM xla_event_class_grps_tl T

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

Line 413: UPDATE xla_event_class_grps_tl t

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

Line 418: FROM xla_event_class_grps_tl b

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

Line 428: FROM xla_event_class_grps_tl subb

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

Line 429: ,xla_event_class_grps_tl subt

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

Line 446: INSERT INTO xla_event_class_grps_tl

442: AND subt.description IS NULL)
443: ))
444: ;
445:
446: INSERT INTO xla_event_class_grps_tl
447: (application_id
448: ,event_class_group_code
449: ,name
450: ,description

Line 470: FROM xla_event_class_grps_tl b

466: ,b.last_updated_by
467: ,b.last_update_login
468: ,l.language_code
469: ,b.source_lang
470: FROM xla_event_class_grps_tl b
471: ,fnd_languages l
472: WHERE l.installed_flag IN ('I', 'B')
473: AND b.language = userenv('LANG')
474: AND NOT EXISTS

Line 476: FROM xla_event_class_grps_tl t

472: WHERE l.installed_flag IN ('I', 'B')
473: AND b.language = userenv('LANG')
474: AND NOT EXISTS
475: (SELECT NULL
476: FROM xla_event_class_grps_tl t
477: WHERE t.application_id = b.application_id
478: AND t.event_class_group_code = b.event_class_group_code
479: AND t.language = l.language_code);
480:

Line 645: FROM xla_event_class_grps_tl

641:
642: BEGIN
643: SELECT last_updated_by, last_update_date
644: INTO db_luby, db_ludate
645: FROM xla_event_class_grps_tl
646: WHERE application_id = l_application_id
647: AND event_class_group_code = p_event_class_group_code
648: AND language = userenv('LANG');
649:

Line 652: UPDATE xla_event_class_grps_tl

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