1 Package HR_PROCESS_EIT_SS AUTHID CURRENT_USER as
2 /* $Header: hreitwrs.pkh 120.0.12020000.1 2012/06/28 23:52:19 appldev ship $ */
3
4
5 gv_wf_review_region_item constant wf_item_attributes.name%type
6 := 'HR_REVIEW_REGION_ITEM';
7
8
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< save_transaction_data >--------------------------------|
12 -- ----------------------------------------------------------------------------
13 /*
14 ||===========================================================================
15 || PROCEDURE: save_transaction_data
16 ||---------------------------------------------------------------------------
17 ||
18 || Description:
19 ||
20 || Pre Conditions:
21 ||
22 || In Arguments:
23 ||
24 || out nocopy Arguments:
25 ||
26 || In out nocopy Arguments:
27 ||
28 || Post Success:
29 ||
30 || Post Failure:
31 || Raises an exception
32 ||
33 || Access Status:
34 || Public.
35 ||
36 ||===========================================================================
37 */
38
39 PROCEDURE save_transaction_data
40 (p_person_id in number
41 ,p_login_person_id in number
42 ,p_eit_type in varchar2
43 ,p_eit_type_id in number
44 ,p_eit_number in number
45 ,p_eit_table in HR_EIT_STRUCTURE_TABLE
46 ,p_item_type in varchar2
47 ,p_item_key in varchar2
48 ,p_activity_id in number
49 ,p_transaction_step_id out nocopy number
50 ,p_error_message out nocopy varchar2
51 ,p_active_view in varchar2
52 ,p_active_row_id in number
53 ,p_flow_mode in varchar2 default null
54 );
55
56
57 -- ---------------------------------------------------------------------------
58 -- ---------------------- < get_eit_data_from_tt> -------------------------
59 -- ---------------------------------------------------------------------------
60 -- Purpose: This procedure will get transaction data which are pending for
61 -- approval in workflow for a given person id, workflow process name
62 -- and workflow activity name. This is the overloaded version.
63 -- ---------------------------------------------------------------------------
64 PROCEDURE get_eit_data_from_tt
65 (p_item_type in varchar2
66 ,p_item_key in varchar2
67 ,p_activity_id in number
68 ,p_person_id out nocopy number
69 ,p_login_person_id out nocopy number
70 ,p_eit_type out nocopy varchar2
71 ,p_eit_type_id out nocopy number
72 ,p_eit_number out nocopy number
73 ,p_eit_table out nocopy HR_EIT_STRUCTURE_TABLE
74 ,p_error_message out nocopy long
75 ,p_active_view out nocopy varchar2
76 ,p_active_row_id out nocopy number
77 );
78
79 --
80 -- ----------------------------------------------------------------------------
81 -- |-----------------------< get_eit_data_from_tt >---------------------------|
82 -- ----------------------------------------------------------------------------
83 -- Purpose: This procedure will get transaction data which are pending for
84 -- approval in workflow for a transaction step id.
85 -- ---------------------------------------------------------------------------
86
87 procedure get_eit_data_from_tt
88 (p_transaction_step_id in number
89 ,p_person_id out nocopy number
90 ,p_login_person_id out nocopy number
91 ,p_eit_type out nocopy varchar2
92 ,p_eit_type_id out nocopy number
93 ,p_eit_number out nocopy number
94 ,p_eit_table out nocopy HR_EIT_STRUCTURE_TABLE
95 ,p_error_message out nocopy long
96 ,p_active_view out nocopy varchar2
97 ,p_active_row_id out nocopy number
98 );
99
100 -- ----------------------------------------------------------------------------
101 -- |-----------------------< del_transaction_data >---------------------------|
102 -- Wrapper Package for API hr_process_sit_ss.
103 --
104 -- Description:
105 -- This Function dels the transaction data for the given item type, item key
106 -- and activity id.
107 -- ----------------------------------------------------------------------------
108
109 PROCEDURE del_transaction_data
110 (p_item_type in varchar2
111 ,p_item_key in varchar2
112 ,p_activity_id in varchar2
113 ,p_login_person_id in varchar2
114 ,p_flow_mode in varchar2 default null
115 );
116
117 --
118 -- ----------------------------------------------------------------------------
119 -- |-----------------------< process_api >-------------------------------------|
120 -- ----------------------------------------------------------------------------
121 -- Purpose: This procedure .....
122 -- ---------------------------------------------------------------------------
123
124 PROCEDURE PROCESS_API
125 (p_validate IN BOOLEAN DEFAULT FALSE
126 ,p_transaction_step_id IN NUMBER DEFAULT NULL
127 ,p_effective_date IN VARCHAR2 DEFAULT null
128 );
129
130 --
131 -- ----------------------------------------------------------------------------
132 -- |----------------------------< create_eit >--------------------------------|
133 -- ----------------------------------------------------------------------------
134 /*
135 ||===========================================================================
136 || PROCEDURE: create_eit
137 ||---------------------------------------------------------------------------
138 ||
139 || Description:
140 || Description:
141 || This procedure will call the actual API -
142 ||
143 || Pre Conditions:
144 ||
145 || In Arguments:
146 || Contains entire list of parameters that are defined in the actual
147 || API.
148 ||
149 || out nocopy Arguments:
150 ||
151 || In out nocopy Arguments:
152 ||
153 || Post Success:
154 || Executes the API call.
155 ||
156 || Post Failure:
157 || Raises an exception
158 ||
159 || Access Status:
160 || Public.
161 ||
162 ||===========================================================================
163 */
164 procedure create_eit
165 (p_validate in number default 0
166 ,p_login_person_id in number default null
167 ,p_eit_type in varchar2
168 ,p_person_id in number
169 ,p_information_type in varchar2
170 ,p_attribute_category in varchar2 default null
171 ,p_attribute1 in varchar2 default null
172 ,p_attribute2 in varchar2 default null
173 ,p_attribute3 in varchar2 default null
174 ,p_attribute4 in varchar2 default null
175 ,p_attribute5 in varchar2 default null
176 ,p_attribute6 in varchar2 default null
177 ,p_attribute7 in varchar2 default null
178 ,p_attribute8 in varchar2 default null
179 ,p_attribute9 in varchar2 default null
180 ,p_attribute10 in varchar2 default null
181 ,p_attribute11 in varchar2 default null
182 ,p_attribute12 in varchar2 default null
183 ,p_attribute13 in varchar2 default null
184 ,p_attribute14 in varchar2 default null
185 ,p_attribute15 in varchar2 default null
186 ,p_attribute16 in varchar2 default null
187 ,p_attribute17 in varchar2 default null
188 ,p_attribute18 in varchar2 default null
189 ,p_attribute19 in varchar2 default null
190 ,p_attribute20 in varchar2 default null
191 ,p_information_category in varchar2 default null
192 ,p_information1 in varchar2 default null
193 ,p_information2 in varchar2 default null
194 ,p_information3 in varchar2 default null
195 ,p_information4 in varchar2 default null
196 ,p_information5 in varchar2 default null
197 ,p_information6 in varchar2 default null
198 ,p_information7 in varchar2 default null
199 ,p_information8 in varchar2 default null
200 ,p_information9 in varchar2 default null
201 ,p_information10 in varchar2 default null
202 ,p_information11 in varchar2 default null
203 ,p_information12 in varchar2 default null
204 ,p_information13 in varchar2 default null
205 ,p_information14 in varchar2 default null
206 ,p_information15 in varchar2 default null
207 ,p_information16 in varchar2 default null
208 ,p_information17 in varchar2 default null
209 ,p_information18 in varchar2 default null
210 ,p_information19 in varchar2 default null
211 ,p_information20 in varchar2 default null
212 ,p_information21 in varchar2 default null
213 ,p_information22 in varchar2 default null
214 ,p_information23 in varchar2 default null
215 ,p_information24 in varchar2 default null
216 ,p_information25 in varchar2 default null
217 ,p_information26 in varchar2 default null
218 ,p_information27 in varchar2 default null
219 ,p_information28 in varchar2 default null
220 ,p_information29 in varchar2 default null
221 ,p_information30 in varchar2 default null
222 ,p_extra_info_id out nocopy number
223 ,p_object_version_number out nocopy number
224 -- EndRegistration
225 ,p_item_type in varchar2
226 ,p_item_key in varchar2
227 ,p_activity_id in number
228 ,p_action in varchar2
229 ,p_old_extra_info_id in number default null
230 ,p_old_object_version_number in number default null
231 ,p_save_mode in varchar2 default null
232 ,p_error_message out nocopy long
233 ,p_eit_type_id in number
234 ,p_flow_mode in varchar2 default null
235 );
236
237 --
238 -- ----------------------------------------------------------------------------
239 -- |----------------------------< update_eit >--------------------------------|
240 -- ----------------------------------------------------------------------------
241 /*
242 ||===========================================================================
243 || PROCEDURE: update_eit
244 ||---------------------------------------------------------------------------
245 ||
246 || Description:
247 || Description:
248 || This procedure will call the actual API -
249 ||
250 || Pre Conditions:
251 ||
252 || In Arguments:
253 || Contains entire list of parameters that are defined in the actual
254 || API.
255 ||
256 || out nocopy Arguments:
257 ||
258 || In out nocopy Arguments:
259 ||
260 || Post Success:
261 || Executes the API call.
262 ||
263 || Post Failure:
264 || Raises an exception
265 ||
266 || Access Status:
267 || Public.
268 ||
272 PROCEDURE update_eit
269 ||===========================================================================
270 */
271
273 (p_validate in number default 0
274 ,p_login_person_id in number default null
275 ,p_eit_type in varchar2
276 ,p_person_id in number
277 ,p_information_type in varchar2
278 ,p_attribute_category in varchar2 default null
279 ,p_attribute1 in varchar2 default null
280 ,p_attribute2 in varchar2 default null
281 ,p_attribute3 in varchar2 default null
282 ,p_attribute4 in varchar2 default null
283 ,p_attribute5 in varchar2 default null
284 ,p_attribute6 in varchar2 default null
285 ,p_attribute7 in varchar2 default null
286 ,p_attribute8 in varchar2 default null
287 ,p_attribute9 in varchar2 default null
288 ,p_attribute10 in varchar2 default null
289 ,p_attribute11 in varchar2 default null
290 ,p_attribute12 in varchar2 default null
291 ,p_attribute13 in varchar2 default null
292 ,p_attribute14 in varchar2 default null
293 ,p_attribute15 in varchar2 default null
294 ,p_attribute16 in varchar2 default null
295 ,p_attribute17 in varchar2 default null
296 ,p_attribute18 in varchar2 default null
297 ,p_attribute19 in varchar2 default null
298 ,p_attribute20 in varchar2 default null
299 ,p_information_category in varchar2 default null
300 ,p_information1 in varchar2 default null
301 ,p_information2 in varchar2 default null
302 ,p_information3 in varchar2 default null
303 ,p_information4 in varchar2 default null
304 ,p_information5 in varchar2 default null
305 ,p_information6 in varchar2 default null
306 ,p_information7 in varchar2 default null
307 ,p_information8 in varchar2 default null
308 ,p_information9 in varchar2 default null
309 ,p_information10 in varchar2 default null
310 ,p_information11 in varchar2 default null
311 ,p_information12 in varchar2 default null
312 ,p_information13 in varchar2 default null
313 ,p_information14 in varchar2 default null
314 ,p_information15 in varchar2 default null
315 ,p_information16 in varchar2 default null
316 ,p_information17 in varchar2 default null
317 ,p_information18 in varchar2 default null
318 ,p_information19 in varchar2 default null
319 ,p_information20 in varchar2 default null
320 ,p_information21 in varchar2 default null
321 ,p_information22 in varchar2 default null
322 ,p_information23 in varchar2 default null
323 ,p_information24 in varchar2 default null
324 ,p_information25 in varchar2 default null
325 ,p_information26 in varchar2 default null
326 ,p_information27 in varchar2 default null
327 ,p_information28 in varchar2 default null
328 ,p_information29 in varchar2 default null
329 ,p_information30 in varchar2 default null
330 ,p_extra_info_id in number
331 ,p_object_version_number in out nocopy number
332 -- EndRegistration
333 ,p_item_type in varchar2
334 ,p_item_key in varchar2
335 ,p_activity_id in number
336 ,p_action in varchar2
337 ,p_old_extra_info_id in number default null
338 ,p_old_object_version_number in number default null
339 ,p_save_mode in varchar2 default null
340 ,p_error_message out nocopy long
341 ,p_eit_type_id in number
342 );
343 --
344 -- ----------------------------------------------------------------------------
345 -- |----------------------------< delete_eit >--------------------------------|
346 -- ----------------------------------------------------------------------------
347 /*
348 ||===========================================================================
349 || PROCEDURE: delete_eit
350 ||---------------------------------------------------------------------------
351 ||
352 || Description:
353 || Description:
354 || This procedure will call the actual API -
355 ||
356 || Pre Conditions:
357 ||
358 || In Arguments:
359 || Contains entire list of parameters that are defined in the actual
360 || API.
361 ||
362 || out nocopy Arguments:
363 ||
364 || In out nocopy Arguments:
365 ||
366 || Post Success:
367 || Executes the API call.
368 ||
369 || Post Failure:
370 || Raises an exception
371 ||
372 || Access Status:
373 || Public.
374 ||
375 ||===========================================================================
376 */
377
378 procedure delete_eit
379 (p_validate in number default 0
380 ,p_login_person_id in number default null
381 ,p_eit_type in varchar2
382 ,p_eit_type_id in number
383 ,p_person_id in number
384 ,p_information_type in varchar2
385 ,p_extra_info_id in number
386 ,p_object_version_number in number
387 -- EndRegistration
391 ,p_action in varchar2
388 ,p_item_type in varchar2
389 ,p_item_key in varchar2
390 ,p_activity_id in number
392 ,p_old_extra_info_id in number default null
393 ,p_old_object_version_number in number default null
394 ,p_save_mode in varchar2 default null
395 ,p_error_message out nocopy long
396 );
397
398
399 --
400 -- ----------------------------------------------------------------------------
401 -- |----------------------------< dump_eit_table >--------------------------------|
402 -- ----------------------------------------------------------------------------
403 /*
404 ||===========================================================================
405 || PROCEDURE: dump_eit_table
406 ||---------------------------------------------------------------------------
407 ||
408 || Description:
409 || Description:
410 || This procedure will call the actual API -
411 ||
412 || Pre Conditions:
413 ||
414 || In Arguments:
415 || Contains entire list of parameters that are defined in the actual
416 || API.
417 ||
418 || out nocopy Arguments:
419 ||
420 || In out nocopy Arguments:
421 ||
422 || Post Success:
423 || Executes the API call.
424 ||
425 || Post Failure:
426 || Raises an exception
427 ||
428 || Access Status:
429 || Public.
430 ||
431 ||===========================================================================
432 */
433
434 PROCEDURE dump_eit_table (p_eit_table in HR_EIT_STRUCTURE_TABLE );
435
436 end hr_process_eit_ss;