DBA Data[Home] [Help]

APPS.WFA_SEC dependencies on WF_PREF

Line 18: -- True if Token Resource WF_PREFERENCE is set to FND

14: --
15: -- Use_Fnd_Preferences (PRIVATE)
16: -- Find out whether we should use FND Preference or not
17: -- Return
18: -- True if Token Resource WF_PREFERENCE is set to FND
19: -- False otherwise or if the above token is not set
20: --
21: function Use_Fnd_Preferences
22: return boolean

Line 26: if (wf_core.translate('WF_PREFERENCE') = 'FND') then

22: return boolean
23: is
24: begin
25: if (wf_use_fnd_preferences is null) then
26: if (wf_core.translate('WF_PREFERENCE') = 'FND') then
27: wf_use_fnd_preferences := true;
28: else
29: wf_use_fnd_preferences := false;
30: end if;

Line 270: c_date_format := ''''||NVL(wf_pref.get_pref(user_name,'DATEFORMAT'),

266: -- get the date format preference
267: c_date_format := ''''||NVL(fnd_profile.value_specific(
268: 'ICX_DATE_FORMAT_MASK',l_user_id, null, null),'DD-MON-RRRR')||'''';
269: else
270: c_date_format := ''''||NVL(wf_pref.get_pref(user_name,'DATEFORMAT'),
271: 'DD-MON-RRRR')||'''';
272: end if;
273:
274: dbms_session.set_nls('NLS_LANGUAGE' , c_language);

Line 577: notification_preference := nvl(WF_PREF.get_pref(name,'MAILTYPE'),

573:
574: --
575: if (orig_system in ('FND_USR', 'PER')) then
576: if (Use_FND_Preferences) then
577: notification_preference := nvl(WF_PREF.get_pref(name,'MAILTYPE'),
578: 'MAILHTML');
579: language := WF_PREF.get_pref(name, 'LANGUAGE');
580: territory := WF_PREF.get_pref(name, 'TERRITORY');
581:

Line 579: language := WF_PREF.get_pref(name, 'LANGUAGE');

575: if (orig_system in ('FND_USR', 'PER')) then
576: if (Use_FND_Preferences) then
577: notification_preference := nvl(WF_PREF.get_pref(name,'MAILTYPE'),
578: 'MAILHTML');
579: language := WF_PREF.get_pref(name, 'LANGUAGE');
580: territory := WF_PREF.get_pref(name, 'TERRITORY');
581:
582: else
583: if (orig_system = 'PER') then

Line 580: territory := WF_PREF.get_pref(name, 'TERRITORY');

576: if (Use_FND_Preferences) then
577: notification_preference := nvl(WF_PREF.get_pref(name,'MAILTYPE'),
578: 'MAILHTML');
579: language := WF_PREF.get_pref(name, 'LANGUAGE');
580: territory := WF_PREF.get_pref(name, 'TERRITORY');
581:
582: else
583: if (orig_system = 'PER') then
584: SELECT USER_ID

Line 594: notification_preference := nvl(WF_PREF.get_pref(name,'MAILTYPE'),

590: fndUserID := orig_system_ID;
591:
592: end if;
593:
594: notification_preference := nvl(WF_PREF.get_pref(name,'MAILTYPE'),
595: 'MAILHTML');
596:
597: -- <7578908> "-1" instead of NULL for ctx parameters other than USER_ID, so that
598: -- NOT to use current login ctx when calling fnd_profile.value_specific.