APPS.CSF_TRIPS_PUB dependencies on FND_TIMEZONES

Line 19: g_server_tz_code fnd_timezones_b.timezone_code%TYPE;

15: g_dep_task_name VARCHAR2(30);
16: g_arr_task_name VARCHAR2(30);
17:
18: g_tz_enabled VARCHAR2(1);
19: g_server_tz_code fnd_timezones_b.timezone_code%TYPE;
20: g_client_tz_code fnd_timezones_b.timezone_code%TYPE;
21: g_datetime_fmt_mask fnd_profile_option_values.profile_option_value%TYPE;
22: g_duration_uom mtl_uom_conversions.uom_code%TYPE;
23: g_overtime NUMBER;

Line 20: g_client_tz_code fnd_timezones_b.timezone_code%TYPE;

16: g_arr_task_name VARCHAR2(30);
17:
18: g_tz_enabled VARCHAR2(1);
19: g_server_tz_code fnd_timezones_b.timezone_code%TYPE;
20: g_client_tz_code fnd_timezones_b.timezone_code%TYPE;
21: g_datetime_fmt_mask fnd_profile_option_values.profile_option_value%TYPE;
22: g_duration_uom mtl_uom_conversions.uom_code%TYPE;
23: g_overtime NUMBER;
24:

Line 120: l_date := fnd_timezones_pvt.adjust_datetime(

116: IF p_convert_to_client_tz IS NULL OR p_convert_to_client_tz = fnd_api.g_true THEN
117: -- AOL doesnt initialize FND_DATE package properly. Refer bugs 3183418 and 3115188.
118: -- Because of this, dates werent printed with TZ Conversion. Bypassing FND_DATE.
119: IF g_tz_enabled = 'Y' THEN
120: l_date := fnd_timezones_pvt.adjust_datetime(
121: date_time => p_date
122: , from_tz => g_server_tz_code
123: , to_tz => g_client_tz_code
124: );

Line 331: g_tz_enabled := fnd_timezones.timezones_enabled;

327:
328: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
329: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
330: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
331: g_tz_enabled := fnd_timezones.timezones_enabled;
332: g_server_tz_code := fnd_timezones.get_server_timezone_code;
333: g_client_tz_code := fnd_timezones.get_client_timezone_code;
334:
335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');

Line 332: g_server_tz_code := fnd_timezones.get_server_timezone_code;

328: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
329: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
330: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
331: g_tz_enabled := fnd_timezones.timezones_enabled;
332: g_server_tz_code := fnd_timezones.get_server_timezone_code;
333: g_client_tz_code := fnd_timezones.get_client_timezone_code;
334:
335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
336: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');

Line 333: g_client_tz_code := fnd_timezones.get_client_timezone_code;

329: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
330: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
331: g_tz_enabled := fnd_timezones.timezones_enabled;
332: g_server_tz_code := fnd_timezones.get_server_timezone_code;
333: g_client_tz_code := fnd_timezones.get_client_timezone_code;
334:
335: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
336: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
337: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');

Line 3643: /* l_conv_end_date:= fnd_timezones_pvt.adjust_datetime(

3639: -- End Date will be 00:00 hours of the Start Date. So making it 23:59.
3640: l_end_date := l_end_date + (g_secs_in_day - 1) / g_secs_in_day;
3641:
3642: -- added this for the bug 8410630
3643: /* l_conv_end_date:= fnd_timezones_pvt.adjust_datetime(
3644: date_time => l_end_date
3645: , from_tz => g_client_tz_code
3646: , to_tz => g_server_tz_code
3647: );