88: ,Bsc_User_Level2 number
89: ,Bsc_User_Level2_Default number
90: ,Bsc_Option_Short_Name BSC_KPI_ANALYSIS_OPTIONS_B.SHORT_NAME%TYPE
91: ,Bsc_Kpi_Measure_Id BSC_KPI_ANALYSIS_MEASURES_B.kpi_measure_id%TYPE
92: ,Bsc_Option_Default_Value BSC_KPI_ANALYSIS_GROUPS.default_value%TYPE
93: ,Bsc_Change_Action_Flag VARCHAR2(1) := FND_API.G_TRUE
94: );
95:
96: TYPE Bsc_Option_Tbl_Type IS TABLE OF Bsc_Option_Rec_Type
95:
96: TYPE Bsc_Option_Tbl_Type IS TABLE OF Bsc_Option_Rec_Type
97: INDEX BY BINARY_INTEGER;
98: TYPE Bsc_Analysis_Group_Rec is RECORD
99: ( Bsc_analysis_group_id BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE
100: , Bsc_no_option_id BSC_KPI_ANALYSIS_GROUPS.num_of_options%TYPE
101: , Bsc_dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE
102: , Bsc_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
103: , Bsc_Change_Dim_Set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE
96: TYPE Bsc_Option_Tbl_Type IS TABLE OF Bsc_Option_Rec_Type
97: INDEX BY BINARY_INTEGER;
98: TYPE Bsc_Analysis_Group_Rec is RECORD
99: ( Bsc_analysis_group_id BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE
100: , Bsc_no_option_id BSC_KPI_ANALYSIS_GROUPS.num_of_options%TYPE
101: , Bsc_dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE
102: , Bsc_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
103: , Bsc_Change_Dim_Set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE
104: );
97: INDEX BY BINARY_INTEGER;
98: TYPE Bsc_Analysis_Group_Rec is RECORD
99: ( Bsc_analysis_group_id BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE
100: , Bsc_no_option_id BSC_KPI_ANALYSIS_GROUPS.num_of_options%TYPE
101: , Bsc_dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE
102: , Bsc_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
103: , Bsc_Change_Dim_Set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE
104: );
105:
98: TYPE Bsc_Analysis_Group_Rec is RECORD
99: ( Bsc_analysis_group_id BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE
100: , Bsc_no_option_id BSC_KPI_ANALYSIS_GROUPS.num_of_options%TYPE
101: , Bsc_dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE
102: , Bsc_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
103: , Bsc_Change_Dim_Set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE
104: );
105:
106: TYPE Bsc_Anal_Opt_Tbl_Type IS TABLE OF Bsc_Analysis_Group_Rec INDEX BY BINARY_INTEGER;
99: ( Bsc_analysis_group_id BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE
100: , Bsc_no_option_id BSC_KPI_ANALYSIS_GROUPS.num_of_options%TYPE
101: , Bsc_dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE
102: , Bsc_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE
103: , Bsc_Change_Dim_Set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE
104: );
105:
106: TYPE Bsc_Anal_Opt_Tbl_Type IS TABLE OF Bsc_Analysis_Group_Rec INDEX BY BINARY_INTEGER;
107:
110: (
111: Bsc_Option_Id BSC_KPI_ANALYSIS_OPTIONS_B.Option_Id%TYPE
112: , Bsc_Parent_Option_Id BSC_KPI_ANALYSIS_OPTIONS_B.Parent_Option_Id%TYPE
113: , Bsc_Grandparent_Option_Id BSC_KPI_ANALYSIS_OPTIONS_B.Grandparent_Option_Id%TYPE
114: , Bsc_dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE
115: , No_of_child NUMBER
116: , Bsc_Option_Short_Name BSC_KPI_ANALYSIS_OPTIONS_B.SHORT_NAME%TYPE
117: );
118:
303:
304: FUNCTION Get_Num_Analysis_options
305: (
306: p_obj_id IN BSC_KPIS_B.indicator%TYPE
307: , p_anal_grp_Id IN BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE
308: ) RETURN NUMBER;
309:
310:
311: FUNCTION Get_Analysis_Group_Id