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_TYPES_F_PKG dependencies on XLA_EVENT_TYPES_TL

Line 137: INSERT INTO xla_event_types_tl

133: ,x_last_updated_by
134: ,x_last_update_login)
135: ;
136:
137: INSERT INTO xla_event_types_tl
138: (application_id
139: ,entity_code
140: ,event_class_code
141: ,event_type_code

Line 169: FROM xla_event_types_tl t

165: FROM fnd_languages l
166: WHERE l.installed_flag IN ('I', 'B')
167: AND NOT EXISTS
168: (SELECT NULL
169: FROM xla_event_types_tl t
170: WHERE t.application_id = x_application_id
171: AND t.entity_code = x_entity_code
172: AND t.event_class_code = x_event_class_code
173: AND t.event_type_code = x_event_type_code

Line 230: FROM xla_event_types_tl

226: SELECT application_id
227: ,name
228: ,description
229: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
230: FROM xla_event_types_tl
231: WHERE application_id = X_application_id
232: AND entity_code = X_entity_code
233: AND event_class_code = X_event_class_code
234: AND event_type_code = X_event_type_code

Line 347: UPDATE xla_event_types_tl

343: IF (SQL%NOTFOUND) THEN
344: RAISE NO_DATA_FOUND;
345: END IF;
346:
347: UPDATE xla_event_types_tl
348: SET
349: last_update_date = x_last_update_date
350: ,name = X_name
351: ,description = X_description

Line 399: DELETE FROM xla_event_types_tl

395: p_module => l_log_module,
396: p_level => C_LEVEL_PROCEDURE);
397: END IF;
398:
399: DELETE FROM xla_event_types_tl
400: WHERE application_id = x_application_id
401: AND entity_code = x_entity_code
402: AND event_class_code = x_event_class_code
403: AND event_type_code = x_event_type_code;

Line 453: DELETE FROM xla_event_types_tl T

449: p_level => C_LEVEL_PROCEDURE);
450: END IF;
451:
452:
453: DELETE FROM xla_event_types_tl T
454: WHERE NOT EXISTS
455: (SELECT NULL
456: FROM xla_event_types_b b
457: WHERE b.application_id = t.application_id

Line 462: UPDATE xla_event_types_tl t

458: AND b.entity_code = t.entity_code
459: AND b.event_class_code = t.event_class_code
460: AND b.event_type_code = t.event_type_code);
461:
462: UPDATE xla_event_types_tl t
463: SET (name
464: ,description)
465: = (SELECT b.name
466: ,b.description

Line 467: FROM xla_event_types_tl b

463: SET (name
464: ,description)
465: = (SELECT b.name
466: ,b.description
467: FROM xla_event_types_tl b
468: WHERE b.application_id = t.application_id
469: AND b.entity_code = t.entity_code
470: AND b.event_class_code = t.event_class_code
471: AND b.event_type_code = t.event_type_code

Line 483: FROM xla_event_types_tl subb

479: ,subt.entity_code
480: ,subt.event_class_code
481: ,subt.event_type_code
482: ,subt.language
483: FROM xla_event_types_tl subb
484: ,xla_event_types_tl subt
485: WHERE subb.application_id = subt.application_id
486: AND subb.entity_code = subt.entity_code
487: AND subb.event_class_code = subt.event_class_code

Line 484: ,xla_event_types_tl subt

480: ,subt.event_class_code
481: ,subt.event_type_code
482: ,subt.language
483: FROM xla_event_types_tl subb
484: ,xla_event_types_tl subt
485: WHERE subb.application_id = subt.application_id
486: AND subb.entity_code = subt.entity_code
487: AND subb.event_class_code = subt.event_class_code
488: AND subb.event_type_code = subt.event_type_code

Line 499: INSERT INTO xla_event_types_tl

495: AND subt.description IS NULL)
496: ))
497: ;
498:
499: INSERT INTO xla_event_types_tl
500: (application_id
501: ,entity_code
502: ,event_class_code
503: ,event_type_code

Line 527: FROM xla_event_types_tl b

523: ,b.last_updated_by
524: ,b.last_update_login
525: ,l.language_code
526: ,b.source_lang
527: FROM xla_event_types_tl b
528: ,fnd_languages l
529: WHERE l.installed_flag IN ('I', 'B')
530: AND b.language = userenv('LANG')
531: AND NOT EXISTS

Line 533: FROM xla_event_types_tl t

529: WHERE l.installed_flag IN ('I', 'B')
530: AND b.language = userenv('LANG')
531: AND NOT EXISTS
532: (SELECT NULL
533: FROM xla_event_types_tl t
534: WHERE t.application_id = b.application_id
535: AND t.entity_code = b.entity_code
536: AND t.event_class_code = b.event_class_code
537: AND t.event_type_code = b.event_type_code

Line 719: FROM xla_event_types_tl

715:
716: BEGIN
717: SELECT last_updated_by, last_update_date
718: INTO db_luby, db_ludate
719: FROM xla_event_types_tl
720: WHERE application_id = l_application_id
721: AND entity_code = p_entity_code
722: AND event_class_code = p_event_class_code
723: AND event_type_code = p_event_type_code

Line 728: UPDATE xla_event_types_tl

724: AND language = userenv('LANG');
725:
726: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
727: db_ludate, p_custom_mode)) then
728: UPDATE xla_event_types_tl
729: SET name = p_name
730: ,description = p_description
731: ,last_update_date = f_ludate
732: ,last_updated_by = f_luby