Unlike the pop culture definition, the technical psychological definition is an object/idea/situation without which a person is literally unable to achieve sexual arousal or satisfaction. Really not the same as a turn-on, though that's certainly the common usage.

No, I'm not obsessed--my mother is a psychologist. :p