eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_COMPETENCES_API dependencies on HR_API

Line 42: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

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}

Line 183: p_language_code in varchar2 default hr_api.userenv_lang ,

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,

Line 318: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

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.

Line 449: p_language_code in varchar2 default hr_api.userenv_lang ,

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,

Line 451: p_description in varchar2 default hr_api.g_varchar2,

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,

Line 452: p_date_from in date default hr_api.g_date,

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,

Line 453: p_date_to in date default hr_api.g_date,

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,

Line 454: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,

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,

Line 455: p_certification_required 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,

Line 456: p_evaluation_method 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,
460: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 457: p_renewal_period_frequency in number default hr_api.g_number,

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,

Line 458: p_renewal_period_units 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,

Line 459: p_rating_scale_id in number default hr_api.g_number,

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,

Line 460: p_attribute_category 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,

Line 461: p_attribute1 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,

Line 462: p_attribute2 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,

Line 463: p_attribute3 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,

Line 464: p_attribute4 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,

Line 465: p_attribute5 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,

Line 466: p_attribute6 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,

Line 467: p_attribute7 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,

Line 468: p_attribute8 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,

Line 469: p_attribute9 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,

Line 470: p_attribute10 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,

Line 471: p_attribute11 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,

Line 472: p_attribute12 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,

Line 473: p_attribute13 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,

Line 474: p_attribute14 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,

Line 475: p_attribute15 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,

Line 476: p_attribute16 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,

Line 477: p_attribute17 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,

Line 478: p_attribute18 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,

Line 479: p_attribute19 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,

Line 480: p_attribute20 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,

Line 481: p_competence_alias 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,

Line 482: p_segment1 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,

Line 483: p_segment2 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,

Line 484: p_segment3 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,

Line 485: p_segment4 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,

Line 486: p_segment5 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,

Line 487: p_segment6 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,

Line 488: p_segment7 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,

Line 489: p_segment8 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,

Line 490: p_segment9 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,

Line 491: p_segment10 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,

Line 492: p_segment11 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,

Line 493: p_segment12 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,

Line 494: p_segment13 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,

Line 495: p_segment14 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,

Line 496: p_segment15 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,

Line 497: p_segment16 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,

Line 498: p_segment17 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,

Line 499: p_segment18 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,

Line 500: p_segment19 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,

Line 501: p_segment20 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,

Line 502: p_segment21 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,

Line 503: p_segment22 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,

Line 504: p_segment23 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,

Line 505: p_segment24 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,

Line 506: p_segment25 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,

Line 507: p_segment26 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,

Line 508: p_segment27 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,

Line 509: p_segment28 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

Line 510: p_segment29 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
514: ,p_competence_cluster in varchar2 default hr_api.g_varchar2

Line 511: p_segment30 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

Line 512: p_concat_segments 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

Line 514: ,p_competence_cluster 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

Line 515: ,p_unit_standard_id 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

Line 516: ,p_credit_type 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
520: ,p_field in varchar2 default hr_api.g_varchar2

Line 517: ,p_credits in number default hr_api.g_number

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

Line 518: ,p_level_type 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

Line 519: ,p_level_number in number default hr_api.g_number

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

Line 520: ,p_field 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

Line 521: ,p_sub_field 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

Line 522: ,p_provider 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

Line 523: ,p_qa_organization 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

Line 524: ,p_information_category 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

Line 525: ,p_information1 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

Line 526: ,p_information2 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

Line 527: ,p_information3 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

Line 528: ,p_information4 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

Line 529: ,p_information5 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

Line 530: ,p_information6 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

Line 531: ,p_information7 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

Line 532: ,p_information8 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

Line 533: ,p_information9 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

Line 534: ,p_information10 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

Line 535: ,p_information11 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

Line 536: ,p_information12 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

Line 537: ,p_information13 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

Line 538: ,p_information14 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

Line 539: ,p_information15 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

Line 540: ,p_information16 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

Line 541: ,p_information17 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: );

Line 542: ,p_information18 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: );
546: --

Line 543: ,p_information19 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: --
547: -- ----------------------------------------------------------------------------

Line 544: ,p_information20 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: -- ----------------------------------------------------------------------------
548: -- |------------------------< >--------------------------|

Line 619: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

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}

Line 656: ,p_language_code in varchar2 default hr_api.userenv_lang

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