1 PACKAGE BODY hr_cn_person_api AS
2 /* $Header: hrcnwrpe.pkb 120.1 2011/12/20 12:10:39 jmarupil ship $ */
3
4 -- Package Variables
5 g_package VARCHAR2(33) := 'hr_cn_person_api.';
6
7
8 -- ----------------------------------------------------------------------------
9 -- |---------------------------< update_cn_person >------------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 -- {Start Of Comments}
13 --
14 -- Description:
15 -- This API updates the person record as identified by p_person_id
16 -- and p_object_version_number.
17 --
18 -- Note: The business group must have the CN legislation code.
19 --
20 -- Prerequisites
21 -- The person record, identified by p_person_id and
22 -- p_object_version_number, must already exist.
23 --
24 -- In Parameters:
25 -- Name Reqd Type Description
26 -- p_validate No boolean If true, the database
27 -- remains unchanged. If false
28 -- then the person will be
29 -- updated.
30 -- p_effective_date Yes date The effective date for this
31 -- change
32 -- p_datetrack_update_mode Yes varchar2 Update mode
33 -- p_person_id Yes number ID of person
34 -- p_object_version_number Yes number Version number of the person
35 -- record
36 -- p_person_type_id No number Person type ID
37 -- p_family_or_last_name No varchar2 Family or Last name
38 -- p_applicant_number No varchar2 Applicant number
39 -- p_comments No varchar2 Comment text
40 -- p_date_employee_data_verified No date Date when the employee
41 -- data was last verified
42 -- p_date_of_birth No date Date of birth
43 -- p_email_address No varchar2 Email address
44 -- p_employee_number No varchar2 Employee number
45 -- p_expense_check_send_to_addres No varchar2 Mailing address
46 -- p_given_or_first_name No varchar2 Given or First name
47 -- p_known_as No varchar2 Known as
48 -- p_marital_status No varchar2 Marital status
49 -- p_middle_names No varchar2 Middle names
50 -- p_nationality No varchar2 Nationality
51 -- p_citizen_identification_num No varchar2 Citizen Identification Number
52 -- p_previous_last_name No varchar2 Previous last name
53 -- p_registered_disabled_flag No varchar2 Registered disabled flag
54 -- p_sex No varchar2 Gender
55 -- p_title No varchar2 Title
56 -- p_vendor_id No number Foreign key to PO_VENDORS
57 -- p_work_telephone No varchar2 Work telephone
58 -- p_attribute_category No varchar2 Determines the context of
59 -- the descriptive flexfield
60 -- p_attribute1 No varchar2 Descriptive flexfield
61 -- p_attribute2 No varchar2 Descriptive flexfield
62 -- p_attribute3 No varchar2 Descriptive flexfield
63 -- p_attribute4 No varchar2 Descriptive flexfield
64 -- p_attribute5 No varchar2 Descriptive flexfield
65 -- p_attribute6 No varchar2 Descriptive flexfield
66 -- p_attribute7 No varchar2 Descriptive flexfield
67 -- p_attribute8 No varchar2 Descriptive flexfield
68 -- p_attribute9 No varchar2 Descriptive flexfield
69 -- p_attribute10 No varchar2 Descriptive flexfield
70 -- p_attribute11 No varchar2 Descriptive flexfield
71 -- p_attribute12 No varchar2 Descriptive flexfield
72 -- p_attribute13 No varchar2 Descriptive flexfield
73 -- p_attribute14 No varchar2 Descriptive flexfield
74 -- p_attribute15 No varchar2 Descriptive flexfield
75 -- p_attribute16 No varchar2 Descriptive flexfield
76 -- p_attribute17 No varchar2 Descriptive flexfield
77 -- p_attribute18 No varchar2 Descriptive flexfield
78 -- p_attribute19 No varchar2 Descriptive flexfield
79 -- p_attribute20 No varchar2 Descriptive flexfield
80 -- p_attribute21 No varchar2 Descriptive flexfield
81 -- p_attribute22 No varchar2 Descriptive flexfield
82 -- p_attribute23 No varchar2 Descriptive flexfield
83 -- p_attribute24 No varchar2 Descriptive flexfield
84 -- p_attribute25 No varchar2 Descriptive flexfield
85 -- p_attribute26 No varchar2 Descriptive flexfield
86 -- p_attribute27 No varchar2 Descriptive flexfield
87 -- p_attribute28 No varchar2 Descriptive flexfield
88 -- p_attribute29 No varchar2 Descriptive flexfield
89 -- p_attribute30 No varchar2 Descriptive flexfield
90 -- p_hukou_type Yes varchar2 Hukou Type
91 -- p_hukou_location Yes varchar2 Hukou Location
92 -- p_highest_education_level No varchar2 Highest Education Level
93 -- p_number_of_children No varchar2 Number Of Children
94 -- p_expatriate_indicator Yes varchar2 Expatriate Indicator
95 -- p_health_status No varchar2 Health Status
96 -- p_tax_exemption_indicator No varchar2 Tax Exemption Indicator
97 -- p_perentage No varchar2 Percentage
98 -- p_family_han_yu_pin_yin_name No varchar2 Family Han Yu Pin Yin Name
99 -- p_given_han_yu_pin_yin_name No varchar2 Given Han Yu Pin Yin Name
100 -- p_previous_name No varchar2 Previous Name
101 -- p_race_ethnic_origin No varchar2 Race or Etnic Origin
102 -- p_social_security_ic_number No varchar2 Social Security IC Number
103 -- p_suffix No varchar2 Person's suffix
104 -- p_date_of_death No date Currently unsupported
105 -- p_background_check_status No varchar2 Background check status
106 -- p_background_date_check No date Background date check
107 -- p_blood_type No varchar2 Blood group
108 -- p_correspondence_language No varchar2 Language for correspondence
109 -- p_fast_path_employee No varchar2 Currently unsupported
110 -- p_fte_capacity No number Full-time employment capacity
111 -- p_hold_applicant_date_until No date Hold applicant until
112 -- p_honors No varchar2 Honors
113 -- p_internal_location No varchar2 Internal location
114 -- p_last_medical_test_by No varchar2 Last medical test by
115 -- p_last_medical_test_date No date Last medical test date
116 -- p_mailstop No varchar2 Internal mail location
117 -- p_office_number No varchar2 Office number
118 -- p_on_military_service No varchar2 On military service
119 -- p_pre_name_adjunct No varchar2 Name prefix
120 -- p_projected_start_date No date Currently unsupported
121 -- p_rehire_authorizor No varchar2 Currently unsupported
122 -- p_rehire_recommendation No varchar2 Re-hire recommendation
123 -- p_resume_exists No varchar2 Resume exists
124 -- p_resume_last_updated No date Date resume last updated
125 -- p_second_passport_exists No varchar2 Second passport available
126 -- flag
127 -- p_student_status No varchar2 Student status
128 -- p_work_schedule No varchar2 Work schedule
129 -- p_rehire_reason No varchar2 Reason for re-hiring
130 -- p_benefit_group_id No number Id for benefit group
131 -- p_receipt_of_death_cert_date No date Date death certificate
132 -- was received
133 -- p_coord_ben_med_pln_no No varchar2 Number of an externally
134 -- provided medical plan
135 -- p_coord_ben_no_cvg_flag No varchar2 No other coverage flag
136 -- p_uses_tobacco_flag No varchar2 Uses tobacco flag
137 -- p_dpdnt_adoption_date No date Date dependent was adopted
138 -- p_dpdnt_vlntry_svce_flag No varchar2 Dependent on voluntary
139 -- service flag
140 -- p_original_date_of_hire No date Original date of hire
141 -- p_adjusted_svc_date No date Adjusted service date
142 -- p_place_of_birth No varchar2 Place of birth
143 -- p_original_hometown No varchar2 Original hometown
144 -- p_country_of_birth No varchar2 Country of birth
145 -- p_global_person_id No varchar2 Global ID for the person
146 -- p_party_id No number Party ID for the person
147 -- p_npw_number No varchar2 Non-payrolled worker number
148 --
149 -- Post Success:
150 -- The API will set the following out parameters:
151 --
152 -- Name Type Description
153 -- p_object_version_number number If p_validate is false, set to
154 -- the new version number of the
155 -- updated person record. If
156 -- p_validate is true set to the
157 -- same value you passed in.
158 -- p_employee_number varchar2 If p_validate is false, set to
159 -- the value of the employee number
160 -- after the person record has
161 -- been updated.
162 -- If p_validate is true, set to
163 -- the same value you passed in.
164 -- This parameter depends on the
165 -- employee number generation method
166 -- of the business group.
167 -- p_effective_start_date date If p_validate is false, set to
168 -- the effective start date of the
169 -- person. If p_validate is true, set
170 -- to null.
171 -- p_effective_end_date date If p_validate is false, set to
172 -- the effective end date of the
173 -- person.
174 -- If p_validate is true, set to
175 -- null.
176 -- p_full_name varchar2 If p_validate is false, set to
177 -- the complete full name of the
178 -- person.
179 -- If p_validate is true, set to
180 -- null.
181 -- p_comment_id number If p_validate is false and any
182 -- comment text exists, set to the id
183 -- of the corresponding person
184 -- comment row.
185 -- If p_validate is true, or no
186 -- comment text exists this will be
187 -- null.
188 -- p_name_combination_warning boolean Set to true if the new
189 -- combination (if changed) of last
190 -- name, first name and date of
191 -- birth already existed prior to
192 -- the update. Else, set to false.
193 -- p_assign_payroll_warning boolean Set to true if the date of birth
194 -- has been updated to a null value,
195 -- and this person is an employee,
196 -- otherwise set to false.
197 -- p_orig_hire_warning boolean Set to true if the original date
198 -- of hire is not null and the
199 -- person type is not EMP,EMP_APL,
200 -- EX_EMP or EX_EMP_APL.
201 --
202 --
203 -- Post Failure:
204 -- The API will not update the person and raises an error.
205 --
206 -- Access Status:
207 -- Public.
208 --
209 -- {End Of Comments}
210 --
211 PROCEDURE update_cn_person
212 ( p_validate IN BOOLEAN DEFAULT false
213 ,p_effective_date IN DATE
214 ,p_datetrack_update_mode IN VARCHAR2
215 ,p_person_id IN NUMBER
216 ,p_object_version_number IN OUT NOCOPY NUMBER
217 ,p_person_type_id IN NUMBER DEFAULT hr_api.g_number
218 ,p_family_or_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
219 ,p_applicant_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
220 ,p_comments IN hr_comments.comment_text%TYPE DEFAULT hr_api.g_varchar2
221 ,p_date_employee_data_verified IN DATE DEFAULT hr_api.g_date
222 ,p_date_of_birth IN DATE DEFAULT hr_api.g_date
223 ,p_email_address IN VARCHAR2 DEFAULT hr_api.g_varchar2
224 ,p_employee_number IN OUT NOCOPY VARCHAR2
225 ,p_expense_check_send_to_addres IN VARCHAR2 DEFAULT hr_api.g_varchar2
226 ,p_given_or_first_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
227 ,p_known_as IN VARCHAR2 DEFAULT hr_api.g_varchar2
228 ,p_marital_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
229 ,p_middle_names IN VARCHAR2 DEFAULT hr_api.g_varchar2
230 ,p_nationality IN VARCHAR2 DEFAULT hr_api.g_varchar2
231 ,p_citizen_identification_num IN VARCHAR2 DEFAULT hr_api.g_varchar2
232 ,p_previous_last_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
233 ,p_registered_disabled_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
234 ,p_sex IN VARCHAR2 DEFAULT hr_api.g_varchar2
235 ,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
236 ,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
237 ,p_work_telephone IN VARCHAR2 DEFAULT hr_api.g_varchar2
238 ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
239 ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
240 ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
241 ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
242 ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
243 ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
244 ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
245 ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
246 ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
247 ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
248 ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
249 ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
250 ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
251 ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
252 ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
253 ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
254 ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
255 ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
256 ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
257 ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
258 ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
259 ,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
260 ,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
261 ,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
262 ,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
263 ,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
264 ,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
265 ,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
266 ,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
267 ,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
268 ,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
269 ,p_hukou_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
270 ,p_hukou_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
271 ,p_highest_education_level IN VARCHAR2 DEFAULT hr_api.g_varchar2
272 ,p_number_of_children IN VARCHAR2 DEFAULT hr_api.g_varchar2
273 ,p_expatriate_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
274 ,p_health_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
275 ,p_tax_exemption_indicator IN VARCHAR2 DEFAULT hr_api.g_varchar2
276 ,p_percentage IN VARCHAR2 DEFAULT hr_api.g_varchar2
277 ,p_family_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
278 ,p_given_han_yu_pin_yin_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
279 ,p_previous_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
280 ,p_race_ethnic_orgin IN VARCHAR2 DEFAULT hr_api.g_varchar2
281 ,p_social_security_ic_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
282 ,p_date_of_death IN DATE DEFAULT hr_api.g_date
283 ,p_background_check_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
284 ,p_background_date_check IN DATE DEFAULT hr_api.g_date
285 ,p_blood_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
286 ,p_correspondence_language IN VARCHAR2 DEFAULT hr_api.g_varchar2
287 ,p_fast_path_employee IN VARCHAR2 DEFAULT hr_api.g_varchar2
288 ,p_fte_capacity IN NUMBER DEFAULT hr_api.g_number
289 ,p_hold_applicant_date_until IN DATE DEFAULT hr_api.g_date
290 ,p_honors IN VARCHAR2 DEFAULT hr_api.g_varchar2
291 ,p_internal_location IN VARCHAR2 DEFAULT hr_api.g_varchar2
292 ,p_last_medical_test_by IN VARCHAR2 DEFAULT hr_api.g_varchar2
293 ,p_last_medical_test_date IN DATE DEFAULT hr_api.g_date
294 ,p_mailstop IN VARCHAR2 DEFAULT hr_api.g_varchar2
295 ,p_office_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
296 ,p_on_military_service IN VARCHAR2 DEFAULT hr_api.g_varchar2
297 ,p_pre_name_adjunct IN VARCHAR2 DEFAULT hr_api.g_varchar2
298 ,p_projected_start_date IN DATE DEFAULT hr_api.g_date
299 ,p_rehire_authorizor IN VARCHAR2 DEFAULT hr_api.g_varchar2
300 ,p_rehire_recommendation IN VARCHAR2 DEFAULT hr_api.g_varchar2
301 ,p_resume_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
302 ,p_resume_last_updated IN DATE DEFAULT hr_api.g_date
303 ,p_second_passport_exists IN VARCHAR2 DEFAULT hr_api.g_varchar2
304 ,p_student_status IN VARCHAR2 DEFAULT hr_api.g_varchar2
305 ,p_work_schedule IN VARCHAR2 DEFAULT hr_api.g_varchar2
306 ,p_rehire_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
307 ,p_suffix IN VARCHAR2 DEFAULT hr_api.g_varchar2
308 ,p_benefit_group_id IN NUMBER DEFAULT hr_api.g_number
309 ,p_receipt_of_death_cert_date IN DATE DEFAULT hr_api.g_date
310 ,p_coord_ben_med_pln_no IN VARCHAR2 DEFAULT hr_api.g_varchar2
311 ,p_coord_ben_no_cvg_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
312 ,p_coord_ben_med_ext_er IN VARCHAR2 DEFAULT hr_api.g_varchar2
313 ,p_coord_ben_med_pl_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
314 ,p_coord_ben_med_insr_crr_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
315 ,p_coord_ben_med_insr_crr_ident IN VARCHAR2 DEFAULT hr_api.g_varchar2
316 ,p_coord_ben_med_cvg_strt_dt IN DATE DEFAULT hr_api.g_date
317 ,p_coord_ben_med_cvg_end_dt IN DATE DEFAULT hr_api.g_date
318 ,p_uses_tobacco_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
319 ,p_dpdnt_adoption_date IN DATE DEFAULT hr_api.g_date
320 ,p_dpdnt_vlntry_svce_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
321 ,p_original_date_of_hire IN DATE DEFAULT hr_api.g_date
322 ,p_adjusted_svc_date IN DATE DEFAULT hr_api.g_date
323 ,p_town_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
324 ,p_region_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
325 ,p_country_of_birth IN VARCHAR2 DEFAULT hr_api.g_varchar2
326 ,p_global_person_id IN VARCHAR2 DEFAULT hr_api.g_varchar2
327 ,p_party_id IN NUMBER DEFAULT hr_api.g_number
328 ,p_npw_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
329 --
330 ,p_effective_start_date OUT NOCOPY DATE
331 ,p_effective_end_date OUT NOCOPY DATE
332 ,p_full_name OUT NOCOPY VARCHAR2
333 ,p_comment_id OUT NOCOPY NUMBER
334 ,p_name_combination_warning OUT NOCOPY BOOLEAN
335 ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
336 ,p_orig_hire_warning OUT NOCOPY BOOLEAN ) IS
337 --
338 -- Declare cursors and local variables
339 --
340 l_proc VARCHAR2(72) := g_package||'update_cn_person';
341 l_effective_date DATE;
342 --
343 BEGIN
344
345 hr_cn_api.set_location(g_trace, 'Entering:'|| l_proc, 10);
346 --
347 -- Initialise local variables
348 --
349 l_effective_date := trunc(p_effective_date);
350
351 --
352 -- Check that the person exists.
353 --
354
355 hr_cn_api.check_person (p_person_id,'CN',l_effective_date);
356
357 hr_cn_api.set_location(g_trace, l_proc, 20);
358
359 --
360 -- Update the person record using the update_person BP
361 --
362 hr_person_api.update_person
363 ( p_validate => p_validate
364 ,p_effective_date => l_effective_date
365 ,p_datetrack_update_mode => p_datetrack_update_mode
366 ,p_person_id => p_person_id
367 ,p_object_version_number => p_object_version_number
368 ,p_person_type_id => p_person_type_id
369 ,p_last_name => p_family_or_last_name
370 ,p_applicant_number => p_applicant_number
371 ,p_comments => p_comments
372 ,p_date_employee_data_verified => p_date_employee_data_verified
373 ,p_date_of_birth => p_date_of_birth
374 ,p_email_address => p_email_address
375 ,p_employee_number => p_employee_number
376 ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
377 ,p_first_name => p_given_or_first_name
378 ,p_known_as => p_known_as
379 ,p_marital_status => p_marital_status
380 ,p_middle_names => p_middle_names
381 ,p_nationality => p_nationality
382 ,p_national_identifier => p_citizen_identification_num
383 ,p_previous_last_name => p_previous_last_name
384 ,p_registered_disabled_flag => p_registered_disabled_flag
385 ,p_sex => p_sex
386 ,p_title => p_title
387 ,p_vendor_id => p_vendor_id
388 ,p_work_telephone => p_work_telephone
389 ,p_attribute_category => p_attribute_category
390 ,p_attribute1 => p_attribute1
391 ,p_attribute2 => p_attribute2
392 ,p_attribute3 => p_attribute3
393 ,p_attribute4 => p_attribute4
394 ,p_attribute5 => p_attribute5
395 ,p_attribute6 => p_attribute6
396 ,p_attribute7 => p_attribute7
397 ,p_attribute8 => p_attribute8
398 ,p_attribute9 => p_attribute9
399 ,p_attribute10 => p_attribute10
400 ,p_attribute11 => p_attribute11
401 ,p_attribute12 => p_attribute12
402 ,p_attribute13 => p_attribute13
403 ,p_attribute14 => p_attribute14
404 ,p_attribute15 => p_attribute15
405 ,p_attribute16 => p_attribute16
406 ,p_attribute17 => p_attribute17
407 ,p_attribute18 => p_attribute18
408 ,p_attribute19 => p_attribute19
409 ,p_attribute20 => p_attribute20
410 ,p_attribute21 => p_attribute21
411 ,p_attribute22 => p_attribute22
412 ,p_attribute23 => p_attribute23
413 ,p_attribute24 => p_attribute24
414 ,p_attribute25 => p_attribute25
415 ,p_attribute26 => p_attribute26
416 ,p_attribute27 => p_attribute27
417 ,p_attribute28 => p_attribute28
418 ,p_attribute29 => p_attribute29
419 ,p_attribute30 => p_attribute30
420 ,p_per_information4 => p_hukou_type
421 ,p_per_information5 => p_hukou_location
422 ,p_per_information6 => p_highest_education_level
423 ,p_per_information7 => p_number_of_children
424 ,p_per_information8 => p_expatriate_indicator
425 ,p_per_information10 => p_health_status
426 ,p_per_information11 => p_tax_exemption_indicator
427 ,p_per_information12 => p_percentage
428 ,p_per_information14 => p_family_han_yu_pin_yin_name
429 ,p_per_information15 => p_given_han_yu_pin_yin_name
430 ,p_per_information16 => p_previous_name
431 ,p_per_information17 => p_race_ethnic_orgin
432 ,p_per_information18 => p_social_security_ic_number
433 ,p_date_of_death => p_date_of_death
434 ,p_background_check_status => p_background_check_status
435 ,p_background_date_check => p_background_date_check
436 ,p_blood_type => p_blood_type
437 ,p_correspondence_language => p_correspondence_language
438 ,p_fast_path_employee => p_fast_path_employee
439 ,p_fte_capacity => p_fte_capacity
440 ,p_hold_applicant_date_until => p_hold_applicant_date_until
441 ,p_honors => p_honors
442 ,p_internal_location => p_internal_location
443 ,p_last_medical_test_by => p_last_medical_test_by
444 ,p_last_medical_test_date => p_last_medical_test_date
445 ,p_mailstop => p_mailstop
446 ,p_office_number => p_office_number
447 ,p_on_military_service => p_on_military_service
448 ,p_pre_name_adjunct => p_pre_name_adjunct
449 ,p_projected_start_date => p_projected_start_date
450 ,p_rehire_authorizor => p_rehire_authorizor
451 ,p_rehire_recommendation => p_rehire_recommendation
452 ,p_resume_exists => p_resume_exists
453 ,p_resume_last_updated => p_resume_last_updated
454 ,p_second_passport_exists => p_second_passport_exists
455 ,p_student_status => p_student_status
456 ,p_work_schedule => p_work_schedule
457 ,p_rehire_reason => p_rehire_reason
458 ,p_suffix => p_suffix
459 ,p_benefit_group_id => p_benefit_group_id
460 ,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
461 ,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
462 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
463 ,p_coord_ben_med_ext_er => p_coord_ben_med_ext_er
464 ,p_coord_ben_med_pl_name => p_coord_ben_med_pl_name
465 ,p_coord_ben_med_insr_crr_name => p_coord_ben_med_insr_crr_name
466 ,p_coord_ben_med_insr_crr_ident => p_coord_ben_med_insr_crr_ident
467 ,p_coord_ben_med_cvg_strt_dt => p_coord_ben_med_cvg_strt_dt
468 ,p_coord_ben_med_cvg_end_dt => p_coord_ben_med_cvg_end_dt
469 ,p_uses_tobacco_flag => p_uses_tobacco_flag
470 ,p_dpdnt_adoption_date => p_dpdnt_adoption_date
471 ,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
472 ,p_original_date_of_hire => p_original_date_of_hire
473 ,p_adjusted_svc_date => p_adjusted_svc_date
474 ,p_town_of_birth => p_town_of_birth
475 ,p_region_of_birth => p_region_of_birth
476 ,p_country_of_birth => p_country_of_birth
477 ,p_global_person_id => p_global_person_id
478 ,p_party_id => p_party_id
479 ,p_npw_number => p_npw_number
480 ,p_effective_start_date => p_effective_start_date
481 ,p_effective_end_date => p_effective_end_date
482 ,p_full_name => p_full_name
483 ,p_comment_id => p_comment_id
484 ,p_name_combination_warning => p_name_combination_warning
485 ,p_assign_payroll_warning => p_assign_payroll_warning
486 ,p_orig_hire_warning => p_orig_hire_warning );
487
488 --
489
490 hr_cn_api.set_location(g_trace, 'Leaving:'|| l_proc, 30);
491 --
492 END update_cn_person;
493
494
495 END hr_cn_person_api;
[Home] [Help]