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.BIS_DIMENSION_PVT dependencies on BIS_DIMENSIONS

Line 41: REM | which is added into the bis_dimensions |

37: REM | 07-JUL-2003 arhegde bug#3028436 Added get_unique_dim_group_name() |
38: REM | 09-JUL-2003 arhegde bug#3028436 Moved logic to BSC API from here |
39: REM | Removed get_unique_dim_group_name() |
40: REM | 11-JUL-03 MAHRAO Modified the package, to handle dim_grp_ID |
41: REM | which is added into the bis_dimensions |
42: REM | 29-JUN-2004 ankgoel bug#3711250 Handle translation of dimension_id=-1 |
43: REM | 30-Jul-04 rpenneru Modified for enhancemen#3748519 |
44: REM | 29-SEP-2004 ankgoel Added WHO columns in Rec for Bug#3891748 |
45: REM | 21-DEC-04 vtulasi Modified for bug#4045278 - Addtion of LUD |

Line 306: FROM bis_dimensions_vl

302: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
303: CURSOR cr_dim_id IS
304: SELECT dimension_id, short_name, name, description,
305: application_id, dim_grp_id, hide_in_design
306: FROM bis_dimensions_vl
307: WHERE dimension_id=p_Dimension_Rec.dimension_id;
308:
309: CURSOR cr_dim_short_name IS
310: SELECT dimension_id, short_name, name, description,

Line 312: FROM bis_dimensions_vl

308:
309: CURSOR cr_dim_short_name IS
310: SELECT dimension_id, short_name, name, description,
311: application_id, dim_grp_id, hide_in_design
312: FROM bis_dimensions_vl
313: WHERE short_name=p_Dimension_Rec.dimension_short_name;
314:
315: CURSOR cr_dim_name IS
316: SELECT dimension_id, short_name, name, description,

Line 318: FROM bis_dimensions_vl

314:
315: CURSOR cr_dim_name IS
316: SELECT dimension_id, short_name, name, description,
317: application_id, dim_grp_id, hide_in_design
318: FROM bis_dimensions_vl
319: WHERE name=p_Dimension_Rec.dimension_name;
320:
321: begin
322:

Line 543: SELECT bis_dimensions_s.NextVal INTO l_id from dual;

539:
540: IF ( l_Dimension_Rec.Dimension_Short_Name = C_UNASSIGNED ) THEN
541: l_id := -1;
542: ELSE
543: SELECT bis_dimensions_s.NextVal INTO l_id from dual;
544: END IF;
545:
546: l_Dimension_Rec.Last_Update_Date := NVL(p_Dimension_Rec.Last_Update_Date, SYSDATE);
547:

Line 625: INSERT INTO bis_dimensions(

621: BEGIN
622:
623: SAVEPOINT InsertIntoBISDims;
624:
625: INSERT INTO bis_dimensions(
626: DIMENSION_ID
627: , SHORT_NAME
628: , APPLICATION_ID
629: , DIM_GRP_ID

Line 651: INSERT INTO bis_dimensions_tl (

647: , p_login_id
648: );
649:
650:
651: INSERT INTO bis_dimensions_tl (
652: DIMENSION_ID,
653: LANGUAGE,
654: NAME,
655: DESCRIPTION,

Line 677: , BIS_DIMENSIONS D

673: , p_login_id
674: , 'Y'
675: , userenv('LANG')
676: FROM FND_LANGUAGES L
677: , BIS_DIMENSIONS D
678: WHERE L.INSTALLED_FLAG IN ('I', 'B')
679: AND D.SHORT_NAME = p_dimension_short_name
680: AND NOT EXISTS
681: (SELECT 'EXISTS'

Line 682: FROM BIS_DIMENSIONS_TL TL

678: WHERE L.INSTALLED_FLAG IN ('I', 'B')
679: AND D.SHORT_NAME = p_dimension_short_name
680: AND NOT EXISTS
681: (SELECT 'EXISTS'
682: FROM BIS_DIMENSIONS_TL TL
683: , BIS_DIMENSIONS D
684: WHERE TL.DIMENSION_ID = D.DIMENSION_ID
685: AND D.SHORT_NAME = p_dimension_short_name
686: AND TL.LANGUAGE = L.LANGUAGE_CODE) ;

Line 683: , BIS_DIMENSIONS D

679: AND D.SHORT_NAME = p_dimension_short_name
680: AND NOT EXISTS
681: (SELECT 'EXISTS'
682: FROM BIS_DIMENSIONS_TL TL
683: , BIS_DIMENSIONS D
684: WHERE TL.DIMENSION_ID = D.DIMENSION_ID
685: AND D.SHORT_NAME = p_dimension_short_name
686: AND TL.LANGUAGE = L.LANGUAGE_CODE) ;
687:

Line 810: Update bis_dimensions

806: --
807:
808: l_Dimension_Rec.Last_Update_Date := NVL(p_Dimension_Rec.Last_Update_Date, SYSDATE);
809:
810: Update bis_dimensions
811: set
812: SHORT_NAME = l_Dimension_Rec.Dimension_Short_Name
813: , APPLICATION_ID = l_Dimension_Rec.Application_ID
814: , DIM_GRP_ID = l_Dimension_Rec.dim_grp_id

Line 958: Update bis_dimensions_TL

954: --
955:
956: l_Dimension_Rec.Last_Update_Date := NVL(p_Dimension_Rec.Last_Update_Date, SYSDATE);
957:
958: Update bis_dimensions_TL
959: set
960: NAME = l_Dimension_Rec.Dimension_Name
961: , DESCRIPTION = l_Dimension_Rec.description
962: , LAST_UPDATE_DATE = l_Dimension_Rec.Last_Update_Date

Line 1125: FROM bis_dimensions_vl

1121:
1122: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Short_Name)
1123: = FND_API.G_TRUE) THEN
1124: SELECT dimension_id INTO x_Dimension_ID
1125: FROM bis_dimensions_vl
1126: WHERE short_name = p_Dimension_Short_Name;
1127: elsIF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Name)
1128: = FND_API.G_TRUE) THEN
1129: SELECT dimension_id INTO x_Dimension_ID

Line 1130: FROM bis_dimensions_vl

1126: WHERE short_name = p_Dimension_Short_Name;
1127: elsIF (BIS_UTILITIES_PUB.Value_Not_Missing(p_Dimension_Name)
1128: = FND_API.G_TRUE) THEN
1129: SELECT dimension_id INTO x_Dimension_ID
1130: FROM bis_dimensions_vl
1131: WHERE name = p_Dimension_Name;
1132: else
1133: l_error_tbl := x_error_tbl;
1134: BIS_UTILITIES_PVT.Add_Error_Message

Line 1247: DELETE FROM bis_dimensions WHERE

1243: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246:
1247: DELETE FROM bis_dimensions WHERE
1248: DIMENSION_ID = l_Dimension_Rec.dimension_id;
1249:
1250: DELETE FROM bis_dimensions_tl WHERE
1251: DIMENSION_ID = l_Dimension_Rec.dimension_id;

Line 1250: DELETE FROM bis_dimensions_tl WHERE

1246:
1247: DELETE FROM bis_dimensions WHERE
1248: DIMENSION_ID = l_Dimension_Rec.dimension_id;
1249:
1250: DELETE FROM bis_dimensions_tl WHERE
1251: DIMENSION_ID = l_Dimension_Rec.dimension_id;
1252: IF (p_commit = FND_API.G_TRUE) THEN
1253: COMMIT;
1254: END if;

Line 1302: FROM BIS_DIMENSIONS

1298: l_login_id := fnd_global.LOGIN_ID;
1299:
1300: SELECT DIMENSION_ID
1301: INTO l_dim_id
1302: FROM BIS_DIMENSIONS
1303: WHERE SHORT_NAME = p_Dimension_Rec.Dimension_Short_Name;
1304:
1305: UPDATE BIS_DIMENSIONS_TL
1306: SET NAME = p_Dimension_Rec.Dimension_Name

Line 1305: UPDATE BIS_DIMENSIONS_TL

1301: INTO l_dim_id
1302: FROM BIS_DIMENSIONS
1303: WHERE SHORT_NAME = p_Dimension_Rec.Dimension_Short_Name;
1304:
1305: UPDATE BIS_DIMENSIONS_TL
1306: SET NAME = p_Dimension_Rec.Dimension_Name
1307: ,DESCRIPTION = p_Dimension_Rec.Description
1308: ,LAST_UPDATE_DATE = p_Dimension_Rec.Last_Update_Date
1309: ,LAST_UPDATED_BY = l_user_id

Line 1356: FROM bis_dimensions_vl BD, bsc_sys_dim_groups_vl BG

1352: FROM bsc_sys_dim_levels_by_group DLG, bsc_sys_dim_levels_b DLB
1353: WHERE DLB.source = 'PMF'
1354: AND DLG.dim_level_id = DLB.dim_level_id
1355: AND BG.dim_group_id = DLG.dim_group_id), 0, 'BSC', 'PMF') type
1356: FROM bis_dimensions_vl BD, bsc_sys_dim_groups_vl BG
1357: WHERE UPPER(BD.Name) = UPPER(p_Dimension_Name)
1358: AND BD.dim_grp_id = BG.dim_group_id
1359: AND BD.short_name <> p_Dimension_Short_Name;
1360:

Line 1365: FROM bis_dimensions_vl

1361: l_unique_name_rec c_unique_name%ROWTYPE;
1362: l_count NUMBER;
1363: BEGIN
1364: SELECT COUNT(1) INTO l_count
1365: FROM bis_dimensions_vl
1366: WHERE UPPER(name) = UPPER(p_Dimension_Name)
1367: AND short_name <> p_Dimension_Short_Name;
1368:
1369: IF (l_count <> 0) THEN

Line 1396: FROM bis_dimensions_vl

1392: WHILE (l_count > 0) LOOP
1393: l_new_disp_name := BSC_UTILITY.get_Next_DispName(l_new_disp_name);
1394:
1395: SELECT COUNT(1) INTO l_count
1396: FROM bis_dimensions_vl
1397: WHERE UPPER(name) = UPPER(l_new_disp_name);
1398:
1399: END LOOP;
1400:

Line 1401: UPDATE bis_dimensions_tl

1397: WHERE UPPER(name) = UPPER(l_new_disp_name);
1398:
1399: END LOOP;
1400:
1401: UPDATE bis_dimensions_tl
1402: SET name = l_new_disp_name
1403: WHERE dimension_id = (SELECT dimension_id FROM bis_dimensions WHERE short_name = p_Dimension_Short_Name)
1404: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1405:

Line 1403: WHERE dimension_id = (SELECT dimension_id FROM bis_dimensions WHERE short_name = p_Dimension_Short_Name)

1399: END LOOP;
1400:
1401: UPDATE bis_dimensions_tl
1402: SET name = l_new_disp_name
1403: WHERE dimension_id = (SELECT dimension_id FROM bis_dimensions WHERE short_name = p_Dimension_Short_Name)
1404: AND userenv('LANG') IN (LANGUAGE, SOURCE_LANG);
1405:
1406: EXCEPTION
1407: WHEN OTHERS THEN