DBA Data[Home] [Help]

APPS.GHR_PDC_API dependencies on GHR_PD_CLASSIFICATIONS

Line 13: p_pd_classification_id OUT NOCOPY 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 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,

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 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,

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 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)

Line 17: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,

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

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 NOCOPY number)
21: IS
22: l_proc varchar2(72);

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 NOCOPY number)
21: IS
22: l_proc varchar2(72);
23: l_pdc_object_version_number number;

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

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,

Line 156: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,

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,

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

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

Line 160: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,

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:

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

Line 162: p_grade_level IN ghr_pd_classifications.grade_level%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
166: l_proc varchar2(72);

Line 168: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;

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

Line 301: p_pd_classification_id IN ghr_pd_classifications.pd_classification_id%TYPE,

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

Line 307: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;

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