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_DIMENSION_LEVELS_PVT dependencies on BSC_SYS_DIM_LEVELS_B

Line 65: FROM BSC_SYS_DIM_LEVELS_B

61: BEGIN
62:
63: SELECT COUNT(Dim_Level_Id)
64: INTO l_Count
65: FROM BSC_SYS_DIM_LEVELS_B
66: WHERE Dim_Level_Id = p_Dim_Level_Id;
67:
68: RETURN l_count;
69: EXCEPTION

Line 266: FROM BSC_SYS_DIM_LEVELS_B

262: CURSOR c_drop_tabs IS
263: SELECT LEVEL_TABLE_NAME,
264: LEVEL_VIEW_NAME,
265: NVL(SOURCE, 'BSC') SOURCE
266: FROM BSC_SYS_DIM_LEVELS_B
267: WHERE DIM_LEVEL_ID = p_Dim_Level_Rec.Bsc_Level_Id;
268: begin
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: FND_MSG_PUB.Initialize;

Line 466: g_db_object := 'BSC_SYS_DIM_LEVELS_B';

462: FND_MSG_PUB.ADD;
463: RAISE FND_API.G_EXC_ERROR;
464: end if;
465:
466: g_db_object := 'BSC_SYS_DIM_LEVELS_B';
467:
468: -- insert the pertaining values into table bsc_sys_dim_levels_b.
469: -- Reminder: Some values are hard coded, need to get them from somewhere.
470: --if source= 'PMF' same values will be inserted for level_table_name, level_view_name

Line 468: -- insert the pertaining values into table bsc_sys_dim_levels_b.

464: end if;
465:
466: g_db_object := 'BSC_SYS_DIM_LEVELS_B';
467:
468: -- insert the pertaining values into table bsc_sys_dim_levels_b.
469: -- Reminder: Some values are hard coded, need to get them from somewhere.
470: --if source= 'PMF' same values will be inserted for level_table_name, level_view_name
471: --if source= 'BSC' level_table_name will contain the name of master table and
472: -- level_view_name will contain the name of view name.

