DBA Data[Home] [Help]

APPS.BEN_PROCESS_USER_SS_API dependencies on FND_FORM_FUNCTIONS

Line 291: cursor lc_get_function_name (p_func_id in fnd_form_functions.function_id%type)

287: where frf.application_id = p_app_id
288: and frf.responsibility_id = p_resp_id;
289: --
290:
291: cursor lc_get_function_name (p_func_id in fnd_form_functions.function_id%type)
292: is
293: select fff.function_name
294: from fnd_form_functions fff
295: where fff.function_id = p_func_id;

Line 294: from fnd_form_functions fff

290:
291: cursor lc_get_function_name (p_func_id in fnd_form_functions.function_id%type)
292: is
293: select fff.function_name
294: from fnd_form_functions fff
295: where fff.function_id = p_func_id;
296: --
297: cursor lc_get_menu_name (p_menu_id in fnd_menus.menu_id%type)
298: is

Line 315: l_rule_name fnd_form_functions.function_name%type;

311: and fr.responsibility_id = p_resp_id;
312: --
313: l_proc varchar2(72) := g_package ||
314: 'add_func_sec_exclusion_rules';
315: l_rule_name fnd_form_functions.function_name%type;
316: l_resp_key fnd_responsibility.responsibility_key%type;
317: l_func_sec_excl_err exception;
318: --
319: begin

Line 329: -- derive the function_name from fnd_form_functions

325: loop
326: --
327: if get_resp_func_rec.rule_type = 'F'
328: then
329: -- derive the function_name from fnd_form_functions
330: open lc_get_function_name
331: (p_func_id => get_resp_func_rec.action_id);
332: fetch lc_get_function_name into l_rule_name;
333: if lc_get_function_name%NOTFOUND