APPS.OTA_TIMEZONE_UTIL dependencies on OTA_CATEGORY_USAGES

Line 300: l_online_flag ota_category_usages.online_flag%TYPE;

296: ,p_timevalue IN VARCHAR2
297: ,p_event_id IN NUMBER)
298: RETURN DATE
299: IS
300: l_online_flag ota_category_usages.online_flag%TYPE;
301: l_evt_timezone ota_events.timezone%TYPE;
302: BEGIN
303: OPEN get_class_info(p_event_id);
304: FETCH get_class_info INTO l_online_flag, l_evt_timezone;

Line 318: l_online_flag ota_category_usages.online_flag%TYPE;

314: ,p_timevalue IN VARCHAR2
315: ,p_resource_booking_id IN NUMBER)
316: RETURN DATE
317: IS
318: l_online_flag ota_category_usages.online_flag%TYPE;
319: --l_trb_timezone ota_resource_bookings.timezone%TYPE;
320: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;
321: l_trb_timezone_name fnd_timezones_tl.name%TYPE;
322: BEGIN