APPS.WF_MAINTENANCE dependencies on WF_COMMENTS

Line 173: from wf_comments

169: and ma.type='ROLE');
170:
171: cursor cWfComments (l_oldname varchar2) is
172: select rowid
173: from wf_comments
174: where from_role = l_oldname
175: or to_role = l_oldname
176: or proxy_role = l_oldname;
177:

Line 181: from WF_COMMENTS WC

177:
178: -- Only notifications belonging to active items
179: cursor cWfComments2 (l_oldname varchar2) is
180: select WC.ROWID
181: from WF_COMMENTS WC
182: where (WC.FROM_ROLE = l_oldname
183: or WC.TO_ROLE = l_oldname
184: or WC.PROXY_ROLE = l_oldname)
185: and (exists (select '1'

Line 377: update WF_COMMENTS

373: exit;
374: end if;
375:
376: forall i in rowIdTbl.first..rowIdTbl.last
377: update WF_COMMENTS
378: set FROM_ROLE = decode(FROM_ROLE, l_oldname, l_newname, FROM_ROLE),
379: FROM_USER = decode(FROM_ROLE, l_oldname, l_roleInfoTAB(1).display_name, FROM_USER),
380: TO_ROLE = decode(TO_ROLE, l_oldname, l_newname, TO_ROLE),
381: TO_USER = decode(TO_ROLE, l_oldname, l_roleInfoTAB(1).display_name, TO_USER),

Line 505: update WF_COMMENTS

501: exit;
502: end if;
503:
504: forall i in rowIdTbl.first..rowIdTbl.last
505: update WF_COMMENTS
506: set FROM_ROLE = decode(FROM_ROLE, l_oldname, l_newname, FROM_ROLE),
507: FROM_USER = decode(FROM_ROLE, l_oldname, l_roleInfoTAB(1).display_name, FROM_USER),
508: TO_ROLE = decode(TO_ROLE, l_oldname, l_newname, TO_ROLE),
509: TO_USER = decode(TO_ROLE, l_oldname, l_roleInfoTAB(1).display_name, TO_USER),

Line 626: ||l_iash||', WF_NTFS:'||l_ntfs||', WF_COMMENTS:'||l_coms);

622:
623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
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);

Line 2157: -- Determine rows to change in WF_COMMENTS Applies to users only

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
2159: if l_roleInfoTAB(1).ORIG_SYSTEM in ('PER','FND_USR') then
2160: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2161: from WF_COMMENTS WC

Line 2161: from WF_COMMENTS WC

2157: -- Determine rows to change in WF_COMMENTS Applies to users only
2158: if (l_pvalue is null or l_pvalue = 'Y') then
2159: if l_roleInfoTAB(1).ORIG_SYSTEM in ('PER','FND_USR') then
2160: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2161: from WF_COMMENTS WC
2162: where (WC.FROM_ROLE = p_name
2163: or WC.TO_ROLE = p_name
2164: or WC.PROXY_ROLE = p_name)
2165: and (exists (select '1'

Line 2183: from WF_COMMENTS WC

2179: end if;
2180: else
2181: if l_roleInfoTAB(1).ORIG_SYSTEM in ('PER','FND_USR') then
2182: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2183: from WF_COMMENTS WC
2184: where WC.FROM_ROLE = p_name
2185: or WC.TO_ROLE = p_name
2186: or WC.PROXY_ROLE = p_name;
2187: else

Line 2191: l_wfcount_tab.TABLE_NAME := 'WF_COMMENTS';

2187: else
2188: l_wfcount_tab.REC_CNT := 0;
2189: end if;
2190: end if;
2191: l_wfcount_tab.TABLE_NAME := 'WF_COMMENTS';
2192: pipe ROW (l_wfcount_tab);
2193:
2194: -- Determine rows to change in WF_ITEM_ATTRIBUTE_VALUES. Can be any role.
2195: if (l_pvalue is null or l_pvalue = 'Y') then