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.MST_WB_UTIL dependencies on MST_GEOCODING

Line 1201: l_localDate DATE ; --:= mst_geocoding.get_local_time(p_location_id, p_date);

1197: END get_hr_min;
1198:
1199: FUNCTION get_local_chardt(p_location_id IN NUMBER, p_date IN DATE)
1200: RETURN VARCHAR2 IS
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)));

Line 1204: l_localDate := mst_geocoding.get_local_time(p_location_id, p_date);

1200: RETURN VARCHAR2 IS
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

Line 1216: l_localDate DATE ; --:= mst_geocoding.get_local_time(p_location_id, p_date);

1212: END get_local_chardt;
1213:
1214: FUNCTION get_local_chardtzone(p_location_id IN NUMBER, p_date IN DATE)
1215: RETURN VARCHAR2 IS
1216: l_localDate DATE ; --:= mst_geocoding.get_local_time(p_location_id, p_date);
1217: l_timeZone VARCHAR2(10) ; --:= mst_geocoding.get_timezone_code(p_location_id, p_date);
1218: l_dateTimeStr VARCHAR2(30);
1219: BEGIN
1220: l_localDate := mst_geocoding.get_local_time(p_location_id, p_date);

Line 1217: l_timeZone VARCHAR2(10) ; --:= mst_geocoding.get_timezone_code(p_location_id, p_date);

1213:
1214: FUNCTION get_local_chardtzone(p_location_id IN NUMBER, p_date IN DATE)
1215: RETURN VARCHAR2 IS
1216: l_localDate DATE ; --:= mst_geocoding.get_local_time(p_location_id, p_date);
1217: l_timeZone VARCHAR2(10) ; --:= mst_geocoding.get_timezone_code(p_location_id, p_date);
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);

Line 1220: l_localDate := mst_geocoding.get_local_time(p_location_id, p_date);

1216: l_localDate DATE ; --:= mst_geocoding.get_local_time(p_location_id, p_date);
1217: l_timeZone VARCHAR2(10) ; --:= mst_geocoding.get_timezone_code(p_location_id, p_date);
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;

Line 1221: l_timeZone := mst_geocoding.get_timezone_code(p_location_id, p_date);

1217: l_timeZone VARCHAR2(10) ; --:= mst_geocoding.get_timezone_code(p_location_id, p_date);
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

Line 5654: l_server_datetime:= MST_GEOCODING.Get_server_time(l_location_id, p_datetime);

5650: close cur_location;
5651: ELSE
5652: l_location_id:= p_location_id;
5653: END IF;
5654: l_server_datetime:= MST_GEOCODING.Get_server_time(l_location_id, p_datetime);
5655: RETURN l_server_datetime;
5656: EXCEPTION
5657: WHEN OTHERS THEN
5658: RETURN p_datetime;