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_SEG_RULES_F_PKG dependencies on XLA_SEG_RULES_TL

Line 145: INSERT INTO xla_seg_rules_tl

141: ,x_last_updated_by
142: ,x_last_update_login)
143: ;
144:
145: INSERT INTO xla_seg_rules_tl
146: (last_update_login
147: ,amb_context_code
148: ,last_update_date
149: ,last_updated_by

Line 177: FROM xla_seg_rules_tl t

173: FROM fnd_languages l
174: WHERE l.installed_flag IN ('I', 'B')
175: AND NOT EXISTS
176: (SELECT NULL
177: FROM xla_seg_rules_tl t
178: WHERE t.application_id = x_application_id
179: AND t.amb_context_code = x_amb_context_code
180: AND t.segment_rule_type_code = x_segment_rule_type_code
181: AND t.segment_rule_code = x_segment_rule_code

Line 244: FROM xla_seg_rules_tl

240: SELECT last_update_login
241: ,name
242: ,description
243: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
244: FROM xla_seg_rules_tl
245: WHERE application_id = X_application_id
246: AND amb_context_code = X_amb_context_code
247: AND segment_rule_type_code = X_segment_rule_type_code
248: AND segment_rule_code = X_segment_rule_code

Line 376: UPDATE xla_seg_rules_tl

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

Line 427: DELETE FROM xla_seg_rules_tl

423: p_module => l_log_module,
424: p_level => C_LEVEL_PROCEDURE);
425: END IF;
426:
427: DELETE FROM xla_seg_rules_tl
428: WHERE application_id = x_application_id
429: AND amb_context_code = x_amb_context_code
430: AND segment_rule_type_code = x_segment_rule_type_code
431: AND segment_rule_code = x_segment_rule_code;

Line 480: DELETE FROM xla_seg_rules_tl T

476: p_level => C_LEVEL_PROCEDURE);
477: END IF;
478:
479:
480: DELETE FROM xla_seg_rules_tl T
481: WHERE NOT EXISTS
482: (SELECT NULL
483: FROM xla_seg_rules_b b
484: WHERE b.application_id = t.application_id

Line 489: UPDATE xla_seg_rules_tl t

485: AND b.amb_context_code = t.amb_context_code
486: AND b.segment_rule_type_code = t.segment_rule_type_code
487: AND b.segment_rule_code = t.segment_rule_code);
488:
489: UPDATE xla_seg_rules_tl t
490: SET (name
491: ,description)
492: = (SELECT b.name
493: ,b.description

Line 494: FROM xla_seg_rules_tl b

490: SET (name
491: ,description)
492: = (SELECT b.name
493: ,b.description
494: FROM xla_seg_rules_tl b
495: WHERE b.application_id = t.application_id
496: AND b.amb_context_code = t.amb_context_code
497: AND b.segment_rule_type_code = t.segment_rule_type_code
498: AND b.segment_rule_code = t.segment_rule_code

Line 510: FROM xla_seg_rules_tl subb

506: ,subt.amb_context_code
507: ,subt.segment_rule_type_code
508: ,subt.segment_rule_code
509: ,subt.language
510: FROM xla_seg_rules_tl subb
511: ,xla_seg_rules_tl subt
512: WHERE subb.application_id = subt.application_id
513: AND subb.amb_context_code = subt.amb_context_code
514: AND subb.segment_rule_type_code = subt.segment_rule_type_code

Line 511: ,xla_seg_rules_tl subt

507: ,subt.segment_rule_type_code
508: ,subt.segment_rule_code
509: ,subt.language
510: FROM xla_seg_rules_tl subb
511: ,xla_seg_rules_tl subt
512: WHERE subb.application_id = subt.application_id
513: AND subb.amb_context_code = subt.amb_context_code
514: AND subb.segment_rule_type_code = subt.segment_rule_type_code
515: AND subb.segment_rule_code = subt.segment_rule_code

Line 526: INSERT INTO xla_seg_rules_tl

522: AND subt.description IS NULL)
523: ))
524: ;
525:
526: INSERT INTO xla_seg_rules_tl
527: (last_update_login
528: ,amb_context_code
529: ,last_update_date
530: ,last_updated_by

Line 554: FROM xla_seg_rules_tl b

550: ,b.description
551: ,b.creation_date
552: ,l.language_code
553: ,b.source_lang
554: FROM xla_seg_rules_tl b
555: ,fnd_languages l
556: WHERE l.installed_flag IN ('I', 'B')
557: AND b.language = userenv('LANG')
558: AND NOT EXISTS

Line 560: FROM xla_seg_rules_tl t

556: WHERE l.installed_flag IN ('I', 'B')
557: AND b.language = userenv('LANG')
558: AND NOT EXISTS
559: (SELECT NULL
560: FROM xla_seg_rules_tl t
561: WHERE t.application_id = b.application_id
562: AND t.amb_context_code = b.amb_context_code
563: AND t.segment_rule_type_code = b.segment_rule_type_code
564: AND t.segment_rule_code = b.segment_rule_code

Line 632: FROM xla_seg_rules_tl

628:
629: BEGIN
630: SELECT last_updated_by, last_update_date
631: INTO db_luby, db_ludate
632: FROM xla_seg_rules_tl
633: WHERE application_id = l_application_id
634: AND amb_context_code = p_amb_context_code
635: AND segment_rule_type_code = p_segment_rule_type_code
636: AND segment_rule_code = p_segment_rule_code

Line 641: UPDATE xla_seg_rules_tl

637: AND language = userenv('LANG');
638:
639: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
640: db_ludate, p_custom_mode)) then
641: UPDATE xla_seg_rules_tl
642: SET name = p_name
643: ,description = p_description
644: ,last_update_date = f_ludate
645: ,last_updated_by = f_luby