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 4556: from FND_LANGUAGES

4552: l_expired VARCHAR2(5);
4553:
4554: cursor c1 (lang in varchar2) is
4555: select UTF8_DATE_LANGUAGE
4556: from FND_LANGUAGES
4557: where NLS_LANGUAGE = lang;
4558:
4559: cursor c2 (lang in varchar2) is
4560: select LOCAL_DATE_LANGUAGE

Line 4561: from FND_LANGUAGES

4557: where NLS_LANGUAGE = lang;
4558:
4559: cursor c2 (lang in varchar2) is
4560: select LOCAL_DATE_LANGUAGE
4561: from FND_LANGUAGES
4562: where NLS_LANGUAGE = lang;
4563:
4564: begin
4565:

Line 4588: from fnd_languages

4584: end if;
4585:
4586: select language_code
4587: into l_language_code
4588: from fnd_languages
4589: where nls_language = l_language;
4590:
4591: fnd_profile.get_specific(name_z => 'ICX_NLS_SORT',
4592: user_id_z => p_user_id,

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

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