630: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
631: jtm_message_log_pkg.Log_Msg
632: ( null
633: , g_table_name
634: , 'Delete from JTM_JTF_NOTES_ACC for resource '||p_resource_id
635: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
636: , 'csl_user_pkg');
637: END IF;
638: DELETE JTM_JTF_NOTES_ACC
634: , 'Delete from JTM_JTF_NOTES_ACC for resource '||p_resource_id
635: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
636: , 'csl_user_pkg');
637: END IF;
638: DELETE JTM_JTF_NOTES_ACC
639: WHERE RESOURCE_ID = p_resource_id;
640: COMMIT;
641:
642: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN