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_MAPPINGS_F_PKG dependencies on XLA_EVENT_MAPPINGS_TL

Line 129: INSERT INTO xla_event_mappings_tl

125: ,x_last_updated_by
126: ,x_last_update_login)
127: ;
128:
129: INSERT INTO xla_event_mappings_tl
130: (event_mapping_id
131: ,column_title
132: ,creation_date
133: ,created_by

Line 153: FROM xla_event_mappings_tl t

149: FROM fnd_languages l
150: WHERE l.installed_flag IN ('I', 'B')
151: AND NOT EXISTS
152: (SELECT NULL
153: FROM xla_event_mappings_tl t
154: WHERE t.event_mapping_id = x_event_mapping_id
155: AND t.language = l.language_code);
156:
157: OPEN c;

Line 207: FROM xla_event_mappings_tl

203: CURSOR c1 IS
204: SELECT event_mapping_id
205: ,column_title
206: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
207: FROM xla_event_mappings_tl
208: WHERE event_mapping_id = X_event_mapping_id
209: AND USERENV('LANG') IN (language ,source_lang)
210: FOR UPDATE OF event_mapping_id NOWAIT;
211:

Line 317: UPDATE xla_event_mappings_tl

313: IF (SQL%NOTFOUND) THEN
314: RAISE NO_DATA_FOUND;
315: END IF;
316:
317: UPDATE xla_event_mappings_tl
318: SET
319: last_update_date = x_last_update_date
320: ,column_title = X_column_title
321: ,last_updated_by = x_last_updated_by

Line 362: DELETE FROM xla_event_mappings_tl

358: p_module => l_log_module,
359: p_level => C_LEVEL_PROCEDURE);
360: END IF;
361:
362: DELETE FROM xla_event_mappings_tl
363: WHERE event_mapping_id = x_event_mapping_id;
364:
365:
366: IF (SQL%NOTFOUND) THEN

Line 409: DELETE FROM xla_event_mappings_tl T

405: p_module => l_log_module,
406: p_level => C_LEVEL_PROCEDURE);
407: END IF;
408:
409: DELETE FROM xla_event_mappings_tl T
410: WHERE NOT EXISTS
411: (SELECT NULL
412: FROM xla_event_mappings_b b
413: WHERE b.event_mapping_id = t.event_mapping_id);

Line 415: UPDATE xla_event_mappings_tl t

411: (SELECT NULL
412: FROM xla_event_mappings_b b
413: WHERE b.event_mapping_id = t.event_mapping_id);
414:
415: UPDATE xla_event_mappings_tl t
416: SET (column_title)
417: = (SELECT b.column_title
418: FROM xla_event_mappings_tl b
419: WHERE b.event_mapping_id = t.event_mapping_id

Line 418: FROM xla_event_mappings_tl b

414:
415: UPDATE xla_event_mappings_tl t
416: SET (column_title)
417: = (SELECT b.column_title
418: FROM xla_event_mappings_tl b
419: WHERE b.event_mapping_id = t.event_mapping_id
420: AND b.language = t.source_lang)
421: WHERE (t.event_mapping_id
422: ,t.language)

Line 425: FROM xla_event_mappings_tl subb

421: WHERE (t.event_mapping_id
422: ,t.language)
423: IN (SELECT subt.event_mapping_id
424: ,subt.language
425: FROM xla_event_mappings_tl subb
426: ,xla_event_mappings_tl subt
427: WHERE subb.event_mapping_id = subt.event_mapping_id
428: AND subb.language = subt.source_lang
429: AND (SUBB.column_title <> SUBT.column_title

Line 426: ,xla_event_mappings_tl subt

422: ,t.language)
423: IN (SELECT subt.event_mapping_id
424: ,subt.language
425: FROM xla_event_mappings_tl subb
426: ,xla_event_mappings_tl subt
427: WHERE subb.event_mapping_id = subt.event_mapping_id
428: AND subb.language = subt.source_lang
429: AND (SUBB.column_title <> SUBT.column_title
430: ))

Line 433: INSERT INTO xla_event_mappings_tl

429: AND (SUBB.column_title <> SUBT.column_title
430: ))
431: ;
432:
433: INSERT INTO xla_event_mappings_tl
434: (event_mapping_id
435: ,column_title
436: ,creation_date
437: ,created_by

Line 453: FROM xla_event_mappings_tl b

449: ,b.last_updated_by
450: ,b.last_update_login
451: ,l.language_code
452: ,b.source_lang
453: FROM xla_event_mappings_tl b
454: ,fnd_languages l
455: WHERE l.installed_flag IN ('I', 'B')
456: AND b.language = userenv('LANG')
457: AND NOT EXISTS

Line 459: FROM xla_event_mappings_tl t

455: WHERE l.installed_flag IN ('I', 'B')
456: AND b.language = userenv('LANG')
457: AND NOT EXISTS
458: (SELECT NULL
459: FROM xla_event_mappings_tl t
460: WHERE t.event_mapping_id = b.event_mapping_id
461: AND t.language = l.language_code);
462:
463: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 571: DELETE FROM xla_event_mappings_tl

567: ,x_last_updated_by => f_luby
568: ,x_last_update_login => 0);
569:
570: WHEN TOO_MANY_ROWS THEN
571: DELETE FROM xla_event_mappings_tl
572: WHERE event_mapping_id IN
573: (SELECT event_mapping_id
574: FROM xla_event_mappings_b
575: WHERE application_id = l_application_id

Line 689: UPDATE xla_event_mappings_tl

685: column_name = p_column_name);
686:
687: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
688: db_ludate, p_custom_mode)) then
689: UPDATE xla_event_mappings_tl
690: SET column_title = p_column_title
691: ,last_update_date = f_ludate
692: ,last_updated_by = f_luby
693: ,last_update_login = 0