APPS.OTA_CPR_UTILITY dependencies on OTA_DELEGATE_BOOKINGS

Line 430: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,

426: End get_enroll_image;
427:
428:
429: Procedure chk_mandatory_prereqs
430: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,
431: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
432: p_event_id ota_events.event_id%TYPE
433: ) IS
434:

Line 431: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,

427:
428:
429: Procedure chk_mandatory_prereqs
430: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,
431: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
432: p_event_id ota_events.event_id%TYPE
433: ) IS
434:
435: Cursor c_get_act_ver_id is

Line 571: ota_delegate_bookings odb,

567: ,decode(odb.delegate_person_id,null,'C', 'E')
568: ,p_prerequisite_course_id
569: ) prereq_met
570: from
571: ota_delegate_bookings odb,
572: ota_booking_status_types bst,
573: ota_events evb
574: where
575: odb.booking_status_type_id = bst.booking_status_type_id

Line 612: ota_delegate_bookings odb,

608: ,p_comp_id
609: ,p_level_id
610: ) prereq_met
611: from
612: ota_delegate_bookings odb,
613: ota_events evb
614: where
615: evb.event_id = odb.event_id
616: and evb.event_id = p_event_id;

Line 730: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE

726: END is_mand_comp_prereqs_comp_evt;
727:
728: FUNCTION is_mand_crs_prereqs_comp_evt
729: (p_person_id in per_all_people_f.person_id%type
730: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE
731: ,p_user_id in number
732: ,p_user_type in varchar2
733: ,p_event_id in ota_events.event_id%type
734: ) RETURN varchar2

Line 757: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL

753: END is_mand_crs_prereqs_comp_evt;
754:
755: FUNCTION is_mandatory_prereqs_comp_evt
756: (p_person_id in per_all_people_f.person_id%type
757: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL
758: ,p_user_id in number default NULL
759: ,p_user_type in varchar2 default 'E'
760: , p_event_id in ota_events.event_id%type
761: ) RETURN varchar2