DBA Data[Home] [Help]

APPS.HR_QUALIFICATION_TYPE_API dependencies on HR_API

Line 15: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 190: when hr_api.cannot_find_prog_unit then

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

Line 191: hr_api.cannot_find_prog_unit_error

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:

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

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

Line 383: when hr_api.cannot_find_prog_unit then

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

Line 384: hr_api.cannot_find_prog_unit_error

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:

Line 401: raise hr_api.validate_enabled;

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

Line 417: WHEN hr_api.validate_enabled THEN

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

Line 453: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 454: ,p_name 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

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

Line 456: ,p_rank in number default hr_api.g_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
460: ,p_attribute3 in varchar2 default hr_api.g_varchar2

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 506: ,p_information28 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
510: ,p_qualification_type in varchar2 default hr_api.g_varchar2

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

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

Line 509: ,p_qual_framework_id 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

Line 510: ,p_qualification_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

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

Line 512: ,p_credits in number default hr_api.g_number

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

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

Line 514: ,p_level_number 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
518: ,p_qa_organization in varchar2 default hr_api.g_varchar2

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

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

Line 517: ,p_provider in varchar2 default hr_api.g_varchar2

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

Line 518: ,p_qa_organization 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: --
522: -- Declare cursors and local variables

Line 636: when hr_api.cannot_find_prog_unit then

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

Line 637: hr_api.cannot_find_prog_unit_error

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

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

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

Line 832: when hr_api.cannot_find_prog_unit then

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

Line 833: hr_api.cannot_find_prog_unit_error

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

Line 846: raise hr_api.validate_enabled;

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

Line 859: when hr_api.validate_enabled then

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

Line 937: when hr_api.cannot_find_prog_unit then

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

Line 938: hr_api.cannot_find_prog_unit_error

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;

Line 975: when hr_api.cannot_find_prog_unit then

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

Line 976: hr_api.cannot_find_prog_unit_error

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;

Line 989: raise hr_api.validate_enabled;

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)

Line 1000: when hr_api.validate_enabled then

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