CREATE PROCEDURE [dbo].[MssWebUpdateInternationalVesselVoyage]
    @inOrdersFID int,
    @inInternationalVesselVoyageId int,
    @inInternationalPortFID int = null,
    @inName varchar(64),
    @inEstimatedDepartureDate date = null,
    @inActualDepartureDate date = null,
    @inEstimatedArrivalDate date = null,
    @inActualArrivalDate date = null,
    @inInternationalOriginPortFID int = null
as
begin

    set nocount on
    
    update InternationalVoyage
    set
        InternationalPortFID = @inInternationalPortFID,
        Name = @inName,
        EstimatedDepartureDate = @inEstimatedDepartureDate,
        ActualDepartureDate = @inActualDepartureDate,
        EstimatedArrivalDate = @inEstimatedArrivalDate,
        ActualArrivalDate = @inActualArrivalDate,
        InternationalOriginPortFID = @inInternationalOriginPortFID
    where OrdersFID = @inOrdersFID and InternationalVoyageID = @inInternationalVesselVoyageId

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