APPS.OTA_CME_UTIL dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 32: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,

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:
36: PROCEDURE get_enrl_status_on_update(p_activity_version_id IN ota_activity_versions.activity_version_id%TYPE,

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

Line 72: p_cert_prd_enrollment_id IN ota_cert_prd_enrollments.cert_prd_enrollment_id%TYPE,

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,
76: p_is_recert IN VARCHAR2 default 'N');

Line 234: return ota_cert_prd_enrollments.cert_prd_enrollment_id%type;

230:
231: function get_cert_prd_enroll_id(p_event_id IN ota_events.event_id%type,
232: p_person_id IN ota_cert_enrollments.person_id%type,
233: p_contact_id ota_cert_enrollments.contact_id%type)
234: return ota_cert_prd_enrollments.cert_prd_enrollment_id%type;
235: END OTA_CME_UTIL;