APPS.OTA_UTILITY dependencies on OTA_EVENTS

Line 771: p_event_id IN ota_events.event_id%TYPE,

767:
768: -- Author: sbhullar
769: FUNCTION get_enrollment_status(p_delegate_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
770: p_delegate_contact_id IN NUMBER,
771: p_event_id IN ota_events.event_id%TYPE,
772: p_code number)
773: RETURN VARCHAR2;
774:
775: FUNCTION get_user_fullname(p_user_id IN ota_attempts.user_id%TYPE,

Line 882: Function get_event_status_code (p_event_id in ota_events.event_id%TYPE)

878: -- Access Status
879: -- Public
880: -- {End of Comments}
881: ------------------------------------------------------------------
882: Function get_event_status_code (p_event_id in ota_events.event_id%TYPE)
883: return varchar2;
884:
885: -- ----------------------------------------------------------------
886: -- ----------------------< is_applicant >--------------------------

Line 1010: function get_class_available_seats(p_event_id ota_events.event_id%type) return varchar2;

1006: function get_lang_name (
1007: p_language_code in varchar2
1008: ) return varchar2;
1009:
1010: function get_class_available_seats(p_event_id ota_events.event_id%type) return varchar2;
1011:
1012: function get_cls_enroll_image(p_manager_flag in varchar2,
1013: p_person_id in number,
1014: p_contact_id in number,

Line 1015: p_event_id in ota_events.event_id%TYPE,

1011:
1012: function get_cls_enroll_image(p_manager_flag in varchar2,
1013: p_person_id in number,
1014: p_contact_id in number,
1015: p_event_id in ota_events.event_id%TYPE,
1016: p_mandatory_flag in ota_delegate_bookings.is_mandatory_enrollment%TYPE,
1017: p_booking_status_type in ota_booking_status_types.type%TYPE) return varchar2;
1018:
1019: FUNCTION is_class_enrollable(

Line 1021: p_class_id ota_events.event_id%TYPE)

1017: p_booking_status_type in ota_booking_status_types.type%TYPE) return varchar2;
1018:
1019: FUNCTION is_class_enrollable(
1020: p_enr_type varchar2,
1021: p_class_id ota_events.event_id%TYPE)
1022: RETURN VARCHAR2;
1023:
1024: function get_learners_email_addresses(p_event_id ota_events.event_id%type) return clob;
1025:

Line 1024: function get_learners_email_addresses(p_event_id ota_events.event_id%type) return clob;

1020: p_enr_type varchar2,
1021: p_class_id ota_events.event_id%TYPE)
1022: RETURN VARCHAR2;
1023:
1024: function get_learners_email_addresses(p_event_id ota_events.event_id%type) return clob;
1025:
1026:
1027: end ota_utility;
1028: