DBA Data[Home] [Help]

APPS.IEX_METRIC_CONCUR_PVT dependencies on IEX_METRIC_SUMMARIES_ALL

Line 102: FROM iex_metric_summaries_all

98:
99: --Start adding for bug 16575665 gnramasa 3rd Apr 2013
100: CURSOR c_cust_acct_cnt IS
101: SELECT count(1)
102: FROM iex_metric_summaries_all
103: WHERE object_type in ('PARTY','ACCOUNT');
104:
105: l_total_cnt NUMBER;
106: l_cust_acct_cnt NUMBER;

Line 110: l_del_cust_acct VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries_all';

106: l_cust_acct_cnt NUMBER;
107: i NUMBER;
108: l_del_sql VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries';
109:
110: l_del_cust_acct VARCHAR2(4000) := 'DELETE FROM iex_metric_summaries_all';
111: --End adding for bug 16575665 gnramasa 3rd Apr 2013
112:
113: TYPE Object_ID_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
114: l_party_id_tbl Object_ID_Tbl_Type;

Line 163: -- DELETE FROM iex_metric_summaries_all;

159: IF G_METRIC_BATCH = 'BATCH' THEN
160: -- Begin fix bug #4941239-jypark-delete records only of current operating unit
161:
162: -- Moac Changes . Delete from synonym iex_metric_summaries. Start.
163: -- DELETE FROM iex_metric_summaries_all;
164: -- DELETE FROM iex_metric_summaries;
165: -- Moac Changes . Delete from synonym iex_metric_summaries. End.
166:
167: IF P_ORG_ID IS NOT NULL THEN -- adding for bug 16516837

Line 213: IEX_DEBUG_PUB.LogMessage('Truncating IEX_METRIC_SUMMARIES_ALL');

209:
210: Else --start adding for bug 16516837
211: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_out_oracle_schema);
212: IEX_DEBUG_PUB.logMessage('IEX Schema:'||l_out_oracle_schema);
213: IEX_DEBUG_PUB.LogMessage('Truncating IEX_METRIC_SUMMARIES_ALL');
214:
215: ad_ddl.do_ddl(l_out_oracle_schema,
216: 'IEX',
217: AD_DDL.TRUNCATE_TABLE,

Line 218: 'TRUNCATE TABLE IEX_METRIC_SUMMARIES_ALL',

214:
215: ad_ddl.do_ddl(l_out_oracle_schema,
216: 'IEX',
217: AD_DDL.TRUNCATE_TABLE,
218: 'TRUNCATE TABLE IEX_METRIC_SUMMARIES_ALL',
219: 'IEX_METRIC_SUMMARIES_ALL');
220:
221: IEX_DEBUG_PUB.LogMessage('Truncated IEX_METRIC_SUMMARIES_ALL');
222: IEX_DEBUG_PUB.logMessage('Done');

Line 219: 'IEX_METRIC_SUMMARIES_ALL');

215: ad_ddl.do_ddl(l_out_oracle_schema,
216: 'IEX',
217: AD_DDL.TRUNCATE_TABLE,
218: 'TRUNCATE TABLE IEX_METRIC_SUMMARIES_ALL',
219: 'IEX_METRIC_SUMMARIES_ALL');
220:
221: IEX_DEBUG_PUB.LogMessage('Truncated IEX_METRIC_SUMMARIES_ALL');
222: IEX_DEBUG_PUB.logMessage('Done');
223:

Line 221: IEX_DEBUG_PUB.LogMessage('Truncated IEX_METRIC_SUMMARIES_ALL');

217: AD_DDL.TRUNCATE_TABLE,
218: 'TRUNCATE TABLE IEX_METRIC_SUMMARIES_ALL',
219: 'IEX_METRIC_SUMMARIES_ALL');
220:
221: IEX_DEBUG_PUB.LogMessage('Truncated IEX_METRIC_SUMMARIES_ALL');
222: IEX_DEBUG_PUB.logMessage('Done');
223:
224: END IF;
225: --end adding for bug 16516837

Line 273: INSERT INTO iex_metric_summaries_all

269:
270: IF l_metric_id_tbl.count > 0 THEN
271:
272: FORALL idx2 IN l_metric_name_tbl.FIRST..l_metric_name_tbl.LAST
273: INSERT INTO iex_metric_summaries_all
274: (object_id, object_type, org_id, score_comp_type_id, metric_value,
275: creation_date, created_by, last_update_date, last_updated_by,
276: last_update_login, metric_rating)
277: VALUES(l_party_id_tbl(idx1), 'PARTY',

Line 347: INSERT INTO iex_metric_summaries_all(object_id, object_type,

343: x_metric_rating_tbl => l_metric_rating_tbl);
344:
345: IF l_metric_id_tbl.count > 0 THEN
346: FORALL idx2 IN l_metric_name_tbl.FIRST..l_metric_name_tbl.LAST
347: INSERT INTO iex_metric_summaries_all(object_id, object_type,
348: org_id, score_comp_type_id, metric_value, creation_date,
349: created_by, last_update_date, last_updated_by,
350: last_update_login, metric_rating)
351: VALUES(l_cust_account_id_tbl(idx1), 'ACCOUNT',

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

415: x_metric_rating_tbl => l_metric_rating_tbl);
416:
417: IF l_metric_id_tbl.count > 0 THEN
418: FORALL idx2 IN l_metric_name_tbl.FIRST..l_metric_name_tbl.LAST
419: INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,
420: score_comp_type_id, metric_value, creation_date, created_by, last_update_date,
421: last_updated_by,last_update_login, metric_rating)
422: VALUES(l_site_use_id_tbl(idx1), 'BILL_TO',
423: --l_org_id, Moac Changes. Insert Org_id from cursor.

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

475:
476:
477: IF l_metric_id_tbl.count > 0 THEN
478: FORALL idx2 IN l_metric_name_tbl.FIRST..l_metric_name_tbl.LAST
479: INSERT INTO iex_metric_summaries_all(object_id, object_type, org_id,
480: score_comp_type_id, metric_value, creation_date, created_by,
481: last_update_date, last_updated_by, last_update_login, metric_rating)
482: VALUES(l_delinquency_id_tbl(idx1), 'DELINQUENCY',
483: --l_org_id, Moac Changes. Insert Org_id from cursor.