you would want to use an "instead of delete" trigger, and update the status to INACTIVE for the row being modified instead of deleting the row. check oracle documentation on how to write the trigger, if you have problems post away.