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.

[Home] [Help]

APPS.BSC_CUSTOM_VIEW_PVT dependencies on BSC_TAB_VIEWS_B

Line 53: l_enabled BSC_TAB_VIEWS_B.enabled_flag%TYPE;

49: p_tab_id IN NUMBER
50: ,p_tab_view_id IN NUMBER
51: ) RETURN NUMBER
52: IS
53: l_enabled BSC_TAB_VIEWS_B.enabled_flag%TYPE;
54: BEGIN
55:
56: --DBMS_OUTPUT.PUT_LINE\n('p_tab_id-->'|| p_tab_id);
57: --DBMS_OUTPUT.PUT_LINE\n('p_tab_view_id-->'|| p_tab_view_id);

Line 80: FROM BSC_TAB_VIEWS_B

76: ELSE
77:
78: SELECT enabled_flag
79: INTO l_enabled
80: FROM BSC_TAB_VIEWS_B
81: WHERE tab_id =p_tab_id
82: AND tab_view_id = p_tab_view_id;
83:
84: END IF;

Line 111: FROM BSC_TAB_VIEWS_B

107: BEGIN
108:
109: SELECT COUNT(0)
110: INTO l_count
111: FROM BSC_TAB_VIEWS_B
112: WHERE tab_id = p_tab_id
113: AND tab_view_id =p_tab_view_id;
114:
115: RETURN l_count;

Line 121: It means it will set the enabled_flag =1 in BSC_TAB_VIEWS_B table

117: END Validate_Tab_View;
118:
119: /*******************************************************************************
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.

Line 276: It means it will set the enabled_flag =0 in BSC_TAB_VIEWS_B table

272: END Assign_Cust_Views;
273:
274: /*******************************************************************************
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.

Line 470: updated in BSC_TAB_VIEWS_B with enabled flag set to 1/0.

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.
473: The default view should be updated in the last only.
474: if we are trying to set the default view of the view which is disabled then we have to throw

Line 662: This procedure will create a new record into the BSC_TAB_VIEWS_B and BSC_TAB_VIEWS_TL table.

658: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
659: END Assign_Unassign_Views;
660:
661: /******************************************************************************************
662: This procedure will create a new record into the BSC_TAB_VIEWS_B and BSC_TAB_VIEWS_TL table.
663:
664: /******************************************************************************************/
665:
666: PROCEDURE Create_Tab_View

Line 700: INSERT INTO BSC_TAB_VIEWS_B

696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699:
700: INSERT INTO BSC_TAB_VIEWS_B
701: ( tab_id
702: ,tab_view_id
703: ,enabled_flag
704: ,created_by

Line 874: Description :- This procedure retrieves the data from BSC_TAB_VIEWS_B table.

870: RAISE;
871: END Retrieve_Tab;
872:
873: /*************************************************************************************
874: Description :- This procedure retrieves the data from BSC_TAB_VIEWS_B table.
875: Input :- p_Tab_View_Rec.Bsc_Tab_Id and p_Tab_View_Rec.Bsc_Tab_View_Id
876: OutPut :- x_Tab_View_Rec
877: Created By :- ashankar 23-Oct-2003
878: /**************************************************************************************/

Line 910: FROM BSC_TAB_VIEWS_B

906: ,x_Tab_View_Rec.Bsc_Creation_Date
907: ,x_Tab_View_Rec.Bsc_Last_Updated_By
908: ,x_Tab_View_Rec.Bsc_Last_Update_Date
909: ,x_Tab_View_Rec.Bsc_Last_Update_Login
910: FROM BSC_TAB_VIEWS_B
911: WHERE tab_id = p_Tab_View_Rec.Bsc_Tab_Id
912: AND tab_view_id =p_Tab_View_Rec.Bsc_Tab_View_Id;
913:
914: EXCEPTION

Line 1029: UPDATE BSC_TAB_VIEWS_B

1025: IF (p_Tab_View_Rec.Bsc_Last_Update_Login IS NOT NULL) THEN
1026: l_Tab_View_Out_Rec.Bsc_Last_Update_Login := p_Tab_View_Rec.Bsc_Last_Update_Login;
1027: END IF;
1028:
1029: UPDATE BSC_TAB_VIEWS_B
1030: SET Enabled_Flag= l_Tab_View_Out_Rec.Bsc_Enabled_Flag
1031: ,Created_By= l_Tab_View_Out_Rec.Bsc_Created_By
1032: ,Creation_Date=l_Tab_View_Out_Rec.Bsc_Creation_Date
1033: ,Last_Updated_By= l_Tab_View_Out_Rec.Bsc_Last_Updated_By

Line 1294: Description :- This procedure will delete the custom view from bsc_tab_views_b table.

1290:
1291:
1292: /*****************************************************************************
1293: Name :- delete_Custom_View
1294: Description :- This procedure will delete the custom view from bsc_tab_views_b table.
1295: It will do the following validations.
1296: 1. Before deleting the custom view it will verify if it is the default
1297: view which is being deleted. If yes then it will set scorecard view
1298: as default view and delete the custom view.

Line 1303: 1.BSC_TAB_VIEWS_B

1299: Otherwise it will update the last update date of the tab.
1300: This is required for Granular locking purpose.
1301:
1302: The entry will be deleted from the following tables.
1303: 1.BSC_TAB_VIEWS_B
1304: 2.BSC_TAB_VIEWS_TL
1305: 3.BSC_TAB_VIEW_KPI_TL
1306: 4.BSC_TAB_VIEW_LABELS_B
1307: 5.BSC_TAB_VIEW_LABELS_TL

Line 1368: FROM bsc_tab_views_b

1364: IF((l_CustView_Rec.Bsc_Tab_Id IS NOT NULL) AND (l_CustView_Rec.Bsc_Tab_View_Id IS NOT NULL)) THEN
1365:
1366: SELECT count(0)
1367: INTO l_count
1368: FROM bsc_tab_views_b
1369: WHERE tab_id = l_CustView_Rec.Bsc_Tab_Id
1370: AND tab_view_id = l_CustView_Rec.Bsc_Tab_View_Id;
1371:
1372: IF (l_count =0) THEN

Line 1423: FROM BSC_TAB_VIEWS_B

1419:
1420: -- now delete the tab view id
1421:
1422: DELETE
1423: FROM BSC_TAB_VIEWS_B
1424: WHERE tab_id = l_CustView_Rec.Bsc_Tab_Id
1425: AND tab_view_id = l_CustView_Rec.Bsc_Tab_View_Id;
1426:
1427: DELETE