USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTREVENUE

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
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date
@SPLITS	xml	IN	Designations
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@BENEFITS	xml	IN	Benefits
@BENEFITSWAIVED	bit	IN	Benefits waived
@GIVENANONYMOUSLY	bit	IN	Planned gift is anonymous
@MAILINGID	uniqueidentifier	IN	Mailing
@CHANNELCODEID	uniqueidentifier	IN	Inbound channel
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@PLEDGESUBTYPEID	uniqueidentifier	IN	Subtype
@OPPORTUNITYID	uniqueidentifier	IN	Opportunity
@REFERENCE	nvarchar(255)	IN	Reference
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@PERCENTAGEBENEFITS	xml	IN	Benefits

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTREVENUE
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @DATE datetime,
                @AMOUNT money,
                @POSTSTATUSCODE tinyint,
                @POSTDATE datetime,
                @SPLITS xml,
                @SOURCECODE nvarchar(50),
                @APPEALID uniqueidentifier,
                @BENEFITS xml,
                @BENEFITSWAIVED bit,
                @GIVENANONYMOUSLY bit,
                @MAILINGID uniqueidentifier,
                @CHANNELCODEID uniqueidentifier,
                @DONOTACKNOWLEDGE bit,
                @PLEDGESUBTYPEID uniqueidentifier,
                @OPPORTUNITYID uniqueidentifier,
                @REFERENCE nvarchar(255),
                @CATEGORYCODEID uniqueidentifier,
                @PERCENTAGEBENEFITS xml
            )

            as
                set nocount on;

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

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLANNEDGIFTREVENUE
                    @ID = @ID,
                    @BASECURRENCYID = @BASECURRENCYID output,
                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                    @EXCHANGERATE = @EXCHANGERATE output,
                    @HADSPOTRATE = @HADSPOTRATE output,
                    @RATECHANGED = @RATECHANGED output

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTREVENUE_2
                    @ID,
                    @CHANGEAGENTID,
                    @DATE,
                    @AMOUNT,
                    @POSTSTATUSCODE,
                    @POSTDATE,
                    @SPLITS,
                    @SOURCECODE,
                    @APPEALID,
                    @BENEFITS,
                    @BENEFITSWAIVED,
                    @GIVENANONYMOUSLY,
                    @MAILINGID,
                    @CHANNELCODEID,
                    @DONOTACKNOWLEDGE,
                    @PLEDGESUBTYPEID,
                    @OPPORTUNITYID,
                    @REFERENCE,
                    @CATEGORYCODEID,
                    @PERCENTAGEBENEFITS,
                    @BASECURRENCYID,
                    @TRANSACTIONCURRENCYID,
                    @BASEEXCHANGERATEID,
                    @EXCHANGERATE,
                    @HADSPOTRATE,
                    @RATECHANGED

                return 0;