158: -- Cursor to fetch Value Sets
159: -------------------------------------
160: CURSOR c_value_sets IS
161: SELECT value_set_id
162: FROM fem_value_sets_b
163: WHERE dimension_id = p_dimension_id
164: AND value_set_id IN
165: (p_val_set_id1,p_val_set_id2,p_val_set_id3,
166: p_val_set_id4,p_val_set_id5,p_val_set_id6,
380:
381: BEGIN
382: SELECT value_set_id
383: INTO v_val_set_id
384: FROM fem_value_sets_b
385: WHERE dimension_id = p_dimension_id
386: AND value_set_id = a_val_set_id(v_arr);
387: EXCEPTION
388: WHEN no_data_found THEN