Tuesday, November 10, 2009

Function to validate value set value

=============================================================
FUNCTION get_validate (v_value_set_id IN NUMBER, v_data_value IN VARCHAR2)
RETURN VARCHAR2
----------------------------------------------------------------------------------------
-- Name : get_validate
-- Pre-reqs : None
-- Purpose : This Function is used validate data from value set name
-- Note :
-- Modifications:
-- Who Date What Changed?
------------------------------------------------------------------------------------------
IS
v_vset fnd_vset.valueset_r;
v_fmt fnd_vset.valueset_dr;
v_found BOOLEAN;
v_row NUMBER;
v_value fnd_vset.value_dr;
BEGIN
fnd_vset.get_valueset (v_value_set_id, v_vset, v_fmt);
fnd_vset.get_value_init (v_vset, TRUE);
fnd_vset.get_value (v_vset, v_row, v_found, v_value);

WHILE (v_found)
LOOP
IF (v_value.VALUE = v_data_value)
THEN
fnd_vset.get_value_end (v_vset);
RETURN 'TRUE';
END IF;

fnd_vset.get_value (v_vset, v_row, v_found, v_value);
END LOOP;

fnd_vset.get_value_end (v_vset);
RETURN 'FALSE';
END get_validate;
===========================================================

No comments: