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_DIM_OBJ_PUB dependencies on BIS_LEVELS

Line 45: REM | 19-APR-2004 PAJOHRI Bug #3583394, fix BIS_LEVELS UI Issues |

41: REM | 12-APR-2004 PAJOHRI Bug #3426566, modified the logic to use dimension|
42: REM | 'UNASSIGNED' always if there if no Dimension/ |
43: REM | Dimension Object association for PMF and retain |
44: REM | 'All Enable' flag |
45: REM | 19-APR-2004 PAJOHRI Bug #3583394, fix BIS_LEVELS UI Issues |
46: REM | Other issues related to Autonmous Transactions, |
47: REM | and performance also fixed, |
48: REM | 23-APR-2004 ASHANKAR Bug #3518610,Added the fucntion Validate |
49: REM | listbutton |

Line 411: CURSOR c_Bis_Levels IS

407: l_Bsc_Dim_Obj_ID BSC_SYS_DIM_LEVELS_B.Dim_Level_ID%TYPE;
408: l_Bsc_Group_ID BSC_SYS_DIM_GROUPS_TL.Dim_Group_ID%TYPE;
409: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
410:
411: CURSOR c_Bis_Levels IS
412: SELECT B.Short_Name
413: FROM BIS_LEVELS A
414: , BIS_DIMENSIONS B
415: WHERE A.Short_Name = p_Dim_Obj_Short_Name

Line 413: FROM BIS_LEVELS A

409: l_Dim_Short_Name BIS_DIMENSIONS.Short_Name%TYPE;
410:
411: CURSOR c_Bis_Levels IS
412: SELECT B.Short_Name
413: FROM BIS_LEVELS A
414: , BIS_DIMENSIONS B
415: WHERE A.Short_Name = p_Dim_Obj_Short_Name
416: AND A.Dimension_Id = B.Dimension_Id;
417: BEGIN

Line 421: IF (c_Bis_Levels%ISOPEN) THEN

417: BEGIN
418:
419: SAVEPOINT SyncPMFAllInPMD;
420: IF ((p_All_Enabled IS NOT NULL) AND ((p_All_Enabled = 0) OR (p_All_Enabled = -1))) THEN
421: IF (c_Bis_Levels%ISOPEN) THEN
422: CLOSE c_Bis_Levels;
423: END IF;
424: OPEN c_Bis_Levels;
425: FETCH c_Bis_Levels

Line 422: CLOSE c_Bis_Levels;

418:
419: SAVEPOINT SyncPMFAllInPMD;
420: IF ((p_All_Enabled IS NOT NULL) AND ((p_All_Enabled = 0) OR (p_All_Enabled = -1))) THEN
421: IF (c_Bis_Levels%ISOPEN) THEN
422: CLOSE c_Bis_Levels;
423: END IF;
424: OPEN c_Bis_Levels;
425: FETCH c_Bis_Levels
426: INTO l_Dim_Short_Name;

Line 424: OPEN c_Bis_Levels;

420: IF ((p_All_Enabled IS NOT NULL) AND ((p_All_Enabled = 0) OR (p_All_Enabled = -1))) THEN
421: IF (c_Bis_Levels%ISOPEN) THEN
422: CLOSE c_Bis_Levels;
423: END IF;
424: OPEN c_Bis_Levels;
425: FETCH c_Bis_Levels
426: INTO l_Dim_Short_Name;
427: CLOSE c_Bis_Levels;
428: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);

Line 425: FETCH c_Bis_Levels

421: IF (c_Bis_Levels%ISOPEN) THEN
422: CLOSE c_Bis_Levels;
423: END IF;
424: OPEN c_Bis_Levels;
425: FETCH c_Bis_Levels
426: INTO l_Dim_Short_Name;
427: CLOSE c_Bis_Levels;
428: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
429: l_Bsc_Dim_Obj_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);

Line 427: CLOSE c_Bis_Levels;

423: END IF;
424: OPEN c_Bis_Levels;
425: FETCH c_Bis_Levels
426: INTO l_Dim_Short_Name;
427: CLOSE c_Bis_Levels;
428: l_Bsc_Group_ID := BSC_BIS_DIMENSION_PUB.Get_Bsc_Dimension_ID(l_Dim_Short_Name);
429: l_Bsc_Dim_Obj_ID := BSC_BIS_DIM_OBJ_PUB.Get_Bsc_Dim_Obj_ID(p_Dim_Obj_Short_Name);
430:
431: UPDATE BSC_SYS_DIM_LEVELS_BY_GROUP

Line 830: 1 BIS_LEVELS.

826:
827: /*
828: This procedure allow user to create a new dimension category whose records
829: will be inserted into the following tables.
830: 1 BIS_LEVELS.
831: 2. BIS_LEVELS_TL
832: 3. BSC_SYS_DIM_LEVELS_B
833: 4. BSC_SYS_DIM_LEVELS_TL
834:

Line 831: 2. BIS_LEVELS_TL

827: /*
828: This procedure allow user to create a new dimension category whose records
829: will be inserted into the following tables.
830: 1 BIS_LEVELS.
831: 2. BIS_LEVELS_TL
832: 3. BSC_SYS_DIM_LEVELS_B
833: 4. BSC_SYS_DIM_LEVELS_TL
834:
835: Key

Line 881: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;

877: ) IS
878: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
879: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
881: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
882: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
883: l_bis_name BIS_LEVELS_TL.Name%TYPE;
884: l_user_id FND_USER.user_id%TYPE;
885: l_login_id NUMBER;

Line 882: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;

878: l_bsc_dim_obj_rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
879: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
881: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
882: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
883: l_bis_name BIS_LEVELS_TL.Name%TYPE;
884: l_user_id FND_USER.user_id%TYPE;
885: l_login_id NUMBER;
886: l_count NUMBER;

Line 883: l_bis_name BIS_LEVELS_TL.Name%TYPE;

879: l_bis_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
880: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
881: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
882: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
883: l_bis_name BIS_LEVELS_TL.Name%TYPE;
884: l_user_id FND_USER.user_id%TYPE;
885: l_login_id NUMBER;
886: l_count NUMBER;
887: l_temp_var BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;

Line 893: l_application_id BIS_LEVELS.Application_Id%TYPE;

889:
890: l_dim_short_names VARCHAR2(32000);
891: l_flag BOOLEAN := FALSE;
892: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
893: l_application_id BIS_LEVELS.Application_Id%TYPE;
894: -- Start Granular Locking added by Aditya
895: l_Dim_Tab BSC_BIS_LOCKS_PUB.t_numberTable;
896: l_dim_Grp_names VARCHAR2(32000);
897:

Line 914: FROM BIS_LEVELS_VL

910: CURSOR c_Master_Level IS
911: SELECT Short_Name
912: , Master_Level
913: , Name
914: FROM BIS_LEVELS_VL
915: WHERE Short_Name = p_Master_Level;
916: BEGIN
917:
918: SAVEPOINT CreateBSCDimObjPMD;

Line 945: FROM BIS_LEVELS_VL

941: FROM BSC_SYS_DIM_LEVELS_VL
942: WHERE UPPER(Short_Name) = UPPER(l_temp_var)
943: UNION
944: SELECT COUNT(1) rec_count
945: FROM BIS_LEVELS_VL
946: WHERE UPPER(Short_Name) = UPPER(l_temp_var))
947: WHERE rec_count > 0;
948: IF (l_count = 0) THEN
949: l_flag := FALSE;

Line 1016: FROM BIS_LEVELS_VL

1012: END IF;
1013: END IF;
1014: --check for uniqueness of l_dim_obj_name in PMF's metadata
1015: SELECT COUNT(1) INTO l_count
1016: FROM BIS_LEVELS_VL
1017: WHERE UPPER(short_name) = UPPER(l_dim_obj_name);
1018: IF (l_count > 0) THEN
1019: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1020: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIM_OBJ_SHORT_NAME'));

Line 1059: FROM BIS_LEVELS_VL

1055: -- start checkin for Default names
1056: l_pmf_disp_name := p_display_name;
1057: IF (p_data_source = 'PMF') THEN
1058: SELECT COUNT(1) INTO l_count
1059: FROM BIS_LEVELS_VL
1060: WHERE UPPER(name) = UPPER(p_display_name);
1061: IF (l_count <> 0) THEN
1062: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
1063: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DISPLAY_NAME'));

Line 1070: FROM BIS_LEVELS_VL

1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: ELSIF (p_data_source = 'BSC') THEN -- Allow insertion into BSC Data Model, with the same display name
1069: SELECT COUNT(1) INTO l_count
1070: FROM BIS_LEVELS_VL
1071: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
1072: WHILE(l_count > 0) LOOP
1073: l_pmf_disp_name := BSC_UTILITY.get_Next_DispName(l_pmf_disp_name);
1074: SELECT COUNT(1) INTO l_count

Line 1075: FROM BIS_LEVELS_VL

1071: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
1072: WHILE(l_count > 0) LOOP
1073: l_pmf_disp_name := BSC_UTILITY.get_Next_DispName(l_pmf_disp_name);
1074: SELECT COUNT(1) INTO l_count
1075: FROM BIS_LEVELS_VL
1076: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
1077: END LOOP;
1078: END IF;
1079:

Line 1267: --SELECT bis_levels_s.NextVal INTO l_bis_dim_level_rec.Dimension_Level_ID FROM DUAL;

1263: l_bis_dim_level_rec.where_Clause := p_where_clause;
1264: l_bis_dim_level_rec.application_id := l_application_id;
1265: l_bis_dim_level_rec.Source := l_bsc_dim_obj_rec.Source;
1266: l_bis_dim_level_rec.Comparison_Label_Code := p_comparison_label_code;
1267: --SELECT bis_levels_s.NextVal INTO l_bis_dim_level_rec.Dimension_Level_ID FROM DUAL;
1268:
1269: IF ((p_Long_Lov IS NULL) OR ((p_Long_Lov <> FND_API.G_TRUE) AND (p_Long_Lov <> FND_API.G_FALSE))) THEN
1270: l_bis_dim_level_rec.Long_Lov := FND_API.G_FALSE;
1271: ELSE

Line 1978: CURSOR c_Bis_Levels IS

1974: FUNCTION Retrieve_Primary_Dimension(
1975: p_Dim_Obj_Short_Name IN VARCHAR2
1976: ) RETURN VARCHAR2 IS
1977: l_Dim_Short_Name BIS_DIMENSIONS.SHORT_NAME%TYPE;
1978: CURSOR c_Bis_Levels IS
1979: SELECT B.Short_Name
1980: FROM BIS_LEVELS A
1981: , BIS_DIMENSIONS B
1982: WHERE A.Short_Name = p_Dim_Obj_Short_Name

Line 1980: FROM BIS_LEVELS A

1976: ) RETURN VARCHAR2 IS
1977: l_Dim_Short_Name BIS_DIMENSIONS.SHORT_NAME%TYPE;
1978: CURSOR c_Bis_Levels IS
1979: SELECT B.Short_Name
1980: FROM BIS_LEVELS A
1981: , BIS_DIMENSIONS B
1982: WHERE A.Short_Name = p_Dim_Obj_Short_Name
1983: AND A.Dimension_Id = B.Dimension_Id;
1984: BEGIN

Line 1985: OPEN c_Bis_Levels;

1981: , BIS_DIMENSIONS B
1982: WHERE A.Short_Name = p_Dim_Obj_Short_Name
1983: AND A.Dimension_Id = B.Dimension_Id;
1984: BEGIN
1985: OPEN c_Bis_Levels;
1986: FETCH c_Bis_Levels INTO l_Dim_Short_Name;
1987: CLOSE c_Bis_Levels;
1988: RETURN l_Dim_Short_Name;
1989: EXCEPTION

Line 1986: FETCH c_Bis_Levels INTO l_Dim_Short_Name;

1982: WHERE A.Short_Name = p_Dim_Obj_Short_Name
1983: AND A.Dimension_Id = B.Dimension_Id;
1984: BEGIN
1985: OPEN c_Bis_Levels;
1986: FETCH c_Bis_Levels INTO l_Dim_Short_Name;
1987: CLOSE c_Bis_Levels;
1988: RETURN l_Dim_Short_Name;
1989: EXCEPTION
1990: WHEN OTHERS THEN

Line 1987: CLOSE c_Bis_Levels;

1983: AND A.Dimension_Id = B.Dimension_Id;
1984: BEGIN
1985: OPEN c_Bis_Levels;
1986: FETCH c_Bis_Levels INTO l_Dim_Short_Name;
1987: CLOSE c_Bis_Levels;
1988: RETURN l_Dim_Short_Name;
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991: RETURN NULL;

Line 2000: 1 BIS_LEVELS.

1996: *********************************************************************************/
1997: /*
1998: This procedure allows user to update a dimension. These changes will
1999: be reflected into the following metadata: -
2000: 1 BIS_LEVELS.
2001: 2. BIS_LEVELS_TL
2002: 3. BSC_SYS_DIM_LEVELS_B
2003: 4. BSC_SYS_DIM_LEVELS_TL
2004:

Line 2001: 2. BIS_LEVELS_TL

1997: /*
1998: This procedure allows user to update a dimension. These changes will
1999: be reflected into the following metadata: -
2000: 1 BIS_LEVELS.
2001: 2. BIS_LEVELS_TL
2002: 3. BSC_SYS_DIM_LEVELS_B
2003: 4. BSC_SYS_DIM_LEVELS_TL
2004:
2005: Key:

Line 2058: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;

2054:
2055: l_temp_var BSC_SYS_DIM_LEVELS_B.abbreviation%TYPE;
2056: l_source_table VARCHAR(33);
2057: l_bsc_dim_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
2058: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
2059: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2060: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
2061: l_application_id BIS_LEVELS.Application_Id%TYPE;
2062: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;

Line 2061: l_application_id BIS_LEVELS.Application_Id%TYPE;

2057: l_bsc_dim_id BSC_SYS_DIM_LEVELS_B.Dim_Level_Id%TYPE;
2058: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
2059: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2060: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
2061: l_application_id BIS_LEVELS.Application_Id%TYPE;
2062: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
2063: l_bis_name BIS_LEVELS_TL.Name%TYPE;
2064: l_flag BOOLEAN := FALSE;
2065: l_struct_change BOOLEAN := FALSE;

Line 2062: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;

2058: l_level_table_name BIS_LEVELS.LEVEL_VALUES_VIEW_NAME%TYPE;
2059: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2060: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
2061: l_application_id BIS_LEVELS.Application_Id%TYPE;
2062: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
2063: l_bis_name BIS_LEVELS_TL.Name%TYPE;
2064: l_flag BOOLEAN := FALSE;
2065: l_struct_change BOOLEAN := FALSE;
2066: l_child_struc BOOLEAN := FALSE;

Line 2063: l_bis_name BIS_LEVELS_TL.Name%TYPE;

2059: l_dim_obj_name BSC_SYS_DIM_LEVELS_B.Short_Name%TYPE;
2060: l_dim_Grp_name BSC_SYS_DIM_GROUPS_TL.short_name%TYPE;
2061: l_application_id BIS_LEVELS.Application_Id%TYPE;
2062: l_bis_short_name BIS_LEVELS.Short_Name%TYPE;
2063: l_bis_name BIS_LEVELS_TL.Name%TYPE;
2064: l_flag BOOLEAN := FALSE;
2065: l_struct_change BOOLEAN := FALSE;
2066: l_child_struc BOOLEAN := FALSE;
2067: l_create_pmf BOOLEAN := FALSE;--must be false

Line 2103: FROM BIS_LEVELS A

2099:
2100: /* ADDED BY RAVI *********/
2101: CURSOR c_dim_short_name IS
2102: SELECT B.SHORT_NAME
2103: FROM BIS_LEVELS A
2104: , BIS_DIMENSIONS B
2105: WHERE B.DIMENSION_ID = A.DIMENSION_ID
2106: AND A.SHORT_NAME = p_dim_obj_short_name;
2107: --dimension_level_short_name = p_dim_obj_short_name;

