38: * applicable during the start to end active date range. This date does not
39: * determine when the changes take effect.
40: * @param p_language_code Specifies to which language the translation values
41: * apply. You can set to the base or any installed language. The default value
42: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
43: * value.
44: * @param p_business_group_id {@rep:casecolumn
45: * PER_COMPETENCES.BUSINESS_GROUP_ID}
46: * @param p_description {@rep:casecolumn PER_COMPETENCES.DESCRIPTION}
179: --
180: procedure create_competence
181: (p_validate in boolean default false,
182: p_effective_date in date,
183: p_language_code in varchar2 default hr_api.userenv_lang ,
184: p_business_group_id in number default null,
185: p_description in varchar2 default null,
186: p_competence_alias in varchar2 default null,
187: p_date_from in date,
314: * will be set to the new version number of the updated competence. If
315: * p_validate is true will be set to the same value which was passed in.
316: * @param p_language_code Specifies to which language the translation values
317: * apply. You can set to the base or any installed language. The default value
318: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
319: * value.
320: * @param p_name If p_validate is false, then this set competence name derive
321: * from p_segment parameters or p_conct_segments parameter. If p_validate is
322: * true, then set to null.
445: (p_validate in boolean default false,
446: p_effective_date in date,
447: p_competence_id in number,
448: p_object_version_number in out nocopy number,
449: p_language_code in varchar2 default hr_api.userenv_lang ,
450: p_name out nocopy varchar2 ,
451: p_description in varchar2 default hr_api.g_varchar2,
452: p_date_from in date default hr_api.g_date,
453: p_date_to in date default hr_api.g_date,
447: p_competence_id in number,
448: p_object_version_number in out nocopy number,
449: p_language_code in varchar2 default hr_api.userenv_lang ,
450: p_name out nocopy varchar2 ,
451: p_description in varchar2 default hr_api.g_varchar2,
452: p_date_from in date default hr_api.g_date,
453: p_date_to in date default hr_api.g_date,
454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
448: p_object_version_number in out nocopy number,
449: p_language_code in varchar2 default hr_api.userenv_lang ,
450: p_name out nocopy varchar2 ,
451: p_description in varchar2 default hr_api.g_varchar2,
452: p_date_from in date default hr_api.g_date,
453: p_date_to in date default hr_api.g_date,
454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
449: p_language_code in varchar2 default hr_api.userenv_lang ,
450: p_name out nocopy varchar2 ,
451: p_description in varchar2 default hr_api.g_varchar2,
452: p_date_from in date default hr_api.g_date,
453: p_date_to in date default hr_api.g_date,
454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
450: p_name out nocopy varchar2 ,
451: p_description in varchar2 default hr_api.g_varchar2,
452: p_date_from in date default hr_api.g_date,
453: p_date_to in date default hr_api.g_date,
454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
451: p_description in varchar2 default hr_api.g_varchar2,
452: p_date_from in date default hr_api.g_date,
453: p_date_to in date default hr_api.g_date,
454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
452: p_date_from in date default hr_api.g_date,
453: p_date_to in date default hr_api.g_date,
454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
453: p_date_to in date default hr_api.g_date,
454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
455: p_certification_required in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
456: p_evaluation_method in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
457: p_renewal_period_frequency in number default hr_api.g_number,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
458: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
459: p_rating_scale_id in number default hr_api.g_number,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
461: p_attribute1 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
462: p_attribute2 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
463: p_attribute3 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
464: p_attribute4 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
465: p_attribute5 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
466: p_attribute6 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
467: p_attribute7 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
468: p_attribute8 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
469: p_attribute9 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
470: p_attribute10 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
471: p_attribute11 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
472: p_attribute12 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
473: p_attribute13 in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
474: p_attribute14 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
475: p_attribute15 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
476: p_attribute16 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
477: p_attribute17 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
478: p_attribute18 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
479: p_attribute19 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
480: p_attribute20 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
481: p_competence_alias in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
482: p_segment1 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
483: p_segment2 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
484: p_segment3 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
485: p_segment4 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
486: p_segment5 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
487: p_segment6 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
488: p_segment7 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
489: p_segment8 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
490: p_segment9 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
491: p_segment10 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
492: p_segment11 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
493: p_segment12 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
494: p_segment13 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
495: p_segment14 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
496: p_segment15 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
497: p_segment16 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
498: p_segment17 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
506: p_segment25 in varchar2 default hr_api.g_varchar2,
499: p_segment18 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
506: p_segment25 in varchar2 default hr_api.g_varchar2,
507: p_segment26 in varchar2 default hr_api.g_varchar2,
500: p_segment19 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
506: p_segment25 in varchar2 default hr_api.g_varchar2,
507: p_segment26 in varchar2 default hr_api.g_varchar2,
508: p_segment27 in varchar2 default hr_api.g_varchar2,
501: p_segment20 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
506: p_segment25 in varchar2 default hr_api.g_varchar2,
507: p_segment26 in varchar2 default hr_api.g_varchar2,
508: p_segment27 in varchar2 default hr_api.g_varchar2,
509: p_segment28 in varchar2 default hr_api.g_varchar2,
502: p_segment21 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
506: p_segment25 in varchar2 default hr_api.g_varchar2,
507: p_segment26 in varchar2 default hr_api.g_varchar2,
508: p_segment27 in varchar2 default hr_api.g_varchar2,
509: p_segment28 in varchar2 default hr_api.g_varchar2,
510: p_segment29 in varchar2 default hr_api.g_varchar2,
503: p_segment22 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
506: p_segment25 in varchar2 default hr_api.g_varchar2,
507: p_segment26 in varchar2 default hr_api.g_varchar2,
508: p_segment27 in varchar2 default hr_api.g_varchar2,
509: p_segment28 in varchar2 default hr_api.g_varchar2,
510: p_segment29 in varchar2 default hr_api.g_varchar2,
511: p_segment30 in varchar2 default hr_api.g_varchar2,
504: p_segment23 in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
506: p_segment25 in varchar2 default hr_api.g_varchar2,
507: p_segment26 in varchar2 default hr_api.g_varchar2,
508: p_segment27 in varchar2 default hr_api.g_varchar2,
509: p_segment28 in varchar2 default hr_api.g_varchar2,
510: p_segment29 in varchar2 default hr_api.g_varchar2,
511: p_segment30 in varchar2 default hr_api.g_varchar2,
512: p_concat_segments in varchar2 default hr_api.g_varchar2,
505: p_segment24 in varchar2 default hr_api.g_varchar2,
506: p_segment25 in varchar2 default hr_api.g_varchar2,
507: p_segment26 in varchar2 default hr_api.g_varchar2,
508: p_segment27 in varchar2 default hr_api.g_varchar2,
509: p_segment28 in varchar2 default hr_api.g_varchar2,
510: p_segment29 in varchar2 default hr_api.g_varchar2,
511: p_segment30 in varchar2 default hr_api.g_varchar2,
512: p_concat_segments in varchar2 default hr_api.g_varchar2,
513: p_competence_definition_id in out nocopy number
506: p_segment25 in varchar2 default hr_api.g_varchar2,
507: p_segment26 in varchar2 default hr_api.g_varchar2,
508: p_segment27 in varchar2 default hr_api.g_varchar2,
509: p_segment28 in varchar2 default hr_api.g_varchar2,
510: p_segment29 in varchar2 default hr_api.g_varchar2,
511: p_segment30 in varchar2 default hr_api.g_varchar2,
512: p_concat_segments in varchar2 default hr_api.g_varchar2,
513: p_competence_definition_id in out nocopy number
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
507: p_segment26 in varchar2 default hr_api.g_varchar2,
508: p_segment27 in varchar2 default hr_api.g_varchar2,
509: p_segment28 in varchar2 default hr_api.g_varchar2,
510: p_segment29 in varchar2 default hr_api.g_varchar2,
511: p_segment30 in varchar2 default hr_api.g_varchar2,
512: p_concat_segments in varchar2 default hr_api.g_varchar2,
513: p_competence_definition_id in out nocopy number
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
515: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
508: p_segment27 in varchar2 default hr_api.g_varchar2,
509: p_segment28 in varchar2 default hr_api.g_varchar2,
510: p_segment29 in varchar2 default hr_api.g_varchar2,
511: p_segment30 in varchar2 default hr_api.g_varchar2,
512: p_concat_segments in varchar2 default hr_api.g_varchar2,
513: p_competence_definition_id in out nocopy number
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
515: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
516: ,p_credit_type in varchar2 default hr_api.g_varchar2
510: p_segment29 in varchar2 default hr_api.g_varchar2,
511: p_segment30 in varchar2 default hr_api.g_varchar2,
512: p_concat_segments in varchar2 default hr_api.g_varchar2,
513: p_competence_definition_id in out nocopy number
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
515: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
516: ,p_credit_type in varchar2 default hr_api.g_varchar2
517: ,p_credits in number default hr_api.g_number
518: ,p_level_type in varchar2 default hr_api.g_varchar2
511: p_segment30 in varchar2 default hr_api.g_varchar2,
512: p_concat_segments in varchar2 default hr_api.g_varchar2,
513: p_competence_definition_id in out nocopy number
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
515: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
516: ,p_credit_type in varchar2 default hr_api.g_varchar2
517: ,p_credits in number default hr_api.g_number
518: ,p_level_type in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
512: p_concat_segments in varchar2 default hr_api.g_varchar2,
513: p_competence_definition_id in out nocopy number
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
515: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
516: ,p_credit_type in varchar2 default hr_api.g_varchar2
517: ,p_credits in number default hr_api.g_number
518: ,p_level_type in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
520: ,p_field in varchar2 default hr_api.g_varchar2
513: p_competence_definition_id in out nocopy number
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
515: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
516: ,p_credit_type in varchar2 default hr_api.g_varchar2
517: ,p_credits in number default hr_api.g_number
518: ,p_level_type in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
520: ,p_field in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
515: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
516: ,p_credit_type in varchar2 default hr_api.g_varchar2
517: ,p_credits in number default hr_api.g_number
518: ,p_level_type in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
520: ,p_field in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
515: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
516: ,p_credit_type in varchar2 default hr_api.g_varchar2
517: ,p_credits in number default hr_api.g_number
518: ,p_level_type in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
520: ,p_field in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
516: ,p_credit_type in varchar2 default hr_api.g_varchar2
517: ,p_credits in number default hr_api.g_number
518: ,p_level_type in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
520: ,p_field in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
517: ,p_credits in number default hr_api.g_number
518: ,p_level_type in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
520: ,p_field in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
518: ,p_level_type in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
520: ,p_field in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
519: ,p_level_number in number default hr_api.g_number
520: ,p_field in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
520: ,p_field in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
521: ,p_sub_field in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
522: ,p_provider in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
523: ,p_qa_organization in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
524: ,p_information_category in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
525: ,p_information1 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
526: ,p_information2 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
527: ,p_information3 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
528: ,p_information4 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
529: ,p_information5 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
530: ,p_information6 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
538: ,p_information14 in varchar2 default hr_api.g_varchar2
531: ,p_information7 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
538: ,p_information14 in varchar2 default hr_api.g_varchar2
539: ,p_information15 in varchar2 default hr_api.g_varchar2
532: ,p_information8 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
538: ,p_information14 in varchar2 default hr_api.g_varchar2
539: ,p_information15 in varchar2 default hr_api.g_varchar2
540: ,p_information16 in varchar2 default hr_api.g_varchar2
533: ,p_information9 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
538: ,p_information14 in varchar2 default hr_api.g_varchar2
539: ,p_information15 in varchar2 default hr_api.g_varchar2
540: ,p_information16 in varchar2 default hr_api.g_varchar2
541: ,p_information17 in varchar2 default hr_api.g_varchar2
534: ,p_information10 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
538: ,p_information14 in varchar2 default hr_api.g_varchar2
539: ,p_information15 in varchar2 default hr_api.g_varchar2
540: ,p_information16 in varchar2 default hr_api.g_varchar2
541: ,p_information17 in varchar2 default hr_api.g_varchar2
542: ,p_information18 in varchar2 default hr_api.g_varchar2
535: ,p_information11 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
538: ,p_information14 in varchar2 default hr_api.g_varchar2
539: ,p_information15 in varchar2 default hr_api.g_varchar2
540: ,p_information16 in varchar2 default hr_api.g_varchar2
541: ,p_information17 in varchar2 default hr_api.g_varchar2
542: ,p_information18 in varchar2 default hr_api.g_varchar2
543: ,p_information19 in varchar2 default hr_api.g_varchar2
536: ,p_information12 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
538: ,p_information14 in varchar2 default hr_api.g_varchar2
539: ,p_information15 in varchar2 default hr_api.g_varchar2
540: ,p_information16 in varchar2 default hr_api.g_varchar2
541: ,p_information17 in varchar2 default hr_api.g_varchar2
542: ,p_information18 in varchar2 default hr_api.g_varchar2
543: ,p_information19 in varchar2 default hr_api.g_varchar2
544: ,p_information20 in varchar2 default hr_api.g_varchar2
537: ,p_information13 in varchar2 default hr_api.g_varchar2
538: ,p_information14 in varchar2 default hr_api.g_varchar2
539: ,p_information15 in varchar2 default hr_api.g_varchar2
540: ,p_information16 in varchar2 default hr_api.g_varchar2
541: ,p_information17 in varchar2 default hr_api.g_varchar2
542: ,p_information18 in varchar2 default hr_api.g_varchar2
543: ,p_information19 in varchar2 default hr_api.g_varchar2
544: ,p_information20 in varchar2 default hr_api.g_varchar2
545: );
538: ,p_information14 in varchar2 default hr_api.g_varchar2
539: ,p_information15 in varchar2 default hr_api.g_varchar2
540: ,p_information16 in varchar2 default hr_api.g_varchar2
541: ,p_information17 in varchar2 default hr_api.g_varchar2
542: ,p_information18 in varchar2 default hr_api.g_varchar2
543: ,p_information19 in varchar2 default hr_api.g_varchar2
544: ,p_information20 in varchar2 default hr_api.g_varchar2
545: );
546: --
539: ,p_information15 in varchar2 default hr_api.g_varchar2
540: ,p_information16 in varchar2 default hr_api.g_varchar2
541: ,p_information17 in varchar2 default hr_api.g_varchar2
542: ,p_information18 in varchar2 default hr_api.g_varchar2
543: ,p_information19 in varchar2 default hr_api.g_varchar2
544: ,p_information20 in varchar2 default hr_api.g_varchar2
545: );
546: --
547: -- ----------------------------------------------------------------------------
540: ,p_information16 in varchar2 default hr_api.g_varchar2
541: ,p_information17 in varchar2 default hr_api.g_varchar2
542: ,p_information18 in varchar2 default hr_api.g_varchar2
543: ,p_information19 in varchar2 default hr_api.g_varchar2
544: ,p_information20 in varchar2 default hr_api.g_varchar2
545: );
546: --
547: -- ----------------------------------------------------------------------------
548: -- |------------------------<
615: * applicable during the start to end active date range. This date does not
616: * determine when the changes take effect.
617: * @param p_language_code Specifies to which language the translation values
618: * apply. You can set to the base or any installed language. The default value
619: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
620: * value.
621: * @param p_category Category name
622: * @param p_name Competence name
623: * @param p_date_from {@rep:casecolumn PER_COMPETENCES.DATE_FROM}
652: --
653: procedure create_or_update_competence
654: (p_validate in boolean default false
655: ,p_effective_date in date default trunc(sysdate)
656: ,p_language_code in varchar2 default hr_api.userenv_lang
657: ,p_category in varchar2 default null
658: ,p_name in varchar2 default null
659: ,p_date_from in date default trunc(sysdate)
660: ,p_date_to in date default null