198: ,p_achieved_date => p_achieved_date
199: ,p_appr_line_score => p_appr_line_score
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'create_competence_element',
205: p_hook_type => 'BP'
206: );
199: ,p_appr_line_score => p_appr_line_score
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
204: (p_module_name => 'create_competence_element',
205: p_hook_type => 'BP'
206: );
207: end;
394: ,p_achieved_date => p_achieved_date
395: ,p_appr_line_score => p_appr_line_score
396: );
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'create_competence_element',
401: p_hook_type => 'AP'
402: );
395: ,p_appr_line_score => p_appr_line_score
396: );
397: exception
398: when hr_api.cannot_find_prog_unit then
399: hr_api.cannot_find_prog_unit_error
400: (p_module_name => 'create_competence_element',
401: p_hook_type => 'AP'
402: );
403: end;
406: --
407: -- When in validation only mode raise the Validate_Enabled exception
408: --
409: if p_validate then
410: raise hr_api.validate_enabled;
411: end if;
412: --
413: -- Set all output arguments
414: --
416: p_object_version_number := l_object_version_number;
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 11);
419: exception
420: when hr_api.validate_enabled then
421: --
422: -- As the Validate_Enabled exception has been raised
423: -- we must rollback to the savepoint
424: --
453: procedure update_competence_element
454: (
455: p_competence_element_id in number,
456: p_object_version_number in out nocopy number,
457: p_proficiency_level_id in number default hr_api.g_number,
458: p_high_proficiency_level_id in number default hr_api.g_number,
459: p_weighting_level_id in number default hr_api.g_number,
460: p_rating_level_id in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
454: (
455: p_competence_element_id in number,
456: p_object_version_number in out nocopy number,
457: p_proficiency_level_id in number default hr_api.g_number,
458: p_high_proficiency_level_id in number default hr_api.g_number,
459: p_weighting_level_id in number default hr_api.g_number,
460: p_rating_level_id in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
455: p_competence_element_id in number,
456: p_object_version_number in out nocopy number,
457: p_proficiency_level_id in number default hr_api.g_number,
458: p_high_proficiency_level_id in number default hr_api.g_number,
459: p_weighting_level_id in number default hr_api.g_number,
460: p_rating_level_id in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
463: p_effective_date_to in date default hr_api.g_date,
456: p_object_version_number in out nocopy number,
457: p_proficiency_level_id in number default hr_api.g_number,
458: p_high_proficiency_level_id in number default hr_api.g_number,
459: p_weighting_level_id in number default hr_api.g_number,
460: p_rating_level_id in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
463: p_effective_date_to in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
457: p_proficiency_level_id in number default hr_api.g_number,
458: p_high_proficiency_level_id in number default hr_api.g_number,
459: p_weighting_level_id in number default hr_api.g_number,
460: p_rating_level_id in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
463: p_effective_date_to in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
458: p_high_proficiency_level_id in number default hr_api.g_number,
459: p_weighting_level_id in number default hr_api.g_number,
460: p_rating_level_id in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
463: p_effective_date_to in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
466: p_normal_elapse_duration in number default hr_api.g_number,
459: p_weighting_level_id in number default hr_api.g_number,
460: p_rating_level_id in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
463: p_effective_date_to in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
466: p_normal_elapse_duration in number default hr_api.g_number,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
460: p_rating_level_id in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
463: p_effective_date_to in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
466: p_normal_elapse_duration in number default hr_api.g_number,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
461: p_mandatory in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
463: p_effective_date_to in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
466: p_normal_elapse_duration in number default hr_api.g_number,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
462: p_effective_date_from in date default hr_api.g_date,
463: p_effective_date_to in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
466: p_normal_elapse_duration in number default hr_api.g_number,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
463: p_effective_date_to in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
466: p_normal_elapse_duration in number default hr_api.g_number,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
471: p_certification_date in date default hr_api.g_date,
464: p_group_competence_type in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
466: p_normal_elapse_duration in number default hr_api.g_number,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
471: p_certification_date in date default hr_api.g_date,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
465: p_competence_type in varchar2 default hr_api.g_varchar2,
466: p_normal_elapse_duration in number default hr_api.g_number,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
471: p_certification_date in date default hr_api.g_date,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
466: p_normal_elapse_duration in number default hr_api.g_number,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
471: p_certification_date in date default hr_api.g_date,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
474: p_comments in varchar2 default hr_api.g_varchar2,
467: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
471: p_certification_date in date default hr_api.g_date,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
474: p_comments in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
468: p_sequence_number in number default hr_api.g_number,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
471: p_certification_date in date default hr_api.g_date,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
474: p_comments in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
469: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
471: p_certification_date in date default hr_api.g_date,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
474: p_comments in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
470: p_line_score in number default hr_api.g_number,
471: p_certification_date in date default hr_api.g_date,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
474: p_comments in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
471: p_certification_date in date default hr_api.g_date,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
474: p_comments in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
472: p_certification_method in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
474: p_comments in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
473: p_next_certification_date in date default hr_api.g_date,
474: p_comments in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
474: p_comments in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
475: p_attribute_category in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
476: p_attribute1 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
477: p_attribute2 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
478: p_attribute3 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
479: p_attribute4 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
480: p_attribute5 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
481: p_attribute6 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
482: p_attribute7 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
483: p_attribute8 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
484: p_attribute9 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
492: p_attribute17 in varchar2 default hr_api.g_varchar2,
485: p_attribute10 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
492: p_attribute17 in varchar2 default hr_api.g_varchar2,
493: p_attribute18 in varchar2 default hr_api.g_varchar2,
486: p_attribute11 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
492: p_attribute17 in varchar2 default hr_api.g_varchar2,
493: p_attribute18 in varchar2 default hr_api.g_varchar2,
494: p_attribute19 in varchar2 default hr_api.g_varchar2,
487: p_attribute12 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
492: p_attribute17 in varchar2 default hr_api.g_varchar2,
493: p_attribute18 in varchar2 default hr_api.g_varchar2,
494: p_attribute19 in varchar2 default hr_api.g_varchar2,
495: p_attribute20 in varchar2 default hr_api.g_varchar2,
488: p_attribute13 in varchar2 default hr_api.g_varchar2,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
492: p_attribute17 in varchar2 default hr_api.g_varchar2,
493: p_attribute18 in varchar2 default hr_api.g_varchar2,
494: p_attribute19 in varchar2 default hr_api.g_varchar2,
495: p_attribute20 in varchar2 default hr_api.g_varchar2,
496: p_effective_date in Date,
489: p_attribute14 in varchar2 default hr_api.g_varchar2,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
492: p_attribute17 in varchar2 default hr_api.g_varchar2,
493: p_attribute18 in varchar2 default hr_api.g_varchar2,
494: p_attribute19 in varchar2 default hr_api.g_varchar2,
495: p_attribute20 in varchar2 default hr_api.g_varchar2,
496: p_effective_date in Date,
497: p_validate in boolean default false,
490: p_attribute15 in varchar2 default hr_api.g_varchar2,
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
492: p_attribute17 in varchar2 default hr_api.g_varchar2,
493: p_attribute18 in varchar2 default hr_api.g_varchar2,
494: p_attribute19 in varchar2 default hr_api.g_varchar2,
495: p_attribute20 in varchar2 default hr_api.g_varchar2,
496: p_effective_date in Date,
497: p_validate in boolean default false,
498: p_party_id in number
491: p_attribute16 in varchar2 default hr_api.g_varchar2,
492: p_attribute17 in varchar2 default hr_api.g_varchar2,
493: p_attribute18 in varchar2 default hr_api.g_varchar2,
494: p_attribute19 in varchar2 default hr_api.g_varchar2,
495: p_attribute20 in varchar2 default hr_api.g_varchar2,
496: p_effective_date in Date,
497: p_validate in boolean default false,
498: p_party_id in number
499: ,p_qualification_type_id in number default hr_api.g_number
495: p_attribute20 in varchar2 default hr_api.g_varchar2,
496: p_effective_date in Date,
497: p_validate in boolean default false,
498: p_party_id in number
499: ,p_qualification_type_id in number default hr_api.g_number
500: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
501: ,p_status in varchar2 default hr_api.g_varchar2
502: ,p_information_category in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
496: p_effective_date in Date,
497: p_validate in boolean default false,
498: p_party_id in number
499: ,p_qualification_type_id in number default hr_api.g_number
500: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
501: ,p_status in varchar2 default hr_api.g_varchar2
502: ,p_information_category in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
497: p_validate in boolean default false,
498: p_party_id in number
499: ,p_qualification_type_id in number default hr_api.g_number
500: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
501: ,p_status in varchar2 default hr_api.g_varchar2
502: ,p_information_category in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
498: p_party_id in number
499: ,p_qualification_type_id in number default hr_api.g_number
500: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
501: ,p_status in varchar2 default hr_api.g_varchar2
502: ,p_information_category in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
499: ,p_qualification_type_id in number default hr_api.g_number
500: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
501: ,p_status in varchar2 default hr_api.g_varchar2
502: ,p_information_category in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
500: ,p_unit_standard_type in varchar2 default hr_api.g_varchar2
501: ,p_status in varchar2 default hr_api.g_varchar2
502: ,p_information_category in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
501: ,p_status in varchar2 default hr_api.g_varchar2
502: ,p_information_category in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
502: ,p_information_category in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
503: ,p_information1 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
504: ,p_information2 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
505: ,p_information3 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
506: ,p_information4 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
507: ,p_information5 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
508: ,p_information6 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
509: ,p_information7 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
510: ,p_information8 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
511: ,p_information9 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
512: ,p_information10 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
513: ,p_information11 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
514: ,p_information12 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
515: ,p_information13 in varchar2 default hr_api.g_varchar2
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_achieved_date in date default hr_api.g_date
516: ,p_information14 in varchar2 default hr_api.g_varchar2
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_achieved_date in date default hr_api.g_date
524: ,p_appr_line_score in number default hr_api.g_number
517: ,p_information15 in varchar2 default hr_api.g_varchar2
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_achieved_date in date default hr_api.g_date
524: ,p_appr_line_score in number default hr_api.g_number
525: ) is
518: ,p_information16 in varchar2 default hr_api.g_varchar2
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_achieved_date in date default hr_api.g_date
524: ,p_appr_line_score in number default hr_api.g_number
525: ) is
526: --
519: ,p_information17 in varchar2 default hr_api.g_varchar2
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_achieved_date in date default hr_api.g_date
524: ,p_appr_line_score in number default hr_api.g_number
525: ) is
526: --
527: -- Declare cursors and local variables
520: ,p_information18 in varchar2 default hr_api.g_varchar2
521: ,p_information19 in varchar2 default hr_api.g_varchar2
522: ,p_information20 in varchar2 default hr_api.g_varchar2
523: ,p_achieved_date in date default hr_api.g_date
524: ,p_appr_line_score in number default hr_api.g_number
525: ) is
526: --
527: -- Declare cursors and local variables
528: --
613: ,p_achieved_date => p_achieved_date
614: ,p_appr_line_score => p_appr_line_score
615: );
616: exception
617: when hr_api.cannot_find_prog_unit then
618: hr_api.cannot_find_prog_unit_error
619: (p_module_name => 'update_competence_element',
620: p_hook_type => 'BP'
621: );
614: ,p_appr_line_score => p_appr_line_score
615: );
616: exception
617: when hr_api.cannot_find_prog_unit then
618: hr_api.cannot_find_prog_unit_error
619: (p_module_name => 'update_competence_element',
620: p_hook_type => 'BP'
621: );
622: end;
781: ,p_achieved_date => p_achieved_date
782: ,p_appr_line_score => p_appr_line_score
783: );
784: exception
785: when hr_api.cannot_find_prog_unit then
786: hr_api.cannot_find_prog_unit_error
787: (p_module_name => 'update_competence_element',
788: p_hook_type => 'AP'
789: );
782: ,p_appr_line_score => p_appr_line_score
783: );
784: exception
785: when hr_api.cannot_find_prog_unit then
786: hr_api.cannot_find_prog_unit_error
787: (p_module_name => 'update_competence_element',
788: p_hook_type => 'AP'
789: );
790: end;
793: --
794: -- When in validation only mode raise the Validate_Enabled exception
795: --
796: if p_validate then
797: raise hr_api.validate_enabled;
798: end if;
799: --
800: --
801: hr_utility.set_location(' Leaving:'||l_proc, 11);
799: --
800: --
801: hr_utility.set_location(' Leaving:'||l_proc, 11);
802: exception
803: when hr_api.validate_enabled then
804: --
805: -- As the Validate_Enabled exception has been raised
806: -- we must rollback to the savepoint
807: --
840: procedure update_competence_element
841: (
842: p_competence_element_id in number,
843: p_object_version_number in out nocopy number,
844: p_proficiency_level_id in number default hr_api.g_number,
845: p_high_proficiency_level_id in number default hr_api.g_number,
846: p_weighting_level_id in number default hr_api.g_number,
847: p_rating_level_id in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
841: (
842: p_competence_element_id in number,
843: p_object_version_number in out nocopy number,
844: p_proficiency_level_id in number default hr_api.g_number,
845: p_high_proficiency_level_id in number default hr_api.g_number,
846: p_weighting_level_id in number default hr_api.g_number,
847: p_rating_level_id in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
842: p_competence_element_id in number,
843: p_object_version_number in out nocopy number,
844: p_proficiency_level_id in number default hr_api.g_number,
845: p_high_proficiency_level_id in number default hr_api.g_number,
846: p_weighting_level_id in number default hr_api.g_number,
847: p_rating_level_id in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
850: p_effective_date_to in date default hr_api.g_date,
843: p_object_version_number in out nocopy number,
844: p_proficiency_level_id in number default hr_api.g_number,
845: p_high_proficiency_level_id in number default hr_api.g_number,
846: p_weighting_level_id in number default hr_api.g_number,
847: p_rating_level_id in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
850: p_effective_date_to in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
844: p_proficiency_level_id in number default hr_api.g_number,
845: p_high_proficiency_level_id in number default hr_api.g_number,
846: p_weighting_level_id in number default hr_api.g_number,
847: p_rating_level_id in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
850: p_effective_date_to in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
845: p_high_proficiency_level_id in number default hr_api.g_number,
846: p_weighting_level_id in number default hr_api.g_number,
847: p_rating_level_id in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
850: p_effective_date_to in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
853: p_normal_elapse_duration in number default hr_api.g_number,
846: p_weighting_level_id in number default hr_api.g_number,
847: p_rating_level_id in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
850: p_effective_date_to in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
853: p_normal_elapse_duration in number default hr_api.g_number,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
847: p_rating_level_id in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
850: p_effective_date_to in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
853: p_normal_elapse_duration in number default hr_api.g_number,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
848: p_mandatory in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
850: p_effective_date_to in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
853: p_normal_elapse_duration in number default hr_api.g_number,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
849: p_effective_date_from in date default hr_api.g_date,
850: p_effective_date_to in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
853: p_normal_elapse_duration in number default hr_api.g_number,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
850: p_effective_date_to in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
853: p_normal_elapse_duration in number default hr_api.g_number,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
858: p_certification_date in date default hr_api.g_date,
851: p_group_competence_type in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
853: p_normal_elapse_duration in number default hr_api.g_number,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
858: p_certification_date in date default hr_api.g_date,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
852: p_competence_type in varchar2 default hr_api.g_varchar2,
853: p_normal_elapse_duration in number default hr_api.g_number,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
858: p_certification_date in date default hr_api.g_date,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
853: p_normal_elapse_duration in number default hr_api.g_number,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
858: p_certification_date in date default hr_api.g_date,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
861: p_comments in varchar2 default hr_api.g_varchar2,
854: p_normal_elapse_duration_unit in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
858: p_certification_date in date default hr_api.g_date,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
861: p_comments in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
855: p_sequence_number in number default hr_api.g_number,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
858: p_certification_date in date default hr_api.g_date,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
861: p_comments in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
856: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
858: p_certification_date in date default hr_api.g_date,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
861: p_comments in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
857: p_line_score in number default hr_api.g_number,
858: p_certification_date in date default hr_api.g_date,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
861: p_comments in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
858: p_certification_date in date default hr_api.g_date,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
861: p_comments in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
859: p_certification_method in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
861: p_comments in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
860: p_next_certification_date in date default hr_api.g_date,
861: p_comments in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
861: p_comments in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
862: p_attribute_category in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
863: p_attribute1 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
864: p_attribute2 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
865: p_attribute3 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
866: p_attribute4 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
867: p_attribute5 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
868: p_attribute6 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
869: p_attribute7 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
870: p_attribute8 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
871: p_attribute9 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
879: p_attribute17 in varchar2 default hr_api.g_varchar2,
872: p_attribute10 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
879: p_attribute17 in varchar2 default hr_api.g_varchar2,
880: p_attribute18 in varchar2 default hr_api.g_varchar2,
873: p_attribute11 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
879: p_attribute17 in varchar2 default hr_api.g_varchar2,
880: p_attribute18 in varchar2 default hr_api.g_varchar2,
881: p_attribute19 in varchar2 default hr_api.g_varchar2,
874: p_attribute12 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
879: p_attribute17 in varchar2 default hr_api.g_varchar2,
880: p_attribute18 in varchar2 default hr_api.g_varchar2,
881: p_attribute19 in varchar2 default hr_api.g_varchar2,
882: p_attribute20 in varchar2 default hr_api.g_varchar2,
875: p_attribute13 in varchar2 default hr_api.g_varchar2,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
879: p_attribute17 in varchar2 default hr_api.g_varchar2,
880: p_attribute18 in varchar2 default hr_api.g_varchar2,
881: p_attribute19 in varchar2 default hr_api.g_varchar2,
882: p_attribute20 in varchar2 default hr_api.g_varchar2,
883: p_effective_date in Date,
876: p_attribute14 in varchar2 default hr_api.g_varchar2,
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
879: p_attribute17 in varchar2 default hr_api.g_varchar2,
880: p_attribute18 in varchar2 default hr_api.g_varchar2,
881: p_attribute19 in varchar2 default hr_api.g_varchar2,
882: p_attribute20 in varchar2 default hr_api.g_varchar2,
883: p_effective_date in Date,
884: p_validate in boolean default false
877: p_attribute15 in varchar2 default hr_api.g_varchar2,
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
879: p_attribute17 in varchar2 default hr_api.g_varchar2,
880: p_attribute18 in varchar2 default hr_api.g_varchar2,
881: p_attribute19 in varchar2 default hr_api.g_varchar2,
882: p_attribute20 in varchar2 default hr_api.g_varchar2,
883: p_effective_date in Date,
884: p_validate in boolean default false
885: ) is
878: p_attribute16 in varchar2 default hr_api.g_varchar2,
879: p_attribute17 in varchar2 default hr_api.g_varchar2,
880: p_attribute18 in varchar2 default hr_api.g_varchar2,
881: p_attribute19 in varchar2 default hr_api.g_varchar2,
882: p_attribute20 in varchar2 default hr_api.g_varchar2,
883: p_effective_date in Date,
884: p_validate in boolean default false
885: ) is
886: --
968: procedure update_personal_comp_element
969: (
970: p_competence_element_id in number,
971: p_object_version_number in out nocopy number,
972: p_proficiency_level_id in number default hr_api.g_number,
973: p_effective_date_from in date default hr_api.g_date,
974: p_effective_date_to in date default hr_api.g_date,
975: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
969: (
970: p_competence_element_id in number,
971: p_object_version_number in out nocopy number,
972: p_proficiency_level_id in number default hr_api.g_number,
973: p_effective_date_from in date default hr_api.g_date,
974: p_effective_date_to in date default hr_api.g_date,
975: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
970: p_competence_element_id in number,
971: p_object_version_number in out nocopy number,
972: p_proficiency_level_id in number default hr_api.g_number,
973: p_effective_date_from in date default hr_api.g_date,
974: p_effective_date_to in date default hr_api.g_date,
975: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
971: p_object_version_number in out nocopy number,
972: p_proficiency_level_id in number default hr_api.g_number,
973: p_effective_date_from in date default hr_api.g_date,
974: p_effective_date_to in date default hr_api.g_date,
975: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
979: p_comments in varchar2 default hr_api.g_varchar2,
972: p_proficiency_level_id in number default hr_api.g_number,
973: p_effective_date_from in date default hr_api.g_date,
974: p_effective_date_to in date default hr_api.g_date,
975: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
979: p_comments in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
973: p_effective_date_from in date default hr_api.g_date,
974: p_effective_date_to in date default hr_api.g_date,
975: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
979: p_comments in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
974: p_effective_date_to in date default hr_api.g_date,
975: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
979: p_comments in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
975: p_source_of_proficiency_level in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
979: p_comments in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
976: p_certification_date in date default hr_api.g_date,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
979: p_comments in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
977: p_certification_method in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
979: p_comments in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
978: p_next_certification_date in date default hr_api.g_date,
979: p_comments in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
979: p_comments in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
980: p_attribute_category in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
981: p_attribute1 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
982: p_attribute2 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
983: p_attribute3 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
984: p_attribute4 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
985: p_attribute5 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
986: p_attribute6 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
987: p_attribute7 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
988: p_attribute8 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
989: p_attribute9 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
997: p_attribute17 in varchar2 default hr_api.g_varchar2,
990: p_attribute10 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
997: p_attribute17 in varchar2 default hr_api.g_varchar2,
998: p_attribute18 in varchar2 default hr_api.g_varchar2,
991: p_attribute11 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
997: p_attribute17 in varchar2 default hr_api.g_varchar2,
998: p_attribute18 in varchar2 default hr_api.g_varchar2,
999: p_attribute19 in varchar2 default hr_api.g_varchar2,
992: p_attribute12 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
997: p_attribute17 in varchar2 default hr_api.g_varchar2,
998: p_attribute18 in varchar2 default hr_api.g_varchar2,
999: p_attribute19 in varchar2 default hr_api.g_varchar2,
1000: p_attribute20 in varchar2 default hr_api.g_varchar2,
993: p_attribute13 in varchar2 default hr_api.g_varchar2,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
997: p_attribute17 in varchar2 default hr_api.g_varchar2,
998: p_attribute18 in varchar2 default hr_api.g_varchar2,
999: p_attribute19 in varchar2 default hr_api.g_varchar2,
1000: p_attribute20 in varchar2 default hr_api.g_varchar2,
1001: p_effective_date in Date,
994: p_attribute14 in varchar2 default hr_api.g_varchar2,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
997: p_attribute17 in varchar2 default hr_api.g_varchar2,
998: p_attribute18 in varchar2 default hr_api.g_varchar2,
999: p_attribute19 in varchar2 default hr_api.g_varchar2,
1000: p_attribute20 in varchar2 default hr_api.g_varchar2,
1001: p_effective_date in Date,
1002: p_validate in boolean default false ,
995: p_attribute15 in varchar2 default hr_api.g_varchar2,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
997: p_attribute17 in varchar2 default hr_api.g_varchar2,
998: p_attribute18 in varchar2 default hr_api.g_varchar2,
999: p_attribute19 in varchar2 default hr_api.g_varchar2,
1000: p_attribute20 in varchar2 default hr_api.g_varchar2,
1001: p_effective_date in Date,
1002: p_validate in boolean default false ,
1003: p_ins_ovn out nocopy number,
996: p_attribute16 in varchar2 default hr_api.g_varchar2,
997: p_attribute17 in varchar2 default hr_api.g_varchar2,
998: p_attribute18 in varchar2 default hr_api.g_varchar2,
999: p_attribute19 in varchar2 default hr_api.g_varchar2,
1000: p_attribute20 in varchar2 default hr_api.g_varchar2,
1001: p_effective_date in Date,
1002: p_validate in boolean default false ,
1003: p_ins_ovn out nocopy number,
1004: p_ins_comp_id out nocopy number
1139: p_attribute20 => p_attribute20,
1140: p_effective_date => p_effective_date
1141: );
1142: exception
1143: when hr_api.cannot_find_prog_unit then
1144: hr_api.cannot_find_prog_unit_error
1145: (p_module_name => 'update_personal_comp_element',
1146: p_hook_type => 'BP'
1147: );
1140: p_effective_date => p_effective_date
1141: );
1142: exception
1143: when hr_api.cannot_find_prog_unit then
1144: hr_api.cannot_find_prog_unit_error
1145: (p_module_name => 'update_personal_comp_element',
1146: p_hook_type => 'BP'
1147: );
1148: end;
1390: p_ins_ovn => l_ins_ovn,
1391: p_ins_comp_id => l_ins_comp_id
1392: );
1393: exception
1394: when hr_api.cannot_find_prog_unit then
1395: hr_api.cannot_find_prog_unit_error
1396: (p_module_name => 'update_personal_comp_element',
1397: p_hook_type => 'AP'
1398: );
1391: p_ins_comp_id => l_ins_comp_id
1392: );
1393: exception
1394: when hr_api.cannot_find_prog_unit then
1395: hr_api.cannot_find_prog_unit_error
1396: (p_module_name => 'update_personal_comp_element',
1397: p_hook_type => 'AP'
1398: );
1399: end;
1402: --
1403: -- When in validation only mode raise the Validate_Enabled exception
1404: --
1405: if p_validate then
1406: raise hr_api.validate_enabled;
1407: end if;
1408: --
1409: --
1410: hr_utility.set_location(' Leaving:'||l_proc, 40);
1408: --
1409: --
1410: hr_utility.set_location(' Leaving:'||l_proc, 40);
1411: exception
1412: when hr_api.validate_enabled then
1413: --
1414: -- As the Validate_Enabled exception has been raised
1415: -- we must rollback to the savepoint
1416: --
1475: p_competence_element_id => p_competence_element_id,
1476: p_object_version_number => p_object_version_number
1477: );
1478: exception
1479: when hr_api.cannot_find_prog_unit then
1480: hr_api.cannot_find_prog_unit_error
1481: (p_module_name => 'delete_competence_element',
1482: p_hook_type => 'BP'
1483: );
1476: p_object_version_number => p_object_version_number
1477: );
1478: exception
1479: when hr_api.cannot_find_prog_unit then
1480: hr_api.cannot_find_prog_unit_error
1481: (p_module_name => 'delete_competence_element',
1482: p_hook_type => 'BP'
1483: );
1484: end;
1509: p_competence_element_id => p_competence_element_id,
1510: p_object_version_number => p_object_version_number
1511: );
1512: exception
1513: when hr_api.cannot_find_prog_unit then
1514: hr_api.cannot_find_prog_unit_error
1515: (p_module_name => 'delete_competence_element',
1516: p_hook_type => 'AP'
1517: );
1510: p_object_version_number => p_object_version_number
1511: );
1512: exception
1513: when hr_api.cannot_find_prog_unit then
1514: hr_api.cannot_find_prog_unit_error
1515: (p_module_name => 'delete_competence_element',
1516: p_hook_type => 'AP'
1517: );
1518: end;
1521: --
1522: -- When in validation only mode raise the Validate_Enabled exception
1523: --
1524: if p_validate then
1525: raise hr_api.validate_enabled;
1526: end if;
1527: --
1528: hr_utility.set_location(' Leaving:'||l_proc, 11);
1529: exception
1526: end if;
1527: --
1528: hr_utility.set_location(' Leaving:'||l_proc, 11);
1529: exception
1530: when hr_api.validate_enabled then
1531: --
1532: -- As the Validate_Enabled exception has been raised
1533: -- we must rollback to the savepoint
1534: --
1647: ,p_comments => p_comments
1648: ,p_effective_date => p_effective_date
1649: );
1650: exception
1651: when hr_api.cannot_find_prog_unit then
1652: hr_api.cannot_find_prog_unit_error
1653: (p_module_name => 'maintain_student_comp_element',
1654: p_hook_type => 'BP'
1655: );
1648: ,p_effective_date => p_effective_date
1649: );
1650: exception
1651: when hr_api.cannot_find_prog_unit then
1652: hr_api.cannot_find_prog_unit_error
1653: (p_module_name => 'maintain_student_comp_element',
1654: p_hook_type => 'BP'
1655: );
1656: end;
1756:
1757: /********* NEW Logic***********8888*/
1758:
1759: if (l_effective_date_from < p_effective_date_from) then
1760: if ((l_effective_date_to is null or l_effective_date_to>= nvl(p_effective_date_to,hr_api.g_eot))) then
1761: -- new record lies within span of existing record
1762: null;
1763:
1764: elsif (l_effective_date_to is not null and l_effective_date_to < nvl(p_effective_date_to,hr_api.g_eot) ) then
1760: if ((l_effective_date_to is null or l_effective_date_to>= nvl(p_effective_date_to,hr_api.g_eot))) then
1761: -- new record lies within span of existing record
1762: null;
1763:
1764: elsif (l_effective_date_to is not null and l_effective_date_to < nvl(p_effective_date_to,hr_api.g_eot) ) then
1765: /*update_personal_comp_element
1766: (p_competence_element_id => l_competence_element_id
1767: ,p_object_version_number => l_object_version_number
1768: ,p_proficiency_level_id => l_proficiency_level_id
1819: ,p_source_of_proficiency_level => p_source_of_proficiency_level
1820: ,p_comments => p_comments
1821: ,p_effective_date => p_effective_date);
1822:
1823: if (nvl(l_effective_date_to,hr_api.g_eot) < nvl(p_effective_date_to,hr_api.g_eot)) then
1824: create_competence_element
1825: (p_competence_element_id => l_new_competence_element_id
1826: ,p_object_version_number => l_new_object_version_number
1827: ,p_type => 'PERSONAL'
1924: ,p_source_of_proficiency_level => p_source_of_proficiency_level
1925: ,p_comments => p_comments
1926: ,p_effective_date => p_effective_date);
1927:
1928: if (p_effective_date_to is not null and nvl(l_effective_date_to,hr_api.g_eot)> p_effective_date_to) then
1929:
1930: create_competence_element
1931: (p_competence_element_id => l_new_competence_element_id
1932: ,p_object_version_number => l_new_object_version_number
1975: ,p_source_of_proficiency_level => p_source_of_proficiency_level
1976: ,p_comments => p_comments
1977: ,p_effective_date => p_effective_date);
1978:
1979: elsif (p_effective_date_to is not null and p_effective_date_to < nvl(l_effective_date_to,hr_api.g_eot)) then
1980: -- new record has an end date less than existing record
1981: update_personal_comp_element
1982: (p_competence_element_id => l_competence_element_id
1983: ,p_object_version_number => l_object_version_number
2299: ,p_effective_date => p_effective_date
2300: ,p_competence_created => p_competence_created
2301: );
2302: exception
2303: when hr_api.cannot_find_prog_unit then
2304: hr_api.cannot_find_prog_unit_error
2305: (p_module_name => 'maintain_student_comp_element',
2306: p_hook_type => 'AP'
2307: );
2300: ,p_competence_created => p_competence_created
2301: );
2302: exception
2303: when hr_api.cannot_find_prog_unit then
2304: hr_api.cannot_find_prog_unit_error
2305: (p_module_name => 'maintain_student_comp_element',
2306: p_hook_type => 'AP'
2307: );
2308: end;
2309: --
2310: -- End of After Process User hook
2311: --
2312: if p_validate then
2313: raise hr_api.validate_enabled;
2314: end if;
2315: --
2316:
2317: exception
2314: end if;
2315: --
2316:
2317: exception
2318: when hr_api.validate_enabled then
2319: --
2320: -- As the Validate_Enabled exception has been raised
2321: -- we must rollback to the savepoint
2322: --
2442: p_activity_version_to => p_activity_version_to ,
2443: p_competence_type => p_competence_type
2444: );
2445: exception
2446: when hr_api.cannot_find_prog_unit then
2447: hr_api.cannot_find_prog_unit_error
2448: (p_module_name => 'copy_competencies',
2449: p_hook_type => 'BP'
2450: );
2443: p_competence_type => p_competence_type
2444: );
2445: exception
2446: when hr_api.cannot_find_prog_unit then
2447: hr_api.cannot_find_prog_unit_error
2448: (p_module_name => 'copy_competencies',
2449: p_hook_type => 'BP'
2450: );
2451: end;
2545: p_activity_version_id => p_activity_version_from,
2546: p_activity_version_to => p_activity_version_to ,
2547: p_competence_type => p_competence_type );
2548: exception
2549: when hr_api.cannot_find_prog_unit then
2550: hr_api.cannot_find_prog_unit_error
2551: (p_module_name => 'copy_competencies',
2552: p_hook_type => 'AP'
2553: );
2546: p_activity_version_to => p_activity_version_to ,
2547: p_competence_type => p_competence_type );
2548: exception
2549: when hr_api.cannot_find_prog_unit then
2550: hr_api.cannot_find_prog_unit_error
2551: (p_module_name => 'copy_competencies',
2552: p_hook_type => 'AP'
2553: );
2554: end;
2555: --
2556: -- End of After Process User hook
2557: --
2558: if p_validate then
2559: raise hr_api.validate_enabled;
2560: end if;
2561: --
2562: exception
2563: when hr_api.validate_enabled then
2559: raise hr_api.validate_enabled;
2560: end if;
2561: --
2562: exception
2563: when hr_api.validate_enabled then
2564: --
2565: -- As the Validate_Enabled exception has been raised
2566: -- we must rollback to the savepoint
2567: --
2624: where e.activity_version_id = p_activity_version_id
2625: and e.type = 'DELIVERY'
2626: and e.competence_id = c.competence_id
2627: and (((l_sd_changed = 'Y'
2628: and nvl(e.effective_date_from,hr_api.g_sot)
2629: = nvl(p_old_start_date,hr_api.g_sot))
2630: or ( l_sd_changed = 'N'
2631: and l_ed_changed = 'Y'
2632: and nvl(e.effective_date_to,hr_api.g_eot)
2625: and e.type = 'DELIVERY'
2626: and e.competence_id = c.competence_id
2627: and (((l_sd_changed = 'Y'
2628: and nvl(e.effective_date_from,hr_api.g_sot)
2629: = nvl(p_old_start_date,hr_api.g_sot))
2630: or ( l_sd_changed = 'N'
2631: and l_ed_changed = 'Y'
2632: and nvl(e.effective_date_to,hr_api.g_eot)
2633: = nvl(p_old_end_date,hr_api.g_eot)))
2628: and nvl(e.effective_date_from,hr_api.g_sot)
2629: = nvl(p_old_start_date,hr_api.g_sot))
2630: or ( l_sd_changed = 'N'
2631: and l_ed_changed = 'Y'
2632: and nvl(e.effective_date_to,hr_api.g_eot)
2633: = nvl(p_old_end_date,hr_api.g_eot)))
2634: OR ((l_ed_changed = 'Y'
2635: and nvl(e.effective_date_to,hr_api.g_eot)
2636: = nvl(p_old_end_date,hr_api.g_eot))
2629: = nvl(p_old_start_date,hr_api.g_sot))
2630: or ( l_sd_changed = 'N'
2631: and l_ed_changed = 'Y'
2632: and nvl(e.effective_date_to,hr_api.g_eot)
2633: = nvl(p_old_end_date,hr_api.g_eot)))
2634: OR ((l_ed_changed = 'Y'
2635: and nvl(e.effective_date_to,hr_api.g_eot)
2636: = nvl(p_old_end_date,hr_api.g_eot))
2637: OR (l_ed_changed = 'N'
2631: and l_ed_changed = 'Y'
2632: and nvl(e.effective_date_to,hr_api.g_eot)
2633: = nvl(p_old_end_date,hr_api.g_eot)))
2634: OR ((l_ed_changed = 'Y'
2635: and nvl(e.effective_date_to,hr_api.g_eot)
2636: = nvl(p_old_end_date,hr_api.g_eot))
2637: OR (l_ed_changed = 'N'
2638: and l_sd_changed = 'Y'
2639: and nvl(e.effective_date_from,hr_api.g_sot)
2632: and nvl(e.effective_date_to,hr_api.g_eot)
2633: = nvl(p_old_end_date,hr_api.g_eot)))
2634: OR ((l_ed_changed = 'Y'
2635: and nvl(e.effective_date_to,hr_api.g_eot)
2636: = nvl(p_old_end_date,hr_api.g_eot))
2637: OR (l_ed_changed = 'N'
2638: and l_sd_changed = 'Y'
2639: and nvl(e.effective_date_from,hr_api.g_sot)
2640: = nvl(p_old_start_date,hr_api.g_sot))));
2635: and nvl(e.effective_date_to,hr_api.g_eot)
2636: = nvl(p_old_end_date,hr_api.g_eot))
2637: OR (l_ed_changed = 'N'
2638: and l_sd_changed = 'Y'
2639: and nvl(e.effective_date_from,hr_api.g_sot)
2640: = nvl(p_old_start_date,hr_api.g_sot))));
2641:
2642: Begin
2643: --
2636: = nvl(p_old_end_date,hr_api.g_eot))
2637: OR (l_ed_changed = 'N'
2638: and l_sd_changed = 'Y'
2639: and nvl(e.effective_date_from,hr_api.g_sot)
2640: = nvl(p_old_start_date,hr_api.g_sot))));
2641:
2642: Begin
2643: --
2644: hr_utility.set_location ('Entering:' || v_proc, 5);
2657: p_old_end_date => p_old_end_date ,
2658: p_end_date => p_end_date
2659: );
2660: exception
2661: when hr_api.cannot_find_prog_unit then
2662: hr_api.cannot_find_prog_unit_error
2663: (p_module_name => 'update_delivered_dates',
2664: p_hook_type => 'BP'
2665: );
2658: p_end_date => p_end_date
2659: );
2660: exception
2661: when hr_api.cannot_find_prog_unit then
2662: hr_api.cannot_find_prog_unit_error
2663: (p_module_name => 'update_delivered_dates',
2664: p_hook_type => 'BP'
2665: );
2666: end;
2710: -- update to the new date
2711: --
2712: If not ota_general.value_changed(p_old_start_date,v_start_date) Then
2713: l_start_date := greatest(p_start_date
2714: ,nvl(v_competence_date_from,hr_api.g_sot));
2715: Else
2716: l_start_date := hr_api.g_date;
2717: End if;
2718: --
2712: If not ota_general.value_changed(p_old_start_date,v_start_date) Then
2713: l_start_date := greatest(p_start_date
2714: ,nvl(v_competence_date_from,hr_api.g_sot));
2715: Else
2716: l_start_date := hr_api.g_date;
2717: End if;
2718: --
2719: -- If the old end date is the same as the cel end date then need to
2720: -- update to the new date
2720: -- update to the new date
2721: --
2722: If not ota_general.value_changed(p_old_end_date,v_end_date) Then
2723: l_end_date := least(p_end_date
2724: ,nvl(v_competence_date_to,hr_api.g_eot));
2725: Else
2726: l_end_date := hr_api.g_date;
2727: End if;
2728: --
2722: If not ota_general.value_changed(p_old_end_date,v_end_date) Then
2723: l_end_date := least(p_end_date
2724: ,nvl(v_competence_date_to,hr_api.g_eot));
2725: Else
2726: l_end_date := hr_api.g_date;
2727: End if;
2728: --
2729: Else
2730: --
2733: -- existing resource usage start date is used
2734: --
2735: If l_start_date_changed Then
2736: l_start_date := greatest(p_start_date
2737: ,nvl(v_competence_date_from,hr_api.g_sot));
2738: Else
2739: l_start_date := hr_api.g_date;
2740: End if;
2741: --
2735: If l_start_date_changed Then
2736: l_start_date := greatest(p_start_date
2737: ,nvl(v_competence_date_from,hr_api.g_sot));
2738: Else
2739: l_start_date := hr_api.g_date;
2740: End if;
2741: --
2742: --
2743: -- If the end date has changed then update the resource usage with the new
2746: -- resource usage end date is used
2747: --
2748: If l_end_date_changed Then
2749: l_end_date := least(p_end_date
2750: ,nvl(v_competence_date_to,hr_api.g_eot));
2751: Else
2752: l_end_date := hr_api.g_date;
2753: End if;
2754: --
2748: If l_end_date_changed Then
2749: l_end_date := least(p_end_date
2750: ,nvl(v_competence_date_to,hr_api.g_eot));
2751: Else
2752: l_end_date := hr_api.g_date;
2753: End if;
2754: --
2755: End if;
2756: --
2783: p_old_end_date => p_old_end_date ,
2784: p_end_date => p_end_date
2785: );
2786: exception
2787: when hr_api.cannot_find_prog_unit then
2788: hr_api.cannot_find_prog_unit_error
2789: (p_module_name => 'update_delivered_dates',
2790: p_hook_type => 'AP'
2791: );
2784: p_end_date => p_end_date
2785: );
2786: exception
2787: when hr_api.cannot_find_prog_unit then
2788: hr_api.cannot_find_prog_unit_error
2789: (p_module_name => 'update_delivered_dates',
2790: p_hook_type => 'AP'
2791: );
2792: end;
2793: --
2794: -- End of after Process User hook
2795: --
2796: if p_validate then
2797: raise hr_api.validate_enabled;
2798: end if;
2799: --
2800: exception
2801: when hr_api.validate_enabled then
2797: raise hr_api.validate_enabled;
2798: end if;
2799: --
2800: exception
2801: when hr_api.validate_enabled then
2802: --
2803: -- As the Validate_Enabled exception has been raised
2804: -- we must rollback to the savepoint
2805: --