DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on FND_MENUS

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

525: )
526: RETURN BOOLEAN
527: IS
528: l_resp_id NUMBER;
529: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
530: l_appraisal_empl_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
531: l_selected_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
532: l_function_id fnd_form_functions.function_id%TYPE;
533: l_function_name fnd_form_functions.function_name%TYPE;

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

526: RETURN BOOLEAN
527: IS
528: l_resp_id NUMBER;
529: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
530: l_appraisal_empl_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
531: l_selected_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
532: l_function_id fnd_form_functions.function_id%TYPE;
533: l_function_name fnd_form_functions.function_name%TYPE;
534: l_initiation_type VARCHAR2 (10) DEFAULT NULL;

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

527: IS
528: l_resp_id NUMBER;
529: l_appraisal_mgr_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
530: l_appraisal_empl_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
531: l_selected_menu fnd_menus.menu_name%TYPE DEFAULT NULL;
532: l_function_id fnd_form_functions.function_id%TYPE;
533: l_function_name fnd_form_functions.function_name%TYPE;
534: l_initiation_type VARCHAR2 (10) DEFAULT NULL;
535: l_func_params fnd_form_functions.PARAMETERS%TYPE;

Line 537: l_menu_id fnd_menus.menu_id%TYPE;

533: l_function_name fnd_form_functions.function_name%TYPE;
534: l_initiation_type VARCHAR2 (10) DEFAULT NULL;
535: l_func_params fnd_form_functions.PARAMETERS%TYPE;
536: l_system_type VARCHAR2 (50);
537: l_menu_id fnd_menus.menu_id%TYPE;
538:
539: CURSOR get_appraisal_function (
540: p_menu_name fnd_menus.menu_name%TYPE,
541: p_search_func VARCHAR2

Line 540: p_menu_name fnd_menus.menu_name%TYPE,

536: l_system_type VARCHAR2 (50);
537: l_menu_id fnd_menus.menu_id%TYPE;
538:
539: CURSOR get_appraisal_function (
540: p_menu_name fnd_menus.menu_name%TYPE,
541: p_search_func VARCHAR2
542: )
543: IS
544: SELECT menu_functions.function_id, ff.function_name, ff.PARAMETERS,

Line 549: FROM fnd_menus

545: menu_id
546: FROM fnd_compiled_menu_functions menu_functions,
547: fnd_form_functions ff
548: WHERE menu_id = (SELECT menu_id
549: FROM fnd_menus
550: WHERE menu_name = p_menu_name)
551: AND ff.function_id = menu_functions.function_id
552: AND ff.PARAMETERS LIKE p_search_func;
553: BEGIN