2163: if ( numeric_characters is not null ) then
2164: begin
2165: select lookup_code
2166: into dummy_val
2167: from fnd_lookup_values_vl
2168: where lookup_type = 'ICX_NUMERIC_CHARACTERS' and
2169: lookup_code = numeric_characters;
2170: exception
2171: when no_data_found then
3756: begin
3757:
3758: select count(*)
3759: into l_lookup_cnt
3760: from fnd_lookup_values_vl
3761: where lookup_type = 'ICX_NUMERIC_CHARACTERS'
3762: and lookup_code = num_char;
3763:
3764: if ( l_lookup_cnt > 0 ) then