USP_RECORDOPERATION_PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUS_DELETEPROMPT

Provides the prompt for the "Planned Gift Acknowledgement Process Status: Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Represents information to be displayed in the record operation prompt.
@MESSAGE	nvarchar(150)	INOUT

Definition

Copy



                            CREATE procedure dbo.USP_RECORDOPERATION_PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUS_DELETEPROMPT
                            (
                                @ID uniqueidentifier,
                                @MESSAGE nvarchar(150) output
                            )
                            as
                                set nocount on;

                                if exists (select ID from dbo.PLANNEDGIFTLETTER where PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUSID = @ID and ACKNOWLEDGEDATE is null)
                                    select @MESSAGE = 'Letters in this planned gift acknowledgement process have not been marked ''Acknowledged'' and results will be cleared.'
                                else
                                    select @MESSAGE = null;

                                return 0;