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

Line 1454: l_internal_name FND_FORM_FUNCTIONS_VL.FUNCTION_NAME%TYPE;

1450: ,x_msg_count OUT NOCOPY NUMBER
1451: ,x_msg_data OUT NOCOPY VARCHAR2
1452: ) IS
1453: l_count NUMBER;
1454: l_internal_name FND_FORM_FUNCTIONS_VL.FUNCTION_NAME%TYPE;
1455: BEGIN
1456:
1457: l_internal_name := p_internal_name;
1458: -- for the new view check if the internal name already exists

Line 1462: FROM FND_FORM_FUNCTIONS_VL

1458: -- for the new view check if the internal name already exists
1459: IF (is_tab_view_exist(p_tab_id, p_tab_view_id) = 'N') THEN
1460: SELECT COUNT(0)
1461: INTO l_count
1462: FROM FND_FORM_FUNCTIONS_VL
1463: WHERE FUNCTION_NAME = p_internal_name;
1464:
1465: IF (l_count <> 0) THEN
1466: -- If the user has not changed the default internal name then insert the next available

Line 1613: from FND_FORM_FUNCTIONS

1609: l_function_name := p_internal_name;
1610: END IF;
1611:
1612: select count(FUNCTION_ID) into l_count
1613: from FND_FORM_FUNCTIONS
1614: where FUNCTION_NAME = l_function_name;
1615:
1616: -- check if function has already been created
1617: IF (l_count =0) THEN

Line 1618: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;

1614: where FUNCTION_NAME = l_function_name;
1615:
1616: -- check if function has already been created
1617: IF (l_count =0) THEN
1618: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;
1619:
1620: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(
1621: X_ROWID => l_ROWID,
1622: X_FUNCTION_ID => l_new_function_id,

Line 1620: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(

1616: -- check if function has already been created
1617: IF (l_count =0) THEN
1618: select FND_FORM_FUNCTIONS_S.NEXTVAL into l_new_function_id from dual;
1619:
1620: FND_FORM_FUNCTIONS_PKG.INSERT_ROW(
1621: X_ROWID => l_ROWID,
1622: X_FUNCTION_ID => l_new_function_id,
1623: X_WEB_HOST_NAME => null,
1624: X_WEB_AGENT_NAME => null,

Line 1651: select FUNCTION_ID into x_function_id from FND_FORM_FUNCTIONS where FUNCTION_NAME = l_function_name;

1647: if l_ROWID is not null then
1648: x_function_id := l_new_function_id;
1649: end if;
1650: ELSE
1651: select FUNCTION_ID into x_function_id from FND_FORM_FUNCTIONS where FUNCTION_NAME = l_function_name;
1652:
1653: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW
1654: (
1655: X_FUNCTION_ID => x_function_id

Line 1653: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW

1649: end if;
1650: ELSE
1651: select FUNCTION_ID into x_function_id from FND_FORM_FUNCTIONS where FUNCTION_NAME = l_function_name;
1652:
1653: FND_FORM_FUNCTIONS_PKG.UPDATE_ROW
1654: (
1655: X_FUNCTION_ID => x_function_id
1656: ,X_WEB_HOST_NAME => NULL
1657: ,X_WEB_AGENT_NAME => NULL

Line 1704: l_param_search_string FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;

1700: ,x_msg_data OUT NOCOPY VARCHAR2
1701: ) is
1702:
1703: l_function_id NUMBER;
1704: l_param_search_string FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;
1705: l_object_name FND_FORM_FUNCTIONS_VL.FUNCTION_NAME%TYPE;
1706: l_count NUMBER;
1707:
1708: CURSOR c_verify_function IS

Line 1705: l_object_name FND_FORM_FUNCTIONS_VL.FUNCTION_NAME%TYPE;

1701: ) is
1702:
1703: l_function_id NUMBER;
1704: l_param_search_string FND_FORM_FUNCTIONS_VL.PARAMETERS%TYPE;
1705: l_object_name FND_FORM_FUNCTIONS_VL.FUNCTION_NAME%TYPE;
1706: l_count NUMBER;
1707:
1708: CURSOR c_verify_function IS
1709: SELECT FUNCTION_ID, FUNCTION_NAME

Line 1710: FROM FND_FORM_FUNCTIONS

1706: l_count NUMBER;
1707:
1708: CURSOR c_verify_function IS
1709: SELECT FUNCTION_ID, FUNCTION_NAME
1710: FROM FND_FORM_FUNCTIONS
1711: WHERE PARAMETERS LIKE l_param_search_string;
1712:
1713: BEGIN
1714: fnd_msg_pub.initialize;

Line 1723: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(l_function_id);

1719: FOR cd IN c_verify_function LOOP
1720: l_function_id := cd.function_id;
1721: l_object_name := cd.function_name;
1722:
1723: FND_FORM_FUNCTIONS_PKG.DELETE_ROW(l_function_id);
1724: -- Checks if the functional_area alredy exists.
1725: SELECT COUNT(0)
1726: INTO l_count
1727: FROM bis_form_function_extension_vl

Line 1775: l_internal_name FND_FORM_FUNCTIONS_VL.function_name%TYPE;

1771: FUNCTION next_custom_view_id (
1772: p_tab_id IN NUMBER
1773: ) RETURN NUMBER IS
1774: l_view_id BSC_TAB_VIEWS_VL.tab_view_id%TYPE;
1775: l_internal_name FND_FORM_FUNCTIONS_VL.function_name%TYPE;
1776:
1777: BEGIN
1778: SELECT NVL(MAX(tab_view_id),1)
1779: INTO l_view_id

Line 2077: l_fun_name FND_FORM_FUNCTIONS_VL.function_name%TYPE;

2073: , p_tab_view_id IN NUMBER
2074: , p_type IN VARCHAR
2075: ) RETURN VARCHAR2 IS
2076:
2077: l_fun_name FND_FORM_FUNCTIONS_VL.function_name%TYPE;
2078: l_short_name BIS_FUNCTIONAL_AREAS_VL.short_name%TYPE;
2079: l_name VARCHAR2(100);
2080:
2081: BEGIN

Line 2086: fnd_form_functions_vl ff

2082: SELECT ff.function_name,fa.short_name
2083: INTO l_fun_name,l_short_name
2084: FROM bis_form_function_extension ext,
2085: bis_functional_areas_vl fa,
2086: fnd_form_functions_vl ff
2087: WHERE
2088: ff.parameters LIKE '%pTabId_'||p_tab_id|| '&pViewId_'||p_tab_view_id||'%'
2089: AND ext.functional_area_id = fa.functional_area_id (+)
2090: AND ff.function_name = ext.object_name (+);