APPS.OTA_UTILITY dependencies on OTA_ATTEMPTS

Line 740: FUNCTION get_user_fullname(p_user_id IN ota_attempts.user_id%TYPE,

736: p_event_id IN ota_events.event_id%TYPE,
737: p_code number)
738: RETURN VARCHAR2;
739:
740: FUNCTION get_user_fullname(p_user_id IN ota_attempts.user_id%TYPE,
741: p_user_type IN ota_attempts.user_type%TYPE)
742:
743: RETURN VARCHAR2;
744:

Line 741: p_user_type IN ota_attempts.user_type%TYPE)

737: p_code number)
738: RETURN VARCHAR2;
739:
740: FUNCTION get_user_fullname(p_user_id IN ota_attempts.user_id%TYPE,
741: p_user_type IN ota_attempts.user_type%TYPE)
742:
743: RETURN VARCHAR2;
744:
745: FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE

Line 745: FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE

741: p_user_type IN ota_attempts.user_type%TYPE)
742:
743: RETURN VARCHAR2;
744:
745: FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE
746: )RETURN VARCHAR2;
747:
748: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,
749: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,