USP_DATAFORMTEMPLATE_ADD_ADDSTEWARDSHIPPLANSTEPSPROCESS_PRELOAD

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

Parameters

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

Definition

Copy


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

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

  return 0;