APPS.OTA_LO_UTILITY dependencies on OTA_BOOKING_STATUS_TYPES

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

215: p_synchronous_flag ota_category_usages.synchronous_flag%type,
216: p_online_flag ota_category_usages.online_flag%type,
217: p_course_start_date ota_events.course_start_date%type,
218: p_course_end_date ota_events.course_end_date%type,
219: p_enrollment_status_type ota_booking_status_types.type%TYPE DEFAULT NULL,
220: p_cert_prd_enrollment_id ota_attempts.cert_prd_enrollment_id%type default null,
221: p_contact_id ota_cert_enrollments.contact_id%type default null,
222: p_chk_active_cert_flag varchar2 default 'N') return varchar2;
223:

Line 335: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,

331:
332: FUNCTION get_enroll_lo_status(p_user_id IN NUMBER,
333: p_user_type IN ota_attempts.user_type%type,
334: p_event_id IN ota_events.event_id%TYPE,
335: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,
336: p_booking_id IN ota_delegate_bookings.booking_id%TYPE,
337: p_mode IN number default null,
338: p_chk_active_cert_flag varchar2 default 'N')
339: RETURN VARCHAR2;

Line 423: p_booking_status_type_id IN ota_booking_status_types.booking_status_type_id%TYPE,

419:
420: FUNCTION get_cert_lo_status(p_user_id IN NUMBER,
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;