APPS.OTA_UTILITY dependencies on OTA_DELEGATE_BOOKINGS

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

765: FUNCTION get_question_bank_count (p_folder_id in number)
766: RETURN varchar2;
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;

Line 784: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,

780: FUNCTION get_person_fullname(p_user_id IN ota_attempts.user_id%TYPE
781: )RETURN VARCHAR2;
782:
783: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,
784: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
785: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
786: RETURN VARCHAR2;
787:
788: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)

Line 785: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)

781: )RETURN VARCHAR2;
782:
783: FUNCTION get_learner_name(p_person_id IN per_all_people_f.person_id%TYPE,
784: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
785: p_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
786: RETURN VARCHAR2;
787:
788: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
789: RETURN number;

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

787:
788: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
789: RETURN number;
790:
791: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
792: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
793: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
794: RETURN VARCHAR2;
795:

Line 792: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,

788: FUNCTION get_customer_id(p_contact_id IN ota_lp_enrollments.contact_id%TYPE)
789: RETURN number;
790:
791: FUNCTION get_cust_org_name(p_organization_id IN ota_delegate_bookings.organization_id%TYPE,
792: p_customer_id IN ota_delegate_bookings.customer_id%TYPE,
793: p_contact_id IN ota_lp_enrollments.contact_id%TYPE default null)
794: RETURN VARCHAR2;
795:
796: -- ----------------------------------------------------------------

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

922: -- Public
923: -- {End of Comments}
924: ------------------------------------------------------------------
925: FUNCTION get_ext_lrnr_party_id
926: (p_delegate_contact_id IN ota_delegate_bookings.delegate_contact_id%TYPE)
927: RETURN number;
928:
929: FUNCTION is_enrollable
930: ( p_object_type in varchar2

Line 1016: p_mandatory_flag in ota_delegate_bookings.is_mandatory_enrollment%TYPE,

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(
1020: p_enr_type varchar2,