1 PACKAGE hri_bpl_fast_formula_util AS
2 /* $Header: hribuffl.pkh 120.1.12000000.2 2007/04/12 12:08:17 smohapat noship $ */
3
4 TYPE formula_param_type IS TABLE OF VARCHAR2(240) INDEX BY VARCHAR2(30);
5
6 PROCEDURE run_formula
7 (p_formula_id IN NUMBER,
8 p_input_tab IN formula_param_type,
9 p_output_tab OUT NOCOPY formula_param_type);
10
11 FUNCTION fetch_bg_formula_id(p_formula_name IN VARCHAR2,
12 p_business_group_id IN NUMBER)
13 RETURN NUMBER;
14
15 FUNCTION fetch_bg_formula_id(p_formula_name IN VARCHAR2,
16 p_business_group_id IN NUMBER,
17 p_formula_type_name IN VARCHAR2)
18 RETURN NUMBER;
19
20 FUNCTION fetch_setup_formula_id(p_formula_name IN VARCHAR2)
21 RETURN NUMBER;
22
23 FUNCTION fetch_seeded_formula_id(p_formula_name IN VARCHAR2)
24 RETURN NUMBER;
25
26 FUNCTION fetch_formula_id
27 (p_formula_name IN VARCHAR2,
28 p_business_group_id IN NUMBER,
29 p_bg_formula_name IN VARCHAR2 DEFAULT NULL,
30 p_setup_formula_name IN VARCHAR2 DEFAULT NULL,
31 p_seeded_formula_name IN VARCHAR2 DEFAULT NULL,
32 p_try_bg_formula IN VARCHAR2 DEFAULT 'Y',
33 p_try_setup_formula IN VARCHAR2 DEFAULT 'Y',
34 p_try_seeded_formula IN VARCHAR2 DEFAULT 'Y')
35 RETURN NUMBER;
36
37 END hri_bpl_fast_formula_util;