APPS.OTA_LO_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES

Line 235: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,

231: p_synchronous_flag ota_category_usages.synchronous_flag%type,
232: p_online_flag ota_category_usages.online_flag%type,
233: p_course_start_date ota_events.course_start_date%type,
234: p_course_end_date ota_events.course_end_date%type,
235: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
236: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
237: p_contact_id ota_cert_enrollments.contact_id%type default null,
238: p_chk_active_cert_flag varchar2 default 'N') return varchar2;
239:

Line 351: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,

347:
348: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
349: p_user_type IN ota_attempts.user_type%type,
350: p_event_id IN ota_events.event_id%TYPE,
351: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
352: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
353: p_mode IN number default null,
354: p_chk_active_cert_flag varchar2 default 'N')
355: RETURN VARCHAR2;

Line 439: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,

435:
436: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
437: p_user_type IN ota_attempts.user_type%type,
438: p_event_id IN ota_events.event_id%TYPE,
439: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
440: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
441: p_cert_prd_enrollment_id in ota_cert_prd_enrollments.cert_prd_enrollment_id%type,
442: p_mode IN number default null)
443: RETURN varchar2;