DBA Data[Home] [Help]

APPS.OTA_TIMEZONE_UTIL dependencies on FND_DATE

Line 173: fnd_date.canonical_to_date(to_char(p_datevalue,'YYYY/MM/DD')||' '||l_timevalue)

169:
170: IF p_dest_timezone_code <> p_src_timezone_code THEN
171:
172: l_return_date:= convert_date_hz(
173: fnd_date.canonical_to_date(to_char(p_datevalue,'YYYY/MM/DD')||' '||l_timevalue)
174: ,p_src_timezone_code
175: ,p_dest_timezone_code);
176: ELSE
177: l_return_date:= fnd_date.canonical_to_date(to_char(p_datevalue,'YYYY/MM/DD')||' '||l_timevalue);

Line 177: l_return_date:= fnd_date.canonical_to_date(to_char(p_datevalue,'YYYY/MM/DD')||' '||l_timevalue);

173: fnd_date.canonical_to_date(to_char(p_datevalue,'YYYY/MM/DD')||' '||l_timevalue)
174: ,p_src_timezone_code
175: ,p_dest_timezone_code);
176: ELSE
177: l_return_date:= fnd_date.canonical_to_date(to_char(p_datevalue,'YYYY/MM/DD')||' '||l_timevalue);
178: END IF;
179: /*
180: l_return_time := to_char(l_return_date,'HH24:MI');
181: IF l_return_time = '00:00' THEN