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 33: RETURN fnd_timezones_pvt.adjust_datetime(p_date, p_src_timezone_code, p_dest_timezone_code);

29: BEGIN
30: --l_src_timezone_id := Get_Timezone_ID(p_src_timezone_code);
31: --l_dest_timezone_id := Get_Timezone_ID(p_dest_timezone_code);
32: --RETURN HZ_TIMEZONE_PUB.Convert_DateTime(l_src_timezone_id, l_dest_timezone_id, p_date);
33: RETURN fnd_timezones_pvt.adjust_datetime(p_date, p_src_timezone_code, p_dest_timezone_code);
34: END convert_date_hz;
35:
36: FUNCTION Get_Timezone_ID
37: (p_timezone_code in varchar2)

Line 42: FROM fnd_timezones_b

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

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

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

Line 61: FROM fnd_timezones_vl

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

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

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

Line 81: FROM FND_TIMEZONES_B

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

Line 114: FROM fnd_timezones_tl ftt

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

Line 134: FROM fnd_timezones_tl

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

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

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

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

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

Line 320: l_trb_timezone fnd_timezones_tl.timezone_code%TYPE;

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
323: OPEN get_resource_booking_info(p_resource_booking_id);
324: FETCH get_resource_booking_info INTO l_online_flag, l_trb_timezone, l_trb_timezone_name;

Line 321: l_trb_timezone_name fnd_timezones_tl.name%TYPE;

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
323: OPEN get_resource_booking_info(p_resource_booking_id);
324: FETCH get_resource_booking_info INTO l_online_flag, l_trb_timezone, l_trb_timezone_name;
325: CLOSE get_resource_booking_info;