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_CAT_OPTIONS_PKG dependencies on FND_PROFILE_CAT_OPTIONS

Line 1: package body FND_PROFILE_CAT_OPTIONS_PKG as

1: package body FND_PROFILE_CAT_OPTIONS_PKG as
2: /* $Header: FNDPRCTB.pls 120.7 2006/09/21 10:28:13 stadepal noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_PROFILE_OPTION_ID in NUMBER,

Line 17: cursor C is select ROWID from FND_PROFILE_CAT_OPTIONS

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER,
15: X_APPLICATION_ID in NUMBER
16: ) is
17: cursor C is select ROWID from FND_PROFILE_CAT_OPTIONS
18: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
19: and CATEGORY_NAME = upper(X_CATEGORY_NAME)
20: and PROFILE_OPTION_APPLICATION_ID = X_PROFILE_OPTION_APPLICATION_I
21: and APPLICATION_ID = X_APPLICATION_ID

Line 24: insert into FND_PROFILE_CAT_OPTIONS (

20: and PROFILE_OPTION_APPLICATION_ID = X_PROFILE_OPTION_APPLICATION_I
21: and APPLICATION_ID = X_APPLICATION_ID
22: ;
23: begin
24: insert into FND_PROFILE_CAT_OPTIONS (
25: PROFILE_OPTION_APPLICATION_ID,
26: PROFILE_OPTION_ID,
27: CATEGORY_NAME,
28: APPLICATION_ID,

Line 51: insert into FND_PROFILE_CAT_OPTIONS_TL (

47: X_LAST_UPDATE_LOGIN
48: );
49:
50: /******************Commented. Since TL table is dropped
51: insert into FND_PROFILE_CAT_OPTIONS_TL (
52: PROFILE_OPTION_APPLICATION_ID,
53: PROFILE_OPTION_ID,
54: CATEGORY_NAME,
55: APPLICATION_ID,

Line 81: from FND_PROFILE_CAT_OPTIONS_TL T

77: from FND_LANGUAGES L
78: where L.INSTALLED_FLAG in ('I', 'B')
79: and not exists
80: (select NULL
81: from FND_PROFILE_CAT_OPTIONS_TL T
82: where T.PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
83: and T.CATEGORY_NAME = X_CATEGORY_NAME
84: and T.PROFILE_OPTION_APPLICATION_ID = X_PROFILE_OPTION_APPLICATION_I
85: and T.APPLICATION_ID = X_APPLICATION_ID

Line 110: from FND_PROFILE_CAT_OPTIONS

106: ) is
107: cursor c is select
108: DISPLAY_SEQUENCE,
109: DISPLAY_TYPE
110: from FND_PROFILE_CAT_OPTIONS
111: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
112: and CATEGORY_NAME = upper(X_CATEGORY_NAME)
113: and PROFILE_OPTION_APPLICATION_ID = X_PROFILE_OPTION_APPLICATION_I
114: and APPLICATION_ID = X_APPLICATION_ID

Line 122: from FND_PROFILE_CAT_OPTIONS_TL

118: /******************Commented. Since TL table is dropped
119: cursor c1 is select
120: DESCRIPTION_OVERRIDE,
121: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
122: from FND_PROFILE_CAT_OPTIONS_TL
123: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
124: and CATEGORY_NAME = X_CATEGORY_NAME
125: and PROFILE_OPTION_APPLICATION_ID = X_PROFILE_OPTION_APPLICATION_I
126: and APPLICATION_ID = X_APPLICATION_ID

Line 179: update FND_PROFILE_CAT_OPTIONS set

175: X_LAST_UPDATE_LOGIN in NUMBER,
176: X_APPLICATION_ID in NUMBER
177: ) is
178: begin
179: update FND_PROFILE_CAT_OPTIONS set
180: DISPLAY_SEQUENCE = X_DISPLAY_SEQUENCE,
181: DISPLAY_TYPE = X_DISPLAY_TYPE,
182: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
183: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 195: update FND_PROFILE_CAT_OPTIONS_TL set

191: raise no_data_found;
192: end if;
193:
194: /******************Commented. Since TL table is dropped
195: update FND_PROFILE_CAT_OPTIONS_TL set
196: DESCRIPTION_OVERRIDE = X_DESCRIPTION_OVERRIDE,
197: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
198: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
199: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 221: delete from FND_PROFILE_CAT_OPTIONS_TL

217: X_APPLICATION_ID in NUMBER
218: ) is
219: begin
220: /******************Commented. Since TL table is dropped
221: delete from FND_PROFILE_CAT_OPTIONS_TL
222: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
223: and CATEGORY_NAME = X_CATEGORY_NAME
224: and PROFILE_OPTION_APPLICATION_ID = X_PROFILE_OPTION_APPLICATION_I
225: and APPLICATION_ID = X_APPLICATION_ID;

Line 232: delete from FND_PROFILE_CAT_OPTIONS

228: raise no_data_found;
229: end if;
230: ***********************/
231:
232: delete from FND_PROFILE_CAT_OPTIONS
233: where PROFILE_OPTION_ID = X_PROFILE_OPTION_ID
234: and CATEGORY_NAME = upper(X_CATEGORY_NAME)
235: and PROFILE_OPTION_APPLICATION_ID = X_PROFILE_OPTION_APPLICATION_I
236: and APPLICATION_ID = X_APPLICATION_ID;

Line 249: ** Fnd_profile_cat_options_pkg.add_language. If the api is commented,

245: is
246: begin
247: /** deleted all the code instead of commenting the ADD_LANGUAGE to remove
248: ** the dependency between this change and FNDNLINS.sql which has call to
249: ** Fnd_profile_cat_options_pkg.add_language. If the api is commented,
250: ** then this change requires a change in FNDNLINS.sql.
251: **/
252: null;
253: end ADD_LANGUAGE;

Line 295: from FND_PROFILE_CAT_OPTIONS_TL

291:
292: begin
293: select LAST_UPDATED_BY, LAST_UPDATE_DATE
294: into db_luby, db_ludate
295: from FND_PROFILE_CAT_OPTIONS_TL
296: where PROFILE_OPTION_APPLICATION_ID = prof_app_id
297: and PROFILE_OPTION_ID = prof_id
298: and CATEGORY_NAME = X_CATEGORY_NAME
299: and APPLICATION_ID = app_id

Line 305: update FND_PROFILE_CAT_OPTIONS_TL set

301:
302: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
303: db_ludate, X_CUSTOM_MODE)) then
304:
305: update FND_PROFILE_CAT_OPTIONS_TL set
306: DESCRIPTION_OVERRIDE = X_DESCRIPTION_OVERRIDE,
307: LAST_UPDATE_DATE = f_ludate,
308: LAST_UPDATED_BY = f_luby,
309: LAST_UPDATE_LOGIN = f_luby,

Line 492: from FND_PROFILE_CAT_OPTIONS

488:
489: begin
490: select LAST_UPDATED_BY, LAST_UPDATE_DATE
491: into db_luby, db_ludate
492: from FND_PROFILE_CAT_OPTIONS
493: where PROFILE_OPTION_APPLICATION_ID = prof_app_id
494: and PROFILE_OPTION_ID = prof_id
495: and CATEGORY_NAME = upper(X_CATEGORY_NAME)
496: and APPLICATION_ID = app_id;

Line 501: FND_PROFILE_CAT_OPTIONS_PKG.UPDATE_ROW (

497:
498: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
499: db_ludate, X_CUSTOM_MODE)) then
500:
501: FND_PROFILE_CAT_OPTIONS_PKG.UPDATE_ROW (
502: X_PROFILE_OPTION_APPLICATION_I => prof_app_id,
503: X_PROFILE_OPTION_ID => prof_id,
504: X_CATEGORY_NAME => X_CATEGORY_NAME,
505: X_APPLICATION_ID => app_id,

Line 515: FND_PROFILE_CAT_OPTIONS_PKG.INSERT_ROW (

511: end if;
512: exception
513: when no_data_found then
514: begin
515: FND_PROFILE_CAT_OPTIONS_PKG.INSERT_ROW (
516: X_ROWID => row_id,
517: X_PROFILE_OPTION_APPLICATION_I => prof_app_id,
518: X_PROFILE_OPTION_ID => prof_id,
519: X_CATEGORY_NAME => X_CATEGORY_NAME,

Line 537: -- in Fnd_Profile_Cat_Options table. But there is no UI feature

533: -- since the data for this link info is always same from different
534: -- ldt's, we can ignore this dup_val_on_index exception while
535: -- inserting profile->category link data.
536: -- (Only Display_Sequence and Display_Type fields are updateable
537: -- in Fnd_Profile_Cat_Options table. But there is no UI feature
538: -- to update the above updateable columns. Hence data in
539: -- different ldt's is always same for this Fnd_Profile_Cat_Options
540: -- entity)
541:

Line 539: -- different ldt's is always same for this Fnd_Profile_Cat_Options

535: -- inserting profile->category link data.
536: -- (Only Display_Sequence and Display_Type fields are updateable
537: -- in Fnd_Profile_Cat_Options table. But there is no UI feature
538: -- to update the above updateable columns. Hence data in
539: -- different ldt's is always same for this Fnd_Profile_Cat_Options
540: -- entity)
541:
542: null;
543: end;

Line 547: end FND_PROFILE_CAT_OPTIONS_PKG;

543: end;
544: end;
545: end LOAD_ROW;
546:
547: end FND_PROFILE_CAT_OPTIONS_PKG;