USP_DATAFORMTEMPLATE_ADD_STEPLETTER_PRELOAD

The load procedure used by the edit dataform template "Step Letter Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@INTERACTIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ADDRESSID	uniqueidentifier	INOUT	Address
@PARAMETERID	nvarchar(37)	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@RELATIONSHIPCONSTITUENTID	uniqueidentifier	INOUT
@ADDRESSES	xml	INOUT
@MAILDATE	datetime	INOUT	Mail date
@ORGNAME	nvarchar(154)	INOUT
@ADDRESSEENAMEFORMATID	uniqueidentifier	INOUT
@SALUTATIONNAMEFORMATID	uniqueidentifier	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STEPLETTER_PRELOAD
                (
                    @INTERACTIONID uniqueidentifier,
                    @ADDRESSID uniqueidentifier = null output,
                    @PARAMETERID nvarchar(37) = null output,
                    @CONSTITUENTID uniqueidentifier = null output,
                    @RELATIONSHIPCONSTITUENTID uniqueidentifier = null output,
                    @ADDRESSES xml = null output,
                    @MAILDATE datetime = null output,
                    @ORGNAME nvarchar(154) = null output,
                    @ADDRESSEENAMEFORMATID uniqueidentifier = null output,
                    @SALUTATIONNAMEFORMATID uniqueidentifier = null output,
                    @CURRENTAPPUSERID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        @CONSTITUENTID = [INTERACTION].[CONSTITUENTID],
                        @ADDRESSID = case [ADDRESS].[DONOTMAIL] when 0 then [ADDRESS].[ID] else null end
                    from
                        dbo.[INTERACTION]
                        left join dbo.[ADDRESS] on [ADDRESS].[CONSTITUENTID] = [INTERACTION].[CONSTITUENTID] and [ADDRESS].[ISPRIMARY] = 1
                    where
                        [INTERACTION].[ID] = @INTERACTIONID;

                    set @PARAMETERID = convert(varchar(36),@CONSTITUENTID)+'1';
                    set @ADDRESSES = dbo.[UFN_CONSTITUENT_GETADDRESSES_TOITEMLISTXML](convert(varchar(36),@CONSTITUENTID)+'1');
                    set @MAILDATE = getdate();

                    exec dbo.USP_CONSTITUENTNAMEFORMATS_GETDEFAULTADDRESSEE
                        @CONSTITUENTID,
                        @CURRENTAPPUSERID,
                        @ADDRESSEENAMEFORMATID output,
                        @SALUTATIONNAMEFORMATID output;

                    return 0;