USP_DATAFORMTEMPLATE_EDIT_ITINERARYITEMCUSTOMITEM

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@ITINERARYID	uniqueidentifier	IN	Itinerary ID
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date
@STARTTIME	UDT_HOURMINUTE	IN	Start time
@ENDTIME	UDT_HOURMINUTE	IN	End time
@NOTES	nvarchar(500)	IN	Notes
@LOCATIONID	uniqueidentifier	IN	Location
@MARKLOCATIONBUSY	bit	IN	Mark location unavailable to other groups
@RESOURCES	xml	IN	Supplies/Equipment resources
@IGNORECONFLICTS	bit	IN	Ignore conflicts when saving
@STAFFRESOURCES	xml	IN	Staffing resources

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ITINERARYITEMCUSTOMITEM
        (
            @ID uniqueidentifier,
            @ITINERARYID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @NAME nvarchar(100),
            @STARTDATE date,
            @ENDDATE date,
            @STARTTIME dbo.UDT_HOURMINUTE,
            @ENDTIME dbo.UDT_HOURMINUTE,
            @NOTES nvarchar(500),
            @LOCATIONID uniqueidentifier,
            @MARKLOCATIONBUSY bit,
            @RESOURCES xml,
            @IGNORECONFLICTS bit,
            @STAFFRESOURCES xml
        )

        as
            set nocount on;

            declare @LOCATIONPRICE money;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ITINERARYITEMCUSTOMITEM
                @ID = @ID,
                @LOCATIONPRICE = @LOCATIONPRICE output

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_ITINERARYITEMCUSTOMITEM_2
                @ID,
                @ITINERARYID,
                @CHANGEAGENTID,
                @NAME,
                @STARTDATE,
                @ENDDATE,
                @STARTTIME,
                @ENDTIME,
                @NOTES,
                @LOCATIONID,
                @MARKLOCATIONBUSY,
                @RESOURCES,
                @IGNORECONFLICTS,
                @STAFFRESOURCES,
                @LOCATIONPRICE

            return 0;