212:
213: --
214: -- Delete accounting method rules
215: --
216: DELETE FROM xla_acctg_method_rules
217: WHERE application_id = p_application_id
218: AND amb_context_code = p_amb_context_code;
219:
220: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
217: WHERE application_id = p_application_id
218: AND amb_context_code = p_amb_context_code;
219:
220: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
221: trace(p_msg => '# record deleted from xla_acctg_method_rules = '||SQL%ROWCOUNT,
222: p_module => l_log_module,
223: p_level => C_LEVEL_STATEMENT);
224: END IF;
225:
2508: p_module => l_log_module,
2509: p_level => C_LEVEL_PROCEDURE);
2510: END IF;
2511:
2512: DELETE FROM xla_acctg_method_rules
2513: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2514: AND application_id = p_application_id;
2515:
2516: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2513: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2514: AND application_id = p_application_id;
2515:
2516: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2517: trace(p_msg => '# xla_acctg_method_rules deleted = '||SQL%ROWCOUNT,
2518: p_module => l_log_module,
2519: p_level => C_LEVEL_PROCEDURE);
2520: END IF;
2521: