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_FMS_DEL dependencies on OTA_FMS_SHD

Line 52: (p_rec in ota_fms_shd.g_rec_type

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

Line 75: ota_fms_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ota_fms_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_fms_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_fms_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 157: Procedure post_delete(p_rec in ota_fms_shd.g_rec_type) is

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

Line 169: => ota_fms_shd.g_old_rec.forum_id

165: ota_fms_rkd.after_delete
166: (p_forum_message_id
167: => p_rec.forum_message_id
168: ,p_forum_id_o
169: => ota_fms_shd.g_old_rec.forum_id
170: ,p_forum_thread_id_o
171: => ota_fms_shd.g_old_rec.forum_thread_id
172: ,p_business_group_id_o
173: => ota_fms_shd.g_old_rec.business_group_id

Line 171: => ota_fms_shd.g_old_rec.forum_thread_id

167: => p_rec.forum_message_id
168: ,p_forum_id_o
169: => ota_fms_shd.g_old_rec.forum_id
170: ,p_forum_thread_id_o
171: => ota_fms_shd.g_old_rec.forum_thread_id
172: ,p_business_group_id_o
173: => ota_fms_shd.g_old_rec.business_group_id
174: ,p_message_body_o
175: => ota_fms_shd.g_old_rec.message_body

Line 173: => ota_fms_shd.g_old_rec.business_group_id

169: => ota_fms_shd.g_old_rec.forum_id
170: ,p_forum_thread_id_o
171: => ota_fms_shd.g_old_rec.forum_thread_id
172: ,p_business_group_id_o
173: => ota_fms_shd.g_old_rec.business_group_id
174: ,p_message_body_o
175: => ota_fms_shd.g_old_rec.message_body
176: ,p_parent_message_id_o
177: => ota_fms_shd.g_old_rec.parent_message_id

Line 175: => ota_fms_shd.g_old_rec.message_body

171: => ota_fms_shd.g_old_rec.forum_thread_id
172: ,p_business_group_id_o
173: => ota_fms_shd.g_old_rec.business_group_id
174: ,p_message_body_o
175: => ota_fms_shd.g_old_rec.message_body
176: ,p_parent_message_id_o
177: => ota_fms_shd.g_old_rec.parent_message_id
178: ,p_person_id_o
179: => ota_fms_shd.g_old_rec.person_id

Line 177: => ota_fms_shd.g_old_rec.parent_message_id

173: => ota_fms_shd.g_old_rec.business_group_id
174: ,p_message_body_o
175: => ota_fms_shd.g_old_rec.message_body
176: ,p_parent_message_id_o
177: => ota_fms_shd.g_old_rec.parent_message_id
178: ,p_person_id_o
179: => ota_fms_shd.g_old_rec.person_id
180: ,p_contact_id_o
181: => ota_fms_shd.g_old_rec.contact_id

Line 179: => ota_fms_shd.g_old_rec.person_id

175: => ota_fms_shd.g_old_rec.message_body
176: ,p_parent_message_id_o
177: => ota_fms_shd.g_old_rec.parent_message_id
178: ,p_person_id_o
179: => ota_fms_shd.g_old_rec.person_id
180: ,p_contact_id_o
181: => ota_fms_shd.g_old_rec.contact_id
182: ,p_target_person_id_o
183: => ota_fms_shd.g_old_rec.target_person_id

Line 181: => ota_fms_shd.g_old_rec.contact_id

177: => ota_fms_shd.g_old_rec.parent_message_id
178: ,p_person_id_o
179: => ota_fms_shd.g_old_rec.person_id
180: ,p_contact_id_o
181: => ota_fms_shd.g_old_rec.contact_id
182: ,p_target_person_id_o
183: => ota_fms_shd.g_old_rec.target_person_id
184: ,p_target_contact_id_o
185: => ota_fms_shd.g_old_rec.target_contact_id

Line 183: => ota_fms_shd.g_old_rec.target_person_id

179: => ota_fms_shd.g_old_rec.person_id
180: ,p_contact_id_o
181: => ota_fms_shd.g_old_rec.contact_id
182: ,p_target_person_id_o
183: => ota_fms_shd.g_old_rec.target_person_id
184: ,p_target_contact_id_o
185: => ota_fms_shd.g_old_rec.target_contact_id
186: ,p_message_scope_o
187: => ota_fms_shd.g_old_rec.message_scope

Line 185: => ota_fms_shd.g_old_rec.target_contact_id

181: => ota_fms_shd.g_old_rec.contact_id
182: ,p_target_person_id_o
183: => ota_fms_shd.g_old_rec.target_person_id
184: ,p_target_contact_id_o
185: => ota_fms_shd.g_old_rec.target_contact_id
186: ,p_message_scope_o
187: => ota_fms_shd.g_old_rec.message_scope
188: ,p_object_version_number_o
189: => ota_fms_shd.g_old_rec.object_version_number

Line 187: => ota_fms_shd.g_old_rec.message_scope

183: => ota_fms_shd.g_old_rec.target_person_id
184: ,p_target_contact_id_o
185: => ota_fms_shd.g_old_rec.target_contact_id
186: ,p_message_scope_o
187: => ota_fms_shd.g_old_rec.message_scope
188: ,p_object_version_number_o
189: => ota_fms_shd.g_old_rec.object_version_number
190: );
191: --

Line 189: => ota_fms_shd.g_old_rec.object_version_number

185: => ota_fms_shd.g_old_rec.target_contact_id
186: ,p_message_scope_o
187: => ota_fms_shd.g_old_rec.message_scope
188: ,p_object_version_number_o
189: => ota_fms_shd.g_old_rec.object_version_number
190: );
191: --
192: exception
193: --

Line 209: (p_rec in ota_fms_shd.g_rec_type

205: -- ----------------------------------------------------------------------------
206: -- |---------------------------------< del >----------------------------------|
207: -- ----------------------------------------------------------------------------
208: Procedure del
209: (p_rec in ota_fms_shd.g_rec_type
210: ) is
211: --
212: l_proc varchar2(72) := g_package||'del';
213: --

Line 219: ota_fms_shd.lck

215: hr_utility.set_location('Entering:'||l_proc, 5);
216: --
217: -- We must lock the row which we need to delete.
218: --
219: ota_fms_shd.lck
220: (p_rec.forum_message_id
221: ,p_rec.object_version_number
222: );
223: --

Line 256: l_rec ota_fms_shd.g_rec_type;

252: (p_forum_message_id in number
253: ,p_object_version_number in number
254: ) is
255: --
256: l_rec ota_fms_shd.g_rec_type;
257: l_proc varchar2(72) := g_package||'del';
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);