38:
39: Begin
40:
41: SELECT count(item_key) into activeCount FROM
42: (select /*+ PARALLEL(wf_item_activity_statuses) */
43: distinct item_type, item_key from wf_item_activity_statuses
44: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING'));
45:
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
39: Begin
40:
41: SELECT count(item_key) into activeCount FROM
42: (select /*+ PARALLEL(wf_item_activity_statuses) */
43: distinct item_type, item_key from wf_item_activity_statuses
44: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING'));
45:
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
47:
42: (select /*+ PARALLEL(wf_item_activity_statuses) */
43: distinct item_type, item_key from wf_item_activity_statuses
44: WHERE activity_status in ('ACTIVE','NOTIFIED','WAITING'));
45:
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
47:
48: SELECT count(item_key) into erroredCount FROM
49: (select /*+ PARALLEL(wf_item_activity_statuses) */
50: distinct item_type, item_key from wf_item_activity_statuses
45:
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
47:
48: SELECT count(item_key) into erroredCount FROM
49: (select /*+ PARALLEL(wf_item_activity_statuses) */
50: distinct item_type, item_key from wf_item_activity_statuses
51: WHERE activity_status = 'ERROR');
52:
53: SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';
46: SELECT count(*) into deferredCount FROM wf_item_activity_statuses WHERE activity_status = 'DEFERRED';
47:
48: SELECT count(item_key) into erroredCount FROM
49: (select /*+ PARALLEL(wf_item_activity_statuses) */
50: distinct item_type, item_key from wf_item_activity_statuses
51: WHERE activity_status = 'ERROR');
52:
53: SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';
54:
49: (select /*+ PARALLEL(wf_item_activity_statuses) */
50: distinct item_type, item_key from wf_item_activity_statuses
51: WHERE activity_status = 'ERROR');
52:
53: SELECT count(*) into suspendedCount FROM wf_item_activity_statuses WHERE activity_status = 'SUSPEND';
54:
55: update FND_USER_PREFERENCES set preference_value = to_char(activeCount) where preference_name = 'NUM_ACTIVE' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
56:
57: update FND_USER_PREFERENCES set preference_value = to_char(deferredCount) where preference_name = 'NUM_DEFER' and user_name='-WF_DEFAULT-' and module_name='WFManagerWFItemsGraph';
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')
90: GROUP BY item_type ORDER BY item_type;
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')
90: GROUP BY item_type ORDER BY item_type;
91: begin
92:
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;
137: begin
138:
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;
184: begin
185:
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;
231: begin
232: