181:
182: UPDATE gmd_monitoring_spec_vrs
183: SET delete_mark = 1,
184: last_update_date = NVL(p_last_update_date,SYSDATE),
185: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
186: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
187: WHERE spec_vr_id = p_spec_vr_id
188: ;
189: ELSE
182: UPDATE gmd_monitoring_spec_vrs
183: SET delete_mark = 1,
184: last_update_date = NVL(p_last_update_date,SYSDATE),
185: last_updated_by = NVL(p_last_updated_by,FND_GLOBAL.USER_ID),
186: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
187: WHERE spec_vr_id = p_spec_vr_id
188: ;
189: ELSE
190: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');