75: p_dependent_flag in varchar2 default 'N',
76: p_beneficiary_flag in varchar2 default 'N',
77: p_object_version_number out nocopy number,
78: p_effective_date in date default null,
79: p_validate in number default hr_api.g_false_num,
80: p_return_status out nocopy varchar2
81: ) as
82:
83: --
114: --
115: --
116: -- Convert constant values to their corresponding boolean value
117: --
118: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
119: --
120: -- Register Surrogate ID or user key values
121: --
122:
261: -- ----------------------------------------------------------------------------
262:
263: procedure upd (
264: p_contact_relationship_id in number,
265: p_contact_type in varchar2 default hr_api.g_varchar2,
266: p_comments in long default hr_api.g_varchar2,
267: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
268: p_request_id in number default hr_api.g_number,
269: p_program_application_id in number default hr_api.g_number,
262:
263: procedure upd (
264: p_contact_relationship_id in number,
265: p_contact_type in varchar2 default hr_api.g_varchar2,
266: p_comments in long default hr_api.g_varchar2,
267: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
268: p_request_id in number default hr_api.g_number,
269: p_program_application_id in number default hr_api.g_number,
270: p_program_id in number default hr_api.g_number,
263: procedure upd (
264: p_contact_relationship_id in number,
265: p_contact_type in varchar2 default hr_api.g_varchar2,
266: p_comments in long default hr_api.g_varchar2,
267: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
268: p_request_id in number default hr_api.g_number,
269: p_program_application_id in number default hr_api.g_number,
270: p_program_id in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
264: p_contact_relationship_id in number,
265: p_contact_type in varchar2 default hr_api.g_varchar2,
266: p_comments in long default hr_api.g_varchar2,
267: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
268: p_request_id in number default hr_api.g_number,
269: p_program_application_id in number default hr_api.g_number,
270: p_program_id in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
272: p_date_start in date default hr_api.g_date,
265: p_contact_type in varchar2 default hr_api.g_varchar2,
266: p_comments in long default hr_api.g_varchar2,
267: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
268: p_request_id in number default hr_api.g_number,
269: p_program_application_id in number default hr_api.g_number,
270: p_program_id in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
272: p_date_start in date default hr_api.g_date,
273: p_start_life_reason_id in number default hr_api.g_number,
266: p_comments in long default hr_api.g_varchar2,
267: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
268: p_request_id in number default hr_api.g_number,
269: p_program_application_id in number default hr_api.g_number,
270: p_program_id in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
272: p_date_start in date default hr_api.g_date,
273: p_start_life_reason_id in number default hr_api.g_number,
274: p_date_end in date default hr_api.g_date,
267: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,
268: p_request_id in number default hr_api.g_number,
269: p_program_application_id in number default hr_api.g_number,
270: p_program_id in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
272: p_date_start in date default hr_api.g_date,
273: p_start_life_reason_id in number default hr_api.g_number,
274: p_date_end in date default hr_api.g_date,
275: p_end_life_reason_id in number default hr_api.g_number,
268: p_request_id in number default hr_api.g_number,
269: p_program_application_id in number default hr_api.g_number,
270: p_program_id in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
272: p_date_start in date default hr_api.g_date,
273: p_start_life_reason_id in number default hr_api.g_number,
274: p_date_end in date default hr_api.g_date,
275: p_end_life_reason_id in number default hr_api.g_number,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
269: p_program_application_id in number default hr_api.g_number,
270: p_program_id in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
272: p_date_start in date default hr_api.g_date,
273: p_start_life_reason_id in number default hr_api.g_number,
274: p_date_end in date default hr_api.g_date,
275: p_end_life_reason_id in number default hr_api.g_number,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
270: p_program_id in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
272: p_date_start in date default hr_api.g_date,
273: p_start_life_reason_id in number default hr_api.g_number,
274: p_date_end in date default hr_api.g_date,
275: p_end_life_reason_id in number default hr_api.g_number,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
271: p_program_update_date in date default hr_api.g_date,
272: p_date_start in date default hr_api.g_date,
273: p_start_life_reason_id in number default hr_api.g_number,
274: p_date_end in date default hr_api.g_date,
275: p_end_life_reason_id in number default hr_api.g_number,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
272: p_date_start in date default hr_api.g_date,
273: p_start_life_reason_id in number default hr_api.g_number,
274: p_date_end in date default hr_api.g_date,
275: p_end_life_reason_id in number default hr_api.g_number,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
273: p_start_life_reason_id in number default hr_api.g_number,
274: p_date_end in date default hr_api.g_date,
275: p_end_life_reason_id in number default hr_api.g_number,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
274: p_date_end in date default hr_api.g_date,
275: p_end_life_reason_id in number default hr_api.g_number,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
275: p_end_life_reason_id in number default hr_api.g_number,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
276: p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
278: p_sequence_number in number default hr_api.g_number,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
280: p_cont_attribute1 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
281: p_cont_attribute2 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
283: p_cont_attribute4 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
284: p_cont_attribute5 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
285: p_cont_attribute6 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
286: p_cont_attribute7 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
287: p_cont_attribute8 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
288: p_cont_attribute9 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
289: p_cont_attribute10 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
290: p_cont_attribute11 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
291: p_cont_attribute12 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
292: p_cont_attribute13 in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
293: p_cont_attribute14 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
294: p_cont_attribute15 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
295: p_cont_attribute16 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
296: p_cont_attribute17 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
297: p_cont_attribute18 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
298: p_cont_attribute19 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
299: p_cont_attribute20 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
300: p_cont_information_category in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
301: p_cont_information1 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
302: p_cont_information2 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
303: p_cont_information3 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
304: p_cont_information4 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
305: p_cont_information5 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
306: p_cont_information6 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
307: p_cont_information7 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
308: p_cont_information8 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
309: p_cont_information9 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
310: p_cont_information10 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
311: p_cont_information11 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
312: p_cont_information12 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
313: p_cont_information13 in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
321: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
314: p_cont_information14 in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
321: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
322: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
315: p_cont_information15 in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
321: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
322: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
323: p_dependent_flag in varchar2 default hr_api.g_varchar2,
316: p_cont_information16 in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
321: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
322: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
323: p_dependent_flag in varchar2 default hr_api.g_varchar2,
324: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
317: p_cont_information17 in varchar2 default hr_api.g_varchar2,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
321: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
322: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
323: p_dependent_flag in varchar2 default hr_api.g_varchar2,
324: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
325: p_object_version_number in out nocopy number,
318: p_cont_information18 in varchar2 default hr_api.g_varchar2,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
321: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
322: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
323: p_dependent_flag in varchar2 default hr_api.g_varchar2,
324: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
325: p_object_version_number in out nocopy number,
326: p_effective_date in date,
319: p_cont_information19 in varchar2 default hr_api.g_varchar2,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
321: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
322: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
323: p_dependent_flag in varchar2 default hr_api.g_varchar2,
324: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
325: p_object_version_number in out nocopy number,
326: p_effective_date in date,
327: p_validate in number default hr_api.g_false_num,
320: p_cont_information20 in varchar2 default hr_api.g_varchar2,
321: p_third_party_pay_flag in varchar2 default hr_api.g_varchar2,
322: p_bondholder_flag in varchar2 default hr_api.g_varchar2,
323: p_dependent_flag in varchar2 default hr_api.g_varchar2,
324: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
325: p_object_version_number in out nocopy number,
326: p_effective_date in date,
327: p_validate in number default hr_api.g_false_num,
328: p_return_status out nocopy varchar2
323: p_dependent_flag in varchar2 default hr_api.g_varchar2,
324: p_beneficiary_flag in varchar2 default hr_api.g_varchar2,
325: p_object_version_number in out nocopy number,
326: p_effective_date in date,
327: p_validate in number default hr_api.g_false_num,
328: p_return_status out nocopy varchar2
329: ) is
330: --
331: -- Variables for API Boolean parameters
352: l_object_version_number := p_object_version_number;
353: --
354: -- Convert constant values to their corresponding boolean value
355: --
356: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
357: --
358: --
359: hr_contact_rel_api.update_contact_relationship(
360: P_CONTACT_RELATIONSHIP_ID => P_CONTACT_RELATIONSHIP_ID,
457:
458: procedure del (
459: p_contact_relationship_id in number,
460: p_object_version_number in number,
461: p_validate in number default hr_api.g_false_num,
462: p_return_status out nocopy varchar2
463: ) is
464:
465: --
478: savepoint per_ctr_swi_del;
479: -- Initialise Multiple Message Detection
480: hr_multi_message.enable_message_list;
481: -- Convert constant values to their corresponding boolean value
482: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);
483: --
484: -- Call API
485: hr_contact_rel_api.delete_contact_relationship(
486: P_CONTACT_RELATIONSHIP_ID => P_CONTACT_RELATIONSHIP_ID,