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