Line 2119: FROM BIS_LEVELS_VL

2115: CURSOR c_Master_Level IS
2116: SELECT Short_Name
2117: , Master_Level
2118: , Name
2119: FROM BIS_LEVELS_VL
2120: WHERE Short_Name = p_Master_Level;
2121:
2122:
2123: CURSOR c_Kpi_Dim_Set1 IS

Line 2175: FROM BIS_LEVELS

2171: END IF;
2172:
2173: --check if short_name exists in the PMF system
2174: SELECT COUNT(1) INTO l_count
2175: FROM BIS_LEVELS
2176: WHERE short_name = l_dim_obj_name;
2177: IF (l_count = 0) THEN
2178: FND_MESSAGE.SET_NAME('BSC','BSC_MUSER_DELETE_MESSAGE');
2179: FND_MESSAGE.SET_TOKEN('TYPE', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), TRUE);

Line 2219: FROM BIS_LEVELS_VL

2215: l_pmf_disp_name := p_display_name;
2216: IF (p_display_name <> l_bis_dim_level_rec.Dimension_Level_Name) THEN
2217: IF (p_data_source = 'PMF') THEN
2218: SELECT COUNT(1) INTO l_count
2219: FROM BIS_LEVELS_VL
2220: WHERE UPPER(short_name) <> UPPER(l_dim_obj_name)
2221: AND UPPER(name) = UPPER(p_display_name);
2222: IF (l_count <> 0) THEN
2223: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

Line 2231: FROM BIS_LEVELS_VL

2227: RAISE FND_API.G_EXC_ERROR;
2228: END IF;
2229: ELSIF (p_data_source = 'BSC') THEN -- Allow insertion into BSC Data Model, with the same display name
2230: SELECT COUNT(1) INTO l_count
2231: FROM BIS_LEVELS_VL
2232: WHERE UPPER(short_name) <> UPPER(l_dim_obj_name)
2233: AND UPPER(name) = UPPER(l_pmf_disp_name);
2234:
2235: WHILE(l_count > 0) LOOP

Line 2238: FROM BIS_LEVELS_VL

2234:
2235: WHILE(l_count > 0) LOOP
2236: l_pmf_disp_name := BSC_UTILITY.get_Next_DispName(l_pmf_disp_name);
2237: SELECT COUNT(1) INTO l_count
2238: FROM BIS_LEVELS_VL
2239: WHERE UPPER(name) = UPPER(l_pmf_disp_name);
2240: END LOOP;
2241: END IF;
2242: END IF;

Line 2450: FROM BIS_LEVELS

2446: END IF;
2447: END IF;
2448:
2449: SELECT level_id INTO l_bis_dim_level_rec.Dimension_Level_ID
2450: FROM BIS_LEVELS
2451: WHERE short_name = l_dim_obj_name;
2452:
2453: /********DISABLED BY RAVI ****************/
2454: --l_bis_dim_level_rec.Dimension_Short_Name := 'UNASSIGNED';

