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_TPS_INS dependencies on OTA_TPS_SHD

Line 71: (p_rec in out nocopy ota_tps_shd.g_rec_type

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

Line 80: ota_tps_shd.g_api_dml := true; -- Set the api dml status

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

Line 185: ota_tps_shd.g_api_dml := false; -- Unset the api dml status

181: ,p_rec.learning_path_id
182: ,p_rec.contact_id
183: );
184: --
185: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: Exception
189: When hr_api.check_integrity_violated Then

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

187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: Exception
189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
191: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tps_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.parent_integrity_violated Then
195: -- Parent integrity has been violated

Line 192: ota_tps_shd.constraint_error

188: Exception
189: When hr_api.check_integrity_violated Then
190: -- A check constraint has been violated
191: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
192: ota_tps_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.parent_integrity_violated Then
195: -- Parent integrity has been violated
196: ota_tps_shd.g_api_dml := false; -- Unset the api dml status

Line 196: ota_tps_shd.g_api_dml := false; -- Unset the api dml status

192: ota_tps_shd.constraint_error
193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.parent_integrity_violated Then
195: -- Parent integrity has been violated
196: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
197: ota_tps_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.unique_integrity_violated Then
200: -- Unique integrity has been violated

Line 197: ota_tps_shd.constraint_error

193: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
194: When hr_api.parent_integrity_violated Then
195: -- Parent integrity has been violated
196: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
197: ota_tps_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.unique_integrity_violated Then
200: -- Unique integrity has been violated
201: ota_tps_shd.g_api_dml := false; -- Unset the api dml status

Line 201: ota_tps_shd.g_api_dml := false; -- Unset the api dml status

197: ota_tps_shd.constraint_error
198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.unique_integrity_violated Then
200: -- Unique integrity has been violated
201: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
202: ota_tps_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When Others Then
205: ota_tps_shd.g_api_dml := false; -- Unset the api dml status

Line 202: ota_tps_shd.constraint_error

198: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
199: When hr_api.unique_integrity_violated Then
200: -- Unique integrity has been violated
201: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
202: ota_tps_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When Others Then
205: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
206: Raise;

Line 205: ota_tps_shd.g_api_dml := false; -- Unset the api dml status

201: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
202: ota_tps_shd.constraint_error
203: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
204: When Others Then
205: ota_tps_shd.g_api_dml := false; -- Unset the api dml status
206: Raise;
207: End insert_dml;
208: --
209: -- ----------------------------------------------------------------------------

Line 247: (p_rec in out nocopy ota_tps_shd.g_rec_type

243: --
244: -- {End Of Comments}
245: -- ----------------------------------------------------------------------------
246: Procedure pre_insert
247: (p_rec in out nocopy ota_tps_shd.g_rec_type
248: ) is
249: --
250: l_proc varchar2(72) := g_package||'pre_insert';
251: --

Line 335: ,p_rec in ota_tps_shd.g_rec_type

331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure post_insert
334: (p_effective_date in date
335: ,p_rec in ota_tps_shd.g_rec_type
336: ) is
337: --
338: l_proc varchar2(72) := g_package||'post_insert';
339: --

Line 455: ,p_rec in out nocopy ota_tps_shd.g_rec_type

451: -- |---------------------------------< ins >----------------------------------|
452: -- ----------------------------------------------------------------------------
453: Procedure ins
454: (p_effective_date in date
455: ,p_rec in out nocopy ota_tps_shd.g_rec_type
456: ) is
457: --
458: l_proc varchar2(72) := g_package||'ins';
459: --

Line 549: l_rec ota_tps_shd.g_rec_type;

545: ,p_training_plan_id out nocopy number
546: ,p_object_version_number out nocopy number
547: ) is
548: --
549: l_rec ota_tps_shd.g_rec_type;
550: l_proc varchar2(72) := g_package||'ins';
551: --
552: Begin
553: hr_utility.set_location('Entering:'||l_proc, 5);

Line 559: ota_tps_shd.convert_args

555: -- Call conversion function to turn arguments into the
556: -- p_rec structure.
557: --
558: l_rec :=
559: ota_tps_shd.convert_args
560: (null
561: ,p_time_period_id
562: ,p_plan_status_type_id
563: ,p_organization_id