USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFT_3

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@SPLITS	xml	IN	Designations
@FREQUENCYCODE	tinyint	IN	Frequency
@ENDDATE	datetime	IN	Ending on
@STARTDATE	datetime	IN	Next transaction
@FINDERNUMBER	bigint	IN	Finder number
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@GIVENANONYMOUSLY	bit	IN	Recurring gift is anonymous
@MAILINGID	uniqueidentifier	IN	Mailing
@CHANNELCODEID	uniqueidentifier	IN	Inbound channel
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@REFERENCE	nvarchar(255)	IN	Reference
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@SENDREMINDER	bit	IN	Send reminders
@NEXTINSTALLMENTID	uniqueidentifier	IN
@REVENUEDEVELOPMENTFUNCTIONCODEID	uniqueidentifier	IN	Revenue function

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFT_3
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @DATE datetime,
                @AMOUNT money,
                @SPLITS xml,
                @FREQUENCYCODE tinyint,
                @ENDDATE datetime,
                @STARTDATE datetime,
                @FINDERNUMBER bigint,
                @SOURCECODE nvarchar(50),
                @APPEALID uniqueidentifier,
                @GIVENANONYMOUSLY bit,
                @MAILINGID uniqueidentifier,
                @CHANNELCODEID uniqueidentifier,
                @DONOTACKNOWLEDGE bit,
                @REFERENCE nvarchar(255),
                @CATEGORYCODEID uniqueidentifier,
                @SENDREMINDER bit,
                @NEXTINSTALLMENTID uniqueidentifier,
                @REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier
            )
            as
            begin
                set nocount on;

                declare @TRANSACTIONCURRENCYID uniqueidentifier;
                declare @BASEEXCHANGERATEID uniqueidentifier;
                declare @EXCHANGERATE decimal(20,8);
                declare @HADSPOTRATE bit;
                declare @RATECHANGED bit;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFT_2
                    @ID = @ID,
                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                    @EXCHANGERATE = @EXCHANGERATE output,
                    @HADSPOTRATE = @HADSPOTRATE output,
                    @RATECHANGED = @RATECHANGED output;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFT_4
                    @ID,
                    @CHANGEAGENTID,
                    @DATE,
                    @AMOUNT,
                    @SPLITS,
                    @FREQUENCYCODE,
                    @ENDDATE,
                    @STARTDATE,
                    @FINDERNUMBER,
                    @SOURCECODE,
                    @APPEALID,
                    @GIVENANONYMOUSLY,
                    @MAILINGID,
                    @CHANNELCODEID,
                    @DONOTACKNOWLEDGE,
                    @REFERENCE,
                    @CATEGORYCODEID,
                    @SENDREMINDER,
                    @NEXTINSTALLMENTID,
                    @REVENUEDEVELOPMENTFUNCTIONCODEID,
                    @TRANSACTIONCURRENCYID,
                    @BASEEXCHANGERATEID,
                    @EXCHANGERATE,
                    @HADSPOTRATE,
                    @RATECHANGED;
            end