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
@OVERRIDEBATCHNUMBER	bit	IN	Override
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_GENERATETRANSACTIONSPREPROCESS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CUTOFFDATE datetime,
    @BATCHTEMPLATEID uniqueidentifier,
    @BATCHNUMBER nvarchar(100),
    @OWNERID uniqueidentifier,
    @OVERRIDEBATCHNUMBER bit,
    @CURRENTAPPUSERID uniqueidentifier
)

as
  set nocount on;

    declare @CONSOLIDATEPAYMENTS bit = null;
    declare @DUEDATETYPECODE tinyint = null;
    declare @DAYSAFTER integer = null;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GENERATETRANSACTIONSPREPROCESS_1_1
        @ID = @ID,
        @CONSOLIDATEPAYMENTS = @CONSOLIDATEPAYMENTS output,
        @DUEDATETYPECODE = @DUEDATETYPECODE output,
        @DAYSAFTER = @DAYSAFTER output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_GENERATETRANSACTIONSPREPROCESS_3
        @ID,
        @CHANGEAGENTID,
        @CUTOFFDATE,
        @BATCHTEMPLATEID,
        @BATCHNUMBER,
        @OWNERID,
        @OVERRIDEBATCHNUMBER,
        @CURRENTAPPUSERID,
        @DUEDATETYPECODE,
        @DAYSAFTER,
        @CONSOLIDATEPAYMENTS

  return 0;