2584: END delete_scorecard_objective;
2585:
2586: FUNCTION get_appraisal_config_params (
2587: p_appr_initiator_code IN per_appraisal_periods.initiator_code%TYPE,
2588: p_function_id IN OUT NOCOPY fnd_form_functions.function_id%TYPE,
2589: p_function_name IN OUT NOCOPY fnd_form_functions.function_name%TYPE,
2590: p_func_parameters IN OUT NOCOPY fnd_form_functions.PARAMETERS%TYPE,
2591: p_appraisal_sys_type IN OUT NOCOPY per_appraisals.appraisal_system_status%TYPE
2592: )
2585:
2586: FUNCTION get_appraisal_config_params (
2587: p_appr_initiator_code IN per_appraisal_periods.initiator_code%TYPE,
2588: p_function_id IN OUT NOCOPY fnd_form_functions.function_id%TYPE,
2589: p_function_name IN OUT NOCOPY fnd_form_functions.function_name%TYPE,
2590: p_func_parameters IN OUT NOCOPY fnd_form_functions.PARAMETERS%TYPE,
2591: p_appraisal_sys_type IN OUT NOCOPY per_appraisals.appraisal_system_status%TYPE
2592: )
2593: RETURN BOOLEAN
2586: FUNCTION get_appraisal_config_params (
2587: p_appr_initiator_code IN per_appraisal_periods.initiator_code%TYPE,
2588: p_function_id IN OUT NOCOPY fnd_form_functions.function_id%TYPE,
2589: p_function_name IN OUT NOCOPY fnd_form_functions.function_name%TYPE,
2590: p_func_parameters IN OUT NOCOPY fnd_form_functions.PARAMETERS%TYPE,
2591: p_appraisal_sys_type IN OUT NOCOPY per_appraisals.appraisal_system_status%TYPE
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;
2601: l_initiation_type VARCHAR2 (10) DEFAULT NULL;
2602: l_func_params fnd_form_functions.PARAMETERS%TYPE;
2603: l_system_type VARCHAR2 (50);
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;
2603: l_system_type VARCHAR2 (50);
2604: l_menu_id fnd_menus.menu_id%TYPE;
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;
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)
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
2611: FROM fnd_menus
2612: WHERE menu_name = p_menu_name)
2613: AND ff.function_id = menu_functions.function_id
3073: appraisal_system_type_error EXCEPTION;
3074: l_weighting_over_100_warning BOOLEAN;
3075: l_weighting_appraisal_warning BOOLEAN;
3076: no_apprl_function_defined EXCEPTION;
3077: l_function_id fnd_form_functions.function_id%TYPE;
3078: l_function_name fnd_form_functions.function_name%TYPE;
3079: l_func_params fnd_form_functions.PARAMETERS%TYPE;
3080: l_object_id NUMBER;
3081: l_assess_comps_processed competences_tbl;
3074: l_weighting_over_100_warning BOOLEAN;
3075: l_weighting_appraisal_warning BOOLEAN;
3076: no_apprl_function_defined EXCEPTION;
3077: l_function_id fnd_form_functions.function_id%TYPE;
3078: l_function_name fnd_form_functions.function_name%TYPE;
3079: l_func_params fnd_form_functions.PARAMETERS%TYPE;
3080: l_object_id NUMBER;
3081: l_assess_comps_processed competences_tbl;
3082: z PLS_INTEGER;
3075: l_weighting_appraisal_warning BOOLEAN;
3076: no_apprl_function_defined EXCEPTION;
3077: l_function_id fnd_form_functions.function_id%TYPE;
3078: l_function_name fnd_form_functions.function_name%TYPE;
3079: l_func_params fnd_form_functions.PARAMETERS%TYPE;
3080: l_object_id NUMBER;
3081: l_assess_comps_processed competences_tbl;
3082: z PLS_INTEGER;
3083: l_def_job_comps sel_comp_tab;