82: NLS_LANGUAGE,
83: DESCRIPTION,
84: ISO_LANGUAGE,
85: ISO_TERRITORY
86: FROM FND_LANGUAGES_VL
87: WHERE INSTALLED_FLAG in ('I', 'B')
88: ORDER BY DESCRIPTION;
89:
90: c_title varchar2(80);
227: then
228:
229: select language_code
230: into l_language_code
231: from fnd_languages
232: where nls_language = v_language;
233:
234: fnd_global.set_nls(
235: p_nls_language => v_LANGUAGE,