APPS.PER_PAR_UPD dependencies on HR_API

Line 99: When hr_api.check_integrity_violated Then

95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 10);
97: --
98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_par_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then

Line 102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

98: Exception
99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_par_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_par_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 103: When hr_api.parent_integrity_violated Then

99: When hr_api.check_integrity_violated Then
100: -- A check constraint has been violated
101: per_par_shd.constraint_error
102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_par_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then

Line 106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

102: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_par_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_par_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 107: When hr_api.unique_integrity_violated Then

103: When hr_api.parent_integrity_violated Then
104: -- Parent integrity has been violated
105: per_par_shd.constraint_error
106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_par_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then

Line 110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

106: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.unique_integrity_violated Then
108: -- Unique integrity has been violated
109: per_par_shd.constraint_error
110: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
111: When Others Then
112: Raise;
113: End update_dml;
114: --

Line 273: when hr_api.cannot_find_prog_unit then

269: p_attribute20_o => per_par_shd.g_old_rec.attribute20 ,
270: p_participant_usage_status_o=> per_par_shd.g_old_rec.participant_usage_status);
271:
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: ( p_module_name => 'PER_PARTICIPANTS'
276: ,p_hook_type => 'AU'
277: );

Line 274: hr_api.cannot_find_prog_unit_error

270: p_participant_usage_status_o=> per_par_shd.g_old_rec.participant_usage_status);
271:
272: exception
273: when hr_api.cannot_find_prog_unit then
274: hr_api.cannot_find_prog_unit_error
275: ( p_module_name => 'PER_PARTICIPANTS'
276: ,p_hook_type => 'AU'
277: );
278: end;

Line 341: If (p_rec.business_group_id = hr_api.g_number) then

337: -- p_rec plsql record structure
338: -- to see if a system default is being used. If a system default
339: -- is being used then we must set to the 'current' argument value.
340: --
341: If (p_rec.business_group_id = hr_api.g_number) then
342: p_rec.business_group_id :=
343: per_par_shd.g_old_rec.business_group_id;
344: End If;
345:

Line 346: If (p_rec.questionnaire_template_id = hr_api.g_number) then

342: p_rec.business_group_id :=
343: per_par_shd.g_old_rec.business_group_id;
344: End If;
345:
346: If (p_rec.questionnaire_template_id = hr_api.g_number) then
347: p_rec.questionnaire_template_id :=
348: per_par_shd.g_old_rec.questionnaire_template_id;
349: End If;
350:

Line 351: If (p_rec.participation_in_table = hr_api.g_varchar2) then

347: p_rec.questionnaire_template_id :=
348: per_par_shd.g_old_rec.questionnaire_template_id;
349: End If;
350:
351: If (p_rec.participation_in_table = hr_api.g_varchar2) then
352: p_rec.participation_in_table :=
353: per_par_shd.g_old_rec.participation_in_table;
354: End If;
355: If (p_rec.participation_in_column = hr_api.g_varchar2) then

Line 355: If (p_rec.participation_in_column = hr_api.g_varchar2) then

351: If (p_rec.participation_in_table = hr_api.g_varchar2) then
352: p_rec.participation_in_table :=
353: per_par_shd.g_old_rec.participation_in_table;
354: End If;
355: If (p_rec.participation_in_column = hr_api.g_varchar2) then
356: p_rec.participation_in_column :=
357: per_par_shd.g_old_rec.participation_in_column;
358: End If;
359: If (p_rec.participation_in_id = hr_api.g_number) then

Line 359: If (p_rec.participation_in_id = hr_api.g_number) then

355: If (p_rec.participation_in_column = hr_api.g_varchar2) then
356: p_rec.participation_in_column :=
357: per_par_shd.g_old_rec.participation_in_column;
358: End If;
359: If (p_rec.participation_in_id = hr_api.g_number) then
360: p_rec.participation_in_id :=
361: per_par_shd.g_old_rec.participation_in_id;
362: End If;
363: If (p_rec.participation_status = hr_api.g_varchar2) then

Line 363: If (p_rec.participation_status = hr_api.g_varchar2) then

359: If (p_rec.participation_in_id = hr_api.g_number) then
360: p_rec.participation_in_id :=
361: per_par_shd.g_old_rec.participation_in_id;
362: End If;
363: If (p_rec.participation_status = hr_api.g_varchar2) then
364: p_rec.participation_status :=
365: per_par_shd.g_old_rec.participation_status;
366: End If;
367: If (p_rec.participation_type = hr_api.g_varchar2) then

Line 367: If (p_rec.participation_type = hr_api.g_varchar2) then

