USP_DATAFORMTEMPLATE_EDIT_RATESCALE_PRICES

USP_DATAFORMTEMPLATE_EDIT_RATESCALE_PRICES

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.
@AMOUNT money IN Group of any size pays
@ISSINGLEPRICE bit IN
@PRICES xml IN Prices

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_RATESCALE_PRICES
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @AMOUNT money,
    @ISSINGLEPRICE bit,
    @PRICES xml
)

as
    set nocount on;

    declare @USEPERTICKETAFTERMAX bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RATESCALE_PRICES
        @ID = @ID,
        @USEPERTICKETAFTERMAX = @USEPERTICKETAFTERMAX output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RATESCALE_PRICES_2
        @ID,
        @CHANGEAGENTID,
        @AMOUNT,
        @ISSINGLEPRICE,
        @PRICES,
        @USEPERTICKETAFTERMAX

    return 0;