USP_DATAFORMTEMPLATE_ADDLOAD_PLANPARTICIPANT

The load procedure used by the edit dataform template "Plan Participant Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PROSPECTID	uniqueidentifier	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADDLOAD_PLANPARTICIPANT (
                        @PROSPECTPLANID uniqueidentifier,
                        @PROSPECTID uniqueidentifier = null output
                    )
                    as
                        set nocount on;

                        select @PROSPECTID = PROSPECTID from dbo.PROSPECTPLAN where ID=@PROSPECTPLANID;

                        return 0;