APPS.HR_HIERARCHY_ELEMENT_INTERNAL SQL Statements

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

Line: 164

procedure update_hier_element_internal
  (p_org_structure_element_id      in     number
  ,p_effective_date                in     date
  ,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_proc                varchar2(72) := g_package||'update_hier_element_internal';

Line: 194

  hr_hierarchy_element_api.update_hierarchy_element
  (p_validate                      => false
  ,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_effective_date                => p_effective_date
  ,p_pos_control_enabled_flag      => p_pos_control_enabled_flag
  ,p_object_version_number         => l_object_version_number
  );

Line: 212

end update_hier_element_internal;

Line: 268

procedure delete_hier_element_internal
  (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_hier_element_internal';

Line: 297

  hr_hierarchy_element_api.delete_hierarchy_element
  (p_validate                      => false
  ,p_org_structure_element_id      => p_org_structure_element_id
  ,p_object_version_number         => p_object_version_number
  ,p_hr_installed                  => p_hr_installed
  ,p_pa_installed                  => p_pa_installed
  ,p_exists_in_hierarchy           => l_exists_in_hierarchy
  );

Line: 315

end delete_hier_element_internal;