DBA Data[Home] [Help]

APPS.IEM_UTILITY_PVT dependencies on FND_PROFILE

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

164: if p_resource_id>0 then
165: begin
166: select user_id into l_user_id from JTF_RS_RESOURCE_EXTNS
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);

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

165: begin
166: select user_id into l_user_id from JTF_RS_RESOURCE_EXTNS
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);

Line 179: l_client_tz_id :=to_number(fnd_profile.value_specific('CLIENT_TIMEZONE_ID'));

175: exception when others then
176: x_date:=to_char(p_date,'DD-MON-YYYY HH24:MI:SS');
177: end;
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);

Line 180: l_time_format :=fnd_profile.value_specific('ICX_DATE_FORMAT_MASK');

176: x_date:=to_char(p_date,'DD-MON-YYYY HH24:MI:SS');
177: end;
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);