Line 2531: FROM BIS_LEVELS

2527: FND_MSG_PUB.ADD;
2528: RAISE FND_API.G_EXC_ERROR;
2529: END IF;
2530: SELECT COUNT(1) INTO l_Count
2531: FROM BIS_LEVELS
2532: WHERE Master_Level = l_bis_dim_level_rec.Dimension_Level_Short_Name;
2533: IF (l_Count <> 0) THEN
2534: FND_MESSAGE.SET_NAME('BIS','BIS_PMF_UPD_NO_MASTER');
2535: FND_MESSAGE.SET_TOKEN('BIS_OBJ_UPD', NVL(l_bis_dim_level_rec.Dimension_Level_Name, l_bis_dim_level_rec.Dimension_Level_Short_Name));

Line 3193: 1 BIS_LEVELS.

3189: *********************************************************************************/
3190: /*
3191: This procedure allows user to delete a dimension. Respective records will be
3192: deleted from the following metadata: -
3193: 1 BIS_LEVELS.
3194: 2. BIS_LEVELS_TL
3195: 3. BSC_SYS_DIM_LEVELS_B
3196: 4. BSC_SYS_DIM_LEVELS_TL
3197:

Line 3194: 2. BIS_LEVELS_TL

3190: /*
3191: This procedure allows user to delete a dimension. Respective records will be
3192: deleted from the following metadata: -
3193: 1 BIS_LEVELS.
3194: 2. BIS_LEVELS_TL
3195: 3. BSC_SYS_DIM_LEVELS_B
3196: 4. BSC_SYS_DIM_LEVELS_TL
3197:
3198: Validations:

Line 3238: SELECT COUNT(1) INTO l_count FROM BIS_LEVELS

3234: RAISE FND_API.G_EXC_ERROR;
3235: END IF;
3236: -- CALL PMF'S API
3237: --check if short_name exists in the PMF system
3238: SELECT COUNT(1) INTO l_count FROM BIS_LEVELS
3239: WHERE short_name = p_dim_obj_short_name;
3240: IF (l_count <> 0) THEN
3241: l_bis_dim_level_rec.Dimension_Level_Short_Name := p_dim_obj_short_name;
3242: SELECT COUNT(1) INTO l_Count

Line 3243: FROM BIS_LEVELS

3239: WHERE short_name = p_dim_obj_short_name;
3240: IF (l_count <> 0) THEN
3241: l_bis_dim_level_rec.Dimension_Level_Short_Name := p_dim_obj_short_name;
3242: SELECT COUNT(1) INTO l_Count
3243: FROM BIS_LEVELS
3244: WHERE Master_Level = l_bis_dim_level_rec.Dimension_Level_Short_Name;
3245: IF (l_Count <> 0) THEN
3246: FND_MESSAGE.SET_NAME('BIS','BIS_MASTER_DELETE_DIM_OBJ');
3247: FND_MSG_PUB.ADD;

Line 5941: ( p_Short_Name IN BIS_LEVELS.Short_Name%TYPE

5937: /*********************************************************************************************
5938: Returns the Dimension Object ID of BIS
5939: *********************************************************************************************/
5940: FUNCTION Get_Bis_Dim_Obj_ID
5941: ( p_Short_Name IN BIS_LEVELS.Short_Name%TYPE
5942: ) RETURN NUMBER IS
5943:
5944: l_dim_id BIS_LEVELS.Level_ID%TYPE;
5945:

