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_DIMENSION_PUB dependencies on BSC_BIS_LOCKS_PUB

Line 900: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;

896: l_alias VARCHAR2(4);
897: l_flag BOOLEAN;
898: l_temp_var BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
899: -- Start Granular Locking added by Aditya
900: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
901: l_dim_obj_names VARCHAR2(32000);
902:
903: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
904: l_index NUMBER := 0;

Line 1095: BSC_BIS_LOCKS_PUB.Lock_Create_Dimension

1091: l_Dim_Obj_Tab(l_index) := NVL(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);
1092: l_index := l_index + 1;
1093: END LOOP;
1094: -- Lock all the Dimension Objects to be assigned to the Dimension
1095: BSC_BIS_LOCKS_PUB.Lock_Create_Dimension
1096: ( p_selected_dim_objets => l_Dim_Obj_Tab
1097: , x_return_status => x_return_status
1098: , x_msg_count => x_msg_count
1099: , x_msg_data => x_msg_data

Line 1706: BSC_BIS_LOCKS_PUB.Lock_Update_Dim_Obj_In_Dim

1702: RAISE FND_API.G_EXC_ERROR;
1703: END IF;
1704: END IF;
1705:
1706: BSC_BIS_LOCKS_PUB.Lock_Update_Dim_Obj_In_Dim
1707: ( p_dim_object_id => l_bsc_dimension_rec.Bsc_Level_Id
1708: , p_dimension_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
1709: , p_time_stamp => p_time_stamp -- Granular Locking
1710: , x_return_status => x_return_status

Line 1870: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group

1866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1867: END IF;
1868:
1869: -- START Granular Locking added by Aditya
1870: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group
1871: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
1872: , x_return_status => x_return_status
1873: , x_msg_count => x_msg_count
1874: , x_msg_data => x_msg_data

Line 2037: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;

2033: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;
2034: l_kpi_cascade BOOLEAN := FALSE;
2035: l_count NUMBER;
2036: -- START Granular Locking Declaration added by Aditya
2037: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
2038: l_index NUMBER := 0;
2039: -- END Granular Locking Declaration added by Aditya
2040: CURSOR cr_bsc_dimension_id IS
2041: SELECT Dim_Group_Id

Line 2091: BSC_BIS_LOCKS_PUB.Lock_Update_Dimension

2087: ) LOOP
2088: l_Dim_Obj_Tab(l_index) := nvl(BSC_DIMENSION_LEVELS_PVT.get_Dim_Level_Id(l_dim_obj_name), -1);
2089: l_index := l_index + 1;
2090: END LOOP;
2091: BSC_BIS_LOCKS_PUB.Lock_Update_Dimension
2092: ( p_dimension_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
2093: , p_selected_dim_objets => l_Dim_Obj_Tab
2094: , p_time_stamp => p_time_stamp -- Granular Locking
2095: , x_return_status => x_return_status

Line 2217: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group

2213: , x_msg_data => x_msg_data
2214: );
2215: END IF;
2216: -- Granular Locking : Change the Time Stamp of the Group, once it is changed
2217: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group
2218: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
2219: , x_return_status => x_return_status
2220: , x_msg_count => x_msg_count
2221: , x_msg_data => x_msg_data

Line 2864: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;

2860: SELECT dim_group_id
2861: FROM BSC_SYS_DIM_GROUPS_VL
2862: WHERE short_name = p_dim_short_name;
2863:
2864: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
2865: l_dim_obj_names VARCHAR2(32000);
2866:
2867: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2868: l_index NUMBER := 0;

Line 2976: BSC_BIS_LOCKS_PUB.Lock_Update_Dimension

2972: END LOOP;
2973: END IF;
2974: -- Lock all the Dimension Objects to be assigned/unassigned to the Dimension
2975: -- Pass the time_stamp_value
2976: BSC_BIS_LOCKS_PUB.Lock_Update_Dimension
2977: ( p_dimension_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
2978: , p_selected_dim_objets => l_Dim_Obj_Tab
2979: , p_time_stamp => p_time_stamp -- Granular Locking
2980: , x_return_status => x_return_status

Line 3018: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group

3014: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3016: END IF;
3017: -- Granular Locking : Change the Time Stamp of the Group, once it is changed
3018: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group
3019: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
3020: , x_return_status => x_return_status
3021: , x_msg_count => x_msg_count
3022: , x_msg_data => x_msg_data

Line 3142: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;

3138: AND grp.dim_group_id = l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
3139: GROUP BY grp.indicator,grp.dim_set_id;
3140:
3141: -- START Granular Locking Declaration added by Aditya
3142: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
3143: l_dim_obj_names VARCHAR2(32000);
3144:
3145: l_unassign_dim_obj_names VARCHAR2(32000);
3146:

Line 3461: BSC_BIS_LOCKS_PUB.Lock_Dim_Group

3457: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name);
3458: FND_MSG_PUB.ADD;
3459: RAISE FND_API.G_EXC_ERROR;
3460: END IF;
3461: BSC_BIS_LOCKS_PUB.Lock_Dim_Group
3462: ( p_dim_group_id => l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id
3463: ,p_time_stamp => NULL -- Granular Locking
3464: ,x_return_status => x_return_status
3465: ,x_msg_count => x_msg_count