[Home] [Help]
PACKAGE: APPS.BEN_CEL_CACHE
Source
1 PACKAGE ben_cel_cache AUTHID CURRENT_USER AS
2 /* $Header: bencelch.pkh 115.4 2002/12/24 15:44:17 bmanyam ship $ */
3 --
4 -- Hand coded
5 --
6 -- cep participating eligibility profile by cep
7 --
8 type g_cache_cepelp_object_rec is record
9 (pl_id ben_pl_f.pl_id%type,
10 pgm_id ben_pgm_f.pgm_id%type,
11 oipl_id ben_oipl_f.oipl_id%type,
12 plip_id ben_plip_f.plip_id%type,
13 ptip_id ben_ptip_f.ptip_id%type,
14 prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type,
15 mndtry_flag ben_prtn_elig_prfl_f.mndtry_flag%type,
16 eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type);
17 --
18 type g_cache_cepelp_instor is table of g_cache_cepelp_object_rec
19 index by binary_integer;
20 --
21 -- plan participating eligibility profile by plan
22 --
23 procedure plnelp_writecache
24 (p_effective_date in date,
25 p_refresh_cache in boolean default FALSE);
26 --
27 procedure plnelp_getcacdets
28 (p_effective_date in date,
29 p_business_group_id in number,
30 p_pl_id in number,
31 p_refresh_cache in boolean default FALSE,
32 p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
33 p_inst_count out nocopy number);
34 --
35 -- program participating eligibility profile by program
36 --
37 procedure pgmelp_writecache
38 (p_effective_date in date,
39 p_refresh_cache in boolean default FALSE);
40 --
41 procedure pgmelp_getcacdets
42 (p_effective_date in date,
43 p_business_group_id in number,
44 p_pgm_id in number,
45 p_refresh_cache in boolean default FALSE,
46 p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
47 p_inst_count out nocopy number);
48 --
49 -- oipl participating eligibility profile by oipl
50 --
51 procedure copelp_writecache
52 (p_effective_date in date,
53 p_refresh_cache in boolean default FALSE);
54 --
55 procedure copelp_getcacdets
56 (p_effective_date in date,
57 p_business_group_id in number,
58 p_oipl_id in number,
59 p_refresh_cache in boolean default FALSE,
60 p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
61 p_inst_count out nocopy number);
62 --
63 -- plip participating eligibility profile by plip
64 --
65 procedure cppelp_writecache
66 (p_effective_date in date,
67 p_refresh_cache in boolean default FALSE);
68 --
69 procedure cppelp_getcacdets
70 (p_effective_date in date,
71 p_business_group_id in number,
72 p_plip_id in number,
73 p_refresh_cache in boolean default FALSE,
74 p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
75 p_inst_count out nocopy number);
76 --
77 -- ptip participating eligibility profile by ptip
78 --
79 procedure ctpelp_writecache
80 (p_effective_date in date,
81 p_refresh_cache in boolean default FALSE);
82 --
83 procedure ctpelp_getcacdets
84 (p_effective_date in date,
85 p_business_group_id in number,
86 p_ptip_id in number,
87 p_refresh_cache in boolean default FALSE,
88 p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
89 p_inst_count out nocopy number);
90 --
91 -- cep participating eligibility profile by cep
92 --
93 procedure cepelp_getdets
94 (p_business_group_id in number,
95 p_effective_date in date,
96 p_pgm_id in number,
97 p_pl_id in number,
98 p_oipl_id in number,
99 p_plip_id in number,
100 p_ptip_id in number,
101 p_refresh_cache in boolean default FALSE,
102 p_inst_set out nocopy ben_cel_cache.g_cache_cepelp_instor,
103 p_inst_count out nocopy number);
104 --
105 procedure clear_down_cache;
106 --
107 END ben_cel_cache;