APPS.GHR_WF_WGI_PKG dependencies on GHR_PA_REQUESTS

Line 29: ,p_effective_date in ghr_pa_requests.effective_date%TYPE

25: ) ;
26: --
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: --

Line 37: ,p_personnel_office_id out nocopy ghr_pa_requests.personnel_office_id%TYPE

33: --
34: PROCEDURE Get_emp_personnel_groupbox ( p_position_id IN number
35: ,p_effective_date IN date
36: ,p_groupbox_name out nocopy varchar2
37: ,p_personnel_office_id out nocopy ghr_pa_requests.personnel_office_id%TYPE
38: ,p_gbx_user_id out nocopy ghr_pois.person_id%TYPE
39: );
40: --
41: --

Line 120: procedure update_sf52_action_taken(p_pa_request_id in ghr_pa_requests.pa_request_id%TYPE

116: ,funcmode in varchar2
117: ,result in out nocopy varchar2);
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);

Line 121: ,p_routing_group_id in ghr_pa_requests.routing_group_id%type

117: ,result in out nocopy varchar2);
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: --