APPS.OKC_ASYNC_PVT dependencies on WF_PREF

Line 28: NVL(wf_pref.get_pref(USR.USER_NAME, 'LANGUAGE'), FNDL.NLS_LANGUAGE) language,

24: -- changed to go of users directly JEG 11/30/2000
25: --
26: cursor nls_csr is
27: select
28: NVL(wf_pref.get_pref(USR.USER_NAME, 'LANGUAGE'), FNDL.NLS_LANGUAGE) language,
29: NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,
30: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
31: notification_preference
32: from fnd_languages fndl,

Line 29: NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,

25: --
26: cursor nls_csr is
27: select
28: NVL(wf_pref.get_pref(USR.USER_NAME, 'LANGUAGE'), FNDL.NLS_LANGUAGE) language,
29: NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,
30: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
31: notification_preference
32: from fnd_languages fndl,
33: fnd_user usr

Line 30: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')

26: cursor nls_csr is
27: select
28: NVL(wf_pref.get_pref(USR.USER_NAME, 'LANGUAGE'), FNDL.NLS_LANGUAGE) language,
29: NVL(wf_pref.get_pref(USR.USER_NAME, 'TERRITORY'), FNDL.NLS_TERRITORY) territory,
30: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
31: notification_preference
32: from fnd_languages fndl,
33: fnd_user usr
34: where usr.user_name = p_recipient

Line 1083: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')

1079: -- changed to go of users directly JEG 11/30/2000
1080: --
1081: cursor pref_csr is
1082: select
1083: NVL(wf_pref.get_pref(USR.USER_NAME,'MAILTYPE'),'MAILHTML')
1084: notification_preference
1085: from fnd_user usr
1086: where usr.user_name = p_recipient;
1087: