update stored procedure class, delete legacy code