APPS.OTA_TPM_INS dependencies on OTA_TPM_SHD

Line 72: (p_rec in out nocopy ota_tpm_shd.g_rec_type

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

Line 190: ota_tpm_shd.constraint_error

186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: --
190: ota_tpm_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.parent_integrity_violated Then
193: -- Parent integrity has been violated
194: --

Line 195: ota_tpm_shd.constraint_error

191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.parent_integrity_violated Then
193: -- Parent integrity has been violated
194: --
195: ota_tpm_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.unique_integrity_violated Then
198: -- Unique integrity has been violated
199: --

Line 200: ota_tpm_shd.constraint_error

196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When hr_api.unique_integrity_violated Then
198: -- Unique integrity has been violated
199: --
200: ota_tpm_shd.constraint_error
201: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
202: When Others Then
203: --
204: Raise;

Line 245: (p_rec in out nocopy ota_tpm_shd.g_rec_type

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

Line 332: ,p_rec in ota_tpm_shd.g_rec_type

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

Line 447: ,p_rec in out nocopy ota_tpm_shd.g_rec_type

443: -- |---------------------------------< ins >----------------------------------|
444: -- ----------------------------------------------------------------------------
445: Procedure ins
446: (p_effective_date in date
447: ,p_rec in out nocopy ota_tpm_shd.g_rec_type
448: ) is
449: --
450: l_proc varchar2(72) := g_package||'ins';
451: --

Line 535: l_rec ota_tpm_shd.g_rec_type;

531: ,p_training_plan_member_id out nocopy number
532: ,p_object_version_number out nocopy number
533: ) is
534: --
535: l_rec ota_tpm_shd.g_rec_type;
536: l_proc varchar2(72) := g_package||'ins';
537: --
538: Begin
539: hr_utility.set_location('Entering:'||l_proc, 5);

Line 545: ota_tpm_shd.convert_args

541: -- Call conversion function to turn arguments into the
542: -- p_rec structure.
543: --
544: l_rec :=
545: ota_tpm_shd.convert_args
546: (null
547: ,p_training_plan_id
548: ,p_activity_version_id
549: ,p_activity_definition_id