USP_DATAFORMTEMPLATE_EDITSAVE_EXCHANGECALENDARITEMBATCHROW_2

Backwards compatible save procedure for Exchange Calendar Item batch records.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PROCESS	bit	IN	Process
@SEQUENCE	int	IN	Sequence
@RECORDTYPECODE	int	IN	Record type

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_EXCHANGECALENDARITEMBATCHROW_2
            (
                @ID uniqueidentifier, 
                @CHANGEAGENTID uniqueidentifier,
                @PROCESS bit,
                @SEQUENCE int,
                @RECORDTYPECODE int
            )
            as 
            set nocount on;

            declare @CHANGEDATE datetime

            if @ID is null
                set @ID = NewID();

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

            set @CHANGEDATE = getdate();

            declare @INTERACTIONID uniqueidentifier = null;
            declare @STEWARDSHIPSTEPID uniqueidentifier = null;
            declare @CONSTITUENTID uniqueidentifier = null;
            declare @OWNERID uniqueidentifier = null;
            declare @EXPECTEDDATE datetime = null;
            declare @OBJECTIVE nvarchar(256) = null;

            begin try
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECALENDARITEMBATCHROW_2 
                        @ID = @ID,
                        @INTERACTIONID = @INTERACTIONID output,
                        @STEWARDSHIPSTEPID = @STEWARDSHIPSTEPID output,
                        @CONSTITUENTID = @CONSTITUENTID output,
                        @OWNERID = @OWNERID output,                  
                        @EXPECTEDDATE = @EXPECTEDDATE output,
                        @OBJECTIVE = @OBJECTIVE output;

                exec dbo.USP_DATAFORMTEMPLATE_EDITSAVE_EXCHANGECALENDARITEMBATCHROW_3
                        @ID, 
                        @CHANGEAGENTID,
                        @PROCESS,
                        @SEQUENCE,
                        @RECORDTYPECODE,
                        @CONSTITUENTID,
                        @OWNERID,
                        @EXPECTEDDATE,
                        @OBJECTIVE,
                        @INTERACTIONID,
                        @STEWARDSHIPSTEPID;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch

            return 0;