APPS.BNE_MENUS_PKG dependencies on BNE_MENUS_TL

Line 68: insert into BNE_MENUS_TL (

64: X_LAST_UPDATED_BY,
65: X_LAST_UPDATE_LOGIN
66: );
67:
68: insert into BNE_MENUS_TL (
69: APPLICATION_ID,
70: MENU_CODE,
71: USER_NAME,
72: CREATED_BY,

Line 94: from BNE_MENUS_TL T

90: from FND_LANGUAGES L
91: where L.INSTALLED_FLAG in ('I', 'B')
92: and not exists
93: (select NULL
94: from BNE_MENUS_TL T
95: where T.APPLICATION_ID = X_APPLICATION_ID
96: and T.MENU_CODE = X_MENU_CODE
97: and T.LANGUAGE = L.LANGUAGE_CODE);
98:

Line 144: from BNE_MENUS_TL

140:
141: cursor c1 is select
142: USER_NAME,
143: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
144: from BNE_MENUS_TL
145: where APPLICATION_ID = X_APPLICATION_ID
146: and MENU_CODE = X_MENU_CODE
147: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
148: for update of APPLICATION_ID nowait;

Line 238: update BNE_MENUS_TL set

234: if (sql%notfound) then
235: raise no_data_found;
236: end if;
237:
238: update BNE_MENUS_TL set
239: USER_NAME = X_USER_NAME,
240: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
241: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
242: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 258: delete from BNE_MENUS_TL

254: X_APPLICATION_ID in NUMBER,
255: X_MENU_CODE in VARCHAR2
256: ) is
257: begin
258: delete from BNE_MENUS_TL
259: where APPLICATION_ID = X_APPLICATION_ID
260: and MENU_CODE = X_MENU_CODE;
261:
262: if (sql%notfound) then

Line 278: delete from BNE_MENUS_TL T

274:
275: procedure ADD_LANGUAGE
276: is
277: begin
278: delete from BNE_MENUS_TL T
279: where not exists
280: (select NULL
281: from BNE_MENUS_B B
282: where B.APPLICATION_ID = T.APPLICATION_ID

Line 286: update BNE_MENUS_TL T set (

282: where B.APPLICATION_ID = T.APPLICATION_ID
283: and B.MENU_CODE = T.MENU_CODE
284: );
285:
286: update BNE_MENUS_TL T set (
287: USER_NAME
288: ) = (select
289: B.USER_NAME
290: from BNE_MENUS_TL B

Line 290: from BNE_MENUS_TL B

286: update BNE_MENUS_TL T set (
287: USER_NAME
288: ) = (select
289: B.USER_NAME
290: from BNE_MENUS_TL B
291: where B.APPLICATION_ID = T.APPLICATION_ID
292: and B.MENU_CODE = T.MENU_CODE
293: and B.LANGUAGE = T.SOURCE_LANG)
294: where (

Line 302: from BNE_MENUS_TL SUBB, BNE_MENUS_TL SUBT

298: ) in (select
299: SUBT.APPLICATION_ID,
300: SUBT.MENU_CODE,
301: SUBT.LANGUAGE
302: from BNE_MENUS_TL SUBB, BNE_MENUS_TL SUBT
303: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
304: and SUBB.MENU_CODE = SUBT.MENU_CODE
305: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
306: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 309: insert into BNE_MENUS_TL (

305: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
306: and (SUBB.USER_NAME <> SUBT.USER_NAME
307: ));
308:
309: insert into BNE_MENUS_TL (
310: APPLICATION_ID,
311: MENU_CODE,
312: USER_NAME,
313: CREATED_BY,

Line 331: from BNE_MENUS_TL B, FND_LANGUAGES L

327: B.LAST_UPDATE_LOGIN,
328: B.LAST_UPDATE_DATE,
329: L.LANGUAGE_CODE,
330: B.SOURCE_LANG
331: from BNE_MENUS_TL B, FND_LANGUAGES L
332: where L.INSTALLED_FLAG in ('I', 'B')
333: and B.LANGUAGE = userenv('LANG')
334: and not exists
335: (select NULL

Line 336: from BNE_MENUS_TL T

332: where L.INSTALLED_FLAG in ('I', 'B')
333: and B.LANGUAGE = userenv('LANG')
334: and not exists
335: (select NULL
336: from BNE_MENUS_TL T
337: where T.APPLICATION_ID = B.APPLICATION_ID
338: and T.MENU_CODE = B.MENU_CODE
339: and T.LANGUAGE = L.LANGUAGE_CODE);
340: end ADD_LANGUAGE;

Line 382: from BNE_MENUS_TL

378: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
379: begin
380: select LAST_UPDATED_BY, LAST_UPDATE_DATE
381: into db_luby, db_ludate
382: from BNE_MENUS_TL
383: where APPLICATION_ID = l_app_id
384: and MENU_CODE = x_menu_code
385: and LANGUAGE = userenv('LANG');
386:

Line 391: update BNE_MENUS_TL

387: -- Test for customization and version
388: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
389: db_ludate, x_custom_mode)) then
390:
391: update BNE_MENUS_TL
392: set USER_NAME = x_user_name,
393: LAST_UPDATE_DATE = f_ludate,
394: LAST_UPDATED_BY = f_luby,
395: LAST_UPDATE_LOGIN = 0,