APPS.WF_OAM_METRICS dependencies on DBMS_SQL

Line 82: l_item_type dbms_sql.VARCHAR2_table;

78:
79: procedure populateActiveWorkItemsData
80: 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) */

Line 83: l_cnt dbms_sql.NUMBER_table;

79: procedure populateActiveWorkItemsData
80: 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

Line 129: l_item_type dbms_sql.VARCHAR2_table;

125:
126: procedure populateErroredWorkItemsData
127: 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

Line 130: l_cnt dbms_sql.NUMBER_table;

126: procedure populateErroredWorkItemsData
127: 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

Line 176: l_item_type dbms_sql.VARCHAR2_table;

172:
173: procedure populateDeferredWorkItemsData
174: 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

Line 177: l_cnt dbms_sql.NUMBER_table;

173: procedure populateDeferredWorkItemsData
174: 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

Line 223: l_item_type dbms_sql.VARCHAR2_table;

219:
220: procedure populateSuspendedWorkItemsData
221: 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

Line 224: l_cnt dbms_sql.NUMBER_table;

220: procedure populateSuspendedWorkItemsData
221: 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

Line 270: l_item_type dbms_sql.VARCHAR2_table;

266:
267: procedure populateCompletedWorkItemsData
268: is
269:
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

Line 271: l_cnt dbms_sql.NUMBER_table;

267: procedure populateCompletedWorkItemsData
268: is
269:
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

Line 272: l_purgeCnt dbms_sql.NUMBER_table;

268: is
269:
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