Two men have been arrested over the attempted murder of a senior police detective in Northern Ireland.