[Home] [Help]
29:
30: /* One level cache for get_function_id() */
31: g_func_id_cache NUMBER := NULL;
32: -- modified for bug#5395351
33: g_func_name_cache fnd_form_functions.function_name%type := NULL;
34:
35: /* One level cache for get_security_predicate */
36: -- modified for bug#5395351
37: g_gsp_function fnd_form_functions.function_name%type := '*EMPTY*';
33: g_func_name_cache fnd_form_functions.function_name%type := NULL;
34:
35: /* One level cache for get_security_predicate */
36: -- modified for bug#5395351
37: g_gsp_function fnd_form_functions.function_name%type := '*EMPTY*';
38: g_gsp_object_name VARCHAR2(30) := '*EMPTY*';
39: g_gsp_grant_instance_type VARCHAR2(30) := '*EMPTY*';
40: g_gsp_user_name VARCHAR2(255) := '*EMPTY*';
41: g_gsp_statement_type VARCHAR2(30) := '*EMPTY*';
394: v_function_id := g_func_id_cache; /* If we have it cached, use value */
395: else /* not cached, hit db */
396: select function_id
397: into v_function_id
398: from fnd_form_functions
399: where function_name=p_function_name;
400:
401: /* Store in cache */
402: g_func_id_cache := v_function_id;
1712: l_api_name CONSTANT VARCHAR2(30) := 'GET_FUNCTIONS';
1713: l_sysdate DATE := Sysdate;
1714: l_predicate VARCHAR2(32767);
1715: -- modified for bug#5395351
1716: function_name fnd_form_functions.function_name%type;
1717: dynamic_sql VARCHAR2(32767);
1718: l_return_status varchar2(1);
1719: result varchar2(30);
1720: l_nrows pls_integer;
2680: 'SELECT unique FF.FUNCTION_NAME '||
2681: ' FROM fnd_grants GNT, ' ||
2682: l_db_object_name||' OBJTAB, '||
2683: 'fnd_compiled_menu_functions CMF, '||
2684: 'fnd_form_functions FF '||
2685: ' WHERE ';
2686: ELSIF (l_grants_only_flag = TRUE) then
2687: NULL;
2688: ELSE