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_MASS_CON_PROGRAM dependencies on GHR_PA_ROUTING_HISTORY

Line 614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

610: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;
611: l_rpa_type ghr_pa_requests.rpa_type%TYPE;
612: l_object_version_number ghr_pa_requests.object_version_number%type;
613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
615: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
616: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
617: l_approval_date date;
618: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;

Line 616: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

612: l_object_version_number ghr_pa_requests.object_version_number%type;
613: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
614: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
615: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
616: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
617: l_approval_date date;
618: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
619: l_1_approval_status varchar2(10);
620: l_u_prh_object_version_number number;

Line 1150: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

1146: l_pa_request_rec ghr_pa_requests%rowtype;
1147: l_personnel_officer_name per_people_f.full_name%type;
1148: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1149: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1150: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1151: l_multiple_error_flag boolean;
1152: l_scd_leave varchar2(30);
1153: l_pa_request_id ghr_pa_requests.pa_request_id%TYPE;
1154: l_pa_notification_id ghr_pa_requests.pa_notification_id%TYPE;

Line 1160: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

1156: l_object_version_number ghr_pa_requests.object_version_number%type;
1157: l_log_text varchar2(2000);
1158: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1159: l_groupbox_id ghr_groupboxes.groupbox_id%type;
1160: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1161: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;
1162: l_duty_station_location_id hr_locations.location_id%TYPE;
1163: l_u_prh_object_version_number number;
1164: l_i_pa_routing_history_id number;

Line 1161: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;

1157: l_log_text varchar2(2000);
1158: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1159: l_groupbox_id ghr_groupboxes.groupbox_id%type;
1160: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1161: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;
1162: l_duty_station_location_id hr_locations.location_id%TYPE;
1163: l_u_prh_object_version_number number;
1164: l_i_pa_routing_history_id number;
1165: l_i_prh_object_version_number number;

Line 1182: FROM ghr_pa_routing_history prh

1178:
1179: CURSOR c_routing_history is
1180: SELECT prh.pa_routing_history_id,
1181: prh.object_version_number
1182: FROM ghr_pa_routing_history prh
1183: WHERE prh.pa_request_id = l_pa_request_rec.pa_request_id
1184: ORDER by 1 desc;
1185:
1186: Begin