API To Upload Value Set Values

DECLARE

   v_enabled_flag        VARCHAR2 (2)                  := 'Y';

   v_summary_flag        VARCHAR2 (2)                  := 'Y';

   v_start_date_active   DATE                          := SYSDATE;

   v_error_msg           VARCHAR2 (1000)               := NULL;

   v_who_type            fnd_flex_loader_apis.who_type;

Oracle apps Value set - Sample Code

SELECT ffv.attribute1

  FROM fnd_flex_value_sets ffvs, fnd_flex_values_tl ffvt, fnd_flex_values ffv

 WHERE     ffvs.flex_value_set_name = 'XX_SAMPLE_VALUESET_VS'

       AND ffvs.flex_value_set_id = ffv.flex_value_set_id

       AND ffv.flex_value_id = ffvt.flex_value_id

       AND ffvt.description = lv_value