APPS.CSF_GANTT_DATA_PKG dependencies on FND_TIMEZONES

Line 271: , fnd_timezones_b tz

267: , jtf_task_statuses_tl sl
268: , hz_party_sites ps
269: , hz_locations hl
270: , hz_parties pi
271: , fnd_timezones_b tz
272: WHERE a.task_id = p_task_id
273: AND resource_id = p_resource_id
274: AND resource_type_code = p_resource_type
275: AND tb.task_id = a.task_id

Line 326: FROM fnd_timezones_vl ft

322: ;
323: Cursor c_res_tz
324: IS
325: SELECT ACTIVE_TIMEZONE_CODE,ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
326: FROM fnd_timezones_vl ft
327: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
328:
329:
330:

Line 856: , fnd_timezones_b tz

852: , jtf_task_statuses_tl sl
853: , hz_party_sites ps
854: , hz_locations hl
855: , hz_parties pi
856: , fnd_timezones_b tz
857: WHERE a.task_id = p_task_id
858: AND resource_id = p_resource_id
859: AND resource_type_code = p_resource_type
860: AND tb.task_id = a.task_id

Line 911: FROM fnd_timezones_vl ft

907: ;
908: Cursor c_res_tz
909: IS
910: SELECT ACTIVE_TIMEZONE_CODE,ACTIVE_TIMEZONE_CODE|| ' (GMT ' ||to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))*60,'FM900') || ') ' tz_desc
911: FROM fnd_timezones_vl ft
912: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
913:
914:
915:

Line 5410: g_server_tz := fnd_timezones.get_server_timezone_code;

5406: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
5407: l_language := USERENV('LANG');
5408: g_resource_id :=csf_resource_pub.resource_id;
5409: g_resource_type :=csf_resource_pub.resource_type;
5410: g_server_tz := fnd_timezones.get_server_timezone_code;
5411: g_client_tz := fnd_timezones.get_client_timezone_code;
5412: g_tz_enabled := 'N';
5413:
5414: -- this function is currently not present in fnd_timezones 1158

Line 5411: g_client_tz := fnd_timezones.get_client_timezone_code;

5407: l_language := USERENV('LANG');
5408: g_resource_id :=csf_resource_pub.resource_id;
5409: g_resource_type :=csf_resource_pub.resource_type;
5410: g_server_tz := fnd_timezones.get_server_timezone_code;
5411: g_client_tz := fnd_timezones.get_client_timezone_code;
5412: g_tz_enabled := 'N';
5413:
5414: -- this function is currently not present in fnd_timezones 1158
5415: -- copied from AFTZONEB.pls 115.3 and modified

Line 5414: -- this function is currently not present in fnd_timezones 1158

5410: g_server_tz := fnd_timezones.get_server_timezone_code;
5411: g_client_tz := fnd_timezones.get_client_timezone_code;
5412: g_tz_enabled := 'N';
5413:
5414: -- this function is currently not present in fnd_timezones 1158
5415: -- copied from AFTZONEB.pls 115.3 and modified
5416: if nvl(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'),'N') = 'Y'
5417: then
5418: g_tz_enabled := 'Y';