DBA Data[Home] [Help]

APPS.BSC_METADATA_DESC dependencies on BSC_KPI_ANALYSIS_OPTIONS_VL

Line 355: FROM BSC_KPI_ANALYSIS_OPTIONS_VL A

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
355: FROM BSC_KPI_ANALYSIS_OPTIONS_VL A
356: WHERE A.INDICATOR = l_Kpi_Id
357: AND A.ANALYSIS_GROUP_ID = 0
358: AND A.PARENT_OPTION_ID = 0
359: AND A.GRANDPARENT_OPTION_ID = 0

Line 364: FROM BSC_KPI_ANALYSIS_OPTIONS_VL A

360: ORDER BY OPTION_ID;
361:
362: CURSOR c_KPI_Analysis_Options1 IS
363: SELECT A.ANALYSIS_GROUP_ID, A.OPTION_ID, A.NAME, A.DIM_SET_ID
364: FROM BSC_KPI_ANALYSIS_OPTIONS_VL A
365: WHERE A.INDICATOR = l_Kpi_Id
366: AND A.ANALYSIS_GROUP_ID = 1
367: AND A.PARENT_OPTION_ID = l_Parent_Option_Id
368: AND A.GRANDPARENT_OPTION_ID = 0

Line 373: FROM BSC_KPI_ANALYSIS_OPTIONS_VL A

369: ORDER BY OPTION_ID;
370:
371: CURSOR c_KPI_Analysis_Options2 IS
372: SELECT A.ANALYSIS_GROUP_ID, A.OPTION_ID, A.NAME, A.DIM_SET_ID
373: FROM BSC_KPI_ANALYSIS_OPTIONS_VL A
374: WHERE A.INDICATOR = l_Kpi_Id
375: AND A.ANALYSIS_GROUP_ID = 2
376: AND A.PARENT_OPTION_ID = l_Parent_Option_Id
377: AND A.GRANDPARENT_OPTION_ID = l_Grandparent_Option

Line 595: l_not_Analysis_Options0_msg := 'Objective Id <'||l_Kpi_Id||'> does not have any Analysis Option Defined for Group ID <0> IN Table BSC_KPI_ANALYSIS_OPTIONS_VL';

591: -----------Analysis Options Structur
592: put_line('---------------------------------------------------------------------------');
593: put_line('Objective ID <'||l_Kpi_Id||'> Analysis Options (KPIs) - Datasets - Measures - Dim. Sets ');
594: put_line('---------------------------------------------------------------------------');
595: l_not_Analysis_Options0_msg := 'Objective Id <'||l_Kpi_Id||'> does not have any Analysis Option Defined for Group ID <0> IN Table BSC_KPI_ANALYSIS_OPTIONS_VL';
596: FOR bsc_AO0_cd IN c_KPI_Analysis_Options0 LOOP
597: l_not_Analysis_Options0_msg := NULL;
598: put_line('-> ANALYSIS_GROUP_ID <'||bsc_AO0_cd.ANALYSIS_GROUP_ID ||'> - OPTION_ID <'||bsc_AO0_cd.OPTION_ID ||'> ' );
599: put_line('.... NAME is <'||bsc_AO0_cd.NAME ||'> ' );

Line 604: l_not_Analysis_Options1_msg := 'Objective Id <'||l_Kpi_Id||'> does not have any Analysis Option Defined for Group ID <1> IN Table BSC_KPI_ANALYSIS_OPTIONS_VL';

600: IF l_Analysis_Group_Rec_tbl(0).CHANGE_DIM_SET = 1 THEN
601: put_line('.... DIM_SET_ID is <'||bsc_AO0_cd.DIM_SET_ID ||'> ' );
602: END IF;
603: -----------Analysis Options 1
604: l_not_Analysis_Options1_msg := 'Objective Id <'||l_Kpi_Id||'> does not have any Analysis Option Defined for Group ID <1> IN Table BSC_KPI_ANALYSIS_OPTIONS_VL';
605: IF l_Analysis_Group_Rec_tbl(1).DEPENDENCY_FLAG = 1 THEN
606: l_Parent_Option_Id := bsc_AO0_cd.OPTION_ID;
607: ELSE
608: l_Parent_Option_Id := 0;

Line 618: l_not_Analysis_Options2_msg := 'Objective Id <'||l_Kpi_Id||'> does not have any Analysis Option Defined for Group ID <2> IN Table BSC_KPI_ANALYSIS_OPTIONS_VL';

614: IF l_Analysis_Group_Rec_tbl(1).CHANGE_DIM_SET = 1 THEN
615: put_line('..... DIM_SET_ID is <'||bsc_AO1_cd.DIM_SET_ID ||'> ' );
616: END IF;
617: -----------Analysis Options 2
618: l_not_Analysis_Options2_msg := 'Objective Id <'||l_Kpi_Id||'> does not have any Analysis Option Defined for Group ID <2> IN Table BSC_KPI_ANALYSIS_OPTIONS_VL';
619: IF l_Analysis_Group_Rec_tbl(2).DEPENDENCY_FLAG = 1 THEN
620: l_Parent_Option_Id := bsc_AO1_cd.OPTION_ID;
621: ELSE
622: l_Parent_Option_Id := 0;