DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_PROCESS_ACTIVITIES

Line 58: from WF_PROCESS_ACTIVITIES

54:
55: cursor ProcessActivities (l_oldname varchar2) is
56: select PROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION,
57: INSTANCE_LABEL, INSTANCE_ID
58: from WF_PROCESS_ACTIVITIES
59: where PERFORM_ROLE = l_oldname;
60:
61: cursor RoutingRules (l_oldname varchar2) is
62: select RULE_ID

Line 189: update WF_PROCESS_ACTIVITIES

185: end loop;
186:
187: for PAct in ProcessActivities (l_oldname) loop
188:
189: update WF_PROCESS_ACTIVITIES
190: set PERFORM_ROLE = l_newname
191: where PROCESS_ITEM_TYPE = pact.process_item_type
192: and PROCESS_NAME = pact.process_name
193: and PROCESS_VERSION = pact.process_version