APPS.OTA_CUS_SHD dependencies on OTA_CHAT_USERS

Line 21: If (p_constraint_name = 'OTA_CHAT_USERS_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'OTA_CHAT_USERS_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 57: from ota_chat_users

53: ,person_id
54: ,contact_id
55: ,login_date
56: ,object_version_number
57: from ota_chat_users
58: where chat_id = p_chat_id
59: and person_id = p_person_id
60: and contact_id = p_contact_id;
61: --

Line 138: from ota_chat_users

134: ,person_id
135: ,contact_id
136: ,login_date
137: ,object_version_number
138: from ota_chat_users
139: where chat_id = p_chat_id
140: and (person_id is null or person_id = p_person_id)
141: and (contact_id is null or contact_id = p_contact_id)
142: for update nowait;

Line 201: fnd_message.set_token('TABLE_NAME', 'ota_chat_users');

197: -- The object is locked therefore we need to supply a meaningful
198: -- error message.
199: --
200: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
201: fnd_message.set_token('TABLE_NAME', 'ota_chat_users');
202: fnd_message.raise_error;
203: End lck;
204: --
205: -- ----------------------------------------------------------------------------