USP_RECORDOPERATION_TRIBUTEACKNOWLEDGEMENTPROCESS_DELETEPROMPT

Provides the prompt for the "Tribute 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_TRIBUTEACKNOWLEDGEMENTPROCESS_DELETEPROMPT
                            (
                                @ID uniqueidentifier,
                                @MESSAGE nvarchar(150) output
                            )
                            as
                                set nocount on;

                                if exists (select RL.ID from dbo.REVENUETRIBUTELETTER RL 
                                           inner join dbo.TRIBUTEACKNOWLEDGEMENTPROCESSSTATUS STATUS on RL.TRIBUTEACKNOWLEDGEMENTPROCESSSTATUSID = STATUS.ID
                                           where STATUS.PARAMETERSETID = @ID and RL.ACKNOWLEDGEDATE is null)
                                    select @MESSAGE = 'Letters in this tribute acknowledgement process have not been marked ''Acknowledged'' and results will be cleared.'
                                else
                                    select @MESSAGE = null;

                                return 0;