USP_DATAFORMTEMPLATE_ADD_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_2

The save procedure used by the add dataform template "Planned Gift Acknowledgement Process Add Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@LABELFILENAME	nvarchar(255)	IN	Mailing label template
@LABELFILE	varbinary	IN	LABELFILE
@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
@MARKLETTERSACKNOWLEDGED	bit	IN	Mark letters 'Acknowledged' when process completes
@PLANNEDGIFTLETTERCODEID	uniqueidentifier	IN	Acknowledge planned gifts with letter
@ACKNOWLEDGEDATETYPECODE	tinyint	IN	Acknowledge date
@ACKNOWLEDGEDATE	datetime	IN	Acknowledge 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
@SITEID	uniqueidentifier	IN	Site

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_2
                    (
                        @ID uniqueidentifier = null output,                        
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,    
                        @NAME nvarchar(100)='', 
                        @IDSETREGISTERID uniqueidentifier = null, 
                        @LABELFILENAME nvarchar(255) = '',
                        @LABELFILE varbinary(max) = null,
                        @DESCRIPTION nvarchar(255)='', 
                        @CREATEOUTPUTIDSET bit = 0,
                        @OUTPUTIDSETRECORDTYPEID uniqueidentifier = null, 
                        @OUTPUTIDSETNAME nvarchar(100) = '', 
                        @OVERWRITEOUTPUTIDSET bit = 0,
                        @MARKLETTERSACKNOWLEDGED bit = 0,
                        @PLANNEDGIFTLETTERCODEID uniqueidentifier = null,
                        @ACKNOWLEDGEDATETYPECODE tinyint = 0,
                        @ACKNOWLEDGEDATE datetime = null,
                        @EXCLUSIONDATETYPECODE tinyint = 0,
                        @EXCLUSIONASOFDATE datetime = null,
                        @EXCLUDEDECEASED bit = 1,
                        @EXCLUDEINACTIVE bit = 1,
                        @EXCLUSIONS xml = null,
                        @SITEID uniqueidentifier = null
                        --@OVERRIDEREQUIREDEXCLUSIONS bit = 0,

                        --@REQUIREDEXCLUSIONS xml = null

                    )
                    as
                    begin
                        set nocount on;

                        declare @CURRENTDATE datetime;                                    

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

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

                        set @CURRENTDATE = getdate();

                        begin try
                            if (@SITEID is not null) 
                            begin
                                if dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, @SITEID) = 0 begin
                                    raiserror ('ERR_SITE_NOACCESS',13,1);
                                    return 1;
                                end
                            end

                            insert into dbo.PLANNEDGIFTACKNOWLEDGEMENTPROCESS
                                (ID, NAME, DESCRIPTION, IDSETREGISTERID, CREATEOUTPUTIDSET, OUTPUTIDSETRECORDTYPEID, OUTPUTIDSETNAME, OVERWRITEOUTPUTIDSET, PLANNEDGIFTLETTERCODEID, MARKLETTERSACKNOWLEDGED, ACKNOWLEDGEDATETYPECODE, ACKNOWLEDGEDATE, LABELFILENAME, LABELFILE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                            values
                                (@ID, @NAME, @DESCRIPTION, @IDSETREGISTERID, @CREATEOUTPUTIDSET, @OUTPUTIDSETRECORDTYPEID, @OUTPUTIDSETNAME, @OVERWRITEOUTPUTIDSET, @PLANNEDGIFTLETTERCODEID, @MARKLETTERSACKNOWLEDGED, @ACKNOWLEDGEDATETYPECODE, @ACKNOWLEDGEDATE, @LABELFILENAME, @LABELFILE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

                            exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD @CHANGEAGENTID = @CHANGEAGENTID, 
                                                                    @BUSINESSPROCESSCATALOGID = '8C332468-7D1F-4434-9ECD-C828FC3B6099', 
                                                                    @BUSINESSPROCESSPARAMETERSETID = @ID, 
                                                                    @OWNERID = @CURRENTAPPUSERID, @SITEID = @SITEID;

                            exec dbo.USP_BUSINESSPROCESSCOMMPREF_ADD @CHANGEAGENTID = @CHANGEAGENTID,
                                                                    @BUSINESSPROCESSCATALOGID = '8C332468-7D1F-4434-9ECD-C828FC3B6099',
                                                                    @BUSINESSPROCESSPARAMETERSETID = @ID,
                                                                    @EXCLUSIONDATETYPECODE = @EXCLUSIONDATETYPECODE,
                                                                    @EXCLUSIONASOFDATE = @EXCLUSIONASOFDATE,
                                                                    @EXCLUDEDECEASED = @EXCLUDEDECEASED,
                                                                    @EXCLUDEINACTIVE = @EXCLUDEINACTIVE,
                                                                    @EXCLUSIONS = @EXCLUSIONS,
                                                                    --@OVERRIDEREQUIREDEXCLUSIONS = @OVERRIDEREQUIREDEXCLUSIONS,

                                                                    --@REQUIREDEXCLUSIONS = @REQUIREDEXCLUSIONS,

                                                                    @CURRENTAPPUSERID = @CURRENTAPPUSERID;

                        end try

                        begin catch
                            exec dbo.USP_RAISE_ERROR;
                            return 1;
                        end catch

                        return 0;
                    end