DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on FND_PREFERENCE

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

2216: wf_event.AddParameterToList('ORCLNLSTERRITORY', myTerr, myList);
2217:
2218: -- begin bug 3280951
2219: -- Retrieve the notification preference for the user
2220: -- using substr since fnd_preference.get returns varchar2(240)
2221: -- and this maps to varchar2(8) column on WF side.
2222: l_userNTFPref := substr(fnd_preference.get(UPPER(p_user_name), 'WF', 'MAILTYPE'), 1, 8);
2223:
2224: if (l_userNTFPref is NULL) then

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

2218: -- begin bug 3280951
2219: -- Retrieve the notification preference for the user
2220: -- using substr since fnd_preference.get returns varchar2(240)
2221: -- and this maps to varchar2(8) column on WF side.
2222: l_userNTFPref := substr(fnd_preference.get(UPPER(p_user_name), 'WF', 'MAILTYPE'), 1, 8);
2223:
2224: if (l_userNTFPref is NULL) then
2225: --There is no preference for the user, so retrieving the global.
2226: l_userNTFPref := substr(fnd_preference.get('-WF_DEFAULT-', 'WF', 'MAILTYPE'), 1, 8);

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

2222: l_userNTFPref := substr(fnd_preference.get(UPPER(p_user_name), 'WF', 'MAILTYPE'), 1, 8);
2223:
2224: if (l_userNTFPref is NULL) then
2225: --There is no preference for the user, so retrieving the global.
2226: l_userNTFPref := substr(fnd_preference.get('-WF_DEFAULT-', 'WF', 'MAILTYPE'), 1, 8);
2227:
2228: end if;
2229:
2230: wf_event.AddParameterToList('ORCLWORKFLOWNOTIFICATIONPREF',