APPS.WF_SOA_CTX_PKG dependencies on FND_PROFILE

Line 29: pTemp:=fnd_profile.value_specific('ICX_LANGUAGE',user_id=>userId);

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

Line 269: If fnd_profile.value_specific('ENABLE_SECURITY_GROUPS',RESPONSIBILITY_ID=> pRespID, APPLICATION_ID=>pRespAppID )='Y' Then

265: -- need to check for user-resp combination here
266: -- as SOA Java code calls only getcontext_id
267: pStage:=6;
268: IF pRespID <> -1 THEN
269: If fnd_profile.value_specific('ENABLE_SECURITY_GROUPS',RESPONSIBILITY_ID=> pRespID, APPLICATION_ID=>pRespAppID )='Y' Then
270: SELECT 1
271: INTO nTemp
272: FROM FND_USER_RESP_GROUPS
273: WHERE user_id=pUserID