APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_SEG_RULES_TL

Line 116: ,xla_seg_rules_tl t

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
120: AND t.application_id = w.application_id

Line 1096: DELETE FROM xla_seg_rules_tl

1092: p_level => C_LEVEL_STATEMENT);
1093: END IF;
1094:
1095: FORALL i IN 1 .. l_adr_codes.COUNT
1096: DELETE FROM xla_seg_rules_tl
1097: WHERE application_id = g_application_id
1098: AND amb_context_code = g_amb_context_code
1099: AND segment_rule_type_code = l_adr_type_codes(i)
1100: AND segment_rule_code = l_adr_codes(i);

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

1099: AND segment_rule_type_code = l_adr_type_codes(i)
1100: AND segment_rule_code = l_adr_codes(i);
1101:
1102: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1103: trace(p_msg => '# row deleted into xla_seg_rules_tl = '||SQL%ROWCOUNT,
1104: p_module => l_log_module,
1105: p_level => C_LEVEL_STATEMENT);
1106: END IF;
1107:

Line 1373: UPDATE xla_seg_rules_tl

1369: p_module => l_log_module,
1370: p_level => C_LEVEL_STATEMENT);
1371: END IF;
1372:
1373: UPDATE xla_seg_rules_tl
1374: SET amb_context_code = g_amb_context_code
1375: WHERE amb_context_code = g_staging_context_code;
1376:
1377: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

1374: SET amb_context_code = g_amb_context_code
1375: WHERE amb_context_code = g_staging_context_code;
1376:
1377: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1378: trace(p_msg => '# row moved in xla_seg_rules_tl = '||SQL%ROWCOUNT,
1379: p_module => l_log_module,
1380: p_level => C_LEVEL_STATEMENT);
1381: END IF;
1382: