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
4732: IF l_language_code IS NOT NULL THEN
4733: BEGIN
4734: select nls_language
4735: into l_language
4736: from fnd_languages_vl
4737: where LANGUAGE_CODE = l_language_code;
4738: FND_GLOBAL.set_nls_context(p_nls_language => l_language);
4739:
4740: EXCEPTION