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_ITEMS

Line 81: from WF_ITEMS

77: -- are not currently used, so they are not included.
78:
79: cursor cItems (l_oldname varchar2) is
80: select ITEM_TYPE, ITEM_KEY
81: from WF_ITEMS
82: where OWNER_ROLE = l_oldname;
83:
84: cursor cItems2 (l_oldname varchar2) is
85: select ITEM_TYPE, ITEM_KEY

Line 86: from WF_ITEMS

82: where OWNER_ROLE = l_oldname;
83:
84: cursor cItems2 (l_oldname varchar2) is
85: select ITEM_TYPE, ITEM_KEY
86: from WF_ITEMS
87: where OWNER_ROLE = l_oldname
88: and END_DATE IS NULL;
89:
90: cursor cItemActivityStatuses (l_oldname varchar2) is

Line 97: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI

93: where ASSIGNED_USER = l_oldname;
94:
95: cursor cItemActivityStatuses2 (l_oldname varchar2) is
96: select WIAS.ITEM_TYPE, WIAS.ITEM_KEY, WIAS.PROCESS_ACTIVITY
97: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI
98: where WIAS.ITEM_TYPE = wi.item_type
99: and WIAS.ITEM_KEY = wi.item_key
100: and WI.END_DATE IS NULL
101: and WIAS.ASSIGNED_USER = l_oldname;

Line 110: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

106: where ASSIGNED_USER = l_oldname;
107:
108: cursor cItemActivityStatuses_H2 (l_oldname varchar2) is
109: select WIASH.ITEM_TYPE, WIASH.ITEM_KEY, WIASH.PROCESS_ACTIVITY
110: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
111: where WIASH.ITEM_TYPE = wi.item_type
112: and WIASH.ITEM_KEY = wi.item_key
113: and WI.END_DATE IS NULL
114: and WIASH.ASSIGNED_USER = l_oldname;

Line 135: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI

131: or WN.MORE_INFO_ROLE = l_oldname
132: or WN.FROM_ROLE = l_oldname
133: or WN.RESPONDER = l_oldname)
134: and (exists (select '1'
135: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI
136: where WIAS.NOTIFICATION_ID = WN.NOTIFICATION_ID
137: and WIAS.NOTIFICATION_ID is not null
138: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
139: and WIAS.ITEM_KEY = WI.ITEM_KEY

Line 142: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

138: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
139: and WIAS.ITEM_KEY = WI.ITEM_KEY
140: and WI.END_DATE IS NULL)
141: or exists (select '1'
142: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
143: where WIASH.NOTIFICATION_ID = WN.NOTIFICATION_ID
144: and WIASH.NOTIFICATION_ID is not null
145: and WIASH.ITEM_TYPE = WI.ITEM_TYPE
146: and WIASH.ITEM_KEY = WI.ITEM_KEY

Line 186: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI

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'
186: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI
187: where WIAS.NOTIFICATION_ID = WC.NOTIFICATION_ID
188: and WIAS.NOTIFICATION_ID is not null
189: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
190: and WIAS.ITEM_KEY = WI.ITEM_KEY

Line 193: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

189: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
190: and WIAS.ITEM_KEY = WI.ITEM_KEY
191: and WI.END_DATE IS NULL)
192: or exists (select '1'
193: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
194: where WIASH.NOTIFICATION_ID = WC.NOTIFICATION_ID
195: and WIASH.NOTIFICATION_ID is not null
196: and WIASH.ITEM_TYPE = WI.ITEM_TYPE
197: and WIASH.ITEM_KEY = WI.ITEM_KEY

Line 216: from WF_ITEMS WI

212: and wia.item_type = wiav.item_type
213: and wia.name = wiav.name
214: and wiav.text_value = l_oldname
215: and exists (select '1'
216: from WF_ITEMS WI
217: where WI.ITEM_TYPE = WIAV.ITEM_TYPE
218: and WI.ITEM_KEY = WIAV.ITEM_KEY
219: and WI.END_DATE IS NULL);
220:

Line 296: update wf_items

292: exit;
293: end if;
294:
295: forall i in itemTbl.first..itemTbl.last
296: update wf_items
297: set owner_role = l_newname
298: where item_type = itemTbl(i).item_type
299: and item_key = itemTbl(i).item_key;
300:

Line 424: update wf_items

420: exit;
421: end if;
422:
423: forall i in itemTbl.first..itemTbl.last
424: update wf_items
425: set owner_role = l_newname
426: where item_type = itemTbl(i).item_type
427: and item_key = itemTbl(i).item_key;
428: commit;

Line 625: 'Updated Records: WF_ITEMS:'||l_items||', WF_IAS:'||l_ias||', WF_IASH:'

621: CLOSE cWorklistAccess;
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

Line 2011: from WF_ITEMS

2007:
2008: -- Determine the workflow processes owned by this role. Can be any role.
2009: if (l_pvalue is null or l_pvalue = 'Y') then
2010: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2011: from WF_ITEMS
2012: where OWNER_ROLE = p_name;
2013: else
2014: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2015: from WF_ITEMS

Line 2015: from WF_ITEMS

2011: from WF_ITEMS
2012: where OWNER_ROLE = p_name;
2013: else
2014: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2015: from WF_ITEMS
2016: where OWNER_ROLE = p_name
2017: and END_DATE is null;
2018: end if;
2019: l_wfcount_tab.TABLE_NAME :='WF_ITEMS';

Line 2019: l_wfcount_tab.TABLE_NAME :='WF_ITEMS';

2015: from WF_ITEMS
2016: where OWNER_ROLE = p_name
2017: and END_DATE is null;
2018: end if;
2019: l_wfcount_tab.TABLE_NAME :='WF_ITEMS';
2020: pipe ROW (l_wfcount_tab);
2021:
2022: -- Determine rows to change in WF_ITEM_ACTIVITY_STATUSES
2023: if (l_pvalue is null or l_pvalue = 'Y') then

Line 2031: from WF_ITEMS WI

2027: else
2028: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2029: from WF_ITEM_ACTIVITY_STATUSES WIAS
2030: where exists (select '1'
2031: from WF_ITEMS WI
2032: where WI.ITEM_TYPE=WIAS.ITEM_TYPE and
2033: WI.ITEM_KEY=WIAS.ITEM_KEY and
2034: WI.END_DATE is null) and
2035: ASSIGNED_USER = p_name;

Line 2049: from WF_ITEMS WI

2045: else
2046: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2047: from WF_ITEM_ACTIVITY_STATUSES_H WIASH
2048: where exists (select '1'
2049: from WF_ITEMS WI
2050: where WI.ITEM_TYPE=WIASH.ITEM_TYPE and
2051: WI.ITEM_KEY=WIASH.ITEM_KEY and
2052: WI.END_DATE is null) and
2053: ASSIGNED_USER = p_name;

Line 2071: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI

2067: else
2068: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2069: from WF_NOTIFICATIONS WN
2070: where (exists (select '1'
2071: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI
2072: where WIAS.NOTIFICATION_ID = WN.NOTIFICATION_ID
2073: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
2074: and WIAS.ITEM_KEY = WI.ITEM_KEY
2075: and WI.END_DATE IS NULL)

Line 2077: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

2073: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
2074: and WIAS.ITEM_KEY = WI.ITEM_KEY
2075: and WI.END_DATE IS NULL)
2076: or exists (select '1'
2077: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
2078: where WIASH.NOTIFICATION_ID = WN.NOTIFICATION_ID
2079: and WIASH.ITEM_TYPE = WI.ITEM_TYPE
2080: and WIASH.ITEM_KEY = WI.ITEM_KEY
2081: and WI.END_DATE IS NULL))

Line 2166: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI

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'
2166: from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_ITEMS WI
2167: where WIAS.NOTIFICATION_ID = WC.NOTIFICATION_ID
2168: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
2169: and WIAS.ITEM_KEY = WI.ITEM_KEY
2170: and WI.END_DATE IS NULL)

Line 2172: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI

2168: and WIAS.ITEM_TYPE = WI.ITEM_TYPE
2169: and WIAS.ITEM_KEY = WI.ITEM_KEY
2170: and WI.END_DATE IS NULL)
2171: or exists (select '1'
2172: from WF_ITEM_ACTIVITY_STATUSES_H WIASH, WF_ITEMS WI
2173: where WIASH.NOTIFICATION_ID = WC.NOTIFICATION_ID
2174: and WIASH.ITEM_TYPE = WI.ITEM_TYPE
2175: and WIASH.ITEM_KEY = WI.ITEM_KEY
2176: and WI.END_DATE IS NULL));

Line 2210: from WF_ITEMS WI

2206: and WIA.ITEM_TYPE = WIAV.ITEM_TYPE
2207: and WIA.NAME = WIAV.NAME
2208: and WIAV.TEXT_VALUE = p_name
2209: and exists (select '1'
2210: from WF_ITEMS WI
2211: where WI.ITEM_TYPE=WIAV.ITEM_TYPE
2212: and WI.ITEM_KEY=WIAV.ITEM_KEY
2213: and WI.END_DATE is null);
2214: end if;