809: --------------------------------------------------------------------------
810: FUNCTION get_IANA_charset RETURN VARCHAR2 IS
811: CURSOR csr_get_iana_charset IS
812: SELECT tag
813: FROM fnd_lookup_values
814: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
815: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
816: INSTR(USERENV('LANGUAGE'), '.') + 1)
817: AND language = 'US';
815: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
816: INSTR(USERENV('LANGUAGE'), '.') + 1)
817: AND language = 'US';
818:
819: lv_iana_charset fnd_lookup_values.tag%type;
820: BEGIN
821: OPEN csr_get_iana_charset;
822: FETCH csr_get_iana_charset INTO lv_iana_charset;
823: CLOSE csr_get_iana_charset;