APPS.PER_OSE_DEL SQL Statements

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

Line: 31

   select 'Y'
   into p_exists_in_hierarchy
   from sys.dual
   where exists ( select null
               from    per_org_structure_elements      ose
               where   ose.org_structure_version_id    = p_org_structure_version_id
               and     ose.organization_id_child      = p_organization_id);

Line: 43

     select 'Y'
     into p_exists_in_hierarchy
     from sys.dual
     where exists ( select null
                    from per_org_structure_elements es1
                    where es1.org_structure_version_id = p_org_structure_version_id
                    and es1.organization_id_parent = p_organization_id
                    and p_organization_id not in (select organization_id_child
                                                  from per_org_structure_elements es
                                                  where es.org_structure_version_id = p_org_structure_version_id));

Line: 103

Procedure delete_dml
  (p_rec in per_ose_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_dml';

Line: 116

  delete from per_org_structure_elements
  where org_structure_element_id = p_rec.org_structure_element_id;

Line: 132

End delete_dml;

Line: 166

Procedure pre_delete(p_rec in per_ose_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_delete';

Line: 174

End pre_delete;

Line: 209

Procedure post_delete(p_rec in per_ose_shd.g_rec_type
             --     ,p_exists_in_hierarchy in out nocopy varchar2 --bug 3205553
                     ) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 221

       delete_hierarchy_element api -- Bug 3205553*/

    per_ose_rkd.after_delete
      (p_org_structure_element_id
      => p_rec.org_structure_element_id
      ,p_business_group_id_o
      => per_ose_shd.g_old_rec.business_group_id
      ,p_organization_id_parent_o
      => per_ose_shd.g_old_rec.organization_id_parent
      ,p_org_structure_version_id_o
      => per_ose_shd.g_old_rec.org_structure_version_id
      ,p_organization_id_child_o
      => per_ose_shd.g_old_rec.organization_id_child
      ,p_request_id_o
      => per_ose_shd.g_old_rec.request_id
      ,p_program_application_id_o
      => per_ose_shd.g_old_rec.program_application_id
      ,p_program_id_o
      => per_ose_shd.g_old_rec.program_id
      ,p_program_update_date_o
      => per_ose_shd.g_old_rec.program_update_date
      ,p_object_version_number_o
      => per_ose_shd.g_old_rec.object_version_number
      ,p_pos_control_enabled_flag_o
      => per_ose_shd.g_old_rec.position_control_enabled_flag
      );

Line: 259

End post_delete;

Line: 288

  per_ose_bus.delete_validate
     (p_rec                   => per_ose_shd.g_old_rec
     ,p_hr_installed          => p_hr_installed
     ,p_pa_installed          => p_pa_installed
     ,p_chk_children_exist    => p_chk_children_exist
     );

Line: 297

  per_ose_del.pre_delete(p_rec);

Line: 301

  per_ose_del.delete_dml(p_rec);

Line: 305

  per_ose_del.post_delete
     (per_ose_shd.g_old_rec
   --  ,p_exists_in_hierarchy   => p_exists_in_hierarchy --Bug 3205553
     );