DBA Data[Home] [Help]

APPS.IEM_UTILITY_PVT dependencies on HZ_TIMEZONE_PUB

Line 171: HZ_TIMEZONE_PUB.Get_Time(1.0,'F', 0, l_client_tz_id, p_date,

167: where resource_id=p_resource_id;
168: l_client_tz_id :=to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID',l_user_id));
169: l_time_format :=fnd_profile.value_specific('ICX_DATE_FORMAT_MASK',l_user_id);
170: l_format:=l_time_format||' '||'HH24:MI:SS';
171: HZ_TIMEZONE_PUB.Get_Time(1.0,'F', 0, l_client_tz_id, p_date,
172: l_date, l_status, l_msg_count, l_msg_data);
173: x_date:=to_char(l_date,l_format);
174: return(x_date);
175: exception when others then

Line 182: HZ_TIMEZONE_PUB.Get_Time(1.0,'F', 0, l_client_tz_id, p_date,

178: else
179: l_client_tz_id :=to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));
180: l_time_format :=fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');
181: l_format:=l_time_format||' '||'HH24:MI:SS';
182: HZ_TIMEZONE_PUB.Get_Time(1.0,'F', 0, l_client_tz_id, p_date,
183: l_date, l_status, l_msg_count, l_msg_data);
184: x_date:=to_char(l_date,l_format);
185: end if;
186: return(x_date);