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_OAM_METRICS dependencies on WF_ITEMS

Line 85: cursor wf_items_cursor is

81:
82: l_item_type dbms_sql.VARCHAR2_table;
83: l_cnt dbms_sql.NUMBER_table;
84:
85: cursor wf_items_cursor is
86: SELECT /*+ PARALLEL(wf_item_activity_statuses) */
87: item_type, count(distinct(item_key)) cnt
88: FROM wf_item_activity_statuses
89: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING')

Line 95: open wf_items_cursor;

91: begin
92:
93: update wf_item_types set NUM_ACTIVE = 0;
94:
95: open wf_items_cursor;
96:
97: loop
98: fetch wf_items_cursor bulk collect into l_item_type, l_cnt limit 1000;
99:

Line 98: fetch wf_items_cursor bulk collect into l_item_type, l_cnt limit 1000;

94:
95: open wf_items_cursor;
96:
97: loop
98: fetch wf_items_cursor bulk collect into l_item_type, l_cnt limit 1000;
99:
100: forall i in 1 .. l_item_type.COUNT
101: update wf_item_types set NUM_ACTIVE = l_cnt(i)
102: where name = l_item_type(i);

Line 104: exit when wf_items_cursor%notfound;

100: forall i in 1 .. l_item_type.COUNT
101: update wf_item_types set NUM_ACTIVE = l_cnt(i)
102: where name = l_item_type(i);
103:
104: exit when wf_items_cursor%notfound;
105:
106: end loop;
107: close wf_items_cursor;
108:

Line 107: close wf_items_cursor;

103:
104: exit when wf_items_cursor%notfound;
105:
106: end loop;
107: close wf_items_cursor;
108:
109: update fnd_user_preferences
110: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
111: where preference_name = 'LAST_UPDATE_TIME' and

Line 117: if wf_items_cursor%ISOPEN then

113: user_name = '-WF_DEFAULT-';
114:
115: exception
116: when others then
117: if wf_items_cursor%ISOPEN then
118: close wf_items_cursor;
119: end if;
120: wf_core.context('WF_METRICS', 'populateActiveWorkItemsData' );
121: raise;

Line 118: close wf_items_cursor;

114:
115: exception
116: when others then
117: if wf_items_cursor%ISOPEN then
118: close wf_items_cursor;
119: end if;
120: wf_core.context('WF_METRICS', 'populateActiveWorkItemsData' );
121: raise;
122:

Line 132: cursor wf_items_cursor is

128:
129: l_item_type dbms_sql.VARCHAR2_table;
130: l_cnt dbms_sql.NUMBER_table;
131:
132: cursor wf_items_cursor is
133: SELECT item_type, count(distinct(item_key)) cnt
134: FROM wf_item_activity_statuses
135: WHERE activity_status = 'ERROR'
136: GROUP BY item_type ORDER BY item_type;

Line 141: open wf_items_cursor;

137: begin
138:
139: update wf_item_types set NUM_ERROR = 0;
140:
141: open wf_items_cursor;
142:
143: loop
144:
145: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;

Line 145: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;

141: open wf_items_cursor;
142:
143: loop
144:
145: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;
146:
147: forall i in 1 .. l_item_type.COUNT
148: update wf_item_types set NUM_ERROR = l_cnt(i)
149: where name = l_item_type(i);

Line 151: exit when wf_items_cursor%notfound;

147: forall i in 1 .. l_item_type.COUNT
148: update wf_item_types set NUM_ERROR = l_cnt(i)
149: where name = l_item_type(i);
150:
151: exit when wf_items_cursor%notfound;
152:
153: end loop;
154: close wf_items_cursor;
155:

Line 154: close wf_items_cursor;

150:
151: exit when wf_items_cursor%notfound;
152:
153: end loop;
154: close wf_items_cursor;
155:
156: update fnd_user_preferences
157: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
158: where preference_name = 'LAST_UPDATE_TIME' and

Line 164: if wf_items_cursor%isopen then

160: user_name = '-WF_DEFAULT-';
161:
162: exception
163: when others then
164: if wf_items_cursor%isopen then
165: close wf_items_cursor;
166: end if;
167: wf_core.context('WF_METRICS', 'populateErroredWorkItemsData' );
168: raise;

Line 165: close wf_items_cursor;

161:
162: exception
163: when others then
164: if wf_items_cursor%isopen then
165: close wf_items_cursor;
166: end if;
167: wf_core.context('WF_METRICS', 'populateErroredWorkItemsData' );
168: raise;
169:

Line 179: cursor wf_items_cursor is

175:
176: l_item_type dbms_sql.VARCHAR2_table;
177: l_cnt dbms_sql.NUMBER_table;
178:
179: cursor wf_items_cursor is
180: SELECT item_type, count(distinct(item_key)) cnt
181: FROM wf_item_activity_statuses
182: WHERE activity_status = 'DEFERRED'
183: GROUP BY item_type ORDER BY item_type;

Line 188: open wf_items_cursor;

184: begin
185:
186: update wf_item_types set NUM_DEFER = 0;
187:
188: open wf_items_cursor;
189:
190: loop
191:
192: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;

Line 192: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;

188: open wf_items_cursor;
189:
190: loop
191:
192: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;
193:
194: forall i in 1 .. l_item_type.COUNT
195: update wf_item_types set NUM_DEFER = l_cnt(i)
196: where name = l_item_type(i);

Line 198: exit when wf_items_cursor%notfound;

194: forall i in 1 .. l_item_type.COUNT
195: update wf_item_types set NUM_DEFER = l_cnt(i)
196: where name = l_item_type(i);
197:
198: exit when wf_items_cursor%notfound;
199:
200: end loop;
201: close wf_items_cursor;
202:

Line 201: close wf_items_cursor;

197:
198: exit when wf_items_cursor%notfound;
199:
200: end loop;
201: close wf_items_cursor;
202:
203: update fnd_user_preferences
204: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
205: where preference_name = 'LAST_UPDATE_TIME' and

Line 211: if wf_items_cursor%isopen then

207: user_name = '-WF_DEFAULT-';
208:
209: exception
210: when others then
211: if wf_items_cursor%isopen then
212: close wf_items_cursor;
213: end if;
214: wf_core.context('WF_METRICS', 'populateDeferredWorkItemsData' );
215: raise;

Line 212: close wf_items_cursor;

208:
209: exception
210: when others then
211: if wf_items_cursor%isopen then
212: close wf_items_cursor;
213: end if;
214: wf_core.context('WF_METRICS', 'populateDeferredWorkItemsData' );
215: raise;
216:

Line 226: cursor wf_items_cursor is

222:
223: l_item_type dbms_sql.VARCHAR2_table;
224: l_cnt dbms_sql.NUMBER_table;
225:
226: cursor wf_items_cursor is
227: SELECT item_type, count(distinct(item_key)) cnt
228: FROM wf_item_activity_statuses
229: WHERE activity_status = 'SUSPEND'
230: GROUP BY item_type ORDER BY item_type;

Line 235: open wf_items_cursor;

231: begin
232:
233: update wf_item_types set NUM_SUSPEND = 0;
234:
235: open wf_items_cursor;
236:
237: loop
238:
239: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;

Line 239: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;

235: open wf_items_cursor;
236:
237: loop
238:
239: fetch wf_items_cursor Bulk Collect into l_item_type, l_cnt limit 1000;
240:
241: forall i in 1 .. l_item_type.COUNT
242: update wf_item_types set NUM_SUSPEND = l_cnt(i)
243: where name = l_item_type(i);

Line 245: exit when wf_items_cursor%notfound;

241: forall i in 1 .. l_item_type.COUNT
242: update wf_item_types set NUM_SUSPEND = l_cnt(i)
243: where name = l_item_type(i);
244:
245: exit when wf_items_cursor%notfound;
246:
247: end loop;
248: close wf_items_cursor;
249:

Line 248: close wf_items_cursor;

244:
245: exit when wf_items_cursor%notfound;
246:
247: end loop;
248: close wf_items_cursor;
249:
250: update fnd_user_preferences
251: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
252: where preference_name = 'LAST_UPDATE_TIME' and

Line 258: if wf_items_cursor%isopen then

254: user_name = '-WF_DEFAULT-';
255:
256: exception
257: when others then
258: if wf_items_cursor%isopen then
259: close wf_items_cursor;
260: end if;
261: wf_core.context('WF_METRICS', 'populateSuspendedWorkItemsData' );
262: raise;

Line 259: close wf_items_cursor;

255:
256: exception
257: when others then
258: if wf_items_cursor%isopen then
259: close wf_items_cursor;
260: end if;
261: wf_core.context('WF_METRICS', 'populateSuspendedWorkItemsData' );
262: raise;
263:

Line 274: cursor wf_items_cursor is

270: l_item_type dbms_sql.VARCHAR2_table;
271: l_cnt dbms_sql.NUMBER_table;
272: l_purgeCnt dbms_sql.NUMBER_table;
273:
274: cursor wf_items_cursor is
275: SELECT /*+ PARALLEL(wi) */ wi.item_type, count(wi.item_key) cnt
276: FROM wf_items wi
277: WHERE wi.end_date IS NOT NULL
278: GROUP BY wi.item_type

Line 276: FROM wf_items wi

272: l_purgeCnt dbms_sql.NUMBER_table;
273:
274: cursor wf_items_cursor is
275: SELECT /*+ PARALLEL(wi) */ wi.item_type, count(wi.item_key) cnt
276: FROM wf_items wi
277: WHERE wi.end_date IS NOT NULL
278: GROUP BY wi.item_type
279: order by wi.item_type;
280: begin

Line 284: open wf_items_cursor;

280: begin
281:
282: update wf_item_types set NUM_COMPLETE = 0, NUM_PURGEABLE = 0;
283:
284: open wf_items_cursor;
285: loop
286: fetch wf_items_cursor bulk collect into l_item_type, l_cnt limit 1000;
287:
288: for i in 1 .. l_item_type.COUNT loop

Line 286: fetch wf_items_cursor bulk collect into l_item_type, l_cnt limit 1000;

282: update wf_item_types set NUM_COMPLETE = 0, NUM_PURGEABLE = 0;
283:
284: open wf_items_cursor;
285: loop
286: fetch wf_items_cursor bulk collect into l_item_type, l_cnt limit 1000;
287:
288: for i in 1 .. l_item_type.COUNT loop
289: l_purgeCnt(i) := wf_purge.getpurgeablecount(l_item_type(i));
290: end loop;

Line 297: exit when wf_items_cursor%notfound;

293: update wf_item_types set NUM_COMPLETE = l_cnt(i),
294: NUM_PURGEABLE = l_purgeCnt(i)
295: where name = l_item_type(i);
296:
297: exit when wf_items_cursor%notfound;
298:
299: end loop;
300: close wf_items_cursor;
301:

Line 300: close wf_items_cursor;

296:
297: exit when wf_items_cursor%notfound;
298:
299: end loop;
300: close wf_items_cursor;
301:
302: update fnd_user_preferences
303: set preference_value = to_char(sysdate,'dd/MM/YYYY HH24:MI:SS')
304: where preference_name = 'LAST_UPDATE_TIME' and

Line 310: if wf_items_cursor%ISOPEN then

306: user_name = '-WF_DEFAULT-';
307:
308: exception
309: when others then
310: if wf_items_cursor%ISOPEN then
311: close wf_items_cursor;
312: end if;
313: wf_core.context('WF_METRICS', 'populateCompletedWorkItemsData' );
314: raise;

Line 311: close wf_items_cursor;

307:
308: exception
309: when others then
310: if wf_items_cursor%ISOPEN then
311: close wf_items_cursor;
312: end if;
313: wf_core.context('WF_METRICS', 'populateCompletedWorkItemsData' );
314: raise;
315: