473: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN
474: jtm_message_log_pkg.Log_Msg
475: ( null
476: , g_table_name
477: , 'Delete from CSL_SR_CONTRACT_HEADERS_ACC for resource '||p_resource_id
478: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
479: , 'csl_user_pkg');
480: END IF;
481: DELETE CSL_SR_CONTRACT_HEADERS_ACC
477: , 'Delete from CSL_SR_CONTRACT_HEADERS_ACC for resource '||p_resource_id
478: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM
479: , 'csl_user_pkg');
480: END IF;
481: DELETE CSL_SR_CONTRACT_HEADERS_ACC
482: WHERE RESOURCE_ID = p_resource_id;
483: COMMIT;
484:
485: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN