DBA Data[Home] [Help]

APPS.BSC_BIS_DIM_OBJ_PUB dependencies on BSC_DIMENSION_GROUPS_PVT

Line 1092: l_Dim_Tab(l_index) := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_Grp_name), -1);

1088: IF (l_first_dim) THEN
1089: l_first_dim := FALSE;
1090: l_bis_dim_level_rec.Dimension_Short_Name := l_dim_Grp_name;
1091: END IF;
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

Line 1575: l_dim_grp_id := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_name), -1);

1571: WHILE (is_more( p_dim_short_names => l_dim_short_names
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

Line 1677: ( p_dim_group_id => NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_name), -1)

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
1681: );

Line 2350: l_Dim_Tab(l_index) := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_Grp_name), -1);

2346: IF (l_dim_short_name = l_dim_Grp_name) THEN
2347: l_dim_exist := TRUE;
2348: l_bis_dim_level_rec.Dimension_Short_Name:= l_dim_Grp_name;
2349: END IF;
2350: l_Dim_Tab(l_index) := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_Grp_name), -1);
2351: l_index := l_index + 1;
2352: END LOOP;
2353: ELSE
2354: l_bis_dim_level_rec.Dimension_Short_Name := BSC_BIS_DIMENSION_PUB.Unassigned_Dim;

Line 2366: l_Dim_Tab(l_index) := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_Grp_name), -1);

2362: l_dim_Grp_names := p_unassign_dim_short_names;
2363: WHILE (is_more( p_dim_short_names => l_dim_Grp_names
2364: , p_dim_name => l_dim_Grp_name)
2365: ) LOOP
2366: l_Dim_Tab(l_index) := NVL(BSC_DIMENSION_GROUPS_PVT.get_Dim_Group_Id(l_dim_Grp_name), -1);
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