145: --
146: -- Declare cursors and local variables
147: --
148: l_proc VARCHAR2(72) := g_package||'create_organization_structure';
149: l_organization_structure_id per_organization_Structures.organization_structure_id%TYPE;
150: l_object_version_number per_organization_structures.object_version_number%TYPE;
151: --
152: BEGIN
153: hr_utility.set_location('Entering:'|| l_proc, 10);
146: -- Declare cursors and local variables
147: --
148: l_proc VARCHAR2(72) := g_package||'create_organization_structure';
149: l_organization_structure_id per_organization_Structures.organization_structure_id%TYPE;
150: l_object_version_number per_organization_structures.object_version_number%TYPE;
151: --
152: BEGIN
153: hr_utility.set_location('Entering:'|| l_proc, 10);
154: --
384: --
385: -- Declare cursors and local variables
386: --
387: l_proc VARCHAR2(72) := g_package||'update_organization_structures';
388: l_object_version_number per_organization_structures.object_version_number%TYPE;
389: l_ovn per_organization_structures.object_version_number%TYPE := p_object_version_number;
390: BEGIN
391:
392: --
385: -- Declare cursors and local variables
386: --
387: l_proc VARCHAR2(72) := g_package||'update_organization_structures';
388: l_object_version_number per_organization_structures.object_version_number%TYPE;
389: l_ovn per_organization_structures.object_version_number%TYPE := p_object_version_number;
390: BEGIN
391:
392: --
393: -- Issue a savepoint.