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_LAUNCH_PAD_PUB dependencies on FND_FORM_FUNCTIONS

Line 33: p_Function_Id IN FND_FORM_FUNCTIONS.function_id% TYPE

29:
30:
31: FUNCTION get_Form_Function_Name
32: (
33: p_Function_Id IN FND_FORM_FUNCTIONS.function_id% TYPE
34: )RETURN VARCHAR2
35: IS
36: l_function_name FND_FORM_FUNCTIONS.Function_Name%TYPE;
37:

Line 36: l_function_name FND_FORM_FUNCTIONS.Function_Name%TYPE;

32: (
33: p_Function_Id IN FND_FORM_FUNCTIONS.function_id% TYPE
34: )RETURN VARCHAR2
35: IS
36: l_function_name FND_FORM_FUNCTIONS.Function_Name%TYPE;
37:
38: BEGIN
39:
40: SELECT Function_Name

Line 42: FROM FND_FORM_FUNCTIONS

38: BEGIN
39:
40: SELECT Function_Name
41: INTO l_function_name
42: FROM FND_FORM_FUNCTIONS
43: WHERE Function_Id = p_Function_Id;
44:
45: RETURN l_function_name;
46: END get_Form_Function_Name;

Line 1391: | Description: This procedure creates a new fucntion in FND_FORM_FUNCTIONS

1387: /*===========================================================================+
1388: |
1389: | Name: INSERT_FORM_FUNCTION_VB
1390: |
1391: | Description: This procedure creates a new fucntion in FND_FORM_FUNCTIONS
1392: | metadata.It will also return the fucntion id of the newly created
1393: | function.The transaction is still not commited. It will be done from
1394: | the UI only.
1395: | Input Parameters :- p_user_function_name --> cannot be null

Line 1409: , x_function_id OUT NOCOPY FND_FORM_FUNCTIONS.function_id% TYPE

1405: p_commit IN VARCHAR2 := FND_API.G_FALSE
1406: , p_user_function_name IN VARCHAR2
1407: , p_url IN VARCHAR2
1408: , p_type IN VARCHAR2 :='WWW'
1409: , x_function_id OUT NOCOPY FND_FORM_FUNCTIONS.function_id% TYPE
1410: , x_return_status OUT NOCOPY VARCHAR2
1411: , x_msg_count OUT NOCOPY NUMBER
1412: , x_msg_data OUT NOCOPY VARCHAR2
1413: ) IS

Line 1415: l_function_id FND_FORM_FUNCTIONS.function_id% TYPE;

1411: , x_msg_count OUT NOCOPY NUMBER
1412: , x_msg_data OUT NOCOPY VARCHAR2
1413: ) IS
1414:
1415: l_function_id FND_FORM_FUNCTIONS.function_id% TYPE;
1416: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
1417: l_ret_val VARCHAR2(2);
1418: l_user_id NUMBER := NULL;
1419: row_id VARCHAR2(30);

Line 1416: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;

1412: , x_msg_data OUT NOCOPY VARCHAR2
1413: ) IS
1414:
1415: l_function_id FND_FORM_FUNCTIONS.function_id% TYPE;
1416: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
1417: l_ret_val VARCHAR2(2);
1418: l_user_id NUMBER := NULL;
1419: row_id VARCHAR2(30);
1420: l_url FND_FORM_FUNCTIONS.web_host_name%TYPE;

Line 1420: l_url FND_FORM_FUNCTIONS.web_host_name%TYPE;

1416: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
1417: l_ret_val VARCHAR2(2);
1418: l_user_id NUMBER := NULL;
1419: row_id VARCHAR2(30);
1420: l_url FND_FORM_FUNCTIONS.web_host_name%TYPE;
1421: BEGIN
1422: FND_MSG_PUB.Initialize;
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424:

Line 1433: SELECT FND_FORM_FUNCTIONS_S.NEXTVAL

1429: RAISE FND_API.G_EXC_ERROR;
1430: END IF;
1431:
1432:
1433: SELECT FND_FORM_FUNCTIONS_S.NEXTVAL
1434: INTO l_function_id
1435: FROM DUAL;
1436:
1437: l_function_name := 'BSC_LINKS_'||l_function_id;

Line 1441: FND_FORM_FUNCTIONS_PKG.INSERT_ROW

1437: l_function_name := 'BSC_LINKS_'||l_function_id;
1438: l_user_id := get_User_Id;
1439:
1440:
1441: FND_FORM_FUNCTIONS_PKG.INSERT_ROW
1442: (
1443: X_ROWID => row_id,
1444: X_FUNCTION_ID => l_function_id,
1445: X_WEB_HOST_NAME => SUBSTR(p_url,1,79),

Line 1515: p_fucntion_id IN FND_FORM_FUNCTIONS.function_id%TYPE

1511:
1512:
1513: PROCEDURE Delete_Launch_Pad_Link
1514: (
1515: p_fucntion_id IN FND_FORM_FUNCTIONS.function_id%TYPE
1516: , x_return_status OUT NOCOPY VARCHAR2
1517: , x_msg_count OUT NOCOPY NUMBER
1518: , x_msg_data OUT NOCOPY VARCHAR2
1519: )IS

Line 1541: FROM FND_FORM_FUNCTIONS_TL

1537:
1538: -- Bug #3236356
1539: SELECT COUNT(0)
1540: INTO l_count
1541: FROM FND_FORM_FUNCTIONS_TL
1542: WHERE FUNCTION_ID = p_fucntion_id;
1543:
1544: IF(l_count =0) THEN
1545: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MENU_ID');

Line 1560: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(X_FUNCTION_ID => p_fucntion_id);

1556: RAISE FND_API.G_EXC_ERROR;
1557:
1558: END IF;
1559:
1560: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(X_FUNCTION_ID => p_fucntion_id);
1561:
1562: IF (c_menu_functions%ISOPEN) THEN
1563: CLOSE c_menu_functions;
1564: END IF;

Line 1634: , p_function_id IN FND_FORM_FUNCTIONS.function_id% TYPE

1630: p_commit IN VARCHAR2 := FND_API.G_FALSE
1631: , p_user_function_name IN VARCHAR2
1632: , p_url IN VARCHAR2
1633: , p_type IN VARCHAR2 :='WWW'
1634: , p_function_id IN FND_FORM_FUNCTIONS.function_id% TYPE
1635: , x_return_status OUT NOCOPY VARCHAR2
1636: , x_msg_count OUT NOCOPY NUMBER
1637: , x_msg_data OUT NOCOPY VARCHAR2
1638: ) IS

Line 1640: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;

1636: , x_msg_count OUT NOCOPY NUMBER
1637: , x_msg_data OUT NOCOPY VARCHAR2
1638: ) IS
1639:
1640: l_function_name FND_FORM_FUNCTIONS.function_name%TYPE;
1641:
1642: BEGIN
1643: FND_MSG_PUB.Initialize;
1644: x_return_status := FND_API.G_RET_STS_SUCCESS;