USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPLANSTEP_GROUPORG_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@STEWARDSHIPPLANID	uniqueidentifier	IN	Plan ID
@STEPOWNERISINDIVIDUAL	bit	IN	Step owner is an individual
@CATEGORYCODEID	uniqueidentifier	IN	Category
@OBJECTIVE	nvarchar(100)	IN	Objective
@TARGETDATE	datetime	IN	Target date
@DATELOCKED	bit	IN	Locked
@ACTUALDATE	datetime	IN	Actual date
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@CONTACTPERSONID	uniqueidentifier	IN	Contact person
@CONTACTMETHODCODEID	uniqueidentifier	IN	Contact method
@CONSTITUENTID	uniqueidentifier	IN	Assigned to
@ASSOCIATEDPLANS	xml	IN	Associated plans
@TEMPLATE	nvarchar(100)	IN	Template
@RECURSCODE	smallint	IN	Frequency
@STATUSCODE	smallint	IN	Status
@NEXTTARGETDATE	datetime	IN	Next target date
@LINKTYPECODE	smallint	IN	Link type
@BENEFITID	uniqueidentifier	IN	Benefit
@EVENTID	uniqueidentifier	IN	Event
@MAILINGID	uniqueidentifier	IN	Mailing
@TARGETSTARTTIME	UDT_HOURMINUTE	IN	Target start time
@TARGETENDTIME	UDT_HOURMINUTE	IN	Target end time
@ISALLDAYEVENT	bit	IN	Is all day event
@TIMEZONEENTRYID	uniqueidentifier	IN	Time zone
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	IN	Actual end time

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPLANSTEP_GROUPORG_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @STEWARDSHIPPLANID uniqueidentifier,
    @STEPOWNERISINDIVIDUAL bit,
    @CATEGORYCODEID uniqueidentifier,
    @OBJECTIVE nvarchar(100),
    @TARGETDATE datetime,
    @DATELOCKED bit,
    @ACTUALDATE datetime,
    @STARTDATE datetime,
    @ENDDATE datetime,
    @CONTACTPERSONID uniqueidentifier,
    @CONTACTMETHODCODEID uniqueidentifier,
    @CONSTITUENTID uniqueidentifier,
    @ASSOCIATEDPLANS xml,
    @TEMPLATE nvarchar(100),
    @RECURSCODE smallint,
    @STATUSCODE smallint,
    @NEXTTARGETDATE datetime,
    @LINKTYPECODE smallint,
    @BENEFITID uniqueidentifier,
    @EVENTID uniqueidentifier,
    @MAILINGID uniqueidentifier,
    @TARGETSTARTTIME dbo.UDT_HOURMINUTE,
    @TARGETENDTIME dbo.UDT_HOURMINUTE,
    @ISALLDAYEVENT bit,
    @TIMEZONEENTRYID uniqueidentifier,
    @ACTUALSTARTTIME dbo.UDT_HOURMINUTE,
    @ACTUALENDTIME dbo.UDT_HOURMINUTE
)

as
  set nocount on;

    declare @STEPPARTICIPANTS xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_GROUPORG
        @ID = @ID,
        @STEPPARTICIPANTS = @STEPPARTICIPANTS output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPLANSTEP_GROUPORG_3
        @ID,
        @CHANGEAGENTID,
        @STEWARDSHIPPLANID,
        @STEPOWNERISINDIVIDUAL,
        @CATEGORYCODEID,
        @OBJECTIVE,
        @TARGETDATE,
        @DATELOCKED,
        @ACTUALDATE,
        @STARTDATE,
        @ENDDATE,
        @CONTACTPERSONID,
        @CONTACTMETHODCODEID,
        @CONSTITUENTID,
        @ASSOCIATEDPLANS,
        @TEMPLATE,
        @RECURSCODE,
        @STATUSCODE,
        @NEXTTARGETDATE,
        @LINKTYPECODE,
        @BENEFITID,
        @EVENTID,
        @MAILINGID,
        @TARGETSTARTTIME,
        @TARGETENDTIME,
        @ISALLDAYEVENT,
        @TIMEZONEENTRYID,
        @ACTUALSTARTTIME,
        @ACTUALENDTIME,
        @STEPPARTICIPANTS

  return 0;