eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_BIS_KPI_MEAS_PUB dependencies on BSC_DESIGNER_PVT

Line 777: , p_kpi_flag_change => BSC_DESIGNER_PVT.G_ActionFlag.Normal

773: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet
774: ( p_commit => FND_API.G_FALSE
775: , p_kpi_id => p_kpi_id
776: , p_dim_set_id => p_dim_set_id
777: , p_kpi_flag_change => BSC_DESIGNER_PVT.G_ActionFlag.Normal
778: , p_delete => TRUE
779: , x_return_status => x_return_status
780: , x_msg_count => x_msg_count
781: , x_msg_data => x_msg_data

Line 2464: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

2460: -- Deleting the Dimension set involves a structural change to be captured by Optimizer.
2461: -- The following changes the action_flag for the currently affected KPI only
2462: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
2463: IF (NOT BSC_BIS_KPI_MEAS_PUB.is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN
2464: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
2465: END IF;
2466: BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset
2467: ( p_commit => FND_API.G_FALSE
2468: , p_Dim_Set_Rec => l_bsc_dimset_rec

Line 2500: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: END IF;
2498: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
2499: IF (NOT BSC_BIS_KPI_MEAS_PUB.is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN
2500: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
2501: END IF;
2502: BSC_DIMENSION_SETS_PUB.Delete_Dim_Group_In_Dset
2503: ( p_commit => FND_API.G_FALSE
2504: , p_Dim_Set_Rec => l_bsc_dimset_rec

Line 2720: -- BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

2716: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2717: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Assign_Dims_To_Dim_Set');
2718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2719: END IF;
2720: -- BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
2721: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Grp_Lev_In_Dset
2722: ( p_commit => FND_API.G_FALSE
2723: , p_kpi_id => p_kpi_id
2724: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id

Line 2774: --BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

2770: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2771: --dbms_output.PUT_LINE('BSC_BIS_LOCKS_PUB.LOCK_DIM_SET - Assign_Dims_To_Dim_Set');
2772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2773: END IF;
2774: --BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
2775: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Grp_Lev_In_Dset
2776: ( p_commit => FND_API.G_FALSE
2777: , p_kpi_id => l_bsc_dimset_rec.Bsc_Kpi_Id
2778: , p_dim_set_id => l_bsc_dimset_rec.bsc_dim_set_id

Line 3211: --BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

3207: l_dim_short_names := p_dim_short_names;
3208: -- Aditya added for Incremental Changes
3209: -- Deleting a Dimension from a Dimension Set should be flagged as a Strucutural change
3210: -- for the KPI under consideration only.
3211: --BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
3212: WHILE (Is_More( p_dim_short_names => l_dim_short_names
3213: , p_dim_short_name => l_dim_short_name)
3214: ) LOOP
3215: SELECT COUNT(*) INTO l_count

Line 3265: --BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

3261: IF(p_dim_short_names IS NOT NULL) THEN
3262: l_count := 0;
3263: l_dim_short_names := p_dim_short_names;
3264: -- Aditya added for Incremental Changes
3265: --BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
3266: WHILE (Is_More( p_dim_short_names => l_dim_short_names
3267: , p_dim_short_name => l_dim_short_name)
3268: ) LOOP
3269: SELECT COUNT(*) INTO l_count

Line 3735: BSC_DESIGNER_PVT.Deflt_Update_AOPTS(l_bsc_dimset_rec.Bsc_Kpi_Id);

3731: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Assign_DSet_Analysis_Options Failed: at BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B <'||x_msg_data||'>');
3732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3733: END IF;
3734: --copied from VB Code
3735: BSC_DESIGNER_PVT.Deflt_Update_AOPTS(l_bsc_dimset_rec.Bsc_Kpi_Id);
3736: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
3737: --repeat the steps above for all the shared indicators
3738: FOR cd IN c_kpi_ids LOOP
3739: l_bsc_dimset_rec.Bsc_Kpi_Id := cd.indicator;

Line 3736: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

3732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3733: END IF;
3734: --copied from VB Code
3735: BSC_DESIGNER_PVT.Deflt_Update_AOPTS(l_bsc_dimset_rec.Bsc_Kpi_Id);
3736: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
3737: --repeat the steps above for all the shared indicators
3738: FOR cd IN c_kpi_ids LOOP
3739: l_bsc_dimset_rec.Bsc_Kpi_Id := cd.indicator;
3740: --dbms_output.PUT_LINE('Within Shared Indicator Loop KPI_ID is <'||l_bsc_dimset_rec.Bsc_Kpi_Id||'>');

Line 3762: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

3758: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3759: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Assign_DSet_Analysis_Options Failed: at BSC_DIMENSION_SETS_PUB.Update_Kpi_Analysis_Options_B <'||x_msg_data||'>');
3760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3761: END IF;
3762: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
3763: END LOOP;
3764: END IF;
3765: IF (p_commit = FND_API.G_TRUE) THEN
3766: COMMIT;

Line 4670: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);

4666: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4667: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
4668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4669: END IF;
4670: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4671: FOR cd IN c_kpi_ids LOOP
4672: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
4673: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4674: END LOOP;

Line 4673: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);

4669: END IF;
4670: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4671: FOR cd IN c_kpi_ids LOOP
4672: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
4673: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
4674: END LOOP;
4675:
4676: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
4677: (

Line 4883: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

4879: END IF;
4880: --ADDED BY PETER
4881: -- If the data set is changed, we need to flag it as a structural change (3169904)
4882: IF (l_old_data_set_id <> l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id) THEN
4883: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
4884: FOR cd IN c_kpi_ids LOOP
4885: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
4886: BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
4887: END LOOP;

Line 4886: BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

4882: IF (l_old_data_set_id <> l_Bsc_Anal_Opt_Rec.Bsc_Dataset_Id) THEN
4883: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
4884: FOR cd IN c_kpi_ids LOOP
4885: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
4886: BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
4887: END LOOP;
4888: END IF;
4889: --END BY PETER
4890: -- START Granular Locking added by Aditya

Line 5207: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);

5203: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5204: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Update_KPI_Analysis_Options Failed: at BSC_ANALYSIS_OPTION_PUB.Update_Analysis_Options');
5205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5206: END IF;
5207: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5208: FOR cd IN c_kpi_ids LOOP
5209: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
5210: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5211: END LOOP;

Line 5210: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);

5206: END IF;
5207: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5208: FOR cd IN c_kpi_ids LOOP
5209: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
5210: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id);
5211: END LOOP;
5212: ELSE
5213: SELECT COUNT(Option_Id) + 1
5214: INTO l_Bsc_Anal_Opt_Rec.Bsc_Option_Group0

Line 5261: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

5257: FROM BSC_KPIS_B
5258: WHERE INDICATOR = p_kpi_id ;
5259:
5260: IF ((l_datasource = 'BSC') OR (l_sname IS NOT NULL)) THEN
5261: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
5262: FOR cd IN c_kpi_ids LOOP
5263: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
5264: BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
5265: END LOOP;

Line 5264: BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

5260: IF ((l_datasource = 'BSC') OR (l_sname IS NOT NULL)) THEN
5261: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
5262: FOR cd IN c_kpi_ids LOOP
5263: l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id := cd.indicator;
5264: BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
5265: END LOOP;
5266:
5267: END IF;
5268:

Line 5480: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

5476: FROM BSC_KPI_ANALYSIS_MEASURES_B
5477: WHERE INDICATOR=p_kpi_id;
5478: IF (l_count <> l_new_count) THEN
5479: -- fixed bug#3136769
5480: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
5481: END IF;
5482: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := p_kpi_id;
5483: BSC_KPI_PUB.Update_Kpi_Time_Stamp
5484: ( p_commit => FND_API.G_FALSE

Line 5918: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

5914: -- Fixed Bug#3663301, Called ActionFlag_Change with a Color Flag
5915: IF (l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Default_Value IS NOT NULL) THEN
5916: IF(BSC_ANALYSIS_OPTION_PUB.Default_Anal_Option_Changed(l_Anal_Num_Tbl,l_Old_Anal_Num_Tbl))THEN
5917:
5918: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5919:
5920: SELECT kpi_measure_id
5921: INTO l_kpi_measure_id
5922: FROM bsc_kpi_analysis_measures_vl

Line 5956: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

5952: );
5953:
5954: END IF;
5955:
5956: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
5957: FOR cd IN c_kpi_ids LOOP
5958: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := cd.indicator;
5959: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5960: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

Line 5959: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

5955:
5956: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
5957: FOR cd IN c_kpi_ids LOOP
5958: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := cd.indicator;
5959: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5960: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
5961: END LOOP;
5962:
5963: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button

Line 5960: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

5956: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
5957: FOR cd IN c_kpi_ids LOOP
5958: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := cd.indicator;
5959: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5960: --BSC_DESIGNER_PVT.ActionFlag_Change(l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
5961: END LOOP;
5962:
5963: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
5964: (

Line 6471: IF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.Normal)) THEN

6467: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_DIMENSION_SETS_PUB.Create_Dim_Levels <'||x_msg_data||'>');
6468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6469: END IF;
6470: END LOOP;
6471: IF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.Normal)) THEN
6472: --do not flag any changes to KPIs
6473: NULL;
6474: --dbms_output.PUT_LINE('NO CHANGES');
6475: ELSIF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color)) THEN

Line 6475: ELSIF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color)) THEN

6471: IF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.Normal)) THEN
6472: --do not flag any changes to KPIs
6473: NULL;
6474: --dbms_output.PUT_LINE('NO CHANGES');
6475: ELSIF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color)) THEN
6476: --flag color changes to KPIs
6477: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
6478: IF (NOT BSC_BIS_KPI_MEAS_PUB.is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN
6479: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

Line 6479: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

6475: ELSIF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color)) THEN
6476: --flag color changes to KPIs
6477: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
6478: IF (NOT BSC_BIS_KPI_MEAS_PUB.is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN
6479: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
6480: END IF;
6481: --dbms_output.PUT_LINE('COLOR CHANGES');
6482: ELSE
6483: --flag structural changes to KPIs

Line 6486: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

6482: ELSE
6483: --flag structural changes to KPIs
6484: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
6485: IF (NOT is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN
6486: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
6487: END IF;
6488: --dbms_output.PUT_LINE('STRUCTURAL CHANGES');
6489: END IF;
6490: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

Line 6556: IF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.Normal)) THEN

6552: --dbms_output.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet Failed: at BSC_DIMENSION_SETS_PUB.Create_Dim_Levels <'||x_msg_data||'>');
6553: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6554: END IF;
6555: END LOOP;
6556: IF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.Normal)) THEN
6557: --do not flag any changes to KPIs
6558: NULL;
6559: --dbms_output.PUT_LINE('NO CHANGES');
6560: ELSIF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color)) THEN

