95: l_object_version_number per_gen_hierarchy_nodes.object_version_number%TYPE;
96: --
97: begin
98: --
99: hr_utility.set_location('Entering:'|| l_proc, 10);
100: hr_utility.set_location(p_effective_date||'Entering:'|| l_proc, 10);
101: --
102: -- Issue a savepoint if operating in validation only mode
103: --
96: --
97: begin
98: --
99: hr_utility.set_location('Entering:'|| l_proc, 10);
100: hr_utility.set_location(p_effective_date||'Entering:'|| l_proc, 10);
101: --
102: -- Issue a savepoint if operating in validation only mode
103: --
104: savepoint create_hierarchy_nodes;
102: -- Issue a savepoint if operating in validation only mode
103: --
104: savepoint create_hierarchy_nodes;
105: --
106: hr_utility.set_location(l_proc, 20);
107: --
108: -- Process Logic
109: --
110: begin
370: -- End of API User Hook for the after hook of create_hierarchy_nodes
371: --
372: end;
373: --
374: hr_utility.set_location(l_proc, 60);
375: --
376: -- When in validation only mode raise the Validate_Enabled exception
377: --
378: if p_validate then
383: --
384: p_hierarchy_node_id := l_hierarchy_node_id;
385: p_object_version_number := l_object_version_number;
386: --
387: hr_utility.set_location(' Leaving:'||l_proc, 70);
388: --
389: exception
390: --
391: when hr_api.validate_enabled then
400: -- when validation only mode is being used.)
401: --
402: p_hierarchy_node_id := null;
403: p_object_version_number := null;
404: hr_utility.set_location(' Leaving:'||l_proc, 80);
405: --
406: when others then
407: --
408: -- A validation or unexpected error has occured
501: l_temp_ovn number := p_object_version_number;
502: --
503: begin
504: --
505: hr_utility.set_location('Entering:'|| l_proc, 10);
506: --
507: -- Issue a savepoint if operating in validation only mode
508: --
509: savepoint update_hierarchy_nodes;
507: -- Issue a savepoint if operating in validation only mode
508: --
509: savepoint update_hierarchy_nodes;
510: --
511: hr_utility.set_location(l_proc, 20);
512: --
513: -- Process Logic
514: --
515: l_object_version_number := p_object_version_number;
772: -- End of API User Hook for the after hook of update_hierarchy_nodes
773: --
774: end;
775: --
776: hr_utility.set_location(l_proc, 60);
777: --
778: -- When in validation only mode raise the Validate_Enabled exception
779: --
780: if p_validate then
784: -- Set all output arguments
785: --
786: p_object_version_number := l_object_version_number;
787: --
788: hr_utility.set_location(' Leaving:'||l_proc, 70);
789: --
790: exception
791: --
792: when hr_api.validate_enabled then
799: -- Only set output warning arguments
800: -- (Any key or derived arguments must be set to null
801: -- when validation only mode is being used.)
802: --
803: hr_utility.set_location(' Leaving:'||l_proc, 80);
804: --
805: when others then
806: --
807: -- A validation or unexpected error has occured
828: l_temp_ovn number := p_object_version_number;
829: --
830: begin
831: --
832: hr_utility.set_location('Entering:'|| l_proc, 10);
833: --
834: -- Issue a savepoint if operating in validation only mode
835: --
836: savepoint delete_hierarchy_nodes;
834: -- Issue a savepoint if operating in validation only mode
835: --
836: savepoint delete_hierarchy_nodes;
837: --
838: hr_utility.set_location(l_proc, 20);
839: --
840: -- Process Logic
841: --
842: l_object_version_number := p_object_version_number;
887: -- End of API User Hook for the after hook of delete_hierarchy_nodes
888: --
889: end;
890: --
891: hr_utility.set_location(l_proc, 60);
892: --
893: -- When in validation only mode raise the Validate_Enabled exception
894: --
895: if p_validate then
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: --
901: exception
902: --
903: when hr_api.validate_enabled then
938: l_proc varchar2(72) := g_package||'lck';
939: --
940: begin
941: --
942: hr_utility.set_location('Entering:'|| l_proc, 10);
943: --
944: per_pgn_shd.lck
945: (
946: p_hierarchy_node_id => p_hierarchy_node_id
946: p_hierarchy_node_id => p_hierarchy_node_id
947: ,p_object_version_number => p_object_version_number
948: );
949: --
950: hr_utility.set_location(' Leaving:'||l_proc, 70);
951: --
952: end lck;
953: --
954: end per_hierarchy_nodes_api;