1 PACKAGE iby_formula_pkg AUTHID CURRENT_USER AS
2 /*$Header: ibyforms.pls 115.7 2002/11/19 00:19:52 jleybovi ship $*/
3
4 /*
5 ** This packge manages payee formulas, creation, modification
6 ** loading , and deletion.
7 */
8
9
10 /* Record definition to store formula header information */
11 TYPE risk_formula IS RECORD ( id number(15),
12 name VARCHAR2(80),
13 description VARCHAR2(240),
14 flag number(15));
15
16 TYPE formula_table IS TABLE OF risk_formula INDEX BY BINARY_INTEGER;
17
18 /* Record definition to store Factor associated with formulas */
19 TYPE risk_factor IS RECORD ( name VARCHAR2(30),
20 weight number(15));
21
22 TYPE factor_table IS TABLE OF risk_factor INDEX BY BINARY_INTEGER;
23
24 /*
25 ** Name : getPayeeFormula
26 ** Purpose : Retrieves the payee Formula records into o_RiskFormula
27 ** corresponding to payeeid.
28 */
29 Procedure getPayeeFormulas( i_payeeid in VARCHAR2,
30 o_RiskFormula out nocopy formula_table);
31
32 /*
33 ** Name : createFormula
34 ** Purpose : Creates a new formula in the database for the payee Id passed
35 ** and returns back the formula Is as output parameter.
36 */
37 Procedure createFormula( i_payeeId in VARCHAR2,
38 i_name in VARCHAR2,
39 i_description in VARCHAR2,
40 i_flag in integer,
41 i_count in integer,
42 i_Factors in factor_table,
43 o_id out nocopy integer);
44
45 /*
46 ** Name : modifyFormula
47 ** Purpose : modifies the formula information corresponding to the
48 ** formulaId with the passed information in the database.
49 */
50 Procedure modifyFormula( i_id in integer,
51 i_name in VARCHAR2,
52 i_description in VARCHAR2,
53 i_flag in integer,
54 i_count in integer,
55 i_Factors in factor_table);
56
57 /*
58 ** Name : deleteFormula
59 ** Purpose : deletes the formula corresponding to the formulaId
60 ** from the database.
61 */
62 Procedure deleteFormula( i_id in integer);
63
64 /*
65 ** Name : loadFormula
66 ** Purpose : Retrievs the Formula information and loads the
67 ** factors of the formula into o_Factors
68 ** corresponding to formulaId.
69 */
70 Procedure loadFormula( i_formulaId in integer,
71 o_name out nocopy varchar2,
72 o_description out nocopy varchar2,
73 o_flag out nocopy integer,
74 o_Factors out nocopy factor_table);
75
76 end iby_formula_pkg;
77