187: ,p_information30 => p_information30
188: ,p_effective_date => p_effective_date
189: );
190: exception
191: when hr_api.cannot_find_prog_unit then
192: hr_api.cannot_find_prog_unit_error
193: (
194: p_module_name => 'CREATE_hierarchy_nodes'
195: ,p_hook_type => 'BP'
188: ,p_effective_date => p_effective_date
189: );
190: exception
191: when hr_api.cannot_find_prog_unit then
192: hr_api.cannot_find_prog_unit_error
193: (
194: p_module_name => 'CREATE_hierarchy_nodes'
195: ,p_hook_type => 'BP'
196: );
360: ,p_information30 => p_information30
361: ,p_effective_date => p_effective_date
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'CREATE_hierarchy_nodes'
367: ,p_hook_type => 'AP'
368: );
361: ,p_effective_date => p_effective_date
362: );
363: exception
364: when hr_api.cannot_find_prog_unit then
365: hr_api.cannot_find_prog_unit_error
366: (p_module_name => 'CREATE_hierarchy_nodes'
367: ,p_hook_type => 'AP'
368: );
369: --
375: --
376: -- When in validation only mode raise the Validate_Enabled exception
377: --
378: if p_validate then
379: raise hr_api.validate_enabled;
380: end if;
381: --
382: -- Set all output arguments
383: --
387: hr_utility.set_location(' Leaving:'||l_proc, 70);
388: --
389: exception
390: --
391: when hr_api.validate_enabled then
392: --
393: -- As the Validate_Enabled exception has been raised
394: -- we must rollback to the savepoint
395: --
419: --
420: procedure update_hierarchy_nodes
421: (p_validate in boolean default false
422: ,p_hierarchy_node_id in number
423: ,p_entity_id in varchar2 default hr_api.g_varchar2
424: ,p_node_type in varchar2 default hr_api.g_varchar2
425: ,p_seq in number default hr_api.g_number
426: ,p_parent_hierarchy_node_id in number default hr_api.g_number
427: ,p_request_id in number default hr_api.g_number
420: procedure update_hierarchy_nodes
421: (p_validate in boolean default false
422: ,p_hierarchy_node_id in number
423: ,p_entity_id in varchar2 default hr_api.g_varchar2
424: ,p_node_type in varchar2 default hr_api.g_varchar2
425: ,p_seq in number default hr_api.g_number
426: ,p_parent_hierarchy_node_id in number default hr_api.g_number
427: ,p_request_id in number default hr_api.g_number
428: ,p_program_application_id in number default hr_api.g_number
421: (p_validate in boolean default false
422: ,p_hierarchy_node_id in number
423: ,p_entity_id in varchar2 default hr_api.g_varchar2
424: ,p_node_type in varchar2 default hr_api.g_varchar2
425: ,p_seq in number default hr_api.g_number
426: ,p_parent_hierarchy_node_id in number default hr_api.g_number
427: ,p_request_id in number default hr_api.g_number
428: ,p_program_application_id in number default hr_api.g_number
429: ,p_program_id in number default hr_api.g_number
422: ,p_hierarchy_node_id in number
423: ,p_entity_id in varchar2 default hr_api.g_varchar2
424: ,p_node_type in varchar2 default hr_api.g_varchar2
425: ,p_seq in number default hr_api.g_number
426: ,p_parent_hierarchy_node_id in number default hr_api.g_number
427: ,p_request_id in number default hr_api.g_number
428: ,p_program_application_id in number default hr_api.g_number
429: ,p_program_id in number default hr_api.g_number
430: ,p_program_update_date in date default hr_api.g_date
423: ,p_entity_id in varchar2 default hr_api.g_varchar2
424: ,p_node_type in varchar2 default hr_api.g_varchar2
425: ,p_seq in number default hr_api.g_number
426: ,p_parent_hierarchy_node_id in number default hr_api.g_number
427: ,p_request_id in number default hr_api.g_number
428: ,p_program_application_id in number default hr_api.g_number
429: ,p_program_id in number default hr_api.g_number
430: ,p_program_update_date in date default hr_api.g_date
431: ,p_object_version_number in out nocopy number
424: ,p_node_type in varchar2 default hr_api.g_varchar2
425: ,p_seq in number default hr_api.g_number
426: ,p_parent_hierarchy_node_id in number default hr_api.g_number
427: ,p_request_id in number default hr_api.g_number
428: ,p_program_application_id in number default hr_api.g_number
429: ,p_program_id in number default hr_api.g_number
430: ,p_program_update_date in date default hr_api.g_date
431: ,p_object_version_number in out nocopy number
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
425: ,p_seq in number default hr_api.g_number
426: ,p_parent_hierarchy_node_id in number default hr_api.g_number
427: ,p_request_id in number default hr_api.g_number
428: ,p_program_application_id in number default hr_api.g_number
429: ,p_program_id in number default hr_api.g_number
430: ,p_program_update_date in date default hr_api.g_date
431: ,p_object_version_number in out nocopy number
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
426: ,p_parent_hierarchy_node_id in number default hr_api.g_number
427: ,p_request_id in number default hr_api.g_number
428: ,p_program_application_id in number default hr_api.g_number
429: ,p_program_id in number default hr_api.g_number
430: ,p_program_update_date in date default hr_api.g_date
431: ,p_object_version_number in out nocopy number
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_program_application_id in number default hr_api.g_number
429: ,p_program_id in number default hr_api.g_number
430: ,p_program_update_date in date default hr_api.g_date
431: ,p_object_version_number in out nocopy number
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
429: ,p_program_id in number default hr_api.g_number
430: ,p_program_update_date in date default hr_api.g_date
431: ,p_object_version_number in out nocopy number
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
430: ,p_program_update_date in date default hr_api.g_date
431: ,p_object_version_number in out nocopy number
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
431: ,p_object_version_number in out nocopy number
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
432: ,p_attribute_category in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
433: ,p_attribute1 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
434: ,p_attribute2 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
435: ,p_attribute3 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
436: ,p_attribute4 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
437: ,p_attribute5 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
438: ,p_attribute6 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
439: ,p_attribute7 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
440: ,p_attribute8 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
441: ,p_attribute9 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
442: ,p_attribute10 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
443: ,p_attribute11 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
444: ,p_attribute12 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
445: ,p_attribute13 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
446: ,p_attribute14 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
447: ,p_attribute15 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
448: ,p_attribute16 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
449: ,p_attribute17 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
450: ,p_attribute18 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
451: ,p_attribute19 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
452: ,p_attribute20 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
453: ,p_attribute21 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
454: ,p_attribute22 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
455: ,p_attribute23 in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
456: ,p_attribute24 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
457: ,p_attribute25 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
458: ,p_attribute26 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
459: ,p_attribute27 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
460: ,p_attribute28 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
461: ,p_attribute29 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
462: ,p_attribute30 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
463: ,p_information_category in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
464: ,p_information1 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
465: ,p_information2 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
466: ,p_information3 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
467: ,p_information4 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
468: ,p_information5 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
469: ,p_information6 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
470: ,p_information7 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
471: ,p_information8 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
472: ,p_information9 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
473: ,p_information10 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
474: ,p_information11 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
475: ,p_information12 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
476: ,p_information13 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
477: ,p_information14 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
478: ,p_information15 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
479: ,p_information16 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
487: ,p_information24 in varchar2 default hr_api.g_varchar2
480: ,p_information17 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
487: ,p_information24 in varchar2 default hr_api.g_varchar2
488: ,p_information25 in varchar2 default hr_api.g_varchar2
481: ,p_information18 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
487: ,p_information24 in varchar2 default hr_api.g_varchar2
488: ,p_information25 in varchar2 default hr_api.g_varchar2
489: ,p_information26 in varchar2 default hr_api.g_varchar2
482: ,p_information19 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
487: ,p_information24 in varchar2 default hr_api.g_varchar2
488: ,p_information25 in varchar2 default hr_api.g_varchar2
489: ,p_information26 in varchar2 default hr_api.g_varchar2
490: ,p_information27 in varchar2 default hr_api.g_varchar2
483: ,p_information20 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
487: ,p_information24 in varchar2 default hr_api.g_varchar2
488: ,p_information25 in varchar2 default hr_api.g_varchar2
489: ,p_information26 in varchar2 default hr_api.g_varchar2
490: ,p_information27 in varchar2 default hr_api.g_varchar2
491: ,p_information28 in varchar2 default hr_api.g_varchar2
484: ,p_information21 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
487: ,p_information24 in varchar2 default hr_api.g_varchar2
488: ,p_information25 in varchar2 default hr_api.g_varchar2
489: ,p_information26 in varchar2 default hr_api.g_varchar2
490: ,p_information27 in varchar2 default hr_api.g_varchar2
491: ,p_information28 in varchar2 default hr_api.g_varchar2
492: ,p_information29 in varchar2 default hr_api.g_varchar2
485: ,p_information22 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
487: ,p_information24 in varchar2 default hr_api.g_varchar2
488: ,p_information25 in varchar2 default hr_api.g_varchar2
489: ,p_information26 in varchar2 default hr_api.g_varchar2
490: ,p_information27 in varchar2 default hr_api.g_varchar2
491: ,p_information28 in varchar2 default hr_api.g_varchar2
492: ,p_information29 in varchar2 default hr_api.g_varchar2
493: ,p_information30 in varchar2 default hr_api.g_varchar2
486: ,p_information23 in varchar2 default hr_api.g_varchar2
487: ,p_information24 in varchar2 default hr_api.g_varchar2
488: ,p_information25 in varchar2 default hr_api.g_varchar2
489: ,p_information26 in varchar2 default hr_api.g_varchar2
490: ,p_information27 in varchar2 default hr_api.g_varchar2
491: ,p_information28 in varchar2 default hr_api.g_varchar2
492: ,p_information29 in varchar2 default hr_api.g_varchar2
493: ,p_information30 in varchar2 default hr_api.g_varchar2
494: ,p_effective_date in date
487: ,p_information24 in varchar2 default hr_api.g_varchar2
488: ,p_information25 in varchar2 default hr_api.g_varchar2
489: ,p_information26 in varchar2 default hr_api.g_varchar2
490: ,p_information27 in varchar2 default hr_api.g_varchar2
491: ,p_information28 in varchar2 default hr_api.g_varchar2
492: ,p_information29 in varchar2 default hr_api.g_varchar2
493: ,p_information30 in varchar2 default hr_api.g_varchar2
494: ,p_effective_date in date
495: ) is
488: ,p_information25 in varchar2 default hr_api.g_varchar2
489: ,p_information26 in varchar2 default hr_api.g_varchar2
490: ,p_information27 in varchar2 default hr_api.g_varchar2
491: ,p_information28 in varchar2 default hr_api.g_varchar2
492: ,p_information29 in varchar2 default hr_api.g_varchar2
493: ,p_information30 in varchar2 default hr_api.g_varchar2
494: ,p_effective_date in date
495: ) is
496: --
489: ,p_information26 in varchar2 default hr_api.g_varchar2
490: ,p_information27 in varchar2 default hr_api.g_varchar2
491: ,p_information28 in varchar2 default hr_api.g_varchar2
492: ,p_information29 in varchar2 default hr_api.g_varchar2
493: ,p_information30 in varchar2 default hr_api.g_varchar2
494: ,p_effective_date in date
495: ) is
496: --
497: -- Declare cursors and local variables
594: ,p_information30 => p_information30
595: ,p_effective_date => p_effective_date
596: );
597: exception
598: when hr_api.cannot_find_prog_unit then
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'UPDATE_hierarchy_nodes'
601: ,p_hook_type => 'BP'
602: );
595: ,p_effective_date => p_effective_date
596: );
597: exception
598: when hr_api.cannot_find_prog_unit then
599: hr_api.cannot_find_prog_unit_error
600: (p_module_name => 'UPDATE_hierarchy_nodes'
601: ,p_hook_type => 'BP'
602: );
603: --
762: ,p_information30 => p_information30
763: ,p_effective_date => p_effective_date
764: );
765: exception
766: when hr_api.cannot_find_prog_unit then
767: hr_api.cannot_find_prog_unit_error
768: (p_module_name => 'UPDATE_hierarchy_nodes'
769: ,p_hook_type => 'AP'
770: );
763: ,p_effective_date => p_effective_date
764: );
765: exception
766: when hr_api.cannot_find_prog_unit then
767: hr_api.cannot_find_prog_unit_error
768: (p_module_name => 'UPDATE_hierarchy_nodes'
769: ,p_hook_type => 'AP'
770: );
771: --
777: --
778: -- When in validation only mode raise the Validate_Enabled exception
779: --
780: if p_validate then
781: raise hr_api.validate_enabled;
782: end if;
783: --
784: -- Set all output arguments
785: --
788: hr_utility.set_location(' Leaving:'||l_proc, 70);
789: --
790: exception
791: --
792: when hr_api.validate_enabled then
793: --
794: -- As the Validate_Enabled exception has been raised
795: -- we must rollback to the savepoint
796: --
851: p_hierarchy_node_id => p_hierarchy_node_id
852: ,p_object_version_number => p_object_version_number
853: );
854: exception
855: when hr_api.cannot_find_prog_unit then
856: hr_api.cannot_find_prog_unit_error
857: (p_module_name => 'DELETE_hierarchy_nodes'
858: ,p_hook_type => 'BP'
859: );
852: ,p_object_version_number => p_object_version_number
853: );
854: exception
855: when hr_api.cannot_find_prog_unit then
856: hr_api.cannot_find_prog_unit_error
857: (p_module_name => 'DELETE_hierarchy_nodes'
858: ,p_hook_type => 'BP'
859: );
860: --
877: p_hierarchy_node_id => p_hierarchy_node_id
878: ,p_object_version_number => l_object_version_number
879: );
880: exception
881: when hr_api.cannot_find_prog_unit then
882: hr_api.cannot_find_prog_unit_error
883: (p_module_name => 'DELETE_hierarchy_nodes'
884: ,p_hook_type => 'AP'
885: );
878: ,p_object_version_number => l_object_version_number
879: );
880: exception
881: when hr_api.cannot_find_prog_unit then
882: hr_api.cannot_find_prog_unit_error
883: (p_module_name => 'DELETE_hierarchy_nodes'
884: ,p_hook_type => 'AP'
885: );
886: --
892: --
893: -- When in validation only mode raise the Validate_Enabled exception
894: --
895: if p_validate then
896: raise hr_api.validate_enabled;
897: end if;
898: --
899: hr_utility.set_location(' Leaving:'||l_proc, 70);
900: --
899: hr_utility.set_location(' Leaving:'||l_proc, 70);
900: --
901: exception
902: --
903: when hr_api.validate_enabled then
904: --
905: -- As the Validate_Enabled exception has been raised
906: -- we must rollback to the savepoint
907: --