USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPLEVEL2_2

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
@ISTYPEPROGRAM	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPLEVEL2_2 (
    @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,
    @ISTYPEPROGRAM bit
)
as
begin
    set nocount on;

  declare @LIFETIMEINSTALLMENTPOSTSTATUSCODE tinyint = null;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPLEVEL2 @ID = @ID, @LIFETIMEINSTALLMENTPOSTSTATUSCODE = @LIFETIMEINSTALLMENTPOSTSTATUSCODE output;

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPLEVEL2_3
        @ID,
        @TABID,
        @CHANGEAGENTID,
        @BASECURRENCYID,
        @MEMBERSHIPLEVELS,
        @RECURRINGPRICES,
        @PROGRAMTYPECODE,
        @PROGRAMBASEDONCODE,
        @ANNUALLYPAYMENTOPTION,
        @SEMIANNUALLYPAYMENTOPTION,
        @QUARTERLYPAYMENTOPTION,
        @MONTHLYPAYMENTOPTION,
        @MULTITERMPRICES,
        @LIFETIMEPAYMENTOPTIONS,
        @MULTIPLETERMSUNITS,
        @ANNUALLYOPTIONACTIVE,
        @SEMIANNUALLYOPTIONACTIVE,
        @QUARTERLYOPTIONACTIVE,
        @MONTHLYOPTIONACTIVE,
        @ISTYPEPROGRAM,
        @LIFETIMEINSTALLMENTPOSTSTATUSCODE --@LIFETIMEINSTALLMENTPOSTCODE 

end