9: l_pdc_object_version_number number;
10:
11: PROCEDURE create_pdc
12: (p_validate IN BOOLEAN default false,
13: p_pd_classification_id OUT ghr_pd_classifications.pd_classification_id%TYPE,
14: p_position_description_id IN number,
15: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
16: p_official_title IN ghr_pd_classifications.official_title%TYPE,
17: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
11: PROCEDURE create_pdc
12: (p_validate IN BOOLEAN default false,
13: p_pd_classification_id OUT ghr_pd_classifications.pd_classification_id%TYPE,
14: p_position_description_id IN number,
15: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
16: p_official_title IN ghr_pd_classifications.official_title%TYPE,
17: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
18: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
19: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
12: (p_validate IN BOOLEAN default false,
13: p_pd_classification_id OUT ghr_pd_classifications.pd_classification_id%TYPE,
14: p_position_description_id IN number,
15: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
16: p_official_title IN ghr_pd_classifications.official_title%TYPE,
17: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
18: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
19: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
20: p_pdc_object_version_number out number)
13: p_pd_classification_id OUT ghr_pd_classifications.pd_classification_id%TYPE,
14: p_position_description_id IN number,
15: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
16: p_official_title IN ghr_pd_classifications.official_title%TYPE,
17: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
18: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
19: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
20: p_pdc_object_version_number out number)
21: IS
14: p_position_description_id IN number,
15: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
16: p_official_title IN ghr_pd_classifications.official_title%TYPE,
17: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
18: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
19: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
20: p_pdc_object_version_number out number)
21: IS
22:
15: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
16: p_official_title IN ghr_pd_classifications.official_title%TYPE,
17: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
18: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
19: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
20: p_pdc_object_version_number out number)
21: IS
22:
23: l_proc varchar2(72) := g_package||' create_pdc';
74: hr_utility.raise_error;
75: END IF;
76:
77: -- Process Logic
78: -- Insert a row into GHR_PD_CLASSIFICATIONS using the row handler.
79:
80: ghr_pdc_ins.ins
81: (p_pd_classification_id => l_pd_classification_id,
82: p_position_description_id => p_position_description_id,
157:
158:
159: PROCEDURE
160: update_pdc(p_validate IN BOOLEAN default false,
161: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
162: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
163: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
164: p_official_title IN ghr_pd_classifications.official_title%TYPE,
165: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
159: PROCEDURE
160: update_pdc(p_validate IN BOOLEAN default false,
161: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
162: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
163: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
164: p_official_title IN ghr_pd_classifications.official_title%TYPE,
165: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
166: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
167: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
160: update_pdc(p_validate IN BOOLEAN default false,
161: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
162: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
163: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
164: p_official_title IN ghr_pd_classifications.official_title%TYPE,
165: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
166: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
167: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
168: p_pdc_object_version_number IN out number)
161: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
162: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
163: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
164: p_official_title IN ghr_pd_classifications.official_title%TYPE,
165: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
166: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
167: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
168: p_pdc_object_version_number IN out number)
169:
162: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
163: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
164: p_official_title IN ghr_pd_classifications.official_title%TYPE,
165: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
166: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
167: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
168: p_pdc_object_version_number IN out number)
169:
170: IS
163: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
164: p_official_title IN ghr_pd_classifications.official_title%TYPE,
165: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
166: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
167: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
168: p_pdc_object_version_number IN out number)
169:
170: IS
171:
170: IS
171:
172: l_proc varchar2(72) := g_package||'Update_pdc';
173: l_object_version_number number;
174: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
175:
176:
177: BEGIN
178:
299: end update_pdc;
300:
301: PROCEDURE delete_pdc
302: ( p_validate IN BOOLEAN default false,
303: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
304: p_pdc_object_version_number in number)
305: IS
306:
307: l_proc varchar2(72) := g_package||'Delete_pdc';
305: IS
306:
307: l_proc varchar2(72) := g_package||'Delete_pdc';
308: l_object_version_number number;
309: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
310:
311:
312: BEGIN
313: