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.12010000.2 2009/07/27 21:45:23 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 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;