USP_DATAFORMTEMPLATE_EDITLOAD_INVITATION

The load procedure used by the edit dataform template "Invitation Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@BUSINESSPROCESSVIEWID	uniqueidentifier	INOUT	Output format
@BUSINESSPROCESSOUTPUTDATALISTIDS	xml	INOUT
@EVENTNAME	nvarchar(100)	INOUT	Event
@MAILDATE	datetime	INOUT	Mail date
@CREATEOUTPUTIDSET	bit	INOUT	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@CUSTOMPARAMETERDATAFORMITEM	xml	INOUT
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@CHANNELCODE	tinyint	INOUT
@CHANNELPREFERENCECODE	tinyint	INOUT	If the constituent does not have a preference, attempt to send
@MAILPACKAGEID	uniqueidentifier	INOUT	Mail package
@EMAILPACKAGEID	uniqueidentifier	INOUT	Email package
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT	Address processing
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT	Name format
@HOUSEHOLDINGTYPECODE	tinyint	INOUT	Include
@HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD	bit	INOUT	Also include qualifying individuals who are not members of any household
@HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS	bit	INOUT	Also include qualifying households which do not have any members
@HOUSEHOLDINGONERECORDPERHOUSEHOLD	bit	INOUT	Send to one person per household
@EVENTID	uniqueidentifier	INOUT	EVENTID

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_INVITATION
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(100) = null output,
    @DESCRIPTION nvarchar(255) = null output,
    @BUSINESSPROCESSVIEWID uniqueidentifier = null output,
  @BUSINESSPROCESSOUTPUTDATALISTIDS xml = null output,
  @EVENTNAME nvarchar(100) = null output,
    @MAILDATE datetime = null output,
    @CREATEOUTPUTIDSET bit = null output,
    @OUTPUTIDSETNAME nvarchar(100) = null output,
    @OVERWRITEOUTPUTIDSET bit = null output,       
  @CUSTOMPARAMETERDATAFORMITEM xml = null output,                                                                                                                             
  @TSLONG bigint = 0 output,
  @CHANNELCODE tinyint = null output,
  @CHANNELPREFERENCECODE tinyint = null output,
  @MAILPACKAGEID uniqueidentifier = null output,
  @EMAILPACKAGEID uniqueidentifier = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output,
  @HOUSEHOLDINGTYPECODE tinyint = null output,
  @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD bit = null output,
  @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS bit = null output,
  @HOUSEHOLDINGONERECORDPERHOUSEHOLD bit = null output,
  @EVENTID uniqueidentifier = null output
)
as
  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  select
    @DATALOADED = 1,
    @TSLONG = INVITATION.TSLONG,
    @NAME = INVITATION.NAME,
        @DESCRIPTION = INVITATION.DESCRIPTION,
      @BUSINESSPROCESSVIEWID = INVITATION.BUSINESSPROCESSVIEWID,
    @EVENTNAME = dbo.UFN_EVENT_GETNAME(INVITATION.EVENTID),
        @MAILDATE = INVITATION.MAILDATE,
        @CREATEOUTPUTIDSET = MKTSEGMENTATION.CREATEOUTPUTIDSET,
        @OUTPUTIDSETNAME = MKTSEGMENTATION.OUTPUTIDSETNAME,
        @OVERWRITEOUTPUTIDSET = MKTSEGMENTATION.OVERWRITEOUTPUTIDSET,
    @CUSTOMPARAMETERDATAFORMITEM = INVITATION.CUSTOMPARAMETERDATAFORMITEM,
    @CHANNELCODE = INVITATION.CHANNELCODE,
    @CHANNELPREFERENCECODE = INVITATION.CHANNELPREFERENCECODE,
    @MAILPACKAGEID = INVITATION.MAILPACKAGEID,
    @EMAILPACKAGEID = INVITATION.EMAILPACKAGEID,
    @ADDRESSPROCESSINGOPTIONID = INVITATION.ADDRESSPROCESSINGOPTIONID,
    @NAMEFORMATPARAMETERID = INVITATION.NAMEFORMATPARAMETERID,
    @HOUSEHOLDINGTYPECODE = INVITATION.HOUSEHOLDINGTYPECODE,
    @HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD = INVITATION.HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD,
    @HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS = INVITATION.HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS,
    @HOUSEHOLDINGONERECORDPERHOUSEHOLD = INVITATION.HOUSEHOLDINGONERECORDPERHOUSEHOLD,
    @EVENTID = INVITATION.EVENTID
  from dbo.INVITATION 
  left join dbo.MKTSEGMENTATION
    on INVITATION.ID = MKTSEGMENTATION.ID
  where
    INVITATION.ID = @ID;

  if not @BUSINESSPROCESSVIEWID is null
    -- Set the default values for Address Processing Option and Name Format

    --    If this is the first time the invitation has been edited since upgrading

    begin
      select top(1) 
        @ADDRESSPROCESSINGOPTIONID = ADDRESSPROCESSINGOPTION.ID 
      from dbo.[ADDRESSPROCESSINGOPTION] 
      where [ISDEFAULT] = 1 
        and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, ADDRESSPROCESSINGOPTION.SITEID) = 1;

      select top(1) 
        @NAMEFORMATPARAMETERID = [ID] 
      from dbo.[NAMEFORMATPARAMETER] 
      where NAMEFORMATPARAMETER.ISDEFAULT = 1 
        and dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, NAMEFORMATPARAMETER.SITEID) = 1;
    end

  return 0;