USP_DATAFORMTEMPLATE_PROSPECTPLAN_ADDLOAD

The load procedure used by the edit dataform template "Prospect Plan Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PROSPECT	nvarchar(700)	INOUT	Prospect
@FISCALYEARSTARTDATE	datetime	INOUT	Fiscal year start date
@FISCALYEARENDDATE	datetime	INOUT	Fiscal year end date
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site required
@SITES	xml	INOUT	Sites

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PROSPECTPLAN_ADDLOAD 
(
  @PROSPECTID uniqueidentifier,
  @PROSPECT nvarchar(700) = null output,
  @FISCALYEARSTARTDATE datetime = null output,
  @FISCALYEARENDDATE datetime = null output,
  @CURRENTAPPUSERID uniqueidentifier,
  @SITEREQUIRED bit = null output,
  @SITES xml = null output
) as
  set nocount on;

  select @PROSPECT = NAME
  from dbo.UFN_CONSTITUENT_DISPLAYNAME(@PROSPECTID) NF;

  declare @CURRENTDATE as DATETIME
  select @CURRENTDATE = CURRENT_TIMESTAMP

  select @FISCALYEARSTARTDATE = dbo.UFN_DATE_THISFISCALYEAR_FIRSTDAY(@CURRENTDATE, 0)
  select @FISCALYEARENDDATE = dbo.UFN_DATE_THISFISCALYEAR_LASTDAY(@CURRENTDATE, 0)

  set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID)

  declare @USERSITEID uniqueidentifier = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
  if @USERSITEID is not null
  begin
    set @SITES = (
      select newid() ID, @USERSITEID SITEID
      for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64
    )
  end

  return 0;