58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the ota_pvt_frm_thread_users row.
63: --
64: delete from ota_pvt_frm_thread_users
65: where forum_thread_id = p_rec.forum_thread_id
66: and forum_id = p_rec.forum_id
60: --
61: --
62: -- Delete the ota_pvt_frm_thread_users row.
63: --
64: delete from ota_pvt_frm_thread_users
65: where forum_thread_id = p_rec.forum_thread_id
66: and forum_id = p_rec.forum_id
67: and (person_id is null or person_id = p_rec.person_id)
68: and (contact_id is null or contact_id = p_rec.contact_id);
187: --
188: when hr_api.cannot_find_prog_unit then
189: --
190: hr_api.cannot_find_prog_unit_error
191: (p_module_name => 'OTA_PVT_FRM_THREAD_USERS'
192: ,p_hook_type => 'AD');
193: --
194: end;
195: --