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_SYS_DIM_GROUPS_TL

Line 85: , p_short_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE

81:
82: TYPE KPI_Dim_Set_Type IS Record
83: ( p_kpi_id BSC_KPI_DIM_SETS_TL.indicator%TYPE
84: , p_dim_set_id BSC_KPI_DIM_SETS_TL.dim_set_id%TYPE
85: , p_short_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE
86: );
87: TYPE KPI_Dim_Set_Table_Type IS TABLE OF KPI_Dim_Set_Type INDEX BY BINARY_INTEGER;
88: /*********************************************************************************/
89: TYPE Dim_Obj_Relations_Type IS Record

Line 203: ( p_Short_Name IN BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE

199: /*********************************************************************************************
200: Returns the Dim_Group_ID of BSC Dimension
201: *********************************************************************************************/
202: FUNCTION Get_Bsc_Dimension_ID
203: ( p_Short_Name IN BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE
204: ) RETURN NUMBER IS
205:
206: l_dim_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
207:

Line 206: l_dim_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

202: FUNCTION Get_Bsc_Dimension_ID
203: ( p_Short_Name IN BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE
204: ) RETURN NUMBER IS
205:
206: l_dim_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
207:
208: CURSOR c_Dim_Group_Id IS
209: SELECT Dim_Group_ID
210: FROM BSC_SYS_DIM_GROUPS_VL

Line 232: ( p_dim_group_id IN BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE

228: /*********************************************************************************************
229: Checks if a Dimension is Attached to a Objective
230: *********************************************************************************************/
231: FUNCTION Is_Dimension_in_Ind
232: ( p_dim_group_id IN BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE
233: ) RETURN BOOLEAN IS
234:
235: l_return_val BOOLEAN:= FALSE;
236: l_Count NUMBER := 0;

Line 255: ( p_Short_Name IN BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE

251: /*********************************************************************************************
252: Returns the Name of BSC Dimension
253: *********************************************************************************************/
254: FUNCTION Get_Bsc_Dimension_Name
255: ( p_Short_Name IN BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE
256: ) RETURN VARCHAR2 IS
257:
258: l_dim_name BSC_SYS_DIM_GROUPS_TL.Name%TYPE;
259:

Line 258: l_dim_name BSC_SYS_DIM_GROUPS_TL.Name%TYPE;

254: FUNCTION Get_Bsc_Dimension_Name
255: ( p_Short_Name IN BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE
256: ) RETURN VARCHAR2 IS
257:
258: l_dim_name BSC_SYS_DIM_GROUPS_TL.Name%TYPE;
259:
260: CURSOR c_Dim_Group_Name IS
261: SELECT Name
262: FROM BSC_SYS_DIM_GROUPS_VL

Line 284: ( p_Dim_Grp_Id IN BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE

280: /*********************************************************************************************
281: Function to check Dimension/Dimension Object if association exists
282: *********************************************************************************************/
283: FUNCTION is_Relation_Exists
284: ( p_Dim_Grp_Id IN BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE
285: , p_Dim_Level_Id IN BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE
286: ) RETURN BOOLEAN IS
287: l_flag BOOLEAN := FALSE;
288: l_Count NUMBER := 0;

Line 309: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

305: *********************************************************************************/
306: FUNCTION Get_Primary_All_Flag(p_Dim_Obj_Short_Name IN VARCHAR2)
307: RETURN NUMBER IS
308: l_Bsc_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
309: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
310: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
311: l_All_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE;
312:
313: CURSOR c_Bis_Levels IS

Line 375: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

371: , x_msg_count OUT NOCOPY NUMBER
372: , x_msg_data OUT NOCOPY VARCHAR2
373: ) IS
374: l_Bsc_Level_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
375: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
376: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
377: l_Total_Flag BSC_SYS_DIM_LEVELS_BY_GROUP.Total_Flag%TYPE := NULL;
378:
379: CURSOR c_Bis_Levels IS

Line 444: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE := NULL;

440: , x_msg_count OUT NOCOPY NUMBER
441: , x_msg_data OUT NOCOPY VARCHAR2
442: ) IS
443: l_Bsc_Level_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
444: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE := NULL;
445: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;
446:
447: l_Old_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
448: l_Old_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;

Line 447: l_Old_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

443: l_Bsc_Level_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
444: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE := NULL;
445: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;
446:
447: l_Old_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
448: l_Old_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
449:
450: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
451:

Line 892: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

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;
895:
896: l_alias VARCHAR2(4);

Line 898: l_temp_var BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

894: l_count NUMBER;
895:
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:

Line 924: FROM BSC_SYS_DIM_GROUPS_TL;

920: l_application_id := p_application_id;
921: ELSE
922: SELECT NVL(MAX(dim_group_id) + 1, 0)
923: INTO l_count
924: FROM BSC_SYS_DIM_GROUPS_TL;
925: IF (p_dim_short_name IS NULL) THEN
926: l_dim_short_name := c_BSC_DIM ||l_count;
927: ELSE
928: l_dim_short_name := p_dim_short_name;

Line 985: FROM BSC_SYS_DIM_GROUPS_TL

981: RAISE FND_API.G_EXC_ERROR;
982: END IF;
983:
984: SELECT COUNT(1) INTO l_count
985: FROM BSC_SYS_DIM_GROUPS_TL
986: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
987: IF (l_count <> 0) THEN
988: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
989: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));

