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_UTILITY

Line 65: REM | 10-OCT-2004 ashankar Moved Parse_Base_Periods to BSC_UTILITY package |

61: REM | Bug #3784852 |
62: REM | 29-SEP-2004 ashankar added modules is_Period_Circular, |
63: REM | Parse_Base_Periods and Find_Period_CircularRef |
64: REM | for bug#3908204 |
65: REM | 10-OCT-2004 ashankar Moved Parse_Base_Periods to BSC_UTILITY package |
66: REM | and renamed it to Parse_String to make it Generic|
67: REM | enough.This was done as per the review comment |
68: REM | 18-JAN-2005 WLEUNG bug 4036171 fix Get_Default_Viewby_For_Measure |
69: REM | 21-FEB-2005 ankagarw enh# 3862703 |

Line 1574: BSC_UTILITY.Enable_Dimensions_Entity(

1570: FND_MSG_PUB.ADD;
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574: BSC_UTILITY.Enable_Dimensions_Entity(
1575: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1576: , p_Entity_Short_Names => p_dim_short_names
1577: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1578: , x_Return_Status => x_return_status

Line 1575: p_Entity_Type => BSC_UTILITY.c_DIMENSION

1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574: BSC_UTILITY.Enable_Dimensions_Entity(
1575: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1576: , p_Entity_Short_Names => p_dim_short_names
1577: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1578: , x_Return_Status => x_return_status
1579: , x_Msg_Count => x_msg_count

Line 1577: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE

1573:
1574: BSC_UTILITY.Enable_Dimensions_Entity(
1575: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1576: , p_Entity_Short_Names => p_dim_short_names
1577: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1578: , x_Return_Status => x_return_status
1579: , x_Msg_Count => x_msg_count
1580: , x_Msg_Data => x_msg_data
1581: );

Line 1741: IF(l_count_independent_dim_obj > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

1737: FROM BSC_KPI_DIM_LEVELS_B
1738: WHERE INDICATOR = p_kpi_id
1739: AND DIM_SET_ID = l_bsc_dimset_rec.bsc_dim_set_id;
1740:
1741: IF(l_count_independent_dim_obj > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
1742:
1743: l_count_independent_dim_obj := 0;
1744: l_count_independent_dim_obj := bsc_utility.get_nof_independent_dimobj
1745: ( p_Kpi_Id => p_Kpi_Id

Line 1744: l_count_independent_dim_obj := bsc_utility.get_nof_independent_dimobj

1740:
1741: IF(l_count_independent_dim_obj > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
1742:
1743: l_count_independent_dim_obj := 0;
1744: l_count_independent_dim_obj := bsc_utility.get_nof_independent_dimobj
1745: ( p_Kpi_Id => p_Kpi_Id
1746: , p_Dim_Set_Id => l_bsc_dimset_rec.bsc_dim_set_id
1747: );
1748: IF(l_count_independent_dim_obj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

Line 1748: IF(l_count_independent_dim_obj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

1744: l_count_independent_dim_obj := bsc_utility.get_nof_independent_dimobj
1745: ( p_Kpi_Id => p_Kpi_Id
1746: , p_Dim_Set_Id => l_bsc_dimset_rec.bsc_dim_set_id
1747: );
1748: IF(l_count_independent_dim_obj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
1749: SELECT NAME INTO l_kpi_name
1750: FROM BSC_KPIS_VL
1751: WHERE INDICATOR = p_Kpi_Id;
1752:

Line 1844: BSC_UTILITY.Enable_Dimensions_Entity(

1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842:
1843: -- added for Bug#4615361
1844: BSC_UTILITY.Enable_Dimensions_Entity(
1845: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1846: , p_Entity_Short_Names => p_assign_dim_names
1847: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1848: , x_Return_Status => x_return_status

Line 1845: p_Entity_Type => BSC_UTILITY.c_DIMENSION

1841: END IF;
1842:
1843: -- added for Bug#4615361
1844: BSC_UTILITY.Enable_Dimensions_Entity(
1845: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1846: , p_Entity_Short_Names => p_assign_dim_names
1847: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1848: , x_Return_Status => x_return_status
1849: , x_Msg_Count => x_msg_count

Line 1847: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE

1843: -- added for Bug#4615361
1844: BSC_UTILITY.Enable_Dimensions_Entity(
1845: p_Entity_Type => BSC_UTILITY.c_DIMENSION
1846: , p_Entity_Short_Names => p_assign_dim_names
1847: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1848: , x_Return_Status => x_return_status
1849: , x_Msg_Count => x_msg_count
1850: , x_Msg_Data => x_msg_data
1851: );

Line 1896: IF(l_count_independent_dim_obj > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

1892: FROM BSC_KPI_DIM_LEVELS_B
1893: WHERE INDICATOR = p_kpi_id
1894: AND DIM_SET_ID = p_dim_set_id;
1895:
1896: IF(l_count_independent_dim_obj > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
1897:
1898: l_count_independent_dim_obj := 0;
1899: l_count_independent_dim_obj := bsc_utility.get_nof_independent_dimobj
1900: ( p_Kpi_Id => p_kpi_id

Line 1899: l_count_independent_dim_obj := bsc_utility.get_nof_independent_dimobj

1895:
1896: IF(l_count_independent_dim_obj > bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
1897:
1898: l_count_independent_dim_obj := 0;
1899: l_count_independent_dim_obj := bsc_utility.get_nof_independent_dimobj
1900: ( p_Kpi_Id => p_kpi_id
1901: , p_Dim_Set_Id => p_dim_set_id
1902: );
1903:

Line 1904: IF(l_count_independent_dim_obj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN

1900: ( p_Kpi_Id => p_kpi_id
1901: , p_Dim_Set_Id => p_dim_set_id
1902: );
1903:
1904: IF(l_count_independent_dim_obj >bsc_utility.NO_IND_DIM_OBJ_LIMIT) THEN
1905: SELECT NAME INTO l_kpi_name
1906: FROM BSC_KPIS_VL
1907: WHERE INDICATOR = p_Kpi_Id;
1908:

Line 2033: BSC_UTILITY.Enable_Dimensions_Entity(

2029: END IF;
2030: END IF;
2031: END LOOP;
2032:
2033: BSC_UTILITY.Enable_Dimensions_Entity(
2034: p_Entity_Type => BSC_UTILITY.c_DIMENSION
2035: , p_Entity_Short_Names => p_dim_short_names
2036: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
2037: , x_Return_Status => x_return_status

Line 2034: p_Entity_Type => BSC_UTILITY.c_DIMENSION

2030: END IF;
2031: END LOOP;
2032:
2033: BSC_UTILITY.Enable_Dimensions_Entity(
2034: p_Entity_Type => BSC_UTILITY.c_DIMENSION
2035: , p_Entity_Short_Names => p_dim_short_names
2036: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
2037: , x_Return_Status => x_return_status
2038: , x_Msg_Count => x_msg_count

Line 2036: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE

2032:
2033: BSC_UTILITY.Enable_Dimensions_Entity(
2034: p_Entity_Type => BSC_UTILITY.c_DIMENSION
2035: , p_Entity_Short_Names => p_dim_short_names
2036: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
2037: , x_Return_Status => x_return_status
2038: , x_Msg_Count => x_msg_count
2039: , x_Msg_Data => x_msg_data
2040: );

Line 5687: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(l_dim_shortName, BSC_UTILITY.c_DIMENSION);

5683: OPEN c_dim_short_name(l_dim_group_id);
5684: FETCH c_dim_short_name INTO l_dim_shortName;
5685: CLOSE c_dim_short_name;
5686: --delete the imported dimensions if it is not used in any report
5687: l_regions := BSC_UTILITY.Is_Dim_In_AKReport(l_dim_shortName, BSC_UTILITY.c_DIMENSION);
5688: IF(l_regions IS NULL AND l_dim_shortName IS NOT NULL) THEN
5689: BSC_BIS_DIMENSION_PUB.Delete_Dimension
5690: ( p_commit => FND_API.G_FALSE
5691: , p_dim_short_name => l_dim_shortName

Line 6868: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN

6864: FND_MSG_PUB.Initialize;
6865: IF (p_Kpi_ID IS NULL) THEN
6866: RETURN NULL;
6867: END IF;
6868: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN
6869: RETURN NULL;
6870: END IF;
6871: IF (p_Dim_Set_ID IS NOT NULL) THEN
6872: SELECT COUNT(*) INTO l_Count

Line 6971: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN

6967: l_Dim_Short_Names := p_Dim_Short_Names;
6968: IF (p_Kpi_ID IS NULL) THEN
6969: RETURN NULL;
6970: END IF;
6971: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN
6972: RETURN NULL;
6973: END IF;
6974: l_unassign_dim_objs := NULL;
6975: IF (p_Dim_Set_ID IS NOT NULL) THEN

Line 7797: l_period_values BSC_UTILITY.varchar_tabletype;

7793:
7794: l_baseperiod BSC_SYS_PERIODICITIES.periodicity_id%TYPE;
7795: l_count NUMBER;
7796: l_Source BSC_SYS_PERIODICITIES.Source%TYPE;
7797: l_period_values BSC_UTILITY.varchar_tabletype;
7798: l_period_number NUMBER;
7799: l_temp BOOLEAN;
7800:
7801: BEGIN

Line 7818: BSC_UTILITY.Parse_String

7814: IF((l_Source IS NULL) OR (LENGTH(TRIM(l_Source))=0))THEN
7815: RETURN FALSE;
7816: END IF;
7817:
7818: BSC_UTILITY.Parse_String
7819: (
7820: p_List => l_Source
7821: , p_Separator => BSC_BIS_KPI_MEAS_PUB.COMMA_SEPARATOR
7822: , p_List_Data => l_period_values