APPS.HR_KI_HIERARCHIES_API SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 157

procedure update_hierarchy_node
  (p_validate                      in     boolean  default false
  ,p_language_code                 in     varchar2 default hr_api.userenv_lang
  ,p_parent_hierarchy_id           in     number   default hr_api.g_number
  ,p_name                          in     varchar2 default hr_api.g_varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,p_hierarchy_id                  in     number
  ,p_object_version_number         in out nocopy   number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'update_hierarchy_node';

Line: 178

  savepoint update_hierarchy_node;

Line: 191

    hr_ki_hierarchies_bk2.update_hierarchy_node_b
      (
       p_language_code           =>    l_language_code
      ,p_parent_hierarchy_id     =>    p_parent_hierarchy_id
      ,p_name                    =>    p_name
      ,p_description             =>    p_description
      ,p_hierarchy_id            =>    p_hierarchy_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 203

        (p_module_name => 'update_hierarchy_node'
        ,p_hook_type   => 'BP'
        );

Line: 230

    hr_ki_hierarchies_bk2.update_hierarchy_node_a
      (
       p_language_code           =>    l_language_code
      ,p_parent_hierarchy_id     =>    p_parent_hierarchy_id
      ,p_name                    =>    p_name
      ,p_description             =>    p_description
      ,p_hierarchy_id            =>    p_hierarchy_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 242

        (p_module_name => 'update_hierarchy_node'
        ,p_hook_type   => 'AP'
        );

Line: 266

    rollback to update_hierarchy_node;

Line: 280

    rollback to update_hierarchy_node;

Line: 290

end update_hierarchy_node;

Line: 297

procedure delete_hierarchy_node
  (
   P_VALIDATE                 in boolean         default false
  ,P_HIERARCHY_ID             in number
  ,P_OBJECT_VERSION_NUMBER    in number
  ) is
  --
  -- Declare cursors and local variables
  --

cursor get_child_ids
is
select hierarchy_id,object_version_number from hr_ki_hierarchies
connect by prior
hierarchy_id=parent_hierarchy_id
start with hierarchy_id=p_hierarchy_id order by level desc;

Line: 316

select hierarchy_node_map_id,object_version_number from hr_ki_hierarchy_node_maps
where hierarchy_id =cur_id;

Line: 320

    select object_version_number
    from        hr_ki_hierarchies
    where       hierarchy_id = p_hierarchy_id;

Line: 324

  l_proc varchar2(72) := g_package||'delete_hierarchy_node';

Line: 334

  savepoint delete_hierarchy_node;

Line: 342

    hr_ki_hierarchies_bk3.delete_hierarchy_node_b
      (
        p_hierarchy_id           => p_hierarchy_id
       ,p_object_version_number  => p_object_version_number

      );

Line: 351

        (p_module_name => 'delete_hierarchy_node'
        ,p_hook_type   => 'BP'
        );

Line: 401

         delete_hierarchy_node_map(
              p_hierarchy_node_map_id   => node_rec.hierarchy_node_map_id
             ,p_object_version_number   => node_rec.object_version_number

         );

Line: 431

    hr_ki_hierarchies_bk3.delete_hierarchy_node_a
      (
       p_hierarchy_id            =>    p_hierarchy_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 439

        (p_module_name => 'delete_hierarchy_node'
        ,p_hook_type   => 'AP'
        );

Line: 461

    rollback to delete_hierarchy_node;

Line: 473

    rollback to delete_hierarchy_node;

Line: 480

end delete_hierarchy_node;

Line: 854

procedure update_hierarchy_node_map
  (p_validate                      in     boolean  default false
  ,p_hierarchy_id                  in     number   default hr_api.g_number
  ,p_topic_id                      in     number   default hr_api.g_number
  ,p_user_interface_id             in     number   default hr_api.g_number
  ,p_hierarchy_node_map_id         in     number
  ,p_object_version_number         in out nocopy   number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'update_hierarchy_node_map';

Line: 873

  savepoint update_hierarchy_node_map;

Line: 882

    hr_ki_hierarchies_bk7.update_hierarchy_node_map_b
      (
       p_topic_id                =>    p_topic_id
      ,p_hierarchy_id            =>    p_hierarchy_id
      ,p_user_interface_id       =>    p_user_interface_id
      ,p_hierarchy_node_map_id   =>    p_hierarchy_node_map_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 893

        (p_module_name => 'update_hierarchy_node_map'
        ,p_hook_type   => 'BP'
        );

Line: 914

    hr_ki_hierarchies_bk7.update_hierarchy_node_map_a
      (
       p_topic_id                =>    p_topic_id
      ,p_hierarchy_id            =>    p_hierarchy_id
      ,p_user_interface_id       =>    p_user_interface_id
      ,p_hierarchy_node_map_id   =>    p_hierarchy_node_map_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 925

        (p_module_name => 'update_hierarchy_node_map'
        ,p_hook_type   => 'AP'
        );

Line: 949

    rollback to update_hierarchy_node_map;

Line: 963

    rollback to update_hierarchy_node_map;

Line: 973

end update_hierarchy_node_map;

Line: 979

procedure delete_hierarchy_node_map
  (
   P_VALIDATE                 in boolean         default false
  ,P_HIERARCHY_NODE_MAP_ID    in number
  ,P_OBJECT_VERSION_NUMBER    in number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc varchar2(72) := g_package||'delete_hierarchy_node_map';

Line: 996

  savepoint delete_hierarchy_node_map;

Line: 1004

    hr_ki_hierarchies_bk8.delete_hierarchy_node_map_b
      (
        p_hierarchy_node_map_id  => p_hierarchy_node_map_id
       ,p_object_version_number  => p_object_version_number

      );

Line: 1013

        (p_module_name => 'delete_hierarchy_node_map'
        ,p_hook_type   => 'BP'
        );

Line: 1033

    hr_ki_hierarchies_bk8.delete_hierarchy_node_map_a
      (
       p_hierarchy_node_map_id   =>    p_hierarchy_node_map_id
      ,p_object_version_number   =>    p_object_version_number
      );

Line: 1041

        (p_module_name => 'delete_hierarchy_node_map'
        ,p_hook_type   => 'AP'
        );

Line: 1063

    rollback to delete_hierarchy_node_map;

Line: 1075

    rollback to delete_hierarchy_node_map;

Line: 1082

end delete_hierarchy_node_map;