USP_DATAFORMTEMPLATE_EDIT_AUCTIONDONATIONADJUST

Backwards compatibility SP for adjusting auction donations.

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.
@AMOUNT	money	IN	Value
@DATE	datetime	IN	Date
@EXPIRATIONDATE	datetime	IN	Expiration date
@DESIGNATIONID	uniqueidentifier	IN	Designation
@ADJUSTMENTDATE	datetime	IN	Adjusted date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjusted post date
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment description
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_AUCTIONDONATIONADJUST (
              @ID uniqueidentifier,
              @CHANGEAGENTID uniqueidentifier = null,
              @AMOUNT money,
              @DATE datetime,
              @EXPIRATIONDATE datetime,
              @DESIGNATIONID uniqueidentifier,
              @ADJUSTMENTDATE datetime,
              @ADJUSTMENTPOSTDATE datetime,
              @ADJUSTMENTREASON nvarchar(300),
              @ADJUSTMENTREASONCODEID uniqueidentifier
          )
          as

            set nocount on;

            declare @BASECURRENCYID uniqueidentifier;
            declare @TRANSACTIONCURRENCYID uniqueidentifier;
            declare @BASEEXCHANGERATEID uniqueidentifier;
            declare @EXCHANGERATE decimal(20,8);
            declare @HADSPOTRATE bit;
            declare @RATECHANGED bit;

            declare @DATALOADED bit = 0;

            begin try
                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_AUCTIONDONATIONADJUST
                    @ID = @ID,
                    @DATALOADED = @DATALOADED output,
                    @BASECURRENCYID = @BASECURRENCYID output,
                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                    @EXCHANGERATE = @EXCHANGERATE output,
                    @HADSPOTRATE = @HADSPOTRATE output,
                    @RATECHANGED = @RATECHANGED output;

                if not @DATALOADED = 1 
                    raiserror('Could not load original data from backwards-compatible SP.', 13, 1);

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_AUCTIONDONATIONADJUST_2
                    @ID = @ID,
                    @CHANGEAGENTID = @CHANGEAGENTID,
                    @AMOUNT = @AMOUNT,
                    @DATE = @DATE,
                    @EXPIRATIONDATE = @EXPIRATIONDATE,
                    @DESIGNATIONID = @DESIGNATIONID,
                    @ADJUSTMENTDATE = @ADJUSTMENTDATE,
                    @ADJUSTMENTPOSTDATE = @ADJUSTMENTPOSTDATE,
                    @ADJUSTMENTREASON = @ADJUSTMENTREASON,
                    @ADJUSTMENTREASONCODEID = @ADJUSTMENTREASONCODEID,

                    @BASECURRENCYID = @BASECURRENCYID,
                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID,
                    @EXCHANGERATE = @EXCHANGERATE,
                    @HADSPOTRATE = @HADSPOTRATE,
                    @RATECHANGED = @RATECHANGED;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR;
            end catch