DBA Data[Home] [Help]

APPS.WFA_SEC dependencies on WF_LOCAL_USER_ROLES

Line 978: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

974: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
975: and ORIG_SYSTEM_ID = 0;
976:
977: -- Update local user roles
978: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
979: set USER_NAME = NewName
980: where USER_NAME = OldName
981: and USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
982: and USER_ORIG_SYSTEM_ID = 0;

Line 984: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

980: where USER_NAME = OldName
981: and USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
982: and USER_ORIG_SYSTEM_ID = 0;
983:
984: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
985: set ROLE_NAME = NewName
986: where ROLE_NAME = OldName
987: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
988: and ROLE_ORIG_SYSTEM_ID = 0;

Line 990: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

986: where ROLE_NAME = OldName
987: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
988: and ROLE_ORIG_SYSTEM_ID = 0;
989:
990: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
991: set ROLE_NAME = NewName
992: where ROLE_NAME = OldName
993: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
994: and ROLE_ORIG_SYSTEM_ID = 0;