APPS.BIS_UTIL dependencies on FND_FORM_FUNCTIONS

Line 1055: ( p_function_type IN FND_FORM_FUNCTIONS.type%TYPE

1051: RETURN BIS_UTIL.G_BSC_APP_ID;
1052: END get_default_application_id;
1053:
1054: FUNCTION get_object_type
1055: ( p_function_type IN FND_FORM_FUNCTIONS.type%TYPE
1056: , p_parameters IN FND_FORM_FUNCTIONS.parameters%TYPE
1057: , p_web_html_call IN FND_FORM_FUNCTIONS.web_html_call%TYPE
1058: )
1059: RETURN VARCHAR2

Line 1056: , p_parameters IN FND_FORM_FUNCTIONS.parameters%TYPE

1052: END get_default_application_id;
1053:
1054: FUNCTION get_object_type
1055: ( p_function_type IN FND_FORM_FUNCTIONS.type%TYPE
1056: , p_parameters IN FND_FORM_FUNCTIONS.parameters%TYPE
1057: , p_web_html_call IN FND_FORM_FUNCTIONS.web_html_call%TYPE
1058: )
1059: RETURN VARCHAR2
1060: IS

Line 1057: , p_web_html_call IN FND_FORM_FUNCTIONS.web_html_call%TYPE

1053:
1054: FUNCTION get_object_type
1055: ( p_function_type IN FND_FORM_FUNCTIONS.type%TYPE
1056: , p_parameters IN FND_FORM_FUNCTIONS.parameters%TYPE
1057: , p_web_html_call IN FND_FORM_FUNCTIONS.web_html_call%TYPE
1058: )
1059: RETURN VARCHAR2
1060: IS
1061: l_object_type VARCHAR2(30);

Line 1364: l_form_function FND_FORM_FUNCTIONS.function_name%TYPE;

1360: , x_Msg_Count OUT NOCOPY NUMBER
1361: , x_Msg_Data OUT NOCOPY VARCHAR2
1362: )RETURN VARCHAR2
1363: IS
1364: l_form_function FND_FORM_FUNCTIONS.function_name%TYPE;
1365: l_parent_obj_table BIS_RSG_PUB_API_PKG.t_BIA_RSG_Obj_Table;
1366: l_msg VARCHAR2(32000);
1367: l_pages_found BOOLEAN;
1368:

Line 1371: FROM fnd_form_functions_vl

1367: l_pages_found BOOLEAN;
1368:
1369: CURSOR c_param_portlets IS
1370: SELECT function_name
1371: FROM fnd_form_functions_vl
1372: WHERE parameters LIKE 'pRegionCode=' || p_Region_Code || '&pRequestType=P%';
1373:
1374: BEGIN
1375: l_pages_found := FALSE;

Line 1828: FROM fnd_form_functions_vl

1824: l_msg_data VARCHAR2(1000);
1825:
1826: CURSOR c_portlets IS
1827: SELECT function_name, user_function_name
1828: FROM fnd_form_functions_vl
1829: WHERE parameters like p_param_search_string;
1830:
1831: Begin
1832: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1912: FROM fnd_menu_entries fnd_mnu_ent, fnd_form_functions fnd_ff

1908: IS
1909:
1910: CURSOR c_menu_id IS
1911: SELECT menu_id
1912: FROM fnd_menu_entries fnd_mnu_ent, fnd_form_functions fnd_ff
1913: WHERE fnd_mnu_ent.function_id = fnd_ff.function_id
1914: AND fnd_ff.function_name = p_function_name;
1915: l_menu_id_rec c_menu_id%ROWTYPE;
1916:

Line 1917: l_function_id FND_FORM_FUNCTIONS.FUNCTION_ID%TYPE;

1913: WHERE fnd_mnu_ent.function_id = fnd_ff.function_id
1914: AND fnd_ff.function_name = p_function_name;
1915: l_menu_id_rec c_menu_id%ROWTYPE;
1916:
1917: l_function_id FND_FORM_FUNCTIONS.FUNCTION_ID%TYPE;
1918: l_resp_id FND_RESPONSIBILITY.RESPONSIBILITY_ID%TYPE;
1919:
1920: BEGIN
1921:

Line 2036: FROM fnd_form_functions

2032: IS
2033:
2034: CURSOR c_function_name(p_region_code VARCHAR2) IS
2035: SELECT function_name
2036: FROM fnd_form_functions
2037: WHERE ((type = 'JSP' AND (web_html_call LIKE 'bisviewm.jsp%' OR web_html_call like 'OA.jsp?page=/oracle/apps/bis/report/webui/BISReportPG%'))
2038: OR (type = 'WWW' AND LOWER(web_html_call) LIKE 'bisviewer.showreport%'))
2039: AND UPPER(parameters) LIKE UPPER('%pRegionCode=' || p_region_code || '%')
2040: AND rownum < 2;

Line 2042: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

2038: OR (type = 'WWW' AND LOWER(web_html_call) LIKE 'bisviewer.showreport%'))
2039: AND UPPER(parameters) LIKE UPPER('%pRegionCode=' || p_region_code || '%')
2040: AND rownum < 2;
2041:
2042: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
2043:
2044: BEGIN
2045:
2046: IF (c_function_name%ISOPEN) THEN

Line 2221: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

2217: )
2218: IS
2219: l_resp_id NUMBER;
2220: l_user_id NUMBER;
2221: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
2222:
2223: BEGIN
2224:
2225: x_resp_id := -1;

Line 2786: p_parameters IN FND_FORM_FUNCTIONS_VL.parameters%TYPE

2782: /******************************************/
2783:
2784: FUNCTION Get_Default_Value_From_Params
2785: (
2786: p_parameters IN FND_FORM_FUNCTIONS_VL.parameters%TYPE
2787: , p_attribute2 IN AK_REGION_ITEMS_VL.attribute2%TYPE
2788: )RETURN VARCHAR2 IS
2789:
2790: l_default_value VARCHAR2(1000);