DBA Data[Home] [Help]

APPS.FND_LANGUAGES_PKG dependencies on FND_LANGUAGES_PKG

Line 1: package body FND_LANGUAGES_PKG as

1: package body FND_LANGUAGES_PKG as
2: /* $Header: AFNLDLGB.pls 120.4 2006/03/08 06:21:25 jvalenti ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

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 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 546: FND_LANGUAGES_PKG.INSERT_ROW(

542: end if;
543:
544: exception
545: when no_data_found then
546: FND_LANGUAGES_PKG.INSERT_ROW(
547: X_ROWID,
548: X_LANGUAGE_CODE,
549: X_LANGUAGE_ID,
550: X_NLS_LANGUAGE,

Line 567: end FND_LANGUAGES_PKG;

563: X_UTF8_DATE_LANGUAGE,
564: X_ISO_LANGUAGE_3);
565: end;
566: end LOAD_ROW;
567: end FND_LANGUAGES_PKG;