APPS.BSC_KPI_SERIES_PUB dependencies on BSC_KPI_ANALYSIS_OPTIONS_B

Line 790: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := 0;

786: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
787: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
788: l_Count NUMBER := 0;
789: l_Measure_Source bsc_sys_datasets_vl.source%TYPE;
790: l_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE := 0;
791: l_Option_Name bsc_kpi_analysis_options_vl.name%TYPE;
792: l_old_default_kpi bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
793:
794: CURSOR c_shared_objs IS

Line 1503: l_Series_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE;

1499: l_All_Comb_Map_New Bsc_Dim_Dataset_Table;
1500: l_AO_Comb_Map Bsc_Dim_Dataset_Table;
1501:
1502: l_Series_DataSet_Id bsc_kpi_analysis_measures_b.dataset_id%TYPE;
1503: l_Series_DimSet_Id bsc_kpi_analysis_options_b.dim_set_id%TYPE;
1504: l_Combination_Cnt NUMBER;
1505: l_Found BOOLEAN;
1506: i NUMBER;
1507: j NUMBER;

Line 1509: l_Current_DimSet bsc_kpi_analysis_options_b.dim_set_id%TYPE;

1505: l_Found BOOLEAN;
1506: i NUMBER;
1507: j NUMBER;
1508:
1509: l_Current_DimSet bsc_kpi_analysis_options_b.dim_set_id%TYPE;
1510:
1511: CURSOR c_dimset_dataset_map IS
1512: SELECT
1513: db.dim_set_id, db.dataset_id, count(1)