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 BIS_DIMENSIONS

Line 174: ( p_Short_Name IN BIS_DIMENSIONS.Short_Name%TYPE

170: /*********************************************************************************************
171: Returns the Dim_Group_ID of BIS Dimension
172: *********************************************************************************************/
173: FUNCTION Get_Bis_Dimension_ID
174: ( p_Short_Name IN BIS_DIMENSIONS.Short_Name%TYPE
175: ) RETURN NUMBER IS
176:
177: l_dim_id BIS_DIMENSIONS.Dimension_ID%TYPE;
178:

Line 177: l_dim_id BIS_DIMENSIONS.Dimension_ID%TYPE;

173: FUNCTION Get_Bis_Dimension_ID
174: ( p_Short_Name IN BIS_DIMENSIONS.Short_Name%TYPE
175: ) RETURN NUMBER IS
176:
177: l_dim_id BIS_DIMENSIONS.Dimension_ID%TYPE;
178:
179: CURSOR c_Dim_Group_Id IS
180: SELECT Dimension_ID
181: FROM BIS_DIMENSIONS

Line 181: FROM BIS_DIMENSIONS

177: l_dim_id BIS_DIMENSIONS.Dimension_ID%TYPE;
178:
179: CURSOR c_Dim_Group_Id IS
180: SELECT Dimension_ID
181: FROM BIS_DIMENSIONS
182: WHERE Short_Name = p_Short_Name;
183: BEGIN
184: IF (c_Dim_Group_Id%ISOPEN) THEN
185: CLOSE c_Dim_Group_Id;

Line 310: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;

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
314: SELECT B.Short_Name

Line 316: , BIS_DIMENSIONS B

312:
313: CURSOR c_Bis_Levels IS
314: SELECT B.Short_Name
315: FROM BIS_LEVELS A
316: , BIS_DIMENSIONS B
317: WHERE A.Short_Name = p_Dim_Obj_Short_Name
318: AND A.Dimension_Id = B.Dimension_Id;
319:
320: CURSOR c_All_Pri_Flag IS

Line 376: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;

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
380: SELECT B.Short_Name

Line 382: , BIS_DIMENSIONS B

378:
379: CURSOR c_Bis_Levels IS
380: SELECT B.Short_Name
381: FROM BIS_LEVELS A
382: , BIS_DIMENSIONS B
383: WHERE A.Short_Name = p_Dim_Obj_Short_Name
384: AND A.Dimension_Id = B.Dimension_Id;
385:
386: CURSOR c_Total_Flag IS

Line 445: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;

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

Line 448: l_Old_Dim_Short_Name BIS_DIMENSIONS.Short_Name%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:
452: l_Sync_Flag BOOLEAN;

Line 450: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%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:
452: l_Sync_Flag BOOLEAN;
453:
454: l_bis_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

Line 462: , BIS_DIMENSIONS B

458:
459: CURSOR c_Bis_Levels IS
460: SELECT B.Short_Name
461: FROM BIS_LEVELS A
462: , BIS_DIMENSIONS B
463: WHERE A.Short_Name = p_Dim_Obj_Short_Name
464: AND A.Dimension_Id = B.Dimension_Id;
465:
466: CURSOR c_Dim_Groups IS

Line 893: l_application_id BIS_DIMENSIONS.Application_Id%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);
897: l_flag BOOLEAN;

Line 940: FROM BIS_DIMENSIONS_VL

936: FROM BSC_SYS_DIM_GROUPS_VL
937: WHERE UPPER(Short_Name) = UPPER(l_temp_var)
938: UNION
939: SELECT COUNT(1) rec_count
940: FROM BIS_DIMENSIONS_VL
941: WHERE UPPER(Short_Name) = UPPER(l_temp_var))
942: WHERE rec_count > 0;
943: IF (l_count = 0) THEN
944: l_flag := FALSE;

Line 996: FROM BIS_DIMENSIONS_VL

992: RAISE FND_API.G_EXC_ERROR;
993: END IF;
994:
995: SELECT COUNT(1) INTO l_count
996: FROM BIS_DIMENSIONS_VL
997: WHERE UPPER(short_name) = UPPER(l_dim_short_name);
998: IF (l_count <> 0) THEN
999: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1000: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_SHORT_NAME'));

Line 1030: FROM BIS_DIMENSIONS_VL

1026: -- Enh#4172034: Validations
1027: IF ((l_dim_type IS NULL) OR (l_dim_type = 'BSC')) THEN
1028:
1029: SELECT COUNT(1) INTO l_count
1030: FROM BIS_DIMENSIONS_VL
1031: WHERE UPPER(name) = UPPER(p_display_name);
1032:
1033: WHILE(l_count > 0) LOOP
1034: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);

Line 1037: FROM BIS_DIMENSIONS_VL

1033: WHILE(l_count > 0) LOOP
1034: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);
1035:
1036: SELECT COUNT(1) INTO l_count
1037: FROM BIS_DIMENSIONS_VL
1038: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
1039:
1040: END LOOP;
1041:

Line 1056: FROM BIS_DIMENSIONS_VL

1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: SELECT COUNT(1) INTO l_count
1056: FROM BIS_DIMENSIONS_VL
1057: WHERE UPPER(name) = UPPER(p_display_name);
1058: IF (l_count <> 0) THEN
1059: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1060: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

Line 1833: --sync up with BIS Dimensions

