APPS.OTA_FNS_DEL dependencies on OTA_FRM_NOTIF_SUBSCRIBERS

Line 62: -- Delete the ota_frm_notif_subscribers row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: ota_fns_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the ota_frm_notif_subscribers row.
63: --
64: delete from ota_frm_notif_subscribers
65: where forum_id = p_rec.forum_id
66: and (person_id is null or person_id = p_rec.person_id)

Line 64: delete from ota_frm_notif_subscribers

60: ota_fns_shd.g_api_dml := true; -- Set the api dml status
61: --
62: -- Delete the ota_frm_notif_subscribers row.
63: --
64: delete from ota_frm_notif_subscribers
65: where forum_id = p_rec.forum_id
66: and (person_id is null or person_id = p_rec.person_id)
67: and (contact_id is null or contact_id = p_rec.contact_id);
68: --

Line 184: (p_module_name => 'OTA_FRM_NOTIF_SUBSCRIBERS'

180: --
181: when hr_api.cannot_find_prog_unit then
182: --
183: hr_api.cannot_find_prog_unit_error
184: (p_module_name => 'OTA_FRM_NOTIF_SUBSCRIBERS'
185: ,p_hook_type => 'AD');
186: --
187: end;
188: --