105: --
106: hr_utility.set_location(' Leaving:'||l_proc, 10);
107: --
108: Exception
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: --
112: ota_cpe_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
109: When hr_api.check_integrity_violated Then
110: -- A check constraint has been violated
111: --
112: ota_cpe_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: --
117: ota_cpe_shd.constraint_error
110: -- A check constraint has been violated
111: --
112: ota_cpe_shd.constraint_error
113: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: --
117: ota_cpe_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.parent_integrity_violated Then
115: -- Parent integrity has been violated
116: --
117: ota_cpe_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ota_cpe_shd.constraint_error
115: -- Parent integrity has been violated
116: --
117: ota_cpe_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ota_cpe_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.unique_integrity_violated Then
120: -- Unique integrity has been violated
121: --
122: ota_cpe_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When Others Then
125: --
126: Raise;
127: End update_dml;
336: );
337: --
338: exception
339: --
340: when hr_api.cannot_find_prog_unit then
341: --
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'OTA_CERT_PRD_ENROLLMENTS'
344: ,p_hook_type => 'AU');
338: exception
339: --
340: when hr_api.cannot_find_prog_unit then
341: --
342: hr_api.cannot_find_prog_unit_error
343: (p_module_name => 'OTA_CERT_PRD_ENROLLMENTS'
344: ,p_hook_type => 'AU');
345: --
346: end;
401: -- p_rec plsql record structure
402: -- to see if a system default is being used. If a system default
403: -- is being used then we must set to the 'current' argument value.
404: --
405: If (p_rec.cert_enrollment_id = hr_api.g_number) then
406: p_rec.cert_enrollment_id :=
407: ota_cpe_shd.g_old_rec.cert_enrollment_id;
408: End If;
409: If (p_rec.period_status_code = hr_api.g_varchar2) then
405: If (p_rec.cert_enrollment_id = hr_api.g_number) then
406: p_rec.cert_enrollment_id :=
407: ota_cpe_shd.g_old_rec.cert_enrollment_id;
408: End If;
409: If (p_rec.period_status_code = hr_api.g_varchar2) then
410: p_rec.period_status_code :=
411: ota_cpe_shd.g_old_rec.period_status_code;
412: End If;
413: If (p_rec.completion_date = hr_api.g_date) then
409: If (p_rec.period_status_code = hr_api.g_varchar2) then
410: p_rec.period_status_code :=
411: ota_cpe_shd.g_old_rec.period_status_code;
412: End If;
413: If (p_rec.completion_date = hr_api.g_date) then
414: p_rec.completion_date :=
415: ota_cpe_shd.g_old_rec.completion_date;
416: End If;
417: If (p_rec.cert_period_start_date = hr_api.g_date) then
413: If (p_rec.completion_date = hr_api.g_date) then
414: p_rec.completion_date :=
415: ota_cpe_shd.g_old_rec.completion_date;
416: End If;
417: If (p_rec.cert_period_start_date = hr_api.g_date) then
418: p_rec.cert_period_start_date :=
419: ota_cpe_shd.g_old_rec.cert_period_start_date;
420: End If;
421: If (p_rec.cert_period_end_date = hr_api.g_date) then
417: If (p_rec.cert_period_start_date = hr_api.g_date) then
418: p_rec.cert_period_start_date :=
419: ota_cpe_shd.g_old_rec.cert_period_start_date;
420: End If;
421: If (p_rec.cert_period_end_date = hr_api.g_date) then
422: p_rec.cert_period_end_date :=
423: ota_cpe_shd.g_old_rec.cert_period_end_date;
424: End If;
425: If (p_rec.business_group_id = hr_api.g_number) then
421: If (p_rec.cert_period_end_date = hr_api.g_date) then
422: p_rec.cert_period_end_date :=
423: ota_cpe_shd.g_old_rec.cert_period_end_date;
424: End If;
425: If (p_rec.business_group_id = hr_api.g_number) then
426: p_rec.business_group_id :=
427: ota_cpe_shd.g_old_rec.business_group_id;
428: End If;
429: If (p_rec.attribute_category = hr_api.g_varchar2) then
425: If (p_rec.business_group_id = hr_api.g_number) then
426: p_rec.business_group_id :=
427: ota_cpe_shd.g_old_rec.business_group_id;
428: End If;
429: If (p_rec.attribute_category = hr_api.g_varchar2) then
430: p_rec.attribute_category :=
431: ota_cpe_shd.g_old_rec.attribute_category;
432: End If;
433: If (p_rec.attribute1 = hr_api.g_varchar2) then
429: If (p_rec.attribute_category = hr_api.g_varchar2) then
430: p_rec.attribute_category :=
431: ota_cpe_shd.g_old_rec.attribute_category;
432: End If;
433: If (p_rec.attribute1 = hr_api.g_varchar2) then
434: p_rec.attribute1 :=
435: ota_cpe_shd.g_old_rec.attribute1;
436: End If;
437: If (p_rec.attribute2 = hr_api.g_varchar2) then
433: If (p_rec.attribute1 = hr_api.g_varchar2) then
434: p_rec.attribute1 :=
435: ota_cpe_shd.g_old_rec.attribute1;
436: End If;
437: If (p_rec.attribute2 = hr_api.g_varchar2) then
438: p_rec.attribute2 :=
439: ota_cpe_shd.g_old_rec.attribute2;
440: End If;
441: If (p_rec.attribute3 = hr_api.g_varchar2) then
437: If (p_rec.attribute2 = hr_api.g_varchar2) then
438: p_rec.attribute2 :=
439: ota_cpe_shd.g_old_rec.attribute2;
440: End If;
441: If (p_rec.attribute3 = hr_api.g_varchar2) then
442: p_rec.attribute3 :=
443: ota_cpe_shd.g_old_rec.attribute3;
444: End If;
445: If (p_rec.attribute4 = hr_api.g_varchar2) then
441: If (p_rec.attribute3 = hr_api.g_varchar2) then
442: p_rec.attribute3 :=
443: ota_cpe_shd.g_old_rec.attribute3;
444: End If;
445: If (p_rec.attribute4 = hr_api.g_varchar2) then
446: p_rec.attribute4 :=
447: ota_cpe_shd.g_old_rec.attribute4;
448: End If;
449: If (p_rec.attribute5 = hr_api.g_varchar2) then
445: If (p_rec.attribute4 = hr_api.g_varchar2) then
446: p_rec.attribute4 :=
447: ota_cpe_shd.g_old_rec.attribute4;
448: End If;
449: If (p_rec.attribute5 = hr_api.g_varchar2) then
450: p_rec.attribute5 :=
451: ota_cpe_shd.g_old_rec.attribute5;
452: End If;
453: If (p_rec.attribute6 = hr_api.g_varchar2) then
449: If (p_rec.attribute5 = hr_api.g_varchar2) then
450: p_rec.attribute5 :=
451: ota_cpe_shd.g_old_rec.attribute5;
452: End If;
453: If (p_rec.attribute6 = hr_api.g_varchar2) then
454: p_rec.attribute6 :=
455: ota_cpe_shd.g_old_rec.attribute6;
456: End If;
457: If (p_rec.attribute7 = hr_api.g_varchar2) then
453: If (p_rec.attribute6 = hr_api.g_varchar2) then
454: p_rec.attribute6 :=
455: ota_cpe_shd.g_old_rec.attribute6;
456: End If;
457: If (p_rec.attribute7 = hr_api.g_varchar2) then
458: p_rec.attribute7 :=
459: ota_cpe_shd.g_old_rec.attribute7;
460: End If;
461: If (p_rec.attribute8 = hr_api.g_varchar2) then
457: If (p_rec.attribute7 = hr_api.g_varchar2) then
458: p_rec.attribute7 :=
459: ota_cpe_shd.g_old_rec.attribute7;
460: End If;
461: If (p_rec.attribute8 = hr_api.g_varchar2) then
462: p_rec.attribute8 :=
463: ota_cpe_shd.g_old_rec.attribute8;
464: End If;
465: If (p_rec.attribute9 = hr_api.g_varchar2) then
461: If (p_rec.attribute8 = hr_api.g_varchar2) then
462: p_rec.attribute8 :=
463: ota_cpe_shd.g_old_rec.attribute8;
464: End If;
465: If (p_rec.attribute9 = hr_api.g_varchar2) then
466: p_rec.attribute9 :=
467: ota_cpe_shd.g_old_rec.attribute9;
468: End If;
469: If (p_rec.attribute10 = hr_api.g_varchar2) then
465: If (p_rec.attribute9 = hr_api.g_varchar2) then
466: p_rec.attribute9 :=
467: ota_cpe_shd.g_old_rec.attribute9;
468: End If;
469: If (p_rec.attribute10 = hr_api.g_varchar2) then
470: p_rec.attribute10 :=
471: ota_cpe_shd.g_old_rec.attribute10;
472: End If;
473: If (p_rec.attribute11 = hr_api.g_varchar2) then
469: If (p_rec.attribute10 = hr_api.g_varchar2) then
470: p_rec.attribute10 :=
471: ota_cpe_shd.g_old_rec.attribute10;
472: End If;
473: If (p_rec.attribute11 = hr_api.g_varchar2) then
474: p_rec.attribute11 :=
475: ota_cpe_shd.g_old_rec.attribute11;
476: End If;
477: If (p_rec.attribute12 = hr_api.g_varchar2) then
473: If (p_rec.attribute11 = hr_api.g_varchar2) then
474: p_rec.attribute11 :=
475: ota_cpe_shd.g_old_rec.attribute11;
476: End If;
477: If (p_rec.attribute12 = hr_api.g_varchar2) then
478: p_rec.attribute12 :=
479: ota_cpe_shd.g_old_rec.attribute12;
480: End If;
481: If (p_rec.attribute13 = hr_api.g_varchar2) then
477: If (p_rec.attribute12 = hr_api.g_varchar2) then
478: p_rec.attribute12 :=
479: ota_cpe_shd.g_old_rec.attribute12;
480: End If;
481: If (p_rec.attribute13 = hr_api.g_varchar2) then
482: p_rec.attribute13 :=
483: ota_cpe_shd.g_old_rec.attribute13;
484: End If;
485: If (p_rec.attribute14 = hr_api.g_varchar2) then
481: If (p_rec.attribute13 = hr_api.g_varchar2) then
482: p_rec.attribute13 :=
483: ota_cpe_shd.g_old_rec.attribute13;
484: End If;
485: If (p_rec.attribute14 = hr_api.g_varchar2) then
486: p_rec.attribute14 :=
487: ota_cpe_shd.g_old_rec.attribute14;
488: End If;
489: If (p_rec.attribute15 = hr_api.g_varchar2) then
485: If (p_rec.attribute14 = hr_api.g_varchar2) then
486: p_rec.attribute14 :=
487: ota_cpe_shd.g_old_rec.attribute14;
488: End If;
489: If (p_rec.attribute15 = hr_api.g_varchar2) then
490: p_rec.attribute15 :=
491: ota_cpe_shd.g_old_rec.attribute15;
492: End If;
493: If (p_rec.attribute16 = hr_api.g_varchar2) then
489: If (p_rec.attribute15 = hr_api.g_varchar2) then
490: p_rec.attribute15 :=
491: ota_cpe_shd.g_old_rec.attribute15;
492: End If;
493: If (p_rec.attribute16 = hr_api.g_varchar2) then
494: p_rec.attribute16 :=
495: ota_cpe_shd.g_old_rec.attribute16;
496: End If;
497: If (p_rec.attribute17 = hr_api.g_varchar2) then
493: If (p_rec.attribute16 = hr_api.g_varchar2) then
494: p_rec.attribute16 :=
495: ota_cpe_shd.g_old_rec.attribute16;
496: End If;
497: If (p_rec.attribute17 = hr_api.g_varchar2) then
498: p_rec.attribute17 :=
499: ota_cpe_shd.g_old_rec.attribute17;
500: End If;
501: If (p_rec.attribute18 = hr_api.g_varchar2) then
497: If (p_rec.attribute17 = hr_api.g_varchar2) then
498: p_rec.attribute17 :=
499: ota_cpe_shd.g_old_rec.attribute17;
500: End If;
501: If (p_rec.attribute18 = hr_api.g_varchar2) then
502: p_rec.attribute18 :=
503: ota_cpe_shd.g_old_rec.attribute18;
504: End If;
505: If (p_rec.attribute19 = hr_api.g_varchar2) then
501: If (p_rec.attribute18 = hr_api.g_varchar2) then
502: p_rec.attribute18 :=
503: ota_cpe_shd.g_old_rec.attribute18;
504: End If;
505: If (p_rec.attribute19 = hr_api.g_varchar2) then
506: p_rec.attribute19 :=
507: ota_cpe_shd.g_old_rec.attribute19;
508: End If;
509: If (p_rec.attribute20 = hr_api.g_varchar2) then
505: If (p_rec.attribute19 = hr_api.g_varchar2) then
506: p_rec.attribute19 :=
507: ota_cpe_shd.g_old_rec.attribute19;
508: End If;
509: If (p_rec.attribute20 = hr_api.g_varchar2) then
510: p_rec.attribute20 :=
511: ota_cpe_shd.g_old_rec.attribute20;
512: End If;
513: If (p_rec.expiration_date = hr_api.g_date) then
509: If (p_rec.attribute20 = hr_api.g_varchar2) then
510: p_rec.attribute20 :=
511: ota_cpe_shd.g_old_rec.attribute20;
512: End If;
513: If (p_rec.expiration_date = hr_api.g_date) then
514: p_rec.expiration_date :=
515: ota_cpe_shd.g_old_rec.expiration_date;
516: End If;
517: --
577: Procedure upd
578: (p_effective_date in date
579: ,p_cert_prd_enrollment_id in number
580: ,p_object_version_number in out nocopy number
581: ,p_cert_enrollment_id in number default hr_api.g_number
582: ,p_period_status_code in varchar2 default hr_api.g_varchar2
583: ,p_cert_period_start_date in date default hr_api.g_date
584: ,p_cert_period_end_date in date default hr_api.g_date
585: ,p_completion_date in date default hr_api.g_date
578: (p_effective_date in date
579: ,p_cert_prd_enrollment_id in number
580: ,p_object_version_number in out nocopy number
581: ,p_cert_enrollment_id in number default hr_api.g_number
582: ,p_period_status_code in varchar2 default hr_api.g_varchar2
583: ,p_cert_period_start_date in date default hr_api.g_date
584: ,p_cert_period_end_date in date default hr_api.g_date
585: ,p_completion_date in date default hr_api.g_date
586: ,p_business_group_id in number default hr_api.g_number
579: ,p_cert_prd_enrollment_id in number
580: ,p_object_version_number in out nocopy number
581: ,p_cert_enrollment_id in number default hr_api.g_number
582: ,p_period_status_code in varchar2 default hr_api.g_varchar2
583: ,p_cert_period_start_date in date default hr_api.g_date
584: ,p_cert_period_end_date in date default hr_api.g_date
585: ,p_completion_date in date default hr_api.g_date
586: ,p_business_group_id in number default hr_api.g_number
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
580: ,p_object_version_number in out nocopy number
581: ,p_cert_enrollment_id in number default hr_api.g_number
582: ,p_period_status_code in varchar2 default hr_api.g_varchar2
583: ,p_cert_period_start_date in date default hr_api.g_date
584: ,p_cert_period_end_date in date default hr_api.g_date
585: ,p_completion_date in date default hr_api.g_date
586: ,p_business_group_id in number default hr_api.g_number
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
581: ,p_cert_enrollment_id in number default hr_api.g_number
582: ,p_period_status_code in varchar2 default hr_api.g_varchar2
583: ,p_cert_period_start_date in date default hr_api.g_date
584: ,p_cert_period_end_date in date default hr_api.g_date
585: ,p_completion_date in date default hr_api.g_date
586: ,p_business_group_id in number default hr_api.g_number
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
582: ,p_period_status_code in varchar2 default hr_api.g_varchar2
583: ,p_cert_period_start_date in date default hr_api.g_date
584: ,p_cert_period_end_date in date default hr_api.g_date
585: ,p_completion_date in date default hr_api.g_date
586: ,p_business_group_id in number default hr_api.g_number
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
583: ,p_cert_period_start_date in date default hr_api.g_date
584: ,p_cert_period_end_date in date default hr_api.g_date
585: ,p_completion_date in date default hr_api.g_date
586: ,p_business_group_id in number default hr_api.g_number
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
584: ,p_cert_period_end_date in date default hr_api.g_date
585: ,p_completion_date in date default hr_api.g_date
586: ,p_business_group_id in number default hr_api.g_number
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
585: ,p_completion_date in date default hr_api.g_date
586: ,p_business_group_id in number default hr_api.g_number
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
586: ,p_business_group_id in number default hr_api.g_number
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
587: ,p_attribute_category in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
588: ,p_attribute1 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
589: ,p_attribute2 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
590: ,p_attribute3 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
591: ,p_attribute4 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
592: ,p_attribute5 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
593: ,p_attribute6 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
594: ,p_attribute7 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
595: ,p_attribute8 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
596: ,p_attribute9 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
597: ,p_attribute10 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
605: ,p_attribute18 in varchar2 default hr_api.g_varchar2
598: ,p_attribute11 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
605: ,p_attribute18 in varchar2 default hr_api.g_varchar2
606: ,p_attribute19 in varchar2 default hr_api.g_varchar2
599: ,p_attribute12 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
605: ,p_attribute18 in varchar2 default hr_api.g_varchar2
606: ,p_attribute19 in varchar2 default hr_api.g_varchar2
607: ,p_attribute20 in varchar2 default hr_api.g_varchar2
600: ,p_attribute13 in varchar2 default hr_api.g_varchar2
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
605: ,p_attribute18 in varchar2 default hr_api.g_varchar2
606: ,p_attribute19 in varchar2 default hr_api.g_varchar2
607: ,p_attribute20 in varchar2 default hr_api.g_varchar2
608: ,p_expiration_date in date default hr_api.g_date
601: ,p_attribute14 in varchar2 default hr_api.g_varchar2
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
605: ,p_attribute18 in varchar2 default hr_api.g_varchar2
606: ,p_attribute19 in varchar2 default hr_api.g_varchar2
607: ,p_attribute20 in varchar2 default hr_api.g_varchar2
608: ,p_expiration_date in date default hr_api.g_date
609: ) is
602: ,p_attribute15 in varchar2 default hr_api.g_varchar2
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
605: ,p_attribute18 in varchar2 default hr_api.g_varchar2
606: ,p_attribute19 in varchar2 default hr_api.g_varchar2
607: ,p_attribute20 in varchar2 default hr_api.g_varchar2
608: ,p_expiration_date in date default hr_api.g_date
609: ) is
610: --
603: ,p_attribute16 in varchar2 default hr_api.g_varchar2
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
605: ,p_attribute18 in varchar2 default hr_api.g_varchar2
606: ,p_attribute19 in varchar2 default hr_api.g_varchar2
607: ,p_attribute20 in varchar2 default hr_api.g_varchar2
608: ,p_expiration_date in date default hr_api.g_date
609: ) is
610: --
611: l_rec ota_cpe_shd.g_rec_type;
604: ,p_attribute17 in varchar2 default hr_api.g_varchar2
605: ,p_attribute18 in varchar2 default hr_api.g_varchar2
606: ,p_attribute19 in varchar2 default hr_api.g_varchar2
607: ,p_attribute20 in varchar2 default hr_api.g_varchar2
608: ,p_expiration_date in date default hr_api.g_date
609: ) is
610: --
611: l_rec ota_cpe_shd.g_rec_type;
612: l_proc varchar2(72) := g_package||'upd';