DBA Data[Home] [Help]

APPS.BSC_DATASETS_PVT dependencies on BSC_DESIGNER_PVT

Line 542: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;

538: -- for Bug#3528425
539:
540: -- ppandey -Set prototype flag based on formula change or column group change
541: IF (p_Dataset_Rec.Bsc_Measure_Group_Id <> l_Dataset_Rec.Bsc_Measure_Group_Id) THEN
542: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;
543: ELSIF (p_Dataset_Rec.Bsc_Measure_Col <> l_Dataset_Rec.Bsc_Measure_Col) THEN
544: IF (Is_Structure_change(p_Dataset_Rec.Bsc_Measure_Col, l_Dataset_Rec.Bsc_Measure_Col)) THEN
545: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;
546: ELSE

Line 545: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;

541: IF (p_Dataset_Rec.Bsc_Measure_Group_Id <> l_Dataset_Rec.Bsc_Measure_Group_Id) THEN
542: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;
543: ELSIF (p_Dataset_Rec.Bsc_Measure_Col <> l_Dataset_Rec.Bsc_Measure_Col) THEN
544: IF (Is_Structure_change(p_Dataset_Rec.Bsc_Measure_Col, l_Dataset_Rec.Bsc_Measure_Col)) THEN
545: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;
546: ELSE
547: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update;
548: END IF;
549: END IF;

Line 547: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update;

543: ELSIF (p_Dataset_Rec.Bsc_Measure_Col <> l_Dataset_Rec.Bsc_Measure_Col) THEN
544: IF (Is_Structure_change(p_Dataset_Rec.Bsc_Measure_Col, l_Dataset_Rec.Bsc_Measure_Col)) THEN
545: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;
546: ELSE
547: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update;
548: END IF;
549: END IF;
550:
551: IF (l_kpi_flag <> -1) THEN

Line 558: BSC_DESIGNER_PVT.ActionFlag_Change(l_indicator_table(i), l_kpi_flag);

554: if indicators_cursor%ISOPEN THEN
555: CLOSE indicators_cursor;
556: end if;
557: for i in 1..l_indicator_table.count loop
558: BSC_DESIGNER_PVT.ActionFlag_Change(l_indicator_table(i), l_kpi_flag);
559: end loop;
560:
561: ELSE
562: if (p_Dataset_Rec.Bsc_Measure_Operation <> l_Dataset_Rec.Bsc_Measure_Operation or

Line 567: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update;

563: p_Dataset_Rec.Bsc_Measure_color_formula <> l_Dataset_Rec.Bsc_Measure_color_formula or
564: p_Dataset_Rec.Bsc_Dataset_Operation <> l_Dataset_Rec.Bsc_Dataset_operation or
565: p_Dataset_Rec.Bsc_Measure_Projection_Id <> l_Dataset_Rec.Bsc_Measure_Projection_Id or
566: p_Dataset_Rec.Bsc_Measure_Type <> l_Dataset_Rec.Bsc_Measure_Type) then
567: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Update;
568:
569: open indicators_cursor;
570: fetch indicators_cursor bulk collect into l_indicator_table, l_prototype_flag;
571: if indicators_cursor%ISOPEN THEN

Line 575: BSC_DESIGNER_PVT.ActionFlag_Change(l_indicator_table(i), l_kpi_flag);

571: if indicators_cursor%ISOPEN THEN
572: CLOSE indicators_cursor;
573: end if;
574: for i in 1..l_indicator_table.count loop
575: BSC_DESIGNER_PVT.ActionFlag_Change(l_indicator_table(i), l_kpi_flag);
576: end loop;
577: end if;
578: END IF;
579:

Line 1298: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;

1294: end if;
1295:
1296: if ( p_Dataset_Rec.Bsc_Measure_Id <> l_Dataset_Rec.Bsc_Measure_Id or
1297: p_Dataset_Rec.Bsc_Measure_Id2 <> l_Dataset_Rec.Bsc_Measure_Id2) then
1298: l_kpi_flag := BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure;
1299: end if;
1300:
1301: -- update LOCAL language ,source language and level Id values with PASSED values.
1302: l_Dataset_Rec.Bsc_Language := p_Dataset_Rec.Bsc_Language;

Line 1413: BSC_DESIGNER_PVT.ActionFlag_Change(l_indicator_table(i), l_kpi_flag);

1409: IF indicators_cursor%ISOPEN THEN CLOSE indicators_cursor; END IF;
1410:
1411: FOR i IN 1..l_indicator_table.COUNT LOOP
1412: IF (l_kpi_flag IS NOT NULL) THEN
1413: BSC_DESIGNER_PVT.ActionFlag_Change(l_indicator_table(i), l_kpi_flag);
1414: END IF;
1415: IF (l_color_Method_flag) THEN
1416: SELECT kpi_measure_id
1417: INTO l_kpi_measure_id

Line 1459: BSC_DESIGNER_PVT.Deflt_RefreshKpi(cd.INDICATOR);

1455:
1456: if ( l_Old_Format_id <> p_Dataset_Rec.Bsc_Dataset_Format_Id and p_Dataset_Rec.Bsc_Dataset_Format_Id is not null ) then
1457:
1458: FOR cd IN c_Default_Measure_In_Indicator LOOP
1459: BSC_DESIGNER_PVT.Deflt_RefreshKpi(cd.INDICATOR);
1460:
1461: END LOOP;
1462:
1463: end if;