[Home] [Help]
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: --
1648: ,p_comments => p_comments
1649: ,p_effective_date => p_effective_date
1650: );
1651: exception
1652: when hr_api.cannot_find_prog_unit then
1653: hr_api.cannot_find_prog_unit_error
1654: (p_module_name => 'maintain_student_comp_element',
1655: p_hook_type => 'BP'
1656: );
1649: ,p_effective_date => p_effective_date
1650: );
1651: exception
1652: when hr_api.cannot_find_prog_unit then
1653: hr_api.cannot_find_prog_unit_error
1654: (p_module_name => 'maintain_student_comp_element',
1655: p_hook_type => 'BP'
1656: );
1657: end;
1757:
1758: /********* NEW Logic***********8888*/
1759:
1760: if (l_effective_date_from < p_effective_date_from) then
1761: if ((l_effective_date_to is null or l_effective_date_to>= nvl(p_effective_date_to,hr_api.g_eot))) then
1762: -- new record lies within span of existing record
1763: null;
1764:
1765: elsif (l_effective_date_to is not null and l_effective_date_to < nvl(p_effective_date_to,hr_api.g_eot) ) then
1761: if ((l_effective_date_to is null or l_effective_date_to>= nvl(p_effective_date_to,hr_api.g_eot))) then
1762: -- new record lies within span of existing record
1763: null;
1764:
1765: elsif (l_effective_date_to is not null and l_effective_date_to < nvl(p_effective_date_to,hr_api.g_eot) ) then
1766: /*update_personal_comp_element
1767: (p_competence_element_id => l_competence_element_id
1768: ,p_object_version_number => l_object_version_number
1769: ,p_proficiency_level_id => l_proficiency_level_id
1820: ,p_source_of_proficiency_level => p_source_of_proficiency_level
1821: ,p_comments => p_comments
1822: ,p_effective_date => p_effective_date);
1823:
1824: if (nvl(l_effective_date_to,hr_api.g_eot) < nvl(p_effective_date_to,hr_api.g_eot)) then
1825: create_competence_element
1826: (p_competence_element_id => l_new_competence_element_id
1827: ,p_object_version_number => l_new_object_version_number
1828: ,p_type => 'PERSONAL'
1925: ,p_source_of_proficiency_level => p_source_of_proficiency_level
1926: ,p_comments => p_comments
1927: ,p_effective_date => p_effective_date);
1928:
1929: if (p_effective_date_to is not null and nvl(l_effective_date_to,hr_api.g_eot)> p_effective_date_to) then
1930:
1931: create_competence_element
1932: (p_competence_element_id => l_new_competence_element_id
1933: ,p_object_version_number => l_new_object_version_number
1976: ,p_source_of_proficiency_level => p_source_of_proficiency_level
1977: ,p_comments => p_comments
1978: ,p_effective_date => p_effective_date);
1979:
1980: elsif (p_effective_date_to is not null and p_effective_date_to < nvl(l_effective_date_to,hr_api.g_eot)) then
1981: -- new record has an end date less than existing record
1982: update_personal_comp_element
1983: (p_competence_element_id => l_competence_element_id
1984: ,p_object_version_number => l_object_version_number
2306: ,p_effective_date => p_effective_date
2307: ,p_competence_created => p_competence_created
2308: );
2309: exception
2310: when hr_api.cannot_find_prog_unit then
2311: hr_api.cannot_find_prog_unit_error
2312: (p_module_name => 'maintain_student_comp_element',
2313: p_hook_type => 'AP'
2314: );
2307: ,p_competence_created => p_competence_created
2308: );
2309: exception
2310: when hr_api.cannot_find_prog_unit then
2311: hr_api.cannot_find_prog_unit_error
2312: (p_module_name => 'maintain_student_comp_element',
2313: p_hook_type => 'AP'
2314: );
2315: end;
2316: --
2317: -- End of After Process User hook
2318: --
2319: if p_validate then
2320: raise hr_api.validate_enabled;
2321: end if;
2322: --
2323:
2324: exception
2321: end if;
2322: --
2323:
2324: exception
2325: when hr_api.validate_enabled then
2326: --
2327: -- As the Validate_Enabled exception has been raised
2328: -- we must rollback to the savepoint
2329: --
2449: p_activity_version_to => p_activity_version_to ,
2450: p_competence_type => p_competence_type
2451: );
2452: exception
2453: when hr_api.cannot_find_prog_unit then
2454: hr_api.cannot_find_prog_unit_error
2455: (p_module_name => 'copy_competencies',
2456: p_hook_type => 'BP'
2457: );
2450: p_competence_type => p_competence_type
2451: );
2452: exception
2453: when hr_api.cannot_find_prog_unit then
2454: hr_api.cannot_find_prog_unit_error
2455: (p_module_name => 'copy_competencies',
2456: p_hook_type => 'BP'
2457: );
2458: end;
2552: p_activity_version_id => p_activity_version_from,
2553: p_activity_version_to => p_activity_version_to ,
2554: p_competence_type => p_competence_type );
2555: exception
2556: when hr_api.cannot_find_prog_unit then
2557: hr_api.cannot_find_prog_unit_error
2558: (p_module_name => 'copy_competencies',
2559: p_hook_type => 'AP'
2560: );
2553: p_activity_version_to => p_activity_version_to ,
2554: p_competence_type => p_competence_type );
2555: exception
2556: when hr_api.cannot_find_prog_unit then
2557: hr_api.cannot_find_prog_unit_error
2558: (p_module_name => 'copy_competencies',
2559: p_hook_type => 'AP'
2560: );
2561: end;
2562: --
2563: -- End of After Process User hook
2564: --
2565: if p_validate then
2566: raise hr_api.validate_enabled;
2567: end if;
2568: --
2569: exception
2570: when hr_api.validate_enabled then
2566: raise hr_api.validate_enabled;
2567: end if;
2568: --
2569: exception
2570: when hr_api.validate_enabled then
2571: --
2572: -- As the Validate_Enabled exception has been raised
2573: -- we must rollback to the savepoint
2574: --
2631: where e.activity_version_id = p_activity_version_id
2632: and e.type = 'DELIVERY'
2633: and e.competence_id = c.competence_id
2634: and (((l_sd_changed = 'Y'
2635: and nvl(e.effective_date_from,hr_api.g_sot)
2636: = nvl(p_old_start_date,hr_api.g_sot))
2637: or ( l_sd_changed = 'N'
2638: and l_ed_changed = 'Y'
2639: and nvl(e.effective_date_to,hr_api.g_eot)
2632: and e.type = 'DELIVERY'
2633: and e.competence_id = c.competence_id
2634: and (((l_sd_changed = 'Y'
2635: and nvl(e.effective_date_from,hr_api.g_sot)
2636: = nvl(p_old_start_date,hr_api.g_sot))
2637: or ( l_sd_changed = 'N'
2638: and l_ed_changed = 'Y'
2639: and nvl(e.effective_date_to,hr_api.g_eot)
2640: = nvl(p_old_end_date,hr_api.g_eot)))
2635: and nvl(e.effective_date_from,hr_api.g_sot)
2636: = nvl(p_old_start_date,hr_api.g_sot))
2637: or ( l_sd_changed = 'N'
2638: and l_ed_changed = 'Y'
2639: and nvl(e.effective_date_to,hr_api.g_eot)
2640: = nvl(p_old_end_date,hr_api.g_eot)))
2641: OR ((l_ed_changed = 'Y'
2642: and nvl(e.effective_date_to,hr_api.g_eot)
2643: = nvl(p_old_end_date,hr_api.g_eot))
2636: = nvl(p_old_start_date,hr_api.g_sot))
2637: or ( l_sd_changed = 'N'
2638: and l_ed_changed = 'Y'
2639: and nvl(e.effective_date_to,hr_api.g_eot)
2640: = nvl(p_old_end_date,hr_api.g_eot)))
2641: OR ((l_ed_changed = 'Y'
2642: and nvl(e.effective_date_to,hr_api.g_eot)
2643: = nvl(p_old_end_date,hr_api.g_eot))
2644: OR (l_ed_changed = 'N'
2638: and l_ed_changed = 'Y'
2639: and nvl(e.effective_date_to,hr_api.g_eot)
2640: = nvl(p_old_end_date,hr_api.g_eot)))
2641: OR ((l_ed_changed = 'Y'
2642: and nvl(e.effective_date_to,hr_api.g_eot)
2643: = nvl(p_old_end_date,hr_api.g_eot))
2644: OR (l_ed_changed = 'N'
2645: and l_sd_changed = 'Y'
2646: and nvl(e.effective_date_from,hr_api.g_sot)
2639: and nvl(e.effective_date_to,hr_api.g_eot)
2640: = nvl(p_old_end_date,hr_api.g_eot)))
2641: OR ((l_ed_changed = 'Y'
2642: and nvl(e.effective_date_to,hr_api.g_eot)
2643: = nvl(p_old_end_date,hr_api.g_eot))
2644: OR (l_ed_changed = 'N'
2645: and l_sd_changed = 'Y'
2646: and nvl(e.effective_date_from,hr_api.g_sot)
2647: = nvl(p_old_start_date,hr_api.g_sot))));
2642: and nvl(e.effective_date_to,hr_api.g_eot)
2643: = nvl(p_old_end_date,hr_api.g_eot))
2644: OR (l_ed_changed = 'N'
2645: and l_sd_changed = 'Y'
2646: and nvl(e.effective_date_from,hr_api.g_sot)
2647: = nvl(p_old_start_date,hr_api.g_sot))));
2648:
2649: Begin
2650: --
2643: = nvl(p_old_end_date,hr_api.g_eot))
2644: OR (l_ed_changed = 'N'
2645: and l_sd_changed = 'Y'
2646: and nvl(e.effective_date_from,hr_api.g_sot)
2647: = nvl(p_old_start_date,hr_api.g_sot))));
2648:
2649: Begin
2650: --
2651: hr_utility.set_location ('Entering:' || v_proc, 5);
2664: p_old_end_date => p_old_end_date ,
2665: p_end_date => p_end_date
2666: );
2667: exception
2668: when hr_api.cannot_find_prog_unit then
2669: hr_api.cannot_find_prog_unit_error
2670: (p_module_name => 'update_delivered_dates',
2671: p_hook_type => 'BP'
2672: );
2665: p_end_date => p_end_date
2666: );
2667: exception
2668: when hr_api.cannot_find_prog_unit then
2669: hr_api.cannot_find_prog_unit_error
2670: (p_module_name => 'update_delivered_dates',
2671: p_hook_type => 'BP'
2672: );
2673: end;
2717: -- update to the new date
2718: --
2719: If not ota_general.value_changed(p_old_start_date,v_start_date) Then
2720: l_start_date := greatest(p_start_date
2721: ,nvl(v_competence_date_from,hr_api.g_sot));
2722: Else
2723: l_start_date := hr_api.g_date;
2724: End if;
2725: --
2719: If not ota_general.value_changed(p_old_start_date,v_start_date) Then
2720: l_start_date := greatest(p_start_date
2721: ,nvl(v_competence_date_from,hr_api.g_sot));
2722: Else
2723: l_start_date := hr_api.g_date;
2724: End if;
2725: --
2726: -- If the old end date is the same as the cel end date then need to
2727: -- update to the new date
2727: -- update to the new date
2728: --
2729: If not ota_general.value_changed(p_old_end_date,v_end_date) Then
2730: l_end_date := least(p_end_date
2731: ,nvl(v_competence_date_to,hr_api.g_eot));
2732: Else
2733: l_end_date := hr_api.g_date;
2734: End if;
2735: --
2729: If not ota_general.value_changed(p_old_end_date,v_end_date) Then
2730: l_end_date := least(p_end_date
2731: ,nvl(v_competence_date_to,hr_api.g_eot));
2732: Else
2733: l_end_date := hr_api.g_date;
2734: End if;
2735: --
2736: Else
2737: --
2740: -- existing resource usage start date is used
2741: --
2742: If l_start_date_changed Then
2743: l_start_date := greatest(p_start_date
2744: ,nvl(v_competence_date_from,hr_api.g_sot));
2745: Else
2746: l_start_date := hr_api.g_date;
2747: End if;
2748: --
2742: If l_start_date_changed Then
2743: l_start_date := greatest(p_start_date
2744: ,nvl(v_competence_date_from,hr_api.g_sot));
2745: Else
2746: l_start_date := hr_api.g_date;
2747: End if;
2748: --
2749: --
2750: -- If the end date has changed then update the resource usage with the new
2753: -- resource usage end date is used
2754: --
2755: If l_end_date_changed Then
2756: l_end_date := least(p_end_date
2757: ,nvl(v_competence_date_to,hr_api.g_eot));
2758: Else
2759: l_end_date := hr_api.g_date;
2760: End if;
2761: --
2755: If l_end_date_changed Then
2756: l_end_date := least(p_end_date
2757: ,nvl(v_competence_date_to,hr_api.g_eot));
2758: Else
2759: l_end_date := hr_api.g_date;
2760: End if;
2761: --
2762: End if;
2763: --
2790: p_old_end_date => p_old_end_date ,
2791: p_end_date => p_end_date
2792: );
2793: exception
2794: when hr_api.cannot_find_prog_unit then
2795: hr_api.cannot_find_prog_unit_error
2796: (p_module_name => 'update_delivered_dates',
2797: p_hook_type => 'AP'
2798: );
2791: p_end_date => p_end_date
2792: );
2793: exception
2794: when hr_api.cannot_find_prog_unit then
2795: hr_api.cannot_find_prog_unit_error
2796: (p_module_name => 'update_delivered_dates',
2797: p_hook_type => 'AP'
2798: );
2799: end;
2800: --
2801: -- End of after Process User hook
2802: --
2803: if p_validate then
2804: raise hr_api.validate_enabled;
2805: end if;
2806: --
2807: exception
2808: when hr_api.validate_enabled then
2804: raise hr_api.validate_enabled;
2805: end if;
2806: --
2807: exception
2808: when hr_api.validate_enabled then
2809: --
2810: -- As the Validate_Enabled exception has been raised
2811: -- we must rollback to the savepoint
2812: --