USP_CLOSINGREQUIREMENT_DELETE_PROMPTDATA

Provides the prompt for the "Closing Requirement: Delete" record operation.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_CLOSINGREQUIREMENT_DELETE_PROMPTDATA
                (
                    @ID uniqueidentifier,
                    @DESCRIPTION nvarchar(60) = null output
                )
                as begin
                    set nocount on;

                    select
                        @DESCRIPTION = DESCRIPTION
                    from
                        dbo.CLOSINGREQUIREMENT
                    where
                        ID = @ID

                    return 0;
                end