Monday, 9 June 2014

HRMS update job API

/* Formatted on 6/9/2014 12:53:58 PM (QP5 v5.115.810.9015) */
DECLARE
   v_validate                       BOOLEAN := FALSE;
   v_date                           DATE := NULL;
   v_valid_grades_changed_warning   BOOLEAN;

   CURSOR c1
   IS
      SELECT job_id, object_version_number, job_definition_id, name
      FROM per_jobs
      WHERE job_id = 35997;
BEGIN
   FOR a IN c1
   LOOP
      hr_job_api.update_job (p_validate => v_validate,
                             p_job_id => a.job_id,
                             p_object_version_number => a.object_version_number,
                             p_date_to => v_date,
                             p_job_definition_id => a.job_definition_id,
                             p_name => a.name,
                             p_valid_grades_changed_warning => v_valid_grades_changed_warning
      );
   END LOOP;
END;

No comments:

Post a Comment