292: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
293: jtm_message_log_pkg.Log_Msg
294: ( null
295: , g_table_name
296: , 'Delete from CSL_CONTR_BUSS_PROCESSES_ACC for resource '||p_resource_id
297: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
298: , 'csl_user_pkg');
299: END IF;
300: DELETE CSL_CONTR_BUSS_PROCESSES_ACC
296: , 'Delete from CSL_CONTR_BUSS_PROCESSES_ACC for resource '||p_resource_id
297: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
298: , 'csl_user_pkg');
299: END IF;
300: DELETE CSL_CONTR_BUSS_PROCESSES_ACC
301: WHERE RESOURCE_ID = p_resource_id;
302: COMMIT;
303:
304: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN