eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CMS_DEL dependencies on OTA_CMS_SHD

Line 52: (p_rec in ota_cms_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ota_cms_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: ota_cms_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ota_cms_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in ota_cms_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in ota_cms_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in ota_cms_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in ota_cms_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => ota_cms_shd.g_old_rec.chat_id

164: ota_cms_rkd.after_delete
165: (p_chat_message_id
166: => p_rec.chat_message_id
167: ,p_chat_id_o
168: => ota_cms_shd.g_old_rec.chat_id
169: ,p_business_group_id_o
170: => ota_cms_shd.g_old_rec.business_group_id
171: ,p_person_id_o
172: => ota_cms_shd.g_old_rec.person_id

Line 170: => ota_cms_shd.g_old_rec.business_group_id

166: => p_rec.chat_message_id
167: ,p_chat_id_o
168: => ota_cms_shd.g_old_rec.chat_id
169: ,p_business_group_id_o
170: => ota_cms_shd.g_old_rec.business_group_id
171: ,p_person_id_o
172: => ota_cms_shd.g_old_rec.person_id
173: ,p_contact_id_o
174: => ota_cms_shd.g_old_rec.contact_id

Line 172: => ota_cms_shd.g_old_rec.person_id

168: => ota_cms_shd.g_old_rec.chat_id
169: ,p_business_group_id_o
170: => ota_cms_shd.g_old_rec.business_group_id
171: ,p_person_id_o
172: => ota_cms_shd.g_old_rec.person_id
173: ,p_contact_id_o
174: => ota_cms_shd.g_old_rec.contact_id
175: ,p_target_person_id_o
176: => ota_cms_shd.g_old_rec.target_person_id

Line 174: => ota_cms_shd.g_old_rec.contact_id

170: => ota_cms_shd.g_old_rec.business_group_id
171: ,p_person_id_o
172: => ota_cms_shd.g_old_rec.person_id
173: ,p_contact_id_o
174: => ota_cms_shd.g_old_rec.contact_id
175: ,p_target_person_id_o
176: => ota_cms_shd.g_old_rec.target_person_id
177: ,p_target_contact_id_o
178: => ota_cms_shd.g_old_rec.target_contact_id

Line 176: => ota_cms_shd.g_old_rec.target_person_id

172: => ota_cms_shd.g_old_rec.person_id
173: ,p_contact_id_o
174: => ota_cms_shd.g_old_rec.contact_id
175: ,p_target_person_id_o
176: => ota_cms_shd.g_old_rec.target_person_id
177: ,p_target_contact_id_o
178: => ota_cms_shd.g_old_rec.target_contact_id
179: ,p_message_text_o
180: => ota_cms_shd.g_old_rec.message_text

Line 178: => ota_cms_shd.g_old_rec.target_contact_id

174: => ota_cms_shd.g_old_rec.contact_id
175: ,p_target_person_id_o
176: => ota_cms_shd.g_old_rec.target_person_id
177: ,p_target_contact_id_o
178: => ota_cms_shd.g_old_rec.target_contact_id
179: ,p_message_text_o
180: => ota_cms_shd.g_old_rec.message_text
181: ,p_object_version_number_o
182: => ota_cms_shd.g_old_rec.object_version_number

Line 180: => ota_cms_shd.g_old_rec.message_text

176: => ota_cms_shd.g_old_rec.target_person_id
177: ,p_target_contact_id_o
178: => ota_cms_shd.g_old_rec.target_contact_id
179: ,p_message_text_o
180: => ota_cms_shd.g_old_rec.message_text
181: ,p_object_version_number_o
182: => ota_cms_shd.g_old_rec.object_version_number
183: );
184: --

Line 182: => ota_cms_shd.g_old_rec.object_version_number

178: => ota_cms_shd.g_old_rec.target_contact_id
179: ,p_message_text_o
180: => ota_cms_shd.g_old_rec.message_text
181: ,p_object_version_number_o
182: => ota_cms_shd.g_old_rec.object_version_number
183: );
184: --
185: exception
186: --

Line 202: (p_rec in ota_cms_shd.g_rec_type

198: -- ----------------------------------------------------------------------------
199: -- |---------------------------------< del >----------------------------------|
200: -- ----------------------------------------------------------------------------
201: Procedure del
202: (p_rec in ota_cms_shd.g_rec_type
203: ) is
204: --
205: l_proc varchar2(72) := g_package||'del';
206: --

Line 212: ota_cms_shd.lck

208: hr_utility.set_location('Entering:'||l_proc, 5);
209: --
210: -- We must lock the row which we need to delete.
211: --
212: ota_cms_shd.lck
213: (p_rec.chat_message_id
214: ,p_rec.object_version_number
215: );
216: --

Line 249: l_rec ota_cms_shd.g_rec_type;

245: (p_chat_message_id in number
246: ,p_object_version_number in number
247: ) is
248: --
249: l_rec ota_cms_shd.g_rec_type;
250: l_proc varchar2(72) := g_package||'del';
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc, 5);