APPS.OTA_EVT_DEL SQL Statements

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

Line: 51

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

Line: 60

/* -- Removed until a Delete Function is implemented
   --
  -- Delete delegate bookings
  --
  delete from ota_delegate_bookings
  where event_id = p_rec.event_id;

Line: 69

  delete from ota_event_associations
  where event_id = p_rec.event_id;

Line: 75

  delete from ota_events
  where event_id = p_rec.event_id;

Line: 91

End delete_dml;

Line: 125

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

Line: 133

End pre_delete;

Line: 167

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

Line: 175

End post_delete;

Line: 210

  ota_evt_bus.delete_validate(p_rec);

Line: 218

  pre_delete(p_rec);

Line: 222

  delete_dml(p_rec);

Line: 226

  post_delete(p_rec);