60: hr_utility.set_location('Entering:'||l_proc, 5);
61: --
62: ota_tdb_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Delete the ota_delegate_bookings row.
65: --
66: delete from ota_delegate_bookings
67: where booking_id = p_rec.booking_id;
68: --
62: ota_tdb_shd.g_api_dml := true; -- Set the api dml status
63: --
64: -- Delete the ota_delegate_bookings row.
65: --
66: delete from ota_delegate_bookings
67: where booking_id = p_rec.booking_id;
68: --
69: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
70: --
116: Procedure pre_delete(p_rec in ota_tdb_shd.g_rec_type) is
117: --
118: cursor c_get_event_id is
119: select event_id, delegate_person_id, delegate_contact_id
120: from ota_delegate_bookings
121: where booking_id = p_rec.booking_id;
122:
123: l_proc varchar2(72) := g_package||'pre_delete';
124: --