USP_DATAFORMTEMPLATE_EDIT_COMMITMULTIPLEBATCHES2PROCESS

Backwards compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_COMMITMULTIPLEBATCHES2PROCESS_2

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.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(1000)	IN	Description
@COMMITEDIT	tinyint	IN	Commit
@SELECTIONID	uniqueidentifier	IN	Selection
@CREATEOUTPUTSELECTION	bit	IN	Create output selections
@CREATEEXCEPTIONBATCHES	bit	IN	Create exception batches
@PURGEBATCHES	bit	IN	Delete batches after commit
@CREATEBATCHCONTROLREPORTS	bit	IN	Create control reports

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_COMMITMULTIPLEBATCHES2PROCESS
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @NAME nvarchar(100),
                @DESCRIPTION nvarchar(1000),
                @COMMITEDIT tinyint,
                @SELECTIONID uniqueidentifier,
                @CREATEOUTPUTSELECTION bit,
                @CREATEEXCEPTIONBATCHES bit,
                @PURGEBATCHES bit,
                @CREATEBATCHCONTROLREPORTS bit
            )
            as
            set nocount on;

            declare @CURRENTAPPUSERID uniqueidentifier = null;
            declare @SITEID uniqueidentifier = null;

            begin try
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COMMITMULTIPLEBATCHES2PROCESS
                    @ID = @ID, 
                    @SITEID = @SITEID output;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_COMMITMULTIPLEBATCHES2PROCESS_2
                    @ID = @ID,
                    @CHANGEAGENTID = @CHANGEAGENTID,
                    @NAME = @NAME,
                    @DESCRIPTION = @DESCRIPTION,
                    @COMMITEDIT = @COMMITEDIT,
                    @SELECTIONID = @SELECTIONID,
                    @CREATEOUTPUTSELECTION = @CREATEOUTPUTSELECTION,
                    @CREATEEXCEPTIONBATCHES = @CREATEEXCEPTIONBATCHES,
                    @PURGEBATCHES = @PURGEBATCHES,
                    @CREATEBATCHCONTROLREPORTS = @CREATEBATCHCONTROLREPORTS,
                    @CURRENTAPPUSERID = @CURRENTAPPUSERID,
                    @SITEID = @SITEID;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
                return 1;
            end catch
            return 0;