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

Line 688: delete from ghr_pa_routing_history

684: where pa_request_id = l_pa_request_id;
685:
686: -- Delete the database RPA award routing history record for the given person_id
687: hr_utility.set_location( l_proc,35);
688: delete from ghr_pa_routing_history
689: where pa_request_id = l_pa_request_id;
690:
691: -- Delete the database RPA award record for the given person_id
692: hr_utility.set_location( l_proc,35);

Line 728: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

724: l_mass_action_comments ghr_pa_requests.mass_action_comments%TYPE;
725: l_object_version_number ghr_pa_requests.object_version_number%type;
726:
727: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
728: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
729: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
730: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
731:
732: l_approval_date date;

Line 730: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

726:
727: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
728: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
729: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
730: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
731:
732: l_approval_date date;
733: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
734: l_1_approval_status varchar2(10);

Line 1636: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

1632: l_approving_off_work_title ghr_pa_requests.APPROVING_OFFICIAL_WORK_TITLE%type;
1633: l_1_approval_status varchar2(10);
1634:
1635: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1636: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1637: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
1638: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1639:
1640: l_multiple_error_flag boolean;

Line 1638: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

1634:
1635: l_1_prh_object_version_number ghr_pa_requests.object_version_number%type;
1636: l_1_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1637: l_2_prh_object_version_number ghr_pa_requests.object_version_number%type;
1638: l_2_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1639:
1640: l_multiple_error_flag boolean;
1641: l_result boolean;
1642:

Line 1655: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;

1651: l_object_version_number ghr_pa_requests.object_version_number%type;
1652: l_log_text varchar2(2000);
1653: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1654: l_groupbox_id ghr_groupboxes.groupbox_id%type;
1655: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1656: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;
1657:
1658: l_duty_station_location_id hr_locations.location_id%TYPE;
1659: l_duty_station_id ghr_duty_stations_v.duty_station_id%TYPE;

Line 1656: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;

1652: l_log_text varchar2(2000);
1653: l_routing_group_id ghr_pa_requests.routing_group_id%type;
1654: l_groupbox_id ghr_groupboxes.groupbox_id%type;
1655: l_pa_routing_history_id ghr_pa_routing_history.pa_routing_history_id%type;
1656: l_prh_object_version_number ghr_pa_routing_history.object_version_number%type;
1657:
1658: l_duty_station_location_id hr_locations.location_id%TYPE;
1659: l_duty_station_id ghr_duty_stations_v.duty_station_id%TYPE;
1660: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;

Line 1708: FROM ghr_pa_routing_history prh

1704:
1705: CURSOR c_routing_history is
1706: SELECT prh.pa_routing_history_id,
1707: prh.object_version_number
1708: FROM ghr_pa_routing_history prh
1709: WHERE prh.pa_request_id = l_pa_request_rec.pa_request_id
1710: ORDER by 1 desc;
1711:
1712: CURSOR cur_maw_name IS