DBA Data[Home] [Help]

APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_ANALYTICAL_DTLS_TL

Line 834: DELETE FROM xla_analytical_dtls_tl

830: p_level => C_LEVEL_STATEMENT);
831: END IF;
832:
833: FORALL i IN 1 .. l_ac_codes.COUNT
834: DELETE FROM xla_analytical_dtls_tl
835: WHERE analytical_criterion_type_code = l_ac_type_codes(i)
836: AND analytical_criterion_code = l_ac_codes(i)
837: AND amb_context_code = g_amb_context_code;
838:

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

836: AND analytical_criterion_code = l_ac_codes(i)
837: AND amb_context_code = g_amb_context_code;
838:
839: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
840: trace(p_msg => '# row deleted into xla_analytical_dtls_tl = '||SQL%ROWCOUNT,
841: p_module => l_log_module,
842: p_level => C_LEVEL_STATEMENT);
843: END IF;
844:

Line 1465: UPDATE xla_analytical_dtls_tl

1461: p_module => l_log_module,
1462: p_level => C_LEVEL_STATEMENT);
1463: END IF;
1464:
1465: UPDATE xla_analytical_dtls_tl
1466: SET amb_context_code = g_amb_context_code
1467: WHERE amb_context_code = g_staging_context_code;
1468:
1469: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

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

1466: SET amb_context_code = g_amb_context_code
1467: WHERE amb_context_code = g_staging_context_code;
1468:
1469: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1470: trace(p_msg => '# row moved in xla_analytical_dtls_tl = '||SQL%ROWCOUNT,
1471: p_module => l_log_module,
1472: p_level => C_LEVEL_STATEMENT);
1473: END IF;
1474: