APPS.OTA_LME_INS dependencies on OTA_LME_SHD

Line 76: (p_rec in out nocopy ota_lme_shd.g_rec_type

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

Line 183: ota_lme_shd.constraint_error

179: Exception
180: When hr_api.check_integrity_violated Then
181: -- A check constraint has been violated
182: --
183: ota_lme_shd.constraint_error
184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Parent integrity has been violated
187: --

Line 188: ota_lme_shd.constraint_error

184: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
185: When hr_api.parent_integrity_violated Then
186: -- Parent integrity has been violated
187: --
188: ota_lme_shd.constraint_error
189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.unique_integrity_violated Then
191: -- Unique integrity has been violated
192: --

Line 193: ota_lme_shd.constraint_error

189: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
190: When hr_api.unique_integrity_violated Then
191: -- Unique integrity has been violated
192: --
193: ota_lme_shd.constraint_error
194: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
195: When Others Then
196: --
197: Raise;

Line 238: (p_rec in out nocopy ota_lme_shd.g_rec_type

234: --
235: -- {End Of Comments}
236: -- ----------------------------------------------------------------------------
237: Procedure pre_insert
238: (p_rec in out nocopy ota_lme_shd.g_rec_type
239: ) is
240: --
241: Cursor C_Sel1 is select ota_lp_member_enrollments_s.nextval from sys.dual;
242: --

Line 326: ,p_rec in ota_lme_shd.g_rec_type

322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure post_insert
325: (p_effective_date in date
326: ,p_rec in ota_lme_shd.g_rec_type
327: ) is
328: --
329: l_proc varchar2(72) := g_package||'post_insert';
330: --

Line 439: ,p_rec in out nocopy ota_lme_shd.g_rec_type

435: -- |---------------------------------< ins >----------------------------------|
436: -- ----------------------------------------------------------------------------
437: Procedure ins
438: (p_effective_date in date
439: ,p_rec in out nocopy ota_lme_shd.g_rec_type
440: ) is
441: --
442: l_proc varchar2(72) := g_package||'ins';
443: --

Line 526: l_rec ota_lme_shd.g_rec_type;

522: ,p_lp_member_enrollment_id out nocopy number
523: ,p_object_version_number out nocopy number
524: ) is
525: --
526: l_rec ota_lme_shd.g_rec_type;
527: l_proc varchar2(72) := g_package||'ins';
528: --
529: Begin
530: hr_utility.set_location('Entering:'||l_proc, 5);

Line 536: ota_lme_shd.convert_args

532: -- Call conversion function to turn arguments into the
533: -- p_rec structure.
534: --
535: l_rec :=
536: ota_lme_shd.convert_args
537: (null
538: ,p_lp_enrollment_id
539: ,p_learning_path_section_id
540: ,p_learning_path_member_id