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

Line 66: FROM BSC_TABS_B

62: -- for scorecard view
63:
64: SELECT KPI_MODEL
65: INTO l_enabled
66: FROM BSC_TABS_B
67: WHERE tab_id =p_tab_id;
68:
69: ELSE
70: SELECT BSC_MODEL

Line 72: FROM BSC_TABS_B

68:
69: ELSE
70: SELECT BSC_MODEL
71: INTO l_enabled
72: FROM BSC_TABS_B
73: WHERE tab_id =p_tab_id;
74: END IF;
75:
76: ELSE

Line 124: and BSC_MODEL =1 in BSC_TABS_B table.

120: Decription :- This procedure will Assign the custom views for the tab.
121: It means it will set the enabled_flag =1 in BSC_TAB_VIEWS_B table
122: for tree view, detail_view and custom views.
123: For scorecard view, strategy map view it will set KPI_MODEL =1
124: and BSC_MODEL =1 in BSC_TABS_B table.
125: Input :- Comma separated views ids which needs to be Assigned.
126: Created by :- ashankar 27-Oct-2003
127: /*******************************************************************************/
128:

Line 279: and BSC_MODEL =0 in BSC_TABS_B table.

275: Decription :- This procedure will unassign the custom views for the tab.
276: It means it will set the enabled_flag =0 in BSC_TAB_VIEWS_B table
277: for tree view, detail_view and custom views.
278: For scorecard view, strategy map view it will set KPI_MODEL =0
279: and BSC_MODEL =0 in BSC_TABS_B table.
280: Input :- Comma separated views ids which needs to be unassigned.
281: Created by :- ashankar 23-Oct-2003
282: /*******************************************************************************/
283:

Line 466: The default view needs to be updated in BSC_TABS_B.

462: This procedure will do the following.
463: For the current tab what views need to be shown.
464: All the assign_Views which are coming from the UI should be visible in the popdown list
465: in IViewer and shown as seleceted in the table.
466: The default view needs to be updated in BSC_TABS_B.
467: If scorecard view and startegy map view are enabled then they should go into
468: BSC_TABS_B COLUMNS KPI_MODEL and BSC_MODEL.
469: For other views like Tree View/Detail View and other custom views should be
470: updated in BSC_TAB_VIEWS_B with enabled flag set to 1/0.

Line 468: BSC_TABS_B COLUMNS KPI_MODEL and BSC_MODEL.

464: All the assign_Views which are coming from the UI should be visible in the popdown list
465: in IViewer and shown as seleceted in the table.
466: The default view needs to be updated in BSC_TABS_B.
467: If scorecard view and startegy map view are enabled then they should go into
468: BSC_TABS_B COLUMNS KPI_MODEL and BSC_MODEL.
469: For other views like Tree View/Detail View and other custom views should be
470: updated in BSC_TAB_VIEWS_B with enabled flag set to 1/0.
471:
472: if user unassigns all the views we have to set scorecard view as default.

Line 841: FROM BSC_TABS_B a

837: ,x_Tab_Rec.Bsc_Tab_Index
838: ,x_Tab_Rec.Bsc_Parent_Tab_id
839: ,x_Tab_Rec.Bsc_Owner_Id
840: ,x_Tab_Rec.Bsc_Short_Name
841: FROM BSC_TABS_B a
842: WHERE a.tab_id = p_Tab_Rec.Bsc_Tab_Id;
843:
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN

Line 946: Description :- This procedure updates the BSC_TABS_B table.

942: END Retrieve_Tab_View;
943:
944:
945: /*****************************************************************************************
946: Description :- This procedure updates the BSC_TABS_B table.
947: This procedure should be called from assign and unassign views.
948: Input :- p_tab_View_rec
949: Ouput :- Updates the BSC_TABS_B
950: Created By :- ashankar 23-Oct-2003

Line 949: Ouput :- Updates the BSC_TABS_B

945: /*****************************************************************************************
946: Description :- This procedure updates the BSC_TABS_B table.
947: This procedure should be called from assign and unassign views.
948: Input :- p_tab_View_rec
949: Ouput :- Updates the BSC_TABS_B
950: Created By :- ashankar 23-Oct-2003
951: /******************************************************************************************/
952: PROCEDURE Update_Tab_View
953: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

Line 1201: UPDATE BSC_TABS_B

1197: IF (p_Tab_Rec.Bsc_Short_Name IS NOT NULL) THEN
1198: l_Tab_Ret_Rec.Bsc_Short_Name := p_Tab_Rec.Bsc_Short_Name;
1199: END IF;
1200:
1201: UPDATE BSC_TABS_B
1202: SET Kpi_Model=l_Tab_Ret_Rec.Bsc_Kpi_Model
1203: ,Bsc_Model=l_Tab_Ret_Rec.Bsc_Bsc_Model
1204: ,Cross_Model=l_Tab_Ret_Rec.Bsc_Cross_Model
1205: ,Default_Model=l_Tab_Ret_Rec.Bsc_Default_Model

Line 1275: p_Tab_Id IN BSC_TABS_B.tab_id%TYPE

1271: /********************************************************************************/
1272:
1273: FUNCTION get_Tab_Default_View
1274: (
1275: p_Tab_Id IN BSC_TABS_B.tab_id%TYPE
1276: )RETURN NUMBER
1277: IS
1278: l_default_view BSC_TABS_B.default_model%TYPE;
1279: BEGIN

Line 1278: l_default_view BSC_TABS_B.default_model%TYPE;

1274: (
1275: p_Tab_Id IN BSC_TABS_B.tab_id%TYPE
1276: )RETURN NUMBER
1277: IS
1278: l_default_view BSC_TABS_B.default_model%TYPE;
1279: BEGIN
1280:
1281: SELECT default_model
1282: INTO l_default_view

Line 1283: FROM BSC_TABS_B

1279: BEGIN
1280:
1281: SELECT default_model
1282: INTO l_default_view
1283: FROM BSC_TABS_B
1284: WHERE tab_id = p_Tab_Id;
1285:
1286: RETURN l_default_view;
1287:

Line 1327: l_default_view BSC_TABS_B.default_model%TYPE;

1323:
1324: l_CustView_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
1325: l_count NUMBER;
1326: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
1327: l_default_view BSC_TABS_B.default_model%TYPE;
1328:
1329: CURSOR c_sys_images IS
1330: SELECT image_id
1331: FROM BSC_SYS_IMAGES

Line 1537: FROM BSC_TABS_B

1533: BEGIN
1534:
1535: SELECT COUNT(0)
1536: INTO l_count
1537: FROM BSC_TABS_B
1538: WHERE TAB_ID = p_Tab_Id;
1539:
1540: RETURN l_count;
1541: