APPS.BSC_CUSTOM_VIEW_UI_WRAPPER dependencies on FND_FORM_FUNCTIONS_VL

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 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 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 (+);