DBA Data[Home] [Help]

APPS.BSC_BIS_DIMENSION_PUB dependencies on BSC_BIS_DIM_OBJ_PUB

Line 336: l_Bsc_Dim_Obj_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);

332: INTO l_Dim_Short_Name;
333: CLOSE c_Bis_Levels;
334:
335: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
336: l_Bsc_Dim_Obj_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
337:
338: IF (c_All_Pri_Flag%ISOPEN) THEN
339: CLOSE c_All_Pri_Flag;
340: END IF;

Line 394: IF (BSC_BIS_DIM_OBJ_PUB.Get_Dim_Obj_Source(NULL, p_Dim_Obj_Short_Name) = 'PMF') THEN

390: AND Dim_Level_Id = l_Bsc_Level_ID;
391: BEGIN
392: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag procedure');
393: SAVEPOINT SyncPMFAllInPMD;
394: IF (BSC_BIS_DIM_OBJ_PUB.Get_Dim_Obj_Source(NULL, p_Dim_Obj_Short_Name) = 'PMF') THEN
395: l_Bsc_Level_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
396:
397: IF (c_Bis_Levels%ISOPEN) THEN
398: CLOSE c_Bis_Levels;

Line 395: l_Bsc_Level_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);

391: BEGIN
392: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Sync_All_Enable_Flag procedure');
393: SAVEPOINT SyncPMFAllInPMD;
394: IF (BSC_BIS_DIM_OBJ_PUB.Get_Dim_Obj_Source(NULL, p_Dim_Obj_Short_Name) = 'PMF') THEN
395: l_Bsc_Level_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
396:
397: IF (c_Bis_Levels%ISOPEN) THEN
398: CLOSE c_Bis_Levels;
399: END IF;

Line 516: l_Bsc_Level_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);

512: CLOSE c_Bis_Levels;
513:
514: l_Old_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Old_Dim_Short_Name);
515:
516: l_Bsc_Level_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
517:
518:
519: l_Sync_Flag := TRUE;
520: IF (p_Sync_Flag) THEN

Line 1883: BSC_BIS_DIM_OBJ_PUB.Cascade_Dim_Props_Into_Dim_Grp (

1879: END IF;
1880:
1881: IF (p_dim_short_name IS NOT NULL AND p_dim_short_name <> BSC_BIS_DIMENSION_PUB.Unassigned_Dim) THEN
1882: -- Bug 4997042
1883: BSC_BIS_DIM_OBJ_PUB.Cascade_Dim_Props_Into_Dim_Grp (
1884: p_Dim_Obj_Short_Name => p_dim_obj_short_name
1885: , p_Dim_Short_Name => p_dim_short_name
1886: , p_All_Flag => p_total_flag
1887: , x_Return_Status => x_return_status

Line 3648: IF (BSC_BIS_DIM_OBJ_PUB.Get_Table_Type_Value(p_dim_lvl_shrt_name) = -1) THEN

3644: l_msg_count NUMBER;
3645: l_msg_data VARCHAR2(2000);
3646: BEGIN
3647: -- Underlying View does not exist.
3648: IF (BSC_BIS_DIM_OBJ_PUB.Get_Table_Type_Value(p_dim_lvl_shrt_name) = -1) THEN
3649: BSC_BIS_DIM_OBJ_PUB.Refresh_BSC_PMF_Dim_View
3650: ( p_Short_Name => p_dim_lvl_shrt_name
3651: , x_return_status => l_return_status
3652: , x_msg_count => l_msg_count

Line 3649: BSC_BIS_DIM_OBJ_PUB.Refresh_BSC_PMF_Dim_View

3645: l_msg_data VARCHAR2(2000);
3646: BEGIN
3647: -- Underlying View does not exist.
3648: IF (BSC_BIS_DIM_OBJ_PUB.Get_Table_Type_Value(p_dim_lvl_shrt_name) = -1) THEN
3649: BSC_BIS_DIM_OBJ_PUB.Refresh_BSC_PMF_Dim_View
3650: ( p_Short_Name => p_dim_lvl_shrt_name
3651: , x_return_status => l_return_status
3652: , x_msg_count => l_msg_count
3653: , x_msg_data => l_msg_data

Line 3656: IF(BSC_BIS_DIM_OBJ_PUB.Get_Table_Type_Value(p_dim_lvl_shrt_name) = -1) THEN

3652: , x_msg_count => l_msg_count
3653: , x_msg_data => l_msg_data
3654: );
3655: -- If the view has still not been created, then we need to return FALSE
3656: IF(BSC_BIS_DIM_OBJ_PUB.Get_Table_Type_Value(p_dim_lvl_shrt_name) = -1) THEN
3657: RETURN FALSE;
3658: END IF;
3659: END IF;
3660:

Line 4428: Called in: 1.) BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs 2.) BSC_BIS_DIM_OBJ_PUB.Assign_Unassign_Dimensions

4424:
4425: END Dim_With_Single_Dim_Obj;
4426: /**************************************************************************************************************
4427: Summry: Check the passing list of dimensions, cascading remove empty BSC dimension from dim set
4428: Called in: 1.) BSC_BIS_DIMENSION_PUB.Assign_Unassign_Dim_Objs 2.) BSC_BIS_DIM_OBJ_PUB.Assign_Unassign_Dimensions
4429: ****************************************************************************************************************/
4430: PROCEDURE Remove_Empty_Dims_For_DimSet
4431: ( p_commit IN VARCHAR2 := FND_API.G_FALSE -- mdamle 06/06/2005 - Set default p_commit to false for dim. group apis called from EO
4432: , p_dim_short_names IN VARCHAR2