eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_WF_PD_PKG dependencies on GHR_PD_CLASSIFICATIONS

Line 23: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;

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

Line 24: l_grade_level ghr_pd_classifications.grade_level%TYPE;

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;

Line 25: l_official_title ghr_pd_classifications.official_title%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;

Line 28: l_pay_plan ghr_pd_classifications.pay_plan%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);

Line 201: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;

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:

Line 202: l_official_title ghr_pd_classifications.official_title%TYPE;

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;

Line 203: l_grade_level ghr_pd_classifications.grade_level%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;

Line 206: l_pay_plan ghr_pd_classifications.pay_plan%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);

Line 448: l_occupational_code ghr_pd_classifications.occupational_code%TYPE;

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;

Line 449: l_grade_level ghr_pd_classifications.grade_level%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);

Line 450: l_pd_classification_id ghr_pd_classifications.pd_classification_id%TYPE;

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;

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

Line 456: l_pay_plan ghr_pd_classifications.pay_plan%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;

Line 474: FROM ghr_pd_classifications

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

Line 479: 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
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: --