USP_DATAFORMTEMPLATE_ADD_PROGRAMGROUP_PRELOAD

The load procedure used by the edit dataform template "Program Group Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@COMBINATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PRICES	xml	INOUT	Prices
@HASONLINEAVAILABILITY	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROGRAMGROUP_PRELOAD
(
    @COMBINATIONID uniqueidentifier,
    @PRICES xml = null output,
    @HASONLINEAVAILABILITY bit = null output
)
as
    set nocount on;

    set @PRICES = (
        select
            ID as COMBINATIONPRICETYPEID,
            null as FACEPRICE
        from
            dbo.COMBINATIONPRICETYPE
        where
            COMBINATIONID = @COMBINATIONID
        order
            by SEQUENCE 
        for xml raw('ITEM'),type,elements,root('PRICES'),BINARY BASE64
    );

    set @HASONLINEAVAILABILITY = dbo.UFN_COMBINATION_HASONLINEAVAILABILITY(@COMBINATIONID);

    return 0;