USP_DATAFORMTEMPLATE_ADD_NAMINGOPPORTUNITYREVENUEORCONSTITUENTRECOGNITION

The save procedure used by the add dataform template "Naming Opportunity Revenue Or Constituent Recognition Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@NAMINGOPPORTUNITYID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@REVENUESPLITID	uniqueidentifier	IN	Revenue
@CONSTITUENTID	uniqueidentifier	IN	Constituent
@CONSTITUENTNAMEFORMATID	uniqueidentifier	IN	Name format
@CUSTOMNAMEFORMAT	nvarchar(100)	IN	Specific name
@STARTDATE	UDT_FUZZYDATE	IN	Recognition date
@ENDDATE	UDT_FUZZYDATE	IN	Recognition ends
@AMOUNT	money	IN	Recognition amount
@QUANTITY	int	IN	Quantity
@INSCRIPTION	nvarchar(max)	IN	Inscription
@SPECIALREQUEST	nvarchar(max)	IN	Special request
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.

Definition

Copy


              CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_NAMINGOPPORTUNITYREVENUEORCONSTITUENTRECOGNITION
              (
                  @ID uniqueidentifier output,
                  @NAMINGOPPORTUNITYID uniqueidentifier,
                  @REVENUESPLITID uniqueidentifier = null,
                  @CONSTITUENTID uniqueidentifier,
                  @CONSTITUENTNAMEFORMATID uniqueidentifier = null,
                  @CUSTOMNAMEFORMAT nvarchar(100) = '',
                  @STARTDATE dbo.UDT_FUZZYDATE = '00000000',
                  @ENDDATE dbo.UDT_FUZZYDATE = '00000000',
                  @AMOUNT money,
                  @QUANTITY int,
                  @INSCRIPTION nvarchar(max) = '',
                  @SPECIALREQUEST nvarchar(max) = '',
                  @CHANGEAGENTID uniqueidentifier
              )
              as
              set nocount on;

                exec dbo.USP_NAMINGOPPORTUNITYREVENUERECOGNITION_ADD
                  @ID = @ID output,
                  @REVENUESPLITID = @REVENUESPLITID,
                  @NAMINGOPPORTUNITYID = @NAMINGOPPORTUNITYID,
                  @CONSTITUENTID = @CONSTITUENTID,
                  @CONSTITUENTNAMEFORMATID = @CONSTITUENTNAMEFORMATID,
                  @CUSTOMNAMEFORMAT = @CUSTOMNAMEFORMAT,
                  @STARTDATE = @STARTDATE,
                  @ENDDATE = @ENDDATE,
                  @AMOUNT = @AMOUNT,
                  @QUANTITY = @QUANTITY,
                  @INSCRIPTION = @INSCRIPTION,
                  @SPECIALREQUEST = @SPECIALREQUEST,
                  @CHANGEAGENTID = @CHANGEAGENTID

              return 0;