1 Package hr_cwk_termination_swi As
2 /* $Header: hrcwtswi.pkh 120.0 2005/05/30 23:33 appldev noship $ */
3 gv_TERMINATION_ACTIVITY_NAME CONSTANT
4 wf_item_activity_statuses_v.activity_name%TYPE := 'HR_CWK_TERMINATION_SWI';
5
6 -- ----------------------------------------------------------------------------
7 -- |---------------------< actual_termination_placement >---------------------|
8 -- ----------------------------------------------------------------------------
9 -- {Start of comments}
10 --
11 -- Description:
12 -- This procedure is the self-service wrapper procedure to the following
13 -- API: hr_contingent_worker_api.actual_termination_placement
14 --
15 -- Pre-requisites
16 -- All 'IN' parameters to this procedure have been appropriately derived.
17 --
18 -- Post Success:
19 -- p_return_status will return value indicating success.
20 --
21 -- Post Failure:
22 -- p_return_status will return value indication failure.
23 --
24 -- Access Status:
25 -- Internal Development use only.
26 --
27 -- {End of comments}
28 -- ----------------------------------------------------------------------------
29 PROCEDURE actual_termination_placement
30 (p_validate in boolean
31 ,p_effective_date in date
32 ,p_person_id in number
33 ,p_date_start in date
34 ,p_object_version_number in out nocopy number
35 ,p_actual_termination_date in date
36 ,p_last_standard_process_date in out nocopy date
37 ,p_person_type_id in number default hr_api.g_number
38 ,p_assignment_status_type_id in number default hr_api.g_number
39 ,p_termination_reason in varchar2 default hr_api.g_varchar2
40 ,p_entries_changed_warning out nocopy varchar2
41 ,p_return_status out nocopy varchar2
42 );
43 -- ----------------------------------------------------------------------------
44 -- |------------------------< final_process_placement >-----------------------|
45 -- ----------------------------------------------------------------------------
46 -- {Start of comments}
47 --
48 -- Description:
49 -- This procedure is the self-service wrapper procedure to the following
50 -- API: hr_contingent_worker_api.final_process_placement
51 --
52 -- Pre-requisites
53 -- All 'IN' parameters to this procedure have been appropriately derived.
54 --
55 -- Post Success:
56 -- p_return_status will return value indicating success.
57 --
58 -- Post Failure:
59 -- p_return_status will return value indication failure.
60 --
61 -- Access Status:
62 -- Internal Development use only.
63 --
64 -- {End of comments}
65 -- ----------------------------------------------------------------------------
66 PROCEDURE final_process_placement
67 (p_validate in boolean
68 ,p_person_id in number
69 ,p_date_start in date
70 ,p_object_version_number in out nocopy number
71 ,p_final_process_date in out nocopy date
72 ,p_entries_changed_warning out nocopy varchar2
73 ,p_return_status out nocopy varchar2
74 );
75 -- ----------------------------------------------------------------------------
76 -- |------------------------< get_length_of_placement >-----------------------|
77 -- ----------------------------------------------------------------------------
78 -- {Start of comments}
79 --
80 -- Description:
81 -- This procedure is the self-service wrapper procedure to the following
82 -- API: hr_contingent_worker_api.get_length_of_placement
83 --
84 -- Pre-requisites
85 -- All 'IN' parameters to this procedure have been appropriately derived.
86 --
87 -- Post Success:
88 -- p_return_status will return value indicating success.
89 --
90 -- Post Failure:
91 -- p_return_status will return value indication failure.
92 --
93 -- Access Status:
94 -- Internal Development use only.
95 --
96 -- {End of comments}
97 -- ----------------------------------------------------------------------------
98 PROCEDURE get_length_of_placement
99 (p_effective_date in date
100 ,p_business_group_id in number
101 ,p_person_id in number
102 ,p_date_start in date
103 ,p_total_years out nocopy number
104 ,p_total_months out nocopy number
105 ,p_return_status out nocopy varchar2
106 );
107 -- ----------------------------------------------------------------------------
108 -- |----------------------< reverse_terminate_placement >---------------------|
109 -- ----------------------------------------------------------------------------
110 -- {Start of comments}
111 --
112 -- Description:
113 -- This procedure is the self-service wrapper procedure to the following
114 -- API: hr_contingent_worker_api.reverse_terminate_placement
115 --
116 -- Pre-requisites
117 -- All 'IN' parameters to this procedure have been appropriately derived.
118 --
119 -- Post Success:
120 -- p_return_status will return value indicating success.
121 --
122 -- Post Failure:
123 -- p_return_status will return value indication failure.
124 --
125 -- Access Status:
126 -- Internal Development use only.
127 --
128 -- {End of comments}
129 -- ----------------------------------------------------------------------------
130 PROCEDURE reverse_terminate_placement
131 (p_validate in boolean
132 ,p_person_id in number
133 ,p_actual_termination_date in date
134 ,p_clear_details in varchar2 default hr_api.g_varchar2
135 ,p_return_status out nocopy varchar2
136 );
137 -- ----------------------------------------------------------------------------
138 -- |--------------------------< terminate_placement >-------------------------|
139 -- ----------------------------------------------------------------------------
140 -- {Start of comments}
141 --
142 -- Description:
143 -- This procedure is the self-service wrapper procedure to the following
144 -- API: hr_contingent_worker_api.terminate_placement
145 --
146 -- Pre-requisites
147 -- All 'IN' parameters to this procedure have been appropriately derived.
148 --
149 -- Post Success:
150 -- p_return_status will return value indicating success.
151 --
152 -- Post Failure:
153 -- p_return_status will return value indication failure.
154 --
155 -- Access Status:
156 -- Internal Development use only.
157 --
158 -- {End of comments}
159 -- ----------------------------------------------------------------------------
160 PROCEDURE terminate_placement
161 (p_validate in boolean
162 ,p_effective_date in date
163 ,p_person_id in number
164 ,p_date_start in date
165 ,p_object_version_number in out nocopy number
166 ,p_person_type_id in number default hr_api.g_number
167 ,p_assignment_status_type_id in number default hr_api.g_number
168 ,p_actual_termination_date in date default hr_api.g_date
169 ,p_final_process_date in out nocopy date
170 ,p_last_standard_process_date in out nocopy date
171 ,p_termination_reason in varchar2 default hr_api.g_varchar2
172 ,p_projected_termination_date in date default hr_api.g_date
173 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
174 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
175 ,p_attribute_category in varchar2 default hr_api.g_varchar2
176 ,p_attribute1 in varchar2 default hr_api.g_varchar2
177 ,p_attribute2 in varchar2 default hr_api.g_varchar2
178 ,p_attribute3 in varchar2 default hr_api.g_varchar2
179 ,p_attribute4 in varchar2 default hr_api.g_varchar2
180 ,p_attribute5 in varchar2 default hr_api.g_varchar2
181 ,p_attribute6 in varchar2 default hr_api.g_varchar2
182 ,p_attribute7 in varchar2 default hr_api.g_varchar2
183 ,p_attribute8 in varchar2 default hr_api.g_varchar2
184 ,p_attribute9 in varchar2 default hr_api.g_varchar2
185 ,p_attribute10 in varchar2 default hr_api.g_varchar2
186 ,p_attribute11 in varchar2 default hr_api.g_varchar2
187 ,p_attribute12 in varchar2 default hr_api.g_varchar2
188 ,p_attribute13 in varchar2 default hr_api.g_varchar2
189 ,p_attribute14 in varchar2 default hr_api.g_varchar2
190 ,p_attribute15 in varchar2 default hr_api.g_varchar2
191 ,p_attribute16 in varchar2 default hr_api.g_varchar2
192 ,p_attribute17 in varchar2 default hr_api.g_varchar2
193 ,p_attribute18 in varchar2 default hr_api.g_varchar2
194 ,p_attribute19 in varchar2 default hr_api.g_varchar2
195 ,p_attribute20 in varchar2 default hr_api.g_varchar2
196 ,p_attribute21 in varchar2 default hr_api.g_varchar2
197 ,p_attribute22 in varchar2 default hr_api.g_varchar2
198 ,p_attribute23 in varchar2 default hr_api.g_varchar2
199 ,p_attribute24 in varchar2 default hr_api.g_varchar2
200 ,p_attribute25 in varchar2 default hr_api.g_varchar2
201 ,p_attribute26 in varchar2 default hr_api.g_varchar2
202 ,p_attribute27 in varchar2 default hr_api.g_varchar2
203 ,p_attribute28 in varchar2 default hr_api.g_varchar2
204 ,p_attribute29 in varchar2 default hr_api.g_varchar2
205 ,p_attribute30 in varchar2 default hr_api.g_varchar2
206 ,p_information_category in varchar2 default hr_api.g_varchar2
207 ,p_information1 in varchar2 default hr_api.g_varchar2
208 ,p_information2 in varchar2 default hr_api.g_varchar2
209 ,p_information3 in varchar2 default hr_api.g_varchar2
210 ,p_information4 in varchar2 default hr_api.g_varchar2
211 ,p_information5 in varchar2 default hr_api.g_varchar2
212 ,p_information6 in varchar2 default hr_api.g_varchar2
213 ,p_information7 in varchar2 default hr_api.g_varchar2
214 ,p_information8 in varchar2 default hr_api.g_varchar2
215 ,p_information9 in varchar2 default hr_api.g_varchar2
216 ,p_information10 in varchar2 default hr_api.g_varchar2
217 ,p_information11 in varchar2 default hr_api.g_varchar2
218 ,p_information12 in varchar2 default hr_api.g_varchar2
219 ,p_information13 in varchar2 default hr_api.g_varchar2
220 ,p_information14 in varchar2 default hr_api.g_varchar2
221 ,p_information15 in varchar2 default hr_api.g_varchar2
222 ,p_information16 in varchar2 default hr_api.g_varchar2
223 ,p_information17 in varchar2 default hr_api.g_varchar2
224 ,p_information18 in varchar2 default hr_api.g_varchar2
225 ,p_information19 in varchar2 default hr_api.g_varchar2
226 ,p_information20 in varchar2 default hr_api.g_varchar2
227 ,p_information21 in varchar2 default hr_api.g_varchar2
228 ,p_information22 in varchar2 default hr_api.g_varchar2
229 ,p_information23 in varchar2 default hr_api.g_varchar2
230 ,p_information24 in varchar2 default hr_api.g_varchar2
231 ,p_information25 in varchar2 default hr_api.g_varchar2
232 ,p_information26 in varchar2 default hr_api.g_varchar2
233 ,p_information27 in varchar2 default hr_api.g_varchar2
234 ,p_information28 in varchar2 default hr_api.g_varchar2
235 ,p_information29 in varchar2 default hr_api.g_varchar2
236 ,p_information30 in varchar2 default hr_api.g_varchar2
237 ,p_entries_changed_warning out nocopy varchar2
238 ,p_return_status out nocopy varchar2
239 );
240
241 PROCEDURE process_save
242 ( p_item_type in wf_items.item_type%TYPE
243 ,p_item_key in wf_items.item_key%TYPE
244 ,p_actid in varchar2
245 ,p_transaction_mode in varchar2 DEFAULT '#'
246 ,p_effective_date in date
247 ,p_person_id in number
248 ,p_date_start in date
249 ,p_object_version_number in number
250 ,p_person_type_id in number default hr_api.g_number
251 ,p_actual_termination_date in date default hr_api.g_date
252 ,p_final_process_date in date
253 ,p_last_standard_process_date in date
254 ,p_termination_reason in varchar2 default hr_api.g_varchar2
255 ,p_projected_termination_date in date default hr_api.g_date
256 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
257 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
258 ,p_attribute_category in varchar2 default hr_api.g_varchar2
259 ,p_attribute1 in varchar2 default hr_api.g_varchar2
260 ,p_attribute2 in varchar2 default hr_api.g_varchar2
261 ,p_attribute3 in varchar2 default hr_api.g_varchar2
262 ,p_attribute4 in varchar2 default hr_api.g_varchar2
263 ,p_attribute5 in varchar2 default hr_api.g_varchar2
264 ,p_attribute6 in varchar2 default hr_api.g_varchar2
265 ,p_attribute7 in varchar2 default hr_api.g_varchar2
266 ,p_attribute8 in varchar2 default hr_api.g_varchar2
267 ,p_attribute9 in varchar2 default hr_api.g_varchar2
268 ,p_attribute10 in varchar2 default hr_api.g_varchar2
269 ,p_attribute11 in varchar2 default hr_api.g_varchar2
270 ,p_attribute12 in varchar2 default hr_api.g_varchar2
271 ,p_attribute13 in varchar2 default hr_api.g_varchar2
272 ,p_attribute14 in varchar2 default hr_api.g_varchar2
273 ,p_attribute15 in varchar2 default hr_api.g_varchar2
274 ,p_attribute16 in varchar2 default hr_api.g_varchar2
275 ,p_attribute17 in varchar2 default hr_api.g_varchar2
276 ,p_attribute18 in varchar2 default hr_api.g_varchar2
277 ,p_attribute19 in varchar2 default hr_api.g_varchar2
278 ,p_attribute20 in varchar2 default hr_api.g_varchar2
279 ,p_attribute21 in varchar2 default hr_api.g_varchar2
280 ,p_attribute22 in varchar2 default hr_api.g_varchar2
281 ,p_attribute23 in varchar2 default hr_api.g_varchar2
282 ,p_attribute24 in varchar2 default hr_api.g_varchar2
283 ,p_attribute25 in varchar2 default hr_api.g_varchar2
284 ,p_attribute26 in varchar2 default hr_api.g_varchar2
285 ,p_attribute27 in varchar2 default hr_api.g_varchar2
286 ,p_attribute28 in varchar2 default hr_api.g_varchar2
287 ,p_attribute29 in varchar2 default hr_api.g_varchar2
288 ,p_attribute30 in varchar2 default hr_api.g_varchar2
289 ,p_information_category in varchar2 default hr_api.g_varchar2
290 ,p_information1 in varchar2 default hr_api.g_varchar2
291 ,p_information2 in varchar2 default hr_api.g_varchar2
292 ,p_information3 in varchar2 default hr_api.g_varchar2
293 ,p_information4 in varchar2 default hr_api.g_varchar2
294 ,p_information5 in varchar2 default hr_api.g_varchar2
295 ,p_information6 in varchar2 default hr_api.g_varchar2
296 ,p_information7 in varchar2 default hr_api.g_varchar2
297 ,p_information8 in varchar2 default hr_api.g_varchar2
298 ,p_information9 in varchar2 default hr_api.g_varchar2
299 ,p_information10 in varchar2 default hr_api.g_varchar2
300 ,p_information11 in varchar2 default hr_api.g_varchar2
301 ,p_information12 in varchar2 default hr_api.g_varchar2
302 ,p_information13 in varchar2 default hr_api.g_varchar2
306 ,p_information17 in varchar2 default hr_api.g_varchar2
303 ,p_information14 in varchar2 default hr_api.g_varchar2
304 ,p_information15 in varchar2 default hr_api.g_varchar2
305 ,p_information16 in varchar2 default hr_api.g_varchar2
307 ,p_information18 in varchar2 default hr_api.g_varchar2
308 ,p_information19 in varchar2 default hr_api.g_varchar2
309 ,p_information20 in varchar2 default hr_api.g_varchar2
310 ,p_information21 in varchar2 default hr_api.g_varchar2
311 ,p_information22 in varchar2 default hr_api.g_varchar2
312 ,p_information23 in varchar2 default hr_api.g_varchar2
313 ,p_information24 in varchar2 default hr_api.g_varchar2
314 ,p_information25 in varchar2 default hr_api.g_varchar2
315 ,p_information26 in varchar2 default hr_api.g_varchar2
316 ,p_information27 in varchar2 default hr_api.g_varchar2
317 ,p_information28 in varchar2 default hr_api.g_varchar2
318 ,p_information29 in varchar2 default hr_api.g_varchar2
319 ,p_information30 in varchar2 default hr_api.g_varchar2
320 ,p_review_proc_call in varchar2 default hr_api.g_varchar2
321 ,p_effective_date_option in varchar2 default hr_api.g_varchar2
322 ,p_login_person_id in number
323 ,p_entries_changed_warning out nocopy varchar2
324 ,p_return_status out nocopy varchar2
325 ,p_return_on_warning in varchar2 default null --Bug fix 1370960
326 );
327
328 PROCEDURE getTransactionDetails
329 ( p_transaction_step_id in varchar2
330 ,p_person_id out nocopy number
331 ,p_date_start out nocopy date
332 ,p_object_version_number out nocopy number
333 ,p_person_type_id out nocopy number
334 ,p_actual_termination_date out nocopy date
335 ,p_final_process_date out nocopy date
336 ,p_last_standard_process_date out nocopy date
337 ,p_termination_reason out nocopy varchar2
338 ,p_rehire_recommendation out nocopy varchar2
339 ,p_rehire_reason out nocopy varchar2
340 ,p_projected_termination_date out nocopy date
341 ,p_attribute_category out nocopy varchar2
342 ,p_attribute1 out nocopy varchar2
343 ,p_attribute2 out nocopy varchar2
344 ,p_attribute3 out nocopy varchar2
345 ,p_attribute4 out nocopy varchar2
346 ,p_attribute5 out nocopy varchar2
347 ,p_attribute6 out nocopy varchar2
348 ,p_attribute7 out nocopy varchar2
349 ,p_attribute8 out nocopy varchar2
350 ,p_attribute9 out nocopy varchar2
351 ,p_attribute10 out nocopy varchar2
352 ,p_attribute11 out nocopy varchar2
353 ,p_attribute12 out nocopy varchar2
354 ,p_attribute13 out nocopy varchar2
355 ,p_attribute14 out nocopy varchar2
356 ,p_attribute15 out nocopy varchar2
357 ,p_attribute16 out nocopy varchar2
358 ,p_attribute17 out nocopy varchar2
359 ,p_attribute18 out nocopy varchar2
360 ,p_attribute19 out nocopy varchar2
361 ,p_attribute20 out nocopy varchar2
362 ,p_attribute21 out nocopy varchar2
363 ,p_attribute22 out nocopy varchar2
364 ,p_attribute23 out nocopy varchar2
365 ,p_attribute24 out nocopy varchar2
366 ,p_attribute25 out nocopy varchar2
367 ,p_attribute26 out nocopy varchar2
368 ,p_attribute27 out nocopy varchar2
369 ,p_attribute28 out nocopy varchar2
370 ,p_attribute29 out nocopy varchar2
371 ,p_attribute30 out nocopy varchar2
372 ,p_information_category out NOCOPY varchar2
373 ,p_information1 out nocopy varchar2
374 ,p_information2 out nocopy varchar2
375 ,p_information3 out nocopy varchar2
376 ,p_information4 out nocopy varchar2
377 ,p_information5 out nocopy varchar2
378 ,p_information6 out nocopy varchar2
379 ,p_information7 out nocopy varchar2
380 ,p_information8 out nocopy varchar2
381 ,p_information9 out nocopy varchar2
382 ,p_information10 out nocopy varchar2
383 ,p_information11 out nocopy varchar2
384 ,p_information12 out nocopy varchar2
385 ,p_information13 out nocopy varchar2
386 ,p_information14 out nocopy varchar2
387 ,p_information15 out nocopy varchar2
388 ,p_information16 out nocopy varchar2
389 ,p_information17 out nocopy varchar2
390 ,p_information18 out nocopy varchar2
391 ,p_information19 out nocopy varchar2
392 ,p_information20 out nocopy varchar2
393 ,p_information21 out nocopy varchar2
394 ,p_information22 out nocopy varchar2
395 ,p_information23 out nocopy varchar2
396 ,p_information24 out nocopy varchar2
397 ,p_information25 out nocopy varchar2
398 ,p_information26 out nocopy varchar2
399 ,p_information27 out nocopy varchar2
400 ,p_information28 out nocopy varchar2
401 ,p_information29 out nocopy varchar2
402 ,p_information30 out nocopy varchar2
403 );
404
405 procedure process_api
406 ( p_validate in boolean default false
407 ,p_transaction_step_id in number default null
408 ,p_effective_date in varchar2 default NULL
409 );
410
411 end hr_cwk_termination_swi;