APPS.OTA_LO_UTILITY dependencies on OTA_CME_UTIL

Line 261: ota_cme_util.calculate_cme_status(p_activity_version_id => a_cert_mbr_enrollment.object_id,

257:
258: -- calculating cme status depending on enrollment status even in case of online classes as
259: -- the enrollment status drives the cme status now. If the enrollment status is in pending signature/evaluation,
260: -- then the cme status should be pending even if the player status for the online course is completed.
261: ota_cme_util.calculate_cme_status(p_activity_version_id => a_cert_mbr_enrollment.object_id,
262: p_cert_prd_enrollment_id => p_cert_prd_enroll_id,
263: p_mode => 'U',
264: p_member_status_code => l_member_status_code,
265: p_completion_date => l_completion_date);

Line 289: ota_cme_util.update_cpe_status(a_cert_mbr_enrollment.cert_mbr_enrollment_id, a_cert_mbr_enrollment.cert_prd_enrollment_id);

285: ,p_completion_date => p_date);
286: end if;
287:
288: -- cascade status to certification period
289: ota_cme_util.update_cpe_status(a_cert_mbr_enrollment.cert_mbr_enrollment_id, a_cert_mbr_enrollment.cert_prd_enrollment_id);
290:
291: end loop;
292: end update_cme_status_for_lo;
293:

Line 441: --earlier for certifications. This is needed only for online courses as the code in ota_cme_util.update_cme_status

437:
438:
439: --Added the following code to update cme status after learner has given the signature for a course
440: --which is part of a cert. This code is not present earlier as signature have not been implemented
441: --earlier for certifications. This is needed only for online courses as the code in ota_cme_util.update_cme_status
442: --will ignore the online case whenever there is a enrollment update.
443: if p_signed = 'Y' then
444: open csr_book_details;
445: fetch csr_book_details into l_person_id, l_contact_id, l_lo_id;

Line 2508: l_cert_mbr_enrollment_id := ota_cme_util.get_cert_mbr_enroll_id(p_event_id, p_user_id, p_contact_id);

2504: l_cert_mbr_enrollment_id ota_cert_mbr_enrollments.cert_mbr_enrollment_id%type;
2505: begin
2506:
2507: if p_chk_active_cert_flag = 'Y' then
2508: l_cert_mbr_enrollment_id := ota_cme_util.get_cert_mbr_enroll_id(p_event_id, p_user_id, p_contact_id);
2509: if(l_cert_mbr_enrollment_id is not null) then
2510: return get_cme_play_button(p_user_id,p_user_type,p_is_manager,l_cert_mbr_enrollment_id);
2511: end if;
2512: end if;

Line 3589: l_cert_prd_enrollment_id := ota_cme_util.get_cert_prd_enroll_id(p_event_id, l_person_id, l_contact_id);

3585: fetch csr_contact_id into l_contact_id;
3586: close csr_contact_id;
3587: end if;
3588:
3589: l_cert_prd_enrollment_id := ota_cme_util.get_cert_prd_enroll_id(p_event_id, l_person_id, l_contact_id);
3590:
3591: if l_cert_prd_enrollment_id is not null then
3592: --return status mng as 'Available under certification'
3593: --added for 14000818

Line 5695: l_cert_prd_enr_id := ota_cme_util.get_cert_prd_enroll_id(p_event_id, l_person_id, l_contact_id);

5691: l_person_id := p_user_id;
5692: elsif p_user_type = 'C' then
5693: l_contact_id := get_contact_id_for_party(p_user_id);
5694: end if;
5695: l_cert_prd_enr_id := ota_cme_util.get_cert_prd_enroll_id(p_event_id, l_person_id, l_contact_id);
5696: end if;
5697:
5698: -- Check if Tracking type of learning object is S or not
5699: open c_learning_object_tracktype;