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_DIMENSION_GROUPS_PUB

Line 890: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

886: , x_msg_data OUT NOCOPY VARCHAR2
887: ) IS
888: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
889: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
890: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
891:
892: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
893: l_application_id BIS_DIMENSIONS.Application_Id%TYPE;
894: l_count NUMBER;

Line 1106: BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group

1102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1103: END IF;
1104: END IF;
1105: -- End Granular Locking
1106: BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group
1107: ( p_commit => FND_API.G_FALSE
1108: , p_Dim_Grp_Rec => l_bsc_dimension_rec
1109: , p_create_Dim_Levels => FALSE
1110: , x_return_status => x_return_status

Line 1241: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

1237: l_dim_group_id BSC_SYS_DIM_GROUPS_VL.Dim_Group_Id%TYPE;
1238: l_count NUMBER;
1239: l_count1 NUMBER;
1240: l_flag BOOLEAN;
1241: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1242: l_dim_level_id BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
1243:
1244: l_tab_index NUMBER;
1245: l_original_tab_index NUMBER;

Line 1402: BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group

1398: l_bsc_dimension_rec.Bsc_Dim_Level_Index := l_count;
1399: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id := l_dim_group_id;
1400: l_bsc_dimension_rec.Bsc_Level_Id := l_MTab_DimRels1(i).p_dim_obj_id;
1401:
1402: BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group
1403: ( p_commit => FND_API.G_FALSE
1404: , p_Dim_Grp_Rec => l_bsc_dimension_rec
1405: , x_return_status => x_return_status
1406: , x_msg_count => x_msg_count

Line 1430: BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group

1426: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id := l_dim_group_id;
1427: l_bsc_dimension_rec.Bsc_Level_Id := l_MTab_DimRels2(l_tab_index).p_dim_obj_id;
1428: l_struct_change := TRUE;
1429:
1430: BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group
1431: ( p_commit => FND_API.G_FALSE
1432: , p_Dim_Grp_Rec => l_bsc_dimension_rec
1433: , x_return_status => x_return_status
1434: , x_msg_count => x_msg_count

Line 1530: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

1526: l_dim_lvl_name VARCHAR2(400);
1527: l_default VARCHAR2(3);
1528: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;
1529: l_dim_obj_objs_tbl BSC_BIS_DIMENSION_PUB.dimobj_obj_kpis_tbl_type;
1530: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
1531: l_count NUMBER;
1532: l_comp_count NUMBER;
1533:
1534: l_valid_Assign BOOLEAN := FALSE;

Line 1756: BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group

1752: FETCH c_Defaut_Value
1753: INTO l_default;
1754: CLOSE c_Defaut_Value;
1755: -- END Added by Aditya for Incremental Changes
1756: BSC_DIMENSION_GROUPS_PUB.Update_Dim_Levels_In_Group
1757: ( p_commit => FND_API.G_FALSE
1758: , p_Dim_Grp_Rec => l_bsc_dimension_rec
1759: , x_return_status => x_return_status
1760: , x_msg_count => x_msg_count

Line 1811: BSC_DIMENSION_GROUPS_PUB.Create_Dim_Levels_In_Group

1807: WHERE Dim_Level_ID = l_bsc_dimension_rec.Bsc_Level_Id
1808: AND Dim_Group_ID = l_Dim_Grp_Id;
1809: ELSE
1810: -- END - Added by Aditya for Incremental Changes
1811: BSC_DIMENSION_GROUPS_PUB.Create_Dim_Levels_In_Group
1812: ( p_commit => FND_API.G_FALSE
1813: , p_Dim_Grp_Rec => l_bsc_dimension_rec
1814: , x_return_status => x_return_status
1815: , x_msg_count => x_msg_count

Line 2026: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

2022: , x_return_status OUT NOCOPY VARCHAR2
2023: , x_msg_count OUT NOCOPY NUMBER
2024: , x_msg_data OUT NOCOPY VARCHAR2
2025: ) IS
2026: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
2027: l_Dim_Obj_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE := NULL;
2028: l_Dim_Grp_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;
2029: l_Source_Type BSC_SYS_DIM_LEVELS_B.Source%TYPE;
2030: l_dim_obj_names VARCHAR2(32000);

Line 2159: BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group

2155: END IF;
2156: END IF;
2157: IF ((l_Dim_Obj_Source = 'BSC') OR
2158: (BSC_BIS_DIMENSION_PUB.Get_Number_Of_Dimensions(l_bsc_dimension_rec.Bsc_Level_Id) <> 1)) THEN
2159: BSC_DIMENSION_GROUPS_PUB.Delete_Dim_Levels_In_Group
2160: ( p_commit => FND_API.G_FALSE
2161: , p_Dim_Grp_Rec => l_bsc_dimension_rec
2162: , x_return_status => x_return_status
2163: , x_msg_count => x_msg_count

Line 2549: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

2545: , x_msg_data OUT NOCOPY VARCHAR2
2546: )IS
2547: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
2548: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2549: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
2550: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
2551: l_application_id BIS_DIMENSIONS.Application_Id%TYPE;
2552: l_bis_create BOOLEAN := FALSE;
2553: l_bsc_create BOOLEAN := FALSE;

Line 2728: BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group

2724: ELSE
2725: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name := p_display_name;
2726: END IF;
2727:
2728: BSC_DIMENSION_GROUPS_PUB.Create_Dimension_Group
2729: ( p_commit => FND_API.G_FALSE
2730: , p_Dim_Grp_Rec => l_bsc_dimension_rec
2731: , p_create_Dim_Levels => FALSE
2732: , x_return_status => x_return_status

Line 2751: BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group

2747: ELSE
2748: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name := p_display_name;
2749:
2750: l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name := l_dim_short_name;
2751: BSC_DIMENSION_GROUPS_PUB.Update_Dimension_Group
2752: ( p_commit => FND_API.G_FALSE
2753: , p_Dim_Grp_Rec => l_bsc_dimension_rec
2754: , p_create_Dim_Levels => FALSE
2755: , x_return_status => x_return_status

Line 2857: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

2853: , x_msg_count OUT NOCOPY NUMBER
2854: , x_msg_data OUT NOCOPY VARCHAR2
2855: )IS
2856: -- START Granular Locking Declaration added by Aditya
2857: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
2858:
2859: CURSOR cr_bsc_dim_id IS
2860: SELECT dim_group_id
2861: FROM BSC_SYS_DIM_GROUPS_VL

Line 3112: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

3108: , x_return_status OUT NOCOPY VARCHAR2
3109: , x_msg_count OUT NOCOPY NUMBER
3110: , x_msg_data OUT NOCOPY VARCHAR2
3111: )IS
3112: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
3113: l_kpi_id NUMBER;
3114: l_dim_set_id NUMBER;
3115: l_count NUMBER;
3116: l_indp_dimobj NUMBER;

Line 3318: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;

3314:
3315: l_delete BOOLEAN := TRUE;
3316: l_bis_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
3317: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
3318: l_bsc_dimension_rec BSC_DIMENSION_GROUPS_PUB.Bsc_Dim_Group_Rec_Type;
3319: l_Dim_Obj_Short_Name BIS_LEVELS.Short_Name%TYPE;
3320: l_count NUMBER;
3321: l_delete_count NUMBER := 0;
3322: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;

Line 3478: BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group

3474: -- This will create a structural changes to all the KPIs that are currently using the
3475: -- Groups, which is going to be deleted.
3476: BSC_DESIGNER_PVT.Dimension_Change(p_dim_short_name, BSC_DESIGNER_PVT.G_ActionFlag.GAA_Structure);
3477: -- End incremental changes.
3478: BSC_DIMENSION_GROUPS_PUB.Delete_Dimension_Group
3479: ( p_commit => FND_API.G_FALSE
3480: , p_Dim_Grp_Rec => l_bsc_dimension_rec
3481: , x_return_status => x_return_status
3482: , x_msg_count => x_msg_count