2450: p_module => l_log_module,
2451: p_level => C_LEVEL_PROCEDURE);
2452: END IF;
2453:
2454: DELETE FROM xla_stage_acctg_methods
2455: WHERE staging_amb_context_code = l_staging_context_code;
2456:
2457: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2458: trace(p_msg => '# xla_stage_acctg_methods deleted = '||SQL%ROWCOUNT,
2454: DELETE FROM xla_stage_acctg_methods
2455: WHERE staging_amb_context_code = l_staging_context_code;
2456:
2457: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2458: trace(p_msg => '# xla_stage_acctg_methods deleted = '||SQL%ROWCOUNT,
2459: p_module => l_log_module,
2460: p_level => C_LEVEL_PROCEDURE);
2461: END IF;
2462: ELSE
2488: p_module => l_log_module,
2489: p_level => C_LEVEL_PROCEDURE);
2490: END IF;
2491:
2492: DELETE FROM xla_stage_acctg_methods
2493: WHERE staging_amb_context_code = p_amb_context_code;
2494:
2495: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2496: trace(p_msg => '# xla_stage_acctg_methods deleted = '||SQL%ROWCOUNT,
2492: DELETE FROM xla_stage_acctg_methods
2493: WHERE staging_amb_context_code = p_amb_context_code;
2494:
2495: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2496: trace(p_msg => '# xla_stage_acctg_methods deleted = '||SQL%ROWCOUNT,
2497: p_module => l_log_module,
2498: p_level => C_LEVEL_PROCEDURE);
2499: END IF;
2500: END IF;