USP_DATAFORMTEMPLATE_EDIT_PLEDGE_5

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 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	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
@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_PLEDGE_5
(
    @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,
    @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 = 0;
  declare @UPDATETRIBUTEOPTION tinyint = null;
  declare @VALIDATETRIBUTES bit = null;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLEDGE_3
    @ID = @ID,
    @UPDATERECOGNITIONOPTION = @UPDATERECOGNITIONOPTION output,
    @UPDATETRIBUTEOPTION = @UPDATETRIBUTEOPTION output,
    @VALIDATETRIBUTES = @VALIDATETRIBUTES output;

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

  return 0;
end