USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTREVENUE_2

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	Effort
@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
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASEEXCHANGERATEID	uniqueidentifier	IN	Exchange rate ID
@EXCHANGERATE	decimal(20, 8)	IN	Exchange rate
@HADSPOTRATE	bit	IN	Had spot rate
@RATECHANGED	bit	IN	Rate changed
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTREVENUE_2
(
    @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,
    @BASECURRENCYID uniqueidentifier,
    @TRANSACTIONCURRENCYID uniqueidentifier,
    @BASEEXCHANGERATEID uniqueidentifier,
    @EXCHANGERATE decimal(20,8),
    @HADSPOTRATE bit,
    @RATECHANGED bit,
    @CURRENTAPPUSERID uniqueidentifier = null
)

as
  set nocount on;

    declare @DONOTRECEIPT bit;
    declare @RECEIPTAMOUNT money;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLANNEDGIFTREVENUE
        @ID = @ID,
        @DONOTRECEIPT = @DONOTRECEIPT output,
        @RECEIPTAMOUNT = @RECEIPTAMOUNT output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTREVENUE_3
        @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,
        @CURRENTAPPUSERID,
        @DONOTRECEIPT,
        @RECEIPTAMOUNT

  return 0;