APPS.ORACLEAPPS dependencies on FND_LANGUAGES

Line 945: from fnd_languages b,

941:
942: begin
943: select b.language_code
944: into c_language_code
945: from fnd_languages b,
946: icx_sessions a
947: where a.session_id = c_session_id
948: and b.nls_language = a.nls_language;
949:

Line 954: from FND_LANGUAGES

950: exception
951: when NO_DATA_FOUND then -- bug 643163, check session exists
952: select LANGUAGE_CODE
953: into c_language_code
954: from FND_LANGUAGES
955: where INSTALLED_FLAG = 'B';
956:
957: end;
958:

Line 1551: from fnd_languages b,

1547: if (l_session_id is not NULL) -- This will happen during the login process
1548: then
1549: select b.language_code
1550: into c_language_code
1551: from fnd_languages b,
1552: icx_sessions a
1553: where a.session_id = n_session_id
1554: and b.nls_language = a.nls_language;
1555: else

Line 3182: FROM FND_LANGUAGES_VL

3178: NLS_LANGUAGE,
3179: DESCRIPTION,
3180: ISO_LANGUAGE,
3181: ISO_TERRITORY
3182: FROM FND_LANGUAGES_VL
3183: WHERE INSTALLED_FLAG in ('I', 'B')
3184: ORDER BY DESCRIPTION;
3185:
3186: cursor get_mail is

Line 3995: from fnd_languages

3991:
3992: -- select added mputman bug 1405228
3993: select nls_language
3994: into p_lang_change
3995: from fnd_languages
3996: where language_code = (SELECT language_code
3997: FROM icx_sessions
3998: WHERE session_id = n_session_id);
3999:

Line 4002: from fnd_languages

3998: WHERE session_id = n_session_id);
3999:
4000: select language_code
4001: into c_language_code
4002: from fnd_languages
4003: where nls_language = c_LANGUAGE;
4004: -- bug 2656698
4005: -- get prof option vals for date_lang and sort.
4006: -- call fnd_global.set_nls to get return vals for date_lang and sort.

Line 4517: from fnd_languages b

4513: c_upper_lang:=upper(c_lang);
4514: begin
4515: select b.language_code, b.nls_language
4516: into c_language_code, c_nls_language
4517: from fnd_languages b
4518: where b.language_code = c_upper_lang;
4519:
4520:
4521: exception

Line 4526: from FND_LANGUAGES

4522: when NO_DATA_FOUND then
4523:
4524: select LANGUAGE_CODE, nls_language
4525: into c_language_code, c_nls_language
4526: from FND_LANGUAGES
4527: where INSTALLED_FLAG = 'B';
4528: end;
4529: FND_GLOBAL.set_nls_context(p_nls_language =>c_nls_language);
4530: --c_nls_language := ''''||c_nls_language||'''';

Line 4737: from fnd_languages_vl

4733: IF l_language_code IS NOT NULL THEN
4734: BEGIN
4735: select nls_language
4736: into l_language
4737: from fnd_languages_vl
4738: where LANGUAGE_CODE = l_language_code;
4739: FND_GLOBAL.set_nls_context(p_nls_language => l_language);
4740:
4741: EXCEPTION