212:
213: UPDATE gmd_supplier_spec_vrs
214: SET delete_mark = 1,
215: last_update_date = NVL(p_last_update_date,SYSDATE),
216: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
217: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
218: WHERE spec_vr_id = p_spec_vr_id
219: ;
220: ELSE
213: UPDATE gmd_supplier_spec_vrs
214: SET delete_mark = 1,
215: last_update_date = NVL(p_last_update_date,SYSDATE),
216: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
217: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
218: WHERE spec_vr_id = p_spec_vr_id
219: ;
220: ELSE
221: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');