APPS.WF_OAM_METRICS dependencies on WF_ITEM_TYPES

Line 93: update wf_item_types set NUM_ACTIVE = 0;

89: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING')
90: GROUP BY item_type ORDER BY item_type;
91: begin
92:
93: update wf_item_types set NUM_ACTIVE = 0;
94:
95: open wf_items_cursor;
96:
97: loop

Line 101: update wf_item_types set NUM_ACTIVE = l_cnt(i)

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);
103:
104: exit when wf_items_cursor%notfound;
105:

Line 139: update wf_item_types set NUM_ERROR = 0;

135: WHERE activity_status = 'ERROR'
136: GROUP BY item_type ORDER BY item_type;
137: begin
138:
139: update wf_item_types set NUM_ERROR = 0;
140:
141: open wf_items_cursor;
142:
143: loop

Line 148: update wf_item_types set NUM_ERROR = l_cnt(i)

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);
150:
151: exit when wf_items_cursor%notfound;
152:

Line 186: update wf_item_types set NUM_DEFER = 0;

182: WHERE activity_status = 'DEFERRED'
183: GROUP BY item_type ORDER BY item_type;
184: begin
185:
186: update wf_item_types set NUM_DEFER = 0;
187:
188: open wf_items_cursor;
189:
190: loop

Line 195: update wf_item_types set NUM_DEFER = l_cnt(i)

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);
197:
198: exit when wf_items_cursor%notfound;
199:

Line 233: update wf_item_types set NUM_SUSPEND = 0;

229: WHERE activity_status = 'SUSPEND'
230: GROUP BY item_type ORDER BY item_type;
231: begin
232:
233: update wf_item_types set NUM_SUSPEND = 0;
234:
235: open wf_items_cursor;
236:
237: loop

Line 242: update wf_item_types set NUM_SUSPEND = l_cnt(i)

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);
244:
245: exit when wf_items_cursor%notfound;
246:

Line 282: update wf_item_types set NUM_COMPLETE = 0, NUM_PURGEABLE = 0;

278: GROUP BY wi.item_type
279: order by wi.item_type;
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;

Line 293: update wf_item_types set NUM_COMPLETE = l_cnt(i),

289: l_purgeCnt(i) := wf_purge.getpurgeablecount(l_item_type(i));
290: end loop;
291:
292: forall i in 1 .. l_item_type.COUNT
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;