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_MENUS_PKG dependencies on FND_MENUS

Line 1: package body FND_MENUS_PKG as

1: package body FND_MENUS_PKG as
2: /* $Header: AFMNMNUB.pls 120.2 2007/12/14 15:23:33 jvalenti ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 18: cursor C is select ROWID from FND_MENUS

14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: )
17: is
18: cursor C is select ROWID from FND_MENUS
19: where MENU_ID = X_MENU_ID;
20:
21: begin
22:

Line 23: insert into FND_MENUS (

19: where MENU_ID = X_MENU_ID;
20:
21: begin
22:
23: insert into FND_MENUS (
24: MENU_ID,
25: MENU_NAME,
26: TYPE,
27: CREATION_DATE,

Line 47: insert into FND_MENUS_TL (

43:
44: -- Added for Function Security Cache Invalidation Project
45: fnd_function_security_cache.insert_menu(X_MENU_ID);
46:
47: insert into FND_MENUS_TL (
48: MENU_ID,
49: USER_MENU_NAME,
50: LAST_UPDATE_DATE,
51: LAST_UPDATED_BY,

Line 71: from FND_MENUS_TL T

67: userenv('LANG')
68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists (select NULL
71: from FND_MENUS_TL T
72: where T.MENU_ID = X_MENU_ID
73: and T.LANGUAGE = L.LANGUAGE_CODE);
74:
75: open c;

Line 94: from FND_MENUS

90: X_DESCRIPTION in VARCHAR2
91: ) is
92: cursor c is select
93: MENU_NAME, TYPE
94: from FND_MENUS
95: where MENU_ID = X_MENU_ID
96: for update of MENU_ID nowait;
97: recinfo c%rowtype;
98:

Line 102: from FND_MENUS_TL

98:
99: cursor c1 is select
100: USER_MENU_NAME,
101: DESCRIPTION
102: from FND_MENUS_TL
103: where MENU_ID = X_MENU_ID
104: and LANGUAGE = userenv('LANG')
105: for update of MENU_ID nowait;
106: tlinfo c1%rowtype;

Line 160: update FND_MENUS

156: )
157: is
158:
159: begin
160: update FND_MENUS
161: set MENU_NAME = X_MENU_NAME,
162: TYPE = X_MENU_TYPE,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 176: update FND_MENUS_TL

172: -- Added for Function Security Cache Invalidation Project
173: fnd_function_security_cache.update_menu(X_MENU_ID);
174: end if;
175:
176: update FND_MENUS_TL
177: set USER_MENU_NAME = X_USER_MENU_NAME,
178: DESCRIPTION = X_DESCRIPTION,
179: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
180: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 201: fnd_menus_pkg.LOAD_ROW (

197: X_OWNER in VARCHAR2,
198: X_CUSTOM_MODE in VARCHAR2
199: ) is
200: begin
201: fnd_menus_pkg.LOAD_ROW (
202: X_MENU_NAME => X_MENU_NAME,
203: X_MENU_TYPE => X_MENU_TYPE,
204: X_USER_MENU_NAME => X_USER_MENU_NAME,
205: X_DESCRIPTION => X_DESCRIPTION,

Line 237: from fnd_menus

233: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
234:
235: select menu_id, last_updated_by, last_update_date
236: into man_id, db_luby, db_ludate
237: from fnd_menus
238: where menu_name = X_MENU_NAME;
239:
240: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
241: db_ludate, X_CUSTOM_MODE)) then

Line 242: fnd_menus_pkg.UPDATE_ROW (

238: where menu_name = X_MENU_NAME;
239:
240: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
241: db_ludate, X_CUSTOM_MODE)) then
242: fnd_menus_pkg.UPDATE_ROW (
243: X_MENU_ID => man_id,
244: X_MENU_NAME => X_MENU_NAME,
245: X_USER_MENU_NAME => X_USER_MENU_NAME,
246: X_MENU_TYPE => X_MENU_TYPE,

Line 255: select fnd_menus_s.nextval into man_id from dual;

251: end if;
252: exception
253: when NO_DATA_FOUND then
254:
255: select fnd_menus_s.nextval into man_id from dual;
256:
257: fnd_menus_pkg.INSERT_ROW(
258: X_ROWID => row_id,
259: X_MENU_ID => man_id,

Line 257: fnd_menus_pkg.INSERT_ROW(

253: when NO_DATA_FOUND then
254:
255: select fnd_menus_s.nextval into man_id from dual;
256:
257: fnd_menus_pkg.INSERT_ROW(
258: X_ROWID => row_id,
259: X_MENU_ID => man_id,
260: X_MENU_NAME => X_MENU_NAME,
261: X_USER_MENU_NAME => X_USER_MENU_NAME,

Line 278: delete from FND_MENUS

274: is
275:
276: begin
277:
278: delete from FND_MENUS
279: where MENU_ID = X_MENU_ID;
280:
281: if (sql%notfound) then
282: raise no_data_found;

Line 289: delete from FND_MENUS_TL

285: -- Added for Function Security Cache Invalidation Project
286: fnd_function_security_cache.delete_menu(X_MENU_ID);
287: end if;
288:
289: delete from FND_MENUS_TL
290: where MENU_ID = X_MENU_ID;
291:
292: if (sql%notfound) then
293: raise no_data_found;

Line 306: delete from FND_MENUS_TL T

302: /* as a quick workaround to fix the time-consuming table handler issue */
303: /* Eventually we'll need to turn them into a separate fix_language procedure */
304: /*
305:
306: delete from FND_MENUS_TL T
307: where not exists
308: (select NULL
309: from FND_MENUS B
310: where B.MENU_ID = T.MENU_ID

Line 309: from FND_MENUS B

305:
306: delete from FND_MENUS_TL T
307: where not exists
308: (select NULL
309: from FND_MENUS B
310: where B.MENU_ID = T.MENU_ID
311: );
312:
313: update FND_MENUS_TL T set (

Line 313: update FND_MENUS_TL T set (

309: from FND_MENUS B
310: where B.MENU_ID = T.MENU_ID
311: );
312:
313: update FND_MENUS_TL T set (
314: USER_MENU_NAME,
315: DESCRIPTION
316: ) = (select
317: B.USER_MENU_NAME,

Line 319: from FND_MENUS_TL B

315: DESCRIPTION
316: ) = (select
317: B.USER_MENU_NAME,
318: B.DESCRIPTION
319: from FND_MENUS_TL B
320: where B.MENU_ID = T.MENU_ID
321: and B.LANGUAGE = T.SOURCE_LANG)
322: where (
323: T.MENU_ID,

Line 328: from FND_MENUS_TL SUBB, FND_MENUS_TL SUBT

324: T.LANGUAGE
325: ) in (select
326: SUBT.MENU_ID,
327: SUBT.LANGUAGE
328: from FND_MENUS_TL SUBB, FND_MENUS_TL SUBT
329: where SUBB.MENU_ID = SUBT.MENU_ID
330: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
331: and (SUBB.USER_MENU_NAME <> SUBT.USER_MENU_NAME
332: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 338: insert into FND_MENUS_TL (

334: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
335: ));
336: */
337:
338: insert into FND_MENUS_TL (
339: MENU_ID,
340: USER_MENU_NAME,
341: LAST_UPDATE_DATE,
342: LAST_UPDATED_BY,

Line 360: from FND_MENUS_TL B, FND_LANGUAGES L

356: B.CREATED_BY,
357: B.DESCRIPTION,
358: L.LANGUAGE_CODE,
359: B.SOURCE_LANG
360: from FND_MENUS_TL B, FND_LANGUAGES L
361: where L.INSTALLED_FLAG in ('I', 'B')
362: and B.LANGUAGE = userenv('LANG')
363: and not exists
364: (select NULL

Line 365: from FND_MENUS_TL T

361: where L.INSTALLED_FLAG in ('I', 'B')
362: and B.LANGUAGE = userenv('LANG')
363: and not exists
364: (select NULL
365: from FND_MENUS_TL T
366: where T.MENU_ID = B.MENU_ID
367: and T.LANGUAGE = L.LANGUAGE_CODE);
368: end ADD_LANGUAGE;
369:

Line 379: fnd_menus_pkg.TRANSLATE_ROW (

375: X_OWNER in VARCHAR2,
376: X_CUSTOM_MODE in VARCHAR2
377: ) is
378: begin
379: fnd_menus_pkg.TRANSLATE_ROW (
380: X_MENU_ID => X_MENU_ID,
381: X_USER_MENU_NAME => X_USER_MENU_NAME,
382: X_DESCRIPTION => X_DESCRIPTION,
383: X_OWNER => X_OWNER,

Line 411: from FND_MENUS_TL

407: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
408:
409: select LAST_UPDATED_BY, LAST_UPDATE_DATE
410: into db_luby, db_ludate
411: from FND_MENUS_TL
412: where MENU_ID = X_MENU_ID
413: and userenv('LANG') = LANGUAGE;
414:
415: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 417: update FND_MENUS_TL set

413: and userenv('LANG') = LANGUAGE;
414:
415: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
416: db_ludate, X_CUSTOM_MODE)) then
417: update FND_MENUS_TL set
418: USER_MENU_NAME = X_USER_MENU_NAME,
419: DESCRIPTION = X_DESCRIPTION,
420: LAST_UPDATE_DATE = f_ludate,
421: LAST_UPDATED_BY = f_luby,

Line 436: FND_MENUS_PKG.currentryseq := 0;

432: end TRANSLATE_ROW;
433:
434: procedure SET_NEW_MENU is
435: begin
436: FND_MENUS_PKG.currentryseq := 0;
437: end SET_NEW_MENU;
438:
439: function NEXT_ENTRY_SEQUENCE return number is
440: begin

Line 443: FND_MENUS_PKG.currentryseq := FND_MENUS_PKG.currentryseq + 5;

439: function NEXT_ENTRY_SEQUENCE return number is
440: begin
441: --Bug6525216 Making the sequence in increments of 5.
442:
443: FND_MENUS_PKG.currentryseq := FND_MENUS_PKG.currentryseq + 5;
444: return(FND_MENUS_PKG.currentryseq);
445: end NEXT_ENTRY_SEQUENCE;
446:
447: function VALIDATE_MENU_TYPE(X_MENU_TYPE in VARCHAR2) return boolean is

Line 444: return(FND_MENUS_PKG.currentryseq);

440: begin
441: --Bug6525216 Making the sequence in increments of 5.
442:
443: FND_MENUS_PKG.currentryseq := FND_MENUS_PKG.currentryseq + 5;
444: return(FND_MENUS_PKG.currentryseq);
445: end NEXT_ENTRY_SEQUENCE;
446:
447: function VALIDATE_MENU_TYPE(X_MENU_TYPE in VARCHAR2) return boolean is
448: buffer varchar2(80);

Line 468: end FND_MENUS_PKG;

464: return(true);
465:
466: end VALIDATE_MENU_TYPE;
467:
468: end FND_MENUS_PKG;