USP_DATAFORMTEMPLATE_EDIT_MGPLEDGE_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.
@ORIGINALGIFTID	uniqueidentifier	IN	Original Gift
@MATCHINGORGANIZATIONID	uniqueidentifier	IN	Matching organization
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@SPLITS	xml	IN	Designations
@MATCHINGGIFTCONDITIONID	uniqueidentifier	IN	Matching gift condition type
@RELATIONSHIPID	uniqueidentifier	IN	Relationship
@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_MGPLEDGE_4
(
  @ID uniqueidentifier, 
  @CHANGEAGENTID uniqueidentifier,
  @ORIGINALGIFTID uniqueidentifier,
  @MATCHINGORGANIZATIONID uniqueidentifier,
  @DATE datetime,
  @AMOUNT money,
  @SPLITS xml,
  @MATCHINGGIFTCONDITIONID uniqueidentifier,
  @RELATIONSHIPID uniqueidentifier,
  @BASECURRENCYID uniqueidentifier,
  @TRANSACTIONCURRENCYID uniqueidentifier,
  @BASEEXCHANGERATEID uniqueidentifier,
  @EXCHANGERATE decimal(20,8),
  @HADSPOTRATE bit,
  @RATECHANGED bit
)
as
begin
  set nocount on;

  declare @UPDATERECOGNITIONOPTION tinyint = 0

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

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_MGPLEDGE_5
    @ID,
    @CHANGEAGENTID,
    @ORIGINALGIFTID,
    @MATCHINGORGANIZATIONID,
    @DATE,
    @AMOUNT,
    @SPLITS,
    @MATCHINGGIFTCONDITIONID,
    @RELATIONSHIPID,
    @BASECURRENCYID,
    @TRANSACTIONCURRENCYID,
    @BASEEXCHANGERATEID,
    @EXCHANGERATE,
    @HADSPOTRATE,
    @RATECHANGED,
    @UPDATERECOGNITIONOPTION

  return 0;
end