DBA Data[Home] [Help]

PACKAGE BODY: APPS.HR_EMPLOYEE_BK1

Source


1 package body HR_EMPLOYEE_BK1 as
2 /* $Header: peempapi.pkb 120.8 2007/11/05 14:52:21 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:53:56 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_EMPLOYEE_A
6 (P_HIRE_DATE in DATE
7 ,P_BUSINESS_GROUP_ID in NUMBER
8 ,P_LAST_NAME in VARCHAR2
9 ,P_SEX in VARCHAR2
10 ,P_PERSON_TYPE_ID in NUMBER
11 ,P_PER_COMMENTS in VARCHAR2
12 ,P_DATE_EMPLOYEE_DATA_VERIFIED in DATE
13 ,P_DATE_OF_BIRTH in DATE
14 ,P_EMAIL_ADDRESS in VARCHAR2
15 ,P_EMPLOYEE_NUMBER in VARCHAR2
16 ,P_EXPENSE_CHECK_SEND_TO_ADDRES in VARCHAR2
17 ,P_FIRST_NAME in VARCHAR2
18 ,P_KNOWN_AS in VARCHAR2
19 ,P_MARITAL_STATUS in VARCHAR2
20 ,P_MIDDLE_NAMES in VARCHAR2
21 ,P_NATIONALITY in VARCHAR2
22 ,P_NATIONAL_IDENTIFIER in VARCHAR2
23 ,P_PREVIOUS_LAST_NAME in VARCHAR2
24 ,P_REGISTERED_DISABLED_FLAG in VARCHAR2
25 ,P_TITLE in VARCHAR2
26 ,P_VENDOR_ID in NUMBER
27 ,P_WORK_TELEPHONE in VARCHAR2
28 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
29 ,P_ATTRIBUTE1 in VARCHAR2
30 ,P_ATTRIBUTE2 in VARCHAR2
31 ,P_ATTRIBUTE3 in VARCHAR2
32 ,P_ATTRIBUTE4 in VARCHAR2
33 ,P_ATTRIBUTE5 in VARCHAR2
34 ,P_ATTRIBUTE6 in VARCHAR2
35 ,P_ATTRIBUTE7 in VARCHAR2
36 ,P_ATTRIBUTE8 in VARCHAR2
37 ,P_ATTRIBUTE9 in VARCHAR2
38 ,P_ATTRIBUTE10 in VARCHAR2
39 ,P_ATTRIBUTE11 in VARCHAR2
40 ,P_ATTRIBUTE12 in VARCHAR2
41 ,P_ATTRIBUTE13 in VARCHAR2
42 ,P_ATTRIBUTE14 in VARCHAR2
43 ,P_ATTRIBUTE15 in VARCHAR2
44 ,P_ATTRIBUTE16 in VARCHAR2
45 ,P_ATTRIBUTE17 in VARCHAR2
46 ,P_ATTRIBUTE18 in VARCHAR2
47 ,P_ATTRIBUTE19 in VARCHAR2
48 ,P_ATTRIBUTE20 in VARCHAR2
49 ,P_ATTRIBUTE21 in VARCHAR2
50 ,P_ATTRIBUTE22 in VARCHAR2
51 ,P_ATTRIBUTE23 in VARCHAR2
52 ,P_ATTRIBUTE24 in VARCHAR2
53 ,P_ATTRIBUTE25 in VARCHAR2
54 ,P_ATTRIBUTE26 in VARCHAR2
55 ,P_ATTRIBUTE27 in VARCHAR2
56 ,P_ATTRIBUTE28 in VARCHAR2
57 ,P_ATTRIBUTE29 in VARCHAR2
58 ,P_ATTRIBUTE30 in VARCHAR2
59 ,P_PER_INFORMATION_CATEGORY in VARCHAR2
60 ,P_PER_INFORMATION1 in VARCHAR2
61 ,P_PER_INFORMATION2 in VARCHAR2
62 ,P_PER_INFORMATION3 in VARCHAR2
63 ,P_PER_INFORMATION4 in VARCHAR2
64 ,P_PER_INFORMATION5 in VARCHAR2
65 ,P_PER_INFORMATION6 in VARCHAR2
66 ,P_PER_INFORMATION7 in VARCHAR2
67 ,P_PER_INFORMATION8 in VARCHAR2
68 ,P_PER_INFORMATION9 in VARCHAR2
69 ,P_PER_INFORMATION10 in VARCHAR2
70 ,P_PER_INFORMATION11 in VARCHAR2
71 ,P_PER_INFORMATION12 in VARCHAR2
72 ,P_PER_INFORMATION13 in VARCHAR2
73 ,P_PER_INFORMATION14 in VARCHAR2
74 ,P_PER_INFORMATION15 in VARCHAR2
75 ,P_PER_INFORMATION16 in VARCHAR2
76 ,P_PER_INFORMATION17 in VARCHAR2
77 ,P_PER_INFORMATION18 in VARCHAR2
78 ,P_PER_INFORMATION19 in VARCHAR2
79 ,P_PER_INFORMATION20 in VARCHAR2
80 ,P_PER_INFORMATION21 in VARCHAR2
81 ,P_PER_INFORMATION22 in VARCHAR2
82 ,P_PER_INFORMATION23 in VARCHAR2
83 ,P_PER_INFORMATION24 in VARCHAR2
84 ,P_PER_INFORMATION25 in VARCHAR2
85 ,P_PER_INFORMATION26 in VARCHAR2
86 ,P_PER_INFORMATION27 in VARCHAR2
87 ,P_PER_INFORMATION28 in VARCHAR2
88 ,P_PER_INFORMATION29 in VARCHAR2
89 ,P_PER_INFORMATION30 in VARCHAR2
90 ,P_DATE_OF_DEATH in DATE
91 ,P_BACKGROUND_CHECK_STATUS in VARCHAR2
92 ,P_BACKGROUND_DATE_CHECK in DATE
93 ,P_BLOOD_TYPE in VARCHAR2
94 ,P_CORRESPONDENCE_LANGUAGE in VARCHAR2
95 ,P_FAST_PATH_EMPLOYEE in VARCHAR2
96 ,P_FTE_CAPACITY in NUMBER
97 ,P_HONORS in VARCHAR2
98 ,P_INTERNAL_LOCATION in VARCHAR2
99 ,P_LAST_MEDICAL_TEST_BY in VARCHAR2
100 ,P_LAST_MEDICAL_TEST_DATE in DATE
101 ,P_MAILSTOP in VARCHAR2
102 ,P_OFFICE_NUMBER in VARCHAR2
103 ,P_ON_MILITARY_SERVICE in VARCHAR2
104 ,P_PRE_NAME_ADJUNCT in VARCHAR2
105 ,P_REHIRE_RECOMMENDATION in VARCHAR2
106 ,P_PROJECTED_START_DATE in DATE
107 ,P_RESUME_EXISTS in VARCHAR2
108 ,P_RESUME_LAST_UPDATED in DATE
109 ,P_SECOND_PASSPORT_EXISTS in VARCHAR2
110 ,P_STUDENT_STATUS in VARCHAR2
111 ,P_WORK_SCHEDULE in VARCHAR2
112 ,P_SUFFIX in VARCHAR2
113 ,P_BENEFIT_GROUP_ID in NUMBER
114 ,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
115 ,P_COORD_BEN_MED_PLN_NO in VARCHAR2
116 ,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
117 ,P_COORD_BEN_MED_EXT_ER in VARCHAR2
118 ,P_COORD_BEN_MED_PL_NAME in VARCHAR2
119 ,P_COORD_BEN_MED_INSR_CRR_NAME in VARCHAR2
120 ,P_COORD_BEN_MED_INSR_CRR_IDENT in VARCHAR2
121 ,P_COORD_BEN_MED_CVG_STRT_DT in DATE
122 ,P_COORD_BEN_MED_CVG_END_DT in DATE
123 ,P_USES_TOBACCO_FLAG in VARCHAR2
124 ,P_DPDNT_ADOPTION_DATE in DATE
125 ,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
126 ,P_ORIGINAL_DATE_OF_HIRE in DATE
127 ,P_ADJUSTED_SVC_DATE in DATE
128 ,P_PERSON_ID in NUMBER
129 ,P_ASSIGNMENT_ID in NUMBER
130 ,P_PER_OBJECT_VERSION_NUMBER in NUMBER
131 ,P_ASG_OBJECT_VERSION_NUMBER in NUMBER
132 ,P_PER_EFFECTIVE_START_DATE in DATE
133 ,P_PER_EFFECTIVE_END_DATE in DATE
134 ,P_FULL_NAME in VARCHAR2
135 ,P_PER_COMMENT_ID in NUMBER
136 ,P_ASSIGNMENT_SEQUENCE in NUMBER
137 ,P_ASSIGNMENT_NUMBER in VARCHAR2
138 ,P_TOWN_OF_BIRTH in VARCHAR2
139 ,P_REGION_OF_BIRTH in VARCHAR2
140 ,P_COUNTRY_OF_BIRTH in VARCHAR2
141 ,P_GLOBAL_PERSON_ID in VARCHAR2
142 ,P_PARTY_ID in NUMBER
143 ,P_NAME_COMBINATION_WARNING in BOOLEAN
144 ,P_ASSIGN_PAYROLL_WARNING in BOOLEAN
145 ,P_ORIG_HIRE_WARNING in BOOLEAN
146 )is
147 l_commit_unit_number number;
148 l_legislation_code   varchar2(30);
149 begin
150 hr_utility.set_location('Entering: HR_EMPLOYEE_BK1.CREATE_EMPLOYEE_A', 10);
151 l_commit_unit_number := hr_api.return_commit_unit;
152 if hr_api.call_app_hooks then
153 hr_employee_be1.CREATE_EMPLOYEE_A
154 (P_HIRE_DATE => P_HIRE_DATE
155 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
156 ,P_LAST_NAME => P_LAST_NAME
157 ,P_SEX => P_SEX
158 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
159 ,P_PER_COMMENTS => P_PER_COMMENTS
160 ,P_DATE_EMPLOYEE_DATA_VERIFIED => P_DATE_EMPLOYEE_DATA_VERIFIED
161 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
162 ,P_EMAIL_ADDRESS => P_EMAIL_ADDRESS
163 ,P_EMPLOYEE_NUMBER => P_EMPLOYEE_NUMBER
164 ,P_EXPENSE_CHECK_SEND_TO_ADDRES => P_EXPENSE_CHECK_SEND_TO_ADDRES
165 ,P_FIRST_NAME => P_FIRST_NAME
166 ,P_KNOWN_AS => P_KNOWN_AS
167 ,P_MARITAL_STATUS => P_MARITAL_STATUS
168 ,P_MIDDLE_NAMES => P_MIDDLE_NAMES
169 ,P_NATIONALITY => P_NATIONALITY
170 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
171 ,P_PREVIOUS_LAST_NAME => P_PREVIOUS_LAST_NAME
172 ,P_REGISTERED_DISABLED_FLAG => P_REGISTERED_DISABLED_FLAG
173 ,P_TITLE => P_TITLE
174 ,P_VENDOR_ID => P_VENDOR_ID
175 ,P_WORK_TELEPHONE => P_WORK_TELEPHONE
176 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
177 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
178 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
179 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
180 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
181 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
182 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
183 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
184 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
185 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
186 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
187 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
188 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
189 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
190 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
191 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
192 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
193 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
194 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
195 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
196 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
197 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
198 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
199 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
200 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
201 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
202 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
203 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
204 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
205 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
206 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
207 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
208 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
209 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
210 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
211 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
212 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
213 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
214 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
215 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
216 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
217 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
218 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
219 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
220 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
221 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
222 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
223 ,P_PER_INFORMATION16 => P_PER_INFORMATION16
224 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
225 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
226 ,P_PER_INFORMATION19 => P_PER_INFORMATION19
227 ,P_PER_INFORMATION20 => P_PER_INFORMATION20
228 ,P_PER_INFORMATION21 => P_PER_INFORMATION21
229 ,P_PER_INFORMATION22 => P_PER_INFORMATION22
230 ,P_PER_INFORMATION23 => P_PER_INFORMATION23
231 ,P_PER_INFORMATION24 => P_PER_INFORMATION24
232 ,P_PER_INFORMATION25 => P_PER_INFORMATION25
233 ,P_PER_INFORMATION26 => P_PER_INFORMATION26
234 ,P_PER_INFORMATION27 => P_PER_INFORMATION27
235 ,P_PER_INFORMATION28 => P_PER_INFORMATION28
236 ,P_PER_INFORMATION29 => P_PER_INFORMATION29
237 ,P_PER_INFORMATION30 => P_PER_INFORMATION30
238 ,P_DATE_OF_DEATH => P_DATE_OF_DEATH
239 ,P_BACKGROUND_CHECK_STATUS => P_BACKGROUND_CHECK_STATUS
240 ,P_BACKGROUND_DATE_CHECK => P_BACKGROUND_DATE_CHECK
241 ,P_BLOOD_TYPE => P_BLOOD_TYPE
242 ,P_CORRESPONDENCE_LANGUAGE => P_CORRESPONDENCE_LANGUAGE
243 ,P_FAST_PATH_EMPLOYEE => P_FAST_PATH_EMPLOYEE
244 ,P_FTE_CAPACITY => P_FTE_CAPACITY
245 ,P_HONORS => P_HONORS
246 ,P_INTERNAL_LOCATION => P_INTERNAL_LOCATION
247 ,P_LAST_MEDICAL_TEST_BY => P_LAST_MEDICAL_TEST_BY
248 ,P_LAST_MEDICAL_TEST_DATE => P_LAST_MEDICAL_TEST_DATE
249 ,P_MAILSTOP => P_MAILSTOP
250 ,P_OFFICE_NUMBER => P_OFFICE_NUMBER
251 ,P_ON_MILITARY_SERVICE => P_ON_MILITARY_SERVICE
252 ,P_PRE_NAME_ADJUNCT => P_PRE_NAME_ADJUNCT
253 ,P_REHIRE_RECOMMENDATION => P_REHIRE_RECOMMENDATION
254 ,P_PROJECTED_START_DATE => P_PROJECTED_START_DATE
255 ,P_RESUME_EXISTS => P_RESUME_EXISTS
256 ,P_RESUME_LAST_UPDATED => P_RESUME_LAST_UPDATED
257 ,P_SECOND_PASSPORT_EXISTS => P_SECOND_PASSPORT_EXISTS
258 ,P_STUDENT_STATUS => P_STUDENT_STATUS
259 ,P_WORK_SCHEDULE => P_WORK_SCHEDULE
260 ,P_SUFFIX => P_SUFFIX
261 ,P_BENEFIT_GROUP_ID => P_BENEFIT_GROUP_ID
262 ,P_RECEIPT_OF_DEATH_CERT_DATE => P_RECEIPT_OF_DEATH_CERT_DATE
263 ,P_COORD_BEN_MED_PLN_NO => P_COORD_BEN_MED_PLN_NO
264 ,P_COORD_BEN_NO_CVG_FLAG => P_COORD_BEN_NO_CVG_FLAG
265 ,P_COORD_BEN_MED_EXT_ER => P_COORD_BEN_MED_EXT_ER
266 ,P_COORD_BEN_MED_PL_NAME => P_COORD_BEN_MED_PL_NAME
267 ,P_COORD_BEN_MED_INSR_CRR_NAME => P_COORD_BEN_MED_INSR_CRR_NAME
268 ,P_COORD_BEN_MED_INSR_CRR_IDENT => P_COORD_BEN_MED_INSR_CRR_IDENT
269 ,P_COORD_BEN_MED_CVG_STRT_DT => P_COORD_BEN_MED_CVG_STRT_DT
270 ,P_COORD_BEN_MED_CVG_END_DT => P_COORD_BEN_MED_CVG_END_DT
271 ,P_USES_TOBACCO_FLAG => P_USES_TOBACCO_FLAG
272 ,P_DPDNT_ADOPTION_DATE => P_DPDNT_ADOPTION_DATE
273 ,P_DPDNT_VLNTRY_SVCE_FLAG => P_DPDNT_VLNTRY_SVCE_FLAG
274 ,P_ORIGINAL_DATE_OF_HIRE => P_ORIGINAL_DATE_OF_HIRE
275 ,P_ADJUSTED_SVC_DATE => P_ADJUSTED_SVC_DATE
276 ,P_PERSON_ID => P_PERSON_ID
277 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
278 ,P_PER_OBJECT_VERSION_NUMBER => P_PER_OBJECT_VERSION_NUMBER
279 ,P_ASG_OBJECT_VERSION_NUMBER => P_ASG_OBJECT_VERSION_NUMBER
280 ,P_PER_EFFECTIVE_START_DATE => P_PER_EFFECTIVE_START_DATE
281 ,P_PER_EFFECTIVE_END_DATE => P_PER_EFFECTIVE_END_DATE
282 ,P_FULL_NAME => P_FULL_NAME
283 ,P_PER_COMMENT_ID => P_PER_COMMENT_ID
284 ,P_ASSIGNMENT_SEQUENCE => P_ASSIGNMENT_SEQUENCE
285 ,P_ASSIGNMENT_NUMBER => P_ASSIGNMENT_NUMBER
286 ,P_TOWN_OF_BIRTH => P_TOWN_OF_BIRTH
287 ,P_REGION_OF_BIRTH => P_REGION_OF_BIRTH
288 ,P_COUNTRY_OF_BIRTH => P_COUNTRY_OF_BIRTH
289 ,P_GLOBAL_PERSON_ID => P_GLOBAL_PERSON_ID
290 ,P_PARTY_ID => P_PARTY_ID
291 ,P_NAME_COMBINATION_WARNING => P_NAME_COMBINATION_WARNING
292 ,P_ASSIGN_PAYROLL_WARNING => P_ASSIGN_PAYROLL_WARNING
293 ,P_ORIG_HIRE_WARNING => P_ORIG_HIRE_WARNING
294 );
295 end if;
296 if hr_api.call_leg_hooks then
297 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
298 if l_legislation_code = 'MX' then
299 PER_MX_VALIDATE_ID.VALIDATE_RFC_ID
300 (P_PER_INFORMATION2 => P_PER_INFORMATION2
301 ,P_PERSON_ID => P_PERSON_ID
302 );
303 PER_MX_VALIDATE_ID.VALIDATE_SS_ID
304 (P_PER_INFORMATION3 => P_PER_INFORMATION3
305 ,P_PERSON_ID => P_PERSON_ID
306 );
307 PER_MX_VALIDATE_ID.VALIDATE_FGA_ID
308 (P_PER_INFORMATION5 => P_PER_INFORMATION5
309 ,P_PERSON_ID => P_PERSON_ID
310 );
311 PER_MX_VALIDATE_ID.VALIDATE_MS_ID
312 (P_PER_INFORMATION6 => P_PER_INFORMATION6
313 ,P_PERSON_ID => P_PERSON_ID
314 );
315 PER_MX_VALIDATE_ID.VALIDATE_IMC_ID
316 (P_PER_INFORMATION4 => P_PER_INFORMATION4
317 );
318 elsif l_legislation_code = 'US' then
319 PER_US_EMPLOYEE_LEG_HOOK.CHECK_NEW_HIRE
320 (P_PERSON_ID => P_PERSON_ID
321 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
322 );
323 end if;
324 end if;
325 hr_multi_message.end_validation_set;
326 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_EMPLOYEE', 'AP');
327 hr_utility.set_location(' Leaving: HR_EMPLOYEE_BK1.CREATE_EMPLOYEE_A', 20);
328 end CREATE_EMPLOYEE_A;
329 procedure CREATE_EMPLOYEE_B
330 (P_HIRE_DATE in DATE
331 ,P_BUSINESS_GROUP_ID in NUMBER
332 ,P_LAST_NAME in VARCHAR2
333 ,P_SEX in VARCHAR2
334 ,P_PERSON_TYPE_ID in NUMBER
335 ,P_PER_COMMENTS in VARCHAR2
336 ,P_DATE_EMPLOYEE_DATA_VERIFIED in DATE
337 ,P_DATE_OF_BIRTH in DATE
338 ,P_EMAIL_ADDRESS in VARCHAR2
339 ,P_EMPLOYEE_NUMBER in VARCHAR2
340 ,P_EXPENSE_CHECK_SEND_TO_ADDRES in VARCHAR2
341 ,P_FIRST_NAME in VARCHAR2
342 ,P_KNOWN_AS in VARCHAR2
343 ,P_MARITAL_STATUS in VARCHAR2
344 ,P_MIDDLE_NAMES in VARCHAR2
345 ,P_NATIONALITY in VARCHAR2
346 ,P_NATIONAL_IDENTIFIER in VARCHAR2
347 ,P_PREVIOUS_LAST_NAME in VARCHAR2
348 ,P_REGISTERED_DISABLED_FLAG in VARCHAR2
349 ,P_TITLE in VARCHAR2
350 ,P_VENDOR_ID in NUMBER
351 ,P_WORK_TELEPHONE in VARCHAR2
352 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
353 ,P_ATTRIBUTE1 in VARCHAR2
354 ,P_ATTRIBUTE2 in VARCHAR2
355 ,P_ATTRIBUTE3 in VARCHAR2
356 ,P_ATTRIBUTE4 in VARCHAR2
357 ,P_ATTRIBUTE5 in VARCHAR2
358 ,P_ATTRIBUTE6 in VARCHAR2
359 ,P_ATTRIBUTE7 in VARCHAR2
360 ,P_ATTRIBUTE8 in VARCHAR2
361 ,P_ATTRIBUTE9 in VARCHAR2
362 ,P_ATTRIBUTE10 in VARCHAR2
363 ,P_ATTRIBUTE11 in VARCHAR2
364 ,P_ATTRIBUTE12 in VARCHAR2
365 ,P_ATTRIBUTE13 in VARCHAR2
366 ,P_ATTRIBUTE14 in VARCHAR2
367 ,P_ATTRIBUTE15 in VARCHAR2
368 ,P_ATTRIBUTE16 in VARCHAR2
369 ,P_ATTRIBUTE17 in VARCHAR2
370 ,P_ATTRIBUTE18 in VARCHAR2
371 ,P_ATTRIBUTE19 in VARCHAR2
372 ,P_ATTRIBUTE20 in VARCHAR2
373 ,P_ATTRIBUTE21 in VARCHAR2
374 ,P_ATTRIBUTE22 in VARCHAR2
375 ,P_ATTRIBUTE23 in VARCHAR2
376 ,P_ATTRIBUTE24 in VARCHAR2
377 ,P_ATTRIBUTE25 in VARCHAR2
378 ,P_ATTRIBUTE26 in VARCHAR2
379 ,P_ATTRIBUTE27 in VARCHAR2
380 ,P_ATTRIBUTE28 in VARCHAR2
381 ,P_ATTRIBUTE29 in VARCHAR2
382 ,P_ATTRIBUTE30 in VARCHAR2
383 ,P_PER_INFORMATION_CATEGORY in VARCHAR2
384 ,P_PER_INFORMATION1 in VARCHAR2
385 ,P_PER_INFORMATION2 in VARCHAR2
386 ,P_PER_INFORMATION3 in VARCHAR2
387 ,P_PER_INFORMATION4 in VARCHAR2
388 ,P_PER_INFORMATION5 in VARCHAR2
389 ,P_PER_INFORMATION6 in VARCHAR2
390 ,P_PER_INFORMATION7 in VARCHAR2
391 ,P_PER_INFORMATION8 in VARCHAR2
392 ,P_PER_INFORMATION9 in VARCHAR2
393 ,P_PER_INFORMATION10 in VARCHAR2
394 ,P_PER_INFORMATION11 in VARCHAR2
395 ,P_PER_INFORMATION12 in VARCHAR2
396 ,P_PER_INFORMATION13 in VARCHAR2
397 ,P_PER_INFORMATION14 in VARCHAR2
398 ,P_PER_INFORMATION15 in VARCHAR2
399 ,P_PER_INFORMATION16 in VARCHAR2
400 ,P_PER_INFORMATION17 in VARCHAR2
401 ,P_PER_INFORMATION18 in VARCHAR2
402 ,P_PER_INFORMATION19 in VARCHAR2
403 ,P_PER_INFORMATION20 in VARCHAR2
404 ,P_PER_INFORMATION21 in VARCHAR2
405 ,P_PER_INFORMATION22 in VARCHAR2
406 ,P_PER_INFORMATION23 in VARCHAR2
407 ,P_PER_INFORMATION24 in VARCHAR2
408 ,P_PER_INFORMATION25 in VARCHAR2
409 ,P_PER_INFORMATION26 in VARCHAR2
410 ,P_PER_INFORMATION27 in VARCHAR2
411 ,P_PER_INFORMATION28 in VARCHAR2
412 ,P_PER_INFORMATION29 in VARCHAR2
413 ,P_PER_INFORMATION30 in VARCHAR2
414 ,P_DATE_OF_DEATH in DATE
415 ,P_BACKGROUND_CHECK_STATUS in VARCHAR2
416 ,P_BACKGROUND_DATE_CHECK in DATE
417 ,P_BLOOD_TYPE in VARCHAR2
418 ,P_CORRESPONDENCE_LANGUAGE in VARCHAR2
419 ,P_FAST_PATH_EMPLOYEE in VARCHAR2
420 ,P_FTE_CAPACITY in NUMBER
421 ,P_HONORS in VARCHAR2
422 ,P_INTERNAL_LOCATION in VARCHAR2
423 ,P_LAST_MEDICAL_TEST_BY in VARCHAR2
424 ,P_LAST_MEDICAL_TEST_DATE in DATE
425 ,P_MAILSTOP in VARCHAR2
426 ,P_OFFICE_NUMBER in VARCHAR2
427 ,P_ON_MILITARY_SERVICE in VARCHAR2
428 ,P_PRE_NAME_ADJUNCT in VARCHAR2
429 ,P_REHIRE_RECOMMENDATION in VARCHAR2
430 ,P_PROJECTED_START_DATE in DATE
431 ,P_RESUME_EXISTS in VARCHAR2
432 ,P_RESUME_LAST_UPDATED in DATE
433 ,P_SECOND_PASSPORT_EXISTS in VARCHAR2
434 ,P_STUDENT_STATUS in VARCHAR2
435 ,P_WORK_SCHEDULE in VARCHAR2
436 ,P_SUFFIX in VARCHAR2
437 ,P_BENEFIT_GROUP_ID in NUMBER
438 ,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
439 ,P_COORD_BEN_MED_PLN_NO in VARCHAR2
440 ,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
441 ,P_COORD_BEN_MED_EXT_ER in VARCHAR2
442 ,P_COORD_BEN_MED_PL_NAME in VARCHAR2
443 ,P_COORD_BEN_MED_INSR_CRR_NAME in VARCHAR2
444 ,P_COORD_BEN_MED_INSR_CRR_IDENT in VARCHAR2
445 ,P_COORD_BEN_MED_CVG_STRT_DT in DATE
446 ,P_COORD_BEN_MED_CVG_END_DT in DATE
447 ,P_USES_TOBACCO_FLAG in VARCHAR2
448 ,P_DPDNT_ADOPTION_DATE in DATE
449 ,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
450 ,P_ORIGINAL_DATE_OF_HIRE in DATE
451 ,P_ADJUSTED_SVC_DATE in DATE
452 ,P_TOWN_OF_BIRTH in VARCHAR2
453 ,P_REGION_OF_BIRTH in VARCHAR2
454 ,P_COUNTRY_OF_BIRTH in VARCHAR2
455 ,P_GLOBAL_PERSON_ID in VARCHAR2
456 ,P_PARTY_ID in NUMBER
457 )is
458 l_commit_unit_number number;
459 l_legislation_code   varchar2(30);
460 begin
461 hr_utility.set_location('Entering: HR_EMPLOYEE_BK1.CREATE_EMPLOYEE_B', 10);
462 l_commit_unit_number := hr_api.return_commit_unit;
463 if hr_api.call_leg_hooks then
464 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
465 if l_legislation_code = 'AE' then
466 HR_AE_VALIDATE_PKG.EMPLOYEE_VALIDATE
467 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
468 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
469 ,P_HIRE_DATE => P_HIRE_DATE
470 ,P_SEX => P_SEX
471 ,P_FIRST_NAME => P_FIRST_NAME
472 ,P_LAST_NAME => P_LAST_NAME
473 ,P_NATIONALITY => P_NATIONALITY
474 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
475 ,P_TITLE => P_TITLE
476 ,P_MARITAL_STATUS => P_MARITAL_STATUS
477 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
478 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
479 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
480 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
481 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
482 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
483 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
484 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
485 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
486 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
487 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
488 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
489 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
490 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
491 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
492 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
493 ,P_PER_INFORMATION16 => P_PER_INFORMATION16
494 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
495 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
496 ,P_PER_INFORMATION19 => P_PER_INFORMATION19
497 ,P_PER_INFORMATION20 => P_PER_INFORMATION20
498 );
499 elsif l_legislation_code = 'BE' then
500 HR_BE_EXTRA_PERSON_RULES.EXTRA_LANGUAGE_CHECKS
501 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
502 ,P_CORRESPONDENCE_LANGUAGE => P_CORRESPONDENCE_LANGUAGE
503 );
504 HR_BE_EXTRA_PERSON_RULES.EXTRA_PERSON_CHECKS
505 (P_REGION_OF_BIRTH => P_REGION_OF_BIRTH
506 );
507 elsif l_legislation_code = 'CN' then
508 PER_CN_EMP_LEG_HOOK.CHECK_EMPLOYEE
509 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
510 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
511 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
512 ,P_HIRE_DATE => P_HIRE_DATE
513 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
514 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
515 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
516 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
517 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
518 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
519 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
520 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
521 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
522 );
523 elsif l_legislation_code = 'DK' then
524 HR_DK_VALIDATE_PKG.EMPLOYEE_VALIDATE
525 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
526 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
527 ,P_FIRST_NAME => P_FIRST_NAME
528 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
529 );
530 elsif l_legislation_code = 'ES' then
531 PER_ES_CREATE_EMPLOYEE.CREATE_ES_EMPLOYEE
532 (P_LAST_NAME => P_LAST_NAME
533 ,P_FIRST_NAME => P_FIRST_NAME
534 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
535 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
536 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
537 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
538 );
539 elsif l_legislation_code = 'FI' then
540 HR_FI_VALIDATE_PKG.EMPLOYEE_VALIDATE
541 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
542 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
543 ,P_FIRST_NAME => P_FIRST_NAME
544 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
545 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
546 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
547 );
548 elsif l_legislation_code = 'FR' then
549 PER_FR_PEOPLE_LEG_HOOK.CHECK_REGN_ENTRY_INS
550 (P_REGION_OF_BIRTH => P_REGION_OF_BIRTH
551 ,P_COUNTRY_OF_BIRTH => P_COUNTRY_OF_BIRTH
552 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
553 ,P_HIRE_DATE => P_HIRE_DATE
554 );
555 elsif l_legislation_code = 'HK' then
556 HR_HK_PEOPLE_LEG_HOOK.CHECK_HKID_PASSPORT
557 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
558 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
559 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
560 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
561 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
562 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
563 );
564 HR_HK_PEOPLE_LEG_HOOK.CHECK_HONGKONG_NAME
565 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
566 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
567 );
568 elsif l_legislation_code = 'HU' then
569 PER_HU_CREATE_EMPLOYEE.CREATE_HU_EMPLOYEE
570 (P_LAST_NAME => P_LAST_NAME
571 ,P_FIRST_NAME => P_FIRST_NAME
572 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
573 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
574 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
575 );
576 elsif l_legislation_code = 'IN' then
577 PER_IN_PERSON_LEG_HOOK.CHECK_IN_PERSON_INSERT
578 (P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
579 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
580 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
581 ,P_HIRE_DATE => P_HIRE_DATE
582 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
583 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
584 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
585 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
586 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
587 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
588 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
589 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
590 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
591 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
592 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
593 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
594 );
595 elsif l_legislation_code = 'IT' then
596 HR_IT_EXTRA_PERSON_RULES.EXTRA_CREATE_PERSON_CHECKS
597 (P_PER_INFORMATION2 => P_PER_INFORMATION2
598 ,P_USES_TOBACCO_FLAG => P_USES_TOBACCO_FLAG
599 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
600 );
601 elsif l_legislation_code = 'KW' then
602 HR_KW_VALIDATE_PKG.EMPLOYEE_VALIDATE
603 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
604 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
605 ,P_HIRE_DATE => P_HIRE_DATE
606 ,P_SEX => P_SEX
607 ,P_FIRST_NAME => P_FIRST_NAME
608 ,P_NATIONALITY => P_NATIONALITY
609 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
610 ,P_TITLE => P_TITLE
611 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
612 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
613 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
614 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
615 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
616 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
617 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
618 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
619 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
620 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
621 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
622 );
623 elsif l_legislation_code = 'NL' then
624 HR_NL_EXTRA_PERSON_RULES.EXTRA_PERSON_CHECKS
625 (P_FIRST_NAME => P_FIRST_NAME
626 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
627 ,P_HONORS => P_HONORS
628 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
629 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
630 );
631 elsif l_legislation_code = 'NO' then
632 HR_NO_VALIDATE_PKG.EMPLOYEE_VALIDATE
633 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
634 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
635 ,P_FIRST_NAME => P_FIRST_NAME
636 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
637 );
638 elsif l_legislation_code = 'PL' then
639 PER_PL_CREATE_EMPLOYEE.CREATE_PL_EMPLOYEE
640 (P_LAST_NAME => P_LAST_NAME
641 ,P_FIRST_NAME => P_FIRST_NAME
642 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
643 ,P_MARITAL_STATUS => P_MARITAL_STATUS
644 ,P_NATIONALITY => P_NATIONALITY
645 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
646 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
647 ,P_SEX => P_SEX
648 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
649 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
650 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
651 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
652 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
653 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
654 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
655 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
656 );
657 elsif l_legislation_code = 'RU' then
658 HR_RU_PEOPLE_LEG_HOOK.CREATE_RU_EMPLOYEE
659 (P_FIRST_NAME => P_FIRST_NAME
660 ,P_HIRE_DATE => P_HIRE_DATE
661 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
662 ,P_SEX => P_SEX
663 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
664 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
665 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
666 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
667 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
668 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
669 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
670 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
671 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
672 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
673 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
674 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
675 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
676 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
677 );
678 elsif l_legislation_code = 'SA' then
679 HR_SA_VALIDATE_PKG.EMPLOYEE_VALIDATE
680 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
681 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
682 ,P_HIRE_DATE => P_HIRE_DATE
683 ,P_SEX => P_SEX
684 ,P_FIRST_NAME => P_FIRST_NAME
685 ,P_NATIONALITY => P_NATIONALITY
686 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
687 ,P_TITLE => P_TITLE
688 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
689 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
690 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
691 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
692 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
693 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
694 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
695 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
696 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
697 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
698 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
699 );
700 elsif l_legislation_code = 'SE' then
701 HR_SE_VALIDATE_PKG.EMPLOYEE_VALIDATE
702 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
703 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
704 ,P_FIRST_NAME => P_FIRST_NAME
705 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
706 );
707 elsif l_legislation_code = 'ZA' then
708 PER_ZA_USER_HOOK_PKG.VALIDATE_EMPLOYEE
709 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
710 ,P_HIRE_DATE => P_HIRE_DATE
711 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
712 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
713 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
714 );
715 end if;
716 end if;
717 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_EMPLOYEE', 'BP');
718 hr_utility.set_location(' Leaving: HR_EMPLOYEE_BK1.CREATE_EMPLOYEE_B', 20);
719 end CREATE_EMPLOYEE_B;
720 end HR_EMPLOYEE_BK1;