PACKAGE: APPS.HRI_BPL_FAST_FORMULA_UTIL

Source

1 PACKAGE hri_bpl_fast_formula_util AUTHID CURRENT_USER AS
2 /* $Header: hribuffl.pkh 120.3 2011/09/21 09:27:16 vepravee ship $ */
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;