APPS.FND_PREFERENCE dependencies on FND_USER_PREFERENCES

Line 16: l_pref_value fnd_user_preferences.preference_value%TYPE;

12: FUNCTION get(p_user_name IN VARCHAR2,
13: p_module_name IN VARCHAR2,
14: p_pref_name IN VARCHAR2) RETURN VARCHAR2
15: IS
16: l_pref_value fnd_user_preferences.preference_value%TYPE;
17: BEGIN
18: SELECT preference_value INTO l_pref_value
19: FROM fnd_user_preferences
20: WHERE user_name=p_user_name

Line 19: FROM fnd_user_preferences

15: IS
16: l_pref_value fnd_user_preferences.preference_value%TYPE;
17: BEGIN
18: SELECT preference_value INTO l_pref_value
19: FROM fnd_user_preferences
20: WHERE user_name=p_user_name
21: AND module_name=p_module_name
22: AND preference_name=p_pref_name;
23: RETURN l_pref_value;

Line 63: UPDATE fnd_user_preferences

59: p_pref_value IN VARCHAR2)
60: IS
61: BEGIN
62:
63: UPDATE fnd_user_preferences
64: SET preference_value=p_pref_value
65: WHERE user_name=p_user_name
66: AND module_name=p_module_name
67: AND preference_name=p_pref_name;

Line 71: INSERT INTO fnd_user_preferences

67: AND preference_name=p_pref_name;
68:
69: IF SQL%notfound THEN
70:
71: INSERT INTO fnd_user_preferences
72: (
73: user_name,
74: module_name,
75: preference_name,

Line 144: FROM fnd_user_preferences

140: IS
141: l_count INTEGER ;
142: BEGIN
143: SELECT COUNT(1) INTO l_count
144: FROM fnd_user_preferences
145: WHERE user_name=p_user_name
146: AND module_name=p_module_name
147: AND preference_name=p_pref_name;
148: IF(l_count=0) THEN

Line 160: DELETE FROM fnd_user_preferences

156: p_module_name IN VARCHAR2,
157: p_pref_name IN VARCHAR2)
158: IS
159: BEGIN
160: DELETE FROM fnd_user_preferences
161: WHERE user_name=p_user_name
162: AND module_name=p_module_name
163: AND preference_name=p_pref_name;
164:

Line 208: DELETE FROM fnd_user_preferences

204: PROCEDURE delete_all(p_user_name IN VARCHAR2,
205: p_module_name IN VARCHAR2)
206: IS
207: BEGIN
208: DELETE FROM fnd_user_preferences
209: WHERE user_name=p_user_name
210: AND module_name=p_module_name;
211: END;
212:

Line 220: l_pref_value fnd_user_preferences.preference_value%TYPE;

216:
217: FUNCTION GetDefined(p_user_name IN VARCHAR2,
218: p_module_name IN VARCHAR2,
219: p_pref_name IN VARCHAR2) RETURN VARCHAR2 IS
220: l_pref_value fnd_user_preferences.preference_value%TYPE;
221: begin
222: select nvl(preference_value,'*NULL*') into l_pref_value
223: from fnd_user_preferences
224: where user_name = p_user_name

Line 223: from fnd_user_preferences

219: p_pref_name IN VARCHAR2) RETURN VARCHAR2 IS
220: l_pref_value fnd_user_preferences.preference_value%TYPE;
221: begin
222: select nvl(preference_value,'*NULL*') into l_pref_value
223: from fnd_user_preferences
224: where user_name = p_user_name
225: and module_name = p_module_name
226: and preference_name = p_pref_name;
227:

Line 246: update fnd_user_preferences

242: if (p_pref_value = '*UNKNOWN*') then
243: return;
244: end if;
245:
246: update fnd_user_preferences
247: set preference_value = decode(p_pref_value, '*NULL*', null, p_pref_value)
248: where user_name = p_user_name
249: and module_name = p_module_name
250: and preference_name = p_pref_name;

Line 253: insert into fnd_user_preferences (

249: and module_name = p_module_name
250: and preference_name = p_pref_name;
251:
252: if SQL%notfound then
253: insert into fnd_user_preferences (
254: user_name,
255: module_name,
256: preference_name,
257: preference_value)