USP_DATAFORMTEMPLATE_PRELOAD_ADD_SPONSORSHIPOPPORTUNITYRESERVEBUSINESS

The load procedure used by the edit dataform template "Sponsorship Opportunity Reserve Business Process Add Form"

Parameters

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

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_SPONSORSHIPOPPORTUNITYRESERVEBUSINESS
          (                        

            @FORMTITLE nvarchar(100) = null output,
            @SPONSORSHIPRECORDTYPEID uniqueidentifier = null output, 
            @RESERVEDINKEY int = null output
          )
          as
              set nocount on;

            set @FORMTITLE = 'Add opportunity reservation key'
            set @RESERVEDINKEY = 0  

              select @SPONSORSHIPRECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'SPONSORSHIP OPPORTUNITY';                        
              return 0;