12: -- ngundura business group id made an optional parameter.
13: procedure create_competence
14: (p_validate in boolean default false,
15: p_effective_date in date,
16: p_language_code in varchar2 default hr_api.userenv_lang,
17: p_business_group_id in number default null,
18: p_description in varchar2 default null,
19: p_competence_alias in varchar2 default null,
20: p_date_from in date,
224: --
225: -- Issue a savepoint.
226: --
227: if p_business_group_id is not null then
228: hr_api.validate_bus_grp_id(p_business_group_id);
229: end if;
230: --
231: savepoint create_competence;
232:
234: -- instead of p_language_code from now on, to allow an IN OUT parameter to
235: -- be passed through.
236: --
237: l_language_code := p_language_code;
238: hr_api.validate_language_code(p_language_code => l_language_code);
239:
240: hr_utility.set_location(l_proc, 6);
241: -- ngundura global competence allowed only if cross business group
242: -- profile is set
256: else
257: l_flex_num := fnd_profile.value('HR_GLOBAL_COMPETENCE');
258: end if;
259: --
260: if nvl(l_flex_num,hr_api.g_number) = hr_api.g_number
261: then
262: hr_utility.set_message(801,'HR_6035_ALL_INVALID_KEYFLEX');
263: hr_utility.raise_error;
264: end if;
431: p_information20 => p_information20
432: );
433: hr_utility.set_location('hr_competences_bk1.create_competence_b',999);
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'create_competence',
438: p_hook_type => 'BP'
439: );
432: );
433: hr_utility.set_location('hr_competences_bk1.create_competence_b',999);
434: exception
435: when hr_api.cannot_find_prog_unit then
436: hr_api.cannot_find_prog_unit_error
437: (p_module_name => 'create_competence',
438: p_hook_type => 'BP'
439: );
440: end;
687: ,p_information19 => p_information19
688: ,p_information20 => p_information20
689: );
690: exception
691: when hr_api.cannot_find_prog_unit then
692: hr_api.cannot_find_prog_unit_error
693: (p_module_name => 'create_competence',
694: p_hook_type => 'AP'
695: );
688: ,p_information20 => p_information20
689: );
690: exception
691: when hr_api.cannot_find_prog_unit then
692: hr_api.cannot_find_prog_unit_error
693: (p_module_name => 'create_competence',
694: p_hook_type => 'AP'
695: );
696: end;
699: --
700: -- When in validation only mode raise the Validate_Enabled exception
701: --
702: if p_validate then
703: raise hr_api.validate_enabled;
704: end if;
705: --
706: -- Set all output arguments
707: --
711: p_name := l_name;
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 11);
714: exception
715: when hr_api.validate_enabled then
716: --
717: -- As the Validate_Enabled exception has been raised
718: -- we must rollback to the savepoint
719: --
762: (p_validate in boolean default false,
763: p_effective_date in date,
764: p_competence_id in number,
765: p_object_version_number in out nocopy number,
766: p_language_code in varchar2 default hr_api.userenv_lang,
767: p_name out nocopy varchar2 ,
768: p_description in varchar2 default hr_api.g_varchar2,
769: p_date_from in date default hr_api.g_date,
770: p_date_to in date default hr_api.g_date,
764: p_competence_id in number,
765: p_object_version_number in out nocopy number,
766: p_language_code in varchar2 default hr_api.userenv_lang,
767: p_name out nocopy varchar2 ,
768: p_description in varchar2 default hr_api.g_varchar2,
769: p_date_from in date default hr_api.g_date,
770: p_date_to in date default hr_api.g_date,
771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
765: p_object_version_number in out nocopy number,
766: p_language_code in varchar2 default hr_api.userenv_lang,
767: p_name out nocopy varchar2 ,
768: p_description in varchar2 default hr_api.g_varchar2,
769: p_date_from in date default hr_api.g_date,
770: p_date_to in date default hr_api.g_date,
771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
766: p_language_code in varchar2 default hr_api.userenv_lang,
767: p_name out nocopy varchar2 ,
768: p_description in varchar2 default hr_api.g_varchar2,
769: p_date_from in date default hr_api.g_date,
770: p_date_to in date default hr_api.g_date,
771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
767: p_name out nocopy varchar2 ,
768: p_description in varchar2 default hr_api.g_varchar2,
769: p_date_from in date default hr_api.g_date,
770: p_date_to in date default hr_api.g_date,
771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
768: p_description in varchar2 default hr_api.g_varchar2,
769: p_date_from in date default hr_api.g_date,
770: p_date_to in date default hr_api.g_date,
771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
769: p_date_from in date default hr_api.g_date,
770: p_date_to in date default hr_api.g_date,
771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
770: p_date_to in date default hr_api.g_date,
771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
772: p_certification_required in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
773: p_evaluation_method in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
774: p_renewal_period_frequency in number default hr_api.g_number,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
775: p_renewal_period_units in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
776: p_rating_scale_id in number default hr_api.g_number,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
777: p_attribute_category in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
778: p_attribute1 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
779: p_attribute2 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
780: p_attribute3 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
781: p_attribute4 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
782: p_attribute5 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
783: p_attribute6 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
784: p_attribute7 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
785: p_attribute8 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
786: p_attribute9 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
787: p_attribute10 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
788: p_attribute11 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
789: p_attribute12 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
790: p_attribute13 in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
791: p_attribute14 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
792: p_attribute15 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
793: p_attribute16 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
794: p_attribute17 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
795: p_attribute18 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
796: p_attribute19 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
797: p_attribute20 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
798: p_competence_alias in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
799: p_segment1 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
800: p_segment2 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
801: p_segment3 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
802: p_segment4 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
803: p_segment5 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
804: p_segment6 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
805: p_segment7 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
806: p_segment8 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
807: p_segment9 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
808: p_segment10 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
809: p_segment11 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
810: p_segment12 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
811: p_segment13 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
812: p_segment14 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
813: p_segment15 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
814: p_segment16 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
815: p_segment17 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
823: p_segment25 in varchar2 default hr_api.g_varchar2,
816: p_segment18 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
823: p_segment25 in varchar2 default hr_api.g_varchar2,
824: p_segment26 in varchar2 default hr_api.g_varchar2,
817: p_segment19 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
823: p_segment25 in varchar2 default hr_api.g_varchar2,
824: p_segment26 in varchar2 default hr_api.g_varchar2,
825: p_segment27 in varchar2 default hr_api.g_varchar2,
818: p_segment20 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
823: p_segment25 in varchar2 default hr_api.g_varchar2,
824: p_segment26 in varchar2 default hr_api.g_varchar2,
825: p_segment27 in varchar2 default hr_api.g_varchar2,
826: p_segment28 in varchar2 default hr_api.g_varchar2,
819: p_segment21 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
823: p_segment25 in varchar2 default hr_api.g_varchar2,
824: p_segment26 in varchar2 default hr_api.g_varchar2,
825: p_segment27 in varchar2 default hr_api.g_varchar2,
826: p_segment28 in varchar2 default hr_api.g_varchar2,
827: p_segment29 in varchar2 default hr_api.g_varchar2,
820: p_segment22 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
823: p_segment25 in varchar2 default hr_api.g_varchar2,
824: p_segment26 in varchar2 default hr_api.g_varchar2,
825: p_segment27 in varchar2 default hr_api.g_varchar2,
826: p_segment28 in varchar2 default hr_api.g_varchar2,
827: p_segment29 in varchar2 default hr_api.g_varchar2,
828: p_segment30 in varchar2 default hr_api.g_varchar2,
821: p_segment23 in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
823: p_segment25 in varchar2 default hr_api.g_varchar2,
824: p_segment26 in varchar2 default hr_api.g_varchar2,
825: p_segment27 in varchar2 default hr_api.g_varchar2,
826: p_segment28 in varchar2 default hr_api.g_varchar2,
827: p_segment29 in varchar2 default hr_api.g_varchar2,
828: p_segment30 in varchar2 default hr_api.g_varchar2,
829: p_concat_segments in varchar2 default hr_api.g_varchar2,
822: p_segment24 in varchar2 default hr_api.g_varchar2,
823: p_segment25 in varchar2 default hr_api.g_varchar2,
824: p_segment26 in varchar2 default hr_api.g_varchar2,
825: p_segment27 in varchar2 default hr_api.g_varchar2,
826: p_segment28 in varchar2 default hr_api.g_varchar2,
827: p_segment29 in varchar2 default hr_api.g_varchar2,
828: p_segment30 in varchar2 default hr_api.g_varchar2,
829: p_concat_segments in varchar2 default hr_api.g_varchar2,
830: --
823: p_segment25 in varchar2 default hr_api.g_varchar2,
824: p_segment26 in varchar2 default hr_api.g_varchar2,
825: p_segment27 in varchar2 default hr_api.g_varchar2,
826: p_segment28 in varchar2 default hr_api.g_varchar2,
827: p_segment29 in varchar2 default hr_api.g_varchar2,
828: p_segment30 in varchar2 default hr_api.g_varchar2,
829: p_concat_segments in varchar2 default hr_api.g_varchar2,
830: --
831: -- bug 2267635 change p_competence_definition_id from an out to an in/out
824: p_segment26 in varchar2 default hr_api.g_varchar2,
825: p_segment27 in varchar2 default hr_api.g_varchar2,
826: p_segment28 in varchar2 default hr_api.g_varchar2,
827: p_segment29 in varchar2 default hr_api.g_varchar2,
828: p_segment30 in varchar2 default hr_api.g_varchar2,
829: p_concat_segments in varchar2 default hr_api.g_varchar2,
830: --
831: -- bug 2267635 change p_competence_definition_id from an out to an in/out
832: -- parameter to enable value to be passed into program when known and required
825: p_segment27 in varchar2 default hr_api.g_varchar2,
826: p_segment28 in varchar2 default hr_api.g_varchar2,
827: p_segment29 in varchar2 default hr_api.g_varchar2,
828: p_segment30 in varchar2 default hr_api.g_varchar2,
829: p_concat_segments in varchar2 default hr_api.g_varchar2,
830: --
831: -- bug 2267635 change p_competence_definition_id from an out to an in/out
832: -- parameter to enable value to be passed into program when known and required
833: --
834: p_competence_definition_id in out nocopy number
835: --
836: -- BUG3356369 Added unit standard qualification framework
837: --
838: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
839: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
840: ,p_credit_type in varchar2 default hr_api.g_varchar2
841: ,p_credits in number default hr_api.g_number
842: ,p_level_type in varchar2 default hr_api.g_varchar2
835: --
836: -- BUG3356369 Added unit standard qualification framework
837: --
838: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
839: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
840: ,p_credit_type in varchar2 default hr_api.g_varchar2
841: ,p_credits in number default hr_api.g_number
842: ,p_level_type in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
836: -- BUG3356369 Added unit standard qualification framework
837: --
838: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
839: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
840: ,p_credit_type in varchar2 default hr_api.g_varchar2
841: ,p_credits in number default hr_api.g_number
842: ,p_level_type in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
844: ,p_field in varchar2 default hr_api.g_varchar2
837: --
838: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
839: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
840: ,p_credit_type in varchar2 default hr_api.g_varchar2
841: ,p_credits in number default hr_api.g_number
842: ,p_level_type in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
844: ,p_field in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
838: ,p_competence_cluster in varchar2 default hr_api.g_varchar2
839: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
840: ,p_credit_type in varchar2 default hr_api.g_varchar2
841: ,p_credits in number default hr_api.g_number
842: ,p_level_type in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
844: ,p_field in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
839: ,p_unit_standard_id in varchar2 default hr_api.g_varchar2
840: ,p_credit_type in varchar2 default hr_api.g_varchar2
841: ,p_credits in number default hr_api.g_number
842: ,p_level_type in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
844: ,p_field in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
840: ,p_credit_type in varchar2 default hr_api.g_varchar2
841: ,p_credits in number default hr_api.g_number
842: ,p_level_type in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
844: ,p_field in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
841: ,p_credits in number default hr_api.g_number
842: ,p_level_type in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
844: ,p_field in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
842: ,p_level_type in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
844: ,p_field in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
843: ,p_level_number in number default hr_api.g_number
844: ,p_field in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
844: ,p_field in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
845: ,p_sub_field in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
846: ,p_provider in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
847: ,p_qa_organization in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
848: ,p_information_category in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
849: ,p_information1 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
850: ,p_information2 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
851: ,p_information3 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
852: ,p_information4 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
853: ,p_information5 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
854: ,p_information6 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
862: ,p_information14 in varchar2 default hr_api.g_varchar2
855: ,p_information7 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
862: ,p_information14 in varchar2 default hr_api.g_varchar2
863: ,p_information15 in varchar2 default hr_api.g_varchar2
856: ,p_information8 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
862: ,p_information14 in varchar2 default hr_api.g_varchar2
863: ,p_information15 in varchar2 default hr_api.g_varchar2
864: ,p_information16 in varchar2 default hr_api.g_varchar2
857: ,p_information9 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
862: ,p_information14 in varchar2 default hr_api.g_varchar2
863: ,p_information15 in varchar2 default hr_api.g_varchar2
864: ,p_information16 in varchar2 default hr_api.g_varchar2
865: ,p_information17 in varchar2 default hr_api.g_varchar2
858: ,p_information10 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
862: ,p_information14 in varchar2 default hr_api.g_varchar2
863: ,p_information15 in varchar2 default hr_api.g_varchar2
864: ,p_information16 in varchar2 default hr_api.g_varchar2
865: ,p_information17 in varchar2 default hr_api.g_varchar2
866: ,p_information18 in varchar2 default hr_api.g_varchar2
859: ,p_information11 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
862: ,p_information14 in varchar2 default hr_api.g_varchar2
863: ,p_information15 in varchar2 default hr_api.g_varchar2
864: ,p_information16 in varchar2 default hr_api.g_varchar2
865: ,p_information17 in varchar2 default hr_api.g_varchar2
866: ,p_information18 in varchar2 default hr_api.g_varchar2
867: ,p_information19 in varchar2 default hr_api.g_varchar2
860: ,p_information12 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
862: ,p_information14 in varchar2 default hr_api.g_varchar2
863: ,p_information15 in varchar2 default hr_api.g_varchar2
864: ,p_information16 in varchar2 default hr_api.g_varchar2
865: ,p_information17 in varchar2 default hr_api.g_varchar2
866: ,p_information18 in varchar2 default hr_api.g_varchar2
867: ,p_information19 in varchar2 default hr_api.g_varchar2
868: ,p_information20 in varchar2 default hr_api.g_varchar2
861: ,p_information13 in varchar2 default hr_api.g_varchar2
862: ,p_information14 in varchar2 default hr_api.g_varchar2
863: ,p_information15 in varchar2 default hr_api.g_varchar2
864: ,p_information16 in varchar2 default hr_api.g_varchar2
865: ,p_information17 in varchar2 default hr_api.g_varchar2
866: ,p_information18 in varchar2 default hr_api.g_varchar2
867: ,p_information19 in varchar2 default hr_api.g_varchar2
868: ,p_information20 in varchar2 default hr_api.g_varchar2
869: ) is
862: ,p_information14 in varchar2 default hr_api.g_varchar2
863: ,p_information15 in varchar2 default hr_api.g_varchar2
864: ,p_information16 in varchar2 default hr_api.g_varchar2
865: ,p_information17 in varchar2 default hr_api.g_varchar2
866: ,p_information18 in varchar2 default hr_api.g_varchar2
867: ,p_information19 in varchar2 default hr_api.g_varchar2
868: ,p_information20 in varchar2 default hr_api.g_varchar2
869: ) is
870: --
863: ,p_information15 in varchar2 default hr_api.g_varchar2
864: ,p_information16 in varchar2 default hr_api.g_varchar2
865: ,p_information17 in varchar2 default hr_api.g_varchar2
866: ,p_information18 in varchar2 default hr_api.g_varchar2
867: ,p_information19 in varchar2 default hr_api.g_varchar2
868: ,p_information20 in varchar2 default hr_api.g_varchar2
869: ) is
870: --
871: -- Declare cursors and local variables
864: ,p_information16 in varchar2 default hr_api.g_varchar2
865: ,p_information17 in varchar2 default hr_api.g_varchar2
866: ,p_information18 in varchar2 default hr_api.g_varchar2
867: ,p_information19 in varchar2 default hr_api.g_varchar2
868: ,p_information20 in varchar2 default hr_api.g_varchar2
869: ) is
870: --
871: -- Declare cursors and local variables
872: --
1044: end if;
1045: --
1046:
1047: l_language_code := p_language_code;
1048: hr_api.validate_language_code(p_language_code => l_language_code);
1049:
1050: -- Call Before Process User Hook
1051: --
1052: begin
1149: ,p_information19 => p_information19
1150: ,p_information20 => p_information20
1151: );
1152: exception
1153: when hr_api.cannot_find_prog_unit then
1154: hr_api.cannot_find_prog_unit_error
1155: (p_module_name => 'update_competence',
1156: p_hook_type => 'BP'
1157: );
1150: ,p_information20 => p_information20
1151: );
1152: exception
1153: when hr_api.cannot_find_prog_unit then
1154: hr_api.cannot_find_prog_unit_error
1155: (p_module_name => 'update_competence',
1156: p_hook_type => 'BP'
1157: );
1158: end;
1451: ,p_information19 => p_information19
1452: ,p_information20 => p_information20
1453: );
1454: exception
1455: when hr_api.cannot_find_prog_unit then
1456: hr_api.cannot_find_prog_unit_error
1457: (p_module_name => 'update_competence',
1458: p_hook_type => 'AP'
1459: );
1452: ,p_information20 => p_information20
1453: );
1454: exception
1455: when hr_api.cannot_find_prog_unit then
1456: hr_api.cannot_find_prog_unit_error
1457: (p_module_name => 'update_competence',
1458: p_hook_type => 'AP'
1459: );
1460: end;
1463: --
1464: -- When in validation only mode raise the Validate_Enabled exception
1465: --
1466: if p_validate then
1467: raise hr_api.validate_enabled;
1468: end if;
1469: --
1470: -- Set all output arguments. l_object_version_number now has the new
1471: -- object version number as the update was successful
1476: --
1477: hr_utility.set_location(p_concat_segments, 694);
1478: hr_utility.set_location(' Leaving:'||l_proc, 12);
1479: exception
1480: when hr_api.validate_enabled then
1481: --
1482: -- As the Validate_Enabled exception has been raised
1483: -- we must rollback to the savepoint
1484: --
1552: p_competence_id => p_competence_id,
1553: p_object_version_number => p_object_version_number
1554: );
1555: exception
1556: when hr_api.cannot_find_prog_unit then
1557: hr_api.cannot_find_prog_unit_error
1558: (p_module_name => 'delete_competence',
1559: p_hook_type => 'BP'
1560: );
1553: p_object_version_number => p_object_version_number
1554: );
1555: exception
1556: when hr_api.cannot_find_prog_unit then
1557: hr_api.cannot_find_prog_unit_error
1558: (p_module_name => 'delete_competence',
1559: p_hook_type => 'BP'
1560: );
1561: end;
1604: p_competence_id => p_competence_id,
1605: p_object_version_number => p_object_version_number
1606: );
1607: exception
1608: when hr_api.cannot_find_prog_unit then
1609: hr_api.cannot_find_prog_unit_error
1610: (p_module_name => 'delete_competence',
1611: p_hook_type => 'AP'
1612: );
1605: p_object_version_number => p_object_version_number
1606: );
1607: exception
1608: when hr_api.cannot_find_prog_unit then
1609: hr_api.cannot_find_prog_unit_error
1610: (p_module_name => 'delete_competence',
1611: p_hook_type => 'AP'
1612: );
1613: end;
1616: --
1617: -- When in validation only mode raise the Validate_Enabled exception
1618: --
1619: if p_validate then
1620: raise hr_api.validate_enabled;
1621: end if;
1622: --
1623: hr_utility.set_location(' Leaving:'||l_proc, 11);
1624: exception
1621: end if;
1622: --
1623: hr_utility.set_location(' Leaving:'||l_proc, 11);
1624: exception
1625: when hr_api.validate_enabled then
1626: --
1627: -- As the Validate_Enabled exception has been raised
1628: -- we must rollback to the savepoint
1629: --
1650: --
1651: procedure create_or_update_competence
1652: (p_validate in boolean default false
1653: ,p_effective_date in date default trunc(sysdate)
1654: ,p_language_code in varchar2 default hr_api.userenv_lang
1655: ,p_category in varchar2 default null
1656: ,p_name in varchar2 default null
1657: ,p_date_from in date default trunc(sysdate)
1658: ,p_date_to in date default null
1748:
1749: hr_competences_api.g_ignore_df := 'Y';
1750:
1751: if (p_language_code is NULL) then
1752: l_language_code := hr_api.userenv_lang;
1753: else
1754: l_language_code := p_language_code;
1755: -- BUG3668368
1756: hr_api.validate_language_code(p_language_code => l_language_code);
1752: l_language_code := hr_api.userenv_lang;
1753: else
1754: l_language_code := p_language_code;
1755: -- BUG3668368
1756: hr_api.validate_language_code(p_language_code => l_language_code);
1757: end if;
1758:
1759: if (p_effective_date is NULL) then
1760: l_effective_date := trunc(sysdate);
1923: hr_utility.trace('l_source_competence_id : ' || l_source_competence_id);
1924: hr_utility.trace('l_source_ovn : ' || l_source_ovn);
1925:
1926: l_translated_language := p_translated_language;
1927: hr_api.validate_language_code(p_language_code => l_translated_language);
1928:
1929: --
1930: -- MLS Processing
1931: --
2047: ,p_information19 => NULL
2048: ,p_information20 => NULL
2049: );
2050: exception
2051: when hr_api.cannot_find_prog_unit then
2052: hr_competences_api.g_ignore_df := 'N';
2053: hr_api.cannot_find_prog_unit_error
2054: (p_module_name => 'update_competence',
2055: p_hook_type => 'AP'
2049: );
2050: exception
2051: when hr_api.cannot_find_prog_unit then
2052: hr_competences_api.g_ignore_df := 'N';
2053: hr_api.cannot_find_prog_unit_error
2054: (p_module_name => 'update_competence',
2055: p_hook_type => 'AP'
2056: );
2057: end;
2059: END IF;
2060: hr_competences_api.g_ignore_df := 'N';
2061: hr_utility.set_location('Leaving... ' || l_proc,70);
2062: exception
2063: when hr_api.validate_enabled then
2064: --
2065: -- As the Validate_Enabled exception has been raised
2066: -- we must rollback to the savepoint
2067: --