381:
382: --
383: -- Delete conditions
384: --
385: DELETE FROM xla_conditions
386: WHERE application_id = p_application_id
387: AND amb_context_code = p_amb_context_code
388: AND segment_rule_detail_id IS NULL; -- bug 4367287: delete ADR on demand
389:
387: AND amb_context_code = p_amb_context_code
388: AND segment_rule_detail_id IS NULL; -- bug 4367287: delete ADR on demand
389:
390: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
391: trace(p_msg => '# record deleted from xla_conditions = '||SQL%ROWCOUNT,
392: p_module => l_log_module,
393: p_level => C_LEVEL_STATEMENT);
394: END IF;
395:
732: FOR UPDATE NOWAIT;
733:
734: CURSOR c_conditions IS
735: SELECT *
736: FROM xla_conditions
737: WHERE application_id = p_application_id
738: AND amb_context_code = p_amb_context_code
739: FOR UPDATE NOWAIT;
740:
2678: p_module => l_log_module,
2679: p_level => C_LEVEL_PROCEDURE);
2680: END IF;
2681:
2682: DELETE FROM xla_conditions
2683: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2684: AND application_id = p_application_id;
2685:
2686: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2683: WHERE amb_context_code IN (p_amb_context_code, l_staging_context_code)
2684: AND application_id = p_application_id;
2685:
2686: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2687: trace(p_msg => '# xla_conditions deleted = '||SQL%ROWCOUNT,
2688: p_module => l_log_module,
2689: p_level => C_LEVEL_PROCEDURE);
2690: END IF;
2691: