240:
241: UPDATE gmd_wip_spec_vrs
242: SET delete_mark = 1,
243: last_update_date = NVL(p_last_update_date,SYSDATE),
244: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
245: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
246: WHERE spec_vr_id = p_spec_vr_id
247: ;
248: ELSE
241: UPDATE gmd_wip_spec_vrs
242: SET delete_mark = 1,
243: last_update_date = NVL(p_last_update_date,SYSDATE),
244: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
245: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
246: WHERE spec_vr_id = p_spec_vr_id
247: ;
248: ELSE
249: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_WIP_SPEC_VRS');