12: p_start_date in date,
13: p_end_date in date)
14: return number is
15: --
16: l_inputs ff_exec.inputs_t;
17: l_outputs ff_exec.outputs_t;
18: l_number number := 0;
19: l_formula_id number := 0;
20: l_formula_type_id number := 0;
13: p_end_date in date)
14: return number is
15: --
16: l_inputs ff_exec.inputs_t;
17: l_outputs ff_exec.outputs_t;
18: l_number number := 0;
19: l_formula_id number := 0;
20: l_formula_type_id number := 0;
21: l_start_date date := null;
61: then
62: return 0;
63: else
64: --
65: ff_exec.init_formula
66: (p_formula_id => l_formula_id,
67: p_effective_date => p_start_date,
68: p_inputs => l_inputs,
69: p_outputs => l_outputs);
123: end if;
124: --
125: end loop;
126: --
127: ff_exec.run_formula(p_inputs => l_inputs,
128: p_outputs => l_outputs);
129: --
130: if l_outputs(1).value <> 0
131: then
157: p_person_id in number,
158: p_effective_date in date)
159: return number is
160: --
161: l_inputs ff_exec.inputs_t;
162: l_outputs ff_exec.outputs_t;
163: l_number number := 0;
164: l_formula_id number := 0;
165: --
158: p_effective_date in date)
159: return number is
160: --
161: l_inputs ff_exec.inputs_t;
162: l_outputs ff_exec.outputs_t;
163: l_number number := 0;
164: l_formula_id number := 0;
165: --
166: -- cursors used for promotion event
198: then
199: return 0;
200: else
201: --
202: ff_exec.init_formula
203: (p_formula_id => l_formula_id,
204: p_effective_date => p_effective_date,
205: p_inputs => l_inputs,
206: p_outputs => l_outputs);
259: end if;
260: --
261: end loop;
262: --
263: ff_exec.run_formula(p_inputs => l_inputs,
264: p_outputs => l_outputs);
265: --
266: if l_outputs(1).value <> 0
267: then
297: p_end_date in date,
298: p_date_tab out nocopy date_tab) -- Added by ssmukher
299: return number is
300: --
301: l_inputs ff_exec.inputs_t;
302: l_outputs ff_exec.outputs_t;
303: l_formula_id number ;
304: l_formula_type_id number;
305: l_start_date date ;
298: p_date_tab out nocopy date_tab) -- Added by ssmukher
299: return number is
300: --
301: l_inputs ff_exec.inputs_t;
302: l_outputs ff_exec.outputs_t;
303: l_formula_id number ;
304: l_formula_type_id number;
305: l_start_date date ;
306: l_cnt number; /* Added by ssmukher for employment equity report */
353: then
354: return 0;
355: else
356: --
357: ff_exec.init_formula
358: (p_formula_id => l_formula_id,
359: p_effective_date => p_start_date,
360: p_inputs => l_inputs,
361: p_outputs => l_outputs);
410: end if;
411: --
412: end loop;
413: --
414: ff_exec.run_formula(p_inputs => l_inputs,
415: p_outputs => l_outputs);
416: --
417: if l_outputs(1).value <> 0
418: then