APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_ANALYTICAL_SOURCES

Line 822: DELETE FROM xla_analytical_sources

818: p_level => C_LEVEL_STATEMENT);
819: END IF;
820:
821: FORALL i IN 1 .. l_ac_codes.COUNT
822: DELETE FROM xla_analytical_sources
823: WHERE analytical_criterion_type_code = l_ac_type_codes(i)
824: AND analytical_criterion_code = l_ac_codes(i)
825: AND amb_context_code = g_amb_context_code;
826:

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

824: AND analytical_criterion_code = l_ac_codes(i)
825: AND amb_context_code = g_amb_context_code;
826:
827: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
828: trace(p_msg => '# row deleted into xla_analytical_sources = '||SQL%ROWCOUNT,
829: p_module => l_log_module,
830: p_level => C_LEVEL_STATEMENT);
831: END IF;
832:

Line 1475: UPDATE xla_analytical_sources

1471: p_module => l_log_module,
1472: p_level => C_LEVEL_STATEMENT);
1473: END IF;
1474:
1475: UPDATE xla_analytical_sources
1476: SET amb_context_code = g_amb_context_code
1477: WHERE amb_context_code = g_staging_context_code;
1478:
1479: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

1476: SET amb_context_code = g_amb_context_code
1477: WHERE amb_context_code = g_staging_context_code;
1478:
1479: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1480: trace(p_msg => '# row moved in xla_analytical_sources = '||SQL%ROWCOUNT,
1481: p_module => l_log_module,
1482: p_level => C_LEVEL_STATEMENT);
1483: END IF;
1484: