860: charset varchar2(150);
861: charmap constant varchar2(30) := 'FND_ISO_CHARACTER_SET_MAP';
862: begin
863: select tag into charset
864: from fnd_lookup_values_vl
865: where lookup_type = charmap
866: and lookup_code = substr(userenv('LANGUAGE'),
867: instr(userenv('LANGUAGE'),'.')+1);
868: return charset;
881: cs varchar2(50);
882: charmap constant varchar2(30) := 'FND_IANA_TO_ORACLE_CHARSET_MAP';
883: begin
884: select tag into cs
885: from fnd_lookup_values_vl
886: where lookup_type = charmap
887: and upper(lookup_code) = upper(ics);
888:
889: if (sql%rowcount <> 1) then
906: ics varchar2(150);
907: charmap constant varchar2(30) := 'FND_ISO_CHARACTER_SET_MAP';
908: begin
909: select tag into ics
910: from fnd_lookup_values_vl
911: where lookup_type = charmap
912: and upper(lookup_code) = upper(cs)
913: and rownum = 1;
914: