DBA Data[Home] [Help]

APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on FND_MENUS

Line 2596: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE DEFAULT NULL;

2592: )
2593: RETURN BOOLEAN
2594: IS
2595: l_resp_id NUMBER;
2596: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2597: l_appraisal_empl_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2598: l_selected_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2599: l_function_id fnd_form_functions.function_id%TYPE;
2600: l_function_name fnd_form_functions.function_name%TYPE;

Line 2597: l_appraisal_empl_menu fnd_menus.menu_name%TYPE DEFAULT NULL;

2593: RETURN BOOLEAN
2594: IS
2595: l_resp_id NUMBER;
2596: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2597: l_appraisal_empl_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2598: l_selected_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2599: l_function_id fnd_form_functions.function_id%TYPE;
2600: l_function_name fnd_form_functions.function_name%TYPE;
2601: l_initiation_type VARCHAR2 (10) DEFAULT NULL;

Line 2598: l_selected_menu fnd_menus.menu_name%TYPE DEFAULT NULL;

2594: IS
2595: l_resp_id NUMBER;
2596: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2597: l_appraisal_empl_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2598: l_selected_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
2599: l_function_id fnd_form_functions.function_id%TYPE;
2600: l_function_name fnd_form_functions.function_name%TYPE;
2601: l_initiation_type VARCHAR2 (10) DEFAULT NULL;
2602: l_func_params fnd_form_functions.PARAMETERS%TYPE;

Line 2604: l_menu_id fnd_menus.menu_id%TYPE;

2600: l_function_name fnd_form_functions.function_name%TYPE;
2601: l_initiation_type VARCHAR2 (10) DEFAULT NULL;
2602: l_func_params fnd_form_functions.PARAMETERS%TYPE;
2603: l_system_type VARCHAR2 (50);
2604: l_menu_id fnd_menus.menu_id%TYPE;
2605:
2606: CURSOR get_appraisal_function (p_menu_name fnd_menus.menu_name%TYPE, p_search_func VARCHAR2)
2607: IS
2608: SELECT menu_functions.function_id, ff.function_name, ff.PARAMETERS, menu_id

Line 2606: CURSOR get_appraisal_function (p_menu_name fnd_menus.menu_name%TYPE, p_search_func VARCHAR2)

2602: l_func_params fnd_form_functions.PARAMETERS%TYPE;
2603: l_system_type VARCHAR2 (50);
2604: l_menu_id fnd_menus.menu_id%TYPE;
2605:
2606: CURSOR get_appraisal_function (p_menu_name fnd_menus.menu_name%TYPE, p_search_func VARCHAR2)
2607: IS
2608: SELECT menu_functions.function_id, ff.function_name, ff.PARAMETERS, menu_id
2609: FROM fnd_compiled_menu_functions menu_functions, fnd_form_functions ff
2610: WHERE menu_id = (SELECT menu_id

Line 2611: FROM fnd_menus

2607: IS
2608: SELECT menu_functions.function_id, ff.function_name, ff.PARAMETERS, menu_id
2609: FROM fnd_compiled_menu_functions menu_functions, fnd_form_functions ff
2610: WHERE menu_id = (SELECT menu_id
2611: FROM fnd_menus
2612: WHERE menu_name = p_menu_name)
2613: AND ff.function_id = menu_functions.function_id
2614: AND ff.PARAMETERS LIKE p_search_func;
2615: BEGIN