DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_DESCRIPTIONS_B

Line 483: DELETE FROM xla_descriptions_b

479: p_module => l_log_module,
480: p_level => C_LEVEL_STATEMENT);
481: END IF;
482:
483: DELETE FROM xla_descriptions_b
484: WHERE application_id = p_application_id
485: AND amb_context_code = p_amb_context_code;
486:
487: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 488: trace(p_msg => '# record deleted from xla_descriptions_b = '||SQL%ROWCOUNT,

484: WHERE application_id = p_application_id
485: AND amb_context_code = p_amb_context_code;
486:
487: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
488: trace(p_msg => '# record deleted from xla_descriptions_b = '||SQL%ROWCOUNT,
489: p_module => l_log_module,
490: p_level => C_LEVEL_STATEMENT);
491: END IF;
492:

Line 704: FROM xla_descriptions_b

700: FOR UPDATE NOWAIT;
701:
702: CURSOR c_descriptions_b IS
703: SELECT *
704: FROM xla_descriptions_b
705: WHERE application_id = p_application_id
706: AND amb_context_code = p_amb_context_code
707: FOR UPDATE NOWAIT;
708:

Line 2840: DELETE FROM xla_descriptions_b

2836: p_module => l_log_module,
2837: p_level => C_LEVEL_PROCEDURE);
2838: END IF;
2839:
2840: DELETE FROM xla_descriptions_b
2841: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2842: AND application_id = p_application_id;
2843:
2844: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2845: trace(p_msg => '# xla_descriptions_b deleted = '||SQL%ROWCOUNT,

2841: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2842: AND application_id = p_application_id;
2843:
2844: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2845: trace(p_msg => '# xla_descriptions_b deleted = '||SQL%ROWCOUNT,
2846: p_module => l_log_module,
2847: p_level => C_LEVEL_PROCEDURE);
2848: END IF;
2849: