[Home] [Help]
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 NOCOPY 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 NOCOPY 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 NOCOPY 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 NOCOPY number)
13: p_pd_classification_id OUT NOCOPY 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 NOCOPY 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 NOCOPY number)
21: IS
22: l_proc varchar2(72);
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 NOCOPY number)
21: IS
22: l_proc varchar2(72);
23: l_pdc_object_version_number number;
67: hr_utility.raise_error;
68: END IF;
69:
70: -- Process Logic
71: -- Insert a row into GHR_PD_CLASSIFICATIONS using the row handler.
72:
73: ghr_pdc_ins.ins
74: (p_pd_classification_id => l_pd_classification_id,
75: p_position_description_id => p_position_description_id,
152:
153:
154: PROCEDURE
155: update_pdc(p_validate IN BOOLEAN default false,
156: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
157: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
158: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
159: p_official_title IN ghr_pd_classifications.official_title%TYPE,
160: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
154: PROCEDURE
155: update_pdc(p_validate IN BOOLEAN default false,
156: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
157: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
158: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
159: p_official_title IN ghr_pd_classifications.official_title%TYPE,
160: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
161: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
162: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
155: update_pdc(p_validate IN BOOLEAN default false,
156: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
157: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
158: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
159: p_official_title IN ghr_pd_classifications.official_title%TYPE,
160: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
161: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
162: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
163: p_pdc_object_version_number IN out NOCOPY number)
156: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
157: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
158: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
159: p_official_title IN ghr_pd_classifications.official_title%TYPE,
160: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
161: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
162: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
163: p_pdc_object_version_number IN out NOCOPY number)
164:
157: p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
158: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
159: p_official_title IN ghr_pd_classifications.official_title%TYPE,
160: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
161: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
162: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
163: p_pdc_object_version_number IN out NOCOPY number)
164:
165: IS
158: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
159: p_official_title IN ghr_pd_classifications.official_title%TYPE,
160: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
161: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
162: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
163: p_pdc_object_version_number IN out NOCOPY number)
164:
165: IS
166: l_proc varchar2(72);
164:
165: IS
166: l_proc varchar2(72);
167: l_object_version_number number;
168: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
169: l_pdc_object_version_number NUMBER;
170:
171: BEGIN
172: l_proc := g_package||'Update_pdc';
297: end update_pdc;
298:
299: PROCEDURE delete_pdc
300: ( p_validate IN BOOLEAN default false,
301: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,
302: p_pdc_object_version_number in number)
303: IS
304:
305: l_proc varchar2(72) ;
303: IS
304:
305: l_proc varchar2(72) ;
306: l_object_version_number number;
307: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
308:
309:
310: BEGIN
311: l_proc := g_package||'Delete_pdc';