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_API dependencies on HR_API

Line 184: when hr_api.cannot_find_prog_unit then

180: ,p_information30 => p_information30
181: ,p_effective_date => p_effective_date
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (
187: p_module_name => 'CREATE_hierarchy'
188: ,p_hook_type => 'BP'

Line 185: hr_api.cannot_find_prog_unit_error

181: ,p_effective_date => p_effective_date
182: );
183: exception
184: when hr_api.cannot_find_prog_unit then
185: hr_api.cannot_find_prog_unit_error
186: (
187: p_module_name => 'CREATE_hierarchy'
188: ,p_hook_type => 'BP'
189: );

Line 351: when hr_api.cannot_find_prog_unit then

347: ,p_information30 => p_information30
348: ,p_effective_date => p_effective_date
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'CREATE_hierarchy'
354: ,p_hook_type => 'AP'
355: );

Line 352: hr_api.cannot_find_prog_unit_error

348: ,p_effective_date => p_effective_date
349: );
350: exception
351: when hr_api.cannot_find_prog_unit then
352: hr_api.cannot_find_prog_unit_error
353: (p_module_name => 'CREATE_hierarchy'
354: ,p_hook_type => 'AP'
355: );
356: --

Line 366: raise hr_api.validate_enabled;

362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then
366: raise hr_api.validate_enabled;
367: end if;
368: --
369: -- Set all output arguments
370: --

Line 378: when hr_api.validate_enabled then

374: hr_utility.set_location(' Leaving:'||l_proc, 70);
375: --
376: exception
377: --
378: when hr_api.validate_enabled then
379: --
380: -- As the Validate_Enabled exception has been raised
381: -- we must rollback to the savepoint
382: --

Line 411: ,p_name in varchar2 default hr_api.g_varchar2

407: --
408: procedure update_hierarchy
409: (p_validate in boolean default false
410: ,p_hierarchy_id in number
411: ,p_name in varchar2 default hr_api.g_varchar2
412: ,p_request_id in number default hr_api.g_number
413: ,p_program_application_id in number default hr_api.g_number
414: ,p_program_id in number default hr_api.g_number
415: ,p_program_update_date in date default hr_api.g_date

Line 412: ,p_request_id in number default hr_api.g_number

408: procedure update_hierarchy
409: (p_validate in boolean default false
410: ,p_hierarchy_id in number
411: ,p_name in varchar2 default hr_api.g_varchar2
412: ,p_request_id in number default hr_api.g_number
413: ,p_program_application_id in number default hr_api.g_number
414: ,p_program_id in number default hr_api.g_number
415: ,p_program_update_date in date default hr_api.g_date
416: ,p_object_version_number in out nocopy number

Line 413: ,p_program_application_id in number default hr_api.g_number

409: (p_validate in boolean default false
410: ,p_hierarchy_id in number
411: ,p_name in varchar2 default hr_api.g_varchar2
412: ,p_request_id in number default hr_api.g_number
413: ,p_program_application_id in number default hr_api.g_number
414: ,p_program_id in number default hr_api.g_number
415: ,p_program_update_date in date default hr_api.g_date
416: ,p_object_version_number in out nocopy number
417: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 414: ,p_program_id in number default hr_api.g_number

410: ,p_hierarchy_id in number
411: ,p_name in varchar2 default hr_api.g_varchar2
412: ,p_request_id in number default hr_api.g_number
413: ,p_program_application_id in number default hr_api.g_number
414: ,p_program_id in number default hr_api.g_number
415: ,p_program_update_date in date default hr_api.g_date
416: ,p_object_version_number in out nocopy number
417: ,p_attribute_category in varchar2 default hr_api.g_varchar2
418: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 415: ,p_program_update_date in date default hr_api.g_date

411: ,p_name in varchar2 default hr_api.g_varchar2
412: ,p_request_id in number default hr_api.g_number
413: ,p_program_application_id in number default hr_api.g_number
414: ,p_program_id in number default hr_api.g_number
415: ,p_program_update_date in date default hr_api.g_date
416: ,p_object_version_number in out nocopy number
417: ,p_attribute_category in varchar2 default hr_api.g_varchar2
418: ,p_attribute1 in varchar2 default hr_api.g_varchar2
419: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 417: ,p_attribute_category in varchar2 default hr_api.g_varchar2

413: ,p_program_application_id in number default hr_api.g_number
414: ,p_program_id in number default hr_api.g_number
415: ,p_program_update_date in date default hr_api.g_date
416: ,p_object_version_number in out nocopy number
417: ,p_attribute_category in varchar2 default hr_api.g_varchar2
418: ,p_attribute1 in varchar2 default hr_api.g_varchar2
419: ,p_attribute2 in varchar2 default hr_api.g_varchar2
420: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 418: ,p_attribute1 in varchar2 default hr_api.g_varchar2

414: ,p_program_id in number default hr_api.g_number
415: ,p_program_update_date in date default hr_api.g_date
416: ,p_object_version_number in out nocopy number
417: ,p_attribute_category in varchar2 default hr_api.g_varchar2
418: ,p_attribute1 in varchar2 default hr_api.g_varchar2
419: ,p_attribute2 in varchar2 default hr_api.g_varchar2
420: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 419: ,p_attribute2 in varchar2 default hr_api.g_varchar2

415: ,p_program_update_date in date default hr_api.g_date
416: ,p_object_version_number in out nocopy number
417: ,p_attribute_category in varchar2 default hr_api.g_varchar2
418: ,p_attribute1 in varchar2 default hr_api.g_varchar2
419: ,p_attribute2 in varchar2 default hr_api.g_varchar2
420: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 420: ,p_attribute3 in varchar2 default hr_api.g_varchar2

416: ,p_object_version_number in out nocopy number
417: ,p_attribute_category in varchar2 default hr_api.g_varchar2
418: ,p_attribute1 in varchar2 default hr_api.g_varchar2
419: ,p_attribute2 in varchar2 default hr_api.g_varchar2
420: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 421: ,p_attribute4 in varchar2 default hr_api.g_varchar2

417: ,p_attribute_category in varchar2 default hr_api.g_varchar2
418: ,p_attribute1 in varchar2 default hr_api.g_varchar2
419: ,p_attribute2 in varchar2 default hr_api.g_varchar2
420: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 422: ,p_attribute5 in varchar2 default hr_api.g_varchar2

418: ,p_attribute1 in varchar2 default hr_api.g_varchar2
419: ,p_attribute2 in varchar2 default hr_api.g_varchar2
420: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 423: ,p_attribute6 in varchar2 default hr_api.g_varchar2

419: ,p_attribute2 in varchar2 default hr_api.g_varchar2
420: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 424: ,p_attribute7 in varchar2 default hr_api.g_varchar2

420: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 425: ,p_attribute8 in varchar2 default hr_api.g_varchar2

421: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 426: ,p_attribute9 in varchar2 default hr_api.g_varchar2

422: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 427: ,p_attribute10 in varchar2 default hr_api.g_varchar2

423: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 428: ,p_attribute11 in varchar2 default hr_api.g_varchar2

424: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 429: ,p_attribute12 in varchar2 default hr_api.g_varchar2

425: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 430: ,p_attribute13 in varchar2 default hr_api.g_varchar2

426: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 431: ,p_attribute14 in varchar2 default hr_api.g_varchar2

427: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 432: ,p_attribute15 in varchar2 default hr_api.g_varchar2

428: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 433: ,p_attribute16 in varchar2 default hr_api.g_varchar2

429: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 434: ,p_attribute17 in varchar2 default hr_api.g_varchar2

430: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 435: ,p_attribute18 in varchar2 default hr_api.g_varchar2

431: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute21 in varchar2 default hr_api.g_varchar2
439: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 436: ,p_attribute19 in varchar2 default hr_api.g_varchar2

432: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute21 in varchar2 default hr_api.g_varchar2
439: ,p_attribute22 in varchar2 default hr_api.g_varchar2
440: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 437: ,p_attribute20 in varchar2 default hr_api.g_varchar2

433: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute21 in varchar2 default hr_api.g_varchar2
439: ,p_attribute22 in varchar2 default hr_api.g_varchar2
440: ,p_attribute23 in varchar2 default hr_api.g_varchar2
441: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 438: ,p_attribute21 in varchar2 default hr_api.g_varchar2

434: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute21 in varchar2 default hr_api.g_varchar2
439: ,p_attribute22 in varchar2 default hr_api.g_varchar2
440: ,p_attribute23 in varchar2 default hr_api.g_varchar2
441: ,p_attribute24 in varchar2 default hr_api.g_varchar2
442: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 439: ,p_attribute22 in varchar2 default hr_api.g_varchar2

435: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute21 in varchar2 default hr_api.g_varchar2
439: ,p_attribute22 in varchar2 default hr_api.g_varchar2
440: ,p_attribute23 in varchar2 default hr_api.g_varchar2
441: ,p_attribute24 in varchar2 default hr_api.g_varchar2
442: ,p_attribute25 in varchar2 default hr_api.g_varchar2
443: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 440: ,p_attribute23 in varchar2 default hr_api.g_varchar2

436: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute21 in varchar2 default hr_api.g_varchar2
439: ,p_attribute22 in varchar2 default hr_api.g_varchar2
440: ,p_attribute23 in varchar2 default hr_api.g_varchar2
441: ,p_attribute24 in varchar2 default hr_api.g_varchar2
442: ,p_attribute25 in varchar2 default hr_api.g_varchar2
443: ,p_attribute26 in varchar2 default hr_api.g_varchar2
444: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 441: ,p_attribute24 in varchar2 default hr_api.g_varchar2

437: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute21 in varchar2 default hr_api.g_varchar2
439: ,p_attribute22 in varchar2 default hr_api.g_varchar2
440: ,p_attribute23 in varchar2 default hr_api.g_varchar2
441: ,p_attribute24 in varchar2 default hr_api.g_varchar2
442: ,p_attribute25 in varchar2 default hr_api.g_varchar2
443: ,p_attribute26 in varchar2 default hr_api.g_varchar2
444: ,p_attribute27 in varchar2 default hr_api.g_varchar2
445: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 442: ,p_attribute25 in varchar2 default hr_api.g_varchar2

438: ,p_attribute21 in varchar2 default hr_api.g_varchar2
439: ,p_attribute22 in varchar2 default hr_api.g_varchar2
440: ,p_attribute23 in varchar2 default hr_api.g_varchar2
441: ,p_attribute24 in varchar2 default hr_api.g_varchar2
442: ,p_attribute25 in varchar2 default hr_api.g_varchar2
443: ,p_attribute26 in varchar2 default hr_api.g_varchar2
444: ,p_attribute27 in varchar2 default hr_api.g_varchar2
445: ,p_attribute28 in varchar2 default hr_api.g_varchar2
446: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 443: ,p_attribute26 in varchar2 default hr_api.g_varchar2

439: ,p_attribute22 in varchar2 default hr_api.g_varchar2
440: ,p_attribute23 in varchar2 default hr_api.g_varchar2
441: ,p_attribute24 in varchar2 default hr_api.g_varchar2
442: ,p_attribute25 in varchar2 default hr_api.g_varchar2
443: ,p_attribute26 in varchar2 default hr_api.g_varchar2
444: ,p_attribute27 in varchar2 default hr_api.g_varchar2
445: ,p_attribute28 in varchar2 default hr_api.g_varchar2
446: ,p_attribute29 in varchar2 default hr_api.g_varchar2
447: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 444: ,p_attribute27 in varchar2 default hr_api.g_varchar2

440: ,p_attribute23 in varchar2 default hr_api.g_varchar2
441: ,p_attribute24 in varchar2 default hr_api.g_varchar2
442: ,p_attribute25 in varchar2 default hr_api.g_varchar2
443: ,p_attribute26 in varchar2 default hr_api.g_varchar2
444: ,p_attribute27 in varchar2 default hr_api.g_varchar2
445: ,p_attribute28 in varchar2 default hr_api.g_varchar2
446: ,p_attribute29 in varchar2 default hr_api.g_varchar2
447: ,p_attribute30 in varchar2 default hr_api.g_varchar2
448: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 445: ,p_attribute28 in varchar2 default hr_api.g_varchar2

441: ,p_attribute24 in varchar2 default hr_api.g_varchar2
442: ,p_attribute25 in varchar2 default hr_api.g_varchar2
443: ,p_attribute26 in varchar2 default hr_api.g_varchar2
444: ,p_attribute27 in varchar2 default hr_api.g_varchar2
445: ,p_attribute28 in varchar2 default hr_api.g_varchar2
446: ,p_attribute29 in varchar2 default hr_api.g_varchar2
447: ,p_attribute30 in varchar2 default hr_api.g_varchar2
448: ,p_information_category in varchar2 default hr_api.g_varchar2
449: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 446: ,p_attribute29 in varchar2 default hr_api.g_varchar2

442: ,p_attribute25 in varchar2 default hr_api.g_varchar2
443: ,p_attribute26 in varchar2 default hr_api.g_varchar2
444: ,p_attribute27 in varchar2 default hr_api.g_varchar2
445: ,p_attribute28 in varchar2 default hr_api.g_varchar2
446: ,p_attribute29 in varchar2 default hr_api.g_varchar2
447: ,p_attribute30 in varchar2 default hr_api.g_varchar2
448: ,p_information_category in varchar2 default hr_api.g_varchar2
449: ,p_information1 in varchar2 default hr_api.g_varchar2
450: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 447: ,p_attribute30 in varchar2 default hr_api.g_varchar2

443: ,p_attribute26 in varchar2 default hr_api.g_varchar2
444: ,p_attribute27 in varchar2 default hr_api.g_varchar2
445: ,p_attribute28 in varchar2 default hr_api.g_varchar2
446: ,p_attribute29 in varchar2 default hr_api.g_varchar2
447: ,p_attribute30 in varchar2 default hr_api.g_varchar2
448: ,p_information_category in varchar2 default hr_api.g_varchar2
449: ,p_information1 in varchar2 default hr_api.g_varchar2
450: ,p_information2 in varchar2 default hr_api.g_varchar2
451: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 448: ,p_information_category in varchar2 default hr_api.g_varchar2

444: ,p_attribute27 in varchar2 default hr_api.g_varchar2
445: ,p_attribute28 in varchar2 default hr_api.g_varchar2
446: ,p_attribute29 in varchar2 default hr_api.g_varchar2
447: ,p_attribute30 in varchar2 default hr_api.g_varchar2
448: ,p_information_category in varchar2 default hr_api.g_varchar2
449: ,p_information1 in varchar2 default hr_api.g_varchar2
450: ,p_information2 in varchar2 default hr_api.g_varchar2
451: ,p_information3 in varchar2 default hr_api.g_varchar2
452: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 449: ,p_information1 in varchar2 default hr_api.g_varchar2

445: ,p_attribute28 in varchar2 default hr_api.g_varchar2
446: ,p_attribute29 in varchar2 default hr_api.g_varchar2
447: ,p_attribute30 in varchar2 default hr_api.g_varchar2
448: ,p_information_category in varchar2 default hr_api.g_varchar2
449: ,p_information1 in varchar2 default hr_api.g_varchar2
450: ,p_information2 in varchar2 default hr_api.g_varchar2
451: ,p_information3 in varchar2 default hr_api.g_varchar2
452: ,p_information4 in varchar2 default hr_api.g_varchar2
453: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 450: ,p_information2 in varchar2 default hr_api.g_varchar2

446: ,p_attribute29 in varchar2 default hr_api.g_varchar2
447: ,p_attribute30 in varchar2 default hr_api.g_varchar2
448: ,p_information_category in varchar2 default hr_api.g_varchar2
449: ,p_information1 in varchar2 default hr_api.g_varchar2
450: ,p_information2 in varchar2 default hr_api.g_varchar2
451: ,p_information3 in varchar2 default hr_api.g_varchar2
452: ,p_information4 in varchar2 default hr_api.g_varchar2
453: ,p_information5 in varchar2 default hr_api.g_varchar2
454: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 451: ,p_information3 in varchar2 default hr_api.g_varchar2

447: ,p_attribute30 in varchar2 default hr_api.g_varchar2
448: ,p_information_category in varchar2 default hr_api.g_varchar2
449: ,p_information1 in varchar2 default hr_api.g_varchar2
450: ,p_information2 in varchar2 default hr_api.g_varchar2
451: ,p_information3 in varchar2 default hr_api.g_varchar2
452: ,p_information4 in varchar2 default hr_api.g_varchar2
453: ,p_information5 in varchar2 default hr_api.g_varchar2
454: ,p_information6 in varchar2 default hr_api.g_varchar2
455: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 452: ,p_information4 in varchar2 default hr_api.g_varchar2

448: ,p_information_category in varchar2 default hr_api.g_varchar2
449: ,p_information1 in varchar2 default hr_api.g_varchar2
450: ,p_information2 in varchar2 default hr_api.g_varchar2
451: ,p_information3 in varchar2 default hr_api.g_varchar2
452: ,p_information4 in varchar2 default hr_api.g_varchar2
453: ,p_information5 in varchar2 default hr_api.g_varchar2
454: ,p_information6 in varchar2 default hr_api.g_varchar2
455: ,p_information7 in varchar2 default hr_api.g_varchar2
456: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 453: ,p_information5 in varchar2 default hr_api.g_varchar2

449: ,p_information1 in varchar2 default hr_api.g_varchar2
450: ,p_information2 in varchar2 default hr_api.g_varchar2
451: ,p_information3 in varchar2 default hr_api.g_varchar2
452: ,p_information4 in varchar2 default hr_api.g_varchar2
453: ,p_information5 in varchar2 default hr_api.g_varchar2
454: ,p_information6 in varchar2 default hr_api.g_varchar2
455: ,p_information7 in varchar2 default hr_api.g_varchar2
456: ,p_information8 in varchar2 default hr_api.g_varchar2
457: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 454: ,p_information6 in varchar2 default hr_api.g_varchar2

450: ,p_information2 in varchar2 default hr_api.g_varchar2
451: ,p_information3 in varchar2 default hr_api.g_varchar2
452: ,p_information4 in varchar2 default hr_api.g_varchar2
453: ,p_information5 in varchar2 default hr_api.g_varchar2
454: ,p_information6 in varchar2 default hr_api.g_varchar2
455: ,p_information7 in varchar2 default hr_api.g_varchar2
456: ,p_information8 in varchar2 default hr_api.g_varchar2
457: ,p_information9 in varchar2 default hr_api.g_varchar2
458: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 455: ,p_information7 in varchar2 default hr_api.g_varchar2

451: ,p_information3 in varchar2 default hr_api.g_varchar2
452: ,p_information4 in varchar2 default hr_api.g_varchar2
453: ,p_information5 in varchar2 default hr_api.g_varchar2
454: ,p_information6 in varchar2 default hr_api.g_varchar2
455: ,p_information7 in varchar2 default hr_api.g_varchar2
456: ,p_information8 in varchar2 default hr_api.g_varchar2
457: ,p_information9 in varchar2 default hr_api.g_varchar2
458: ,p_information10 in varchar2 default hr_api.g_varchar2
459: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 456: ,p_information8 in varchar2 default hr_api.g_varchar2

452: ,p_information4 in varchar2 default hr_api.g_varchar2
453: ,p_information5 in varchar2 default hr_api.g_varchar2
454: ,p_information6 in varchar2 default hr_api.g_varchar2
455: ,p_information7 in varchar2 default hr_api.g_varchar2
456: ,p_information8 in varchar2 default hr_api.g_varchar2
457: ,p_information9 in varchar2 default hr_api.g_varchar2
458: ,p_information10 in varchar2 default hr_api.g_varchar2
459: ,p_information11 in varchar2 default hr_api.g_varchar2
460: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 457: ,p_information9 in varchar2 default hr_api.g_varchar2

453: ,p_information5 in varchar2 default hr_api.g_varchar2
454: ,p_information6 in varchar2 default hr_api.g_varchar2
455: ,p_information7 in varchar2 default hr_api.g_varchar2
456: ,p_information8 in varchar2 default hr_api.g_varchar2
457: ,p_information9 in varchar2 default hr_api.g_varchar2
458: ,p_information10 in varchar2 default hr_api.g_varchar2
459: ,p_information11 in varchar2 default hr_api.g_varchar2
460: ,p_information12 in varchar2 default hr_api.g_varchar2
461: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 458: ,p_information10 in varchar2 default hr_api.g_varchar2

454: ,p_information6 in varchar2 default hr_api.g_varchar2
455: ,p_information7 in varchar2 default hr_api.g_varchar2
456: ,p_information8 in varchar2 default hr_api.g_varchar2
457: ,p_information9 in varchar2 default hr_api.g_varchar2
458: ,p_information10 in varchar2 default hr_api.g_varchar2
459: ,p_information11 in varchar2 default hr_api.g_varchar2
460: ,p_information12 in varchar2 default hr_api.g_varchar2
461: ,p_information13 in varchar2 default hr_api.g_varchar2
462: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 459: ,p_information11 in varchar2 default hr_api.g_varchar2

455: ,p_information7 in varchar2 default hr_api.g_varchar2
456: ,p_information8 in varchar2 default hr_api.g_varchar2
457: ,p_information9 in varchar2 default hr_api.g_varchar2
458: ,p_information10 in varchar2 default hr_api.g_varchar2
459: ,p_information11 in varchar2 default hr_api.g_varchar2
460: ,p_information12 in varchar2 default hr_api.g_varchar2
461: ,p_information13 in varchar2 default hr_api.g_varchar2
462: ,p_information14 in varchar2 default hr_api.g_varchar2
463: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 460: ,p_information12 in varchar2 default hr_api.g_varchar2

456: ,p_information8 in varchar2 default hr_api.g_varchar2
457: ,p_information9 in varchar2 default hr_api.g_varchar2
458: ,p_information10 in varchar2 default hr_api.g_varchar2
459: ,p_information11 in varchar2 default hr_api.g_varchar2
460: ,p_information12 in varchar2 default hr_api.g_varchar2
461: ,p_information13 in varchar2 default hr_api.g_varchar2
462: ,p_information14 in varchar2 default hr_api.g_varchar2
463: ,p_information15 in varchar2 default hr_api.g_varchar2
464: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 461: ,p_information13 in varchar2 default hr_api.g_varchar2

457: ,p_information9 in varchar2 default hr_api.g_varchar2
458: ,p_information10 in varchar2 default hr_api.g_varchar2
459: ,p_information11 in varchar2 default hr_api.g_varchar2
460: ,p_information12 in varchar2 default hr_api.g_varchar2
461: ,p_information13 in varchar2 default hr_api.g_varchar2
462: ,p_information14 in varchar2 default hr_api.g_varchar2
463: ,p_information15 in varchar2 default hr_api.g_varchar2
464: ,p_information16 in varchar2 default hr_api.g_varchar2
465: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 462: ,p_information14 in varchar2 default hr_api.g_varchar2

458: ,p_information10 in varchar2 default hr_api.g_varchar2
459: ,p_information11 in varchar2 default hr_api.g_varchar2
460: ,p_information12 in varchar2 default hr_api.g_varchar2
461: ,p_information13 in varchar2 default hr_api.g_varchar2
462: ,p_information14 in varchar2 default hr_api.g_varchar2
463: ,p_information15 in varchar2 default hr_api.g_varchar2
464: ,p_information16 in varchar2 default hr_api.g_varchar2
465: ,p_information17 in varchar2 default hr_api.g_varchar2
466: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 463: ,p_information15 in varchar2 default hr_api.g_varchar2

459: ,p_information11 in varchar2 default hr_api.g_varchar2
460: ,p_information12 in varchar2 default hr_api.g_varchar2
461: ,p_information13 in varchar2 default hr_api.g_varchar2
462: ,p_information14 in varchar2 default hr_api.g_varchar2
463: ,p_information15 in varchar2 default hr_api.g_varchar2
464: ,p_information16 in varchar2 default hr_api.g_varchar2
465: ,p_information17 in varchar2 default hr_api.g_varchar2
466: ,p_information18 in varchar2 default hr_api.g_varchar2
467: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 464: ,p_information16 in varchar2 default hr_api.g_varchar2

460: ,p_information12 in varchar2 default hr_api.g_varchar2
461: ,p_information13 in varchar2 default hr_api.g_varchar2
462: ,p_information14 in varchar2 default hr_api.g_varchar2
463: ,p_information15 in varchar2 default hr_api.g_varchar2
464: ,p_information16 in varchar2 default hr_api.g_varchar2
465: ,p_information17 in varchar2 default hr_api.g_varchar2
466: ,p_information18 in varchar2 default hr_api.g_varchar2
467: ,p_information19 in varchar2 default hr_api.g_varchar2
468: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 465: ,p_information17 in varchar2 default hr_api.g_varchar2

461: ,p_information13 in varchar2 default hr_api.g_varchar2
462: ,p_information14 in varchar2 default hr_api.g_varchar2
463: ,p_information15 in varchar2 default hr_api.g_varchar2
464: ,p_information16 in varchar2 default hr_api.g_varchar2
465: ,p_information17 in varchar2 default hr_api.g_varchar2
466: ,p_information18 in varchar2 default hr_api.g_varchar2
467: ,p_information19 in varchar2 default hr_api.g_varchar2
468: ,p_information20 in varchar2 default hr_api.g_varchar2
469: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 466: ,p_information18 in varchar2 default hr_api.g_varchar2

462: ,p_information14 in varchar2 default hr_api.g_varchar2
463: ,p_information15 in varchar2 default hr_api.g_varchar2
464: ,p_information16 in varchar2 default hr_api.g_varchar2
465: ,p_information17 in varchar2 default hr_api.g_varchar2
466: ,p_information18 in varchar2 default hr_api.g_varchar2
467: ,p_information19 in varchar2 default hr_api.g_varchar2
468: ,p_information20 in varchar2 default hr_api.g_varchar2
469: ,p_information21 in varchar2 default hr_api.g_varchar2
470: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 467: ,p_information19 in varchar2 default hr_api.g_varchar2

463: ,p_information15 in varchar2 default hr_api.g_varchar2
464: ,p_information16 in varchar2 default hr_api.g_varchar2
465: ,p_information17 in varchar2 default hr_api.g_varchar2
466: ,p_information18 in varchar2 default hr_api.g_varchar2
467: ,p_information19 in varchar2 default hr_api.g_varchar2
468: ,p_information20 in varchar2 default hr_api.g_varchar2
469: ,p_information21 in varchar2 default hr_api.g_varchar2
470: ,p_information22 in varchar2 default hr_api.g_varchar2
471: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 468: ,p_information20 in varchar2 default hr_api.g_varchar2

464: ,p_information16 in varchar2 default hr_api.g_varchar2
465: ,p_information17 in varchar2 default hr_api.g_varchar2
466: ,p_information18 in varchar2 default hr_api.g_varchar2
467: ,p_information19 in varchar2 default hr_api.g_varchar2
468: ,p_information20 in varchar2 default hr_api.g_varchar2
469: ,p_information21 in varchar2 default hr_api.g_varchar2
470: ,p_information22 in varchar2 default hr_api.g_varchar2
471: ,p_information23 in varchar2 default hr_api.g_varchar2
472: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 469: ,p_information21 in varchar2 default hr_api.g_varchar2

465: ,p_information17 in varchar2 default hr_api.g_varchar2
466: ,p_information18 in varchar2 default hr_api.g_varchar2
467: ,p_information19 in varchar2 default hr_api.g_varchar2
468: ,p_information20 in varchar2 default hr_api.g_varchar2
469: ,p_information21 in varchar2 default hr_api.g_varchar2
470: ,p_information22 in varchar2 default hr_api.g_varchar2
471: ,p_information23 in varchar2 default hr_api.g_varchar2
472: ,p_information24 in varchar2 default hr_api.g_varchar2
473: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 470: ,p_information22 in varchar2 default hr_api.g_varchar2

466: ,p_information18 in varchar2 default hr_api.g_varchar2
467: ,p_information19 in varchar2 default hr_api.g_varchar2
468: ,p_information20 in varchar2 default hr_api.g_varchar2
469: ,p_information21 in varchar2 default hr_api.g_varchar2
470: ,p_information22 in varchar2 default hr_api.g_varchar2
471: ,p_information23 in varchar2 default hr_api.g_varchar2
472: ,p_information24 in varchar2 default hr_api.g_varchar2
473: ,p_information25 in varchar2 default hr_api.g_varchar2
474: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 471: ,p_information23 in varchar2 default hr_api.g_varchar2

467: ,p_information19 in varchar2 default hr_api.g_varchar2
468: ,p_information20 in varchar2 default hr_api.g_varchar2
469: ,p_information21 in varchar2 default hr_api.g_varchar2
470: ,p_information22 in varchar2 default hr_api.g_varchar2
471: ,p_information23 in varchar2 default hr_api.g_varchar2
472: ,p_information24 in varchar2 default hr_api.g_varchar2
473: ,p_information25 in varchar2 default hr_api.g_varchar2
474: ,p_information26 in varchar2 default hr_api.g_varchar2
475: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 472: ,p_information24 in varchar2 default hr_api.g_varchar2

468: ,p_information20 in varchar2 default hr_api.g_varchar2
469: ,p_information21 in varchar2 default hr_api.g_varchar2
470: ,p_information22 in varchar2 default hr_api.g_varchar2
471: ,p_information23 in varchar2 default hr_api.g_varchar2
472: ,p_information24 in varchar2 default hr_api.g_varchar2
473: ,p_information25 in varchar2 default hr_api.g_varchar2
474: ,p_information26 in varchar2 default hr_api.g_varchar2
475: ,p_information27 in varchar2 default hr_api.g_varchar2
476: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 473: ,p_information25 in varchar2 default hr_api.g_varchar2

469: ,p_information21 in varchar2 default hr_api.g_varchar2
470: ,p_information22 in varchar2 default hr_api.g_varchar2
471: ,p_information23 in varchar2 default hr_api.g_varchar2
472: ,p_information24 in varchar2 default hr_api.g_varchar2
473: ,p_information25 in varchar2 default hr_api.g_varchar2
474: ,p_information26 in varchar2 default hr_api.g_varchar2
475: ,p_information27 in varchar2 default hr_api.g_varchar2
476: ,p_information28 in varchar2 default hr_api.g_varchar2
477: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 474: ,p_information26 in varchar2 default hr_api.g_varchar2

470: ,p_information22 in varchar2 default hr_api.g_varchar2
471: ,p_information23 in varchar2 default hr_api.g_varchar2
472: ,p_information24 in varchar2 default hr_api.g_varchar2
473: ,p_information25 in varchar2 default hr_api.g_varchar2
474: ,p_information26 in varchar2 default hr_api.g_varchar2
475: ,p_information27 in varchar2 default hr_api.g_varchar2
476: ,p_information28 in varchar2 default hr_api.g_varchar2
477: ,p_information29 in varchar2 default hr_api.g_varchar2
478: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 475: ,p_information27 in varchar2 default hr_api.g_varchar2

471: ,p_information23 in varchar2 default hr_api.g_varchar2
472: ,p_information24 in varchar2 default hr_api.g_varchar2
473: ,p_information25 in varchar2 default hr_api.g_varchar2
474: ,p_information26 in varchar2 default hr_api.g_varchar2
475: ,p_information27 in varchar2 default hr_api.g_varchar2
476: ,p_information28 in varchar2 default hr_api.g_varchar2
477: ,p_information29 in varchar2 default hr_api.g_varchar2
478: ,p_information30 in varchar2 default hr_api.g_varchar2
479: ,p_effective_date in date

Line 476: ,p_information28 in varchar2 default hr_api.g_varchar2

472: ,p_information24 in varchar2 default hr_api.g_varchar2
473: ,p_information25 in varchar2 default hr_api.g_varchar2
474: ,p_information26 in varchar2 default hr_api.g_varchar2
475: ,p_information27 in varchar2 default hr_api.g_varchar2
476: ,p_information28 in varchar2 default hr_api.g_varchar2
477: ,p_information29 in varchar2 default hr_api.g_varchar2
478: ,p_information30 in varchar2 default hr_api.g_varchar2
479: ,p_effective_date in date
480: ) is

Line 477: ,p_information29 in varchar2 default hr_api.g_varchar2

473: ,p_information25 in varchar2 default hr_api.g_varchar2
474: ,p_information26 in varchar2 default hr_api.g_varchar2
475: ,p_information27 in varchar2 default hr_api.g_varchar2
476: ,p_information28 in varchar2 default hr_api.g_varchar2
477: ,p_information29 in varchar2 default hr_api.g_varchar2
478: ,p_information30 in varchar2 default hr_api.g_varchar2
479: ,p_effective_date in date
480: ) is
481: --

Line 478: ,p_information30 in varchar2 default hr_api.g_varchar2

474: ,p_information26 in varchar2 default hr_api.g_varchar2
475: ,p_information27 in varchar2 default hr_api.g_varchar2
476: ,p_information28 in varchar2 default hr_api.g_varchar2
477: ,p_information29 in varchar2 default hr_api.g_varchar2
478: ,p_information30 in varchar2 default hr_api.g_varchar2
479: ,p_effective_date in date
480: ) is
481: --
482: -- Declare cursors and local variables

Line 579: when hr_api.cannot_find_prog_unit then

575: ,p_information30 => p_information30
576: ,p_effective_date => p_effective_date
577: );
578: exception
579: when hr_api.cannot_find_prog_unit then
580: hr_api.cannot_find_prog_unit_error
581: (p_module_name => 'UPDATE_hierarchy'
582: ,p_hook_type => 'BP'
583: );

Line 580: hr_api.cannot_find_prog_unit_error

576: ,p_effective_date => p_effective_date
577: );
578: exception
579: when hr_api.cannot_find_prog_unit then
580: hr_api.cannot_find_prog_unit_error
581: (p_module_name => 'UPDATE_hierarchy'
582: ,p_hook_type => 'BP'
583: );
584: --

Line 741: when hr_api.cannot_find_prog_unit then

737: ,p_information30 => p_information30
738: ,p_effective_date => p_effective_date
739: );
740: exception
741: when hr_api.cannot_find_prog_unit then
742: hr_api.cannot_find_prog_unit_error
743: (p_module_name => 'UPDATE_hierarchy'
744: ,p_hook_type => 'AP'
745: );

Line 742: hr_api.cannot_find_prog_unit_error

738: ,p_effective_date => p_effective_date
739: );
740: exception
741: when hr_api.cannot_find_prog_unit then
742: hr_api.cannot_find_prog_unit_error
743: (p_module_name => 'UPDATE_hierarchy'
744: ,p_hook_type => 'AP'
745: );
746: --

Line 756: raise hr_api.validate_enabled;

752: --
753: -- When in validation only mode raise the Validate_Enabled exception
754: --
755: if p_validate then
756: raise hr_api.validate_enabled;
757: end if;
758: --
759: -- Set all output arguments
760: --

Line 767: when hr_api.validate_enabled then

763: hr_utility.set_location(' Leaving:'||l_proc, 70);
764: --
765: exception
766: --
767: when hr_api.validate_enabled then
768: --
769: -- As the Validate_Enabled exception has been raised
770: -- we must rollback to the savepoint
771: --

Line 830: when hr_api.cannot_find_prog_unit then

826: p_hierarchy_id => p_hierarchy_id
827: ,p_object_version_number => p_object_version_number
828: );
829: exception
830: when hr_api.cannot_find_prog_unit then
831: hr_api.cannot_find_prog_unit_error
832: (p_module_name => 'DELETE_hierarchy'
833: ,p_hook_type => 'BP'
834: );

Line 831: hr_api.cannot_find_prog_unit_error

827: ,p_object_version_number => p_object_version_number
828: );
829: exception
830: when hr_api.cannot_find_prog_unit then
831: hr_api.cannot_find_prog_unit_error
832: (p_module_name => 'DELETE_hierarchy'
833: ,p_hook_type => 'BP'
834: );
835: --

Line 856: when hr_api.cannot_find_prog_unit then

852: p_hierarchy_id => p_hierarchy_id
853: ,p_object_version_number => l_object_version_number
854: );
855: exception
856: when hr_api.cannot_find_prog_unit then
857: hr_api.cannot_find_prog_unit_error
858: (p_module_name => 'DELETE_hierarchy'
859: ,p_hook_type => 'AP'
860: );

Line 857: hr_api.cannot_find_prog_unit_error

853: ,p_object_version_number => l_object_version_number
854: );
855: exception
856: when hr_api.cannot_find_prog_unit then
857: hr_api.cannot_find_prog_unit_error
858: (p_module_name => 'DELETE_hierarchy'
859: ,p_hook_type => 'AP'
860: );
861: --

Line 871: raise hr_api.validate_enabled;

867: --
868: -- When in validation only mode raise the Validate_Enabled exception
869: --
870: if p_validate then
871: raise hr_api.validate_enabled;
872: end if;
873: --
874: hr_utility.set_location(' Leaving:'||l_proc, 70);
875: --

Line 878: when hr_api.validate_enabled then

874: hr_utility.set_location(' Leaving:'||l_proc, 70);
875: --
876: exception
877: --
878: when hr_api.validate_enabled then
879: --
880: -- As the Validate_Enabled exception has been raised
881: -- we must rollback to the savepoint
882: --