425: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
426: jtm_message_log_pkg.Log_Msg
427: ( null
428: , g_table_name
429: , 'Delete from CSL_HZ_RELATIONSHIPS_ACC for resource '||p_resource_id
430: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
431: , 'csl_user_pkg');
432: END IF;
433: DELETE CSL_HZ_RELATIONSHIPS_ACC
429: , 'Delete from CSL_HZ_RELATIONSHIPS_ACC for resource '||p_resource_id
430: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
431: , 'csl_user_pkg');
432: END IF;
433: DELETE CSL_HZ_RELATIONSHIPS_ACC
434: WHERE RESOURCE_ID = p_resource_id;
435: COMMIT;
436:
437: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN