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;
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:
87: IF p_convert_to_client_tz IS NULL OR p_convert_to_client_tz = fnd_api.g_true THEN
88: -- AOL doesnt initialize FND_DATE package properly. Refer bugs 3183418 and 3115188.
89: -- Because of this, dates werent printed with TZ Conversion. Bypassing FND_DATE.
90: IF g_tz_enabled = 'Y' THEN
91: l_date := fnd_timezones_pvt.adjust_datetime(
92: date_time => p_date
93: , from_tz => g_server_tz_code
94: , to_tz => g_client_tz_code
95: );
285: g_overtime := NVL(fnd_profile.value('MAXOVERTIME'), 0) / g_mins_in_day;
286: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
287: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
288: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
289: g_tz_enabled := fnd_timezones.timezones_enabled;
290: g_server_tz_code := fnd_timezones.get_server_timezone_code;
291: g_client_tz_code := fnd_timezones.get_client_timezone_code;
292:
293: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
286: g_debug := NVL(fnd_profile.value('AFLOG_ENABLED'), 'N');
287: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
288: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
289: g_tz_enabled := fnd_timezones.timezones_enabled;
290: g_server_tz_code := fnd_timezones.get_server_timezone_code;
291: g_client_tz_code := fnd_timezones.get_client_timezone_code;
292:
293: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
294: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
287: g_debug_level := NVL(fnd_profile.value_specific('AFLOG_LEVEL'), fnd_log.level_event);
288: g_datetime_fmt_mask := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'), 'DD-MON-YYYY') || ' HH24:MI';
289: g_tz_enabled := fnd_timezones.timezones_enabled;
290: g_server_tz_code := fnd_timezones.get_server_timezone_code;
291: g_client_tz_code := fnd_timezones.get_client_timezone_code;
292:
293: g_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_PLANNED_STATUS');
294: g_assigned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_ASSIGNED_STATUS');
295: g_blocked_planned_status_id := fnd_profile.value('CSF_DEFAULT_TASK_BLOCKED_PLAN_STATUS');