DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on FND_MENUS

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

1870: )
1871: return boolean
1872: is
1873: l_resp_id number;
1874: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE default null;
1875: l_appraisal_empl_menu fnd_menus.menu_name%TYPE default null;
1876: l_selected_menu fnd_menus.menu_name%TYPE default null;
1877: l_function_id fnd_form_functions.function_id%TYPE;
1878: l_function_name fnd_form_functions.function_name%TYPE;

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

1871: return boolean
1872: is
1873: l_resp_id number;
1874: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE default null;
1875: l_appraisal_empl_menu fnd_menus.menu_name%TYPE default null;
1876: l_selected_menu fnd_menus.menu_name%TYPE default null;
1877: l_function_id fnd_form_functions.function_id%TYPE;
1878: l_function_name fnd_form_functions.function_name%TYPE;
1879: l_initiation_type varchar2(10) default null;

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

1872: is
1873: l_resp_id number;
1874: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE default null;
1875: l_appraisal_empl_menu fnd_menus.menu_name%TYPE default null;
1876: l_selected_menu fnd_menus.menu_name%TYPE default null;
1877: l_function_id fnd_form_functions.function_id%TYPE;
1878: l_function_name fnd_form_functions.function_name%TYPE;
1879: l_initiation_type varchar2(10) default null;
1880: l_func_params fnd_form_functions.parameters%TYPE;

Line 1882: l_menu_id fnd_menus.menu_id%TYPE;

1878: l_function_name fnd_form_functions.function_name%TYPE;
1879: l_initiation_type varchar2(10) default null;
1880: l_func_params fnd_form_functions.parameters%TYPE;
1881: l_system_type varchar2(50);
1882: l_menu_id fnd_menus.menu_id%TYPE;
1883:
1884:
1885: cursor get_appraisal_function(p_menu_name fnd_menus.menu_name%TYPE, p_search_func varchar2)
1886: is

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

1881: l_system_type varchar2(50);
1882: l_menu_id fnd_menus.menu_id%TYPE;
1883:
1884:
1885: cursor get_appraisal_function(p_menu_name fnd_menus.menu_name%TYPE, p_search_func varchar2)
1886: is
1887: select menu_functions.function_id, ff.function_name, ff.parameters, menu_id from FND_COMPILED_MENU_FUNCTIONS menu_functions, fnd_form_functions ff
1888: where menu_id = (select menu_id from fnd_menus where menu_name = p_menu_name)
1889: and ff.function_id = menu_functions.function_id

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

1884:
1885: cursor get_appraisal_function(p_menu_name fnd_menus.menu_name%TYPE, p_search_func varchar2)
1886: is
1887: select menu_functions.function_id, ff.function_name, ff.parameters, menu_id from FND_COMPILED_MENU_FUNCTIONS menu_functions, fnd_form_functions ff
1888: where menu_id = (select menu_id from fnd_menus where menu_name = p_menu_name)
1889: and ff.function_id = menu_functions.function_id
1890: and ff.parameters like p_search_func;
1891:
1892: begin