APPS.OTA_LO_UTILITY dependencies on OTA_CERT_PRD_ENROLLMENTS

Line 173: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

169: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null) return varchar2;
170:
171:
172: function user_can_attempt_cert(
173: p_cert_prd_enroll_id ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
174: p_user_id fnd_user.user_id%type,
175: p_user_type ota_attempts.user_type%type,
176: p_reason out nocopy number) return varchar2;
177:

Line 425: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,

421: p_user_type IN ota_attempts.user_type%type,
422: p_event_id IN ota_events.event_id%TYPE,
423: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
424: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
425: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
426: p_mode IN number default null)
427: RETURN varchar2;
428:
429: -- ----------------------------------------------------------------