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_AAD_OVERWRITE_PVT dependencies on XLA_SEG_RULES_B

Line 114: FROM xla_seg_rules_b w

110: AND s.amb_context_code = g_staging_context_code;
111:
112: CURSOR c_adr IS
113: SELECT t.name
114: FROM xla_seg_rules_b w
115: ,xla_seg_rules_b s
116: ,xla_seg_rules_tl t
117: WHERE s.version_num < w.version_num
118: AND t.language = USERENV('LANG')

Line 115: ,xla_seg_rules_b s

111:
112: CURSOR c_adr IS
113: SELECT t.name
114: FROM xla_seg_rules_b w
115: ,xla_seg_rules_b s
116: ,xla_seg_rules_tl t
117: WHERE s.version_num < w.version_num
118: AND t.language = USERENV('LANG')
119: AND t.amb_context_code = w.amb_context_code

Line 916: FROM xla_seg_rules_b s

912: SELECT s.segment_rule_type_code
913: ,s.segment_rule_code
914: ,w.version_num version_from
915: ,s.version_num version_to
916: FROM xla_seg_rules_b s
917: ,xla_seg_rules_b w
918: WHERE s.application_id = w.application_id
919: AND s.segment_rule_type_code = w.segment_rule_type_code
920: AND s.segment_rule_code = w.segment_rule_code

Line 917: ,xla_seg_rules_b w

913: ,s.segment_rule_code
914: ,w.version_num version_from
915: ,s.version_num version_to
916: FROM xla_seg_rules_b s
917: ,xla_seg_rules_b w
918: WHERE s.application_id = w.application_id
919: AND s.segment_rule_type_code = w.segment_rule_type_code
920: AND s.segment_rule_code = w.segment_rule_code
921: AND s.amb_context_code = g_staging_context_code

Line 928: FROM xla_seg_rules_b w

924: SELECT w.segment_rule_type_code
925: ,w.segment_rule_code
926: ,NULL
927: ,NULL
928: FROM xla_seg_rules_b w
929: WHERE w.application_id = g_application_id
930: AND w.amb_context_code = g_amb_context_code;
931:
932: l_adrs xla_component_tbl_type;

Line 1109: DELETE FROM xla_seg_rules_b

1105: p_level => C_LEVEL_STATEMENT);
1106: END IF;
1107:
1108: FORALL i IN 1 .. l_adr_codes.COUNT
1109: DELETE FROM xla_seg_rules_b
1110: WHERE application_id = g_application_id
1111: AND amb_context_code = g_amb_context_code
1112: AND segment_rule_type_code = l_adr_type_codes(i)
1113: AND segment_rule_code = l_adr_codes(i);

Line 1116: trace(p_msg => '# row deleted into xla_seg_rules_b = '||SQL%ROWCOUNT,

1112: AND segment_rule_type_code = l_adr_type_codes(i)
1113: AND segment_rule_code = l_adr_codes(i);
1114:
1115: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1116: trace(p_msg => '# row deleted into xla_seg_rules_b = '||SQL%ROWCOUNT,
1117: p_module => l_log_module,
1118: p_level => C_LEVEL_STATEMENT);
1119: END IF;
1120:

Line 1207: FROM xla_seg_rules_b s

1203: WHERE xld.amb_context_code = g_amb_context_code
1204: AND xld.application_id <> g_application_id
1205: AND xld.segment_rule_appl_id = g_application_id
1206: AND NOT EXISTS (SELECT 1
1207: FROM xla_seg_rules_b s
1208: WHERE s.amb_context_code = g_staging_context_code
1209: AND s.application_id = xld.segment_rule_appl_id
1210: AND s.segment_rule_type_code = xld.segment_rule_type_code
1211: AND s.segment_rule_code = xld.segment_rule_code);

Line 1225: FROM xla_seg_rules_b s

1221: DELETE FROM xla_line_defn_adr_assgns xld
1222: WHERE xld.amb_context_code = g_amb_context_code
1223: AND xld.segment_rule_appl_id = g_application_id
1224: AND NOT EXISTS (SELECT 1
1225: FROM xla_seg_rules_b s
1226: WHERE s.amb_context_code = g_staging_context_code
1227: AND s.application_id = xld.segment_rule_appl_id
1228: AND s.segment_rule_type_code = xld.segment_rule_type_code
1229: AND s.segment_rule_code = xld.segment_rule_code);

Line 1363: UPDATE xla_seg_rules_b

1359: p_level => C_LEVEL_STATEMENT);
1360: END IF;
1361:
1362: -- Move account derivation rules
1363: UPDATE xla_seg_rules_b
1364: SET amb_context_code = g_amb_context_code
1365: WHERE amb_context_code = g_staging_context_code;
1366:
1367: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1368: trace(p_msg => '# row moved in xla_seg_rules_b = '||SQL%ROWCOUNT,

1364: SET amb_context_code = g_amb_context_code
1365: WHERE amb_context_code = g_staging_context_code;
1366:
1367: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1368: trace(p_msg => '# row moved in xla_seg_rules_b = '||SQL%ROWCOUNT,
1369: p_module => l_log_module,
1370: p_level => C_LEVEL_STATEMENT);
1371: END IF;
1372: