create procedure [dbo].[MssWebRemoveLocalServiceOriginDestinationLocation]
    @inOrderId int,
    @inLocalServiceId int,
    @inLocationId int
as
begin
    set nocount on

    -- remove origin from local service if matched with the locationId
    update LocServ
    set OriginOrderLocationFID = null
    where LocServ.OrdPriKey = @inOrderId and LocServ.PriKey =@inLocalServiceId and LocServ.OriginOrderLocationFID = @inLocationId;
    -- remove destination from local service if matched with the locationId    
    update LocServ
    set DestinationOrderLocationFID = null
    where LocServ.OrdPriKey = @inOrderId and LocServ.PriKey =@inLocalServiceId and LocServ.DestinationOrderLocationFID = @inLocationId;        
end
GO
GRANT EXECUTE ON  [dbo].[MssWebRemoveLocalServiceOriginDestinationLocation] TO [MssExec]
GO