16: -------------------------------------------------------------------------------
17: FUNCTION get_IANA_charset RETURN VARCHAR2 IS
18: CURSOR csr_get_iana_charset IS
19: SELECT tag
20: FROM fnd_lookup_values
21: WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
22: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
23: INSTR(USERENV('LANGUAGE'), '.') + 1)
24: AND language = 'US';
22: AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
23: INSTR(USERENV('LANGUAGE'), '.') + 1)
24: AND language = 'US';
25:
26: lv_iana_charset fnd_lookup_values.tag%type;
27: BEGIN
28: OPEN csr_get_iana_charset;
29: FETCH csr_get_iana_charset INTO lv_iana_charset;
30: CLOSE csr_get_iana_charset;