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_CUSTOM_VIEW_PUB

Line 141: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;

137: )IS
138: l_count NUMBER;
139: l_cust_views VARCHAR2(32000);
140: l_cust_View VARCHAR2(10);
141: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
142: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
143: l_tab_view_id NUMBER;
144: BEGIN
145: FND_MSG_PUB.Initialize;

Line 142: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

138: l_count NUMBER;
139: l_cust_views VARCHAR2(32000);
140: l_cust_View VARCHAR2(10);
141: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
142: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
143: l_tab_view_id NUMBER;
144: BEGIN
145: FND_MSG_PUB.Initialize;
146: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 296: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;

292:
293: l_count NUMBER;
294: l_cust_views VARCHAR2(32000);
295: l_cust_View VARCHAR2(10);
296: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
297: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
298: l_tab_view_id NUMBER;
299: BEGIN
300: FND_MSG_PUB.Initialize;

Line 297: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

293: l_count NUMBER;
294: l_cust_views VARCHAR2(32000);
295: l_cust_View VARCHAR2(10);
296: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
297: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
298: l_tab_view_id NUMBER;
299: BEGIN
300: FND_MSG_PUB.Initialize;
301: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 491: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;

487: ,x_msg_count OUT NOCOPY NUMBER
488: ,x_msg_data OUT NOCOPY VARCHAR2
489: )IS
490: l_count NUMBER;
491: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
492: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
493: BEGIN
494: FND_MSG_PUB.Initialize;
495: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 492: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

488: ,x_msg_data OUT NOCOPY VARCHAR2
489: )IS
490: l_count NUMBER;
491: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
492: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
493: BEGIN
494: FND_MSG_PUB.Initialize;
495: x_return_status := FND_API.G_RET_STS_SUCCESS;
496:

Line 669: ,p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type

665:
666: PROCEDURE Create_Tab_View
667: (
668: p_commit IN VARCHAR2 := FND_API.G_FALSE
669: ,p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
670: ,x_return_status OUT NOCOPY VARCHAR2
671: ,x_msg_count OUT NOCOPY NUMBER
672: ,x_msg_data OUT NOCOPY VARCHAR2
673: )IS

Line 674: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

670: ,x_return_status OUT NOCOPY VARCHAR2
671: ,x_msg_count OUT NOCOPY NUMBER
672: ,x_msg_data OUT NOCOPY VARCHAR2
673: )IS
674: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
675: l_count NUMBER;
676: BEGIN
677: SAVEPOINT CreateTabView;
678: FND_MSG_PUB.Initialize;

Line 801: p_Tab_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type

797: It will be used when we will be updating the tab record.
798: /*****************************************************************************/
799:
800: PROCEDURE Retrieve_Tab(
801: p_Tab_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
802: ,x_Tab_Rec IN OUT NOCOPY BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
803: ,x_return_status OUT NOCOPY VARCHAR2
804: ,x_msg_count OUT NOCOPY NUMBER
805: ,x_msg_data OUT NOCOPY VARCHAR2

Line 802: ,x_Tab_Rec IN OUT NOCOPY BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type

798: /*****************************************************************************/
799:
800: PROCEDURE Retrieve_Tab(
801: p_Tab_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
802: ,x_Tab_Rec IN OUT NOCOPY BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
803: ,x_return_status OUT NOCOPY VARCHAR2
804: ,x_msg_count OUT NOCOPY NUMBER
805: ,x_msg_data OUT NOCOPY VARCHAR2
806: ) IS

Line 881: ( p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type

877: Created By :- ashankar 23-Oct-2003
878: /**************************************************************************************/
879:
880: PROCEDURE Retrieve_Tab_View
881: ( p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
882: ,x_Tab_View_Rec IN OUT NOCOPY BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
883: ,x_return_status OUT NOCOPY VARCHAR2
884: ,x_msg_count OUT NOCOPY NUMBER
885: ,x_msg_data OUT NOCOPY VARCHAR2

Line 882: ,x_Tab_View_Rec IN OUT NOCOPY BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type

878: /**************************************************************************************/
879:
880: PROCEDURE Retrieve_Tab_View
881: ( p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
882: ,x_Tab_View_Rec IN OUT NOCOPY BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
883: ,x_return_status OUT NOCOPY VARCHAR2
884: ,x_msg_count OUT NOCOPY NUMBER
885: ,x_msg_data OUT NOCOPY VARCHAR2
886: )IS

Line 954: ,p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type

950: Created By :- ashankar 23-Oct-2003
951: /******************************************************************************************/
952: PROCEDURE Update_Tab_View
953: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
954: ,p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
955: ,x_return_status OUT NOCOPY VARCHAR2
956: ,x_msg_count OUT NOCOPY NUMBER
957: ,x_msg_data OUT NOCOPY VARCHAR2
958:

Line 960: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

956: ,x_msg_count OUT NOCOPY NUMBER
957: ,x_msg_data OUT NOCOPY VARCHAR2
958:
959: )IS
960: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
961: l_Tab_View_Out_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
962: l_count NUMBER;
963:
964: BEGIN

Line 961: l_Tab_View_Out_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

957: ,x_msg_data OUT NOCOPY VARCHAR2
958:
959: )IS
960: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
961: l_Tab_View_Out_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
962: l_count NUMBER;
963:
964: BEGIN
965: SAVEPOINT UpdateTabView;

Line 1097: ,p_Tab_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type

1093:
1094: PROCEDURE Update_Tab_default_View
1095: (
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE
1097: ,p_Tab_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
1098: ,x_return_status OUT NOCOPY VARCHAR2
1099: ,x_msg_count OUT NOCOPY NUMBER
1100: ,x_msg_data OUT NOCOPY VARCHAR2
1101:

Line 1104: l_Tab_Ret_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;

1100: ,x_msg_data OUT NOCOPY VARCHAR2
1101:
1102: )IS
1103:
1104: l_Tab_Ret_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
1105: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
1106: l_count NUMBER;
1107:
1108: BEGIN

Line 1105: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;

1101:
1102: )IS
1103:
1104: l_Tab_Ret_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
1105: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
1106: l_count NUMBER;
1107:
1108: BEGIN
1109: SAVEPOINT UpdateTabdefaultView;

Line 1318: ,p_CustView_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type

1314: /******************************************************************************/
1315: PROCEDURE delete_Custom_View
1316: (
1317: p_commit IN VARCHAR2 := FND_API.G_FALSE
1318: ,p_CustView_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
1319: ,x_return_status OUT NOCOPY VARCHAR2
1320: ,x_msg_count OUT NOCOPY NUMBER
1321: ,x_msg_data OUT NOCOPY VARCHAR2
1322: ) IS

Line 1324: l_CustView_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;

1320: ,x_msg_count OUT NOCOPY NUMBER
1321: ,x_msg_data OUT NOCOPY VARCHAR2
1322: ) IS
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:

Line 1326: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;

1322: ) IS
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

Line 1339: ----DBMS_OUTPUT.PUT_LINE\n('Entered inside BSC_CUSTOM_VIEW_PUB.delete_Custom_View ');

1335:
1336: BEGIN
1337:
1338: SAVEPOINT deleteCustomView;
1339: ----DBMS_OUTPUT.PUT_LINE\n('Entered inside BSC_CUSTOM_VIEW_PUB.delete_Custom_View ');
1340: FND_MSG_PUB.Initialize;
1341:
1342: l_CustView_Rec.Bsc_Tab_Id := p_CustView_Rec.Bsc_Tab_Id;
1343: l_CustView_Rec.Bsc_Tab_View_Id := p_CustView_Rec.Bsc_Tab_View_Id;

Line 1504: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

1500: WHEN NO_DATA_FOUND THEN
1501: ROLLBACK TO deleteCustomView;
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503: IF (x_msg_data IS NOT NULL) THEN
1504: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1505: ELSE
1506: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1507: END IF;
1508: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1506: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503: IF (x_msg_data IS NOT NULL) THEN
1504: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1505: ELSE
1506: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1507: END IF;
1508: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1509:
1510: WHEN OTHERS THEN

Line 1514: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

1510: WHEN OTHERS THEN
1511: ROLLBACK TO deleteCustomView;
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1513: IF (x_msg_data IS NOT NULL) THEN
1514: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1515: ELSE
1516: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1517: END IF;
1518: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);

Line 1516: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1513: IF (x_msg_data IS NOT NULL) THEN
1514: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1515: ELSE
1516: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1517: END IF;
1518: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
1519:
1520: