APPS.IEX_METRIC_CONCUR_PVT dependencies on IEX_METRIC_PVT

Line 65: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;

61: AND organization_id = nvl(P_ORG_ID,organization_id);
62:
63: --Moac Changes. Define Cursor for org_id. End.
64:
65: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;
66: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;
67: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;
68: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;
69:

Line 66: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;

62:
63: --Moac Changes. Define Cursor for org_id. End.
64:
65: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;
66: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;
67: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;
68: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;
69:
70: CURSOR c_total_cnt IS

Line 67: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;

63: --Moac Changes. Define Cursor for org_id. End.
64:
65: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;
66: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;
67: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;
68: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;
69:
70: CURSOR c_total_cnt IS
71: SELECT count(1)

Line 68: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;

64:
65: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;
66: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;
67: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;
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;

Line 163: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

159: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Party Count=' || i);
160:
161: FOR idx1 IN l_party_id_tbl.FIRST..l_party_id_tbl.LAST LOOP
162:
163: iex_metric_pvt.get_metric_info(p_api_version => 1.0,
164: p_init_msg_list => FND_API.G_TRUE,
165: p_commit => FND_API.G_TRUE,
166: p_validation_level => 100,
167: x_return_status => l_return_status,

Line 224: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

220: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Account Count=' || i);
221:
222: FOR idx1 IN l_cust_account_id_tbl.FIRST..l_cust_account_id_tbl.LAST LOOP
223:
224: iex_metric_pvt.get_metric_info(p_api_version => 1.0,
225: p_init_msg_list => FND_API.G_TRUE,
226: p_commit => FND_API.G_TRUE,
227: p_validation_level => 100,
228: x_return_status => l_return_status,

Line 289: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

285: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total BillTo Count=' || i);
286:
287: FOR idx1 IN l_site_use_id_tbl.FIRST..l_site_use_id_tbl.LAST LOOP
288:
289: iex_metric_pvt.get_metric_info(p_api_version => 1.0,
290: p_init_msg_list => FND_API.G_TRUE,
291: p_commit => FND_API.G_TRUE,
292: p_validation_level => 100,
293: x_return_status => l_return_status,

Line 340: iex_metric_pvt.get_metric_info(p_api_version => 1.0,

336: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total Delinquency Count=' || i);
337:
338: FOR idx1 IN l_delinquency_id_tbl.FIRST..l_delinquency_id_tbl.LAST LOOP
339:
340: iex_metric_pvt.get_metric_info(p_api_version => 1.0,
341: p_init_msg_list => FND_API.G_TRUE,
342: p_commit => FND_API.G_TRUE,
343: p_validation_level => 100,
344: x_return_status => l_return_status,