USP_DATAFORMTEMPLATE_EDIT_PLEDGEREMINDERPROCESS_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
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@DESCRIPTION	nvarchar(255)	IN	Description
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@BUSINESSPROCESSVIEWID	uniqueidentifier	IN	Output format
@DATETYPECODE	tinyint	IN	Calculate amounts as of
@DATE	datetime	IN	Process date
@LETTERFILE	varbinary	IN	File
@LETTERFILENAME	nvarchar(255)	IN	Word template
@DISPLAYEDLETTERFILENAME	nvarchar(255)	IN	File
@LETTERFILECHANGED	bit	IN	File changed?
@LABELFILE	varbinary	IN	Label File
@LABELFILENAME	nvarchar(255)	IN	Label File
@DISPLAYEDLABELFILENAME	nvarchar(255)	IN	Label file
@LABELFILECHANGED	bit	IN	Label File changed?
@MARKREMINDERSSENT	bit	IN	Mark reminders sent when process completes
@SENTDATETYPECODE	tinyint	IN	Sent date
@SENTDATE	datetime	IN	Sent date
@EXCLUSIONDATETYPECODE	tinyint	IN	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	IN	Consider exclusions as of
@EXCLUDEDECEASED	bit	IN	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	IN	Exclude inactive constituents
@EXCLUSIONS	xml	IN	Exclusions
@CUSTOMPARAMETERDATAFORMITEM	xml	IN
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@ISRECURRINGGIFTS	bit	IN
@ISPLEDGES	bit	IN

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEREMINDERPROCESS_2
                    (
                    @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,                
                        @NAME nvarchar(100), 
                        @IDSETREGISTERID uniqueidentifier, 
                        @DESCRIPTION nvarchar(255), 
                        @CREATEOUTPUTIDSET bit,
                        @OUTPUTIDSETRECORDTYPEID uniqueidentifier, 
                        @OUTPUTIDSETNAME nvarchar(100), 
                        @OVERWRITEOUTPUTIDSET bit,                        
                        @BUSINESSPROCESSVIEWID uniqueidentifier,
                        @DATETYPECODE tinyint,
                        @DATE datetime,
                        @LETTERFILE varbinary(max),
                        @LETTERFILENAME nvarchar(255),
                        @DISPLAYEDLETTERFILENAME nvarchar(255),
                        @LETTERFILECHANGED bit,
                        @LABELFILE varbinary(max),
                        @LABELFILENAME nvarchar(255),
                        @DISPLAYEDLABELFILENAME nvarchar(255),
                        @LABELFILECHANGED bit,
                        @MARKREMINDERSSENT bit,
                        @SENTDATETYPECODE tinyint,
                        @SENTDATE datetime,
                        @EXCLUSIONDATETYPECODE tinyint,
                        @EXCLUSIONASOFDATE datetime,
                        @EXCLUDEDECEASED bit,
                        @EXCLUDEINACTIVE bit,
                        @EXCLUSIONS xml,
                        @CUSTOMPARAMETERDATAFORMITEM xml,
                        --@OVERRIDEREQUIREDEXCLUSIONS bit,

                        --@REQUIREDEXCLUSIONS xml,

                        @CURRENTAPPUSERID uniqueidentifier = null,
            @ISRECURRINGGIFTS bit,
            @ISPLEDGES bit
                    )
                    as
                        set nocount on

                          declare @OUTPUTGROUPINGCODE smallint;

              exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLEDGEREMINDERPROCESS_2 
                  @ID = @ID, 
                  @OUTPUTGROUPINGCODE = @OUTPUTGROUPINGCODE output;

              exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEREMINDERPROCESS_3 @ID, @CHANGEAGENTID, @NAME, @IDSETREGISTERID, @DESCRIPTION, @CREATEOUTPUTIDSET,
                  @OUTPUTIDSETRECORDTYPEID, @OUTPUTIDSETNAME, @OVERWRITEOUTPUTIDSET, @BUSINESSPROCESSVIEWID, @DATETYPECODE, @DATE, @LETTERFILE, @LETTERFILENAME,
              @DISPLAYEDLETTERFILENAME, @LETTERFILECHANGED, @LABELFILE, @LABELFILENAME, @DISPLAYEDLABELFILENAME, @LABELFILECHANGED, @MARKREMINDERSSENT, @SENTDATETYPECODE,
              @SENTDATE, @EXCLUSIONDATETYPECODE, @EXCLUSIONASOFDATE, @EXCLUDEDECEASED, @EXCLUDEINACTIVE, @EXCLUSIONS, @CUSTOMPARAMETERDATAFORMITEM, @CURRENTAPPUSERID, @ISRECURRINGGIFTS, @ISPLEDGES, @OUTPUTGROUPINGCODE;     

                        return 0;