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    per_pos_structure_elements b
					WHERE   a.business_group_id        = b.business_group_id
							AND a.POS_structure_version_id = b.pos_structure_version_id
							CONNECT BY parent_position_id = prior subordinate_position_id
							START WITH parent_position_id = a.parent_position_id
					);

Line: 205

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: 217

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

Line: 228

  savepoint update_pos_hierarchy_ele;

Line: 238

    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: 246

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

Line: 267

    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: 275

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

Line: 297

    rollback to update_pos_hierarchy_ele;

Line: 310

    rollback to update_pos_hierarchy_ele;

Line: 313

end update_pos_hierarchy_ele;

Line: 319

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: 335

  savepoint delete_pos_hierarchy_ele;

Line: 343

    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: 350

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

Line: 370

    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: 377

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

Line: 398

    rollback to delete_pos_hierarchy_ele;

Line: 409

    rollback to delete_pos_hierarchy_ele;

Line: 412

end delete_pos_hierarchy_ele;

Line: 447

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: 469

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
  );