741: l_found boolean := false;
742: --
743: cursor c1 is
744: select null
745: from ota_resource_bookings
746: where event_id = p_event_id
747: and (required_date_from = p_course_start_date
748: and required_start_time <
749: p_start_time
2803: -- cursor to check if resources exist for the event
2804: --
2805: Cursor c_resource_details is
2806: select 'X'
2807: from ota_resource_bookings
2808: where event_id = p_event_id;
2809: --
2810: -- cursor to check if program membership exist for the event
2811: --