USP_DATAFORMTEMPLATE_EDIT_GENERATETRANSACTIONSPREPROCESS_1_1

Backwards compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_GENERATETRANSACTIONSPREPROCESS_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.
@CUTOFFDATE datetime IN Generate payments due on or before
@BATCHTEMPLATEID uniqueidentifier IN Batch template
@BATCHNUMBER nvarchar(100) IN Batch number
@OWNERID uniqueidentifier IN Batch owner

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GENERATETRANSACTIONSPREPROCESS_1_1
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CUTOFFDATE datetime,
                @BATCHTEMPLATEID uniqueidentifier,
                @BATCHNUMBER nvarchar(100),
                @OWNERID uniqueidentifier
            )
            as
            set nocount on;

            declare @OVERRIDEBATCHNUMBER bit = 0;
            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GENERATETRANSACTIONSPREPROCESS_1_1 
                @ID = @ID,
                @OVERRIDEBATCHNUMBER = @OVERRIDEBATCHNUMBER output;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_GENERATETRANSACTIONSPREPROCESS_2
                @ID = @ID,
                @CHANGEAGENTID = @CHANGEAGENTID,
                @CUTOFFDATE = @CUTOFFDATE,
                @BATCHTEMPLATEID = @BATCHTEMPLATEID,
                @BATCHNUMBER = @BATCHNUMBER,
                @OWNERID = @OWNERID,
                @OVERRIDEBATCHNUMBER = @OVERRIDEBATCHNUMBER,
                @CURRENTAPPUSERID = null;