DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_ROUTING_RULES

Line 63: from WF_ROUTING_RULES

59: where PERFORM_ROLE = l_oldname;
60:
61: cursor RoutingRules (l_oldname varchar2) is
62: select RULE_ID
63: from WF_ROUTING_RULES
64: where ROLE = l_oldname
65: or ACTION_ARGUMENT = l_oldname;
66:
67: cursor wfComments (l_oldname varchar2) is

Line 202: update WF_ROUTING_RULES

198: end loop;
199:
200: for RR in RoutingRules (l_oldname) loop
201:
202: update WF_ROUTING_RULES
203: set ROLE = l_newname
204: where RULE_ID = rr.rule_id
205: and ROLE = l_oldname;
206:

Line 207: update WF_ROUTING_RULES

203: set ROLE = l_newname
204: where RULE_ID = rr.rule_id
205: and ROLE = l_oldname;
206:
207: update WF_ROUTING_RULES
208: set ACTION_ARGUMENT = l_newname
209: where RULE_ID = rr.rule_id
210: and ACTION_ARGUMENT = l_oldname;
211: