eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_CONTACT_RELATIONSHIP_SWI dependencies on HR_API

Line 79: p_validate in number default hr_api.g_false_num,

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: --

Line 118: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);

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:

Line 265: p_contact_type in varchar2 default hr_api.g_varchar2,

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 per_contact_relationships.comments%TYPE 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,

Line 266: p_comments in per_contact_relationships.comments%TYPE default hr_api.g_varchar2,

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 per_contact_relationships.comments%TYPE 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,

Line 267: p_primary_contact_flag in varchar2 default hr_api.g_varchar2,

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 per_contact_relationships.comments%TYPE 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,

Line 268: p_request_id in number default hr_api.g_number,

264: p_contact_relationship_id in number,
265: p_contact_type in varchar2 default hr_api.g_varchar2,
266: p_comments in per_contact_relationships.comments%TYPE 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,

Line 269: p_program_application_id in number default hr_api.g_number,

265: p_contact_type in varchar2 default hr_api.g_varchar2,
266: p_comments in per_contact_relationships.comments%TYPE 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,

Line 270: p_program_id in number default hr_api.g_number,

266: p_comments in per_contact_relationships.comments%TYPE 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,

Line 271: p_program_update_date 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,

Line 272: p_date_start in date default hr_api.g_date,

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,

Line 273: p_start_life_reason_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,
277: p_personal_flag in varchar2 default hr_api.g_varchar2,

Line 274: p_date_end in date default hr_api.g_date,

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,

Line 275: p_end_life_reason_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,
279: p_cont_attribute_category in varchar2 default hr_api.g_varchar2,

Line 276: p_rltd_per_rsds_w_dsgntr_flag 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,

Line 277: p_personal_flag 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,

Line 278: p_sequence_number 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,
282: p_cont_attribute3 in varchar2 default hr_api.g_varchar2,

Line 279: p_cont_attribute_category 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,

Line 280: p_cont_attribute1 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,

Line 281: p_cont_attribute2 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,

Line 282: p_cont_attribute3 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,

Line 283: p_cont_attribute4 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,

Line 284: p_cont_attribute5 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,

Line 285: p_cont_attribute6 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,

Line 286: p_cont_attribute7 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,

Line 287: p_cont_attribute8 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,

Line 288: p_cont_attribute9 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,

Line 289: p_cont_attribute10 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,

Line 290: p_cont_attribute11 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,

Line 291: p_cont_attribute12 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,

Line 292: p_cont_attribute13 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,

Line 293: p_cont_attribute14 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,

Line 294: p_cont_attribute15 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,

Line 295: p_cont_attribute16 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,

Line 296: p_cont_attribute17 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,

Line 297: p_cont_attribute18 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,

Line 298: p_cont_attribute19 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,

Line 299: p_cont_attribute20 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,

Line 300: p_cont_information_category 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,

Line 301: p_cont_information1 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,

Line 302: p_cont_information2 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,

Line 303: p_cont_information3 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,

Line 304: p_cont_information4 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,

Line 305: p_cont_information5 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,

Line 306: p_cont_information6 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,

Line 307: p_cont_information7 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,

Line 308: p_cont_information8 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,

Line 309: p_cont_information9 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,

Line 310: p_cont_information10 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,

Line 311: p_cont_information11 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,

Line 312: p_cont_information12 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,

Line 313: p_cont_information13 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,

Line 314: p_cont_information14 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,

Line 315: p_cont_information15 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,

Line 316: p_cont_information16 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,

Line 317: p_cont_information17 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,

Line 318: p_cont_information18 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,

Line 319: p_cont_information19 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,

Line 320: p_cont_information20 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,

Line 321: p_third_party_pay_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,

Line 322: p_bondholder_flag 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,
326: p_effective_date in date,

Line 323: p_dependent_flag 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,
327: p_validate in number default hr_api.g_false_num,

Line 324: p_beneficiary_flag 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,
328: p_return_status out nocopy varchar2

Line 327: p_validate in number default hr_api.g_false_num,

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

Line 356: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);

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,

Line 461: p_validate in number default hr_api.g_false_num,

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: --

Line 482: l_validate := hr_api.constant_to_boolean (p_constant_value => p_validate);

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,