USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_10

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATE	datetime	IN
@AMOUNT	money	IN
@POSTSTATUSCODE	tinyint	IN
@POSTDATE	datetime	IN
@SENDPLEDGEREMINDER	bit	IN
@SPLITS	xml	IN
@FREQUENCYCODE	tinyint	IN
@NUMBEROFINSTALLMENTS	int	IN
@NEXTTRANSACTIONDATE	datetime	IN
@INSTALLMENTS	xml	IN
@SOURCECODE	nvarchar(50)	IN
@APPEALID	uniqueidentifier	IN
@BENEFITS	xml	IN
@BENEFITSWAIVED	bit	IN
@GIVENANONYMOUSLY	bit	IN
@MAILINGID	uniqueidentifier	IN
@CHANNELCODEID	uniqueidentifier	IN
@DONOTACKNOWLEDGE	bit	IN
@PLEDGESUBTYPEID	uniqueidentifier	IN
@OPPORTUNITYID	uniqueidentifier	IN
@REFERENCE	nvarchar(255)	IN
@CATEGORYCODEID	uniqueidentifier	IN
@ADJUSTMENTDATE	datetime	IN
@ADJUSTMENTPOSTDATE	datetime	IN
@ADJUSTMENTREASON	nvarchar(300)	IN
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN
@ADJPAYMENT_DATE	datetime	IN
@ADJPAYMENT_POSTDATE	datetime	IN
@ADJPAYMENT_REASONCODEID	uniqueidentifier	IN
@ADJPAYMENT_DETAILS	nvarchar(255)	IN
@PERCENTAGEBENEFITS	xml	IN
@BASECURRENCYID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@EXCHANGERATE	decimal(20, 8)	IN
@HADSPOTRATE	bit	IN
@RATECHANGED	bit	IN
@UPDATERECOGNITIONOPTION	tinyint	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@UPDATETRIBUTEOPTION	tinyint	IN
@VALIDATETRIBUTES	bit	IN
@ISMEMBERSHIPPLEDGE	bit	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_10
(
    @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,
    @UPDATETRIBUTEOPTION tinyint,
    @VALIDATETRIBUTES bit,
  @ISMEMBERSHIPPLEDGE bit
)

as
  set nocount on;

    declare @INSTALLMENTAMOUNT money;

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

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEADJUST_11
        @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,
        @CURRENTAPPUSERID,
        @UPDATETRIBUTEOPTION,
        @VALIDATETRIBUTES,
        @ISMEMBERSHIPPLEDGE,
    @INSTALLMENTAMOUNT

  return 0;