DBA Data[Home] [Help]

APPS.FND_PROFILE dependencies on FND_USER

Line 1425: FROM fnd_user

1421: ELSE
1422: BEGIN
1423: SELECT user_name
1424: INTO tempName
1425: FROM fnd_user
1426: WHERE user_id = user_id_z;
1427: EXCEPTION
1428: WHEN OTHERS THEN
1429: tempName := '';

Line 2260: ** needs to call FND_USER_PKG.User_Synch() whenever an update to

2256: END IF;
2257: END IF;
2258:
2259: /* Bug 3203225: PREFERENCES NOT UPDATED ON FLY IN WF_ROLES VIEW
2260: ** needs to call FND_USER_PKG.User_Synch() whenever an update to
2261: ** ICX_LANGUAGE or ICX_TERRITORY is updated at the user level.
2262: */
2263: IF ((profNameUpper = 'ICX_LANGUAGE') OR
2264: (profNameUpper = 'ICX_TERRITORY')) THEN

Line 2268: FROM fnd_user

2264: (profNameUpper = 'ICX_TERRITORY')) THEN
2265: IF ((levelId = USER_LEVEL_ID) AND (levelValueActual IS NOT NULL)) THEN
2266: SELECT user_name
2267: INTO userName
2268: FROM fnd_user
2269: WHERE user_id = levelValueActual;
2270:
2271: fnd_user_pkg.user_synch(userName);
2272: END IF;

Line 2271: fnd_user_pkg.user_synch(userName);

2267: INTO userName
2268: FROM fnd_user
2269: WHERE user_id = levelValueActual;
2270:
2271: fnd_user_pkg.user_synch(userName);
2272: END IF;
2273: END IF;
2274:
2275: -- Log exit