Line 480: insert into BSC_SYS_DIM_LEVELS_B( dim_level_id

476: l_level_view_name := p_Dim_Level_Rec.Bsc_Level_View_Name;
477: END IF;
478: l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);
479:
480: insert into BSC_SYS_DIM_LEVELS_B( dim_level_id
481: ,level_table_name
482: ,table_type
483: ,level_pk_col
484: ,abbreviation

Line 656: from BSC_SYS_DIM_LEVELS_B a

652: ,x_Dim_Level_Rec.Bsc_Creation_Date -- PMD
653: ,x_Dim_Level_Rec.Bsc_Last_Updated_By -- PMD
654: ,x_Dim_Level_Rec.Bsc_Last_Update_Date -- PMD
655: ,x_Dim_Level_Rec.Bsc_Last_Update_Login -- PMD
656: from BSC_SYS_DIM_LEVELS_B a
657: ,BSC_SYS_DIM_LEVELS_TL b
658: where a.dim_level_id = b.dim_level_id
659: and a.dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id
660: and b.language = NVL(p_Dim_Level_Rec.Bsc_Language,USERENV('LANG')); --Bug #3528143

Line 828: update BSC_SYS_DIM_LEVELS_B

824:
825:
826: l_Dim_Level_Rec.Bsc_Last_Update_Date := NVL(p_Dim_Level_Rec.Bsc_Last_Update_Date, SYSDATE);
827:
828: update BSC_SYS_DIM_LEVELS_B
829: set level_table_name = l_Dim_Level_Rec.Bsc_Level_Name
830: ,table_type = l_Dim_Level_Rec.Bsc_Level_Table_Type
831: ,level_pk_col = l_Dim_Level_Rec.Bsc_Pk_Col
832: ,abbreviation = l_Dim_Level_Rec.Bsc_Level_Abbreviation

Line 919: delete from BSC_SYS_DIM_LEVELS_B

915:
916: begin
917: x_return_status := FND_API.G_RET_STS_SUCCESS;
918: SAVEPOINT DeleteBSCDimLevMdPVT;
919: delete from BSC_SYS_DIM_LEVELS_B
920: where dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;
921:
922: delete from BSC_SYS_DIM_LEVELS_TL
923: where dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;

Line 927: DELETE FROM BSC_SYS_DIM_LEVELS_BY_GROUP

923: where dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;
924:
925: --PAJOHRI Added 01-JUN-2003
926: -- delete dimensin from groups
927: DELETE FROM BSC_SYS_DIM_LEVELS_BY_GROUP
928: WHERE dim_level_id = p_Dim_Level_Rec.Bsc_Level_Id;
929:
930: --delete dimension from relationships
931: DELETE FROM BSC_SYS_DIM_LEVEL_RELS

Line 1338: IF (UPPER(p_table_name) = 'BSC_SYS_DIM_LEVELS_B') THEN

1334: begin
1335:
1336: -- Check if it is a Dimension Level, Group, Dataset or a Measure.
1337:
1338: IF (UPPER(p_table_name) = 'BSC_SYS_DIM_LEVELS_B') THEN
1339: SELECT BSC_SYS_DIM_LEVEL_ID_S.NEXTVAL
1340: INTO l_next
1341: FROM DUAL;
1342: ELSIF (UPPER(p_table_name) = 'BSC_SYS_DIM_GROUPS_TL') THEN

Line 1471: FROM BSC_SYS_DIM_LEVELS_B

1467: l_msg_count number;
1468:
1469: begin
1470: SELECT COUNT(*) INTO l_Count
1471: FROM BSC_SYS_DIM_LEVELS_B
1472: WHERE Level_Table_Name = p_level_name;
1473:
1474: RETURN l_Count;
1475: EXCEPTION

Line 1779: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);

1775: -- Validate level id exists.
1776:
1777: IF ((p_Dim_Level_Rec.Bsc_Level_Id IS NOT NULL) AND (p_Dim_Level_Rec.Bsc_Parent_Level_Id IS NOT NULL)) THEN
1778:
1779: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1780: IF (l_count = 0) THEN
1781: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1782: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Level_Id);
1783: FND_MSG_PUB.ADD;

Line 1787: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);

1783: FND_MSG_PUB.ADD;
1784: RAISE FND_API.G_EXC_ERROR;
1785: END IF;
1786:
1787: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1788: IF (l_count = 0) THEN
1789: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
1790: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Dim_Level_Rec.Bsc_Parent_Level_Id);
1791: FND_MSG_PUB.ADD;

Line 2063: FROM BSC_SYS_DIM_LEVELS_B

2059: ELSIF v_parent = p_Parent_Dim_Level_Id THEN
2060:
2061: SELECT COUNT(dim_level_id)
2062: INTO l_count
2063: FROM BSC_SYS_DIM_LEVELS_B
2064: WHERE dim_level_id = p_Parent_Dim_Level_Id
2065: AND source = 'PMF';
2066:
2067: IF (l_count <> 0) THEN

Line 2099: FROM BSC_SYS_DIM_LEVELS_B

2095: END LOOP;
2096: ELSE
2097: SELECT COUNT(dim_level_id)
2098: INTO l_count
2099: FROM BSC_SYS_DIM_LEVELS_B
2100: WHERE dim_level_id = p_Parent_Dim_Level_Id
2101: AND source = 'PMF';
2102:
2103: IF (l_count <> 0) THEN

Line 2210: from BSC_SYS_DIM_LEVELS_B

2206: BEGIN
2207:
2208: Select DIM_LEVEL_ID
2209: into v_Id
2210: from BSC_SYS_DIM_LEVELS_B
2211: where SHORT_NAME = p_Short_Name;
2212:
2213: RETURN v_Id;
2214:

Line 2308: FROM BSC_SYS_DIM_LEVELS_B

2304: , x_Dim_Level_Rec.Bsc_Relation_Type;
2305: CLOSE cr_getId_rels;
2306: ELSIF ((p_Dim_Level_Rec.Bsc_Level_Short_Name IS NOT NULL) AND (p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name IS NOT NULL)) THEN
2307: SELECT COUNT(dim_level_id) INTO l_count
2308: FROM BSC_SYS_DIM_LEVELS_B
2309: WHERE short_name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
2310:
2311: IF (l_count = 0) THEN
2312: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');

Line 2321: FROM BSC_SYS_DIM_LEVELS_B

2317:
2318: -- bug# 3814375: Most often short name and parent are the same - hence, need not fire this SQL if the above is validated.
2319: IF (p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name <> p_Dim_Level_Rec.Bsc_Level_Short_Name) THEN
2320: SELECT COUNT(dim_level_id) INTO l_count
2321: FROM BSC_SYS_DIM_LEVELS_B
2322: WHERE short_name = p_Dim_Level_Rec.Bsc_Parent_Level_Short_Name;
2323:
2324: IF (l_count = 0) THEN
2325: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_NAME');

Line 2448: FROM BSC_SYS_DIM_LEVELS_B

2444: str_p_abbr VARCHAR2(30);
2445:
2446: CURSOR c_abbr IS
2447: SELECT ABBREVIATION
2448: FROM BSC_SYS_DIM_LEVELS_B
2449: WHERE DIM_LEVEL_ID = p_Child_level_Id;
2450:
2451: CURSOR p_abbr IS
2452: SELECT ABBREVIATION

Line 2453: FROM BSC_SYS_DIM_LEVELS_B

2449: WHERE DIM_LEVEL_ID = p_Child_level_Id;
2450:
2451: CURSOR p_abbr IS
2452: SELECT ABBREVIATION
2453: FROM BSC_SYS_DIM_LEVELS_B
2454: WHERE DIM_LEVEL_ID = p_Parent_level_Id;
2455:
2456: CURSOR r_col IS
2457: SELECT LEVEL_PK_COL

Line 2458: FROM BSC_SYS_DIM_LEVELS_B

2454: WHERE DIM_LEVEL_ID = p_Parent_level_Id;
2455:
2456: CURSOR r_col IS
2457: SELECT LEVEL_PK_COL
2458: FROM BSC_SYS_DIM_LEVELS_B
2459: WHERE DIM_LEVEL_ID = p_Parent_level_Id;
2460:
2461: BEGIN
2462: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2468: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Child_level_Id);

2464: FND_MSG_PUB.Initialize;
2465:
2466: IF ((p_Child_level_Id IS NOT NULL) AND (p_Parent_level_Id IS NOT NULL)) THEN
2467:
2468: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Child_level_Id);
2469: IF (l_count = 0) THEN
2470: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2471: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Child_level_Id);
2472: FND_MSG_PUB.ADD;

Line 2476: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Parent_level_Id);

2472: FND_MSG_PUB.ADD;
2473: RAISE FND_API.G_EXC_ERROR;
2474: END IF;
2475:
2476: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_DIM_LEVELS_B', 'DIM_LEVEL_ID', p_Parent_level_Id);
2477: IF (l_count = 0) THEN
2478: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_LEVEL_ID');
2479: FND_MESSAGE.SET_TOKEN('BSC_LEVEL_ID', p_Parent_level_Id);
2480: FND_MSG_PUB.ADD;

Line 2802: FROM BSC_SYS_DIM_LEVELS_B

2798: FND_MSG_PUB.Initialize;
2799:
2800: SELECT Dim_Level_Id
2801: INTO l_Dim_Level_Id
2802: FROM BSC_SYS_DIM_LEVELS_B
2803: WHERE Short_Name = p_Dim_Level_Rec.Bsc_Level_Short_Name;
2804:
2805:
2806: UPDATE BSC_SYS_DIM_LEVELS_TL