/* Formatted on 6/9/2014 11:48:05 AM (QP5 v5.115.810.9015) */
DECLARE
v_validate BOOLEAN := FALSE;
v_attribute20 VARCHAR2 (100) := NULL;
v_valid_grades_changed_warning BOOLEAN;
CURSOR c1
IS
SELECT position_id, object_version_number, position_definition_id, name
FROM per_all_positions
WHERE position_id = 60549;
BEGIN
FOR a IN c1
LOOP
hr_position_api.update_position (p_validate => v_validate,
p_position_id => a.position_id,
p_object_version_number => a.object_version_number,
p_attribute20 => v_attribute20,
p_position_definition_id => a.position_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_attribute20 VARCHAR2 (100) := NULL;
v_valid_grades_changed_warning BOOLEAN;
CURSOR c1
IS
SELECT position_id, object_version_number, position_definition_id, name
FROM per_all_positions
WHERE position_id = 60549;
BEGIN
FOR a IN c1
LOOP
hr_position_api.update_position (p_validate => v_validate,
p_position_id => a.position_id,
p_object_version_number => a.object_version_number,
p_attribute20 => v_attribute20,
p_position_definition_id => a.position_definition_id,
p_name => a.name,
p_valid_grades_changed_warning => v_valid_grades_changed_warning
);
END LOOP;
END;
No comments:
Post a Comment