APPS.HR_POS_HIERARCHY_ELE_API SQL Statements

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

Line: 33

  cursor get_old_element is select pos_structure_element_id,
  object_version_number
  from per_pos_structure_elements
  where subordinate_position_id = p_subordinate_position_id
  and   pos_structure_version_id = p_pos_structure_version_id;

Line: 43

	SELECT distinct '1'
	FROM    per_pos_structure_elements a
	WHERE   a.business_group_id            = p_business_group_id
			AND a.POS_structure_version_id = p_pos_structure_version_id
			AND a.parent_position_id       = p_subordinate_position_id
			AND p_parent_position_id IN
					(SELECT subordinate_position_id
					 FROM    ( SELECT *                            /*Added this subquery for bug#14158576*/
                                                  FROM per_pos_structure_elements b
                                                  WHERE  b.business_group_id = p_business_group_id
                                                  AND b.pos_structure_version_id = p_pos_structure_version_id)
		                         CONNECT BY parent_position_id = prior subordinate_position_id
					 START WITH parent_position_id = a.parent_position_id
					);

Line: 206

procedure update_pos_hierarchy_ele
  (p_validate                      in     boolean  default false
  ,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
  ) is
  --
  -- Declare cursors and local variables
  --
  l_effective_date date;

Line: 218

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

Line: 229

  savepoint update_pos_hierarchy_ele;

Line: 239

    hr_pos_hierarchy_ele_bk2.update_pos_hierarchy_ele_b
     (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
     );

Line: 247

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

Line: 268

    hr_pos_hierarchy_ele_bk2.update_pos_hierarchy_ele_a
     (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
     );

Line: 276

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

Line: 298

    rollback to update_pos_hierarchy_ele;

Line: 311

    rollback to update_pos_hierarchy_ele;

Line: 314

end update_pos_hierarchy_ele;

Line: 320

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

Line: 336

  savepoint delete_pos_hierarchy_ele;

Line: 344

    hr_pos_hierarchy_ele_bk3.delete_pos_hierarchy_ele_b
     (p_pos_structure_element_id       =>     p_pos_structure_element_id
     ,p_object_version_number          =>     p_object_version_number
     );

Line: 351

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

Line: 371

    hr_pos_hierarchy_ele_bk3.delete_pos_hierarchy_ele_a
     (p_pos_structure_element_id       =>     p_pos_structure_element_id
     ,p_object_version_number          =>     p_object_version_number
     );

Line: 378

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

Line: 399

    rollback to delete_pos_hierarchy_ele;

Line: 410

    rollback to delete_pos_hierarchy_ele;

Line: 413

end delete_pos_hierarchy_ele;

Line: 448

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
  ) is
begin
  hr_pos_hierarchy_ele_api.update_pos_hierarchy_ele
  (p_validate                      =>     false
  ,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: 470

procedure delete_pos_hier_elem_internal
  (p_pos_structure_element_id      in     number
  ,p_object_version_number         in     number
  ,p_hr_installed                  in     VARCHAR2
  ) is
begin
  hr_pos_hierarchy_ele_api.delete_pos_hierarchy_ele
  (p_validate                      =>     false
  ,p_pos_structure_element_id      =>     p_pos_structure_element_id
  ,p_object_version_number         =>     p_object_version_number
  ,p_hr_installed                  =>     p_hr_installed
  );