USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_7

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
@SENDPLEDGEREMINDER	bit	IN	Send pledge reminders
@SPLITS	xml	IN	Designations
@FREQUENCYCODE	tinyint	IN	Frequency
@NUMBEROFINSTALLMENTS	int	IN	No. installments remaining
@NEXTTRANSACTIONDATE	datetime	IN	Next installment date
@INSTALLMENTS	xml	IN
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@BENEFITS	xml	IN	Benefits
@BENEFITSWAIVED	bit	IN	Benefits waived
@GIVENANONYMOUSLY	bit	IN	Pledge 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
@ADJUSTMENTDATE	datetime	IN	Adjusted date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjusted post date
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment description
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason
@ADJPAYMENT_DATE	datetime	IN	Adjustment date
@ADJPAYMENT_POSTDATE	datetime	IN	Adjustment post date
@ADJPAYMENT_REASONCODEID	uniqueidentifier	IN	Adjustment reason
@ADJPAYMENT_DETAILS	nvarchar(255)	IN	Adjustment details
@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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_7
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @DATE datetime,
  @AMOUNT money,
  @POSTSTATUSCODE tinyint,
  @POSTDATE datetime,
  @SENDPLEDGEREMINDER bit,
  @SPLITS xml,
  @FREQUENCYCODE tinyint,
  @NUMBEROFINSTALLMENTS int,
  @NEXTTRANSACTIONDATE datetime,
  @INSTALLMENTS 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,
  @ADJUSTMENTDATE datetime,
  @ADJUSTMENTPOSTDATE datetime,
  @ADJUSTMENTREASON nvarchar(300),
  @ADJUSTMENTREASONCODEID uniqueidentifier,
  @ADJPAYMENT_DATE datetime,
  @ADJPAYMENT_POSTDATE datetime,
  @ADJPAYMENT_REASONCODEID uniqueidentifier,
  @ADJPAYMENT_DETAILS nvarchar(255),
  @PERCENTAGEBENEFITS xml,
  @BASECURRENCYID uniqueidentifier,
  @TRANSACTIONCURRENCYID uniqueidentifier,
  @BASEEXCHANGERATEID uniqueidentifier,
  @EXCHANGERATE decimal(20,8),
  @HADSPOTRATE bit,
  @RATECHANGED bit
)
as
begin
    set nocount on;

  declare @UPDATERECOGNITIONOPTION tinyint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLEDGEADJUST_4
    @ID=@ID,
    @UPDATERECOGNITIONOPTION=@UPDATERECOGNITIONOPTION output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_8
         @ID,
        @CHANGEAGENTID,
        @DATE,
        @AMOUNT,
        @POSTSTATUSCODE,
        @POSTDATE,
        @SENDPLEDGEREMINDER,
        @SPLITS,
        @FREQUENCYCODE,
        @NUMBEROFINSTALLMENTS,
        @NEXTTRANSACTIONDATE,
        @INSTALLMENTS,
        @SOURCECODE,
        @APPEALID,
        @BENEFITS,
        @BENEFITSWAIVED,
        @GIVENANONYMOUSLY,
        @MAILINGID,
        @CHANNELCODEID,
        @DONOTACKNOWLEDGE,
        @PLEDGESUBTYPEID,
        @OPPORTUNITYID,
        @REFERENCE,
        @CATEGORYCODEID,
        @ADJUSTMENTDATE,
        @ADJUSTMENTPOSTDATE,
        @ADJUSTMENTREASON,
        @ADJUSTMENTREASONCODEID,
        @ADJPAYMENT_DATE,
        @ADJPAYMENT_POSTDATE,
        @ADJPAYMENT_REASONCODEID,
        @ADJPAYMENT_DETAILS,
        @PERCENTAGEBENEFITS,
        @BASECURRENCYID,
        @TRANSACTIONCURRENCYID,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @HADSPOTRATE,
        @RATECHANGED,
    @UPDATERECOGNITIONOPTION

end