USP_DATAFORMTEMPLATE_ADD_BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHROW

The save procedure used by the add dataform template "Stewardship Plan Step Update Batch Row Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@PRIMARYRECORDID	uniqueidentifier	IN	Stewardship plan step
@STEWARDSHIPPLANID	uniqueidentifier	IN	Plan ID
@STEPOWNERID	uniqueidentifier	IN
@CATEGORYCODEID	uniqueidentifier	IN	Category
@OBJECTIVE	nvarchar(100)	IN	Objective
@TARGETDATE	date	IN	Target date
@DATELOCKED	bit	IN	Locked
@ACTUALDATE	date	IN	Actual date
@STARTDATE	date	IN	Frequency start date
@ENDDATE	date	IN	Frequency end date
@CONTACTMETHODCODEID	uniqueidentifier	IN	Contact method
@CONTACTPERSONID	uniqueidentifier	IN	Contact person
@CONSTITUENTID	uniqueidentifier	IN	Assigned to
@ASSOCIATEDPLANS	xml	IN	Associated plans
@RECURSCODE	smallint	IN	Frequency
@STATUSCODE	smallint	IN	Status
@NEXTTARGETDATE	date	IN	Next target date
@LINKTYPECODE	tinyint	IN	Connect to
@EVENTID	uniqueidentifier	IN	Event
@MAILINGID	uniqueidentifier	IN	Mailing
@BENEFITID	uniqueidentifier	IN	Benefit
@TARGETSTARTTIME	UDT_HOURMINUTE	IN	Target start time
@TARGETENDTIME	UDT_HOURMINUTE	IN	Target end time
@TIMEZONEENTRYID	uniqueidentifier	IN	Time zone
@ISALLDAYEVENT	bit	IN	Is all day event
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	IN	Actual end time
@STEPPARTICIPANTS	xml	IN	Plan participants

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHROW
(
  @ID uniqueidentifier = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @BATCHID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @SEQUENCE int,
  @PRIMARYRECORDID uniqueidentifier = null,
  @STEWARDSHIPPLANID uniqueidentifier = null,
  @STEPOWNERID uniqueidentifier = null,
  @CATEGORYCODEID uniqueidentifier = null,
  @OBJECTIVE nvarchar(100) = '',
  @TARGETDATE date = null,
  @DATELOCKED bit = 0,
  @ACTUALDATE date = null,
  @STARTDATE date = null,
  @ENDDATE date = null,
  @CONTACTMETHODCODEID uniqueidentifier = null,
  @CONTACTPERSONID uniqueidentifier = null,
  @CONSTITUENTID uniqueidentifier = null,
  @ASSOCIATEDPLANS xml = null,
  @RECURSCODE smallint = 0,
  @STATUSCODE smallint = 0,
  @NEXTTARGETDATE date = null,
  @LINKTYPECODE tinyint = 0,
  @EVENTID uniqueidentifier = null,
  @MAILINGID uniqueidentifier = null,
  @BENEFITID uniqueidentifier = null,
  @TARGETSTARTTIME dbo.UDT_HOURMINUTE = '',
  @TARGETENDTIME dbo.UDT_HOURMINUTE = '',
  @TIMEZONEENTRYID uniqueidentifier = null,
  @ISALLDAYEVENT bit = 0,
  @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = '',
  @ACTUALENDTIME dbo.UDT_HOURMINUTE = '',
  @STEPPARTICIPANTS xml = null
)
as
set nocount on;

declare @CURRENTDATE datetime;

if @ID is null
  set @ID = newid();

if @CHANGEAGENTID is null
  exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

set @CURRENTDATE = getdate();

begin try

insert into dbo.BATCHSTEWARDSHIPPLANSTEPUPDATE
( 
  [ID],
  [BATCHID],
  [SEQUENCE],
  [ADDEDBYID],
  [CHANGEDBYID],
  [DATEADDED],
  [DATECHANGED],
  [PRIMARYRECORDID],
  [STEWARDSHIPPLANID],
  [STEPOWNERID],
  [CATEGORYCODEID],
  [OBJECTIVE],
  [TARGETDATE],
  [DATELOCKED],
  [ACTUALDATE],
  [STARTDATE],
  [ENDDATE],
  [CONTACTMETHODCODEID],
  [CONTACTPERSONID],
  [CONSTITUENTID],
  [RECURSCODE],
  [STATUSCODE],
  [NEXTTARGETDATE],
  [EVENTID],
  [MAILINGID],
  [BENEFITID],
  [TARGETSTARTTIME],
  [TARGETENDTIME],
  [TIMEZONEENTRYID],
  [ISALLDAYEVENT],
  [ACTUALSTARTTIME],
  [ACTUALENDTIME]
) values (
  @ID,
  @BATCHID,
  @SEQUENCE,
  @CHANGEAGENTID,
  @CHANGEAGENTID,
  @CURRENTDATE,
  @CURRENTDATE,
  @PRIMARYRECORDID,
  @STEWARDSHIPPLANID,
  @STEPOWNERID,
  @CATEGORYCODEID,
  coalesce(@OBJECTIVE, ''),
  @TARGETDATE,
  coalesce(@DATELOCKED, 0),
  @ACTUALDATE,
  @STARTDATE,
  @ENDDATE,
  @CONTACTMETHODCODEID,
  @CONTACTPERSONID,
  @CONSTITUENTID,
  coalesce(@RECURSCODE, 0),
  coalesce(@STATUSCODE, 0),
  @NEXTTARGETDATE,
  case
    when @LINKTYPECODE = 1 then @EVENTID
    else null
  end,
  case
    when @LINKTYPECODE = 2 then @MAILINGID
    else null
  end,
  case
    when @LINKTYPECODE = 0 then @BENEFITID
    else null
  end,
  coalesce(@TARGETSTARTTIME, ''),
  coalesce(@TARGETENDTIME, ''),
  @TIMEZONEENTRYID,
  coalesce(@ISALLDAYEVENT, 0),
  coalesce(@ACTUALSTARTTIME, ''),
  coalesce(@ACTUALENDTIME, '')
);

exec dbo.USP_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETASSOCIATEDPLANS_ADDFROMXML @ID, @CURRENTAPPUSERID, @ASSOCIATEDPLANS, @CHANGEAGENTID;

exec dbo.USP_BATCHSTEWARDSHIPPLANSTEPUPDATE_GETSTEPPARTICIPANTS_ADDFROMXML @ID, @STEPPARTICIPANTS, @CHANGEAGENTID;

end try
begin catch
  exec.dbo.USP_RAISE_ERROR;
  return 1;
end catch

return 0;