226: ,p_attribute29 => p_attribute29
227: ,p_attribute30 => p_attribute30
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'CREATE_APPRAISAL_PERIOD'
233: ,p_hook_type => 'BP'
234: );
227: ,p_attribute30 => p_attribute30
228: );
229: exception
230: when hr_api.cannot_find_prog_unit then
231: hr_api.cannot_find_prog_unit_error
232: (p_module_name => 'CREATE_APPRAISAL_PERIOD'
233: ,p_hook_type => 'BP'
234: );
235: end;
344: ,p_appraisal_period_id => l_appraisal_period_id
345: ,p_object_version_number => l_object_version_number
346: );
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'CREATE_APPRAISAL_PERIOD'
351: ,p_hook_type => 'AP'
352: );
345: ,p_object_version_number => l_object_version_number
346: );
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'CREATE_APPRAISAL_PERIOD'
351: ,p_hook_type => 'AP'
352: );
353: end;
363: --
364: -- When in validation only mode raise the Validate_Enabled exception
365: --
366: if p_validate then
367: raise hr_api.validate_enabled;
368: end if;
369: --
370: -- Set all IN OUT and OUT parameters with out values
371: --
395:
396: END IF;
397:
398: exception
399: when hr_api.validate_enabled then
400: --
401: -- As the Validate_Enabled exception has been raised
402: -- we must rollback to the savepoint
403: --
433: (p_validate in boolean default false
434: ,p_effective_date in date
435: ,p_appraisal_period_id in number
436: ,p_object_version_number in out nocopy number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ,p_task_start_date in date default hr_api.g_date
440: ,p_task_end_date in date default hr_api.g_date
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
434: ,p_effective_date in date
435: ,p_appraisal_period_id in number
436: ,p_object_version_number in out nocopy number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ,p_task_start_date in date default hr_api.g_date
440: ,p_task_end_date in date default hr_api.g_date
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
435: ,p_appraisal_period_id in number
436: ,p_object_version_number in out nocopy number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ,p_task_start_date in date default hr_api.g_date
440: ,p_task_end_date in date default hr_api.g_date
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
436: ,p_object_version_number in out nocopy number
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ,p_task_start_date in date default hr_api.g_date
440: ,p_task_end_date in date default hr_api.g_date
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
437: ,p_start_date in date default hr_api.g_date
438: ,p_end_date in date default hr_api.g_date
439: ,p_task_start_date in date default hr_api.g_date
440: ,p_task_end_date in date default hr_api.g_date
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
438: ,p_end_date in date default hr_api.g_date
439: ,p_task_start_date in date default hr_api.g_date
440: ,p_task_end_date in date default hr_api.g_date
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
439: ,p_task_start_date in date default hr_api.g_date
440: ,p_task_end_date in date default hr_api.g_date
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
440: ,p_task_end_date in date default hr_api.g_date
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
441: ,p_initiator_code in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
442: ,p_appraisal_system_type in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
443: ,p_appraisal_type in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
444: ,p_appraisal_assmt_status in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
445: ,p_auto_conc_process in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
446: ,p_days_before_task_st_dt in number default hr_api.g_number
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
447: ,p_participation_type in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
448: ,p_questionnaire_template_id in number default hr_api.g_number
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
449: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
450: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
451: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
452: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
453: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
454: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
455: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
456: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
457: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
458: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
459: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
460: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
461: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
462: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
463: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
464: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
465: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
466: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
467: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
468: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
476: ,p_attribute27 in varchar2 default hr_api.g_varchar2
469: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
476: ,p_attribute27 in varchar2 default hr_api.g_varchar2
477: ,p_attribute28 in varchar2 default hr_api.g_varchar2
470: ,p_attribute21 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
476: ,p_attribute27 in varchar2 default hr_api.g_varchar2
477: ,p_attribute28 in varchar2 default hr_api.g_varchar2
478: ,p_attribute29 in varchar2 default hr_api.g_varchar2
471: ,p_attribute22 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
476: ,p_attribute27 in varchar2 default hr_api.g_varchar2
477: ,p_attribute28 in varchar2 default hr_api.g_varchar2
478: ,p_attribute29 in varchar2 default hr_api.g_varchar2
479: ,p_attribute30 in varchar2 default hr_api.g_varchar2
472: ,p_attribute23 in varchar2 default hr_api.g_varchar2
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
476: ,p_attribute27 in varchar2 default hr_api.g_varchar2
477: ,p_attribute28 in varchar2 default hr_api.g_varchar2
478: ,p_attribute29 in varchar2 default hr_api.g_varchar2
479: ,p_attribute30 in varchar2 default hr_api.g_varchar2
480: ) is
473: ,p_attribute24 in varchar2 default hr_api.g_varchar2
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
476: ,p_attribute27 in varchar2 default hr_api.g_varchar2
477: ,p_attribute28 in varchar2 default hr_api.g_varchar2
478: ,p_attribute29 in varchar2 default hr_api.g_varchar2
479: ,p_attribute30 in varchar2 default hr_api.g_varchar2
480: ) is
481: --
474: ,p_attribute25 in varchar2 default hr_api.g_varchar2
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
476: ,p_attribute27 in varchar2 default hr_api.g_varchar2
477: ,p_attribute28 in varchar2 default hr_api.g_varchar2
478: ,p_attribute29 in varchar2 default hr_api.g_varchar2
479: ,p_attribute30 in varchar2 default hr_api.g_varchar2
480: ) is
481: --
482: -- Declare cursors and local variables
475: ,p_attribute26 in varchar2 default hr_api.g_varchar2
476: ,p_attribute27 in varchar2 default hr_api.g_varchar2
477: ,p_attribute28 in varchar2 default hr_api.g_varchar2
478: ,p_attribute29 in varchar2 default hr_api.g_varchar2
479: ,p_attribute30 in varchar2 default hr_api.g_varchar2
480: ) is
481: --
482: -- Declare cursors and local variables
483: --
590: ,p_attribute29 => p_attribute29
591: ,p_attribute30 => p_attribute30
592: );
593: exception
594: when hr_api.cannot_find_prog_unit then
595: hr_api.cannot_find_prog_unit_error
596: (p_module_name => 'UPDATE_APPRAISAL_PERIOD'
597: ,p_hook_type => 'BP'
598: );
591: ,p_attribute30 => p_attribute30
592: );
593: exception
594: when hr_api.cannot_find_prog_unit then
595: hr_api.cannot_find_prog_unit_error
596: (p_module_name => 'UPDATE_APPRAISAL_PERIOD'
597: ,p_hook_type => 'BP'
598: );
599: end;
704: ,p_attribute29 => p_attribute29
705: ,p_attribute30 => p_attribute30
706: );
707: exception
708: when hr_api.cannot_find_prog_unit then
709: hr_api.cannot_find_prog_unit_error
710: (p_module_name => 'UPDATE_APPRAISAL_PERIOD'
711: ,p_hook_type => 'AP'
712: );
705: ,p_attribute30 => p_attribute30
706: );
707: exception
708: when hr_api.cannot_find_prog_unit then
709: hr_api.cannot_find_prog_unit_error
710: (p_module_name => 'UPDATE_APPRAISAL_PERIOD'
711: ,p_hook_type => 'AP'
712: );
713: end;
723: --
724: -- When in validation only mode raise the Validate_Enabled exception
725: --
726: if p_validate then
727: raise hr_api.validate_enabled;
728: end if;
729: --
730: -- Set all IN OUT and OUT parameters with out values
731: --
752:
753: END IF;
754:
755: exception
756: when hr_api.validate_enabled then
757: --
758: -- As the Validate_Enabled exception has been raised
759: -- we must rollback to the savepoint
760: --
830: (p_appraisal_period_id => p_appraisal_period_id
831: ,p_object_version_number => p_object_version_number
832: );
833: exception
834: when hr_api.cannot_find_prog_unit then
835: hr_api.cannot_find_prog_unit_error
836: (p_module_name => 'DELETE_APPRAISAL_PERIOD'
837: ,p_hook_type => 'BP'
838: );
831: ,p_object_version_number => p_object_version_number
832: );
833: exception
834: when hr_api.cannot_find_prog_unit then
835: hr_api.cannot_find_prog_unit_error
836: (p_module_name => 'DELETE_APPRAISAL_PERIOD'
837: ,p_hook_type => 'BP'
838: );
839: end;
856: (p_appraisal_period_id => p_appraisal_period_id
857: ,p_object_version_number => p_object_version_number
858: );
859: exception
860: when hr_api.cannot_find_prog_unit then
861: hr_api.cannot_find_prog_unit_error
862: (p_module_name => 'DELETE_APPRAISAL_PERIOD'
863: ,p_hook_type => 'AP'
864: );
857: ,p_object_version_number => p_object_version_number
858: );
859: exception
860: when hr_api.cannot_find_prog_unit then
861: hr_api.cannot_find_prog_unit_error
862: (p_module_name => 'DELETE_APPRAISAL_PERIOD'
863: ,p_hook_type => 'AP'
864: );
865: end;
868: --
869: -- When in validation only mode raise the Validate_Enabled exception
870: --
871: if p_validate then
872: raise hr_api.validate_enabled;
873: end if;
874:
875: --
876: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
889:
890: END IF;
891:
892: exception
893: when hr_api.validate_enabled then
894: --
895: -- As the Validate_Enabled exception has been raised
896: -- we must rollback to the savepoint
897: --