1 Package pqh_popl_criteria_ovrrd as
2 /* $Header: pqrbcovd.pkh 120.0 2005/05/29 02:24 appldev noship $ */
3 --
4 -- Record structure for passing criteria list, for which rate has to be evaluated.
5 -- May need to change the structure based on BEN changes.
6 --
7 Type g_crit_ovrrd_val_rec is record(criteria_short_code varchar2(30),
8 number_value1 number(15),
9 number_value2 number(15),
10 char_value1 varchar2(240),
11 char_value2 varchar2(240),
12 date_value1 date,
13 date_value2 date);
14 --
15 Type g_crit_ovrrd_val_tbl is table of g_crit_ovrrd_val_rec index by binary_integer;
16 --
17 g_criteria_override_val g_crit_ovrrd_val_tbl; /** Table with override data, accessed by BEN **/
18 g_criteria_count number(15) := 0; /** If count > 0, then there is override data in above table **/
19 --
20 Procedure init_criteria_override_tbl;
21 --
22 Procedure insert_criteria_override(p_crit_ovrrd_val_rec IN g_crit_ovrrd_val_rec);
23 --
24 Procedure get_criteria_override(p_crit_ovrrd_val_rec OUT nocopy g_crit_ovrrd_val_rec);
25 --
26 --
27 End pqh_popl_criteria_ovrrd;
[Home] [Help]