4 * This package contains person APIs for Poland.
1 Package hr_pl_person_api AUTHID CURRENT_USER as
2 /* $Header: peperpli.pkh 120.4 2006/05/11 23:52:18 mseshadr noship $ */
3 /*#
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Person for Poland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------------< update_pl_person >-------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This procedure(older version) updates the record of a Polish person.
17 *
18 * This API is effectively an alternative to the API update_person. If
19 * p_validate is set to false, then the person record is updated.
20 *
21 *
22 * <P> This version of the API is now out-of-date however it has been provided
23 * to you for backward compatibility support and will be removed in the future.
24 * Oracle recommends you to modify existing calling programs in advance of the
25 * support being withdrawn thus avoiding any potential disruption.
26 *
27 * <p><b>Licensing</b><br>
28 * This API is licensed for use with Human Resources.
29 *
30 * <p><b>Prerequisites</b><br>
31 * The person record must exist on the effective date.
32 *
33 * <p><b>Post Success</b><br>
34 * The person will have been updated.
35 *
36 * <p><b>Post Failure</b><br>
37 * The API will not update the person and raises an error.
38 *
39 * @param p_validate If true, then validation alone will be performed and the
40 * database will remain unchanged. If false and all validation checks pass,
41 * then the database will be modified.
42 * @param p_effective_date Determines when the DateTrack operation comes into
43 * force.
44 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
45 * updating the record. You must set to either UPDATE, CORRECTION,
46 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
47 * particular record depend on the dates of previous record changes and the
48 * effective date of this change.
49 * @param p_person_id Identifies the person record to modify.
50 * @param p_object_version_number Pass in the current version number of the
51 * person to be updated. When the API completes if p_validate is false, will be
52 * set to the new version number of the updated person. If p_validate is true
53 * will be set to the same value which was passed in.
54 * @param p_person_type_id The person type identification of the person record
55 * which needs to be updated.
56 * @param p_last_name Last name of the person.
57 * @param p_applicant_number Applicant number of the person.
58 * @param p_comments Comment text.
59 * @param p_date_employee_data_verified Date when the employee last verified
60 * the data.
61 * @param p_date_of_birth Date of birth of the person.
62 * @param p_email_address Email address of the person.
63 * @param p_employee_number The business group's employee number generation
64 * method determines when you can update the employee value. To keep the
65 * existing employee number pass in hr_api.g_varchar2. When the API call
66 * completes if p_validate is false then will be set to the employee number. If
67 * p_validate is true then will be set to the passed value.
68 * @param p_expense_check_send_to_addres Mailing address of the person.
69 * @param p_first_name First Name of the person.
70 * @param p_preferred_name Preferred name of the person, if different from
71 * first name.
72 * @param p_marital_status Marital status of the person. Valid values are
73 * defined by 'MAR_STATUS' lookup type.
74 * @param p_middle_names Person's middle name(s).
75 * @param p_nationality Person's nationality. Valid values are defined by
76 * 'NATIONALITY' lookup type.
77 * @param p_pesel_value National Identifier of the person.
78 * @param p_maiden_name Previous last name of the person.
79 * @param p_registered_disabled_flag Indicates whether person is classified as
80 * disabled. Valid values are defined by 'REGISTERED_DISABLED' lookup type.
81 * @param p_sex Person's gender.
82 * @param p_title Title of the person. Valid values are defined by 'TITLE'
83 * lookup type.
84 * @param p_vendor_id Identifies the organization supplying workers.
85 * @param p_work_telephone Work telephone of the person.
86 * @param p_attribute_category This context value determines which flexfield
87 * structure to use with the descriptive flexfield segments.
88 * @param p_attribute1 Descriptive flexfield segment.
89 * @param p_attribute2 Descriptive flexfield segment.
90 * @param p_attribute3 Descriptive flexfield segment.
91 * @param p_attribute4 Descriptive flexfield segment.
92 * @param p_attribute5 Descriptive flexfield segment.
93 * @param p_attribute6 Descriptive flexfield segment.
94 * @param p_attribute7 Descriptive flexfield segment.
95 * @param p_attribute8 Descriptive flexfield segment.
96 * @param p_attribute9 Descriptive flexfield segment.
100 * @param p_attribute13 Descriptive flexfield segment.
97 * @param p_attribute10 Descriptive flexfield segment.
98 * @param p_attribute11 Descriptive flexfield segment.
99 * @param p_attribute12 Descriptive flexfield segment.
101 * @param p_attribute14 Descriptive flexfield segment.
102 * @param p_attribute15 Descriptive flexfield segment.
103 * @param p_attribute16 Descriptive flexfield segment.
104 * @param p_attribute17 Descriptive flexfield segment.
105 * @param p_attribute18 Descriptive flexfield segment.
106 * @param p_attribute19 Descriptive flexfield segment.
107 * @param p_attribute20 Descriptive flexfield segment.
108 * @param p_attribute21 Descriptive flexfield segment.
109 * @param p_attribute22 Descriptive flexfield segment.
110 * @param p_attribute23 Descriptive flexfield segment.
111 * @param p_attribute24 Descriptive flexfield segment.
112 * @param p_attribute25 Descriptive flexfield segment.
113 * @param p_attribute26 Descriptive flexfield segment.
114 * @param p_attribute27 Descriptive flexfield segment.
115 * @param p_attribute28 Descriptive flexfield segment.
116 * @param p_attribute29 Descriptive flexfield segment.
117 * @param p_attribute30 Descriptive flexfield segment.
118 * @param p_per_information_category Obsolete parameter, do not use.
119 * @param p_nip_value The National Polish Tax identifier of the person. Also
120 * for a contact person who is an 'Inheritor', the Polish Tax identifier is
121 * mandatory.
122 * @param p_per_information2 If a contact record is updated, then this
123 * parameter indicates if the contact person is insured by employee (health
124 * insurance). Valid values are defined by 'YES_NO' lookup type.
125 * @param p_per_information3 If a contact record is updated, then this
126 * parameter indicates if the contact person is an inheritor. Valid values are
127 * defined by 'YES_NO' lookup type.
131 * @param p_per_information7 Developer descriptive flexfield segment.
128 * @param p_per_information4 Developer descriptive flexfield segment.
129 * @param p_per_information5 Developer descriptive flexfield segment.
130 * @param p_per_information6 Developer descriptive flexfield segment.
132 * @param p_per_information8 Developer descriptive flexfield segment.
133 * @param p_per_information9 Developer descriptive flexfield segment.
134 * @param p_per_information10 Developer descriptive flexfield segment.
135 * @param p_per_information11 Developer descriptive flexfield segment.
136 * @param p_per_information12 Developer descriptive flexfield segment.
137 * @param p_per_information13 Developer descriptive flexfield segment.
138 * @param p_per_information14 Developer descriptive flexfield segment.
139 * @param p_per_information15 Developer descriptive flexfield segment.
140 * @param p_per_information16 Developer descriptive flexfield segment.
141 * @param p_per_information17 Developer descriptive flexfield segment.
142 * @param p_per_information18 Developer descriptive flexfield segment.
143 * @param p_per_information19 Developer descriptive flexfield segment.
144 * @param p_per_information20 Developer descriptive flexfield segment.
145 * @param p_per_information21 Developer descriptive flexfield segment.
146 * @param p_per_information22 Developer descriptive flexfield segment.
147 * @param p_per_information23 Developer descriptive flexfield segment.
148 * @param p_per_information24 Developer descriptive flexfield segment.
149 * @param p_per_information25 Developer descriptive flexfield segment.
150 * @param p_per_information26 Developer descriptive flexfield segment.
151 * @param p_per_information27 Developer descriptive flexfield segment.
152 * @param p_per_information28 Developer descriptive flexfield segment.
153 * @param p_per_information29 Developer descriptive flexfield segment.
154 * @param p_per_information30 Developer descriptive flexfield segment.
155 * @param p_date_of_death Currently unsupported.
156 * @param p_background_check_status Y/N flag indicates whether background check
157 * has been performed.
158 * @param p_background_date_check Date background check was performed.
159 * @param p_blood_type Blood type of the person.
160 * @param p_correspondence_language Preferred language for correspondance.
161 * @param p_fast_path_employee Currently not supported.
162 * @param p_fte_capacity Full-time employment capacity of the person.
163 * @param p_hold_applicant_date_until Date until which the applicant should be
164 * put on hold.
165 * @param p_honors Honors or degrees awarded.
166 * @param p_internal_location Internal location of office of the person.
167 * @param p_last_medical_test_by Name of physician who performed last medical
168 * test.
169 * @param p_last_medical_test_date Date of last medical test.
170 * @param p_mailstop Internal mail location for the person.
171 * @param p_office_number Office Number of the person.
172 * @param p_on_military_service Y/N flag indicating whether the person is
173 * employed in military service.
174 * @param p_prefix Obsolete parameter, do not use.
178 * @param p_resume_exists Y/N flag indicating whether resume is on file.
175 * @param p_projected_start_date Currently unsupported.
176 * @param p_rehire_authorizor Currently unsupported.
177 * @param p_rehire_recommendation Re-hire recommendation.
179 * @param p_resume_last_updated Date when the resume was last updated.
180 * @param p_second_passport_exists Y/N flag indicaing whether the person has
181 * multiple passports.
182 * @param p_student_status Full time/part time status of the person.
183 * @param p_work_schedule Type of work schedule indicating which days the
184 * person works. Valid values are defined by 'WORK_SCHEDULE' lookup type.
185 * @param p_rehire_reason Reason for re-hiring the person.
186 * @param p_suffix Obsolete parameter, do not use.
187 * @param p_benefit_group_id Identification for benefit group.
188 * @param p_receipt_of_death_cert_date Date death certificate is received.
189 * @param p_coord_ben_med_pln_no Coordination of benefits medical group plan
190 * number.
191 * @param p_coord_ben_no_cvg_flag Coordinated benefit no other coverage flag.
192 * @param p_coord_ben_med_ext_er Secondary medical coverage external employer.
193 * @param p_coord_ben_med_pl_name Secondary medical coverage name.
194 * @param p_coord_ben_med_insr_crr_name Secondary medical coverage insurance
195 * carrier name.
196 * @param p_coord_ben_med_insr_crr_ident Identifier for secondary medical
197 * coverage insurance carrier.
198 * @param p_coord_ben_med_cvg_strt_dt Secondary medical coverage effective
199 * start date.
200 * @param p_coord_ben_med_cvg_end_dt Secondary medical coverage effective end
201 * date.
202 * @param p_uses_tobacco_flag Tobacoo type used by the person. Valid values are
203 * defined by 'TOBACCO_USER' lookup type.
204 * @param p_dpdnt_adoption_date Date dependent was adopted.
205 * @param p_dpdnt_vlntry_svce_flag Indicates whether the dependent is on
206 * voluntary service.
207 * @param p_original_date_of_hire Original date of hire of the person.
208 * @param p_adjusted_svc_date Adjusted service date.
209 * @param p_town_of_birth Town or city of birth of the person.
210 * @param p_region_of_birth Geographical region of birth of the person.
211 * @param p_country_of_birth Country of birth of the person.
212 * @param p_global_person_id Global Identification number for the person.
213 * @param p_party_id Identifier for the party.
214 * @param p_npw_number Number of non-payrolled worker.
215 * @param p_effective_start_date If p_validate is false, then set to the
216 * effective start date on the updated person row which now exists as of the
217 * effective date. If p_validate is true, then set to null.
218 * @param p_effective_end_date If p_validate is false, then set to the
219 * effective end date on the updated person row which now exists as of the
220 * effective date. If p_validate is true, then set to null.
221 * @param p_full_name If p_validate is false, this will be set to the complete
222 * full name of the person. If p_validate is true this will be null.
223 * @param p_comment_id If p_validate is false and new or existing comment text
224 * exists, then will be set to the identifier of the person comment record. If
225 * p_validate is true or no comment text exists, then will be null.
226 * @param p_name_combination_warning If set to true, then the combination of
227 * last name, first name and date of birth existed prior to calling this API.
228 * @param p_assign_payroll_warning If set to true, then the date of birth is
229 * not entered. If set to false, then the date of birth has been entered.
230 * Indicates if it will be possible to set the payroll on any of this person's
231 * assignments.
232 * @param p_orig_hire_warning Set to true if the original date of hire is not
233 * null and the person type is not EMP,EMP_APL, EX_EMP or EX_EMP_APL.
234 * @rep:displayname Update Person for Poland
238 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
235 * @rep:category BUSINESS_ENTITY HR_PERSON
236 * @rep:scope public
237 * @rep:lifecycle deprecated
239 */
240 --
241 -- {End Of Comments}
242 --
243 procedure update_pl_person
244 (p_validate in boolean default false
245 ,p_effective_date in date
246 ,p_datetrack_update_mode in varchar2
247 ,p_person_id in number
248 ,p_object_version_number in out nocopy number
249 ,p_person_type_id in number default hr_api.g_number
250 ,p_last_name in varchar2 default hr_api.g_varchar2
251 ,p_applicant_number in varchar2 default hr_api.g_varchar2
252 ,p_comments in varchar2 default hr_api.g_varchar2
253 ,p_date_employee_data_verified in date default hr_api.g_date
257 ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
254 ,p_date_of_birth in date default hr_api.g_date
255 ,p_email_address in varchar2 default hr_api.g_varchar2
256 ,p_employee_number in out nocopy varchar2
258 ,p_first_name in varchar2 default hr_api.g_varchar2
259 ,p_preferred_name in varchar2 default hr_api.g_varchar2
260 ,p_marital_status in varchar2 default hr_api.g_varchar2
261 ,p_middle_names in varchar2 default hr_api.g_varchar2
262 ,p_nationality in varchar2 default hr_api.g_varchar2
263 ,p_pesel_value in varchar2 default hr_api.g_varchar2
264 ,p_maiden_name in varchar2 default hr_api.g_varchar2
265 ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
266 ,p_sex in varchar2 default hr_api.g_varchar2
267 ,p_title in varchar2 default hr_api.g_varchar2
268 ,p_vendor_id in number default hr_api.g_number
269 ,p_work_telephone in varchar2 default hr_api.g_varchar2
270 ,p_attribute_category in varchar2 default hr_api.g_varchar2
271 ,p_attribute1 in varchar2 default hr_api.g_varchar2
272 ,p_attribute2 in varchar2 default hr_api.g_varchar2
273 ,p_attribute3 in varchar2 default hr_api.g_varchar2
274 ,p_attribute4 in varchar2 default hr_api.g_varchar2
275 ,p_attribute5 in varchar2 default hr_api.g_varchar2
276 ,p_attribute6 in varchar2 default hr_api.g_varchar2
277 ,p_attribute7 in varchar2 default hr_api.g_varchar2
278 ,p_attribute8 in varchar2 default hr_api.g_varchar2
279 ,p_attribute9 in varchar2 default hr_api.g_varchar2
280 ,p_attribute10 in varchar2 default hr_api.g_varchar2
281 ,p_attribute11 in varchar2 default hr_api.g_varchar2
282 ,p_attribute12 in varchar2 default hr_api.g_varchar2
283 ,p_attribute13 in varchar2 default hr_api.g_varchar2
284 ,p_attribute14 in varchar2 default hr_api.g_varchar2
285 ,p_attribute15 in varchar2 default hr_api.g_varchar2
286 ,p_attribute16 in varchar2 default hr_api.g_varchar2
287 ,p_attribute17 in varchar2 default hr_api.g_varchar2
288 ,p_attribute18 in varchar2 default hr_api.g_varchar2
289 ,p_attribute19 in varchar2 default hr_api.g_varchar2
290 ,p_attribute20 in varchar2 default hr_api.g_varchar2
291 ,p_attribute21 in varchar2 default hr_api.g_varchar2
292 ,p_attribute22 in varchar2 default hr_api.g_varchar2
293 ,p_attribute23 in varchar2 default hr_api.g_varchar2
294 ,p_attribute24 in varchar2 default hr_api.g_varchar2
295 ,p_attribute25 in varchar2 default hr_api.g_varchar2
296 ,p_attribute26 in varchar2 default hr_api.g_varchar2
297 ,p_attribute27 in varchar2 default hr_api.g_varchar2
298 ,p_attribute28 in varchar2 default hr_api.g_varchar2
299 ,p_attribute29 in varchar2 default hr_api.g_varchar2
300 ,p_attribute30 in varchar2 default hr_api.g_varchar2
301 ,p_per_information_category in varchar2 default hr_api.g_varchar2
302 ,p_nip_value in varchar2 default hr_api.g_varchar2
303 ,p_per_information2 in varchar2 default hr_api.g_varchar2
304 ,p_per_information3 in varchar2 default hr_api.g_varchar2
305 ,p_per_information4 in varchar2 default hr_api.g_varchar2
306 ,p_per_information5 in varchar2 default hr_api.g_varchar2
307 ,p_per_information6 in varchar2 default hr_api.g_varchar2
308 ,p_per_information7 in varchar2 default hr_api.g_varchar2
309 ,p_per_information8 in varchar2 default hr_api.g_varchar2
310 ,p_per_information9 in varchar2 default hr_api.g_varchar2
311 ,p_per_information10 in varchar2 default hr_api.g_varchar2
312 ,p_per_information11 in varchar2 default hr_api.g_varchar2
313 ,p_per_information12 in varchar2 default hr_api.g_varchar2
314 ,p_per_information13 in varchar2 default hr_api.g_varchar2
315 ,p_per_information14 in varchar2 default hr_api.g_varchar2
316 ,p_per_information15 in varchar2 default hr_api.g_varchar2
317 ,p_per_information16 in varchar2 default hr_api.g_varchar2
318 ,p_per_information17 in varchar2 default hr_api.g_varchar2
319 ,p_per_information18 in varchar2 default hr_api.g_varchar2
320 ,p_per_information19 in varchar2 default hr_api.g_varchar2
321 ,p_per_information20 in varchar2 default hr_api.g_varchar2
322 ,p_per_information21 in varchar2 default hr_api.g_varchar2
323 ,p_per_information22 in varchar2 default hr_api.g_varchar2
324 ,p_per_information23 in varchar2 default hr_api.g_varchar2
325 ,p_per_information24 in varchar2 default hr_api.g_varchar2
326 ,p_per_information25 in varchar2 default hr_api.g_varchar2
327 ,p_per_information26 in varchar2 default hr_api.g_varchar2
328 ,p_per_information27 in varchar2 default hr_api.g_varchar2
329 ,p_per_information28 in varchar2 default hr_api.g_varchar2
330 ,p_per_information29 in varchar2 default hr_api.g_varchar2
331 ,p_per_information30 in varchar2 default hr_api.g_varchar2
335 ,p_blood_type in varchar2 default hr_api.g_varchar2
332 ,p_date_of_death in date default hr_api.g_date
333 ,p_background_check_status in varchar2 default hr_api.g_varchar2
334 ,p_background_date_check in date default hr_api.g_date
336 ,p_correspondence_language in varchar2 default hr_api.g_varchar2
337 ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
338 ,p_fte_capacity in number default hr_api.g_number
339 ,p_hold_applicant_date_until in date default hr_api.g_date
340 ,p_honors in varchar2 default hr_api.g_varchar2
341 ,p_internal_location in varchar2 default hr_api.g_varchar2
342 ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
343 ,p_last_medical_test_date in date default hr_api.g_date
344 ,p_mailstop in varchar2 default hr_api.g_varchar2
345 ,p_office_number in varchar2 default hr_api.g_varchar2
346 ,p_on_military_service in varchar2 default hr_api.g_varchar2
347 ,p_prefix in varchar2 default hr_api.g_varchar2
348 ,p_projected_start_date in date default hr_api.g_date
349 ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
350 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
351 ,p_resume_exists in varchar2 default hr_api.g_varchar2
352 ,p_resume_last_updated in date default hr_api.g_date
353 ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
354 ,p_student_status in varchar2 default hr_api.g_varchar2
355 ,p_work_schedule in varchar2 default hr_api.g_varchar2
359 ,p_receipt_of_death_cert_date in date default hr_api.g_date
356 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
357 ,p_suffix in varchar2 default hr_api.g_varchar2
358 ,p_benefit_group_id in number default hr_api.g_number
360 ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
361 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
362 ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
363 ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
364 ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
365 ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
366 ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
367 ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
368 ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
369 ,p_dpdnt_adoption_date in date default hr_api.g_date
370 ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
371 ,p_original_date_of_hire in date default hr_api.g_date
372 ,p_adjusted_svc_date in date default hr_api.g_date
373 ,p_town_of_birth in varchar2 default hr_api.g_varchar2
374 ,p_region_of_birth in varchar2 default hr_api.g_varchar2
375 ,p_country_of_birth in varchar2 default hr_api.g_varchar2
376 ,p_global_person_id in varchar2 default hr_api.g_varchar2
377 ,p_party_id in number default hr_api.g_number
378 ,p_npw_number in varchar2 default hr_api.g_varchar2
379 ,p_effective_start_date out nocopy date
380 ,p_effective_end_date out nocopy date
381 ,p_full_name out nocopy varchar2
382 ,p_comment_id out nocopy number
383 ,p_name_combination_warning out nocopy boolean
384 ,p_assign_payroll_warning out nocopy boolean
385 ,p_orig_hire_warning out nocopy boolean
386 );
387
388 -- ----------------------------------------------------------------------------
389 -- |---------------------------< update_pl_person >--------------------------|
390 -- ----------------------------------------------------------------------------
391 --
392 -- {Start Of Comments}
393 /*#
394 * This procedure updates the record of a Polish person.
395 *
396 * This API is effectively an alternative to the API update_person. If
397 * p_validate is set to false, then the person record is updated.
398 *
399 * <p><b>Licensing</b><br>
400 * This API is licensed for use with Human Resources.
401 *
402 * <p><b>Prerequisites</b><br>
403 * The person record must exist on the effective date.
404 *
405 * <p><b>Post Success</b><br>
406 * The person will have been updated.
407 *
408 * <p><b>Post Failure</b><br>
409 * The API will not update the person and raises an error.
410 *
411 * @param p_validate If true, then validation alone will be performed and the
412 * database will remain unchanged. If false and all validation checks pass,
413 * then the database will be modified.
414 * @param p_effective_date Determines when the DateTrack operation comes into
415 * force.
416 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
417 * updating the record. You must set to either UPDATE, CORRECTION,
418 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
419 * particular record depend on the dates of previous record changes and the
420 * effective date of this change.
421 * @param p_person_id Identifies the person record to modify.
422 * @param p_object_version_number Pass in the current version number of the
423 * person to be updated. When the API completes if p_validate is false, will be
424 * set to the new version number of the updated person. If p_validate is true
425 * will be set to the same value which was passed in.
426 * @param p_person_type_id The person type identification of the person record
427 * which needs to be updated.
428 * @param p_last_name Last name of the person.
429 * @param p_applicant_number Applicant number of the person.
430 * @param p_comments Comment text.
431 * @param p_date_employee_data_verified Date when the employee last verified
432 * the data.
433 * @param p_date_of_birth Date of birth of the person.
434 * @param p_email_address Email address of the person.
435 * @param p_employee_number The business group's employee number generation
436 * method determines when you can update the employee value. To keep the
437 * existing employee number pass in hr_api.g_varchar2. When the API call
438 * completes if p_validate is false then will be set to the employee number. If
439 * p_validate is true then will be set to the passed value.
440 * @param p_expense_check_send_to_addres Mailing address of the person.
441 * @param p_first_name First Name of the person.
442 * @param p_preferred_name Preferred name of the person, if different from
443 * first name.
444 * @param p_marital_status Marital status of the person. Valid values are
445 * defined by 'MAR_STATUS' lookup type.
446 * @param p_middle_names Person's middle name(s).
447 * @param p_nationality Person's nationality. Valid values are defined by
448 * 'NATIONALITY' lookup type.
449 * @param p_pesel National Identifier of the person.
450 * @param p_maiden_name Previous last name of the person.
451 * @param p_registered_disabled_flag Indicates whether person is classified as
452 * disabled. Valid values are defined by 'REGISTERED_DISABLED' lookup type.
453 * @param p_sex Person's gender.
454 * @param p_title Title of the person. Valid values are defined by 'TITLE'
455 * lookup type.
456 * @param p_vendor_id Identifies the organization supplying workers.
460 * @param p_attribute1 Descriptive flexfield segment.
457 * @param p_work_telephone Work telephone of the person.
458 * @param p_attribute_category This context value determines which flexfield
459 * structure to use with the descriptive flexfield segments.
461 * @param p_attribute2 Descriptive flexfield segment.
462 * @param p_attribute3 Descriptive flexfield segment.
463 * @param p_attribute4 Descriptive flexfield segment.
464 * @param p_attribute5 Descriptive flexfield segment.
465 * @param p_attribute6 Descriptive flexfield segment.
466 * @param p_attribute7 Descriptive flexfield segment.
467 * @param p_attribute8 Descriptive flexfield segment.
468 * @param p_attribute9 Descriptive flexfield segment.
469 * @param p_attribute10 Descriptive flexfield segment.
470 * @param p_attribute11 Descriptive flexfield segment.
471 * @param p_attribute12 Descriptive flexfield segment.
472 * @param p_attribute13 Descriptive flexfield segment.
473 * @param p_attribute14 Descriptive flexfield segment.
474 * @param p_attribute15 Descriptive flexfield segment.
475 * @param p_attribute16 Descriptive flexfield segment.
476 * @param p_attribute17 Descriptive flexfield segment.
477 * @param p_attribute18 Descriptive flexfield segment.
478 * @param p_attribute19 Descriptive flexfield segment.
479 * @param p_attribute20 Descriptive flexfield segment.
480 * @param p_attribute21 Descriptive flexfield segment.
481 * @param p_attribute22 Descriptive flexfield segment.
482 * @param p_attribute23 Descriptive flexfield segment.
483 * @param p_attribute24 Descriptive flexfield segment.
484 * @param p_attribute25 Descriptive flexfield segment.
485 * @param p_attribute26 Descriptive flexfield segment.
486 * @param p_attribute27 Descriptive flexfield segment.
487 * @param p_attribute28 Descriptive flexfield segment.
488 * @param p_attribute29 Descriptive flexfield segment.
489 * @param p_attribute30 Descriptive flexfield segment.
490 * @param p_per_information_category Obsolete parameter, do not use.
491 * @param p_nip Person's national Polish tax identifier.
492 * @param p_insured_by_employee If a contact record is
493 * updated,then this parameter indicates if the contact
494 * is insured by the employee (health insurance). Valid
495 * values are defined by the 'YES_NO' lookup type.
496 * @param p_inheritor If a contact record is
497 * updated,then this parameter indicates if the contact
498 * is an inheritor. Valid values are defined by the 'YES_NO'
499 * lookup type.
500 * @param p_oldage_pension_rights This indicates whether the person
501 * has old age or pension rights.Valid values are defined by the
502 * 'PL_OLDAGE_PENSION_RIGHTS' lookup type.
503 * @param p_national_fund_of_health This indicates the national fund of health
504 * to which the person belongs.Valid values are defined by 'PL_NATIONAL_FUND_OF_HEALTH'
505 * lookup type.
506 * @param p_tax_office Specifies the tax office of the person.
507 * @param p_legal_employer Specifies the legal employer of the person.
508 * @param p_citizenship This indicates the citizenship of the person.
509 * Valid values are defined by 'PL_CITIZENSHIP' lookup type.
510 * @param p_date_of_death Currently unsupported.
511 * @param p_background_check_status Yes/No flag indicates whether background check
512 * has been performed.
513 * @param p_background_date_check Date background check was performed.
514 * @param p_blood_type Blood type of the person.
515 * @param p_correspondence_language Preferred language for correspondance.
516 * @param p_fast_path_employee Currently not supported.
517 * @param p_fte_capacity Full-time employment capacity of the person.
518 * @param p_hold_applicant_date_until Date until which the applicant should be
519 * put on hold.
520 * @param p_honors Honors or degrees awarded.
521 * @param p_internal_location Internal location of office of the person.
522 * @param p_last_medical_test_by Name of physician who performed last medical
523 * test.
524 * @param p_last_medical_test_date Date of last medical test.
525 * @param p_mailstop Internal mail location for the person.
526 * @param p_office_number Office Number of the person.
527 * @param p_on_military_service Yes/No flag indicating whether the person is
528 * employed in military service.
529 * @param p_prefix Obsolete parameter, do not use.
530 * @param p_projected_start_date Currently unsupported.
531 * @param p_rehire_authorizor Currently unsupported.
532 * @param p_rehire_recommendation Re-hire recommendation.
533 * @param p_resume_exists Yes/No flag indicating whether resume is on file.
534 * @param p_resume_last_updated Date when the resume was last updated.
535 * @param p_second_passport_exists Yes/No flag indicaing whether the person has
536 * multiple passports.
537 * @param p_student_status Full time/part time status of the person.
538 * @param p_work_schedule Type of work schedule indicating which days the
539 * person works. Valid values are defined by 'WORK_SCHEDULE' lookup type.
540 * @param p_rehire_reason Reason for re-hiring the person.
541 * @param p_suffix Obsolete parameter, do not use.
542 * @param p_benefit_group_id Identification for benefit group.
543 * @param p_receipt_of_death_cert_date Date death certificate is received.
544 * @param p_coord_ben_med_pln_no Coordination of benefits medical group plan
545 * number.
546 * @param p_coord_ben_no_cvg_flag Coordinated benefit no other coverage flag.
547 * @param p_coord_ben_med_ext_er Secondary medical coverage external employer.
548 * @param p_coord_ben_med_pl_name Secondary medical coverage name.
549 * @param p_coord_ben_med_insr_crr_name Secondary medical coverage insurance
550 * carrier name.
551 * @param p_coord_ben_med_insr_crr_ident Identifier for secondary medical
552 * coverage insurance carrier.
553 * @param p_coord_ben_med_cvg_strt_dt Secondary medical coverage effective
554 * start date.
555 * @param p_coord_ben_med_cvg_end_dt Secondary medical coverage effective end
556 * date.
557 * @param p_uses_tobacco_flag Tobacoo type used by the person. Valid values are
561 * voluntary service.
558 * defined by 'TOBACCO_USER' lookup type.
559 * @param p_dpdnt_adoption_date Date dependent was adopted.
560 * @param p_dpdnt_vlntry_svce_flag Indicates whether the dependent is on
562 * @param p_original_date_of_hire Original date of hire of the person.
563 * @param p_adjusted_svc_date Adjusted service date.
564 * @param p_town_of_birth Town or city of birth of the person.
565 * @param p_region_of_birth Geographical region of birth of the person.
566 * @param p_country_of_birth Country of birth of the person.
567 * @param p_global_person_id Global Identification number for the person.
568 * @param p_party_id Identifier for the party.
569 * @param p_npw_number Number of non-payrolled worker.
570 * @param p_effective_start_date If p_validate is false, then set to the
571 * effective start date on the updated person row which now exists as of the
572 * effective date. If p_validate is true, then set to null.
573 * @param p_effective_end_date If p_validate is false, then set to the
574 * effective end date on the updated person row which now exists as of the
575 * effective date. If p_validate is true, then set to null.
576 * @param p_full_name If p_validate is false, this will be set to the complete
577 * full name of the person. If p_validate is true this will be null.
578 * @param p_comment_id If p_validate is false and new or existing comment text
579 * exists, then will be set to the identifier of the person comment record. If
580 * p_validate is true or no comment text exists, then will be null.
581 * @param p_name_combination_warning If set to true, then the combination of
582 * last name, first name and date of birth existed prior to calling this API.
583 * @param p_assign_payroll_warning If set to true, then the date of birth is
584 * not entered. If set to false, then the date of birth has been entered.
585 * Indicates if it will be possible to set the payroll on any of this person's
586 * assignments.
587 * @param p_orig_hire_warning Set to true if the original date of hire is not
588 * null and the person type is not EMP,EMP_APL, EX_EMP or EX_EMP_APL.
589 * @rep:displayname Update Person for Poland
590 * @rep:category BUSINESS_ENTITY HR_PERSON
591 * @rep:primaryinstance
592 * @rep:scope public
593 * @rep:lifecycle active
594 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
595 */
596 --
597 -- {End Of Comments}
598 --
599 procedure update_pl_person
600 (p_validate in boolean default false
601 ,p_effective_date in date
602 ,p_datetrack_update_mode in varchar2
603 ,p_person_id in number
604 ,p_object_version_number in out nocopy number
605 ,p_person_type_id in number default hr_api.g_number
606 ,p_last_name in varchar2 default hr_api.g_varchar2
607 ,p_applicant_number in varchar2 default hr_api.g_varchar2
608 ,p_comments in varchar2 default hr_api.g_varchar2
609 ,p_date_employee_data_verified in date default hr_api.g_date
610 ,p_date_of_birth in date default hr_api.g_date
611 ,p_email_address in varchar2 default hr_api.g_varchar2
612 ,p_employee_number in out nocopy varchar2
613 ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
614 ,p_first_name in varchar2 default hr_api.g_varchar2
615 ,p_preferred_name in varchar2 default hr_api.g_varchar2
616 ,p_marital_status in varchar2 default hr_api.g_varchar2
617 ,p_middle_names in varchar2 default hr_api.g_varchar2
618 ,p_nationality in varchar2 default hr_api.g_varchar2
619 ,p_pesel in varchar2 default hr_api.g_varchar2
620 ,p_maiden_name in varchar2 default hr_api.g_varchar2
621 ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
622 ,p_sex in varchar2 default hr_api.g_varchar2
623 ,p_title in varchar2 default hr_api.g_varchar2
624 ,p_vendor_id in number default hr_api.g_number
625 ,p_work_telephone in varchar2 default hr_api.g_varchar2
626 ,p_attribute_category in varchar2 default hr_api.g_varchar2
627 ,p_attribute1 in varchar2 default hr_api.g_varchar2
628 ,p_attribute2 in varchar2 default hr_api.g_varchar2
629 ,p_attribute3 in varchar2 default hr_api.g_varchar2
630 ,p_attribute4 in varchar2 default hr_api.g_varchar2
631 ,p_attribute5 in varchar2 default hr_api.g_varchar2
632 ,p_attribute6 in varchar2 default hr_api.g_varchar2
633 ,p_attribute7 in varchar2 default hr_api.g_varchar2
634 ,p_attribute8 in varchar2 default hr_api.g_varchar2
635 ,p_attribute9 in varchar2 default hr_api.g_varchar2
636 ,p_attribute10 in varchar2 default hr_api.g_varchar2
637 ,p_attribute11 in varchar2 default hr_api.g_varchar2
638 ,p_attribute12 in varchar2 default hr_api.g_varchar2
639 ,p_attribute13 in varchar2 default hr_api.g_varchar2
640 ,p_attribute14 in varchar2 default hr_api.g_varchar2
641 ,p_attribute15 in varchar2 default hr_api.g_varchar2
642 ,p_attribute16 in varchar2 default hr_api.g_varchar2
643 ,p_attribute17 in varchar2 default hr_api.g_varchar2
644 ,p_attribute18 in varchar2 default hr_api.g_varchar2
645 ,p_attribute19 in varchar2 default hr_api.g_varchar2
646 ,p_attribute20 in varchar2 default hr_api.g_varchar2
647 ,p_attribute21 in varchar2 default hr_api.g_varchar2
648 ,p_attribute22 in varchar2 default hr_api.g_varchar2
649 ,p_attribute23 in varchar2 default hr_api.g_varchar2
650 ,p_attribute24 in varchar2 default hr_api.g_varchar2
651 ,p_attribute25 in varchar2 default hr_api.g_varchar2
652 ,p_attribute26 in varchar2 default hr_api.g_varchar2
653 ,p_attribute27 in varchar2 default hr_api.g_varchar2
654 ,p_attribute28 in varchar2 default hr_api.g_varchar2
655 ,p_attribute29 in varchar2 default hr_api.g_varchar2
656 ,p_attribute30 in varchar2 default hr_api.g_varchar2
657 ,p_per_information_category in varchar2 default hr_api.g_varchar2
658 ,p_nip in varchar2 default hr_api.g_varchar2
659 ,p_insured_by_employee in varchar2 default hr_api.g_varchar2
660 ,p_inheritor in varchar2 default hr_api.g_varchar2
661 ,p_oldage_pension_rights in varchar2 default hr_api.g_varchar2
662 ,p_national_fund_of_health in varchar2 default hr_api.g_varchar2
663 ,p_tax_office in varchar2 default hr_api.g_varchar2
664 ,p_legal_employer in varchar2 default hr_api.g_varchar2
665 ,p_citizenship in varchar2 default hr_api.g_varchar2
666 ,p_date_of_death in date default hr_api.g_date
667 ,p_background_check_status in varchar2 default hr_api.g_varchar2
668 ,p_background_date_check in date default hr_api.g_date
669 ,p_blood_type in varchar2 default hr_api.g_varchar2
670 ,p_correspondence_language in varchar2 default hr_api.g_varchar2
671 ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
672 ,p_fte_capacity in number default hr_api.g_number
673 ,p_hold_applicant_date_until in date default hr_api.g_date
674 ,p_honors in varchar2 default hr_api.g_varchar2
675 ,p_internal_location in varchar2 default hr_api.g_varchar2
676 ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
677 ,p_last_medical_test_date in date default hr_api.g_date
678 ,p_mailstop in varchar2 default hr_api.g_varchar2
679 ,p_office_number in varchar2 default hr_api.g_varchar2
680 ,p_on_military_service in varchar2 default hr_api.g_varchar2
681 ,p_prefix in varchar2 default hr_api.g_varchar2
682 ,p_projected_start_date in date default hr_api.g_date
683 ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
684 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
685 ,p_resume_exists in varchar2 default hr_api.g_varchar2
686 ,p_resume_last_updated in date default hr_api.g_date
687 ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
688 ,p_student_status in varchar2 default hr_api.g_varchar2
689 ,p_work_schedule in varchar2 default hr_api.g_varchar2
690 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
691 ,p_suffix in varchar2 default hr_api.g_varchar2
692 ,p_benefit_group_id in number default hr_api.g_number
693 ,p_receipt_of_death_cert_date in date default hr_api.g_date
694 ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
695 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
696 ,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
697 ,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
698 ,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
699 ,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
700 ,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
701 ,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
702 ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
703 ,p_dpdnt_adoption_date in date default hr_api.g_date
704 ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
705 ,p_original_date_of_hire in date default hr_api.g_date
706 ,p_adjusted_svc_date in date default hr_api.g_date
707 ,p_town_of_birth in varchar2 default hr_api.g_varchar2
708 ,p_region_of_birth in varchar2 default hr_api.g_varchar2
709 ,p_country_of_birth in varchar2 default hr_api.g_varchar2
710 ,p_global_person_id in varchar2 default hr_api.g_varchar2
711 ,p_party_id in number default hr_api.g_number
712 ,p_npw_number in varchar2 default hr_api.g_varchar2
713 ,p_effective_start_date out nocopy date
714 ,p_effective_end_date out nocopy date
715 ,p_full_name out nocopy varchar2
716 ,p_comment_id out nocopy number
717 ,p_name_combination_warning out nocopy boolean
718 ,p_assign_payroll_warning out nocopy boolean
719 ,p_orig_hire_warning out nocopy boolean
720 );
721
722 END hr_pl_person_api;
[Home] [Help]