APPS.OTA_TIMEZONE_UTIL dependencies on FND_TIMEZONES

Line 15: RETURN fnd_timezones_pvt.adjust_datetime(

11: RETURN DATE
12: IS
13: BEGIN
14:
15: RETURN fnd_timezones_pvt.adjust_datetime(
16: date_time => p_date
17: ,from_tz => p_src_timezone_code
18: ,to_tz => p_dest_timezone_code);
19: END convert_date_fnd;

Line 41: FROM fnd_timezones_b

37: RETURN NUMBER
38: IS
39: CURSOR csr_get_timezone_id IS
40: SELECT UPGRADE_TZ_ID
41: FROM fnd_timezones_b
42: WHERE timezone_code = p_timezone_code;
43:
44: l_timezone_id fnd_timezones_b.UPGRADE_TZ_ID%TYPE := NULL;
45: BEGIN

Line 44: l_timezone_id fnd_timezones_b.UPGRADE_TZ_ID%TYPE := NULL;

40: SELECT UPGRADE_TZ_ID
41: FROM fnd_timezones_b
42: WHERE timezone_code = p_timezone_code;
43:
44: l_timezone_id fnd_timezones_b.UPGRADE_TZ_ID%TYPE := NULL;
45: BEGIN
46: OPEN csr_get_timezone_id;
47: FETCH csr_get_timezone_id INTO l_timezone_id;
48: CLOSE csr_get_timezone_id;

Line 60: FROM fnd_timezones_vl

56: IS
57: CURSOR csr_get_client_tzvals IS
58: SELECT timezone_code
59: ,name
60: FROM fnd_timezones_vl
61: WHERE UPGRADE_TZ_ID = fnd_profile.VALUE ('CLIENT_TIMEZONE_ID');
62: BEGIN
63: p_timezone_code := NULL;
64: p_timezone_name := NULL;

Line 73: l_timezone_code VARCHAR2(50) := fnd_timezones.get_server_timezone_code;

69:
70: FUNCTION get_server_timezone_code
71: RETURN VARCHAR2
72: IS
73: l_timezone_code VARCHAR2(50) := fnd_timezones.get_server_timezone_code;
74: /*
75: l_db_timezone VARCHAR2(6) := NULL;
76: l_offset NUMBER;
77:

Line 80: FROM FND_TIMEZONES_B

76: l_offset NUMBER;
77:
78: CURSOR csr_timezone_code(p_offset NUMBER) IS
79: SELECT timezone_code
80: FROM FND_TIMEZONES_B
81: WHERE GMT_OFFSET = p_offset
82: AND enabled_flag = 'Y';
83: */
84:

Line 113: FROM fnd_timezones_tl ftt

109: IS
110: CURSOR csr_get_evt_tzvals IS
111: SELECT timezone_code
112: ,name
113: FROM fnd_timezones_tl ftt
114: ,ota_events evt
115: WHERE event_id = p_event_id
116: AND evt.timezone = ftt.timezone_code
117: AND ftt.language = userenv('LANG');

Line 133: FROM fnd_timezones_tl

129: RETURN VARCHAR2
130: IS
131: CURSOR csr_get_timezone_vals IS
132: SELECT name
133: FROM fnd_timezones_tl
134: WHERE timezone_code = p_timezone_code
135: AND LANGUAGE = userenv('LANG');
136:
137: l_timezone_name fnd_timezones_tl.name%TYPE := NULL;

Line 137: l_timezone_name fnd_timezones_tl.name%TYPE := NULL;

133: FROM fnd_timezones_tl
134: WHERE timezone_code = p_timezone_code
135: AND LANGUAGE = userenv('LANG');
136:
137: l_timezone_name fnd_timezones_tl.name%TYPE := NULL;
138: BEGIN
139: OPEN csr_get_timezone_vals;
140: FETCH csr_get_timezone_vals INTO l_timezone_name;
141: CLOSE csr_get_timezone_vals;

Line 234: RETURN convert_date(p_datevalue, p_timevalue, p_src_timezone,fnd_timezones.get_client_timezone_code);

230: IF p_online_flag = 'N' THEN
231: -- Do not convert for Offline Classes
232: RETURN convert_date(p_datevalue, p_timevalue, p_src_timezone, NULL);
233: ELSE
234: RETURN convert_date(p_datevalue, p_timevalue, p_src_timezone,fnd_timezones.get_client_timezone_code);
235: END IF;
236: ELSE
237: RETURN NULL;
238: END IF;

Line 319: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;

315: RETURN DATE
316: IS
317: l_online_flag ota_category_usages.online_flag%TYPE;
318: --l_trb_timezone ota_resource_bookings.timezone%TYPE;
319: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;
320: l_trb_timezone_name fnd_timezones_tl.name%TYPE;
321: BEGIN
322: OPEN get_resource_booking_info(p_resource_booking_id);
323: FETCH get_resource_booking_info INTO l_online_flag, l_trb_timezone, l_trb_timezone_name;

Line 320: l_trb_timezone_name fnd_timezones_tl.name%TYPE;

316: IS
317: l_online_flag ota_category_usages.online_flag%TYPE;
318: --l_trb_timezone ota_resource_bookings.timezone%TYPE;
319: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;
320: l_trb_timezone_name fnd_timezones_tl.name%TYPE;
321: BEGIN
322: OPEN get_resource_booking_info(p_resource_booking_id);
323: FETCH get_resource_booking_info INTO l_online_flag, l_trb_timezone, l_trb_timezone_name;
324: CLOSE get_resource_booking_info;