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_DIMENSION_SETS_PUB dependencies on BSC_KPI_DIM_LEVELS_B

Line 611: Delete_Dim_Levels( p_commit --BSC_KPI_DIM_LEVELS_B

607: ,x_msg_data);
608: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
610: END IF;
611: Delete_Dim_Levels( p_commit --BSC_KPI_DIM_LEVELS_B
612: ,l_Dim_Set_Rec
613: ,x_return_status
614: ,x_msg_count
615: ,x_msg_data);

Line 639: Delete_Dim_Levels( p_commit --BSC_KPI_DIM_LEVELS_B

635: ,x_msg_data);
636: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
637: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
638: END IF;
639: Delete_Dim_Levels( p_commit --BSC_KPI_DIM_LEVELS_B
640: ,l_Dim_Set_Rec
641: ,x_return_status
642: ,x_msg_count
643: ,x_msg_data);

Line 1414: UPDATE BSC_KPI_DIM_LEVELS_B

1410: SAVEPOINT ReorderBSCDimLevsPUB;
1411:
1412: l_count := 0;
1413: FOR cd IN set_correct_index LOOP
1414: UPDATE BSC_KPI_DIM_LEVELS_B
1415: SET Parent_Level_Index = l_count
1416: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1417: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1418: AND Parent_Level_Index = cd.Dim_Level_Index;

Line 1421: UPDATE BSC_KPI_DIM_LEVELS_B

1417: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1418: AND Parent_Level_Index = cd.Dim_Level_Index;
1419:
1420:
1421: UPDATE BSC_KPI_DIM_LEVELS_B
1422: SET Parent_Level_Index2 = l_count
1423: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1424: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1425: AND Parent_Level_Index2 = cd.Dim_Level_Index;

Line 1433: UPDATE BSC_KPI_DIM_LEVELS_B

1429: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1430: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1431: AND Dim_Level_Index = cd.Dim_Level_Index;
1432:
1433: UPDATE BSC_KPI_DIM_LEVELS_B
1434: SET Dim_Level_Index = l_count
1435: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1436: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1437: AND Dim_Level_Index = cd.Dim_Level_Index;

Line 1552: FROM BSC_KPI_DIM_LEVELS_B A -- current

1548: , E.Relation_Type
1549: , D.Level_Pk_Col
1550: , C.Level_Table_Name
1551: , C.Source
1552: FROM BSC_KPI_DIM_LEVELS_B A -- current
1553: , BSC_KPI_DIM_LEVELS_B B -- parent
1554: , BSC_SYS_DIM_LEVELS_B C -- current
1555: , BSC_SYS_DIM_LEVELS_B D -- parent
1556: , BSC_SYS_DIM_LEVEL_RELS E

Line 1553: , BSC_KPI_DIM_LEVELS_B B -- parent

1549: , D.Level_Pk_Col
1550: , C.Level_Table_Name
1551: , C.Source
1552: FROM BSC_KPI_DIM_LEVELS_B A -- current
1553: , BSC_KPI_DIM_LEVELS_B B -- parent
1554: , BSC_SYS_DIM_LEVELS_B C -- current
1555: , BSC_SYS_DIM_LEVELS_B D -- parent
1556: , BSC_SYS_DIM_LEVEL_RELS E
1557: WHERE A.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id

Line 1579: FROM BSC_KPI_DIM_LEVELS_B A -- current

1575: , E.Relation_Type
1576: , D.Level_Pk_Col
1577: , C.Level_Table_Name
1578: , C.Source
1579: FROM BSC_KPI_DIM_LEVELS_B A -- current
1580: , BSC_KPI_DIM_LEVELS_B B -- parent
1581: , BSC_SYS_DIM_LEVELS_B C -- current
1582: , BSC_SYS_DIM_LEVELS_B D -- parent
1583: , BSC_SYS_DIM_LEVEL_RELS E

Line 1580: , BSC_KPI_DIM_LEVELS_B B -- parent

1576: , D.Level_Pk_Col
1577: , C.Level_Table_Name
1578: , C.Source
1579: FROM BSC_KPI_DIM_LEVELS_B A -- current
1580: , BSC_KPI_DIM_LEVELS_B B -- parent
1581: , BSC_SYS_DIM_LEVELS_B C -- current
1582: , BSC_SYS_DIM_LEVELS_B D -- parent
1583: , BSC_SYS_DIM_LEVEL_RELS E
1584: WHERE A.Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id

Line 1632: FROM BSC_KPI_DIM_LEVELS_B

1628: l_Dim_Set_Rec.Bsc_Dset_Position := 0;
1629:
1630: SELECT NVL(MAX(dim_level_index)+1, 0)
1631: INTO l_index_cnt
1632: FROM BSC_KPI_DIM_LEVELS_B
1633: WHERE Indicator = l_Dim_Set_Rec.Bsc_Kpi_Id
1634: AND Dim_Set_Id = l_Dim_Set_Rec.Bsc_Dim_Set_Id;
1635:
1636: FOR cd IN c_dim_levels LOOP

Line 1688: FROM BSC_KPI_DIM_LEVELS_B

1684: l_index_cnt := l_index_cnt + 1;
1685: END LOOP;
1686: FOR cd IN c_kpi_dim_set_relations LOOP
1687: SELECT COUNT(1) INTO l_Count
1688: FROM BSC_KPI_DIM_LEVELS_B
1689: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1690: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1691: AND Dim_Level_Index = cd.Dim_Level_Index
1692: AND Parent_Level_Index IS NULL;

Line 1742: FROM BSC_KPI_DIM_LEVELS_B

1738: ---//////////////Fix for the bug 5734259 //////////////////////
1739: IF (BIS_UTILITIES_PUB.Enable_Generated_Source_Report = FND_API.G_TRUE) THEN
1740: FOR cd IN c_pmf_dim_set_relations LOOP
1741: SELECT COUNT(1) INTO l_Count
1742: FROM BSC_KPI_DIM_LEVELS_B
1743: WHERE Indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1744: AND Dim_Set_Id = p_Dim_Set_Rec.Bsc_Dim_Set_Id
1745: AND Dim_Level_Index = cd.Dim_Level_Index
1746: AND Parent_Level_Index IS NULL;