[Home] [Help]
706: /*
707: cursor get_resource_info
708: is
709: select osr.trainer_id
710: from ota_suppliable_resources osr
711: where
712: osr.supplied_resource_id=p_sup_res_id;
713: */
714: cursor get_event_info
725: is
726: select distinct(osr.trainer_id) trainer_id ,orb.required_date_from,orb.required_date_to,
727: orb.required_start_time,orb.required_end_time,orb.status,ota_timezone_util.get_timezone_name(orb.timezone_code) timezone,
728: orb.resource_booking_id resource_booking_id
729: from ota_resource_bookings orb,ota_suppliable_resources osr
730: where orb.supplied_resource_id = osr.supplied_resource_id
731: and osr.resource_type ='T'
732: and orb.event_id = p_eventid
733: and (p_res_book_id is null or orb.resource_booking_id=p_res_book_id);
736: is
737: select osr.trainer_id trainer_id ,orb.required_date_from,orb.required_date_to,
738: orb.required_start_time,orb.required_end_time,orb.status,ota_timezone_util.get_timezone_name(orb.timezone_code) timezone,
739: orb.resource_booking_id resource_booking_id
740: from ota_resource_bookings orb,ota_suppliable_resources osr
741: where orb.supplied_resource_id = osr.supplied_resource_id
742: and osr.supplied_resource_id = p_sup_res_id
743: and osr.resource_type ='T'
744: and orb.event_id = p_eventid;
1131: --- get all class info for instructor
1132:
1133: cursor get_supp_res_id is
1134: select supplied_resource_id
1135: from ota_suppliable_resources
1136: where resource_type ='T';
1137:
1138: cursor get_all_cls_info (l_supp_res_id number) is
1139: select orb.event_id event_id
1145:
1146: /*cursor get_all_cls_info
1147: is
1148: select distinct(orb.event_id) event_id, orb.supplied_resource_id
1149: from ota_resource_bookings orb,ota_suppliable_resources osr
1150: where orb.supplied_resource_id = osr.supplied_resource_id
1151: and osr.resource_type ='T'
1152: and orb.required_date_from = (trunc(sysdate) + l_notify_days_before)
1153: and orb.status= 'C'