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_LANGUAGES_PKG dependencies on FND_LANGUAGES

Line 1: package body FND_LANGUAGES_PKG as

1: package body FND_LANGUAGES_PKG as
2: /* $Header: AFNLDLGB.pls 120.4.12010000.2 2009/07/27 21:45:23 jvalenti ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 24: cursor C is select ROWID from FND_LANGUAGES

20: X_LOCAL_DATE_LANGUAGE in VARCHAR2,
21: X_UTF8_DATE_LANGUAGE in VARCHAR2,
22: X_ISO_LANGUAGE_3 in VARCHAR2
23: ) is
24: cursor C is select ROWID from FND_LANGUAGES
25: where LANGUAGE_CODE = X_LANGUAGE_CODE
26: ;
27: begin
28: insert into FND_LANGUAGES (

Line 28: insert into FND_LANGUAGES (

24: cursor C is select ROWID from FND_LANGUAGES
25: where LANGUAGE_CODE = X_LANGUAGE_CODE
26: ;
27: begin
28: insert into FND_LANGUAGES (
29: LANGUAGE_CODE,
30: LANGUAGE_ID,
31: NLS_LANGUAGE,
32: NLS_TERRITORY,

Line 64: insert into FND_LANGUAGES_TL (

60: X_UTF8_DATE_LANGUAGE,
61: X_ISO_LANGUAGE_3
62: );
63:
64: insert into FND_LANGUAGES_TL (
65: LANGUAGE_CODE,
66: DESCRIPTION,
67: CREATED_BY,
68: CREATION_DATE,

Line 84: from FND_LANGUAGES L

80: X_LAST_UPDATE_DATE,
81: X_LAST_UPDATE_LOGIN,
82: L.LANGUAGE_CODE,
83: userenv('LANG')
84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from FND_LANGUAGES_TL T

Line 88: from FND_LANGUAGES_TL T

84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from FND_LANGUAGES_TL T
89: where T.LANGUAGE_CODE = X_LANGUAGE_CODE
90: and T.LANGUAGE = L.LANGUAGE_CODE);
91:
92: open c;

Line 121: from FND_LANGUAGES

117: ISO_LANGUAGE,
118: ISO_TERRITORY,
119: NLS_CODESET,
120: INSTALLED_FLAG
121: from FND_LANGUAGES
122: where LANGUAGE_CODE = X_LANGUAGE_CODE
123: for update of LANGUAGE_CODE nowait;
124: recinfo c%rowtype;
125:

Line 128: from FND_LANGUAGES_TL

124: recinfo c%rowtype;
125:
126: cursor c1 is select
127: DESCRIPTION
128: from FND_LANGUAGES_TL
129: where LANGUAGE_CODE = X_LANGUAGE_CODE
130: and LANGUAGE = userenv('LANG')
131: for update of LANGUAGE_CODE nowait;
132: tlinfo c1%rowtype;

Line 199: update FND_LANGUAGES set

195: ) is
196:
197: begin
198:
199: update FND_LANGUAGES set
200: LANGUAGE_ID = X_LANGUAGE_ID,
201: NLS_LANGUAGE = X_NLS_LANGUAGE,
202: NLS_TERRITORY = X_NLS_TERRITORY,
203: ISO_LANGUAGE = X_ISO_LANGUAGE,

Line 218: update FND_LANGUAGES_TL set

214: if (sql%notfound) then
215: raise no_data_found;
216: end if;
217:
218: update FND_LANGUAGES_TL set
219: DESCRIPTION = X_DESCRIPTION,
220: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
221: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
222: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 236: delete from FND_LANGUAGES

232: procedure DELETE_ROW (
233: X_LANGUAGE_CODE in VARCHAR2
234: ) is
235: begin
236: delete from FND_LANGUAGES
237: where LANGUAGE_CODE = X_LANGUAGE_CODE;
238:
239: if (sql%notfound) then
240: raise no_data_found;

Line 243: delete from FND_LANGUAGES_TL

239: if (sql%notfound) then
240: raise no_data_found;
241: end if;
242:
243: delete from FND_LANGUAGES_TL
244: where LANGUAGE_CODE = X_LANGUAGE_CODE;
245:
246: if (sql%notfound) then
247: raise no_data_found;

Line 260: delete from FND_LANGUAGES_TL T

256: /* as a quick workaround to fix the time-consuming table handler issue */
257: /* Eventually we'll need to turn them into a separate fix_language procedure */
258: /*
259:
260: delete from FND_LANGUAGES_TL T
261: where not exists
262: (select NULL
263: from FND_LANGUAGES B
264: where B.LANGUAGE_CODE = T.LANGUAGE_CODE

Line 263: from FND_LANGUAGES B

259:
260: delete from FND_LANGUAGES_TL T
261: where not exists
262: (select NULL
263: from FND_LANGUAGES B
264: where B.LANGUAGE_CODE = T.LANGUAGE_CODE
265: );
266:
267: update FND_LANGUAGES_TL T set (

Line 267: update FND_LANGUAGES_TL T set (

263: from FND_LANGUAGES B
264: where B.LANGUAGE_CODE = T.LANGUAGE_CODE
265: );
266:
267: update FND_LANGUAGES_TL T set (
268: DESCRIPTION
269: ) = (select
270: B.DESCRIPTION
271: from FND_LANGUAGES_TL B

Line 271: from FND_LANGUAGES_TL B

267: update FND_LANGUAGES_TL T set (
268: DESCRIPTION
269: ) = (select
270: B.DESCRIPTION
271: from FND_LANGUAGES_TL B
272: where B.LANGUAGE_CODE = T.LANGUAGE_CODE
273: and B.LANGUAGE = T.SOURCE_LANG)
274: where (
275: T.LANGUAGE_CODE,

Line 280: from FND_LANGUAGES_TL SUBB, FND_LANGUAGES_TL SUBT

276: T.LANGUAGE
277: ) in (select
278: SUBT.LANGUAGE_CODE,
279: SUBT.LANGUAGE
280: from FND_LANGUAGES_TL SUBB, FND_LANGUAGES_TL SUBT
281: where SUBB.LANGUAGE_CODE = SUBT.LANGUAGE_CODE
282: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
283: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
284: ));

Line 287: insert into FND_LANGUAGES_TL (

283: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
284: ));
285: */
286:
287: insert into FND_LANGUAGES_TL (
288: LANGUAGE_CODE,
289: DESCRIPTION,
290: CREATED_BY,
291: CREATION_DATE,

Line 307: from FND_LANGUAGES_TL B, FND_LANGUAGES L

303: B.LAST_UPDATE_DATE,
304: B.LAST_UPDATE_LOGIN,
305: L.LANGUAGE_CODE,
306: B.SOURCE_LANG
307: from FND_LANGUAGES_TL B, FND_LANGUAGES L
308: where L.INSTALLED_FLAG in ('I', 'B')
309: and B.LANGUAGE = userenv('LANG')
310: and not exists
311: (select NULL

Line 312: from FND_LANGUAGES_TL T

308: where L.INSTALLED_FLAG in ('I', 'B')
309: and B.LANGUAGE = userenv('LANG')
310: and not exists
311: (select NULL
312: from FND_LANGUAGES_TL T
313: where T.LANGUAGE_CODE = B.LANGUAGE_CODE
314: and T.LANGUAGE = L.LANGUAGE_CODE);
315: end ADD_LANGUAGE;
316:

Line 420: from fnd_languages_tl

416:
417: begin
418: select last_updated_by, last_update_date
419: into db_luby, db_ludate
420: from fnd_languages_tl
421: where language_code = X_LANGUAGE_CODE
422: and language = userenv('LANG');
423:
424: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 426: update FND_LANGUAGES_TL set

422: and language = userenv('LANG');
423:
424: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
425: db_ludate, X_CUSTOM_MODE)) then
426: update FND_LANGUAGES_TL set
427: DESCRIPTION = X_DESCRIPTION,
428: LAST_UPDATE_DATE = f_ludate,
429: LAST_UPDATED_BY = f_luby,
430: LAST_UPDATE_LOGIN = 0,

Line 487: from fnd_languages

483: begin
484:
485: select LAST_UPDATED_BY, LAST_UPDATE_DATE
486: into db_luby, db_ludate
487: from fnd_languages
488: where language_code = X_LANGUAGE_CODE;
489:
490: -- Bug4493112 Moved decode select from UPDATE_ROW to LOAD_ROW.
491: -- Bug4648984 Moved sql to inside exception block to handle the

Line 495: decode(x_language_id, fnd_languages_pkg.null_number, null,

491: -- Bug4648984 Moved sql to inside exception block to handle the
492: -- no data found.
493:
494: select
495: decode(x_language_id, fnd_languages_pkg.null_number, null,
496: null, u.language_id,
497: x_language_id),
498: decode(x_iso_language, fnd_languages_pkg.null_char, null,
499: null, u.iso_language,

Line 498: decode(x_iso_language, fnd_languages_pkg.null_char, null,

494: select
495: decode(x_language_id, fnd_languages_pkg.null_number, null,
496: null, u.language_id,
497: x_language_id),
498: decode(x_iso_language, fnd_languages_pkg.null_char, null,
499: null, u.iso_language,
500: x_iso_language),
501: decode(x_iso_territory, fnd_languages_pkg.null_char, null,
502: null, u.iso_territory,

Line 501: decode(x_iso_territory, fnd_languages_pkg.null_char, null,

497: x_language_id),
498: decode(x_iso_language, fnd_languages_pkg.null_char, null,
499: null, u.iso_language,
500: x_iso_language),
501: decode(x_iso_territory, fnd_languages_pkg.null_char, null,
502: null, u.iso_territory,
503: x_iso_territory),
504: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,
505: null, u.nls_codeset,

Line 504: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,

500: x_iso_language),
501: decode(x_iso_territory, fnd_languages_pkg.null_char, null,
502: null, u.iso_territory,
503: x_iso_territory),
504: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,
505: null, u.nls_codeset,
506: x_nls_codeset),
507: decode(x_local_date_language, fnd_languages_pkg.null_char, null,
508: null, u.local_date_language,

Line 507: decode(x_local_date_language, fnd_languages_pkg.null_char, null,

503: x_iso_territory),
504: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,
505: null, u.nls_codeset,
506: x_nls_codeset),
507: decode(x_local_date_language, fnd_languages_pkg.null_char, null,
508: null, u.local_date_language,
509: x_local_date_language),
510: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,
511: null, u.utf8_date_language,

Line 510: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,

506: x_nls_codeset),
507: decode(x_local_date_language, fnd_languages_pkg.null_char, null,
508: null, u.local_date_language,
509: x_local_date_language),
510: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,
511: null, u.utf8_date_language,
512: x_utf8_date_language),
513: decode(x_iso_language_3, fnd_languages_pkg.null_char, null,
514: null, u.iso_language_3,

Line 513: decode(x_iso_language_3, fnd_languages_pkg.null_char, null,

509: x_local_date_language),
510: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,
511: null, u.utf8_date_language,
512: x_utf8_date_language),
513: decode(x_iso_language_3, fnd_languages_pkg.null_char, null,
514: null, u.iso_language_3,
515: x_iso_language_3)
516: into l_language_id,l_iso_language,l_iso_territory,l_nls_codeset,
517: l_local_date_language, l_utf8_date_language, l_iso_language_3

Line 518: from fnd_languages U

514: null, u.iso_language_3,
515: x_iso_language_3)
516: into l_language_id,l_iso_language,l_iso_territory,l_nls_codeset,
517: l_local_date_language, l_utf8_date_language, l_iso_language_3
518: from fnd_languages U
519: where language_code = X_language_code;
520:
521: -- Bug4493112 Modify code to use local variables for UPDATE_ROW and
522: -- INSERT_ROW.

Line 526: FND_LANGUAGES_PKG.UPDATE_ROW(

522: -- INSERT_ROW.
523:
524: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
525: db_ludate, X_CUSTOM_MODE)) then
526: FND_LANGUAGES_PKG.UPDATE_ROW(
527: X_LANGUAGE_CODE,
528: L_LANGUAGE_ID,
529: X_NLS_LANGUAGE,
530: X_NLS_TERRITORY,

Line 551: decode(x_language_id, fnd_languages_pkg.null_number, null,

547: -- bug8727004 - Need to correctly translate the provided NULL value
548: -- for inserting.
549:
550: select
551: decode(x_language_id, fnd_languages_pkg.null_number, null,
552: null, null,x_language_id),
553: decode(x_iso_language, fnd_languages_pkg.null_char, null,
554: null, null,x_iso_language),
555: decode(x_iso_territory, fnd_languages_pkg.null_char, null,

Line 553: decode(x_iso_language, fnd_languages_pkg.null_char, null,

549:
550: select
551: decode(x_language_id, fnd_languages_pkg.null_number, null,
552: null, null,x_language_id),
553: decode(x_iso_language, fnd_languages_pkg.null_char, null,
554: null, null,x_iso_language),
555: decode(x_iso_territory, fnd_languages_pkg.null_char, null,
556: null, null, x_iso_territory),
557: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,

Line 555: decode(x_iso_territory, fnd_languages_pkg.null_char, null,

551: decode(x_language_id, fnd_languages_pkg.null_number, null,
552: null, null,x_language_id),
553: decode(x_iso_language, fnd_languages_pkg.null_char, null,
554: null, null,x_iso_language),
555: decode(x_iso_territory, fnd_languages_pkg.null_char, null,
556: null, null, x_iso_territory),
557: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,
558: null, null, x_nls_codeset),
559: decode(x_local_date_language, fnd_languages_pkg.null_char, null,

Line 557: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,

553: decode(x_iso_language, fnd_languages_pkg.null_char, null,
554: null, null,x_iso_language),
555: decode(x_iso_territory, fnd_languages_pkg.null_char, null,
556: null, null, x_iso_territory),
557: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,
558: null, null, x_nls_codeset),
559: decode(x_local_date_language, fnd_languages_pkg.null_char, null,
560: null, null, x_local_date_language),
561: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,

Line 559: decode(x_local_date_language, fnd_languages_pkg.null_char, null,

555: decode(x_iso_territory, fnd_languages_pkg.null_char, null,
556: null, null, x_iso_territory),
557: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,
558: null, null, x_nls_codeset),
559: decode(x_local_date_language, fnd_languages_pkg.null_char, null,
560: null, null, x_local_date_language),
561: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,
562: null, null, x_utf8_date_language),
563: decode(x_iso_language_3, fnd_languages_pkg.null_char, null,

Line 561: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,

557: decode(x_nls_codeset, fnd_languages_pkg.null_char, null,
558: null, null, x_nls_codeset),
559: decode(x_local_date_language, fnd_languages_pkg.null_char, null,
560: null, null, x_local_date_language),
561: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,
562: null, null, x_utf8_date_language),
563: decode(x_iso_language_3, fnd_languages_pkg.null_char, null,
564: null, null, x_iso_language_3)
565: into l_language_id,l_iso_language,l_iso_territory,l_nls_codeset,

Line 563: decode(x_iso_language_3, fnd_languages_pkg.null_char, null,

559: decode(x_local_date_language, fnd_languages_pkg.null_char, null,
560: null, null, x_local_date_language),
561: decode(x_utf8_date_language, fnd_languages_pkg.null_char, null,
562: null, null, x_utf8_date_language),
563: decode(x_iso_language_3, fnd_languages_pkg.null_char, null,
564: null, null, x_iso_language_3)
565: into l_language_id,l_iso_language,l_iso_territory,l_nls_codeset,
566: l_local_date_language, l_utf8_date_language, l_iso_language_3
567: from dual;

Line 569: FND_LANGUAGES_PKG.INSERT_ROW(

565: into l_language_id,l_iso_language,l_iso_territory,l_nls_codeset,
566: l_local_date_language, l_utf8_date_language, l_iso_language_3
567: from dual;
568:
569: FND_LANGUAGES_PKG.INSERT_ROW(
570: X_ROWID,
571: X_LANGUAGE_CODE,
572: L_LANGUAGE_ID,
573: X_NLS_LANGUAGE,

Line 590: end FND_LANGUAGES_PKG;

586: L_UTF8_DATE_LANGUAGE,
587: L_ISO_LANGUAGE_3);
588: end;
589: end LOAD_ROW;
590: end FND_LANGUAGES_PKG;