add stored procedures for parts