eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSF_GANTT_DATA_PKG dependencies on FND_TIMEZONES

Line 326: , fnd_timezones_b tz

322: , jtf_task_statuses_tl sl
323: , hz_party_sites ps
324: , hz_locations hl
325: , hz_parties pi
326: , fnd_timezones_b tz
327: WHERE a.task_id = p_task_id
328: AND resource_id = p_resource_id
329: AND resource_type_code = p_resource_type
330: AND tb.task_id = a.task_id

Line 382: FROM fnd_timezones_vl ft

378: ;
379: Cursor c_res_tz
380: IS
381: 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
382: FROM fnd_timezones_vl ft
383: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
384:
385: Cursor c_trip
386: IS

Line 1466: , fnd_timezones_b tz

1462: , jtf_task_statuses_tl sl
1463: , hz_party_sites ps
1464: , hz_locations hl
1465: , hz_parties pi
1466: , fnd_timezones_b tz
1467: WHERE a.task_id = p_task_id
1468: AND resource_id = p_resource_id
1469: AND resource_type_code = p_resource_type
1470: AND tb.task_id = a.task_id

Line 1521: FROM fnd_timezones_vl ft

1517: ;
1518: Cursor c_res_tz
1519: IS
1520: 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
1521: FROM fnd_timezones_vl ft
1522: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
1523:
1524: Cursor c_trip
1525: IS

Line 2436: , fnd_timezones_b tz

2432: , jtf_task_statuses_tl sl
2433: , hz_party_sites ps
2434: , hz_locations hl
2435: , hz_parties pi
2436: , fnd_timezones_b tz
2437: WHERE a.task_id = p_task_id
2438: AND resource_id = p_resource_id
2439: AND resource_type_code = p_resource_type
2440: AND tb.task_id = a.task_id

Line 2491: FROM fnd_timezones_vl ft

2487: ;
2488: Cursor c_res_tz
2489: IS
2490: 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
2491: FROM fnd_timezones_vl ft
2492: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
2493:
2494: Cursor c_terr
2495: IS

Line 3163: , fnd_timezones_b tz

3159: , jtf_task_statuses_tl sl
3160: , hz_party_sites ps
3161: , hz_locations hl
3162: , hz_parties pi
3163: , fnd_timezones_b tz
3164: WHERE a.task_id = p_task_id
3165: AND resource_id = p_resource_id
3166: AND resource_type_code = p_resource_type
3167: AND tb.task_id = a.task_id

Line 3218: FROM fnd_timezones_vl ft

3214: ;
3215: Cursor c_res_tz
3216: IS
3217: 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
3218: FROM fnd_timezones_vl ft
3219: WHERE UPGRADE_TZ_ID =l_Res_TimeZone_id;
3220:
3221: Cursor c_terr
3222: IS

Line 7466: g_server_tz := fnd_timezones.get_server_timezone_code;

7462: BEGIN
7463:
7464:
7465: --- Fix for bug 7282611 forward ported.
7466: g_server_tz := fnd_timezones.get_server_timezone_code;
7467: g_client_tz := fnd_timezones.get_client_timezone_code;
7468: --- end of fix for bug 7282611
7469: p_res_id := jtf_number_table();
7470: p_res_type := jtf_varchar2_table_2000();

Line 7467: g_client_tz := fnd_timezones.get_client_timezone_code;

7463:
7464:
7465: --- Fix for bug 7282611 forward ported.
7466: g_server_tz := fnd_timezones.get_server_timezone_code;
7467: g_client_tz := fnd_timezones.get_client_timezone_code;
7468: --- end of fix for bug 7282611
7469: p_res_id := jtf_number_table();
7470: p_res_type := jtf_varchar2_table_2000();
7471: p_res_name := jtf_varchar2_table_2000();

Line 8707: g_server_tz := fnd_timezones.get_server_timezone_code;

8703: g_date_format := fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
8704: l_language := USERENV('LANG');
8705: g_resource_id :=csf_resource_pub.resource_id;
8706: g_resource_type :=csf_resource_pub.resource_type;
8707: g_server_tz := fnd_timezones.get_server_timezone_code;
8708: g_client_tz := fnd_timezones.get_client_timezone_code;
8709: g_tz_enabled := 'N';
8710:
8711: -- this function is currently not present in fnd_timezones 1158

Line 8708: g_client_tz := fnd_timezones.get_client_timezone_code;

8704: l_language := USERENV('LANG');
8705: g_resource_id :=csf_resource_pub.resource_id;
8706: g_resource_type :=csf_resource_pub.resource_type;
8707: g_server_tz := fnd_timezones.get_server_timezone_code;
8708: g_client_tz := fnd_timezones.get_client_timezone_code;
8709: g_tz_enabled := 'N';
8710:
8711: -- this function is currently not present in fnd_timezones 1158
8712: -- copied from AFTZONEB.pls 115.3 and modified

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

8707: g_server_tz := fnd_timezones.get_server_timezone_code;
8708: g_client_tz := fnd_timezones.get_client_timezone_code;
8709: g_tz_enabled := 'N';
8710:
8711: -- this function is currently not present in fnd_timezones 1158
8712: -- copied from AFTZONEB.pls 115.3 and modified
8713: if nvl(fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS'),'N') = 'Y'
8714: then
8715: g_tz_enabled := 'Y';