[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*';
395: v_function_id := g_func_id_cache; /* If we have it cached, use value */
396: else /* not cached, hit db */
397: select function_id
398: into v_function_id
399: from fnd_form_functions
400: where function_name=p_function_name;
401:
402: /* Store in cache */
403: g_func_id_cache := v_function_id;
1713: l_api_name CONSTANT VARCHAR2(30) := 'GET_FUNCTIONS';
1714: l_sysdate DATE := Sysdate;
1715: l_predicate VARCHAR2(32767);
1716: -- modified for bug#5395351
1717: function_name fnd_form_functions.function_name%type;
1718: dynamic_sql VARCHAR2(32767);
1719: l_return_status varchar2(1);
1720: result varchar2(30);
1721: l_nrows pls_integer;
2681: 'SELECT unique FF.FUNCTION_NAME '||
2682: ' FROM fnd_grants GNT, ' ||
2683: l_db_object_name||' OBJTAB, '||
2684: 'fnd_compiled_menu_functions CMF, '||
2685: 'fnd_form_functions FF '||
2686: ' WHERE ';
2687: ELSIF (l_grants_only_flag = TRUE) then
2688: NULL;
2689: ELSE
6181: ),
6182: NFT AS
6183: (
6184: select /*+ materialize */ function_id
6185: from fnd_form_functions_vl
6186: where type in ('WWW', 'WWK', 'SERVLET', 'JSP', 'FORM')
6187: )
6188: select
6189: U.function_id,U.responsibility_name,U.responsibility_id, U.application_id, U.security_group_id, U.menu_id,U.prompt