USP_RECORDOPERATION_R68PROCESSSTATUS_DELETEPROMPT

Provides the prompt for the "R68 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(255)	INOUT

Definition

Copy



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

    if dbo.UFN_R68_HASPENDINGRECORDS(@ID) = 1
        select @MESSAGE = 'Revenue applications in this R68 process have not been committed and results will be cleared.';
    else
        select @MESSAGE = null;

    return 0;