[Home] [Help]
145: l_labels VARCHAR2(5000);
146:
147: CURSOR kpi_cur IS
148: SELECT indicator
149: FROM bsc_tab_view_kpi_vl
150: WHERE tab_id = p_tab_id
151: AND tab_view_id = p_tab_view_id;
152: l_kpi_cur kpi_cur%ROWTYPE;
153:
1015: fnd_msg_pub.initialize;
1016: x_return_status := FND_API.G_RET_STS_SUCCESS;
1017:
1018: SELECT count(1) INTO l_count
1019: FROM BSC_TAB_VIEW_KPI_VL
1020: WHERE TAB_ID = p_tab_id
1021: AND TAB_VIEW_ID = p_tab_view_id
1022: AND INDICATOR = p_kpi_id;
1023: