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_LOCKS_PUB

Line 895: l_Dim_Tab BSC_BIS_LOCKS_PUB.t_numberTable;

891: l_flag BOOLEAN := FALSE;
892: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
893: l_application_id BIS_LEVELS.Application_Id%TYPE;
894: -- Start Granular Locking added by Aditya
895: l_Dim_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
896: l_dim_Grp_names VARCHAR2(32000);
897:
898: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
899: l_index NUMBER := 0;

Line 1096: BSC_BIS_LOCKS_PUB.Lock_Create_Dimension_Object

1092: l_Dim_Tab(l_index) := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_Grp_name), -1);
1093: l_index := l_index + 1;
1094: END LOOP;
1095: -- Lock all the Dimension to be assigned to the Dimension Objects
1096: BSC_BIS_LOCKS_PUB.Lock_Create_Dimension_Object
1097: ( p_selected_dimensions => l_Dim_Tab
1098: , x_return_status => x_return_status
1099: , x_msg_count => x_msg_count
1100: , x_msg_data => x_msg_data

Line 1576: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group

1572: , p_dim_name => l_dim_name)
1573: ) LOOP
1574: -- Granular Locking - Set the timestamp of Dimension Group
1575: l_dim_grp_id := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_name), -1);
1576: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group
1577: ( p_dim_group_id => l_dim_grp_id
1578: , x_return_status => x_return_status
1579: , x_msg_count => x_msg_count
1580: , x_msg_data => x_msg_data

Line 1676: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group

1672: , p_dim_name => l_dim_name)
1673: ) LOOP
1674:
1675: -- Granular Locking - Set the timestamp of Dimension Group
1676: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Group
1677: ( p_dim_group_id => NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_name), -1)
1678: , x_return_status => x_return_status
1679: , x_msg_count => x_msg_count
1680: , x_msg_data => x_msg_data

Line 2073: l_Dim_Tab BSC_BIS_LOCKS_PUB.t_numberTable;

2069: l_mix_type_dim BOOLEAN ;
2070: l_duplicate_flag BOOLEAN ;
2071:
2072:
2073: l_Dim_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
2074: l_dim_Grp_names VARCHAR2(32000);
2075: l_dim_short_names VARCHAR2(32000);
2076: l_child_dim_obj_list VARCHAR2(32000);
2077: l_pmf_disp_name VARCHAR2(255); -- DispName

Line 2371: BSC_BIS_LOCKS_PUB.Lock_Update_Dimension_Object

2367: l_index := l_index + 1;
2368: END LOOP;
2369: END IF;
2370: -- Lock all the Dimension Groups to be assigned to the Dimension Objects
2371: BSC_BIS_LOCKS_PUB.Lock_Update_Dimension_Object
2372: ( p_Dim_Object_Id => l_bsc_dim_obj_rec.Bsc_Level_Id
2373: ,p_Selected_Dimensions => l_Dim_Tab
2374: ,p_time_stamp => p_time_stamp -- Granular Locking
2375: ,x_return_status => x_return_status

Line 2759: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Level

2755: END IF;
2756: END IF;
2757:
2758: -- Start Granular Locking
2759: BSC_BIS_LOCKS_PUB.Set_Time_Stamp_Dim_Level
2760: ( p_dim_level_id => l_bsc_dim_obj_rec.Bsc_Level_Id
2761: , x_return_status => x_return_status
2762: , x_msg_count => x_msg_count
2763: , x_msg_data => x_msg_data

Line 3284: BSC_BIS_LOCKS_PUB.Lock_Dim_Level

3280: , l_bsc_dim_obj_rec.Bsc_Dim_Level_Long_Name;
3281: CLOSE c_bsc_levels;
3282: IF (l_bsc_dim_obj_rec.Bsc_Level_Id IS NOT NULL) THEN
3283: -- Granular Locking START
3284: BSC_BIS_LOCKS_PUB.Lock_Dim_Level
3285: ( p_dim_level_id => l_bsc_dim_obj_rec.Bsc_Level_Id
3286: ,p_time_stamp => NULL -- Granular Locking
3287: ,x_return_status => x_return_status
3288: ,x_msg_count => x_msg_count