APPS.HR_HIERARCHY_ELEMENT_API SQL Statements

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

Line: 46

  cursor get_old_element is select org_structure_element_id,
  object_version_number
  from per_org_structure_elements
  where organization_id_child = p_Organization_Id_Child
  and   org_structure_version_id = p_org_structure_version_id;

Line: 54

  cursor c_date_from is select date_from
  from per_org_structure_versions
  where org_structure_version_id= p_org_structure_version_id;

Line: 58

  cursor c_org_flag is select VIEW_ALL_ORGANIZATIONS_FLAG
  from per_security_profiles
  where security_profile_id= l_security_profile_id;

Line: 316

procedure update_hierarchy_element
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_org_structure_element_id      in     number
  ,p_organization_id_parent        in     number   default hr_api.g_number
  ,p_organization_id_child         in     number   default hr_api.g_number
  ,p_pos_control_enabled_flag      in     varchar2 default hr_api.g_varchar2
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 329

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

Line: 340

  savepoint update_hierarchy_element;

Line: 350

    hr_hierarchy_element_bk2.update_hierarchy_element_b
     (p_effective_date                 =>     p_effective_date
     ,p_org_structure_element_id       =>     p_org_structure_element_id
     ,p_organization_id_parent         =>     p_organization_id_parent
     ,p_organization_id_child          =>     p_organization_id_child
     ,p_pos_control_enabled_flag       =>     p_pos_control_enabled_flag
     ,p_object_version_number          =>     p_object_version_number
     );

Line: 361

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

Line: 389

    hr_hierarchy_element_bk2.update_hierarchy_element_a
     (p_effective_date                 =>     p_effective_date
     ,p_org_structure_element_id       =>     p_org_structure_element_id
     ,p_organization_id_parent         =>     p_organization_id_parent
     ,p_organization_id_child          =>     p_organization_id_child
     ,p_pos_control_enabled_flag       =>     p_pos_control_enabled_flag
     ,p_object_version_number          =>     p_object_version_number
     );

Line: 400

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

Line: 422

    rollback to update_hierarchy_element;

Line: 434

    rollback to update_hierarchy_element;

Line: 441

end update_hierarchy_element;

Line: 447

procedure delete_hierarchy_element
  (p_validate                      in     boolean  default false
  ,p_org_structure_element_id      in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_hierarchy_element';

Line: 462

  savepoint delete_hierarchy_element;

Line: 471

    hr_hierarchy_element_bk3.delete_hierarchy_element_b
     (p_org_structure_element_id       =>     p_org_structure_element_id
     ,p_object_version_number          =>     p_object_version_number
     );

Line: 478

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

Line: 506

    hr_hierarchy_element_bk3.delete_hierarchy_element_a
     (p_org_structure_element_id       =>     p_org_structure_element_id
     ,p_object_version_number          =>     p_object_version_number
     );

Line: 513

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

Line: 534

    rollback to delete_hierarchy_element;

Line: 545

    rollback to delete_hierarchy_element;

Line: 552

end delete_hierarchy_element;

Line: 558

procedure delete_hierarchy_element
  (p_validate                      in     boolean  default false
  ,p_org_structure_element_id      in     number
  ,p_object_version_number         in     number
  ,p_hr_installed                  in     VARCHAR2
  ,p_pa_installed                  in     VARCHAR2
  ,p_exists_in_hierarchy           in out nocopy VARCHAR2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'delete_hierarchy_element- old';

Line: 576

  savepoint delete_hierarchy_element;

Line: 578

  delete_hierarchy_element
  (p_validate                     =>   p_validate
  ,p_org_structure_element_id     =>   p_org_structure_element_id
  ,p_object_version_number        =>   p_object_version_number
  );

Line: 588

end delete_hierarchy_element;