1 PACKAGE ghr_wf_wgi_pkg AUTHID CURRENT_USER AS
2 /* $Header: ghwfwgi.pkh 120.1 2005/07/01 12:44:24 vnarasim noship $ */
3 --
4 --
5 PROCEDURE StartWGIProcess
6 ( p_pa_request_id in number,
7 p_full_name in varchar2);
8 --
9 --
10 procedure FindDestination( itemtype in varchar2
11 ,itemkey in varchar2
12 ,actid in number
13 ,funcmode in varchar2
14 ,result in out nocopy varchar2);
15 --
16 --
17 --
18 PROCEDURE GetRoutingGroupDetails (
19 p_groupbox_name IN varchar2,
20 p_groupbox_id out nocopy number,
21 p_routing_group_id out nocopy number,
22 p_groupbox_desc out nocopy varchar2,
23 p_routing_group_name out nocopy varchar2,
24 p_routing_group_desc out nocopy varchar2
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 --
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 --
42 PROCEDURE Get_par_details ( p_pa_request_id in number
43 ,p_person_id out nocopy number
44 ,p_effective_date out nocopy date
45 ,p_position_id out nocopy number);
46 --
47 --
48 PROCEDURE PersonnelGrpBoxExists( itemtype in varchar2,
49 itemkey in varchar2,
50 actid in number,
51 funcmode in varchar2,
52 result in out nocopy varchar2
53 );
54 --
55 --
56 Procedure CancelSF52Process( itemtype in varchar2,
57 itemkey in varchar2,
58 actid in number,
59 funcmode in varchar2,
60 result in out nocopy varchar2
61 );
62 --
63 --
64 Procedure StartSF52Process( itemtype in varchar2,
65 itemkey in varchar2,
66 actid in number,
67 funcmode in varchar2,
68 result in out nocopy varchar2
69 );
70 --
71 --
72 Function VerifyValidWFUser (p_user_name in varchar2)
73 return boolean;
74 --
75 --
76 PROCEDURE SetDestination( p_request_id in varchar2
77 ,p_person_id in varchar2
78 ,p_position_id in varchar2
79 ,p_effective_date in date
80 ,p_office_symbol_name out nocopy varchar2
81 ,p_line1 out nocopy varchar2
82 ,p_line2 out nocopy varchar2
83 ,p_line3 out nocopy varchar2
84 ,p_line4 out nocopy varchar2
85 ,p_line5 out nocopy varchar2
86 ,p_line6 out nocopy varchar2
87 ,p_line7 out nocopy varchar2
88 ,p_routing_group out nocopy varchar2
89 );
90 --
91 --
92 PROCEDURE UpdateRoutingHistory( itemtype in varchar2,
93 itemkey in varchar2,
94 actid in number,
95 funcmode in varchar2,
96 result in out nocopy varchar2);
97 --
98 --
99 procedure approval_required( itemtype in varchar2,
100 itemkey in varchar2,
101 actid in number,
102 funcmode in varchar2,
103 result in out nocopy varchar2 );
104 --
105 --
106 PROCEDURE CallUpdateToHR( itemtype in varchar2,
107 itemkey in varchar2,
108 actid in number,
109 funcmode in varchar2,
110 result in out nocopy varchar2);
111 --
112 --
113 PROCEDURE EndWGIProcess( itemtype in varchar2
114 ,itemkey in varchar2
115 ,actid in number
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);
125 --
126 --
127 procedure perofc_approval_required ( itemtype in varchar2,
128 itemkey in varchar2,
129 actid in number,
130 funcmode in varchar2,
131 result in out nocopy varchar2 );
132 --
133 --
134 procedure use_perofc_only ( itemtype in varchar2,
135 itemkey in varchar2,
136 actid in number,
137 funcmode in varchar2,
138 result in out nocopy varchar2 );
139 --
140 --
141 procedure FindDestPerOfficeGbx( itemtype in varchar2,
142 itemkey in varchar2,
143 actid in number,
144 funcmode in varchar2,
145 result in out nocopy varchar2 );
146 --
147 --
148 procedure update_sf52_for_wgi_denial ( itemtype in varchar2,
149 itemkey in varchar2,
150 actid in number,
151 funcmode in varchar2,
152 result in out nocopy varchar2);
153 --
154 --
155 procedure CheckNtfyPOI ( itemtype in varchar2,
156 itemkey in varchar2,
157 actid in number,
158 funcmode in varchar2,
159 result in out nocopy varchar2);
160 --
161 --
162 procedure populate_shadow ( itemtype in varchar2,
163 itemkey in varchar2,
164 actid in number,
165 funcmode in varchar2,
166 result in out nocopy varchar2);
167 --
168 --
169 end ghr_wf_wgi_pkg;