APPS.OTA_LPE_INS dependencies on OTA_LPE_SHD

Line 76: (p_rec in out nocopy ota_lpe_shd.g_rec_type

72: --
73: -- {End Of Comments}
74: -- ----------------------------------------------------------------------------
75: Procedure insert_dml
76: (p_rec in out nocopy ota_lpe_shd.g_rec_type
77: ) is
78: --
79: l_proc varchar2(72) := g_package||'insert_dml';
80: --

Line 191: ota_lpe_shd.constraint_error

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

Line 196: ota_lpe_shd.constraint_error

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

Line 201: ota_lpe_shd.constraint_error

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

Line 246: (p_rec in out nocopy ota_lpe_shd.g_rec_type

242: --
243: -- {End Of Comments}
244: -- ----------------------------------------------------------------------------
245: Procedure pre_insert
246: (p_rec in out nocopy ota_lpe_shd.g_rec_type
247: ) is
248: --
249: Cursor C_Sel1 is select ota_lp_enrollments_s.nextval from sys.dual;
250: --

Line 334: ,p_rec in ota_lpe_shd.g_rec_type

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

Line 455: ,p_rec in out nocopy ota_lpe_shd.g_rec_type

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

Line 546: l_rec ota_lpe_shd.g_rec_type;

542: ,p_lp_enrollment_id out nocopy number
543: ,p_object_version_number out nocopy number
544: ) is
545: --
546: l_rec ota_lpe_shd.g_rec_type;
547: l_proc varchar2(72) := g_package||'ins';
548: --
549: Begin
550: hr_utility.set_location('Entering:'||l_proc, 5);

Line 556: ota_lpe_shd.convert_args

552: -- Call conversion function to turn arguments into the
553: -- p_rec structure.
554: --
555: l_rec :=
556: ota_lpe_shd.convert_args
557: (null
558: ,p_learning_path_id
559: ,p_person_id
560: ,p_contact_id