19: l_forward_from_display_name varchar2(100);
20: l_load_form varchar2(100);
21: l_load_pdrh varchar2(100);
22: l_category ghr_position_descriptions.category%TYPE;
23: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
24: l_grade_level ghr_pd_classifications.grade_level%TYPE;
25: l_official_title ghr_pd_classifications.official_title%TYPE;
26:
27: --
20: l_load_form varchar2(100);
21: l_load_pdrh varchar2(100);
22: l_category ghr_position_descriptions.category%TYPE;
23: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
24: l_grade_level ghr_pd_classifications.grade_level%TYPE;
25: l_official_title ghr_pd_classifications.official_title%TYPE;
26:
27: --
28: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;
21: l_load_pdrh varchar2(100);
22: l_category ghr_position_descriptions.category%TYPE;
23: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
24: l_grade_level ghr_pd_classifications.grade_level%TYPE;
25: l_official_title ghr_pd_classifications.official_title%TYPE;
26:
27: --
28: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;
29: l_current_status ghr_pd_routing_history.action_taken%TYPE;
24: l_grade_level ghr_pd_classifications.grade_level%TYPE;
25: l_official_title ghr_pd_classifications.official_title%TYPE;
26:
27: --
28: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;
29: l_current_status ghr_pd_routing_history.action_taken%TYPE;
30: l_date_initiated varchar2(15);
31: l_date_received varchar2(15);
32: l_routing_group varchar2(500);
197: l_from_name VARCHAR2(500);
198: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
199: l_groupbox_name ghr_groupboxes.name%TYPE;
200: l_category ghr_position_descriptions.category%TYPE;
201: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
202: l_official_title ghr_pd_classifications.official_title%TYPE;
203: l_grade_level ghr_pd_classifications.grade_level%TYPE;
204: --
205:
198: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
199: l_groupbox_name ghr_groupboxes.name%TYPE;
200: l_category ghr_position_descriptions.category%TYPE;
201: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
202: l_official_title ghr_pd_classifications.official_title%TYPE;
203: l_grade_level ghr_pd_classifications.grade_level%TYPE;
204: --
205:
206: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;
199: l_groupbox_name ghr_groupboxes.name%TYPE;
200: l_category ghr_position_descriptions.category%TYPE;
201: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
202: l_official_title ghr_pd_classifications.official_title%TYPE;
203: l_grade_level ghr_pd_classifications.grade_level%TYPE;
204: --
205:
206: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;
207: l_current_status ghr_pd_routing_history.action_taken%TYPE;
202: l_official_title ghr_pd_classifications.official_title%TYPE;
203: l_grade_level ghr_pd_classifications.grade_level%TYPE;
204: --
205:
206: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;
207: l_current_status ghr_pd_routing_history.action_taken%TYPE;
208: l_date_initiated varchar2(15);
209: l_date_received varchar2(15);
210: l_routing_group varchar2(500);
444: ) is
445: -- Local variables
446: l_category ghr_position_descriptions.category%TYPE;
447: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
448: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
449: l_grade_level ghr_pd_classifications.grade_level%TYPE;
450: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
451: l_full_name per_people_f.full_name%TYPE;
452: l_description ghr_routing_groups.description%TYPE;
445: -- Local variables
446: l_category ghr_position_descriptions.category%TYPE;
447: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
448: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
449: l_grade_level ghr_pd_classifications.grade_level%TYPE;
450: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
451: l_full_name per_people_f.full_name%TYPE;
452: l_description ghr_routing_groups.description%TYPE;
453: l_name varchar2(240);
446: l_category ghr_position_descriptions.category%TYPE;
447: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
448: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;
449: l_grade_level ghr_pd_classifications.grade_level%TYPE;
450: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
451: l_full_name per_people_f.full_name%TYPE;
452: l_description ghr_routing_groups.description%TYPE;
453: l_name varchar2(240);
454: l_official_title ghr_pd_classifications.official_title%TYPE;
450: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;
451: l_full_name per_people_f.full_name%TYPE;
452: l_description ghr_routing_groups.description%TYPE;
453: l_name varchar2(240);
454: l_official_title ghr_pd_classifications.official_title%TYPE;
455: --
456: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;
457: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
458: l_date_initiated ghr_pd_routing_history.date_notification_sent%TYPE;
452: l_description ghr_routing_groups.description%TYPE;
453: l_name varchar2(240);
454: l_official_title ghr_pd_classifications.official_title%TYPE;
455: --
456: l_pay_plan ghr_pd_classifications.pay_plan%TYPE;
457: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
458: l_date_initiated ghr_pd_routing_history.date_notification_sent%TYPE;
459: l_date_received ghr_pd_routing_history.date_notification_sent%TYPE;
460: l_date_notification_sent ghr_pd_routing_history.date_notification_sent%TYPE;
470: WHERE position_description_id = p_position_description_id;
471: --
472: cursor csr_pdc is
473: SELECT count(*)
474: FROM ghr_pd_classifications
475: WHERE position_description_id = p_position_description_id;
476: --
477: cursor csr_pd_classification_details (l_class_grade_by in varchar2) is
478: SELECT occupational_code, grade_level, official_title, pay_plan
475: WHERE position_description_id = p_position_description_id;
476: --
477: cursor csr_pd_classification_details (l_class_grade_by in varchar2) is
478: SELECT occupational_code, grade_level, official_title, pay_plan
479: FROM ghr_pd_classifications
480: WHERE position_description_id = p_position_description_id
481: and class_grade_by = l_class_grade_by;
482: --
483: --