eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_MAINTENANCE dependencies on WF_ROUTING_RULE_ATTRIBUTES

Line 163: from WF_ROUTING_RULE_ATTRIBUTES ra

159: or ACTION_ARGUMENT = l_oldname;
160:
161: cursor cRoutingRuleAttributes (l_oldname varchar2) is
162: select ra.ROWID
163: from WF_ROUTING_RULE_ATTRIBUTES ra
164: where ra.TEXT_VALUE = l_oldname
165: and exists
166: (select null
167: from wf_message_attributes ma

Line 595: update wf_routing_rule_attributes

591: exit;
592: end if;
593:
594: forall i in rowIdTbl.first..rowIdTbl.last
595: update wf_routing_rule_attributes
596: set text_value = l_newname
597: where rowid = rowIdTbl(i);
598: commit;
599:

Line 2121: -- Determine rows to change in WF_ROUTING_RULE_ATTRIBUTES. Applies to users only

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
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

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

Line 2154: l_wfcount_tab.TABLE_NAME := 'WF_ROUTING_RULE_ATTRIBUTES';

2150: l_wfcount_tab.REC_CNT := 0;
2151: end if;
2152:
2153: end if;
2154: l_wfcount_tab.TABLE_NAME := 'WF_ROUTING_RULE_ATTRIBUTES';
2155: pipe ROW (l_wfcount_tab);
2156:
2157: -- Determine rows to change in WF_COMMENTS Applies to users only
2158: if (l_pvalue is null or l_pvalue = 'Y') then