APPS.OTA_CUS_DEL dependencies on OTA_CHAT_USERS

Line 62: -- Delete the ota_chat_users row.

58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: --
62: -- Delete the ota_chat_users row.
63: --
64: delete from ota_chat_users
65: where chat_id = p_rec.chat_id
66: and (person_id is null or person_id = p_rec.person_id)

Line 64: delete from ota_chat_users

60: --
61: --
62: -- Delete the ota_chat_users row.
63: --
64: delete from ota_chat_users
65: where chat_id = p_rec.chat_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 186: (p_module_name => 'OTA_CHAT_USERS'

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