USP_RECORDOPERATION_PROSPECTRESEARCHREQUESTCOMPLETEPROMPT

Provides the prompt for the "Prospect Research Request: Complete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Represents information to be displayed in the record operation prompt.
@ACTIVECONSTITUENTS	smallint	INOUT

Definition

Copy



                            CREATE procedure dbo.USP_RECORDOPERATION_PROSPECTRESEARCHREQUESTCOMPLETEPROMPT (
                                @ID uniqueidentifier,
                                @ACTIVECONSTITUENTS smallint output
                            )as
                                set nocount on;

                                select 
                                    @ACTIVECONSTITUENTS = count(ID)
                                from
                                    dbo.PROSPECTRESEARCHREQUESTCONSTITUENT
                                where
                                    PROSPECTRESEARCHREQUESTID = @ID and STATUSCODE not in (4, 6)

                                return 0;