DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on FND_GRANTS

Line 3227: -- A temp fix to update fnd_grants.grantee_key

3223: app_exception.raise_exception;
3224: end;
3225:
3226: -- Added for bug 4676568
3227: -- A temp fix to update fnd_grants.grantee_key
3228: -- No need to check SQL%NOTFOUND because if there is no data to be
3229: -- updated in fnd_grants.grantee_key, that is perfectly fine.
3230: update fnd_grants
3231: set grantee_key = x_new_user_name

Line 3229: -- updated in fnd_grants.grantee_key, that is perfectly fine.

3225:
3226: -- Added for bug 4676568
3227: -- A temp fix to update fnd_grants.grantee_key
3228: -- No need to check SQL%NOTFOUND because if there is no data to be
3229: -- updated in fnd_grants.grantee_key, that is perfectly fine.
3230: update fnd_grants
3231: set grantee_key = x_new_user_name
3232: where grantee_key = x_old_user_name
3233: and grantee_type = 'USER';

Line 3230: update fnd_grants

3226: -- Added for bug 4676568
3227: -- A temp fix to update fnd_grants.grantee_key
3228: -- No need to check SQL%NOTFOUND because if there is no data to be
3229: -- updated in fnd_grants.grantee_key, that is perfectly fine.
3230: update fnd_grants
3231: set grantee_key = x_new_user_name
3232: where grantee_key = x_old_user_name
3233: and grantee_type = 'USER';
3234: