USP_DATAFORMTEMPLATE_EDITLOAD_BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHCOMMIT

The load procedure used by the edit dataform template "Stewardship Plan Step Update Batch Row Commit Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@VALIDATEONLY	bit	INOUT	Validate only
@STEPOWNERID	uniqueidentifier	INOUT
@STEPOWNERNAME	nvarchar(154)	INOUT	Constituent name
@STEPOWNERISINDIVIDUAL	bit	INOUT	Step owner is an individual
@STEWARDSHIPPLANID	uniqueidentifier	INOUT	Plan ID
@CATEGORYCODEID	uniqueidentifier	INOUT	Category
@OBJECTIVE	nvarchar(100)	INOUT	Objective
@TARGETDATE	date	INOUT	Target date
@DATELOCKED	bit	INOUT	Locked
@ACTUALDATE	date	INOUT	Actual date
@STARTDATE	date	INOUT	Frequency start date
@ENDDATE	date	INOUT	Frequency end date
@CONTACTMETHODCODEID	uniqueidentifier	INOUT	Contact method
@CONTACTPERSONID	uniqueidentifier	INOUT	Contact person
@CONSTITUENTID	uniqueidentifier	INOUT	Assigned to
@ASSOCIATEDPLANS	xml	INOUT	Associated plans
@TEMPLATE	nvarchar(100)	INOUT	Template
@RECURSCODE	smallint	INOUT	Frequency
@STATUSCODE	smallint	INOUT	Status
@NEXTTARGETDATE	date	INOUT	Next target date
@LINKTYPECODE	tinyint	INOUT	Connect to
@EVENTID	uniqueidentifier	INOUT	Event
@MAILINGID	uniqueidentifier	INOUT	Mailing
@BENEFITID	uniqueidentifier	INOUT	Benefit
@TARGETSTARTTIME	UDT_HOURMINUTE	INOUT	Target start time
@TARGETENDTIME	UDT_HOURMINUTE	INOUT	Target end time
@TIMEZONEENTRYID	uniqueidentifier	INOUT	Time zone
@ISALLDAYEVENT	bit	INOUT	Is all day event
@ACTUALSTARTTIME	UDT_HOURMINUTE	INOUT	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	INOUT	Actual end time
@STEPPARTICIPANTS	xml	INOUT	Plan participants

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHSTEWARDSHIPPLANSTEPUPDATEBATCHCOMMIT
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @VALIDATEONLY bit = null output,
  @STEPOWNERID uniqueidentifier = null output,
  @STEPOWNERNAME nvarchar(154) = null output,
  @STEPOWNERISINDIVIDUAL bit = null output,
  @STEWARDSHIPPLANID uniqueidentifier = null output,
  @CATEGORYCODEID uniqueidentifier = null output,
  @OBJECTIVE nvarchar(100) = null output,
  @TARGETDATE date = null output,
  @DATELOCKED bit = null output,
  @ACTUALDATE date = null output,
  @STARTDATE date = null output,
  @ENDDATE date = null output,
  @CONTACTMETHODCODEID uniqueidentifier = null output,
  @CONTACTPERSONID uniqueidentifier = null output,
  @CONSTITUENTID uniqueidentifier = null output,
  @ASSOCIATEDPLANS xml = null output,
  @TEMPLATE nvarchar(100) = null output,
  @RECURSCODE smallint = null output,
  @STATUSCODE smallint = null output,
  @NEXTTARGETDATE date = null output,
  @LINKTYPECODE tinyint = null output,
  @EVENTID uniqueidentifier = null output,
  @MAILINGID uniqueidentifier = null output,
  @BENEFITID uniqueidentifier = null output,
  @TARGETSTARTTIME dbo.UDT_HOURMINUTE = null output,
  @TARGETENDTIME dbo.UDT_HOURMINUTE = null output,
  @TIMEZONEENTRYID uniqueidentifier = null output,
  @ISALLDAYEVENT bit = null output,
  @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = null output,
  @ACTUALENDTIME dbo.UDT_HOURMINUTE  = null output,
  @STEPPARTICIPANTS xml = null output)
as
set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  declare @USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_DATALOADED bit;
  declare @USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_TSLONG bigint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_GROUPORG @ID = @ID, @CURRENTAPPUSERID = @CURRENTAPPUSERID, @DATALOADED = @USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_DATALOADED output, @TSLONG = @USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_TSLONG output, @STEPOWNERNAME = @STEPOWNERNAME output, @STEWARDSHIPPLANID = @STEWARDSHIPPLANID output, @CATEGORYCODEID = @CATEGORYCODEID output, @OBJECTIVE = @OBJECTIVE output, @TARGETDATE = @TARGETDATE output, @DATELOCKED = @DATELOCKED output, @ACTUALDATE = @ACTUALDATE output, @STARTDATE = @STARTDATE output, @ENDDATE = @ENDDATE output, @CONTACTMETHODCODEID = @CONTACTMETHODCODEID output, @CONTACTPERSONID = @CONTACTPERSONID output, @CONSTITUENTID = @CONSTITUENTID output, @RECURSCODE = @RECURSCODE output, @STATUSCODE = @STATUSCODE output, @NEXTTARGETDATE = @NEXTTARGETDATE output, @BENEFITID = @BENEFITID output, @EVENTID = @EVENTID output, @MAILINGID = @MAILINGID output, @TARGETSTARTTIME = @TARGETSTARTTIME output, @TARGETENDTIME = @TARGETENDTIME output, @TIMEZONEENTRYID = @TIMEZONEENTRYID output, @ISALLDAYEVENT = @ISALLDAYEVENT output, @ACTUALSTARTTIME = @ACTUALSTARTTIME output, @ACTUALENDTIME = @ACTUALENDTIME output, @STEPOWNERID = @STEPOWNERID output, @STEPOWNERISINDIVIDUAL = @STEPOWNERISINDIVIDUAL output, @LINKTYPECODE = @LINKTYPECODE output, @TEMPLATE = @TEMPLATE output, @ASSOCIATEDPLANS = @ASSOCIATEDPLANS output, @STEPPARTICIPANTS = @STEPPARTICIPANTS output;

  if @ASSOCIATEDPLANS is not null 
    SET @ASSOCIATEDPLANS.modify('delete /ASSOCIATEDPLANS/ITEM/ID') --reset IDs...don't want to reuse ones from the originating table

  if @STEPPARTICIPANTS is not null
    SET @STEPPARTICIPANTS.modify('delete /STEPPARTICIPANTS/ITEM/ID')

  set @DATALOADED = @DATALOADED | @USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_DATALOADED;
  select @TSLONG = convert(bigint,((@TSLONG + @USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_TSLONG) + ABS(@TSLONG - @USP_DATAFORMTEMPLATE_EDITLOAD_STEWARDSHIPPLANSTEP_TSLONG))/2);


return 0;