USP_DATAFORMTEMPLATE_EDIT_ITINERARYITEMCUSTOMRESOLVE

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.
@ITINERARYID	uniqueidentifier	IN	Itinerary ID
@STARTDATE	datetime	IN	Date
@ENDDATE	datetime	IN	Date
@STARTTIME	UDT_HOURMINUTE	IN	Start time
@ENDTIME	UDT_HOURMINUTE	IN	End time
@LOCATIONID	uniqueidentifier	IN	Location
@RESOURCES	xml	IN	Supplies/Equipment resources
@STAFFRESOURCES	xml	IN	Staff resources
@IGNORECONFLICTS	bit	IN	Ignore conflicts when saving
@COMPUTEDITEMTYPECODE	tinyint	IN	Item type

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ITINERARYITEMCUSTOMRESOLVE
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @ITINERARYID uniqueidentifier,
            @STARTDATE datetime,
            @ENDDATE datetime,
            @STARTTIME UDT_HOURMINUTE,
            @ENDTIME UDT_HOURMINUTE,
            @LOCATIONID uniqueidentifier,
            @RESOURCES xml,
            @STAFFRESOURCES xml,
            @IGNORECONFLICTS bit,
            @COMPUTEDITEMTYPECODE tinyint
        )

        as
            set nocount on;

            declare @LOCATIONPRICE money;

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

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_ITINERARYITEMCUSTOMRESOLVE_2
                @ID,
                @CHANGEAGENTID,
                @ITINERARYID,
                @STARTDATE,
                @ENDDATE,
                @STARTTIME,
                @ENDTIME,
                @LOCATIONID,
                @RESOURCES,
                @STAFFRESOURCES,
                @IGNORECONFLICTS,
                @COMPUTEDITEMTYPECODE,
                @LOCATIONPRICE;

            return 0;