APPS.IEM_UTILITY_PVT dependencies on FND_PROFILE

Line 165: l_client_tz_id :=to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID',l_user_id));

161: l_format varchar2(100);
162: begin
163: select user_id into l_user_id from JTF_RS_RESOURCE_EXTNS
164: where resource_id=p_resource_id;
165: l_client_tz_id :=to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID',l_user_id));
166: l_time_format :=fnd_profile.value_specific('ICX_DATE_FORMAT_MASK',l_user_id);
167: l_format:=l_time_format||' '||'HH24:MI:SS';
168: HZ_TIMEZONE_PUB.Get_Time(1.0,'F', 0, l_client_tz_id, p_date,
169: l_date, l_status, l_msg_count, l_msg_data);

Line 166: l_time_format :=fnd_profile.value_specific('ICX_DATE_FORMAT_MASK',l_user_id);

162: begin
163: select user_id into l_user_id from JTF_RS_RESOURCE_EXTNS
164: where resource_id=p_resource_id;
165: l_client_tz_id :=to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID',l_user_id));
166: l_time_format :=fnd_profile.value_specific('ICX_DATE_FORMAT_MASK',l_user_id);
167: l_format:=l_time_format||' '||'HH24:MI:SS';
168: HZ_TIMEZONE_PUB.Get_Time(1.0,'F', 0, l_client_tz_id, p_date,
169: l_date, l_status, l_msg_count, l_msg_data);
170: x_date:=to_char(l_date,l_format);