APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_CONDITIONS

Line 1067: DELETE FROM xla_conditions

1063: p_level => C_LEVEL_STATEMENT);
1064: END IF;
1065:
1066: FORALL i IN 1 .. l_adr_codes.COUNT
1067: DELETE FROM xla_conditions
1068: WHERE segment_rule_detail_id IN
1069: (SELECT segment_rule_detail_id
1070: FROM xla_seg_rule_details
1071: WHERE application_id = g_application_id

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

1073: AND segment_rule_type_code = l_adr_type_codes(i)
1074: AND segment_rule_code = l_adr_codes(i));
1075:
1076: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1077: trace(p_msg => '# row deleted into xla_conditions = '||SQL%ROWCOUNT,
1078: p_module => l_log_module,
1079: p_level => C_LEVEL_STATEMENT);
1080: END IF;
1081:

Line 1486: UPDATE xla_conditions

1482: p_level => C_LEVEL_STATEMENT);
1483: END IF;
1484:
1485: -- Move conditions
1486: UPDATE xla_conditions
1487: SET amb_context_code = g_amb_context_code
1488: WHERE amb_context_code = g_staging_context_code;
1489:
1490: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

1487: SET amb_context_code = g_amb_context_code
1488: WHERE amb_context_code = g_staging_context_code;
1489:
1490: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1491: trace(p_msg => '# row moved in xla_conditions = '||SQL%ROWCOUNT,
1492: p_module => l_log_module,
1493: p_level => C_LEVEL_STATEMENT);
1494: END IF;
1495: