USP_DATAFORMTEMPLATE_ADD_RECOGNITIONRELATIONSHIPDEFAULT

The save procedure used by the add dataform template "Recognition Relationship Default Add Data 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.
@CONSTITUENTTYPECODE	tinyint	IN	Constituent type
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@REVENUERECOGNITIONTYPECODEID	uniqueidentifier	IN	Recognition credit type
@MATCHFACTOR	decimal(5, 2)	IN	Recognition credit match percent

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_RECOGNITIONRELATIONSHIPDEFAULT
        (
          @ID uniqueidentifier = null output,
          @CHANGEAGENTID uniqueidentifier = null,
          @CONSTITUENTTYPECODE tinyint = null,
          @RELATIONSHIPTYPECODEID uniqueidentifier = null,
          @REVENUERECOGNITIONTYPECODEID uniqueidentifier = null,
          @MATCHFACTOR decimal (5, 2) = 100.00
        )
        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
          -- handle inserting the data

          insert into dbo.RECOGNITIONRELATIONSHIPDEFAULT
              (ID, CONSTITUENTTYPECODE, RELATIONSHIPTYPECODEID, REVENUERECOGNITIONTYPECODEID, MATCHFACTOR, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
            values
              (@ID, @CONSTITUENTTYPECODE, @RELATIONSHIPTYPECODEID, @REVENUERECOGNITIONTYPECODEID, @MATCHFACTOR, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
        end try

        begin catch
            exec dbo.USP_RAISE_ERROR
            return 1
        end catch

        return 0