API to Delete EIT Structure

--select * from fnd_descr_flex_contexts  where descriptive_flex_context_code = 'XXHR_XXX_EDUCATION'-- EIT Details

--select *   from fnd_descr_flex_col_usage_vl where descriptive_flex_context_code = 'XXHR_XXX_EDUCATION' - EIT Column Details

DECLARE

   CURSOR c1

   IS

      SELECT *

        FROM fnd_descr_flex_contexts

       WHERE descriptive_flex_context_code = 'XXHR_XXX_EDUCATION';

BEGIN

   FOR i IN c1

   LOOP

      BEGIN

         fnd_flex_dsc_api.delete_context (

            appl_short_name   => 'PER',                                  -- HR

            flexfield_name    => i.descriptive_flexfield_name,

            context           => i.descriptive_flex_context_code);

         DBMS_OUTPUT.put_line (

               i.descriptive_flex_context_code

            || ' has been deleted Successfully!');

      EXCEPTION

         WHEN OTHERS

         THEN

            DBMS_OUTPUT.put_line (

                  ' Inner Exception: '

               || i.descriptive_flex_context_code

               || ' - '

               || SQLERRM);

      END;

   END LOOP;

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line (' Main Exception: ' || SQLERRM);

END;