DBA Data[Home] [Help]

APPS.GHR_PDC_API dependencies on GHR_PD_CLASSIFICATIONS

Line 13: p_pd_classification_id OUT ghr_pd_classifications.pd_classification_id%TYPE,

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,

Line 15: p_class_grade_by IN ghr_pd_classifications.class_grade_by%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,

Line 16: p_official_title IN ghr_pd_classifications.official_title%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)

Line 17: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,

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

Line 18: p_occupational_code IN ghr_pd_classifications.occupational_code%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
22:

Line 19: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,

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';

Line 78: -- Insert a row into GHR_PD_CLASSIFICATIONS using the row handler.

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,

Line 161: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,

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,

Line 163: p_class_grade_by IN ghr_pd_classifications.class_grade_by%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,

Line 164: p_official_title IN ghr_pd_classifications.official_title%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)

Line 165: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,

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:

Line 166: p_occupational_code IN ghr_pd_classifications.occupational_code%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:
170: IS

Line 167: p_grade_level IN ghr_pd_classifications.grade_level%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
171:

Line 174: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;

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:

Line 303: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,

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';

Line 309: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;

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: