APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_ANALYTICAL_DTLS_B

Line 846: DELETE FROM xla_analytical_dtls_b

842: p_level => C_LEVEL_STATEMENT);
843: END IF;
844:
845: FORALL i IN 1 .. l_ac_codes.COUNT
846: DELETE FROM xla_analytical_dtls_b
847: WHERE analytical_criterion_type_code = l_ac_type_codes(i)
848: AND analytical_criterion_code = l_ac_codes(i)
849: AND amb_context_code = g_amb_context_code;
850:

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

848: AND analytical_criterion_code = l_ac_codes(i)
849: AND amb_context_code = g_amb_context_code;
850:
851: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
852: trace(p_msg => '# row deleted into xla_analytical_dtls_b = '||SQL%ROWCOUNT,
853: p_module => l_log_module,
854: p_level => C_LEVEL_STATEMENT);
855: END IF;
856:

Line 1450: UPDATE xla_analytical_dtls_b

1446: p_module => l_log_module,
1447: p_level => C_LEVEL_STATEMENT);
1448: END IF;
1449:
1450: UPDATE xla_analytical_dtls_b
1451: SET amb_context_code = g_amb_context_code
1452: WHERE amb_context_code = g_staging_context_code;
1453:
1454: l_count := SQL%ROWCOUNT;

Line 1460: trace(p_msg => '# row moved in xla_analytical_dtls_b = '||l_count,

1456: g_ac_updated := TRUE;
1457: END IF;
1458:
1459: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1460: trace(p_msg => '# row moved in xla_analytical_dtls_b = '||l_count,
1461: p_module => l_log_module,
1462: p_level => C_LEVEL_STATEMENT);
1463: END IF;
1464: