APPS.OTA_LME_INS dependencies on OTA_LP_MEMBER_ENROLLMENTS

Line 87: -- Insert the row into: ota_lp_member_enrollments

83: p_rec.object_version_number := 1; -- Initialise the object version
84: --
85: --
86: --
87: -- Insert the row into: ota_lp_member_enrollments
88: --
89: insert into ota_lp_member_enrollments
90: (lp_member_enrollment_id
91: ,lp_enrollment_id

Line 89: insert into ota_lp_member_enrollments

85: --
86: --
87: -- Insert the row into: ota_lp_member_enrollments
88: --
89: insert into ota_lp_member_enrollments
90: (lp_member_enrollment_id
91: ,lp_enrollment_id
92: ,learning_path_section_id
93: ,learning_path_member_id

Line 243: Cursor C_Sel1 is select ota_lp_member_enrollments_s.nextval from sys.dual;

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: --
245: Cursor C_Sel2 is
246: Select null
247: from ota_lp_member_enrollments

Line 247: from ota_lp_member_enrollments

243: Cursor C_Sel1 is select ota_lp_member_enrollments_s.nextval from sys.dual;
244: --
245: Cursor C_Sel2 is
246: Select null
247: from ota_lp_member_enrollments
248: where lp_member_enrollment_id =
249: ota_lme_ins.g_lp_member_enrollment_id_i;
250: --
251: l_proc varchar2(72) := g_package||'pre_insert';

Line 269: fnd_message.set_token('TABLE_NAME','ota_lp_member_enrollments');

265: --
266: -- The primary key values are already in use.
267: --
268: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
269: fnd_message.set_token('TABLE_NAME','ota_lp_member_enrollments');
270: fnd_message.raise_error;
271: End If;
272: Close C_Sel2;
273: --

Line 430: (p_module_name => 'OTA_LP_MEMBER_ENROLLMENTS'

426: --
427: when hr_api.cannot_find_prog_unit then
428: --
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'OTA_LP_MEMBER_ENROLLMENTS'
431: ,p_hook_type => 'AI');
432: --
433: end;
434: --