API to Update Absence Type

DECLARE

   CURSOR c1

   IS

      SELECT *

        FROM per_absence_attendance_types

       WHERE business_group_id = 10549 AND name = 'Annual Leave';

   l_attribute5   NUMBER := 68896;

BEGIN

   FOR i IN c1

   LOOP

      BEGIN

         hr_absence_type_api.update_absence_type (

            p_validate                     => FALSE,

            p_absence_attendance_type_id   => i.absence_attendance_type_id,

            p_date_end                     => i.date_end,

            p_attribute5                   => l_attribute5,

            p_object_version_number        => i.object_version_number);

         COMMIT;

         DBMS_OUTPUT.put_line (

            i.absence_attendance_type_id || ' has been Updated ');

      EXCEPTION

         WHEN OTHERS

         THEN

            DBMS_OUTPUT.put_line (

               i.absence_attendance_type_id || ' Failure -->  ' || SQLERRM);

      END;

   END LOOP;

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line (' Failure -->  ' || SQLERRM);

END;