That set in each app - if the app has a setting for the notification sound. Some just have "notification sound on" and "notification sound off" and use the default notification sound. (And you'd have to email the developer and ask for the app to be changed.)