USP_DATAFORMTEMPLATE_EDIT_MGPLEDGE_3

Maintain backwards compatibility for Matching Gift Claim Edit.

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
@MATCHINGGIFTCONDITIONID	uniqueidentifier	IN	Matching gift condition type
@RELATIONSHIPID	uniqueidentifier	IN	Relationship

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MGPLEDGE_3
            (
                @ID uniqueidentifier, 
                @CHANGEAGENTID uniqueidentifier,
                @ORIGINALGIFTID uniqueidentifier,
                @MATCHINGORGANIZATIONID uniqueidentifier,
                @DATE datetime,
                @AMOUNT money,
                @SPLITS xml,
                @MATCHINGGIFTCONDITIONID uniqueidentifier,
                @RELATIONSHIPID uniqueidentifier
            )
            as
            begin
                set nocount on;

                declare @BASECURRENCYID uniqueidentifier;
                declare @TRANSACTIONCURRENCYID uniqueidentifier;
                declare @BASEEXCHANGERATEID uniqueidentifier;
                declare @EXCHANGERATE decimal(20,8);
                declare @HADSPOTRATE bit;
                declare @RATECHANGED bit;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MGPLEDGE_3
                    @ID=@ID,
                    @BASECURRENCYID = @BASECURRENCYID output,
                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                    @EXCHANGERATE = @EXCHANGERATE output,
                    @HADSPOTRATE = @HADSPOTRATE output,
                    @RATECHANGED = @RATECHANGED output

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_MGPLEDGE_4
                    @ID, 
                    @CHANGEAGENTID,
                    @ORIGINALGIFTID,
                    @MATCHINGORGANIZATIONID,
                    @DATE,
                    @AMOUNT,
                    @SPLITS,
                    @MATCHINGGIFTCONDITIONID,
                    @RELATIONSHIPID,
                    @BASECURRENCYID,
                    @TRANSACTIONCURRENCYID,
                    @BASEEXCHANGERATEID,
                    @EXCHANGERATE,
                    @HADSPOTRATE,
                    @RATECHANGED

                return 0;
            end