129: --
130: --
131:
132: PROCEDURE chk_grade_level(p_pd_classification_id IN
133: ghr_pd_classifications.pd_classification_id%TYPE,
134: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
135: p_effective_date IN date,
136: p_object_version_number IN number)
137:
130: --
131:
132: PROCEDURE chk_grade_level(p_pd_classification_id IN
133: ghr_pd_classifications.pd_classification_id%TYPE,
134: p_grade_level IN ghr_pd_classifications.grade_level%TYPE,
135: p_effective_date IN date,
136: p_object_version_number IN number)
137:
138: IS
210: --
211:
212:
213: PROCEDURE chk_pay_plan(p_pd_classification_id IN
214: ghr_pd_classifications.pd_classification_id%TYPE,
215: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
216: p_effective_date IN date,
217: p_object_version_number IN number)
218:
211:
212:
213: PROCEDURE chk_pay_plan(p_pd_classification_id IN
214: ghr_pd_classifications.pd_classification_id%TYPE,
215: p_pay_plan IN ghr_pd_classifications.pay_plan%TYPE,
216: p_effective_date IN date,
217: p_object_version_number IN number)
218:
219: IS
294: --
295:
296:
297: PROCEDURE chk_occupational_code(p_pd_classification_id IN
298: ghr_pd_classifications.pd_classification_id%TYPE,
299: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
300: p_effective_date IN date,
301: p_object_version_number IN number)
302:
295:
296:
297: PROCEDURE chk_occupational_code(p_pd_classification_id IN
298: ghr_pd_classifications.pd_classification_id%TYPE,
299: p_occupational_code IN ghr_pd_classifications.occupational_code%TYPE,
300: p_effective_date IN date,
301: p_object_version_number IN number)
302:
303: IS
372: END CHK_OCCUPATIONAL_CODE;
373:
374:
375: PROCEDURE CHK_CLASS_GRADE_BY(p_pd_classification_id IN
376: ghr_pd_classifications.pd_classification_id%TYPE,
377: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
378: p_effective_date IN date,
379: p_object_version_number IN number)
380:
373:
374:
375: PROCEDURE CHK_CLASS_GRADE_BY(p_pd_classification_id IN
376: ghr_pd_classifications.pd_classification_id%TYPE,
377: p_class_grade_by IN ghr_pd_classifications.class_grade_by%TYPE,
378: p_effective_date IN date,
379: p_object_version_number IN number)
380:
381: IS