1: package body ben_rt_asnt_cache as
2: /* $Header: bertasch.pkb 115.0 2004/02/02 11:54:44 kmahendr noship $ */
3: --
4: /*
5: * +==============================================================================+
18: * --------------------------------------------
19: */
20: -- Globals.
21: --
22: g_package varchar2(50) := 'ben_rt_asnt_cache.';
23: --
24: g_asntlookup ben_cache.g_cache_lookup_table;
25: g_nxelenum number;
26: g_asntinst ben_rt_asnt_cache.g_rt_asnt_inst_tbl;
22: g_package varchar2(50) := 'ben_rt_asnt_cache.';
23: --
24: g_asntlookup ben_cache.g_cache_lookup_table;
25: g_nxelenum number;
26: g_asntinst ben_rt_asnt_cache.g_rt_asnt_inst_tbl;
27: g_asntcached pls_integer := 0;
28: --
29: g_hash_key pls_integer := 1299827;
30: g_hash_jump pls_integer := 100;
162: (p_vrbl_rt_prfl_id in number
163: ,p_effective_date in date
164: ,p_lf_evt_ocrd_dt in date
165: ,p_business_group_id in number
166: ,p_inst_set out nocopy ben_rt_asnt_cache.g_rt_asnt_inst_tbl
167: ,p_inst_count out nocopy number
168: )
169: is
170: --
167: ,p_inst_count out nocopy number
168: )
169: is
170: --
171: l_inst_set ben_rt_asnt_cache.g_rt_asnt_inst_tbl;
172: --
173: l_hv pls_integer;
174: l_hash_found boolean;
175: l_insttorrw_num pls_integer;
311: procedure clear_down_cache
312: is
313: --
314: l_asntlookup ben_cache.g_cache_lookup_table;
315: l_asntinst ben_rt_asnt_cache.g_rt_asnt_inst_tbl;
316: --
317: begin
318: --
319: -- On demand cache structures