APPS.OTA_CUS_INS dependencies on OTA_CHAT_USERS

Line 93: -- Insert the row into: ota_chat_users

89: p_rec.object_version_number := 1; -- Initialise the object version
90: --
91: --
92: --
93: -- Insert the row into: ota_chat_users
94: --
95: insert into ota_chat_users
96: (chat_id
97: ,business_group_id

Line 95: insert into ota_chat_users

91: --
92: --
93: -- Insert the row into: ota_chat_users
94: --
95: insert into ota_chat_users
96: (chat_id
97: ,business_group_id
98: ,person_id
99: ,contact_id

Line 177: -- Cursor C_Sel1 is select ota_chat_users_s.nextval from sys.dual;

173: Procedure pre_insert
174: (p_rec in out nocopy ota_cus_shd.g_rec_type
175: ) is
176: --
177: -- Cursor C_Sel1 is select ota_chat_users_s.nextval from sys.dual;
178: --
179: -- Cursor C_Sel2 is
180: -- Select null
181: -- from ota_chat_users

Line 181: -- from ota_chat_users

177: -- Cursor C_Sel1 is select ota_chat_users_s.nextval from sys.dual;
178: --
179: -- Cursor C_Sel2 is
180: -- Select null
181: -- from ota_chat_users
182: -- where chat_id =
183: -- ota_cus_ins.g_chat_id_i
184: -- or person_id =
185: -- ota_cus_ins.g_person_id_i

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

205: --
206: -- The primary key values are already in use.
207: --
208: -- fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
209: -- fnd_message.set_token('TABLE_NAME','ota_chat_users');
210: -- fnd_message.raise_error;
211: -- End If;
212: -- Close C_Sel2;
213: --

Line 304: (p_module_name => 'OTA_CHAT_USERS'

300: --
301: when hr_api.cannot_find_prog_unit then
302: --
303: hr_api.cannot_find_prog_unit_error
304: (p_module_name => 'OTA_CHAT_USERS'
305: ,p_hook_type => 'AI');
306: --
307: end;
308: --