86: ) is
87: --
88: -- Declare cursors and local variables
89: --
90: l_hierarchy_id per_gen_hierarchy.hierarchy_id%TYPE;
91: l_proc varchar2(72) := g_package||'create_hierarchy';
92: l_object_version_number per_gen_hierarchy.object_version_number%TYPE;
93: --
94: begin
88: -- Declare cursors and local variables
89: --
90: l_hierarchy_id per_gen_hierarchy.hierarchy_id%TYPE;
91: l_proc varchar2(72) := g_package||'create_hierarchy';
92: l_object_version_number per_gen_hierarchy.object_version_number%TYPE;
93: --
94: begin
95: --
96: hr_utility.set_location('Entering:'|| l_proc, 10);
481: --
482: -- Declare cursors and local variables
483: --
484: l_proc varchar2(72) := g_package||'update_hierarchy';
485: l_object_version_number per_gen_hierarchy.object_version_number%TYPE;
486: --
487: begin
488: --
489: hr_utility.set_location('Entering:'|| l_proc, 10);
799: --
800: -- Declare cursors and local variables
801: --
802: l_proc varchar2(72) := g_package||'update_hierarchy';
803: l_object_version_number per_gen_hierarchy.object_version_number%TYPE;
804: --
805: begin
806: --
807: hr_utility.set_location('Entering:'|| l_proc, 10);