291: -- to_number is able to handle only upto 126 chars. so making this logic to go beyond 126.
292: --
293: if att_type = 'N' then
294: if nvl(length(p_rec.attribute_value), 0) > 120 then
295: select to_number(substr(p_rec.attribute_value, 1, 120)) into att_val from dual;
296: select to_number(substr(p_rec.attribute_value, 120)) into att_val from dual;
297: else
298: select to_number(p_rec.attribute_value) into att_val from dual;
299: end if;
292: --
293: if att_type = 'N' then
294: if nvl(length(p_rec.attribute_value), 0) > 120 then
295: select to_number(substr(p_rec.attribute_value, 1, 120)) into att_val from dual;
296: select to_number(substr(p_rec.attribute_value, 120)) into att_val from dual;
297: else
298: select to_number(p_rec.attribute_value) into att_val from dual;
299: end if;
300: end if;
294: if nvl(length(p_rec.attribute_value), 0) > 120 then
295: select to_number(substr(p_rec.attribute_value, 1, 120)) into att_val from dual;
296: select to_number(substr(p_rec.attribute_value, 120)) into att_val from dual;
297: else
298: select to_number(p_rec.attribute_value) into att_val from dual;
299: end if;
300: end if;
301: else
302: hr_utility.set_message(8302, 'PQH_ATTRIBUTE_NOT_FOUND');