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