189: p_sharing_access_code => p_sharing_access_code
190:
191: );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'CREATE_OBJECTIVE'
196: ,p_hook_type => 'BP'
197: );
190:
191: );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'CREATE_OBJECTIVE'
196: ,p_hook_type => 'BP'
197: );
198: --
360: p_objective_id => l_objective_id,
361: p_object_version_number => l_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'CREATE_OBJECTIVE'
367: ,p_hook_type => 'AP'
368: );
361: p_object_version_number => l_object_version_number
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'CREATE_OBJECTIVE'
367: ,p_hook_type => 'AP'
368: );
369: --
373: --
374: -- When in validation only mode raise the Validate_Enabled exception
375: --
376: if p_validate then
377: raise hr_api.validate_enabled;
378: end if;
379: --
380: -- Set all output arguments
381: --
385: p_weighting_appraisal_warning := l_weighting_appraisal_warning;
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 11);
388: exception
389: when hr_api.validate_enabled then
390: --
391: -- As the Validate_Enabled exception has been raised
392: -- we must rollback to the savepoint
393: --
431: (p_validate in boolean default false,
432: p_effective_date in date,
433: p_objective_id in number,
434: p_object_version_number in out nocopy number,
435: p_name in varchar2 default hr_api.g_varchar2,
436: p_target_date in date default hr_api.g_date,
437: p_start_date in date default hr_api.g_date,
438: p_achievement_date in date default hr_api.g_date,
439: p_detail in varchar2 default hr_api.g_varchar2,
432: p_effective_date in date,
433: p_objective_id in number,
434: p_object_version_number in out nocopy number,
435: p_name in varchar2 default hr_api.g_varchar2,
436: p_target_date in date default hr_api.g_date,
437: p_start_date in date default hr_api.g_date,
438: p_achievement_date in date default hr_api.g_date,
439: p_detail in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
433: p_objective_id in number,
434: p_object_version_number in out nocopy number,
435: p_name in varchar2 default hr_api.g_varchar2,
436: p_target_date in date default hr_api.g_date,
437: p_start_date in date default hr_api.g_date,
438: p_achievement_date in date default hr_api.g_date,
439: p_detail in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
434: p_object_version_number in out nocopy number,
435: p_name in varchar2 default hr_api.g_varchar2,
436: p_target_date in date default hr_api.g_date,
437: p_start_date in date default hr_api.g_date,
438: p_achievement_date in date default hr_api.g_date,
439: p_detail in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
435: p_name in varchar2 default hr_api.g_varchar2,
436: p_target_date in date default hr_api.g_date,
437: p_start_date in date default hr_api.g_date,
438: p_achievement_date in date default hr_api.g_date,
439: p_detail in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
436: p_target_date in date default hr_api.g_date,
437: p_start_date in date default hr_api.g_date,
438: p_achievement_date in date default hr_api.g_date,
439: p_detail in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
437: p_start_date in date default hr_api.g_date,
438: p_achievement_date in date default hr_api.g_date,
439: p_detail in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
438: p_achievement_date in date default hr_api.g_date,
439: p_detail in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
439: p_detail in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
440: p_comments in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
441: p_success_criteria in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
442: p_attribute_category in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
443: p_attribute1 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
444: p_attribute2 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
445: p_attribute3 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
446: p_attribute4 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
447: p_attribute5 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
448: p_attribute6 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
449: p_attribute7 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
450: p_attribute8 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
451: p_attribute9 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
459: p_attribute17 in varchar2 default hr_api.g_varchar2,
452: p_attribute10 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
459: p_attribute17 in varchar2 default hr_api.g_varchar2,
460: p_attribute18 in varchar2 default hr_api.g_varchar2,
453: p_attribute11 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
459: p_attribute17 in varchar2 default hr_api.g_varchar2,
460: p_attribute18 in varchar2 default hr_api.g_varchar2,
461: p_attribute19 in varchar2 default hr_api.g_varchar2,
454: p_attribute12 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
459: p_attribute17 in varchar2 default hr_api.g_varchar2,
460: p_attribute18 in varchar2 default hr_api.g_varchar2,
461: p_attribute19 in varchar2 default hr_api.g_varchar2,
462: p_attribute20 in varchar2 default hr_api.g_varchar2,
455: p_attribute13 in varchar2 default hr_api.g_varchar2,
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
459: p_attribute17 in varchar2 default hr_api.g_varchar2,
460: p_attribute18 in varchar2 default hr_api.g_varchar2,
461: p_attribute19 in varchar2 default hr_api.g_varchar2,
462: p_attribute20 in varchar2 default hr_api.g_varchar2,
463:
456: p_attribute14 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
459: p_attribute17 in varchar2 default hr_api.g_varchar2,
460: p_attribute18 in varchar2 default hr_api.g_varchar2,
461: p_attribute19 in varchar2 default hr_api.g_varchar2,
462: p_attribute20 in varchar2 default hr_api.g_varchar2,
463:
464: p_attribute21 in varchar2 default hr_api.g_varchar2,
457: p_attribute15 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
459: p_attribute17 in varchar2 default hr_api.g_varchar2,
460: p_attribute18 in varchar2 default hr_api.g_varchar2,
461: p_attribute19 in varchar2 default hr_api.g_varchar2,
462: p_attribute20 in varchar2 default hr_api.g_varchar2,
463:
464: p_attribute21 in varchar2 default hr_api.g_varchar2,
465: p_attribute22 in varchar2 default hr_api.g_varchar2,
458: p_attribute16 in varchar2 default hr_api.g_varchar2,
459: p_attribute17 in varchar2 default hr_api.g_varchar2,
460: p_attribute18 in varchar2 default hr_api.g_varchar2,
461: p_attribute19 in varchar2 default hr_api.g_varchar2,
462: p_attribute20 in varchar2 default hr_api.g_varchar2,
463:
464: p_attribute21 in varchar2 default hr_api.g_varchar2,
465: p_attribute22 in varchar2 default hr_api.g_varchar2,
466: p_attribute23 in varchar2 default hr_api.g_varchar2,
460: p_attribute18 in varchar2 default hr_api.g_varchar2,
461: p_attribute19 in varchar2 default hr_api.g_varchar2,
462: p_attribute20 in varchar2 default hr_api.g_varchar2,
463:
464: p_attribute21 in varchar2 default hr_api.g_varchar2,
465: p_attribute22 in varchar2 default hr_api.g_varchar2,
466: p_attribute23 in varchar2 default hr_api.g_varchar2,
467: p_attribute24 in varchar2 default hr_api.g_varchar2,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
461: p_attribute19 in varchar2 default hr_api.g_varchar2,
462: p_attribute20 in varchar2 default hr_api.g_varchar2,
463:
464: p_attribute21 in varchar2 default hr_api.g_varchar2,
465: p_attribute22 in varchar2 default hr_api.g_varchar2,
466: p_attribute23 in varchar2 default hr_api.g_varchar2,
467: p_attribute24 in varchar2 default hr_api.g_varchar2,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
462: p_attribute20 in varchar2 default hr_api.g_varchar2,
463:
464: p_attribute21 in varchar2 default hr_api.g_varchar2,
465: p_attribute22 in varchar2 default hr_api.g_varchar2,
466: p_attribute23 in varchar2 default hr_api.g_varchar2,
467: p_attribute24 in varchar2 default hr_api.g_varchar2,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
470: p_attribute27 in varchar2 default hr_api.g_varchar2,
463:
464: p_attribute21 in varchar2 default hr_api.g_varchar2,
465: p_attribute22 in varchar2 default hr_api.g_varchar2,
466: p_attribute23 in varchar2 default hr_api.g_varchar2,
467: p_attribute24 in varchar2 default hr_api.g_varchar2,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
470: p_attribute27 in varchar2 default hr_api.g_varchar2,
471: p_attribute28 in varchar2 default hr_api.g_varchar2,
464: p_attribute21 in varchar2 default hr_api.g_varchar2,
465: p_attribute22 in varchar2 default hr_api.g_varchar2,
466: p_attribute23 in varchar2 default hr_api.g_varchar2,
467: p_attribute24 in varchar2 default hr_api.g_varchar2,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
470: p_attribute27 in varchar2 default hr_api.g_varchar2,
471: p_attribute28 in varchar2 default hr_api.g_varchar2,
472: p_attribute29 in varchar2 default hr_api.g_varchar2,
465: p_attribute22 in varchar2 default hr_api.g_varchar2,
466: p_attribute23 in varchar2 default hr_api.g_varchar2,
467: p_attribute24 in varchar2 default hr_api.g_varchar2,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
470: p_attribute27 in varchar2 default hr_api.g_varchar2,
471: p_attribute28 in varchar2 default hr_api.g_varchar2,
472: p_attribute29 in varchar2 default hr_api.g_varchar2,
473: p_attribute30 in varchar2 default hr_api.g_varchar2,
466: p_attribute23 in varchar2 default hr_api.g_varchar2,
467: p_attribute24 in varchar2 default hr_api.g_varchar2,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
470: p_attribute27 in varchar2 default hr_api.g_varchar2,
471: p_attribute28 in varchar2 default hr_api.g_varchar2,
472: p_attribute29 in varchar2 default hr_api.g_varchar2,
473: p_attribute30 in varchar2 default hr_api.g_varchar2,
474:
467: p_attribute24 in varchar2 default hr_api.g_varchar2,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
470: p_attribute27 in varchar2 default hr_api.g_varchar2,
471: p_attribute28 in varchar2 default hr_api.g_varchar2,
472: p_attribute29 in varchar2 default hr_api.g_varchar2,
473: p_attribute30 in varchar2 default hr_api.g_varchar2,
474:
475: p_scorecard_id in number default hr_api.g_number,
468: p_attribute25 in varchar2 default hr_api.g_varchar2,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
470: p_attribute27 in varchar2 default hr_api.g_varchar2,
471: p_attribute28 in varchar2 default hr_api.g_varchar2,
472: p_attribute29 in varchar2 default hr_api.g_varchar2,
473: p_attribute30 in varchar2 default hr_api.g_varchar2,
474:
475: p_scorecard_id in number default hr_api.g_number,
476: p_copied_from_library_id in number default hr_api.g_number,
469: p_attribute26 in varchar2 default hr_api.g_varchar2,
470: p_attribute27 in varchar2 default hr_api.g_varchar2,
471: p_attribute28 in varchar2 default hr_api.g_varchar2,
472: p_attribute29 in varchar2 default hr_api.g_varchar2,
473: p_attribute30 in varchar2 default hr_api.g_varchar2,
474:
475: p_scorecard_id in number default hr_api.g_number,
476: p_copied_from_library_id in number default hr_api.g_number,
477: p_copied_from_objective_id in number default hr_api.g_number,
471: p_attribute28 in varchar2 default hr_api.g_varchar2,
472: p_attribute29 in varchar2 default hr_api.g_varchar2,
473: p_attribute30 in varchar2 default hr_api.g_varchar2,
474:
475: p_scorecard_id in number default hr_api.g_number,
476: p_copied_from_library_id in number default hr_api.g_number,
477: p_copied_from_objective_id in number default hr_api.g_number,
478: p_aligned_with_objective_id in number default hr_api.g_number,
479:
472: p_attribute29 in varchar2 default hr_api.g_varchar2,
473: p_attribute30 in varchar2 default hr_api.g_varchar2,
474:
475: p_scorecard_id in number default hr_api.g_number,
476: p_copied_from_library_id in number default hr_api.g_number,
477: p_copied_from_objective_id in number default hr_api.g_number,
478: p_aligned_with_objective_id in number default hr_api.g_number,
479:
480: p_next_review_date in date default hr_api.g_date,
473: p_attribute30 in varchar2 default hr_api.g_varchar2,
474:
475: p_scorecard_id in number default hr_api.g_number,
476: p_copied_from_library_id in number default hr_api.g_number,
477: p_copied_from_objective_id in number default hr_api.g_number,
478: p_aligned_with_objective_id in number default hr_api.g_number,
479:
480: p_next_review_date in date default hr_api.g_date,
481: p_group_code in varchar2 default hr_api.g_varchar2,
474:
475: p_scorecard_id in number default hr_api.g_number,
476: p_copied_from_library_id in number default hr_api.g_number,
477: p_copied_from_objective_id in number default hr_api.g_number,
478: p_aligned_with_objective_id in number default hr_api.g_number,
479:
480: p_next_review_date in date default hr_api.g_date,
481: p_group_code in varchar2 default hr_api.g_varchar2,
482: p_priority_code in varchar2 default hr_api.g_varchar2,
476: p_copied_from_library_id in number default hr_api.g_number,
477: p_copied_from_objective_id in number default hr_api.g_number,
478: p_aligned_with_objective_id in number default hr_api.g_number,
479:
480: p_next_review_date in date default hr_api.g_date,
481: p_group_code in varchar2 default hr_api.g_varchar2,
482: p_priority_code in varchar2 default hr_api.g_varchar2,
483: p_appraise_flag in varchar2 default hr_api.g_varchar2,
484: p_verified_flag in varchar2 default hr_api.g_varchar2,
477: p_copied_from_objective_id in number default hr_api.g_number,
478: p_aligned_with_objective_id in number default hr_api.g_number,
479:
480: p_next_review_date in date default hr_api.g_date,
481: p_group_code in varchar2 default hr_api.g_varchar2,
482: p_priority_code in varchar2 default hr_api.g_varchar2,
483: p_appraise_flag in varchar2 default hr_api.g_varchar2,
484: p_verified_flag in varchar2 default hr_api.g_varchar2,
485:
478: p_aligned_with_objective_id in number default hr_api.g_number,
479:
480: p_next_review_date in date default hr_api.g_date,
481: p_group_code in varchar2 default hr_api.g_varchar2,
482: p_priority_code in varchar2 default hr_api.g_varchar2,
483: p_appraise_flag in varchar2 default hr_api.g_varchar2,
484: p_verified_flag in varchar2 default hr_api.g_varchar2,
485:
486: p_target_value in number default hr_api.g_number,
479:
480: p_next_review_date in date default hr_api.g_date,
481: p_group_code in varchar2 default hr_api.g_varchar2,
482: p_priority_code in varchar2 default hr_api.g_varchar2,
483: p_appraise_flag in varchar2 default hr_api.g_varchar2,
484: p_verified_flag in varchar2 default hr_api.g_varchar2,
485:
486: p_target_value in number default hr_api.g_number,
487: p_actual_value in number default hr_api.g_number,
480: p_next_review_date in date default hr_api.g_date,
481: p_group_code in varchar2 default hr_api.g_varchar2,
482: p_priority_code in varchar2 default hr_api.g_varchar2,
483: p_appraise_flag in varchar2 default hr_api.g_varchar2,
484: p_verified_flag in varchar2 default hr_api.g_varchar2,
485:
486: p_target_value in number default hr_api.g_number,
487: p_actual_value in number default hr_api.g_number,
488: p_weighting_percent in number default hr_api.g_number,
482: p_priority_code in varchar2 default hr_api.g_varchar2,
483: p_appraise_flag in varchar2 default hr_api.g_varchar2,
484: p_verified_flag in varchar2 default hr_api.g_varchar2,
485:
486: p_target_value in number default hr_api.g_number,
487: p_actual_value in number default hr_api.g_number,
488: p_weighting_percent in number default hr_api.g_number,
489: p_complete_percent in number default hr_api.g_number,
490: p_uom_code in varchar2 default hr_api.g_varchar2,
483: p_appraise_flag in varchar2 default hr_api.g_varchar2,
484: p_verified_flag in varchar2 default hr_api.g_varchar2,
485:
486: p_target_value in number default hr_api.g_number,
487: p_actual_value in number default hr_api.g_number,
488: p_weighting_percent in number default hr_api.g_number,
489: p_complete_percent in number default hr_api.g_number,
490: p_uom_code in varchar2 default hr_api.g_varchar2,
491:
484: p_verified_flag in varchar2 default hr_api.g_varchar2,
485:
486: p_target_value in number default hr_api.g_number,
487: p_actual_value in number default hr_api.g_number,
488: p_weighting_percent in number default hr_api.g_number,
489: p_complete_percent in number default hr_api.g_number,
490: p_uom_code in varchar2 default hr_api.g_varchar2,
491:
492: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
485:
486: p_target_value in number default hr_api.g_number,
487: p_actual_value in number default hr_api.g_number,
488: p_weighting_percent in number default hr_api.g_number,
489: p_complete_percent in number default hr_api.g_number,
490: p_uom_code in varchar2 default hr_api.g_varchar2,
491:
492: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
493: p_measure_name in varchar2 default hr_api.g_varchar2,
486: p_target_value in number default hr_api.g_number,
487: p_actual_value in number default hr_api.g_number,
488: p_weighting_percent in number default hr_api.g_number,
489: p_complete_percent in number default hr_api.g_number,
490: p_uom_code in varchar2 default hr_api.g_varchar2,
491:
492: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
493: p_measure_name in varchar2 default hr_api.g_varchar2,
494: p_measure_type_code in varchar2 default hr_api.g_varchar2,
488: p_weighting_percent in number default hr_api.g_number,
489: p_complete_percent in number default hr_api.g_number,
490: p_uom_code in varchar2 default hr_api.g_varchar2,
491:
492: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
493: p_measure_name in varchar2 default hr_api.g_varchar2,
494: p_measure_type_code in varchar2 default hr_api.g_varchar2,
495: p_measure_comments in varchar2 default hr_api.g_varchar2,
496: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
489: p_complete_percent in number default hr_api.g_number,
490: p_uom_code in varchar2 default hr_api.g_varchar2,
491:
492: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
493: p_measure_name in varchar2 default hr_api.g_varchar2,
494: p_measure_type_code in varchar2 default hr_api.g_varchar2,
495: p_measure_comments in varchar2 default hr_api.g_varchar2,
496: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
497:
490: p_uom_code in varchar2 default hr_api.g_varchar2,
491:
492: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
493: p_measure_name in varchar2 default hr_api.g_varchar2,
494: p_measure_type_code in varchar2 default hr_api.g_varchar2,
495: p_measure_comments in varchar2 default hr_api.g_varchar2,
496: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
497:
498: p_weighting_over_100_warning out nocopy boolean,
491:
492: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
493: p_measure_name in varchar2 default hr_api.g_varchar2,
494: p_measure_type_code in varchar2 default hr_api.g_varchar2,
495: p_measure_comments in varchar2 default hr_api.g_varchar2,
496: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
497:
498: p_weighting_over_100_warning out nocopy boolean,
499: p_weighting_appraisal_warning out nocopy boolean,
492: p_measurement_style_code in varchar2 default hr_api.g_varchar2,
493: p_measure_name in varchar2 default hr_api.g_varchar2,
494: p_measure_type_code in varchar2 default hr_api.g_varchar2,
495: p_measure_comments in varchar2 default hr_api.g_varchar2,
496: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
497:
498: p_weighting_over_100_warning out nocopy boolean,
499: p_weighting_appraisal_warning out nocopy boolean,
500: p_appraisal_id in number default hr_api.g_number
496: p_sharing_access_code in varchar2 default hr_api.g_varchar2,
497:
498: p_weighting_over_100_warning out nocopy boolean,
499: p_weighting_appraisal_warning out nocopy boolean,
500: p_appraisal_id in number default hr_api.g_number
501:
502: ) is
503: --
504: -- Declare cursors and local variables
608:
609: );
610: --
611: exception
612: when hr_api.cannot_find_prog_unit then
613: hr_api.cannot_find_prog_unit_error
614: (p_module_name => 'UPDATE_OBJECTIVE'
615: ,p_hook_type => 'BP'
616: );
609: );
610: --
611: exception
612: when hr_api.cannot_find_prog_unit then
613: hr_api.cannot_find_prog_unit_error
614: (p_module_name => 'UPDATE_OBJECTIVE'
615: ,p_hook_type => 'BP'
616: );
617: --
778:
779: );
780: --
781: exception
782: when hr_api.cannot_find_prog_unit then
783: hr_api.cannot_find_prog_unit_error
784: (p_module_name => 'UPDATE_OBJECTIVE'
785: ,p_hook_type => 'AP'
786: );
779: );
780: --
781: exception
782: when hr_api.cannot_find_prog_unit then
783: hr_api.cannot_find_prog_unit_error
784: (p_module_name => 'UPDATE_OBJECTIVE'
785: ,p_hook_type => 'AP'
786: );
787: --
791: --
792: -- When in validation only mode raise the Validate_Enabled exception
793: --
794: if p_validate then
795: raise hr_api.validate_enabled;
796: end if;
797: --
798: -- Set all output arguments. l_object_version_number now has the new
799: -- object version number as the update was successful
805: hr_utility.set_location(' Leaving:'||l_proc, 11);
806: --
807: exception
808: --
809: when hr_api.validate_enabled then
810: --
811: -- As the Validate_Enabled exception has been raised
812: -- we must rollback to the savepoint
813: --
882: p_object_version_number => p_object_version_number
883: );
884:
885: exception
886: when hr_api.cannot_find_prog_unit then
887: hr_api.cannot_find_prog_unit_error
888: (p_module_name => 'DELETE_OBJECTIVE',
889: p_hook_type => 'BP'
890: );
883: );
884:
885: exception
886: when hr_api.cannot_find_prog_unit then
887: hr_api.cannot_find_prog_unit_error
888: (p_module_name => 'DELETE_OBJECTIVE',
889: p_hook_type => 'BP'
890: );
891: end;
947: (p_objective_id => p_objective_id,
948: p_object_version_number => p_object_version_number
949: );
950: exception
951: when hr_api.cannot_find_prog_unit then
952: hr_api.cannot_find_prog_unit_error
953: (p_module_name => 'DELETE_OBJECTIVE',
954: p_hook_type => 'AP'
955: );
948: p_object_version_number => p_object_version_number
949: );
950: exception
951: when hr_api.cannot_find_prog_unit then
952: hr_api.cannot_find_prog_unit_error
953: (p_module_name => 'DELETE_OBJECTIVE',
954: p_hook_type => 'AP'
955: );
956: end;
959: --
960: -- When in validation only mode raise the Validate_Enabled exception
961: --
962: if p_validate then
963: raise hr_api.validate_enabled;
964: end if;
965: --
966: hr_utility.set_location(' Leaving:'||l_proc, 11);
967: exception
964: end if;
965: --
966: hr_utility.set_location(' Leaving:'||l_proc, 11);
967: exception
968: when hr_api.validate_enabled then
969: --
970: -- As the Validate_Enabled exception has been raised
971: -- we must rollback to the savepoint
972: --