11: --
12: procedure create_qualification_type
13: (p_validate in boolean default false
14: ,p_effective_date in date
15: ,p_language_code in varchar2 default hr_api.userenv_lang
16: ,p_name in varchar2
17: ,p_category in varchar2
18: ,p_rank in number default null
19: ,p_attribute_category in varchar2 default null
186: ,p_provider => p_provider
187: ,p_qa_organization => p_qa_organization
188: );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'create_qualification_type'
193: ,p_hook_type => 'BP'
194: );
187: ,p_qa_organization => p_qa_organization
188: );
189: exception
190: when hr_api.cannot_find_prog_unit then
191: hr_api.cannot_find_prog_unit_error
192: (p_module_name => 'create_qualification_type'
193: ,p_hook_type => 'BP'
194: );
195:
210: -- instead of p_language_code from now on, to allow an IN OUT parameter to
211: -- be passed through.
212: --
213: l_language_code := p_language_code;
214: hr_api.validate_language_code(p_language_code => l_language_code);
215:
216: hr_utility.set_location(l_proc, 40);
217:
218: --
379: ,p_provider => p_provider
380: ,p_qa_organization => p_qa_organization
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'create_qualification_type'
386: ,p_hook_type => 'AP'
387: );
380: ,p_qa_organization => p_qa_organization
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'create_qualification_type'
386: ,p_hook_type => 'AP'
387: );
388:
397: -- When in validation only mode raise the Validate_Enabled exception
398: --
399: if p_validate
400: then
401: raise hr_api.validate_enabled;
402: end if;
403: --
404: hr_utility.set_location(l_proc, 80);
405: --
413:
414:
415: EXCEPTION
416: --
417: WHEN hr_api.validate_enabled THEN
418: --
419: -- As the Validate_Enabled exception has been raised
420: -- we must rollback to the savepoint
421: --
449: (p_validate in boolean default false
450: ,p_qualification_type_id in number
451: ,p_object_version_number in out nocopy number
452: ,p_effective_date in date
453: ,p_language_code in varchar2 default hr_api.userenv_lang
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_category in varchar2 default hr_api.g_varchar2
456: ,p_rank in number default hr_api.g_number
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
450: ,p_qualification_type_id in number
451: ,p_object_version_number in out nocopy number
452: ,p_effective_date in date
453: ,p_language_code in varchar2 default hr_api.userenv_lang
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_category in varchar2 default hr_api.g_varchar2
456: ,p_rank in number default hr_api.g_number
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
451: ,p_object_version_number in out nocopy number
452: ,p_effective_date in date
453: ,p_language_code in varchar2 default hr_api.userenv_lang
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_category in varchar2 default hr_api.g_varchar2
456: ,p_rank in number default hr_api.g_number
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
452: ,p_effective_date in date
453: ,p_language_code in varchar2 default hr_api.userenv_lang
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_category in varchar2 default hr_api.g_varchar2
456: ,p_rank in number default hr_api.g_number
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
453: ,p_language_code in varchar2 default hr_api.userenv_lang
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_category in varchar2 default hr_api.g_varchar2
456: ,p_rank in number default hr_api.g_number
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
454: ,p_name in varchar2 default hr_api.g_varchar2
455: ,p_category in varchar2 default hr_api.g_varchar2
456: ,p_rank in number default hr_api.g_number
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
455: ,p_category in varchar2 default hr_api.g_varchar2
456: ,p_rank in number default hr_api.g_number
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
456: ,p_rank in number default hr_api.g_number
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
457: ,p_attribute_category in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
458: ,p_attribute1 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
459: ,p_attribute2 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
461: ,p_attribute4 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
462: ,p_attribute5 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
463: ,p_attribute6 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
464: ,p_attribute7 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
465: ,p_attribute8 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
466: ,p_attribute9 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
467: ,p_attribute10 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
468: ,p_attribute11 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
469: ,p_attribute12 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
470: ,p_attribute13 in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
471: ,p_attribute14 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
472: ,p_attribute15 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
473: ,p_attribute16 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
474: ,p_attribute17 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
475: ,p_attribute18 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
476: ,p_attribute19 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
477: ,p_attribute20 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
478: ,p_information_category in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
479: ,p_information1 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
480: ,p_information2 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
481: ,p_information3 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
482: ,p_information4 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
483: ,p_information5 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
484: ,p_information6 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
485: ,p_information7 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
486: ,p_information8 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
487: ,p_information9 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
488: ,p_information10 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
489: ,p_information11 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
490: ,p_information12 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
491: ,p_information13 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
492: ,p_information14 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
493: ,p_information15 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
494: ,p_information16 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
502: ,p_information24 in varchar2 default hr_api.g_varchar2
495: ,p_information17 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
502: ,p_information24 in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
496: ,p_information18 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
502: ,p_information24 in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
497: ,p_information19 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
502: ,p_information24 in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
505: ,p_information27 in varchar2 default hr_api.g_varchar2
498: ,p_information20 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
502: ,p_information24 in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
505: ,p_information27 in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
499: ,p_information21 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
502: ,p_information24 in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
505: ,p_information27 in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
507: ,p_information29 in varchar2 default hr_api.g_varchar2
500: ,p_information22 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
502: ,p_information24 in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
505: ,p_information27 in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
507: ,p_information29 in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
501: ,p_information23 in varchar2 default hr_api.g_varchar2
502: ,p_information24 in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
505: ,p_information27 in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
507: ,p_information29 in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
502: ,p_information24 in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
505: ,p_information27 in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
507: ,p_information29 in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
503: ,p_information25 in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
505: ,p_information27 in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
507: ,p_information29 in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
504: ,p_information26 in varchar2 default hr_api.g_varchar2
505: ,p_information27 in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
507: ,p_information29 in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
512: ,p_credits in number default hr_api.g_number
505: ,p_information27 in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
507: ,p_information29 in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
512: ,p_credits in number default hr_api.g_number
513: ,p_level_type in varchar2 default hr_api.g_varchar2
506: ,p_information28 in varchar2 default hr_api.g_varchar2
507: ,p_information29 in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
512: ,p_credits in number default hr_api.g_number
513: ,p_level_type in varchar2 default hr_api.g_varchar2
514: ,p_level_number in number default hr_api.g_number
507: ,p_information29 in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
512: ,p_credits in number default hr_api.g_number
513: ,p_level_type in varchar2 default hr_api.g_varchar2
514: ,p_level_number in number default hr_api.g_number
515: ,p_field in varchar2 default hr_api.g_varchar2
508: ,p_information30 in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
512: ,p_credits in number default hr_api.g_number
513: ,p_level_type in varchar2 default hr_api.g_varchar2
514: ,p_level_number in number default hr_api.g_number
515: ,p_field in varchar2 default hr_api.g_varchar2
516: ,p_sub_field in varchar2 default hr_api.g_varchar2
509: ,p_qual_framework_id in number default hr_api.g_number
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
512: ,p_credits in number default hr_api.g_number
513: ,p_level_type in varchar2 default hr_api.g_varchar2
514: ,p_level_number in number default hr_api.g_number
515: ,p_field in varchar2 default hr_api.g_varchar2
516: ,p_sub_field in varchar2 default hr_api.g_varchar2
517: ,p_provider in varchar2 default hr_api.g_varchar2
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
512: ,p_credits in number default hr_api.g_number
513: ,p_level_type in varchar2 default hr_api.g_varchar2
514: ,p_level_number in number default hr_api.g_number
515: ,p_field in varchar2 default hr_api.g_varchar2
516: ,p_sub_field in varchar2 default hr_api.g_varchar2
517: ,p_provider in varchar2 default hr_api.g_varchar2
518: ,p_qa_organization in varchar2 default hr_api.g_varchar2
511: ,p_credit_type in varchar2 default hr_api.g_varchar2
512: ,p_credits in number default hr_api.g_number
513: ,p_level_type in varchar2 default hr_api.g_varchar2
514: ,p_level_number in number default hr_api.g_number
515: ,p_field in varchar2 default hr_api.g_varchar2
516: ,p_sub_field in varchar2 default hr_api.g_varchar2
517: ,p_provider in varchar2 default hr_api.g_varchar2
518: ,p_qa_organization in varchar2 default hr_api.g_varchar2
519: ) is
512: ,p_credits in number default hr_api.g_number
513: ,p_level_type in varchar2 default hr_api.g_varchar2
514: ,p_level_number in number default hr_api.g_number
515: ,p_field in varchar2 default hr_api.g_varchar2
516: ,p_sub_field in varchar2 default hr_api.g_varchar2
517: ,p_provider in varchar2 default hr_api.g_varchar2
518: ,p_qa_organization in varchar2 default hr_api.g_varchar2
519: ) is
520:
513: ,p_level_type in varchar2 default hr_api.g_varchar2
514: ,p_level_number in number default hr_api.g_number
515: ,p_field in varchar2 default hr_api.g_varchar2
516: ,p_sub_field in varchar2 default hr_api.g_varchar2
517: ,p_provider in varchar2 default hr_api.g_varchar2
518: ,p_qa_organization in varchar2 default hr_api.g_varchar2
519: ) is
520:
521: --
514: ,p_level_number in number default hr_api.g_number
515: ,p_field in varchar2 default hr_api.g_varchar2
516: ,p_sub_field in varchar2 default hr_api.g_varchar2
517: ,p_provider in varchar2 default hr_api.g_varchar2
518: ,p_qa_organization in varchar2 default hr_api.g_varchar2
519: ) is
520:
521: --
522: -- Declare cursors and local variables
632: ,p_qa_organization => p_qa_organization
633: ,p_object_version_number => l_object_version_number
634: );
635: exception
636: when hr_api.cannot_find_prog_unit then
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'update_qualification_type'
639: ,p_hook_type => 'BP'
640: );
633: ,p_object_version_number => l_object_version_number
634: );
635: exception
636: when hr_api.cannot_find_prog_unit then
637: hr_api.cannot_find_prog_unit_error
638: (p_module_name => 'update_qualification_type'
639: ,p_hook_type => 'BP'
640: );
641: --
655: -- instead of p_language_code from now on, to allow an IN OUT parameter to
656: -- be passed through.
657: --
658: l_language_code := p_language_code;
659: hr_api.validate_language_code(p_language_code => l_language_code);
660:
661: hr_utility.set_location(l_proc, 40);
662: --
663: --
828: ,p_qa_organization => p_qa_organization
829: ,p_object_version_number => l_object_version_number
830: );
831: exception
832: when hr_api.cannot_find_prog_unit then
833: hr_api.cannot_find_prog_unit_error
834: (p_module_name => 'update_qualification_type'
835: ,p_hook_type => 'AP'
836: );
829: ,p_object_version_number => l_object_version_number
830: );
831: exception
832: when hr_api.cannot_find_prog_unit then
833: hr_api.cannot_find_prog_unit_error
834: (p_module_name => 'update_qualification_type'
835: ,p_hook_type => 'AP'
836: );
837: --
842: hr_utility.set_location(l_proc, 70);
843:
844: if p_validate
845: then
846: raise hr_api.validate_enabled;
847: end if;
848: --
849: hr_utility.set_location(l_proc, 80);
850: --
855: hr_utility.set_location(' Leaving:' ||l_proc, 90);
856: --
857: exception
858: --
859: when hr_api.validate_enabled then
860: --
861: -- As the Validate_Enabled exception has been raised
862: -- we must rollback to the savepoint
863: --
933: (p_qualification_type_id => p_qualification_type_id
934: ,p_object_version_number => l_object_version_number
935: );
936: exception
937: when hr_api.cannot_find_prog_unit then
938: hr_api.cannot_find_prog_unit_error
939: (p_module_name => 'DELETE_QUALIFICATION_TYPE'
940: ,p_hook_type => 'BP'
941: );
934: ,p_object_version_number => l_object_version_number
935: );
936: exception
937: when hr_api.cannot_find_prog_unit then
938: hr_api.cannot_find_prog_unit_error
939: (p_module_name => 'DELETE_QUALIFICATION_TYPE'
940: ,p_hook_type => 'BP'
941: );
942: end;
971: (p_qualification_type_id => p_qualification_type_id
972: ,p_object_version_number => l_object_version_number
973: );
974: exception
975: when hr_api.cannot_find_prog_unit then
976: hr_api.cannot_find_prog_unit_error
977: (p_module_name => 'DELETE_QUALIFICATION_TYPE'
978: ,p_hook_type => 'AP'
979: );
972: ,p_object_version_number => l_object_version_number
973: );
974: exception
975: when hr_api.cannot_find_prog_unit then
976: hr_api.cannot_find_prog_unit_error
977: (p_module_name => 'DELETE_QUALIFICATION_TYPE'
978: ,p_hook_type => 'AP'
979: );
980: end;
985: --
986: -- When in validation only mode raise the Validate_Enabled exception
987: --
988: if p_validate then
989: raise hr_api.validate_enabled;
990: end if;
991:
992: --
993: -- Set all output arguments (returned by some dt modes only)
996:
997: hr_utility.set_location(' Leaving:'||l_proc, 70);
998:
999: exception
1000: when hr_api.validate_enabled then
1001: hr_utility.set_location(' Leaving...:'||l_proc, 80);
1002: --
1003: -- As the Validate_Enabled exception has been raised
1004: -- we must rollback to the savepoint