DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on FND_MENUS

Line 440: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE default null;

436: )
437: return boolean
438: is
439: l_resp_id number;
440: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE default null;
441: l_appraisal_empl_menu fnd_menus.menu_name%TYPE default null;
442: l_selected_menu fnd_menus.menu_name%TYPE default null;
443: l_function_id fnd_form_functions.function_id%TYPE;
444: l_function_name fnd_form_functions.function_name%TYPE;

Line 441: l_appraisal_empl_menu fnd_menus.menu_name%TYPE default null;

437: return boolean
438: is
439: l_resp_id number;
440: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE default null;
441: l_appraisal_empl_menu fnd_menus.menu_name%TYPE default null;
442: l_selected_menu fnd_menus.menu_name%TYPE default null;
443: l_function_id fnd_form_functions.function_id%TYPE;
444: l_function_name fnd_form_functions.function_name%TYPE;
445: l_initiation_type varchar2(10) default null;

Line 442: l_selected_menu fnd_menus.menu_name%TYPE default null;

438: is
439: l_resp_id number;
440: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE default null;
441: l_appraisal_empl_menu fnd_menus.menu_name%TYPE default null;
442: l_selected_menu fnd_menus.menu_name%TYPE default null;
443: l_function_id fnd_form_functions.function_id%TYPE;
444: l_function_name fnd_form_functions.function_name%TYPE;
445: l_initiation_type varchar2(10) default null;
446: l_func_params fnd_form_functions.parameters%TYPE;

Line 448: l_menu_id fnd_menus.menu_id%TYPE;

444: l_function_name fnd_form_functions.function_name%TYPE;
445: l_initiation_type varchar2(10) default null;
446: l_func_params fnd_form_functions.parameters%TYPE;
447: l_system_type varchar2(50);
448: l_menu_id fnd_menus.menu_id%TYPE;
449:
450:
451: cursor get_appraisal_function(p_menu_name fnd_menus.menu_name%TYPE, p_search_func varchar2)
452: is

Line 451: cursor get_appraisal_function(p_menu_name fnd_menus.menu_name%TYPE, p_search_func varchar2)

447: l_system_type varchar2(50);
448: l_menu_id fnd_menus.menu_id%TYPE;
449:
450:
451: cursor get_appraisal_function(p_menu_name fnd_menus.menu_name%TYPE, p_search_func varchar2)
452: is
453: select menu_functions.function_id, ff.function_name, ff.parameters, menu_id from FND_COMPILED_MENU_FUNCTIONS menu_functions, fnd_form_functions ff
454: where menu_id = (select menu_id from fnd_menus where menu_name = p_menu_name)
455: and ff.function_id = menu_functions.function_id

Line 454: where menu_id = (select menu_id from fnd_menus where menu_name = p_menu_name)

450:
451: cursor get_appraisal_function(p_menu_name fnd_menus.menu_name%TYPE, p_search_func varchar2)
452: is
453: select menu_functions.function_id, ff.function_name, ff.parameters, menu_id from FND_COMPILED_MENU_FUNCTIONS menu_functions, fnd_form_functions ff
454: where menu_id = (select menu_id from fnd_menus where menu_name = p_menu_name)
455: and ff.function_id = menu_functions.function_id
456: and ff.parameters like p_search_func;
457:
458: begin