103: --
104: hr_utility.set_location(' Leaving:'||l_proc, 10);
105: --
106: Exception
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: ota_cme_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
107: When hr_api.check_integrity_violated Then
108: -- A check constraint has been violated
109: --
110: ota_cme_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: ota_cme_shd.constraint_error
108: -- A check constraint has been violated
109: --
110: ota_cme_shd.constraint_error
111: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: ota_cme_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
112: When hr_api.parent_integrity_violated Then
113: -- Parent integrity has been violated
114: --
115: ota_cme_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: ota_cme_shd.constraint_error
113: -- Parent integrity has been violated
114: --
115: ota_cme_shd.constraint_error
116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: ota_cme_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: ota_cme_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;
125: End update_dml;
326: );
327: --
328: exception
329: --
330: when hr_api.cannot_find_prog_unit then
331: --
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'OTA_CERT_MBR_ENROLLMENTS'
334: ,p_hook_type => 'AU');
328: exception
329: --
330: when hr_api.cannot_find_prog_unit then
331: --
332: hr_api.cannot_find_prog_unit_error
333: (p_module_name => 'OTA_CERT_MBR_ENROLLMENTS'
334: ,p_hook_type => 'AU');
335: --
336: end;
391: -- p_rec plsql record structure
392: -- to see if a system default is being used. If a system default
393: -- is being used then we must set to the 'current' argument value.
394: --
395: If (p_rec.cert_prd_enrollment_id = hr_api.g_number) then
396: p_rec.cert_prd_enrollment_id :=
397: ota_cme_shd.g_old_rec.cert_prd_enrollment_id;
398: End If;
399: If (p_rec.cert_member_id = hr_api.g_number) then
395: If (p_rec.cert_prd_enrollment_id = hr_api.g_number) then
396: p_rec.cert_prd_enrollment_id :=
397: ota_cme_shd.g_old_rec.cert_prd_enrollment_id;
398: End If;
399: If (p_rec.cert_member_id = hr_api.g_number) then
400: p_rec.cert_member_id :=
401: ota_cme_shd.g_old_rec.cert_member_id;
402: End If;
403: If (p_rec.member_status_code = hr_api.g_varchar2) then
399: If (p_rec.cert_member_id = hr_api.g_number) then
400: p_rec.cert_member_id :=
401: ota_cme_shd.g_old_rec.cert_member_id;
402: End If;
403: If (p_rec.member_status_code = hr_api.g_varchar2) then
404: p_rec.member_status_code :=
405: ota_cme_shd.g_old_rec.member_status_code;
406: End If;
407: If (p_rec.completion_date = hr_api.g_date) then
403: If (p_rec.member_status_code = hr_api.g_varchar2) then
404: p_rec.member_status_code :=
405: ota_cme_shd.g_old_rec.member_status_code;
406: End If;
407: If (p_rec.completion_date = hr_api.g_date) then
408: p_rec.completion_date :=
409: ota_cme_shd.g_old_rec.completion_date;
410: End If;
411: If (p_rec.business_group_id = hr_api.g_number) then
407: If (p_rec.completion_date = hr_api.g_date) then
408: p_rec.completion_date :=
409: ota_cme_shd.g_old_rec.completion_date;
410: End If;
411: If (p_rec.business_group_id = hr_api.g_number) then
412: p_rec.business_group_id :=
413: ota_cme_shd.g_old_rec.business_group_id;
414: End If;
415: If (p_rec.attribute_category = hr_api.g_varchar2) then
411: If (p_rec.business_group_id = hr_api.g_number) then
412: p_rec.business_group_id :=
413: ota_cme_shd.g_old_rec.business_group_id;
414: End If;
415: If (p_rec.attribute_category = hr_api.g_varchar2) then
416: p_rec.attribute_category :=
417: ota_cme_shd.g_old_rec.attribute_category;
418: End If;
419: If (p_rec.attribute1 = hr_api.g_varchar2) then
415: If (p_rec.attribute_category = hr_api.g_varchar2) then
416: p_rec.attribute_category :=
417: ota_cme_shd.g_old_rec.attribute_category;
418: End If;
419: If (p_rec.attribute1 = hr_api.g_varchar2) then
420: p_rec.attribute1 :=
421: ota_cme_shd.g_old_rec.attribute1;
422: End If;
423: If (p_rec.attribute2 = hr_api.g_varchar2) then
419: If (p_rec.attribute1 = hr_api.g_varchar2) then
420: p_rec.attribute1 :=
421: ota_cme_shd.g_old_rec.attribute1;
422: End If;
423: If (p_rec.attribute2 = hr_api.g_varchar2) then
424: p_rec.attribute2 :=
425: ota_cme_shd.g_old_rec.attribute2;
426: End If;
427: If (p_rec.attribute3 = hr_api.g_varchar2) then
423: If (p_rec.attribute2 = hr_api.g_varchar2) then
424: p_rec.attribute2 :=
425: ota_cme_shd.g_old_rec.attribute2;
426: End If;
427: If (p_rec.attribute3 = hr_api.g_varchar2) then
428: p_rec.attribute3 :=
429: ota_cme_shd.g_old_rec.attribute3;
430: End If;
431: If (p_rec.attribute4 = hr_api.g_varchar2) then
427: If (p_rec.attribute3 = hr_api.g_varchar2) then
428: p_rec.attribute3 :=
429: ota_cme_shd.g_old_rec.attribute3;
430: End If;
431: If (p_rec.attribute4 = hr_api.g_varchar2) then
432: p_rec.attribute4 :=
433: ota_cme_shd.g_old_rec.attribute4;
434: End If;
435: If (p_rec.attribute5 = hr_api.g_varchar2) then
431: If (p_rec.attribute4 = hr_api.g_varchar2) then
432: p_rec.attribute4 :=
433: ota_cme_shd.g_old_rec.attribute4;
434: End If;
435: If (p_rec.attribute5 = hr_api.g_varchar2) then
436: p_rec.attribute5 :=
437: ota_cme_shd.g_old_rec.attribute5;
438: End If;
439: If (p_rec.attribute6 = hr_api.g_varchar2) then
435: If (p_rec.attribute5 = hr_api.g_varchar2) then
436: p_rec.attribute5 :=
437: ota_cme_shd.g_old_rec.attribute5;
438: End If;
439: If (p_rec.attribute6 = hr_api.g_varchar2) then
440: p_rec.attribute6 :=
441: ota_cme_shd.g_old_rec.attribute6;
442: End If;
443: If (p_rec.attribute7 = hr_api.g_varchar2) then
439: If (p_rec.attribute6 = hr_api.g_varchar2) then
440: p_rec.attribute6 :=
441: ota_cme_shd.g_old_rec.attribute6;
442: End If;
443: If (p_rec.attribute7 = hr_api.g_varchar2) then
444: p_rec.attribute7 :=
445: ota_cme_shd.g_old_rec.attribute7;
446: End If;
447: If (p_rec.attribute8 = hr_api.g_varchar2) then
443: If (p_rec.attribute7 = hr_api.g_varchar2) then
444: p_rec.attribute7 :=
445: ota_cme_shd.g_old_rec.attribute7;
446: End If;
447: If (p_rec.attribute8 = hr_api.g_varchar2) then
448: p_rec.attribute8 :=
449: ota_cme_shd.g_old_rec.attribute8;
450: End If;
451: If (p_rec.attribute9 = hr_api.g_varchar2) then
447: If (p_rec.attribute8 = hr_api.g_varchar2) then
448: p_rec.attribute8 :=
449: ota_cme_shd.g_old_rec.attribute8;
450: End If;
451: If (p_rec.attribute9 = hr_api.g_varchar2) then
452: p_rec.attribute9 :=
453: ota_cme_shd.g_old_rec.attribute9;
454: End If;
455: If (p_rec.attribute10 = hr_api.g_varchar2) then
451: If (p_rec.attribute9 = hr_api.g_varchar2) then
452: p_rec.attribute9 :=
453: ota_cme_shd.g_old_rec.attribute9;
454: End If;
455: If (p_rec.attribute10 = hr_api.g_varchar2) then
456: p_rec.attribute10 :=
457: ota_cme_shd.g_old_rec.attribute10;
458: End If;
459: If (p_rec.attribute11 = hr_api.g_varchar2) then
455: If (p_rec.attribute10 = hr_api.g_varchar2) then
456: p_rec.attribute10 :=
457: ota_cme_shd.g_old_rec.attribute10;
458: End If;
459: If (p_rec.attribute11 = hr_api.g_varchar2) then
460: p_rec.attribute11 :=
461: ota_cme_shd.g_old_rec.attribute11;
462: End If;
463: If (p_rec.attribute12 = hr_api.g_varchar2) then
459: If (p_rec.attribute11 = hr_api.g_varchar2) then
460: p_rec.attribute11 :=
461: ota_cme_shd.g_old_rec.attribute11;
462: End If;
463: If (p_rec.attribute12 = hr_api.g_varchar2) then
464: p_rec.attribute12 :=
465: ota_cme_shd.g_old_rec.attribute12;
466: End If;
467: If (p_rec.attribute13 = hr_api.g_varchar2) then
463: If (p_rec.attribute12 = hr_api.g_varchar2) then
464: p_rec.attribute12 :=
465: ota_cme_shd.g_old_rec.attribute12;
466: End If;
467: If (p_rec.attribute13 = hr_api.g_varchar2) then
468: p_rec.attribute13 :=
469: ota_cme_shd.g_old_rec.attribute13;
470: End If;
471: If (p_rec.attribute14 = hr_api.g_varchar2) then
467: If (p_rec.attribute13 = hr_api.g_varchar2) then
468: p_rec.attribute13 :=
469: ota_cme_shd.g_old_rec.attribute13;
470: End If;
471: If (p_rec.attribute14 = hr_api.g_varchar2) then
472: p_rec.attribute14 :=
473: ota_cme_shd.g_old_rec.attribute14;
474: End If;
475: If (p_rec.attribute15 = hr_api.g_varchar2) then
471: If (p_rec.attribute14 = hr_api.g_varchar2) then
472: p_rec.attribute14 :=
473: ota_cme_shd.g_old_rec.attribute14;
474: End If;
475: If (p_rec.attribute15 = hr_api.g_varchar2) then
476: p_rec.attribute15 :=
477: ota_cme_shd.g_old_rec.attribute15;
478: End If;
479: If (p_rec.attribute16 = hr_api.g_varchar2) then
475: If (p_rec.attribute15 = hr_api.g_varchar2) then
476: p_rec.attribute15 :=
477: ota_cme_shd.g_old_rec.attribute15;
478: End If;
479: If (p_rec.attribute16 = hr_api.g_varchar2) then
480: p_rec.attribute16 :=
481: ota_cme_shd.g_old_rec.attribute16;
482: End If;
483: If (p_rec.attribute17 = hr_api.g_varchar2) then
479: If (p_rec.attribute16 = hr_api.g_varchar2) then
480: p_rec.attribute16 :=
481: ota_cme_shd.g_old_rec.attribute16;
482: End If;
483: If (p_rec.attribute17 = hr_api.g_varchar2) then
484: p_rec.attribute17 :=
485: ota_cme_shd.g_old_rec.attribute17;
486: End If;
487: If (p_rec.attribute18 = hr_api.g_varchar2) then
483: If (p_rec.attribute17 = hr_api.g_varchar2) then
484: p_rec.attribute17 :=
485: ota_cme_shd.g_old_rec.attribute17;
486: End If;
487: If (p_rec.attribute18 = hr_api.g_varchar2) then
488: p_rec.attribute18 :=
489: ota_cme_shd.g_old_rec.attribute18;
490: End If;
491: If (p_rec.attribute19 = hr_api.g_varchar2) then
487: If (p_rec.attribute18 = hr_api.g_varchar2) then
488: p_rec.attribute18 :=
489: ota_cme_shd.g_old_rec.attribute18;
490: End If;
491: If (p_rec.attribute19 = hr_api.g_varchar2) then
492: p_rec.attribute19 :=
493: ota_cme_shd.g_old_rec.attribute19;
494: End If;
495: If (p_rec.attribute20 = hr_api.g_varchar2) then
491: If (p_rec.attribute19 = hr_api.g_varchar2) then
492: p_rec.attribute19 :=
493: ota_cme_shd.g_old_rec.attribute19;
494: End If;
495: If (p_rec.attribute20 = hr_api.g_varchar2) then
496: p_rec.attribute20 :=
497: ota_cme_shd.g_old_rec.attribute20;
498: End If;
499: --
559: Procedure upd
560: (p_effective_date in date
561: ,p_cert_mbr_enrollment_id in number
562: ,p_object_version_number in out nocopy number
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
560: (p_effective_date in date
561: ,p_cert_mbr_enrollment_id in number
562: ,p_object_version_number in out nocopy number
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
561: ,p_cert_mbr_enrollment_id in number
562: ,p_object_version_number in out nocopy number
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
562: ,p_object_version_number in out nocopy number
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
563: ,p_cert_prd_enrollment_id in number default hr_api.g_number
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
564: ,p_cert_member_id in number default hr_api.g_number
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
565: ,p_member_status_code in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
566: ,p_completion_date in date default hr_api.g_date
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
567: ,p_business_group_id in number default hr_api.g_number
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
568: ,p_attribute_category in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
569: ,p_attribute1 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
570: ,p_attribute2 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
571: ,p_attribute3 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
572: ,p_attribute4 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
573: ,p_attribute5 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
574: ,p_attribute6 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
575: ,p_attribute7 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
576: ,p_attribute8 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
577: ,p_attribute9 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
578: ,p_attribute10 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
579: ,p_attribute11 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
580: ,p_attribute12 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
581: ,p_attribute13 in varchar2 default hr_api.g_varchar2
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is
582: ,p_attribute14 in varchar2 default hr_api.g_varchar2
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is
590: --
583: ,p_attribute15 in varchar2 default hr_api.g_varchar2
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is
590: --
591: l_rec ota_cme_shd.g_rec_type;
584: ,p_attribute16 in varchar2 default hr_api.g_varchar2
585: ,p_attribute17 in varchar2 default hr_api.g_varchar2
586: ,p_attribute18 in varchar2 default hr_api.g_varchar2
587: ,p_attribute19 in varchar2 default hr_api.g_varchar2
588: ,p_attribute20 in varchar2 default hr_api.g_varchar2
589: ) is
590: --
591: l_rec ota_cme_shd.g_rec_type;
592: l_proc varchar2(72) := g_package||'upd';