1 Package hr_person_att AUTHID CURRENT_USER as
2 /* $Header: peperati.pkh 115.7 2002/12/02 15:59:07 eumenyio ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |---------------------------< update_person >------------------------------|
5 -- ----------------------------------------------------------------------------
6 --
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This API updates the person record as identified by p_person_id
11 -- and p_object_version_number using the pseudo datetrack modes of
12 -- ATTRIBUTE_UPDATE or ATTRIBUTE_CORRECTION. Depending on the pseudo mode
13 -- specified, the hr_person_api.update_person API is called with true
14 -- datetrack modes of either UPDATE, CORRECTION or UPDATE_CHANGE_INSERT.
15 -- It is important to note that the pseudo modes are not part of DateTrack
16 -- core. The pseudo mode corresponds to the p_attribute_update_mode
17 -- parameter.
18 --
19 -- The ATTRIBUTE_UPDATE will update the current and all rows in the future
20 -- where the attribute(s) have the same value. The future update of the
21 -- attribute(s) will only be completed when either the last row is selected
22 -- or the attribute(s) value has changed.
23 --
24 -- The ATTRIBUTE_CORRECTION works by first updating all rows in the
25 -- future where the attribute(s) have the same value. The future update of
26 -- the attribute will only be completed when either the last row is
27 -- selected or the attribute(s) value has changed. Next, the change has to
28 -- be applied in the past using the same logic as future rows except
29 -- it is only complete when either the first row is selected or the
30 -- attribute value has changed.
31 --
32 -- Prerequisites
33 -- The person record, identified by p_person_id and
34 -- p_object_version_number, must already exist.
35 --
36 -- In Parameters:
37 -- Name Reqd Type Description
38 -- p_validate No boolean If true, the database
39 -- remains unchanged. If false
40 -- then the person will be
41 -- updated.
42 -- p_effective_date Yes date The effective date for this
43 -- change
44 -- p_attribute_update_mode Yes varchar2 Update attribute mode
45 -- Valid values are; ATTRIBUTE_UPDATE,
46 -- ATTRIBUTE_CORRECTION
47 -- p_person_id Yes number ID of person
48 -- p_object_version_number Yes number Version number of the person
49 -- record
50 -- p_person_type_id No number Person type ID
51 -- p_last_name No varchar2 Last name
52 -- p_applicant_number No varchar2 Applicant number
53 -- p_comments No varchar2 Comment text
54 -- p_date_employee_data_verified No date Date when the employee
55 -- data was last verified
56 -- p_date_of_birth No date Date of birth
57 -- p_email_address No varchar2 Email address
58 -- p_employee_number No varchar2 Employee number
59 -- p_expense_check_send_to_addres No varchar2 Mailing address
60 -- p_first_name No varchar2 First name
61 -- p_known_as No varchar2 Known as
62 -- p_marital_status No varchar2 Marital status
63 -- p_middle_names No varchar2 Middle names
64 -- p_nationality No varchar2 Nationality
65 -- p_national_identifier No varchar2 National identifier
66 -- p_previous_last_name No varchar2 Previous last name
67 -- p_registered_disabled_flag No varchar2 Registered disabled flag
68 -- p_sex No varchar2 Gender
69 -- p_title No varchar2 Title
70 -- p_vendor_id No number Foreign key to PO_VENDORS
71 -- p_work_telephone No varchar2 Work telephone
72 -- p_attribute_category No varchar2 Determines the context of
73 -- the user-defined
74 -- descriptive flexfield
75 -- p_attribute1 No varchar2 Descriptive flexfield
76 -- p_attribute2 No varchar2 Descriptive flexfield
77 -- p_attribute3 No varchar2 Descriptive flexfield
78 -- p_attribute4 No varchar2 Descriptive flexfield
79 -- p_attribute5 No varchar2 Descriptive flexfield
80 -- p_attribute6 No varchar2 Descriptive flexfield
81 -- p_attribute7 No varchar2 Descriptive flexfield
82 -- p_attribute8 No varchar2 Descriptive flexfield
83 -- p_attribute9 No varchar2 Descriptive flexfield
84 -- p_attribute10 No varchar2 Descriptive flexfield
85 -- p_attribute11 No varchar2 Descriptive flexfield
89 -- p_attribute15 No varchar2 Descriptive flexfield
86 -- p_attribute12 No varchar2 Descriptive flexfield
87 -- p_attribute13 No varchar2 Descriptive flexfield
88 -- p_attribute14 No varchar2 Descriptive flexfield
90 -- p_attribute16 No varchar2 Descriptive flexfield
91 -- p_attribute17 No varchar2 Descriptive flexfield
92 -- p_attribute18 No varchar2 Descriptive flexfield
93 -- p_attribute19 No varchar2 Descriptive flexfield
94 -- p_attribute20 No varchar2 Descriptive flexfield
95 -- p_attribute21 No varchar2 Descriptive flexfield
96 -- p_attribute22 No varchar2 Descriptive flexfield
97 -- p_attribute23 No varchar2 Descriptive flexfield
98 -- p_attribute24 No varchar2 Descriptive flexfield
99 -- p_attribute25 No varchar2 Descriptive flexfield
100 -- p_attribute26 No varchar2 Descriptive flexfield
101 -- p_attribute27 No varchar2 Descriptive flexfield
102 -- p_attribute28 No varchar2 Descriptive flexfield
103 -- p_attribute29 No varchar2 Descriptive flexfield
104 -- p_attribute30 No varchar2 Descriptive flexfield
105 -- p_per_information_category No varchar2 Determines the context of
106 -- the developer descriptive
107 -- flexfield
108 -- p_per_information1 No varchar2 Developer descriptive
109 -- flexfield
110 -- p_per_information2 No varchar2 Developer descriptive
111 -- flexfield
112 -- p_per_information3 No varchar2 Developer descriptive
113 -- flexfield
114 -- p_per_information4 No varchar2 Developer descriptive
115 -- flexfield
116 -- p_per_information5 No varchar2 Developer descriptive
117 -- flexfield
118 -- p_per_information6 No varchar2 Developer descriptive
119 -- flexfield
120 -- p_per_information7 No varchar2 Developer descriptive
121 -- flexfield
122 -- p_per_information8 No varchar2 Developer descriptive
123 -- flexfield
124 -- p_per_information9 No varchar2 Developer descriptive
125 -- flexfield
126 -- p_per_information10 No varchar2 Developer descriptive
127 -- flexfield
128 -- p_per_information11 No varchar2 Developer descriptive
129 -- flexfield
130 -- p_per_information12 No varchar2 Developer descriptive
131 -- flexfield
132 -- p_per_information13 No varchar2 Developer descriptive
133 -- flexfield
134 -- p_per_information14 No varchar2 Developer descriptive
135 -- flexfield
136 -- p_per_information15 No varchar2 Developer descriptive
137 -- flexfield
138 -- p_per_information16 No varchar2 Developer descriptive
139 -- flexfield
140 -- p_per_information17 No varchar2 Developer descriptive
141 -- flexfield
142 -- p_per_information18 No varchar2 Developer descriptive
143 -- flexfield
144 -- p_per_information19 No varchar2 Developer descriptive
145 -- flexfield
146 -- p_per_information20 No varchar2 Developer descriptive
147 -- flexfield
148 -- p_per_information21 No varchar2 Developer descriptive
149 -- flexfield
150 -- p_per_information22 No varchar2 Developer descriptive
151 -- flexfield
152 -- p_per_information23 No varchar2 Developer descriptive
153 -- flexfield
154 -- p_per_information24 No varchar2 Developer descriptive
155 -- flexfield
156 -- p_per_information25 No varchar2 Developer descriptive
157 -- flexfield
158 -- p_per_information26 No varchar2 Developer descriptive
159 -- flexfield
160 -- p_per_information27 No varchar2 Developer descriptive
161 -- flexfield
162 -- p_per_information28 No varchar2 Developer descriptive
163 -- flexfield
164 -- p_per_information29 No varchar2 Developer descriptive
165 -- flexfield
166 -- p_per_information30 No varchar2 Developer descriptive
167 -- flexfield
168 -- p_date_of_death No date date of death
169 -- p_background_check_status No varchar2 background status check
170 -- p_background_date_check No date background check date
171 -- p_blood_type No varchar2 blood type
175 -- p_hold_applicant_date_until No date hold applicant date until
172 -- p_correspondence_language No varchar2 correspondence language
173 -- p_fast_path_employee No varchar2 fast path employee
174 -- p_fte_capacity No number fte capacity
176 -- p_honors No varchar2 honors
177 -- p_internal_location No varchar2 internal location
178 -- p_last_medical_test_by No varchar2 last medical test by
179 -- p_last_medical_test_date No date last medical test date
180 -- p_mailstop No varchar2 mailstop
181 -- p_office_number No varchar2 office number
182 -- p_on_military_service No varchar2 on military service
183 -- p_pre_name_adjunct No varchar2 pre name adjunct
184 -- p_projected_start_date No date projected start date
185 -- p_rehire_authorizor No varchar2 rehire authorizor
186 -- p_rehire_recommendation No varchar2 rehire recommendation
187 -- p_resume_exists No varchar2 resume exists
188 -- p_resume_last_updated No date resume last updated
189 -- p_second_passport_exists No varchar2 second passport exists
190 -- p_student_status No varchar2 student status
191 -- p_work_schedule No varchar2 work schedule
192 -- p_rehire_reason No varchar2 rehire reason
193 -- p_suffix No varchar2 Person's suffix
194 -- p_benefit_group_id No number Id for benefit group
195 -- p_receipt_of_death_cert_date No date Date death certificate
196 -- was received
197 -- p_coord_ben_med_pln_no No varchar2 Number of an externally
198 -- provided medical plan
199 -- p_coord_ben_no_cvg_flag No varchar2 No other coverage flag
200 -- p_uses_tobacco_flag No varchar2 Uses tobacco flag
201 -- p_dpdnt_adoption_date No date Date dependent was adopted
202 -- p_dpdnt_vlntry_svce_flag No varchar2 Dependent on voluntary
203 -- service flag
204 -- p_original_date_of_hire No date Original date of hire
205 -- p_town_of_birth No varchar2 Town or city of birth
206 -- p_region_of_birth No varchar2 Geographical region of birth
207 -- p_country_of_birth No varchar2 Country of birth
208 -- p_global_person_id No varchar2 Global ID for the person
209 --
210 -- Post Success:
211 -- The API will set the following out parameters:
212 --
213 -- Name Type Description
214 -- p_object_version_number number If p_validate is false, set to
215 -- the new version number of the
216 -- updated person record. If
217 -- p_validate is true set to the
218 -- same value you passed in.
219 -- p_employee_number varchar2 If p_validate is false, set to
220 -- the value of the employee number
221 -- after the person record has
222 -- been updated.
223 -- If p_validate is true, set to
224 -- the same value you passed in.
225 -- This parameter depends on the
226 -- employee number generation method
227 -- of the business group.
228 -- p_effective_start_date date If p_validate is false, set to
229 -- the effective start date of the
230 -- person. If p_validate is true, set
231 -- to null.
232 -- p_effective_end_date date If p_validate is false, set to
233 -- the effective end date of the
234 -- person.
235 -- If p_validate is true, set to
236 -- null.
237 -- p_full_name varchar2 If p_validate is false, set to
238 -- the complete full name of the
239 -- person.
240 -- If p_validate is true, set to
241 -- null.
242 -- p_comment_id number If p_validate is false and any
243 -- comment text exists, set to the id
244 -- of the corresponding person
245 -- comment row.
246 -- If p_validate is true, or no
247 -- comment text exists this will be
248 -- null.
249 -- p_name_combination_warning boolean Set to true if the new
250 -- combination (if changed) of last
251 -- name, first name and date of
252 -- birth already existed prior to
253 -- the update. Else, set to false.
254 -- p_assign_payroll_warning boolean Set to true if the date of birth
255 -- has been updated to a null value,
256 -- and this person is an employee,
260 -- person_type is not EMP,EMP_APL,
257 -- otherwise set to false.
258 -- p_orig_hire_warning boolean Set to true if the original date
259 -- of hire is not null and the
261 -- EX_EMP,EX_EMP_APL.
262 --
263 -- Post Failure:
264 -- The API will not update the person and raises an error.
265 --
266 -- Access Status:
267 -- Internal Development Use Only.
268 --
269 -- {End Of Comments}
270 --
271 procedure update_person
272 (p_validate in boolean default false
273 ,p_effective_date in date
274 ,p_attribute_update_mode in varchar2
275 ,p_person_id in number
276 ,p_object_version_number in out nocopy number
277 ,p_person_type_id in number default hr_api.g_number
278 ,p_last_name in varchar2 default hr_api.g_varchar2
279 ,p_applicant_number in varchar2 default hr_api.g_varchar2
280 ,p_comments in varchar2 default hr_api.g_varchar2
281 ,p_date_employee_data_verified in date default hr_api.g_date
282 ,p_date_of_birth in date default hr_api.g_date
283 ,p_email_address in varchar2 default hr_api.g_varchar2
284 ,p_employee_number in out nocopy varchar2
285 ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
286 ,p_first_name in varchar2 default hr_api.g_varchar2
287 ,p_known_as in varchar2 default hr_api.g_varchar2
288 ,p_marital_status in varchar2 default hr_api.g_varchar2
289 ,p_middle_names in varchar2 default hr_api.g_varchar2
290 ,p_nationality in varchar2 default hr_api.g_varchar2
291 ,p_national_identifier in varchar2 default hr_api.g_varchar2
292 ,p_previous_last_name in varchar2 default hr_api.g_varchar2
293 ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
294 ,p_sex in varchar2 default hr_api.g_varchar2
295 ,p_title in varchar2 default hr_api.g_varchar2
296 ,p_vendor_id in number default hr_api.g_number
297 ,p_work_telephone in varchar2 default hr_api.g_varchar2
298 ,p_suffix in varchar2 default hr_api.g_varchar2
299 ,p_attribute_category in varchar2 default hr_api.g_varchar2
300 ,p_attribute1 in varchar2 default hr_api.g_varchar2
301 ,p_attribute2 in varchar2 default hr_api.g_varchar2
302 ,p_attribute3 in varchar2 default hr_api.g_varchar2
303 ,p_attribute4 in varchar2 default hr_api.g_varchar2
304 ,p_attribute5 in varchar2 default hr_api.g_varchar2
305 ,p_attribute6 in varchar2 default hr_api.g_varchar2
306 ,p_attribute7 in varchar2 default hr_api.g_varchar2
307 ,p_attribute8 in varchar2 default hr_api.g_varchar2
308 ,p_attribute9 in varchar2 default hr_api.g_varchar2
309 ,p_attribute10 in varchar2 default hr_api.g_varchar2
310 ,p_attribute11 in varchar2 default hr_api.g_varchar2
311 ,p_attribute12 in varchar2 default hr_api.g_varchar2
312 ,p_attribute13 in varchar2 default hr_api.g_varchar2
313 ,p_attribute14 in varchar2 default hr_api.g_varchar2
314 ,p_attribute15 in varchar2 default hr_api.g_varchar2
315 ,p_attribute16 in varchar2 default hr_api.g_varchar2
316 ,p_attribute17 in varchar2 default hr_api.g_varchar2
317 ,p_attribute18 in varchar2 default hr_api.g_varchar2
318 ,p_attribute19 in varchar2 default hr_api.g_varchar2
319 ,p_attribute20 in varchar2 default hr_api.g_varchar2
320 ,p_attribute21 in varchar2 default hr_api.g_varchar2
321 ,p_attribute22 in varchar2 default hr_api.g_varchar2
322 ,p_attribute23 in varchar2 default hr_api.g_varchar2
323 ,p_attribute24 in varchar2 default hr_api.g_varchar2
324 ,p_attribute25 in varchar2 default hr_api.g_varchar2
325 ,p_attribute26 in varchar2 default hr_api.g_varchar2
326 ,p_attribute27 in varchar2 default hr_api.g_varchar2
327 ,p_attribute28 in varchar2 default hr_api.g_varchar2
328 ,p_attribute29 in varchar2 default hr_api.g_varchar2
329 ,p_attribute30 in varchar2 default hr_api.g_varchar2
330 ,p_per_information_category in varchar2 default hr_api.g_varchar2
331 ,p_per_information1 in varchar2 default hr_api.g_varchar2
332 ,p_per_information2 in varchar2 default hr_api.g_varchar2
333 ,p_per_information3 in varchar2 default hr_api.g_varchar2
334 ,p_per_information4 in varchar2 default hr_api.g_varchar2
335 ,p_per_information5 in varchar2 default hr_api.g_varchar2
336 ,p_per_information6 in varchar2 default hr_api.g_varchar2
337 ,p_per_information7 in varchar2 default hr_api.g_varchar2
338 ,p_per_information8 in varchar2 default hr_api.g_varchar2
339 ,p_per_information9 in varchar2 default hr_api.g_varchar2
340 ,p_per_information10 in varchar2 default hr_api.g_varchar2
341 ,p_per_information11 in varchar2 default hr_api.g_varchar2
342 ,p_per_information12 in varchar2 default hr_api.g_varchar2
343 ,p_per_information13 in varchar2 default hr_api.g_varchar2
344 ,p_per_information14 in varchar2 default hr_api.g_varchar2
345 ,p_per_information15 in varchar2 default hr_api.g_varchar2
346 ,p_per_information16 in varchar2 default hr_api.g_varchar2
347 ,p_per_information17 in varchar2 default hr_api.g_varchar2
348 ,p_per_information18 in varchar2 default hr_api.g_varchar2
349 ,p_per_information19 in varchar2 default hr_api.g_varchar2
350 ,p_per_information20 in varchar2 default hr_api.g_varchar2
351 ,p_per_information21 in varchar2 default hr_api.g_varchar2
352 ,p_per_information22 in varchar2 default hr_api.g_varchar2
353 ,p_per_information23 in varchar2 default hr_api.g_varchar2
354 ,p_per_information24 in varchar2 default hr_api.g_varchar2
355 ,p_per_information25 in varchar2 default hr_api.g_varchar2
356 ,p_per_information26 in varchar2 default hr_api.g_varchar2
357 ,p_per_information27 in varchar2 default hr_api.g_varchar2
358 ,p_per_information28 in varchar2 default hr_api.g_varchar2
359 ,p_per_information29 in varchar2 default hr_api.g_varchar2
360 ,p_per_information30 in varchar2 default hr_api.g_varchar2
361 ,p_date_of_death in date default hr_api.g_date
362 ,p_background_check_status in varchar2 default hr_api.g_varchar2
363 ,p_background_date_check in date default hr_api.g_date
364 ,p_blood_type in varchar2 default hr_api.g_varchar2
365 ,p_correspondence_language in varchar2 default hr_api.g_varchar2
366 ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
367 ,p_fte_capacity in number default hr_api.g_number
368 ,p_hold_applicant_date_until in date default hr_api.g_date
369 ,p_honors in varchar2 default hr_api.g_varchar2
370 ,p_internal_location in varchar2 default hr_api.g_varchar2
371 ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
372 ,p_last_medical_test_date in date default hr_api.g_date
373 ,p_mailstop in varchar2 default hr_api.g_varchar2
374 ,p_office_number in varchar2 default hr_api.g_varchar2
375 ,p_on_military_service in varchar2 default hr_api.g_varchar2
376 ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
377 ,p_projected_start_date in date default hr_api.g_date
378 ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
379 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
380 ,p_resume_exists in varchar2 default hr_api.g_varchar2
381 ,p_resume_last_updated in date default hr_api.g_date
382 ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
383 ,p_student_status in varchar2 default hr_api.g_varchar2
384 ,p_work_schedule in varchar2 default hr_api.g_varchar2
385 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
386 ,p_benefit_group_id in number default hr_api.g_number
387 ,p_receipt_of_death_cert_date in date default hr_api.g_date
388 ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
389 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
390 ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
391 ,p_dpdnt_adoption_date in date default hr_api.g_date
392 ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
393 ,p_original_date_of_hire in date default hr_api.g_date
394 ,p_town_of_birth in varchar2 default hr_api.g_varchar2
395 ,p_region_of_birth in varchar2 default hr_api.g_varchar2
396 ,p_country_of_birth in varchar2 default hr_api.g_varchar2
397 ,p_global_person_id in varchar2 default hr_api.g_varchar2
398 ,p_effective_start_date out nocopy date
399 ,p_effective_end_date out nocopy date
400 ,p_full_name out nocopy varchar2
401 ,p_comment_id out nocopy number
402 ,p_name_combination_warning out nocopy boolean
403 ,p_assign_payroll_warning out nocopy boolean
404 ,p_orig_hire_warning out nocopy boolean);
405 --
406 end hr_person_att;