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_ACCT_LINE_TYPES_F_PKG dependencies on XLA_ACCT_LINE_TYPES_TL

Line 175: INSERT INTO xla_acct_line_types_tl

171: ,x_mpa_option_code
172: ,x_encumbrance_type_id)
173: ;
174:
175: INSERT INTO xla_acct_line_types_tl
176: (amb_context_code
177: ,application_id
178: ,entity_code
179: ,event_class_code

Line 211: FROM xla_acct_line_types_tl t

207: FROM fnd_languages l
208: WHERE l.installed_flag IN ('I', 'B')
209: AND NOT EXISTS
210: (SELECT NULL
211: FROM xla_acct_line_types_tl t
212: WHERE t.application_id = x_application_id
213: AND t.amb_context_code = x_amb_context_code
214: AND t.entity_code = x_entity_code
215: AND t.event_class_code = x_event_class_code

Line 300: FROM xla_acct_line_types_tl

296: SELECT amb_context_code
297: ,name
298: ,description
299: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
300: FROM xla_acct_line_types_tl
301: WHERE application_id = X_application_id
302: AND amb_context_code = X_amb_context_code
303: AND entity_code = X_entity_code
304: AND event_class_code = X_event_class_code

Line 466: UPDATE xla_acct_line_types_tl

462: IF (SQL%NOTFOUND) THEN
463: RAISE NO_DATA_FOUND;
464: END IF;
465:
466: UPDATE xla_acct_line_types_tl
467: SET
468: last_update_date = x_last_update_date
469: ,name = X_name
470: ,description = X_description

Line 521: DELETE FROM xla_acct_line_types_tl

517: p_module => l_log_module,
518: p_level => C_LEVEL_PROCEDURE);
519: END IF;
520:
521: DELETE FROM xla_acct_line_types_tl
522: WHERE application_id = x_application_id
523: AND amb_context_code = x_amb_context_code
524: AND entity_code = x_entity_code
525: AND event_class_code = x_event_class_code

Line 577: DELETE FROM xla_acct_line_types_tl T

573: p_module => l_log_module,
574: p_level => C_LEVEL_PROCEDURE);
575: END IF;
576:
577: DELETE FROM xla_acct_line_types_tl T
578: WHERE NOT EXISTS
579: (SELECT NULL
580: FROM xla_acct_line_types_b b
581: WHERE b.application_id = t.application_id

Line 588: UPDATE xla_acct_line_types_tl t

584: AND b.event_class_code = t.event_class_code
585: AND b.accounting_line_type_code = t.accounting_line_type_code
586: AND b.accounting_line_code = t.accounting_line_code);
587:
588: UPDATE xla_acct_line_types_tl t
589: SET (name
590: ,description)
591: = (SELECT b.name
592: ,b.description

Line 593: FROM xla_acct_line_types_tl b

589: SET (name
590: ,description)
591: = (SELECT b.name
592: ,b.description
593: FROM xla_acct_line_types_tl b
594: WHERE b.application_id = t.application_id
595: AND b.amb_context_code = t.amb_context_code
596: AND b.entity_code = t.entity_code
597: AND b.event_class_code = t.event_class_code

Line 615: FROM xla_acct_line_types_tl subb

611: ,subt.event_class_code
612: ,subt.accounting_line_type_code
613: ,subt.accounting_line_code
614: ,subt.language
615: FROM xla_acct_line_types_tl subb
616: ,xla_acct_line_types_tl subt
617: WHERE subb.application_id = subt.application_id
618: AND subb.amb_context_code = subt.amb_context_code
619: AND subb.entity_code = subt.entity_code

Line 616: ,xla_acct_line_types_tl subt

612: ,subt.accounting_line_type_code
613: ,subt.accounting_line_code
614: ,subt.language
615: FROM xla_acct_line_types_tl subb
616: ,xla_acct_line_types_tl subt
617: WHERE subb.application_id = subt.application_id
618: AND subb.amb_context_code = subt.amb_context_code
619: AND subb.entity_code = subt.entity_code
620: AND subb.event_class_code = subt.event_class_code

Line 633: INSERT INTO xla_acct_line_types_tl

629: AND subt.description IS NULL)
630: ))
631: ;
632:
633: INSERT INTO xla_acct_line_types_tl
634: (amb_context_code
635: ,application_id
636: ,entity_code
637: ,event_class_code

Line 665: FROM xla_acct_line_types_tl b

661: ,b.last_updated_by
662: ,b.last_update_login
663: ,l.language_code
664: ,b.source_lang
665: FROM xla_acct_line_types_tl b
666: ,fnd_languages l
667: WHERE l.installed_flag IN ('I', 'B')
668: AND b.language = userenv('LANG')
669: AND NOT EXISTS

Line 671: FROM xla_acct_line_types_tl t

667: WHERE l.installed_flag IN ('I', 'B')
668: AND b.language = userenv('LANG')
669: AND NOT EXISTS
670: (SELECT NULL
671: FROM xla_acct_line_types_tl t
672: WHERE t.application_id = b.application_id
673: AND t.amb_context_code = b.amb_context_code
674: AND t.entity_code = b.entity_code
675: AND t.event_class_code = b.event_class_code

Line 744: FROM xla_acct_line_types_tl

740:
741: BEGIN
742: SELECT last_updated_by, last_update_date
743: INTO db_luby, db_ludate
744: FROM xla_acct_line_types_tl
745: WHERE application_id = l_application_id
746: AND amb_context_code = p_amb_context_code
747: AND event_class_code = p_event_class_code
748: AND accounting_line_type_code = p_accounting_line_type_code

Line 754: UPDATE xla_acct_line_types_tl

750: AND language = userenv('LANG');
751:
752: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
753: db_ludate, p_custom_mode)) then
754: UPDATE xla_acct_line_types_tl
755: SET name = p_name
756: ,description = p_description
757: ,last_update_date = f_ludate
758: ,last_updated_by = f_luby