146: ,p_identifier_key => NULL
147: ,p_description => p_description);
148:
149: exception
150: when hr_api.cannot_find_prog_unit then
151: hr_api.cannot_find_prog_unit_error
152: (p_module_name => 'create_node_type_b'
153: ,p_hook_type => 'BP'
154: );
147: ,p_description => p_description);
148:
149: exception
150: when hr_api.cannot_find_prog_unit then
151: hr_api.cannot_find_prog_unit_error
152: (p_module_name => 'create_node_type_b'
153: ,p_hook_type => 'BP'
154: );
155: end;
185: ,p_hier_node_type_id => l_hier_node_type_id
186: ,p_object_version_number => l_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'create_node_type_a'
192: ,p_hook_type => 'AP'
193: );
186: ,p_object_version_number => l_object_version_number
187: );
188: exception
189: when hr_api.cannot_find_prog_unit then
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'create_node_type_a'
192: ,p_hook_type => 'AP'
193: );
194: end;
195: --
196: -- When in validation only mode raise the Validate_Enabled exception
197: --
198: if p_validate then
199: raise hr_api.validate_enabled;
200: end if;
201: --
202: -- Set all output arguments
203: --
205: p_object_version_number := l_object_version_number;
206: --
207: hr_utility.set_location(' Leaving:'||l_proc, 70);
208: exception
209: when hr_api.validate_enabled then
210: --
211: -- As the Validate_Enabled exception has been raised
212: -- we must rollback to the savepoint
213: --
237: (p_validate in boolean default false
238: ,p_effective_date in date
239: ,p_hier_node_type_id in number
240: ,p_object_version_number in out nocopy number
241: ,p_child_node_name in varchar2 default hr_api.g_varchar2
242: ,p_child_value_set in varchar2 default hr_api.g_varchar2
243: ,p_parent_node_type in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ) is
238: ,p_effective_date in date
239: ,p_hier_node_type_id in number
240: ,p_object_version_number in out nocopy number
241: ,p_child_node_name in varchar2 default hr_api.g_varchar2
242: ,p_child_value_set in varchar2 default hr_api.g_varchar2
243: ,p_parent_node_type in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ) is
246: --
239: ,p_hier_node_type_id in number
240: ,p_object_version_number in out nocopy number
241: ,p_child_node_name in varchar2 default hr_api.g_varchar2
242: ,p_child_value_set in varchar2 default hr_api.g_varchar2
243: ,p_parent_node_type in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ) is
246: --
247: -- Declare cursors and local variables
240: ,p_object_version_number in out nocopy number
241: ,p_child_node_name in varchar2 default hr_api.g_varchar2
242: ,p_child_value_set in varchar2 default hr_api.g_varchar2
243: ,p_parent_node_type in varchar2 default hr_api.g_varchar2
244: ,p_description in varchar2 default hr_api.g_varchar2
245: ) is
246: --
247: -- Declare cursors and local variables
248: --
269: --
270: begin
271: hr_utility.set_location('Entering:'|| l_proc, 10);
272: --
273: hr_api.mandatory_arg_error(P_API_NAME => l_proc
274: ,P_ARGUMENT => 'p_hier_node_type_id'
275: ,P_ARGUMENT_VALUE => p_hier_node_type_id );
276: --
277: -- Issue a savepoint
379: ,p_parent_node_type => p_parent_node_type
380: ,p_description => p_description
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'update_node_type_b'
386: ,p_hook_type => 'BP'
387: );
380: ,p_description => p_description
381: );
382: exception
383: when hr_api.cannot_find_prog_unit then
384: hr_api.cannot_find_prog_unit_error
385: (p_module_name => 'update_node_type_b'
386: ,p_hook_type => 'BP'
387: );
388: end;
412: ,p_parent_node_type => p_parent_node_type
413: ,p_description => p_description
414: );
415: exception
416: when hr_api.cannot_find_prog_unit then
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'update_node_type_a'
419: ,p_hook_type => 'AP'
420: );
413: ,p_description => p_description
414: );
415: exception
416: when hr_api.cannot_find_prog_unit then
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'update_node_type_a'
419: ,p_hook_type => 'AP'
420: );
421: end;
422: --
423: -- When in validation only mode raise the Validate_Enabled exception
424: --
425: if p_validate then
426: raise hr_api.validate_enabled;
427: end if;
428: --
429: -- Set all output arguments
430: --
431: p_object_version_number := l_object_version_number;
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 70);
434: exception
435: when hr_api.validate_enabled then
436: --
437: -- As the Validate_Enabled exception has been raised
438: -- we must rollback to the savepoint
439: --
478: begin
479: hr_utility.set_location('Entering:'|| l_proc, 5);
480: --
481:
482: hr_api.mandatory_arg_error(P_API_NAME => l_proc
483: ,P_ARGUMENT => 'p_hier_node_type_id'
484: ,P_ARGUMENT_VALUE => p_hier_node_type_id );
485: --
486: -- Issue a savepoint if operating in validation only mode.
511: (p_hier_node_type_id => p_hier_node_type_id,
512: p_object_version_number => p_object_version_number
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'delete_node_type_b',
518: p_hook_type => 'BP'
519: );
512: p_object_version_number => p_object_version_number
513: );
514: exception
515: when hr_api.cannot_find_prog_unit then
516: hr_api.cannot_find_prog_unit_error
517: (p_module_name => 'delete_node_type_b',
518: p_hook_type => 'BP'
519: );
520: end;
553: (p_hier_node_type_id => p_hier_node_type_id,
554: p_object_version_number => p_object_version_number
555: );
556: exception
557: when hr_api.cannot_find_prog_unit then
558: hr_api.cannot_find_prog_unit_error
559: (p_module_name => 'delete_node_type_a',
560: p_hook_type => 'AP'
561: );
554: p_object_version_number => p_object_version_number
555: );
556: exception
557: when hr_api.cannot_find_prog_unit then
558: hr_api.cannot_find_prog_unit_error
559: (p_module_name => 'delete_node_type_a',
560: p_hook_type => 'AP'
561: );
562: end;
563: --
564: -- When in validation only mode raise the Validate_Enabled exception
565: --
566: if p_validate then
567: raise hr_api.validate_enabled;
568: end if;
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 11);
571: exception
568: end if;
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 11);
571: exception
572: when hr_api.validate_enabled then
573: --
574: -- As the Validate_Enabled exception has been raised
575: -- we must rollback to the savepoint
576: --