USP_DATAFORMTEMPLATE_EDIT_JOBOCCURRENCE_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 date
@ENDMONTHDAY	UDT_MONTHDAY	IN	End date
@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(4000)	IN	Comment
@SITEID	uniqueidentifier	IN	Site
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_JOBOCCURRENCE_1_1
(
    @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 int,
    @COMMENTS nvarchar(4000),
    @SITEID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)
as

    declare @ESTIMATEDVALUE money;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_JOBOCCURRENCE_1_1
        @ID = @ID,
        @ESTIMATEDVALUE = @ESTIMATEDVALUE output;

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