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_EVT_INS dependencies on OTA_EVT_SHD

Line 71: Procedure insert_dml(p_rec in out nocopy ota_evt_shd.g_rec_type) is

67: -- Internal Development Use Only.
68: --
69: -- {End Of Comments}
70: -- ----------------------------------------------------------------------------
71: Procedure insert_dml(p_rec in out nocopy ota_evt_shd.g_rec_type) is
72: --
73: l_proc varchar2(72) := g_package||'insert_dml';
74: --
75: Begin

Line 79: ota_evt_shd.g_api_dml := true; -- Set the api dml status

75: Begin
76: hr_utility.set_location('Entering:'||l_proc, 5);
77: p_rec.object_version_number := 1; -- Initialise the object version
78: --
79: ota_evt_shd.g_api_dml := true; -- Set the api dml status
80: --
81: -- Insert the row into: ota_events
82: --
83: insert into ota_events

Line 224: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

220: p_rec.data_source,
221: p_rec.event_availability
222: );
223: --
224: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
225: --
226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: Exception
228: When hr_api.check_integrity_violated Then

Line 230: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

226: hr_utility.set_location(' Leaving:'||l_proc, 10);
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
231: ota_evt_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated

Line 231: ota_evt_shd.constraint_error

227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
231: ota_evt_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

Line 235: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

231: ota_evt_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
236: ota_evt_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated

Line 236: ota_evt_shd.constraint_error

232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.parent_integrity_violated Then
234: -- Parent integrity has been violated
235: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
236: ota_evt_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

Line 240: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

236: ota_evt_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
241: ota_evt_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When Others Then
244: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

Line 241: ota_evt_shd.constraint_error

237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When hr_api.unique_integrity_violated Then
239: -- Unique integrity has been violated
240: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
241: ota_evt_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When Others Then
244: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
245: Raise;

Line 244: ota_evt_shd.g_api_dml := false; -- Unset the api dml status

240: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
241: ota_evt_shd.constraint_error
242: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
243: When Others Then
244: ota_evt_shd.g_api_dml := false; -- Unset the api dml status
245: Raise;
246: End insert_dml;
247: --
248: -- ----------------------------------------------------------------------------

Line 286: (p_rec in out nocopy ota_evt_shd.g_rec_type

282: --
283: -- {End Of Comments}
284: -- ----------------------------------------------------------------------------
285: Procedure pre_insert
286: (p_rec in out nocopy ota_evt_shd.g_rec_type
287: ) is
288: --
289: l_proc varchar2(72) := g_package||'pre_insert';
290: --

Line 373: Procedure post_insert(p_rec in ota_evt_shd.g_rec_type) is

369: -- Internal Development Use Only.
370: --
371: -- {End Of Comments}
372: -- ----------------------------------------------------------------------------
373: Procedure post_insert(p_rec in ota_evt_shd.g_rec_type) is
374: --
375: l_proc varchar2(72) := g_package||'post_insert';
376: l_return boolean;
377: --

Line 400: p_rec in out nocopy ota_evt_shd.g_rec_type,

396: -- |---------------------------------< ins >----------------------------------|
397: -- ----------------------------------------------------------------------------
398: Procedure ins
399: (
400: p_rec in out nocopy ota_evt_shd.g_rec_type,
401: p_validate in boolean default false
402: ) is
403: --
404: l_proc varchar2(72) := g_package||'ins';

Line 532: l_rec ota_evt_shd.g_rec_type;

528: p_validate in boolean default false,
529: p_event_availability in varchar2 default null
530: ) is
531: --
532: l_rec ota_evt_shd.g_rec_type;
533: l_proc varchar2(72) := g_package||'ins';
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);

Line 542: ota_evt_shd.convert_args

538: -- Call conversion function to turn arguments into the
539: -- p_rec structure.
540: --
541: l_rec :=
542: ota_evt_shd.convert_args
543: (
544: null,
545: p_vendor_id,
546: p_activity_version_id,