USP_DATAFORMTEMPLATE_ADD_ACKNOWLEDGEMENTPROCESS

The save procedure used by the add dataform template "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 sent
@LETTERCODEID	uniqueidentifier	IN	Letter
@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_ACKNOWLEDGEMENTPROCESS
            (
                @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,
                @LETTERCODEID 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.ACKNOWLEDGEMENTPROCESS
                        (ID, NAME, DESCRIPTION, IDSETREGISTERID, CREATEOUTPUTIDSET, OUTPUTIDSETRECORDTYPEID, OUTPUTIDSETNAME, OVERWRITEOUTPUTIDSET, LETTERCODEID, MARKLETTERSACKNOWLEDGED, ACKNOWLEDGEDATETYPECODE, ACKNOWLEDGEDATE, LABELFILENAME, LABELFILE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                    values
                        (@ID, @NAME, @DESCRIPTION, @IDSETREGISTERID, @CREATEOUTPUTIDSET, @OUTPUTIDSETRECORDTYPEID, @OUTPUTIDSETNAME, @OVERWRITEOUTPUTIDSET, @LETTERCODEID, @MARKLETTERSACKNOWLEDGED, @ACKNOWLEDGEDATETYPECODE, @ACKNOWLEDGEDATE, @LABELFILENAME, @LABELFILE, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

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

                            insert into dbo.ACKNOWLEDGEMENTPROCESSNAMEFORMAT
                                (    ID, 
                                    ACKNOWLEDGEMENTPROCESSID,
                                    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