APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_LRNG_PATH_MEMBER_UTIL

Line 240: ,p_completion_date => ota_lrng_path_member_util.get_lp_completion_date(p_lp_enrollment_id));

236: (p_effective_date => sysdate
237: ,p_lp_enrollment_id => p_lp_enrollment_id
238: ,p_object_version_number => l_object_version_number
239: ,p_path_status_code => l_path_status_code
240: ,p_completion_date => ota_lrng_path_member_util.get_lp_completion_date(p_lp_enrollment_id));
241: ELSE
242: CLOSE csr_lpe_update;
243: END IF;
244: END complete_path;

Line 541: ,p_completion_date => ota_lrng_path_member_util.get_lp_completion_date(p_lp_enrollment_id));

537: ,p_no_of_completed_courses => l_no_of_completed_courses
538: ,p_no_of_mandatory_courses => l_no_of_mandatory_courses
539: ,p_completion_target_date => l_completion_target_date
540: ,p_path_status_code => l_path_status_code
541: ,p_completion_date => ota_lrng_path_member_util.get_lp_completion_date(p_lp_enrollment_id));
542: --set the return flag as completed
543: l_return_status := 'C';
544: ELSE
545: ota_lp_enrollment_api.update_lp_enrollment

Line 1007: OTA_LRNG_PATH_MEMBER_UTIL.get_enrollment_status(p_person_id => lp_mbr_rec.person_id,

1003: for lp_mbr_rec in lp_members loop
1004: if(lp_mbr_rec.path_status_code = 'CANCELLED') then
1005: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', 'CANCELLED', 810);
1006: end if;
1007: OTA_LRNG_PATH_MEMBER_UTIL.get_enrollment_status(p_person_id => lp_mbr_rec.person_id,
1008: p_contact_id => lp_mbr_rec.contact_id,
1009: p_activity_version_id => lp_mbr_rec.activity_version_id,
1010: p_lp_member_enrollment_id => lp_mbr_rec.lp_member_enrollment_id,
1011: p_booking_status_type => l_enroll_type,