DBA Data[Home] [Help]

APPS.BSC_KPI_PUB dependencies on BSC_KPIS_B

Line 42: DELETE_KPI_FLAG CONSTANT NUMBER := 2; -- BSC_KPIS_B.PROTOTYPE_FLAG to indicate DELETED KPI

38: | 21-MAR-2007 akoduri Copy Indicator Enh#5943238 |
39: +======================================================================================+
40: */
41: -- Added for Bug #3248729
42: DELETE_KPI_FLAG CONSTANT NUMBER := 2; -- BSC_KPIS_B.PROTOTYPE_FLAG to indicate DELETED KPI
43:
44: BENCHMARK_KPI_PROPERTY CONSTANT VARCHAR(20) := 'BENCHMARK_GRAPH_TYPE';
45: BENCHMARK_KPI_LINE_GRAPH CONSTANT NUMBER := 0; --this is the default graph type
46: BENCHMARK_KPI_BAR_GRAPH CONSTANT NUMBER := 1;

Line 164: ,Bsc_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE

160: ,Creation_Date date -- Tab, Kpi
161: ,Last_Updated_By number -- Tab, Kpi
162: ,Last_Update_Date date -- Tab, Kpi
163: ,Last_Update_Login number -- Tab, Kpi
164: ,Bsc_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE
165: ,Bsc_Kpi_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
166: ,Bsc_Kpi_Dim_Set_Short_Name BSC_KPI_DIM_SETS_TL.SHORT_NAME%TYPE
167: ,Bsc_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
168: ,Bsc_Color_Rollup_Type BSC_KPIS_B.COLOR_ROLLUP_TYPE%TYPE

Line 168: ,Bsc_Color_Rollup_Type BSC_KPIS_B.COLOR_ROLLUP_TYPE%TYPE

164: ,Bsc_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE
165: ,Bsc_Kpi_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
166: ,Bsc_Kpi_Dim_Set_Short_Name BSC_KPI_DIM_SETS_TL.SHORT_NAME%TYPE
167: ,Bsc_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
168: ,Bsc_Color_Rollup_Type BSC_KPIS_B.COLOR_ROLLUP_TYPE%TYPE
169: ,Bsc_Prototype_Color_Id BSC_KPIS_B.PROTOTYPE_COLOR_ID%TYPE
170: ,Bsc_Weighted_Color_Method BSC_KPIS_B.WEIGHTED_COLOR_METHOD%TYPE
171: ,Bsc_Prototype_Trend_Id BSC_KPIS_B.PROTOTYPE_TREND_ID%TYPE
172: );

Line 169: ,Bsc_Prototype_Color_Id BSC_KPIS_B.PROTOTYPE_COLOR_ID%TYPE

165: ,Bsc_Kpi_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
166: ,Bsc_Kpi_Dim_Set_Short_Name BSC_KPI_DIM_SETS_TL.SHORT_NAME%TYPE
167: ,Bsc_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
168: ,Bsc_Color_Rollup_Type BSC_KPIS_B.COLOR_ROLLUP_TYPE%TYPE
169: ,Bsc_Prototype_Color_Id BSC_KPIS_B.PROTOTYPE_COLOR_ID%TYPE
170: ,Bsc_Weighted_Color_Method BSC_KPIS_B.WEIGHTED_COLOR_METHOD%TYPE
171: ,Bsc_Prototype_Trend_Id BSC_KPIS_B.PROTOTYPE_TREND_ID%TYPE
172: );
173:

Line 170: ,Bsc_Weighted_Color_Method BSC_KPIS_B.WEIGHTED_COLOR_METHOD%TYPE

166: ,Bsc_Kpi_Dim_Set_Short_Name BSC_KPI_DIM_SETS_TL.SHORT_NAME%TYPE
167: ,Bsc_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
168: ,Bsc_Color_Rollup_Type BSC_KPIS_B.COLOR_ROLLUP_TYPE%TYPE
169: ,Bsc_Prototype_Color_Id BSC_KPIS_B.PROTOTYPE_COLOR_ID%TYPE
170: ,Bsc_Weighted_Color_Method BSC_KPIS_B.WEIGHTED_COLOR_METHOD%TYPE
171: ,Bsc_Prototype_Trend_Id BSC_KPIS_B.PROTOTYPE_TREND_ID%TYPE
172: );
173:
174: TYPE Bsc_Kpi_Entity_Tbl IS TABLE OF Bsc_Kpi_Entity_Rec

Line 171: ,Bsc_Prototype_Trend_Id BSC_KPIS_B.PROTOTYPE_TREND_ID%TYPE

167: ,Bsc_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type
168: ,Bsc_Color_Rollup_Type BSC_KPIS_B.COLOR_ROLLUP_TYPE%TYPE
169: ,Bsc_Prototype_Color_Id BSC_KPIS_B.PROTOTYPE_COLOR_ID%TYPE
170: ,Bsc_Weighted_Color_Method BSC_KPIS_B.WEIGHTED_COLOR_METHOD%TYPE
171: ,Bsc_Prototype_Trend_Id BSC_KPIS_B.PROTOTYPE_TREND_ID%TYPE
172: );
173:
174: TYPE Bsc_Kpi_Entity_Tbl IS TABLE OF Bsc_Kpi_Entity_Rec
175: INDEX BY BINARY_INTEGER;