363: If (p_rec.participation_status = hr_api.g_varchar2) then
364: p_rec.participation_status :=
365: per_par_shd.g_old_rec.participation_status;
366: End If;
367: If (p_rec.participation_type = hr_api.g_varchar2) then
368: p_rec.participation_type :=
369: per_par_shd.g_old_rec.participation_type;
370: End If;
371: If (p_rec.last_notified_date = hr_api.g_date) then

Line 371: If (p_rec.last_notified_date = hr_api.g_date) then

367: If (p_rec.participation_type = hr_api.g_varchar2) then
368: p_rec.participation_type :=
369: per_par_shd.g_old_rec.participation_type;
370: End If;
371: If (p_rec.last_notified_date = hr_api.g_date) then
372: p_rec.last_notified_date :=
373: per_par_shd.g_old_rec.last_notified_date;
374: End If;
375: If (p_rec.date_completed = hr_api.g_date) then

Line 375: If (p_rec.date_completed = hr_api.g_date) then

371: If (p_rec.last_notified_date = hr_api.g_date) then
372: p_rec.last_notified_date :=
373: per_par_shd.g_old_rec.last_notified_date;
374: End If;
375: If (p_rec.date_completed = hr_api.g_date) then
376: p_rec.date_completed :=
377: per_par_shd.g_old_rec.date_completed;
378: End If;
379: If (p_rec.comments = hr_api.g_varchar2) then

Line 379: If (p_rec.comments = hr_api.g_varchar2) then

375: If (p_rec.date_completed = hr_api.g_date) then
376: p_rec.date_completed :=
377: per_par_shd.g_old_rec.date_completed;
378: End If;
379: If (p_rec.comments = hr_api.g_varchar2) then
380: p_rec.comments :=
381: per_par_shd.g_old_rec.comments;
382: End If;
383: If (p_rec.person_id = hr_api.g_number) then

Line 383: If (p_rec.person_id = hr_api.g_number) then

379: If (p_rec.comments = hr_api.g_varchar2) then
380: p_rec.comments :=
381: per_par_shd.g_old_rec.comments;
382: End If;
383: If (p_rec.person_id = hr_api.g_number) then
384: p_rec.person_id :=
385: per_par_shd.g_old_rec.person_id;
386: End If;
387: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 387: If (p_rec.attribute_category = hr_api.g_varchar2) then

383: If (p_rec.person_id = hr_api.g_number) then
384: p_rec.person_id :=
385: per_par_shd.g_old_rec.person_id;
386: End If;
387: If (p_rec.attribute_category = hr_api.g_varchar2) then
388: p_rec.attribute_category :=
389: per_par_shd.g_old_rec.attribute_category;
390: End If;
391: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 391: If (p_rec.attribute1 = hr_api.g_varchar2) then

387: If (p_rec.attribute_category = hr_api.g_varchar2) then
388: p_rec.attribute_category :=
389: per_par_shd.g_old_rec.attribute_category;
390: End If;
391: If (p_rec.attribute1 = hr_api.g_varchar2) then
392: p_rec.attribute1 :=
393: per_par_shd.g_old_rec.attribute1;
394: End If;
395: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 395: If (p_rec.attribute2 = hr_api.g_varchar2) then

391: If (p_rec.attribute1 = hr_api.g_varchar2) then
392: p_rec.attribute1 :=
393: per_par_shd.g_old_rec.attribute1;
394: End If;
395: If (p_rec.attribute2 = hr_api.g_varchar2) then
396: p_rec.attribute2 :=
397: per_par_shd.g_old_rec.attribute2;
398: End If;
399: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 399: If (p_rec.attribute3 = hr_api.g_varchar2) then

395: If (p_rec.attribute2 = hr_api.g_varchar2) then
396: p_rec.attribute2 :=
397: per_par_shd.g_old_rec.attribute2;
398: End If;
399: If (p_rec.attribute3 = hr_api.g_varchar2) then
400: p_rec.attribute3 :=
401: per_par_shd.g_old_rec.attribute3;
402: End If;
403: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 403: If (p_rec.attribute4 = hr_api.g_varchar2) then

399: If (p_rec.attribute3 = hr_api.g_varchar2) then
400: p_rec.attribute3 :=
401: per_par_shd.g_old_rec.attribute3;
402: End If;
403: If (p_rec.attribute4 = hr_api.g_varchar2) then
404: p_rec.attribute4 :=
405: per_par_shd.g_old_rec.attribute4;
406: End If;
407: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 407: If (p_rec.attribute5 = hr_api.g_varchar2) then

