1 PACKAGE ben_cop_cache AUTHID CURRENT_USER AS
2 /* $Header: bencopch.pkh 115.3 2003/01/30 00:08:01 kmahendr ship $ */
3 --
4 -- Get oipl details for plans which are not in programs
5 --
6 type g_bgpcop_rec is record
7 (oipl_id ben_oipl_f.oipl_id%type
8 ,opt_id ben_oipl_f.opt_id%type
9 ,drvbl_fctr_prtn_elig_flag ben_oipl_f.drvbl_fctr_prtn_elig_flag%type
10 ,drvbl_fctr_apls_rts_flag ben_oipl_f.drvbl_fctr_apls_rts_flag%type
11 ,trk_inelig_per_flag ben_oipl_f.trk_inelig_per_flag%type
12 );
13 --
14 type g_bgpcop_cache is table of g_bgpcop_rec
15 index by binary_integer;
16 --
17 g_eedcop_parlookup ben_cache.g_cache_lookup_table;
18 g_eedcop_lookup ben_cache.g_cache_lookup_table;
19 g_eedcop_inst ben_cop_cache.g_bgpcop_cache;
20 --
21 procedure bgpcop_getdets
22 (p_effective_date in date
23 ,p_business_group_id in number
24 ,p_pl_id in number default null
25 ,p_opt_id in number default null
26 ,p_eligy_prfl_id in number default null
27 ,p_vrbl_rt_prfl_id in number default null
28 ,p_mode in varchar2 default null
29 --
30 ,p_inst_set out nocopy ben_cop_cache.g_bgpcop_cache
31 );
32 --
33 procedure clear_down_cache;
34 --
35 END ben_cop_cache;
[Home] [Help]