401: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
402: jtm_message_log_pkg.Log_Msg
403: ( null
404: , g_table_name
405: , 'Delete from CSL_HZ_PARTIES_ACC for resource '||p_resource_id
406: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
407: , 'csl_user_pkg');
408: END IF;
409: DELETE CSL_HZ_PARTIES_ACC
405: , 'Delete from CSL_HZ_PARTIES_ACC for resource '||p_resource_id
406: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
407: , 'csl_user_pkg');
408: END IF;
409: DELETE CSL_HZ_PARTIES_ACC
410: WHERE RESOURCE_ID = p_resource_id;
411: COMMIT;
412:
413: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN