DBA Data[Home] [Help]

APPS.FND_PROFILE dependencies on FND_USER

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

3539: SITE_VAL_TAB,hashValue);
3540: end if;
3541:
3542: /* Bug 3203225: PREFERENCES NOT UPDATED ON FLY IN WF_ROLES VIEW
3543: ** needs to call FND_USER_PKG.User_Synch() whenever an update to
3544: ** ICX_LANGUAGE or ICX_TERRITORY is updated at the user level.
3545: */
3546: if ((X_NAME_UPPER = 'ICX_LANGUAGE')
3547: or (X_NAME_UPPER = 'ICX_TERRITORY')) then

Line 3551: from fnd_user

3547: or (X_NAME_UPPER = 'ICX_TERRITORY')) then
3548: if ((X_LEVEL_NAME = 'USER') and (X_LEVEL_VALUE is not null)) then
3549: select user_name
3550: into x_user_name
3551: from fnd_user
3552: where user_id = to_number(X_LEVEL_VALUE);
3553:
3554: FND_USER_PKG.user_synch(x_user_name);
3555: end if;

Line 3554: FND_USER_PKG.user_synch(x_user_name);

3550: into x_user_name
3551: from fnd_user
3552: where user_id = to_number(X_LEVEL_VALUE);
3553:
3554: FND_USER_PKG.user_synch(x_user_name);
3555: end if;
3556: end if;
3557:
3558: -- Log API exit

Line 4011: FROM FND_USER

4007: else
4008: begin
4009: SELECT USER_NAME
4010: INTO NAME
4011: FROM FND_USER
4012: WHERE USER_ID = user_id_z;
4013: exception
4014: when others then
4015: NAME := '';