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_DTLS_F_PKG dependencies on XLA_ANALYTICAL_DTLS_TL

Line 131: INSERT INTO xla_analytical_dtls_tl

127: ,x_last_updated_by
128: ,x_last_update_login)
129: ;
130:
131: INSERT INTO xla_analytical_dtls_tl
132: (analytical_criterion_code
133: ,analytical_criterion_type_code
134: ,amb_context_code
135: ,analytical_detail_code

Line 163: FROM xla_analytical_dtls_tl t

159: FROM fnd_languages l
160: WHERE l.installed_flag IN ('I', 'B')
161: AND NOT EXISTS
162: (SELECT NULL
163: FROM xla_analytical_dtls_tl t
164: WHERE t.analytical_criterion_code = x_analytical_criterion_code
165: AND t.analytical_criterion_type_code = x_analytical_criterion_type_co
166: AND t.amb_context_code = x_amb_context_code
167: AND t.analytical_detail_code = x_analytical_detail_code

Line 222: FROM xla_analytical_dtls_tl

218: SELECT analytical_criterion_code
219: ,name
220: ,description
221: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
222: FROM xla_analytical_dtls_tl
223: WHERE analytical_criterion_code = X_analytical_criterion_code
224: AND analytical_criterion_type_code = X_analytical_criterion_type_co
225: AND amb_context_code = X_amb_context_code
226: AND analytical_detail_code = X_analytical_detail_code

Line 336: UPDATE xla_analytical_dtls_tl

332: IF (SQL%NOTFOUND) THEN
333: RAISE NO_DATA_FOUND;
334: END IF;
335:
336: UPDATE xla_analytical_dtls_tl
337: SET
338: last_update_date = x_last_update_date
339: ,name = X_name
340: ,description = X_description

Line 387: DELETE FROM xla_analytical_dtls_tl

383: p_module => l_log_module,
384: p_level => C_LEVEL_PROCEDURE);
385: END IF;
386:
387: DELETE FROM xla_analytical_dtls_tl
388: WHERE analytical_criterion_code = x_analytical_criterion_code
389: AND analytical_criterion_type_code = x_analytical_criterion_type_co
390: AND amb_context_code = x_amb_context_code
391: AND analytical_detail_code = x_analytical_detail_code;

Line 440: DELETE FROM xla_analytical_dtls_tl T

436: p_level => C_LEVEL_PROCEDURE);
437: END IF;
438:
439:
440: DELETE FROM xla_analytical_dtls_tl T
441: WHERE NOT EXISTS
442: (SELECT NULL
443: FROM xla_analytical_dtls_b b
444: WHERE b.analytical_criterion_code = t.analytical_criterion_code

Line 449: UPDATE xla_analytical_dtls_tl t

445: AND b.analytical_criterion_type_code = t.analytical_criterion_type_code
446: AND b.amb_context_code = t.amb_context_code
447: AND b.analytical_detail_code = t.analytical_detail_code);
448:
449: UPDATE xla_analytical_dtls_tl t
450: SET (name
451: ,description)
452: = (SELECT b.name
453: ,b.description

Line 454: FROM xla_analytical_dtls_tl b

450: SET (name
451: ,description)
452: = (SELECT b.name
453: ,b.description
454: FROM xla_analytical_dtls_tl b
455: WHERE b.analytical_criterion_code = t.analytical_criterion_code
456: AND b.analytical_criterion_type_code = t.analytical_criterion_type_code
457: AND b.amb_context_code = t.amb_context_code
458: AND b.analytical_detail_code = t.analytical_detail_code

Line 470: FROM xla_analytical_dtls_tl subb

466: ,subt.analytical_criterion_type_code
467: ,subt.amb_context_code
468: ,subt.analytical_detail_code
469: ,subt.language
470: FROM xla_analytical_dtls_tl subb
471: ,xla_analytical_dtls_tl subt
472: WHERE subb.analytical_criterion_code = subt.analytical_criterion_code
473: AND subb.analytical_criterion_type_code = subt.analytical_criterion_type_code
474: AND subb.amb_context_code = subt.amb_context_code

Line 471: ,xla_analytical_dtls_tl subt

467: ,subt.amb_context_code
468: ,subt.analytical_detail_code
469: ,subt.language
470: FROM xla_analytical_dtls_tl subb
471: ,xla_analytical_dtls_tl subt
472: WHERE subb.analytical_criterion_code = subt.analytical_criterion_code
473: AND subb.analytical_criterion_type_code = subt.analytical_criterion_type_code
474: AND subb.amb_context_code = subt.amb_context_code
475: AND subb.analytical_detail_code = subt.analytical_detail_code

Line 486: INSERT INTO xla_analytical_dtls_tl

482: AND subt.description IS NULL)
483: ))
484: ;
485:
486: INSERT INTO xla_analytical_dtls_tl
487: (analytical_criterion_code
488: ,analytical_criterion_type_code
489: ,amb_context_code
490: ,analytical_detail_code

Line 514: FROM xla_analytical_dtls_tl b

510: ,b.last_updated_by
511: ,b.last_update_login
512: ,l.language_code
513: ,b.source_lang
514: FROM xla_analytical_dtls_tl b
515: ,fnd_languages l
516: WHERE l.installed_flag IN ('I', 'B')
517: AND b.language = userenv('LANG')
518: AND NOT EXISTS

Line 520: FROM xla_analytical_dtls_tl t

516: WHERE l.installed_flag IN ('I', 'B')
517: AND b.language = userenv('LANG')
518: AND NOT EXISTS
519: (SELECT NULL
520: FROM xla_analytical_dtls_tl t
521: WHERE t.analytical_criterion_code = b.analytical_criterion_code
522: AND t.analytical_criterion_type_code = b.analytical_criterion_type_code
523: AND t.amb_context_code = b.amb_context_code
524: AND t.analytical_detail_code = b.analytical_detail_code

Line 580: FROM xla_analytical_dtls_tl

576:
577: BEGIN
578: SELECT last_updated_by, last_update_date
579: INTO db_luby, db_ludate
580: FROM xla_analytical_dtls_tl
581: WHERE amb_context_code = p_amb_context_code
582: AND analytical_criterion_type_code = p_analytical_criterion_type_co
583: AND analytical_criterion_code = p_analytical_criterion_code
584: AND analytical_detail_code = p_analytical_detail_code

Line 589: UPDATE xla_analytical_dtls_tl

585: AND language = userenv('LANG');
586:
587: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
588: db_ludate, p_custom_mode)) then
589: UPDATE xla_analytical_dtls_tl
590: SET name = p_name
591: ,description = p_description
592: ,last_update_date = f_ludate
593: ,last_updated_by = f_luby