eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HR_PERSON_BK1

Source


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