Line 28: pTemp:=fnd_profile.value_specific('ICX_LANGUAGE',user_id=>userId);
24: lang_code OUT NOCOPY varchar2)
25: is
26: pTemp fnd_languages.nls_language%type;
27: begin 28: pTemp:=fnd_profile.value_specific('ICX_LANGUAGE',user_id=>userId); 29: SELECT language_code
30: INTO lang_code
31: FROM fnd_languages
32: WHERE nls_language = pTemp