34: where OWNER_ROLE = l_oldname;
35:
36: cursor ItemActivityStatuses (l_oldname varchar2) is
37: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
38: from WF_ITEM_ACTIVITY_STATUSES
39: where ASSIGNED_USER = l_oldname;
40:
41: cursor ItemActivityStatuses_H (l_oldname varchar2) is
42: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
39: where ASSIGNED_USER = l_oldname;
40:
41: cursor ItemActivityStatuses_H (l_oldname varchar2) is
42: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
43: from WF_ITEM_ACTIVITY_STATUSES_H
44: where ASSIGNED_USER = l_oldname;
45:
46: cursor Notifications (l_oldname varchar2) is
47: select NOTIFICATION_ID
133: end loop;
134:
135: for IAS in ItemActivityStatuses (l_oldname) loop
136:
137: update WF_ITEM_ACTIVITY_STATUSES
138: set ASSIGNED_USER = l_newname
139: where ITEM_TYPE = ias.item_type
140: and ITEM_KEY = ias.item_key
141: and PROCESS_ACTIVITY = ias.process_activity;
144: end loop;
145:
146: for IASH in ItemActivityStatuses_H (l_oldname) loop
147:
148: update WF_ITEM_ACTIVITY_STATUSES_H
149: set ASSIGNED_USER = l_newname
150: where ITEM_TYPE = iash.item_type
151: and ITEM_KEY = iash.item_key
152: and PROCESS_ACTIVITY = iash.process_activity;