USP_DATAFORMTEMPLATE_PRELOAD_ADD_PLANNEDGIFTLETTERCODE

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

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	INOUT
@DATALISTIDS	xml	INOUT	DataListIDs
@SITEREQUIRED	bit	INOUT	Site required
@SITES	xml	INOUT	Sites
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@LETTERRECORDTYPENAME	nvarchar(50)	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PLANNEDGIFTLETTERCODE
(
  @RECORDTYPEID uniqueidentifier = null output,
  @DATALISTIDS xml = null output,
  @SITEREQUIRED bit = null output,
  @SITES xml = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @LETTERRECORDTYPENAME nvarchar(50) = null output
)
as
  set nocount on;

  set @LETTERRECORDTYPENAME = 'Planned Gift';

  select 
    @RECORDTYPEID = [ID],
    @DATALISTIDS = dbo.[UFN_QUERYVIEW_GETTAGGEDDATALIST_TOITEMLISTXML]('PlannedGiftAcknowledgementLetters')
  from dbo.[RECORDTYPE]
  where [NAME] = @LETTERRECORDTYPENAME;

  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, 'FD68D47C-B35F-43DB-8808-1191B6628973', 1);

  declare @DEFAULTSITEID uniqueidentifier;
  set @DEFAULTSITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);

  if @DEFAULTSITEID is not null
    set @SITES = (select newid() as [ID], @DEFAULTSITEID as [SITEID] for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64);

  return 0;