Detective Inspector John Caldwell was shot several times by dissident republicans in Co Tyrone.