USP_DATAFORMTEMPLATE_EDIT_GROUPSALESCHECKINVISITOR

USP_DATAFORMTEMPLATE_EDIT_GROUPSALESCHECKINVISITOR

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.
@ITINERARIES xml IN
@PRICETYPES xml IN
@RESOURCES xml IN Resources
@STAFFRESOURCES xml IN Staffing resources
@UPDATERATESCALE bit IN Update group rate based on new number of visitors
@IGNORECONFLICTS bit IN Ignore conflicts when checking in
@ADDITIONALPRICETYPES xml IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GROUPSALESCHECKINVISITOR
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @ITINERARIES xml,
    @PRICETYPES xml,
    @RESOURCES xml,
    @STAFFRESOURCES xml,
    @UPDATERATESCALE bit,
    @IGNORECONFLICTS bit,
    @ADDITIONALPRICETYPES xml
)
as
    set nocount on;

    declare @UPDATEPERTICKETBALANCE bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GROUPSALESCHECKINVISITOR
        @ID = @ID,
        @UPDATEPERTICKETBALANCE = @UPDATEPERTICKETBALANCE output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_GROUPSALESCHECKINVISITOR_2
        @ID,
        @CHANGEAGENTID,
        @ITINERARIES,
        @PRICETYPES,
        @RESOURCES,
        @STAFFRESOURCES,
        @UPDATERATESCALE,
        @IGNORECONFLICTS,
        @ADDITIONALPRICETYPES,
        @UPDATEPERTICKETBALANCE;

    return 0;