USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPLEVEL2

Parameters

Parameter	Parameter Type	Mode
@ID	nvarchar(50)	IN
@TABID	tinyint	IN
@CHANGEAGENTID	uniqueidentifier	IN
@BASECURRENCYID	uniqueidentifier	IN
@MEMBERSHIPLEVELS	xml	IN
@RECURRINGPRICES	xml	IN
@PROGRAMTYPECODE	tinyint	IN
@PROGRAMBASEDONCODE	tinyint	IN
@ANNUALLYPAYMENTOPTION	bit	IN
@SEMIANNUALLYPAYMENTOPTION	bit	IN
@QUARTERLYPAYMENTOPTION	bit	IN
@MONTHLYPAYMENTOPTION	bit	IN
@MULTITERMPRICES	xml	IN
@LIFETIMEPAYMENTOPTIONS	xml	IN
@MULTIPLETERMSUNITS	xml	IN
@ANNUALLYOPTIONACTIVE	bit	IN
@SEMIANNUALLYOPTIONACTIVE	bit	IN
@QUARTERLYOPTIONACTIVE	bit	IN
@MONTHLYOPTIONACTIVE	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPLEVEL2 (
    @ID nvarchar(50),        --actually the tabid + '@' + recordid

    @TABID tinyint,
    @CHANGEAGENTID uniqueidentifier = null,
    @BASECURRENCYID uniqueidentifier,
    @MEMBERSHIPLEVELS xml,
    @RECURRINGPRICES xml,
    @PROGRAMTYPECODE tinyint,
    @PROGRAMBASEDONCODE tinyint,
    @ANNUALLYPAYMENTOPTION bit,
    @SEMIANNUALLYPAYMENTOPTION bit,
    @QUARTERLYPAYMENTOPTION bit,
    @MONTHLYPAYMENTOPTION bit,
    @MULTITERMPRICES xml,
    @LIFETIMEPAYMENTOPTIONS xml,
    @MULTIPLETERMSUNITS xml,
    @ANNUALLYOPTIONACTIVE bit,
    @SEMIANNUALLYOPTIONACTIVE bit,
    @QUARTERLYOPTIONACTIVE bit,
    @MONTHLYOPTIONACTIVE bit
    )
as

    set nocount on;
    declare @ISTYPEPROGRAM bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPLEVEL2
        @ID = @ID,
        @ISTYPEPROGRAM = @ISTYPEPROGRAM output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPLEVEL2_2
    @ID,        --actually the tabid + '@' + recordid

    @TABID,
    @CHANGEAGENTID,
    @BASECURRENCYID,
    @MEMBERSHIPLEVELS,
    @RECURRINGPRICES,
    @PROGRAMTYPECODE,
    @PROGRAMBASEDONCODE,
    @ANNUALLYPAYMENTOPTION,
    @SEMIANNUALLYPAYMENTOPTION,
    @QUARTERLYPAYMENTOPTION,
    @MONTHLYPAYMENTOPTION,
    @MULTITERMPRICES,
    @LIFETIMEPAYMENTOPTIONS,
    @MULTIPLETERMSUNITS,
    @ANNUALLYOPTIONACTIVE,
    @SEMIANNUALLYOPTIONACTIVE,
    @QUARTERLYOPTIONACTIVE,
    @MONTHLYOPTIONACTIVE,
    @ISTYPEPROGRAM