USP_DATAFORMTEMPLATE_ADDLOAD_STEWARDSHIPPLANCOMPLETEDSTEPS

The load procedure used by the edit dataform template "Stewardship Plan Completed Steps Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@STEWARDSHIPPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PLANID	uniqueidentifier	INOUT
@NEWSTEPSTATUSCODE	smallint	INOUT
@CURRENTPLANOWNERNAME	nvarchar(154)	INOUT
@STEPS	xml	INOUT	Steps
@CONSTITUENTID	uniqueidentifier	INOUT
@STARTDATE	datetime	INOUT	Start date

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADDLOAD_STEWARDSHIPPLANCOMPLETEDSTEPS
(
  @STEWARDSHIPPLANID uniqueidentifier,
  @PLANID uniqueidentifier = null output,
  @NEWSTEPSTATUSCODE smallint = null output,
  @CURRENTPLANOWNERNAME nvarchar(154) = null output,
  @STEPS xml = null output,
  @CONSTITUENTID uniqueidentifier = null output,
  @STARTDATE datetime = null output
) 
as begin
  set nocount on;

  -- Field needed for parameter to pass to Steward Simple list
  --    ContextRecordID not supported by EditGridHelper.GetSimpleListFieldValue
  set @PLANID = @STEWARDSHIPPLANID;

  select 
    @NEWSTEPSTATUSCODE = 1,             
    @CURRENTPLANOWNERNAME = NF.NAME,
    @CONSTITUENTID = [PLAN].CONSTITUENTID,
    @STARTDATE = [PLAN].STARTDATE
  from
    dbo.STEWARDSHIPPLAN [PLAN]
  cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME([PLAN].CONSTITUENTID) NF
  where
    [PLAN].ID = @STEWARDSHIPPLANID;

  return 0;

end;