195:
196: UPDATE gmd_customer_spec_vrs
197: SET delete_mark = 1,
198: last_update_date = NVL(p_last_update_date,SYSDATE),
199: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
200: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
201: WHERE spec_vr_id = p_spec_vr_id
202: ;
203: ELSE
196: UPDATE gmd_customer_spec_vrs
197: SET delete_mark = 1,
198: last_update_date = NVL(p_last_update_date,SYSDATE),
199: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
200: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
201: WHERE spec_vr_id = p_spec_vr_id
202: ;
203: ELSE
204: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');