APPS.BSC_OBJECTIVE_METADATA_SETUP dependencies on BSC_KPIS_VL

Line 67: l_kpi_Id bsc_kpis_vl.indicator%TYPE;

63: ************************************************************************************/
64: PROCEDURE runtest(inputs IN JTF_DIAG_INPUTTBL,
65: report OUT NOCOPY JTF_DIAG_REPORT,
66: reportClob OUT NOCOPY CLOB) IS
67: l_kpi_Id bsc_kpis_vl.indicator%TYPE;
68: l_Is_AG_Report BOOLEAN := FALSE;
69: statusStr VARCHAR2(50);
70: errStr VARCHAR2(4000);
71: fixInfo VARCHAR2(4000);

Line 91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);

87: isFatal := 'FALSE';
88: ELSE
89: JTF_DIAGNOSTIC_COREAPI.BRPrint;
90: l_Where_Clause := ' WHERE indicator ='|| l_kpi_Id;
91: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpis_vl','BSC_KPIS_VL', l_Where_Clause);
92: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_measures_vl','BSC_KPI_ANALYSIS_MEASURES_VL', l_Where_Clause);
93: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_groups','BSC_KPI_ANALYSIS_GROUPS', l_Where_Clause);
94: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_analysis_options_vl','BSC_KPI_ANALYSIS_OPTIONS_VL', l_Where_Clause);
95: l_Num_Rows := JTF_DIAGNOSTIC_COREAPI.Display_Table('bsc_kpi_dim_levels_vl','BSC_KPI_DIM_LEVELS_VL', l_Where_Clause);