USP_DATAFORMTEMPLATE_PRELOAD_ADD_SPONSORSHIPTRANSFERPROCESS

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

Parameters

Parameter	Parameter Type	Mode	Description
@FORMTITLE	nvarchar(100)	INOUT
@SPONSORSHIPRECORDTYPEID	uniqueidentifier	INOUT	Sponsorship record type

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_SPONSORSHIPTRANSFERPROCESS
          (                    
            @FORMTITLE nvarchar(100) = null output, -- no longer used
              @SPONSORSHIPRECORDTYPEID uniqueidentifier = null output           
          )
          as
              set nocount on;
            --set @FORMTITLE = 'Add sponsorship transfer business process'
              select @SPONSORSHIPRECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'SPONSORSHIP';                        
              return 0;