USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED	tinyint	IN
@CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE	tinyint	IN
@CONTRIBUTIONINCLUDEEVENTTYPECODE	tinyint	IN
@CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE	tinyint	IN
@WHATHAPPENSIFTHEYGIVEMORECODE	tinyint	IN
@WHATDATETOCALCULATEEXPIRATIONDATECODE	tinyint	IN
@CONTRIBUTIONMEMBERSHIPPROGRAMID	uniqueidentifier	IN
@CONTRIBUTIONEVENTCATEGORYCODEID	uniqueidentifier	IN
@CONTRIBUTIONDESIGNATIONID	uniqueidentifier	IN
@CONTRIBUTIONISEVENTREGISTRATIONCOUNTED	bit	IN
@CONTRIBUTIONISMEMBERSHIPDUECOUNTED	bit	IN
@CONTRIBUTIONISPAYMENTCOUNTED	bit	IN
@CONTRIBUTIONISPLEDGECOUNTED	bit	IN
@CONTRIBUTIONISRECURRINGGIFTCOUNTED	bit	IN
@CONTRIBUTIONIDSETREGISTERID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES 
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED tinyint,
    @CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE tinyint,
    @CONTRIBUTIONINCLUDEEVENTTYPECODE tinyint,
    @CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE tinyint,
    @WHATHAPPENSIFTHEYGIVEMORECODE tinyint,
    @WHATDATETOCALCULATEEXPIRATIONDATECODE tinyint,
    @CONTRIBUTIONMEMBERSHIPPROGRAMID uniqueidentifier,
    @CONTRIBUTIONEVENTCATEGORYCODEID uniqueidentifier,
    @CONTRIBUTIONDESIGNATIONID uniqueidentifier,
    @CONTRIBUTIONISEVENTREGISTRATIONCOUNTED bit,
    @CONTRIBUTIONISMEMBERSHIPDUECOUNTED bit,
    @CONTRIBUTIONISPAYMENTCOUNTED bit,
    @CONTRIBUTIONISPLEDGECOUNTED bit,
    @CONTRIBUTIONISRECURRINGGIFTCOUNTED bit,
    @CONTRIBUTIONIDSETREGISTERID uniqueidentifier
)
as

    set nocount on;

    declare @CONTRIBUTIONCRITERIADEFINITIONTYPECODE tinyint;
    declare @CONTRIBUTIONAPPLICATIONSELECTIONID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES
        @ID = @ID,
        @CONTRIBUTIONCRITERIADEFINITIONTYPECODE = @CONTRIBUTIONCRITERIADEFINITIONTYPECODE,
        @CONTRIBUTIONAPPLICATIONSELECTIONID = @CONTRIBUTIONAPPLICATIONSELECTIONID

    -- handle updating the data

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES_2
        @ID,
        @CHANGEAGENTID,
        @CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED,
        @CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE,
        @CONTRIBUTIONINCLUDEEVENTTYPECODE,
        @CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE,
        @WHATHAPPENSIFTHEYGIVEMORECODE,
        @WHATDATETOCALCULATEEXPIRATIONDATECODE,
        @CONTRIBUTIONMEMBERSHIPPROGRAMID,
        @CONTRIBUTIONEVENTCATEGORYCODEID,
        @CONTRIBUTIONDESIGNATIONID,
        @CONTRIBUTIONISEVENTREGISTRATIONCOUNTED,
        @CONTRIBUTIONISMEMBERSHIPDUECOUNTED,
        @CONTRIBUTIONISPAYMENTCOUNTED,
        @CONTRIBUTIONISPLEDGECOUNTED,
        @CONTRIBUTIONISRECURRINGGIFTCOUNTED,
        @CONTRIBUTIONIDSETREGISTERID,
        @CONTRIBUTIONCRITERIADEFINITIONTYPECODE,
        @CONTRIBUTIONAPPLICATIONSELECTIONID

    return 0;