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_ANALYTICAL_HDRS_F_PKG dependencies on XLA_ANALYTICAL_HDRS_TL

Line 145: INSERT INTO xla_analytical_hdrs_tl

141: ,x_last_updated_by
142: ,x_last_update_login)
143: ;
144:
145: INSERT INTO xla_analytical_hdrs_tl
146: (analytical_criterion_code
147: ,analytical_criterion_type_code
148: ,amb_context_code
149: ,name

Line 175: FROM xla_analytical_hdrs_tl t

171: FROM fnd_languages l
172: WHERE l.installed_flag IN ('I', 'B')
173: AND NOT EXISTS
174: (SELECT NULL
175: FROM xla_analytical_hdrs_tl t
176: WHERE t.analytical_criterion_code = x_analytical_criterion_code
177: AND t.analytical_criterion_type_code = x_analytical_criterion_type_co
178: AND t.amb_context_code = x_amb_context_code
179: AND t.language = l.language_code);

Line 241: FROM xla_analytical_hdrs_tl

237: SELECT analytical_criterion_code
238: ,name
239: ,description
240: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
241: FROM xla_analytical_hdrs_tl
242: WHERE analytical_criterion_code = X_analytical_criterion_code
243: AND analytical_criterion_type_code = X_analytical_criterion_type_co
244: AND amb_context_code = X_amb_context_code
245: AND USERENV('LANG') IN (language ,source_lang)

Line 372: UPDATE xla_analytical_hdrs_tl

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

Line 421: DELETE FROM xla_analytical_hdrs_tl

417: p_module => l_log_module,
418: p_level => C_LEVEL_PROCEDURE);
419: END IF;
420:
421: DELETE FROM xla_analytical_hdrs_tl
422: WHERE analytical_criterion_code = x_analytical_criterion_code
423: AND analytical_criterion_type_code = x_analytical_criterion_type_co
424: AND amb_context_code = x_amb_context_code;
425:

Line 471: DELETE FROM xla_analytical_hdrs_tl T

467: p_level => C_LEVEL_PROCEDURE);
468: END IF;
469:
470:
471: DELETE FROM xla_analytical_hdrs_tl T
472: WHERE NOT EXISTS
473: (SELECT NULL
474: FROM xla_analytical_hdrs_b b
475: WHERE b.analytical_criterion_code = t.analytical_criterion_code

Line 479: UPDATE xla_analytical_hdrs_tl t

475: WHERE b.analytical_criterion_code = t.analytical_criterion_code
476: AND b.analytical_criterion_type_code = t.analytical_criterion_type_code
477: AND b.amb_context_code = t.amb_context_code);
478:
479: UPDATE xla_analytical_hdrs_tl t
480: SET (name
481: ,description)
482: = (SELECT b.name
483: ,b.description

Line 484: FROM xla_analytical_hdrs_tl b

480: SET (name
481: ,description)
482: = (SELECT b.name
483: ,b.description
484: FROM xla_analytical_hdrs_tl b
485: WHERE b.analytical_criterion_code = t.analytical_criterion_code
486: AND b.analytical_criterion_type_code = t.analytical_criterion_type_code
487: AND b.amb_context_code = t.amb_context_code
488: AND b.language = t.source_lang)

Line 497: FROM xla_analytical_hdrs_tl subb

493: IN (SELECT subt.analytical_criterion_code
494: ,subt.analytical_criterion_type_code
495: ,subt.amb_context_code
496: ,subt.language
497: FROM xla_analytical_hdrs_tl subb
498: ,xla_analytical_hdrs_tl subt
499: WHERE subb.analytical_criterion_code = subt.analytical_criterion_code
500: AND subb.analytical_criterion_type_code = subt.analytical_criterion_type_code
501: AND subb.amb_context_code = subt.amb_context_code

Line 498: ,xla_analytical_hdrs_tl subt

494: ,subt.analytical_criterion_type_code
495: ,subt.amb_context_code
496: ,subt.language
497: FROM xla_analytical_hdrs_tl subb
498: ,xla_analytical_hdrs_tl subt
499: WHERE subb.analytical_criterion_code = subt.analytical_criterion_code
500: AND subb.analytical_criterion_type_code = subt.analytical_criterion_type_code
501: AND subb.amb_context_code = subt.amb_context_code
502: AND subb.language = subt.source_lang

Line 512: INSERT INTO xla_analytical_hdrs_tl

508: AND subt.description IS NULL)
509: ))
510: ;
511:
512: INSERT INTO xla_analytical_hdrs_tl
513: (analytical_criterion_code
514: ,analytical_criterion_type_code
515: ,amb_context_code
516: ,name

Line 538: FROM xla_analytical_hdrs_tl b

534: ,b.last_updated_by
535: ,b.last_update_login
536: ,l.language_code
537: ,b.source_lang
538: FROM xla_analytical_hdrs_tl b
539: ,fnd_languages l
540: WHERE l.installed_flag IN ('I', 'B')
541: AND b.language = userenv('LANG')
542: AND NOT EXISTS

Line 544: FROM xla_analytical_hdrs_tl t

540: WHERE l.installed_flag IN ('I', 'B')
541: AND b.language = userenv('LANG')
542: AND NOT EXISTS
543: (SELECT NULL
544: FROM xla_analytical_hdrs_tl t
545: WHERE t.analytical_criterion_code = b.analytical_criterion_code
546: AND t.analytical_criterion_type_code = b.analytical_criterion_type_code
547: AND t.amb_context_code = b.amb_context_code
548: AND t.language = l.language_code);

Line 688: FROM xla_analytical_hdrs_tl

684:
685: BEGIN
686: SELECT last_updated_by, last_update_date
687: INTO db_luby, db_ludate
688: FROM xla_analytical_hdrs_tl
689: WHERE amb_context_code = p_amb_context_code
690: AND analytical_criterion_type_code = p_analytical_criterion_type_co
691: AND analytical_criterion_code = p_analytical_criterion_code
692: AND language = userenv('LANG');

Line 696: UPDATE xla_analytical_hdrs_tl

692: AND language = userenv('LANG');
693:
694: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
695: db_ludate, p_custom_mode)) then
696: UPDATE xla_analytical_hdrs_tl
697: SET name = p_name
698: ,description = p_description
699: ,last_update_date = f_ludate
700: ,last_updated_by = f_luby