USP_RECORDOPERATION_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_DELETEPROMPT

Provides the prompt for the "Planned Gift Acknowledgement Process: 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_PLANNEDGIFTACKNOWLEDGEMENTPROCESS_DELETEPROMPT
                            (
                                @ID uniqueidentifier,
                                @MESSAGE nvarchar(150) output
                            )
                            as
                                set nocount on;

                                if exists (select PGL.ID from dbo.PLANNEDGIFTLETTER PGL 
                                            inner join dbo.PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUS STATUS on PGL.PLANNEDGIFTACKNOWLEDGEMENTPROCESSSTATUSID = STATUS.ID
                                            where STATUS.PARAMETERSETID = @ID and PGL.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;