APPS.ICX_SEC dependencies on FND_LANGUAGES

Line 531: from FND_LANGUAGES

527:
528:
529: cursor c1 (lang in varchar2) is
530: select UTF8_DATE_LANGUAGE
531: from FND_LANGUAGES
532: where NLS_LANGUAGE = lang;
533:
534: cursor c2 (lang in varchar2) is
535: select LOCAL_DATE_LANGUAGE

Line 536: from FND_LANGUAGES

532: where NLS_LANGUAGE = lang;
533:
534: cursor c2 (lang in varchar2) is
535: select LOCAL_DATE_LANGUAGE
536: from FND_LANGUAGES
537: where NLS_LANGUAGE = lang;
538:
539: begin
540:

Line 1605: from fnd_languages

1601: if icx_sec.g_language_code is null
1602: then
1603: select language_code
1604: into icx_sec.g_language_code
1605: from fnd_languages
1606: where nls_language = icx_sec.g_language;
1607: end if;
1608:
1609: -- **************************************************

Line 3060: from FND_LANGUAGES

3056: if n_param = PV_LANGUAGE_CODE --** LANGUAGE CODE (21) **
3057: then
3058: select LANGUAGE_CODE
3059: into n_id
3060: from FND_LANGUAGES
3061: where INSTALLED_FLAG = 'B';
3062: elsif n_param = PV_DATE_FORMAT --** DATE FORMAT MASK (22) **
3063: then
3064: /*

Line 4552: from FND_LANGUAGES

4548: l_expired VARCHAR2(5);
4549:
4550: cursor c1 (lang in varchar2) is
4551: select UTF8_DATE_LANGUAGE
4552: from FND_LANGUAGES
4553: where NLS_LANGUAGE = lang;
4554:
4555: cursor c2 (lang in varchar2) is
4556: select LOCAL_DATE_LANGUAGE

Line 4557: from FND_LANGUAGES

4553: where NLS_LANGUAGE = lang;
4554:
4555: cursor c2 (lang in varchar2) is
4556: select LOCAL_DATE_LANGUAGE
4557: from FND_LANGUAGES
4558: where NLS_LANGUAGE = lang;
4559:
4560: begin
4561:

Line 4584: from fnd_languages

4580: end if;
4581:
4582: select language_code
4583: into l_language_code
4584: from fnd_languages
4585: where nls_language = l_language;
4586:
4587: fnd_profile.get_specific(name_z => 'ICX_NLS_SORT',
4588: user_id_z => p_user_id,

Line 4628: /* set the NLS date language. Get it from the FND_LANGUAGES table,

4624: l_date_format := replace(l_date_format, 'RR', 'RRRR');
4625: end if;
4626: end if;
4627:
4628: /* set the NLS date language. Get it from the FND_LANGUAGES table,
4629: choosing which column based on whether the codeset is UTF8
4630: or AL32UTF8. But the profile ICX_DATE_LANGUAGE overrides
4631: all that if it is set.
4632: */