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_FRM_UPD dependencies on OTA_FRM_SHD

Line 55: (p_rec in out nocopy ota_frm_shd.g_rec_type

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

Line 92: ota_frm_shd.constraint_error

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

Line 97: ota_frm_shd.constraint_error

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

Line 102: ota_frm_shd.constraint_error

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

Line 142: (p_rec in ota_frm_shd.g_rec_type

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

Line 187: ,p_rec in ota_frm_shd.g_rec_type

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

Line 219: => ota_frm_shd.g_old_rec.business_group_id

215: => p_rec.public_flag
216: ,p_object_version_number
217: => p_rec.object_version_number
218: ,p_business_group_id_o
219: => ota_frm_shd.g_old_rec.business_group_id
220: ,p_start_date_active_o
221: => ota_frm_shd.g_old_rec.start_date_active
222: ,p_end_date_active_o
223: => ota_frm_shd.g_old_rec.end_date_active

Line 221: => ota_frm_shd.g_old_rec.start_date_active

217: => p_rec.object_version_number
218: ,p_business_group_id_o
219: => ota_frm_shd.g_old_rec.business_group_id
220: ,p_start_date_active_o
221: => ota_frm_shd.g_old_rec.start_date_active
222: ,p_end_date_active_o
223: => ota_frm_shd.g_old_rec.end_date_active
224: ,p_message_type_flag_o
225: => ota_frm_shd.g_old_rec.message_type_flag

Line 223: => ota_frm_shd.g_old_rec.end_date_active

219: => ota_frm_shd.g_old_rec.business_group_id
220: ,p_start_date_active_o
221: => ota_frm_shd.g_old_rec.start_date_active
222: ,p_end_date_active_o
223: => ota_frm_shd.g_old_rec.end_date_active
224: ,p_message_type_flag_o
225: => ota_frm_shd.g_old_rec.message_type_flag
226: ,p_allow_html_flag_o
227: => ota_frm_shd.g_old_rec.allow_html_flag

Line 225: => ota_frm_shd.g_old_rec.message_type_flag

221: => ota_frm_shd.g_old_rec.start_date_active
222: ,p_end_date_active_o
223: => ota_frm_shd.g_old_rec.end_date_active
224: ,p_message_type_flag_o
225: => ota_frm_shd.g_old_rec.message_type_flag
226: ,p_allow_html_flag_o
227: => ota_frm_shd.g_old_rec.allow_html_flag
228: ,p_allow_attachment_flag_o
229: => ota_frm_shd.g_old_rec.allow_attachment_flag

Line 227: => ota_frm_shd.g_old_rec.allow_html_flag

223: => ota_frm_shd.g_old_rec.end_date_active
224: ,p_message_type_flag_o
225: => ota_frm_shd.g_old_rec.message_type_flag
226: ,p_allow_html_flag_o
227: => ota_frm_shd.g_old_rec.allow_html_flag
228: ,p_allow_attachment_flag_o
229: => ota_frm_shd.g_old_rec.allow_attachment_flag
230: ,p_auto_notification_flag_o
231: => ota_frm_shd.g_old_rec.auto_notification_flag

Line 229: => ota_frm_shd.g_old_rec.allow_attachment_flag

225: => ota_frm_shd.g_old_rec.message_type_flag
226: ,p_allow_html_flag_o
227: => ota_frm_shd.g_old_rec.allow_html_flag
228: ,p_allow_attachment_flag_o
229: => ota_frm_shd.g_old_rec.allow_attachment_flag
230: ,p_auto_notification_flag_o
231: => ota_frm_shd.g_old_rec.auto_notification_flag
232: ,p_public_flag_o
233: => ota_frm_shd.g_old_rec.public_flag

Line 231: => ota_frm_shd.g_old_rec.auto_notification_flag

227: => ota_frm_shd.g_old_rec.allow_html_flag
228: ,p_allow_attachment_flag_o
229: => ota_frm_shd.g_old_rec.allow_attachment_flag
230: ,p_auto_notification_flag_o
231: => ota_frm_shd.g_old_rec.auto_notification_flag
232: ,p_public_flag_o
233: => ota_frm_shd.g_old_rec.public_flag
234: ,p_object_version_number_o
235: => ota_frm_shd.g_old_rec.object_version_number

Line 233: => ota_frm_shd.g_old_rec.public_flag

229: => ota_frm_shd.g_old_rec.allow_attachment_flag
230: ,p_auto_notification_flag_o
231: => ota_frm_shd.g_old_rec.auto_notification_flag
232: ,p_public_flag_o
233: => ota_frm_shd.g_old_rec.public_flag
234: ,p_object_version_number_o
235: => ota_frm_shd.g_old_rec.object_version_number
236: );
237: --

Line 235: => ota_frm_shd.g_old_rec.object_version_number

231: => ota_frm_shd.g_old_rec.auto_notification_flag
232: ,p_public_flag_o
233: => ota_frm_shd.g_old_rec.public_flag
234: ,p_object_version_number_o
235: => ota_frm_shd.g_old_rec.object_version_number
236: );
237: --
238: exception
239: --

Line 295: (p_rec in out nocopy ota_frm_shd.g_rec_type

291: --
292: -- {End Of Comments}
293: -- ----------------------------------------------------------------------------
294: Procedure convert_defs
295: (p_rec in out nocopy ota_frm_shd.g_rec_type
296: ) is
297: --
298: Begin
299: --

Line 307: ota_frm_shd.g_old_rec.business_group_id;

303: -- is being used then we must set to the 'current' argument value.
304: --
305: If (p_rec.business_group_id = hr_api.g_number) then
306: p_rec.business_group_id :=
307: ota_frm_shd.g_old_rec.business_group_id;
308: End If;
309: If (p_rec.start_date_active = hr_api.g_date) then
310: p_rec.start_date_active :=
311: ota_frm_shd.g_old_rec.start_date_active;

Line 311: ota_frm_shd.g_old_rec.start_date_active;

307: ota_frm_shd.g_old_rec.business_group_id;
308: End If;
309: If (p_rec.start_date_active = hr_api.g_date) then
310: p_rec.start_date_active :=
311: ota_frm_shd.g_old_rec.start_date_active;
312: End If;
313: If (p_rec.end_date_active = hr_api.g_date) then
314: p_rec.end_date_active :=
315: ota_frm_shd.g_old_rec.end_date_active;

Line 315: ota_frm_shd.g_old_rec.end_date_active;

311: ota_frm_shd.g_old_rec.start_date_active;
312: End If;
313: If (p_rec.end_date_active = hr_api.g_date) then
314: p_rec.end_date_active :=
315: ota_frm_shd.g_old_rec.end_date_active;
316: End If;
317: If (p_rec.message_type_flag = hr_api.g_varchar2) then
318: p_rec.message_type_flag :=
319: ota_frm_shd.g_old_rec.message_type_flag;

Line 319: ota_frm_shd.g_old_rec.message_type_flag;

315: ota_frm_shd.g_old_rec.end_date_active;
316: End If;
317: If (p_rec.message_type_flag = hr_api.g_varchar2) then
318: p_rec.message_type_flag :=
319: ota_frm_shd.g_old_rec.message_type_flag;
320: End If;
321: If (p_rec.allow_html_flag = hr_api.g_varchar2) then
322: p_rec.allow_html_flag :=
323: ota_frm_shd.g_old_rec.allow_html_flag;

Line 323: ota_frm_shd.g_old_rec.allow_html_flag;

319: ota_frm_shd.g_old_rec.message_type_flag;
320: End If;
321: If (p_rec.allow_html_flag = hr_api.g_varchar2) then
322: p_rec.allow_html_flag :=
323: ota_frm_shd.g_old_rec.allow_html_flag;
324: End If;
325: If (p_rec.allow_attachment_flag = hr_api.g_varchar2) then
326: p_rec.allow_attachment_flag :=
327: ota_frm_shd.g_old_rec.allow_attachment_flag;

Line 327: ota_frm_shd.g_old_rec.allow_attachment_flag;

323: ota_frm_shd.g_old_rec.allow_html_flag;
324: End If;
325: If (p_rec.allow_attachment_flag = hr_api.g_varchar2) then
326: p_rec.allow_attachment_flag :=
327: ota_frm_shd.g_old_rec.allow_attachment_flag;
328: End If;
329: If (p_rec.auto_notification_flag = hr_api.g_varchar2) then
330: p_rec.auto_notification_flag :=
331: ota_frm_shd.g_old_rec.auto_notification_flag;

Line 331: ota_frm_shd.g_old_rec.auto_notification_flag;

327: ota_frm_shd.g_old_rec.allow_attachment_flag;
328: End If;
329: If (p_rec.auto_notification_flag = hr_api.g_varchar2) then
330: p_rec.auto_notification_flag :=
331: ota_frm_shd.g_old_rec.auto_notification_flag;
332: End If;
333: If (p_rec.public_flag = hr_api.g_varchar2) then
334: p_rec.public_flag :=
335: ota_frm_shd.g_old_rec.public_flag;

Line 335: ota_frm_shd.g_old_rec.public_flag;

331: ota_frm_shd.g_old_rec.auto_notification_flag;
332: End If;
333: If (p_rec.public_flag = hr_api.g_varchar2) then
334: p_rec.public_flag :=
335: ota_frm_shd.g_old_rec.public_flag;
336: End If;
337: --
338: End convert_defs;
339: --

Line 345: ,p_rec in out nocopy ota_frm_shd.g_rec_type

341: -- |---------------------------------< upd >----------------------------------|
342: -- ----------------------------------------------------------------------------
343: Procedure upd
344: (p_effective_date in date
345: ,p_rec in out nocopy ota_frm_shd.g_rec_type
346: ) is
347: --
348: l_proc varchar2(72) := g_package||'upd';
349: --

Line 355: ota_frm_shd.lck

351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: -- We must lock the row which we need to update.
354: --
355: ota_frm_shd.lck
356: (p_rec.forum_id
357: ,p_rec.object_version_number
358: );
359: --

Line 411: l_rec ota_frm_shd.g_rec_type;

407: ,p_start_date_active in date default hr_api.g_date
408: ,p_end_date_active in date default hr_api.g_date
409: ) is
410: --
411: l_rec ota_frm_shd.g_rec_type;
412: l_proc varchar2(72) := g_package||'upd';
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);

Line 421: ota_frm_shd.convert_args

417: -- Call conversion function to turn arguments into the
418: -- l_rec structure.
419: --
420: l_rec :=
421: ota_frm_shd.convert_args
422: (p_forum_id
423: ,p_business_group_id
424: ,p_start_date_active
425: ,p_end_date_active