DBA Data[Home] [Help]

APPS.BSC_ANALYSIS_OPTION_PUB dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 92: ,Bsc_Option_Default_Value BSC_KPI_ANALYSIS_GROUPS.default_value%TYPE

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

Line 99: ( Bsc_analysis_group_id BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%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

Line 100: , Bsc_no_option_id BSC_KPI_ANALYSIS_GROUPS.num_of_options%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: );

Line 101: , Bsc_dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%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: );
105:

Line 102: , Bsc_Ana_Group_Short_Name BSC_KPI_ANALYSIS_GROUPS.SHORT_NAME%TYPE

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;

Line 103: , Bsc_Change_Dim_Set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE

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:

Line 114: , Bsc_dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE

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:

Line 307: , p_anal_grp_Id IN BSC_KPI_ANALYSIS_GROUPS.analysis_group_id%TYPE

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