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_PARAM_DEFNS_PKG dependencies on BNE_PARAM_DEFNS_TL

Line 59: l_trans_default_string bne_param_defns_tl.default_string%type;

55: where APPLICATION_ID = X_APPLICATION_ID
56: and PARAM_DEFN_CODE = X_PARAM_DEFN_CODE
57: ;
58: l_base_default_string bne_param_defns_b.default_string%type;
59: l_trans_default_string bne_param_defns_tl.default_string%type;
60: begin
61: if X_DEFAULT_STRING_TRANS_FLAG = 'Y'
62: then
63: l_base_default_string := null;

Line 142: insert into BNE_PARAM_DEFNS_TL (

138: X_OA_FLEX_CODE,
139: X_OA_FLEX_NUM
140: );
141:
142: insert into BNE_PARAM_DEFNS_TL (
143: USER_NAME,
144: APPLICATION_ID,
145: PARAM_DEFN_CODE,
146: DEFAULT_STRING,

Line 180: from BNE_PARAM_DEFNS_TL T

176: from FND_LANGUAGES L
177: where L.INSTALLED_FLAG in ('I', 'B')
178: and not exists
179: (select NULL
180: from BNE_PARAM_DEFNS_TL T
181: where T.APPLICATION_ID = X_APPLICATION_ID
182: and T.PARAM_DEFN_CODE = X_PARAM_DEFN_CODE
183: and T.LANGUAGE = L.LANGUAGE_CODE);
184:

Line 275: from BNE_PARAM_DEFNS_TL

271: PROMPT_ABOVE,
272: USER_TIP,
273: ACCESS_KEY,
274: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
275: from BNE_PARAM_DEFNS_TL
276: where APPLICATION_ID = X_APPLICATION_ID
277: and PARAM_DEFN_CODE = X_PARAM_DEFN_CODE
278: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
279: for update of APPLICATION_ID nowait;

Line 403: l_trans_default_string bne_param_defns_tl.default_string%type;

399: X_OA_FLEX_CODE in VARCHAR2,
400: X_OA_FLEX_NUM in VARCHAR2
401: ) is
402: l_base_default_string bne_param_defns_b.default_string%type;
403: l_trans_default_string bne_param_defns_tl.default_string%type;
404: begin
405: if X_DEFAULT_STRING_TRANS_FLAG = 'Y'
406: then
407: l_base_default_string := null;

Line 452: update BNE_PARAM_DEFNS_TL set

448: if (sql%notfound) then
449: raise no_data_found;
450: end if;
451:
452: update BNE_PARAM_DEFNS_TL set
453: USER_NAME = X_USER_NAME,
454: DEFAULT_STRING = l_trans_default_string,
455: DEFAULT_DESC = X_DEFAULT_DESC,
456: PROMPT_LEFT = X_PROMPT_LEFT,

Line 478: delete from BNE_PARAM_DEFNS_TL

474: X_APPLICATION_ID in NUMBER,
475: X_PARAM_DEFN_CODE in VARCHAR2
476: ) is
477: begin
478: delete from BNE_PARAM_DEFNS_TL
479: where APPLICATION_ID = X_APPLICATION_ID
480: and PARAM_DEFN_CODE = X_PARAM_DEFN_CODE;
481:
482: if (sql%notfound) then

Line 498: delete from BNE_PARAM_DEFNS_TL T

494:
495: procedure ADD_LANGUAGE
496: is
497: begin
498: delete from BNE_PARAM_DEFNS_TL T
499: where not exists
500: (select NULL
501: from BNE_PARAM_DEFNS_B B
502: where B.APPLICATION_ID = T.APPLICATION_ID

Line 506: update BNE_PARAM_DEFNS_TL T set (

502: where B.APPLICATION_ID = T.APPLICATION_ID
503: and B.PARAM_DEFN_CODE = T.PARAM_DEFN_CODE
504: );
505:
506: update BNE_PARAM_DEFNS_TL T set (
507: USER_NAME,
508: DEFAULT_STRING,
509: DEFAULT_DESC,
510: PROMPT_LEFT,

Line 522: from BNE_PARAM_DEFNS_TL B

518: B.PROMPT_LEFT,
519: B.PROMPT_ABOVE,
520: B.USER_TIP,
521: B.ACCESS_KEY
522: from BNE_PARAM_DEFNS_TL B
523: where B.APPLICATION_ID = T.APPLICATION_ID
524: and B.PARAM_DEFN_CODE = T.PARAM_DEFN_CODE
525: and B.LANGUAGE = T.SOURCE_LANG)
526: where (

Line 534: from BNE_PARAM_DEFNS_TL SUBB, BNE_PARAM_DEFNS_TL SUBT

530: ) in (select
531: SUBT.APPLICATION_ID,
532: SUBT.PARAM_DEFN_CODE,
533: SUBT.LANGUAGE
534: from BNE_PARAM_DEFNS_TL SUBB, BNE_PARAM_DEFNS_TL SUBT
535: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
536: and SUBB.PARAM_DEFN_CODE = SUBT.PARAM_DEFN_CODE
537: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
538: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 559: insert into BNE_PARAM_DEFNS_TL (

555: or (SUBB.ACCESS_KEY is null and SUBT.ACCESS_KEY is not null)
556: or (SUBB.ACCESS_KEY is not null and SUBT.ACCESS_KEY is null)
557: ));
558:
559: insert into BNE_PARAM_DEFNS_TL (
560: USER_NAME,
561: APPLICATION_ID,
562: PARAM_DEFN_CODE,
563: DEFAULT_STRING,

Line 593: from BNE_PARAM_DEFNS_TL B, FND_LANGUAGES L

589: B.LAST_UPDATE_DATE,
590: B.LAST_UPDATE_LOGIN,
591: L.LANGUAGE_CODE,
592: B.SOURCE_LANG
593: from BNE_PARAM_DEFNS_TL B, FND_LANGUAGES L
594: where L.INSTALLED_FLAG in ('I', 'B')
595: and B.LANGUAGE = userenv('LANG')
596: and not exists
597: (select NULL

Line 598: from BNE_PARAM_DEFNS_TL T

594: where L.INSTALLED_FLAG in ('I', 'B')
595: and B.LANGUAGE = userenv('LANG')
596: and not exists
597: (select NULL
598: from BNE_PARAM_DEFNS_TL T
599: where T.APPLICATION_ID = B.APPLICATION_ID
600: and T.PARAM_DEFN_CODE = B.PARAM_DEFN_CODE
601: and T.LANGUAGE = L.LANGUAGE_CODE);
602: end ADD_LANGUAGE;

Line 649: from BNE_PARAM_DEFNS_TL

645: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
646: begin
647: select LAST_UPDATED_BY, LAST_UPDATE_DATE
648: into db_luby, db_ludate
649: from BNE_PARAM_DEFNS_TL
650: where APPLICATION_ID = l_app_id
651: and PARAM_DEFN_CODE = x_param_defn_code
652: and LANGUAGE = userenv('LANG');
653:

Line 659: update BNE_PARAM_DEFNS_TL

655: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
656: db_ludate, x_custom_mode)) then
657:
658:
659: update BNE_PARAM_DEFNS_TL
660: set USER_TIP = x_user_tip,
661: PROMPT_LEFT = x_prompt_left,
662: PROMPT_ABOVE = x_prompt_above,
663: USER_NAME = x_user_name,