APPS.OTA_COI_INS dependencies on OTA_CHAT_OBJ_INCLUSIONS

Line 93: -- Insert the row into: ota_chat_obj_inclusions

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

Line 95: insert into ota_chat_obj_inclusions

91: --
92: --
93: -- Insert the row into: ota_chat_obj_inclusions
94: --
95: insert into ota_chat_obj_inclusions
96: (chat_id
97: ,object_id
98: ,object_type
99: ,start_date_active

Line 179: -- Cursor C_Sel1 is select ota_chat_obj_inclusions_s.nextval from sys.dual;

175: Procedure pre_insert
176: (p_rec in out nocopy ota_coi_shd.g_rec_type
177: ) is
178: --
179: -- Cursor C_Sel1 is select ota_chat_obj_inclusions_s.nextval from sys.dual;
180: --
181: -- Cursor C_Sel2 is
182: -- Select null
183: -- from ota_chat_obj_inclusions

Line 183: -- from ota_chat_obj_inclusions

179: -- Cursor C_Sel1 is select ota_chat_obj_inclusions_s.nextval from sys.dual;
180: --
181: -- Cursor C_Sel2 is
182: -- Select null
183: -- from ota_chat_obj_inclusions
184: -- where chat_id =
185: -- ota_coi_ins.g_chat_id_i
186: -- or object_id =
187: -- ota_coi_ins.g_object_id_i

Line 265: (p_module_name => 'OTA_CHAT_OBJ_INCLUSIONS'

261: --
262: when hr_api.cannot_find_prog_unit then
263: --
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'OTA_CHAT_OBJ_INCLUSIONS'
266: ,p_hook_type => 'AI');
267: --
268: end;
269: --