APPS.HR_DTY_DEL SQL Statements

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

Line: 45

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

Line: 58

  delete from hr_document_types
  where document_type_id = p_rec.document_type_id;

Line: 74

End delete_dml;

Line: 108

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

Line: 116

End pre_delete;

Line: 150

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

Line: 158

    hr_dty_rkd.after_delete
      (p_document_type_id
      => p_rec.document_type_id
      ,p_category_code_o
      => hr_dty_shd.g_old_rec.category_code
      ,p_sub_category_code_o
      => hr_dty_shd.g_old_rec.sub_category_code
      ,p_active_inactive_flag_o
      => hr_dty_shd.g_old_rec.active_inactive_flag
      ,p_multiple_occurences_flag_o
      => hr_dty_shd.g_old_rec.multiple_occurences_flag
      ,p_legislation_code_o
      => hr_dty_shd.g_old_rec.legislation_code
      ,p_authorization_required_o
      => hr_dty_shd.g_old_rec.authorization_required
      ,p_warning_period_o
      => hr_dty_shd.g_old_rec.warning_period
      ,p_request_id_o
      => hr_dty_shd.g_old_rec.request_id
      ,p_program_application_id_o
      => hr_dty_shd.g_old_rec.program_application_id
      ,p_program_id_o
      => hr_dty_shd.g_old_rec.program_id
      ,p_program_update_date_o
      => hr_dty_shd.g_old_rec.program_update_date
      ,p_object_version_number_o
      => hr_dty_shd.g_old_rec.object_version_number
      );

Line: 198

End post_delete;

Line: 221

  hr_dty_bus.delete_validate(p_rec);

Line: 228

  hr_dty_del.pre_delete(p_rec);

Line: 232

  hr_dty_del.delete_dml(p_rec);

Line: 236

  hr_dty_del.post_delete(p_rec);