USP_DATAFORMTEMPLATE_PRELOAD_ADD_SPONSORSHIPTERMINATEPROCESS

The load procedure used by the edit dataform template "Sponsorship Terminate Process Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SPONSORSHIPRECORDTYPEID	uniqueidentifier	INOUT	Sponsorship record type

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_SPONSORSHIPTERMINATEPROCESS
          (                        
              @SPONSORSHIPRECORDTYPEID uniqueidentifier = null output             
          )
          as
              set nocount on;
              select @SPONSORSHIPRECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'SPONSORSHIP';                        
              return 0;