APPS.WF_MAINTENANCE dependencies on WF_PROCESS_ACTIVITIES

Line 152: from WF_PROCESS_ACTIVITIES

148:
149: cursor cProcessActivities (l_oldname varchar2) is
150: select PROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION,
151: INSTANCE_LABEL, INSTANCE_ID
152: from WF_PROCESS_ACTIVITIES
153: where PERFORM_ROLE = l_oldname;
154:
155: cursor cRoutingRules (l_oldname varchar2) is
156: select RULE_ID

Line 547: update WF_PROCESS_ACTIVITIES

543: exit;
544: end if;
545:
546: forall i in procActTbl.first..procActTbl.last
547: update WF_PROCESS_ACTIVITIES
548: set PERFORM_ROLE = l_newname
549: where PROCESS_ITEM_TYPE = procActTbl(i).process_item_type
550: and PROCESS_NAME = procActTbl(i).process_name
551: and PROCESS_VERSION = procActTbl(i).process_version

Line 2091: -- Determine rows to change in WF_PROCESS_ACTIVITIES

2087: end if;
2088: l_wfcount_tab.TABLE_NAME := 'WF_NOTIFICATIONS';
2089: pipe ROW (l_wfcount_tab);
2090:
2091: -- Determine rows to change in WF_PROCESS_ACTIVITIES
2092: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2093: from WF_PROCESS_ACTIVITIES
2094: where PERFORM_ROLE = p_name;
2095: l_wfcount_tab.TABLE_NAME := 'WF_PROCESS_ACTIVITIES';

Line 2093: from WF_PROCESS_ACTIVITIES

2089: pipe ROW (l_wfcount_tab);
2090:
2091: -- Determine rows to change in WF_PROCESS_ACTIVITIES
2092: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2093: from WF_PROCESS_ACTIVITIES
2094: where PERFORM_ROLE = p_name;
2095: l_wfcount_tab.TABLE_NAME := 'WF_PROCESS_ACTIVITIES';
2096: pipe ROW (l_wfcount_tab);
2097:

Line 2095: l_wfcount_tab.TABLE_NAME := 'WF_PROCESS_ACTIVITIES';

2091: -- Determine rows to change in WF_PROCESS_ACTIVITIES
2092: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2093: from WF_PROCESS_ACTIVITIES
2094: where PERFORM_ROLE = p_name;
2095: l_wfcount_tab.TABLE_NAME := 'WF_PROCESS_ACTIVITIES';
2096: pipe ROW (l_wfcount_tab);
2097:
2098: -- Determine rows to change in WF_ROUTING_RULES. Applies to users only
2099: if (l_pvalue is null or l_pvalue = 'Y') then