APPS.OTA_LRNG_PATH_UTIL dependencies on OTA_UTILITY

Line 1001: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', 'COMPLETED', 810);

997: l_successful_attendance_flag ota_delegate_bookings.successful_attendance_flag%type;
998:
999: begin
1000: if(ota_lrng_path_util.is_path_successful(p_lp_enrollment_id => p_lp_enrollment_id) = 'Y') then
1001: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', 'COMPLETED', 810);
1002: else
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);

Line 1005: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', 'CANCELLED', 810);

1001: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', 'COMPLETED', 810);
1002: else
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,

Line 1028: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', l_path_status_code, 810);

1024: l_path_status_code := 'SUBSCRIBED';
1025: end if;
1026: end loop;
1027: end if;
1028: return ota_utility.get_lookup_meaning('OTA_LP_CURRENT_STATUS', l_path_status_code, 810);
1029: end get_lp_current_status;
1030:
1031: function get_lp_enroll_id(p_event_id IN ota_events.event_id%type,
1032: p_person_id IN ota_lp_enrollments.person_id%type,