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 16: p_language_code in varchar2 default hr_api.userenv_lang,

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,

Line 228: hr_api.validate_bus_grp_id(p_business_group_id);

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:

Line 238: hr_api.validate_language_code(p_language_code => l_language_code);

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

Line 260: if nvl(l_flex_num,hr_api.g_number) = hr_api.g_number

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;

Line 435: when hr_api.cannot_find_prog_unit then

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: );

Line 436: hr_api.cannot_find_prog_unit_error

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;

Line 691: when hr_api.cannot_find_prog_unit then

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: );

Line 692: hr_api.cannot_find_prog_unit_error

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;

Line 703: raise hr_api.validate_enabled;

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: --

Line 715: when hr_api.validate_enabled then

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: --

Line 766: p_language_code in varchar2 default hr_api.userenv_lang,

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,

Line 768: p_description in varchar2 default hr_api.g_varchar2,

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,

Line 769: p_date_from in date default hr_api.g_date,

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,

Line 770: p_date_to in date default hr_api.g_date,

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,

Line 771: p_behavioural_indicator in varchar2 default hr_api.g_varchar2,

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,

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

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

Line 774: p_renewal_period_frequency in number default hr_api.g_number,

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,

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

Line 776: p_rating_scale_id in number default hr_api.g_number,

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 827: p_segment29 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: --
831: -- bug 2267635 change p_competence_definition_id from an out to an in/out

Line 828: p_segment30 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
832: -- parameter to enable value to be passed into program when known and required

Line 829: p_concat_segments 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
833: --

Line 838: ,p_competence_cluster in varchar2 default hr_api.g_varchar2

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

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

Line 840: ,p_credit_type in varchar2 default hr_api.g_varchar2

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

Line 841: ,p_credits in number default hr_api.g_number

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

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

Line 843: ,p_level_number in number default hr_api.g_number

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 865: ,p_information17 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

Line 866: ,p_information18 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
870: --

Line 867: ,p_information19 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: --
871: -- Declare cursors and local variables

Line 868: ,p_information20 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
872: --

Line 1048: hr_api.validate_language_code(p_language_code => l_language_code);

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

Line 1153: when hr_api.cannot_find_prog_unit then

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: );

Line 1154: hr_api.cannot_find_prog_unit_error

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;

Line 1455: when hr_api.cannot_find_prog_unit then

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: );

Line 1456: hr_api.cannot_find_prog_unit_error

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;

Line 1467: raise hr_api.validate_enabled;

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

Line 1480: when hr_api.validate_enabled then

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: --

Line 1556: when hr_api.cannot_find_prog_unit then

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: );

Line 1557: hr_api.cannot_find_prog_unit_error

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;

Line 1608: when hr_api.cannot_find_prog_unit then

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: );

Line 1609: hr_api.cannot_find_prog_unit_error

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;

Line 1620: raise hr_api.validate_enabled;

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

Line 1625: when hr_api.validate_enabled then

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: --

Line 1654: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 1752: l_language_code := hr_api.userenv_lang;

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);

Line 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);

Line 1927: hr_api.validate_language_code(p_language_code => l_translated_language);

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: --

Line 2051: when hr_api.cannot_find_prog_unit then

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'

Line 2053: hr_api.cannot_find_prog_unit_error

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;

Line 2063: when hr_api.validate_enabled then

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: --