388: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
389: jtm_message_log_pkg.Log_Msg
390: ( null
391: , g_table_name
392: , 'Delete from CSL_HZ_LOCATIONS_ACC for resource '||p_resource_id
393: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
394: , 'csl_user_pkg');
395: END IF;
396: DELETE CSL_HZ_LOCATIONS_ACC
392: , 'Delete from CSL_HZ_LOCATIONS_ACC for resource '||p_resource_id
393: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
394: , 'csl_user_pkg');
395: END IF;
396: DELETE CSL_HZ_LOCATIONS_ACC
397: WHERE RESOURCE_ID = p_resource_id;
398: COMMIT;
399:
400: