86: and jtf_object_code=l_jtf_object_code
87: and active_flag='Y';
88: --End Bug 7477844 24-Dec-2008 barathsr
89:
90: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;
91: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;
92: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;
93: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;
94:
87: and active_flag='Y';
88: --End Bug 7477844 24-Dec-2008 barathsr
89:
90: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;
91: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;
92: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;
93: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;
94:
95: CURSOR c_total_cnt IS
88: --End Bug 7477844 24-Dec-2008 barathsr
89:
90: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;
91: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;
92: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;
93: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;
94:
95: CURSOR c_total_cnt IS
96: SELECT count(1)
89:
90: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;
91: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;
92: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;
93: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;
94:
95: CURSOR c_total_cnt IS
96: SELECT count(1)
97: FROM iex_metric_summaries;
249: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Party Count=' || i);
250:
251: FOR idx1 IN l_party_id_tbl.FIRST..l_party_id_tbl.LAST LOOP
252:
253: iex_metric_pvt.get_metric_info(p_api_version => 1.0,
254: p_init_msg_list => FND_API.G_TRUE,
255: p_commit => FND_API.G_TRUE,
256: p_validation_level => 100,
257: x_return_status => l_return_status,
324: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Account Count=' || i);
325:
326: FOR idx1 IN l_cust_account_id_tbl.FIRST..l_cust_account_id_tbl.LAST LOOP
327:
328: iex_metric_pvt.get_metric_info(p_api_version => 1.0,
329: p_init_msg_list => FND_API.G_TRUE,
330: p_commit => FND_API.G_TRUE,
331: p_validation_level => 100,
332: x_return_status => l_return_status,
396: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total BillTo Count=' || i);
397:
398: FOR idx1 IN l_site_use_id_tbl.FIRST..l_site_use_id_tbl.LAST LOOP
399:
400: iex_metric_pvt.get_metric_info(p_api_version => 1.0,
401: p_init_msg_list => FND_API.G_TRUE,
402: p_commit => FND_API.G_TRUE,
403: p_validation_level => 100,
404: x_return_status => l_return_status,
454: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Delinquency Count=' || i);
455:
456: FOR idx1 IN l_delinquency_id_tbl.FIRST..l_delinquency_id_tbl.LAST LOOP
457:
458: iex_metric_pvt.get_metric_info(p_api_version => 1.0,
459: p_init_msg_list => FND_API.G_TRUE,
460: p_commit => FND_API.G_TRUE,
461: p_validation_level => 100,
462: x_return_status => l_return_status,