APPS.OTA_UTILITY dependencies on OTA_DELEGATE_BOOKINGS

Line 734: FUNCTION get_enrollment_status(p_delegate_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,

730: FUNCTION get_question_bank_count (p_folder_id in number)
731: RETURN varchar2;
732:
733: -- Author: sbhullar
734: FUNCTION get_enrollment_status(p_delegate_person_id IN ota_delegate_bookings.delegate_person_id%TYPE,
735: p_delegate_contact_id IN NUMBER,
736: p_event_id IN ota_events.event_id%TYPE,
737: p_code number)
738: RETURN VARCHAR2;

Line 749: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,

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,
750: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
751: RETURN VARCHAR2;
752:
753: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)

Line 750: p_contact_id IN ota_delegate_bookings.delegate_contact_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,
750: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
751: RETURN VARCHAR2;
752:
753: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
754: RETURN number;

Line 756: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,

752:
753: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
754: RETURN number;
755:
756: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
757: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
758: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
759: RETURN VARCHAR2;
760:

Line 757: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,

753: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
754: RETURN number;
755:
756: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
757: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
758: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
759: RETURN VARCHAR2;
760:
761: -- ----------------------------------------------------------------

Line 891: (p_delegate_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)

887: -- Public
888: -- {End of Comments}
889: ------------------------------------------------------------------
890: FUNCTION get_ext_lrnr_party_id
891: (p_delegate_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
892: RETURN number;
893:
894: FUNCTION is_enrollable
895: ( p_object_type in varchar2