13: g_message_name VARCHAR2(255) := ' ';
14:
15: g_working_hours_formula_exists BOOLEAN := TRUE;
16: g_working_hours_formula_cached BOOLEAN := FALSE;
17: g_working_hours_formula_id ff_formulas_f.formula_id%TYPE;
18: g_working_hours_formula_name ff_formulas_f.formula_name%TYPE;
19:
20:
21: /*******************************************************************************
14:
15: g_working_hours_formula_exists BOOLEAN := TRUE;
16: g_working_hours_formula_cached BOOLEAN := FALSE;
17: g_working_hours_formula_id ff_formulas_f.formula_id%TYPE;
18: g_working_hours_formula_name ff_formulas_f.formula_name%TYPE;
19:
20:
21: /*******************************************************************************
22: |Name : GET_ALL_PARAMETERS |
668: l_inputs ff_exec.inputs_t;
669: l_outputs ff_exec.outputs_t;
670: l_formula_exists BOOLEAN := TRUE;
671: l_formula_cached BOOLEAN := FALSE;
672: l_formula_id ff_formulas_f.formula_id%TYPE;
673: l_formula_name ff_formulas_f.formula_name%TYPE;
674: l_weekly_working_hours NUMBER;
675: l_ind_work_hours NUMBER;
676: l_ind_work_hours2 varchar2(10);
669: l_outputs ff_exec.outputs_t;
670: l_formula_exists BOOLEAN := TRUE;
671: l_formula_cached BOOLEAN := FALSE;
672: l_formula_id ff_formulas_f.formula_id%TYPE;
673: l_formula_name ff_formulas_f.formula_name%TYPE;
674: l_weekly_working_hours NUMBER;
675: l_ind_work_hours NUMBER;
676: l_ind_work_hours2 varchar2(10);
677: l_frequency varchar2(10);