APPS.HR_POS_HIERARCHY_ELE_SWI SQL Statements

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

Line: 225

PROCEDURE delete_pos_hierarchy_ele
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_pos_structure_element_id     in     number
  ,p_object_version_number        in     number
  ,p_hr_installed                 in     varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 239

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

Line: 245

  savepoint delete_pos_hierarchy_ele_swi;

Line: 265

  hr_pos_hierarchy_ele_api.delete_pos_hierarchy_ele
    (p_validate                     => l_validate
    ,p_pos_structure_element_id     => p_pos_structure_element_id
    ,p_object_version_number        => p_object_version_number
    ,p_hr_installed                 => p_hr_installed
    );

Line: 293

    rollback to delete_pos_hierarchy_ele_swi;

Line: 307

    rollback to delete_pos_hierarchy_ele_swi;

Line: 317

end delete_pos_hierarchy_ele;

Line: 321

PROCEDURE delete_pos_hier_elem_internal
  (p_pos_structure_element_id     in     number
  ,p_object_version_number        in     number
  ,p_hr_installed                 in     varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  --
  -- Other variables
  l_proc    varchar2(72) := g_package ||'delete_pos_hier_elem_internal';

Line: 339

  savepoint delete_poshiereleminternal_swi;

Line: 356

  hr_pos_hierarchy_ele_api.delete_pos_hier_elem_internal
    (p_pos_structure_element_id     => p_pos_structure_element_id
    ,p_object_version_number        => p_object_version_number
    ,p_hr_installed                 => p_hr_installed
    );

Line: 383

    rollback to delete_poshiereleminternal_swi;

Line: 397

    rollback to delete_poshiereleminternal_swi;

Line: 407

end delete_pos_hier_elem_internal;

Line: 411

PROCEDURE update_pos_hierarchy_ele
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_pos_structure_element_id     in     number
  ,p_effective_date               in     date
  ,p_parent_position_id           in     number    default hr_api.g_number
  ,p_subordinate_position_id      in     number    default hr_api.g_number
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 428

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

Line: 434

  savepoint update_pos_hierarchy_ele_swi;

Line: 455

  hr_pos_hierarchy_ele_api.update_pos_hierarchy_ele
    (p_validate                     => l_validate
    ,p_pos_structure_element_id     => p_pos_structure_element_id
    ,p_parent_position_id           => p_parent_position_id
    ,p_effective_date               => p_effective_date
    ,p_subordinate_position_id      => p_subordinate_position_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 485

    rollback to update_pos_hierarchy_ele_swi;

Line: 500

    rollback to update_pos_hierarchy_ele_swi;

Line: 511

end update_pos_hierarchy_ele;

Line: 515

PROCEDURE update_pos_hier_elem_internal
  (p_pos_structure_element_id     in     number
  ,p_parent_position_id           in     number    default hr_api.g_number
  ,p_subordinate_position_id      in     number    default hr_api.g_number
  ,p_effective_date               in     date
  ,p_object_version_number        in out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  l_object_version_number         number;

Line: 530

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

Line: 536

  savepoint update_poshiereleminternal_swi;

Line: 554

  hr_pos_hierarchy_ele_api.update_pos_hier_elem_internal
    (p_pos_structure_element_id     => p_pos_structure_element_id
    ,p_parent_position_id           => p_parent_position_id
    ,p_subordinate_position_id      => p_subordinate_position_id
    ,p_effective_date               => p_effective_date
    ,p_object_version_number        => p_object_version_number
    );

Line: 583

    rollback to update_poshiereleminternal_swi;

Line: 598

    rollback to update_poshiereleminternal_swi;

Line: 609

end update_pos_hier_elem_internal;