ALTER PROCEDURE [dbo].[RoutePlan_Save]

(
    @RoutePlanId int,
    @FormId int,
    @UserId int,
    @Rank int,
    @RoutePlanStatusId int = NULL,
    @StatusDate datetime = NULL,
    @Notes varchar(500) = NULL,
    @IsStrict bit,
    @RoutePlanResponsibilityId int,
    @IsPostApproval bit,
    @ProcessedByUserId int = NULL,
    @Deleted bit,
    @CreatedById int = NULL,
    @ModifiedById int = NULL
)
AS
BEGIN

    SET NOCOUNT ON

    DECLARE @PrivateErrorVar int
    DECLARE @localRoutePlanId int
    DECLARE @localFormId int
    DECLARE @localUserId int
    DECLARE @localRank int
    DECLARE @localRoutePlanStatusId int
    DECLARE @localStatusDate datetime
    DECLARE @localNotes varchar(500)
    DECLARE @localIsStrict bit
    DECLARE @localRoutePlanResponsibilityId int
    DECLARE @localIsPostApproval bit
    DECLARE @localProcessedByUserId int
    DECLARE @localDeleted bit
    DECLARE @localCreatedById int
    DECLARE @localModifiedById int
    SET @localRoutePlanId = @RoutePlanId
    SET @localFormId = @FormId
    SET @localUserId = @UserId
    SET @localRank = @Rank
    SET @localRoutePlanStatusId = @RoutePlanStatusId
    SET @localStatusDate = @StatusDate
    SET @localNotes = @Notes
    SET @localIsStrict = @IsStrict
    SET @localRoutePlanResponsibilityId = @RoutePlanResponsibilityId
    SET @localIsPostApproval = @IsPostApproval
    SET @localProcessedByUserId = @ProcessedByUserId
    SET @localDeleted = @Deleted
    SET @localCreatedById = @CreatedById
    SET @localModifiedById = @ModifiedById

    IF EXISTS(SELECT [RoutePlan].[RoutePlanId] FROM [RoutePlan] WHERE
            ([RoutePlan].[RoutePlanId] = @localRoutePlanId))
    BEGIN


        UPDATE [RoutePlan]
        SET
            [RoutePlan].[FormId] = @localFormId,
            [RoutePlan].[UserId] = @localUserId,
            [RoutePlan].[Rank] = @localRank,
            [RoutePlan].[RoutePlanStatusId] = @localRoutePlanStatusId,
            [RoutePlan].[StatusDate] = @localStatusDate,
            [RoutePlan].[Notes] = @localNotes,
            [RoutePlan].[IsStrict] = @localIsStrict,
            [RoutePlan].[RoutePlanResponsibilityId] = @localRoutePlanResponsibilityId,
            [RoutePlan].[IsPostApproval] = @localIsPostApproval,
            [RoutePlan].[ProcessedByUserId] = @localProcessedByUserId,
            [RoutePlan].[Deleted] = @localDeleted,
            [RoutePlan].[ModifiedById] = @localModifiedById,
            [RoutePlan].[ModifiedDate] = GETDATE()
        WHERE
        [RoutePlan].[RoutePlanId] = @localRoutePlanId

        SET @PrivateErrorVar = @@Error


    END
    ELSE
    BEGIN

        INSERT
        INTO [RoutePlan]
        (
            [RoutePlan].[FormId],
            [RoutePlan].[UserId],
            [RoutePlan].[Rank],
            [RoutePlan].[RoutePlanStatusId],
            [RoutePlan].[StatusDate],
            [RoutePlan].[Notes],
            [RoutePlan].[IsStrict],
            [RoutePlan].[RoutePlanResponsibilityId],
            [RoutePlan].[IsPostApproval],
            [RoutePlan].[ProcessedByUserId],
            [RoutePlan].[Deleted],
            [RoutePlan].[CreatedById],
            [RoutePlan].[CreatedDate]
        )
        VALUES
        (
            @localFormId,
            @localUserId,
            @localRank,
            @localRoutePlanStatusId,
            @localStatusDate,
            @localNotes,
            @localIsStrict,
            @localRoutePlanResponsibilityId,
            @localIsPostApproval,
            @localProcessedByUserId,
            @localDeleted,
            @localCreatedById,
            GETDATE()
        )

        SET @PrivateErrorVar = @@Error

        SELECT @localRoutePlanId = SCOPE_IDENTITY()


    END
    --*** Return the PK
    SELECT @localRoutePlanId
    RETURN @PrivateErrorVar
END