USP_DATAFORMTEMPLATE_EDIT_JOBOCCURRENCE_1_1_2

The save procedure used by the edit dataform template "Job Occurrence Edit Form 1.1".

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.
@DESCRIPTION	nvarchar(30)	IN	Occurrence name
@DEPARTMENTCODEID	uniqueidentifier	IN	Department
@LOCATIONCODEID	uniqueidentifier	IN	Location
@TYPECODE	tinyint	IN	Type
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@STARTMONTHDAY	UDT_MONTHDAY	IN	Start day (mm/dd)
@ENDMONTHDAY	UDT_MONTHDAY	IN	End day (mm/dd)
@ONESTARTTIME	UDT_HOURMINUTE	IN	Start time
@ONEENDTIME	UDT_HOURMINUTE	IN	End time
@RECSTARTTIME	UDT_HOURMINUTE	IN	Start time
@RECENDTIME	UDT_HOURMINUTE	IN	End time
@DAYOFWEEKCODE	tinyint	IN	Day of week
@EVENTID	uniqueidentifier	IN	Event
@VOLUNTEERSNEEDED	int	IN	Volunteers needed
@COMMENTS	nvarchar(max)	IN	Comment
@SITEID	uniqueidentifier	IN	Site
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@ESTIMATEDVALUE	money	IN	Estimated value

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_JOBOCCURRENCE_1_1_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DESCRIPTION nvarchar(30),
    @DEPARTMENTCODEID uniqueidentifier,
    @LOCATIONCODEID uniqueidentifier,
    @TYPECODE tinyint,
    @STARTDATE datetime,
    @ENDDATE datetime,
    @STARTMONTHDAY dbo.[UDT_MONTHDAY],
    @ENDMONTHDAY dbo.[UDT_MONTHDAY],
    @ONESTARTTIME dbo.[UDT_HOURMINUTE],
    @ONEENDTIME dbo.[UDT_HOURMINUTE],
    @RECSTARTTIME dbo.[UDT_HOURMINUTE],
    @RECENDTIME dbo.[UDT_HOURMINUTE],
    @DAYOFWEEKCODE tinyint,
    @EVENTID uniqueidentifier,
    @VOLUNTEERSNEEDED integer,
    @COMMENTS nvarchar(max),
    @SITEID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @ESTIMATEDVALUE money
)

as
  set nocount on;

    declare @RECURRENCESTARTDATE datetime;
    declare @RECURRENCEENDDATE datetime;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_JOBOCCURRENCE_1_1
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @RECURRENCESTARTDATE = @RECURRENCESTARTDATE output,
        @RECURRENCEENDDATE = @RECURRENCEENDDATE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_JOBOCCURRENCE_1_1_3
        @ID,
        @CHANGEAGENTID,
        @DESCRIPTION,
        @DEPARTMENTCODEID,
        @LOCATIONCODEID,
        @TYPECODE,
        @STARTDATE,
        @ENDDATE,
        @STARTMONTHDAY,
        @ENDMONTHDAY,
        @ONESTARTTIME,
        @ONEENDTIME,
        @RECSTARTTIME,
        @RECENDTIME,
        @DAYOFWEEKCODE,
        @EVENTID,
        @VOLUNTEERSNEEDED,
        @COMMENTS,
        @SITEID,
        @CURRENTAPPUSERID,
        @ESTIMATEDVALUE,
        @RECURRENCESTARTDATE,
        @RECURRENCEENDDATE

  return 0;