APPS.BSC_METADATA_DESC dependencies on BSC_KPI_ANALYSIS_GROUPS

Line 8: dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE

4: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_METADATA_DESC';
5: g_db_object varchar2(30) := null;
6:
7: TYPE Analysis_Group_Rec_Type IS RECORD (
8: dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE
9: ,change_dim_set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE
10: );
11:
12: TYPE t_Analysis_Group_Rec_tbl IS TABLE OF Analysis_Group_Rec_Type

Line 9: ,change_dim_set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE

5: g_db_object varchar2(30) := null;
6:
7: TYPE Analysis_Group_Rec_Type IS RECORD (
8: dependency_flag BSC_KPI_ANALYSIS_GROUPS.dependency_flag%TYPE
9: ,change_dim_set BSC_KPI_ANALYSIS_GROUPS.change_dim_set%TYPE
10: );
11:
12: TYPE t_Analysis_Group_Rec_tbl IS TABLE OF Analysis_Group_Rec_Type
13: INDEX BY BINARY_INTEGER;

Line 350: FROM BSC_KPI_ANALYSIS_GROUPS

346: ORDER BY DIM_LEVEL_INDEX;
347: -------------------------------------
348: CURSOR c_KPI_Analysis_Groups IS
349: SELECT ANALYSIS_GROUP_ID, DEPENDENCY_FLAG, CHANGE_DIM_SET
350: FROM BSC_KPI_ANALYSIS_GROUPS
351: WHERE INDICATOR = l_Kpi_Id;
352: -------------------------------------
353: CURSOR c_KPI_Analysis_Options0 IS
354: SELECT A.ANALYSIS_GROUP_ID, A.OPTION_ID, A.NAME, A.DIM_SET_ID

Line 572: l_not_found_msg := ' There is not any Analysis Group defined in table BSC_KPI_ANALYSIS_GROUPS';

568: l_Analysis_Group_Rec_tbl(1) := l_Analysis_Group_Rec_Type;
569: l_Analysis_Group_Rec_tbl(2) := l_Analysis_Group_Rec_Type;
570:
571: -------------- Analsysis Groups General Information.
572: l_not_found_msg := ' There is not any Analysis Group defined in table BSC_KPI_ANALYSIS_GROUPS';
573: put_line('---------------------------------------------------------------------------');
574: put_line('Objective Id <'||l_Kpi_Id||'> Analysis Groups (KPI Groups) Definition:');
575: put_line('---------------------------------------------------------------------------');
576: FOR bsc_AG_cd IN c_KPI_Analysis_Groups LOOP