Line 304: l_language := FND_PROFILE.Value_Specific('ICX_LANGUAGE', rec.user_id);
300: FROM fnd_user
301: WHERE employee_id = l_agent_id)
302: LOOP
303: -- get user's preferred lanaguage 304: l_language := FND_PROFILE.Value_Specific('ICX_LANGUAGE', rec.user_id); 305:
306: IF l_language IS NOT NULL THEN
307:
308: SELECT language_code