DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_ITEMS

Line 33: from WF_ITEMS

29: -- are not currently used, so they are not included.
30:
31: cursor Items (l_oldname varchar2) is
32: select ITEM_TYPE, ITEM_KEY
33: from WF_ITEMS
34: where OWNER_ROLE = l_oldname;
35:
36: cursor ItemActivityStatuses (l_oldname varchar2) is
37: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY

Line 127: update WF_ITEMS

123: to NewName
124: */
125: for I in Items (l_oldname) loop
126:
127: update WF_ITEMS
128: set OWNER_ROLE = l_newname
129: where ITEM_TYPE = i.item_type
130: and item_key = i.item_key;
131: