27: l_language_code varchar2(30);
28: l_object_version_number number;
29:
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_hierarchy_node;
113: p_hierarchy_id := l_hierarchy_id;
114: p_object_version_number := l_object_version_number;
115:
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 70);
118: exception
119: when hr_api.validate_enabled then
120: --
121: -- As the Validate_Enabled exception has been raised
130:
131: p_hierarchy_id := null;
132: p_object_version_number := null;
133:
134: hr_utility.set_location(' Leaving:'||l_proc, 80);
135: when others then
136: --
137: -- A validation or unexpected error has occured
138: --
144:
145: p_hierarchy_id := null;
146: p_object_version_number := null;
147:
148: hr_utility.set_location(' Leaving:'||l_proc, 90);
149: raise;
150: end create_hierarchy_node;
151:
152: --
170: l_language_code varchar2(30);
171: l_object_version_number number := p_object_version_number;
172:
173: begin
174: hr_utility.set_location('Entering:'|| l_proc, 10);
175: --
176: -- Issue a savepoint
177: --
178: savepoint update_hierarchy_node;
255:
256: -- p_object_version_number := p_object_version_number;
257:
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 70);
260: exception
261: when hr_api.validate_enabled then
262: --
263: -- As the Validate_Enabled exception has been raised
271: --
272:
273: p_object_version_number := l_object_version_number;
274:
275: hr_utility.set_location(' Leaving:'||l_proc, 80);
276: when others then
277: --
278: -- A validation or unexpected error has occured
279: --
284: --
285:
286: p_object_version_number := l_object_version_number;
287:
288: hr_utility.set_location(' Leaving:'||l_proc, 90);
289: raise;
290: end update_hierarchy_node;
291: --
292: --
326: l_found_node_map number(15);
327: l_no number(9);
328:
329: begin
330: hr_utility.set_location('Entering:'|| l_proc, 10);
331: --
332: -- Issue a savepoint
333: --
334: savepoint delete_hierarchy_node;
364: (p_api_name => l_proc
365: ,p_argument => 'HIERARCHY_ID'
366: ,p_argument_value => p_hierarchy_id
367: );
368: hr_utility.set_location(l_proc,6);
369: hr_api.mandatory_arg_error
370: (p_api_name => l_proc
371: ,p_argument => 'OBJECT_VERSION_NUMBER'
372: ,p_argument_value => p_object_version_number
450: -- Set all IN OUT and OUT parameters with out values
451: --
452:
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 70);
455: exception
456: when hr_api.validate_enabled then
457: --
458: -- As the Validate_Enabled exception has been raised
464: -- (Any key or derived arguments must be set to null
465: -- when validation only mode is being used.)
466: --
467:
468: hr_utility.set_location(' Leaving:'||l_proc, 80);
469: when others then
470: --
471: -- A validation or unexpected error has occured
472: --
474: --
475: -- Reset IN OUT parameters and set all
476: -- OUT parameters, including warnings, to null
477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 90);
479: raise;
480: end delete_hierarchy_node;
481:
482: --
498: l_hierarchy_node_map_id number;
499: l_object_version_number number;
500:
501: begin
502: hr_utility.set_location('Entering:'|| l_proc, 10);
503: --
504: -- Issue a savepoint
505: --
506: savepoint create_topic_hierarchy_map;
566: p_hierarchy_node_map_id := l_hierarchy_node_map_id;
567: p_object_version_number := l_object_version_number;
568:
569: --
570: hr_utility.set_location(' Leaving:'||l_proc, 70);
571: exception
572: when hr_api.validate_enabled then
573: --
574: -- As the Validate_Enabled exception has been raised
583:
584: p_hierarchy_node_map_id := null;
585: p_object_version_number := null;
586:
587: hr_utility.set_location(' Leaving:'||l_proc, 80);
588: when others then
589: --
590: -- A validation or unexpected error has occured
591: --
597:
598: p_hierarchy_node_map_id := null;
599: p_object_version_number := null;
600:
601: hr_utility.set_location(' Leaving:'||l_proc, 90);
602: raise;
603: end create_topic_hierarchy_map;
604: --
605: -- ----------------------------------------------------------------------------
620: l_hierarchy_node_map_id number;
621: l_object_version_number number;
622:
623: begin
624: hr_utility.set_location('Entering:'|| l_proc, 10);
625: --
626: -- Issue a savepoint
627: --
628: savepoint create_ui_hierarchy_map;
688: p_hierarchy_node_map_id := l_hierarchy_node_map_id;
689: p_object_version_number := l_object_version_number;
690:
691: --
692: hr_utility.set_location(' Leaving:'||l_proc, 70);
693: exception
694: when hr_api.validate_enabled then
695: --
696: -- As the Validate_Enabled exception has been raised
705:
706: p_hierarchy_node_map_id := null;
707: p_object_version_number := null;
708:
709: hr_utility.set_location(' Leaving:'||l_proc, 80);
710: when others then
711: --
712: -- A validation or unexpected error has occured
713: --
719:
720: p_hierarchy_node_map_id := null;
721: p_object_version_number := null;
722:
723: hr_utility.set_location(' Leaving:'||l_proc, 90);
724: raise;
725: end create_ui_hierarchy_map;
726: --
727: -- ----------------------------------------------------------------------------
742: l_hierarchy_node_map_id number;
743: l_object_version_number number;
744:
745: begin
746: hr_utility.set_location('Entering:'|| l_proc, 10);
747: --
748: -- Issue a savepoint
749: --
750: savepoint create_topic_ui_map;
810: p_hierarchy_node_map_id := l_hierarchy_node_map_id;
811: p_object_version_number := l_object_version_number;
812:
813: --
814: hr_utility.set_location(' Leaving:'||l_proc, 70);
815: exception
816: when hr_api.validate_enabled then
817: --
818: -- As the Validate_Enabled exception has been raised
827:
828: p_hierarchy_node_map_id := null;
829: p_object_version_number := null;
830:
831: hr_utility.set_location(' Leaving:'||l_proc, 80);
832: when others then
833: --
834: -- A validation or unexpected error has occured
835: --
841:
842: p_hierarchy_node_map_id := null;
843: p_object_version_number := null;
844:
845: hr_utility.set_location(' Leaving:'||l_proc, 90);
846: raise;
847: end create_topic_ui_map;
848:
849: --
865: l_proc varchar2(72) := g_package||'update_hierarchy_node_map';
866: l_object_version_number number := p_object_version_number;
867:
868: begin
869: hr_utility.set_location('Entering:'|| l_proc, 10);
870: --
871: -- Issue a savepoint
872: --
873: savepoint update_hierarchy_node_map;
938:
939: -- p_object_version_number := p_object_version_number;
940:
941: --
942: hr_utility.set_location(' Leaving:'||l_proc, 70);
943: exception
944: when hr_api.validate_enabled then
945: --
946: -- As the Validate_Enabled exception has been raised
954: --
955:
956: p_object_version_number := l_object_version_number;
957:
958: hr_utility.set_location(' Leaving:'||l_proc, 80);
959: when others then
960: --
961: -- A validation or unexpected error has occured
962: --
967: --
968:
969: p_object_version_number := l_object_version_number;
970:
971: hr_utility.set_location(' Leaving:'||l_proc, 90);
972: raise;
973: end update_hierarchy_node_map;
974:
975: -- ----------------------------------------------------------------------------
988:
989: l_proc varchar2(72) := g_package||'delete_hierarchy_node_map';
990:
991: begin
992: hr_utility.set_location('Entering:'|| l_proc, 10);
993: --
994: -- Issue a savepoint
995: --
996: savepoint delete_hierarchy_node_map;
1052: -- Set all IN OUT and OUT parameters with out values
1053: --
1054:
1055: --
1056: hr_utility.set_location(' Leaving:'||l_proc, 70);
1057: exception
1058: when hr_api.validate_enabled then
1059: --
1060: -- As the Validate_Enabled exception has been raised
1066: -- (Any key or derived arguments must be set to null
1067: -- when validation only mode is being used.)
1068: --
1069:
1070: hr_utility.set_location(' Leaving:'||l_proc, 80);
1071: when others then
1072: --
1073: -- A validation or unexpected error has occured
1074: --
1076: --
1077: -- Reset IN OUT parameters and set all
1078: -- OUT parameters, including warnings, to null
1079: --
1080: hr_utility.set_location(' Leaving:'||l_proc, 90);
1081: raise;
1082: end delete_hierarchy_node_map;
1083:
1084: