USP_DATAFORMTEMPLATE_EDIT_R68ONLINESUBMISSIONPREPROCESS

            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_R68ONLINESUBMISSIONPREPROCESS 
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @SETTINGSID uniqueidentifier,
                @SENDERSETTINGSID uniqueidentifier
            )
            as

                set nocount on;

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                begin try
                    -- handle updating the data

                    update dbo.R68ONLINESUBMISSIONPARAMETERS 
                    set
                        R68ONLINESUBMISSIONSETTINGSSENDERINFOID = @SENDERSETTINGSID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where ID = @ID
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

            return 0;