APPS.OTA_TDB_DEL SQL Statements

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

Line: 55

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

Line: 66

  delete from ota_delegate_bookings
  where booking_id = p_rec.booking_id;

Line: 82

End delete_dml;

Line: 116

Procedure pre_delete(p_rec in ota_tdb_shd.g_rec_type) is
--
  cursor c_get_event_id is
  select event_id, delegate_person_id, delegate_contact_id
  from ota_delegate_bookings
  where booking_id = p_rec.booking_id;

Line: 123

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

Line: 142

  delete from ota_booking_status_histories
  where booking_id = p_rec.booking_id;

Line: 147

End pre_delete;

Line: 181

Procedure post_delete(p_rec in ota_tdb_shd.g_rec_type) is
--
  cursor c_get_forum_id is
  select fns.forum_id,fns.object_version_number
  from ota_frm_obj_inclusions foi,ota_frm_notif_subscribers fns
  where foi.object_id = g_event_id
  and foi.object_Type = 'E'
  and foi.forum_id = fns.forum_id
  and (fns.person_id = g_person_id or fns.contact_id = g_contact_id);

Line: 192

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

Line: 225

        ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id          => g_event_id,
                                                                 p_person_id         => g_person_id,
                                                                 p_contact_id        => null,
                                                                 p_lp_enrollment_ids => l_lp_enrollment_ids);

Line: 230

        ota_cme_util.update_cme_status(p_event_id          => g_event_id,
                                                                 p_person_id         => g_person_id,
                                                                 p_contact_id        => null,
                                                                 p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);

Line: 235

        ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id          => g_event_id,
                                                               p_person_id         => null,
                                                               p_contact_id        => g_contact_id,
                                                               p_lp_enrollment_ids => l_lp_enrollment_ids);

Line: 240

        ota_cme_util.update_cme_status(p_event_id          => g_event_id,
                                                                 p_person_id         => null,
                                                                 p_contact_id        => g_contact_id,
                                                                 p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);

Line: 267

End post_delete;

Line: 302

  ota_tdb_bus.delete_validate(p_rec);

Line: 306

  pre_delete(p_rec);

Line: 310

  delete_dml(p_rec);

Line: 314

  post_delete(p_rec);