1 Package hr_pl_contact_rel_api AUTHID CURRENT_USER as
2 -- $Header: pecrlpli.pkh 120.6 2012/01/19 09:04:35 rpahune ship $ */
3 /*#
4 * This package contains contact relationship APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Contact Relationship for Poland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< create_pl_contact >-------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API(older version) creates a new Polish contact relationship.
17 *
18 * The API is effectively an alternative to the API hr_contact_rel_api. If
19 * p_validate is set to false, a contact relationship is created.
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 business group for Poland legislation must already exist. A valid
32 * person_type_id with a corresponding system type of 'CONTACT', must be active
33 * and in the same business group as that of the contact being created.
34 *
35 * <p><b>Post Success</b><br>
36 * The API successfully creates a contact relationship into the database.
37 *
38 * <p><b>Post Failure</b><br>
39 * The API does not create a contact relationship and raises an error.
40 *
41 * @param p_validate If true, then validation alone will be performed and the
42 * database will remain unchanged. If false and all validation checks pass,
43 * then the database will be modified.
44 * @param p_start_date The effective start date of the contact person.
45 * @param p_business_group_id Identifies the contact person's business group.
46 * @param p_person_id Identifies the person for whom you create the contact
47 * relationship record.
48 * @param p_contact_person_id Identifies the contact person for whom you create
49 * the contact relationship record.
50 * @param p_contact_type Identifies the contact type. The lookup type 'CONTACT'
51 * defines the valid values.
52 * @param p_ctr_comments Comments for the main contact relationship.
53 * @param p_primary_contact_flag Indicates whether contact is primary contact
54 * for the employee.
55 * @param p_date_start The start date of the contact relationship.
56 * @param p_start_life_reason_id Identifies the reason the relationship
57 * started.
58 * @param p_date_end The end date of the relationship.
59 * @param p_end_life_reason_id Identifies the reason the relationship ended.
60 * @param p_rltd_per_rsds_w_dsgntr_flag Indicates if the employee and the
61 * contact live at the same address.
62 * @param p_personal_flag Indicates whether the relationship is a personal
63 * relationship.
64 * @param p_sequence_number The unique sequence number for the relationship
65 * used to identify contacts with a third party organization.
66 * @param p_cont_attribute_category Contact attribute category.
67 * @param p_cont_attribute1 Descriptive flexfield segment.
68 * @param p_cont_attribute2 Descriptive flexfield segment.
69 * @param p_cont_attribute3 Descriptive flexfield segment.
70 * @param p_cont_attribute4 Descriptive flexfield segment.
71 * @param p_cont_attribute5 Descriptive flexfield segment.
72 * @param p_cont_attribute6 Descriptive flexfield segment.
73 * @param p_cont_attribute7 Descriptive flexfield segment.
74 * @param p_cont_attribute8 Descriptive flexfield segment.
75 * @param p_cont_attribute9 Descriptive flexfield segment.
76 * @param p_cont_attribute10 Descriptive flexfield segment.
77 * @param p_cont_attribute11 Descriptive flexfield segment.
78 * @param p_cont_attribute12 Descriptive flexfield segment.
79 * @param p_cont_attribute13 Descriptive flexfield segment.
80 * @param p_cont_attribute14 Descriptive flexfield segment.
81 * @param p_cont_attribute15 Descriptive flexfield segment.
82 * @param p_cont_attribute16 Descriptive flexfield segment.
83 * @param p_cont_attribute17 Descriptive flexfield segment.
84 * @param p_cont_attribute18 Descriptive flexfield segment.
85 * @param p_cont_attribute19 Descriptive flexfield segment.
86 * @param p_cont_attribute20 Descriptive flexfield segment.
87 * @param p_cont_information_category Contact information category.
88 * @param relationship_info Additional relationship information.
89 * @param address_info Additional address information.
90 * @param p_cont_information3 Descriptive flexfield segment.
91 * @param p_cont_information4 Descriptive flexfield segment.
92 * @param p_cont_information5 Descriptive flexfield segment.
93 * @param p_cont_information6 Descriptive flexfield segment.
94 * @param p_cont_information7 Descriptive flexfield segment.
95 * @param p_cont_information8 Descriptive flexfield segment.
96 * @param p_cont_information9 Descriptive flexfield segment.
97 * @param p_cont_information10 Descriptive flexfield segment.
98 * @param p_cont_information11 Descriptive flexfield segment.
99 * @param p_cont_information12 Descriptive flexfield segment.
100 * @param p_cont_information13 Descriptive flexfield segment.
101 * @param p_cont_information14 Descriptive flexfield segment.
102 * @param p_cont_information15 Descriptive flexfield segment.
103 * @param p_cont_information16 Descriptive flexfield segment.
104 * @param p_cont_information17 Descriptive flexfield segment.
105 * @param p_cont_information18 Descriptive flexfield segment.
106 * @param p_cont_information19 Descriptive flexfield segment.
107 * @param p_cont_information20 Descriptive flexfield segment.
108 * @param p_third_party_pay_flag Indicates whether the contact receives third
109 * party payment from the employee.
110 * @param p_bondholder_flag Indicates whether the contact person is a potential
111 * EE bondholder.
112 * @param p_dependent_flag Dependent flag.
113 * @param p_beneficiary_flag Beneficiary flag.
114 * @param p_last_name Contact's last name.
115 * @param p_sex Contact's gender.
116 * @param p_person_type_id Identifies the person type id. If a person_type_id
117 * is not specified, then the API will use the default 'OTHER' system person
118 * type for the business group.
119 * @param p_per_comments Comments for the person record.
120 * @param p_date_of_birth The date of birth of the contact. If the employee has
121 * insured the contact the date of birth is mandatory.
122 * @param p_email_address Contact's e-mail address.
123 * @param p_first_name Contact's first name.
124 * @param p_known_as Contact's preferred name, if different from first name.
125 * @param p_marital_status Contact's marital status. The lookup type
126 * 'MAR_STATUS' defines the valid values.
127 * @param p_middle_names Contact's middle name(s).
128 * @param p_nationality Contact's nationality. The lookup type 'NATIONALITY'
129 * defines the valid values.
130 * @param p_national_identifier Contact's national identifier. If the contact's
131 * nationality is Polish and is insured by an employee, then PESEL is
132 * mandatory.
133 * @param p_previous_last_name Contact's previous last name.
134 * @param p_registered_disabled_flag Indicates whether contact is classified as
135 * disabled. The lookup type 'REGISTERED_DISABLED' defines the valid values.
136 * @param p_title Contact's title. The lookup type 'TITLE' defines the valid
137 * values.
138 * @param p_work_telephone Contact's work telephone.
139 * @param p_attribute_category This context value determines which flexfield
140 * structure to use with the descriptive flexfield segments.
141 * @param p_attribute1 Descriptive flexfield segment.
142 * @param p_attribute2 Descriptive flexfield segment.
143 * @param p_attribute3 Descriptive flexfield segment.
144 * @param p_attribute4 Descriptive flexfield segment.
145 * @param p_attribute5 Descriptive flexfield segment.
146 * @param p_attribute6 Descriptive flexfield segment.
147 * @param p_attribute7 Descriptive flexfield segment.
148 * @param p_attribute8 Descriptive flexfield segment.
149 * @param p_attribute9 Descriptive flexfield segment.
150 * @param p_attribute10 Descriptive flexfield segment.
151 * @param p_attribute11 Descriptive flexfield segment.
152 * @param p_attribute12 Descriptive flexfield segment.
153 * @param p_attribute13 Descriptive flexfield segment.
154 * @param p_attribute14 Descriptive flexfield segment.
155 * @param p_attribute15 Descriptive flexfield segment.
156 * @param p_attribute16 Descriptive flexfield segment.
157 * @param p_attribute17 Descriptive flexfield segment.
158 * @param p_attribute18 Descriptive flexfield segment.
159 * @param p_attribute19 Descriptive flexfield segment.
160 * @param p_attribute20 Descriptive flexfield segment.
161 * @param p_attribute21 Descriptive flexfield segment.
162 * @param p_attribute22 Descriptive flexfield segment.
163 * @param p_attribute23 Descriptive flexfield segment.
164 * @param p_attribute24 Descriptive flexfield segment.
165 * @param p_attribute25 Descriptive flexfield segment.
166 * @param p_attribute26 Descriptive flexfield segment.
167 * @param p_attribute27 Descriptive flexfield segment.
168 * @param p_attribute28 Descriptive flexfield segment.
169 * @param p_attribute29 Descriptive flexfield segment.
170 * @param p_attribute30 Descriptive flexfield segment.
171 * @param p_per_information_category Obsolete parameter, do not use.
172 * @param nip Contact's national Polish tax identifier. If the contact is an
173 * inheritor, then the Polish tax identifier is mandatory.
174 * @param insured_by_employee Indicates if the contact is insured by the
175 * employee (health insurance). The lookup type 'YES_NO' defines the valid
176 * values.
177 * @param inheritor Indicates if the contact is an inheritor. The lookup type
178 * 'YES_NO' defines the valid values.
179 * @param p_per_information4 Developer descriptive flexfield segment.
180 * @param p_per_information5 Developer descriptive flexfield segment.
181 * @param p_per_information6 Developer descriptive flexfield segment.
182 * @param p_per_information7 Developer descriptive flexfield segment.
183 * @param p_per_information8 Developer descriptive flexfield segment.
184 * @param p_per_information9 Developer descriptive flexfield segment.
185 * @param p_per_information10 Developer descriptive flexfield segment.
186 * @param p_per_information11 Developer descriptive flexfield segment.
187 * @param p_per_information12 Developer descriptive flexfield segment.
188 * @param p_per_information13 Developer descriptive flexfield segment.
189 * @param p_per_information14 Developer descriptive flexfield segment.
190 * @param p_per_information15 Developer descriptive flexfield segment.
191 * @param p_per_information16 Developer descriptive flexfield segment.
192 * @param p_per_information17 Developer descriptive flexfield segment.
193 * @param p_per_information18 Developer descriptive flexfield segment.
194 * @param p_per_information19 Developer descriptive flexfield segment.
195 * @param p_per_information20 Developer descriptive flexfield segment.
196 * @param p_per_information21 Developer descriptive flexfield segment.
197 * @param p_per_information22 Developer descriptive flexfield segment.
198 * @param p_per_information23 Developer descriptive flexfield segment.
199 * @param p_per_information24 Developer descriptive flexfield segment.
200 * @param p_per_information25 Developer descriptive flexfield segment.
201 * @param p_per_information26 Developer descriptive flexfield segment.
202 * @param p_per_information27 Developer descriptive flexfield segment.
203 * @param p_per_information28 Developer descriptive flexfield segment.
204 * @param p_per_information29 Developer descriptive flexfield segment.
205 * @param p_per_information30 Developer descriptive flexfield segment.
206 * @param p_correspondence_language Preferred language for correspondance.
207 * @param p_honors Honors or degrees awarded.
208 * @param p_pre_name_adjunct Obsolete parameter, do not use.
209 * @param p_suffix Obsolete parameter, do not use.
210 * @param p_create_mirror_flag Create mirror flag.
211 * @param p_mirror_type Mirror relationship type.
212 * @param p_mirror_cont_attribute_cat Mirror contact attribute category.
213 * @param p_mirror_cont_attribute1 Descriptive flexfield segment.
214 * @param p_mirror_cont_attribute2 Descriptive flexfield segment.
215 * @param p_mirror_cont_attribute3 Descriptive flexfield segment.
216 * @param p_mirror_cont_attribute4 Descriptive flexfield segment.
217 * @param p_mirror_cont_attribute5 Descriptive flexfield segment.
218 * @param p_mirror_cont_attribute6 Descriptive flexfield segment.
219 * @param p_mirror_cont_attribute7 Descriptive flexfield segment.
220 * @param p_mirror_cont_attribute8 Descriptive flexfield segment.
221 * @param p_mirror_cont_attribute9 Descriptive flexfield segment.
222 * @param p_mirror_cont_attribute10 Descriptive flexfield segment.
223 * @param p_mirror_cont_attribute11 Descriptive flexfield segment.
224 * @param p_mirror_cont_attribute12 Descriptive flexfield segment.
225 * @param p_mirror_cont_attribute13 Descriptive flexfield segment.
226 * @param p_mirror_cont_attribute14 Descriptive flexfield segment.
227 * @param p_mirror_cont_attribute15 Descriptive flexfield segment.
228 * @param p_mirror_cont_attribute16 Descriptive flexfield segment.
229 * @param p_mirror_cont_attribute17 Descriptive flexfield segment.
230 * @param p_mirror_cont_attribute18 Descriptive flexfield segment.
231 * @param p_mirror_cont_attribute19 Descriptive flexfield segment.
232 * @param p_mirror_cont_attribute20 Descriptive flexfield segment.
233 * @param p_mirror_cont_information_cat Mirror contact information category.
234 * @param p_mirror_cont_information1 Descriptive flexfield segment.
235 * @param p_mirror_cont_information2 Descriptive flexfield segment.
236 * @param p_mirror_cont_information3 Descriptive flexfield segment.
237 * @param p_mirror_cont_information4 Descriptive flexfield segment.
238 * @param p_mirror_cont_information5 Descriptive flexfield segment.
239 * @param p_mirror_cont_information6 Descriptive flexfield segment.
240 * @param p_mirror_cont_information7 Descriptive flexfield segment.
241 * @param p_mirror_cont_information8 Descriptive flexfield segment.
242 * @param p_mirror_cont_information9 Descriptive flexfield segment.
243 * @param p_mirror_cont_information10 Descriptive flexfield segment.
244 * @param p_mirror_cont_information11 Descriptive flexfield segment.
245 * @param p_mirror_cont_information12 Descriptive flexfield segment.
246 * @param p_mirror_cont_information13 Descriptive flexfield segment.
247 * @param p_mirror_cont_information14 Descriptive flexfield segment.
248 * @param p_mirror_cont_information15 Descriptive flexfield segment.
249 * @param p_mirror_cont_information16 Descriptive flexfield segment.
250 * @param p_mirror_cont_information17 Descriptive flexfield segment.
251 * @param p_mirror_cont_information18 Descriptive flexfield segment.
252 * @param p_mirror_cont_information19 Descriptive flexfield segment.
253 * @param p_mirror_cont_information20 Descriptive flexfield segment.
254 * @param p_contact_relationship_id Identifies the main contact relationship.
255 * If p_validate is false, this uniquely identifies the relationship created.
256 * If p_validate is true this parameter will be null.
257 * @param p_ctr_object_version_number If p_validate is false, this will be set
258 * to the version number of the created contact relationship. If p_validate is
259 * true, then value will be set to null.
260 * @param p_per_person_id If p_validate is false, then this uniquely identifies
261 * the person created. If p_validate is true, then set to null.
262 * @param p_per_object_version_number If p_validate is false, then set to the
263 * version number of the created Person Address. If p_validate is true, then
264 * the value will be null.
265 * @param p_per_effective_start_date If p_validate is false, this will be set
266 * to the effective start date of the person. If p_validate is true this will
267 * be null.
268 * @param p_per_effective_end_date If p_validate is false, this will be set to
269 * the effective end date of the person. If p_validate is true this will be
270 * null.
271 * @param p_full_name If p_validate is false, this will be set to the complete
272 * full name of the person. If p_validate is true this will be null.
273 * @param p_per_comment_id If p_validate is false and comment text was
274 * provided, then will be set to the identifier of the created contact
275 * relationship comment record. If p_validate is true or no comment text was
276 * provided, then will be null.
277 * @param p_name_combination_warning If set to true, then the combination of
278 * last name, first name and date of birth existed prior to calling this API.
279 * @param p_orig_hire_warning Set to true if the original date of hire is not
280 * null and the person type is not EMP, EMP_APL, EX_EMP or EX_EMP_APL.
281 * @rep:displayname Create Contact Relationship for Poland
282 * @rep:category BUSINESS_ENTITY PER_CONTACT_RELATIONSHIP
283 * @rep:lifecycle deprecated
284 * @rep:scope public
285 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
286 */
287 --
288 -- {End Of Comments}
289 --
290 PROCEDURE create_pl_contact
291 (p_validate in boolean default false
292 ,p_start_date in date
293 ,p_business_group_id in number
294 ,p_person_id in number
295 ,p_contact_person_id in number default null
296 ,p_contact_type in varchar2
297 ,p_ctr_comments in varchar2 default null
298 ,p_primary_contact_flag in varchar2 default 'N'
299 ,p_date_start in date default null
300 ,p_start_life_reason_id in number default null
301 ,p_date_end in date default null
302 ,p_end_life_reason_id in number default null
303 ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default 'N'
304 ,p_personal_flag in varchar2 default 'N'
305 ,p_sequence_number in number default null
306 ,p_cont_attribute_category in varchar2 default null
307 ,p_cont_attribute1 in varchar2 default null
308 ,p_cont_attribute2 in varchar2 default null
309 ,p_cont_attribute3 in varchar2 default null
310 ,p_cont_attribute4 in varchar2 default null
311 ,p_cont_attribute5 in varchar2 default null
312 ,p_cont_attribute6 in varchar2 default null
313 ,p_cont_attribute7 in varchar2 default null
314 ,p_cont_attribute8 in varchar2 default null
315 ,p_cont_attribute9 in varchar2 default null
316 ,p_cont_attribute10 in varchar2 default null
317 ,p_cont_attribute11 in varchar2 default null
318 ,p_cont_attribute12 in varchar2 default null
319 ,p_cont_attribute13 in varchar2 default null
320 ,p_cont_attribute14 in varchar2 default null
321 ,p_cont_attribute15 in varchar2 default null
322 ,p_cont_attribute16 in varchar2 default null
323 ,p_cont_attribute17 in varchar2 default null
324 ,p_cont_attribute18 in varchar2 default null
325 ,p_cont_attribute19 in varchar2 default null
326 ,p_cont_attribute20 in varchar2 default null
327 ,p_cont_information_category in varchar2 default null
328 ,Relationship_Info in varchar2 default null
329 ,Address_Info in varchar2 default null
330 ,p_cont_information3 in varchar2 default null
331 ,p_cont_information4 in varchar2 default null
332 ,p_cont_information5 in varchar2 default null
333 ,p_cont_information6 in varchar2 default null
334 ,p_cont_information7 in varchar2 default null
335 ,p_cont_information8 in varchar2 default null
336 ,p_cont_information9 in varchar2 default null
337 ,p_cont_information10 in varchar2 default null
338 ,p_cont_information11 in varchar2 default null
339 ,p_cont_information12 in varchar2 default null
340 ,p_cont_information13 in varchar2 default null
341 ,p_cont_information14 in varchar2 default null
342 ,p_cont_information15 in varchar2 default null
343 ,p_cont_information16 in varchar2 default null
344 ,p_cont_information17 in varchar2 default null
345 ,p_cont_information18 in varchar2 default null
346 ,p_cont_information19 in varchar2 default null
347 ,p_cont_information20 in varchar2 default null
348 ,p_third_party_pay_flag in varchar2 default 'N'
349 ,p_bondholder_flag in varchar2 default 'N'
350 ,p_dependent_flag in varchar2 default 'N'
351 ,p_beneficiary_flag in varchar2 default 'N'
352 ,p_last_name in varchar2 default null
353 ,p_sex in varchar2 default null
354 ,p_person_type_id in number default null
355 ,p_per_comments in varchar2 default null
356 ,p_date_of_birth in date default null
357 ,p_email_address in varchar2 default null
358 ,p_first_name in varchar2 default null
359 ,p_known_as in varchar2 default null
360 ,p_marital_status in varchar2 default null
361 ,p_middle_names in varchar2 default null
362 ,p_nationality in varchar2 default null
363 ,p_national_identifier in varchar2 default null
364 ,p_previous_last_name in varchar2 default null
365 ,p_registered_disabled_flag in varchar2 default null
366 ,p_title in varchar2 default null
367 ,p_work_telephone in varchar2 default null
368 ,p_attribute_category in varchar2 default null
369 ,p_attribute1 in varchar2 default null
370 ,p_attribute2 in varchar2 default null
371 ,p_attribute3 in varchar2 default null
372 ,p_attribute4 in varchar2 default null
373 ,p_attribute5 in varchar2 default null
374 ,p_attribute6 in varchar2 default null
375 ,p_attribute7 in varchar2 default null
376 ,p_attribute8 in varchar2 default null
377 ,p_attribute9 in varchar2 default null
378 ,p_attribute10 in varchar2 default null
379 ,p_attribute11 in varchar2 default null
380 ,p_attribute12 in varchar2 default null
381 ,p_attribute13 in varchar2 default null
382 ,p_attribute14 in varchar2 default null
383 ,p_attribute15 in varchar2 default null
384 ,p_attribute16 in varchar2 default null
385 ,p_attribute17 in varchar2 default null
386 ,p_attribute18 in varchar2 default null
387 ,p_attribute19 in varchar2 default null
388 ,p_attribute20 in varchar2 default null
389 ,p_attribute21 in varchar2 default null
390 ,p_attribute22 in varchar2 default null
391 ,p_attribute23 in varchar2 default null
392 ,p_attribute24 in varchar2 default null
393 ,p_attribute25 in varchar2 default null
394 ,p_attribute26 in varchar2 default null
395 ,p_attribute27 in varchar2 default null
396 ,p_attribute28 in varchar2 default null
397 ,p_attribute29 in varchar2 default null
398 ,p_attribute30 in varchar2 default null
399 ,p_per_information_category in varchar2 default null
400 ,NIP in varchar2 default null
401 ,Insured_by_Employee in varchar2
402 ,Inheritor in varchar2
403 ,p_per_information4 in varchar2 default null
404 ,p_per_information5 in varchar2 default null
405 ,p_per_information6 in varchar2 default null
406 ,p_per_information7 in varchar2 default null
407 ,p_per_information8 in varchar2 default null
408 ,p_per_information9 in varchar2 default null
409 ,p_per_information10 in varchar2 default null
410 ,p_per_information11 in varchar2 default null
411 ,p_per_information12 in varchar2 default null
412 ,p_per_information13 in varchar2 default null
413 ,p_per_information14 in varchar2 default null
414 ,p_per_information15 in varchar2 default null
415 ,p_per_information16 in varchar2 default null
416 ,p_per_information17 in varchar2 default null
417 ,p_per_information18 in varchar2 default null
418 ,p_per_information19 in varchar2 default null
419 ,p_per_information20 in varchar2 default null
420 ,p_per_information21 in varchar2 default null
421 ,p_per_information22 in varchar2 default null
422 ,p_per_information23 in varchar2 default null
423 ,p_per_information24 in varchar2 default null
424 ,p_per_information25 in varchar2 default null
425 ,p_per_information26 in varchar2 default null
426 ,p_per_information27 in varchar2 default null
427 ,p_per_information28 in varchar2 default null
428 ,p_per_information29 in varchar2 default null
429 ,p_per_information30 in varchar2 default null
430 ,p_correspondence_language in varchar2 default null
431 ,p_honors in varchar2 default null
432 ,p_pre_name_adjunct in varchar2 default null
433 ,p_suffix in varchar2 default null
434 ,p_create_mirror_flag in varchar2 default 'N'
435 ,p_mirror_type in varchar2 default null
436 ,p_mirror_cont_attribute_cat in varchar2 default null
437 ,p_mirror_cont_attribute1 in varchar2 default null
438 ,p_mirror_cont_attribute2 in varchar2 default null
439 ,p_mirror_cont_attribute3 in varchar2 default null
440 ,p_mirror_cont_attribute4 in varchar2 default null
441 ,p_mirror_cont_attribute5 in varchar2 default null
442 ,p_mirror_cont_attribute6 in varchar2 default null
443 ,p_mirror_cont_attribute7 in varchar2 default null
444 ,p_mirror_cont_attribute8 in varchar2 default null
445 ,p_mirror_cont_attribute9 in varchar2 default null
446 ,p_mirror_cont_attribute10 in varchar2 default null
447 ,p_mirror_cont_attribute11 in varchar2 default null
448 ,p_mirror_cont_attribute12 in varchar2 default null
449 ,p_mirror_cont_attribute13 in varchar2 default null
450 ,p_mirror_cont_attribute14 in varchar2 default null
451 ,p_mirror_cont_attribute15 in varchar2 default null
452 ,p_mirror_cont_attribute16 in varchar2 default null
453 ,p_mirror_cont_attribute17 in varchar2 default null
454 ,p_mirror_cont_attribute18 in varchar2 default null
455 ,p_mirror_cont_attribute19 in varchar2 default null
456 ,p_mirror_cont_attribute20 in varchar2 default null
457 ,p_mirror_cont_information_cat in varchar2 default null
458 ,p_mirror_cont_information1 in varchar2 default null
459 ,p_mirror_cont_information2 in varchar2 default null
460 ,p_mirror_cont_information3 in varchar2 default null
461 ,p_mirror_cont_information4 in varchar2 default null
462 ,p_mirror_cont_information5 in varchar2 default null
463 ,p_mirror_cont_information6 in varchar2 default null
464 ,p_mirror_cont_information7 in varchar2 default null
465 ,p_mirror_cont_information8 in varchar2 default null
466 ,p_mirror_cont_information9 in varchar2 default null
467 ,p_mirror_cont_information10 in varchar2 default null
468 ,p_mirror_cont_information11 in varchar2 default null
469 ,p_mirror_cont_information12 in varchar2 default null
470 ,p_mirror_cont_information13 in varchar2 default null
471 ,p_mirror_cont_information14 in varchar2 default null
472 ,p_mirror_cont_information15 in varchar2 default null
473 ,p_mirror_cont_information16 in varchar2 default null
474 ,p_mirror_cont_information17 in varchar2 default null
475 ,p_mirror_cont_information18 in varchar2 default null
476 ,p_mirror_cont_information19 in varchar2 default null
477 ,p_mirror_cont_information20 in varchar2 default null
478 ,p_contact_relationship_id out nocopy number
479 ,p_ctr_object_version_number out nocopy number
480 ,p_per_person_id out nocopy number
481 ,p_per_object_version_number out nocopy number
482 ,p_per_effective_start_date out nocopy date
483 ,p_per_effective_end_date out nocopy date
484 ,p_full_name out nocopy varchar2
485 ,p_per_comment_id out nocopy number
486 ,p_name_combination_warning out nocopy boolean
487 ,p_orig_hire_warning out nocopy boolean
488 );
489 --
490 -- ----------------------------------------------------------------------------
491 -- |----------------------< update_pl_contact_relationship >------------------|
492 -- ----------------------------------------------------------------------------
493 --
494 -- {Start Of Comments}
495 /*#
496 * This procedure modifies a contact relationship.
497 *
498 * This API is effectively an alternative to the API hr_contact_rel_api.If
499 * p_validate is set to false, the contact relationship is updated.
500 *
501 * <p><b>Licensing</b><br>
502 * This API is licensed for use with Human Resources.
503 *
504 * <p><b>Prerequisites</b><br>
505 * The contact relationship record identified by p_contact_relationship_id must
506 * already exist.
507 *
508 * <p><b>Post Success</b><br>
509 * The contact relationship is successfully updated.
510 *
511 * <p><b>Post Failure</b><br>
512 * The contact relationship will not be updated and raises an error.
513 *
514 * @param p_validate If true, then validation alone will be performed and the
515 * database will remain unchanged. If false and all validation checks pass,
516 * then the database will be modified.
517 * @param p_effective_date Determines when the DateTrack operation comes into
518 * force.
519 * @param p_contact_relationship_id Identifies the contact relationship record
520 * to be modified.
521 * @param p_contact_type Type of contact. The lookup type 'CONTACT' defines the
522 * valid values.
523 * @param p_comments Contact relationship comment text.
524 * @param p_primary_contact_flag Indicates whether contact is primary contact
525 * for the employee.
526 * @param p_third_party_pay_flag Indicates whether the contact receives third
527 * party payment from the employee.
528 * @param p_bondholder_flag Indicates whether a contact person is a potential
529 * EE bondholder.
530 * @param p_date_start The start date of the relationship.
531 * @param p_start_life_reason_id Identifies the reason the relationship
532 * started.
533 * @param p_date_end The end date of the relationship.
534 * @param p_end_life_reason_id Identifies the reason the relationship ended.
535 * @param p_rltd_per_rsds_w_dsgntr_flag Indicates whether the two people in the
536 * relationship live at the same address.
537 * @param p_personal_flag Indicates whether relationship is a personal
538 * relationship.
539 * @param p_sequence_number The unique sequence number for the relationship
540 * used to identify contacts with a third party organization.
541 * @param p_dependent_flag Dependent flag.
542 * @param p_beneficiary_flag Beneficiary flag.
543 * @param p_cont_attribute_category Contact attribute category.
544 * @param p_cont_attribute1 Descriptive flexfield segment.
545 * @param p_cont_attribute2 Descriptive flexfield segment.
546 * @param p_cont_attribute3 Descriptive flexfield segment.
547 * @param p_cont_attribute4 Descriptive flexfield segment.
548 * @param p_cont_attribute5 Descriptive flexfield segment.
549 * @param p_cont_attribute6 Descriptive flexfield segment.
550 * @param p_cont_attribute7 Descriptive flexfield segment.
551 * @param p_cont_attribute8 Descriptive flexfield segment.
552 * @param p_cont_attribute9 Descriptive flexfield segment.
553 * @param p_cont_attribute10 Descriptive flexfield segment.
554 * @param p_cont_attribute11 Descriptive flexfield segment.
555 * @param p_cont_attribute12 Descriptive flexfield segment.
556 * @param p_cont_attribute13 Descriptive flexfield segment.
557 * @param p_cont_attribute14 Descriptive flexfield segment.
558 * @param p_cont_attribute15 Descriptive flexfield segment.
559 * @param p_cont_attribute16 Descriptive flexfield segment.
560 * @param p_cont_attribute17 Descriptive flexfield segment.
561 * @param p_cont_attribute18 Descriptive flexfield segment.
562 * @param p_cont_attribute19 Descriptive flexfield segment.
563 * @param p_cont_attribute20 Descriptive flexfield segment.
564 * @param p_cont_information_category Contact information category.
565 * @param relationship_info Additional relationship information.
566 * @param address_info Additional address information.
567 * @param p_cont_information3 Descriptive flexfield segment.
568 * @param p_cont_information4 Descriptive flexfield segment.
569 * @param p_cont_information5 Descriptive flexfield segment.
570 * @param p_cont_information6 Descriptive flexfield segment.
571 * @param p_cont_information7 Descriptive flexfield segment.
572 * @param p_cont_information8 Descriptive flexfield segment.
573 * @param p_cont_information9 Descriptive flexfield segment.
574 * @param p_cont_information10 Descriptive flexfield segment.
575 * @param p_cont_information11 Descriptive flexfield segment.
576 * @param p_cont_information12 Descriptive flexfield segment.
577 * @param p_cont_information13 Descriptive flexfield segment.
578 * @param p_cont_information14 Descriptive flexfield segment.
579 * @param p_cont_information15 Descriptive flexfield segment.
580 * @param p_cont_information16 Descriptive flexfield segment.
581 * @param p_cont_information17 Descriptive flexfield segment.
582 * @param p_cont_information18 Descriptive flexfield segment.
583 * @param p_cont_information19 Descriptive flexfield segment.
584 * @param p_cont_information20 Descriptive flexfield segment.
585 * @param p_object_version_number Pass in the current version number of the
586 * Contact Relationship to be updated. When the API completes if p_validate is
587 * false, will be set to the new version number of the updated Contact
588 * Relationship. If p_validate is true will be set to the same value which was
589 * passed in.
590 * @rep:displayname Update Contact Relationship for Poland
591 * @rep:category BUSINESS_ENTITY PER_CONTACT_RELATIONSHIP
592 * @rep:lifecycle active
593 * @rep:scope public
594 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
595 */
596 --
597 -- {End Of Comments}
598 --
599 PROCEDURE update_pl_contact_relationship
600 (p_validate in boolean default false
601 ,p_effective_date in date
602 ,p_contact_relationship_id in number
603 ,p_contact_type in varchar2 default hr_api.g_varchar2
604 ,p_comments in PER_CONTACT_RELATIONSHIPS.COMMENTS%TYPE default hr_api.g_varchar2 -- bug 13375568
605 ,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
606 ,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
607 ,p_bondholder_flag in varchar2 default hr_api.g_varchar2
608 ,p_date_start in date default hr_api.g_date
609 ,p_start_life_reason_id in number default hr_api.g_number
610 ,p_date_end in date default hr_api.g_date
611 ,p_end_life_reason_id in number default hr_api.g_number
612 ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
613 ,p_personal_flag in varchar2 default hr_api.g_varchar2
614 ,p_sequence_number in number default hr_api.g_number
615 ,p_dependent_flag in varchar2 default hr_api.g_varchar2
616 ,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
617 ,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
618 ,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
619 ,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
620 ,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
621 ,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
622 ,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
623 ,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
624 ,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
625 ,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
626 ,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
627 ,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
628 ,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
629 ,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
630 ,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
631 ,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
632 ,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
633 ,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
634 ,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
635 ,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
636 ,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
637 ,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
638 ,p_cont_information_category in varchar2 default hr_api.g_varchar2
639 ,Relationship_Info in varchar2 default hr_api.g_varchar2
640 ,Address_Info in varchar2 default hr_api.g_varchar2
641 ,p_cont_information3 in varchar2 default hr_api.g_varchar2
642 ,p_cont_information4 in varchar2 default hr_api.g_varchar2
643 ,p_cont_information5 in varchar2 default hr_api.g_varchar2
644 ,p_cont_information6 in varchar2 default hr_api.g_varchar2
645 ,p_cont_information7 in varchar2 default hr_api.g_varchar2
646 ,p_cont_information8 in varchar2 default hr_api.g_varchar2
647 ,p_cont_information9 in varchar2 default hr_api.g_varchar2
648 ,p_cont_information10 in varchar2 default hr_api.g_varchar2
649 ,p_cont_information11 in varchar2 default hr_api.g_varchar2
650 ,p_cont_information12 in varchar2 default hr_api.g_varchar2
651 ,p_cont_information13 in varchar2 default hr_api.g_varchar2
652 ,p_cont_information14 in varchar2 default hr_api.g_varchar2
653 ,p_cont_information15 in varchar2 default hr_api.g_varchar2
654 ,p_cont_information16 in varchar2 default hr_api.g_varchar2
655 ,p_cont_information17 in varchar2 default hr_api.g_varchar2
656 ,p_cont_information18 in varchar2 default hr_api.g_varchar2
657 ,p_cont_information19 in varchar2 default hr_api.g_varchar2
658 ,p_cont_information20 in varchar2 default hr_api.g_varchar2
659 ,p_object_version_number in out nocopy number
660 );
661 --
662 -- ----------------------------------------------------------------------------
663 -- |----------------------------< create_pl_contact >-------------------------|
664 -- ----------------------------------------------------------------------------
665 --
666 -- {Start Of Comments}
667 /*#
668 * This API creates a new Polish contact relationship.
669 *
670 * The API is effectively an alternative to the API hr_contact_rel_api. If
671 * p_validate is set to false, a contact relationship is created.
672 *
673 * <p><b>Licensing</b><br>
674 * This API is licensed for use with Human Resources.
675 *
676 * <p><b>Prerequisites</b><br>
677 * The business group for Poland legislation must already exist. A valid
678 * person_type_id with a corresponding system type of 'CONTACT', must be active
679 * and in the same business group as that of the contact being created.
680 *
681 * <p><b>Post Success</b><br>
682 * The API successfully creates a contact relationship into the database.
683 *
684 * <p><b>Post Failure</b><br>
685 * The API does not create a contact relationship and raises an error.
686 *
687 * @param p_validate If true, then validation alone will be performed and the
688 * database will remain unchanged. If false and all validation checks pass,
689 * then the database will be modified.
690 * @param p_start_date The effective start date of the contact person.
691 * @param p_business_group_id Identifies the contact person's business group.
692 * @param p_person_id Identifies the person for whom you create the contact
693 * relationship record.
694 * @param p_contact_person_id Identifies the contact person for whom you create
695 * the contact relationship record.
696 * @param p_contact_type Identifies the contact type. The lookup type 'CONTACT'
697 * defines the valid values.
698 * @param p_ctr_comments Comments for the main contact relationship.
699 * @param p_primary_contact_flag Indicates whether contact is primary contact
700 * for the employee.
701 * @param p_date_start The start date of the contact relationship.
702 * @param p_start_life_reason_id Identifies the reason the relationship
703 * started.
704 * @param p_date_end The end date of the relationship.
705 * @param p_end_life_reason_id Identifies the reason the relationship ended.
706 * @param p_rltd_per_rsds_w_dsgntr_flag Indicates if the employee and the
707 * contact live at the same address.
708 * @param p_personal_flag Indicates whether the relationship is a personal
709 * relationship.
710 * @param p_sequence_number The unique sequence number for the relationship
711 * used to identify contacts with a third party organization.
712 * @param p_cont_attribute_category Contact attribute category.
713 * @param p_cont_attribute1 Descriptive flexfield segment.
714 * @param p_cont_attribute2 Descriptive flexfield segment.
715 * @param p_cont_attribute3 Descriptive flexfield segment.
716 * @param p_cont_attribute4 Descriptive flexfield segment.
717 * @param p_cont_attribute5 Descriptive flexfield segment.
718 * @param p_cont_attribute6 Descriptive flexfield segment.
719 * @param p_cont_attribute7 Descriptive flexfield segment.
720 * @param p_cont_attribute8 Descriptive flexfield segment.
721 * @param p_cont_attribute9 Descriptive flexfield segment.
722 * @param p_cont_attribute10 Descriptive flexfield segment.
723 * @param p_cont_attribute11 Descriptive flexfield segment.
724 * @param p_cont_attribute12 Descriptive flexfield segment.
725 * @param p_cont_attribute13 Descriptive flexfield segment.
726 * @param p_cont_attribute14 Descriptive flexfield segment.
727 * @param p_cont_attribute15 Descriptive flexfield segment.
728 * @param p_cont_attribute16 Descriptive flexfield segment.
729 * @param p_cont_attribute17 Descriptive flexfield segment.
730 * @param p_cont_attribute18 Descriptive flexfield segment.
731 * @param p_cont_attribute19 Descriptive flexfield segment.
732 * @param p_cont_attribute20 Descriptive flexfield segment.
733 * @param p_cont_information_category Contact information category.
734 * @param relationship_info Additional relationship information.
735 * @param address_info Additional address information.
736 * @param p_cont_information3 Descriptive flexfield segment.
737 * @param p_cont_information4 Descriptive flexfield segment.
738 * @param p_cont_information5 Descriptive flexfield segment.
739 * @param p_cont_information6 Descriptive flexfield segment.
740 * @param p_cont_information7 Descriptive flexfield segment.
741 * @param p_cont_information8 Descriptive flexfield segment.
742 * @param p_cont_information9 Descriptive flexfield segment.
743 * @param p_cont_information10 Descriptive flexfield segment.
744 * @param p_cont_information11 Descriptive flexfield segment.
745 * @param p_cont_information12 Descriptive flexfield segment.
746 * @param p_cont_information13 Descriptive flexfield segment.
747 * @param p_cont_information14 Descriptive flexfield segment.
748 * @param p_cont_information15 Descriptive flexfield segment.
749 * @param p_cont_information16 Descriptive flexfield segment.
750 * @param p_cont_information17 Descriptive flexfield segment.
751 * @param p_cont_information18 Descriptive flexfield segment.
752 * @param p_cont_information19 Descriptive flexfield segment.
753 * @param p_cont_information20 Descriptive flexfield segment.
754 * @param p_third_party_pay_flag Indicates whether the contact receives third
755 * party payment from the employee.
756 * @param p_bondholder_flag Indicates whether the contact person is a potential
757 * EE bondholder.
758 * @param p_dependent_flag Dependent flag.
759 * @param p_beneficiary_flag Beneficiary flag.
760 * @param p_last_name Contact's last name.
761 * @param p_sex Contact's gender.
762 * @param p_person_type_id Identifies the person type id. If a person_type_id
763 * is not specified, then the API will use the default 'OTHER' system person
764 * type for the business group.
765 * @param p_per_comments Comments for the person record.
766 * @param p_date_of_birth The date of birth of the contact. If the employee has
767 * insured the contact the date of birth is mandatory.
768 * @param p_email_address Contact's e-mail address.
769 * @param p_first_name Contact's first name.
770 * @param p_known_as Contact's preferred name, if different from first name.
771 * @param p_marital_status Contact's marital status. The lookup type
772 * 'MAR_STATUS' defines the valid values.
773 * @param p_middle_names Contact's middle name(s).
774 * @param p_nationality Contact's nationality. The lookup type 'NATIONALITY'
775 * defines the valid values.
776 * @param p_pesel Contact's national identifier.If a contact's
777 * nationality and citizenship are both Polish
778 * and is insured by an employee, then PESEL or NIP has to be specified.
779 * @param p_previous_last_name Contact's previous last name.
780 * @param p_registered_disabled_flag Indicates whether contact is classified as
781 * disabled. The lookup type 'REGISTERED_DISABLED' defines the valid values.
782 * @param p_title Contact's title. The lookup type 'TITLE' defines the valid
783 * values.
784 * @param p_work_telephone Contact's work telephone.
785 * @param p_attribute_category This context value determines which flexfield
786 * structure to use with the descriptive flexfield segments.
787 * @param p_attribute1 Descriptive flexfield segment.
788 * @param p_attribute2 Descriptive flexfield segment.
789 * @param p_attribute3 Descriptive flexfield segment.
790 * @param p_attribute4 Descriptive flexfield segment.
791 * @param p_attribute5 Descriptive flexfield segment.
792 * @param p_attribute6 Descriptive flexfield segment.
793 * @param p_attribute7 Descriptive flexfield segment.
794 * @param p_attribute8 Descriptive flexfield segment.
795 * @param p_attribute9 Descriptive flexfield segment.
796 * @param p_attribute10 Descriptive flexfield segment.
797 * @param p_attribute11 Descriptive flexfield segment.
798 * @param p_attribute12 Descriptive flexfield segment.
799 * @param p_attribute13 Descriptive flexfield segment.
800 * @param p_attribute14 Descriptive flexfield segment.
801 * @param p_attribute15 Descriptive flexfield segment.
802 * @param p_attribute16 Descriptive flexfield segment.
803 * @param p_attribute17 Descriptive flexfield segment.
804 * @param p_attribute18 Descriptive flexfield segment.
805 * @param p_attribute19 Descriptive flexfield segment.
806 * @param p_attribute20 Descriptive flexfield segment.
807 * @param p_attribute21 Descriptive flexfield segment.
808 * @param p_attribute22 Descriptive flexfield segment.
809 * @param p_attribute23 Descriptive flexfield segment.
810 * @param p_attribute24 Descriptive flexfield segment.
811 * @param p_attribute25 Descriptive flexfield segment.
812 * @param p_attribute26 Descriptive flexfield segment.
813 * @param p_attribute27 Descriptive flexfield segment.
814 * @param p_attribute28 Descriptive flexfield segment.
815 * @param p_attribute29 Descriptive flexfield segment.
816 * @param p_attribute30 Descriptive flexfield segment.
817 * @param p_per_information_category Obsolete parameter, do not use.
818 * @param p_nip Contact's national Polish tax identifier. If the contact is an
819 * inheritor and nationality and citizenship are both Polish
820 * then the Polish tax identifier is mandatory.
821 * @param p_insured_by_employee Indicates if the contact is insured by the
822 * employee (health insurance). The lookup type 'YES_NO' defines the valid
823 * values.
824 * @param p_inheritor Indicates if the contact is an inheritor. The lookup type
825 * 'YES_NO' defines the valid values.
826 * @param p_oldage_pension_rights This indicates whether the contact
827 * has old age or pension rights.The lookup type 'PL_OLDAGE_PENSION_RIGHTS'
828 * defines the valid values for the Polish legislation.
829 * @param p_national_fund_of_health This indicates the national fund of health
830 * to which the contact belongs.The lookup type 'PL_NATIONAL_FUND_OF_HEALTH'
831 * defines the valid values for the Polish legislation.
832 * @param p_tax_office Specifies the tax office of the contact.
833 * @param p_legal_employer Specifies the legal employer of the contact.
834 * @param p_citizenship This indicates the citizenship of the contact.
835 * The lookup type 'PL_CITIZENSHIP' defines the valid values for the
836 * Polish legislation.
837 * @param p_correspondence_language Preferred language for correspondance.
838 * @param p_honors Honors or degrees awarded.
839 * @param p_pre_name_adjunct Obsolete parameter, do not use.
840 * @param p_suffix Obsolete parameter, do not use.
841 * @param p_create_mirror_flag Create mirror flag.
842 * @param p_mirror_type Mirror relationship type.
843 * @param p_mirror_cont_attribute_cat Mirror contact attribute category.
844 * @param p_mirror_cont_attribute1 Descriptive flexfield segment.
845 * @param p_mirror_cont_attribute2 Descriptive flexfield segment.
846 * @param p_mirror_cont_attribute3 Descriptive flexfield segment.
847 * @param p_mirror_cont_attribute4 Descriptive flexfield segment.
848 * @param p_mirror_cont_attribute5 Descriptive flexfield segment.
849 * @param p_mirror_cont_attribute6 Descriptive flexfield segment.
850 * @param p_mirror_cont_attribute7 Descriptive flexfield segment.
851 * @param p_mirror_cont_attribute8 Descriptive flexfield segment.
852 * @param p_mirror_cont_attribute9 Descriptive flexfield segment.
853 * @param p_mirror_cont_attribute10 Descriptive flexfield segment.
854 * @param p_mirror_cont_attribute11 Descriptive flexfield segment.
855 * @param p_mirror_cont_attribute12 Descriptive flexfield segment.
856 * @param p_mirror_cont_attribute13 Descriptive flexfield segment.
857 * @param p_mirror_cont_attribute14 Descriptive flexfield segment.
858 * @param p_mirror_cont_attribute15 Descriptive flexfield segment.
859 * @param p_mirror_cont_attribute16 Descriptive flexfield segment.
860 * @param p_mirror_cont_attribute17 Descriptive flexfield segment.
861 * @param p_mirror_cont_attribute18 Descriptive flexfield segment.
862 * @param p_mirror_cont_attribute19 Descriptive flexfield segment.
863 * @param p_mirror_cont_attribute20 Descriptive flexfield segment.
864 * @param p_mirror_cont_information_cat Mirror contact information category.
865 * @param p_mirror_cont_information1 Descriptive flexfield segment.
866 * @param p_mirror_cont_information2 Descriptive flexfield segment.
867 * @param p_mirror_cont_information3 Descriptive flexfield segment.
868 * @param p_mirror_cont_information4 Descriptive flexfield segment.
869 * @param p_mirror_cont_information5 Descriptive flexfield segment.
870 * @param p_mirror_cont_information6 Descriptive flexfield segment.
871 * @param p_mirror_cont_information7 Descriptive flexfield segment.
872 * @param p_mirror_cont_information8 Descriptive flexfield segment.
873 * @param p_mirror_cont_information9 Descriptive flexfield segment.
874 * @param p_mirror_cont_information10 Descriptive flexfield segment.
875 * @param p_mirror_cont_information11 Descriptive flexfield segment.
876 * @param p_mirror_cont_information12 Descriptive flexfield segment.
877 * @param p_mirror_cont_information13 Descriptive flexfield segment.
878 * @param p_mirror_cont_information14 Descriptive flexfield segment.
879 * @param p_mirror_cont_information15 Descriptive flexfield segment.
880 * @param p_mirror_cont_information16 Descriptive flexfield segment.
881 * @param p_mirror_cont_information17 Descriptive flexfield segment.
882 * @param p_mirror_cont_information18 Descriptive flexfield segment.
883 * @param p_mirror_cont_information19 Descriptive flexfield segment.
884 * @param p_mirror_cont_information20 Descriptive flexfield segment.
885 * @param p_contact_relationship_id Identifies the main contact relationship.
886 * If p_validate is false, this uniquely identifies the relationship created.
887 * If p_validate is true this parameter will be null.
888 * @param p_ctr_object_version_number If p_validate is false, this will be set
889 * to the version number of the created contact relationship. If p_validate is
890 * true, then value will be set to null.
891 * @param p_per_person_id If p_validate is false, then this uniquely identifies
892 * the person created. If p_validate is true, then set to null.
893 * @param p_per_object_version_number If p_validate is false, then set to the
894 * version number of the created Person Address. If p_validate is true, then
895 * the value will be null.
896 * @param p_per_effective_start_date If p_validate is false, this will be set
897 * to the effective start date of the person. If p_validate is true this will
898 * be null.
899 * @param p_per_effective_end_date If p_validate is false, this will be set to
900 * the effective end date of the person. If p_validate is true this will be
901 * null.
902 * @param p_full_name If p_validate is false, this will be set to the complete
903 * full name of the person. If p_validate is true this will be null.
904 * @param p_per_comment_id If p_validate is false and comment text was
905 * provided, then will be set to the identifier of the created contact
906 * relationship comment record. If p_validate is true or no comment text was
907 * provided, then will be null.
908 * @param p_name_combination_warning If set to true, then the combination of
909 * last name, first name and date of birth existed prior to calling this API.
910 * @param p_orig_hire_warning Set to true if the original date of hire is not
911 * null and the person type is not EMP, EMP_APL, EX_EMP or EX_EMP_APL.
912 * @rep:displayname Create Contact Relationship for Poland
913 * @rep:category BUSINESS_ENTITY PER_CONTACT_RELATIONSHIP
914 * @rep:lifecycle active
915 * @rep:primaryinstance
916 * @rep:scope public
917 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
918 */
919 --
920 -- {End Of Comments}
921 --
922 PROCEDURE create_pl_contact
923 (p_validate in boolean default false
924 ,p_start_date in date
925 ,p_business_group_id in number
926 ,p_person_id in number
927 ,p_contact_person_id in number default null
928 ,p_contact_type in varchar2
929 ,p_ctr_comments in varchar2 default null
930 ,p_primary_contact_flag in varchar2 default 'N'
931 ,p_date_start in date default null
932 ,p_start_life_reason_id in number default null
933 ,p_date_end in date default null
934 ,p_end_life_reason_id in number default null
935 ,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default 'N'
936 ,p_personal_flag in varchar2 default 'N'
937 ,p_sequence_number in number default null
938 ,p_cont_attribute_category in varchar2 default null
939 ,p_cont_attribute1 in varchar2 default null
940 ,p_cont_attribute2 in varchar2 default null
941 ,p_cont_attribute3 in varchar2 default null
942 ,p_cont_attribute4 in varchar2 default null
943 ,p_cont_attribute5 in varchar2 default null
944 ,p_cont_attribute6 in varchar2 default null
945 ,p_cont_attribute7 in varchar2 default null
946 ,p_cont_attribute8 in varchar2 default null
947 ,p_cont_attribute9 in varchar2 default null
948 ,p_cont_attribute10 in varchar2 default null
949 ,p_cont_attribute11 in varchar2 default null
950 ,p_cont_attribute12 in varchar2 default null
951 ,p_cont_attribute13 in varchar2 default null
952 ,p_cont_attribute14 in varchar2 default null
953 ,p_cont_attribute15 in varchar2 default null
954 ,p_cont_attribute16 in varchar2 default null
955 ,p_cont_attribute17 in varchar2 default null
956 ,p_cont_attribute18 in varchar2 default null
957 ,p_cont_attribute19 in varchar2 default null
958 ,p_cont_attribute20 in varchar2 default null
959 ,p_cont_information_category in varchar2 default null
960 ,Relationship_Info in varchar2 default null
961 ,Address_Info in varchar2 default null
962 ,p_cont_information3 in varchar2 default null
963 ,p_cont_information4 in varchar2 default null
964 ,p_cont_information5 in varchar2 default null
965 ,p_cont_information6 in varchar2 default null
966 ,p_cont_information7 in varchar2 default null
967 ,p_cont_information8 in varchar2 default null
968 ,p_cont_information9 in varchar2 default null
969 ,p_cont_information10 in varchar2 default null
970 ,p_cont_information11 in varchar2 default null
971 ,p_cont_information12 in varchar2 default null
972 ,p_cont_information13 in varchar2 default null
973 ,p_cont_information14 in varchar2 default null
974 ,p_cont_information15 in varchar2 default null
975 ,p_cont_information16 in varchar2 default null
976 ,p_cont_information17 in varchar2 default null
977 ,p_cont_information18 in varchar2 default null
978 ,p_cont_information19 in varchar2 default null
979 ,p_cont_information20 in varchar2 default null
980 ,p_third_party_pay_flag in varchar2 default 'N'
981 ,p_bondholder_flag in varchar2 default 'N'
982 ,p_dependent_flag in varchar2 default 'N'
983 ,p_beneficiary_flag in varchar2 default 'N'
984 ,p_last_name in varchar2
985 ,p_sex in varchar2 default null
986 ,p_person_type_id in number default null
987 ,p_per_comments in varchar2 default null
988 ,p_date_of_birth in date default null
989 ,p_email_address in varchar2 default null
990 ,p_first_name in varchar2 default null
991 ,p_known_as in varchar2 default null
992 ,p_marital_status in varchar2 default null
993 ,p_middle_names in varchar2 default null
994 ,p_nationality in varchar2 default null
995 ,p_pesel in varchar2 default null
996 ,p_previous_last_name in varchar2 default null
997 ,p_registered_disabled_flag in varchar2 default null
998 ,p_title in varchar2 default null
999 ,p_work_telephone in varchar2 default null
1000 ,p_attribute_category in varchar2 default null
1001 ,p_attribute1 in varchar2 default null
1002 ,p_attribute2 in varchar2 default null
1003 ,p_attribute3 in varchar2 default null
1004 ,p_attribute4 in varchar2 default null
1005 ,p_attribute5 in varchar2 default null
1006 ,p_attribute6 in varchar2 default null
1007 ,p_attribute7 in varchar2 default null
1008 ,p_attribute8 in varchar2 default null
1009 ,p_attribute9 in varchar2 default null
1010 ,p_attribute10 in varchar2 default null
1011 ,p_attribute11 in varchar2 default null
1012 ,p_attribute12 in varchar2 default null
1013 ,p_attribute13 in varchar2 default null
1014 ,p_attribute14 in varchar2 default null
1015 ,p_attribute15 in varchar2 default null
1016 ,p_attribute16 in varchar2 default null
1017 ,p_attribute17 in varchar2 default null
1018 ,p_attribute18 in varchar2 default null
1019 ,p_attribute19 in varchar2 default null
1020 ,p_attribute20 in varchar2 default null
1021 ,p_attribute21 in varchar2 default null
1022 ,p_attribute22 in varchar2 default null
1023 ,p_attribute23 in varchar2 default null
1024 ,p_attribute24 in varchar2 default null
1025 ,p_attribute25 in varchar2 default null
1026 ,p_attribute26 in varchar2 default null
1027 ,p_attribute27 in varchar2 default null
1028 ,p_attribute28 in varchar2 default null
1029 ,p_attribute29 in varchar2 default null
1030 ,p_attribute30 in varchar2 default null
1031 ,p_per_information_category in varchar2 default null
1032 ,p_nip in varchar2 default null
1033 ,p_insured_by_employee in varchar2 default null
1034 ,p_inheritor in varchar2 default null
1035 ,p_oldage_pension_rights in varchar2 default null
1036 ,p_national_fund_of_health in varchar2 default null
1037 ,p_tax_office in varchar2 default null
1038 ,p_legal_employer in varchar2 default null
1039 ,p_citizenship in varchar2 default null
1040 ,p_correspondence_language in varchar2 default null
1041 ,p_honors in varchar2 default null
1042 ,p_pre_name_adjunct in varchar2 default null
1043 ,p_suffix in varchar2 default null
1044 ,p_create_mirror_flag in varchar2 default 'N'
1045 ,p_mirror_type in varchar2 default null
1046 ,p_mirror_cont_attribute_cat in varchar2 default null
1047 ,p_mirror_cont_attribute1 in varchar2 default null
1048 ,p_mirror_cont_attribute2 in varchar2 default null
1049 ,p_mirror_cont_attribute3 in varchar2 default null
1050 ,p_mirror_cont_attribute4 in varchar2 default null
1051 ,p_mirror_cont_attribute5 in varchar2 default null
1052 ,p_mirror_cont_attribute6 in varchar2 default null
1053 ,p_mirror_cont_attribute7 in varchar2 default null
1054 ,p_mirror_cont_attribute8 in varchar2 default null
1055 ,p_mirror_cont_attribute9 in varchar2 default null
1056 ,p_mirror_cont_attribute10 in varchar2 default null
1057 ,p_mirror_cont_attribute11 in varchar2 default null
1058 ,p_mirror_cont_attribute12 in varchar2 default null
1059 ,p_mirror_cont_attribute13 in varchar2 default null
1060 ,p_mirror_cont_attribute14 in varchar2 default null
1061 ,p_mirror_cont_attribute15 in varchar2 default null
1062 ,p_mirror_cont_attribute16 in varchar2 default null
1063 ,p_mirror_cont_attribute17 in varchar2 default null
1064 ,p_mirror_cont_attribute18 in varchar2 default null
1065 ,p_mirror_cont_attribute19 in varchar2 default null
1066 ,p_mirror_cont_attribute20 in varchar2 default null
1067 ,p_mirror_cont_information_cat in varchar2 default null
1068 ,p_mirror_cont_information1 in varchar2 default null
1069 ,p_mirror_cont_information2 in varchar2 default null
1070 ,p_mirror_cont_information3 in varchar2 default null
1071 ,p_mirror_cont_information4 in varchar2 default null
1072 ,p_mirror_cont_information5 in varchar2 default null
1073 ,p_mirror_cont_information6 in varchar2 default null
1074 ,p_mirror_cont_information7 in varchar2 default null
1075 ,p_mirror_cont_information8 in varchar2 default null
1076 ,p_mirror_cont_information9 in varchar2 default null
1077 ,p_mirror_cont_information10 in varchar2 default null
1078 ,p_mirror_cont_information11 in varchar2 default null
1079 ,p_mirror_cont_information12 in varchar2 default null
1080 ,p_mirror_cont_information13 in varchar2 default null
1081 ,p_mirror_cont_information14 in varchar2 default null
1082 ,p_mirror_cont_information15 in varchar2 default null
1083 ,p_mirror_cont_information16 in varchar2 default null
1084 ,p_mirror_cont_information17 in varchar2 default null
1085 ,p_mirror_cont_information18 in varchar2 default null
1086 ,p_mirror_cont_information19 in varchar2 default null
1087 ,p_mirror_cont_information20 in varchar2 default null
1088 ,p_contact_relationship_id out nocopy number
1089 ,p_ctr_object_version_number out nocopy number
1090 ,p_per_person_id out nocopy number
1091 ,p_per_object_version_number out nocopy number
1092 ,p_per_effective_start_date out nocopy date
1093 ,p_per_effective_end_date out nocopy date
1094 ,p_full_name out nocopy varchar2
1095 ,p_per_comment_id out nocopy number
1096 ,p_name_combination_warning out nocopy boolean
1097 ,p_orig_hire_warning out nocopy boolean
1098 );
1099
1100 END hr_pl_contact_rel_api;
[Home] [Help]