APPS.PER_SEU_DEL SQL Statements

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

Line: 52

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

Line: 65

  delete from per_security_users
  where security_user_id = p_rec.security_user_id;

Line: 81

End delete_dml;

Line: 115

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

Line: 123

End pre_delete;

Line: 157

Procedure post_delete
  (p_rec in per_seu_shd.g_rec_type
  ,p_del_static_lists_warning out nocopy boolean) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 186

    hr_security_internal.delete_static_lists_for_user
      (p_user_id             => per_seu_shd.g_old_rec.user_id
      ,p_security_profile_id => per_seu_shd.g_old_rec.security_profile_id);

Line: 198

    per_seu_rkd.after_delete
      (p_security_user_id
      => p_rec.security_user_id
      ,p_user_id_o
      => per_seu_shd.g_old_rec.user_id
      ,p_security_profile_id_o
      => per_seu_shd.g_old_rec.security_profile_id
      ,p_object_version_number_o
      => per_seu_shd.g_old_rec.object_version_number
      ,p_del_static_lists_warning
      => p_del_static_lists_warning
      );

Line: 225

End post_delete;

Line: 250

  per_seu_bus.delete_validate(p_rec);

Line: 257

  per_seu_del.pre_delete(p_rec);

Line: 261

  per_seu_del.delete_dml(p_rec);

Line: 265

  per_seu_del.post_delete(p_rec, l_del_static_lists_warning);