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_PDI_API dependencies on GHR_GROUPBOXES

Line 85: l_forward_to_name ghr_groupboxes.name%TYPE;

81: l_user_name_emp_first_name per_people_f.first_name%TYPE;
82: l_user_name_emp_last_name per_people_f.last_name%TYPE;
83: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
84: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
85: l_forward_to_name ghr_groupboxes.name%TYPE;
86: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
87: l_2_user_name ghr_pd_routing_history.user_name%TYPE;
88: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
89: l_item_key ghr_pd_routing_history.item_key%TYPE;

Line 133: from ghr_groupboxes gbx

129: from ghr_pd_routing_history pdh
130: where pdh.position_description_id = l_position_description_id;
131: Cursor c_groupbox_name is
132: select gbx.name
133: from ghr_groupboxes gbx
134: where gbx.groupbox_id = l_2_groupbox_id;
135: Cursor c_item_key_seq is
136: select ghr_pd_wf_item_key_s.nextval
137: from dual;

Line 632: l_next_groupbox_name ghr_groupboxes.name%TYPE;

628: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
629: l_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
630: l_cur_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
631: l_next_seq_numb ghr_pd_routing_history.routing_seq_number%TYPE;
632: l_next_groupbox_name ghr_groupboxes.name%TYPE;
633: l_next_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
634: l_next_user_name ghr_pd_routing_history.user_name%TYPE := p_i_user_name_routed_to;
635: l_action_taken ghr_pd_routing_history.action_taken%TYPE;
636: l_old_action_taken ghr_pd_routing_history.action_taken%TYPE;

Line 722: from ghr_groupboxes gbx

718: and action_taken = 'INITIATED';
719:
720: cursor c_groupbox_name is
721: select gbx.name
722: from ghr_groupboxes gbx
723: where gbx.groupbox_id = l_next_groupbox_id;
724: Cursor c_item_key_seq is
725: select ghr_pd_wf_item_key_s.nextval
726: from dual;

Line 1332: l_forward_to_name ghr_groupboxes.name%TYPE;

1328: l_user_name_emp_first_name per_people_f.first_name%TYPE;
1329: l_user_name_emp_last_name per_people_f.last_name%TYPE;
1330: l_user_name_emp_middle_names per_people_f.middle_names%TYPE;
1331: l_2_routing_seq_number ghr_pd_routing_history.routing_seq_number%TYPE;
1332: l_forward_to_name ghr_groupboxes.name%TYPE;
1333: l_2_groupbox_id ghr_pd_routing_history.groupbox_id%TYPE;
1334: l_user_name_1 ghr_pd_routing_history.user_name%TYPE;
1335: l_user_name_2 ghr_pd_routing_history.user_name%TYPE;
1336: l_last_action_taken_1 ghr_pd_routing_history.action_taken%TYPE;

Line 1355: from ghr_groupboxes gbx

1351: from ghr_pd_routing_history pdh
1352: where pdh.position_description_id = p_position_description_id;
1353: Cursor c_groupbox_name is
1354: select gbx.name
1355: from ghr_groupboxes gbx
1356: where gbx.groupbox_id = l_groupbox_id_1;
1357: Cursor c_item_key_seq is
1358: select ghr_pd_wf_item_key_s.nextval
1359: from dual;