USP_DATAFORMTEMPLATE_ADD_ADDSTEWARDSHIPPLANSPROCESS_PRELOAD

The load procedure used by the edit dataform template "Add Stewardship Plans Business Process Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	INOUT
@SITEREQUIRED	bit	INOUT	Site required
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ADDSTEWARDSHIPPLANSPROCESS_PRELOAD
(
  @RECORDTYPEID uniqueidentifier = null output,
  @SITEREQUIRED bit = null output,
  @CURRENTAPPUSERID uniqueidentifier
)
as
  set nocount on;

  set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);

  select @RECORDTYPEID = ID
  from dbo.RECORDTYPE 
  where NAME = 'Constituent';

  return 0;