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

Line 55: (p_rec in out nocopy ota_fms_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_fms_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 94: ota_fms_shd.constraint_error

90: Exception
91: When hr_api.check_integrity_violated Then
92: -- A check constraint has been violated
93: --
94: ota_fms_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --

Line 99: ota_fms_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.parent_integrity_violated Then
97: -- Parent integrity has been violated
98: --
99: ota_fms_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --

Line 104: ota_fms_shd.constraint_error

100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When hr_api.unique_integrity_violated Then
102: -- Unique integrity has been violated
103: --
104: ota_fms_shd.constraint_error
105: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
106: When Others Then
107: --
108: Raise;

Line 144: (p_rec in ota_fms_shd.g_rec_type

140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure pre_update
144: (p_rec in ota_fms_shd.g_rec_type
145: ) is
146: --
147: l_proc varchar2(72) := g_package||'pre_update';
148: --

Line 189: ,p_rec in ota_fms_shd.g_rec_type

185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure post_update
188: (p_effective_date in date
189: ,p_rec in ota_fms_shd.g_rec_type
190: ) is
191: --
192: l_proc varchar2(72) := g_package||'post_update';
193: --

Line 225: => ota_fms_shd.g_old_rec.forum_id

221: => p_rec.message_scope
222: ,p_object_version_number
223: => p_rec.object_version_number
224: ,p_forum_id_o
225: => ota_fms_shd.g_old_rec.forum_id
226: ,p_forum_thread_id_o
227: => ota_fms_shd.g_old_rec.forum_thread_id
228: ,p_business_group_id_o
229: => ota_fms_shd.g_old_rec.business_group_id

Line 227: => ota_fms_shd.g_old_rec.forum_thread_id

223: => p_rec.object_version_number
224: ,p_forum_id_o
225: => ota_fms_shd.g_old_rec.forum_id
226: ,p_forum_thread_id_o
227: => ota_fms_shd.g_old_rec.forum_thread_id
228: ,p_business_group_id_o
229: => ota_fms_shd.g_old_rec.business_group_id
230: ,p_message_body_o
231: => ota_fms_shd.g_old_rec.message_body

Line 229: => ota_fms_shd.g_old_rec.business_group_id

225: => ota_fms_shd.g_old_rec.forum_id
226: ,p_forum_thread_id_o
227: => ota_fms_shd.g_old_rec.forum_thread_id
228: ,p_business_group_id_o
229: => ota_fms_shd.g_old_rec.business_group_id
230: ,p_message_body_o
231: => ota_fms_shd.g_old_rec.message_body
232: ,p_parent_message_id_o
233: => ota_fms_shd.g_old_rec.parent_message_id

Line 231: => ota_fms_shd.g_old_rec.message_body

227: => ota_fms_shd.g_old_rec.forum_thread_id
228: ,p_business_group_id_o
229: => ota_fms_shd.g_old_rec.business_group_id
230: ,p_message_body_o
231: => ota_fms_shd.g_old_rec.message_body
232: ,p_parent_message_id_o
233: => ota_fms_shd.g_old_rec.parent_message_id
234: ,p_person_id_o
235: => ota_fms_shd.g_old_rec.person_id

Line 233: => ota_fms_shd.g_old_rec.parent_message_id

229: => ota_fms_shd.g_old_rec.business_group_id
230: ,p_message_body_o
231: => ota_fms_shd.g_old_rec.message_body
232: ,p_parent_message_id_o
233: => ota_fms_shd.g_old_rec.parent_message_id
234: ,p_person_id_o
235: => ota_fms_shd.g_old_rec.person_id
236: ,p_contact_id_o
237: => ota_fms_shd.g_old_rec.contact_id

Line 235: => ota_fms_shd.g_old_rec.person_id

231: => ota_fms_shd.g_old_rec.message_body
232: ,p_parent_message_id_o
233: => ota_fms_shd.g_old_rec.parent_message_id
234: ,p_person_id_o
235: => ota_fms_shd.g_old_rec.person_id
236: ,p_contact_id_o
237: => ota_fms_shd.g_old_rec.contact_id
238: ,p_target_person_id_o
239: => ota_fms_shd.g_old_rec.target_person_id

Line 237: => ota_fms_shd.g_old_rec.contact_id

233: => ota_fms_shd.g_old_rec.parent_message_id
234: ,p_person_id_o
235: => ota_fms_shd.g_old_rec.person_id
236: ,p_contact_id_o
237: => ota_fms_shd.g_old_rec.contact_id
238: ,p_target_person_id_o
239: => ota_fms_shd.g_old_rec.target_person_id
240: ,p_target_contact_id_o
241: => ota_fms_shd.g_old_rec.target_contact_id

Line 239: => ota_fms_shd.g_old_rec.target_person_id

235: => ota_fms_shd.g_old_rec.person_id
236: ,p_contact_id_o
237: => ota_fms_shd.g_old_rec.contact_id
238: ,p_target_person_id_o
239: => ota_fms_shd.g_old_rec.target_person_id
240: ,p_target_contact_id_o
241: => ota_fms_shd.g_old_rec.target_contact_id
242: ,p_message_scope_o
243: => ota_fms_shd.g_old_rec.message_scope

Line 241: => ota_fms_shd.g_old_rec.target_contact_id

237: => ota_fms_shd.g_old_rec.contact_id
238: ,p_target_person_id_o
239: => ota_fms_shd.g_old_rec.target_person_id
240: ,p_target_contact_id_o
241: => ota_fms_shd.g_old_rec.target_contact_id
242: ,p_message_scope_o
243: => ota_fms_shd.g_old_rec.message_scope
244: ,p_object_version_number_o
245: => ota_fms_shd.g_old_rec.object_version_number

Line 243: => ota_fms_shd.g_old_rec.message_scope

239: => ota_fms_shd.g_old_rec.target_person_id
240: ,p_target_contact_id_o
241: => ota_fms_shd.g_old_rec.target_contact_id
242: ,p_message_scope_o
243: => ota_fms_shd.g_old_rec.message_scope
244: ,p_object_version_number_o
245: => ota_fms_shd.g_old_rec.object_version_number
246: );
247: --

Line 245: => ota_fms_shd.g_old_rec.object_version_number

241: => ota_fms_shd.g_old_rec.target_contact_id
242: ,p_message_scope_o
243: => ota_fms_shd.g_old_rec.message_scope
244: ,p_object_version_number_o
245: => ota_fms_shd.g_old_rec.object_version_number
246: );
247: --
248: exception
249: --

