USP_AUCTIONPURCHASE_UPDATEPAYMENT

Updates a payment towards an auction purchase.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@AMOUNT	money	IN
@CHANGEDATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



      CREATE procedure dbo.USP_AUCTIONPURCHASE_UPDATEPAYMENT
      (
        @ID uniqueidentifier,
                @AMOUNT money,
                @CHANGEDATE datetime = null,
                @CHANGEAGENTID uniqueidentifier = null
      )
      as
      begin
          set nocount on;

        declare @ORIGINALAMOUNT money;

        select 
          @ORIGINALAMOUNT = REVENUESPLIT.AMOUNT
        from
          dbo.AUCTIONITEM
          inner join dbo.AUCTIONITEMPURCHASE on AUCTIONITEM.ID = AUCTIONITEMPURCHASE.AUCTIONITEMID
          inner join dbo.REVENUESPLIT on AUCTIONITEMPURCHASE.PURCHASEID = REVENUESPLIT.ID
        where
          REVENUESPLIT.ID = @ID

        if @ORIGINALAMOUNT <> @AMOUNT
          raiserror('BBERR_AUCTIONPURCHASE_INVALIDAMOUNT', 13, 1)

      end