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_SCORECARD_PVT dependencies on BSC_TABS_B

Line 64: FROM BSC_TABS_B T

60: -- Check Tab Id does not exist.
61: IF p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id IS NOT NULL THEN
62:
63: SELECT COUNT(1) INTO l_Count
64: FROM BSC_TABS_B T
65: WHERE T.TAB_ID = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
66:
67: IF l_Count <> 0 THEN
68: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_ID_EXISTS');

Line 77: FROM BSC_TABS_B T

73:
74: -- Check for duplicate short_name
75: IF p_Bsc_Tab_Entity_Rec.Bsc_Short_Name IS NOT NULL THEN
76: SELECT COUNT(1) INTO l_Count
77: FROM BSC_TABS_B T
78: WHERE T.SHORT_NAME = p_Bsc_Tab_Entity_Rec.Bsc_Short_Name;
79:
80: IF l_Count <> 0 THEN
81: FND_MESSAGE.SET_NAME('BSC','BSC_TAB_SHORT_NAME_NOT_UNIQUE');

Line 94: g_db_object := 'BSC_TABS_B';

90: FND_MSG_PUB.ADD;
91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93:
94: g_db_object := 'BSC_TABS_B';
95:
96: -- if there are no errors up to this point then create tab.
97: INSERT INTO BSC_TABS_B( TAB_ID
98: ,KPI_MODEL

Line 97: INSERT INTO BSC_TABS_B( TAB_ID

93:
94: g_db_object := 'BSC_TABS_B';
95:
96: -- if there are no errors up to this point then create tab.
97: INSERT INTO BSC_TABS_B( TAB_ID
98: ,KPI_MODEL
99: ,BSC_MODEL
100: ,CROSS_MODEL
101: ,DEFAULT_MODEL

Line 299: FROM BSC_TABS_B A

295: ,x_Bsc_Tab_Entity_Rec.Bsc_Csf_Id
296: ,x_Bsc_Tab_Entity_Rec.Bsc_Csf_Type
297: ,x_Bsc_Tab_Entity_Rec.Bsc_Intermediate_Flag
298: ,x_Bsc_Tab_Entity_Rec.Bsc_Csf_Id
299: FROM BSC_TABS_B A
300: ,BSC_TABS_TL B
301: ,BSC_TAB_CSF_B C
302: ,BSC_TAB_CSF_TL D
303: WHERE A.TAB_ID = B.TAB_ID

Line 372: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'

368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369: SAVEPOINT UpdateBSCTabPVT;
370: -- Check that valid Tab id was entered.
371: if p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id is not null then
372: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
373: ,'tab_id'
374: ,p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
375: if l_count = 0 then
376: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');

Line 478: update BSC_TABS_B

474: end if;
475: l_Bsc_Tab_Entity_Rec.Bsc_Tab_Index := p_Bsc_Tab_Entity_Rec.Bsc_Tab_Index;
476: end if;
477:
478: update BSC_TABS_B
479: set kpi_model = l_Bsc_Tab_Entity_Rec.Bsc_Kpi_Model
480: ,bsc_model = l_Bsc_Tab_Entity_Rec.Bsc_Bsc_Model
481: ,cross_model = l_Bsc_Tab_Entity_Rec.Bsc_Cross_Model
482: ,default_model = l_Bsc_Tab_Entity_Rec.Bsc_Default_Model

Line 621: FROM BSC_TABS_B

617: if p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id is not null then
618:
619: SELECT COUNT(0)
620: INTO l_count
621: FROM BSC_TABS_B
622: WHERE Tab_Id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
623:
624: if l_count = 0 then
625: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');

Line 642: from BSC_TABS_B

638: -- for the children of current tab.
639: -- get the index.
640: select max(tab_index)
641: into l_tab_index
642: from BSC_TABS_B
643: where tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
644:
645: l_sql := 'select tab_id ' ||
646: ' from BSC_TABS_B ' ||

Line 646: ' from BSC_TABS_B ' ||

642: from BSC_TABS_B
643: where tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
644:
645: l_sql := 'select tab_id ' ||
646: ' from BSC_TABS_B ' ||
647: ' where parent_tab_id = :1';
648:
649: open dc_value for l_sql using p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
650: loop

Line 657: update BSC_TABS_B

653:
654: -- update the index
655: l_tab_index := l_tab_index + 1;
656:
657: update BSC_TABS_B
658: set parent_tab_id = null
659: ,tab_index = l_tab_index
660: where tab_id = l_child_tab;
661:

Line 706: DELETE FROM BSC_TABS_B

702: CLOSE c_tab_views;
703: END IF;
704:
705: -- delete pertinent values from pertinent tables.
706: DELETE FROM BSC_TABS_B
707: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
708:
709: DELETE FROM BSC_TABS_TL
710: WHERE tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;

Line 841: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'

837: x_return_status := FND_API.G_RET_STS_SUCCESS;
838: SAVEPOINT CreateBSCTabAccessPVT;
839: -- Check that valid Tab id was entered.
840: if p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id is not null then
841: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
842: ,'tab_id'
843: ,p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id);
844: if l_count = 0 then
845: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');

Line 1024: ' from BSC_TABS_B ' ||

1020: FND_MSG_PUB.Initialize;
1021: x_return_status := FND_API.G_RET_STS_SUCCESS;
1022: SAVEPOINT MoveBSCTabPVT;
1023: l_sql := 'select distinct tab_id, tab_index ' ||
1024: ' from BSC_TABS_B ' ||
1025: ' where tab_index >= :1' ||
1026: ' and tab_id <> :2' ||
1027: ' order by tab_index asc';
1028:

Line 1040: update BSC_TABS_B

1036: end loop;
1037: close dc_value;
1038:
1039: for i in 1..l_Bsc_Tab_Entity_Tbl.count loop
1040: update BSC_TABS_B
1041: set tab_index = l_Bsc_Tab_Entity_Tbl(i).Bsc_Tab_Index + 1
1042: where tab_id = l_Bsc_Tab_Entity_Tbl(i).Bsc_Tab_Id;
1043: end loop;
1044:

Line 1108: update BSC_TABS_B

1104: begin
1105: FND_MSG_PUB.Initialize;
1106: x_return_status := FND_API.G_RET_STS_SUCCESS;
1107: SAVEPOINT UpdateBSCTabTimStmPVT;
1108: update BSC_TABS_B
1109: set last_update_date = sysdate
1110: where tab_id = p_Bsc_Tab_Entity_Rec.Bsc_Tab_Id;
1111:
1112: IF (p_commit = FND_API.G_TRUE) THEN

Line 1349: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B','tab_id',p_tab_id);

1345: BEGIN
1346:
1347: IF(p_tab_id IS NOT NULL ) THEN
1348:
1349: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B','tab_id',p_tab_id);
1350: IF l_count = 0 THEN
1351: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
1352: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);
1353: FND_MSG_PUB.ADD;