1 Package hr_pl_contact_api as
2 /* $Header: peconpli.pkh 120.4 2005/11/30 05:28:16 mseshadr noship $ */
3 /*#
4 * This package contains contact APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Contact for Poland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------------< create_pl_person >-------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * The following procedure(older version) creates a Polish contact.
17 *
18 * This API is an alternative to the API create_person. If p_validate is set to
19 * false, a person of type 'OTHER' is created. No information is stored in any
20 * other tables.
21 *
22 *
23 * <P> This version of the API is now out-of-date however it has been provided
24 * to you for backward compatibility support and will be removed in the future.
25 * Oracle recommends you to modify existing calling programs in advance of the
26 * support being withdrawn thus avoiding any potential disruption.
27 *
28 * <p><b>Licensing</b><br>
29 * This API is licensed for use with Human Resources.
30 *
31 * <p><b>Prerequisites</b><br>
32 * The business group for Poland legislation must already exist. Also a valid
33 * person_type_id, with a corresponding system type of 'OTHER', must be active
34 * and in the same business group as that of the person being created.
35 *
36 * <p><b>Post Success</b><br>
37 * The contact person will be successfully inserted into the database.
38 *
39 * <p><b>Post Failure</b><br>
40 * The contact person will not be created and an error will be raised.
41 *
42 * @param p_validate If true, then validation alone will be performed and the
43 * database will remain unchanged. If false and all validation checks pass,
44 * then the database will be modified.
45 * @param p_start_date The effective start date of the person.
46 * @param p_business_group_id The person's business group.
47 * @param p_last_name Person's last name.
48 * @param p_sex Person's gender.
49 * @param p_person_type_id This is the identifier corrresponding to the type of
50 * person. If an identification number is not specified, then the API will use
51 * the default 'OTHER' type for the business group.
52 * @param p_comments Comment text.
53 * @param p_date_employee_data_verified Date when the contact last verified the
54 * data.
55 * @param p_date_of_birth Date of birth of the contact. Also if the contact
56 * person is Insured by an Employee, then the date of birth is mandatory.
57 * @param p_email_address Email address of the contact.
58 * @param p_expense_check_send_to_addres Address to use as mailing address.
59 * @param p_first_name Person's first name.
60 * @param p_known_as Preferred name, if different from first name.
61 * @param p_marital_status Marital status of the person.
62 * @param p_middle_names Person's middle name(s).
63 * @param p_nationality Person's nationality.
64 * @param p_inn National identifier of the contact. If the contact person of
65 * nationality 'Polish' is Insured by an Employee, then a PESEL value is
66 * mandatory.
67 * @param p_previous_last_name Previous last name.
68 * @param p_registered_disabled_flag Flag indicating whether person is
69 * classified as disabled.
70 * @param p_title Person's title. Valid values are defined by 'TITLE' lookup
71 * type.
72 * @param p_vendor_id Identification for information about suppliers.
73 * @param p_work_telephone Work telephone.
74 * @param p_attribute_category This context value determines which flexfield
75 * structure to use with the descriptive flexfield segments.
76 * @param p_attribute1 Descriptive flexfield segment.
77 * @param p_attribute2 Descriptive flexfield segment.
78 * @param p_attribute3 Descriptive flexfield segment.
79 * @param p_attribute4 Descriptive flexfield segment.
80 * @param p_attribute5 Descriptive flexfield segment.
81 * @param p_attribute6 Descriptive flexfield segment.
82 * @param p_attribute7 Descriptive flexfield segment.
83 * @param p_attribute8 Descriptive flexfield segment.
84 * @param p_attribute9 Descriptive flexfield segment.
85 * @param p_attribute10 Descriptive flexfield segment.
86 * @param p_attribute11 Descriptive flexfield segment.
87 * @param p_attribute12 Descriptive flexfield segment.
88 * @param p_attribute13 Descriptive flexfield segment.
89 * @param p_attribute14 Descriptive flexfield segment.
90 * @param p_attribute15 Descriptive flexfield segment.
91 * @param p_attribute16 Descriptive flexfield segment.
92 * @param p_attribute17 Descriptive flexfield segment.
93 * @param p_attribute18 Descriptive flexfield segment.
94 * @param p_attribute19 Descriptive flexfield segment.
95 * @param p_attribute20 Descriptive flexfield segment.
96 * @param p_attribute21 Descriptive flexfield segment.
97 * @param p_attribute22 Descriptive flexfield segment.
98 * @param p_attribute23 Descriptive flexfield segment.
99 * @param p_attribute24 Descriptive flexfield segment.
100 * @param p_attribute25 Descriptive flexfield segment.
101 * @param p_attribute26 Descriptive flexfield segment.
102 * @param p_attribute27 Descriptive flexfield segment.
103 * @param p_attribute28 Descriptive flexfield segment.
104 * @param p_attribute29 Descriptive flexfield segment.
105 * @param p_attribute30 Descriptive flexfield segment.
106 * @param p_per_information_category Obsolete parameter, do not use.
107 * @param nip The National Polish Tax identifier of the contact. Also if the
108 * contact person is an 'Inheritor', then the Polish Tax identifier is
109 * mandatory for the contact person.
110 * @param insured_by_employee Indicates if the contact person is insured by
111 * employee (health insurance). Valid values are defined by 'YES_NO' lookup
112 * type.
113 * @param inheritor Indicates if the contact person is an inheritor. Valid
114 * values are defined by 'YES_NO' lookup type.
115 * @param p_per_information4 Developer descriptive flexfield segment.
116 * @param p_per_information5 Developer descriptive flexfield segment.
117 * @param p_per_information6 Developer descriptive flexfield segment.
118 * @param p_per_information7 Developer descriptive flexfield segment.
119 * @param p_per_information8 Developer descriptive flexfield segment.
120 * @param p_per_information9 Developer descriptive flexfield segment.
121 * @param p_per_information10 Developer descriptive flexfield segment.
122 * @param p_per_information11 Developer descriptive flexfield segment.
123 * @param p_per_information12 Developer descriptive flexfield segment.
124 * @param p_per_information13 Developer descriptive flexfield segment.
125 * @param p_per_information14 Developer descriptive flexfield segment.
126 * @param p_per_information15 Developer descriptive flexfield segment.
127 * @param p_per_information16 Developer descriptive flexfield segment.
128 * @param p_per_information17 Developer descriptive flexfield segment.
129 * @param p_per_information18 Developer descriptive flexfield segment.
130 * @param p_per_information19 Developer descriptive flexfield segment.
131 * @param p_per_information20 Developer descriptive flexfield segment.
132 * @param p_per_information21 Developer descriptive flexfield segment.
133 * @param p_per_information22 Developer descriptive flexfield segment.
134 * @param p_per_information23 Developer descriptive flexfield segment.
135 * @param p_per_information24 Developer descriptive flexfield segment.
136 * @param p_per_information25 Developer descriptive flexfield segment.
137 * @param p_per_information26 Developer descriptive flexfield segment.
138 * @param p_per_information27 Developer descriptive flexfield segment.
139 * @param p_per_information28 Developer descriptive flexfield segment.
140 * @param p_per_information29 Developer descriptive flexfield segment.
141 * @param p_per_information30 Developer descriptive flexfield segment.
142 * @param p_correspondence_language Preferred language for correspondance.
143 * @param p_honors Honors or degrees awarded.
144 * @param p_benefit_group_id Identification for benefit group.
145 * @param p_on_military_service Type of military service.
146 * @param p_student_status Type of student status.
147 * @param p_uses_tobacco_flag Tobacoo type used by the contact. Valid values
148 * are defined by 'TOBACCO_USER' lookup type.
149 * @param p_coord_ben_no_cvg_flag Coordination of benefits no other coverage
150 * flag.
151 * @param p_pre_name_adjunct Name prefix.
152 * @param p_suffix Obsolete parameter, do not use.
153 * @param p_town_of_birth Town or city of birth of the contact.
154 * @param p_region_of_birth Geographical region of birth of the contact.
155 * @param p_country_of_birth Country of birth of the contact.
156 * @param p_global_person_id Global Identification number for the person.
157 * @param p_person_id If p_validate is false, then this uniquely identifies the
158 * person created. If p_validate is true, then set to null.
159 * @param p_object_version_number If p_validate is false, then set to the
160 * version number of the created contact. If p_validate is true, then the value
161 * will be null.
162 * @param p_effective_start_date If p_validate is false, then set to the
163 * earliest effective start date for the created contact. If p_validate is
164 * true, then set to null.
165 * @param p_effective_end_date If p_validate is false, then set to the
166 * effective end date for the created contact. If p_validate is true, then set
167 * to null.
168 * @param p_full_name If p_validate is false, this will be set to the complete
169 * full name of the person. If p_validate is true this will be null.
170 * @param p_comment_id If p_validate is false and comment text was provided,
171 * then will be set to the identifier of the created contact comment record. If
172 * p_validate is true or no comment text was provided, then will be null.
173 * @param p_name_combination_warning If set to true, then the combination of
174 * last name, first name and date of birth existed prior to calling this API.
175 * @param p_orig_hire_warning Set to true if the person type is not EMP,
176 * EMP_APL, EX_EMP or EX_EMP_APL and the original_date_of_hire is not null.
177 * @rep:displayname Create Contact for Poland
178 * @rep:category BUSINESS_ENTITY PER_PERSONAL_CONTACT
179 * @rep:lifecycle deprecated
180 * @rep:scope public
181 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
182 */
183 --
184 -- {End Of Comments}
185 --
186 procedure create_pl_person
187 (p_validate in boolean default false
188 ,p_start_date in date
189 ,p_business_group_id in number
190 ,p_last_name in varchar2
191 ,p_sex in varchar2
192 ,p_person_type_id in number default null
193 ,p_comments in varchar2 default null
194 ,p_date_employee_data_verified in date default null
195 ,p_date_of_birth in date default null
196 ,p_email_address in varchar2 default null
197 ,p_expense_check_send_to_addres in varchar2 default null
198 ,p_first_name in varchar2 default null
199 ,p_known_as in varchar2 default null
200 ,p_marital_status in varchar2 default null
201 ,p_middle_names in varchar2 default null
202 ,p_nationality in varchar2 default null
203 ,p_inn in varchar2 default null
204 ,p_previous_last_name in varchar2 default null
205 ,p_registered_disabled_flag in varchar2 default null
206 ,p_title in varchar2 default null
207 ,p_vendor_id in number default null
208 ,p_work_telephone in varchar2 default null
209 ,p_attribute_category in varchar2 default null
210 ,p_attribute1 in varchar2 default null
211 ,p_attribute2 in varchar2 default null
212 ,p_attribute3 in varchar2 default null
213 ,p_attribute4 in varchar2 default null
214 ,p_attribute5 in varchar2 default null
215 ,p_attribute6 in varchar2 default null
216 ,p_attribute7 in varchar2 default null
217 ,p_attribute8 in varchar2 default null
218 ,p_attribute9 in varchar2 default null
219 ,p_attribute10 in varchar2 default null
220 ,p_attribute11 in varchar2 default null
221 ,p_attribute12 in varchar2 default null
222 ,p_attribute13 in varchar2 default null
223 ,p_attribute14 in varchar2 default null
224 ,p_attribute15 in varchar2 default null
225 ,p_attribute16 in varchar2 default null
226 ,p_attribute17 in varchar2 default null
227 ,p_attribute18 in varchar2 default null
228 ,p_attribute19 in varchar2 default null
229 ,p_attribute20 in varchar2 default null
230 ,p_attribute21 in varchar2 default null
231 ,p_attribute22 in varchar2 default null
232 ,p_attribute23 in varchar2 default null
233 ,p_attribute24 in varchar2 default null
234 ,p_attribute25 in varchar2 default null
235 ,p_attribute26 in varchar2 default null
236 ,p_attribute27 in varchar2 default null
237 ,p_attribute28 in varchar2 default null
238 ,p_attribute29 in varchar2 default null
239 ,p_attribute30 in varchar2 default null
240 ,p_per_information_category in varchar2 default null
241 ,NIP in varchar2 default null
242 ,Insured_by_Employee in varchar2 default null
243 ,Inheritor in varchar2 default null
244 ,p_per_information4 in varchar2 default null
245 ,p_per_information5 in varchar2 default null
246 ,p_per_information6 in varchar2 default null
247 ,p_per_information7 in varchar2 default null
251 ,p_per_information11 in varchar2 default null
248 ,p_per_information8 in varchar2 default null
249 ,p_per_information9 in varchar2 default null
250 ,p_per_information10 in varchar2 default null
252 ,p_per_information12 in varchar2 default null
253 ,p_per_information13 in varchar2 default null
254 ,p_per_information14 in varchar2 default null
255 ,p_per_information15 in varchar2 default null
256 ,p_per_information16 in varchar2 default null
257 ,p_per_information17 in varchar2 default null
258 ,p_per_information18 in varchar2 default null
259 ,p_per_information19 in varchar2 default null
260 ,p_per_information20 in varchar2 default null
261 ,p_per_information21 in varchar2 default null
262 ,p_per_information22 in varchar2 default null
263 ,p_per_information23 in varchar2 default null
264 ,p_per_information24 in varchar2 default null
265 ,p_per_information25 in varchar2 default null
266 ,p_per_information26 in varchar2 default null
267 ,p_per_information27 in varchar2 default null
268 ,p_per_information28 in varchar2 default null
269 ,p_per_information29 in varchar2 default null
270 ,p_per_information30 in varchar2 default null
271 ,p_correspondence_language in varchar2 default null
272 ,p_honors in varchar2 default null
273 ,p_benefit_group_id in number default null
274 ,p_on_military_service in varchar2 default null
275 ,p_student_status in varchar2 default null
276 ,p_uses_tobacco_flag in varchar2 default null
277 ,p_coord_ben_no_cvg_flag in varchar2 default null
278 ,p_pre_name_adjunct in varchar2 default null
279 ,p_suffix in varchar2 default null
280 ,p_town_of_birth in varchar2 default null
281 ,p_region_of_birth in varchar2 default null
282 ,p_country_of_birth in varchar2 default null
283 ,p_global_person_id in varchar2 default null
284 ,p_person_id out nocopy number
285 ,p_object_version_number out nocopy number
286 ,p_effective_start_date out nocopy date
287 ,p_effective_end_date out nocopy date
288 ,p_full_name out nocopy varchar2
289 ,p_comment_id out nocopy number
290 ,p_name_combination_warning out nocopy boolean
291 ,p_orig_hire_warning out nocopy boolean
292 );
293
294 --
295 -- ----------------------------------------------------------------------------
296 -- |---------------------------< create_pl_person >-------------------------|
297 -- ----------------------------------------------------------------------------
298 -- {Start Of Comments}
299 /*#
300 * The following procedure creates a Polish contact.
301 *
302 * This API is an alternative to the API create_person. If p_validate is set to
303 * false, a person of type 'OTHER' is created. No information is stored in any
304 * other tables.
305 *
306 * <p><b>Licensing</b><br>
307 * This API is licensed for use with Human Resources.
308 *
309 * <p><b>Prerequisites</b><br>
310 * The business group for Poland legislation must already exist. Also a valid
311 * person_type_id, with a corresponding system type of 'OTHER', must be active
312 * and in the same business group as that of the person being created.
313 *
314 * <p><b>Post Success</b><br>
315 * The contact person will be successfully inserted into the database.
316 *
317 * <p><b>Post Failure</b><br>
318 * The contact person will not be created and an error will be raised.
319 *
320 * @param p_validate If true, then validation alone will be performed and the
321 * database will remain unchanged. If false and all validation checks pass,
322 * then the database will be modified.
323 * @param p_start_date The effective start date of the person.
324 * @param p_business_group_id The person's business group.
325 * @param p_last_name Person's last name.
326 * @param p_sex Person's gender.
327 * @param p_person_type_id This is the identifier corrresponding to the type of
328 * person. If an identification number is not specified, then the API will use
329 * the default 'OTHER' type for the business group.
330 * @param p_comments Comment text.
331 * @param p_date_employee_data_verified Date when the contact last verified the
332 * data.
333 * @param p_date_of_birth Date of birth of the contact. Also if the contact
334 * person is Insured by an Employee, then the date of birth is mandatory.
335 * @param p_email_address Email address of the contact.
336 * @param p_expense_check_send_to_addres Address to use as mailing address.
337 * @param p_first_name Person's first name.
338 * @param p_known_as Preferred name, if different from first name.
339 * @param p_marital_status Marital status of the person.
340 * @param p_middle_names Person's middle name(s).
341 * @param p_nationality Person's nationality.
342 * @param p_pesel Contact's national identifier.If a contact's
343 * nationality and citizenship are both Polish
344 * and is insured by an employee, then PESEL or NIP has to be specified.
345 * @param p_previous_last_name Previous last name.
346 * @param p_registered_disabled_flag Flag indicating whether person is
347 * classified as disabled.
348 * @param p_title Person's title. Valid values are defined by 'TITLE' lookup
349 * type.
350 * @param p_vendor_id Identification for information about suppliers.
351 * @param p_work_telephone Work telephone.
352 * @param p_attribute_category This context value determines which flexfield
356 * @param p_attribute3 Descriptive flexfield segment.
353 * structure to use with the descriptive flexfield segments.
354 * @param p_attribute1 Descriptive flexfield segment.
355 * @param p_attribute2 Descriptive flexfield segment.
357 * @param p_attribute4 Descriptive flexfield segment.
358 * @param p_attribute5 Descriptive flexfield segment.
359 * @param p_attribute6 Descriptive flexfield segment.
360 * @param p_attribute7 Descriptive flexfield segment.
361 * @param p_attribute8 Descriptive flexfield segment.
362 * @param p_attribute9 Descriptive flexfield segment.
363 * @param p_attribute10 Descriptive flexfield segment.
364 * @param p_attribute11 Descriptive flexfield segment.
365 * @param p_attribute12 Descriptive flexfield segment.
366 * @param p_attribute13 Descriptive flexfield segment.
367 * @param p_attribute14 Descriptive flexfield segment.
368 * @param p_attribute15 Descriptive flexfield segment.
369 * @param p_attribute16 Descriptive flexfield segment.
370 * @param p_attribute17 Descriptive flexfield segment.
371 * @param p_attribute18 Descriptive flexfield segment.
372 * @param p_attribute19 Descriptive flexfield segment.
373 * @param p_attribute20 Descriptive flexfield segment.
374 * @param p_attribute21 Descriptive flexfield segment.
375 * @param p_attribute22 Descriptive flexfield segment.
376 * @param p_attribute23 Descriptive flexfield segment.
377 * @param p_attribute24 Descriptive flexfield segment.
378 * @param p_attribute25 Descriptive flexfield segment.
379 * @param p_attribute26 Descriptive flexfield segment.
380 * @param p_attribute27 Descriptive flexfield segment.
381 * @param p_attribute28 Descriptive flexfield segment.
382 * @param p_attribute29 Descriptive flexfield segment.
383 * @param p_attribute30 Descriptive flexfield segment.
384 * @param p_per_information_category Obsolete parameter, do not use.
385 * @param p_nip Contact's national Polish tax identifier. If the contact is an
386 * inheritor and nationality and citizenship are both Polish
387 * then the Polish tax identifier is mandatory.
388 * @param p_insured_by_employee Indicates if the contact is insured by the
389 * employee (health insurance). The lookup type 'YES_NO' defines the valid
390 * values.
391 * @param p_inheritor Indicates if the contact is an inheritor. The lookup type
392 * 'YES_NO' defines the valid values.
393 * @param p_oldage_pension_rights This indicates whether the contact
394 * has old age or pension rights.The lookup type 'PL_OLDAGE_PENSION_RIGHTS'
395 * defines the valid values for the Polish legislation.
396 * @param p_national_fund_of_health This indicates the national fund of health
397 * to which the contact belongs.The lookup type 'PL_NATIONAL_FUND_OF_HEALTH'
398 * defines the valid values for the Polish legislation.
399 * @param p_tax_office Specifies the tax office of the contact.
400 * @param p_legal_employer Specifies the legal employer of the contact.
401 * @param p_citizenship This indicates the citizenship of the contact.
402 * The lookup type 'PL_CITIZENSHIP' defines the valid values for the
403 * Polish legislation.
404 * @param p_correspondence_language Preferred language for correspondance.
405 * @param p_honors Honors or degrees awarded.
406 * @param p_benefit_group_id Identification for benefit group.
407 * @param p_on_military_service Type of military service.
408 * @param p_student_status Type of student status.
409 * @param p_uses_tobacco_flag Tobacoo type used by the contact. Valid values
410 * are defined by 'TOBACCO_USER' lookup type.
411 * @param p_coord_ben_no_cvg_flag Coordination of benefits no other coverage
412 * flag.
413 * @param p_pre_name_adjunct Name prefix.
414 * @param p_suffix Obsolete parameter, do not use.
415 * @param p_town_of_birth Town or city of birth of the contact.
416 * @param p_region_of_birth Geographical region of birth of the contact.
417 * @param p_country_of_birth Country of birth of the contact.
418 * @param p_global_person_id Global Identification number for the person.
419 * @param p_person_id If p_validate is false, then this uniquely identifies the
420 * person created. If p_validate is true, then set to null.
421 * @param p_object_version_number If p_validate is false, then set to the
422 * version number of the created contact. If p_validate is true, then the value
423 * will be null.
424 * @param p_effective_start_date If p_validate is false, then set to the
425 * earliest effective start date for the created contact. If p_validate is
426 * true, then set to null.
427 * @param p_effective_end_date If p_validate is false, then set to the
428 * effective end date for the created contact. If p_validate is true, then set
429 * to null.
430 * @param p_full_name If p_validate is false, this will be set to the complete
431 * full name of the person. If p_validate is true this will be null.
432 * @param p_comment_id If p_validate is false and comment text was provided,
433 * then will be set to the identifier of the created contact comment record. If
434 * p_validate is true or no comment text was provided, then will be null.
435 * @param p_name_combination_warning If set to true, then the combination of
436 * last name, first name and date of birth existed prior to calling this API.
437 * @param p_orig_hire_warning Set to true if the person type is not EMP,
438 * EMP_APL, EX_EMP or EX_EMP_APL and the original_date_of_hire is not null.
439 * @rep:displayname Create Contact for Poland
440 * @rep:category BUSINESS_ENTITY PER_PERSONAL_CONTACT
441 * @rep:lifecycle active
442 * @rep:primaryinstance
443 * @rep:scope public
444 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
445 */
446 -- {End Of Comments}
447 --
448
449
450 procedure create_pl_person
451 (p_validate in boolean default false
452 ,p_start_date in date
453 ,p_business_group_id in number
454 ,p_last_name in varchar2
455 ,p_sex in varchar2
459 ,p_date_of_birth in date default null
456 ,p_person_type_id in number default null
457 ,p_comments in varchar2 default null
458 ,p_date_employee_data_verified in date default null
460 ,p_email_address in varchar2 default null
461 ,p_expense_check_send_to_addres in varchar2 default null
462 ,p_first_name in varchar2 default null
463 ,p_known_as in varchar2 default null
464 ,p_marital_status in varchar2 default null
465 ,p_middle_names in varchar2 default null
466 ,p_nationality in varchar2 default null
467 ,p_pesel in varchar2 default null
468 ,p_previous_last_name in varchar2 default null
469 ,p_registered_disabled_flag in varchar2 default null
470 ,p_title in varchar2 default null
471 ,p_vendor_id in number default null
472 ,p_work_telephone in varchar2 default null
473 ,p_attribute_category in varchar2 default null
474 ,p_attribute1 in varchar2 default null
475 ,p_attribute2 in varchar2 default null
476 ,p_attribute3 in varchar2 default null
477 ,p_attribute4 in varchar2 default null
478 ,p_attribute5 in varchar2 default null
479 ,p_attribute6 in varchar2 default null
480 ,p_attribute7 in varchar2 default null
481 ,p_attribute8 in varchar2 default null
482 ,p_attribute9 in varchar2 default null
483 ,p_attribute10 in varchar2 default null
484 ,p_attribute11 in varchar2 default null
485 ,p_attribute12 in varchar2 default null
486 ,p_attribute13 in varchar2 default null
487 ,p_attribute14 in varchar2 default null
488 ,p_attribute15 in varchar2 default null
489 ,p_attribute16 in varchar2 default null
490 ,p_attribute17 in varchar2 default null
491 ,p_attribute18 in varchar2 default null
492 ,p_attribute19 in varchar2 default null
493 ,p_attribute20 in varchar2 default null
494 ,p_attribute21 in varchar2 default null
495 ,p_attribute22 in varchar2 default null
496 ,p_attribute23 in varchar2 default null
497 ,p_attribute24 in varchar2 default null
498 ,p_attribute25 in varchar2 default null
499 ,p_attribute26 in varchar2 default null
500 ,p_attribute27 in varchar2 default null
501 ,p_attribute28 in varchar2 default null
502 ,p_attribute29 in varchar2 default null
503 ,p_attribute30 in varchar2 default null
504 ,p_per_information_category in varchar2 default null
505 ,p_nip in varchar2 default null
506 ,p_insured_by_employee in varchar2 default null
507 ,p_inheritor in varchar2 default null
508 ,p_oldage_pension_rights in varchar2 default null
509 ,p_national_fund_of_health in varchar2 default null
510 ,p_tax_office in varchar2 default null
511 ,p_legal_employer in varchar2 default null
512 ,p_citizenship in varchar2 default null
513 ,p_correspondence_language in varchar2 default null
514 ,p_honors in varchar2 default null
515 ,p_benefit_group_id in number default null
516 ,p_on_military_service in varchar2 default null
517 ,p_student_status in varchar2 default null
518 ,p_uses_tobacco_flag in varchar2 default null
519 ,p_coord_ben_no_cvg_flag in varchar2 default null
520 ,p_pre_name_adjunct in varchar2 default null
521 ,p_suffix in varchar2 default null
522 ,p_town_of_birth in varchar2 default null
523 ,p_region_of_birth in varchar2 default null
524 ,p_country_of_birth in varchar2 default null
525 ,p_global_person_id in varchar2 default null
526 ,p_person_id out nocopy number
527 ,p_object_version_number out nocopy number
528 ,p_effective_start_date out nocopy date
529 ,p_effective_end_date out nocopy date
533 ,p_orig_hire_warning out nocopy boolean
530 ,p_full_name out nocopy varchar2
531 ,p_comment_id out nocopy number
532 ,p_name_combination_warning out nocopy boolean
534 );
535
536 end hr_pl_contact_api;