DBA Data[Home] [Help]

APPS.BIS_UTILITIES_PUB dependencies on FND_USER

Line 33: from fnd_user

29:
30: IF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_id) = FND_API.G_TRUE THEN
31: select user_id , user_name
32: into x_user_id, x_user_name
33: from fnd_user
34: where user_id = p_user_id;
35: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_name) = FND_API.G_TRUE THEN
36: select user_id , user_name
37: into x_user_id, x_user_name

Line 38: from fnd_user

34: where user_id = p_user_id;
35: ELSIF BIS_UTILITIES_PUB.Value_Not_Missing(p_user_name) = FND_API.G_TRUE THEN
36: select user_id , user_name
37: into x_user_id, x_user_name
38: from fnd_user
39: where user_name = p_user_name;
40: ELSE
41: null;
42: END IF;

Line 200: FROM fnd_user

196: IF BIS_UTILITIES_PUB.Value_Missing(p_user_id) = FND_API.G_TRUE
197: THEN
198: SELECT user_id
199: INTO l_user_id
200: FROM fnd_user
201: WHERE user_name = p_user_name;
202: ELSE
203: l_user_id := p_user_id;
204: END IF;

Line 1766: l_User_Id FND_USER.USER_ID%TYPE;

1762:
1763: l_Function_Name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
1764: l_Function_Id FND_FORM_FUNCTIONS.FUNCTION_ID%TYPE;
1765: l_Menu_Id FND_MENUS.MENU_ID%TYPE;
1766: l_User_Id FND_USER.USER_ID%TYPE;
1767:
1768: l_Has_User_Access BOOLEAN;
1769: l_Return_Status VARCHAR2(1);
1770:

Line 1775: FND_USER_RESP_GROUPS U

1771:
1772: CURSOR c_Resp_Menus IS
1773: SELECT R.MENU_ID
1774: FROM FND_RESPONSIBILITY_VL R,
1775: FND_USER_RESP_GROUPS U
1776: WHERE U.USER_ID = FND_GLOBAL.USER_ID
1777: AND R.VERSION = 'W'
1778: AND U.RESPONSIBILITY_ID = R.RESPONSIBILITY_ID
1779: AND U.START_DATE <= SYSDATE