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_LEVELS

Line 313: CURSOR c_Bis_Levels IS

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
315: FROM BIS_LEVELS A
316: , BIS_DIMENSIONS B
317: WHERE A.Short_Name = p_Dim_Obj_Short_Name

Line 315: FROM BIS_LEVELS A

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

Line 327: IF (c_Bis_Levels%ISOPEN) THEN

323: WHERE Dim_Level_Id = l_Bsc_Dim_Obj_ID
324: AND Dim_Group_Id = l_Bsc_Group_ID;
325: BEGIN
326: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag procedure');
327: IF (c_Bis_Levels%ISOPEN) THEN
328: CLOSE c_Bis_Levels;
329: END IF;
330: OPEN c_Bis_Levels;
331: FETCH c_Bis_Levels

Line 328: CLOSE c_Bis_Levels;

324: AND Dim_Group_Id = l_Bsc_Group_ID;
325: BEGIN
326: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag procedure');
327: IF (c_Bis_Levels%ISOPEN) THEN
328: CLOSE c_Bis_Levels;
329: END IF;
330: OPEN c_Bis_Levels;
331: FETCH c_Bis_Levels
332: INTO l_Dim_Short_Name;

Line 330: OPEN c_Bis_Levels;

326: --DBMS_OUTPUT.PUT_LINE('Entered inside BSC_BIS_DIMENSION_PUB.Get_Primary_All_Flag procedure');
327: IF (c_Bis_Levels%ISOPEN) THEN
328: CLOSE c_Bis_Levels;
329: END IF;
330: OPEN c_Bis_Levels;
331: FETCH c_Bis_Levels
332: INTO l_Dim_Short_Name;
333: CLOSE c_Bis_Levels;
334:

Line 331: FETCH c_Bis_Levels

327: IF (c_Bis_Levels%ISOPEN) THEN
328: CLOSE c_Bis_Levels;
329: END IF;
330: OPEN c_Bis_Levels;
331: FETCH c_Bis_Levels
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);

Line 333: CLOSE c_Bis_Levels;

329: END IF;
330: OPEN c_Bis_Levels;
331: FETCH c_Bis_Levels
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:

Line 379: CURSOR c_Bis_Levels IS

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
381: FROM BIS_LEVELS A
382: , BIS_DIMENSIONS B
383: WHERE A.Short_Name = p_Dim_Obj_Short_Name

Line 381: FROM BIS_LEVELS A

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

Line 397: IF (c_Bis_Levels%ISOPEN) THEN

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;
400: OPEN c_Bis_Levels;
401: FETCH c_Bis_Levels

Line 398: CLOSE c_Bis_Levels;

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;
400: OPEN c_Bis_Levels;
401: FETCH c_Bis_Levels
402: INTO l_Dim_Short_Name;

Line 400: OPEN c_Bis_Levels;

396:
397: IF (c_Bis_Levels%ISOPEN) THEN
398: CLOSE c_Bis_Levels;
399: END IF;
400: OPEN c_Bis_Levels;
401: FETCH c_Bis_Levels
402: INTO l_Dim_Short_Name;
403: CLOSE c_Bis_Levels;
404:

Line 401: FETCH c_Bis_Levels

397: IF (c_Bis_Levels%ISOPEN) THEN
398: CLOSE c_Bis_Levels;
399: END IF;
400: OPEN c_Bis_Levels;
401: FETCH c_Bis_Levels
402: INTO l_Dim_Short_Name;
403: CLOSE c_Bis_Levels;
404:
405: --sync up all values

Line 403: CLOSE c_Bis_Levels;

399: END IF;
400: OPEN c_Bis_Levels;
401: FETCH c_Bis_Levels
402: INTO l_Dim_Short_Name;
403: CLOSE c_Bis_Levels;
404:
405: --sync up all values
406: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
407: IF (c_Total_Flag%ISOPEN) THEN

Line 457: l_bis_dim_level_rec BIS_LEVELS%ROWTYPE;

453:
454: l_bis_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
455: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
456:
457: l_bis_dim_level_rec BIS_LEVELS%ROWTYPE;
458:
459: CURSOR c_Bis_Levels IS
460: SELECT B.Short_Name
461: FROM BIS_LEVELS A

Line 459: CURSOR c_Bis_Levels IS

455: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
456:
457: l_bis_dim_level_rec BIS_LEVELS%ROWTYPE;
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

Line 461: FROM BIS_LEVELS A

457: l_bis_dim_level_rec BIS_LEVELS%ROWTYPE;
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:

Line 500: FROM BIS_LEVELS A

496: , MASTER_LEVEL
497: , ENABLED
498: , DRILL_TO_FORM_FUNCTION
499: , HIDE_IN_DESIGN
500: FROM BIS_LEVELS A
501: WHERE A.Short_Name = p_Dim_Obj_Short_Name;
502: BEGIN
503:
504: SAVEPOINT SyncPMFBSCDimsInPMD;

Line 505: IF (c_Bis_Levels%ISOPEN) THEN

501: WHERE A.Short_Name = p_Dim_Obj_Short_Name;
502: BEGIN
503:
504: SAVEPOINT SyncPMFBSCDimsInPMD;
505: IF (c_Bis_Levels%ISOPEN) THEN
506: CLOSE c_Bis_Levels;
507: END IF;
508:
509: OPEN c_Bis_Levels;

Line 506: CLOSE c_Bis_Levels;

502: BEGIN
503:
504: SAVEPOINT SyncPMFBSCDimsInPMD;
505: IF (c_Bis_Levels%ISOPEN) THEN
506: CLOSE c_Bis_Levels;
507: END IF;
508:
509: OPEN c_Bis_Levels;
510: FETCH c_Bis_Levels

Line 509: OPEN c_Bis_Levels;

505: IF (c_Bis_Levels%ISOPEN) THEN
506: CLOSE c_Bis_Levels;
507: END IF;
508:
509: OPEN c_Bis_Levels;
510: FETCH c_Bis_Levels
511: INTO l_Old_Dim_Short_Name;
512: CLOSE c_Bis_Levels;
513:

Line 510: FETCH c_Bis_Levels

506: CLOSE c_Bis_Levels;
507: END IF;
508:
509: OPEN c_Bis_Levels;
510: FETCH c_Bis_Levels
511: INTO l_Old_Dim_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);

Line 512: CLOSE c_Bis_Levels;

508:
509: OPEN c_Bis_Levels;
510: FETCH c_Bis_Levels
511: INTO l_Old_Dim_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);

Line 2053: FROM BIS_LEVELS

2049: WHERE Short_Name = l_dim_obj_name;
2050:
2051: CURSOR cr_bis_dim_ids IS
2052: SELECT Short_Name
2053: FROM BIS_LEVELS
2054: WHERE Dimension_Id = l_Bis_Group_ID;
2055: BEGIN
2056: SAVEPOINT UnAssBSCDimObjectPMD;
2057:

Line 2384: l_dim_obj_sht_name BIS_LEVELS.Short_Name%TYPE;

2380: l_unassign_dim_objs VARCHAR2(32000);
2381: l_flag BOOLEAN;
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

Line 2390: FROM BIS_LEVELS A

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
2392: WHERE B.DIMENSION_ID = A.DIMENSION_ID
2393: AND A.SHORT_NAME = l_dim_obj_sht_name;
2394:

Line 3319: l_Dim_Obj_Short_Name BIS_LEVELS.Short_Name%TYPE;

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;
3323: l_regions VARCHAR2(32000);

Line 3339: FROM BIS_LEVELS

3335: WHERE short_name = p_dim_short_name;
3336:
3337: CURSOR cr_bis_dim_ids IS
3338: SELECT Short_Name
3339: FROM BIS_LEVELS
3340: WHERE Dimension_Id = l_bis_dimension_rec.dimension_id;
3341: BEGIN
3342: SAVEPOINT DeleteBSCDimensionsPMD;
3343:

Line 3687: FROM bis_levels_vl

3683: , x_dim_lvl_name
3684: , x_dim_lvl_view_name
3685: , x_dim_lvl_pk_key
3686: , x_dim_lvl_name_col
3687: FROM bis_levels_vl
3688: WHERE UPPER(short_name) = UPPER(p_dim_lvl_shrt_name);
3689: END IF;
3690: EXCEPTION
3691: WHEN OTHERS THEN