USP_RECORDOPERATION_PLEDGEREMINDERPROCESSMARKREMINDERSSENT

Executes the "Pledge Reminder Process: Mark Reminders Sent" 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_RECORDOPERATION_PLEDGEREMINDERPROCESSMARKREMINDERSSENT
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null
                    )
                    as
                        set nocount on;

                        declare @OUTPUTTABLE nvarchar(128);
                        declare @CURRENTDATE datetime;

                        set @CURRENTDATE = getdate();

                        select @OUTPUTTABLE = TABLENAME from dbo.BUSINESSPROCESSOUTPUT where BUSINESSPROCESSSTATUSID = @ID and TABLEKEY = 'OUTPUT';

                        if @OUTPUTTABLE is not null
                            exec dbo.USP_SCHEMA_TABLE_SETDATEEXTENDEDPROPERTY @OUTPUTTABLE, @CURRENTDATE, 'BB_REMINDERSENTDATE';

                        update 
                            dbo.PLEDGEREMINDERSENT
                        set 
                            SENTDATE = @CURRENTDATE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where
                            PLEDGEREMINDERPROCESSSTATUSID = @ID;

                        return 0;