DBA Data[Home] [Help]

APPS.MST_WB_UTIL dependencies on FND_TIMEZONES

Line 1205: l_dateTimeStr := ltrim(rtrim(fnd_date.date_to_displayDT(l_localDate, fnd_timezones.get_server_timezone_code)));

1201: l_localDate DATE ; --:= mst_geocoding.get_local_time(p_location_id, p_date);
1202: l_dateTimeStr VARCHAR2(30);
1203: BEGIN
1204: l_localDate := mst_geocoding.get_local_time(p_location_id, p_date);
1205: l_dateTimeStr := ltrim(rtrim(fnd_date.date_to_displayDT(l_localDate, fnd_timezones.get_server_timezone_code)));
1206: l_dateTimeStr := Substr(l_dateTimeStr,1,length(l_dateTimeStr)-3);
1207: RETURN l_dateTimeStr;
1208: EXCEPTION
1209: WHEN OTHERS THEN

Line 1222: l_dateTimeStr := ltrim(rtrim(fnd_date.date_to_displaydt(l_localDate, fnd_timezones.get_server_timezone_code)));

1218: l_dateTimeStr VARCHAR2(30);
1219: BEGIN
1220: l_localDate := mst_geocoding.get_local_time(p_location_id, p_date);
1221: l_timeZone := mst_geocoding.get_timezone_code(p_location_id, p_date);
1222: l_dateTimeStr := ltrim(rtrim(fnd_date.date_to_displaydt(l_localDate, fnd_timezones.get_server_timezone_code)));
1223: l_dateTimeStr := Substr(l_dateTimeStr,1,length(l_dateTimeStr)-3)||' '||l_timeZone;
1224: RETURN l_dateTimeStr;
1225: EXCEPTION
1226: WHEN OTHERS THEN