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_TSR_INS dependencies on OTA_TSR_SHD

Line 74: Procedure insert_dml(p_rec in out nocopy ota_tsr_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_tsr_shd.g_rec_type) is
75: --
76: l_proc varchar2(72) := g_package||'insert_dml';
77: --
78: Begin

Line 82: ota_tsr_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_tsr_shd.g_api_dml := true; -- Set the api dml status
83: --
84: -- Insert the row into: ota_suppliable_resources
85: --
86: insert into ota_suppliable_resources

Line 175: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

171: p_rec.trainer_id,
172: p_rec.special_instruction
173: );
174: --
175: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
176: --
177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: Exception
179: When hr_api.check_integrity_violated Then

Line 181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

177: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated

Line 182: ota_tsr_shd.constraint_error

178: Exception
179: When hr_api.check_integrity_violated Then
180: -- A check constraint has been violated
181: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

Line 186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

182: ota_tsr_shd.constraint_error
183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated

Line 187: ota_tsr_shd.constraint_error

183: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
184: When hr_api.parent_integrity_violated Then
185: -- Parent integrity has been violated
186: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

Line 191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

187: ota_tsr_shd.constraint_error
188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When Others Then
195: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

Line 192: ota_tsr_shd.constraint_error

188: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
189: When hr_api.unique_integrity_violated Then
190: -- Unique integrity has been violated
191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When Others Then
195: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
196: Raise;

Line 195: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status

191: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tsr_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When Others Then
195: ota_tsr_shd.g_api_dml := false; -- Unset the api dml status
196: Raise;
197: End insert_dml;
198: --
199: -- ----------------------------------------------------------------------------

Line 236: Procedure pre_insert(p_rec in out nocopy ota_tsr_shd.g_rec_type) is

232: -- Internal Development Use Only.
233: --
234: -- {End Of Comments}
235: -- ----------------------------------------------------------------------------
236: Procedure pre_insert(p_rec in out nocopy ota_tsr_shd.g_rec_type) is
237: --
238: l_proc varchar2(72) := g_package||'pre_insert';
239: --
240: Cursor C_Sel1 is select ota_suppliable_resources_s.nextval from sys.dual;

Line 320: Procedure post_insert(p_rec in ota_tsr_shd.g_rec_type) is

316: -- Internal Development Use Only.
317: --
318: -- {End Of Comments}
319: -- ----------------------------------------------------------------------------
320: Procedure post_insert(p_rec in ota_tsr_shd.g_rec_type) is
321: --
322: l_proc varchar2(72) := g_package||'post_insert';
323: --
324: Begin

Line 335: p_rec in out nocopy ota_tsr_shd.g_rec_type,

331: -- |---------------------------------< ins >----------------------------------|
332: -- ----------------------------------------------------------------------------
333: Procedure ins
334: (
335: p_rec in out nocopy ota_tsr_shd.g_rec_type,
336: p_validate in boolean
337: ) is
338: --
339: l_proc varchar2(72) := g_package||'ins';

Line 435: l_rec ota_tsr_shd.g_rec_type;

431: p_special_instruction in varchar2,
432: p_validate in boolean
433: ) is
434: --
435: l_rec ota_tsr_shd.g_rec_type;
436: l_proc varchar2(72) := g_package||'ins';
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);

Line 445: ota_tsr_shd.convert_args

441: -- Call conversion function to turn arguments into the
442: -- p_rec structure.
443: --
444: l_rec :=
445: ota_tsr_shd.convert_args
446: (
447: null,
448: p_vendor_id,
449: p_business_group_id,