USP_MATCHINGGIFTPLEDGE_MARKACTIVE

Executes the "Matching Gift Claim: Mark Active" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



                    CREATE procedure dbo.USP_MATCHINGGIFTPLEDGE_MARKACTIVE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as
                    set nocount on;
                    declare @CHANGEDATE datetime;
                    set @CHANGEDATE = getdate();

                    if(select ISACTIVE from dbo.REVENUEMATCHINGGIFT where ID = @ID) = 0
                        update dbo.REVENUEMATCHINGGIFT
                            set ISACTIVE = 1,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CHANGEDATE
                        where ID = @ID;