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.BNE_LAYOUT_BLOCKS_PKG dependencies on BNE_LAYOUT_BLOCKS_TL

Line 130: insert into BNE_LAYOUT_BLOCKS_TL (

126: X_LAST_UPDATED_BY,
127: X_LAST_UPDATE_LOGIN
128: );
129:
130: insert into BNE_LAYOUT_BLOCKS_TL (
131: APPLICATION_ID,
132: LAYOUT_CODE,
133: BLOCK_ID,
134: USER_NAME,

Line 160: from BNE_LAYOUT_BLOCKS_TL T

156: from FND_LANGUAGES L
157: where L.INSTALLED_FLAG in ('I', 'B')
158: and not exists
159: (select NULL
160: from BNE_LAYOUT_BLOCKS_TL T
161: where T.APPLICATION_ID = X_APPLICATION_ID
162: and T.LAYOUT_CODE = X_LAYOUT_CODE
163: and T.BLOCK_ID = X_BLOCK_ID
164: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 252: from BNE_LAYOUT_BLOCKS_TL

248:
249: cursor c1 is select
250: USER_NAME,
251: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
252: from BNE_LAYOUT_BLOCKS_TL
253: where APPLICATION_ID = X_APPLICATION_ID
254: and LAYOUT_CODE = X_LAYOUT_CODE
255: and BLOCK_ID = X_BLOCK_ID
256: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 416: update BNE_LAYOUT_BLOCKS_TL set

412: if (sql%notfound) then
413: raise no_data_found;
414: end if;
415:
416: update BNE_LAYOUT_BLOCKS_TL set
417: USER_NAME = X_USER_NAME,
418: PROMPT_ABOVE = X_PROMPT_ABOVE,
419: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
420: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 439: delete from BNE_LAYOUT_BLOCKS_TL

435: X_LAYOUT_CODE in VARCHAR2,
436: X_BLOCK_ID in NUMBER
437: ) is
438: begin
439: delete from BNE_LAYOUT_BLOCKS_TL
440: where APPLICATION_ID = X_APPLICATION_ID
441: and LAYOUT_CODE = X_LAYOUT_CODE
442: and BLOCK_ID = X_BLOCK_ID;
443:

Line 461: delete from BNE_LAYOUT_BLOCKS_TL T

457:
458: procedure ADD_LANGUAGE
459: is
460: begin
461: delete from BNE_LAYOUT_BLOCKS_TL T
462: where not exists
463: (select NULL
464: from BNE_LAYOUT_BLOCKS_B B
465: where B.APPLICATION_ID = T.APPLICATION_ID

Line 470: update BNE_LAYOUT_BLOCKS_TL T set (

466: and B.LAYOUT_CODE = T.LAYOUT_CODE
467: and B.BLOCK_ID = T.BLOCK_ID
468: );
469:
470: update BNE_LAYOUT_BLOCKS_TL T set (
471: USER_NAME
472: ) = (select
473: B.USER_NAME
474: from BNE_LAYOUT_BLOCKS_TL B

Line 474: from BNE_LAYOUT_BLOCKS_TL B

470: update BNE_LAYOUT_BLOCKS_TL T set (
471: USER_NAME
472: ) = (select
473: B.USER_NAME
474: from BNE_LAYOUT_BLOCKS_TL B
475: where B.APPLICATION_ID = T.APPLICATION_ID
476: and B.LAYOUT_CODE = T.LAYOUT_CODE
477: and B.BLOCK_ID = T.BLOCK_ID
478: and B.LANGUAGE = T.SOURCE_LANG)

Line 489: from BNE_LAYOUT_BLOCKS_TL SUBB, BNE_LAYOUT_BLOCKS_TL SUBT

485: SUBT.APPLICATION_ID,
486: SUBT.LAYOUT_CODE,
487: SUBT.BLOCK_ID,
488: SUBT.LANGUAGE
489: from BNE_LAYOUT_BLOCKS_TL SUBB, BNE_LAYOUT_BLOCKS_TL SUBT
490: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
491: and SUBB.LAYOUT_CODE = SUBT.LAYOUT_CODE
492: and SUBB.BLOCK_ID = SUBT.BLOCK_ID
493: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 497: insert into BNE_LAYOUT_BLOCKS_TL (

493: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
494: and (SUBB.USER_NAME <> SUBT.USER_NAME
495: ));
496:
497: insert into BNE_LAYOUT_BLOCKS_TL (
498: APPLICATION_ID,
499: LAYOUT_CODE,
500: BLOCK_ID,
501: USER_NAME,

Line 521: from BNE_LAYOUT_BLOCKS_TL B, FND_LANGUAGES L

517: B.LAST_UPDATE_LOGIN,
518: B.LAST_UPDATE_DATE,
519: L.LANGUAGE_CODE,
520: B.SOURCE_LANG
521: from BNE_LAYOUT_BLOCKS_TL B, FND_LANGUAGES L
522: where L.INSTALLED_FLAG in ('I', 'B')
523: and B.LANGUAGE = userenv('LANG')
524: and not exists
525: (select NULL

Line 526: from BNE_LAYOUT_BLOCKS_TL T

522: where L.INSTALLED_FLAG in ('I', 'B')
523: and B.LANGUAGE = userenv('LANG')
524: and not exists
525: (select NULL
526: from BNE_LAYOUT_BLOCKS_TL T
527: where T.APPLICATION_ID = B.APPLICATION_ID
528: and T.LAYOUT_CODE = B.LAYOUT_CODE
529: and T.BLOCK_ID = B.BLOCK_ID
530: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 574: from BNE_LAYOUT_BLOCKS_TL

570: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
571: begin
572: select LAST_UPDATED_BY, LAST_UPDATE_DATE
573: into db_luby, db_ludate
574: from BNE_LAYOUT_BLOCKS_TL
575: where APPLICATION_ID = l_app_id
576: and LAYOUT_CODE = x_layout_code
577: and BLOCK_ID = x_block_id
578: and LANGUAGE = userenv('LANG');

Line 584: update BNE_LAYOUT_BLOCKS_TL

580: -- Test for customization and version
581: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
582: db_ludate, x_custom_mode)) then
583:
584: update BNE_LAYOUT_BLOCKS_TL
585: set USER_NAME = x_user_name,
586: PROMPT_ABOVE = x_prompt_above,
587: LAST_UPDATE_DATE = f_ludate,
588: LAST_UPDATED_BY = f_luby,