Line 6560: ELSIF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color)) THEN

6556: IF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.Normal)) THEN
6557: --do not flag any changes to KPIs
6558: NULL;
6559: --dbms_output.PUT_LINE('NO CHANGES');
6560: ELSIF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color)) THEN
6561: --flag color changes to KPIs
6562: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
6563: IF (NOT BSC_BIS_KPI_MEAS_PUB.is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN
6564: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

Line 6564: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);

6560: ELSIF ((p_kpi_flag_change IS NOT NULL) AND (p_kpi_flag_change = BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color)) THEN
6561: --flag color changes to KPIs
6562: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
6563: IF (NOT BSC_BIS_KPI_MEAS_PUB.is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN
6564: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Color);
6565: END IF;
6566: --dbms_output.PUT_LINE('COLOR CHANGES');
6567: ELSE
6568: --flag structural changes to KPIs

Line 6571: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

6567: ELSE
6568: --flag structural changes to KPIs
6569: --IF (NVL(BSC_BIS_KPI_MEAS_PUB.get_DimensionSetSource(l_bsc_dimset_rec.Bsc_Kpi_Id,l_bsc_dimset_rec.Bsc_Dim_Set_Id), 'BSC') = 'BSC') THEN
6570: IF (NOT BSC_BIS_KPI_MEAS_PUB.is_Pure_Pmf_Dim_Grp(l_bsc_dimset_rec.Bsc_Kpi_Id, l_bsc_dimset_rec.Bsc_Dim_Set_Id)) THEN
6571: BSC_DESIGNER_PVT.ActionFlag_Change(l_bsc_dimset_rec.Bsc_Kpi_Id , BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
6572: END IF;
6573: --dbms_output.PUT_LINE('STRUCTURAL CHANGES');
6574: END IF;
6575: BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DIM_SET

Line 7674: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

7670:
7671: l_new_count := get_Struct_Meas_Count(p_kpi_id);
7672:
7673: IF (l_count <> l_new_count) THEN
7674: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
7675: END IF;
7676: BSC_DESIGNER_PVT.Deflt_RefreshKpi(p_kpi_id);
7677:
7678: FOR cd IN c_kpi_ids LOOP

Line 7676: BSC_DESIGNER_PVT.Deflt_RefreshKpi(p_kpi_id);

7672:
7673: IF (l_count <> l_new_count) THEN
7674: BSC_DESIGNER_PVT.ActionFlag_Change(p_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
7675: END IF;
7676: BSC_DESIGNER_PVT.Deflt_RefreshKpi(p_kpi_id);
7677:
7678: FOR cd IN c_kpi_ids LOOP
7679: l_kpi_id := cd.indicator;
7680: BSC_ANALYSIS_OPTION_PUB.Synch_Kpi_Anal_Group

Line 7697: BSC_DESIGNER_PVT.ActionFlag_Change(l_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);

7693: SELECT COUNT (DISTINCT dataset_id) INTO l_new_count
7694: FROM BSC_KPI_ANALYSIS_MEASURES_B
7695: WHERE INDICATOR = l_kpi_id;
7696: IF (l_count <> l_new_count) THEN
7697: BSC_DESIGNER_PVT.ActionFlag_Change(l_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
7698: END IF;
7699: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_kpi_id);
7700: END LOOP;
7701:

Line 7699: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_kpi_id);

7695: WHERE INDICATOR = l_kpi_id;
7696: IF (l_count <> l_new_count) THEN
7697: BSC_DESIGNER_PVT.ActionFlag_Change(l_kpi_id, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
7698: END IF;
7699: BSC_DESIGNER_PVT.Deflt_RefreshKpi(l_kpi_id);
7700: END LOOP;
7701:
7702: BSC_COMMON_DIM_LEVELS_PUB.Validate_List_Button
7703: (