1 PACKAGE ben_pln_cache AUTHID CURRENT_USER AS
2 /* $Header: benplnch.pkh 115.7 2003/01/01 00:00:22 mmudigon ship $ */
3 --
4 -- Get plan details for plans which are not in programs
5 --
6 type g_nipplnpln_cache is table of ben_pl_f%rowtype
7 index by binary_integer;
8 --
9 type g_bgppln_rec is record
10 (pl_id ben_pl_f.pl_id%type
11 ,pl_typ_id ben_pl_f.pl_typ_id%type
12 ,ptp_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type
13 ,drvbl_fctr_prtn_elig_flag ben_pl_f.drvbl_fctr_prtn_elig_flag%type
14 ,drvbl_fctr_apls_rts_flag ben_pl_f.drvbl_fctr_apls_rts_flag%type
15 ,trk_inelig_per_flag ben_pl_f.trk_inelig_per_flag%type
16 );
17 --
18 type g_bgppln_cache is table of g_bgppln_rec
19 index by binary_integer;
20 --
21 type g_bgpcpp_cache_rec is record
22 (pgm_id number
23 ,pl_id number
24 ,pl_typ_id number
25 );
26 --
27 type g_bgpcpp_cache is table of ben_pl_f%rowtype
28 index by binary_integer;
29 --
30 g_eedcpp_parlookup ben_cache.g_cache_lookup_table;
31 g_eedcpp_lookup ben_cache.g_cache_lookup_table;
32 g_eedcpp_inst ben_pln_cache.g_bgpcpp_cache;
33 --
34 procedure bgpcpp_getdets
35 (p_business_group_id in number
36 ,p_effective_date in date
37 ,p_mode in varchar2
38 ,p_pgm_id in number default null
39 ,p_pl_id in number default null
40 ,p_opt_id in number default null
41 ,p_rptg_grp_id in number default null
42 ,p_vrbl_rt_prfl_id in number default null
43 ,p_eligy_prfl_id in number default null
44 -- PB : 5422 :
45 -- ,p_popl_enrt_typ_cycl_id in number default null
46 --
47 ,p_asnd_lf_evt_dt in date default null
48 ,p_inst_set out nocopy ben_pln_cache.g_bgppln_cache
49 );
50 --
51 procedure clear_down_cache;
52 --
53 END ben_pln_cache;
[Home] [Help]