USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPTERMINATEPROCESS

The save procedure used by the add dataform template "Sponsorship Terminate Process Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@SPONSORSHIPREASONID	uniqueidentifier	IN	Reason

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPTERMINATEPROCESS
          (
              @ID uniqueidentifier = null output,    
              @CHANGEAGENTID uniqueidentifier = null,    
              @NAME nvarchar(100) = '',
              @DESCRIPTION nvarchar(255) = '',
              @IDSETREGISTERID uniqueidentifier = null,
              @SPONSORSHIPREASONID uniqueidentifier = null
          )
          as
          set nocount on;
          if @ID is null
              set @ID = newid()

          if @CHANGEAGENTID is null  
              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

          declare @CURRENTDATE datetime
          set @CURRENTDATE = getdate()

          begin try
              insert into dbo.SPONSORSHIPTERMINATEPROCESS
                     ([ID]
                     ,[NAME]
                     ,[DESCRIPTION]
                     ,[IDSETREGISTERID]
                     ,[SPONSORSHIPREASONID]
                     ,[ADDEDBYID]
                     ,[CHANGEDBYID]
                     ,[DATEADDED]
                     ,[DATECHANGED])
               values(
                     @ID,
                         @NAME,
                         @DESCRIPTION,
                         @IDSETREGISTERID,
                     @SPONSORSHIPREASONID,
                         @CHANGEAGENTID,
                         @CHANGEAGENTID,
                         @CURRENTDATE,
                         @CURRENTDATE)
            end try

            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch
          return 0