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_REL_PUB dependencies on BSC_UTILITY

Line 600: IF(BSC_UTILITY.is_View_Exists(p_level_view_name)) THEN

596: FND_MSG_PUB.Initialize;
597: x_return_status := FND_API.G_RET_STS_SUCCESS;
598: BSC_APPS.Init_Bsc_Apps;
599:
600: IF(BSC_UTILITY.is_View_Exists(p_level_view_name)) THEN
601: l_Sql := C_SELECT || C_SELECT_CLAUSE
602: || C_FROM || p_level_view_name
603: || C_WHERE || C_WHERE_CLAUSE ;
604:

Line 909: l_dim_obj_tbls BSC_UTILITY.varchar_tabletype;

905:
906: )IS
907: l_new_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
908: l_prev_rel_Table BSC_BIS_DIM_REL_PUB.Relation_Table_Type;
909: l_dim_obj_tbls BSC_UTILITY.varchar_tabletype;
910:
911:
912: l_New_Count NUMBER;
913: l_Old_Count NUMBER;

Line 1594: BSC_UTILITY.Enable_Dimension_Entity(

1590: INTO l_dim_obj_name, l_dim_obj_sname
1591: FROM BSC_SYS_DIM_LEVELS_VL
1592: WHERE DIM_LEVEL_ID = l_rel_id;
1593:
1594: BSC_UTILITY.Enable_Dimension_Entity(
1595: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
1596: , p_Entity_Short_Name => l_dim_obj_sname
1597: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1598: , p_Entity_Name => l_dim_obj_name

Line 1595: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT

1591: FROM BSC_SYS_DIM_LEVELS_VL
1592: WHERE DIM_LEVEL_ID = l_rel_id;
1593:
1594: BSC_UTILITY.Enable_Dimension_Entity(
1595: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
1596: , p_Entity_Short_Name => l_dim_obj_sname
1597: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1598: , p_Entity_Name => l_dim_obj_name
1599: , x_Return_Status => x_return_status

Line 1597: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE

1593:
1594: BSC_UTILITY.Enable_Dimension_Entity(
1595: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
1596: , p_Entity_Short_Name => l_dim_obj_sname
1597: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1598: , p_Entity_Name => l_dim_obj_name
1599: , x_Return_Status => x_return_status
1600: , x_Msg_Count => x_msg_count
1601: , x_Msg_Data => x_msg_data

Line 1618: BSC_UTILITY.Enable_Dimension_Entity(

1614: INTO l_dim_obj_name, l_dim_obj_sname
1615: FROM BSC_SYS_DIM_LEVELS_VL
1616: WHERE DIM_LEVEL_ID = l_rel_id;
1617:
1618: BSC_UTILITY.Enable_Dimension_Entity(
1619: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
1620: , p_Entity_Short_Name => l_dim_obj_sname
1621: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1622: , p_Entity_Name => l_dim_obj_name

Line 1619: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT

1615: FROM BSC_SYS_DIM_LEVELS_VL
1616: WHERE DIM_LEVEL_ID = l_rel_id;
1617:
1618: BSC_UTILITY.Enable_Dimension_Entity(
1619: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
1620: , p_Entity_Short_Name => l_dim_obj_sname
1621: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1622: , p_Entity_Name => l_dim_obj_name
1623: , x_Return_Status => x_return_status

Line 1621: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE

1617:
1618: BSC_UTILITY.Enable_Dimension_Entity(
1619: p_Entity_Type => BSC_UTILITY.c_DIMENSION_OBJECT
1620: , p_Entity_Short_Name => l_dim_obj_sname
1621: , p_Entity_Action_Type => BSC_UTILITY.c_UPDATE
1622: , p_Entity_Name => l_dim_obj_name
1623: , x_Return_Status => x_return_status
1624: , x_Msg_Count => x_msg_count
1625: , x_Msg_Data => x_msg_data

Line 2402: IF (l_source = BSC_UTILITY.c_PMF) THEN

2398: END IF;
2399: END IF;
2400:
2401: -- Added for Bug#4758995
2402: IF (l_source = BSC_UTILITY.c_PMF) THEN
2403:
2404: SELECT short_name
2405: INTO l_dim_short_name
2406: FROM bsc_sys_dim_levels_b

Line 2422: l_rel_ids := BSC_UTILITY.Create_Unique_Comma_List(l_original_child_ids, p_child_ids);

2418:
2419: -- now, refresh all the child dimension object views as well - Bug#5300060
2420: -- Create an unique list child IDs ,which has been removed from the relationship, which exist in
2421: -- the relationship and that have been newly added to relationship
2422: l_rel_ids := BSC_UTILITY.Create_Unique_Comma_List(l_original_child_ids, p_child_ids);
2423:
2424: IF (l_rel_ids IS NOT NULL) THEN
2425: WHILE (is_more( p_dim_lev_ids => l_rel_ids
2426: , p_dim_lev_id => l_rel_id

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

3724: BEGIN
3725: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIM_REL_PUB.is_KPI_Flag_For_Dim_Obj_Rels Function');
3726:
3727: FND_MSG_PUB.Initialize;
3728: IF (NOT BSC_UTILITY.isBscInProductionMode()) THEN
3729: RETURN NULL;
3730: END IF;
3731:
3732: OPEN c_Source;