1 PACKAGE ben_cvg_cache AUTHID CURRENT_USER AS
2 /* $Header: bencvgch.pkh 115.3 2002/12/23 12:43:37 lakrish ship $ */
3 --
4 -- Get epe plan coverage
5 --
6 type g_epeplncvg_cache_rec is record
7 (cvg_amt_calc_mthd_id ben_cvg_amt_calc_mthd_f.cvg_amt_calc_mthd_id%type
8 ,comp_lvl_fctr_id ben_cvg_amt_calc_mthd_f.comp_lvl_fctr_id%type
9 ,cvg_mlt_cd ben_cvg_amt_calc_mthd_f.cvg_mlt_cd%type
10 ,bndry_perd_cd ben_cvg_amt_calc_mthd_f.bndry_perd_cd%type
11 ,bnft_typ_cd ben_cvg_amt_calc_mthd_f.bnft_typ_cd%type
12 ,val ben_cvg_amt_calc_mthd_f.val%type
13 ,nnmntry_uom ben_cvg_amt_calc_mthd_f.nnmntry_uom%type
14 ,mx_val ben_cvg_amt_calc_mthd_f.mx_val%type
15 ,mn_val ben_cvg_amt_calc_mthd_f.mn_val%type
16 ,incrmt_val ben_cvg_amt_calc_mthd_f.incrmt_val%type
17 ,rt_typ_cd ben_cvg_amt_calc_mthd_f.rt_typ_cd%type
18 ,business_group_id ben_cvg_amt_calc_mthd_f.business_group_id%type
19 ,rndg_cd ben_cvg_amt_calc_mthd_f.rndg_cd%type
20 ,rndg_rl ben_cvg_amt_calc_mthd_f.rndg_rl%type
21 ,val_calc_rl ben_cvg_amt_calc_mthd_f.val_calc_rl%type
22 ,dflt_val ben_cvg_amt_calc_mthd_f.dflt_val%type
23 ,entr_val_at_enrt_flag ben_cvg_amt_calc_mthd_f.entr_val_at_enrt_flag%type
24 ,lwr_lmt_val ben_cvg_amt_calc_mthd_f.lwr_lmt_val%type
25 ,lwr_lmt_calc_rl ben_cvg_amt_calc_mthd_f.lwr_lmt_calc_rl%type
26 ,upr_lmt_val ben_cvg_amt_calc_mthd_f.upr_lmt_val%type
27 ,upr_lmt_calc_rl ben_cvg_amt_calc_mthd_f.upr_lmt_calc_rl%type
28 ,cvg_incr_r_decr_only_cd ben_pl_f.cvg_incr_r_decr_only_cd%type
29 ,bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type
30 ,mx_cvg_rl ben_pl_f.mx_cvg_rl%type
31 ,mn_cvg_rl ben_pl_f.mn_cvg_rl%type
32 );
33 --
34 type g_epeplncvg_cache is table of g_epeplncvg_cache_rec index by binary_integer;
35 --
36 procedure epeplncvg_getdets
37 (p_epe_id in number
38 ,p_epe_pl_id in number
39 ,p_epe_plip_id in number
40 ,p_epe_oipl_id in number
41 ,p_effective_date in date
42 ,p_cvgtype_code in varchar2
43 --
44 ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache
45 ,p_inst_count out nocopy number
46 );
47 --
48 procedure plnplncvg_getdets
49 (p_pln_id in number
50 ,p_effective_date in date
51 --
52 ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache
53 ,p_inst_count out nocopy number
54 );
55 --
56 procedure cppplncvg_getdets
57 (p_plip_id in number
58 ,p_effective_date in date
59 --
60 ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache
61 ,p_inst_count out nocopy number
62 );
63 --
64 procedure copplncvg_getdets
65 (p_oipl_id in number
66 ,p_effective_date in date
67 --
68 ,p_inst_set out nocopy ben_cvg_cache.g_epeplncvg_cache
69 ,p_inst_count out nocopy number
70 );
71 --
72 -- Get the coverage details for the EPE walking down the comp
73 -- object tree
74 --
75 procedure epecobjtree_getcvgdets
76 (p_epe_id in number
77 ,p_epe_pl_id in number
78 ,p_epe_plip_id in number
79 ,p_epe_oipl_id in number
80 ,p_effective_date in date
81 --
82 ,p_cvg_set out nocopy ben_cvg_cache.g_epeplncvg_cache
83 );
84 --
85 END ben_cvg_cache;