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_FNS_UPD dependencies on OTA_FNS_SHD

Line 55: (p_rec in out nocopy ota_fns_shd.g_rec_type

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

Line 66: ota_fns_shd.g_api_dml := true; -- Set the api dml status

62: --
63: -- Increment the object version
64: p_rec.object_version_number := p_rec.object_version_number + 1;
65: --
66: ota_fns_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Update the ota_frm_notif_subscribers Row
69: --
70: update ota_frm_notif_subscribers

Line 81: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

77: where forum_id = p_rec.forum_id
78: and person_id = p_rec.person_id
79: and contact_id = p_rec.contact_id;
80: --
81: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
82: --
83: hr_utility.set_location(' Leaving:'||l_proc, 10);
84: --
85: Exception

Line 88: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

84: --
85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
89: ota_fns_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated

Line 89: ota_fns_shd.constraint_error

85: Exception
86: When hr_api.check_integrity_violated Then
87: -- A check constraint has been violated
88: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
89: ota_fns_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

Line 93: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

89: ota_fns_shd.constraint_error
90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
94: ota_fns_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated

Line 94: ota_fns_shd.constraint_error

90: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
91: When hr_api.parent_integrity_violated Then
92: -- Parent integrity has been violated
93: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
94: ota_fns_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

Line 98: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

94: ota_fns_shd.constraint_error
95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
99: ota_fns_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

Line 99: ota_fns_shd.constraint_error

95: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
96: When hr_api.unique_integrity_violated Then
97: -- Unique integrity has been violated
98: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
99: ota_fns_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
103: Raise;

Line 102: ota_fns_shd.g_api_dml := false; -- Unset the api dml status

98: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
99: ota_fns_shd.constraint_error
100: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
101: When Others Then
102: ota_fns_shd.g_api_dml := false; -- Unset the api dml status
103: Raise;
104: End update_dml;
105: --
106: -- ----------------------------------------------------------------------------

Line 139: (p_rec in ota_fns_shd.g_rec_type

135: --
136: -- {End Of Comments}
137: -- ----------------------------------------------------------------------------
138: Procedure pre_update
139: (p_rec in ota_fns_shd.g_rec_type
140: ) is
141: --
142: l_proc varchar2(72) := g_package||'pre_update';
143: --

Line 184: ,p_rec in ota_fns_shd.g_rec_type

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

Line 206: => ota_fns_shd.g_old_rec.business_group_id

202: => p_rec.person_id
203: ,p_contact_id
204: => p_rec.contact_id
205: ,p_business_group_id_o
206: => ota_fns_shd.g_old_rec.business_group_id
207: ,p_object_version_number_o
208: => ota_fns_shd.g_old_rec.object_version_number
209: );
210: --

Line 208: => ota_fns_shd.g_old_rec.object_version_number

204: => p_rec.contact_id
205: ,p_business_group_id_o
206: => ota_fns_shd.g_old_rec.business_group_id
207: ,p_object_version_number_o
208: => ota_fns_shd.g_old_rec.object_version_number
209: );
210: --
211: exception
212: --

Line 268: (p_rec in out nocopy ota_fns_shd.g_rec_type

264: --
265: -- {End Of Comments}
266: -- ----------------------------------------------------------------------------
267: Procedure convert_defs
268: (p_rec in out nocopy ota_fns_shd.g_rec_type
269: ) is
270: --
271: Begin
272: --

Line 280: ota_fns_shd.g_old_rec.business_group_id;

276: -- is being used then we must set to the 'current' argument value.
277: --
278: If (p_rec.business_group_id = hr_api.g_number) then
279: p_rec.business_group_id :=
280: ota_fns_shd.g_old_rec.business_group_id;
281: End If;
282: --
283: End convert_defs;
284: --

Line 290: ,p_rec in out nocopy ota_fns_shd.g_rec_type

286: -- |---------------------------------< upd >----------------------------------|
287: -- ----------------------------------------------------------------------------
288: Procedure upd
289: (p_effective_date in date
290: ,p_rec in out nocopy ota_fns_shd.g_rec_type
291: ) is
292: --
293: l_proc varchar2(72) := g_package||'upd';
294: --

Line 300: ota_fns_shd.lck

296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: -- We must lock the row which we need to update.
299: --
300: ota_fns_shd.lck
301: (p_rec.forum_id
302: ,p_rec.person_id
303: ,p_rec.contact_id
304: ,p_rec.object_version_number

Line 353: l_rec ota_fns_shd.g_rec_type;

349: ,p_object_version_number in out nocopy number
350: ,p_business_group_id in number default hr_api.g_number
351: ) is
352: --
353: l_rec ota_fns_shd.g_rec_type;
354: l_proc varchar2(72) := g_package||'upd';
355: --
356: Begin
357: hr_utility.set_location('Entering:'||l_proc, 5);

Line 363: ota_fns_shd.convert_args

359: -- Call conversion function to turn arguments into the
360: -- l_rec structure.
361: --
362: l_rec :=
363: ota_fns_shd.convert_args
364: (p_forum_id
365: ,p_business_group_id
366: ,p_object_version_number
367: ,p_person_id