1 Package hr_employee_swi As
2 /* $Header: hrempswi.pkh 120.1 2005/09/13 15:02:51 ndorai noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< apply_for_internal_vacancy >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: hr_employee_api.apply_for_internal_vacancy
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE apply_for_internal_vacancy
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_person_id in number
30 ,p_applicant_number in out nocopy varchar2
31 ,p_per_object_version_number in out nocopy number
32 ,p_vacancy_id in number default hr_api.g_number
33 ,p_person_type_id in number default hr_api.g_number
34 ,p_application_id out nocopy number
35 ,p_assignment_id out nocopy number
36 ,p_apl_object_version_number out nocopy number
37 ,p_asg_object_version_number out nocopy number
38 ,p_assignment_sequence out nocopy number
39 ,p_per_effective_start_date out nocopy date
40 ,p_per_effective_end_date out nocopy date
41 ,p_return_status out nocopy varchar2
42 );
43 -- ----------------------------------------------------------------------------
44 -- |----------------------------< create_employee >---------------------------|
45 -- ----------------------------------------------------------------------------
46 -- {Start of comments}
47 --
48 -- Description:
49 -- This procedure is the self-service wrapper procedure to the following
50 -- API: hr_employee_api.create_employee
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 create_employee
67 (p_validate in number default hr_api.g_false_num
68 ,p_hire_date in date
69 ,p_business_group_id in number
70 ,p_last_name in varchar2
71 ,p_sex in varchar2
72 ,p_person_type_id in number default null
73 ,p_per_comments in varchar2 default null
74 ,p_date_employee_data_verified in date default null
75 ,p_date_of_birth in date default null
76 ,p_email_address in varchar2 default null
77 ,p_employee_number in out nocopy varchar2
78 ,p_expense_check_send_to_addres in varchar2 default null
79 ,p_first_name in varchar2 default null
80 ,p_known_as in varchar2 default null
81 ,p_marital_status in varchar2 default null
82 ,p_middle_names in varchar2 default null
83 ,p_nationality in varchar2 default null
84 ,p_national_identifier in varchar2 default null
85 ,p_previous_last_name in varchar2 default null
86 ,p_registered_disabled_flag in varchar2 default null
87 ,p_title in varchar2 default null
88 ,p_vendor_id in number default null
89 ,p_work_telephone in varchar2 default null
90 ,p_attribute_category in varchar2 default null
91 ,p_attribute1 in varchar2 default null
92 ,p_attribute2 in varchar2 default null
93 ,p_attribute3 in varchar2 default null
94 ,p_attribute4 in varchar2 default null
95 ,p_attribute5 in varchar2 default null
96 ,p_attribute6 in varchar2 default null
97 ,p_attribute7 in varchar2 default null
98 ,p_attribute8 in varchar2 default null
99 ,p_attribute9 in varchar2 default null
100 ,p_attribute10 in varchar2 default null
101 ,p_attribute11 in varchar2 default null
102 ,p_attribute12 in varchar2 default null
103 ,p_attribute13 in varchar2 default null
104 ,p_attribute14 in varchar2 default null
105 ,p_attribute15 in varchar2 default null
106 ,p_attribute16 in varchar2 default null
107 ,p_attribute17 in varchar2 default null
108 ,p_attribute18 in varchar2 default null
109 ,p_attribute19 in varchar2 default null
110 ,p_attribute20 in varchar2 default null
111 ,p_attribute21 in varchar2 default null
112 ,p_attribute22 in varchar2 default null
113 ,p_attribute23 in varchar2 default null
114 ,p_attribute24 in varchar2 default null
115 ,p_attribute25 in varchar2 default null
116 ,p_attribute26 in varchar2 default null
117 ,p_attribute27 in varchar2 default null
118 ,p_attribute28 in varchar2 default null
119 ,p_attribute29 in varchar2 default null
120 ,p_attribute30 in varchar2 default null
121 ,p_per_information_category in varchar2 default null
122 ,p_per_information1 in varchar2 default null
123 ,p_per_information2 in varchar2 default null
124 ,p_per_information3 in varchar2 default null
125 ,p_per_information4 in varchar2 default null
126 ,p_per_information5 in varchar2 default null
127 ,p_per_information6 in varchar2 default null
128 ,p_per_information7 in varchar2 default null
129 ,p_per_information8 in varchar2 default null
130 ,p_per_information9 in varchar2 default null
131 ,p_per_information10 in varchar2 default null
132 ,p_per_information11 in varchar2 default null
133 ,p_per_information12 in varchar2 default null
134 ,p_per_information13 in varchar2 default null
135 ,p_per_information14 in varchar2 default null
136 ,p_per_information15 in varchar2 default null
137 ,p_per_information16 in varchar2 default null
138 ,p_per_information17 in varchar2 default null
139 ,p_per_information18 in varchar2 default null
140 ,p_per_information19 in varchar2 default null
141 ,p_per_information20 in varchar2 default null
142 ,p_per_information21 in varchar2 default null
143 ,p_per_information22 in varchar2 default null
144 ,p_per_information23 in varchar2 default null
145 ,p_per_information24 in varchar2 default null
146 ,p_per_information25 in varchar2 default null
147 ,p_per_information26 in varchar2 default null
148 ,p_per_information27 in varchar2 default null
149 ,p_per_information28 in varchar2 default null
150 ,p_per_information29 in varchar2 default null
151 ,p_per_information30 in varchar2 default null
152 ,p_date_of_death in date default null
153 ,p_background_check_status in varchar2 default null
154 ,p_background_date_check in date default null
155 ,p_blood_type in varchar2 default null
156 ,p_correspondence_language in varchar2 default null
157 ,p_fast_path_employee in varchar2 default null
158 ,p_fte_capacity in number default null
159 ,p_honors in varchar2 default null
160 ,p_internal_location in varchar2 default null
161 ,p_last_medical_test_by in varchar2 default null
162 ,p_last_medical_test_date in date default null
163 ,p_mailstop in varchar2 default null
164 ,p_office_number in varchar2 default null
165 ,p_on_military_service in varchar2 default null
166 ,p_pre_name_adjunct in varchar2 default null
167 ,p_projected_start_date in date default null
168 ,p_resume_exists in varchar2 default null
169 ,p_resume_last_updated in date default null
170 ,p_second_passport_exists in varchar2 default null
171 ,p_student_status in varchar2 default null
172 ,p_work_schedule in varchar2 default null
173 ,p_suffix in varchar2 default null
174 ,p_benefit_group_id in number default null
175 ,p_receipt_of_death_cert_date in date default null
176 ,p_coord_ben_med_pln_no in varchar2 default null
177 ,p_coord_ben_no_cvg_flag in varchar2 default null
178 ,p_coord_ben_med_ext_er in varchar2 default null
179 ,p_coord_ben_med_pl_name in varchar2 default null
180 ,p_coord_ben_med_insr_crr_name in varchar2 default null
181 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
182 ,p_coord_ben_med_cvg_strt_dt in date default null
183 ,p_coord_ben_med_cvg_end_dt in date default null
184 ,p_uses_tobacco_flag in varchar2 default null
185 ,p_dpdnt_adoption_date in date default null
186 ,p_dpdnt_vlntry_svce_flag in varchar2 default null
187 ,p_original_date_of_hire in date default null
188 ,p_adjusted_svc_date in date default null
189 ,p_town_of_birth in varchar2 default null
190 ,p_region_of_birth in varchar2 default null
191 ,p_country_of_birth in varchar2 default null
192 ,p_global_person_id in varchar2 default null
193 ,p_party_id in number default null
194 ,p_person_id out nocopy number
195 ,p_assignment_id out nocopy number
196 ,p_per_object_version_number out nocopy number
197 ,p_asg_object_version_number out nocopy number
198 ,p_per_effective_start_date out nocopy date
199 ,p_per_effective_end_date out nocopy date
200 ,p_full_name out nocopy varchar2
201 ,p_per_comment_id out nocopy number
202 ,p_assignment_sequence out nocopy number
203 ,p_assignment_number out nocopy varchar2
204 ,p_return_status out nocopy varchar2
205 );
206 -- ----------------------------------------------------------------------------
207 -- |----------------------------< create_employee >---------------------------|
208 -- ----------------------------------------------------------------------------
209 -- {Start of comments}
210 --
211 -- Description:
212 -- This procedure is the self-service wrapper procedure to the following
213 -- API: hr_employee_api.create_employee
214 --
215 -- Pre-requisites
216 -- All 'IN' parameters to this procedure have been appropriately derived.
217 --
218 -- Post Success:
219 -- p_return_status will return value indicating success.
220 --
221 -- Post Failure:
222 -- p_return_status will return value indication failure.
223 --
224 -- Access Status:
225 -- Internal Development use only.
226 --
227 -- {End of comments}
228 -- ----------------------------------------------------------------------------
229 PROCEDURE create_employee
230 (p_validate in number default hr_api.g_false_num
231 ,p_hire_date in date
232 ,p_business_group_id in number
233 ,p_last_name in varchar2
234 ,p_sex in varchar2
235 ,p_person_type_id in number default null
236 ,p_per_comments in varchar2 default null
237 ,p_date_employee_data_verified in date default null
238 ,p_date_of_birth in date default null
239 ,p_email_address in varchar2 default null
240 ,p_employee_number in out nocopy varchar2
241 ,p_expense_check_send_to_addres in varchar2 default null
242 ,p_first_name in varchar2 default null
243 ,p_known_as in varchar2 default null
244 ,p_marital_status in varchar2 default null
245 ,p_middle_names in varchar2 default null
246 ,p_nationality in varchar2 default null
247 ,p_national_identifier in varchar2 default null
248 ,p_previous_last_name in varchar2 default null
249 ,p_registered_disabled_flag in varchar2 default null
250 ,p_title in varchar2 default null
251 ,p_vendor_id in number default null
252 ,p_work_telephone in varchar2 default null
253 ,p_attribute_category in varchar2 default null
254 ,p_attribute1 in varchar2 default null
255 ,p_attribute2 in varchar2 default null
256 ,p_attribute3 in varchar2 default null
257 ,p_attribute4 in varchar2 default null
258 ,p_attribute5 in varchar2 default null
259 ,p_attribute6 in varchar2 default null
260 ,p_attribute7 in varchar2 default null
261 ,p_attribute8 in varchar2 default null
262 ,p_attribute9 in varchar2 default null
263 ,p_attribute10 in varchar2 default null
264 ,p_attribute11 in varchar2 default null
265 ,p_attribute12 in varchar2 default null
266 ,p_attribute13 in varchar2 default null
267 ,p_attribute14 in varchar2 default null
268 ,p_attribute15 in varchar2 default null
269 ,p_attribute16 in varchar2 default null
270 ,p_attribute17 in varchar2 default null
271 ,p_attribute18 in varchar2 default null
272 ,p_attribute19 in varchar2 default null
273 ,p_attribute20 in varchar2 default null
274 ,p_attribute21 in varchar2 default null
275 ,p_attribute22 in varchar2 default null
276 ,p_attribute23 in varchar2 default null
277 ,p_attribute24 in varchar2 default null
278 ,p_attribute25 in varchar2 default null
279 ,p_attribute26 in varchar2 default null
280 ,p_attribute27 in varchar2 default null
281 ,p_attribute28 in varchar2 default null
282 ,p_attribute29 in varchar2 default null
283 ,p_attribute30 in varchar2 default null
284 ,p_per_information_category in varchar2 default null
285 ,p_per_information1 in varchar2 default null
286 ,p_per_information2 in varchar2 default null
287 ,p_per_information3 in varchar2 default null
288 ,p_per_information4 in varchar2 default null
289 ,p_per_information5 in varchar2 default null
290 ,p_per_information6 in varchar2 default null
291 ,p_per_information7 in varchar2 default null
292 ,p_per_information8 in varchar2 default null
293 ,p_per_information9 in varchar2 default null
294 ,p_per_information10 in varchar2 default null
295 ,p_per_information11 in varchar2 default null
296 ,p_per_information12 in varchar2 default null
297 ,p_per_information13 in varchar2 default null
298 ,p_per_information14 in varchar2 default null
299 ,p_per_information15 in varchar2 default null
300 ,p_per_information16 in varchar2 default null
301 ,p_per_information17 in varchar2 default null
302 ,p_per_information18 in varchar2 default null
303 ,p_per_information19 in varchar2 default null
304 ,p_per_information20 in varchar2 default null
305 ,p_per_information21 in varchar2 default null
306 ,p_per_information22 in varchar2 default null
307 ,p_per_information23 in varchar2 default null
308 ,p_per_information24 in varchar2 default null
309 ,p_per_information25 in varchar2 default null
310 ,p_per_information26 in varchar2 default null
311 ,p_per_information27 in varchar2 default null
312 ,p_per_information28 in varchar2 default null
313 ,p_per_information29 in varchar2 default null
314 ,p_per_information30 in varchar2 default null
315 ,p_date_of_death in date default null
316 ,p_background_check_status in varchar2 default null
317 ,p_background_date_check in date default null
318 ,p_blood_type in varchar2 default null
319 ,p_correspondence_language in varchar2 default null
320 ,p_fast_path_employee in varchar2 default null
321 ,p_fte_capacity in number default null
322 ,p_honors in varchar2 default null
323 ,p_internal_location in varchar2 default null
324 ,p_last_medical_test_by in varchar2 default null
325 ,p_last_medical_test_date in date default null
326 ,p_mailstop in varchar2 default null
327 ,p_office_number in varchar2 default null
328 ,p_on_military_service in varchar2 default null
329 ,p_pre_name_adjunct in varchar2 default null
330 ,p_projected_start_date in date default null
331 ,p_resume_exists in varchar2 default null
332 ,p_resume_last_updated in date default null
333 ,p_second_passport_exists in varchar2 default null
334 ,p_student_status in varchar2 default null
335 ,p_work_schedule in varchar2 default null
336 ,p_suffix in varchar2 default null
337 ,p_benefit_group_id in number default null
338 ,p_receipt_of_death_cert_date in date default null
339 ,p_coord_ben_med_pln_no in varchar2 default null
340 ,p_coord_ben_no_cvg_flag in varchar2 default null
341 ,p_coord_ben_med_ext_er in varchar2 default null
342 ,p_coord_ben_med_pl_name in varchar2 default null
343 ,p_coord_ben_med_insr_crr_name in varchar2 default null
344 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
345 ,p_coord_ben_med_cvg_strt_dt in date default null
346 ,p_coord_ben_med_cvg_end_dt in date default null
347 ,p_uses_tobacco_flag in varchar2 default null
348 ,p_dpdnt_adoption_date in date default null
349 ,p_dpdnt_vlntry_svce_flag in varchar2 default null
350 ,p_original_date_of_hire in date default null
351 ,p_adjusted_svc_date in date default null
352 ,p_town_of_birth in varchar2 default null
353 ,p_region_of_birth in varchar2 default null
354 ,p_country_of_birth in varchar2 default null
355 ,p_global_person_id in varchar2 default null
356 ,p_party_id in number default null
357 ,p_person_id out nocopy number
358 ,p_assignment_id out nocopy number
359 ,p_per_object_version_number out nocopy number
360 ,p_asg_object_version_number out nocopy number
361 ,p_per_effective_start_date out nocopy date
362 ,p_per_effective_end_date out nocopy date
363 ,p_full_name out nocopy varchar2
364 ,p_per_comment_id out nocopy number
365 ,p_assignment_sequence out nocopy number
366 ,p_assignment_number out nocopy varchar2
367 ,p_return_status out nocopy varchar2
368 /* person address parameters */
369 ,p_addr_validate in number default hr_api.g_false_num
370 ,p_addr_effective_date in date
371 ,p_pradd_ovlapval_override in number default null
372 ,p_addr_validate_county in number default null
373 ,p_addr_person_id in number default null
374 ,p_addr_primary_flag in varchar2
375 ,p_addr_style in varchar2
376 ,p_addr_date_from in date
377 ,p_addr_date_to in date default null
378 ,p_addr_address_type in varchar2 default null
379 ,p_addr_comments in long default null
380 ,p_addr_address_line1 in varchar2 default null
381 ,p_addr_address_line2 in varchar2 default null
382 ,p_addr_address_line3 in varchar2 default null
383 ,p_addr_town_or_city in varchar2 default null
384 ,p_addr_region_1 in varchar2 default null
385 ,p_addr_region_2 in varchar2 default null
386 ,p_addr_region_3 in varchar2 default null
387 ,p_addr_postal_code in varchar2 default null
388 ,p_addr_country in varchar2 default null
389 ,p_addr_telephone_number_1 in varchar2 default null
390 ,p_addr_telephone_number_2 in varchar2 default null
391 ,p_addr_telephone_number_3 in varchar2 default null
392 ,p_addr_attribute_category in varchar2 default null
393 ,p_addr_attribute1 in varchar2 default null
394 ,p_addr_attribute2 in varchar2 default null
395 ,p_addr_attribute3 in varchar2 default null
396 ,p_addr_attribute4 in varchar2 default null
397 ,p_addr_attribute5 in varchar2 default null
398 ,p_addr_attribute6 in varchar2 default null
399 ,p_addr_attribute7 in varchar2 default null
400 ,p_addr_attribute8 in varchar2 default null
401 ,p_addr_attribute9 in varchar2 default null
402 ,p_addr_attribute10 in varchar2 default null
403 ,p_addr_attribute11 in varchar2 default null
404 ,p_addr_attribute12 in varchar2 default null
405 ,p_addr_attribute13 in varchar2 default null
406 ,p_addr_attribute14 in varchar2 default null
407 ,p_addr_attribute15 in varchar2 default null
408 ,p_addr_attribute16 in varchar2 default null
409 ,p_addr_attribute17 in varchar2 default null
410 ,p_addr_attribute18 in varchar2 default null
411 ,p_addr_attribute19 in varchar2 default null
412 ,p_addr_attribute20 in varchar2 default null
413 ,p_addr_add_information13 in varchar2 default null
414 ,p_addr_add_information14 in varchar2 default null
415 ,p_addr_add_information15 in varchar2 default null
416 ,p_addr_add_information16 in varchar2 default null
417 ,p_addr_add_information17 in varchar2 default null
418 ,p_addr_add_information18 in varchar2 default null
419 ,p_addr_add_information19 in varchar2 default null
420 ,p_addr_add_information20 in varchar2 default null
421 ,p_addr_party_id in number default null
422 ,p_addr_address_id in number
423 ,p_addr_object_version_number out nocopy number
424 ,p_addr_return_status out nocopy varchar2
425 );
426 -- ----------------------------------------------------------------------------
427 -- |-----------------------------< hire_into_job >----------------------------|
428 -- ----------------------------------------------------------------------------
429 -- {Start of comments}
430 --
431 -- Description:
432 -- This procedure is the self-service wrapper procedure to the following
433 -- API: hr_employee_api.hire_into_job
434 --
435 -- Pre-requisites
436 -- All 'IN' parameters to this procedure have been appropriately derived.
437 --
438 -- Post Success:
439 -- p_return_status will return value indicating success.
440 --
441 -- Post Failure:
442 -- p_return_status will return value indication failure.
443 --
444 -- Access Status:
445 -- Internal Development use only.
446 --
447 -- {End of comments}
448 -- ----------------------------------------------------------------------------
449 PROCEDURE hire_into_job
450 (p_validate in number default hr_api.g_false_num
451 ,p_effective_date in date
452 ,p_person_id in number
453 ,p_object_version_number in out nocopy number
454 ,p_employee_number in out nocopy varchar2
455 ,p_datetrack_update_mode in varchar2 default hr_api.g_varchar2
456 ,p_person_type_id in number default hr_api.g_number
457 ,p_national_identifier in varchar2 default hr_api.g_varchar2
458 ,p_effective_start_date out nocopy date
459 ,p_effective_end_date out nocopy date
460 ,p_return_status out nocopy varchar2
461 );
462 -- ----------------------------------------------------------------------------
463 -- |--------------------------< re_hire_ex_employee >-------------------------|
464 -- ----------------------------------------------------------------------------
465 -- {Start of comments}
466 --
467 -- Description:
468 -- This procedure is the self-service wrapper procedure to the following
469 -- API: hr_employee_api.re_hire_ex_employee
470 --
471 -- Pre-requisites
472 -- All 'IN' parameters to this procedure have been appropriately derived.
473 --
474 -- Post Success:
475 -- p_return_status will return value indicating success.
476 --
477 -- Post Failure:
478 -- p_return_status will return value indication failure.
479 --
480 -- Access Status:
481 -- Internal Development use only.
482 --
483 -- {End of comments}
484 -- ----------------------------------------------------------------------------
485 PROCEDURE re_hire_ex_employee
486 (p_validate in number default hr_api.g_false_num
487 ,p_hire_date in date
488 ,p_person_id in number
489 ,p_per_object_version_number in out nocopy number
490 ,p_person_type_id in number default hr_api.g_number
491 ,p_rehire_reason in varchar2
492 ,p_assignment_id out nocopy number
493 ,p_asg_object_version_number out nocopy number
494 ,p_per_effective_start_date out nocopy date
495 ,p_per_effective_end_date out nocopy date
496 ,p_assignment_sequence out nocopy number
497 ,p_assignment_number out nocopy varchar2
498 ,p_return_status out nocopy varchar2
499 );
500 -- ----------------------------------------------------------------------------
501 -- |------------< convert_to_manual_gen_method > -----------------------------|
502 -- ----------------------------------------------------------------------------
503 -- {Start of comments}
504 --
505 -- Description:
506 -- This procedure is to update the employee number, applicant number,
507 -- contigent worker number generation flag to Manual 'M' to support
508 -- iSetup Employee Migration.
509 --
510 -- Pre-requisites
511 -- All 'IN' parameters to this procedure have been appropriately derived.
512 --
513 -- Post Success:
514 --
515 -- Post Failure:
516 --
517 -- Access Status:
518 -- Internal Development use only.
519 --
520 -- {End of comments}
521 -- ----------------------------------------------------------------------------
522 PROCEDURE convert_to_manual_gen_method
523 (errbuf out nocopy varchar2
524 ,retcode out nocopy number
525 ,p_business_group_id in number
526 );
527 -- ----------------------------------------------------------------------------
528 end hr_employee_swi;