1 PACKAGE hr_in_contact_rel_api AS
2 /* $Header: pecrlini.pkh 120.1 2005/10/02 02:39 aroussel $ */
3 /*#
4 * This package contains contact relationship APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Contact Relationship for India
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |----------------------------< create_in_contact >-------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a main contact relationship between a person and a contact.
17 *
18 * It is effectively an alternative to the API hr_contact_rel_api. Creating a
19 * contact involves using two people's identification numbers, the main person
20 * and their contact. If the contact does not exist, HRMS sets up a new person
21 * with the system person type of 'OTHER'.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * The contact person's identification number must be a valid value from
28 * PER_PEOPLE_F or be blank.
29 *
30 * <p><b>Post Success</b><br>
31 * Creates a main contact relationship between the person and the contact.
32 *
33 * <p><b>Post Failure</b><br>
34 * The API does not create the contact relationship and raises and error.
35 *
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_start_date The effective start date of the contact person.
40 * @param p_business_group_id Identifier for the business group of the contact
41 * person.
42 * @param p_person_id Identifies the person for whom you create the contact
43 * relationship record.
44 * @param p_contact_person_id Identifies the contact person for whom you create
45 * the contact relationship record.
46 * @param p_contact_type Type of contact. Valid values are defined by 'CONTACT'
47 * lookup type.
48 * @param p_ctr_comments Comments for the main contact relationship.
49 * @param p_primary_contact_flag Indicates whether contact is primary contact
50 * for the employee.
51 * @param p_date_start The start date of the relationship
52 * @param p_start_life_reason_id Identifier for the reason the relationship
53 * started.
54 * @param p_date_end The end date of the relationship.
55 * @param p_end_life_reason_id Identifier for the reason the relationship
56 * ended.
57 * @param p_rltd_per_rsds_w_dsgntr_flag Indicates whether the two people in the
58 * relationship live at the same address. Defaults 'N'.
59 * @param p_personal_flag Indicates whether the relationship is a personal
60 * relationship.
61 * @param p_sequence_number The unique sequence number for the relationship
62 * used to identify contacts with a third party organization.
63 * @param p_cont_attribute_category Contact Attribute Category
64 * @param p_cont_attribute1 Descriptive flexfield segment.
65 * @param p_cont_attribute2 Descriptive flexfield segment.
66 * @param p_cont_attribute3 Descriptive flexfield segment.
67 * @param p_cont_attribute4 Descriptive flexfield segment.
68 * @param p_cont_attribute5 Descriptive flexfield segment.
69 * @param p_cont_attribute6 Descriptive flexfield segment.
70 * @param p_cont_attribute7 Descriptive flexfield segment.
71 * @param p_cont_attribute8 Descriptive flexfield segment.
72 * @param p_cont_attribute9 Descriptive flexfield segment.
73 * @param p_cont_attribute10 Descriptive flexfield segment.
74 * @param p_cont_attribute11 Descriptive flexfield segment.
75 * @param p_cont_attribute12 Descriptive flexfield segment.
76 * @param p_cont_attribute13 Descriptive flexfield segment.
77 * @param p_cont_attribute14 Descriptive flexfield segment.
78 * @param p_cont_attribute15 Descriptive flexfield segment.
79 * @param p_cont_attribute16 Descriptive flexfield segment.
80 * @param p_cont_attribute17 Descriptive flexfield segment.
81 * @param p_cont_attribute18 Descriptive flexfield segment.
82 * @param p_cont_attribute19 Descriptive flexfield segment.
83 * @param p_cont_attribute20 Descriptive flexfield segment.
84 * @param p_guardian_name Guardian Name
85 * @param p_guardian_birth_date Guardian Birth Date
86 * @param p_guardian_address Guardian Address
87 * @param p_guardian_telephone Guardian Telephone Number
88 * @param p_third_party_pay_flag Indicates whether the contact receives third
89 * party payment from the employee. Default 'N'
90 * @param p_bondholder_flag Indicates whether a contact person is a potential
91 * EE bondholder. Default 'N'
92 * @param p_dependent_flag Dependent flag. Default 'N'
93 * @param p_beneficiary_flag Beneficiary flag. Default 'N'
94 * @param p_last_name The last name of the contact person.
95 * @param p_sex Gender of the contact person.
96 * @param p_person_type_id Identifier corresponding to Person Type. If this
97 * value is omitted (new record) then the person_type_id of the default `OTHER'
98 * system person type in the person's business group is used.
99 * @param p_per_comments Comments for the person record.
100 * @param p_date_of_birth The date of birth of the contact person.
101 * @param p_email_address Email address of the contact person.
102 * @param p_first_name The first name of the contact person.
103 * @param p_alias_name Preferred name of the contact person if different from
104 * first name.
105 * @param p_marital_status Marital status of the contact person. Valid values
106 * are defined by 'MAR_STATUS' lookup type
107 * @param p_middle_names Middle name(s) of the contact person
108 * @param p_nationality Nationality of the contact person. Valid values are
109 * defined by 'NATIONALITY' lookup type
110 * @param p_national_identifier National identifier of the contact.
111 * @param p_previous_last_name The previous last name of the contact person.
112 * @param p_registered_disabled_flag Indicates whether contact person is
113 * classified as disabled. Valid values are defined by 'REGISTERED_DISABLED'
114 * lookup type.
115 * @param p_title The title of the contact person. Valid values are defined by
116 * 'TITLE' lookup type
117 * @param p_work_telephone Work telephone of the contact person.
118 * @param p_attribute_category This context value determines which flexfield
119 * structure to use with the descriptive flexfield segments.
120 * @param p_attribute1 Descriptive flexfield segment.
121 * @param p_attribute2 Descriptive flexfield segment.
122 * @param p_attribute3 Descriptive flexfield segment.
123 * @param p_attribute4 Descriptive flexfield segment.
124 * @param p_attribute5 Descriptive flexfield segment.
125 * @param p_attribute6 Descriptive flexfield segment.
126 * @param p_attribute7 Descriptive flexfield segment.
127 * @param p_attribute8 Descriptive flexfield segment.
128 * @param p_attribute9 Descriptive flexfield segment.
129 * @param p_attribute10 Descriptive flexfield segment.
130 * @param p_attribute11 Descriptive flexfield segment.
131 * @param p_attribute12 Descriptive flexfield segment.
132 * @param p_attribute13 Descriptive flexfield segment.
133 * @param p_attribute14 Descriptive flexfield segment.
134 * @param p_attribute15 Descriptive flexfield segment.
135 * @param p_attribute16 Descriptive flexfield segment.
136 * @param p_attribute17 Descriptive flexfield segment.
137 * @param p_attribute18 Descriptive flexfield segment.
138 * @param p_attribute19 Descriptive flexfield segment.
139 * @param p_attribute20 Descriptive flexfield segment.
140 * @param p_attribute21 Descriptive flexfield segment.
141 * @param p_attribute22 Descriptive flexfield segment.
142 * @param p_attribute23 Descriptive flexfield segment.
143 * @param p_attribute24 Descriptive flexfield segment.
144 * @param p_attribute25 Descriptive flexfield segment.
145 * @param p_attribute26 Descriptive flexfield segment.
146 * @param p_attribute27 Descriptive flexfield segment.
147 * @param p_attribute28 Descriptive flexfield segment.
148 * @param p_attribute29 Descriptive flexfield segment.
149 * @param p_attribute30 Descriptive flexfield segment.
150 * @param p_resident_status Residential status of the contact. Valid values are
151 * defined by 'IN_RESIDENTIAL_STATUS' lookup type. Default 'RO'
152 * @param p_correspondence_language Correspondence language
153 * @param p_honors Honors or degrees awarded.
154 * @param p_pre_name_adjunct Obsolete parameter, do not use.
155 * @param p_suffix Obsolete parameter, do not use.
156 * @param p_create_mirror_flag Create mirror flag.
157 * @param p_mirror_type Mirror relationship type.
158 * @param p_mirror_cont_attribute_cat Mirror contact attribute category.
159 * @param p_mirror_cont_attribute1 Descriptive flexfield segment.
160 * @param p_mirror_cont_attribute2 Descriptive flexfield segment.
161 * @param p_mirror_cont_attribute3 Descriptive flexfield segment.
162 * @param p_mirror_cont_attribute4 Descriptive flexfield segment.
163 * @param p_mirror_cont_attribute5 Descriptive flexfield segment.
164 * @param p_mirror_cont_attribute6 Descriptive flexfield segment.
165 * @param p_mirror_cont_attribute7 Descriptive flexfield segment.
166 * @param p_mirror_cont_attribute8 Descriptive flexfield segment.
167 * @param p_mirror_cont_attribute9 Descriptive flexfield segment.
168 * @param p_mirror_cont_attribute10 Descriptive flexfield segment.
169 * @param p_mirror_cont_attribute11 Descriptive flexfield segment.
170 * @param p_mirror_cont_attribute12 Descriptive flexfield segment.
171 * @param p_mirror_cont_attribute13 Descriptive flexfield segment.
172 * @param p_mirror_cont_attribute14 Descriptive flexfield segment.
173 * @param p_mirror_cont_attribute15 Descriptive flexfield segment.
174 * @param p_mirror_cont_attribute16 Descriptive flexfield segment.
175 * @param p_mirror_cont_attribute17 Descriptive flexfield segment.
176 * @param p_mirror_cont_attribute18 Descriptive flexfield segment.
177 * @param p_mirror_cont_attribute19 Descriptive flexfield segment.
178 * @param p_mirror_cont_attribute20 Descriptive flexfield segment.
179 * @param p_contact_relationship_id Identifier of the main contact
180 * relationship. If p_validate is false, this uniquely identifies the
181 * relationship created. If p_validate is true this parameter will be null.
182 * @param p_ctr_object_version_number If p_validate is false, this will be set
183 * to the version number of the created contact relationship. If p_validate is
184 * true, then value will be set to null.
185 * @param p_per_person_id If p_validate is false, then this uniquely identifies
186 * the person created. If p_validate is true, then set to null.
187 * @param p_per_object_version_number If p_validate is false, then set to the
188 * version number of the created person. If p_validate is true, then the value
189 * will be null.
190 * @param p_per_effective_start_date If p_validate is false, this will be set
191 * to the effective start date of the person. If p_validate is true this will
192 * be null.
193 * @param p_per_effective_end_date If p_validate is false, this will be set to
194 * the effective end date of the person. If p_validate is true this will be
195 * null.
196 * @param p_full_name If p_validate is false, this will be set to the complete
197 * full name of the person. If p_validate is true this will be null.
198 * @param p_per_comment_id If p_validate is false and comment text was
199 * provided, then will be set to the identifier of the created contact
200 * relationship comment record. If p_validate is true or no comment text was
201 * provided, then will be null.
202 * @param p_name_combination_warning If set to true, then the combination of
203 * last name, first name and date of birth existed prior to calling this API.
204 * @param p_orig_hire_warning Set to true if the original date of hire is not
205 * null and the person type is not EMP,EMP_APL, EX_EMP or EX_EMP_APL.
206 * @rep:displayname Create Contact for India
207 * @rep:category BUSINESS_ENTITY PER_CONTACT_RELATIONSHIP
208 * @rep:lifecycle active
209 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
210 * @rep:scope public
211 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
212 */
213 --
214 -- {End Of Comments}
215 --
216 PROCEDURE create_in_contact
217 (p_validate IN BOOLEAN default false
218 ,p_start_date IN DATE
219 ,p_business_group_id IN NUMBER
220 ,p_person_id IN NUMBER
221 ,p_contact_person_id IN NUMBER default null
222 ,p_contact_type IN varchar2
223 ,p_ctr_comments IN varchar2 default null
224 ,p_primary_contact_flag IN varchar2 default 'N'
225 ,p_date_start IN DATE default null
226 ,p_start_life_reason_id IN NUMBER default null
227 ,p_date_end IN DATE default null
228 ,p_end_life_reason_id IN NUMBER default null
229 ,p_rltd_per_rsds_w_dsgntr_flag IN VARCHAR2 default 'N'
230 ,p_personal_flag IN VARCHAR2 default 'N'
231 ,p_sequence_number IN NUMBER default null
232 ,p_cont_attribute_category IN VARCHAR2 default null
233 ,p_cont_attribute1 IN VARCHAR2 default null
234 ,p_cont_attribute2 IN VARCHAR2 default null
235 ,p_cont_attribute3 IN VARCHAR2 default null
236 ,p_cont_attribute4 IN VARCHAR2 default null
237 ,p_cont_attribute5 IN VARCHAR2 default null
238 ,p_cont_attribute6 IN VARCHAR2 default null
239 ,p_cont_attribute7 IN VARCHAR2 default null
240 ,p_cont_attribute8 IN VARCHAR2 default null
241 ,p_cont_attribute9 IN VARCHAR2 default null
242 ,p_cont_attribute10 IN VARCHAR2 default null
243 ,p_cont_attribute11 IN VARCHAR2 default null
244 ,p_cont_attribute12 IN VARCHAR2 default null
245 ,p_cont_attribute13 IN VARCHAR2 default null
246 ,p_cont_attribute14 IN VARCHAR2 default null
247 ,p_cont_attribute15 IN VARCHAR2 default null
248 ,p_cont_attribute16 IN VARCHAR2 default null
249 ,p_cont_attribute17 IN VARCHAR2 default null
250 ,p_cont_attribute18 IN VARCHAR2 default null
251 ,p_cont_attribute19 IN VARCHAR2 default null
252 ,p_cont_attribute20 IN VARCHAR2 default null
253 ,p_guardian_name IN VARCHAR2 default null
254 ,p_guardian_birth_date IN VARCHAR2 default null
255 ,p_guardian_address IN VARCHAR2 default null
256 ,p_guardian_telephone IN VARCHAR2 default null
257 ,p_third_party_pay_flag IN VARCHAR2 default 'N'
258 ,p_bondholder_flag IN VARCHAR2 default 'N'
259 ,p_dependent_flag IN VARCHAR2 default 'N'
260 ,p_beneficiary_flag IN VARCHAR2 default 'N'
261 ,p_last_name IN VARCHAR2 default null
262 ,p_sex IN VARCHAR2 default null
263 ,p_person_type_id IN NUMBER default null
264 ,p_per_comments IN VARCHAR2 default null
265 ,p_date_of_birth IN DATE default null
266 ,p_email_address IN VARCHAR2 default null
267 ,p_first_name IN VARCHAR2 default null
268 ,p_alias_name IN VARCHAR2 default null
269 ,p_marital_status IN VARCHAR2 default null
270 ,p_middle_names IN VARCHAR2 default null
271 ,p_nationality IN VARCHAR2 default null
272 ,p_national_identifier IN VARCHAR2 default null
273 ,p_previous_last_name IN VARCHAR2 default null
274 ,p_registered_disabled_flag IN VARCHAR2 default null
275 ,p_title IN VARCHAR2 default null
276 ,p_work_telephone IN VARCHAR2 default null
277 ,p_attribute_category IN VARCHAR2 default null
278 ,p_attribute1 IN VARCHAR2 default null
279 ,p_attribute2 IN VARCHAR2 default null
280 ,p_attribute3 IN VARCHAR2 default null
281 ,p_attribute4 IN VARCHAR2 default null
282 ,p_attribute5 IN VARCHAR2 default null
283 ,p_attribute6 IN VARCHAR2 default null
284 ,p_attribute7 IN VARCHAR2 default null
285 ,p_attribute8 IN VARCHAR2 default null
286 ,p_attribute9 IN VARCHAR2 default null
290 ,p_attribute13 IN VARCHAR2 default null
287 ,p_attribute10 IN VARCHAR2 default null
288 ,p_attribute11 IN VARCHAR2 default null
289 ,p_attribute12 IN VARCHAR2 default null
291 ,p_attribute14 IN VARCHAR2 default null
292 ,p_attribute15 IN VARCHAR2 default null
293 ,p_attribute16 IN VARCHAR2 default null
294 ,p_attribute17 IN VARCHAR2 default null
295 ,p_attribute18 IN VARCHAR2 default null
296 ,p_attribute19 IN VARCHAR2 default null
297 ,p_attribute20 IN VARCHAR2 default null
298 ,p_attribute21 IN VARCHAR2 default null
299 ,p_attribute22 IN VARCHAR2 default null
300 ,p_attribute23 IN VARCHAR2 default null
301 ,p_attribute24 IN VARCHAR2 default null
302 ,p_attribute25 IN VARCHAR2 default null
303 ,p_attribute26 IN VARCHAR2 default null
304 ,p_attribute27 IN VARCHAR2 default null
305 ,p_attribute28 IN VARCHAR2 default null
306 ,p_attribute29 IN VARCHAR2 default null
307 ,p_attribute30 IN VARCHAR2 default null
308 ,p_resident_status IN VARCHAR2 DEFAULT null
309 ,p_correspondence_language IN VARCHAR2 default null
310 ,p_honors IN VARCHAR2 default null
311 ,p_pre_name_adjunct IN VARCHAR2 default null
312 ,p_suffix IN VARCHAR2 default null
313 ,p_create_mirror_flag IN VARCHAR2 default 'N'
314 ,p_mirror_type IN VARCHAR2 default null
315 ,p_mirror_cont_attribute_cat IN VARCHAR2 default null
316 ,p_mirror_cont_attribute1 IN VARCHAR2 default null
317 ,p_mirror_cont_attribute2 IN VARCHAR2 default null
318 ,p_mirror_cont_attribute3 IN VARCHAR2 default null
319 ,p_mirror_cont_attribute4 IN VARCHAR2 default null
320 ,p_mirror_cont_attribute5 IN VARCHAR2 default null
321 ,p_mirror_cont_attribute6 IN VARCHAR2 default null
322 ,p_mirror_cont_attribute7 IN VARCHAR2 default null
323 ,p_mirror_cont_attribute8 IN VARCHAR2 default null
324 ,p_mirror_cont_attribute9 IN VARCHAR2 default null
325 ,p_mirror_cont_attribute10 IN VARCHAR2 default null
326 ,p_mirror_cont_attribute11 IN VARCHAR2 default null
327 ,p_mirror_cont_attribute12 IN VARCHAR2 default null
328 ,p_mirror_cont_attribute13 IN VARCHAR2 default null
329 ,p_mirror_cont_attribute14 IN VARCHAR2 default null
330 ,p_mirror_cont_attribute15 IN VARCHAR2 default null
331 ,p_mirror_cont_attribute16 IN VARCHAR2 default null
332 ,p_mirror_cont_attribute17 IN VARCHAR2 default null
333 ,p_mirror_cont_attribute18 IN VARCHAR2 default null
334 ,p_mirror_cont_attribute19 IN VARCHAR2 default null
335 ,p_mirror_cont_attribute20 IN VARCHAR2 default null
336 ,p_contact_relationship_id OUT NOCOPY NUMBER
337 ,p_ctr_object_version_number OUT NOCOPY NUMBER
338 ,p_per_person_id OUT NOCOPY NUMBER
339 ,p_per_object_version_number OUT NOCOPY NUMBER
340 ,p_per_effective_start_date OUT NOCOPY DATE
341 ,p_per_effective_end_date OUT NOCOPY DATE
342 ,p_full_name OUT NOCOPY VARCHAR2
343 ,p_per_comment_id OUT NOCOPY NUMBER
344 ,p_name_combination_warning OUT NOCOPY BOOLEAN
345 ,p_orig_hire_warning OUT NOCOPY BOOLEAN
346 ) ;
347 --
348 -- ----------------------------------------------------------------------------
349 -- |----------------------< update_in_contact_relationship >------------------|
350 -- ----------------------------------------------------------------------------
351 --
352 -- {Start Of Comments}
353 /*#
354 * This API updates the main contact relationship details of a contact.
355 *
356 * It modifies all contact relationship details for a contact. Use this API to
357 * update the contact relationship record as identified by
358 * p_contact_relationship_id. If you update the contact type, the link to the
359 * mirror relationship is removed and the mirror contact relationship is not
360 * updated. If you update the relationship type of contact relationship or the
361 * mirror relationship, the link between relationships is removed and the
362 * reciprocal relationship is not updated.
363 *
364 * <p><b>Licensing</b><br>
365 * This API is licensed for use with Human Resources.
366 *
367 * <p><b>Prerequisites</b><br>
368 * The contact relationship record, identified by p_contact_relationship_id
369 * must already exist.
370 *
371 * <p><b>Post Success</b><br>
372 * Updates the main contact relationship of the contact.
373 *
374 * <p><b>Post Failure</b><br>
375 * The API will not update the contact relationship and raises an error.
376 *
377 * @param p_validate If true, then validation alone will be performed and the
378 * database will remain unchanged. If false and all validation checks pass,
379 * then the database will be modified.
380 * @param p_effective_date Determines when the DateTrack operation comes into
381 * force.
385 * lookup type
382 * @param p_contact_relationship_id Identifies the contact relationship record
383 * to be modified.
384 * @param p_contact_type Type of contact. Valid values are defined by 'CONTACT'
386 * @param p_comments Contact relationship comment text.
387 * @param p_primary_contact_flag Indicates whether contact is primary contact
388 * for the employee.
389 * @param p_third_party_pay_flag Indicates whether the contact receives third
390 * party payment from the employee.
391 * @param p_bondholder_flag Indicates whether a contact person is a potential
392 * EE bondholder.
393 * @param p_date_start The start date of the relationship.
394 * @param p_start_life_reason_id Identifier for the reason the relationship
395 * started.
396 * @param p_date_end The end date of the relationship.
397 * @param p_end_life_reason_id Identifier for the reason the relationship
398 * ended.
399 * @param p_rltd_per_rsds_w_dsgntr_flag Indicates whether the two people in the
400 * relationship live at the same address. Defaults 'N'.
401 * @param p_personal_flag Indicates whether relationship is a personal
402 * relationship. Defaults 'N'.
403 * @param p_sequence_number The unique sequence number for the relationship
404 * used to identify contacts with a third party organization.
405 * @param p_dependent_flag Dependent flag. Default 'N'.
406 * @param p_beneficiary_flag Beneficiary flag. Default 'N'.
407 * @param p_cont_attribute_category Contact attribute category.
408 * @param p_cont_attribute1 Descriptive flexfield segment.
409 * @param p_cont_attribute2 Descriptive flexfield segment.
410 * @param p_cont_attribute3 Descriptive flexfield segment.
411 * @param p_cont_attribute4 Descriptive flexfield segment.
412 * @param p_cont_attribute5 Descriptive flexfield segment.
413 * @param p_cont_attribute6 Descriptive flexfield segment.
414 * @param p_cont_attribute7 Descriptive flexfield segment.
415 * @param p_cont_attribute8 Descriptive flexfield segment.
416 * @param p_cont_attribute9 Descriptive flexfield segment.
417 * @param p_cont_attribute10 Descriptive flexfield segment.
418 * @param p_cont_attribute11 Descriptive flexfield segment.
419 * @param p_cont_attribute12 Descriptive flexfield segment.
420 * @param p_cont_attribute13 Descriptive flexfield segment.
421 * @param p_cont_attribute14 Descriptive flexfield segment.
422 * @param p_cont_attribute15 Descriptive flexfield segment.
423 * @param p_cont_attribute16 Descriptive flexfield segment.
424 * @param p_cont_attribute17 Descriptive flexfield segment.
425 * @param p_cont_attribute18 Descriptive flexfield segment.
426 * @param p_cont_attribute19 Descriptive flexfield segment.
427 * @param p_cont_attribute20 Descriptive flexfield segment.
428 * @param p_guardian_name Guardian Name.
429 * @param p_guardian_birth_date Guardian Birth Date.
430 * @param p_guardian_address Guardian Address.
431 * @param p_guardian_telephone Guardian Telephone Number.
432 * @param p_object_version_number Pass in the current version number of the
433 * Contact Relationship to be updated. When the API completes if p_validate is
434 * false, will be set to the new version number of the updated Contact
435 * Relationship. If p_validate is true will be set to the same value which was
436 * passed in.
437 * @rep:displayname Update Contact Relationship for India
438 * @rep:category BUSINESS_ENTITY PER_CONTACT_RELATIONSHIP
439 * @rep:lifecycle active
440 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
441 * @rep:scope public
442 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
443 */
444 --
445 -- {End Of Comments}
446 --
447 PROCEDURE update_in_contact_relationship
448 (p_validate IN BOOLEAN default false
449 ,p_effective_date IN DATE
450 ,p_contact_relationship_id IN NUMBER
451 ,p_contact_type IN VARCHAR2 default hr_api.g_varchar2
452 ,p_comments IN LONG default hr_api.g_varchar2
453 ,p_primary_contact_flag IN VARCHAR2 default hr_api.g_varchar2
454 ,p_third_party_pay_flag IN VARCHAR2 default hr_api.g_varchar2
455 ,p_bondholder_flag IN VARCHAR2 default hr_api.g_varchar2
456 ,p_date_start IN DATE default hr_api.g_date
457 ,p_start_life_reason_id IN NUMBER default hr_api.g_number
458 ,p_date_end IN DATE default hr_api.g_date
459 ,p_end_life_reason_id IN NUMBER default hr_api.g_number
460 ,p_rltd_per_rsds_w_dsgntr_flag IN VARCHAR2 default hr_api.g_varchar2
461 ,p_personal_flag IN VARCHAR2 default hr_api.g_varchar2
462 ,p_sequence_number IN NUMBER default hr_api.g_number
463 ,p_dependent_flag IN VARCHAR2 default hr_api.g_varchar2
464 ,p_beneficiary_flag IN VARCHAR2 default hr_api.g_varchar2
465 ,p_cont_attribute_category IN VARCHAR2 default hr_api.g_varchar2
466 ,p_cont_attribute1 IN VARCHAR2 default hr_api.g_varchar2
467 ,p_cont_attribute2 IN VARCHAR2 default hr_api.g_varchar2
468 ,p_cont_attribute3 IN VARCHAR2 default hr_api.g_varchar2
469 ,p_cont_attribute4 IN VARCHAR2 default hr_api.g_varchar2
470 ,p_cont_attribute5 IN VARCHAR2 default hr_api.g_varchar2
471 ,p_cont_attribute6 IN VARCHAR2 default hr_api.g_varchar2
472 ,p_cont_attribute7 IN VARCHAR2 default hr_api.g_varchar2
473 ,p_cont_attribute8 IN VARCHAR2 default hr_api.g_varchar2
477 ,p_cont_attribute12 IN VARCHAR2 default hr_api.g_varchar2
474 ,p_cont_attribute9 IN VARCHAR2 default hr_api.g_varchar2
475 ,p_cont_attribute10 IN VARCHAR2 default hr_api.g_varchar2
476 ,p_cont_attribute11 IN VARCHAR2 default hr_api.g_varchar2
478 ,p_cont_attribute13 IN VARCHAR2 default hr_api.g_varchar2
479 ,p_cont_attribute14 IN VARCHAR2 default hr_api.g_varchar2
480 ,p_cont_attribute15 IN VARCHAR2 default hr_api.g_varchar2
481 ,p_cont_attribute16 IN VARCHAR2 default hr_api.g_varchar2
482 ,p_cont_attribute17 IN VARCHAR2 default hr_api.g_varchar2
483 ,p_cont_attribute18 IN VARCHAR2 default hr_api.g_varchar2
484 ,p_cont_attribute19 IN VARCHAR2 default hr_api.g_varchar2
485 ,p_cont_attribute20 IN VARCHAR2 default hr_api.g_varchar2
486 ,p_guardian_name IN VARCHAR2 default hr_api.g_varchar2
487 ,p_guardian_birth_date IN VARCHAR2 default hr_api.g_varchar2
488 ,p_guardian_address IN VARCHAR2 default hr_api.g_varchar2
489 ,p_guardian_telephone IN VARCHAR2 default hr_api.g_varchar2
490 ,p_object_version_number IN OUT NOCOPY number
491 );
492 END hr_in_contact_rel_api;