Line 5944: l_dim_id BIS_LEVELS.Level_ID%TYPE;

5940: FUNCTION Get_Bis_Dim_Obj_ID
5941: ( p_Short_Name IN BIS_LEVELS.Short_Name%TYPE
5942: ) RETURN NUMBER IS
5943:
5944: l_dim_id BIS_LEVELS.Level_ID%TYPE;
5945:
5946: CURSOR c_Dim_Group_Id IS
5947: SELECT Level_ID
5948: FROM BIS_LEVELS

Line 5948: FROM BIS_LEVELS

5944: l_dim_id BIS_LEVELS.Level_ID%TYPE;
5945:
5946: CURSOR c_Dim_Group_Id IS
5947: SELECT Level_ID
5948: FROM BIS_LEVELS
5949: WHERE Short_Name = p_Short_Name;
5950: BEGIN
5951: IF (c_Dim_Group_Id%ISOPEN) THEN
5952: CLOSE c_Dim_Group_Id;

Line 6015: FROM BIS_LEVELS A

6011: , A.Level_Values_View_Name
6012: , A.Hide_In_Design
6013: , B.Level_Table_Name
6014: , B.Dim_Level_Id
6015: FROM BIS_LEVELS A
6016: , BSC_SYS_DIM_LEVELS_B B
6017: WHERE A.Short_Name = B.Short_Name
6018: AND B.Source = 'PMF'
6019: AND A.Source = 'OLTP';

Line 6029: FROM BIS_LEVELS A

6025: , A.Level_Values_View_Name
6026: , A.Hide_In_Design
6027: , B.Level_Table_Name
6028: , B.Dim_Level_Id
6029: FROM BIS_LEVELS A
6030: , BSC_SYS_DIM_LEVELS_B B
6031: WHERE A.Short_Name = B.Short_Name
6032: AND B.Source = 'PMF'
6033: AND A.Source = 'OLTP'

Line 6118: FROM BIS_LEVELS A

6114: l_sql VARCHAR2(50);
6115: CURSOR c_Pmf_Dim_Obj_Edw is
6116: SELECT A.Short_Name
6117: , B.Level_Table_Name
6118: FROM BIS_LEVELS A
6119: , BSC_SYS_DIM_LEVELS_B B
6120: WHERE A.Short_Name = B.Short_Name
6121: AND B.Source = 'PMF'
6122: AND A.Source = 'EDW'

Line 6413: , BIS_LEVELS L

6409: SELECT R.SHORT_NAME CHILD_SHORT_NAME
6410: , R.RELATION_COL PARENT_COL
6411: , L.LEVEL_VALUES_VIEW_NAME VIEW_NAME
6412: FROM BSC_SYS_DIM_LEVEL_RELS_V R
6413: , BIS_LEVELS L
6414: WHERE R.SHORT_NAME = L.SHORT_NAME
6415: AND L.SHORT_NAME = p_Dim_Obj_Short_Name
6416: AND R.SOURCE = 'PMF';
6417:

Line 6446: FROM BIS_LEVELS L

6442: ELSE
6443: BEGIN
6444: SELECT L.LEVEL_VALUES_VIEW_NAME
6445: INTO l_View_Name
6446: FROM BIS_LEVELS L
6447: WHERE L.SHORT_NAME = p_Dim_Obj_Short_Name;
6448: EXCEPTION
6449: WHEN OTHERS THEN
6450: l_View_Name := NULL;

Line 7181: FROM bsc_sys_dim_levels_vl bsc, bis_levels_vl bis

7177: BEGIN
7178:
7179: SELECT bsc.name, bis.LEVEL_VALUES_VIEW_NAME, bsc.source
7180: INTO l_name, l_Dim_Obj_View_Name, l_source
7181: FROM bsc_sys_dim_levels_vl bsc, bis_levels_vl bis
7182: WHERE bsc.short_name = bis.short_name
7183: AND bsc.short_name = p_Dim_Obj_Short_Name;
7184:
7185: IF (l_source = BSC_UTILITY.c_PMF) THEN