APPS.OTA_CPR_UTILITY dependencies on OTA_DELEGATE_BOOKINGS

Line 424: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,

420: End get_enroll_image;
421:
422:
423: Procedure chk_mandatory_prereqs
424: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,
425: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
426: p_event_id ota_events.event_id%TYPE
427: ) IS
428:

Line 425: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,

421:
422:
423: Procedure chk_mandatory_prereqs
424: (p_person_id ota_delegate_bookings.delegate_person_id%TYPE,
425: p_delegate_contact_id ota_delegate_bookings.delegate_contact_id%TYPE,
426: p_event_id ota_events.event_id%TYPE
427: ) IS
428:
429: Cursor c_get_act_ver_id is

Line 565: ota_delegate_bookings odb,

561: ,decode(odb.delegate_person_id,null,'C', 'E')
562: ,p_prerequisite_course_id
563: ) prereq_met
564: from
565: ota_delegate_bookings odb,
566: ota_booking_status_types bst,
567: ota_events evb
568: where
569: odb.booking_status_type_id = bst.booking_status_type_id

Line 606: ota_delegate_bookings odb,

602: ,p_comp_id
603: ,p_level_id
604: ) prereq_met
605: from
606: ota_delegate_bookings odb,
607: ota_events evb
608: where
609: evb.event_id = odb.event_id
610: and evb.event_id = p_event_id;

Line 724: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE

720: END is_mand_comp_prereqs_comp_evt;
721:
722: FUNCTION is_mand_crs_prereqs_comp_evt
723: (p_person_id in per_all_people_f.person_id%type
724: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE
725: ,p_user_id in number
726: ,p_user_type in varchar2
727: ,p_event_id in ota_events.event_id%type
728: ) RETURN varchar2

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

747: END is_mand_crs_prereqs_comp_evt;
748:
749: FUNCTION is_mandatory_prereqs_comp_evt
750: (p_person_id in per_all_people_f.person_id%type
751: ,p_delegate_contact_id in ota_delegate_bookings.delegate_contact_id%TYPE default NULL
752: ,p_user_id in number default NULL
753: ,p_user_type in varchar2 default 'E'
754: , p_event_id in ota_events.event_id%type
755: ) RETURN varchar2