CREATE PROCEDURE [dbo].[MssWebCreateInternationalVesselVoyage]
    @inOrdersFID 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
    
    declare @id int
    
      insert into InternationalVoyage
      (
        OrdersFID,
        InternationalPortFID,
        Name,
        EstimatedDepartureDate,
        ActualDepartureDate,
        EstimatedArrivalDate,
        ActualArrivalDate,
        InternationalOriginPortFID
      )
    select
        @inOrdersFID,
        @inInternationalPortFID,
        @inName,
        @inEstimatedDepartureDate,
        @inActualDepartureDate,
        @inEstimatedArrivalDate,
        @inActualArrivalDate,
        @inInternationalOriginPortFID

    set @id = SCOPE_IDENTITY()

    select @id

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