APPS.FND_OBIEE_I18N dependencies on FND_LANGUAGES

Line 40: from fnd_languages fl

36: 'ZHT', fl.ISO_LANGUAGE||'-'||fl.ISO_TERRITORY,
37: 'ZHS', fl.ISO_LANGUAGE||'-'||fl.ISO_TERRITORY,
38: fl.iso_language)
39: into target_lang_code
40: from fnd_languages fl
41: where u_lang_code = fl.language_code;
42:
43: return lower(target_lang_code);
44: exception

Line 88: from fnd_languages fl

84: end if;
85:
86: select fl.language_code
87: into target_lang_code
88: from fnd_languages fl
89: where fl.iso_language = target_lang
90: and fl.iso_territory = target_terr;
91:
92: return target_lang_code;

Line 100: -- record in fnd_languages

96: end;
97: else
98: begin
99: -- for OBIEE code that matches Oracle ISO lang code with a unique
100: -- record in fnd_languages
101: select fl.language_code
102: into target_lang_code
103: from fnd_languages fl
104: where fl.iso_language = u_lang_code;

Line 103: from fnd_languages fl

99: -- for OBIEE code that matches Oracle ISO lang code with a unique
100: -- record in fnd_languages
101: select fl.language_code
102: into target_lang_code
103: from fnd_languages fl
104: where fl.iso_language = u_lang_code;
105:
106: return target_lang_code;
107: exception

Line 108: -- there are multiple entries in fnd_languages with the matching ISO code

104: where fl.iso_language = u_lang_code;
105:
106: return target_lang_code;
107: exception
108: -- there are multiple entries in fnd_languages with the matching ISO code
109: -- for the following OBIEE language codes, hardcode the mapping since
110: -- there is no systematic way of finding the mapping and the language codes
111: -- are not expected to change.
112: when too_many_rows then

Line 271: from fnd_languages fl

267: end if;
268:
269: select fl.language_code
270: into target_lang_code
271: from fnd_languages fl
272: where fl.nls_language = upper(lang);
273:
274: return obiee_convert_langcode('ORACLE', 'OBIEE', target_lang_code);
275: exception

Line 289: from fnd_languages fl

285: target_lang_code := obiee_convert_langcode ('OBIEE', 'ORACLE', lang);
286:
287: select fl.nls_language
288: into target_language
289: from fnd_languages fl
290: where fl.language_code = upper(target_lang_code);
291:
292: return target_language;
293: exception

Line 320: from fnd_languages fl, FND_TERRITORIES ft

316: o_locale varchar2(10) := null;
317: begin
318: select lower(fl.ISO_LANGUAGE)||'-'||lower(ft.TERRITORY_CODE)
319: into o_locale
320: from fnd_languages fl, FND_TERRITORIES ft
321: where fnd_global.nls_language = fl.nls_language
322: and fnd_global.nls_territory = ft.nls_territory
323: and ft.OBSOLETE_FLAG = 'N';
324:

Line 343: from fnd_languages

339: begin
340: -- Get the base language code
341: select language_code
342: into base_lang_code
343: from fnd_languages
344: where installed_flag = 'B';
345:
346: if (lang is null) then
347: return base_lang_code;

Line 360: from fnd_languages

356: else
357: begin
358: select installed_flag
359: into install_status
360: from fnd_languages
361: where language_code = target_lang_code;
362:
363: -- If the matching Oracle language is not installed, return
364: -- the base language code.

Line 398: from fnd_languages

394: target_lang_code := oracle_installed_langcode (lang);
395:
396: select nls_language
397: into target_language
398: from fnd_languages
399: where language_code = target_lang_code;
400:
401: return target_language;
402: