USP_RECORDOPERATION_PLANNEDGIFTACKNOWLEDGEMENTPROCESSMARKLETTERSSENT

Executes the "Planned Gift Acknowledgement Process: Mark Letters 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_PLANNEDGIFTACKNOWLEDGEMENTPROCESSMARKLETTERSSENT
                    (
                        @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_ACKNOWLEDGEMENTSSENTDATE';

                        update 
                            dbo.PLANNEDGIFTLETTER
                        set 
                            ACKNOWLEDGEDATE = @CURRENTDATE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where
                            PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUSID = @ID;

                        declare @SQL nvarchar(250);
                        declare @PARAMDEF nvarchar(25);

                        set @SQL = N'update dbo.' + @OUTPUTTABLE + ' set PROCESS_ACKNOWLEDGEDATE = @DATE';
                        set @PARAMDEF = N'@DATE datetime';

                        if @OUTPUTTABLE is not null 
                            exec sp_executesql @SQL, @PARAMDEF, @DATE = @CURRENTDATE;

                        return 0;