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_TDB_INS dependencies on OTA_TDB_SHD

Line 74: Procedure insert_dml(p_rec in out nocopy ota_tdb_shd.g_rec_type) is

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

Line 82: ota_tdb_shd.g_api_dml := true; -- Set the api dml status

78: Begin
79: hr_utility.set_location('Entering:'||l_proc, 5);
80: p_rec.object_version_number := 1; -- Initialise the object version
81: --
82: ota_tdb_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: ota_delegate_bookings
85: --
86: insert into ota_delegate_bookings

Line 243: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

239: p_rec.is_history_flag,
240: p_rec.is_mandatory_enrollment
241: );
242: --
243: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
244: --
245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: Exception
247: When hr_api.check_integrity_violated Then

Line 249: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

245: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: Exception
247: When hr_api.check_integrity_violated Then
248: -- A check constraint has been violated
249: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
250: ota_tdb_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.parent_integrity_violated Then
253: -- Parent integrity has been violated

Line 250: ota_tdb_shd.constraint_error

246: Exception
247: When hr_api.check_integrity_violated Then
248: -- A check constraint has been violated
249: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
250: ota_tdb_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.parent_integrity_violated Then
253: -- Parent integrity has been violated
254: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

Line 254: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

250: ota_tdb_shd.constraint_error
251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.parent_integrity_violated Then
253: -- Parent integrity has been violated
254: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
255: ota_tdb_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated

Line 255: ota_tdb_shd.constraint_error

251: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
252: When hr_api.parent_integrity_violated Then
253: -- Parent integrity has been violated
254: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
255: ota_tdb_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated
259: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

Line 259: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

255: ota_tdb_shd.constraint_error
256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated
259: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
260: ota_tdb_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

Line 260: ota_tdb_shd.constraint_error

256: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
257: When hr_api.unique_integrity_violated Then
258: -- Unique integrity has been violated
259: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
260: ota_tdb_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
264: Raise;

Line 263: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status

259: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
260: ota_tdb_shd.constraint_error
261: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
262: When Others Then
263: ota_tdb_shd.g_api_dml := false; -- Unset the api dml status
264: Raise;
265: End insert_dml;
266: --
267: -- ----------------------------------------------------------------------------

Line 304: Procedure pre_insert(p_rec in out nocopy ota_tdb_shd.g_rec_type) is

300: -- Internal Development Use Only.
301: --
302: -- {End Of Comments}
303: -- ----------------------------------------------------------------------------
304: Procedure pre_insert(p_rec in out nocopy ota_tdb_shd.g_rec_type) is
305: --
306: l_proc varchar2(72) := g_package||'pre_insert';
307: --
308: Cursor C_Sel1 is select ota_delegate_bookings_s.nextval from sys.dual;

Line 391: Procedure post_insert(p_rec in ota_tdb_shd.g_rec_type) is

387: -- Internal Development Use Only.
388: --
389: -- {End Of Comments}
390: -- ----------------------------------------------------------------------------
391: Procedure post_insert(p_rec in ota_tdb_shd.g_rec_type) is
392: --
393: l_proc varchar2(72) := g_package||'post_insert';
394: l_dummy number;
395: l_return boolean;

Line 440: p_rec in out nocopy ota_tdb_shd.g_rec_type,

436: -- |---------------------------------< ins >----------------------------------|
437: -- ----------------------------------------------------------------------------
438: Procedure ins
439: (
440: p_rec in out nocopy ota_tdb_shd.g_rec_type,
441: p_create_finance_line in varchar2,
442: p_finance_header_id in number,
443: p_currency_code in varchar2,
444: p_standard_amount in number,

Line 595: l_rec ota_tdb_shd.g_rec_type;

591: p_is_history_flag in varchar2,
592: p_is_mandatory_enrollment in varchar2
593: ) is
594: --
595: l_rec ota_tdb_shd.g_rec_type;
596: l_proc varchar2(72) := g_package||'ins';
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);

Line 605: ota_tdb_shd.convert_args

601: -- Call conversion function to turn arguments into the
602: -- p_rec structure.
603: --
604: l_rec :=
605: ota_tdb_shd.convert_args
606: (
607: null,
608: p_booking_status_type_id,
609: p_delegate_person_id,