USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTCONDITION_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@MATCHINGGIFTCONDITIONTYPECODEID	uniqueidentifier	IN	Type
@MATCHINGFACTOR	decimal(5, 2)	IN	Matching factor
@MINMATCHPERGIFT	money	IN	Min match per gift
@MAXMATCHPERGIFT	money	IN	Max match per gift
@MAXMATCHANNUAL	money	IN	Max match per year
@MAXMATCHTOTAL	money	IN	Max match total
@NOTES	nvarchar(max)	IN	Notes
@RELATIONSHIPS	xml	IN	Relationship mappings
@MATCHTYPECODE	tinyint	IN	Matching amount

Definition

Copy



    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTCONDITION_2
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @MATCHINGGIFTCONDITIONTYPECODEID uniqueidentifier,
                        @MATCHINGFACTOR decimal(5,2),
                        @MINMATCHPERGIFT money,
                        @MAXMATCHPERGIFT money,
                        @MAXMATCHANNUAL money,
                        @MAXMATCHTOTAL money,
                        @NOTES nvarchar(max),
                        @RELATIONSHIPS xml,
                        @MATCHTYPECODE tinyint
                    ) as
                        set nocount on;

              declare @REVENUETYPECODE smallint;

              exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MATCHINGGIFTCONDITION_2 
                  @ID = @ID, 
                  @REVENUETYPECODE = @REVENUETYPECODE output;

              exec dbo.USP_DATAFORMTEMPLATE_EDIT_MATCHINGGIFTCONDITION_3 @ID, @CHANGEAGENTID, @MATCHINGGIFTCONDITIONTYPECODEID, @MATCHINGFACTOR,
                  @MINMATCHPERGIFT, @MAXMATCHPERGIFT, @MAXMATCHANNUAL, @MAXMATCHTOTAL, @NOTES, @RELATIONSHIPS, @MATCHTYPECODE, @REVENUETYPECODE;

                        return 0;