APPS.IEX_METRIC_CONCUR_PVT dependencies on IEX_METRIC_SUMMARIES

Line 72: FROM iex_metric_summaries;

68: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;
69:
70: CURSOR c_total_cnt IS
71: SELECT count(1)
72: FROM iex_metric_summaries;
73:
74: l_total_cnt NUMBER;
75: i NUMBER;
76: l_del_sql VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries';

Line 76: l_del_sql VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries';

72: FROM iex_metric_summaries;
73:
74: l_total_cnt NUMBER;
75: i NUMBER;
76: l_del_sql VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries';
77:
78: TYPE Object_ID_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
79: l_party_id_tbl Object_ID_Tbl_Type;
80: l_cust_account_id_tbl Object_ID_Tbl_Type;

Line 121: -- Moac Changes . Delete from synonym iex_metric_summaries. Start.

117:
118: IF G_METRIC_BATCH = 'BATCH' THEN
119: -- Begin fix bug #4941239-jypark-delete records only of current operating unit
120:
121: -- Moac Changes . Delete from synonym iex_metric_summaries. Start.
122: -- DELETE FROM iex_metric_summaries_all;
123: -- DELETE FROM iex_metric_summaries;
124: -- Moac Changes . Delete from synonym iex_metric_summaries. End.
125:

Line 122: -- DELETE FROM iex_metric_summaries_all;

118: IF G_METRIC_BATCH = 'BATCH' THEN
119: -- Begin fix bug #4941239-jypark-delete records only of current operating unit
120:
121: -- Moac Changes . Delete from synonym iex_metric_summaries. Start.
122: -- DELETE FROM iex_metric_summaries_all;
123: -- DELETE FROM iex_metric_summaries;
124: -- Moac Changes . Delete from synonym iex_metric_summaries. End.
125:
126: l_del_sql := l_del_sql || ' WHERE rownum >= 0 and rownum < ' || l_batch_size;

Line 123: -- DELETE FROM iex_metric_summaries;

119: -- Begin fix bug #4941239-jypark-delete records only of current operating unit
120:
121: -- Moac Changes . Delete from synonym iex_metric_summaries. Start.
122: -- DELETE FROM iex_metric_summaries_all;
123: -- DELETE FROM iex_metric_summaries;
124: -- Moac Changes . Delete from synonym iex_metric_summaries. End.
125:
126: l_del_sql := l_del_sql || ' WHERE rownum >= 0 and rownum < ' || l_batch_size;
127:

Line 124: -- Moac Changes . Delete from synonym iex_metric_summaries. End.

120:
121: -- Moac Changes . Delete from synonym iex_metric_summaries. Start.
122: -- DELETE FROM iex_metric_summaries_all;
123: -- DELETE FROM iex_metric_summaries;
124: -- Moac Changes . Delete from synonym iex_metric_summaries. End.
125:
126: l_del_sql := l_del_sql || ' WHERE rownum >= 0 and rownum < ' || l_batch_size;
127:
128: OPEN c_total_cnt;

Line 183: INSERT INTO iex_metric_summaries_all

179:
180: IF l_metric_id_tbl.count > 0 THEN
181:
182: FORALL idx2 IN l_metric_name_tbl.FIRST..l_metric_name_tbl.LAST
183: INSERT INTO iex_metric_summaries_all
184: (object_id, object_type, org_id, score_comp_type_id, metric_value,
185: creation_date, created_by, last_update_date, last_updated_by,
186: last_update_login, metric_rating)
187: VALUES(l_party_id_tbl(idx1), 'PARTY',

Line 243: INSERT INTO iex_metric_summaries_all(object_id, object_type,

239: x_metric_rating_tbl => l_metric_rating_tbl);
240:
241: IF l_metric_id_tbl.count > 0 THEN
242: FORALL idx2 IN l_metric_name_tbl.FIRST..l_metric_name_tbl.LAST
243: INSERT INTO iex_metric_summaries_all(object_id, object_type,
244: org_id, score_comp_type_id, metric_value, creation_date,
245: created_by, last_update_date, last_updated_by,
246: last_update_login, metric_rating)
247: VALUES(l_cust_account_id_tbl(idx1), 'ACCOUNT',

Line 308: INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,

304: x_metric_rating_tbl => l_metric_rating_tbl);
305:
306: IF l_metric_id_tbl.count > 0 THEN
307: FORALL idx2 IN l_metric_name_tbl.FIRST..l_metric_name_tbl.LAST
308: INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,
309: score_comp_type_id, metric_value, creation_date, created_by, last_update_date,
310: last_updated_by,last_update_login, metric_rating)
311: VALUES(l_site_use_id_tbl(idx1), 'BILL_TO',
312: --l_org_id, Moac Changes. Insert Org_id from cursor.

Line 361: INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,

357:
358:
359: IF l_metric_id_tbl.count > 0 THEN
360: FORALL idx2 IN l_metric_name_tbl.FIRST..l_metric_name_tbl.LAST
361: INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,
362: score_comp_type_id, metric_value, creation_date, created_by,
363: last_update_date, last_updated_by, last_update_login, metric_rating)
364: VALUES(l_delinquency_id_tbl(idx1), 'DELINQUENCY',
365: --l_org_id, Moac Changes. Insert Org_id from cursor.