APPS.OTA_CME_INS dependencies on OTA_CERT_MBR_ENROLLMENTS

Line 87: -- Insert the row into: ota_cert_mbr_enrollments

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

Line 89: insert into ota_cert_mbr_enrollments

85: --
86: --
87: -- Insert the row into: ota_cert_mbr_enrollments
88: --
89: insert into ota_cert_mbr_enrollments
90: (cert_mbr_enrollment_id
91: ,cert_prd_enrollment_id
92: ,cert_member_id
93: ,member_status_code

Line 215: Cursor C_Sel1 is select ota_cert_mbr_enrollments_s.nextval from sys.dual;

211: Procedure pre_insert
212: (p_rec in out nocopy ota_cme_shd.g_rec_type
213: ) is
214: --
215: Cursor C_Sel1 is select ota_cert_mbr_enrollments_s.nextval from sys.dual;
216: --
217: Cursor C_Sel2 is
218: Select null
219: from ota_cert_mbr_enrollments

Line 219: from ota_cert_mbr_enrollments

215: Cursor C_Sel1 is select ota_cert_mbr_enrollments_s.nextval from sys.dual;
216: --
217: Cursor C_Sel2 is
218: Select null
219: from ota_cert_mbr_enrollments
220: where cert_mbr_enrollment_id =
221: ota_cme_ins.g_cert_mbr_enrollment_id_i;
222: --
223: l_proc varchar2(72) := g_package||'pre_insert';

Line 241: fnd_message.set_token('TABLE_NAME','ota_cert_mbr_enrollments');

237: --
238: -- The primary key values are already in use.
239: --
240: fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
241: fnd_message.set_token('TABLE_NAME','ota_cert_mbr_enrollments');
242: fnd_message.raise_error;
243: End If;
244: Close C_Sel2;
245: --

Line 374: (p_module_name => 'OTA_CERT_MBR_ENROLLMENTS'

370: --
371: when hr_api.cannot_find_prog_unit then
372: --
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'OTA_CERT_MBR_ENROLLMENTS'
375: ,p_hook_type => 'AI');
376: --
377: end;
378: --