USP_RECORDOPERATION_ACKNOWLEDGEMENTPROCESS_DELETEPROMPT

Provides the prompt for the "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
@PROMPTRESOURCEKEY	nvarchar(150)	INOUT
@QUEUEPROCESSCOUNTTEXT	nvarchar(10)	INOUT
@FIRSTQUEUEPROCESSNAME	nvarchar(255)	INOUT
Definition

Copy


                            CREATE procedure dbo.USP_RECORDOPERATION_ACKNOWLEDGEMENTPROCESS_DELETEPROMPT
                            (
                                @ID uniqueidentifier,
                                @MESSAGE nvarchar(150) output, --Deprecated

                                @PROMPTRESOURCEKEY nvarchar(150) output,
                                @QUEUEPROCESSCOUNTTEXT nvarchar(10) output,
                                @FIRSTQUEUEPROCESSNAME nvarchar(255) output
                            )
                            as
                                set nocount on;

                                declare @HASLETTERSNOTACKNOWLEDGED bit = 0;

                                if exists (select RL.ID from dbo.REVENUELETTER RL 
                                           inner join dbo.ACKNOWLEDGEMENTPROCESSSTATUS STATUS on RL.ACKNOWLEDGEMENTPROCESSSTATUSID = STATUS.ID
                                           where STATUS.PARAMETERSETID = @ID and RL.ACKNOWLEDGEDATE is null)
                                    set @HASLETTERSNOTACKNOWLEDGED = 1;

                                declare @QUEUEPROCESSCOUNT int;

                                exec dbo.USP_QUEUEPROCESS_GETBUSINESSPROCESSDELETEPROMPTINFO
                                    @PARAMETERSETID = @ID,
                                    @BUSINESSPROCESSID = '02e8a918-fb90-4c3d-a70e-821db5da7a1f',
                                    @PROMPTRESOURCEKEY = null, --We'll build our own because of @HASLETTERSNOTACKNOWLEDGED

                                    @QUEUEPROCESSCOUNT = @QUEUEPROCESSCOUNT output,
                                    @QUEUEPROCESSCOUNTTEXT = @QUEUEPROCESSCOUNTTEXT output,
                                    @FIRSTQUEUEPROCESSNAME = @FIRSTQUEUEPROCESSNAME output;

                                set @PROMPTRESOURCEKEY =
                                    N'DeletePrompt'
                                    + case
                                        when @QUEUEPROCESSCOUNT = 1 then N'InSingleQueue'
                                        when @QUEUEPROCESSCOUNT = 2 then N'InTwoQueues'
                                        when @QUEUEPROCESSCOUNT > 2 then N'InMoreThanTwoQueues'
                                        else N'NotInQueue'
                                    end
                                    + case
                                        when @HASLETTERSNOTACKNOWLEDGED = 1 then N'HasLettersNotAcknowledged'
                                        else N'AllLettersAcknowledged'
                                    end;

                                return 0;