APPS.OTA_TDB_DEL dependencies on OTA_EVT_SHD

Line 190: l_event_rec ota_evt_shd.g_rec_type;

186: where foi.object_id = g_event_id
187: and foi.object_Type = 'E'
188: and foi.forum_id = fns.forum_id
189: and (fns.person_id = g_person_id or fns.contact_id = g_contact_id);
190: l_event_rec ota_evt_shd.g_rec_type;
191: l_event_exists boolean;
192: l_proc varchar2(72) := g_package||'post_delete';
193:
194: --Added for Bug#4106893

Line 205: ota_evt_shd.get_event_details(g_event_id,

201: Begin
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204:
205: ota_evt_shd.get_event_details(g_event_id,
206: l_event_rec,
207: l_event_exists);
208:
209: if l_event_exists then