109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: --
112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: ota_cre_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: ota_cre_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_cre_shd.constraint_error
114: -- A check constraint has been violated
115: --
116: ota_cre_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_cre_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_cre_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_cre_shd.constraint_error
119: -- Parent integrity has been violated
120: --
121: ota_cre_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_cre_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_cre_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;
131: End update_dml;
356: );
357: --
358: exception
359: --
360: when hr_api.cannot_find_prog_unit then
361: --
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'OTA_CERT_ENROLLMENTS'
364: ,p_hook_type => 'AU');
358: exception
359: --
360: when hr_api.cannot_find_prog_unit then
361: --
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'OTA_CERT_ENROLLMENTS'
364: ,p_hook_type => 'AU');
365: --
366: end;
421: -- p_rec plsql record structure
422: -- to see if a system default is being used. If a system default
423: -- is being used then we must set to the 'current' argument value.
424: --
425: If (p_rec.certification_id = hr_api.g_number) then
426: p_rec.certification_id :=
427: ota_cre_shd.g_old_rec.certification_id;
428: End If;
429: If (p_rec.person_id = hr_api.g_number) then
425: If (p_rec.certification_id = hr_api.g_number) then
426: p_rec.certification_id :=
427: ota_cre_shd.g_old_rec.certification_id;
428: End If;
429: If (p_rec.person_id = hr_api.g_number) then
430: p_rec.person_id :=
431: ota_cre_shd.g_old_rec.person_id;
432: End If;
433: If (p_rec.contact_id = hr_api.g_number) then
429: If (p_rec.person_id = hr_api.g_number) then
430: p_rec.person_id :=
431: ota_cre_shd.g_old_rec.person_id;
432: End If;
433: If (p_rec.contact_id = hr_api.g_number) then
434: p_rec.contact_id :=
435: ota_cre_shd.g_old_rec.contact_id;
436: End If;
437: If (p_rec.certification_status_code = hr_api.g_varchar2) then
433: If (p_rec.contact_id = hr_api.g_number) then
434: p_rec.contact_id :=
435: ota_cre_shd.g_old_rec.contact_id;
436: End If;
437: If (p_rec.certification_status_code = hr_api.g_varchar2) then
438: p_rec.certification_status_code :=
439: ota_cre_shd.g_old_rec.certification_status_code;
440: End If;
441: If (p_rec.completion_date = hr_api.g_date) then
437: If (p_rec.certification_status_code = hr_api.g_varchar2) then
438: p_rec.certification_status_code :=
439: ota_cre_shd.g_old_rec.certification_status_code;
440: End If;
441: If (p_rec.completion_date = hr_api.g_date) then
442: p_rec.completion_date :=
443: ota_cre_shd.g_old_rec.completion_date;
444: End If;
445: If (p_rec.business_group_id = hr_api.g_number) then
441: If (p_rec.completion_date = hr_api.g_date) then
442: p_rec.completion_date :=
443: ota_cre_shd.g_old_rec.completion_date;
444: End If;
445: If (p_rec.business_group_id = hr_api.g_number) then
446: p_rec.business_group_id :=
447: ota_cre_shd.g_old_rec.business_group_id;
448: End If;
449: If (p_rec.unenrollment_date = hr_api.g_date) then
445: If (p_rec.business_group_id = hr_api.g_number) then
446: p_rec.business_group_id :=
447: ota_cre_shd.g_old_rec.business_group_id;
448: End If;
449: If (p_rec.unenrollment_date = hr_api.g_date) then
450: p_rec.unenrollment_date :=
451: ota_cre_shd.g_old_rec.unenrollment_date;
452: End If;
453: If (p_rec.expiration_date = hr_api.g_date) then
449: If (p_rec.unenrollment_date = hr_api.g_date) then
450: p_rec.unenrollment_date :=
451: ota_cre_shd.g_old_rec.unenrollment_date;
452: End If;
453: If (p_rec.expiration_date = hr_api.g_date) then
454: p_rec.expiration_date :=
455: ota_cre_shd.g_old_rec.expiration_date;
456: End If;
457: If (p_rec.earliest_enroll_date = hr_api.g_date) then
453: If (p_rec.expiration_date = hr_api.g_date) then
454: p_rec.expiration_date :=
455: ota_cre_shd.g_old_rec.expiration_date;
456: End If;
457: If (p_rec.earliest_enroll_date = hr_api.g_date) then
458: p_rec.earliest_enroll_date :=
459: ota_cre_shd.g_old_rec.earliest_enroll_date;
460: End If;
461: If (p_rec.is_history_flag = hr_api.g_varchar2) then
457: If (p_rec.earliest_enroll_date = hr_api.g_date) then
458: p_rec.earliest_enroll_date :=
459: ota_cre_shd.g_old_rec.earliest_enroll_date;
460: End If;
461: If (p_rec.is_history_flag = hr_api.g_varchar2) then
462: p_rec.is_history_flag :=
463: ota_cre_shd.g_old_rec.is_history_flag;
464: End If;
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
461: If (p_rec.is_history_flag = hr_api.g_varchar2) then
462: p_rec.is_history_flag :=
463: ota_cre_shd.g_old_rec.is_history_flag;
464: End If;
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
466: p_rec.attribute_category :=
467: ota_cre_shd.g_old_rec.attribute_category;
468: End If;
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
465: If (p_rec.attribute_category = hr_api.g_varchar2) then
466: p_rec.attribute_category :=
467: ota_cre_shd.g_old_rec.attribute_category;
468: End If;
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
470: p_rec.attribute1 :=
471: ota_cre_shd.g_old_rec.attribute1;
472: End If;
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
469: If (p_rec.attribute1 = hr_api.g_varchar2) then
470: p_rec.attribute1 :=
471: ota_cre_shd.g_old_rec.attribute1;
472: End If;
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
474: p_rec.attribute2 :=
475: ota_cre_shd.g_old_rec.attribute2;
476: End If;
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
473: If (p_rec.attribute2 = hr_api.g_varchar2) then
474: p_rec.attribute2 :=
475: ota_cre_shd.g_old_rec.attribute2;
476: End If;
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
478: p_rec.attribute3 :=
479: ota_cre_shd.g_old_rec.attribute3;
480: End If;
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
477: If (p_rec.attribute3 = hr_api.g_varchar2) then
478: p_rec.attribute3 :=
479: ota_cre_shd.g_old_rec.attribute3;
480: End If;
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
482: p_rec.attribute4 :=
483: ota_cre_shd.g_old_rec.attribute4;
484: End If;
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
481: If (p_rec.attribute4 = hr_api.g_varchar2) then
482: p_rec.attribute4 :=
483: ota_cre_shd.g_old_rec.attribute4;
484: End If;
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
486: p_rec.attribute5 :=
487: ota_cre_shd.g_old_rec.attribute5;
488: End If;
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
485: If (p_rec.attribute5 = hr_api.g_varchar2) then
486: p_rec.attribute5 :=
487: ota_cre_shd.g_old_rec.attribute5;
488: End If;
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
490: p_rec.attribute6 :=
491: ota_cre_shd.g_old_rec.attribute6;
492: End If;
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
489: If (p_rec.attribute6 = hr_api.g_varchar2) then
490: p_rec.attribute6 :=
491: ota_cre_shd.g_old_rec.attribute6;
492: End If;
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
494: p_rec.attribute7 :=
495: ota_cre_shd.g_old_rec.attribute7;
496: End If;
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
493: If (p_rec.attribute7 = hr_api.g_varchar2) then
494: p_rec.attribute7 :=
495: ota_cre_shd.g_old_rec.attribute7;
496: End If;
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
498: p_rec.attribute8 :=
499: ota_cre_shd.g_old_rec.attribute8;
500: End If;
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
497: If (p_rec.attribute8 = hr_api.g_varchar2) then
498: p_rec.attribute8 :=
499: ota_cre_shd.g_old_rec.attribute8;
500: End If;
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
502: p_rec.attribute9 :=
503: ota_cre_shd.g_old_rec.attribute9;
504: End If;
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
501: If (p_rec.attribute9 = hr_api.g_varchar2) then
502: p_rec.attribute9 :=
503: ota_cre_shd.g_old_rec.attribute9;
504: End If;
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
506: p_rec.attribute10 :=
507: ota_cre_shd.g_old_rec.attribute10;
508: End If;
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
505: If (p_rec.attribute10 = hr_api.g_varchar2) then
506: p_rec.attribute10 :=
507: ota_cre_shd.g_old_rec.attribute10;
508: End If;
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
510: p_rec.attribute11 :=
511: ota_cre_shd.g_old_rec.attribute11;
512: End If;
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
509: If (p_rec.attribute11 = hr_api.g_varchar2) then
510: p_rec.attribute11 :=
511: ota_cre_shd.g_old_rec.attribute11;
512: End If;
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
514: p_rec.attribute12 :=
515: ota_cre_shd.g_old_rec.attribute12;
516: End If;
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
513: If (p_rec.attribute12 = hr_api.g_varchar2) then
514: p_rec.attribute12 :=
515: ota_cre_shd.g_old_rec.attribute12;
516: End If;
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
518: p_rec.attribute13 :=
519: ota_cre_shd.g_old_rec.attribute13;
520: End If;
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
517: If (p_rec.attribute13 = hr_api.g_varchar2) then
518: p_rec.attribute13 :=
519: ota_cre_shd.g_old_rec.attribute13;
520: End If;
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
522: p_rec.attribute14 :=
523: ota_cre_shd.g_old_rec.attribute14;
524: End If;
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
521: If (p_rec.attribute14 = hr_api.g_varchar2) then
522: p_rec.attribute14 :=
523: ota_cre_shd.g_old_rec.attribute14;
524: End If;
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
526: p_rec.attribute15 :=
527: ota_cre_shd.g_old_rec.attribute15;
528: End If;
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
525: If (p_rec.attribute15 = hr_api.g_varchar2) then
526: p_rec.attribute15 :=
527: ota_cre_shd.g_old_rec.attribute15;
528: End If;
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
530: p_rec.attribute16 :=
531: ota_cre_shd.g_old_rec.attribute16;
532: End If;
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
529: If (p_rec.attribute16 = hr_api.g_varchar2) then
530: p_rec.attribute16 :=
531: ota_cre_shd.g_old_rec.attribute16;
532: End If;
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
534: p_rec.attribute17 :=
535: ota_cre_shd.g_old_rec.attribute17;
536: End If;
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
533: If (p_rec.attribute17 = hr_api.g_varchar2) then
534: p_rec.attribute17 :=
535: ota_cre_shd.g_old_rec.attribute17;
536: End If;
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
538: p_rec.attribute18 :=
539: ota_cre_shd.g_old_rec.attribute18;
540: End If;
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
537: If (p_rec.attribute18 = hr_api.g_varchar2) then
538: p_rec.attribute18 :=
539: ota_cre_shd.g_old_rec.attribute18;
540: End If;
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
542: p_rec.attribute19 :=
543: ota_cre_shd.g_old_rec.attribute19;
544: End If;
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
541: If (p_rec.attribute19 = hr_api.g_varchar2) then
542: p_rec.attribute19 :=
543: ota_cre_shd.g_old_rec.attribute19;
544: End If;
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
546: p_rec.attribute20 :=
547: ota_cre_shd.g_old_rec.attribute20;
548: End If;
549: If (p_rec.enrollment_date = hr_api.g_date) then
545: If (p_rec.attribute20 = hr_api.g_varchar2) then
546: p_rec.attribute20 :=
547: ota_cre_shd.g_old_rec.attribute20;
548: End If;
549: If (p_rec.enrollment_date = hr_api.g_date) then
550: p_rec.enrollment_date :=
551: ota_cre_shd.g_old_rec.enrollment_date;
552: End If;
553: --
613: Procedure upd
614: (p_effective_date in date
615: ,p_cert_enrollment_id in number
616: ,p_object_version_number in out nocopy number
617: ,p_certification_id in number default hr_api.g_number
618: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
619: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
620: ,p_person_id in number default hr_api.g_number
621: ,p_contact_id in number default hr_api.g_number
614: (p_effective_date in date
615: ,p_cert_enrollment_id in number
616: ,p_object_version_number in out nocopy number
617: ,p_certification_id in number default hr_api.g_number
618: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
619: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
620: ,p_person_id in number default hr_api.g_number
621: ,p_contact_id in number default hr_api.g_number
622: ,p_completion_date in date default hr_api.g_date
615: ,p_cert_enrollment_id in number
616: ,p_object_version_number in out nocopy number
617: ,p_certification_id in number default hr_api.g_number
618: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
619: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
620: ,p_person_id in number default hr_api.g_number
621: ,p_contact_id in number default hr_api.g_number
622: ,p_completion_date in date default hr_api.g_date
623: ,p_business_group_id in number default hr_api.g_number
616: ,p_object_version_number in out nocopy number
617: ,p_certification_id in number default hr_api.g_number
618: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
619: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
620: ,p_person_id in number default hr_api.g_number
621: ,p_contact_id in number default hr_api.g_number
622: ,p_completion_date in date default hr_api.g_date
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_unenrollment_date in date default hr_api.g_date
617: ,p_certification_id in number default hr_api.g_number
618: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
619: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
620: ,p_person_id in number default hr_api.g_number
621: ,p_contact_id in number default hr_api.g_number
622: ,p_completion_date in date default hr_api.g_date
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_unenrollment_date in date default hr_api.g_date
625: ,p_expiration_date in date default hr_api.g_date
618: ,p_certification_status_code in varchar2 default hr_api.g_varchar2
619: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
620: ,p_person_id in number default hr_api.g_number
621: ,p_contact_id in number default hr_api.g_number
622: ,p_completion_date in date default hr_api.g_date
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_unenrollment_date in date default hr_api.g_date
625: ,p_expiration_date in date default hr_api.g_date
626: ,p_earliest_enroll_date in date default hr_api.g_date
619: ,p_is_history_flag in varchar2 default hr_api.g_varchar2
620: ,p_person_id in number default hr_api.g_number
621: ,p_contact_id in number default hr_api.g_number
622: ,p_completion_date in date default hr_api.g_date
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_unenrollment_date in date default hr_api.g_date
625: ,p_expiration_date in date default hr_api.g_date
626: ,p_earliest_enroll_date in date default hr_api.g_date
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
620: ,p_person_id in number default hr_api.g_number
621: ,p_contact_id in number default hr_api.g_number
622: ,p_completion_date in date default hr_api.g_date
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_unenrollment_date in date default hr_api.g_date
625: ,p_expiration_date in date default hr_api.g_date
626: ,p_earliest_enroll_date in date default hr_api.g_date
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
621: ,p_contact_id in number default hr_api.g_number
622: ,p_completion_date in date default hr_api.g_date
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_unenrollment_date in date default hr_api.g_date
625: ,p_expiration_date in date default hr_api.g_date
626: ,p_earliest_enroll_date in date default hr_api.g_date
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
622: ,p_completion_date in date default hr_api.g_date
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_unenrollment_date in date default hr_api.g_date
625: ,p_expiration_date in date default hr_api.g_date
626: ,p_earliest_enroll_date in date default hr_api.g_date
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
623: ,p_business_group_id in number default hr_api.g_number
624: ,p_unenrollment_date in date default hr_api.g_date
625: ,p_expiration_date in date default hr_api.g_date
626: ,p_earliest_enroll_date in date default hr_api.g_date
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
624: ,p_unenrollment_date in date default hr_api.g_date
625: ,p_expiration_date in date default hr_api.g_date
626: ,p_earliest_enroll_date in date default hr_api.g_date
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
625: ,p_expiration_date in date default hr_api.g_date
626: ,p_earliest_enroll_date in date default hr_api.g_date
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
626: ,p_earliest_enroll_date in date default hr_api.g_date
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
627: ,p_attribute_category in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
628: ,p_attribute1 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
629: ,p_attribute2 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
630: ,p_attribute3 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
631: ,p_attribute4 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
632: ,p_attribute5 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
633: ,p_attribute6 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
634: ,p_attribute7 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
635: ,p_attribute8 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
636: ,p_attribute9 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
637: ,p_attribute10 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
645: ,p_attribute18 in varchar2 default hr_api.g_varchar2
638: ,p_attribute11 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
645: ,p_attribute18 in varchar2 default hr_api.g_varchar2
646: ,p_attribute19 in varchar2 default hr_api.g_varchar2
639: ,p_attribute12 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
645: ,p_attribute18 in varchar2 default hr_api.g_varchar2
646: ,p_attribute19 in varchar2 default hr_api.g_varchar2
647: ,p_attribute20 in varchar2 default hr_api.g_varchar2
640: ,p_attribute13 in varchar2 default hr_api.g_varchar2
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
645: ,p_attribute18 in varchar2 default hr_api.g_varchar2
646: ,p_attribute19 in varchar2 default hr_api.g_varchar2
647: ,p_attribute20 in varchar2 default hr_api.g_varchar2
648: ,p_enrollment_date in date default hr_api.g_date
641: ,p_attribute14 in varchar2 default hr_api.g_varchar2
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
645: ,p_attribute18 in varchar2 default hr_api.g_varchar2
646: ,p_attribute19 in varchar2 default hr_api.g_varchar2
647: ,p_attribute20 in varchar2 default hr_api.g_varchar2
648: ,p_enrollment_date in date default hr_api.g_date
649: ) is
642: ,p_attribute15 in varchar2 default hr_api.g_varchar2
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
645: ,p_attribute18 in varchar2 default hr_api.g_varchar2
646: ,p_attribute19 in varchar2 default hr_api.g_varchar2
647: ,p_attribute20 in varchar2 default hr_api.g_varchar2
648: ,p_enrollment_date in date default hr_api.g_date
649: ) is
650: --
643: ,p_attribute16 in varchar2 default hr_api.g_varchar2
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
645: ,p_attribute18 in varchar2 default hr_api.g_varchar2
646: ,p_attribute19 in varchar2 default hr_api.g_varchar2
647: ,p_attribute20 in varchar2 default hr_api.g_varchar2
648: ,p_enrollment_date in date default hr_api.g_date
649: ) is
650: --
651: l_rec ota_cre_shd.g_rec_type;
644: ,p_attribute17 in varchar2 default hr_api.g_varchar2
645: ,p_attribute18 in varchar2 default hr_api.g_varchar2
646: ,p_attribute19 in varchar2 default hr_api.g_varchar2
647: ,p_attribute20 in varchar2 default hr_api.g_varchar2
648: ,p_enrollment_date in date default hr_api.g_date
649: ) is
650: --
651: l_rec ota_cre_shd.g_rec_type;
652: l_proc varchar2(72) := g_package||'upd';