DBA Data[Home] [Help]

APPS.BSC_DESIGNER_PVT dependencies on BSC_KPI_ANALYSIS_MEASURES_TL

Line 90: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_TL';

86: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
87: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;*/
88:
89: g_num_kpi_metadata_tables := g_num_kpi_metadata_tables + 1;
90: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_name := 'BSC_KPI_ANALYSIS_MEASURES_TL';
91: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_type := C_KPI_TABLE ;
92: g_kpi_metadata_tables(g_num_kpi_metadata_tables).table_column := C_INDICATOR ;
93: g_kpi_metadata_tables(g_num_kpi_metadata_tables).duplicate_data := bsc_utility.YES;
94: g_kpi_metadata_tables(g_num_kpi_metadata_tables).mls_table := bsc_utility.YES;

Line 1138: h_name BSC_KPI_ANALYSIS_MEASURES_TL.NAME%TYPE;

1134: h_a1 NUMBER;
1135: h_a2 NUMBER;
1136:
1137: --
1138: h_name BSC_KPI_ANALYSIS_MEASURES_TL.NAME%TYPE;
1139: h_lang VARCHAR2(4);
1140: h_source_lang VARCHAR2(4);
1141: --08/30/02
1142: h_tmp VARCHAR2(255); /* Bug Fix #2691601 changine size from 80 to 255 */

Line 1170: FROM BSC_KPI_ANALYSIS_MEASURES_TL

1166:
1167: h_serie_id NUMBER;
1168: CURSOR c_analisys_measure_tl IS
1169: SELECT LANGUAGE,SOURCE_LANG,NAME
1170: FROM BSC_KPI_ANALYSIS_MEASURES_TL
1171: WHERE INDICATOR = l_indicator
1172: AND ANALYSIS_OPTION0= h_a0
1173: AND ANALYSIS_OPTION1= h_a1
1174: AND ANALYSIS_OPTION2= h_a2