403: If (p_rec.attribute4 = hr_api.g_varchar2) then
404: p_rec.attribute4 :=
405: per_par_shd.g_old_rec.attribute4;
406: End If;
407: If (p_rec.attribute5 = hr_api.g_varchar2) then
408: p_rec.attribute5 :=
409: per_par_shd.g_old_rec.attribute5;
410: End If;
411: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 411: If (p_rec.attribute6 = hr_api.g_varchar2) then

407: If (p_rec.attribute5 = hr_api.g_varchar2) then
408: p_rec.attribute5 :=
409: per_par_shd.g_old_rec.attribute5;
410: End If;
411: If (p_rec.attribute6 = hr_api.g_varchar2) then
412: p_rec.attribute6 :=
413: per_par_shd.g_old_rec.attribute6;
414: End If;
415: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 415: If (p_rec.attribute7 = hr_api.g_varchar2) then

411: If (p_rec.attribute6 = hr_api.g_varchar2) then
412: p_rec.attribute6 :=
413: per_par_shd.g_old_rec.attribute6;
414: End If;
415: If (p_rec.attribute7 = hr_api.g_varchar2) then
416: p_rec.attribute7 :=
417: per_par_shd.g_old_rec.attribute7;
418: End If;
419: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 419: If (p_rec.attribute8 = hr_api.g_varchar2) then

415: If (p_rec.attribute7 = hr_api.g_varchar2) then
416: p_rec.attribute7 :=
417: per_par_shd.g_old_rec.attribute7;
418: End If;
419: If (p_rec.attribute8 = hr_api.g_varchar2) then
420: p_rec.attribute8 :=
421: per_par_shd.g_old_rec.attribute8;
422: End If;
423: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 423: If (p_rec.attribute9 = hr_api.g_varchar2) then

419: If (p_rec.attribute8 = hr_api.g_varchar2) then
420: p_rec.attribute8 :=
421: per_par_shd.g_old_rec.attribute8;
422: End If;
423: If (p_rec.attribute9 = hr_api.g_varchar2) then
424: p_rec.attribute9 :=
425: per_par_shd.g_old_rec.attribute9;
426: End If;
427: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 427: If (p_rec.attribute10 = hr_api.g_varchar2) then

423: If (p_rec.attribute9 = hr_api.g_varchar2) then
424: p_rec.attribute9 :=
425: per_par_shd.g_old_rec.attribute9;
426: End If;
427: If (p_rec.attribute10 = hr_api.g_varchar2) then
428: p_rec.attribute10 :=
429: per_par_shd.g_old_rec.attribute10;
430: End If;
431: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 431: If (p_rec.attribute11 = hr_api.g_varchar2) then

427: If (p_rec.attribute10 = hr_api.g_varchar2) then
428: p_rec.attribute10 :=
429: per_par_shd.g_old_rec.attribute10;
430: End If;
431: If (p_rec.attribute11 = hr_api.g_varchar2) then
432: p_rec.attribute11 :=
433: per_par_shd.g_old_rec.attribute11;
434: End If;
435: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 435: If (p_rec.attribute12 = hr_api.g_varchar2) then

431: If (p_rec.attribute11 = hr_api.g_varchar2) then
432: p_rec.attribute11 :=
433: per_par_shd.g_old_rec.attribute11;
434: End If;
435: If (p_rec.attribute12 = hr_api.g_varchar2) then
436: p_rec.attribute12 :=
437: per_par_shd.g_old_rec.attribute12;
438: End If;
439: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 439: If (p_rec.attribute13 = hr_api.g_varchar2) then

435: If (p_rec.attribute12 = hr_api.g_varchar2) then
436: p_rec.attribute12 :=
437: per_par_shd.g_old_rec.attribute12;
438: End If;
439: If (p_rec.attribute13 = hr_api.g_varchar2) then
440: p_rec.attribute13 :=
441: per_par_shd.g_old_rec.attribute13;
442: End If;
443: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 443: If (p_rec.attribute14 = hr_api.g_varchar2) then

439: If (p_rec.attribute13 = hr_api.g_varchar2) then
440: p_rec.attribute13 :=
441: per_par_shd.g_old_rec.attribute13;
442: End If;
443: If (p_rec.attribute14 = hr_api.g_varchar2) then
444: p_rec.attribute14 :=
445: per_par_shd.g_old_rec.attribute14;
446: End If;
447: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 447: If (p_rec.attribute15 = hr_api.g_varchar2) then

443: If (p_rec.attribute14 = hr_api.g_varchar2) then
444: p_rec.attribute14 :=
445: per_par_shd.g_old_rec.attribute14;
446: End If;
447: If (p_rec.attribute15 = hr_api.g_varchar2) then
448: p_rec.attribute15 :=
449: per_par_shd.g_old_rec.attribute15;
450: End If;
451: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 451: If (p_rec.attribute16 = hr_api.g_varchar2) then