Line 1069: --l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_GROUPS_TL', 'DIM_GROUP_ID');

1065:
1066: END IF;
1067:
1068: --assign values to bsc records
1069: --l_bsc_dimension_rec.Bsc_Dim_Level_Group_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_SYS_DIM_GROUPS_TL', 'DIM_GROUP_ID');
1070: l_bsc_dimension_rec.Bsc_Dim_Level_Group_Name := p_display_name;
1071: l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name := l_dim_short_name;
1072: l_bsc_dimension_rec.Bsc_Dim_Level_Index := 1;
1073: l_bsc_dimension_rec.Bsc_Group_Level_Comp_Flag := -1;

Line 1525: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;

1521: , x_return_status OUT NOCOPY VARCHAR2
1522: , x_msg_count OUT NOCOPY NUMBER
1523: , x_msg_data OUT NOCOPY VARCHAR2
1524: ) IS
1525: l_Dim_Grp_Id BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%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;

Line 2028: l_Dim_Grp_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_Id%TYPE;

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);
2031: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2032: l_MTab_Tbl BSC_BIS_DIMENSION_PUB.KPI_Dim_Set_Table_Type;

Line 2550: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

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;
2554:

Line 3609: FROM BSC_SYS_DIM_GROUPS_TL TL

3605: l_Data_Source BSC_SYS_DIM_LEVELS_B.Source%TYPE := NULL;
3606:
3607: CURSOR c_Dim_Obj_Data_Source IS
3608: SELECT VL.Source
3609: FROM BSC_SYS_DIM_GROUPS_TL TL
3610: , BSC_SYS_DIM_LEVELS_BY_GROUP GP
3611: , BSC_SYS_DIM_LEVELS_B VL
3612: WHERE TL.Dim_Group_Id = GP.Dim_Group_Id
3613: AND GP.Dim_Level_Id = VL.Dim_Level_Id

Line 4333: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

4329: p_dim_short_names IN VARCHAR
4330:
4331: ) RETURN VARCHAR2 IS
4332: l_count NUMBER;
4333: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
4334: l_dim_short_names VARCHAR2(32000);
4335: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
4336: l_return_value VARCHAR2(1);
4337:

Line 4335: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

4331: ) RETURN VARCHAR2 IS
4332: l_count NUMBER;
4333: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
4334: l_dim_short_names VARCHAR2(32000);
4335: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
4336: l_return_value VARCHAR2(1);
4337:
4338:
4339:

Line 4375: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

4371: p_dim_short_names IN VARCHAR
4372:
4373: ) RETURN VARCHAR2 IS
4374: l_count NUMBER;
4375: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
4376: l_dim_short_names VARCHAR2(32000);
4377: l_dim_name BSC_SYS_DIM_GROUPS_TL.Name%TYPE;
4378: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
4379: l_return_value VARCHAR2(32000);

Line 4377: l_dim_name BSC_SYS_DIM_GROUPS_TL.Name%TYPE;

4373: ) RETURN VARCHAR2 IS
4374: l_count NUMBER;
4375: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
4376: l_dim_short_names VARCHAR2(32000);
4377: l_dim_name BSC_SYS_DIM_GROUPS_TL.Name%TYPE;
4378: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
4379: l_return_value VARCHAR2(32000);
4380:
4381:

Line 4378: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

4374: l_count NUMBER;
4375: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
4376: l_dim_short_names VARCHAR2(32000);
4377: l_dim_name BSC_SYS_DIM_GROUPS_TL.Name%TYPE;
4378: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
4379: l_return_value VARCHAR2(32000);
4380:
4381:
4382:

Line 4440: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;

4436: , x_msg_data OUT NOCOPY VARCHAR2
4437: ) IS
4438:
4439: l_count NUMBER;
4440: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
4441: l_dim_short_names VARCHAR2(32000);
4442: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
4443: l_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4444:

Line 4442: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;

4438:
4439: l_count NUMBER;
4440: l_dim_group_id BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
4441: l_dim_short_names VARCHAR2(32000);
4442: l_dim_short_name BSC_SYS_DIM_GROUPS_TL.Short_Name%TYPE;
4443: l_source BSC_SYS_DIM_LEVELS_B.Source%TYPE;
4444:
4445: CURSOR c_dim_set_kpi IS
4446: SELECT DISTINCT A.indicator INDICATOR