API to Delete Competence Elements

DECLARE

   CURSOR c1

   IS

      SELECT *

        FROM per_competence_elements

       WHERE business_group_id = 10529 AND competence_element_id = 1467595;

BEGIN

   FOR i IN c1

   LOOP

      BEGIN

         hr_competence_element_api.delete_competence_element (

            p_validate                => FALSE,

            p_competence_element_id   => i.competence_element_id,

            p_object_version_number   => i.object_version_number);

         COMMIT;

         DBMS_OUTPUT.put_line (

            i.competence_element_id || ' has been deleted');

      EXCEPTION

         WHEN OTHERS

         THEN

            DBMS_OUTPUT.put_line (

               'Failure: ' || i.competence_element_id || '- ' || SQLERRM);

      END;

   END LOOP;

EXCEPTION

   WHEN OTHERS

   THEN

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

END;