USP_RESERVATIONSECURITYDEPOSIT_RECALCULATE

create procedure dbo.USP_RESERVATIONSECURITYDEPOSIT_RECALCULATE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin

    if @CHANGEAGENTID is null  
      exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try

    declare @DEPOSITPERCENT decimal(5,2)
    select @DEPOSITPERCENT = SECURITYDEPOSITPERCENT
        from dbo.GROUPSALESDEFAULT

    declare @DEPOSITAMOUNT money 
    set @DEPOSITAMOUNT = round(dbo.UFN_SALESORDER_TOTAL(@ID) * @DEPOSITPERCENT * .01, 2)

    update dbo.RESERVATION set
          SECURITYDEPOSITAMOUNT = @DEPOSITAMOUNT,
          CHANGEDBYID = @CHANGEAGENTID,
          DATECHANGED = @CURRENTDATE
        where ID = @ID

      end try
        begin catch
          exec dbo.USP_RAISE_ERROR
            return 1
        end catch

    return 0;
end