USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMDUESBASEDRULES

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DUESTREATEDASCONTRIBUTION	bit	IN
@DUESONEPAYMENTEACHTERM	bit	IN
@DUESMULTIPLEPAYMENTSEACHTERM	bit	IN
@DESIGNATIONSFORCONTRIBUTEDPORTION	xml	IN
@MEMBERSHIPLEVELDESIGNATIONS	xml	IN
@PROGRAMTYPECODE	tinyint	IN
@DISCOUNTSFORPROGRAM	xml	IN
@BASECURRENCYID	uniqueidentifier	IN
@DEDUCTIBILITYCODE	tinyint	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMDUESBASEDRULES (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DUESTREATEDASCONTRIBUTION bit,
    @DUESONEPAYMENTEACHTERM bit,
    @DUESMULTIPLEPAYMENTSEACHTERM bit,
    @DESIGNATIONSFORCONTRIBUTEDPORTION xml,
    @MEMBERSHIPLEVELDESIGNATIONS xml,
    @PROGRAMTYPECODE tinyint,
    @DISCOUNTSFORPROGRAM xml,
    @BASECURRENCYID uniqueidentifier,
    @DEDUCTIBILITYCODE tinyint
)
as
begin
    set nocount on;

  declare @DUESINSTALLMENTPOSTSTATUSCODE tinyint = null;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAMDUESBASEDRULES @ID = @ID, @DUESINSTALLMENTPOSTSTATUSCODE = @DUESINSTALLMENTPOSTSTATUSCODE

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMDUESBASEDRULES_2
        @ID,
        @CHANGEAGENTID,
        @DUESTREATEDASCONTRIBUTION,
        @DUESONEPAYMENTEACHTERM,
        @DUESMULTIPLEPAYMENTSEACHTERM,
        @DESIGNATIONSFORCONTRIBUTEDPORTION,
        @MEMBERSHIPLEVELDESIGNATIONS,
        @PROGRAMTYPECODE,
        @DISCOUNTSFORPROGRAM,
        @BASECURRENCYID,
        @DEDUCTIBILITYCODE,
        @DUESINSTALLMENTPOSTSTATUSCODE; --DUESINSTALLMENTPOSTCODE

end