update CMGT_MATERIAL_PURCHASING_DETAIL set IS_DELE_ = '1' where PURCHASING_ID_ = #{pId} and IS_DELE_ = '0'