1829: );
1830: ----DEBUG('8..'||get_default_value());
1831: END IF;
1832: END IF;
1833: --sync up with BIS Dimensions
1834: BSC_BIS_DIMENSION_PUB.Sync_Dimensions_In_Bis
1835: ( p_commit => FND_API.G_FALSE
1836: , p_Dim_Obj_Short_Name => p_dim_obj_short_name
1837: , p_Sync_Flag => TRUE

Line 2033: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_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;
2033: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%TYPE;
2034: l_kpi_cascade BOOLEAN := FALSE;
2035: l_count NUMBER;
2036: -- START Granular Locking Declaration added by Aditya
2037: l_Dim_Obj_Tab BSC_BIS_LOCKS_PUB.t_numberTable;

Line 2386: l_dim_short_name BIS_DIMENSIONS.short_name%TYPE;

2382:
2383: l_dim_obj_sht_names VARCHAR2(32000);
2384: l_dim_obj_sht_name BIS_LEVELS.Short_Name%TYPE;
2385:
2386: l_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2387: l_first_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2388: CURSOR c_dim_sht_names IS
2389: SELECT B.SHORT_NAME
2390: FROM BIS_LEVELS A

Line 2387: l_first_dim_short_name BIS_DIMENSIONS.short_name%TYPE;

2383: l_dim_obj_sht_names VARCHAR2(32000);
2384: l_dim_obj_sht_name BIS_LEVELS.Short_Name%TYPE;
2385:
2386: l_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2387: l_first_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2388: CURSOR c_dim_sht_names IS
2389: SELECT B.SHORT_NAME
2390: FROM BIS_LEVELS A
2391: , BIS_DIMENSIONS B

Line 2391: , BIS_DIMENSIONS B

2387: l_first_dim_short_name BIS_DIMENSIONS.short_name%TYPE;
2388: CURSOR c_dim_sht_names IS
2389: SELECT B.SHORT_NAME
2390: FROM BIS_LEVELS A
2391: , BIS_DIMENSIONS B
2392: WHERE B.DIMENSION_ID = A.DIMENSION_ID
2393: AND A.SHORT_NAME = l_dim_obj_sht_name;
2394:
2395: CURSOR c_bsc_dim_sht_names IS

Line 2551: l_application_id BIS_DIMENSIONS.Application_Id%TYPE;

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

Line 2568: FROM BIS_DIMENSIONS_VL

2564: WHERE short_name = l_dim_short_name;
2565:
2566: CURSOR cr_bis_dim_id IS
2567: SELECT name, description, dimension_id
2568: FROM BIS_DIMENSIONS_VL
2569: WHERE short_name = l_dim_short_name;
2570: BEGIN
2571: SAVEPOINT UpdateBSCDimensionPMD;
2572:

Line 2630: FROM BIS_DIMENSIONS_VL

2626: IF (p_display_name IS NOT NULL) THEN
2627: IF (p_display_name <> l_bis_dimension_rec.Dimension_Name) THEN
2628: l_pmf_disp_name := p_display_name;
2629: SELECT COUNT(1) INTO l_count
2630: FROM BIS_DIMENSIONS_VL
2631: WHERE UPPER(short_name) <> UPPER(l_dim_short_name)
2632: AND UPPER(name) = UPPER(p_display_name);
2633: WHILE(l_count > 0) LOOP
2634: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);

Line 2636: FROM BIS_DIMENSIONS_VL

2632: AND UPPER(name) = UPPER(p_display_name);
2633: WHILE(l_count > 0) LOOP
2634: l_pmf_disp_name := bsc_utility.get_Next_DispName(l_pmf_disp_name);
2635: SELECT COUNT(1) INTO l_count
2636: FROM BIS_DIMENSIONS_VL
2637: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
2638: END LOOP;
2639: END IF;
2640: END IF;

Line 2741: UPDATE BIS_DIMENSIONS

2737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2738: END IF;
2739: --update grp id in BIS Diemension Tables
2740: --this call will be moved to CRUD APIs later
2741: UPDATE BIS_DIMENSIONS
2742: SET Dim_Grp_ID =
2743: ( SELECT dim_group_id
2744: FROM BSC_SYS_DIM_GROUPS_VL
2745: WHERE Short_Name = l_bsc_dimension_rec.Bsc_Dim_Level_Group_short_name

Line 2937: FROM BIS_DIMENSIONS_VL

2933: RAISE FND_API.G_EXC_ERROR;
2934: END IF;
2935:
2936: SELECT COUNT(1) INTO l_count
2937: FROM BIS_DIMENSIONS_VL
2938: WHERE UPPER(short_name) <> UPPER(p_dim_short_name)
2939: AND UPPER(name) = UPPER(p_display_name);
2940: IF (l_count <> 0) THEN
2941: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

Line 3322: l_Bis_Group_ID BIS_DIMENSIONS.Dimension_ID%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;
3323: l_regions VARCHAR2(32000);
3324:
3325: CURSOR cr_bis_dim_short_name IS
3326: SELECT dimension_id

Line 3328: FROM BIS_DIMENSIONS_VL

3324:
3325: CURSOR cr_bis_dim_short_name IS
3326: SELECT dimension_id
3327: ,name
3328: FROM BIS_DIMENSIONS_VL
3329: WHERE short_name = p_dim_short_name;
3330:
3331: CURSOR cr_bsc_dimension_id IS
3332: SELECT dim_group_id