APPS.OTA_LO_UTILITY dependencies on OTA_CERT_MBR_ENROLLMENT_API

Line 270: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment

266: --call upd cme api
267: -- Added the following if clause for the newly introduced cme status 'pending'. This would prevent updation of
268: -- certification status to certified even if the member status is completed when the enrollments are in pending signature/evaluation status.
269: if l_member_status_code = 'PENDING' then
270: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment
271: (p_effective_date => sysdate
272: ,p_object_version_number => a_cert_mbr_enrollment.object_version_number
273: ,p_cert_member_id => a_cert_mbr_enrollment.cert_member_id
274: ,p_cert_prd_enrollment_id => p_cert_prd_enroll_id

Line 278: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment

274: ,p_cert_prd_enrollment_id => p_cert_prd_enroll_id
275: ,p_cert_mbr_enrollment_id => a_cert_mbr_enrollment.cert_mbr_enrollment_id
276: ,p_member_status_code => l_member_status_code);
277: elsif l_member_status_code = 'COMPLETED' then
278: ota_cert_mbr_enrollment_api.update_cert_mbr_enrollment
279: (p_effective_date => sysdate
280: ,p_object_version_number => a_cert_mbr_enrollment.object_version_number
281: ,p_cert_member_id => a_cert_mbr_enrollment.cert_member_id
282: ,p_cert_prd_enrollment_id => p_cert_prd_enroll_id