APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_ACTIVITY_VERSIONS

Line 140: PROCEDURE calculate_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

136: -- Internal Development Use Only.
137: --
138: -- {End Of Comments}
139: -- ---------------------------------------------------------------------------
140: PROCEDURE calculate_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
141: p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
142: p_member_status_code OUT nocopy VARCHAR2,
143: p_completion_date OUT nocopy DATE);
144:

Line 175: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

171: -- Internal Development Use Only.
172: --
173: -- {End Of Comments}
174: -- ---------------------------------------------------------------------------
175: FUNCTION get_lme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
176: p_person_id IN ota_learning_paths.person_id%TYPE,
177: p_contact_id IN ota_learning_paths.contact_id%TYPE)
178: RETURN VARCHAR2;
179: