DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_PROPERTIES

Line 259: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PROPERTIES';

255: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;
256: g_kpi_metadata_tables(g_num_kpi_metadata_tables).copy_type := C_SHARED_KPI;
257:
258: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
259: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_PROPERTIES';
260: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
261: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
262: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
263: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.NO;

Line 970: FROM BSC_KPI_PROPERTIES WHERE PROPERTY_CODE='S_NODE_ID'

966: --Init s_node
967: s_node := 0;
968: SELECT PROPERTY_VALUE
969: INTO s_node
970: FROM BSC_KPI_PROPERTIES WHERE PROPERTY_CODE='S_NODE_ID'
971: AND INDICATOR=l_indicator;
972: --h_msg := ' s_node:' || s_node;
973: --DBMS_OUTPUT.PUT_LINE(h_msg);
974:

Line 1207: FROM BSC_KPI_PROPERTIES WHERE PROPERTY_CODE='S_NODE_ID'

1203: --Init s_node
1204: s_node := 0;
1205: SELECT PROPERTY_VALUE
1206: INTO s_node
1207: FROM BSC_KPI_PROPERTIES WHERE PROPERTY_CODE='S_NODE_ID'
1208: AND INDICATOR = l_indicator;
1209: --h_msg := ' s_node:' || s_node;
1210: --DBMS_OUTPUT.PUT_LINE(h_msg);
1211: