USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_8

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
@UPDATERECOGNITIONOPTION	tinyint	IN	Update recognition option
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_8
            (
              @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,
              @UPDATERECOGNITIONOPTION tinyint,
              @CURRENTAPPUSERID uniqueidentifier = null

            )
            as
            begin
              set nocount on;

              declare @UPDATETRIBUTEOPTION tinyint;

              declare @HASTRIBUTE bit = 1;

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

              exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_9
                     @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,
                    @UPDATETRIBUTEOPTION,
                    @HASTRIBUTE
            end