USP_R68PROCESS_COMMIT_POSTCLEANUP

CREATE procedure dbo.USP_R68PROCESS_COMMIT_POSTCLEANUP
(
  @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @TAXCLAIMNUMBER varchar(20)
)
as 
set nocount on;

begin try            
    begin tran

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

  update 
    dbo.R68ARCHIVEDPARAMETERS 
  set 
    TAXCLAIMNUMBER = @TAXCLAIMNUMBER, 
    COMMITTED = 1, 
    CHANGEDBYID = @CHANGEAGENTID, 
    DATECHANGED = Getdate()
  where 
    ID = @ID;

if @@ERROR <> 0
        rollback tran
else
        commit tran
end try

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