447: If (p_rec.attribute15 = hr_api.g_varchar2) then
448: p_rec.attribute15 :=
449: per_par_shd.g_old_rec.attribute15;
450: End If;
451: If (p_rec.attribute16 = hr_api.g_varchar2) then
452: p_rec.attribute16 :=
453: per_par_shd.g_old_rec.attribute16;
454: End If;
455: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 455: If (p_rec.attribute17 = hr_api.g_varchar2) then

451: If (p_rec.attribute16 = hr_api.g_varchar2) then
452: p_rec.attribute16 :=
453: per_par_shd.g_old_rec.attribute16;
454: End If;
455: If (p_rec.attribute17 = hr_api.g_varchar2) then
456: p_rec.attribute17 :=
457: per_par_shd.g_old_rec.attribute17;
458: End If;
459: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 459: If (p_rec.attribute18 = hr_api.g_varchar2) then

455: If (p_rec.attribute17 = hr_api.g_varchar2) then
456: p_rec.attribute17 :=
457: per_par_shd.g_old_rec.attribute17;
458: End If;
459: If (p_rec.attribute18 = hr_api.g_varchar2) then
460: p_rec.attribute18 :=
461: per_par_shd.g_old_rec.attribute18;
462: End If;
463: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 463: If (p_rec.attribute19 = hr_api.g_varchar2) then

459: If (p_rec.attribute18 = hr_api.g_varchar2) then
460: p_rec.attribute18 :=
461: per_par_shd.g_old_rec.attribute18;
462: End If;
463: If (p_rec.attribute19 = hr_api.g_varchar2) then
464: p_rec.attribute19 :=
465: per_par_shd.g_old_rec.attribute19;
466: End If;
467: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 467: If (p_rec.attribute20 = hr_api.g_varchar2) then

463: If (p_rec.attribute19 = hr_api.g_varchar2) then
464: p_rec.attribute19 :=
465: per_par_shd.g_old_rec.attribute19;
466: End If;
467: If (p_rec.attribute20 = hr_api.g_varchar2) then
468: p_rec.attribute20 :=
469: per_par_shd.g_old_rec.attribute20;
470: End If;
471: If (p_rec.participant_usage_status = hr_api.g_varchar2) then

Line 471: If (p_rec.participant_usage_status = hr_api.g_varchar2) then

467: If (p_rec.attribute20 = hr_api.g_varchar2) then
468: p_rec.attribute20 :=
469: per_par_shd.g_old_rec.attribute20;
470: End If;
471: If (p_rec.participant_usage_status = hr_api.g_varchar2) then
472: p_rec.participant_usage_status :=
473: per_par_shd.g_old_rec.participant_usage_status;
474: End If;
475: --

Line 546: Raise HR_Api.Validate_Enabled;

542: --
543: -- If we are validating then raise the Validate_Enabled exception
544: --
545: If p_validate then
546: Raise HR_Api.Validate_Enabled;
547: End If;
548: --
549: hr_utility.set_location(' Leaving:'||l_proc, 10);
550: Exception

Line 551: When HR_Api.Validate_Enabled Then

547: End If;
548: --
549: hr_utility.set_location(' Leaving:'||l_proc, 10);
550: Exception
551: When HR_Api.Validate_Enabled Then
552: --
553: -- As the Validate_Enabled exception has been raised
554: -- we must rollback to the savepoint
555: --

Line 566: p_questionnaire_template_id in number default hr_api.g_number,

