USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFT_4

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
@SPLITS	xml	IN	Designations
@FREQUENCYCODE	tinyint	IN	Frequency
@ENDDATE	datetime	IN	Ending on
@STARTDATE	datetime	IN	Next transaction
@FINDERNUMBER	bigint	IN	Finder number
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@GIVENANONYMOUSLY	bit	IN	Recurring gift is anonymous
@MAILINGID	uniqueidentifier	IN	Effort
@CHANNELCODEID	uniqueidentifier	IN	Inbound channel
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@REFERENCE	nvarchar(255)	IN	Reference
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@SENDREMINDER	bit	IN	Send reminders
@NEXTINSTALLMENTID	uniqueidentifier	IN
@REVENUEDEVELOPMENTFUNCTIONCODEID	uniqueidentifier	IN	Revenue function
@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_RECURRINGGIFT_4
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @DATE datetime,
  @AMOUNT money,
  @SPLITS xml,
  @FREQUENCYCODE tinyint,
  @ENDDATE datetime,
  @STARTDATE datetime,
  @FINDERNUMBER bigint,
  @SOURCECODE nvarchar(50),
  @APPEALID uniqueidentifier,
  @GIVENANONYMOUSLY bit,
  @MAILINGID uniqueidentifier,
  @CHANNELCODEID uniqueidentifier,
  @DONOTACKNOWLEDGE bit,
  @REFERENCE nvarchar(255),
  @CATEGORYCODEID uniqueidentifier,
  @SENDREMINDER bit,
  @NEXTINSTALLMENTID uniqueidentifier,
  @REVENUEDEVELOPMENTFUNCTIONCODEID uniqueidentifier,
  @TRANSACTIONCURRENCYID uniqueidentifier,
  @BASEEXCHANGERATEID uniqueidentifier,
  @EXCHANGERATE decimal(20,8),
  @HADSPOTRATE bit,
  @RATECHANGED bit
)
as
begin
  set nocount on;

  declare @UPDATERECOGNITIONOPTION tinyint = 2;
  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECURRINGGIFT_2
    @ID=@ID,
    @UPDATERECOGNITIONOPTION=@UPDATERECOGNITIONOPTION output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECURRINGGIFT_5
    @ID,
    @CHANGEAGENTID,
    @DATE,
    @AMOUNT,
    @SPLITS,
    @FREQUENCYCODE,
    @ENDDATE,
    @STARTDATE,
    @FINDERNUMBER,
    @SOURCECODE,
    @APPEALID,
    @GIVENANONYMOUSLY,
    @MAILINGID,
    @CHANNELCODEID,
    @DONOTACKNOWLEDGE,
    @REFERENCE,
    @CATEGORYCODEID,
    @SENDREMINDER,
    @NEXTINSTALLMENTID,
    @REVENUEDEVELOPMENTFUNCTIONCODEID,
    @TRANSACTIONCURRENCYID,
    @BASEEXCHANGERATEID,
    @EXCHANGERATE,
    @HADSPOTRATE,
    @RATECHANGED,
    @UPDATERECOGNITIONOPTION;

  return 0;

end