DBA Data[Home] [Help]

APPS.WF_SOA_CTX_PKG dependencies on FND_USER

Line 134: FROM fnd_user

130: END IF;
131: pStage:=1;
132: SELECT user_id
133: INTO pUserID
134: FROM fnd_user
135: WHERE user_name = upper(pUserName);
136:
137: --End Username->UserID
138: pStage:=2;

Line 272: FROM FND_USER_RESP_GROUPS

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
274: AND RESPONSIBILITY_ID=pRespID
275: and SECURITY_GROUP_ID=pSecurityGroupID
276: AND rownum <2;

Line 280: FROM FND_USER_RESP_GROUPS

276: AND rownum <2;
277: Else
278: SELECT 1
279: INTO nTemp
280: FROM FND_USER_RESP_GROUPS
281: WHERE user_id=pUserID
282: AND RESPONSIBILITY_ID=pRespID
283: AND rownum <2;
284: End if;

Line 320: pUserId fnd_user.user_id%TYPE;

316: pIsLangCode NUMBER default 0,
317: pOrgId NUMBER)
318: IS
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);