1 PACKAGE ben_cagrelp_cache AUTHID CURRENT_USER AS
2 /* $Header: benelpc1.pkh 120.0 2005/05/28 08:57:21 appldev noship $ */
3 --
4 type g_elp_cache_rec is record
5 (eligy_prfl_id number
6 ,pk_id number
7 ,short_code varchar2(30)
8 ,v230_val varchar2(30)
9 ,num_val number
10 ,num_val1 number
11 ,excld_flag varchar2(100)
12 ,criteria_score number
13 ,criteria_weight number
14 );
15 --
16 type g_elp_cache is varray(1000000) of g_elp_cache_rec;
17 --
18 procedure elpegn_getdets
19 (p_effective_date in date
20 ,p_eligy_prfl_id in number
21 --
22 ,p_inst_set in out nocopy g_elp_cache
23 );
24 --
25 procedure elpemp_getdets
26 (p_effective_date in date
27 ,p_eligy_prfl_id in number
28 --
29 ,p_inst_set in out nocopy g_elp_cache
30 );
31 --
32 procedure elpect_getdets
33 (p_effective_date in date
34 ,p_eligy_prfl_id in number
35 --
36 ,p_inst_set in out nocopy g_elp_cache
37 );
38 --
39 procedure elpedr_getdets
40 (p_effective_date in date
41 ,p_eligy_prfl_id in number
42 --
43 ,p_inst_set in out nocopy g_elp_cache
44 );
45 --
46 procedure elpedd_getdets
47 (p_effective_date in date
48 ,p_eligy_prfl_id in number
49 --
50 ,p_inst_set in out nocopy g_elp_cache
51 );
52 --
53 procedure elpest_getdets
54 (p_effective_date in date
55 ,p_eligy_prfl_id in number
56 --
57 ,p_inst_set in out nocopy g_elp_cache
58 );
59 --
60 procedure elpeqt_getdets
61 (p_effective_date in date
62 ,p_eligy_prfl_id in number
63 --
64 ,p_inst_set in out nocopy g_elp_cache
65 );
66 --
67 procedure elpeps_getdets
68 (p_effective_date in date
69 ,p_eligy_prfl_id in number
70 --
71 ,p_inst_set in out nocopy g_elp_cache
72 );
73 --
74 procedure elpepn_getdets
75 (p_effective_date in date
76 ,p_eligy_prfl_id in number
77 --
78 ,p_inst_set in out nocopy g_elp_cache
79 );
80 --
81 procedure elpesp_getdets
82 (p_effective_date in date
83 ,p_eligy_prfl_id in number
84 --
85 ,p_inst_set in out nocopy g_elp_cache
86 );
87 --
88 procedure clear_down_cache;
89 --
90 END ben_cagrelp_cache;
[Home] [Help]