APPS.PQP_GB_SWF_ARCHIVE dependencies on FF_EXEC

Line 1710: l_inputs ff_exec.inputs_t;

1706: where ff.formula_id = p_formula_id
1707: and ff.business_group_id = p_business_group_id
1708: and p_effective_date between ff.effective_start_date and ff.effective_end_date;
1709: --
1710: l_inputs ff_exec.inputs_t;
1711: p_inputs ff_exec.inputs_t;
1712: l_outputs ff_exec.outputs_t;
1713: l_result varchar2(25);
1714: l_formula_id ff_formulas_f.formula_id%type;

Line 1711: p_inputs ff_exec.inputs_t;

1707: and ff.business_group_id = p_business_group_id
1708: and p_effective_date between ff.effective_start_date and ff.effective_end_date;
1709: --
1710: l_inputs ff_exec.inputs_t;
1711: p_inputs ff_exec.inputs_t;
1712: l_outputs ff_exec.outputs_t;
1713: l_result varchar2(25);
1714: l_formula_id ff_formulas_f.formula_id%type;
1715: l_formula_name ff_formulas_f.formula_name%type;

Line 1712: l_outputs ff_exec.outputs_t;

1708: and p_effective_date between ff.effective_start_date and ff.effective_end_date;
1709: --
1710: l_inputs ff_exec.inputs_t;
1711: p_inputs ff_exec.inputs_t;
1712: l_outputs ff_exec.outputs_t;
1713: l_result varchar2(25);
1714: l_formula_id ff_formulas_f.formula_id%type;
1715: l_formula_name ff_formulas_f.formula_name%type;
1716: l_warning_msg varchar2(300);

Line 1741: ff_exec.init_formula(l_formula_id, p_effective_date , l_inputs, l_outputs);

1737: close get_formula_id;
1738:
1739: if l_formula_id is not null then
1740: hr_utility.trace(' Inside run_user_formula '||l_formula_name);
1741: ff_exec.init_formula(l_formula_id, p_effective_date , l_inputs, l_outputs);
1742:
1743: if l_inputs.count > 0 and p_inputs.count > 0 then
1744: for i in 1..l_inputs.count
1745: loop

Line 1760: ff_exec.run_formula(l_inputs,l_outputs);

1756: for i in 1..l_inputs.count loop
1757: hr_utility.trace(' i= '||i||' name '||l_inputs(i).name ||' value '||l_inputs(i).value);
1758: end loop;
1759:
1760: ff_exec.run_formula(l_inputs,l_outputs);
1761: hr_utility.trace(' calculated value from user formula '||l_outputs(1).value);
1762: l_result := l_outputs(1).value ;
1763: end if;
1764:

Line 1796: l_inputs ff_exec.inputs_t;

1792: where ff.formula_name = 'GB_CALCULATE_FTE_USING_PQP_CONTRACT_TYPES'
1793: and ff.legislation_code = 'GB'
1794: and p_effective_date between ff.effective_start_date and ff.effective_end_date;
1795: --
1796: l_inputs ff_exec.inputs_t;
1797: p_inputs ff_exec.inputs_t;
1798: l_outputs ff_exec.outputs_t;
1799: l_result varchar2(25);
1800: l_formula_id ff_formulas_f.formula_id%type;

Line 1797: p_inputs ff_exec.inputs_t;

1793: and ff.legislation_code = 'GB'
1794: and p_effective_date between ff.effective_start_date and ff.effective_end_date;
1795: --
1796: l_inputs ff_exec.inputs_t;
1797: p_inputs ff_exec.inputs_t;
1798: l_outputs ff_exec.outputs_t;
1799: l_result varchar2(25);
1800: l_formula_id ff_formulas_f.formula_id%type;
1801: l_formula_name ff_formulas_f.formula_name%type;

Line 1798: l_outputs ff_exec.outputs_t;

1794: and p_effective_date between ff.effective_start_date and ff.effective_end_date;
1795: --
1796: l_inputs ff_exec.inputs_t;
1797: p_inputs ff_exec.inputs_t;
1798: l_outputs ff_exec.outputs_t;
1799: l_result varchar2(25);
1800: l_formula_id ff_formulas_f.formula_id%type;
1801: l_formula_name ff_formulas_f.formula_name%type;
1802: l_warning_msg varchar2(300);

Line 1827: ff_exec.init_formula(l_formula_id, p_effective_date , l_inputs, l_outputs);

1823: close get_formula_id;
1824:
1825: if l_formula_id is not null then
1826: hr_utility.trace(' Inside run_seeded_formula '||l_formula_name);
1827: ff_exec.init_formula(l_formula_id, p_effective_date , l_inputs, l_outputs);
1828:
1829: if l_inputs.count > 0 and p_inputs.count > 0 then
1830: for i in 1..l_inputs.count
1831: loop

Line 1846: ff_exec.run_formula(l_inputs,l_outputs);

1842: for i in 1..l_inputs.count loop
1843: hr_utility.trace(' i= '||i||' name '||l_inputs(i).name ||' value '||l_inputs(i).value);
1844: end loop;
1845:
1846: ff_exec.run_formula(l_inputs,l_outputs);
1847:
1848: for i in 1..l_outputs.count loop
1849: hr_utility.trace(' i= '||i||' name '||l_outputs(i).name ||' value '||l_outputs(i).value);
1850: