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.4.12010000.3 2008/09/08 14:54:17 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:53:59 (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 = 'MX' then
300 PER_MX_VALIDATE_ID.VALIDATE_RFC_ID
301 (P_PER_INFORMATION2 => P_PER_INFORMATION2
302 ,P_PERSON_ID => P_PERSON_ID
303 );
304 PER_MX_VALIDATE_ID.VALIDATE_SS_ID
305 (P_PER_INFORMATION3 => P_PER_INFORMATION3
306 ,P_PERSON_ID => P_PERSON_ID
307 );
308 PER_MX_VALIDATE_ID.VALIDATE_FGA_ID
309 (P_PER_INFORMATION5 => P_PER_INFORMATION5
310 ,P_PERSON_ID => P_PERSON_ID
311 );
312 PER_MX_VALIDATE_ID.VALIDATE_MS_ID
313 (P_PER_INFORMATION6 => P_PER_INFORMATION6
314 ,P_PERSON_ID => P_PERSON_ID
315 );
316 PER_MX_VALIDATE_ID.VALIDATE_IMC_ID
317 (P_PER_INFORMATION4 => P_PER_INFORMATION4
318 );
319 end if;
320 end if;
321 hr_multi_message.end_validation_set;
322 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERSON', 'AP');
323 hr_utility.set_location(' Leaving: HR_PERSON_BK1.UPDATE_PERSON_A', 20);
324 end UPDATE_PERSON_A;
325 procedure UPDATE_PERSON_B
326 (P_EFFECTIVE_DATE in DATE
327 ,P_DATETRACK_UPDATE_MODE in VARCHAR2
328 ,P_PERSON_ID in NUMBER
329 ,P_OBJECT_VERSION_NUMBER in NUMBER
330 ,P_PERSON_TYPE_ID in NUMBER
331 ,P_LAST_NAME in VARCHAR2
332 ,P_APPLICANT_NUMBER in VARCHAR2
333 ,P_COMMENTS in VARCHAR2
334 ,P_DATE_EMPLOYEE_DATA_VERIFIED in DATE
335 ,P_DATE_OF_BIRTH in DATE
336 ,P_EMAIL_ADDRESS in VARCHAR2
337 ,P_EMPLOYEE_NUMBER in VARCHAR2
338 ,P_EXPENSE_CHECK_SEND_TO_ADDRES in VARCHAR2
339 ,P_FIRST_NAME in VARCHAR2
340 ,P_KNOWN_AS in VARCHAR2
341 ,P_MARITAL_STATUS in VARCHAR2
342 ,P_MIDDLE_NAMES in VARCHAR2
343 ,P_NATIONALITY in VARCHAR2
344 ,P_NATIONAL_IDENTIFIER in VARCHAR2
345 ,P_PREVIOUS_LAST_NAME in VARCHAR2
346 ,P_REGISTERED_DISABLED_FLAG in VARCHAR2
347 ,P_SEX in VARCHAR2
348 ,P_TITLE in VARCHAR2
349 ,P_VENDOR_ID in NUMBER
350 ,P_WORK_TELEPHONE in VARCHAR2
351 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
352 ,P_ATTRIBUTE1 in VARCHAR2
353 ,P_ATTRIBUTE2 in VARCHAR2
354 ,P_ATTRIBUTE3 in VARCHAR2
355 ,P_ATTRIBUTE4 in VARCHAR2
356 ,P_ATTRIBUTE5 in VARCHAR2
357 ,P_ATTRIBUTE6 in VARCHAR2
358 ,P_ATTRIBUTE7 in VARCHAR2
359 ,P_ATTRIBUTE8 in VARCHAR2
360 ,P_ATTRIBUTE9 in VARCHAR2
361 ,P_ATTRIBUTE10 in VARCHAR2
362 ,P_ATTRIBUTE11 in VARCHAR2
363 ,P_ATTRIBUTE12 in VARCHAR2
364 ,P_ATTRIBUTE13 in VARCHAR2
365 ,P_ATTRIBUTE14 in VARCHAR2
366 ,P_ATTRIBUTE15 in VARCHAR2
367 ,P_ATTRIBUTE16 in VARCHAR2
368 ,P_ATTRIBUTE17 in VARCHAR2
369 ,P_ATTRIBUTE18 in VARCHAR2
370 ,P_ATTRIBUTE19 in VARCHAR2
371 ,P_ATTRIBUTE20 in VARCHAR2
372 ,P_ATTRIBUTE21 in VARCHAR2
373 ,P_ATTRIBUTE22 in VARCHAR2
374 ,P_ATTRIBUTE23 in VARCHAR2
375 ,P_ATTRIBUTE24 in VARCHAR2
376 ,P_ATTRIBUTE25 in VARCHAR2
377 ,P_ATTRIBUTE26 in VARCHAR2
378 ,P_ATTRIBUTE27 in VARCHAR2
379 ,P_ATTRIBUTE28 in VARCHAR2
380 ,P_ATTRIBUTE29 in VARCHAR2
381 ,P_ATTRIBUTE30 in VARCHAR2
382 ,P_PER_INFORMATION_CATEGORY in VARCHAR2
383 ,P_PER_INFORMATION1 in VARCHAR2
384 ,P_PER_INFORMATION2 in VARCHAR2
385 ,P_PER_INFORMATION3 in VARCHAR2
386 ,P_PER_INFORMATION4 in VARCHAR2
387 ,P_PER_INFORMATION5 in VARCHAR2
388 ,P_PER_INFORMATION6 in VARCHAR2
389 ,P_PER_INFORMATION7 in VARCHAR2
390 ,P_PER_INFORMATION8 in VARCHAR2
391 ,P_PER_INFORMATION9 in VARCHAR2
392 ,P_PER_INFORMATION10 in VARCHAR2
393 ,P_PER_INFORMATION11 in VARCHAR2
394 ,P_PER_INFORMATION12 in VARCHAR2
395 ,P_PER_INFORMATION13 in VARCHAR2
396 ,P_PER_INFORMATION14 in VARCHAR2
397 ,P_PER_INFORMATION15 in VARCHAR2
398 ,P_PER_INFORMATION16 in VARCHAR2
399 ,P_PER_INFORMATION17 in VARCHAR2
400 ,P_PER_INFORMATION18 in VARCHAR2
401 ,P_PER_INFORMATION19 in VARCHAR2
402 ,P_PER_INFORMATION20 in VARCHAR2
403 ,P_PER_INFORMATION21 in VARCHAR2
404 ,P_PER_INFORMATION22 in VARCHAR2
405 ,P_PER_INFORMATION23 in VARCHAR2
406 ,P_PER_INFORMATION24 in VARCHAR2
407 ,P_PER_INFORMATION25 in VARCHAR2
408 ,P_PER_INFORMATION26 in VARCHAR2
409 ,P_PER_INFORMATION27 in VARCHAR2
410 ,P_PER_INFORMATION28 in VARCHAR2
411 ,P_PER_INFORMATION29 in VARCHAR2
412 ,P_PER_INFORMATION30 in VARCHAR2
413 ,P_DATE_OF_DEATH in DATE
414 ,P_BACKGROUND_CHECK_STATUS in VARCHAR2
415 ,P_BACKGROUND_DATE_CHECK in DATE
416 ,P_BLOOD_TYPE in VARCHAR2
417 ,P_CORRESPONDENCE_LANGUAGE in VARCHAR2
418 ,P_FAST_PATH_EMPLOYEE in VARCHAR2
419 ,P_FTE_CAPACITY in NUMBER
420 ,P_HOLD_APPLICANT_DATE_UNTIL in DATE
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_PROJECTED_START_DATE in DATE
430 ,P_REHIRE_AUTHORIZOR in VARCHAR2
431 ,P_REHIRE_RECOMMENDATION in VARCHAR2
432 ,P_RESUME_EXISTS in VARCHAR2
433 ,P_RESUME_LAST_UPDATED in DATE
434 ,P_SECOND_PASSPORT_EXISTS in VARCHAR2
435 ,P_STUDENT_STATUS in VARCHAR2
436 ,P_WORK_SCHEDULE in VARCHAR2
437 ,P_REHIRE_REASON in VARCHAR2
438 ,P_SUFFIX in VARCHAR2
439 ,P_BENEFIT_GROUP_ID in NUMBER
440 ,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
441 ,P_COORD_BEN_MED_PLN_NO in VARCHAR2
442 ,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
443 ,P_COORD_BEN_MED_EXT_ER in VARCHAR2
444 ,P_COORD_BEN_MED_PL_NAME in VARCHAR2
445 ,P_COORD_BEN_MED_INSR_CRR_NAME in VARCHAR2
446 ,P_COORD_BEN_MED_INSR_CRR_IDENT in VARCHAR2
447 ,P_COORD_BEN_MED_CVG_STRT_DT in DATE
448 ,P_COORD_BEN_MED_CVG_END_DT in DATE
449 ,P_USES_TOBACCO_FLAG in VARCHAR2
450 ,P_DPDNT_ADOPTION_DATE in DATE
451 ,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
452 ,P_ORIGINAL_DATE_OF_HIRE in DATE
453 ,P_ADJUSTED_SVC_DATE in DATE
454 ,P_TOWN_OF_BIRTH in VARCHAR2
455 ,P_REGION_OF_BIRTH in VARCHAR2
456 ,P_COUNTRY_OF_BIRTH in VARCHAR2
457 ,P_GLOBAL_PERSON_ID in VARCHAR2
458 ,P_PARTY_ID in NUMBER
459 ,P_NPW_NUMBER in VARCHAR2
460 )is
461 l_commit_unit_number number;
462 l_legislation_code   varchar2(30);
463 begin
464 hr_utility.set_location('Entering: HR_PERSON_BK1.UPDATE_PERSON_B', 10);
465 l_commit_unit_number := hr_api.return_commit_unit;
466 if hr_api.call_leg_hooks then
467 l_legislation_code := PER_PER_BUS.return_legislation_code(P_PERSON_ID => P_PERSON_ID
468 );
469 if l_legislation_code = 'AE' then
470 HR_AE_VALIDATE_PKG.PERSON_VALIDATE
471 (P_PERSON_ID => P_PERSON_ID
472 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
473 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
474 ,P_SEX => P_SEX
475 ,P_FIRST_NAME => P_FIRST_NAME
476 ,P_LAST_NAME => P_LAST_NAME
477 ,P_NATIONALITY => P_NATIONALITY
478 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
479 ,P_TITLE => P_TITLE
480 ,P_MARITAL_STATUS => P_MARITAL_STATUS
481 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
482 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
483 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
484 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
485 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
486 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
487 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
488 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
489 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
490 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
491 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
492 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
493 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
494 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
495 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
496 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
497 ,P_PER_INFORMATION16 => P_PER_INFORMATION16
498 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
499 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
500 ,P_PER_INFORMATION19 => P_PER_INFORMATION19
501 ,P_PER_INFORMATION20 => P_PER_INFORMATION20
502 );
503 elsif l_legislation_code = 'BE' then
504 HR_BE_EXTRA_PERSON_RULES.EXTRA_LANGUAGE_CHECKS
505 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
506 ,P_CORRESPONDENCE_LANGUAGE => P_CORRESPONDENCE_LANGUAGE
507 );
508 HR_BE_EXTRA_PERSON_RULES.EXTRA_PERSON_CHECKS
509 (P_REGION_OF_BIRTH => P_REGION_OF_BIRTH
510 );
511 elsif l_legislation_code = 'CN' then
512 PER_CN_EMP_LEG_HOOK.CHECK_PERSON
513 (P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
514 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
515 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
516 ,P_PERSON_ID => P_PERSON_ID
517 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
518 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
519 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
520 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
521 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
522 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
523 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
524 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
525 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
526 );
527 elsif l_legislation_code = 'DK' then
528 HR_DK_VALIDATE_PKG.PERSON_VALIDATE
529 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
530 ,P_FIRST_NAME => P_FIRST_NAME
531 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
532 );
533 elsif l_legislation_code = 'ES' then
534 PER_ES_UPDATE_PERSON.UPDATE_ES_PERSON
535 (P_PERSON_ID => P_PERSON_ID
536 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
537 ,P_LAST_NAME => P_LAST_NAME
538 ,P_FIRST_NAME => P_FIRST_NAME
539 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
540 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
541 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
542 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
543 );
544 elsif l_legislation_code = 'FI' then
545 HR_FI_VALIDATE_PKG.PERSON_VALIDATE
546 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
547 ,P_FIRST_NAME => P_FIRST_NAME
548 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
549 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
550 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
551 );
552 elsif l_legislation_code = 'FR' then
553 PER_FR_PEOPLE_LEG_HOOK.CHECK_REGN_ENTRY_UPD
554 (P_REGION_OF_BIRTH => P_REGION_OF_BIRTH
555 ,P_COUNTRY_OF_BIRTH => P_COUNTRY_OF_BIRTH
556 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
557 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
558 ,P_PERSON_ID => P_PERSON_ID
559 );
560 elsif l_legislation_code = 'GB' then
561 PER_ASG_AGGR.CHECK_AGGR_ASSG
562 (P_PERSON_ID => P_PERSON_ID
563 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
564 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
565 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
566 );
567 elsif l_legislation_code = 'HK' then
568 HR_HK_PEOPLE_LEG_HOOK.CHECK_HKID_PASSPORT
569 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
570 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
571 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
572 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
573 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
574 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
575 );
576 HR_HK_PEOPLE_LEG_HOOK.CHECK_HONGKONG_NAME
577 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
578 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
579 );
580 elsif l_legislation_code = 'HU' then
581 PER_HU_UPDATE_PERSON.UPDATE_HU_PERSON
582 (P_PERSON_ID => P_PERSON_ID
583 ,P_LAST_NAME => P_LAST_NAME
584 ,P_FIRST_NAME => P_FIRST_NAME
585 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
586 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
587 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
588 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
589 );
590 elsif l_legislation_code = 'IN' then
591 PER_IN_PERSON_LEG_HOOK.CHECK_IN_PERSON_UPDATE
592 (P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
593 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
594 ,P_PERSON_ID => P_PERSON_ID
595 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
596 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
597 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
598 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
599 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
600 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
601 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
602 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
603 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
604 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
605 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
606 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
607 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
608 );
609 elsif l_legislation_code = 'IT' then
610 HR_IT_EXTRA_PERSON_RULES.EXTRA_UPDATE_PERSON_CHECKS
611 (P_PERSON_ID => P_PERSON_ID
612 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
613 ,P_USES_TOBACCO_FLAG => P_USES_TOBACCO_FLAG
614 );
615 elsif l_legislation_code = 'KW' then
616 HR_KW_VALIDATE_PKG.PERSON_VALIDATE
617 (P_PERSON_ID => P_PERSON_ID
618 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
619 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
620 ,P_SEX => P_SEX
621 ,P_FIRST_NAME => P_FIRST_NAME
622 ,P_NATIONALITY => P_NATIONALITY
623 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
624 ,P_TITLE => P_TITLE
625 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
626 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
627 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
628 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
629 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
630 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
631 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
632 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
633 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
634 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
635 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
636 );
637 elsif l_legislation_code = 'NO' then
638 HR_NO_VALIDATE_PKG.PERSON_VALIDATE
639 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
640 ,P_FIRST_NAME => P_FIRST_NAME
641 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
642 );
643 elsif l_legislation_code = 'PL' then
644 PER_PL_UPDATE_PERSON.UPDATE_PL_PERSON
645 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
646 ,P_LAST_NAME => P_LAST_NAME
647 ,P_FIRST_NAME => P_FIRST_NAME
648 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
649 ,P_MARITAL_STATUS => P_MARITAL_STATUS
650 ,P_NATIONALITY => P_NATIONALITY
651 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
652 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
653 ,P_PERSON_ID => P_PERSON_ID
654 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
655 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
656 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
657 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
658 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
659 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
660 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
661 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
662 );
663 elsif l_legislation_code = 'RU' then
664 HR_RU_PEOPLE_LEG_HOOK.UPDATE_RU_PERSON
665 (P_PERSON_ID => P_PERSON_ID
666 ,P_FIRST_NAME => P_FIRST_NAME
667 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
668 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
669 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
670 ,P_SEX => P_SEX
671 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
672 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
673 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
674 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
675 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
676 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
677 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
678 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
679 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
680 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
681 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
682 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
683 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
684 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
685 );
686 elsif l_legislation_code = 'SA' then
687 HR_SA_VALIDATE_PKG.PERSON_VALIDATE
688 (P_PERSON_ID => P_PERSON_ID
689 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
690 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
691 ,P_SEX => P_SEX
692 ,P_FIRST_NAME => P_FIRST_NAME
693 ,P_NATIONALITY => P_NATIONALITY
694 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
695 ,P_TITLE => P_TITLE
696 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
697 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
698 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
699 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
700 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
701 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
702 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
703 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
704 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
705 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
706 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
707 );
708 elsif l_legislation_code = 'SE' then
709 HR_SE_VALIDATE_PKG.PERSON_VALIDATE
710 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
711 ,P_FIRST_NAME => P_FIRST_NAME
712 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
713 );
714 elsif l_legislation_code = 'SG' then
715 HR_SG_PEOPLE_LEG_HOOK.CHECK_SG_LEGAL_NAME
716 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
717 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
718 );
719 HR_SG_PEOPLE_LEG_HOOK.CHECK_SG_INCOME_TAX
720 (P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
721 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
722 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
723 );
724 elsif l_legislation_code = 'ZA' then
725 PER_ZA_USER_HOOK_PKG.VALIDATE_PERSON
726 (P_PERSON_ID => P_PERSON_ID
727 ,P_EFFECTIVE_DATE => P_EFFECTIVE_DATE
728 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
729 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
730 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
731 );
732 end if;
733 end if;
734 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PERSON', 'BP');
735 hr_utility.set_location(' Leaving: HR_PERSON_BK1.UPDATE_PERSON_B', 20);
736 end UPDATE_PERSON_B;
737 end HR_PERSON_BK1;