APPS.WF_MAINTENANCE dependencies on WF_ROUTING_RULES

Line 157: from WF_ROUTING_RULES

153: where PERFORM_ROLE = l_oldname;
154:
155: cursor cRoutingRules (l_oldname varchar2) is
156: select RULE_ID
157: from WF_ROUTING_RULES
158: where ROLE = l_oldname
159: or ACTION_ARGUMENT = l_oldname;
160:
161: cursor cRoutingRuleAttributes (l_oldname varchar2) is

Line 569: update WF_ROUTING_RULES

565: exit;
566: end if;
567:
568: forall i in numTbl.first..numTbl.last
569: update WF_ROUTING_RULES
570: set ROLE = l_newname
571: where RULE_ID = numTbl(i)
572: and ROLE = l_oldname;
573: commit;

Line 576: update WF_ROUTING_RULES

572: and ROLE = l_oldname;
573: commit;
574:
575: forall i in numTbl.first..numTbl.last
576: update WF_ROUTING_RULES
577: set ACTION_ARGUMENT = l_newname
578: where RULE_ID = numTbl(i)
579: and ACTION_ARGUMENT = l_oldname;
580: commit;

Line 628: 'Updated Records: WF_PROC_ACTS:'||l_pas||', WF_ROUTING_RULES:'||l_rr

624: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
625: 'Updated Records: WF_ITEMS:'||l_items||', WF_IAS:'||l_ias||', WF_IASH:'
626: ||l_iash||', WF_NTFS:'||l_ntfs||', WF_COMMENTS:'||l_coms);
627: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
628: 'Updated Records: WF_PROC_ACTS:'||l_pas||', WF_ROUTING_RULES:'||l_rr
629: ||', WF_ROUTING_RULE_ATTRS:' ||l_rra||', WF_ITEM_ATTR_VALUES:'||l_ra
630: ||', WORKLIST_ACCESS:'||l_wa);
631: end if;
632:

Line 2098: -- Determine rows to change in WF_ROUTING_RULES. Applies to users only

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
2100: if l_roleInfoTAB(1).ORIG_SYSTEM in ('PER','FND_USR') then
2101: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2102: from WF_ROUTING_RULES

Line 2102: from WF_ROUTING_RULES

2098: -- Determine rows to change in WF_ROUTING_RULES. Applies to users only
2099: if (l_pvalue is null or l_pvalue = 'Y') then
2100: if l_roleInfoTAB(1).ORIG_SYSTEM in ('PER','FND_USR') then
2101: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2102: from WF_ROUTING_RULES
2103: where ROLE = p_name or ACTION_ARGUMENT = p_name;
2104: else
2105: l_wfcount_tab.REC_CNT := 0;
2106: end if;

Line 2110: from WF_ROUTING_RULES

2106: end if;
2107: else
2108: if l_roleInfoTAB(1).ORIG_SYSTEM in ('PER','FND_USR') then
2109: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2110: from WF_ROUTING_RULES
2111: where (ROLE = p_name or ACTION_ARGUMENT = p_name)
2112: and BEGIN_DATE<=SYSDATE
2113: and (END_DATE is null or END_DATE>=SYSDATE);
2114: else

Line 2118: l_wfcount_tab.TABLE_NAME := 'WF_ROUTING_RULES';

2114: else
2115: l_wfcount_tab.REC_CNT := 0;
2116: end if;
2117: end if;
2118: l_wfcount_tab.TABLE_NAME := 'WF_ROUTING_RULES';
2119: pipe ROW (l_wfcount_tab);
2120:
2121: -- Determine rows to change in WF_ROUTING_RULE_ATTRIBUTES. Applies to users only
2122: if (l_pvalue is null or l_pvalue = 'Y') then

Line 2125: from WF_ROUTING_RULE_ATTRIBUTES ra, WF_ROUTING_RULES wrr

2121: -- Determine rows to change in WF_ROUTING_RULE_ATTRIBUTES. Applies to users only
2122: if (l_pvalue is null or l_pvalue = 'Y') then
2123: if l_roleInfoTAB(1).ORIG_SYSTEM in ('PER','FND_USR') then
2124: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2125: from WF_ROUTING_RULE_ATTRIBUTES ra, WF_ROUTING_RULES wrr
2126: where wrr.RULE_ID=ra.RULE_ID
2127: and ra.TEXT_VALUE = p_name
2128: and exists
2129: (select '1'

Line 2139: from WF_ROUTING_RULE_ATTRIBUTES ra, WF_ROUTING_RULES wrr

2135: end if;
2136: else
2137: if l_roleInfoTAB(1).ORIG_SYSTEM in ('PER','FND_USR') then
2138: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2139: from WF_ROUTING_RULE_ATTRIBUTES ra, WF_ROUTING_RULES wrr
2140: where wrr.BEGIN_DATE<=SYSDATE
2141: and (wrr.END_DATE is null or wrr.END_DATE>=SYSDATE)
2142: and wrr.RULE_ID=ra.RULE_ID
2143: and ra.TEXT_VALUE = p_name