APPS.OTA_CME_UTIL dependencies on OTA_BOOKING_STATUS_TYPES

Line 33: p_booking_status_type OUT NOCOPY ota_booking_status_types.type%TYPE,

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:
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,

Line 38: 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);
41:
42: -- ---------------------------------------------------------------------------