APPS.PQP_GB_SWF_ARCHIVE dependencies on FF_FORMULAS_F

Line 1695: function run_user_formula(p_formula_id in ff_formulas_f.formula_name%type

1691: -- for hours per week and fte hours, the formula should return values in
1692: -- number(s).numbers(s) format
1693: -- The formula will throw an error if the format is anything other than the
1694: -- specified format
1695: function run_user_formula(p_formula_id in ff_formulas_f.formula_name%type
1696: ,p_assignment_id in number
1697: ,p_effective_date in date
1698: ,p_business_group_id in number
1699: ,p_assignment_number in varchar2

Line 1705: from ff_formulas_f ff

1701: return varchar2 is
1702:
1703: cursor get_formula_id is
1704: select ff.formula_id,ff.formula_name
1705: from ff_formulas_f ff
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: --

Line 1714: l_formula_id ff_formulas_f.formula_id%type;

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);
1717:
1718: l_proc constant varchar2(50):= g_package||'run_user_formula';

Line 1715: l_formula_name ff_formulas_f.formula_name%type;

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);
1717:
1718: l_proc constant varchar2(50):= g_package||'run_user_formula';
1719: begin

Line 1791: from ff_formulas_f ff

1787:
1788:
1789: cursor get_formula_id is
1790: select ff.formula_id,ff.formula_name
1791: from ff_formulas_f ff
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: --

Line 1800: l_formula_id ff_formulas_f.formula_id%type;

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);
1803:
1804: l_proc constant varchar2(50):= g_package||'run_seeded_formula';

Line 1801: l_formula_name ff_formulas_f.formula_name%type;

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);
1803:
1804: l_proc constant varchar2(50):= g_package||'run_seeded_formula';
1805: begin

Line 2814: l_user_formula_name ff_formulas_f.formula_name%type;

2810: l_dcsf_destination hr_lookups.lookup_code%type;
2811: l_la_or_school_level varchar2(150);
2812: l_establishment number := p_estab_no;
2813: l_contract_agg_type hr_lookups.lookup_code%type;
2814: l_user_formula_name ff_formulas_f.formula_name%type;
2815: l_arch_role boolean;
2816: l_person_category varchar2(30);
2817: l_arch boolean := true;
2818: l_valid_flag varchar2(1);