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.PER_HIERARCHY_VERSIONS_API dependencies on HR_API

Line 220: when hr_api.cannot_find_prog_unit then

216: ,p_information30 => p_information30
217: ,p_effective_date => trunc(p_effective_date)
218: );
219: exception
220: when hr_api.cannot_find_prog_unit then
221: hr_api.cannot_find_prog_unit_error
222: (
223: p_module_name => 'CREATE_hierarchy_versions'
224: ,p_hook_type => 'BP'

Line 221: hr_api.cannot_find_prog_unit_error

217: ,p_effective_date => trunc(p_effective_date)
218: );
219: exception
220: when hr_api.cannot_find_prog_unit then
221: hr_api.cannot_find_prog_unit_error
222: (
223: p_module_name => 'CREATE_hierarchy_versions'
224: ,p_hook_type => 'BP'
225: );

Line 395: when hr_api.cannot_find_prog_unit then

391: ,p_information30 => p_information30
392: ,p_effective_date => trunc(p_effective_date)
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'CREATE_hierarchy_versions'
398: ,p_hook_type => 'AP'
399: );

Line 396: hr_api.cannot_find_prog_unit_error

392: ,p_effective_date => trunc(p_effective_date)
393: );
394: exception
395: when hr_api.cannot_find_prog_unit then
396: hr_api.cannot_find_prog_unit_error
397: (p_module_name => 'CREATE_hierarchy_versions'
398: ,p_hook_type => 'AP'
399: );
400: --

Line 410: raise hr_api.validate_enabled;

406: --
407: -- When in validation only mode raise the Validate_Enabled exception
408: --
409: if p_validate then
410: raise hr_api.validate_enabled;
411: end if;
412: --
413: -- Set all output arguments
414: --

Line 422: when hr_api.validate_enabled then

418: hr_utility.set_location(' Leaving:'||l_proc, 70);
419: --
420: exception
421: --
422: when hr_api.validate_enabled then
423: --
424: -- As the Validate_Enabled exception has been raised
425: -- we must rollback to the savepoint
426: --

Line 454: ,p_version_number in number default hr_api.g_number

450: --
451: procedure update_hierarchy_versions
452: (p_validate in boolean default false
453: ,p_hierarchy_version_id in number
454: ,p_version_number in number default hr_api.g_number
455: ,p_date_from in date default hr_api.g_date
456: ,p_date_to in date default hr_api.g_date
457: ,p_status in varchar2 default hr_api.g_varchar2
458: ,p_validate_flag in varchar2 default hr_api.g_varchar2

Line 455: ,p_date_from in date default hr_api.g_date

451: procedure update_hierarchy_versions
452: (p_validate in boolean default false
453: ,p_hierarchy_version_id in number
454: ,p_version_number in number default hr_api.g_number
455: ,p_date_from in date default hr_api.g_date
456: ,p_date_to in date default hr_api.g_date
457: ,p_status in varchar2 default hr_api.g_varchar2
458: ,p_validate_flag in varchar2 default hr_api.g_varchar2
459: ,p_request_id in number default hr_api.g_number

Line 456: ,p_date_to in date default hr_api.g_date

452: (p_validate in boolean default false
453: ,p_hierarchy_version_id in number
454: ,p_version_number in number default hr_api.g_number
455: ,p_date_from in date default hr_api.g_date
456: ,p_date_to in date default hr_api.g_date
457: ,p_status in varchar2 default hr_api.g_varchar2
458: ,p_validate_flag in varchar2 default hr_api.g_varchar2
459: ,p_request_id in number default hr_api.g_number
460: ,p_program_application_id in number default hr_api.g_number

Line 457: ,p_status in varchar2 default hr_api.g_varchar2

453: ,p_hierarchy_version_id in number
454: ,p_version_number in number default hr_api.g_number
455: ,p_date_from in date default hr_api.g_date
456: ,p_date_to in date default hr_api.g_date
457: ,p_status in varchar2 default hr_api.g_varchar2
458: ,p_validate_flag in varchar2 default hr_api.g_varchar2
459: ,p_request_id in number default hr_api.g_number
460: ,p_program_application_id in number default hr_api.g_number
461: ,p_program_id in number default hr_api.g_number

Line 458: ,p_validate_flag in varchar2 default hr_api.g_varchar2

454: ,p_version_number in number default hr_api.g_number
455: ,p_date_from in date default hr_api.g_date
456: ,p_date_to in date default hr_api.g_date
457: ,p_status in varchar2 default hr_api.g_varchar2
458: ,p_validate_flag in varchar2 default hr_api.g_varchar2
459: ,p_request_id in number default hr_api.g_number
460: ,p_program_application_id in number default hr_api.g_number
461: ,p_program_id in number default hr_api.g_number
462: ,p_program_update_date in date default hr_api.g_date

Line 459: ,p_request_id in number default hr_api.g_number

455: ,p_date_from in date default hr_api.g_date
456: ,p_date_to in date default hr_api.g_date
457: ,p_status in varchar2 default hr_api.g_varchar2
458: ,p_validate_flag in varchar2 default hr_api.g_varchar2
459: ,p_request_id in number default hr_api.g_number
460: ,p_program_application_id in number default hr_api.g_number
461: ,p_program_id in number default hr_api.g_number
462: ,p_program_update_date in date default hr_api.g_date
463: ,p_object_version_number in out nocopy number

Line 460: ,p_program_application_id in number default hr_api.g_number

456: ,p_date_to in date default hr_api.g_date
457: ,p_status in varchar2 default hr_api.g_varchar2
458: ,p_validate_flag in varchar2 default hr_api.g_varchar2
459: ,p_request_id in number default hr_api.g_number
460: ,p_program_application_id in number default hr_api.g_number
461: ,p_program_id in number default hr_api.g_number
462: ,p_program_update_date in date default hr_api.g_date
463: ,p_object_version_number in out nocopy number
464: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 461: ,p_program_id in number default hr_api.g_number

457: ,p_status in varchar2 default hr_api.g_varchar2
458: ,p_validate_flag in varchar2 default hr_api.g_varchar2
459: ,p_request_id in number default hr_api.g_number
460: ,p_program_application_id in number default hr_api.g_number
461: ,p_program_id in number default hr_api.g_number
462: ,p_program_update_date in date default hr_api.g_date
463: ,p_object_version_number in out nocopy number
464: ,p_attribute_category in varchar2 default hr_api.g_varchar2
465: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 462: ,p_program_update_date in date default hr_api.g_date

458: ,p_validate_flag in varchar2 default hr_api.g_varchar2
459: ,p_request_id in number default hr_api.g_number
460: ,p_program_application_id in number default hr_api.g_number
461: ,p_program_id in number default hr_api.g_number
462: ,p_program_update_date in date default hr_api.g_date
463: ,p_object_version_number in out nocopy number
464: ,p_attribute_category in varchar2 default hr_api.g_varchar2
465: ,p_attribute1 in varchar2 default hr_api.g_varchar2
466: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 464: ,p_attribute_category in varchar2 default hr_api.g_varchar2

460: ,p_program_application_id in number default hr_api.g_number
461: ,p_program_id in number default hr_api.g_number
462: ,p_program_update_date in date default hr_api.g_date
463: ,p_object_version_number in out nocopy number
464: ,p_attribute_category in varchar2 default hr_api.g_varchar2
465: ,p_attribute1 in varchar2 default hr_api.g_varchar2
466: ,p_attribute2 in varchar2 default hr_api.g_varchar2
467: ,p_attribute3 in varchar2 default hr_api.g_varchar2
468: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 465: ,p_attribute1 in varchar2 default hr_api.g_varchar2

461: ,p_program_id in number default hr_api.g_number
462: ,p_program_update_date in date default hr_api.g_date
463: ,p_object_version_number in out nocopy number
464: ,p_attribute_category in varchar2 default hr_api.g_varchar2
465: ,p_attribute1 in varchar2 default hr_api.g_varchar2
466: ,p_attribute2 in varchar2 default hr_api.g_varchar2
467: ,p_attribute3 in varchar2 default hr_api.g_varchar2
468: ,p_attribute4 in varchar2 default hr_api.g_varchar2
469: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 466: ,p_attribute2 in varchar2 default hr_api.g_varchar2

462: ,p_program_update_date in date default hr_api.g_date
463: ,p_object_version_number in out nocopy number
464: ,p_attribute_category in varchar2 default hr_api.g_varchar2
465: ,p_attribute1 in varchar2 default hr_api.g_varchar2
466: ,p_attribute2 in varchar2 default hr_api.g_varchar2
467: ,p_attribute3 in varchar2 default hr_api.g_varchar2
468: ,p_attribute4 in varchar2 default hr_api.g_varchar2
469: ,p_attribute5 in varchar2 default hr_api.g_varchar2
470: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 467: ,p_attribute3 in varchar2 default hr_api.g_varchar2

463: ,p_object_version_number in out nocopy number
464: ,p_attribute_category in varchar2 default hr_api.g_varchar2
465: ,p_attribute1 in varchar2 default hr_api.g_varchar2
466: ,p_attribute2 in varchar2 default hr_api.g_varchar2
467: ,p_attribute3 in varchar2 default hr_api.g_varchar2
468: ,p_attribute4 in varchar2 default hr_api.g_varchar2
469: ,p_attribute5 in varchar2 default hr_api.g_varchar2
470: ,p_attribute6 in varchar2 default hr_api.g_varchar2
471: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 468: ,p_attribute4 in varchar2 default hr_api.g_varchar2

464: ,p_attribute_category in varchar2 default hr_api.g_varchar2
465: ,p_attribute1 in varchar2 default hr_api.g_varchar2
466: ,p_attribute2 in varchar2 default hr_api.g_varchar2
467: ,p_attribute3 in varchar2 default hr_api.g_varchar2
468: ,p_attribute4 in varchar2 default hr_api.g_varchar2
469: ,p_attribute5 in varchar2 default hr_api.g_varchar2
470: ,p_attribute6 in varchar2 default hr_api.g_varchar2
471: ,p_attribute7 in varchar2 default hr_api.g_varchar2
472: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 469: ,p_attribute5 in varchar2 default hr_api.g_varchar2

465: ,p_attribute1 in varchar2 default hr_api.g_varchar2
466: ,p_attribute2 in varchar2 default hr_api.g_varchar2
467: ,p_attribute3 in varchar2 default hr_api.g_varchar2
468: ,p_attribute4 in varchar2 default hr_api.g_varchar2
469: ,p_attribute5 in varchar2 default hr_api.g_varchar2
470: ,p_attribute6 in varchar2 default hr_api.g_varchar2
471: ,p_attribute7 in varchar2 default hr_api.g_varchar2
472: ,p_attribute8 in varchar2 default hr_api.g_varchar2
473: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 470: ,p_attribute6 in varchar2 default hr_api.g_varchar2

466: ,p_attribute2 in varchar2 default hr_api.g_varchar2
467: ,p_attribute3 in varchar2 default hr_api.g_varchar2
468: ,p_attribute4 in varchar2 default hr_api.g_varchar2
469: ,p_attribute5 in varchar2 default hr_api.g_varchar2
470: ,p_attribute6 in varchar2 default hr_api.g_varchar2
471: ,p_attribute7 in varchar2 default hr_api.g_varchar2
472: ,p_attribute8 in varchar2 default hr_api.g_varchar2
473: ,p_attribute9 in varchar2 default hr_api.g_varchar2
474: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 471: ,p_attribute7 in varchar2 default hr_api.g_varchar2

467: ,p_attribute3 in varchar2 default hr_api.g_varchar2
468: ,p_attribute4 in varchar2 default hr_api.g_varchar2
469: ,p_attribute5 in varchar2 default hr_api.g_varchar2
470: ,p_attribute6 in varchar2 default hr_api.g_varchar2
471: ,p_attribute7 in varchar2 default hr_api.g_varchar2
472: ,p_attribute8 in varchar2 default hr_api.g_varchar2
473: ,p_attribute9 in varchar2 default hr_api.g_varchar2
474: ,p_attribute10 in varchar2 default hr_api.g_varchar2
475: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 472: ,p_attribute8 in varchar2 default hr_api.g_varchar2

468: ,p_attribute4 in varchar2 default hr_api.g_varchar2
469: ,p_attribute5 in varchar2 default hr_api.g_varchar2
470: ,p_attribute6 in varchar2 default hr_api.g_varchar2
471: ,p_attribute7 in varchar2 default hr_api.g_varchar2
472: ,p_attribute8 in varchar2 default hr_api.g_varchar2
473: ,p_attribute9 in varchar2 default hr_api.g_varchar2
474: ,p_attribute10 in varchar2 default hr_api.g_varchar2
475: ,p_attribute11 in varchar2 default hr_api.g_varchar2
476: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 473: ,p_attribute9 in varchar2 default hr_api.g_varchar2

469: ,p_attribute5 in varchar2 default hr_api.g_varchar2
470: ,p_attribute6 in varchar2 default hr_api.g_varchar2
471: ,p_attribute7 in varchar2 default hr_api.g_varchar2
472: ,p_attribute8 in varchar2 default hr_api.g_varchar2
473: ,p_attribute9 in varchar2 default hr_api.g_varchar2
474: ,p_attribute10 in varchar2 default hr_api.g_varchar2
475: ,p_attribute11 in varchar2 default hr_api.g_varchar2
476: ,p_attribute12 in varchar2 default hr_api.g_varchar2
477: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 474: ,p_attribute10 in varchar2 default hr_api.g_varchar2

470: ,p_attribute6 in varchar2 default hr_api.g_varchar2
471: ,p_attribute7 in varchar2 default hr_api.g_varchar2
472: ,p_attribute8 in varchar2 default hr_api.g_varchar2
473: ,p_attribute9 in varchar2 default hr_api.g_varchar2
474: ,p_attribute10 in varchar2 default hr_api.g_varchar2
475: ,p_attribute11 in varchar2 default hr_api.g_varchar2
476: ,p_attribute12 in varchar2 default hr_api.g_varchar2
477: ,p_attribute13 in varchar2 default hr_api.g_varchar2
478: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 475: ,p_attribute11 in varchar2 default hr_api.g_varchar2

471: ,p_attribute7 in varchar2 default hr_api.g_varchar2
472: ,p_attribute8 in varchar2 default hr_api.g_varchar2
473: ,p_attribute9 in varchar2 default hr_api.g_varchar2
474: ,p_attribute10 in varchar2 default hr_api.g_varchar2
475: ,p_attribute11 in varchar2 default hr_api.g_varchar2
476: ,p_attribute12 in varchar2 default hr_api.g_varchar2
477: ,p_attribute13 in varchar2 default hr_api.g_varchar2
478: ,p_attribute14 in varchar2 default hr_api.g_varchar2
479: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 476: ,p_attribute12 in varchar2 default hr_api.g_varchar2

472: ,p_attribute8 in varchar2 default hr_api.g_varchar2
473: ,p_attribute9 in varchar2 default hr_api.g_varchar2
474: ,p_attribute10 in varchar2 default hr_api.g_varchar2
475: ,p_attribute11 in varchar2 default hr_api.g_varchar2
476: ,p_attribute12 in varchar2 default hr_api.g_varchar2
477: ,p_attribute13 in varchar2 default hr_api.g_varchar2
478: ,p_attribute14 in varchar2 default hr_api.g_varchar2
479: ,p_attribute15 in varchar2 default hr_api.g_varchar2
480: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 477: ,p_attribute13 in varchar2 default hr_api.g_varchar2

473: ,p_attribute9 in varchar2 default hr_api.g_varchar2
474: ,p_attribute10 in varchar2 default hr_api.g_varchar2
475: ,p_attribute11 in varchar2 default hr_api.g_varchar2
476: ,p_attribute12 in varchar2 default hr_api.g_varchar2
477: ,p_attribute13 in varchar2 default hr_api.g_varchar2
478: ,p_attribute14 in varchar2 default hr_api.g_varchar2
479: ,p_attribute15 in varchar2 default hr_api.g_varchar2
480: ,p_attribute16 in varchar2 default hr_api.g_varchar2
481: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 478: ,p_attribute14 in varchar2 default hr_api.g_varchar2

474: ,p_attribute10 in varchar2 default hr_api.g_varchar2
475: ,p_attribute11 in varchar2 default hr_api.g_varchar2
476: ,p_attribute12 in varchar2 default hr_api.g_varchar2
477: ,p_attribute13 in varchar2 default hr_api.g_varchar2
478: ,p_attribute14 in varchar2 default hr_api.g_varchar2
479: ,p_attribute15 in varchar2 default hr_api.g_varchar2
480: ,p_attribute16 in varchar2 default hr_api.g_varchar2
481: ,p_attribute17 in varchar2 default hr_api.g_varchar2
482: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 479: ,p_attribute15 in varchar2 default hr_api.g_varchar2

475: ,p_attribute11 in varchar2 default hr_api.g_varchar2
476: ,p_attribute12 in varchar2 default hr_api.g_varchar2
477: ,p_attribute13 in varchar2 default hr_api.g_varchar2
478: ,p_attribute14 in varchar2 default hr_api.g_varchar2
479: ,p_attribute15 in varchar2 default hr_api.g_varchar2
480: ,p_attribute16 in varchar2 default hr_api.g_varchar2
481: ,p_attribute17 in varchar2 default hr_api.g_varchar2
482: ,p_attribute18 in varchar2 default hr_api.g_varchar2
483: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 480: ,p_attribute16 in varchar2 default hr_api.g_varchar2

476: ,p_attribute12 in varchar2 default hr_api.g_varchar2
477: ,p_attribute13 in varchar2 default hr_api.g_varchar2
478: ,p_attribute14 in varchar2 default hr_api.g_varchar2
479: ,p_attribute15 in varchar2 default hr_api.g_varchar2
480: ,p_attribute16 in varchar2 default hr_api.g_varchar2
481: ,p_attribute17 in varchar2 default hr_api.g_varchar2
482: ,p_attribute18 in varchar2 default hr_api.g_varchar2
483: ,p_attribute19 in varchar2 default hr_api.g_varchar2
484: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 481: ,p_attribute17 in varchar2 default hr_api.g_varchar2

477: ,p_attribute13 in varchar2 default hr_api.g_varchar2
478: ,p_attribute14 in varchar2 default hr_api.g_varchar2
479: ,p_attribute15 in varchar2 default hr_api.g_varchar2
480: ,p_attribute16 in varchar2 default hr_api.g_varchar2
481: ,p_attribute17 in varchar2 default hr_api.g_varchar2
482: ,p_attribute18 in varchar2 default hr_api.g_varchar2
483: ,p_attribute19 in varchar2 default hr_api.g_varchar2
484: ,p_attribute20 in varchar2 default hr_api.g_varchar2
485: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 482: ,p_attribute18 in varchar2 default hr_api.g_varchar2

478: ,p_attribute14 in varchar2 default hr_api.g_varchar2
479: ,p_attribute15 in varchar2 default hr_api.g_varchar2
480: ,p_attribute16 in varchar2 default hr_api.g_varchar2
481: ,p_attribute17 in varchar2 default hr_api.g_varchar2
482: ,p_attribute18 in varchar2 default hr_api.g_varchar2
483: ,p_attribute19 in varchar2 default hr_api.g_varchar2
484: ,p_attribute20 in varchar2 default hr_api.g_varchar2
485: ,p_attribute21 in varchar2 default hr_api.g_varchar2
486: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 483: ,p_attribute19 in varchar2 default hr_api.g_varchar2

479: ,p_attribute15 in varchar2 default hr_api.g_varchar2
480: ,p_attribute16 in varchar2 default hr_api.g_varchar2
481: ,p_attribute17 in varchar2 default hr_api.g_varchar2
482: ,p_attribute18 in varchar2 default hr_api.g_varchar2
483: ,p_attribute19 in varchar2 default hr_api.g_varchar2
484: ,p_attribute20 in varchar2 default hr_api.g_varchar2
485: ,p_attribute21 in varchar2 default hr_api.g_varchar2
486: ,p_attribute22 in varchar2 default hr_api.g_varchar2
487: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 484: ,p_attribute20 in varchar2 default hr_api.g_varchar2

480: ,p_attribute16 in varchar2 default hr_api.g_varchar2
481: ,p_attribute17 in varchar2 default hr_api.g_varchar2
482: ,p_attribute18 in varchar2 default hr_api.g_varchar2
483: ,p_attribute19 in varchar2 default hr_api.g_varchar2
484: ,p_attribute20 in varchar2 default hr_api.g_varchar2
485: ,p_attribute21 in varchar2 default hr_api.g_varchar2
486: ,p_attribute22 in varchar2 default hr_api.g_varchar2
487: ,p_attribute23 in varchar2 default hr_api.g_varchar2
488: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 485: ,p_attribute21 in varchar2 default hr_api.g_varchar2

481: ,p_attribute17 in varchar2 default hr_api.g_varchar2
482: ,p_attribute18 in varchar2 default hr_api.g_varchar2
483: ,p_attribute19 in varchar2 default hr_api.g_varchar2
484: ,p_attribute20 in varchar2 default hr_api.g_varchar2
485: ,p_attribute21 in varchar2 default hr_api.g_varchar2
486: ,p_attribute22 in varchar2 default hr_api.g_varchar2
487: ,p_attribute23 in varchar2 default hr_api.g_varchar2
488: ,p_attribute24 in varchar2 default hr_api.g_varchar2
489: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 486: ,p_attribute22 in varchar2 default hr_api.g_varchar2

482: ,p_attribute18 in varchar2 default hr_api.g_varchar2
483: ,p_attribute19 in varchar2 default hr_api.g_varchar2
484: ,p_attribute20 in varchar2 default hr_api.g_varchar2
485: ,p_attribute21 in varchar2 default hr_api.g_varchar2
486: ,p_attribute22 in varchar2 default hr_api.g_varchar2
487: ,p_attribute23 in varchar2 default hr_api.g_varchar2
488: ,p_attribute24 in varchar2 default hr_api.g_varchar2
489: ,p_attribute25 in varchar2 default hr_api.g_varchar2
490: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 487: ,p_attribute23 in varchar2 default hr_api.g_varchar2

483: ,p_attribute19 in varchar2 default hr_api.g_varchar2
484: ,p_attribute20 in varchar2 default hr_api.g_varchar2
485: ,p_attribute21 in varchar2 default hr_api.g_varchar2
486: ,p_attribute22 in varchar2 default hr_api.g_varchar2
487: ,p_attribute23 in varchar2 default hr_api.g_varchar2
488: ,p_attribute24 in varchar2 default hr_api.g_varchar2
489: ,p_attribute25 in varchar2 default hr_api.g_varchar2
490: ,p_attribute26 in varchar2 default hr_api.g_varchar2
491: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 488: ,p_attribute24 in varchar2 default hr_api.g_varchar2

484: ,p_attribute20 in varchar2 default hr_api.g_varchar2
485: ,p_attribute21 in varchar2 default hr_api.g_varchar2
486: ,p_attribute22 in varchar2 default hr_api.g_varchar2
487: ,p_attribute23 in varchar2 default hr_api.g_varchar2
488: ,p_attribute24 in varchar2 default hr_api.g_varchar2
489: ,p_attribute25 in varchar2 default hr_api.g_varchar2
490: ,p_attribute26 in varchar2 default hr_api.g_varchar2
491: ,p_attribute27 in varchar2 default hr_api.g_varchar2
492: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 489: ,p_attribute25 in varchar2 default hr_api.g_varchar2

485: ,p_attribute21 in varchar2 default hr_api.g_varchar2
486: ,p_attribute22 in varchar2 default hr_api.g_varchar2
487: ,p_attribute23 in varchar2 default hr_api.g_varchar2
488: ,p_attribute24 in varchar2 default hr_api.g_varchar2
489: ,p_attribute25 in varchar2 default hr_api.g_varchar2
490: ,p_attribute26 in varchar2 default hr_api.g_varchar2
491: ,p_attribute27 in varchar2 default hr_api.g_varchar2
492: ,p_attribute28 in varchar2 default hr_api.g_varchar2
493: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 490: ,p_attribute26 in varchar2 default hr_api.g_varchar2

486: ,p_attribute22 in varchar2 default hr_api.g_varchar2
487: ,p_attribute23 in varchar2 default hr_api.g_varchar2
488: ,p_attribute24 in varchar2 default hr_api.g_varchar2
489: ,p_attribute25 in varchar2 default hr_api.g_varchar2
490: ,p_attribute26 in varchar2 default hr_api.g_varchar2
491: ,p_attribute27 in varchar2 default hr_api.g_varchar2
492: ,p_attribute28 in varchar2 default hr_api.g_varchar2
493: ,p_attribute29 in varchar2 default hr_api.g_varchar2
494: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 491: ,p_attribute27 in varchar2 default hr_api.g_varchar2

487: ,p_attribute23 in varchar2 default hr_api.g_varchar2
488: ,p_attribute24 in varchar2 default hr_api.g_varchar2
489: ,p_attribute25 in varchar2 default hr_api.g_varchar2
490: ,p_attribute26 in varchar2 default hr_api.g_varchar2
491: ,p_attribute27 in varchar2 default hr_api.g_varchar2
492: ,p_attribute28 in varchar2 default hr_api.g_varchar2
493: ,p_attribute29 in varchar2 default hr_api.g_varchar2
494: ,p_attribute30 in varchar2 default hr_api.g_varchar2
495: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 492: ,p_attribute28 in varchar2 default hr_api.g_varchar2

488: ,p_attribute24 in varchar2 default hr_api.g_varchar2
489: ,p_attribute25 in varchar2 default hr_api.g_varchar2
490: ,p_attribute26 in varchar2 default hr_api.g_varchar2
491: ,p_attribute27 in varchar2 default hr_api.g_varchar2
492: ,p_attribute28 in varchar2 default hr_api.g_varchar2
493: ,p_attribute29 in varchar2 default hr_api.g_varchar2
494: ,p_attribute30 in varchar2 default hr_api.g_varchar2
495: ,p_information_category in varchar2 default hr_api.g_varchar2
496: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 493: ,p_attribute29 in varchar2 default hr_api.g_varchar2

489: ,p_attribute25 in varchar2 default hr_api.g_varchar2
490: ,p_attribute26 in varchar2 default hr_api.g_varchar2
491: ,p_attribute27 in varchar2 default hr_api.g_varchar2
492: ,p_attribute28 in varchar2 default hr_api.g_varchar2
493: ,p_attribute29 in varchar2 default hr_api.g_varchar2
494: ,p_attribute30 in varchar2 default hr_api.g_varchar2
495: ,p_information_category in varchar2 default hr_api.g_varchar2
496: ,p_information1 in varchar2 default hr_api.g_varchar2
497: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 494: ,p_attribute30 in varchar2 default hr_api.g_varchar2

490: ,p_attribute26 in varchar2 default hr_api.g_varchar2
491: ,p_attribute27 in varchar2 default hr_api.g_varchar2
492: ,p_attribute28 in varchar2 default hr_api.g_varchar2
493: ,p_attribute29 in varchar2 default hr_api.g_varchar2
494: ,p_attribute30 in varchar2 default hr_api.g_varchar2
495: ,p_information_category in varchar2 default hr_api.g_varchar2
496: ,p_information1 in varchar2 default hr_api.g_varchar2
497: ,p_information2 in varchar2 default hr_api.g_varchar2
498: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 495: ,p_information_category in varchar2 default hr_api.g_varchar2

491: ,p_attribute27 in varchar2 default hr_api.g_varchar2
492: ,p_attribute28 in varchar2 default hr_api.g_varchar2
493: ,p_attribute29 in varchar2 default hr_api.g_varchar2
494: ,p_attribute30 in varchar2 default hr_api.g_varchar2
495: ,p_information_category in varchar2 default hr_api.g_varchar2
496: ,p_information1 in varchar2 default hr_api.g_varchar2
497: ,p_information2 in varchar2 default hr_api.g_varchar2
498: ,p_information3 in varchar2 default hr_api.g_varchar2
499: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 496: ,p_information1 in varchar2 default hr_api.g_varchar2

492: ,p_attribute28 in varchar2 default hr_api.g_varchar2
493: ,p_attribute29 in varchar2 default hr_api.g_varchar2
494: ,p_attribute30 in varchar2 default hr_api.g_varchar2
495: ,p_information_category in varchar2 default hr_api.g_varchar2
496: ,p_information1 in varchar2 default hr_api.g_varchar2
497: ,p_information2 in varchar2 default hr_api.g_varchar2
498: ,p_information3 in varchar2 default hr_api.g_varchar2
499: ,p_information4 in varchar2 default hr_api.g_varchar2
500: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 497: ,p_information2 in varchar2 default hr_api.g_varchar2

493: ,p_attribute29 in varchar2 default hr_api.g_varchar2
494: ,p_attribute30 in varchar2 default hr_api.g_varchar2
495: ,p_information_category in varchar2 default hr_api.g_varchar2
496: ,p_information1 in varchar2 default hr_api.g_varchar2
497: ,p_information2 in varchar2 default hr_api.g_varchar2
498: ,p_information3 in varchar2 default hr_api.g_varchar2
499: ,p_information4 in varchar2 default hr_api.g_varchar2
500: ,p_information5 in varchar2 default hr_api.g_varchar2
501: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 498: ,p_information3 in varchar2 default hr_api.g_varchar2

494: ,p_attribute30 in varchar2 default hr_api.g_varchar2
495: ,p_information_category in varchar2 default hr_api.g_varchar2
496: ,p_information1 in varchar2 default hr_api.g_varchar2
497: ,p_information2 in varchar2 default hr_api.g_varchar2
498: ,p_information3 in varchar2 default hr_api.g_varchar2
499: ,p_information4 in varchar2 default hr_api.g_varchar2
500: ,p_information5 in varchar2 default hr_api.g_varchar2
501: ,p_information6 in varchar2 default hr_api.g_varchar2
502: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 499: ,p_information4 in varchar2 default hr_api.g_varchar2

495: ,p_information_category in varchar2 default hr_api.g_varchar2
496: ,p_information1 in varchar2 default hr_api.g_varchar2
497: ,p_information2 in varchar2 default hr_api.g_varchar2
498: ,p_information3 in varchar2 default hr_api.g_varchar2
499: ,p_information4 in varchar2 default hr_api.g_varchar2
500: ,p_information5 in varchar2 default hr_api.g_varchar2
501: ,p_information6 in varchar2 default hr_api.g_varchar2
502: ,p_information7 in varchar2 default hr_api.g_varchar2
503: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 500: ,p_information5 in varchar2 default hr_api.g_varchar2

496: ,p_information1 in varchar2 default hr_api.g_varchar2
497: ,p_information2 in varchar2 default hr_api.g_varchar2
498: ,p_information3 in varchar2 default hr_api.g_varchar2
499: ,p_information4 in varchar2 default hr_api.g_varchar2
500: ,p_information5 in varchar2 default hr_api.g_varchar2
501: ,p_information6 in varchar2 default hr_api.g_varchar2
502: ,p_information7 in varchar2 default hr_api.g_varchar2
503: ,p_information8 in varchar2 default hr_api.g_varchar2
504: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 501: ,p_information6 in varchar2 default hr_api.g_varchar2

497: ,p_information2 in varchar2 default hr_api.g_varchar2
498: ,p_information3 in varchar2 default hr_api.g_varchar2
499: ,p_information4 in varchar2 default hr_api.g_varchar2
500: ,p_information5 in varchar2 default hr_api.g_varchar2
501: ,p_information6 in varchar2 default hr_api.g_varchar2
502: ,p_information7 in varchar2 default hr_api.g_varchar2
503: ,p_information8 in varchar2 default hr_api.g_varchar2
504: ,p_information9 in varchar2 default hr_api.g_varchar2
505: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 502: ,p_information7 in varchar2 default hr_api.g_varchar2

498: ,p_information3 in varchar2 default hr_api.g_varchar2
499: ,p_information4 in varchar2 default hr_api.g_varchar2
500: ,p_information5 in varchar2 default hr_api.g_varchar2
501: ,p_information6 in varchar2 default hr_api.g_varchar2
502: ,p_information7 in varchar2 default hr_api.g_varchar2
503: ,p_information8 in varchar2 default hr_api.g_varchar2
504: ,p_information9 in varchar2 default hr_api.g_varchar2
505: ,p_information10 in varchar2 default hr_api.g_varchar2
506: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 503: ,p_information8 in varchar2 default hr_api.g_varchar2

499: ,p_information4 in varchar2 default hr_api.g_varchar2
500: ,p_information5 in varchar2 default hr_api.g_varchar2
501: ,p_information6 in varchar2 default hr_api.g_varchar2
502: ,p_information7 in varchar2 default hr_api.g_varchar2
503: ,p_information8 in varchar2 default hr_api.g_varchar2
504: ,p_information9 in varchar2 default hr_api.g_varchar2
505: ,p_information10 in varchar2 default hr_api.g_varchar2
506: ,p_information11 in varchar2 default hr_api.g_varchar2
507: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 504: ,p_information9 in varchar2 default hr_api.g_varchar2

500: ,p_information5 in varchar2 default hr_api.g_varchar2
501: ,p_information6 in varchar2 default hr_api.g_varchar2
502: ,p_information7 in varchar2 default hr_api.g_varchar2
503: ,p_information8 in varchar2 default hr_api.g_varchar2
504: ,p_information9 in varchar2 default hr_api.g_varchar2
505: ,p_information10 in varchar2 default hr_api.g_varchar2
506: ,p_information11 in varchar2 default hr_api.g_varchar2
507: ,p_information12 in varchar2 default hr_api.g_varchar2
508: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 505: ,p_information10 in varchar2 default hr_api.g_varchar2

501: ,p_information6 in varchar2 default hr_api.g_varchar2
502: ,p_information7 in varchar2 default hr_api.g_varchar2
503: ,p_information8 in varchar2 default hr_api.g_varchar2
504: ,p_information9 in varchar2 default hr_api.g_varchar2
505: ,p_information10 in varchar2 default hr_api.g_varchar2
506: ,p_information11 in varchar2 default hr_api.g_varchar2
507: ,p_information12 in varchar2 default hr_api.g_varchar2
508: ,p_information13 in varchar2 default hr_api.g_varchar2
509: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 506: ,p_information11 in varchar2 default hr_api.g_varchar2

502: ,p_information7 in varchar2 default hr_api.g_varchar2
503: ,p_information8 in varchar2 default hr_api.g_varchar2
504: ,p_information9 in varchar2 default hr_api.g_varchar2
505: ,p_information10 in varchar2 default hr_api.g_varchar2
506: ,p_information11 in varchar2 default hr_api.g_varchar2
507: ,p_information12 in varchar2 default hr_api.g_varchar2
508: ,p_information13 in varchar2 default hr_api.g_varchar2
509: ,p_information14 in varchar2 default hr_api.g_varchar2
510: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 507: ,p_information12 in varchar2 default hr_api.g_varchar2

503: ,p_information8 in varchar2 default hr_api.g_varchar2
504: ,p_information9 in varchar2 default hr_api.g_varchar2
505: ,p_information10 in varchar2 default hr_api.g_varchar2
506: ,p_information11 in varchar2 default hr_api.g_varchar2
507: ,p_information12 in varchar2 default hr_api.g_varchar2
508: ,p_information13 in varchar2 default hr_api.g_varchar2
509: ,p_information14 in varchar2 default hr_api.g_varchar2
510: ,p_information15 in varchar2 default hr_api.g_varchar2
511: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 508: ,p_information13 in varchar2 default hr_api.g_varchar2

504: ,p_information9 in varchar2 default hr_api.g_varchar2
505: ,p_information10 in varchar2 default hr_api.g_varchar2
506: ,p_information11 in varchar2 default hr_api.g_varchar2
507: ,p_information12 in varchar2 default hr_api.g_varchar2
508: ,p_information13 in varchar2 default hr_api.g_varchar2
509: ,p_information14 in varchar2 default hr_api.g_varchar2
510: ,p_information15 in varchar2 default hr_api.g_varchar2
511: ,p_information16 in varchar2 default hr_api.g_varchar2
512: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 509: ,p_information14 in varchar2 default hr_api.g_varchar2

505: ,p_information10 in varchar2 default hr_api.g_varchar2
506: ,p_information11 in varchar2 default hr_api.g_varchar2
507: ,p_information12 in varchar2 default hr_api.g_varchar2
508: ,p_information13 in varchar2 default hr_api.g_varchar2
509: ,p_information14 in varchar2 default hr_api.g_varchar2
510: ,p_information15 in varchar2 default hr_api.g_varchar2
511: ,p_information16 in varchar2 default hr_api.g_varchar2
512: ,p_information17 in varchar2 default hr_api.g_varchar2
513: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 510: ,p_information15 in varchar2 default hr_api.g_varchar2

506: ,p_information11 in varchar2 default hr_api.g_varchar2
507: ,p_information12 in varchar2 default hr_api.g_varchar2
508: ,p_information13 in varchar2 default hr_api.g_varchar2
509: ,p_information14 in varchar2 default hr_api.g_varchar2
510: ,p_information15 in varchar2 default hr_api.g_varchar2
511: ,p_information16 in varchar2 default hr_api.g_varchar2
512: ,p_information17 in varchar2 default hr_api.g_varchar2
513: ,p_information18 in varchar2 default hr_api.g_varchar2
514: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 511: ,p_information16 in varchar2 default hr_api.g_varchar2

507: ,p_information12 in varchar2 default hr_api.g_varchar2
508: ,p_information13 in varchar2 default hr_api.g_varchar2
509: ,p_information14 in varchar2 default hr_api.g_varchar2
510: ,p_information15 in varchar2 default hr_api.g_varchar2
511: ,p_information16 in varchar2 default hr_api.g_varchar2
512: ,p_information17 in varchar2 default hr_api.g_varchar2
513: ,p_information18 in varchar2 default hr_api.g_varchar2
514: ,p_information19 in varchar2 default hr_api.g_varchar2
515: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 512: ,p_information17 in varchar2 default hr_api.g_varchar2

508: ,p_information13 in varchar2 default hr_api.g_varchar2
509: ,p_information14 in varchar2 default hr_api.g_varchar2
510: ,p_information15 in varchar2 default hr_api.g_varchar2
511: ,p_information16 in varchar2 default hr_api.g_varchar2
512: ,p_information17 in varchar2 default hr_api.g_varchar2
513: ,p_information18 in varchar2 default hr_api.g_varchar2
514: ,p_information19 in varchar2 default hr_api.g_varchar2
515: ,p_information20 in varchar2 default hr_api.g_varchar2
516: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 513: ,p_information18 in varchar2 default hr_api.g_varchar2

509: ,p_information14 in varchar2 default hr_api.g_varchar2
510: ,p_information15 in varchar2 default hr_api.g_varchar2
511: ,p_information16 in varchar2 default hr_api.g_varchar2
512: ,p_information17 in varchar2 default hr_api.g_varchar2
513: ,p_information18 in varchar2 default hr_api.g_varchar2
514: ,p_information19 in varchar2 default hr_api.g_varchar2
515: ,p_information20 in varchar2 default hr_api.g_varchar2
516: ,p_information21 in varchar2 default hr_api.g_varchar2
517: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 514: ,p_information19 in varchar2 default hr_api.g_varchar2

510: ,p_information15 in varchar2 default hr_api.g_varchar2
511: ,p_information16 in varchar2 default hr_api.g_varchar2
512: ,p_information17 in varchar2 default hr_api.g_varchar2
513: ,p_information18 in varchar2 default hr_api.g_varchar2
514: ,p_information19 in varchar2 default hr_api.g_varchar2
515: ,p_information20 in varchar2 default hr_api.g_varchar2
516: ,p_information21 in varchar2 default hr_api.g_varchar2
517: ,p_information22 in varchar2 default hr_api.g_varchar2
518: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 515: ,p_information20 in varchar2 default hr_api.g_varchar2

511: ,p_information16 in varchar2 default hr_api.g_varchar2
512: ,p_information17 in varchar2 default hr_api.g_varchar2
513: ,p_information18 in varchar2 default hr_api.g_varchar2
514: ,p_information19 in varchar2 default hr_api.g_varchar2
515: ,p_information20 in varchar2 default hr_api.g_varchar2
516: ,p_information21 in varchar2 default hr_api.g_varchar2
517: ,p_information22 in varchar2 default hr_api.g_varchar2
518: ,p_information23 in varchar2 default hr_api.g_varchar2
519: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 516: ,p_information21 in varchar2 default hr_api.g_varchar2

512: ,p_information17 in varchar2 default hr_api.g_varchar2
513: ,p_information18 in varchar2 default hr_api.g_varchar2
514: ,p_information19 in varchar2 default hr_api.g_varchar2
515: ,p_information20 in varchar2 default hr_api.g_varchar2
516: ,p_information21 in varchar2 default hr_api.g_varchar2
517: ,p_information22 in varchar2 default hr_api.g_varchar2
518: ,p_information23 in varchar2 default hr_api.g_varchar2
519: ,p_information24 in varchar2 default hr_api.g_varchar2
520: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 517: ,p_information22 in varchar2 default hr_api.g_varchar2

513: ,p_information18 in varchar2 default hr_api.g_varchar2
514: ,p_information19 in varchar2 default hr_api.g_varchar2
515: ,p_information20 in varchar2 default hr_api.g_varchar2
516: ,p_information21 in varchar2 default hr_api.g_varchar2
517: ,p_information22 in varchar2 default hr_api.g_varchar2
518: ,p_information23 in varchar2 default hr_api.g_varchar2
519: ,p_information24 in varchar2 default hr_api.g_varchar2
520: ,p_information25 in varchar2 default hr_api.g_varchar2
521: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 518: ,p_information23 in varchar2 default hr_api.g_varchar2

514: ,p_information19 in varchar2 default hr_api.g_varchar2
515: ,p_information20 in varchar2 default hr_api.g_varchar2
516: ,p_information21 in varchar2 default hr_api.g_varchar2
517: ,p_information22 in varchar2 default hr_api.g_varchar2
518: ,p_information23 in varchar2 default hr_api.g_varchar2
519: ,p_information24 in varchar2 default hr_api.g_varchar2
520: ,p_information25 in varchar2 default hr_api.g_varchar2
521: ,p_information26 in varchar2 default hr_api.g_varchar2
522: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 519: ,p_information24 in varchar2 default hr_api.g_varchar2

515: ,p_information20 in varchar2 default hr_api.g_varchar2
516: ,p_information21 in varchar2 default hr_api.g_varchar2
517: ,p_information22 in varchar2 default hr_api.g_varchar2
518: ,p_information23 in varchar2 default hr_api.g_varchar2
519: ,p_information24 in varchar2 default hr_api.g_varchar2
520: ,p_information25 in varchar2 default hr_api.g_varchar2
521: ,p_information26 in varchar2 default hr_api.g_varchar2
522: ,p_information27 in varchar2 default hr_api.g_varchar2
523: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 520: ,p_information25 in varchar2 default hr_api.g_varchar2

516: ,p_information21 in varchar2 default hr_api.g_varchar2
517: ,p_information22 in varchar2 default hr_api.g_varchar2
518: ,p_information23 in varchar2 default hr_api.g_varchar2
519: ,p_information24 in varchar2 default hr_api.g_varchar2
520: ,p_information25 in varchar2 default hr_api.g_varchar2
521: ,p_information26 in varchar2 default hr_api.g_varchar2
522: ,p_information27 in varchar2 default hr_api.g_varchar2
523: ,p_information28 in varchar2 default hr_api.g_varchar2
524: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 521: ,p_information26 in varchar2 default hr_api.g_varchar2

517: ,p_information22 in varchar2 default hr_api.g_varchar2
518: ,p_information23 in varchar2 default hr_api.g_varchar2
519: ,p_information24 in varchar2 default hr_api.g_varchar2
520: ,p_information25 in varchar2 default hr_api.g_varchar2
521: ,p_information26 in varchar2 default hr_api.g_varchar2
522: ,p_information27 in varchar2 default hr_api.g_varchar2
523: ,p_information28 in varchar2 default hr_api.g_varchar2
524: ,p_information29 in varchar2 default hr_api.g_varchar2
525: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 522: ,p_information27 in varchar2 default hr_api.g_varchar2

518: ,p_information23 in varchar2 default hr_api.g_varchar2
519: ,p_information24 in varchar2 default hr_api.g_varchar2
520: ,p_information25 in varchar2 default hr_api.g_varchar2
521: ,p_information26 in varchar2 default hr_api.g_varchar2
522: ,p_information27 in varchar2 default hr_api.g_varchar2
523: ,p_information28 in varchar2 default hr_api.g_varchar2
524: ,p_information29 in varchar2 default hr_api.g_varchar2
525: ,p_information30 in varchar2 default hr_api.g_varchar2
526: ,p_effective_date in date

Line 523: ,p_information28 in varchar2 default hr_api.g_varchar2

519: ,p_information24 in varchar2 default hr_api.g_varchar2
520: ,p_information25 in varchar2 default hr_api.g_varchar2
521: ,p_information26 in varchar2 default hr_api.g_varchar2
522: ,p_information27 in varchar2 default hr_api.g_varchar2
523: ,p_information28 in varchar2 default hr_api.g_varchar2
524: ,p_information29 in varchar2 default hr_api.g_varchar2
525: ,p_information30 in varchar2 default hr_api.g_varchar2
526: ,p_effective_date in date
527: ) is

Line 524: ,p_information29 in varchar2 default hr_api.g_varchar2

520: ,p_information25 in varchar2 default hr_api.g_varchar2
521: ,p_information26 in varchar2 default hr_api.g_varchar2
522: ,p_information27 in varchar2 default hr_api.g_varchar2
523: ,p_information28 in varchar2 default hr_api.g_varchar2
524: ,p_information29 in varchar2 default hr_api.g_varchar2
525: ,p_information30 in varchar2 default hr_api.g_varchar2
526: ,p_effective_date in date
527: ) is
528: --

Line 525: ,p_information30 in varchar2 default hr_api.g_varchar2

521: ,p_information26 in varchar2 default hr_api.g_varchar2
522: ,p_information27 in varchar2 default hr_api.g_varchar2
523: ,p_information28 in varchar2 default hr_api.g_varchar2
524: ,p_information29 in varchar2 default hr_api.g_varchar2
525: ,p_information30 in varchar2 default hr_api.g_varchar2
526: ,p_effective_date in date
527: ) is
528: --
529: -- Declare cursors and local variables

Line 631: when hr_api.cannot_find_prog_unit then

627: ,p_information30 => p_information30
628: ,p_effective_date => trunc(p_effective_date)
629: );
630: exception
631: when hr_api.cannot_find_prog_unit then
632: hr_api.cannot_find_prog_unit_error
633: (p_module_name => 'UPDATE_hierarchy_versions'
634: ,p_hook_type => 'BP'
635: );

Line 632: hr_api.cannot_find_prog_unit_error

628: ,p_effective_date => trunc(p_effective_date)
629: );
630: exception
631: when hr_api.cannot_find_prog_unit then
632: hr_api.cannot_find_prog_unit_error
633: (p_module_name => 'UPDATE_hierarchy_versions'
634: ,p_hook_type => 'BP'
635: );
636: --

Line 801: when hr_api.cannot_find_prog_unit then

797: ,p_information30 => p_information30
798: ,p_effective_date => trunc(p_effective_date)
799: );
800: exception
801: when hr_api.cannot_find_prog_unit then
802: hr_api.cannot_find_prog_unit_error
803: (p_module_name => 'UPDATE_hierarchy_versions'
804: ,p_hook_type => 'AP'
805: );

Line 802: hr_api.cannot_find_prog_unit_error

798: ,p_effective_date => trunc(p_effective_date)
799: );
800: exception
801: when hr_api.cannot_find_prog_unit then
802: hr_api.cannot_find_prog_unit_error
803: (p_module_name => 'UPDATE_hierarchy_versions'
804: ,p_hook_type => 'AP'
805: );
806: --

Line 816: raise hr_api.validate_enabled;

812: --
813: -- When in validation only mode raise the Validate_Enabled exception
814: --
815: if p_validate then
816: raise hr_api.validate_enabled;
817: end if;
818: --
819: -- Set all output arguments
820: --

Line 827: when hr_api.validate_enabled then

823: hr_utility.set_location(' Leaving:'||l_proc, 70);
824: --
825: exception
826: --
827: when hr_api.validate_enabled then
828: --
829: -- As the Validate_Enabled exception has been raised
830: -- we must rollback to the savepoint
831: --

Line 892: when hr_api.cannot_find_prog_unit then

888: ,p_object_version_number => p_object_version_number
889: ,p_effective_date => trunc(p_effective_date)
890: );
891: exception
892: when hr_api.cannot_find_prog_unit then
893: hr_api.cannot_find_prog_unit_error
894: (p_module_name => 'DELETE_hierarchy_versions'
895: ,p_hook_type => 'BP'
896: );

Line 893: hr_api.cannot_find_prog_unit_error

889: ,p_effective_date => trunc(p_effective_date)
890: );
891: exception
892: when hr_api.cannot_find_prog_unit then
893: hr_api.cannot_find_prog_unit_error
894: (p_module_name => 'DELETE_hierarchy_versions'
895: ,p_hook_type => 'BP'
896: );
897: --

Line 919: when hr_api.cannot_find_prog_unit then

915: ,p_object_version_number => l_object_version_number
916: ,p_effective_date => trunc(p_effective_date)
917: );
918: exception
919: when hr_api.cannot_find_prog_unit then
920: hr_api.cannot_find_prog_unit_error
921: (p_module_name => 'DELETE_hierarchy_versions'
922: ,p_hook_type => 'AP'
923: );

Line 920: hr_api.cannot_find_prog_unit_error

916: ,p_effective_date => trunc(p_effective_date)
917: );
918: exception
919: when hr_api.cannot_find_prog_unit then
920: hr_api.cannot_find_prog_unit_error
921: (p_module_name => 'DELETE_hierarchy_versions'
922: ,p_hook_type => 'AP'
923: );
924: --

Line 934: raise hr_api.validate_enabled;

930: --
931: -- When in validation only mode raise the Validate_Enabled exception
932: --
933: if p_validate then
934: raise hr_api.validate_enabled;
935: end if;
936: --
937: hr_utility.set_location(' Leaving:'||l_proc, 70);
938: --

Line 941: when hr_api.validate_enabled then

937: hr_utility.set_location(' Leaving:'||l_proc, 70);
938: --
939: exception
940: --
941: when hr_api.validate_enabled then
942: --
943: -- As the Validate_Enabled exception has been raised
944: -- we must rollback to the savepoint
945: --