APPS.GHR_WF_WGI_PKG dependencies on GHR_PA_ROUTING_HISTORY

Line 31: return ghr_pa_routing_history.user_name%TYPE;

27: --
28: function get_next_approver ( p_person_id in per_people_f.person_id%type
29: ,p_effective_date in ghr_pa_requests.effective_date%TYPE
30: )
31: return ghr_pa_routing_history.user_name%TYPE;
32: --
33: --
34: PROCEDURE Get_emp_personnel_groupbox ( p_position_id IN number
35: ,p_effective_date IN date

Line 122: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type

118: --
119: --
120: procedure update_sf52_action_taken(p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
121: ,p_routing_group_id in ghr_pa_requests.routing_group_id%type
122: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type
123: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE
124: ,p_gbx_user_id in ghr_pois.person_id%TYPE);
125: --
126: --

Line 123: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE

119: --
120: procedure update_sf52_action_taken(p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE
121: ,p_routing_group_id in ghr_pa_requests.routing_group_id%type
122: ,p_groupbox_id in ghr_pa_routing_history.groupbox_id%type
123: ,p_action_taken in ghr_pa_routing_history.action_taken%TYPE
124: ,p_gbx_user_id in ghr_pois.person_id%TYPE);
125: --
126: --
127: procedure perofc_approval_required ( itemtype in varchar2,