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 185: ota_lme_shd.constraint_error

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

Line 190: ota_lme_shd.constraint_error

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

Line 195: ota_lme_shd.constraint_error

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

Line 240: (p_rec in out nocopy ota_lme_shd.g_rec_type

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

Line 328: ,p_rec in ota_lme_shd.g_rec_type

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

Line 443: ,p_rec in out nocopy ota_lme_shd.g_rec_type

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

Line 531: l_rec ota_lme_shd.g_rec_type;

527: ,p_lp_member_enrollment_id out nocopy number
528: ,p_object_version_number out nocopy number
529: ) is
530: --
531: l_rec ota_lme_shd.g_rec_type;
532: l_proc varchar2(72) := g_package||'ins';
533: --
534: Begin
535: hr_utility.set_location('Entering:'||l_proc, 5);

Line 541: ota_lme_shd.convert_args

537: -- Call conversion function to turn arguments into the
538: -- p_rec structure.
539: --
540: l_rec :=
541: ota_lme_shd.convert_args
542: (null
543: ,p_lp_enrollment_id
544: ,p_learning_path_section_id
545: ,p_learning_path_member_id