APPS.OTA_LRNG_PATH_MEMBER_UTIL dependencies on OTA_ACTIVITY_VERSIONS

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

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

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

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

Line 429: p_activity_version_id ota_activity_versions.activity_version_id%TYPE,

425: FUNCTION get_lp_completion_date(p_lp_enrollment_id ota_lp_enrollments.lp_enrollment_id%TYPE)
426: RETURN DATE;
427:
428: FUNCTION get_lpm_completion_date(p_lp_member_enrollment_id ota_lp_member_enrollments.lp_member_enrollment_id%TYPE,
429: p_activity_version_id ota_activity_versions.activity_version_id%TYPE,
430: p_person_id ota_lp_enrollments.person_id%TYPE,
431: p_contact_id ota_lp_enrollments.contact_id%TYPE)
432: RETURN DATE;
433: