1 Package hr_employee_api AUTHID CURRENT_USER as
2 /* $Header: peempapi.pkh 120.5 2009/03/09 13:26:04 swamukhe ship $ */
3 /*#
4 * This package contains employee APIs.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Employee
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------------< create_employee >--------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a new employee.
17 *
18 * This API creates a default primary assignment and a period of service for
19 * the employee. Secure user functionality is included in this version of the
20 * API. The employee is visible to secure users in the business group. <P>HR
21 * Foundation users can use the following parameters only: p_validate,
22 * p_hire_date, p_business_group_id, p_last_name, p_previous_last_name,
26 * p_national_identifier, p_title, p_attribute_category, and p_attribute1-30.
23 * p_mailstop, p_office_number, p_internal_location, p_correspondence_language,
24 * p_known_as, p_sex, p_date_of_birth, p_email_address, p_employee_number,
25 * p_expense_check_send_to_addres, p_first_name, p_middle_names,
27 *
28 * <p><b>Licensing</b><br>
29 * This API is licensed for use with Human Resources and HR Foundation.
30 *
31 * <p><b>Prerequisites</b><br>
32 * The business group must exist on the effective date. If person_type_id is
33 * supplied, it must have a corresponding system person type of EMP and must be
34 * active in the same business group as the employee being created.
35 *
36 * <p><b>Post Success</b><br>
37 * The person, period of service, and default employee assignment are created.
38 *
39 * <p><b>Post Failure</b><br>
40 * The employee is not created and an error is raised.
41 * @param p_validate If true, then validation alone will be performed and the
42 * database will remain unchanged. If false and all validation checks pass,
43 * then the database will be modified.
44 * @param p_hire_date Hire Date.
45 * @param p_business_group_id Business group of the person.
46 * @param p_last_name Last name.
47 * @param p_sex Legal gender. Valid values are defined by the SEX lookup type.
48 * @param p_person_type_id Type of employee being created.
49 * @param p_per_comments Person comment text.
50 * @param p_date_employee_data_verified Date on which the employee data was
51 * last verified.
52 * @param p_date_of_birth Date of birth.
53 * @param p_email_address Email address.
54 * @param p_employee_number The business group's employee number generation
55 * method determines when the API derives and passes out an employee number or
56 * when the calling program should pass in a value. When the API call completes
57 * if p_validate is false then will be set to the employee number. If
58 * p_validate is true then will be set to the passed value.
59 * @param p_expense_check_send_to_addres Mailing address.
60 * @param p_first_name First name.
61 * @param p_known_as Preferred name.
62 * @param p_marital_status Marital status. Valid values are defined by the
63 * MAR_STATUS lookup type.
64 * @param p_middle_names Middle names.
65 * @param p_nationality Nationality. Valid values are defined by the
66 * NATIONALITY lookup type.
67 * @param p_national_identifier Number by which a person is identified in a
68 * given legislation.
69 * @param p_previous_last_name Previous last name.
70 * @param p_registered_disabled_flag Flag indicating whether the person is
71 * classified as disabled.
72 * @param p_title Title. Valid values are defined by the TITLE lookup type.
73 * @param p_vendor_id Obsolete parameter, do not use.
74 * @param p_work_telephone Obsolete parameter, do not use.
75 * @param p_attribute_category This context value determines which flexfield
76 * structure to use with the descriptive flexfield segments.
77 * @param p_attribute1 Descriptive flexfield segment.
78 * @param p_attribute2 Descriptive flexfield segment.
79 * @param p_attribute3 Descriptive flexfield segment.
80 * @param p_attribute4 Descriptive flexfield segment.
81 * @param p_attribute5 Descriptive flexfield segment.
82 * @param p_attribute6 Descriptive flexfield segment.
83 * @param p_attribute7 Descriptive flexfield segment.
84 * @param p_attribute8 Descriptive flexfield segment.
85 * @param p_attribute9 Descriptive flexfield segment.
86 * @param p_attribute10 Descriptive flexfield segment.
87 * @param p_attribute11 Descriptive flexfield segment.
88 * @param p_attribute12 Descriptive flexfield segment.
89 * @param p_attribute13 Descriptive flexfield segment.
90 * @param p_attribute14 Descriptive flexfield segment.
91 * @param p_attribute15 Descriptive flexfield segment.
92 * @param p_attribute16 Descriptive flexfield segment.
93 * @param p_attribute17 Descriptive flexfield segment.
94 * @param p_attribute18 Descriptive flexfield segment.
95 * @param p_attribute19 Descriptive flexfield segment.
96 * @param p_attribute20 Descriptive flexfield segment.
97 * @param p_attribute21 Descriptive flexfield segment.
98 * @param p_attribute22 Descriptive flexfield segment.
99 * @param p_attribute23 Descriptive flexfield segment.
100 * @param p_attribute24 Descriptive flexfield segment.
101 * @param p_attribute25 Descriptive flexfield segment.
102 * @param p_attribute26 Descriptive flexfield segment.
103 * @param p_attribute27 Descriptive flexfield segment.
104 * @param p_attribute28 Descriptive flexfield segment.
105 * @param p_attribute29 Descriptive flexfield segment.
106 * @param p_attribute30 Descriptive flexfield segment.
107 * @param p_per_information_category Obsolete parameter, do not use.
108 * @param p_per_information1 Developer descriptive flexfield segment.
109 * @param p_per_information2 Developer descriptive flexfield segment.
110 * @param p_per_information3 Developer descriptive flexfield segment.
111 * @param p_per_information4 Developer descriptive flexfield segment.
112 * @param p_per_information5 Developer descriptive flexfield segment.
113 * @param p_per_information6 Developer descriptive flexfield segment.
114 * @param p_per_information7 Developer descriptive flexfield segment.
115 * @param p_per_information8 Developer descriptive flexfield segment.
116 * @param p_per_information9 Developer descriptive flexfield segment.
117 * @param p_per_information10 Developer descriptive flexfield segment.
118 * @param p_per_information11 Developer descriptive flexfield segment.
119 * @param p_per_information12 Developer descriptive flexfield segment.
120 * @param p_per_information13 Developer descriptive flexfield segment.
121 * @param p_per_information14 Developer descriptive flexfield segment.
122 * @param p_per_information15 Developer descriptive flexfield segment.
128 * @param p_per_information21 Developer descriptive flexfield segment.
123 * @param p_per_information16 Developer descriptive flexfield segment.
124 * @param p_per_information17 Developer descriptive flexfield segment.
125 * @param p_per_information18 Developer descriptive flexfield segment.
126 * @param p_per_information19 Developer descriptive flexfield segment.
127 * @param p_per_information20 Developer descriptive flexfield segment.
129 * @param p_per_information22 Developer descriptive flexfield segment.
130 * @param p_per_information23 Developer descriptive flexfield segment.
131 * @param p_per_information24 Developer descriptive flexfield segment.
132 * @param p_per_information25 Developer descriptive flexfield segment.
133 * @param p_per_information26 Developer descriptive flexfield segment.
134 * @param p_per_information27 Developer descriptive flexfield segment.
135 * @param p_per_information28 Developer descriptive flexfield segment.
136 * @param p_per_information29 Developer descriptive flexfield segment.
137 * @param p_per_information30 Developer descriptive flexfield segment.
138 * @param p_date_of_death Date of death.
139 * @param p_background_check_status Flag indicating whether the person's
140 * background has been checked.
141 * @param p_background_date_check Date on which the background check was
142 * performed.
143 * @param p_blood_type Blood type.
144 * @param p_correspondence_language Preferred language for correspondence.
145 * @param p_fast_path_employee Obsolete parameter, do not use.
146 * @param p_fte_capacity Obsolete parameter, do not use.
147 * @param p_honors Honors awarded.
148 * @param p_internal_location Internal location of office.
149 * @param p_last_medical_test_by Name of physician who performed the last
150 * medical test.
151 * @param p_last_medical_test_date Date of last medical test.
152 * @param p_mailstop Internal mail location.
153 * @param p_office_number Office number.
154 * @param p_on_military_service Flag indicating whether the person is on
155 * military service.
156 * @param p_pre_name_adjunct First part of the last name.
157 * @param p_rehire_recommendation Obsolete parameter, do not use.
158 * @param p_projected_start_date Obsolete parameter, do not use.
159 * @param p_resume_exists Flag indicating whether the person's resume is on
160 * file.
161 * @param p_resume_last_updated Date on which the resume was last updated.
162 * @param p_second_passport_exists Flag indicating whether a person has
163 * multiple passports.
164 * @param p_student_status If this employee is a student, this field is used to
165 * capture their status. Valid values are defined by the STUDENT_STATUS lookup
166 * type.
167 * @param p_work_schedule Days on which this person will work.
171 * @param p_coord_ben_med_pln_no Secondary medical plan name. Column used for
168 * @param p_suffix Suffix after the person's last name e.g. Sr., Jr., III.
169 * @param p_benefit_group_id Benefit group to which this person will belong.
170 * @param p_receipt_of_death_cert_date Date death certificate was received.
172 * external processing.
173 * @param p_coord_ben_no_cvg_flag No secondary medical plan coverage. Column
174 * used for external processing.
175 * @param p_coord_ben_med_ext_er Secondary external medical coverage. Column
176 * used for external processing.
177 * @param p_coord_ben_med_pl_name Secondary medical coverage name. Column used
178 * for external processing.
179 * @param p_coord_ben_med_insr_crr_name Secondary medical coverage insurance
180 * carrier name. Column used for external processing.
181 * @param p_coord_ben_med_insr_crr_ident Secondary medical coverage insurance
182 * carrier identifier. Column used for external processing.
183 * @param p_coord_ben_med_cvg_strt_dt Secondary medical coverage effective
184 * start date. Column used for external processing.
185 * @param p_coord_ben_med_cvg_end_dt Secondary medical coverage effective end
186 * date. Column used for external processing.
187 * @param p_uses_tobacco_flag Flag indicating whether the person uses tobacco.
188 * @param p_dpdnt_adoption_date Date on which the dependent was adopted.
189 * @param p_dpdnt_vlntry_svce_flag Flag indicating whether the dependent is on
190 * voluntary service.
191 * @param p_original_date_of_hire Original date of hire.
192 * @param p_adjusted_svc_date Adjusted service date.
193 * @param p_town_of_birth Town or city of birth.
194 * @param p_region_of_birth Geographical region of birth.
195 * @param p_country_of_birth Country of birth.
196 * @param p_global_person_id Obsolete parameter, do not use.
197 * @param p_party_id TCA party for whom you create the person record.
198 * @param p_person_id If p_validate is false, then this uniquely identifies the
199 * person created. If p_validate is true, then set to null.
200 * @param p_assignment_id If p_validate is false, then this uniquely identifies
201 * the created assignment. If p_validate is true, then set to null.
202 * @param p_per_object_version_number If p_validate is false, then set to the
203 * version number of the created person. If p_validate is true, then set to
204 * null.
205 * @param p_asg_object_version_number If p_validate is false, then this
206 * parameter is set to the version number of the assignment created. If
207 * p_validate is true, then this parameter is null.
208 * @param p_per_effective_start_date If p_validate is false, then set to the
209 * earliest effective start date for the created person. If p_validate is true,
210 * then set to null.
211 * @param p_per_effective_end_date If p_validate is false, then set to the
212 * effective end date for the created person. If p_validate is true, then set
213 * to null.
214 * @param p_full_name If p_validate is false, then set to the complete full
215 * name of the person. If p_validate is true, then set to null.
216 * @param p_per_comment_id If p_validate is false and comment text was
217 * provided, then will be set to the identifier of the created person comment
218 * record. If p_validate is true or no comment text was provided, then will be
219 * null.
220 * @param p_assignment_sequence If p_validate is false, then set to the
221 * sequence number of the default assignment. If p_validate is true, then set
222 * to null.
223 * @param p_assignment_number If p_validate is false, then set to the
224 * assignment number of the default assignment. If p_validate is true, then set
225 * to null.
226 * @param p_name_combination_warning If set to true, then the combination of
227 * last name, first name and date of birth existed prior to calling this API.
228 * @param p_assign_payroll_warning If set to true, then the date of birth is
229 * not entered. If set to false, then the date of birth has been entered.
230 * Indicates if it will be possible to set the payroll on any of this person's
231 * assignments.
232 * @param p_orig_hire_warning Set to true if the original hire date is
233 * populated and the person type is not "Employee", "Employee and Applicant",
234 * "Ex-employee" or "Ex-employee and Applicant".
235 * @rep:displayname Create Employee
236 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
237 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
238 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
239 * @rep:scope public
240 * @rep:lifecycle active
241 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
242 */
243 --
244 -- {End Of Comments}
245 --
246 procedure create_employee
247 (p_validate in boolean default false
248 ,p_hire_date in date
249 ,p_business_group_id in number
250 ,p_last_name in varchar2
251 ,p_sex in varchar2
252 ,p_person_type_id in number default null
253 ,p_per_comments in varchar2 default null
254 ,p_date_employee_data_verified in date default null
255 ,p_date_of_birth in date default null
256 ,p_email_address in varchar2 default null
257 ,p_employee_number in out nocopy varchar2
258 ,p_expense_check_send_to_addres in varchar2 default null
259 ,p_first_name in varchar2 default null
260 ,p_known_as in varchar2 default null
261 ,p_marital_status in varchar2 default null
262 ,p_middle_names in varchar2 default null
263 ,p_nationality in varchar2 default null
264 ,p_national_identifier in varchar2 default null
265 ,p_previous_last_name in varchar2 default null
266 ,p_registered_disabled_flag in varchar2 default null
270 ,p_attribute_category in varchar2 default null
267 ,p_title in varchar2 default null
268 ,p_vendor_id in number default null
269 ,p_work_telephone in varchar2 default null
271 ,p_attribute1 in varchar2 default null
272 ,p_attribute2 in varchar2 default null
273 ,p_attribute3 in varchar2 default null
274 ,p_attribute4 in varchar2 default null
275 ,p_attribute5 in varchar2 default null
276 ,p_attribute6 in varchar2 default null
277 ,p_attribute7 in varchar2 default null
278 ,p_attribute8 in varchar2 default null
279 ,p_attribute9 in varchar2 default null
280 ,p_attribute10 in varchar2 default null
281 ,p_attribute11 in varchar2 default null
282 ,p_attribute12 in varchar2 default null
283 ,p_attribute13 in varchar2 default null
284 ,p_attribute14 in varchar2 default null
285 ,p_attribute15 in varchar2 default null
286 ,p_attribute16 in varchar2 default null
287 ,p_attribute17 in varchar2 default null
288 ,p_attribute18 in varchar2 default null
289 ,p_attribute19 in varchar2 default null
290 ,p_attribute20 in varchar2 default null
291 ,p_attribute21 in varchar2 default null
292 ,p_attribute22 in varchar2 default null
293 ,p_attribute23 in varchar2 default null
294 ,p_attribute24 in varchar2 default null
295 ,p_attribute25 in varchar2 default null
296 ,p_attribute26 in varchar2 default null
297 ,p_attribute27 in varchar2 default null
298 ,p_attribute28 in varchar2 default null
299 ,p_attribute29 in varchar2 default null
300 ,p_attribute30 in varchar2 default null
301 ,p_per_information_category in varchar2 default null
302 -- p_per_information_category - Obsolete parameter, do not use
303 ,p_per_information1 in varchar2 default null
304 ,p_per_information2 in varchar2 default null
305 ,p_per_information3 in varchar2 default null
306 ,p_per_information4 in varchar2 default null
307 ,p_per_information5 in varchar2 default null
308 ,p_per_information6 in varchar2 default null
309 ,p_per_information7 in varchar2 default null
310 ,p_per_information8 in varchar2 default null
311 ,p_per_information9 in varchar2 default null
312 ,p_per_information10 in varchar2 default null
313 ,p_per_information11 in varchar2 default null
314 ,p_per_information12 in varchar2 default null
315 ,p_per_information13 in varchar2 default null
316 ,p_per_information14 in varchar2 default null
317 ,p_per_information15 in varchar2 default null
318 ,p_per_information16 in varchar2 default null
319 ,p_per_information17 in varchar2 default null
320 ,p_per_information18 in varchar2 default null
321 ,p_per_information19 in varchar2 default null
322 ,p_per_information20 in varchar2 default null
323 ,p_per_information21 in varchar2 default null
324 ,p_per_information22 in varchar2 default null
325 ,p_per_information23 in varchar2 default null
326 ,p_per_information24 in varchar2 default null
327 ,p_per_information25 in varchar2 default null
328 ,p_per_information26 in varchar2 default null
329 ,p_per_information27 in varchar2 default null
330 ,p_per_information28 in varchar2 default null
331 ,p_per_information29 in varchar2 default null
332 ,p_per_information30 in varchar2 default null
333 ,p_date_of_death in date default null
334 ,p_background_check_status in varchar2 default null
335 ,p_background_date_check in date default null
336 ,p_blood_type in varchar2 default null
337 ,p_correspondence_language in varchar2 default null
338 ,p_fast_path_employee in varchar2 default null
339 ,p_fte_capacity in number default null
340 ,p_honors in varchar2 default null
341 ,p_internal_location in varchar2 default null
342 ,p_last_medical_test_by in varchar2 default null
343 ,p_last_medical_test_date in date default null
344 ,p_mailstop in varchar2 default null
345 ,p_office_number in varchar2 default null
346 ,p_on_military_service in varchar2 default null
347 ,p_pre_name_adjunct in varchar2 default null
348 ,p_rehire_recommendation in varchar2 default null -- Bug3210500
349 ,p_projected_start_date in date default null
350 ,p_resume_exists in varchar2 default null
351 ,p_resume_last_updated in date default null
352 ,p_second_passport_exists in varchar2 default null
353 ,p_student_status in varchar2 default null
354 ,p_work_schedule in varchar2 default null
355 ,p_suffix in varchar2 default null
359 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
356 ,p_benefit_group_id in number default null
357 ,p_receipt_of_death_cert_date in date default null
358 ,p_coord_ben_med_pln_no in varchar2 default null
360 ,p_coord_ben_med_ext_er in varchar2 default null
361 ,p_coord_ben_med_pl_name in varchar2 default null
362 ,p_coord_ben_med_insr_crr_name in varchar2 default null
363 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
364 ,p_coord_ben_med_cvg_strt_dt in date default null
365 ,p_coord_ben_med_cvg_end_dt in date default null
366 ,p_uses_tobacco_flag in varchar2 default null
367 ,p_dpdnt_adoption_date in date default null
368 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
369 ,p_original_date_of_hire in date default null
370 ,p_adjusted_svc_date in date default null
371 ,p_town_of_birth in varchar2 default null
372 ,p_region_of_birth in varchar2 default null
373 ,p_country_of_birth in varchar2 default null
374 ,p_global_person_id in varchar2 default null
375 ,p_party_id in number default null
376 ,p_person_id out nocopy number
377 ,p_assignment_id out nocopy number
378 ,p_per_object_version_number out nocopy number
379 ,p_asg_object_version_number out nocopy number
380 ,p_per_effective_start_date out nocopy date
381 ,p_per_effective_end_date out nocopy date
382 ,p_full_name out nocopy varchar2
383 ,p_per_comment_id out nocopy number
384 ,p_assignment_sequence out nocopy number
385 ,p_assignment_number out nocopy varchar2
386 ,p_name_combination_warning out nocopy boolean
387 ,p_assign_payroll_warning out nocopy boolean
388 ,p_orig_hire_warning out nocopy boolean
389 );
390 --
391 -- ----------------------------------------------------------------------------
392 -- |-----------------------------< create_employee >--------------------------|
393 -- ----------------------------------------------------------------------------
394 --
395 -- This version of the API is now out-of-date however it has been provided to
396 -- you for backward compatibility support and will be removed in the future.
397 -- Oracle recommends you to modify existing calling programs in advance of the
398 -- support being withdrawn thus avoiding any potential disruption.
399 --
400 procedure create_employee
401 (p_validate in boolean default false
402 ,p_hire_date in date
403 ,p_business_group_id in number
404 ,p_last_name in varchar2
405 ,p_sex in varchar2
406 ,p_person_type_id in number default null
407 ,p_per_comments in varchar2 default null
408 ,p_date_employee_data_verified in date default null
409 ,p_date_of_birth in date default null
410 ,p_email_address in varchar2 default null
411 ,p_employee_number in out nocopy varchar2
412 ,p_expense_check_send_to_addres in varchar2 default null
413 ,p_first_name in varchar2 default null
414 ,p_known_as in varchar2 default null
415 ,p_marital_status in varchar2 default null
416 ,p_middle_names in varchar2 default null
417 ,p_nationality in varchar2 default null
418 ,p_national_identifier in varchar2 default null
419 ,p_previous_last_name in varchar2 default null
420 ,p_registered_disabled_flag in varchar2 default null
421 ,p_title in varchar2 default null
422 ,p_vendor_id in number default null
423 ,p_work_telephone in varchar2 default null
424 ,p_attribute_category in varchar2 default null
425 ,p_attribute1 in varchar2 default null
426 ,p_attribute2 in varchar2 default null
427 ,p_attribute3 in varchar2 default null
428 ,p_attribute4 in varchar2 default null
429 ,p_attribute5 in varchar2 default null
430 ,p_attribute6 in varchar2 default null
431 ,p_attribute7 in varchar2 default null
432 ,p_attribute8 in varchar2 default null
433 ,p_attribute9 in varchar2 default null
434 ,p_attribute10 in varchar2 default null
435 ,p_attribute11 in varchar2 default null
436 ,p_attribute12 in varchar2 default null
437 ,p_attribute13 in varchar2 default null
438 ,p_attribute14 in varchar2 default null
439 ,p_attribute15 in varchar2 default null
440 ,p_attribute16 in varchar2 default null
441 ,p_attribute17 in varchar2 default null
442 ,p_attribute18 in varchar2 default null
443 ,p_attribute19 in varchar2 default null
444 ,p_attribute20 in varchar2 default null
445 ,p_attribute21 in varchar2 default null
446 ,p_attribute22 in varchar2 default null
447 ,p_attribute23 in varchar2 default null
448 ,p_attribute24 in varchar2 default null
449 ,p_attribute25 in varchar2 default null
453 ,p_attribute29 in varchar2 default null
450 ,p_attribute26 in varchar2 default null
451 ,p_attribute27 in varchar2 default null
452 ,p_attribute28 in varchar2 default null
454 ,p_attribute30 in varchar2 default null
455 ,p_per_information_category in varchar2 default null
456 -- p_per_information_category - Obsolete parameter, do not use
457 ,p_per_information1 in varchar2 default null
458 ,p_per_information2 in varchar2 default null
459 ,p_per_information3 in varchar2 default null
460 ,p_per_information4 in varchar2 default null
461 ,p_per_information5 in varchar2 default null
462 ,p_per_information6 in varchar2 default null
463 ,p_per_information7 in varchar2 default null
464 ,p_per_information8 in varchar2 default null
465 ,p_per_information9 in varchar2 default null
466 ,p_per_information10 in varchar2 default null
467 ,p_per_information11 in varchar2 default null
468 ,p_per_information12 in varchar2 default null
469 ,p_per_information13 in varchar2 default null
470 ,p_per_information14 in varchar2 default null
471 ,p_per_information15 in varchar2 default null
472 ,p_per_information16 in varchar2 default null
473 ,p_per_information17 in varchar2 default null
474 ,p_per_information18 in varchar2 default null
475 ,p_per_information19 in varchar2 default null
476 ,p_per_information20 in varchar2 default null
477 ,p_per_information21 in varchar2 default null
478 ,p_per_information22 in varchar2 default null
479 ,p_per_information23 in varchar2 default null
480 ,p_per_information24 in varchar2 default null
481 ,p_per_information25 in varchar2 default null
482 ,p_per_information26 in varchar2 default null
483 ,p_per_information27 in varchar2 default null
484 ,p_per_information28 in varchar2 default null
485 ,p_per_information29 in varchar2 default null
486 ,p_per_information30 in varchar2 default null
487 ,p_date_of_death in date default null
488 ,p_background_check_status in varchar2 default null
489 ,p_background_date_check in date default null
490 ,p_blood_type in varchar2 default null
491 ,p_correspondence_language in varchar2 default null
492 ,p_fast_path_employee in varchar2 default null
493 ,p_fte_capacity in number default null
494 ,p_honors in varchar2 default null
495 ,p_internal_location in varchar2 default null
496 ,p_last_medical_test_by in varchar2 default null
497 ,p_last_medical_test_date in date default null
498 ,p_mailstop in varchar2 default null
499 ,p_office_number in varchar2 default null
500 ,p_on_military_service in varchar2 default null
501 ,p_pre_name_adjunct in varchar2 default null
502 ,p_rehire_recommendation in varchar2 default null -- Bug3210500
503 ,p_projected_start_date in date default null
504 ,p_resume_exists in varchar2 default null
505 ,p_resume_last_updated in date default null
506 ,p_second_passport_exists in varchar2 default null
507 ,p_student_status in varchar2 default null
508 ,p_work_schedule in varchar2 default null
509 ,p_suffix in varchar2 default null
510 ,p_benefit_group_id in number default null
511 ,p_receipt_of_death_cert_date in date default null
512 ,p_coord_ben_med_pln_no in varchar2 default null
513 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
514 ,p_coord_ben_med_ext_er in varchar2 default null
515 ,p_coord_ben_med_pl_name in varchar2 default null
516 ,p_coord_ben_med_insr_crr_name in varchar2 default null
517 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
518 ,p_coord_ben_med_cvg_strt_dt in date default null
519 ,p_coord_ben_med_cvg_end_dt in date default null
520 ,p_uses_tobacco_flag in varchar2 default null
521 ,p_dpdnt_adoption_date in date default null
522 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
523 ,p_original_date_of_hire in date default null
524 ,p_adjusted_svc_date in date default null
525 ,p_town_of_birth in varchar2 default null
526 ,p_region_of_birth in varchar2 default null
527 ,p_country_of_birth in varchar2 default null
528 ,p_global_person_id in varchar2 default null
529 ,p_party_id in number default null
530 ,p_person_id out nocopy number
531 ,p_assignment_id out nocopy number
532 ,p_per_object_version_number out nocopy number
533 ,p_asg_object_version_number out nocopy number
534 ,p_per_effective_start_date out nocopy date
535 ,p_per_effective_end_date out nocopy date
536 ,p_full_name out nocopy varchar2
537 ,p_per_comment_id out nocopy number
538 ,p_assignment_sequence out nocopy number
539 ,p_assignment_number out nocopy varchar2
540 ,p_name_combination_warning out nocopy boolean
541 ,p_assign_payroll_warning out nocopy boolean
542 );
543 --
547 --
544 -- ----------------------------------------------------------------------------
545 -- |----------------------------< create_gb_employee >------------------------|
546 -- ----------------------------------------------------------------------------
548 -- {Start Of Comments}
549 /*#
550 * This API creates an employee in a United Kingdom business group.
551 *
552 * This API creates a default primary assignment and a period of service for
553 * the employee. Secure user functionality is included in this version of the
554 * API. The employee is visible to secure users in the business group. <P>HR
555 * Foundation users can use the following parameters only: p_validate,
556 * p_hire_date, p_business_group_id, p_last_name, p_previous_last_name,
557 * p_mailstop, p_office_number, p_internal_location, p_correspondence_language,
558 * p_known_as, p_sex, p_date_of_birth, p_email_address, p_employee_number,
559 * p_expense_check_send_to_addres, p_first_name, p_middle_names,
560 * p_national_identifier, p_title, p_attribute_category, and p_attribute1-30.
561 *
562 * <p><b>Licensing</b><br>
563 * This API is licensed for use with Human Resources and HR Foundation.
564 *
565 * <p><b>Prerequisites</b><br>
566 * The United Kingdom business group must exist on the effective date. If
567 * person_type_id is supplied, it must have a corresponding system person type
568 * of EMP and must be active in the same business group as the employee being
569 * created.
570 *
571 * <p><b>Post Success</b><br>
572 * The person, period of service, and default employee assignment are created.
573 *
574 * <p><b>Post Failure</b><br>
575 * The employee is not created and an error is raised.
576 * @param p_validate If true, then validation alone will be performed and the
577 * database will remain unchanged. If false and all validation checks pass,
578 * then the database will be modified.
579 * @param p_hire_date Hire Date.
580 * @param p_business_group_id Business group of the person.
581 * @param p_last_name Last name.
582 * @param p_sex Legal gender. Valid values are defined by the SEX lookup type.
583 * @param p_person_type_id Type of employee being created.
584 * @param p_comments Person comment text.
585 * @param p_date_employee_data_verified Date on which the employee data was
586 * last verified.
587 * @param p_date_of_birth Date of birth.
588 * @param p_email_address Email address.
589 * @param p_employee_number The business group's employee number generation
590 * method determines when the API derives and passes out an employee number or
591 * when the calling program should pass in a value. When the API call completes
592 * if p_validate is false then will be set to the employee number. If
593 * p_validate is true then will be set to the passed value.
594 * @param p_expense_check_send_to_addres Mailing address.
595 * @param p_first_name First name.
596 * @param p_known_as Preferred name.
597 * @param p_marital_status Marital status. Valid values are defined by the
598 * MAR_STATUS lookup type.
599 * @param p_middle_names Middle names.
600 * @param p_nationality Nationality. Valid values are defined by the
601 * NATIONALITY lookup type.
602 * @param p_ni_number Number by which a person is identified in a given
603 * legislation.
604 * @param p_previous_last_name Previous last name.
605 * @param p_registered_disabled_flag Flag indicating whether the person is
606 * classified as disabled.
607 * @param p_title Title. Valid values are defined by the TITLE lookup type.
608 * @param p_vendor_id Obsolete parameter, do not use.
609 * @param p_work_telephone Obsolete parameter, do not use.
610 * @param p_attribute_category This context value determines which flexfield
611 * structure to use with the descriptive flexfield segments.
612 * @param p_attribute1 Descriptive flexfield segment.
613 * @param p_attribute2 Descriptive flexfield segment.
614 * @param p_attribute3 Descriptive flexfield segment.
615 * @param p_attribute4 Descriptive flexfield segment.
616 * @param p_attribute5 Descriptive flexfield segment.
617 * @param p_attribute6 Descriptive flexfield segment.
618 * @param p_attribute7 Descriptive flexfield segment.
619 * @param p_attribute8 Descriptive flexfield segment.
620 * @param p_attribute9 Descriptive flexfield segment.
621 * @param p_attribute10 Descriptive flexfield segment.
622 * @param p_attribute11 Descriptive flexfield segment.
623 * @param p_attribute12 Descriptive flexfield segment.
624 * @param p_attribute13 Descriptive flexfield segment.
625 * @param p_attribute14 Descriptive flexfield segment.
626 * @param p_attribute15 Descriptive flexfield segment.
627 * @param p_attribute16 Descriptive flexfield segment.
628 * @param p_attribute17 Descriptive flexfield segment.
629 * @param p_attribute18 Descriptive flexfield segment.
630 * @param p_attribute19 Descriptive flexfield segment.
631 * @param p_attribute20 Descriptive flexfield segment.
632 * @param p_attribute21 Descriptive flexfield segment.
633 * @param p_attribute22 Descriptive flexfield segment.
634 * @param p_attribute23 Descriptive flexfield segment.
635 * @param p_attribute24 Descriptive flexfield segment.
636 * @param p_attribute25 Descriptive flexfield segment.
637 * @param p_attribute26 Descriptive flexfield segment.
638 * @param p_attribute27 Descriptive flexfield segment.
639 * @param p_attribute28 Descriptive flexfield segment.
640 * @param p_attribute29 Descriptive flexfield segment.
641 * @param p_attribute30 Descriptive flexfield segment.
642 * @param p_ethnic_origin Ethnic origin. Valid values are defined by the
643 * ETH_TYPE lookup type.
644 * @param p_director Flag indicating whether the person is a company director.
645 * @param p_pensioner Flag indicating whether the person is a pensioner.
646 * @param p_work_permit_number Work permit number.
647 * @param p_addl_pension_years Additional pension years.
648 * @param p_addl_pension_months Additional pension months.
652 * defined by the YES_NO lookup type.
649 * @param p_addl_pension_days Additional pension days.
650 * @param p_ni_multiple_asg Identifies whether the National Insurance should be
651 * calculated according to the Multiple Assignments rules. Valid values are
653 * @param p_date_of_death Date of death.
654 * @param p_background_check_status Flag indicating whether the person's
655 * background has been checked.
656 * @param p_background_date_check Date on which the background check was
657 * performed.
658 * @param p_blood_type Blood type.
659 * @param p_correspondence_language Preferred language for correspondence.
660 * @param p_fast_path_employee Obsolete parameter, do not use.
661 * @param p_fte_capacity Obsolete parameter, do not use.
662 * @param p_honors Honors awarded.
663 * @param p_internal_location Internal location of office.
664 * @param p_last_medical_test_by Name of physician who performed the last
665 * medical test.
666 * @param p_last_medical_test_date Date of last medical test.
667 * @param p_mailstop Internal mail location.
668 * @param p_office_number Office number.
669 * @param p_on_military_service Flag indicating whether the person is on
670 * military service.
671 * @param p_pre_name_adjunct First part of the last name.
672 * @param p_rehire_recommendation Obsolete parameter, do not use.
673 * @param p_projected_start_date Obsolete parameter, do not use.
674 * @param p_resume_exists Flag indicating whether the person's resume is on
675 * file.
676 * @param p_resume_last_updated Date on which the resume was last updated.
677 * @param p_second_passport_exists Flag indicating whether a person has
678 * multiple passports.
679 * @param p_student_status If this employee is a student, this field is used to
680 * capture their status. Valid values are defined by the STUDENT_STATUS lookup
681 * type.
682 * @param p_work_schedule Days on which this person will work.
683 * @param p_suffix Suffix after the person's last name e.g. Sr., Jr., III.
684 * @param p_benefit_group_id Benefit group to which this person will belong.
685 * @param p_receipt_of_death_cert_date Date death certificate was received.
686 * @param p_coord_ben_med_pln_no Secondary medical plan name. Column used for
687 * external processing.
688 * @param p_coord_ben_no_cvg_flag No secondary medical plan coverage. Column
689 * used for external processing.
690 * @param p_coord_ben_med_ext_er Secondary external medical coverage. Column
691 * used for external processing.
692 * @param p_coord_ben_med_pl_name Secondary medical coverage name. Column used
693 * for external processing.
694 * @param p_coord_ben_med_insr_crr_name Secondary medical coverage insurance
695 * carrier name. Column used for external processing.
696 * @param p_coord_ben_med_insr_crr_ident Secondary medical coverage insurance
697 * carrier identifier. Column used for external processing.
698 * @param p_coord_ben_med_cvg_strt_dt Secondary medical coverage effective
699 * start date. Column used for external processing.
700 * @param p_coord_ben_med_cvg_end_dt Secondary medical coverage effective end
701 * date. Column used for external processing.
702 * @param p_uses_tobacco_flag Flag indicating whether the person uses tobacco.
703 * @param p_dpdnt_adoption_date Date on which the dependent was adopted.
704 * @param p_dpdnt_vlntry_svce_flag Flag indicating whether the dependent is on
705 * voluntary service.
706 * @param p_original_date_of_hire Original date of hire.
707 * @param p_adjusted_svc_date Adjusted service date.
708 * @param p_town_of_birth Town or city of birth.
709 * @param p_region_of_birth Geographical region of birth.
710 * @param p_country_of_birth Country of birth.
711 * @param p_global_person_id Obsolete parameter, do not use.
712 * @param p_party_id TCA party for whom you create the person record.
713 * @param p_person_id If p_validate is false, then this uniquely identifies the
714 * person created. If p_validate is true, then set to null.
715 * @param p_assignment_id If p_validate is false, then this uniquely identifies
716 * the created assignment. If p_validate is true, then set to null.
717 * @param p_per_object_version_number If p_validate is false, then set to the
718 * version number of the created person. If p_validate is true, then set to
719 * null.
720 * @param p_asg_object_version_number If p_validate is false, then this
721 * parameter is set to the version number of the assignment created. If
722 * p_validate is true, then this parameter is null.
723 * @param p_per_effective_start_date If p_validate is false, then set to the
724 * earliest effective start date for the created person. If p_validate is true,
725 * then set to null.
726 * @param p_per_effective_end_date If p_validate is false, then set to the
727 * effective end date for the created person. If p_validate is true, then set
728 * to null.
729 * @param p_full_name If p_validate is false, then set to the complete full
730 * name of the person. If p_validate is true, then set to null.
731 * @param p_per_comment_id If p_validate is false and comment text was
732 * provided, then will be set to the identifier of the created person comment
733 * record. If p_validate is true or no comment text was provided, then will be
734 * null.
735 * @param p_assignment_sequence If p_validate is false, then set to the
736 * sequence number of the default assignment. If p_validate is true, then set
737 * to null.
738 * @param p_assignment_number If p_validate is false, then set to the
739 * assignment number of the default assignment. If p_validate is true, then set
740 * to null.
741 * @param p_name_combination_warning If set to true, then the combination of
742 * last name, first name and date of birth existed prior to calling this API.
743 * @param p_assign_payroll_warning If set to true, then the date of birth is
744 * not entered. If set to false, then the date of birth has been entered.
745 * Indicates if it will be possible to set the payroll on any of this person's
746 * assignments.
750 * @rep:displayname Create Employee for United Kingdom
747 * @param p_orig_hire_warning Set to true if the original hire date is
748 * populated and the person type is not "Employee", "Employee and Applicant",
749 * "Ex-employee" or "Ex-employee and Applicant".
751 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
752 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
753 * @rep:scope public
754 * @rep:lifecycle active
755 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
756 */
757 --
758 -- {End Of Comments}
759 --
760 procedure create_gb_employee
761 (p_validate in boolean default false
762 ,p_hire_date in date
763 ,p_business_group_id in number
764 ,p_last_name in varchar2
765 ,p_sex in varchar2
766 ,p_person_type_id in number default null
767 ,p_comments in varchar2 default null
768 ,p_date_employee_data_verified in date default null
769 ,p_date_of_birth in date default null
770 ,p_email_address in varchar2 default null
771 ,p_employee_number in out nocopy varchar2
772 ,p_expense_check_send_to_addres in varchar2 default null
773 ,p_first_name in varchar2 default null
774 ,p_known_as in varchar2 default null
775 ,p_marital_status in varchar2 default null
776 ,p_middle_names in varchar2 default null
777 ,p_nationality in varchar2 default null
778 ,p_ni_number in varchar2 default null
779 ,p_previous_last_name in varchar2 default null
780 ,p_registered_disabled_flag in varchar2 default null
781 ,p_title in varchar2 default null
782 ,p_vendor_id in number default null
783 ,p_work_telephone in varchar2 default null
784 ,p_attribute_category in varchar2 default null
785 ,p_attribute1 in varchar2 default null
786 ,p_attribute2 in varchar2 default null
787 ,p_attribute3 in varchar2 default null
788 ,p_attribute4 in varchar2 default null
789 ,p_attribute5 in varchar2 default null
790 ,p_attribute6 in varchar2 default null
791 ,p_attribute7 in varchar2 default null
792 ,p_attribute8 in varchar2 default null
793 ,p_attribute9 in varchar2 default null
794 ,p_attribute10 in varchar2 default null
795 ,p_attribute11 in varchar2 default null
796 ,p_attribute12 in varchar2 default null
797 ,p_attribute13 in varchar2 default null
798 ,p_attribute14 in varchar2 default null
799 ,p_attribute15 in varchar2 default null
800 ,p_attribute16 in varchar2 default null
801 ,p_attribute17 in varchar2 default null
802 ,p_attribute18 in varchar2 default null
803 ,p_attribute19 in varchar2 default null
804 ,p_attribute20 in varchar2 default null
805 ,p_attribute21 in varchar2 default null
806 ,p_attribute22 in varchar2 default null
807 ,p_attribute23 in varchar2 default null
808 ,p_attribute24 in varchar2 default null
809 ,p_attribute25 in varchar2 default null
810 ,p_attribute26 in varchar2 default null
811 ,p_attribute27 in varchar2 default null
812 ,p_attribute28 in varchar2 default null
813 ,p_attribute29 in varchar2 default null
814 ,p_attribute30 in varchar2 default null
815 ,p_ethnic_origin in varchar2 default null
816 ,p_director in varchar2 default 'N'
817 ,p_pensioner in varchar2 default 'N'
818 ,p_work_permit_number in varchar2 default null
819 ,p_addl_pension_years in varchar2 default null
820 ,p_addl_pension_months in varchar2 default null
821 ,p_addl_pension_days in varchar2 default null
822 ,p_ni_multiple_asg in varchar2 default 'N'
823 ,p_date_of_death in date default null
824 ,p_background_check_status in varchar2 default null
825 ,p_background_date_check in date default null
826 ,p_blood_type in varchar2 default null
827 ,p_correspondence_language in varchar2 default null
828 ,p_fast_path_employee in varchar2 default null
829 ,p_fte_capacity in number default null
830 ,p_honors in varchar2 default null
831 ,p_internal_location in varchar2 default null
832 ,p_last_medical_test_by in varchar2 default null
833 ,p_last_medical_test_date in date default null
834 ,p_mailstop in varchar2 default null
835 ,p_office_number in varchar2 default null
836 ,p_on_military_service in varchar2 default null
837 ,p_pre_name_adjunct in varchar2 default null
838 ,p_rehire_recommendation in varchar2 default null -- Bug3210500
839 ,p_projected_start_date in date default null
840 ,p_resume_exists in varchar2 default null
841 ,p_resume_last_updated in date default null
842 ,p_second_passport_exists in varchar2 default null
846 ,p_benefit_group_id in number default null
843 ,p_student_status in varchar2 default null
844 ,p_work_schedule in varchar2 default null
845 ,p_suffix in varchar2 default null
847 ,p_receipt_of_death_cert_date in date default null
848 ,p_coord_ben_med_pln_no in varchar2 default null
849 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
850 ,p_coord_ben_med_ext_er in varchar2 default null
851 ,p_coord_ben_med_pl_name in varchar2 default null
852 ,p_coord_ben_med_insr_crr_name in varchar2 default null
853 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
854 ,p_coord_ben_med_cvg_strt_dt in date default null
855 ,p_coord_ben_med_cvg_end_dt in date default null
856 ,p_uses_tobacco_flag in varchar2 default null
857 ,p_dpdnt_adoption_date in date default null
858 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
859 ,p_original_date_of_hire in date default null
860 ,p_adjusted_svc_date in date default null
861 ,p_town_of_birth in varchar2 default null
862 ,p_region_of_birth in varchar2 default null
863 ,p_country_of_birth in varchar2 default null
864 ,p_global_person_id in varchar2 default null
865 ,p_party_id in number default null
866 ,p_person_id out nocopy number
867 ,p_assignment_id out nocopy number
868 ,p_per_object_version_number out nocopy number
869 ,p_asg_object_version_number out nocopy number
870 ,p_per_effective_start_date out nocopy date
871 ,p_per_effective_end_date out nocopy date
872 ,p_full_name out nocopy varchar2
873 ,p_per_comment_id out nocopy number
874 ,p_assignment_sequence out nocopy number
875 ,p_assignment_number out nocopy varchar2
876 ,p_name_combination_warning out nocopy boolean
877 ,p_assign_payroll_warning out nocopy boolean
878 ,p_orig_hire_warning out nocopy boolean
879 );
880 --
881 -- ----------------------------------------------------------------------------
882 -- |----------------------------< create_gb_employee >------------------------|
883 -- ----------------------------------------------------------------------------
884 --
885 -- This version of the API is now out-of-date however it has been provided to
886 -- you for backward compatibility support and will be removed in the future.
887 -- Oracle recommends you to modify existing calling programs in advance of the
888 -- support being withdrawn thus avoiding any potential disruption.
889 --
890 procedure create_gb_employee
891 (p_validate in boolean default false
892 ,p_hire_date in date
893 ,p_business_group_id in number
894 ,p_last_name in varchar2
895 ,p_sex in varchar2
896 ,p_person_type_id in number default null
897 ,p_comments in varchar2 default null
898 ,p_date_employee_data_verified in date default null
899 ,p_date_of_birth in date default null
900 ,p_email_address in varchar2 default null
901 ,p_employee_number in out nocopy varchar2
902 ,p_expense_check_send_to_addres in varchar2 default null
903 ,p_first_name in varchar2 default null
904 ,p_known_as in varchar2 default null
905 ,p_marital_status in varchar2 default null
906 ,p_middle_names in varchar2 default null
907 ,p_nationality in varchar2 default null
908 ,p_ni_number in varchar2 default null
909 ,p_previous_last_name in varchar2 default null
910 ,p_registered_disabled_flag in varchar2 default null
911 ,p_title in varchar2 default null
912 ,p_vendor_id in number default null
913 ,p_work_telephone in varchar2 default null
914 ,p_attribute_category in varchar2 default null
915 ,p_attribute1 in varchar2 default null
916 ,p_attribute2 in varchar2 default null
917 ,p_attribute3 in varchar2 default null
918 ,p_attribute4 in varchar2 default null
919 ,p_attribute5 in varchar2 default null
920 ,p_attribute6 in varchar2 default null
921 ,p_attribute7 in varchar2 default null
922 ,p_attribute8 in varchar2 default null
923 ,p_attribute9 in varchar2 default null
924 ,p_attribute10 in varchar2 default null
925 ,p_attribute11 in varchar2 default null
926 ,p_attribute12 in varchar2 default null
927 ,p_attribute13 in varchar2 default null
928 ,p_attribute14 in varchar2 default null
929 ,p_attribute15 in varchar2 default null
930 ,p_attribute16 in varchar2 default null
931 ,p_attribute17 in varchar2 default null
932 ,p_attribute18 in varchar2 default null
933 ,p_attribute19 in varchar2 default null
934 ,p_attribute20 in varchar2 default null
935 ,p_attribute21 in varchar2 default null
936 ,p_attribute22 in varchar2 default null
940 ,p_attribute26 in varchar2 default null
937 ,p_attribute23 in varchar2 default null
938 ,p_attribute24 in varchar2 default null
939 ,p_attribute25 in varchar2 default null
941 ,p_attribute27 in varchar2 default null
942 ,p_attribute28 in varchar2 default null
943 ,p_attribute29 in varchar2 default null
944 ,p_attribute30 in varchar2 default null
945 ,p_ethnic_origin in varchar2 default null
946 ,p_director in varchar2 default 'N'
947 ,p_pensioner in varchar2 default 'N'
948 ,p_work_permit_number in varchar2 default null
949 ,p_addl_pension_years in varchar2 default null
950 ,p_addl_pension_months in varchar2 default null
951 ,p_addl_pension_days in varchar2 default null
952 ,p_ni_multiple_asg in varchar2 default 'N'
953 ,p_date_of_death in date default null
954 ,p_background_check_status in varchar2 default null
955 ,p_background_date_check in date default null
956 ,p_blood_type in varchar2 default null
957 ,p_correspondence_language in varchar2 default null
958 ,p_fast_path_employee in varchar2 default null
959 ,p_fte_capacity in number default null
960 ,p_honors in varchar2 default null
961 ,p_internal_location in varchar2 default null
962 ,p_last_medical_test_by in varchar2 default null
963 ,p_last_medical_test_date in date default null
964 ,p_mailstop in varchar2 default null
965 ,p_office_number in varchar2 default null
966 ,p_on_military_service in varchar2 default null
967 ,p_pre_name_adjunct in varchar2 default null
968 ,p_rehire_recommendation in varchar2 default null -- Bug3210500
969 ,p_projected_start_date in date default null
970 ,p_resume_exists in varchar2 default null
971 ,p_resume_last_updated in date default null
972 ,p_second_passport_exists in varchar2 default null
973 ,p_student_status in varchar2 default null
974 ,p_work_schedule in varchar2 default null
975 ,p_suffix in varchar2 default null
976 ,p_benefit_group_id in number default null
977 ,p_receipt_of_death_cert_date in date default null
978 ,p_coord_ben_med_pln_no in varchar2 default null
979 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
980 ,p_coord_ben_med_ext_er in varchar2 default null
981 ,p_coord_ben_med_pl_name in varchar2 default null
982 ,p_coord_ben_med_insr_crr_name in varchar2 default null
983 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
984 ,p_coord_ben_med_cvg_strt_dt in date default null
985 ,p_coord_ben_med_cvg_end_dt in date default null
986 ,p_uses_tobacco_flag in varchar2 default null
987 ,p_dpdnt_adoption_date in date default null
988 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
989 ,p_original_date_of_hire in date default null
990 ,p_adjusted_svc_date in date default null
991 ,p_town_of_birth in varchar2 default null
992 ,p_region_of_birth in varchar2 default null
993 ,p_country_of_birth in varchar2 default null
994 ,p_global_person_id in varchar2 default null
995 ,p_party_id in number default null
996 ,p_person_id out nocopy number
997 ,p_assignment_id out nocopy number
998 ,p_per_object_version_number out nocopy number
999 ,p_asg_object_version_number out nocopy number
1000 ,p_per_effective_start_date out nocopy date
1001 ,p_per_effective_end_date out nocopy date
1002 ,p_full_name out nocopy varchar2
1003 ,p_per_comment_id out nocopy number
1004 ,p_assignment_sequence out nocopy number
1005 ,p_assignment_number out nocopy varchar2
1006 ,p_name_combination_warning out nocopy boolean
1007 ,p_assign_payroll_warning out nocopy boolean
1008 );
1009 --
1010 -- ----------------------------------------------------------------------------
1011 -- |----------------------------< create_us_employee >------------------------|
1012 -- ----------------------------------------------------------------------------
1013 --
1014 -- This version of the API is now out-of-date however it has been provided to
1015 -- you for backward compatibility support and will be removed in the future.
1016 -- Oracle recommends you to modify existing calling programs in advance of the
1017 -- support being withdrawn thus avoiding any potential disruption.
1018 --
1019 procedure create_us_employee
1020 (p_validate in boolean default false
1021 ,p_hire_date in date
1022 ,p_business_group_id in number
1023 ,p_last_name in varchar2
1024 ,p_sex in varchar2
1025 ,p_person_type_id in number default null
1026 ,p_comments in varchar2 default null
1027 ,p_date_employee_data_verified in date default null
1028 ,p_date_of_birth in date default null
1029 ,p_email_address in varchar2 default null
1033 ,p_known_as in varchar2 default null
1030 ,p_employee_number in out nocopy varchar2
1031 ,p_expense_check_send_to_addres in varchar2 default null
1032 ,p_first_name in varchar2 default null
1034 ,p_marital_status in varchar2 default null
1035 ,p_middle_names in varchar2 default null
1036 ,p_nationality in varchar2 default null
1037 ,p_ss_number in varchar2 default null
1038 ,p_previous_last_name in varchar2 default null
1039 ,p_registered_disabled_flag in varchar2 default null
1040 ,p_title in varchar2 default null
1041 ,p_vendor_id in number default null
1042 ,p_work_telephone in varchar2 default null
1043 ,p_attribute_category in varchar2 default null
1044 ,p_attribute1 in varchar2 default null
1045 ,p_attribute2 in varchar2 default null
1046 ,p_attribute3 in varchar2 default null
1047 ,p_attribute4 in varchar2 default null
1048 ,p_attribute5 in varchar2 default null
1049 ,p_attribute6 in varchar2 default null
1050 ,p_attribute7 in varchar2 default null
1051 ,p_attribute8 in varchar2 default null
1052 ,p_attribute9 in varchar2 default null
1053 ,p_attribute10 in varchar2 default null
1054 ,p_attribute11 in varchar2 default null
1055 ,p_attribute12 in varchar2 default null
1056 ,p_attribute13 in varchar2 default null
1057 ,p_attribute14 in varchar2 default null
1058 ,p_attribute15 in varchar2 default null
1059 ,p_attribute16 in varchar2 default null
1060 ,p_attribute17 in varchar2 default null
1061 ,p_attribute18 in varchar2 default null
1062 ,p_attribute19 in varchar2 default null
1063 ,p_attribute20 in varchar2 default null
1064 ,p_attribute21 in varchar2 default null
1065 ,p_attribute22 in varchar2 default null
1066 ,p_attribute23 in varchar2 default null
1067 ,p_attribute24 in varchar2 default null
1068 ,p_attribute25 in varchar2 default null
1069 ,p_attribute26 in varchar2 default null
1070 ,p_attribute27 in varchar2 default null
1071 ,p_attribute28 in varchar2 default null
1072 ,p_attribute29 in varchar2 default null
1073 ,p_attribute30 in varchar2 default null
1074 ,p_ethnic_origin in varchar2 default null
1075 ,p_I_9 in varchar2 default 'N'
1076 ,p_I_9_expiration_date in varchar2 default null
1077 -- ,p_visa_type in varchar2 default null
1078 ,p_veteran_status in varchar2 default null
1079 ,p_new_hire in varchar2 default null
1080 ,p_exception_reason in varchar2 default null
1081 ,p_child_support_obligation in varchar2 default 'N'
1082 ,p_opted_for_medicare_flag in varchar2 default 'N'
1083 ,p_date_of_death in date default null
1084 ,p_background_check_status in varchar2 default null
1085 ,p_background_date_check in date default null
1086 ,p_blood_type in varchar2 default null
1087 ,p_correspondence_language in varchar2 default null
1088 ,p_fast_path_employee in varchar2 default null
1089 ,p_fte_capacity in number default null
1090 ,p_honors in varchar2 default null
1091 ,p_internal_location in varchar2 default null
1092 ,p_last_medical_test_by in varchar2 default null
1093 ,p_last_medical_test_date in date default null
1094 ,p_mailstop in varchar2 default null
1095 ,p_office_number in varchar2 default null
1096 ,p_on_military_service in varchar2 default null
1097 ,p_pre_name_adjunct in varchar2 default null
1098 ,p_rehire_recommendation in varchar2 default null -- Bug 3210500
1099 ,p_projected_start_date in date default null
1100 ,p_resume_exists in varchar2 default null
1101 ,p_resume_last_updated in date default null
1102 ,p_second_passport_exists in varchar2 default null
1103 ,p_student_status in varchar2 default null
1104 ,p_work_schedule in varchar2 default null
1105 ,p_suffix in varchar2 default null
1106 ,p_benefit_group_id in number default null
1107 ,p_receipt_of_death_cert_date in date default null
1108 ,p_coord_ben_med_pln_no in varchar2 default null
1109 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
1110 ,p_coord_ben_med_ext_er in varchar2 default null
1111 ,p_coord_ben_med_pl_name in varchar2 default null
1112 ,p_coord_ben_med_insr_crr_name in varchar2 default null
1113 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
1114 ,p_coord_ben_med_cvg_strt_dt in date default null
1115 ,p_coord_ben_med_cvg_end_dt in date default null
1116 ,p_uses_tobacco_flag in varchar2 default null
1117 ,p_dpdnt_adoption_date in date default null
1118 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
1122 ,p_region_of_birth in varchar2 default null
1119 ,p_original_date_of_hire in date default null
1120 ,p_adjusted_svc_date in date default null
1121 ,p_town_of_birth in varchar2 default null
1123 ,p_country_of_birth in varchar2 default null
1124 ,p_global_person_id in varchar2 default null
1125 ,p_party_id in number default null
1126 ,p_person_id out nocopy number
1127 ,p_assignment_id out nocopy number
1128 ,p_per_object_version_number out nocopy number
1129 ,p_asg_object_version_number out nocopy number
1130 ,p_per_effective_start_date out nocopy date
1131 ,p_per_effective_end_date out nocopy date
1132 ,p_full_name out nocopy varchar2
1133 ,p_per_comment_id out nocopy number
1134 ,p_assignment_sequence out nocopy number
1135 ,p_assignment_number out nocopy varchar2
1136 ,p_name_combination_warning out nocopy boolean
1137 ,p_assign_payroll_warning out nocopy boolean
1138 );
1139 --
1140 -- ----------------------------------------------------------------------------
1141 -- |----------------------------< create_us_employee >------------------------|
1142 -- ----------------------------------------------------------------------------
1143 --
1144 -- This version of the API is now out-of-date however it has been provided to
1145 -- you for backward compatibility support and will be removed in the future.
1146 -- Oracle recommends you to modify existing calling programs in advance of the
1147 -- support being withdrawn thus avoiding any potential disruption.
1148 --
1149 procedure create_us_employee
1150 (p_validate in boolean default false
1151 ,p_hire_date in date
1152 ,p_business_group_id in number
1153 ,p_last_name in varchar2
1154 ,p_sex in varchar2
1155 ,p_person_type_id in number default null
1156 ,p_comments in varchar2 default null
1157 ,p_date_employee_data_verified in date default null
1158 ,p_date_of_birth in date default null
1159 ,p_email_address in varchar2 default null
1160 ,p_employee_number in out nocopy varchar2
1161 ,p_expense_check_send_to_addres in varchar2 default null
1162 ,p_first_name in varchar2 default null
1163 ,p_known_as in varchar2 default null
1164 ,p_marital_status in varchar2 default null
1165 ,p_middle_names in varchar2 default null
1166 ,p_nationality in varchar2 default null
1167 ,p_ss_number in varchar2 default null
1168 ,p_previous_last_name in varchar2 default null
1169 ,p_registered_disabled_flag in varchar2 default null
1170 ,p_title in varchar2 default null
1171 ,p_vendor_id in number default null
1172 ,p_work_telephone in varchar2 default null
1173 ,p_attribute_category in varchar2 default null
1174 ,p_attribute1 in varchar2 default null
1175 ,p_attribute2 in varchar2 default null
1176 ,p_attribute3 in varchar2 default null
1177 ,p_attribute4 in varchar2 default null
1178 ,p_attribute5 in varchar2 default null
1179 ,p_attribute6 in varchar2 default null
1180 ,p_attribute7 in varchar2 default null
1181 ,p_attribute8 in varchar2 default null
1182 ,p_attribute9 in varchar2 default null
1183 ,p_attribute10 in varchar2 default null
1184 ,p_attribute11 in varchar2 default null
1185 ,p_attribute12 in varchar2 default null
1186 ,p_attribute13 in varchar2 default null
1187 ,p_attribute14 in varchar2 default null
1188 ,p_attribute15 in varchar2 default null
1189 ,p_attribute16 in varchar2 default null
1190 ,p_attribute17 in varchar2 default null
1191 ,p_attribute18 in varchar2 default null
1192 ,p_attribute19 in varchar2 default null
1193 ,p_attribute20 in varchar2 default null
1194 ,p_attribute21 in varchar2 default null
1195 ,p_attribute22 in varchar2 default null
1196 ,p_attribute23 in varchar2 default null
1197 ,p_attribute24 in varchar2 default null
1198 ,p_attribute25 in varchar2 default null
1199 ,p_attribute26 in varchar2 default null
1200 ,p_attribute27 in varchar2 default null
1201 ,p_attribute28 in varchar2 default null
1202 ,p_attribute29 in varchar2 default null
1203 ,p_attribute30 in varchar2 default null
1204 ,p_ethnic_origin in varchar2 default null
1205 ,p_I_9 in varchar2 default 'N'
1206 ,p_I_9_expiration_date in varchar2 default null
1207 -- ,p_visa_type in varchar2 default null
1208 ,p_veteran_status in varchar2 default null
1209 ,p_new_hire in varchar2 default null
1210 ,p_exception_reason in varchar2 default null
1211 ,p_child_support_obligation in varchar2 default 'N'
1212 ,p_opted_for_medicare_flag in varchar2 default 'N'
1213 ,p_date_of_death in date default null
1214 ,p_background_check_status in varchar2 default null
1218 ,p_fast_path_employee in varchar2 default null
1215 ,p_background_date_check in date default null
1216 ,p_blood_type in varchar2 default null
1217 ,p_correspondence_language in varchar2 default null
1219 ,p_fte_capacity in number default null
1220 ,p_honors in varchar2 default null
1221 ,p_internal_location in varchar2 default null
1222 ,p_last_medical_test_by in varchar2 default null
1223 ,p_last_medical_test_date in date default null
1224 ,p_mailstop in varchar2 default null
1225 ,p_office_number in varchar2 default null
1226 ,p_on_military_service in varchar2 default null
1227 ,p_pre_name_adjunct in varchar2 default null
1228 ,p_rehire_recommendation in varchar2 default null -- Bug 3210500
1229 ,p_projected_start_date in date default null
1230 ,p_resume_exists in varchar2 default null
1231 ,p_resume_last_updated in date default null
1232 ,p_second_passport_exists in varchar2 default null
1233 ,p_student_status in varchar2 default null
1234 ,p_work_schedule in varchar2 default null
1235 ,p_suffix in varchar2 default null
1236 ,p_benefit_group_id in number default null
1237 ,p_receipt_of_death_cert_date in date default null
1238 ,p_coord_ben_med_pln_no in varchar2 default null
1239 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
1240 ,p_coord_ben_med_ext_er in varchar2 default null
1241 ,p_coord_ben_med_pl_name in varchar2 default null
1242 ,p_coord_ben_med_insr_crr_name in varchar2 default null
1243 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
1244 ,p_coord_ben_med_cvg_strt_dt in date default null
1245 ,p_coord_ben_med_cvg_end_dt in date default null
1246 ,p_uses_tobacco_flag in varchar2 default null
1247 ,p_dpdnt_adoption_date in date default null
1248 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
1249 ,p_original_date_of_hire in date default null
1250 ,p_adjusted_svc_date in date default null
1251 ,p_town_of_birth in varchar2 default null
1252 ,p_region_of_birth in varchar2 default null
1253 ,p_country_of_birth in varchar2 default null
1254 ,p_global_person_id in varchar2 default null
1255 ,p_party_id in number default null
1256 ,p_person_id out nocopy number
1257 ,p_assignment_id out nocopy number
1258 ,p_per_object_version_number out nocopy number
1259 ,p_asg_object_version_number out nocopy number
1260 ,p_per_effective_start_date out nocopy date
1261 ,p_per_effective_end_date out nocopy date
1262 ,p_full_name out nocopy varchar2
1263 ,p_per_comment_id out nocopy number
1264 ,p_assignment_sequence out nocopy number
1265 ,p_assignment_number out nocopy varchar2
1266 ,p_name_combination_warning out nocopy boolean
1267 ,p_assign_payroll_warning out nocopy boolean
1268 ,p_orig_hire_warning out nocopy boolean
1269 );
1270 --
1271 --
1272 -- ----------------------------------------------------------------------------
1273 -- |----------------------------< create_us_employee >------------------------|
1274 -- ----------------------------------------------------------------------------
1275 --
1276 -- {Start Of Comments}
1277 /*#
1278 * This API creates an employee in a United States business group.
1279 *
1280 * This API creates a default primary assignment and a period of service for
1281 * the employee. Secure user functionality is included in this version of the
1282 * API. The employee is visible to secure users in the business group. <P>HR
1283 * Foundation users can use the following parameters only: p_validate,
1284 * p_hire_date, p_business_group_id, p_last_name, p_previous_last_name,
1285 * p_mailstop, p_office_number, p_internal_location, p_correspondence_language,
1286 * p_known_as, p_sex, p_date_of_birth, p_email_address, p_employee_number,
1287 * p_expense_check_send_to_addres, p_first_name, p_middle_names,
1288 * p_national_identifier, p_title, p_attribute_category, and p_attribute1-30.
1289 *
1290 * <p><b>Licensing</b><br>
1291 * This API is licensed for use with Human Resources and HR Foundation.
1292 *
1293 * <p><b>Prerequisites</b><br>
1294 * The United States business group must exist on the effective date. If
1295 * person_type_id is supplied, it must have a corresponding system person type
1296 * of EMP and be active in the same business group as the employee being
1297 * created.
1298 *
1299 * <p><b>Post Success</b><br>
1300 * The person, period of service, and default employee assignment are created.
1301 *
1302 * <p><b>Post Failure</b><br>
1303 * The employee is not created and an error is raised.
1304 * @param p_validate If true, then validation alone will be performed and the
1305 * database will remain unchanged. If false and all validation checks pass,
1306 * then the database will be modified.
1307 * @param p_hire_date Hire Date.
1308 * @param p_business_group_id Business group of the person.
1309 * @param p_last_name Last name.
1310 * @param p_sex Legal gender. Valid values are defined by the SEX lookup type.
1311 * @param p_person_type_id Type of employee being created.
1312 * @param p_comments Person comment text.
1313 * @param p_date_employee_data_verified Date on which the employee data was
1314 * last verified.
1315 * @param p_date_of_birth Date of birth.
1316 * @param p_email_address Email address.
1317 * @param p_employee_number The business group's employee number generation
1318 * method determines when the API derives and passes out an employee number or
1319 * when the calling program should pass in a value. When the API call completes
1320 * if p_validate is false then will be set to the employee number. If
1321 * p_validate is true then will be set to the passed value.
1322 * @param p_expense_check_send_to_addres Mailing address.
1323 * @param p_first_name First name.
1324 * @param p_known_as Preferred name.
1325 * @param p_marital_status Marital status. Valid values are defined by the
1326 * MAR_STATUS lookup type.
1327 * @param p_middle_names Middle names.
1328 * @param p_nationality Nationality. Valid values are defined by the
1329 * NATIONALITY lookup type.
1330 * @param p_ss_number Number by which a person is identified in a given
1331 * legislation.
1332 * @param p_previous_last_name Previous last name.
1333 * @param p_registered_disabled_flag Flag indicating whether the person is
1334 * classified as disabled.
1335 * @param p_title Title. Valid values are defined by the TITLE lookup type.
1336 * @param p_vendor_id Obsolete parameter, do not use.
1337 * @param p_work_telephone Obsolete parameter, do not use.
1338 * @param p_attribute_category This context value determines which flexfield
1339 * structure to use with the descriptive flexfield segments.
1340 * @param p_attribute1 Descriptive flexfield segment.
1341 * @param p_attribute2 Descriptive flexfield segment.
1342 * @param p_attribute3 Descriptive flexfield segment.
1343 * @param p_attribute4 Descriptive flexfield segment.
1344 * @param p_attribute5 Descriptive flexfield segment.
1345 * @param p_attribute6 Descriptive flexfield segment.
1346 * @param p_attribute7 Descriptive flexfield segment.
1347 * @param p_attribute8 Descriptive flexfield segment.
1348 * @param p_attribute9 Descriptive flexfield segment.
1349 * @param p_attribute10 Descriptive flexfield segment.
1350 * @param p_attribute11 Descriptive flexfield segment.
1351 * @param p_attribute12 Descriptive flexfield segment.
1352 * @param p_attribute13 Descriptive flexfield segment.
1353 * @param p_attribute14 Descriptive flexfield segment.
1354 * @param p_attribute15 Descriptive flexfield segment.
1355 * @param p_attribute16 Descriptive flexfield segment.
1356 * @param p_attribute17 Descriptive flexfield segment.
1357 * @param p_attribute18 Descriptive flexfield segment.
1358 * @param p_attribute19 Descriptive flexfield segment.
1359 * @param p_attribute20 Descriptive flexfield segment.
1360 * @param p_attribute21 Descriptive flexfield segment.
1361 * @param p_attribute22 Descriptive flexfield segment.
1362 * @param p_attribute23 Descriptive flexfield segment.
1363 * @param p_attribute24 Descriptive flexfield segment.
1364 * @param p_attribute25 Descriptive flexfield segment.
1365 * @param p_attribute26 Descriptive flexfield segment.
1366 * @param p_attribute27 Descriptive flexfield segment.
1367 * @param p_attribute28 Descriptive flexfield segment.
1368 * @param p_attribute29 Descriptive flexfield segment.
1369 * @param p_attribute30 Descriptive flexfield segment.
1370 * @param p_ethnic_origin Ethnic origin. Valid values are defined by the
1371 * US_ETHNIC_GROUP lookup type.
1372 * @param p_i_9 Status of I9 Visa. Valid values are defined by the
1373 * PER_US_I9_STATE lookup type.
1374 * @param p_i_9_expiration_date I9 expiration date.
1375 * @param p_veteran_status Indicates whether this person is a war veteran.
1376 * Valid values are defined by the US_VETERAN_STATUS lookup type.
1377 * @param p_vets100A Indicates whether this person is a war veteran.
1378 * Valid values are defined by the US_VETERAN_STATUS_VETS100A lookup type.
1379 * @param p_new_hire Status of the new hire. Valid values are defined by the
1380 * US_NEW_HIRE_STATUS lookup type.
1381 * @param p_exception_reason New hire exception reason. Valid values are
1382 * defined by the US_NEW_HIRE_EXCEPTIONS lookup type.
1383 * @param p_child_support_obligation Flag indicating whether the person has a
1384 * child support obligation.
1385 * @param p_opted_for_medicare_flag Flag indicating whether the person has
1386 * opted for additional medicare.
1387 * @param p_date_of_death Date of death.
1388 * @param p_background_check_status Flag indicating whether the person's
1389 * background has been checked.
1390 * @param p_background_date_check Date on which the background check was
1391 * performed.
1392 * @param p_blood_type Blood type.
1393 * @param p_correspondence_language Preferred language for correspondence.
1394 * @param p_fast_path_employee Obsolete parameter, do not use.
1395 * @param p_fte_capacity Obsolete parameter, do not use.
1396 * @param p_honors Honors awarded.
1397 * @param p_internal_location Internal location of office.
1398 * @param p_last_medical_test_by Name of physician who performed the last
1399 * medical test.
1400 * @param p_last_medical_test_date Date of last medical test.
1401 * @param p_mailstop Internal mail location.
1405 * @param p_pre_name_adjunct First part of the last name.
1402 * @param p_office_number Office number.
1403 * @param p_on_military_service Flag indicating whether the person is on
1404 * military service.
1406 * @param p_rehire_recommendation Obsolete parameter, do not use.
1407 * @param p_projected_start_date Obsolete parameter, do not use.
1408 * @param p_resume_exists Flag indicating whether the person's resume is on
1409 * file.
1410 * @param p_resume_last_updated Date on which the resume was last updated.
1411 * @param p_second_passport_exists Flag indicating whether a person has
1412 * multiple passports.
1413 * @param p_student_status If this employee is a student, this field is used to
1414 * capture their status. Valid values are defined by the STUDENT_STATUS lookup
1415 * type.
1416 * @param p_work_schedule Days on which this person will work.
1417 * @param p_suffix Suffix after the person's last name e.g. Sr., Jr., III.
1418 * @param p_benefit_group_id Benefit group to which this person will belong.
1419 * @param p_receipt_of_death_cert_date Date death certificate was received.
1420 * @param p_coord_ben_med_pln_no Secondary medical plan name. Column used for
1421 * external processing.
1422 * @param p_coord_ben_no_cvg_flag No secondary medical plan coverage. Column
1423 * used for external processing.
1424 * @param p_coord_ben_med_ext_er Secondary external medical coverage. Column
1425 * used for external processing.
1426 * @param p_coord_ben_med_pl_name Secondary medical coverage name. Column used
1427 * for external processing.
1428 * @param p_coord_ben_med_insr_crr_name Secondary medical coverage insurance
1429 * carrier name. Column used for external processing.
1430 * @param p_coord_ben_med_insr_crr_ident Secondary medical coverage insurance
1431 * carrier identifier. Column used for external processing.
1432 * @param p_coord_ben_med_cvg_strt_dt Secondary medical coverage effective
1433 * start date. Column used for external processing.
1434 * @param p_coord_ben_med_cvg_end_dt Secondary medical coverage effective end
1435 * date. Column used for external processing.
1436 * @param p_uses_tobacco_flag Flag indicating whether the person uses tobacco.
1437 * @param p_dpdnt_adoption_date Date on which the dependent was adopted.
1438 * @param p_dpdnt_vlntry_svce_flag Flag indicating whether the dependent is on
1439 * voluntary service.
1440 * @param p_original_date_of_hire Original date of hire.
1441 * @param p_adjusted_svc_date Adjusted service date.
1442 * @param p_town_of_birth Town or city of birth.
1443 * @param p_region_of_birth Geographical region of birth.
1444 * @param p_country_of_birth Country of birth.
1445 * @param p_global_person_id Obsolete parameter, do not use.
1446 * @param p_party_id TCA party for whom you create the person record.
1447 * @param p_person_id If p_validate is false, then this uniquely identifies the
1448 * person created. If p_validate is true, then set to null.
1449 * @param p_assignment_id If p_validate is false, then this uniquely identifies
1450 * the created assignment. If p_validate is true, then set to null.
1451 * @param p_per_object_version_number If p_validate is false, then set to the
1452 * version number of the created person. If p_validate is true, then set to
1453 * null.
1454 * @param p_asg_object_version_number If p_validate is false, then this
1455 * parameter is set to the version number of the assignment created. If
1456 * p_validate is true, then this parameter is null.
1457 * @param p_per_effective_start_date If p_validate is false, then set to the
1458 * earliest effective start date for the created person. If p_validate is true,
1459 * then set to null.
1460 * @param p_per_effective_end_date If p_validate is false, then set to the
1461 * effective end date for the created person. If p_validate is true, then set
1462 * to null.
1463 * @param p_full_name If p_validate is false, then set to the complete full
1464 * name of the person. If p_validate is true, then set to null.
1465 * @param p_per_comment_id If p_validate is false and comment text was
1466 * provided, then will be set to the identifier of the created person comment
1467 * record. If p_validate is true or no comment text was provided, then will be
1468 * null.
1469 * @param p_assignment_sequence If p_validate is false, then set to the
1470 * sequence number of the default assignment. If p_validate is true, then set
1471 * to null.
1472 * @param p_assignment_number If p_validate is false, then set to the
1473 * assignment number of the default assignment. If p_validate is true, then set
1474 * to null.
1475 * @param p_name_combination_warning If set to true, then the combination of
1476 * last name, first name and date of birth existed prior to calling this API.
1477 * @param p_assign_payroll_warning If set to true, then the date of birth is
1478 * not entered. If set to false, then the date of birth has been entered.
1479 * Indicates if it will be possible to set the payroll on any of this person's
1480 * assignments.
1481 * @param p_orig_hire_warning Set to true if the original hire date is
1482 * populated and the person type is not "Employee", "Employee and Applicant",
1483 * "Ex-employee" or "Ex-employee and Applicant".
1484 * @rep:displayname Create Employee for United States
1485 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
1486 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
1487 * @rep:scope public
1488 * @rep:lifecycle active
1489 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1490 */
1491 --
1492 -- {End Of Comments}
1493 --
1494 procedure create_us_employee
1495 (p_validate in boolean default false
1496 ,p_hire_date in date
1497 ,p_business_group_id in number
1498 ,p_last_name in varchar2
1499 ,p_sex in varchar2
1500 ,p_person_type_id in number default null
1501 ,p_comments in varchar2 default null
1502 ,p_date_employee_data_verified in date default null
1503 ,p_date_of_birth in date default null
1504 ,p_email_address in varchar2 default null
1505 ,p_employee_number in out nocopy varchar2
1506 ,p_expense_check_send_to_addres in varchar2 default null
1507 ,p_first_name in varchar2 default null
1508 ,p_known_as in varchar2 default null
1509 ,p_marital_status in varchar2 default null
1510 ,p_middle_names in varchar2 default null
1511 ,p_nationality in varchar2 default null
1512 ,p_ss_number in varchar2 default null
1513 ,p_previous_last_name in varchar2 default null
1514 ,p_registered_disabled_flag in varchar2 default null
1515 ,p_title in varchar2 default null
1516 ,p_vendor_id in number default null
1517 ,p_work_telephone in varchar2 default null
1518 ,p_attribute_category in varchar2 default null
1519 ,p_attribute1 in varchar2 default null
1520 ,p_attribute2 in varchar2 default null
1521 ,p_attribute3 in varchar2 default null
1522 ,p_attribute4 in varchar2 default null
1523 ,p_attribute5 in varchar2 default null
1524 ,p_attribute6 in varchar2 default null
1525 ,p_attribute7 in varchar2 default null
1526 ,p_attribute8 in varchar2 default null
1527 ,p_attribute9 in varchar2 default null
1528 ,p_attribute10 in varchar2 default null
1529 ,p_attribute11 in varchar2 default null
1530 ,p_attribute12 in varchar2 default null
1531 ,p_attribute13 in varchar2 default null
1532 ,p_attribute14 in varchar2 default null
1533 ,p_attribute15 in varchar2 default null
1534 ,p_attribute16 in varchar2 default null
1535 ,p_attribute17 in varchar2 default null
1536 ,p_attribute18 in varchar2 default null
1537 ,p_attribute19 in varchar2 default null
1538 ,p_attribute20 in varchar2 default null
1539 ,p_attribute21 in varchar2 default null
1540 ,p_attribute22 in varchar2 default null
1541 ,p_attribute23 in varchar2 default null
1542 ,p_attribute24 in varchar2 default null
1543 ,p_attribute25 in varchar2 default null
1544 ,p_attribute26 in varchar2 default null
1545 ,p_attribute27 in varchar2 default null
1546 ,p_attribute28 in varchar2 default null
1547 ,p_attribute29 in varchar2 default null
1548 ,p_attribute30 in varchar2 default null
1549 ,p_ethnic_origin in varchar2 default null
1550 ,p_I_9 in varchar2 default 'N'
1551 ,p_I_9_expiration_date in varchar2 default null
1552 -- ,p_visa_type in varchar2 default null
1553 ,p_veteran_status in varchar2 default null
1554 ,p_vets100A in varchar2
1555 ,p_new_hire in varchar2 default null
1556 ,p_exception_reason in varchar2 default null
1557 ,p_child_support_obligation in varchar2 default 'N'
1558 ,p_opted_for_medicare_flag in varchar2 default 'N'
1559 ,p_date_of_death in date default null
1560 ,p_background_check_status in varchar2 default null
1561 ,p_background_date_check in date default null
1565 ,p_fte_capacity in number default null
1562 ,p_blood_type in varchar2 default null
1563 ,p_correspondence_language in varchar2 default null
1564 ,p_fast_path_employee in varchar2 default null
1566 ,p_honors in varchar2 default null
1567 ,p_internal_location in varchar2 default null
1568 ,p_last_medical_test_by in varchar2 default null
1569 ,p_last_medical_test_date in date default null
1570 ,p_mailstop in varchar2 default null
1571 ,p_office_number in varchar2 default null
1572 ,p_on_military_service in varchar2 default null
1573 ,p_pre_name_adjunct in varchar2 default null
1574 ,p_rehire_recommendation in varchar2 default null -- Bug 3210500
1575 ,p_projected_start_date in date default null
1576 ,p_resume_exists in varchar2 default null
1577 ,p_resume_last_updated in date default null
1578 ,p_second_passport_exists in varchar2 default null
1579 ,p_student_status in varchar2 default null
1580 ,p_work_schedule in varchar2 default null
1581 ,p_suffix in varchar2 default null
1582 ,p_benefit_group_id in number default null
1583 ,p_receipt_of_death_cert_date in date default null
1584 ,p_coord_ben_med_pln_no in varchar2 default null
1585 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
1586 ,p_coord_ben_med_ext_er in varchar2 default null
1587 ,p_coord_ben_med_pl_name in varchar2 default null
1588 ,p_coord_ben_med_insr_crr_name in varchar2 default null
1589 ,p_coord_ben_med_insr_crr_ident in varchar2 default null
1590 ,p_coord_ben_med_cvg_strt_dt in date default null
1591 ,p_coord_ben_med_cvg_end_dt in date default null
1592 ,p_uses_tobacco_flag in varchar2 default null
1593 ,p_dpdnt_adoption_date in date default null
1594 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
1595 ,p_original_date_of_hire in date default null
1596 ,p_adjusted_svc_date in date default null
1597 ,p_town_of_birth in varchar2 default null
1598 ,p_region_of_birth in varchar2 default null
1599 ,p_country_of_birth in varchar2 default null
1600 ,p_global_person_id in varchar2 default null
1601 ,p_party_id in number default null
1602 ,p_person_id out nocopy number
1603 ,p_assignment_id out nocopy number
1604 ,p_per_object_version_number out nocopy number
1605 ,p_asg_object_version_number out nocopy number
1606 ,p_per_effective_start_date out nocopy date
1607 ,p_per_effective_end_date out nocopy date
1608 ,p_full_name out nocopy varchar2
1609 ,p_per_comment_id out nocopy number
1610 ,p_assignment_sequence out nocopy number
1611 ,p_assignment_number out nocopy varchar2
1612 ,p_name_combination_warning out nocopy boolean
1613 ,p_assign_payroll_warning out nocopy boolean
1614 ,p_orig_hire_warning out nocopy boolean
1615 );
1616 -- ----------------------------------------------------------------------------
1617 -- |---------------------------< re_hire_ex_employee >------------------------|
1618 -- ----------------------------------------------------------------------------
1619 --
1620 -- {Start Of Comments}
1621 /*#
1622 * This API hires an ex-employee as an employee.
1623 *
1624 * A person can be re-hired only if their previous period of service has a
1625 * final process date. When an employee is re-hired, the person type is changed
1626 * to employee, a new period of service record is created, and a new primary
1627 * employee assignment record is created. All changes are effective from the
1628 * hire date. It is possible to re-hire an employee the day after they were
1629 * terminated. The new person type must have a system type of EMP. If a person
1630 * type is not specified, the API uses the default EMP type for the business
1631 * group. The security lists are updated so that this employee is visible to
1632 * secure users. HR Foundation users can use the following parameters only:
1633 * p_validate, p_hire_date, p_business_group_id, p_last_name,
1634 * p_previous_last_name, p_mailstop, p_office_number, p_internal_location,
1635 * p_correspondence_language, p_known_as, p_sex, p_date_of_birth,
1636 * p_email_address, p_employee_number, p_expense_check_send_to_addres,
1637 * p_first_name, p_middle_names, p_national_identifier, p_title,
1638 * p_attribute_category, and p_attribute1-30.
1639 *
1640 * <p><b>Licensing</b><br>
1641 * This API is licensed for use with Human Resources and HR Foundation.
1642 *
1643 * <p><b>Prerequisites</b><br>
1644 * The person must exist in the relevant business group.
1645 *
1646 * <p><b>Post Success</b><br>
1647 * The period of service and default employee assignment are created.
1648 *
1649 * <p><b>Post Failure</b><br>
1650 * The API does not convert the person to an employee and raises an error.
1651 * @param p_validate If true, then validation alone will be performed and the
1652 * database will remain unchanged. If false and all validation checks pass,
1653 * then the database will be modified.
1654 * @param p_hire_date Hire date.
1655 * @param p_person_id Person who is being hired.
1656 * @param p_per_object_version_number Pass in the current version number of the
1657 * person to be updated. When the API completes if p_validate is false, will be
1658 * set to the new version number of the updated person. If p_validate is true
1659 * will be set to the same value which was passed in.
1660 * @param p_person_type_id Type of employee being created.
1661 * @param p_rehire_reason Reason the person is being rehired.
1662 * @param p_assignment_id If p_validate is false, then this uniquely identifies
1663 * the created assignment. If p_validate is true, then set to null.
1664 * @param p_asg_object_version_number If p_validate is false, then this
1665 * parameter is set to the version number of the assignment created. If
1666 * p_validate is true, then this parameter is null.
1667 * @param p_per_effective_start_date If p_validate is false, then set to the
1668 * effective start date on the updated person row which now exists as of the
1669 * effective date. If p_validate is true, then set to null.
1670 * @param p_per_effective_end_date If p_validate is false, then set to the
1671 * effective end date on the updated person row which now exists as of the
1672 * effective date. If p_validate is true, then set to null.
1673 * @param p_assignment_sequence If p_validate is false, then set to the
1674 * sequence number of the default assignment. If p_validate is true, then set
1675 * to null.
1676 * @param p_assignment_number If p_validate is false, then set to the
1677 * assignment number of the default assignment. If p_validate is true, then set
1678 * to null.
1679 * @param p_assign_payroll_warning If set to true, then the date of birth is
1680 * not entered. If set to false, then the date of birth has been entered.
1681 * Indicates if it will be possible to set the payroll on any of this person's
1682 * assignments.
1683 * @rep:displayname Rehire Ex-Employee
1684 * @rep:category BUSINESS_ENTITY PER_EX-EMPLOYEE
1685 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
1686 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1687 * @rep:scope public
1688 * @rep:lifecycle active
1689 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1690 */
1691 --
1692 -- {End Of Comments}
1693 --
1694 procedure re_hire_ex_employee
1695 (p_validate in boolean default false
1696 ,p_hire_date in date
1697 ,p_person_id in number
1698 ,p_per_object_version_number in out nocopy number
1699 ,p_person_type_id in number default hr_api.g_number
1700 ,p_rehire_reason in varchar2
1701 ,p_assignment_id out nocopy number
1702 ,p_asg_object_version_number out nocopy number
1703 ,p_per_effective_start_date out nocopy date
1704 ,p_per_effective_end_date out nocopy date
1705 ,p_assignment_sequence out nocopy number
1706 ,p_assignment_number out nocopy varchar2
1707 ,p_assign_payroll_warning out nocopy boolean
1708 );
1709 --
1710 -- ----------------------------------------------------------------------------
1711 -- |------------------------< apply_for_internal_vacancy >--------------------|
1712 -- ----------------------------------------------------------------------------
1713 --
1714 -- {Start Of Comments}
1715 /*#
1716 * This API converts an existing employee to an applicant.
1717 *
1718 * This API updates employee details and creates an application and a default
1719 * applicant assignment. The process adds the applicant to the security lists
1720 * so that secure users can see the applicant. If you do not specify a
1721 * person_type_id, the API uses the default APL type for the business group.
1722 *
1723 * <p><b>Licensing</b><br>
1724 * This API is licensed for use with Human Resources.
1725 *
1726 * <p><b>Prerequisites</b><br>
1727 * The person must exist in the relevant business group.
1728 *
1729 * <p><b>Post Success</b><br>
1730 * The application, default applicant assignment, and (if required) associated
1731 * assignment budget values and a letter request are created.
1732 *
1733 * <p><b>Post Failure</b><br>
1734 * The API does not convert the employee to an applicant and raises an error.
1735 * @param p_validate If true, then validation alone will be performed and the
1736 * database will remain unchanged. If false and all validation checks pass,
1737 * then the database will be modified.
1738 * @param p_effective_date Determines when the DateTrack operation comes into
1739 * force.
1740 * @param p_person_id Person whose record needs to be modified.
1741 * @param p_applicant_number The business group's applicant number generation
1742 * method determines when the API derives and passes out an applicant number or
1743 * when the calling program should pass in a value. When the API call completes
1744 * if p_validate is true then will be set to the applicant number. If
1745 * p_validate is true then will be set to the passed value.
1746 * @param p_per_object_version_number Pass in the current version number of the
1750 * @param p_vacancy_id Vacancy for which this person has applied.
1747 * person to be updated. When the API completes if p_validate is false, will be
1748 * set to the new version number of the updated person. If p_validate is true
1749 * will be set to the same value which was passed in.
1751 * @param p_person_type_id Type of applicant being created.
1752 * @param p_application_id If p_validate is false, then this uniquely
1753 * identifies the application created. If p_validate is true, then set to null.
1754 * @param p_assignment_id If p_validate is false, then this uniquely identifies
1755 * the created assignment. If p_validate is true, then set to null.
1756 * @param p_apl_object_version_number If p_validate is false, then set to the
1757 * version number of the created application. If p_validate is true, then set
1758 * to null.
1759 * @param p_asg_object_version_number If p_validate is false, then this
1760 * parameter is set to the version number of the assignment created. If
1761 * p_validate is true, then this parameter is null.
1762 * @param p_assignment_sequence If p_validate is false, then set to the
1763 * sequence number of the default assignment. If p_validate is true, then set
1764 * to null.
1765 * @param p_per_effective_start_date If p_validate is false, then set to the
1766 * effective start date on the updated person row which now exists as of the
1767 * effective date. If p_validate is true, then set to null.
1768 * @param p_per_effective_end_date If p_validate is false, then set to the
1769 * effective end date on the updated person row which now exists as of the
1770 * effective date. If p_validate is true, then set to null.
1771 * @rep:displayname Apply For Internal Vacancy
1772 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
1773 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1774 * @rep:scope public
1775 * @rep:lifecycle active
1776 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1777 */
1778 --
1779 -- {End Of Comments}
1780 --
1781 procedure apply_for_internal_vacancy
1782 (p_validate in boolean default false
1783 ,p_effective_date in date
1784 ,p_person_id in number
1785 ,p_applicant_number in out nocopy varchar2
1786 ,p_per_object_version_number in out nocopy number
1787 ,p_vacancy_id in number default null
1788 ,p_person_type_id in number default hr_api.g_number
1789 ,p_application_id out nocopy number
1790 ,p_assignment_id out nocopy number
1791 ,p_apl_object_version_number out nocopy number
1792 ,p_asg_object_version_number out nocopy number
1793 ,p_assignment_sequence out nocopy number
1794 ,p_per_effective_start_date out nocopy date
1795 ,p_per_effective_end_date out nocopy date
1796 );
1797 -- NEW
1798 -- ----------------------------------------------------------------------------
1799 -- |-----------------< apply_for_internal_vacancy >---------------------------|
1800 -- ----------------------------------------------------------------------------
1801 --
1802 -- {Start Of Comments}
1803 --
1804 -- Description:
1805 -- This API updates an employee, system person type 'EMP'
1806 -- to an employee and applicant, system person type 'EMP_APL'.
1807 --
1808 -- A new applicant assignment is created for the employee.
1809 -- An existing application might be updated on effective date or
1810 -- a new one is added.
1811 --
1812 -- The security lists are updated.
1813 --
1814 --
1815 -- Prerequisites:
1816 -- The employee must have a system person type of 'EMP'.
1817 --
1818 -- In Parameters:
1819 -- Name Reqd Type Description
1820 -- p_validate No boolean If true, the database
1821 -- remains unchanged. If false
1822 -- then the employee person type
1823 -- is updated to an 'EMP_APL',
1824 -- an application is a secondary
1825 -- assignment is created in
1826 -- the database.
1827 -- p_effective_date Yes date The effective start date
1828 -- of the new person status,
1829 -- application and secondary
1830 -- assignment.
1831 -- p_person_id Yes number. Person ID.
1832 -- p_applicant_number No varchar2 Applicant number. If the
1833 -- number generation method is
1834 -- Manual then this parameter
1835 -- is mandatory. If the number
1836 -- generation is Automatic, the
1837 -- the value of this parameter
1838 -- defaults to null.
1839 -- p_per_object_version_number Yes number Object version number of
1840 -- person.
1841 -- p_vacancy_id No number Vacancy ID. Defaults to null.
1842 -- p_person_type_id No number Person Type ID of 'EMP_APL'.
1843 -- Defaults to hr_api.g_number.
1844 --
1845 -- Post success:
1846 -- When the person is successfully updated, applicant assignment and
1847 -- application are successfully inserted, the following OUT parameters are
1848 -- set:
1849 --
1850 -- Name Type Description
1851 -- p_per_object_version_number number If p_validate is false, this will
1852 -- be set to the new version number of
1856 -- p_application_id number If p_validate is false, this
1853 -- the person updated. If
1854 -- p_validate is true this parameter
1855 -- will be set to the value passed in.
1857 -- uniquely identifies the application
1858 -- created or updated. If p_validate
1859 -- is true this parameter is null.
1860 -- p_assignment_id number If p_validate is false, this
1861 -- uniquely identifies the assignment
1862 -- created. If p_validate is true
1863 -- this parameter is set null.
1864 -- p_apl_object_version_number number If p_validate is false, this will
1865 -- be set to the version number of
1866 -- the application created. If
1867 -- p_validate is true this parameter
1868 -- is set to null.
1869 -- p_asg_object_version_number number If p_validate is false, this will
1870 -- be set to the version number of
1871 -- the assignment created. If
1872 -- p_validate is true this
1873 -- parameter is set to null.
1874 -- p_assignment_sequence number If p_validate is false, this will
1875 -- be set to the assignment sequence
1876 -- of the assignment created. If
1877 -- p_validate is true, this parameter
1878 -- is set to null.
1879 -- p_per_effective_start_date date If p_validate is false, this is
1880 -- set to the effective start
1881 -- date of the person. If
1882 -- p_validate is true this is
1883 -- null.
1884 -- p_per_effective_end_date date If p_validate is false, this is
1885 -- set to the effective end date
1886 -- of the person. If p_validate
1887 -- is true this is set null.
1888 -- p_appl_override_warning boolean if p_validate is false, this is
1889 -- set to TRUE whenever future
1890 -- applications have been overwritten.
1891 --
1892 -- Post Failure:
1893 -- The API does not update the person or create the applicant assignment
1894 -- or application and raises an error.
1895 --
1896 -- Access Status:
1897 -- Public.
1898 --
1899 -- {End Of Comments}
1900 --
1901 procedure apply_for_internal_vacancy
1902 (p_validate in boolean default false
1903 ,p_effective_date in date
1904 ,p_person_id in number
1905 ,p_applicant_number in out nocopy varchar2
1906 ,p_per_object_version_number in out nocopy number
1907 ,p_vacancy_id in number default null
1908 ,p_person_type_id in number default hr_api.g_number
1909 ,p_application_id out nocopy number
1910 ,p_assignment_id out nocopy number
1911 ,p_apl_object_version_number out nocopy number
1912 ,p_asg_object_version_number out nocopy number
1913 ,p_assignment_sequence out nocopy number
1914 ,p_per_effective_start_date out nocopy date
1915 ,p_per_effective_end_date out nocopy date
1916 ,p_appl_override_warning out nocopy boolean -- 3652025
1917 );
1918 --
1919 -- ----------------------------------------------------------------------------
1920 -- |------------------------------< hire_into_job >---------------------------|
1921 -- ----------------------------------------------------------------------------
1922 --
1923 -- {Start Of Comments}
1924 /*#
1925 * This API hires an applicant as an employee.
1926 *
1927 * This API converts a person of type Applicant to a person of type Employee
1928 * (EMP).
1929 *
1930 * <p><b>Licensing</b><br>
1931 * This API is licensed for use with Human Resources.
1932 *
1933 * <p><b>Prerequisites</b><br>
1934 * The applicant must exist in the relevant business group and must have an
1935 * applicant assignment with the assignment status Accepted. If person_type_id
1936 * is supplied, it must have a corresponding system person type of EMP and must
1937 * be active in the same business group as the applicant being changed to
1938 * employee.
1939 *
1940 * <p><b>Post Success</b><br>
1941 * The applicant has been successfully hired as an employee with a default
1942 * employee assignment.
1943 *
1944 * <p><b>Post Failure</b><br>
1945 * The applicant is not hired as an employee and an error is raised.
1946 * @param p_validate If true, then validation alone will be performed and the
1947 * database will remain unchanged. If false and all validation checks pass,
1948 * then the database will be modified.
1949 * @param p_effective_date Determines when the DateTrack operation comes into
1950 * force.
1951 * @param p_person_id Person who is being hired.
1952 * @param p_object_version_number Pass in the current version number of the
1953 * person to be updated. When the API completes if p_validate is false, will be
1957 * method determines when the API derives and passes out an employee number or
1954 * set to the new version number of the updated person. If p_validate is true
1955 * will be set to the same value which was passed in.
1956 * @param p_employee_number The business group's employee number generation
1958 * when the calling program should pass in a value. When the API call completes
1959 * if p_validate is false then will be set to the employee number. If
1960 * p_validate is true then will be set to the passed value.
1961 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
1962 * updating the record. You must set to either UPDATE, CORRECTION,
1963 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
1964 * particular record depend on the dates of previous record changes and the
1965 * effective date of this change.
1966 * @param p_person_type_id Type of employee being created.
1967 * @param p_national_identifier Number by which a person is identified in a
1968 * given legislation.
1969 * @param p_per_information7 Developer descriptive flexfield segment.
1970 * @param p_effective_start_date If p_validate is false, then set to the
1971 * effective start date on the updated person row which now exists as of the
1972 * effective date. If p_validate is true, then set to null.
1973 * @param p_effective_end_date If p_validate is false, then set to the
1974 * effective end date on the updated person row which now exists as of the
1975 * effective date. If p_validate is true, then set to null.
1976 * @param p_assign_payroll_warning If set to true, then the date of birth is
1977 * not entered. If set to false, then the date of birth has been entered.
1978 * Indicates if it will be possible to set the payroll on any of this person's
1979 * assignments.
1980 * @param p_orig_hire_warning If set to true, an orginal date of hire exists
1981 * for an applicant who has never been an employee.
1982 * @rep:displayname Hire Into Job
1983 * @rep:category BUSINESS_ENTITY PER_EMPLOYEE
1984 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
1985 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1986 * @rep:scope public
1987 * @rep:lifecycle active
1988 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1989 */
1990 --
1991 -- {End Of Comments}
1992 --
1993 PROCEDURE hire_into_job
1994 (p_validate IN BOOLEAN DEFAULT FALSE
1995 ,p_effective_date IN DATE
1996 ,p_person_id IN NUMBER
1997 ,p_object_version_number IN OUT NOCOPY NUMBER
1998 ,p_employee_number IN OUT NOCOPY VARCHAR2
1999 ,p_datetrack_update_mode IN VARCHAR2 DEFAULT NULL
2000 ,p_person_type_id IN NUMBER DEFAULT NULL
2001 ,p_national_identifier IN VARCHAR2 DEFAULT NULL
2002 ,p_per_information7 IN VARCHAR2 DEFAULT NULL --3414274
2003 ,p_effective_start_date OUT NOCOPY DATE
2004 ,p_effective_end_date OUT NOCOPY DATE
2005 ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
2006 ,p_orig_hire_warning OUT NOCOPY BOOLEAN
2007 );
2008 --
2009 -- -----------------------------------------------------------------------------
2010 -- |----------------------------< hire_into_job - new >------------------------|
2011 -- -----------------------------------------------------------------------------
2012 --
2013 -- {Start Of Comments}
2014 --
2015 -- Description:
2016 -- This business process converts a person of type EX_APL, EX_EMP or OTHER to
2017 -- a type of EMP.
2018 -- This is achieved by
2019 -- Setting the person type to EMP
2020 -- Creating a period of service
2021 -- Creating a default employee assignment
2022 -- Repopulating the security lists
2023 --
2024 -- In Parameters:
2025 -- Name Reqd Type Description
2026 -- p_validate No boolean If true, the database remains
2027 -- unchanged. If false a valid
2028 -- assignment is updated in
2029 -- the database.
2030 -- p_effective_date Yes date Effective date of the change
2031 -- of status.
2032 -- p_person_id Yes number Person to become an applicant.
2033 -- p_per_object_version_number Yes number Version number of the person
2034 -- record.
2035 -- p_datetrack_update_mode No varchar2 Datetrack update mode. Only
2036 -- applicable if hiring a person of
2037 -- type OTHER, when the values of
2038 -- Update or Correction may be used.
2039 -- If not set a value of Update is
2040 -- used. In all other cases this
2041 -- value is ignored and a value of
2042 -- Update used.
2043 -- p_employee_number No varchar2 Employee number. Ignored if
2044 -- the person already has an
2045 -- employee number. Required if
2046 -- the number generation method
2047 -- is manual. Must be NULL if the
2048 -- number generation method is
2049 -- automatic.
2050 -- p_person_type_id No number Person type id the person is to
2051 -- become. If this value is
2055 -- business group is used.
2052 -- omitted the person type id
2053 -- of the default system person
2054 -- type required in the person's
2056 -- p_national_identifier No varchar2 The national identifier.
2057 -- p_per_information7 No Varchar2 Hire status of the Hired
2058 -- person. This is used to
2059 -- determine whether the person
2060 -- has to included into
2061 -- New Hire Report, PERUSHIR.
2062 -- This is valid for
2063 -- US legislation.
2064 --
2065 -- Post Success:
2066 -- The API updates the person and application and set the following out
2067 -- parameters:
2068 --
2069 -- Name Type Description
2070 -- p_per_object_version_number number If p_validate is false, set to
2071 -- the new version number of the
2072 -- person record. If p_validate is
2073 -- true, set to the value passed in.
2074 -- p_employee_number number If p_validate is false, set to the
2075 -- employee number of the person. If
2076 -- p_validate is true, set to the
2077 -- value passed in.
2078 -- p_assignment_id number If p_validate is false, set to the
2079 -- assignment_id for the person.
2080 -- p_effective_start_date date If p_validate is false, set to
2081 -- the effective start date of the
2082 -- updated person record. If
2083 -- p_validate is true, set to null.
2084 -- p_effective_end_date date If p_validate is false, set to
2085 -- the effective end date of the
2086 -- updated person record. If
2087 -- p_validate is true, set to null.
2088 -- p_assign_payroll_warning boolean Set to true if the person's date of
2089 -- birth has not been set. Set to
2090 -- false if the date of birth has been
2091 -- entered. Indicates if it will be
2092 -- possible to set the payroll
2093 -- component on any of this person's
2094 -- assignments.
2095 -- p_orig_hire_warning boolean Set to true if the original date of
2096 -- hire is not null and the person
2097 -- type is not EMP, EMP_APL, EX_EMP or
2098 -- EX_EMP_APL.
2099 --
2100 -- Post Failure:
2101 -- The API does not update the person and period of service and raises an error.
2102 --
2103 -- Access Status:
2104 -- Public.
2105 --
2106 -- {End Of Comments}
2107 --
2108 PROCEDURE hire_into_job
2109 (p_validate IN BOOLEAN DEFAULT FALSE
2110 ,p_effective_date IN DATE
2111 ,p_person_id IN NUMBER
2112 ,p_object_version_number IN OUT NOCOPY NUMBER
2113 ,p_employee_number IN OUT NOCOPY VARCHAR2
2114 ,p_datetrack_update_mode IN VARCHAR2 DEFAULT NULL
2115 ,p_person_type_id IN NUMBER DEFAULT NULL
2116 ,p_national_identifier IN VARCHAR2 DEFAULT NULL
2117 ,p_per_information7 IN VARCHAR2 DEFAULT NULL --3414274
2118 ,p_assignment_id OUT NOCOPY NUMBER -- Bug#3919096
2119 ,p_effective_start_date OUT NOCOPY DATE
2120 ,p_effective_end_date OUT NOCOPY DATE
2121 ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
2122 ,p_orig_hire_warning OUT NOCOPY BOOLEAN
2123 );
2124 --
2125 -- 115.30 (START)
2126 --
2127 -- ----------------------------------------------------------------------------
2128 -- |-----------------------< MANAGE_REHIRE_PRIMARY_ASGS >---------------------|
2129 -- ----------------------------------------------------------------------------
2130 -- {Start Of Comments}
2131 --
2132 -- Description: This procedure manages the switching of the primary but
2133 -- terminated terminated assignment of an employee on the old
2134 -- period of service to a secondary assignment during rehire
2135 -- and swithcing it back should the rehire be cancelled.
2136 --
2137 -- Prerequisites: None
2138 --
2139 -- In Parameters:
2140 -- Name Reqd Type Description
2141 -- P_PERSON_ID Yes NUMBER Person Identifier
2142 -- P_REHIRE_DATE Yes DATE Employee Re-hire date
2143 -- P_CANCEL Yes VARCHAR2 Flags whether rehire or cancel
2144 -- rehire invocation.
2145 --
2146 -- Post Success:
2147 -- The TERM_ASSIGN assignment record will be flipped from primary to
2148 -- secondary if rehire before FPD and flipped back to primary if the
2149 -- rehire is being cancelled.
2150 --
2151 -- Name Type Description
2152 -- - - -
2153 -- Post Failure:
2154 -- An exception will be raised depending on the nature of failure.
2155 --
2156 -- Access Status:
2157 -- Internal Development Use Only.
2158 --
2159 -- {End Of Comments}
2160 --
2161 procedure manage_rehire_primary_asgs
2162 (p_person_id in number
2163 ,p_rehire_date in date
2164 ,p_cancel in varchar2
2165 );
2166 --
2167 -- 115.30 (END)
2168 --
2169 end hr_employee_api;
[Home] [Help]