USP_DATAFORMTEMPLATE_ADD_CONTEXTLESSAPPEALMAILING_PRELOAD

The load procedure used by the edit dataform template "Contextless Appeal Mailing Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONSTITUENTRECORDTYPEID	uniqueidentifier	INOUT	Constituent record type
@EXCLUSIONS	xml	INOUT	Exclusions
@HOUSEHOLDINGTYPECODE	tinyint	INOUT	Householding
@ENABLEHOUSEHOLDING	bit	INOUT	Enable householding?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT	Address processing options
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT	Name format options
@SITEID	uniqueidentifier	INOUT	Site ID
@CANUPDATEEXCLUDEDECEASED	bit	INOUT	Can update exclude deceased constituents?
@CANUPDATEEXCLUDEINACTIVE	bit	INOUT	Can update exclude inactive constituents?
@ACTIVATIONKPIS	xml	INOUT	Activation KPIs
@BBECRECORDSOURCEID	uniqueidentifier	INOUT	BBEC record source ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_CONTEXTLESSAPPEALMAILING_PRELOAD]
(
  @CURRENTAPPUSERID uniqueidentifier,
  @CONSTITUENTRECORDTYPEID uniqueidentifier = null output,
  @EXCLUSIONS xml = null output,
  @HOUSEHOLDINGTYPECODE tinyint = null output,
  @ENABLEHOUSEHOLDING bit = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output,
  @SITEID uniqueidentifier = null output,
  @CANUPDATEEXCLUDEDECEASED bit = null output,
  @CANUPDATEEXCLUDEINACTIVE bit = null output,
  @ACTIVATIONKPIS xml = null output,
  @BBECRECORDSOURCEID uniqueidentifier = null output
)
as
begin
  set nocount on;

  exec [dbo].[USP_DATAFORMTEMPLATE_ADD_APPEALMAILING_PRELOAD] 
     null
    ,@CURRENTAPPUSERID
    ,@CONSTITUENTRECORDTYPEID
    ,@EXCLUSIONS
    ,@HOUSEHOLDINGTYPECODE
    ,@ENABLEHOUSEHOLDING
    ,@ADDRESSPROCESSINGOPTIONID
    ,@NAMEFORMATPARAMETERID
    ,@SITEID
    ,@CANUPDATEEXCLUDEDECEASED
    ,@CANUPDATEEXCLUDEINACTIVE
    ,@ACTIVATIONKPIS;

  set @BBECRECORDSOURCEID = dbo.[UFN_MKTRECORDSOURCE_GETFIRSTBBECRECORDSOURCEID]();

  return 0;
end