APPS.OTA_CPR_UTILITY dependencies on OTA_UTILITY

Line 259: l_enrollment_status := ota_utility.get_enrollment_status(p_person_id, p_delegate_contact_id, a_event_rec.event_id, 1);

255: End If;
256: End If;
257: Close c_learning_object_status;
258: Else -- Offline class
259: l_enrollment_status := ota_utility.get_enrollment_status(p_person_id, p_delegate_contact_id, a_event_rec.event_id, 1);
260: If ( l_enrollment_status = 'A' ) Then
261: l_completed_status := 'Y';
262: RETURN l_completed_status;
263: End If;

Line 407: l_enrollment_status := ota_utility.get_enrollment_status(p_person_id, p_delegate_contact_id, p_event_id, 1);

403: l_enrollment_status varchar2(1);
404: l_prereq_completed_status varchar2(1);
405: l_act_ver_id ota_activity_versions.activity_version_id%type;
406: Begin
407: l_enrollment_status := ota_utility.get_enrollment_status(p_person_id, p_delegate_contact_id, p_event_id, 1);
408: If ( l_enrollment_status = 'P' or l_enrollment_status = 'W' or l_enrollment_status = 'R' or l_enrollment_status = 'A') Then --Bug 4518920
409: l_enroll_image := 'AE'; -- Already enrolled
410: RETURN l_enroll_image;
411: End If;

Line 769: l_user_id := ota_utility.get_ext_lrnr_party_id(p_delegate_contact_id);

765: BEGIN
766:
767: If p_delegate_contact_id is not null then
768: l_user_type := 'C';
769: l_user_id := ota_utility.get_ext_lrnr_party_id(p_delegate_contact_id);
770:
771: end if;
772: IF is_mand_crs_prereqs_comp_evt(p_person_id => p_person_id
773: ,p_delegate_contact_id => p_delegate_contact_id