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_ROUTING_HISTORY

Line 17: l_ItemKey ghr_pd_routing_history.item_key%TYPE := p_item_key ;

13: p_forward_to_name in varchar2
14: ) is
15: --
16: l_ItemType varchar2(30) := 'OF8';
17: l_ItemKey ghr_pd_routing_history.item_key%TYPE := p_item_key ;
18: l_from_name varchar2(500);
19: l_forward_from_display_name varchar2(100);
20: l_load_form varchar2(100);
21: l_load_pdrh varchar2(100);

Line 29: l_current_status ghr_pd_routing_history.action_taken%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);
33: --

Line 196: l_user_name ghr_pd_routing_history.user_name%TYPE;

192: funcmode in varchar2,
193: result in OUT NOCOPY varchar2 ) is
194: --
195: --
196: l_user_name ghr_pd_routing_history.user_name%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;

Line 198: l_action_taken ghr_pd_routing_history.action_taken%TYPE;

194: --
195: --
196: l_user_name ghr_pd_routing_history.user_name%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;

Line 207: l_current_status ghr_pd_routing_history.action_taken%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);
211: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;

Line 354: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;

350: p_groupbox_name OUT NOCOPY varchar2
351: ) IS
352:
353: -- Local variables
354: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
355: l_user_name ghr_pd_routing_history.user_name%TYPE;
356: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
357: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
358: l_groupbox_name ghr_groupboxes.name%TYPE;

Line 355: l_user_name ghr_pd_routing_history.user_name%TYPE;

351: ) IS
352:
353: -- Local variables
354: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
355: l_user_name ghr_pd_routing_history.user_name%TYPE;
356: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
357: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
358: l_groupbox_name ghr_groupboxes.name%TYPE;
359: --

Line 356: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;

352:
353: -- Local variables
354: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
355: l_user_name ghr_pd_routing_history.user_name%TYPE;
356: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
357: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
358: l_groupbox_name ghr_groupboxes.name%TYPE;
359: --
360: cursor csr_pd_routing_history is

Line 357: l_action_taken ghr_pd_routing_history.action_taken%TYPE;

353: -- Local variables
354: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;
355: l_user_name ghr_pd_routing_history.user_name%TYPE;
356: l_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
357: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
358: l_groupbox_name ghr_groupboxes.name%TYPE;
359: --
360: cursor csr_pd_routing_history is
361: SELECT max(pd_routing_history_id)

Line 362: FROM ghr_pd_routing_history

358: l_groupbox_name ghr_groupboxes.name%TYPE;
359: --
360: cursor csr_pd_routing_history is
361: SELECT max(pd_routing_history_id)
362: FROM ghr_pd_routing_history
363: WHERE position_description_id = p_position_description_id;
364: --
365: cursor csr_pd_routing_details is
366: SELECT action_taken, user_name, groupbox_id

Line 367: FROM ghr_pd_routing_history

363: WHERE position_description_id = p_position_description_id;
364: --
365: cursor csr_pd_routing_details is
366: SELECT action_taken, user_name, groupbox_id
367: FROM ghr_pd_routing_history
368: WHERE pd_routing_history_id = l_pd_routing_history_id;
369: cursor csr_groupbox_details is
370: SELECT name
371: FROM GHR_GROUPBOXES

Line 447: l_pd_routing_history_id ghr_pd_routing_history.pd_routing_history_id%TYPE;

443: p_date_received OUT NOCOPY varchar2
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;

Line 457: l_action_taken ghr_pd_routing_history.action_taken%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;
461: --

Line 458: l_date_initiated ghr_pd_routing_history.date_notification_sent%TYPE;

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;
461: --
462: l_routing_group_id ghr_position_descriptions.routing_group_id%TYPE;

Line 459: l_date_received ghr_pd_routing_history.date_notification_sent%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;
461: --
462: l_routing_group_id ghr_position_descriptions.routing_group_id%TYPE;
463: l_routing_group_name ghr_routing_groups.name%TYPE;

Line 460: l_date_notification_sent ghr_pd_routing_history.date_notification_sent%TYPE;

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;
461: --
462: l_routing_group_id ghr_position_descriptions.routing_group_id%TYPE;
463: l_routing_group_name ghr_routing_groups.name%TYPE;
464: l_count integer;

Line 490: SELECT action_taken, date_notification_sent from ghr_pd_routing_history

486: FROM ghr_routing_groups
487: WHERE routing_group_id = l_routing_group_id;
488: --
489: cursor csr_get_routing_details is
490: SELECT action_taken, date_notification_sent from ghr_pd_routing_history
491: where position_description_id = p_position_description_id
492: order by pd_routing_history_id desc;
493: --
494: begin

Line 617: l_Item_Key ghr_pd_routing_history.item_key%TYPE;

613: --
614: procedure CompleteBlockingOfPD ( p_position_description_id in Number) is
615: --
616: --
617: l_Item_Key ghr_pd_routing_history.item_key%TYPE;
618: --
619: cursor csr_pdh is
620: SELECT max(to_number(item_key))
621: FROM ghr_pd_routing_history

Line 621: FROM ghr_pd_routing_history

617: l_Item_Key ghr_pd_routing_history.item_key%TYPE;
618: --
619: cursor csr_pdh is
620: SELECT max(to_number(item_key))
621: FROM ghr_pd_routing_history
622: WHERE position_description_id = p_position_description_id;
623: --
624: begin
625: open csr_pdh;

Line 753: l_action_taken ghr_pd_routing_history.action_taken%TYPE;

749: funcmode in varchar2,
750: result in OUT NOCOPY varchar2) is
751: --
752: --
753: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
754: l_position_description_id ghr_position_descriptions.position_description_id%TYPE;
755: l_load_form varchar2(100);
756: l_result VARCHAR2(4000);
757: --

Line 760: FROM ghr_pd_routing_history

756: l_result VARCHAR2(4000);
757: --
758: cursor csr_pdh is
759: SELECT action_taken
760: FROM ghr_pd_routing_history
761: WHERE position_description_id = l_position_description_id
762: order by pd_routing_history_id desc;
763: --
764: begin