USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTADDITION

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.
@EXPECTEDGIFTAMOUNT	money	IN	Gift amount
@RECOGNITIONAMOUNT	money	IN	Recognition amount
@GIFTDATE	datetime	IN	Date
@DESIGNATION	xml	IN	Planned gift addition details
@ASSETS	xml	IN	Assets
@BASEEXCHANGERATEID	uniqueidentifier	IN	Exchange rate ID
@EXCHANGERATE	decimal(20, 8)	IN	Exchange rate
@HADSPOTRATE	bit	IN	Had spot rate
@RATECHANGED	bit	IN	Rate changed
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTADDITION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @EXPECTEDGIFTAMOUNT money,
    @RECOGNITIONAMOUNT money,
    @GIFTDATE datetime,
    @DESIGNATION xml,
    @ASSETS xml,
    @BASEEXCHANGERATEID uniqueidentifier,
    @EXCHANGERATE decimal(20,8),
    @HADSPOTRATE bit,
    @RATECHANGED bit,
    @CURRENTAPPUSERID uniqueidentifier
)

as
  set nocount on;

    declare @DONOTRECEIPT bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLANNEDGIFTADDITION
        @ID = @ID,
        @DONOTRECEIPT = @DONOTRECEIPT output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLANNEDGIFTADDITION_2
        @ID,
        @CHANGEAGENTID,
        @EXPECTEDGIFTAMOUNT,
        @RECOGNITIONAMOUNT,
        @GIFTDATE,
        @DESIGNATION,
        @ASSETS,
        @BASEEXCHANGERATEID,
        @EXCHANGERATE,
        @HADSPOTRATE,
        @RATECHANGED,
        @CURRENTAPPUSERID,
        @DONOTRECEIPT

  return 0;