eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_UPDATE_PREFS_PKG dependencies on AD_UPDATE_PREFERENCES

Line 10: l_owner ad_update_preferences.owner%TYPE ;

6: p_name in VARCHAR2,
7: p_description in VARCHAR2 DEFAULT NULL ,
8: p_default_value in VARCHAR2 DEFAULT NULL )
9: IS
10: l_owner ad_update_preferences.owner%TYPE ;
11: l_name ad_update_preferences.name%TYPE ;
12: p_pref_id ad_update_preferences.preference_id%TYPE ;
13:
14: BEGIN

Line 11: l_name ad_update_preferences.name%TYPE ;

7: p_description in VARCHAR2 DEFAULT NULL ,
8: p_default_value in VARCHAR2 DEFAULT NULL )
9: IS
10: l_owner ad_update_preferences.owner%TYPE ;
11: l_name ad_update_preferences.name%TYPE ;
12: p_pref_id ad_update_preferences.preference_id%TYPE ;
13:
14: BEGIN
15: l_owner := upper(p_owner);

Line 12: p_pref_id ad_update_preferences.preference_id%TYPE ;

8: p_default_value in VARCHAR2 DEFAULT NULL )
9: IS
10: l_owner ad_update_preferences.owner%TYPE ;
11: l_name ad_update_preferences.name%TYPE ;
12: p_pref_id ad_update_preferences.preference_id%TYPE ;
13:
14: BEGIN
15: l_owner := upper(p_owner);
16: l_name := upper(p_name);

Line 22: FROM ad_update_preferences

18: -- Check if the preference already exists
19:
20: SELECT preference_id
21: INTO p_pref_id
22: FROM ad_update_preferences
23: WHERE name = l_name
24: AND owner= l_owner;
25:
26: IF SQL%ROWCOUNT > 0 THEN

Line 35: INSERT INTO ad_update_preferences(

31: WHEN NO_DATA_FOUND THEN
32:
33: -- Insert a new record to define the new preference
34:
35: INSERT INTO ad_update_preferences(
36: preference_id,
37: owner,
38: name,
39: description,

Line 46: AD_UPDATE_PREFERENCES_S.NEXTVAL ,

42: created_by,
43: last_update_date,
44: last_updated_by)
45: VALUES(
46: AD_UPDATE_PREFERENCES_S.NEXTVAL ,
47: l_owner,
48: l_name,
49: p_description,
50: p_default_value,

Line 67: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;

63: p_description IN VARCHAR2,
64: p_default_value IN VARCHAR2,
65: p_pref_id OUT NOCOPY NUMBER )
66: IS
67: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;
68: l_name AD_UPDATE_PREFERENCES.name%TYPE ;
69: BEGIN
70: l_owner := upper(p_owner);
71: l_name := upper(p_name);

Line 68: l_name AD_UPDATE_PREFERENCES.name%TYPE ;

64: p_default_value IN VARCHAR2,
65: p_pref_id OUT NOCOPY NUMBER )
66: IS
67: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;
68: l_name AD_UPDATE_PREFERENCES.name%TYPE ;
69: BEGIN
70: l_owner := upper(p_owner);
71: l_name := upper(p_name);
72:

Line 77: FROM ad_update_preferences

73: -- Check if the preference already exists
74:
75: SELECT preference_id
76: INTO p_pref_id
77: FROM ad_update_preferences
78: WHERE name = l_name
79: AND owner= l_owner;
80:
81:

Line 82: UPDATE ad_update_preferences

78: WHERE name = l_name
79: AND owner= l_owner;
80:
81:
82: UPDATE ad_update_preferences
83: SET description = p_description,
84: default_value= p_default_value,
85: last_update_date = SYSDATE,
86: last_updated_by = SYSADMIN_VALUE

Line 105: l_pref_id ad_update_preferences.preference_id%TYPE ;

101: p_owner IN VARCHAR2,
102: p_name IN VARCHAR2)
103: RETURN NUMBER
104: IS
105: l_pref_id ad_update_preferences.preference_id%TYPE ;
106: BEGIN
107:
108: SELECT preference_id INTO l_pref_id
109: FROM ad_update_preferences

Line 109: FROM ad_update_preferences

105: l_pref_id ad_update_preferences.preference_id%TYPE ;
106: BEGIN
107:
108: SELECT preference_id INTO l_pref_id
109: FROM ad_update_preferences
110: WHERE owner = upper(p_owner)
111: AND name = upper(p_name) ;
112:
113: RETURN l_pref_id;

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 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 206: p_pref_id AD_UPDATE_PREFERENCES.preference_id%TYPE ;

202: p_owner IN VARCHAR2,
203: p_name IN VARCHAR2,
204: p_value IN VARCHAR2)
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

Line 207: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;

203: p_name IN VARCHAR2,
204: p_value IN VARCHAR2)
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);

Line 208: l_name AD_UPDATE_PREFERENCES.name%TYPE ;

204: p_value IN VARCHAR2)
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);

Line 247: p_pref_id ad_update_preferences.preference_id%TYPE ;

243: p_owner IN VARCHAR2,
244: p_name IN VARCHAR2,
245: p_value IN VARCHAR2)
246: IS
247: p_pref_id ad_update_preferences.preference_id%TYPE ;
248: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;
249: l_name AD_UPDATE_PREFERENCES.name%TYPE ;
250: BEGIN
251: l_owner := upper(p_owner);

Line 248: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;

244: p_name IN VARCHAR2,
245: p_value IN VARCHAR2)
246: IS
247: p_pref_id ad_update_preferences.preference_id%TYPE ;
248: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;
249: l_name AD_UPDATE_PREFERENCES.name%TYPE ;
250: BEGIN
251: l_owner := upper(p_owner);
252: l_name := upper(p_name);

Line 249: l_name AD_UPDATE_PREFERENCES.name%TYPE ;

245: p_value IN VARCHAR2)
246: IS
247: p_pref_id ad_update_preferences.preference_id%TYPE ;
248: l_owner AD_UPDATE_PREFERENCES.owner%TYPE ;
249: l_name AD_UPDATE_PREFERENCES.name%TYPE ;
250: BEGIN
251: l_owner := upper(p_owner);
252: l_name := upper(p_name);
253: -- Check the existence of the preference

Line 309: FROM ad_update_preferences WHERE

305: BEGIN
306: --Get the preference_id for the given owner,name of the preference
307:
308: SELECT preference_id INTO l_pref_id
309: FROM ad_update_preferences WHERE
310: owner = upper(p_owner)
311: AND name = upper(p_name);
312:
313: --Update the preference value for that particular session