DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on FND_PREFERENCE

Line 2827: -- using substr since fnd_preference.get returns varchar2(240)

2823: wf_event.AddParameterToList('ORCLNLSTERRITORY', myTerr, myList);
2824:
2825: -- begin bug 3280951
2826: -- Retrieve the notification preference for the user
2827: -- using substr since fnd_preference.get returns varchar2(240)
2828: -- and this maps to varchar2(8) column on WF side.
2829: l_userNTFPref := substr(fnd_preference.get(UPPER(p_user_name), 'WF', 'MAILTYPE'), 1, 8);
2830:
2831: if (l_userNTFPref is NULL) then

Line 2829: l_userNTFPref := substr(fnd_preference.get(UPPER(p_user_name), 'WF', 'MAILTYPE'), 1, 8);

2825: -- begin bug 3280951
2826: -- Retrieve the notification preference for the user
2827: -- using substr since fnd_preference.get returns varchar2(240)
2828: -- and this maps to varchar2(8) column on WF side.
2829: l_userNTFPref := substr(fnd_preference.get(UPPER(p_user_name), 'WF', 'MAILTYPE'), 1, 8);
2830:
2831: if (l_userNTFPref is NULL) then
2832: --There is no preference for the user, so retrieving the global.
2833: l_userNTFPref := substr(fnd_preference.get('-WF_DEFAULT-', 'WF', 'MAILTYPE'), 1, 8);

Line 2833: l_userNTFPref := substr(fnd_preference.get('-WF_DEFAULT-', 'WF', 'MAILTYPE'), 1, 8);

2829: l_userNTFPref := substr(fnd_preference.get(UPPER(p_user_name), 'WF', 'MAILTYPE'), 1, 8);
2830:
2831: if (l_userNTFPref is NULL) then
2832: --There is no preference for the user, so retrieving the global.
2833: l_userNTFPref := substr(fnd_preference.get('-WF_DEFAULT-', 'WF', 'MAILTYPE'), 1, 8);
2834:
2835: end if;
2836:
2837: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',