[Home] [Help]
14: REM | |
15: REM | NOTES |
16: REM | 02-MAY-2003 PAJOHRI Created. |
17: REM | 17-JUL-2003 ADRAO Bug#3054935 Changed following procedures |
18: REM | BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet() |
19: REM | BSC_BIS_KPI_MEAS_PUB.UnCreate_Dim_Objs_In_DSet() |
20: REM | to use 'NULL' timestamp |
21: REM | 18-JUL-2003 PAJOHRI Bug #3053521 |
22: REM | 22-JUL-2003 ADRAO Bug #3034094 - Fixed in Update_Dimension |
15: REM | NOTES |
16: REM | 02-MAY-2003 PAJOHRI Created. |
17: REM | 17-JUL-2003 ADRAO Bug#3054935 Changed following procedures |
18: REM | BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet() |
19: REM | BSC_BIS_KPI_MEAS_PUB.UnCreate_Dim_Objs_In_DSet() |
20: REM | to use 'NULL' timestamp |
21: REM | 18-JUL-2003 PAJOHRI Bug #3053521 |
22: REM | 22-JUL-2003 ADRAO Bug #3034094 - Fixed in Update_Dimension |
23: REM | 30-JUL-2003 PAJOHRI Bug #3075316, 3073486 |
48: REM | 17-AUG-2004 wleung modified Bug#3784852 on Assign_Unassign_Dim_Objs |
49: REM | 08-SEP-2004 visuri Added Dim_With_Single_Dim_Obj() and |
50: REM | Is_Dim_Empty() for bug #3784852 |
51: REM | 09-SEP-2004 visuri Shifted Remove_Empty_Dims_For_DimSet() from |
52: REM | BSC_BIS_KPI_MEAS_PUB for bug #3784852 |
53: REM | 08-OCT-2004 rpenneru added Modified for bug#3939995 |
54: REM | 27-OCT-2004 sawu Bug#3947903: added Is_Objective_Assigned() |
55: REM | 08-Feb-05 ankgoel Enh#4172034 DD Seeding by Product Teams |
56: REM | 02-Mar-05 ppandey Bug#4211876 Prmary Dim provided for |
619: , x_msg_data OUT NOCOPY VARCHAR2
620: ) IS
621: BEGIN
622: FOR i IN 0..(p_MTab_Tbl.COUNT-1) LOOP
623: BSC_BIS_KPI_MEAS_PUB.Delete_Dim_Objs_In_DSet
624: ( p_commit => FND_API.G_FALSE
625: , p_kpi_id => p_MTab_Tbl(i).p_kpi_id
626: , p_dim_set_id => p_MTab_Tbl(i).p_dim_set_id
627: , x_return_status => x_return_status
643: , x_msg_data OUT NOCOPY VARCHAR2
644: ) IS
645: BEGIN
646: FOR i IN 0..(p_MTab_Tbl.COUNT-1) LOOP
647: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet
648: ( p_commit => FND_API.G_FALSE
649: , p_kpi_id => p_MTab_Tbl(i).p_kpi_id
650: , p_dim_set_id => p_MTab_Tbl(i).p_dim_set_id
651: , p_kpi_flag_change => p_kpi_flag_change
691: p_indicator => p_MTab_Tbl(i).p_kpi_id,
692: p_dim_obj_objs_tbl => p_dim_obj_objs_tbl
693: );
694:
695: BSC_BIS_KPI_MEAS_PUB.Create_Dim_Objs_In_DSet
696: ( p_commit => FND_API.G_FALSE
697: , p_kpi_id => p_MTab_Tbl(i).p_kpi_id
698: , p_dim_set_id => p_MTab_Tbl(i).p_dim_set_id
699: , p_kpi_flag_change => l_kpi_flag_change
4182: WHILE(Is_More(p_dim_obj_short_names=>l_dim_obj_short_names,p_dim_obj_name=> l_dim_short_name)) LOOP
4183: l_count_dim_objs:= l_count_dim_objs +1;
4184: END LOOP;
4185:
4186: IF(l_count_dim_objs > BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim) THEN
4187: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
4188: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4189: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4190: FND_MSG_PUB.ADD;
4266:
4267: END IF;
4268: END LOOP;
4269:
4270: IF(( (dim_objs_array.COUNT)+l_plus_count-l_minus_count ) > BSC_BIS_KPI_MEAS_PUB.Config_Limit_Dim ) THEN
4271:
4272: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_IMPACT_KPI_SPACE');
4273: FND_MESSAGE.SET_TOKEN('CONTINUE', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'YES'), TRUE);
4274: FND_MESSAGE.SET_TOKEN('CANCEL', BSC_APPS.Get_Lookup_Value('BSC_UI_KPIDESIGNER', 'NO'), TRUE);
4484: IF (l_count =0) THEN
4485: -- Cascading unassign empty dimension from Objectives-dim sets
4486: FOR cd IN c_dim_set_kpi LOOP
4487:
4488: BSC_BIS_KPI_MEAS_PUB.Unassign_Dims_From_Dim_Set
4489: ( p_commit => FND_API.G_FALSE
4490: , p_kpi_id => cd.Indicator
4491: , p_dim_set_id => cd.Dim_Set_Id
4492: , p_dim_short_names => l_dim_short_name