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.FND_PROFILE_OPTION_VALUES_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 1: package body FND_PROFILE_OPTION_VALUES_PKG as

1: package body FND_PROFILE_OPTION_VALUES_PKG as
2: /* $Header: AFPOMPVB.pls 120.3 2011/05/25 03:15:59 jwsmith ship $ */
3:
4: function GET_HIERARCHY_TYPE(
5: X_PROFILE_OPTION_ID in NUMBER,

Line 25: /* This procedure is used to insert a row into fnd_profile_option_values.

21: return L_HIERARCHY_TYPE;
22:
23: end GET_HIERARCHY_TYPE;
24:
25: /* This procedure is used to insert a row into fnd_profile_option_values.
26: ** Due to the nature of profile option values having levels and granular
27: ** values associated to its levels, this routine distinguishes between
28: ** these levels to ensure data integrity.
29: */

Line 47: cursor S is select ROWID from FND_PROFILE_OPTION_VALUES

43: X_LEVEL_VALUE2 in NUMBER
44: ) is
45:
46: -- Site level cursor
47: cursor S is select ROWID from FND_PROFILE_OPTION_VALUES
48: where APPLICATION_ID = X_APPLICATION_ID
49: and PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
50: and LEVEL_ID = X_LEVEL_ID
51: and LEVEL_VALUE = 0;

Line 54: cursor ARSO is select ROWID from FND_PROFILE_OPTION_VALUES

50: and LEVEL_ID = X_LEVEL_ID
51: and LEVEL_VALUE = 0;
52:
53: -- Application/Server/Org level cursor
54: cursor ARSO is select ROWID from FND_PROFILE_OPTION_VALUES
55: where APPLICATION_ID = X_APPLICATION_ID
56: and PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
57: and LEVEL_ID = X_LEVEL_ID
58: and LEVEL_VALUE = X_LEVEL_VALUE

Line 63: cursor R is select ROWID from FND_PROFILE_OPTION_VALUES

59: and LEVEL_VALUE_APPLICATION_ID is null
60: and LEVEL_VALUE2 is null;
61:
62: -- Responsibility level cursor
63: cursor R is select ROWID from FND_PROFILE_OPTION_VALUES
64: where APPLICATION_ID = X_APPLICATION_ID
65: and PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
66: and LEVEL_ID = X_LEVEL_ID
67: and LEVEL_VALUE = X_LEVEL_VALUE

Line 72: cursor SR is select ROWID from FND_PROFILE_OPTION_VALUES

68: and LEVEL_VALUE_APPLICATION_ID = X_LEVEL_VALUE_APPLICATION_ID
69: and LEVEL_VALUE2 is null;
70:
71: -- ServResp level cursor
72: cursor SR is select ROWID from FND_PROFILE_OPTION_VALUES
73: where APPLICATION_ID = X_APPLICATION_ID
74: and PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
75: and LEVEL_ID = X_LEVEL_ID
76: and LEVEL_VALUE = X_LEVEL_VALUE

Line 92: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE

88: if length(X_PROFILE_OPTION_VALUE) > 240 then
89: raise profile_option_value_too_large;
90: end if;
91:
92: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE
93: (X_PROFILE_OPTION_ID, X_APPLICATION_ID);
94:
95: /* Being conservative here and wanting to make sure that levels get
96: profile option values inserted correctly. For example, if, by some

Line 104: insert into FND_PROFILE_OPTION_VALUES (

100: */
101:
102: if (X_LEVEL_ID = 10001) then
103: -- Site level
104: insert into FND_PROFILE_OPTION_VALUES (
105: APPLICATION_ID,
106: PROFILE_OPTION_ID,
107: LEVEL_ID,
108: LEVEL_VALUE,

Line 142: insert into FND_PROFILE_OPTION_VALUES (

138: close S;
139:
140: elsif (X_LEVEL_ID = 10007 and L_HIERARCHY_TYPE = 'SERVRESP') then
141: -- ServResp level
142: insert into FND_PROFILE_OPTION_VALUES (
143: APPLICATION_ID,
144: PROFILE_OPTION_ID,
145: LEVEL_ID,
146: LEVEL_VALUE,

Line 183: insert into FND_PROFILE_OPTION_VALUES (

179: (X_LEVEL_ID = 10005 and L_HIERARCHY_TYPE = 'SERVER') or
180: (X_LEVEL_ID = 10004) or
181: (X_LEVEL_ID = 10002 and L_HIERARCHY_TYPE = 'SECURITY')) then
182: -- Appl/Resp/Server/Org levels
183: insert into FND_PROFILE_OPTION_VALUES (
184: APPLICATION_ID,
185: PROFILE_OPTION_ID,
186: LEVEL_ID,
187: LEVEL_VALUE,

Line 222: insert into FND_PROFILE_OPTION_VALUES (

218:
219: elsif (X_LEVEL_ID = 10003 and L_HIERARCHY_TYPE = 'SECURITY') then
220:
221: -- Resp level
222: insert into FND_PROFILE_OPTION_VALUES (
223: APPLICATION_ID,
224: PROFILE_OPTION_ID,
225: LEVEL_ID,
226: LEVEL_VALUE,

Line 306: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE

302: if length(X_PROFILE_OPTION_VALUE) > 240 then
303: raise profile_option_value_too_large;
304: end if;
305:
306: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE
307: (X_PROFILE_OPTION_ID, X_APPLICATION_ID);
308:
309: if (X_LEVEL_ID = 10007 and L_HIERARCHY_TYPE = 'SERVRESP') then
310: /* ServResp U P D A T E */

Line 311: update FND_PROFILE_OPTION_VALUES

307: (X_PROFILE_OPTION_ID, X_APPLICATION_ID);
308:
309: if (X_LEVEL_ID = 10007 and L_HIERARCHY_TYPE = 'SERVRESP') then
310: /* ServResp U P D A T E */
311: update FND_PROFILE_OPTION_VALUES
312: set PROFILE_OPTION_VALUE = X_PROFILE_OPTION_VALUE,
313: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
314: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
315: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 330: update FND_PROFILE_OPTION_VALUES

326: (X_LEVEL_ID = 10003 and L_HIERARCHY_TYPE = 'SECURITY') or
327: (X_LEVEL_ID = 10002 and L_HIERARCHY_TYPE = 'SECURITY') or
328: (X_LEVEL_ID = 10001)) then
329: /* U P D A T E */
330: update FND_PROFILE_OPTION_VALUES
331: set PROFILE_OPTION_VALUE = X_PROFILE_OPTION_VALUE,
332: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
333: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
334: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 345: FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(

341: end if;
342:
343: if SQL%NOTFOUND then
344: /* I N S E R T */
345: FND_PROFILE_OPTION_VALUES_PKG.INSERT_ROW(
346: L_ROWID,
347: X_APPLICATION_ID,
348: X_PROFILE_OPTION_ID,
349: X_LEVEL_ID,

Line 424: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE

420: L_HIERARCHY_TYPE VARCHAR2(8);
421:
422: begin
423:
424: L_HIERARCHY_TYPE := FND_PROFILE_OPTION_VALUES_PKG.GET_HIERARCHY_TYPE
425: (X_PROFILE_OPTION_ID, X_APPLICATION_ID);
426:
427: if (X_LEVEL_ID = 10007 and L_HIERARCHY_TYPE = 'SERVRESP') then
428:

Line 430: delete from FND_PROFILE_OPTION_VALUES

426:
427: if (X_LEVEL_ID = 10007 and L_HIERARCHY_TYPE = 'SERVRESP') then
428:
429: /* ServResp D E L E T E */
430: delete from FND_PROFILE_OPTION_VALUES
431: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
432: and APPLICATION_ID = X_APPLICATION_ID
433: and LEVEL_ID = X_LEVEL_ID
434: and LEVEL_VALUE = X_LEVEL_VALUE

Line 446: delete from FND_PROFILE_OPTION_VALUES

442: (X_LEVEL_ID = 10002 and L_HIERARCHY_TYPE = 'SECURITY') or
443: (X_LEVEL_ID = 10001)) then
444:
445: /* D E L E T E */
446: delete from FND_PROFILE_OPTION_VALUES
447: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
448: and APPLICATION_ID = X_APPLICATION_ID
449: and LEVEL_ID = X_LEVEL_ID
450: and LEVEL_VALUE = X_LEVEL_VALUE

Line 457: delete from FND_PROFILE_OPTION_VALUES

453:
454: elsif (X_LEVEL_ID = 10003 and L_HIERARCHY_TYPE = 'SECURITY') then
455:
456: /* D E L E T E */
457: delete from FND_PROFILE_OPTION_VALUES
458: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
459: and APPLICATION_ID = X_APPLICATION_ID
460: and LEVEL_ID = X_LEVEL_ID
461: and LEVEL_VALUE = X_LEVEL_VALUE

Line 502: * references in FND_PROFILE_OPTION_VALUES to the profile option being

498:
499: /* This procedure is only going to be called from
500: * FND_PROFILE_OPTIONS_PKG.DELETE_ROW which deletes profile option
501: * definitions. This procedure ensures that there will be no dangling
502: * references in FND_PROFILE_OPTION_VALUES to the profile option being
503: * deleted, i.e. if a profile is being deleted, it should have no rows
504: * for profile option values.
505: */
506: procedure DELETE_PROFILE_OPTION_VALUES (X_PROFILE_OPTION_NAME in VARCHAR2) is

Line 524: delete from fnd_profile_option_values

520: end if;
521:
522: -- Delete all rows with the profile_option_id, application_id
523: -- combination
524: delete from fnd_profile_option_values
525: where profile_option_id = L_PROFILE_OPTION_ID
526: and application_id = L_APPLICATION_ID;
527:
528: -- It is possible for a profile option to not have any profile option

Line 537: end FND_PROFILE_OPTION_VALUES_PKG;

533: end if;
534:
535: end DELETE_PROFILE_OPTION_VALUES;
536:
537: end FND_PROFILE_OPTION_VALUES_PKG;