APPS.AD_UPDATE_PREFS_PKG dependencies on AD_UPDATE_PREF_VALUES

Line 131: l_value ad_update_pref_values.value%TYPE ;

127: p_name IN VARCHAR2,
128: p_session_id IN NUMBER DEFAULT NULL)
129: RETURN VARCHAR2
130: IS
131: l_value ad_update_pref_values.value%TYPE ;
132: BEGIN
133:
134: SELECT value INTO l_value
135: FROM ad_update_pref_values v,ad_update_preferences p

Line 135: FROM ad_update_pref_values v,ad_update_preferences p

131: l_value ad_update_pref_values.value%TYPE ;
132: BEGIN
133:
134: SELECT value INTO l_value
135: FROM ad_update_pref_values v,ad_update_preferences p
136: WHERE v.preference_id=p.preference_id
137: AND owner = upper(p_owner)
138: AND name = upper(p_name)
139: --Check for global or session preference

Line 153: FROM ad_update_pref_values v,ad_update_preferences p

149: BEGIN
150: --If Session level preference is not found get the global preference
151:
152: SELECT value INTO l_value
153: FROM ad_update_pref_values v,ad_update_preferences p
154: WHERE v.preference_id=p.preference_id
155: AND owner = upper(p_owner)
156: AND name = upper(p_name)
157: AND pref_level = 'G';

Line 177: l_value ad_update_pref_values.value%TYPE ;

173: p_name IN VARCHAR2,
174: p_session_id IN NUMBER)
175: RETURN VARCHAR2
176: IS
177: l_value ad_update_pref_values.value%TYPE ;
178: BEGIN
179: --Get the session level preference value for the given parameters
180:
181: SELECT value INTO l_value

Line 182: FROM ad_update_pref_values v,ad_update_preferences p

178: BEGIN
179: --Get the session level preference value for the given parameters
180:
181: SELECT value INTO l_value
182: FROM ad_update_pref_values v,ad_update_preferences p
183: WHERE v.preference_id=p.preference_id
184: AND owner = upper(p_owner)
185: AND name=upper(p_name )
186: AND pref_level = 'S'

Line 209: l_value AD_UPDATE_PREF_VALUES.value%TYPE ;

205: IS
206: p_pref_id AD_UPDATE_PREFERENCES.preference_id%TYPE ;
207: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;
208: l_name AD_UPDATE_PREFERENCES.name%TYPE ;
209: l_value AD_UPDATE_PREF_VALUES.value%TYPE ;
210: BEGIN
211: l_owner := upper(p_owner);
212: l_name := upper(p_name);
213: -- Check the existence of the preference

Line 221: FROM AD_UPDATE_PREF_VALUES

217: END IF;
218: -- Check for the record for the Global Preference Value
219: SELECT value
220: INTO l_value
221: FROM AD_UPDATE_PREF_VALUES
222: WHERE preference_id = p_pref_id
223: AND pref_level = 'G';
224:
225: -- Update the value for the Global Preference

Line 226: UPDATE ad_update_pref_values

222: WHERE preference_id = p_pref_id
223: AND pref_level = 'G';
224:
225: -- Update the value for the Global Preference
226: UPDATE ad_update_pref_values
227: SET value = p_value,
228: last_update_date = SYSDATE,
229: last_updated_by = SYSADMIN_VALUE
230: WHERE preference_id=p_pref_id;

Line 261: FROM ad_update_pref_values

257: END IF;
258:
259: SELECT preference_id
260: INTO p_pref_id
261: FROM ad_update_pref_values
262: WHERE preference_id = p_pref_id
263: AND pref_level = 'G';
264: -- Check if the record for the Global Preference Value already exists
265:

Line 275: INSERT INTO ad_update_pref_values(

271: WHEN NO_DATA_FOUND THEN
272:
273: -- Insert a new record to define the new Global preference value
274:
275: INSERT INTO ad_update_pref_values(
276: preference_id,
277: pref_level,
278: pref_level_value,
279: value,

Line 304: l_pref_id ad_update_pref_values.preference_id%TYPE ;

300: p_name IN VARCHAR2,
301: p_session_id IN NUMBER,
302: p_value IN VARCHAR2)
303: IS
304: l_pref_id ad_update_pref_values.preference_id%TYPE ;
305: BEGIN
306: --Get the preference_id for the given owner,name of the preference
307:
308: SELECT preference_id INTO l_pref_id

Line 314: UPDATE ad_update_pref_values

310: owner = upper(p_owner)
311: AND name = upper(p_name);
312:
313: --Update the preference value for that particular session
314: UPDATE ad_update_pref_values
315: SET value = p_value,
316: last_update_date = SYSDATE,
317: last_updated_by =SYSADMIN_VALUE
318: WHERE

Line 325: INSERT INTO ad_update_pref_values(

321: AND pref_level_value=p_session_id;
322:
323: IF SQL%ROWCOUNT = 0 THEN
324: -- Create new value record if the value record is not updated
325: INSERT INTO ad_update_pref_values(
326: preference_id,
327: pref_level,
328: pref_level_value,
329: value,