DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_COMMENTS

Line 69: from wf_comments

65: or ACTION_ARGUMENT = l_oldname;
66:
67: cursor wfComments (l_oldname varchar2) is
68: select rowid
69: from wf_comments
70: where from_role = l_oldname
71: or to_role = l_oldname
72: or proxy_role = l_oldname;
73:

Line 216: update WF_COMMENTS

212: PerformCommit();
213: end loop;
214:
215: for wcom in wfComments (l_oldname) loop
216: update WF_COMMENTS
217: set FROM_ROLE = l_newname,
218: FROM_USER = l_roleInfoTAB(1).display_name
219: where rowid = wcom.rowid
220: and FROM_ROLE = l_oldName;

Line 222: update WF_COMMENTS

218: FROM_USER = l_roleInfoTAB(1).display_name
219: where rowid = wcom.rowid
220: and FROM_ROLE = l_oldName;
221:
222: update WF_COMMENTS
223: set TO_ROLE = l_newname,
224: TO_USER = l_roleInfoTAB(1).display_name
225: where rowid = wcom.rowid
226: and TO_ROLE = l_oldName;

Line 228: update WF_COMMENTS

224: TO_USER = l_roleInfoTAB(1).display_name
225: where rowid = wcom.rowid
226: and TO_ROLE = l_oldName;
227:
228: update WF_COMMENTS
229: set PROXY_ROLE = l_newname
230: where rowid = wcom.rowid
231: and PROXY_ROLE = l_oldName;
232: