1 Package ben_pd_formula_pkg as
2 /* $Header: beffnpkg.pkh 120.0 2006/03/21 17:19:42 nsanghal noship $ */
3
4 FUNCTION copy_formula_to_FF
5 (
6 p_business_group_id in number,
7 p_legislation_code in varchar2,
8 p_formula_id in number,
9 p_formula_type_id in number,
10 p_formula_name in varchar2,
11 p_description in varchar2,
12 p_effective_start_date in date,
13 p_effective_end_date in date,
14 p_formula_text in long ) return number;
15
16 function copy_formula_STAGE_TO_FF (
17 p_copy_entity_result_id IN number) return number;
18
19 procedure remove_formula_from_FF
20 ( p_formula_name in varchar2) ;
21
22 function compile_formula(
23 p_formula_id in number,
24 p_effective_date in date ) return varchar2;
25
26 function get_formula_text (p_formula_id number, p_effective_start_date date)
27 return clob;
28 --
29 FUNCTION maintain_formula(p_formula_id IN NUMBER
30 ,p_effective_date IN DATE
31 ,p_effective_start_date IN DATE
32 ,p_effective_end_date IN DATE
33 ,p_business_group_id IN NUMBER
34 ,p_legislation_code IN VARCHAR2
35 ,p_formula_type_id IN NUMBER
36 ,p_formula_name IN VARCHAR2
37 ,p_description IN VARCHAR2
38 ,p_formula_text IN LONG
39 ,p_sticky_flag IN VARCHAR2
40 ,p_compile_flag IN VARCHAR2
41 ,p_dml_operation IN VARCHAR2
42 ,p_datetrack_mode IN VARCHAR2)
43 RETURN varchar2;
44 --
45 FUNCTION copy_formula_result(p_copy_entity_txn_id IN NUMBER
46 ,p_formula_id IN NUMBER
47 ,p_effective_date IN DATE
48 ,p_business_group_id IN NUMBER)
49 RETURN NUMBER;
50
51 FUNCTION is_formula_verified (p_formula_id IN NUMBER
52 ,p_effective_date IN DATE ) RETURN VARCHAR2;
53 --
54 --
55 PROCEDURE formula_length_check (
56 p_formula_id IN NUMBER
57 ,p_effective_date IN DATE );
58
59 END; -- Package Specification BEN_PD_FORMULA_PKG