APPS.OTA_CME_UTIL dependencies on OTA_ACTIVITY_VERSIONS

Line 31: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

27: -- Internal Development Use Only.
28: --
29: -- {End Of Comments}
30: -- ----------------------------------------------------------------------------
31: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
32: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
33: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
34: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE);
35:

Line 65: PROCEDURE calculate_cme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

61: -- Internal Development Use Only.
62: --
63: -- {End Of Comments}
64: -- ---------------------------------------------------------------------------
65: PROCEDURE calculate_cme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
66: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
67: p_mode IN VARCHAR2,
68: p_member_status_code OUT nocopy VARCHAR2,
69: p_completion_date OUT nocopy DATE);