USP_DATAFORMTEMPLATE_PRELOAD_ADD_DONORCHALLENGEDESIGNATIONMAPSELECTION

The load procedure used by the edit dataform template "Donor Challenge Designation Map Selection Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DONORCHALLENGEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@RECORDTYPEID	uniqueidentifier	INOUT	Record type ID
@TYPECODE	tinyint	INOUT	Donor challenge type code

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_DONORCHALLENGEDESIGNATIONMAPSELECTION
(
  @DONORCHALLENGEID uniqueidentifier,
  @RECORDTYPEID uniqueidentifier = null output,
  @TYPECODE tinyint = null output
)
as
begin            
  set nocount on;

  select 
    @RECORDTYPEID = ID
  from 
    dbo.RECORDTYPE 
  where 
    upper(NAME) = 'DESIGNATION';

  select
    @TYPECODE = TYPECODE
  from
    dbo.DONORCHALLENGE
  where
    ID = @DONORCHALLENGEID;

  return 0;
end