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_DIM_OBJ_PUB dependencies on BSC_BIS_DIMENSION_PUB

Line 63: REM | BSC_BIS_KPI_MEAS_PUB to BSC_BIS_DIMENSION_PUB |

59: REM |25-AUG-2004 visuri Modified Initialize_Bsc_Recs() and |
60: REM | Update_Dim_Object() for bug#3842366 |
61: REM | 17-AUG-2004 wleung modified Bug#3784852 Assign_Unassign_Dimensions |
62: REM | 09-SEP-2004 visuri Shifted Remove_Empty_Dims_For_DimSet() from |
63: REM | BSC_BIS_KPI_MEAS_PUB to BSC_BIS_DIMENSION_PUB |
64: REM | 14-SEP-2004 KYADAMAK added function get_valid_ddlentry_frm_name() |
65: REM | 08-OCT-2004 rpenneru added Modified for bug#3939995 |
66: REM | 21-OCT-2004 akoduri added Modified for bug#3930280 |
67: REM | 03-FEB-2005 kyadamak modified for the bug#4091924 |

Line 428: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);

424: OPEN c_Bis_Levels;
425: FETCH c_Bis_Levels
426: INTO l_Dim_Short_Name;
427: CLOSE c_Bis_Levels;
428: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
429: l_Bsc_Dim_Obj_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
430:
431: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP
432: SET Total_Flag = p_All_Enabled

Line 534: AND dim_group_id = BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(p_Dim_Short_Name);

530: IF (p_Dim_Short_Name IS NOT NULL) THEN -- Update Mode
531: UPDATE bsc_sys_dim_levels_by_group
532: SET total_flag = p_All_Enabled
533: WHERE dim_level_id = BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name)
534: AND dim_group_id = BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(p_Dim_Short_Name);
535: ELSE -- Create Mode
536: UPDATE bsc_sys_dim_levels_by_group
537: SET total_flag = p_All_Enabled
538: WHERE dim_level_id = BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);

Line 721: BSC_BIS_DIMENSION_PUB.Create_Dimension

717:
718: -- Create Dimension if p_Force_Dimension_Create = 'T' (AG)
719: IF (p_Force_Dimension_Create = 'T') THEN
720:
721: BSC_BIS_DIMENSION_PUB.Create_Dimension
722: ( p_commit => FND_API.G_FALSE
723: , p_dim_short_name => p_dim_short_names
724: , p_display_name => p_display_name
725: , p_description => p_description

Line 1106: l_bis_dim_level_rec.Dimension_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;

1102: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: END IF;
1105: ELSE
1106: l_bis_dim_level_rec.Dimension_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;
1107: END IF;
1108: -- End Granular Locking
1109: --BSC_SYS_DIM_LEVELS_B.dim_level_id
1110: l_bsc_dim_obj_rec.Bsc_Level_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value('BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID');

Line 1388: , p_dim_short_names => BSC_BIS_DIMENSION_PUB.Unassigned_Dim

1384: IF (l_bsc_dim_obj_rec.Bsc_Source = 'PMF') THEN
1385: BSC_BIS_DIM_OBJ_PUB.Assign_Dimensions
1386: ( p_commit => FND_API.G_FALSE
1387: , p_dim_obj_short_name => l_dim_obj_name
1388: , p_dim_short_names => BSC_BIS_DIMENSION_PUB.Unassigned_Dim
1389: , x_return_status => x_return_status
1390: , x_msg_count => x_msg_count
1391: , x_msg_data => x_msg_data
1392: );

Line 1413: , p_unassign_dim_short_names => BSC_BIS_DIMENSION_PUB.Unassigned_Dim

1409: BSC_BIS_DIM_OBJ_PUB.Assign_Unassign_Dimensions
1410: ( p_commit => FND_API.G_FALSE
1411: , p_dim_obj_short_name => l_dim_obj_name
1412: , p_assign_dim_short_names => p_dim_short_names
1413: , p_unassign_dim_short_names => BSC_BIS_DIMENSION_PUB.Unassigned_Dim
1414: , p_Restrict_Dim_Validate => p_Restrict_Dim_Validate
1415: , x_return_status => x_return_status
1416: , x_msg_count => x_msg_count
1417: , x_msg_data => x_msg_data

Line 1593: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects

1589: WHERE A.Dim_Group_Id = l_dim_grp_id
1590: AND A.Dim_Level_Id = B.Dim_Level_Id
1591: AND B.Short_Name = p_dim_obj_short_name;
1592: IF (l_count = 0) THEN
1593: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects
1594: ( p_commit => FND_API.G_FALSE
1595: , p_dim_short_name => l_dim_name
1596: , p_dim_obj_short_names => p_dim_obj_short_name
1597: , p_time_stamp => NULL

Line 1686: BSC_BIS_DIMENSION_PUB.Unassign_Dimension_Objects

1682: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1684: END IF;
1685: -- Granular Locking - Set the timestamp of Dimension Group
1686: BSC_BIS_DIMENSION_PUB.Unassign_Dimension_Objects
1687: ( p_commit => FND_API.G_FALSE
1688: , p_dim_short_name => l_dim_name
1689: , p_dim_obj_short_names => p_dim_obj_short_name
1690: , x_return_status => x_return_status

Line 1857: IF (l_unassign <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN

1853: ELSE
1854: l_unassign_dims := l_unassign_dims||', '||l_unassign;
1855: END IF;
1856:
1857: IF (l_unassign <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
1858:
1859: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(l_unassign||'+'||p_dim_obj_short_name);
1860: IF(l_regions IS NOT NULL) THEN
1861: SELECT DIM_NAME

Line 1924: BSC_BIS_DIMENSION_PUB.Remove_Empty_Dims_For_DimSet

1920: END IF;
1921: END IF;
1922: -- Bug 3784852 validate empty dimension after unassign/assign dim objs. Remove empty from dim sets for all objectives
1923: IF (p_unassign_dim_short_names IS NOT NULL) THEN
1924: BSC_BIS_DIMENSION_PUB.Remove_Empty_Dims_For_DimSet
1925: ( p_commit => FND_API.G_FALSE
1926: , p_dim_short_names => p_unassign_dim_short_names
1927: , x_return_status => x_return_status
1928: , x_msg_count => x_msg_count

Line 2354: l_bis_dim_level_rec.Dimension_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;

2350: l_Dim_Tab(l_index) := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_Grp_name), -1);
2351: l_index := l_index + 1;
2352: END LOOP;
2353: ELSE
2354: l_bis_dim_level_rec.Dimension_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;
2355: END IF;
2356: IF ((NOT l_dim_exist) AND (NOT l_first)) THEN
2357: l_bis_dim_level_rec.Dimension_Short_Name := l_first_dim_short_name;
2358: END IF;

Line 2743: IF (l_primary_dim_sht_name IS NOT NULL AND l_primary_dim_sht_name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN

2739: END IF;
2740: END IF;
2741:
2742: l_primary_dim_sht_name := Retrieve_Primary_Dimension(l_dim_obj_name);
2743: IF (l_primary_dim_sht_name IS NOT NULL AND l_primary_dim_sht_name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
2744: -- Bug 4997042
2745: BSC_BIS_DIM_OBJ_PUB.Cascade_Dim_Props_Into_Dim_Grp (
2746: p_Dim_Obj_Short_Name => l_dim_obj_name
2747: , p_Dim_Short_Name => l_primary_dim_sht_name

Line 3308: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;

3304: IF (l_bsc_dim_obj_rec.Bsc_Source = 'BSC') THEN
3305: BSC_DESIGNER_PVT.Dim_Object_Change(l_bsc_dim_obj_rec.Bsc_Level_Id);
3306: END IF;
3307: --remove association with unassigned Dimension if exists
3308: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;
3309: l_bsc_dimension_rec.Bsc_Level_Id := l_bsc_dim_obj_rec.Bsc_Level_Id;
3310: BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group
3311: ( p_commit => FND_API.G_FALSE
3312: , p_Dim_Grp_Rec => l_bsc_dimension_rec

Line 3456: l_dim_Group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);

3452: BEGIN
3453: FND_MSG_PUB.Initialize;
3454: x_return_status := FND_API.G_RET_STS_SUCCESS;
3455:
3456: l_dim_Group_id := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(BSC_BIS_DIMENSION_PUB.Unassigned_Dim);
3457: IF (p_dim_obj_short_name IS NULL) THEN
3458: FND_MESSAGE.SET_NAME('BSC','BSC_REQ_FIELD_MISSING');
3459: FND_MESSAGE.SET_TOKEN('FIELD_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'), TRUE);
3460: FND_MSG_PUB.ADD;

Line 6794: IF ((l_dim_short_name = BSC_BIS_DIMENSION_PUB.Unassigned_Dim) AND

6790: l_dim_obj_name := cd.name;
6791: IF(l_source IS NULL) THEN
6792: l_source := CD.SOURCE;
6793: END IF;
6794: IF ((l_dim_short_name = BSC_BIS_DIMENSION_PUB.Unassigned_Dim) AND
6795: (l_source = 'BSC')) THEN
6796: EXIT;
6797: END IF;
6798: IF((l_source <> CD.SOURCE)OR (l_source <> p_dim_obj_source)) THEN

Line 6822: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.is_Valid_Dim_Grp_Rels ';

6818: EXCEPTION
6819: WHEN OTHERS THEN
6820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6821: IF (x_msg_data IS NULL) THEN
6822: x_msg_data := SQLERRM||' at BSC_BIS_DIMENSION_PUB.is_Valid_Dim_Grp_Rels ';
6823: END IF;
6824:
6825: RETURN l_true;
6826: END check_sametype_dims;

Line 7265: AND dim_group_id = BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);

7261: SET
7262: total_flag = p_All_Flag
7263: WHERE
7264: dim_level_id = BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name)
7265: AND dim_group_id = BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
7266: END LOOP;
7267: END IF;
7268: EXCEPTION
7269: WHEN OTHERS THEN