APPS.BSC_ANALYSIS_OPTION_PUB dependencies on BIS_INDICATORS

Line 43: | names in bis_indicators & bsc_sys_measures |

39: | PMF type measures |
40: | 12-Sep-2006 akoduri Bug#5526265 Issues iwth actual_data_source and |
41: | function name updation |
42: | 11-OCT-2006 akoduri Bug #5554168 Issue with Measures having different short |
43: | names in bis_indicators & bsc_sys_measures |
44: | 31-Jan-2007 akoduri Enh #5679096 Migration of multibar functionality from |
45: | VB to Html |
46: +======================================================================================+
47: */

Line 2147: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;

2143: x_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
2144: l_attribute_code VARCHAR2(100);
2145: l_count NUMBER;
2146:
2147: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
2148: l_Objective_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
2149: l_Measure_Source BSC_SYS_DATASETS_B.SOURCE%TYPE;
2150:
2151: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

Line 2151: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;

2147: l_Measure_Short_Name BIS_INDICATORS.SHORT_NAME%TYPE;
2148: l_Objective_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
2149: l_Measure_Source BSC_SYS_DATASETS_B.SOURCE%TYPE;
2150:
2151: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
2152: l_Compare_Attribute_Code AK_REGION_ITEMS.ATTRIBUTE_CODE%TYPE;
2153:
2154: -- Cursor to get the Data Set Id correspondig to each Short_name
2155: Cursor c_Dataset is

Line 2159: bis_indicators i

2155: Cursor c_Dataset is
2156: SELECT
2157: i.dataset_id
2158: FROM
2159: bis_indicators i
2160: WHERE
2161: i.short_name = l_short_name;
2162:
2163: -- Cursor to get the Data Series Id correspondig each Data Set