206:
207: UPDATE gmd_inventory_spec_vrs
208: SET delete_mark = 1,
209: last_update_date = NVL(p_last_update_date,SYSDATE),
210: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
211: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
212: WHERE spec_vr_id = p_spec_vr_id
213: ;
214: ELSE
207: UPDATE gmd_inventory_spec_vrs
208: SET delete_mark = 1,
209: last_update_date = NVL(p_last_update_date,SYSDATE),
210: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
211: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
212: WHERE spec_vr_id = p_spec_vr_id
213: ;
214: ELSE
215: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');