240: ,p_attribute30 => p_attribute30
241: );
242:
243: exception
244: when hr_api.cannot_find_prog_unit then
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'CREATE_LIBRARY_OBJECTIVE',
247: p_hook_type => 'BP'
248: );
241: );
242:
243: exception
244: when hr_api.cannot_find_prog_unit then
245: hr_api.cannot_find_prog_unit_error
246: (p_module_name => 'CREATE_LIBRARY_OBJECTIVE',
247: p_hook_type => 'BP'
248: );
249: end;
381: ,p_weighting_appraisal_warning => l_weighting_appraisal_warning
382: );
383:
384: exception
385: when hr_api.cannot_find_prog_unit then
386: hr_api.cannot_find_prog_unit_error
387: (p_module_name => 'CREATE_LIBRARY_OBJECTIVE',
388: p_hook_type => 'AP'
389: );
382: );
383:
384: exception
385: when hr_api.cannot_find_prog_unit then
386: hr_api.cannot_find_prog_unit_error
387: (p_module_name => 'CREATE_LIBRARY_OBJECTIVE',
388: p_hook_type => 'AP'
389: );
390:
397: --
398: -- When in validation only mode raise the Validate_Enabled exception
399: --
400: if p_validate then
401: raise hr_api.validate_enabled;
402: end if;
403: --
404: --
405: -- Set all IN OUT and OUT parameters with out values
452:
453: END IF;
454:
455: exception
456: when hr_api.validate_enabled then
457: --
458: -- As the Validate_Enabled exception has been raised
459: -- we must rollback to the savepoint
460: --
524: procedure update_library_objective
525: (p_validate in boolean default false
526: ,p_effective_date in date
527: ,p_objective_id in number
528: ,p_objective_name in varchar2 default hr_api.g_varchar2
529: ,p_valid_from in date default hr_api.g_date
530: ,p_valid_to in date default hr_api.g_date
531: ,p_target_date in date default hr_api.g_date
532: ,p_next_review_date in date default hr_api.g_date
525: (p_validate in boolean default false
526: ,p_effective_date in date
527: ,p_objective_id in number
528: ,p_objective_name in varchar2 default hr_api.g_varchar2
529: ,p_valid_from in date default hr_api.g_date
530: ,p_valid_to in date default hr_api.g_date
531: ,p_target_date in date default hr_api.g_date
532: ,p_next_review_date in date default hr_api.g_date
533: ,p_group_code in varchar2 default hr_api.g_varchar2
526: ,p_effective_date in date
527: ,p_objective_id in number
528: ,p_objective_name in varchar2 default hr_api.g_varchar2
529: ,p_valid_from in date default hr_api.g_date
530: ,p_valid_to in date default hr_api.g_date
531: ,p_target_date in date default hr_api.g_date
532: ,p_next_review_date in date default hr_api.g_date
533: ,p_group_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
527: ,p_objective_id in number
528: ,p_objective_name in varchar2 default hr_api.g_varchar2
529: ,p_valid_from in date default hr_api.g_date
530: ,p_valid_to in date default hr_api.g_date
531: ,p_target_date in date default hr_api.g_date
532: ,p_next_review_date in date default hr_api.g_date
533: ,p_group_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
528: ,p_objective_name in varchar2 default hr_api.g_varchar2
529: ,p_valid_from in date default hr_api.g_date
530: ,p_valid_to in date default hr_api.g_date
531: ,p_target_date in date default hr_api.g_date
532: ,p_next_review_date in date default hr_api.g_date
533: ,p_group_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
529: ,p_valid_from in date default hr_api.g_date
530: ,p_valid_to in date default hr_api.g_date
531: ,p_target_date in date default hr_api.g_date
532: ,p_next_review_date in date default hr_api.g_date
533: ,p_group_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
530: ,p_valid_to in date default hr_api.g_date
531: ,p_target_date in date default hr_api.g_date
532: ,p_next_review_date in date default hr_api.g_date
533: ,p_group_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
531: ,p_target_date in date default hr_api.g_date
532: ,p_next_review_date in date default hr_api.g_date
533: ,p_group_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
532: ,p_next_review_date in date default hr_api.g_date
533: ,p_group_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
533: ,p_group_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
534: ,p_priority_code in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
535: ,p_appraise_flag in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
536: ,p_weighting_percent in number default hr_api.g_number
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
537: ,p_measurement_style_code in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
538: ,p_measure_name in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
539: ,p_target_value in number default hr_api.g_number
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
540: ,p_uom_code in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
541: ,p_measure_type_code in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
542: ,p_measure_comments in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
543: ,p_eligibility_type_code in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
544: ,p_details in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
545: ,p_success_criteria in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
546: ,p_comments in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
547: ,p_attribute_category in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
548: ,p_attribute1 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
549: ,p_attribute2 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
550: ,p_attribute3 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
551: ,p_attribute4 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
552: ,p_attribute5 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
553: ,p_attribute6 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
554: ,p_attribute7 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
555: ,p_attribute8 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
556: ,p_attribute9 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
557: ,p_attribute10 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
558: ,p_attribute11 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
559: ,p_attribute12 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
560: ,p_attribute13 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
561: ,p_attribute14 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
562: ,p_attribute15 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
563: ,p_attribute16 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
564: ,p_attribute17 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
565: ,p_attribute18 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
566: ,p_attribute19 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
574: ,p_attribute27 in varchar2 default hr_api.g_varchar2
567: ,p_attribute20 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
574: ,p_attribute27 in varchar2 default hr_api.g_varchar2
575: ,p_attribute28 in varchar2 default hr_api.g_varchar2
568: ,p_attribute21 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
574: ,p_attribute27 in varchar2 default hr_api.g_varchar2
575: ,p_attribute28 in varchar2 default hr_api.g_varchar2
576: ,p_attribute29 in varchar2 default hr_api.g_varchar2
569: ,p_attribute22 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
574: ,p_attribute27 in varchar2 default hr_api.g_varchar2
575: ,p_attribute28 in varchar2 default hr_api.g_varchar2
576: ,p_attribute29 in varchar2 default hr_api.g_varchar2
577: ,p_attribute30 in varchar2 default hr_api.g_varchar2
570: ,p_attribute23 in varchar2 default hr_api.g_varchar2
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
574: ,p_attribute27 in varchar2 default hr_api.g_varchar2
575: ,p_attribute28 in varchar2 default hr_api.g_varchar2
576: ,p_attribute29 in varchar2 default hr_api.g_varchar2
577: ,p_attribute30 in varchar2 default hr_api.g_varchar2
578: ,p_object_version_number in out nocopy number
571: ,p_attribute24 in varchar2 default hr_api.g_varchar2
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
574: ,p_attribute27 in varchar2 default hr_api.g_varchar2
575: ,p_attribute28 in varchar2 default hr_api.g_varchar2
576: ,p_attribute29 in varchar2 default hr_api.g_varchar2
577: ,p_attribute30 in varchar2 default hr_api.g_varchar2
578: ,p_object_version_number in out nocopy number
579: ,p_duplicate_name_warning out nocopy boolean
572: ,p_attribute25 in varchar2 default hr_api.g_varchar2
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
574: ,p_attribute27 in varchar2 default hr_api.g_varchar2
575: ,p_attribute28 in varchar2 default hr_api.g_varchar2
576: ,p_attribute29 in varchar2 default hr_api.g_varchar2
577: ,p_attribute30 in varchar2 default hr_api.g_varchar2
578: ,p_object_version_number in out nocopy number
579: ,p_duplicate_name_warning out nocopy boolean
580: ,p_weighting_over_100_warning out nocopy boolean
573: ,p_attribute26 in varchar2 default hr_api.g_varchar2
574: ,p_attribute27 in varchar2 default hr_api.g_varchar2
575: ,p_attribute28 in varchar2 default hr_api.g_varchar2
576: ,p_attribute29 in varchar2 default hr_api.g_varchar2
577: ,p_attribute30 in varchar2 default hr_api.g_varchar2
578: ,p_object_version_number in out nocopy number
579: ,p_duplicate_name_warning out nocopy boolean
580: ,p_weighting_over_100_warning out nocopy boolean
581: ,p_weighting_appraisal_warning out nocopy boolean
738: ,p_object_version_number => l_object_version_number
739: );
740:
741: exception
742: when hr_api.cannot_find_prog_unit then
743: hr_api.cannot_find_prog_unit_error
744: (p_module_name => 'UPDATE_LIBRARY_OBJECTIVE',
745: p_hook_type => 'BP'
746: );
739: );
740:
741: exception
742: when hr_api.cannot_find_prog_unit then
743: hr_api.cannot_find_prog_unit_error
744: (p_module_name => 'UPDATE_LIBRARY_OBJECTIVE',
745: p_hook_type => 'BP'
746: );
747:
877: ,p_weighting_over_100_warning => l_weighting_over_100_warning
878: ,p_weighting_appraisal_warning => l_weighting_appraisal_warning
879: );
880: exception
881: when hr_api.cannot_find_prog_unit then
882: hr_api.cannot_find_prog_unit_error
883: (p_module_name => 'UPDATE_LIBRARY_OBJECTIVE',
884: p_hook_type => 'AP'
885: );
878: ,p_weighting_appraisal_warning => l_weighting_appraisal_warning
879: );
880: exception
881: when hr_api.cannot_find_prog_unit then
882: hr_api.cannot_find_prog_unit_error
883: (p_module_name => 'UPDATE_LIBRARY_OBJECTIVE',
884: p_hook_type => 'AP'
885: );
886: end;
892: --
893: -- When in validation only mode raise the Validate_Enabled exception
894: --
895: if p_validate then
896: raise hr_api.validate_enabled;
897: end if;
898:
899: --
900: -- Set all IN OUT and OUT parameters with out values
943:
944: END IF;
945:
946: exception
947: when hr_api.validate_enabled then
948: --
949: -- As the Validate_Enabled exception has been raised
950: -- we must rollback to the savepoint
951: --
1057: (p_objective_id => p_objective_id
1058: ,p_object_version_number => p_object_version_number
1059: );
1060: exception
1061: when hr_api.cannot_find_prog_unit then
1062: hr_api.cannot_find_prog_unit_error
1063: (p_module_name => 'DELETE_LIBRARY_OBJECTIVE',
1064: p_hook_type => 'BP'
1065: );
1058: ,p_object_version_number => p_object_version_number
1059: );
1060: exception
1061: when hr_api.cannot_find_prog_unit then
1062: hr_api.cannot_find_prog_unit_error
1063: (p_module_name => 'DELETE_LIBRARY_OBJECTIVE',
1064: p_hook_type => 'BP'
1065: );
1066: end;
1087: (p_objective_id => p_objective_id
1088: ,p_object_version_number => p_object_version_number
1089: );
1090: exception
1091: when hr_api.cannot_find_prog_unit then
1092: hr_api.cannot_find_prog_unit_error
1093: (p_module_name => 'DELETE_LIBRARY_OBJECTIVE',
1094: p_hook_type => 'AP'
1095: );
1088: ,p_object_version_number => p_object_version_number
1089: );
1090: exception
1091: when hr_api.cannot_find_prog_unit then
1092: hr_api.cannot_find_prog_unit_error
1093: (p_module_name => 'DELETE_LIBRARY_OBJECTIVE',
1094: p_hook_type => 'AP'
1095: );
1096: end;
1099: --
1100: -- When in validation only mode raise the Validate_Enabled exception
1101: --
1102: if p_validate then
1103: raise hr_api.validate_enabled;
1104: end if;
1105:
1106: --
1107: -- Pipe the main IN OUT / OUT parameters for ease of debugging.
1108: --
1109: IF g_debug THEN hr_utility.set_location(' Leaving:'||l_proc, 970); END IF;
1110:
1111: exception
1112: when hr_api.validate_enabled then
1113: --
1114: -- As the Validate_Enabled exception has been raised
1115: -- we must rollback to the savepoint
1116: --
1383: (p_validate in boolean default false
1384: ,p_elig_obj_id in number
1385: ,p_effective_start_date out nocopy date
1386: ,p_effective_end_date out nocopy date
1387: ,p_business_group_id in number default hr_api.g_number
1388: ,p_table_name in varchar2 default hr_api.g_varchar2
1389: ,p_column_name in varchar2 default hr_api.g_varchar2
1390: ,p_column_value in varchar2 default hr_api.g_varchar2
1391: ,p_object_version_number in out nocopy number
1384: ,p_elig_obj_id in number
1385: ,p_effective_start_date out nocopy date
1386: ,p_effective_end_date out nocopy date
1387: ,p_business_group_id in number default hr_api.g_number
1388: ,p_table_name in varchar2 default hr_api.g_varchar2
1389: ,p_column_name in varchar2 default hr_api.g_varchar2
1390: ,p_column_value in varchar2 default hr_api.g_varchar2
1391: ,p_object_version_number in out nocopy number
1392: ,p_effective_date in date
1385: ,p_effective_start_date out nocopy date
1386: ,p_effective_end_date out nocopy date
1387: ,p_business_group_id in number default hr_api.g_number
1388: ,p_table_name in varchar2 default hr_api.g_varchar2
1389: ,p_column_name in varchar2 default hr_api.g_varchar2
1390: ,p_column_value in varchar2 default hr_api.g_varchar2
1391: ,p_object_version_number in out nocopy number
1392: ,p_effective_date in date
1393: ,p_datetrack_mode in varchar2
1386: ,p_effective_end_date out nocopy date
1387: ,p_business_group_id in number default hr_api.g_number
1388: ,p_table_name in varchar2 default hr_api.g_varchar2
1389: ,p_column_name in varchar2 default hr_api.g_varchar2
1390: ,p_column_value in varchar2 default hr_api.g_varchar2
1391: ,p_object_version_number in out nocopy number
1392: ,p_effective_date in date
1393: ,p_datetrack_mode in varchar2
1394: ) is
1583: (p_validate in boolean default false
1584: ,p_elig_obj_elig_prfl_id in number
1585: ,p_effective_start_date out nocopy date
1586: ,p_effective_end_date out nocopy date
1587: ,p_elig_obj_id in number default hr_api.g_number
1588: ,p_elig_prfl_id in number default hr_api.g_number
1589: ,p_object_version_number in out nocopy number
1590: ,p_effective_date in date
1591: ,p_datetrack_mode in varchar2
1584: ,p_elig_obj_elig_prfl_id in number
1585: ,p_effective_start_date out nocopy date
1586: ,p_effective_end_date out nocopy date
1587: ,p_elig_obj_id in number default hr_api.g_number
1588: ,p_elig_prfl_id in number default hr_api.g_number
1589: ,p_object_version_number in out nocopy number
1590: ,p_effective_date in date
1591: ,p_datetrack_mode in varchar2
1592: ) is
1783: (p_validate in boolean default false
1784: ,p_elig_grd_prte_id in number
1785: ,p_effective_start_date out nocopy date
1786: ,p_effective_end_date out nocopy date
1787: ,p_business_group_id in number default hr_api.g_number
1788: ,p_eligy_prfl_id in number default hr_api.g_number
1789: ,p_grade_id in number default hr_api.g_number
1790: ,p_object_version_number in out nocopy number
1791: ,p_effective_date in date
1784: ,p_elig_grd_prte_id in number
1785: ,p_effective_start_date out nocopy date
1786: ,p_effective_end_date out nocopy date
1787: ,p_business_group_id in number default hr_api.g_number
1788: ,p_eligy_prfl_id in number default hr_api.g_number
1789: ,p_grade_id in number default hr_api.g_number
1790: ,p_object_version_number in out nocopy number
1791: ,p_effective_date in date
1792: ,p_datetrack_mode in varchar2
1785: ,p_effective_start_date out nocopy date
1786: ,p_effective_end_date out nocopy date
1787: ,p_business_group_id in number default hr_api.g_number
1788: ,p_eligy_prfl_id in number default hr_api.g_number
1789: ,p_grade_id in number default hr_api.g_number
1790: ,p_object_version_number in out nocopy number
1791: ,p_effective_date in date
1792: ,p_datetrack_mode in varchar2
1793: ) is
1988: (p_validate in boolean default false
1989: ,p_elig_org_unit_prte_id in number
1990: ,p_effective_start_date out nocopy date
1991: ,p_effective_end_date out nocopy date
1992: ,p_business_group_id in number default hr_api.g_number
1993: ,p_eligy_prfl_id in number default hr_api.g_number
1994: ,p_organization_id in number default hr_api.g_number
1995: ,p_object_version_number in out nocopy number
1996: ,p_effective_date in date
1989: ,p_elig_org_unit_prte_id in number
1990: ,p_effective_start_date out nocopy date
1991: ,p_effective_end_date out nocopy date
1992: ,p_business_group_id in number default hr_api.g_number
1993: ,p_eligy_prfl_id in number default hr_api.g_number
1994: ,p_organization_id in number default hr_api.g_number
1995: ,p_object_version_number in out nocopy number
1996: ,p_effective_date in date
1997: ,p_datetrack_mode in varchar2
1990: ,p_effective_start_date out nocopy date
1991: ,p_effective_end_date out nocopy date
1992: ,p_business_group_id in number default hr_api.g_number
1993: ,p_eligy_prfl_id in number default hr_api.g_number
1994: ,p_organization_id in number default hr_api.g_number
1995: ,p_object_version_number in out nocopy number
1996: ,p_effective_date in date
1997: ,p_datetrack_mode in varchar2
1998: ) is
2193: (p_validate in boolean default false
2194: ,p_elig_job_prte_id in number
2195: ,p_effective_start_date out nocopy date
2196: ,p_effective_end_date out nocopy date
2197: ,p_business_group_id in number default hr_api.g_number
2198: ,p_eligy_prfl_id in number default hr_api.g_number
2199: ,p_job_id in number default hr_api.g_number
2200: ,p_object_version_number in out nocopy number
2201: ,p_effective_date in date
2194: ,p_elig_job_prte_id in number
2195: ,p_effective_start_date out nocopy date
2196: ,p_effective_end_date out nocopy date
2197: ,p_business_group_id in number default hr_api.g_number
2198: ,p_eligy_prfl_id in number default hr_api.g_number
2199: ,p_job_id in number default hr_api.g_number
2200: ,p_object_version_number in out nocopy number
2201: ,p_effective_date in date
2202: ,p_datetrack_mode in varchar2
2195: ,p_effective_start_date out nocopy date
2196: ,p_effective_end_date out nocopy date
2197: ,p_business_group_id in number default hr_api.g_number
2198: ,p_eligy_prfl_id in number default hr_api.g_number
2199: ,p_job_id in number default hr_api.g_number
2200: ,p_object_version_number in out nocopy number
2201: ,p_effective_date in date
2202: ,p_datetrack_mode in varchar2
2203: ) is
2398: (p_validate in boolean default false
2399: ,p_elig_pstn_prte_id in number
2400: ,p_effective_start_date out nocopy date
2401: ,p_effective_end_date out nocopy date
2402: ,p_business_group_id in number default hr_api.g_number
2403: ,p_eligy_prfl_id in number default hr_api.g_number
2404: ,p_position_id in number default hr_api.g_number
2405: ,p_object_version_number in out nocopy number
2406: ,p_effective_date in date
2399: ,p_elig_pstn_prte_id in number
2400: ,p_effective_start_date out nocopy date
2401: ,p_effective_end_date out nocopy date
2402: ,p_business_group_id in number default hr_api.g_number
2403: ,p_eligy_prfl_id in number default hr_api.g_number
2404: ,p_position_id in number default hr_api.g_number
2405: ,p_object_version_number in out nocopy number
2406: ,p_effective_date in date
2407: ,p_datetrack_mode in varchar2
2400: ,p_effective_start_date out nocopy date
2401: ,p_effective_end_date out nocopy date
2402: ,p_business_group_id in number default hr_api.g_number
2403: ,p_eligy_prfl_id in number default hr_api.g_number
2404: ,p_position_id in number default hr_api.g_number
2405: ,p_object_version_number in out nocopy number
2406: ,p_effective_date in date
2407: ,p_datetrack_mode in varchar2
2408: ) is