APPS.IEX_METRIC_CONCUR_PVT dependencies on IEX_METRIC_SUMMARIES_ALL

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 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.