APPS.BSC_METADATA_DESC dependencies on BSC_KPI_DIM_GROUPS

Line 328: , BSC_KPI_DIM_GROUPS B

324: -------------------------------------
325: CURSOR c_KPI_Dimensions IS
326: SELECT A.Name, A.Short_Name, B.Dim_Group_Id
327: FROM BSC_SYS_DIM_GROUPS_VL A
328: , BSC_KPI_DIM_GROUPS B
329: WHERE A.Dim_Group_Id (+) = B.Dim_Group_Id
330: AND B.Indicator = l_Kpi_Id
331: AND B.Dim_Set_Id = l_Dim_set_Id;
332: -------------------------------------

Line 422: -- invalide DIM Set ids in table BSC_KPI_DIM_GROUPS

418: WHERE INDICATOR = l_Kpi_Id
419: ORDER BY PERIODICITY_ID, DIM_SET_ID, LEVEL_COMB ;
420: -------------------------------------
421:
422: -- invalide DIM Set ids in table BSC_KPI_DIM_GROUPS
423: CURSOR c_invalide_dim_sets1 IS
424: SELECT DISTINCT K.DIM_SET_ID
425: FROM BSC_KPI_DIM_GROUPS K
426: WHERE K.Indicator = l_Kpi_Id

Line 425: FROM BSC_KPI_DIM_GROUPS K

421:
422: -- invalide DIM Set ids in table BSC_KPI_DIM_GROUPS
423: CURSOR c_invalide_dim_sets1 IS
424: SELECT DISTINCT K.DIM_SET_ID
425: FROM BSC_KPI_DIM_GROUPS K
426: WHERE K.Indicator = l_Kpi_Id
427: AND K.Dim_Set_Id NOT IN (
428: SELECT DIM_SET_ID
429: FROM BSC_KPI_DIM_SETS_VL

Line 530: --PART 3 OF INFORMATION, get information about dimensions within KPI's Dimension Set in table BSC_KPI_DIM_GROUPS

526: FOR bsc_cd IN c_KPI_Dim_sets LOOP
527: l_not_found_msg := NULL;
528: put_line('-> DIM_SET_ID (Dimension Set Id) is <'||bsc_cd.DIM_SET_ID||'>');
529: put_line('.... NAME (Dimension Set Name) is <'||bsc_cd.NAME||'>');
530: --PART 3 OF INFORMATION, get information about dimensions within KPI's Dimension Set in table BSC_KPI_DIM_GROUPS
531: l_dim_set_id := bsc_cd.DIM_SET_ID;
532: FOR bsc_dim_cd IN c_KPI_Dimensions LOOP
533: IF bsc_dim_cd.Name IS NOT NULL THEN
534: put_line('---> DIM_GROUP_ID (Dimension Id) is <'||bsc_dim_cd.DIM_GROUP_ID||'> ');

Line 556: put_line('....... Error: Invalid Dimension Id <'||bsc_dim_cd.Dim_Group_Id||'> found in table BSC_KPI_DIM_GROUPS' );

552: END IF;
553: END LOOP;
554: ELSE
555: put_line('---> DIM_GROUP_ID (Dimension Id) is <'||bsc_dim_cd.DIM_GROUP_ID||'> ');
556: put_line('....... Error: Invalid Dimension Id <'||bsc_dim_cd.Dim_Group_Id||'> found in table BSC_KPI_DIM_GROUPS' );
557: END IF;
558: END LOOP;
559: END LOOP;
560: IF (l_not_found_msg IS NOT NULL) THEN

Line 778: put_line(' Invalide Dimension Set ID <'||bsc_cd.DIM_SET_ID||'> in BSC_KPI_DIM_GROUPS table ' );

774: put_line('Objective ID <'||l_Kpi_Id||'> Additional Invalide KPI Metadata: ');
775: put_line('---------------------------------------------------------------------------');
776: FOR bsc_cd IN c_invalide_dim_sets1 LOOP
777: l_not_found_msg := NULL;
778: put_line(' Invalide Dimension Set ID <'||bsc_cd.DIM_SET_ID||'> in BSC_KPI_DIM_GROUPS table ' );
779: END LOOP;
780: IF (l_not_found_msg IS NOT NULL) THEN
781: put_line(l_not_found_msg);
782: END IF;