DBA Data[Home] [Help]

APPS.WF_SOA_CTX_PKG dependencies on FND_SECURITY_GROUPS

Line 261: FROM FND_SECURITY_GROUPS

257:
258: pStage:=5;
259: SELECT SECURITY_GROUP_ID
260: INTO pSecurityGroupID
261: FROM FND_SECURITY_GROUPS
262: WHERE upper(SECURITY_GROUP_KEY) = upper(nvl(pSecurityGroup,'STANDARD'));
263:
264: -- changes for bug 8492785
265: -- need to check for user-resp combination here

Line 323: pSecGrpId fnd_security_groups.security_group_id%TYPE;

319: pLangCode fnd_languages.language_code%TYPE;
320: pUserId fnd_user.user_id%TYPE;
321: pAppId fnd_application.application_id%TYPE;
322: pRespId fnd_responsibility.responsibility_id%TYPE;
323: pSecGrpId fnd_security_groups.security_group_id%TYPE;
324: x_status_code VARCHAR2(1);
325: x_error_code varchar2(50);
326: BEGIN
327: GETCONTEXT_ID(pUserName, pResp,pRespApp,pSecurityGroup, pnlslanguage,pIsLangCode, pUserId,pRespId,pAppId,pSecGrpId,pLangCode,x_status_code,x_error_code);