[Home] [Help]
PACKAGE: APPS.BEN_ELIG_RL_CACHE
Source
1 PACKAGE ben_elig_rl_cache AUTHID CURRENT_USER AS
2 /* $Header: benelrch.pkh 115.2 2002/12/30 23:01:49 ikasire ship $*/
3 --
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 History
12 Version Date Who What?
13 --------- --------- ---------- --------------------------------------------
14 115.0 11-Jun-99 bbulusu Created.
15 115.1 02-Aug-99 gperry Added support for PLIP and PTIP.
16 115.2 30-Dec-02 ikasire nocopy changes
17 -----------------------------------------------------------------------------
18 */
19 --
20 -- Global record type.
21 --
22 type g_elig_rl_rec is record
23 (id number
24 ,pgm_id ben_pgm_f.pgm_id%type
25 ,pl_id ben_pl_f.pl_id%type
26 ,oipl_id ben_oipl_f.oipl_id%type
27 ,plip_id ben_plip_f.plip_id%type
28 ,ptip_id ben_ptip_f.ptip_id%type
29 ,formula_id ben_prtn_eligy_rl_f.formula_id%type
30 ,mndtry_flag ben_prtn_eligy_rl_f.mndtry_flag%type
31 ,ordr_to_aply_num ben_prtn_eligy_rl_f.ordr_to_aply_num%type
32 );
33 --
34 type g_elig_rl_inst_tbl is table of g_elig_rl_rec index by binary_integer;
35 --
36 -- Global cache structures for eache comp object's lookup and instance.
37 --
38 g_pgm_lookup ben_cache.g_cache_lookup_table;
39 g_pl_lookup ben_cache.g_cache_lookup_table;
40 g_oipl_lookup ben_cache.g_cache_lookup_table;
41 g_plip_lookup ben_cache.g_cache_lookup_table;
42 g_ptip_lookup ben_cache.g_cache_lookup_table;
43 g_pgm_instance ben_elig_rl_cache.g_elig_rl_inst_tbl;
44 g_pl_instance ben_elig_rl_cache.g_elig_rl_inst_tbl;
45 g_oipl_instance ben_elig_rl_cache.g_elig_rl_inst_tbl;
46 g_plip_instance ben_elig_rl_cache.g_elig_rl_inst_tbl;
47 g_ptip_instance ben_elig_rl_cache.g_elig_rl_inst_tbl;
48 --
49 procedure get_elig_rl_cache
50 (p_pgm_id in number
51 ,p_pl_id in number
52 ,p_oipl_id in number
53 ,p_plip_id in number
54 ,p_ptip_id in number
55 ,p_effective_date in date
56 ,p_lf_evt_ocrd_dt in date
57 ,p_business_group_id in number
58 ,p_inst_set out nocopy ben_elig_rl_cache.g_elig_rl_inst_tbl
59 ,p_inst_count out nocopy number
60 );
61 --
62 procedure clear_down_cache;
63 --
64 end ben_elig_rl_cache;