DBA Data[Home] [Help]

APPS.IEX_METRIC_CONCUR_PVT dependencies on IEX_METRIC_PVT

Line 90: l_metric_id_tbl iex_metric_pvt.metric_id_tbl_type;

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:

Line 91: l_metric_name_tbl iex_metric_pvt.metric_name_tbl_type;

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

Line 92: l_metric_value_tbl iex_metric_pvt.metric_value_tbl_type;

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)

Line 93: l_metric_rating_tbl iex_metric_pvt.metric_rating_tbl_type;

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;

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

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,

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

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,

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

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,

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

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,