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_MAPPING_SETS_F_PKG dependencies on XLA_MAPPING_SETS_TL

Line 144: INSERT INTO xla_mapping_sets_tl

140: ,x_last_updated_by
141: ,x_last_update_login)
142: ;
143:
144: INSERT INTO xla_mapping_sets_tl
145: (amb_context_code
146: ,mapping_set_code
147: ,name
148: ,description

Line 172: FROM xla_mapping_sets_tl t

168: FROM fnd_languages l
169: WHERE l.installed_flag IN ('I', 'B')
170: AND NOT EXISTS
171: (SELECT NULL
172: FROM xla_mapping_sets_tl t
173: WHERE t.mapping_set_code = x_mapping_set_code
174: AND t.amb_context_code = x_amb_context_code
175: AND t.language = l.language_code);
176:

Line 237: FROM xla_mapping_sets_tl

233: SELECT amb_context_code
234: ,name
235: ,description
236: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
237: FROM xla_mapping_sets_tl
238: WHERE mapping_set_code = X_mapping_set_code
239: AND amb_context_code = X_amb_context_code
240: AND USERENV('LANG') IN (language ,source_lang)
241: FOR UPDATE OF mapping_set_code NOWAIT;

Line 374: UPDATE xla_mapping_sets_tl

370: IF (SQL%NOTFOUND) THEN
371: RAISE NO_DATA_FOUND;
372: END IF;
373:
374: UPDATE xla_mapping_sets_tl
375: SET
376: last_update_date = x_last_update_date
377: ,name = X_name
378: ,description = X_description

Line 421: DELETE FROM xla_mapping_sets_tl

417: p_module => l_log_module,
418: p_level => C_LEVEL_PROCEDURE);
419: END IF;
420:
421: DELETE FROM xla_mapping_sets_tl
422: WHERE mapping_set_code = x_mapping_set_code
423: AND amb_context_code = x_amb_context_code;
424:
425:

Line 470: DELETE FROM xla_mapping_sets_tl T

466: p_level => C_LEVEL_PROCEDURE);
467: END IF;
468:
469:
470: DELETE FROM xla_mapping_sets_tl T
471: WHERE NOT EXISTS
472: (SELECT NULL
473: FROM xla_mapping_sets_b b
474: WHERE b.mapping_set_code = t.mapping_set_code

Line 477: UPDATE xla_mapping_sets_tl t

473: FROM xla_mapping_sets_b b
474: WHERE b.mapping_set_code = t.mapping_set_code
475: AND b.amb_context_code = t.amb_context_code);
476:
477: UPDATE xla_mapping_sets_tl t
478: SET (name
479: ,description)
480: = (SELECT b.name
481: ,b.description

Line 482: FROM xla_mapping_sets_tl b

478: SET (name
479: ,description)
480: = (SELECT b.name
481: ,b.description
482: FROM xla_mapping_sets_tl b
483: WHERE b.mapping_set_code = t.mapping_set_code
484: AND b.amb_context_code = t.amb_context_code
485: AND b.language = t.source_lang)
486: WHERE (t.mapping_set_code

Line 492: FROM xla_mapping_sets_tl subb

488: ,t.language)
489: IN (SELECT subt.mapping_set_code
490: ,subt.amb_context_code
491: ,subt.language
492: FROM xla_mapping_sets_tl subb
493: ,xla_mapping_sets_tl subt
494: WHERE subb.mapping_set_code = subt.mapping_set_code
495: AND subb.amb_context_code = subt.amb_context_code
496: AND subb.language = subt.source_lang

Line 493: ,xla_mapping_sets_tl subt

489: IN (SELECT subt.mapping_set_code
490: ,subt.amb_context_code
491: ,subt.language
492: FROM xla_mapping_sets_tl subb
493: ,xla_mapping_sets_tl subt
494: WHERE subb.mapping_set_code = subt.mapping_set_code
495: AND subb.amb_context_code = subt.amb_context_code
496: AND subb.language = subt.source_lang
497: AND (SUBB.name <> SUBT.name

Line 506: INSERT INTO xla_mapping_sets_tl

502: AND subt.description IS NULL)
503: ))
504: ;
505:
506: INSERT INTO xla_mapping_sets_tl
507: (amb_context_code
508: ,mapping_set_code
509: ,name
510: ,description

Line 530: FROM xla_mapping_sets_tl b

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

Line 536: FROM xla_mapping_sets_tl t

532: WHERE l.installed_flag IN ('I', 'B')
533: AND b.language = userenv('LANG')
534: AND NOT EXISTS
535: (SELECT NULL
536: FROM xla_mapping_sets_tl t
537: WHERE t.mapping_set_code = b.mapping_set_code
538: AND t.amb_context_code = b.amb_context_code
539: AND t.language = l.language_code);
540:

Line 592: FROM xla_mapping_sets_tl

588:
589: BEGIN
590: SELECT last_updated_by, last_update_date
591: INTO db_luby, db_ludate
592: FROM xla_mapping_sets_tl
593: WHERE amb_context_code = p_amb_context_code
594: AND mapping_set_code = p_mapping_set_code
595: AND language = userenv('LANG');
596:

Line 599: UPDATE xla_mapping_sets_tl

595: AND language = userenv('LANG');
596:
597: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
598: db_ludate, p_custom_mode)) then
599: UPDATE xla_mapping_sets_tl
600: SET name = p_name
601: ,description = p_description
602: ,last_update_date = f_ludate
603: ,last_updated_by = f_luby