DBA Data[Home] [Help]

APPS.OTA_TIMEZONE_UTIL dependencies on FND_DATE

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

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

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

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