CREATE PROCEDURE [dbo].[MssWebUpdateInternationalContainer]
    @inOrdersFID int,
    @inInternationalContainerID int,
    @inInternationalContainerLoadTypeFID int,
    @inContainerNumber varchar(32),
    @inPieces int,
    @inGrossWeight int,
    @inTareWeight int,
    @inNetWeight int,
    @inSealNumber varchar(32),
    @inCubicFeet int,
    @inRequiredDate date,
    @inPositionedDate date,
    @inLoadedDate date,
    @inEmptyDate date,
    @inReturnedDate date,
    @inSealNumber2 varchar(32),
    @inInternationalContainerSizeTypeFID int,
    @inAutoInContainer bit
as
begin

    set nocount on
    
    update InternationalContainer
    set
        InternationalContainerLoadTypeFId = @inInternationalContainerLoadTypeFId,
        ContainerNumber = @inContainerNumber,
        Pieces = @inPieces,
        GrossWeight = @inGrossWeight,
        TareWeight = @inTareWeight,
        NetWeight = @inNetWeight,
        SealNumber = @inSealNumber,
        CubicFeet = @inCubicFeet,
        RequiredDate = @inRequiredDate,
        PositionedDate = @inPositionedDate,
        LoadedDate = @inLoadedDate,
        EmptyDate = @inEmptyDate,
        ReturnedDate = @inReturnedDate,
        SealNumber2 = @inSealNumber2,
        InternationalContainerSizeTypeFID = @inInternationalContainerSizeTypeFID,
        AutoInContainer = @inAutoInContainer
    where OrdersFID = @inOrdersFID and InternationalContainerID = @inInternationalContainerID

end
GO
GRANT EXECUTE ON  [dbo].[MssWebUpdateInternationalContainer] TO [MssExec]
GO