USP_DATAFORMTEMPLATE_ADDLOAD_MOBILE_STEWARDSHIPPLANCOMPLETEDSTEPS

Parameters

Parameter	Parameter Type	Mode
@STEWARDSHIPPLANID	uniqueidentifier	IN
@PLANID	uniqueidentifier	INOUT
@NEWSTEPSTATUSCODE	smallint	INOUT
@CURRENTPLANOWNERNAME	nvarchar(154)	INOUT
@STEPS	xml	INOUT
@CONSTITUENTID	uniqueidentifier	INOUT
@STARTDATE	datetime	INOUT

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_ADDLOAD_MOBILE_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;