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_FTU_UPD dependencies on OTA_FTU_SHD

Line 55: (p_rec in out nocopy ota_ftu_shd.g_rec_type

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

Line 93: ota_ftu_shd.constraint_error

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

Line 98: ota_ftu_shd.constraint_error

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

Line 103: ota_ftu_shd.constraint_error

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

Line 143: (p_rec in ota_ftu_shd.g_rec_type

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

Line 188: ,p_rec in ota_ftu_shd.g_rec_type

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

Line 216: => ota_ftu_shd.g_old_rec.business_group_id

212: => p_rec.contact_id
213: ,p_object_version_number
214: => p_rec.object_version_number
215: ,p_business_group_id_o
216: => ota_ftu_shd.g_old_rec.business_group_id
217: ,p_author_person_id_o
218: => ota_ftu_shd.g_old_rec.author_person_id
219: ,p_author_contact_id_o
220: => ota_ftu_shd.g_old_rec.author_contact_id

Line 218: => ota_ftu_shd.g_old_rec.author_person_id

214: => p_rec.object_version_number
215: ,p_business_group_id_o
216: => ota_ftu_shd.g_old_rec.business_group_id
217: ,p_author_person_id_o
218: => ota_ftu_shd.g_old_rec.author_person_id
219: ,p_author_contact_id_o
220: => ota_ftu_shd.g_old_rec.author_contact_id
221: ,p_object_version_number_o
222: => ota_ftu_shd.g_old_rec.object_version_number

Line 220: => ota_ftu_shd.g_old_rec.author_contact_id

216: => ota_ftu_shd.g_old_rec.business_group_id
217: ,p_author_person_id_o
218: => ota_ftu_shd.g_old_rec.author_person_id
219: ,p_author_contact_id_o
220: => ota_ftu_shd.g_old_rec.author_contact_id
221: ,p_object_version_number_o
222: => ota_ftu_shd.g_old_rec.object_version_number
223: );
224: --

Line 222: => ota_ftu_shd.g_old_rec.object_version_number

218: => ota_ftu_shd.g_old_rec.author_person_id
219: ,p_author_contact_id_o
220: => ota_ftu_shd.g_old_rec.author_contact_id
221: ,p_object_version_number_o
222: => ota_ftu_shd.g_old_rec.object_version_number
223: );
224: --
225: exception
226: --

Line 282: (p_rec in out nocopy ota_ftu_shd.g_rec_type

278: --
279: -- {End Of Comments}
280: -- ----------------------------------------------------------------------------
281: Procedure convert_defs
282: (p_rec in out nocopy ota_ftu_shd.g_rec_type
283: ) is
284: --
285: Begin
286: --

Line 294: ota_ftu_shd.g_old_rec.business_group_id;

290: -- is being used then we must set to the 'current' argument value.
291: --
292: If (p_rec.business_group_id = hr_api.g_number) then
293: p_rec.business_group_id :=
294: ota_ftu_shd.g_old_rec.business_group_id;
295: End If;
296: If (p_rec.author_person_id = hr_api.g_number) then
297: p_rec.author_person_id :=
298: ota_ftu_shd.g_old_rec.author_person_id;

Line 298: ota_ftu_shd.g_old_rec.author_person_id;

294: ota_ftu_shd.g_old_rec.business_group_id;
295: End If;
296: If (p_rec.author_person_id = hr_api.g_number) then
297: p_rec.author_person_id :=
298: ota_ftu_shd.g_old_rec.author_person_id;
299: End If;
300: If (p_rec.author_contact_id = hr_api.g_number) then
301: p_rec.author_contact_id :=
302: ota_ftu_shd.g_old_rec.author_contact_id;

Line 302: ota_ftu_shd.g_old_rec.author_contact_id;

298: ota_ftu_shd.g_old_rec.author_person_id;
299: End If;
300: If (p_rec.author_contact_id = hr_api.g_number) then
301: p_rec.author_contact_id :=
302: ota_ftu_shd.g_old_rec.author_contact_id;
303: End If;
304: --
305: End convert_defs;
306: --

Line 312: ,p_rec in out nocopy ota_ftu_shd.g_rec_type

308: -- |---------------------------------< upd >----------------------------------|
309: -- ----------------------------------------------------------------------------
310: Procedure upd
311: (p_effective_date in date
312: ,p_rec in out nocopy ota_ftu_shd.g_rec_type
313: ) is
314: --
315: l_proc varchar2(72) := g_package||'upd';
316: --

Line 322: ota_ftu_shd.lck

318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- We must lock the row which we need to update.
321: --
322: ota_ftu_shd.lck
323: (p_rec.forum_thread_id
324: ,p_rec.forum_id
325: ,p_rec.person_id
326: ,p_rec.contact_id

Line 379: l_rec ota_ftu_shd.g_rec_type;

375: ,p_author_person_id in number default hr_api.g_number
376: ,p_author_contact_id in number default hr_api.g_number
377: ) is
378: --
379: l_rec ota_ftu_shd.g_rec_type;
380: l_proc varchar2(72) := g_package||'upd';
381: --
382: Begin
383: hr_utility.set_location('Entering:'||l_proc, 5);

Line 389: ota_ftu_shd.convert_args

385: -- Call conversion function to turn arguments into the
386: -- l_rec structure.
387: --
388: l_rec :=
389: ota_ftu_shd.convert_args
390: (p_forum_thread_id
391: ,p_forum_id
392: ,p_business_group_id
393: ,p_author_person_id