USP_DATAFORMTEMPLATE_EDIT_MGPLEDGE

The save procedure used by the edit dataform template "Matching Gift Claim Edit Form".

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.
@ORIGINALGIFTID	uniqueidentifier	IN	Original Gift
@MATCHINGORGANIZATIONID	uniqueidentifier	IN	Matching organization
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@SPLITS	xml	IN	Designations
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date
@MATCHINGGIFTCONDITIONID	uniqueidentifier	IN	Relationship type

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MGPLEDGE
                    (
                        @ID uniqueidentifier, 
                        @CHANGEAGENTID uniqueidentifier,
                        @ORIGINALGIFTID uniqueidentifier,
                        @MATCHINGORGANIZATIONID uniqueidentifier,
                        @DATE datetime,
                        @AMOUNT money,
                        @SPLITS xml,
                        @POSTSTATUSCODE tinyint,
                        @POSTDATE datetime,
                        @MATCHINGGIFTCONDITIONID uniqueidentifier
                    )
                    as
                    set nocount on;
                    declare @CHANGEDATE datetime;
                    set @CHANGEDATE = getdate();

                    exec dbo.USP_MATCHINGGIFTPLEDGE_EDIT @ID, @CHANGEAGENTID, @CHANGEDATE, @ORIGINALGIFTID, @MATCHINGGIFTCONDITIONID, 
                        @DATE, @AMOUNT, @SPLITS, @POSTSTATUSCODE, @POSTDATE, @MATCHINGGIFTCONDITIONID;

                    return 0;