/* 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;
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