562: Procedure upd
563: (
564: p_participant_id in number,
565: p_object_version_number in out nocopy number,
566: p_questionnaire_template_id in number default hr_api.g_number,
567: p_participation_status in varchar2 default hr_api.g_varchar2,
568: p_participation_type in varchar2 default hr_api.g_varchar2,
569: p_last_notified_date in date default hr_api.g_date,
570: p_date_completed in date default hr_api.g_date,

Line 567: p_participation_status in varchar2 default hr_api.g_varchar2,

563: (
564: p_participant_id in number,
565: p_object_version_number in out nocopy number,
566: p_questionnaire_template_id in number default hr_api.g_number,
567: p_participation_status in varchar2 default hr_api.g_varchar2,
568: p_participation_type in varchar2 default hr_api.g_varchar2,
569: p_last_notified_date in date default hr_api.g_date,
570: p_date_completed in date default hr_api.g_date,
571: p_comments in varchar2 default hr_api.g_varchar2,

Line 568: p_participation_type in varchar2 default hr_api.g_varchar2,

564: p_participant_id in number,
565: p_object_version_number in out nocopy number,
566: p_questionnaire_template_id in number default hr_api.g_number,
567: p_participation_status in varchar2 default hr_api.g_varchar2,
568: p_participation_type in varchar2 default hr_api.g_varchar2,
569: p_last_notified_date in date default hr_api.g_date,
570: p_date_completed in date default hr_api.g_date,
571: p_comments in varchar2 default hr_api.g_varchar2,
572: p_person_id in number default hr_api.g_number,

Line 569: p_last_notified_date in date default hr_api.g_date,

565: p_object_version_number in out nocopy number,
566: p_questionnaire_template_id in number default hr_api.g_number,
567: p_participation_status in varchar2 default hr_api.g_varchar2,
568: p_participation_type in varchar2 default hr_api.g_varchar2,
569: p_last_notified_date in date default hr_api.g_date,
570: p_date_completed in date default hr_api.g_date,
571: p_comments in varchar2 default hr_api.g_varchar2,
572: p_person_id in number default hr_api.g_number,
573: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 570: p_date_completed in date default hr_api.g_date,

566: p_questionnaire_template_id in number default hr_api.g_number,
567: p_participation_status in varchar2 default hr_api.g_varchar2,
568: p_participation_type in varchar2 default hr_api.g_varchar2,
569: p_last_notified_date in date default hr_api.g_date,
570: p_date_completed in date default hr_api.g_date,
571: p_comments in varchar2 default hr_api.g_varchar2,
572: p_person_id in number default hr_api.g_number,
573: p_attribute_category in varchar2 default hr_api.g_varchar2,
574: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 571: p_comments in varchar2 default hr_api.g_varchar2,

567: p_participation_status in varchar2 default hr_api.g_varchar2,
568: p_participation_type in varchar2 default hr_api.g_varchar2,
569: p_last_notified_date in date default hr_api.g_date,
570: p_date_completed in date default hr_api.g_date,
571: p_comments in varchar2 default hr_api.g_varchar2,
572: p_person_id in number default hr_api.g_number,
573: p_attribute_category in varchar2 default hr_api.g_varchar2,
574: p_attribute1 in varchar2 default hr_api.g_varchar2,
575: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 572: p_person_id in number default hr_api.g_number,

568: p_participation_type in varchar2 default hr_api.g_varchar2,
569: p_last_notified_date in date default hr_api.g_date,
570: p_date_completed in date default hr_api.g_date,
571: p_comments in varchar2 default hr_api.g_varchar2,
572: p_person_id in number default hr_api.g_number,
573: p_attribute_category in varchar2 default hr_api.g_varchar2,
574: p_attribute1 in varchar2 default hr_api.g_varchar2,
575: p_attribute2 in varchar2 default hr_api.g_varchar2,
576: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 573: p_attribute_category in varchar2 default hr_api.g_varchar2,

569: p_last_notified_date in date default hr_api.g_date,
570: p_date_completed in date default hr_api.g_date,
571: p_comments in varchar2 default hr_api.g_varchar2,
572: p_person_id in number default hr_api.g_number,
573: p_attribute_category in varchar2 default hr_api.g_varchar2,
574: p_attribute1 in varchar2 default hr_api.g_varchar2,
575: p_attribute2 in varchar2 default hr_api.g_varchar2,
576: p_attribute3 in varchar2 default hr_api.g_varchar2,
577: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 574: p_attribute1 in varchar2 default hr_api.g_varchar2,

570: p_date_completed in date default hr_api.g_date,
571: p_comments in varchar2 default hr_api.g_varchar2,
572: p_person_id in number default hr_api.g_number,
573: p_attribute_category in varchar2 default hr_api.g_varchar2,
574: p_attribute1 in varchar2 default hr_api.g_varchar2,
575: p_attribute2 in varchar2 default hr_api.g_varchar2,
576: p_attribute3 in varchar2 default hr_api.g_varchar2,
577: p_attribute4 in varchar2 default hr_api.g_varchar2,
578: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 575: p_attribute2 in varchar2 default hr_api.g_varchar2,

571: p_comments in varchar2 default hr_api.g_varchar2,
572: p_person_id in number default hr_api.g_number,
573: p_attribute_category in varchar2 default hr_api.g_varchar2,
574: p_attribute1 in varchar2 default hr_api.g_varchar2,
575: p_attribute2 in varchar2 default hr_api.g_varchar2,
576: p_attribute3 in varchar2 default hr_api.g_varchar2,
577: p_attribute4 in varchar2 default hr_api.g_varchar2,
578: p_attribute5 in varchar2 default hr_api.g_varchar2,
579: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 576: p_attribute3 in varchar2 default hr_api.g_varchar2,

572: p_person_id in number default hr_api.g_number,
573: p_attribute_category in varchar2 default hr_api.g_varchar2,
574: p_attribute1 in varchar2 default hr_api.g_varchar2,
575: p_attribute2 in varchar2 default hr_api.g_varchar2,
576: p_attribute3 in varchar2 default hr_api.g_varchar2,
577: p_attribute4 in varchar2 default hr_api.g_varchar2,
578: p_attribute5 in varchar2 default hr_api.g_varchar2,
579: p_attribute6 in varchar2 default hr_api.g_varchar2,
580: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 577: p_attribute4 in varchar2 default hr_api.g_varchar2,

573: p_attribute_category in varchar2 default hr_api.g_varchar2,
574: p_attribute1 in varchar2 default hr_api.g_varchar2,
575: p_attribute2 in varchar2 default hr_api.g_varchar2,
576: p_attribute3 in varchar2 default hr_api.g_varchar2,
577: p_attribute4 in varchar2 default hr_api.g_varchar2,
578: p_attribute5 in varchar2 default hr_api.g_varchar2,
579: p_attribute6 in varchar2 default hr_api.g_varchar2,
580: p_attribute7 in varchar2 default hr_api.g_varchar2,
581: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 578: p_attribute5 in varchar2 default hr_api.g_varchar2,

574: p_attribute1 in varchar2 default hr_api.g_varchar2,
575: p_attribute2 in varchar2 default hr_api.g_varchar2,
576: p_attribute3 in varchar2 default hr_api.g_varchar2,
577: p_attribute4 in varchar2 default hr_api.g_varchar2,
578: p_attribute5 in varchar2 default hr_api.g_varchar2,
579: p_attribute6 in varchar2 default hr_api.g_varchar2,
580: p_attribute7 in varchar2 default hr_api.g_varchar2,
581: p_attribute8 in varchar2 default hr_api.g_varchar2,
582: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 579: p_attribute6 in varchar2 default hr_api.g_varchar2,

575: p_attribute2 in varchar2 default hr_api.g_varchar2,
576: p_attribute3 in varchar2 default hr_api.g_varchar2,
577: p_attribute4 in varchar2 default hr_api.g_varchar2,
578: p_attribute5 in varchar2 default hr_api.g_varchar2,
579: p_attribute6 in varchar2 default hr_api.g_varchar2,
580: p_attribute7 in varchar2 default hr_api.g_varchar2,
581: p_attribute8 in varchar2 default hr_api.g_varchar2,
582: p_attribute9 in varchar2 default hr_api.g_varchar2,
583: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 580: p_attribute7 in varchar2 default hr_api.g_varchar2,

576: p_attribute3 in varchar2 default hr_api.g_varchar2,
577: p_attribute4 in varchar2 default hr_api.g_varchar2,
578: p_attribute5 in varchar2 default hr_api.g_varchar2,
579: p_attribute6 in varchar2 default hr_api.g_varchar2,
580: p_attribute7 in varchar2 default hr_api.g_varchar2,
581: p_attribute8 in varchar2 default hr_api.g_varchar2,
582: p_attribute9 in varchar2 default hr_api.g_varchar2,
583: p_attribute10 in varchar2 default hr_api.g_varchar2,
584: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 581: p_attribute8 in varchar2 default hr_api.g_varchar2,

577: p_attribute4 in varchar2 default hr_api.g_varchar2,
578: p_attribute5 in varchar2 default hr_api.g_varchar2,
579: p_attribute6 in varchar2 default hr_api.g_varchar2,
580: p_attribute7 in varchar2 default hr_api.g_varchar2,
581: p_attribute8 in varchar2 default hr_api.g_varchar2,
582: p_attribute9 in varchar2 default hr_api.g_varchar2,
583: p_attribute10 in varchar2 default hr_api.g_varchar2,
584: p_attribute11 in varchar2 default hr_api.g_varchar2,
585: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 582: p_attribute9 in varchar2 default hr_api.g_varchar2,

578: p_attribute5 in varchar2 default hr_api.g_varchar2,
579: p_attribute6 in varchar2 default hr_api.g_varchar2,
580: p_attribute7 in varchar2 default hr_api.g_varchar2,
581: p_attribute8 in varchar2 default hr_api.g_varchar2,
582: p_attribute9 in varchar2 default hr_api.g_varchar2,
583: p_attribute10 in varchar2 default hr_api.g_varchar2,
584: p_attribute11 in varchar2 default hr_api.g_varchar2,
585: p_attribute12 in varchar2 default hr_api.g_varchar2,
586: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 583: p_attribute10 in varchar2 default hr_api.g_varchar2,

579: p_attribute6 in varchar2 default hr_api.g_varchar2,
580: p_attribute7 in varchar2 default hr_api.g_varchar2,
581: p_attribute8 in varchar2 default hr_api.g_varchar2,
582: p_attribute9 in varchar2 default hr_api.g_varchar2,
583: p_attribute10 in varchar2 default hr_api.g_varchar2,
584: p_attribute11 in varchar2 default hr_api.g_varchar2,
585: p_attribute12 in varchar2 default hr_api.g_varchar2,
586: p_attribute13 in varchar2 default hr_api.g_varchar2,
587: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 584: p_attribute11 in varchar2 default hr_api.g_varchar2,

580: p_attribute7 in varchar2 default hr_api.g_varchar2,
581: p_attribute8 in varchar2 default hr_api.g_varchar2,
582: p_attribute9 in varchar2 default hr_api.g_varchar2,
583: p_attribute10 in varchar2 default hr_api.g_varchar2,
584: p_attribute11 in varchar2 default hr_api.g_varchar2,
585: p_attribute12 in varchar2 default hr_api.g_varchar2,
586: p_attribute13 in varchar2 default hr_api.g_varchar2,
587: p_attribute14 in varchar2 default hr_api.g_varchar2,
588: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 585: p_attribute12 in varchar2 default hr_api.g_varchar2,

581: p_attribute8 in varchar2 default hr_api.g_varchar2,
582: p_attribute9 in varchar2 default hr_api.g_varchar2,
583: p_attribute10 in varchar2 default hr_api.g_varchar2,
584: p_attribute11 in varchar2 default hr_api.g_varchar2,
585: p_attribute12 in varchar2 default hr_api.g_varchar2,
586: p_attribute13 in varchar2 default hr_api.g_varchar2,
587: p_attribute14 in varchar2 default hr_api.g_varchar2,
588: p_attribute15 in varchar2 default hr_api.g_varchar2,
589: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 586: p_attribute13 in varchar2 default hr_api.g_varchar2,

582: p_attribute9 in varchar2 default hr_api.g_varchar2,
583: p_attribute10 in varchar2 default hr_api.g_varchar2,
584: p_attribute11 in varchar2 default hr_api.g_varchar2,
585: p_attribute12 in varchar2 default hr_api.g_varchar2,
586: p_attribute13 in varchar2 default hr_api.g_varchar2,
587: p_attribute14 in varchar2 default hr_api.g_varchar2,
588: p_attribute15 in varchar2 default hr_api.g_varchar2,
589: p_attribute16 in varchar2 default hr_api.g_varchar2,
590: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 587: p_attribute14 in varchar2 default hr_api.g_varchar2,

583: p_attribute10 in varchar2 default hr_api.g_varchar2,
584: p_attribute11 in varchar2 default hr_api.g_varchar2,
585: p_attribute12 in varchar2 default hr_api.g_varchar2,
586: p_attribute13 in varchar2 default hr_api.g_varchar2,
587: p_attribute14 in varchar2 default hr_api.g_varchar2,
588: p_attribute15 in varchar2 default hr_api.g_varchar2,
589: p_attribute16 in varchar2 default hr_api.g_varchar2,
590: p_attribute17 in varchar2 default hr_api.g_varchar2,
591: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 588: p_attribute15 in varchar2 default hr_api.g_varchar2,

584: p_attribute11 in varchar2 default hr_api.g_varchar2,
585: p_attribute12 in varchar2 default hr_api.g_varchar2,
586: p_attribute13 in varchar2 default hr_api.g_varchar2,
587: p_attribute14 in varchar2 default hr_api.g_varchar2,
588: p_attribute15 in varchar2 default hr_api.g_varchar2,
589: p_attribute16 in varchar2 default hr_api.g_varchar2,
590: p_attribute17 in varchar2 default hr_api.g_varchar2,
591: p_attribute18 in varchar2 default hr_api.g_varchar2,
592: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 589: p_attribute16 in varchar2 default hr_api.g_varchar2,

585: p_attribute12 in varchar2 default hr_api.g_varchar2,
586: p_attribute13 in varchar2 default hr_api.g_varchar2,
587: p_attribute14 in varchar2 default hr_api.g_varchar2,
588: p_attribute15 in varchar2 default hr_api.g_varchar2,
589: p_attribute16 in varchar2 default hr_api.g_varchar2,
590: p_attribute17 in varchar2 default hr_api.g_varchar2,
591: p_attribute18 in varchar2 default hr_api.g_varchar2,
592: p_attribute19 in varchar2 default hr_api.g_varchar2,
593: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 590: p_attribute17 in varchar2 default hr_api.g_varchar2,

586: p_attribute13 in varchar2 default hr_api.g_varchar2,
587: p_attribute14 in varchar2 default hr_api.g_varchar2,
588: p_attribute15 in varchar2 default hr_api.g_varchar2,
589: p_attribute16 in varchar2 default hr_api.g_varchar2,
590: p_attribute17 in varchar2 default hr_api.g_varchar2,
591: p_attribute18 in varchar2 default hr_api.g_varchar2,
592: p_attribute19 in varchar2 default hr_api.g_varchar2,
593: p_attribute20 in varchar2 default hr_api.g_varchar2,
594: p_effective_date in date,

Line 591: p_attribute18 in varchar2 default hr_api.g_varchar2,

587: p_attribute14 in varchar2 default hr_api.g_varchar2,
588: p_attribute15 in varchar2 default hr_api.g_varchar2,
589: p_attribute16 in varchar2 default hr_api.g_varchar2,
590: p_attribute17 in varchar2 default hr_api.g_varchar2,
591: p_attribute18 in varchar2 default hr_api.g_varchar2,
592: p_attribute19 in varchar2 default hr_api.g_varchar2,
593: p_attribute20 in varchar2 default hr_api.g_varchar2,
594: p_effective_date in date,
595: p_participant_usage_status in varchar2 default hr_api.g_varchar2,

Line 592: p_attribute19 in varchar2 default hr_api.g_varchar2,

588: p_attribute15 in varchar2 default hr_api.g_varchar2,
589: p_attribute16 in varchar2 default hr_api.g_varchar2,
590: p_attribute17 in varchar2 default hr_api.g_varchar2,
591: p_attribute18 in varchar2 default hr_api.g_varchar2,
592: p_attribute19 in varchar2 default hr_api.g_varchar2,
593: p_attribute20 in varchar2 default hr_api.g_varchar2,
594: p_effective_date in date,
595: p_participant_usage_status in varchar2 default hr_api.g_varchar2,
596: p_validate in boolean default false

Line 593: p_attribute20 in varchar2 default hr_api.g_varchar2,

589: p_attribute16 in varchar2 default hr_api.g_varchar2,
590: p_attribute17 in varchar2 default hr_api.g_varchar2,
591: p_attribute18 in varchar2 default hr_api.g_varchar2,
592: p_attribute19 in varchar2 default hr_api.g_varchar2,
593: p_attribute20 in varchar2 default hr_api.g_varchar2,
594: p_effective_date in date,
595: p_participant_usage_status in varchar2 default hr_api.g_varchar2,
596: p_validate in boolean default false
597: ) is

Line 595: p_participant_usage_status in varchar2 default hr_api.g_varchar2,

591: p_attribute18 in varchar2 default hr_api.g_varchar2,
592: p_attribute19 in varchar2 default hr_api.g_varchar2,
593: p_attribute20 in varchar2 default hr_api.g_varchar2,
594: p_effective_date in date,
595: p_participant_usage_status in varchar2 default hr_api.g_varchar2,
596: p_validate in boolean default false
597: ) is
598: --
599: l_rec per_par_shd.g_rec_type;

Line 612: hr_api.g_number,

608: l_rec :=
609: per_par_shd.convert_args
610: (
611: p_participant_id,
612: hr_api.g_number,
613: p_object_version_number,
614: p_questionnaire_template_id,
615: hr_api.g_varchar2,
616: hr_api.g_varchar2,

Line 615: hr_api.g_varchar2,

611: p_participant_id,
612: hr_api.g_number,
613: p_object_version_number,
614: p_questionnaire_template_id,
615: hr_api.g_varchar2,
616: hr_api.g_varchar2,
617: hr_api.g_number,
618: p_participation_status,
619: p_participation_type,

Line 616: hr_api.g_varchar2,

612: hr_api.g_number,
613: p_object_version_number,
614: p_questionnaire_template_id,
615: hr_api.g_varchar2,
616: hr_api.g_varchar2,
617: hr_api.g_number,
618: p_participation_status,
619: p_participation_type,
620: p_last_notified_date,

Line 617: hr_api.g_number,

613: p_object_version_number,
614: p_questionnaire_template_id,
615: hr_api.g_varchar2,
616: hr_api.g_varchar2,
617: hr_api.g_number,
618: p_participation_status,
619: p_participation_type,
620: p_last_notified_date,
621: p_date_completed,