DBA Data[Home] [Help]

APPS.HR_WPM_MASS_APR_PUSH dependencies on FND_FORM_FUNCTIONS

Line 432: p_function_id in out nocopy fnd_form_functions.function_id%TYPE,

428: End populate_plan_apprsl_periods;
429: --
430:
431: function get_appraisal_config_params(p_appr_initiator_code in per_appraisal_periods.initiator_code%TYPE,
432: p_function_id in out nocopy fnd_form_functions.function_id%TYPE,
433: p_function_name in out nocopy fnd_form_functions.function_name%TYPE,
434: p_func_parameters in out nocopy fnd_form_functions.parameters%TYPE,
435: p_appraisal_sys_type in out nocopy per_appraisals.appraisal_system_status%TYPE
436: )

Line 433: p_function_name in out nocopy fnd_form_functions.function_name%TYPE,

429: --
430:
431: function get_appraisal_config_params(p_appr_initiator_code in per_appraisal_periods.initiator_code%TYPE,
432: p_function_id in out nocopy fnd_form_functions.function_id%TYPE,
433: p_function_name in out nocopy fnd_form_functions.function_name%TYPE,
434: p_func_parameters in out nocopy fnd_form_functions.parameters%TYPE,
435: p_appraisal_sys_type in out nocopy per_appraisals.appraisal_system_status%TYPE
436: )
437: return boolean

Line 434: p_func_parameters in out nocopy fnd_form_functions.parameters%TYPE,

430:
431: function get_appraisal_config_params(p_appr_initiator_code in per_appraisal_periods.initiator_code%TYPE,
432: p_function_id in out nocopy fnd_form_functions.function_id%TYPE,
433: p_function_name in out nocopy fnd_form_functions.function_name%TYPE,
434: p_func_parameters in out nocopy fnd_form_functions.parameters%TYPE,
435: p_appraisal_sys_type in out nocopy per_appraisals.appraisal_system_status%TYPE
436: )
437: return boolean
438: is

Line 443: l_function_id fnd_form_functions.function_id%TYPE;

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;
447: l_system_type varchar2(50);

Line 444: l_function_name fnd_form_functions.function_name%TYPE;

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;
447: l_system_type varchar2(50);
448: l_menu_id fnd_menus.menu_id%TYPE;

Line 446: l_func_params fnd_form_functions.parameters%TYPE;

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;
447: l_system_type varchar2(50);
448: l_menu_id fnd_menus.menu_id%TYPE;
449:
450:

Line 453: select menu_functions.function_id, ff.function_name, ff.parameters, menu_id from FND_COMPILED_MENU_FUNCTIONS menu_functions, fnd_form_functions ff

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
456: and ff.parameters like p_search_func;
457:

Line 925: l_function_id fnd_form_functions.function_id%TYPE;

921: APPRAISAL_SYSTEM_TYPE_ERROR EXCEPTION;
922: l_weighting_over_100_warning boolean;
923: l_weighting_appraisal_warning boolean;
924: NO_APPRL_FUNCTION_DEFINED EXCEPTION;
925: l_function_id fnd_form_functions.function_id%TYPE;
926: l_function_name fnd_form_functions.function_name%TYPE;
927: l_func_params fnd_form_functions.parameters%TYPE;
928: l_object_id NUMBER;
929: l_assess_comps_processed competences_tbl;

Line 926: l_function_name fnd_form_functions.function_name%TYPE;

922: l_weighting_over_100_warning boolean;
923: l_weighting_appraisal_warning boolean;
924: NO_APPRL_FUNCTION_DEFINED EXCEPTION;
925: l_function_id fnd_form_functions.function_id%TYPE;
926: l_function_name fnd_form_functions.function_name%TYPE;
927: l_func_params fnd_form_functions.parameters%TYPE;
928: l_object_id NUMBER;
929: l_assess_comps_processed competences_tbl;
930: z PLS_INTEGER;

Line 927: l_func_params fnd_form_functions.parameters%TYPE;

923: l_weighting_appraisal_warning boolean;
924: NO_APPRL_FUNCTION_DEFINED EXCEPTION;
925: l_function_id fnd_form_functions.function_id%TYPE;
926: l_function_name fnd_form_functions.function_name%TYPE;
927: l_func_params fnd_form_functions.parameters%TYPE;
928: l_object_id NUMBER;
929: l_assess_comps_processed competences_tbl;
930: z PLS_INTEGER;
931: l_def_job_comps sel_comp_tab;