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_LINE_DEFINITIONS_F_PVT dependencies on XLA_LINE_DEFINITIONS_TL

Line 134: INSERT INTO xla_line_definitions_tl

130: ,x_last_updated_by
131: ,x_last_update_login)
132: ;
133:
134: INSERT INTO xla_line_definitions_tl
135: (amb_context_code
136: ,creation_date
137: ,created_by
138: ,last_update_date

Line 172: FROM xla_line_definitions_tl xld

168: FROM fnd_languages fl
169: WHERE fl.installed_flag IN ('I', 'B')
170: AND NOT EXISTS
171: (SELECT NULL
172: FROM xla_line_definitions_tl xld
173: WHERE xld.application_id = x_application_id
174: AND xld.amb_context_code = x_amb_context_code
175: AND xld.event_class_code = x_event_class_code
176: AND xld.event_type_code = x_event_type_code

Line 240: FROM xla_line_definitions_tl

236: CURSOR c1 IS
237: SELECT name
238: ,description
239: ,DECODE(language, USERENV('LANG'), 'Y', 'N') baselang
240: FROM xla_line_definitions_tl
241: WHERE application_id = x_application_id
242: AND amb_context_code = x_amb_context_code
243: AND event_class_code = x_event_class_code
244: AND event_type_code = x_event_type_code

Line 370: UPDATE xla_line_definitions_tl

366: IF (SQL%NOTFOUND) THEN
367: RAISE NO_DATA_FOUND;
368: END IF;
369:
370: UPDATE xla_line_definitions_tl
371: SET
372: last_update_date = x_last_update_date
373: ,name = x_name
374: ,description = x_description

Line 427: DELETE FROM xla_line_definitions_tl

423: p_module => l_log_module,
424: p_level => C_LEVEL_PROCEDURE);
425: END IF;
426:
427: DELETE FROM xla_line_definitions_tl
428: WHERE application_id = x_application_id
429: AND amb_context_code = x_amb_context_code
430: AND event_class_code = x_event_class_code
431: AND event_type_code = x_event_type_code

Line 479: DELETE FROM xla_line_definitions_tl T

475: p_module => l_log_module,
476: p_level => C_LEVEL_PROCEDURE);
477: END IF;
478:
479: DELETE FROM xla_line_definitions_tl T
480: WHERE NOT EXISTS
481: (SELECT NULL
482: FROM xla_line_definitions_b b
483: WHERE b.application_id = t.application_id

Line 490: UPDATE xla_line_definitions_tl t

486: AND b.event_type_code = t.event_type_code
487: AND b.line_definition_owner_code = t.line_definition_owner_code
488: AND b.line_definition_code = t.line_definition_code);
489:
490: UPDATE xla_line_definitions_tl t
491: SET (name
492: ,description
493: ,object_version_number)
494: = (SELECT b.name

Line 497: FROM xla_line_definitions_tl b

493: ,object_version_number)
494: = (SELECT b.name
495: ,b.description
496: ,b.object_version_number + 1
497: FROM xla_line_definitions_tl b
498: WHERE b.application_id = t.application_id
499: AND b.amb_context_code = t.amb_context_code
500: AND b.event_class_code = t.event_class_code
501: AND b.event_type_code = t.event_type_code

Line 519: FROM xla_line_definitions_tl subb

515: ,subt.event_type_code
516: ,subt.line_definition_owner_code
517: ,subt.line_definition_code
518: ,subt.language
519: FROM xla_line_definitions_tl subb
520: ,xla_line_definitions_tl subt
521: WHERE subb.application_id = subt.application_id
522: AND subb.amb_context_code = subt.amb_context_code
523: AND subb.event_class_code = subt.event_class_code

Line 520: ,xla_line_definitions_tl subt

516: ,subt.line_definition_owner_code
517: ,subt.line_definition_code
518: ,subt.language
519: FROM xla_line_definitions_tl subb
520: ,xla_line_definitions_tl subt
521: WHERE subb.application_id = subt.application_id
522: AND subb.amb_context_code = subt.amb_context_code
523: AND subb.event_class_code = subt.event_class_code
524: AND subb.event_type_code = subt.event_type_code

Line 537: INSERT INTO xla_line_definitions_tl

533: AND subt.description IS NULL)
534: ))
535: ;
536:
537: INSERT INTO xla_line_definitions_tl
538: (amb_context_code
539: ,object_version_number
540: ,last_update_login
541: ,creation_date

Line 571: FROM xla_line_definitions_tl b

567: ,b.name
568: ,b.description
569: ,l.language_code
570: ,b.source_lang
571: FROM xla_line_definitions_tl b
572: ,fnd_languages l
573: WHERE l.installed_flag IN ('I', 'B')
574: AND b.language = userenv('LANG')
575: AND NOT EXISTS

Line 577: FROM xla_line_definitions_tl t

573: WHERE l.installed_flag IN ('I', 'B')
574: AND b.language = userenv('LANG')
575: AND NOT EXISTS
576: (SELECT NULL
577: FROM xla_line_definitions_tl t
578: WHERE t.application_id = b.application_id
579: AND t.amb_context_code = b.amb_context_code
580: AND t.event_class_code = b.event_class_code
581: AND t.event_type_code = b.event_type_code

Line 651: FROM xla_line_definitions_tl

647:
648: BEGIN
649: SELECT last_updated_by, last_update_date
650: INTO db_luby, db_ludate
651: FROM xla_line_definitions_tl
652: WHERE application_id = l_application_id
653: AND amb_context_code = p_amb_context_code
654: AND event_class_code = p_event_class_code
655: AND event_type_code = p_event_type_code

Line 662: UPDATE xla_line_definitions_tl

658: AND language = userenv('LANG');
659:
660: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
661: db_ludate, p_custom_mode)) then
662: UPDATE xla_line_definitions_tl
663: SET name = p_name
664: ,description = p_description
665: ,last_update_date = f_ludate
666: ,last_updated_by = f_luby