DBA Data[Home] [Help]

APPS.WFA_SEC dependencies on WF_LOCAL_USER_ROLES

Line 970: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

966: and ORIG_SYSTEM in ('WF_LOCAL_USERS', 'WF_LOCAL_ROLES')
967: and ORIG_SYSTEM_ID = 0;
968:
969: -- Update local user roles
970: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
971: set USER_NAME = NewName
972: where USER_NAME = OldName
973: and USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
974: and USER_ORIG_SYSTEM_ID = 0;

Line 976: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

972: where USER_NAME = OldName
973: and USER_ORIG_SYSTEM = 'WF_LOCAL_USERS'
974: and USER_ORIG_SYSTEM_ID = 0;
975:
976: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
977: set ROLE_NAME = NewName
978: where ROLE_NAME = OldName
979: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
980: and ROLE_ORIG_SYSTEM_ID = 0;

Line 982: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)

978: where ROLE_NAME = OldName
979: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_USERS'
980: and ROLE_ORIG_SYSTEM_ID = 0;
981:
982: update WF_LOCAL_USER_ROLES PARTITION (WF_LOCAL_ROLES)
983: set ROLE_NAME = NewName
984: where ROLE_NAME = OldName
985: and ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
986: and ROLE_ORIG_SYSTEM_ID = 0;