Line 305: (p_rec in out nocopy ota_fms_shd.g_rec_type

301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure convert_defs
305: (p_rec in out nocopy ota_fms_shd.g_rec_type
306: ) is
307: --
308: Begin
309: --

Line 317: ota_fms_shd.g_old_rec.forum_id;

313: -- is being used then we must set to the 'current' argument value.
314: --
315: If (p_rec.forum_id = hr_api.g_number) then
316: p_rec.forum_id :=
317: ota_fms_shd.g_old_rec.forum_id;
318: End If;
319: If (p_rec.forum_thread_id = hr_api.g_number) then
320: p_rec.forum_thread_id :=
321: ota_fms_shd.g_old_rec.forum_thread_id;

Line 321: ota_fms_shd.g_old_rec.forum_thread_id;

317: ota_fms_shd.g_old_rec.forum_id;
318: End If;
319: If (p_rec.forum_thread_id = hr_api.g_number) then
320: p_rec.forum_thread_id :=
321: ota_fms_shd.g_old_rec.forum_thread_id;
322: End If;
323: If (p_rec.business_group_id = hr_api.g_number) then
324: p_rec.business_group_id :=
325: ota_fms_shd.g_old_rec.business_group_id;

Line 325: ota_fms_shd.g_old_rec.business_group_id;

321: ota_fms_shd.g_old_rec.forum_thread_id;
322: End If;
323: If (p_rec.business_group_id = hr_api.g_number) then
324: p_rec.business_group_id :=
325: ota_fms_shd.g_old_rec.business_group_id;
326: End If;
327: If (p_rec.message_body = hr_api.g_varchar2) then
328: p_rec.message_body :=
329: ota_fms_shd.g_old_rec.message_body;

Line 329: ota_fms_shd.g_old_rec.message_body;

325: ota_fms_shd.g_old_rec.business_group_id;
326: End If;
327: If (p_rec.message_body = hr_api.g_varchar2) then
328: p_rec.message_body :=
329: ota_fms_shd.g_old_rec.message_body;
330: End If;
331: If (p_rec.parent_message_id = hr_api.g_number) then
332: p_rec.parent_message_id :=
333: ota_fms_shd.g_old_rec.parent_message_id;

Line 333: ota_fms_shd.g_old_rec.parent_message_id;

329: ota_fms_shd.g_old_rec.message_body;
330: End If;
331: If (p_rec.parent_message_id = hr_api.g_number) then
332: p_rec.parent_message_id :=
333: ota_fms_shd.g_old_rec.parent_message_id;
334: End If;
335: If (p_rec.person_id = hr_api.g_number) then
336: p_rec.person_id :=
337: ota_fms_shd.g_old_rec.person_id;

Line 337: ota_fms_shd.g_old_rec.person_id;

333: ota_fms_shd.g_old_rec.parent_message_id;
334: End If;
335: If (p_rec.person_id = hr_api.g_number) then
336: p_rec.person_id :=
337: ota_fms_shd.g_old_rec.person_id;
338: End If;
339: If (p_rec.contact_id = hr_api.g_number) then
340: p_rec.contact_id :=
341: ota_fms_shd.g_old_rec.contact_id;

Line 341: ota_fms_shd.g_old_rec.contact_id;

337: ota_fms_shd.g_old_rec.person_id;
338: End If;
339: If (p_rec.contact_id = hr_api.g_number) then
340: p_rec.contact_id :=
341: ota_fms_shd.g_old_rec.contact_id;
342: End If;
343: If (p_rec.target_person_id = hr_api.g_number) then
344: p_rec.target_person_id :=
345: ota_fms_shd.g_old_rec.target_person_id;

Line 345: ota_fms_shd.g_old_rec.target_person_id;

341: ota_fms_shd.g_old_rec.contact_id;
342: End If;
343: If (p_rec.target_person_id = hr_api.g_number) then
344: p_rec.target_person_id :=
345: ota_fms_shd.g_old_rec.target_person_id;
346: End If;
347: If (p_rec.target_contact_id = hr_api.g_number) then
348: p_rec.target_contact_id :=
349: ota_fms_shd.g_old_rec.target_contact_id;

Line 349: ota_fms_shd.g_old_rec.target_contact_id;

345: ota_fms_shd.g_old_rec.target_person_id;
346: End If;
347: If (p_rec.target_contact_id = hr_api.g_number) then
348: p_rec.target_contact_id :=
349: ota_fms_shd.g_old_rec.target_contact_id;
350: End If;
351: If (p_rec.message_scope = hr_api.g_varchar2) then
352: p_rec.message_scope :=
353: ota_fms_shd.g_old_rec.message_scope;

Line 353: ota_fms_shd.g_old_rec.message_scope;

349: ota_fms_shd.g_old_rec.target_contact_id;
350: End If;
351: If (p_rec.message_scope = hr_api.g_varchar2) then
352: p_rec.message_scope :=
353: ota_fms_shd.g_old_rec.message_scope;
354: End If;
355: --
356: End convert_defs;
357: --

Line 363: ,p_rec in out nocopy ota_fms_shd.g_rec_type

359: -- |---------------------------------< upd >----------------------------------|
360: -- ----------------------------------------------------------------------------
361: Procedure upd
362: (p_effective_date in date
363: ,p_rec in out nocopy ota_fms_shd.g_rec_type
364: ) is
365: --
366: l_proc varchar2(72) := g_package||'upd';
367: --

Line 373: ota_fms_shd.lck

369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- We must lock the row which we need to update.
372: --
373: ota_fms_shd.lck
374: (p_rec.forum_message_id
375: ,p_rec.object_version_number
376: );
377: --

Line 431: l_rec ota_fms_shd.g_rec_type;

427: ,p_target_person_id in number default hr_api.g_number
428: ,p_target_contact_id in number default hr_api.g_number
429: ) is
430: --
431: l_rec ota_fms_shd.g_rec_type;
432: l_proc varchar2(72) := g_package||'upd';
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);

Line 441: ota_fms_shd.convert_args

437: -- Call conversion function to turn arguments into the
438: -- l_rec structure.
439: --
440: l_rec :=
441: ota_fms_shd.convert_args
442: (p_forum_message_id
443: ,p_forum_id
444: ,p_forum_thread_id
445: ,p_business_group_id