USP_DATAFORMTEMPLATE_ADD_PLANNEDGIFTACKNOWLEDGEMENTPROCESS

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@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
@PLANNEDGIFTLETTERCODEID	uniqueidentifier	IN	Letter code
@ACKNOWLEDGEDATETYPECODE	tinyint	IN	Acknowledge date
@ACKNOWLEDGEDATE	datetime	IN	Acknowledge date
@HASNAMEFORMATS	bit	IN
@ADDRESSEEFORMATID	uniqueidentifier	IN	Use this format, if defined:
@ALTADDRESSEEFORMATID	uniqueidentifier	IN	Otherwise, use this format:
@ADDRESSEEFUNCTIONID	uniqueidentifier	IN	Addressee system format:
@SALUTATIONFORMATID	uniqueidentifier	IN	Use this format, if defined:
@ALTSALUTATIONFORMATID	uniqueidentifier	IN	Otherwise, use this format:
@SALUTATIONFUNCTIONID	uniqueidentifier	IN	Salutation system format:
@CONTACTADDRESSEEFORMATID	uniqueidentifier	IN	Use this format, if defined:
@ALTCONTACTADDRESSEEFORMATID	uniqueidentifier	IN	Otherwise, use this format:
@CONTACTADDRESSEEFUNCTIONID	uniqueidentifier	IN	Contact addressee system format:
@ORGSALUTATIONCODE	tinyint	IN	Organization salutation
@CONTACTSALUTATIONFORMATID	uniqueidentifier	IN	Use this format, if defined:
@ALTCONTACTSALUTATIONFORMATID	uniqueidentifier	IN	Otherwise, use this format:
@CONTACTSALUTATIONFUNCTIONID	uniqueidentifier	IN	Contact salutation system format:
@CONTACTSALUTATIONOPTIONCODE	tinyint	IN	If contact is not available, use:
@CUSTOMNAME	nvarchar(100)	IN	Custom name
@USEADDRESSEEFORMAT	bit	IN	Use the pre-defined name formats for addressee
@USESALUTATIONFORMAT	bit	IN	Use the pre-defined name formats for salutation
@USECONTACTADDRESSEEFORMAT	bit	IN	Use the pre-defined name formats for addressee
@USEADDRESSEESYSTEMFUNCTION	bit	IN	Use a system function to build the name formats for addressee
@USESALUTATIONSYSTEMFUNCTION	bit	IN	Use a system function to build the name formats for salutation
@USECONTACTADDRESSEESYSTEMFUNCTION	bit	IN	Use a system function to build the name formats for addressee
@USECONTACTSALUTATIONSYSTEMFUNCTION	bit	IN	Use a system function to build the name formats for salutation
@USECONTACTSALUTATIONFORMAT	bit	IN	Use the pre-defined name formats for salutation

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PLANNEDGIFTACKNOWLEDGEMENTPROCESS
                    (
                        @ID uniqueidentifier = null output,                        
                        @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,
                        @HASNAMEFORMATS bit = 0,
                        @ADDRESSEEFORMATID uniqueidentifier = null,
                        @ALTADDRESSEEFORMATID uniqueidentifier = null,
                        @ADDRESSEEFUNCTIONID uniqueidentifier = null,
                        @SALUTATIONFORMATID uniqueidentifier = null,
                        @ALTSALUTATIONFORMATID uniqueidentifier = null,
                        @SALUTATIONFUNCTIONID uniqueidentifier = null,
                        @CONTACTADDRESSEEFORMATID uniqueidentifier = null,
                        @ALTCONTACTADDRESSEEFORMATID uniqueidentifier = null,
                        @CONTACTADDRESSEEFUNCTIONID uniqueidentifier = null,
                        @ORGSALUTATIONCODE tinyint = 0,
                        @CONTACTSALUTATIONFORMATID uniqueidentifier = null,
                        @ALTCONTACTSALUTATIONFORMATID uniqueidentifier = null,
                        @CONTACTSALUTATIONFUNCTIONID uniqueidentifier = null,
                        @CONTACTSALUTATIONOPTIONCODE tinyint = 0,
                        @CUSTOMNAME nvarchar(100) = '',
                        @USEADDRESSEEFORMAT bit = 0,
                        @USESALUTATIONFORMAT bit = 0,
                        @USECONTACTADDRESSEEFORMAT bit = 0,
                        @USEADDRESSEESYSTEMFUNCTION bit = 0,
                        @USESALUTATIONSYSTEMFUNCTION bit = 0,
                        @USECONTACTADDRESSEESYSTEMFUNCTION bit = 0,
                        @USECONTACTSALUTATIONSYSTEMFUNCTION bit = 0,
                        @USECONTACTSALUTATIONFORMAT bit = 0
                    )
                    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
                            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);

                            if @HASNAMEFORMATS = 1
                            begin
                            declare @NAMEFORMATID uniqueidentifier;
                            set @NAMEFORMATID = newid();

                            insert into dbo.PLANNEDGIFTACKNOWLEDGEMENTPROCESSNAMEFORMAT
                                (    ID, 
                                    PLANNEDGIFTACKNOWLEDGEMENTPROCESSID,
                                    ADDRESSEEFORMATID,
                                    ALTADDRESSEEFORMATID,
                                    ADDRESSEEFUNCTIONID,
                                    SALUTATIONFORMATID,
                                    ALTSALUTATIONFORMATID,
                                    SALUTATIONFUNCTIONID,
                                    CONTACTADDRESSEEFORMATID,
                                    ALTCONTACTADDRESSEEFORMATID,
                                    CONTACTADDRESSEEFUNCTIONID,
                                    ORGSALUTATIONCODE,
                                    CONTACTSALUTATIONFORMATID,
                                    ALTCONTACTSALUTATIONFORMATID,
                                    CONTACTSALUTATIONFUNCTIONID,
                                    CONTACTSALUTATIONOPTIONCODE,
                                    CUSTOMNAME,
                                    USEADDRESSEEFORMAT,
                                    USESALUTATIONFORMAT,
                                    USECONTACTADDRESSEEFORMAT,
                                    USECONTACTSALUTATIONFORMAT,
                                    ADDEDBYID, 
                                    CHANGEDBYID, 
                                    DATEADDED, 
                                    DATECHANGED)
                            values
                                (    @NAMEFORMATID,
                                    @ID, 
                                    @ADDRESSEEFORMATID,
                                    @ALTADDRESSEEFORMATID,
                                    @ADDRESSEEFUNCTIONID,
                                    @SALUTATIONFORMATID,
                                    @ALTSALUTATIONFORMATID,
                                    @SALUTATIONFUNCTIONID,
                                    @CONTACTADDRESSEEFORMATID,
                                    @ALTCONTACTADDRESSEEFORMATID,
                                    @CONTACTADDRESSEEFUNCTIONID,
                                    @ORGSALUTATIONCODE,
                                    @CONTACTSALUTATIONFORMATID,
                                    @ALTCONTACTSALUTATIONFORMATID,
                                    @CONTACTSALUTATIONFUNCTIONID,
                                    @CONTACTSALUTATIONOPTIONCODE,
                                    @CUSTOMNAME,
                                    @USEADDRESSEEFORMAT,
                                    @USESALUTATIONFORMAT,
                                    @USECONTACTADDRESSEEFORMAT,
                                    @USECONTACTSALUTATIONFORMAT,
                                    @CHANGEAGENTID, 
                                    @CHANGEAGENTID, 
                                    @CURRENTDATE, 
                                    @CURRENTDATE);
                            end
                        end try

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

                        return 0;
                    end