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

Line 55: l_user_name ghr_pa_routing_history.user_name%TYPE;

51: result in out nocopy varchar2 ) is
52: --
53: --
54: --
55: l_user_name ghr_pa_routing_history.user_name%TYPE;
56: l_person_id ghr_pa_requests.person_id%TYPE;
57: l_position_id ghr_pa_requests.from_position_id%TYPE;
58: l_effective_date ghr_pa_requests.effective_date%TYPE;
59: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

Line 64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;

60: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
61: l_full_name per_people_f.full_name%TYPE;
62: l_routing_group_name ghr_routing_groups.name%TYPE;
63: l_routing_group_desc ghr_routing_groups.description%TYPE;
64: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
65: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
66: l_groupbox_name ghr_groupboxes.name%TYPE;
67: l_groupbox_desc ghr_groupboxes.description%TYPE;
68: l_office_symbol_name hr_lookups.meaning%TYPE;

Line 435: return ghr_pa_routing_history.user_name%TYPE is

431: function get_next_approver
432: (p_person_id in per_people_f.person_id%type,
433: p_effective_date in ghr_pa_requests.effective_date%TYPE
434: )
435: return ghr_pa_routing_history.user_name%TYPE is
436: --
437: l_in_person_id ghr_pa_requests.person_id%TYPE;
438: l_effective_date ghr_pa_requests.effective_date%TYPE;
439: l_out_person_name ghr_pa_routing_history.user_name%TYPE;

Line 439: l_out_person_name ghr_pa_routing_history.user_name%TYPE;

435: return ghr_pa_routing_history.user_name%TYPE is
436: --
437: l_in_person_id ghr_pa_requests.person_id%TYPE;
438: l_effective_date ghr_pa_requests.effective_date%TYPE;
439: l_out_person_name ghr_pa_routing_history.user_name%TYPE;
440: --
441: cursor csr_pa is
442: select substr(usr.user_name,1,30) user_name
443: from per_assignments_f paf

Line 657: l_grpbox_name ghr_pa_routing_history.user_name%TYPE;

653: actid in number,
654: funcmode in varchar2,
655: result in out nocopy varchar2
656: ) is
657: l_grpbox_name ghr_pa_routing_history.user_name%TYPE;
658: l_error_msg varchar2(1000);
659: l_result VARCHAR2(250);
660: Begin
661: l_result := result;

Line 1046: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type

1042: --
1043: --
1044: procedure update_sf52_action_taken(p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1045: ,p_routing_group_id in ghr_pa_requests.routing_group_id%type
1046: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type
1047: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE
1048: ,p_gbx_user_id in ghr_pois.person_id%TYPE)
1049: is
1050: --

Line 1047: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE

1043: --
1044: procedure update_sf52_action_taken(p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
1045: ,p_routing_group_id in ghr_pa_requests.routing_group_id%type
1046: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type
1047: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE
1048: ,p_gbx_user_id in ghr_pois.person_id%TYPE)
1049: is
1050: --
1051: Cursor c_fnd_sessions is

Line 1233: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;

1229: l_first_lac2_information4 ghr_pa_requests.first_lac2_information4%TYPE;
1230: l_first_lac2_information5 ghr_pa_requests.first_lac2_information5%TYPE;
1231: l_u_attachment_modified_flag varchar2(30);
1232: l_u_approved_flag varchar2(30);
1233: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
1234: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
1235: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
1236: l_i_routing_list_id number;
1237: l_i_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;

Line 1234: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;

1230: l_first_lac2_information5 ghr_pa_requests.first_lac2_information5%TYPE;
1231: l_u_attachment_modified_flag varchar2(30);
1232: l_u_approved_flag varchar2(30);
1233: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
1234: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
1235: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
1236: l_i_routing_list_id number;
1237: l_i_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
1238: l_u_prh_object_version_number number;

Line 1235: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;

1231: l_u_attachment_modified_flag varchar2(30);
1232: l_u_approved_flag varchar2(30);
1233: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
1234: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
1235: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
1236: l_i_routing_list_id number;
1237: l_i_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
1238: l_u_prh_object_version_number number;
1239: l_i_pa_routing_history_id number;

Line 1237: l_i_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;

1233: l_u_user_name_acted_on ghr_pa_routing_history.user_name%TYPE;
1234: l_i_user_name_routed_to ghr_pa_routing_history.user_name%TYPE;
1235: l_i_groupbox_id ghr_pa_routing_history.groupbox_id%TYPE;
1236: l_i_routing_list_id number;
1237: l_i_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
1238: l_u_prh_object_version_number number;
1239: l_i_pa_routing_history_id number;
1240: l_i_prh_object_version_number number;
1241: l_u_approval_status ghr_pa_routing_history.approval_status%TYPE;

Line 1241: l_u_approval_status ghr_pa_routing_history.approval_status%TYPE;

1237: l_i_routing_seq_number ghr_pa_routing_history.routing_seq_number%TYPE;
1238: l_u_prh_object_version_number number;
1239: l_i_pa_routing_history_id number;
1240: l_i_prh_object_version_number number;
1241: l_u_approval_status ghr_pa_routing_history.approval_status%TYPE;
1242: l_approving_official_full_name ghr_pa_requests.approving_official_full_name%TYPE;
1243: l_approving_official_work_titl ghr_pa_requests.approving_official_work_title%TYPE;
1244: l_approval_date ghr_pa_requests.approval_date%TYPE;
1245: --

Line 1256: from ghr_pa_routing_history

1252: --
1253: -- Added cursor to select object version number and routing history id
1254: cursor csr_get_parh_info is
1255: select pa_routing_history_id, object_version_number
1256: from ghr_pa_routing_history
1257: where pa_request_id = p_pa_request_id;
1258: --
1259: cursor csr_par_details is
1260: select

Line 1992: l_user_name ghr_pa_routing_history.user_name%TYPE;

1988: result in out nocopy varchar2 ) is
1989: --
1990: --
1991: --
1992: l_user_name ghr_pa_routing_history.user_name%TYPE;
1993: l_person_id ghr_pa_requests.person_id%TYPE;
1994: l_position_id ghr_pa_requests.from_position_id%TYPE;
1995: l_effective_date ghr_pa_requests.effective_date%TYPE;
1996: l_routing_group_id ghr_pa_requests.routing_group_id%TYPE;

Line 2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;

1997: l_assignment_id ghr_pa_requests.employee_assignment_id%TYPE;
1998: l_full_name per_people_f.full_name%TYPE;
1999: l_routing_group_name ghr_routing_groups.name%TYPE;
2000: l_routing_group_desc ghr_routing_groups.description%TYPE;
2001: l_supervisor_name ghr_pa_routing_history.user_name%TYPE;
2002: l_groupbox_id ghr_groupboxes.groupbox_id%TYPE;
2003: l_groupbox_name ghr_groupboxes.name%TYPE;
2004: l_groupbox_desc ghr_groupboxes.description%TYPE;
2005: l_office_symbol_name hr_lookups.meaning%TYPE;