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:
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:
36: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
37: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
38: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,
39: p_date_status_changed OUT NOCOPY ota_delegate_bookings.date_status_changed%TYPE,
40: p_successful_attendance_flag OUT NOCOPY ota_delegate_bookings.successful_attendance_flag%TYPE);
67: -- Internal Development Use Only.
68: --
69: -- {End Of Comments}
70: -- ---------------------------------------------------------------------------
71: PROCEDURE calculate_cme_status(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,
72: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,
73: p_mode IN VARCHAR2,
74: p_member_status_code OUT nocopy VARCHAR2,
75: p_completion_date OUT nocopy DATE,