Wednesday, December 31, 2014

API to Delete Employee Appraisal

Salam Alaikum,

   I share with you guys this API, that i used to delete an Appraisal for employees.

DECLARE
   v_appraisal_id            NUMBER;
   v_object_version_number   NUMBER;
   l_template_id             NUMBER;
   l_rating_level_id         NUMBER;
   l_appraisal_id            NUMBER;
   v_date_of_hire            DATE;
   v_start_date_var          DATE;
   v_end_date_var            DATE;
   l_object_version_number   NUMBER;

   CURSOR app_data
   IS
      SELECT *
        FROM per_appraisals;     
BEGIN
   FOR i_rec IN app_data
   LOOP

        HR_UTILITY.FND_INSERT(SYSDATE);

      hr_appraisals_api.delete_appraisal
                    (p_appraisal_id                 => i_rec.appraisal_id,
                     p_object_version_number        => i_rec.OBJECT_VERSION_NUMBER
                    );

         commit;
        
   END LOOP;
END;

Hope you found it useful guys, feel free to leave a comment if have any note on the subject.   

No comments:

Post a Comment