1 package ben_pep_cache1 AUTHID CURRENT_USER as
2 /* $Header: benppch1.pkh 115.5 2004/04/06 11:31:00 mhoyes noship $*/
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 25-Aug-03 mhoyes Created.
15 115.1 28-Aug-03 mhoyes - Added get_currplnpep_dets.
16 115.2 01-Feb-04 mhoyes - Bug 3412822: Added get_currpepcobj_prtnstrtdt.
17 115.3 18-Feb-04 mhoyes - Bug 3412822. Revamp of eligibility cache.
18 115.4 24-Feb-04 mhoyes - Bug 3412822. More eligibility cache tuning.
19 115.5 08-Apr-04 mhoyes - Bug 3412822. More eligibility cache tuning.
20 -----------------------------------------------------------------------------
21 */
22 --
23 type g_ecrpep_rec is record
24 (prtn_strt_dt date
25 ,prtn_ovridn_flag varchar2(30)
26 ,prtn_ovridn_thru_dt date
27 ,rt_age_val number
28 ,rt_los_val number
29 ,rt_hrs_wkd_val number
30 ,rt_cmbn_age_n_los_val number
31 ,per_in_ler_id number
32 ,elig_per_id number
33 ,elig_per_opt_id number
34 );
35 --
36 procedure get_curroiplippep_dets
37 (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
38 ,p_person_id in number
39 ,p_effective_date in date
40 --
41 ,p_inst_row in out NOCOPY ben_pep_cache.g_pep_rec
42 );
43 --
44 procedure get_currplnpep_dets
45 (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
46 ,p_person_id in number
47 ,p_effective_date in date
48 --
49 ,p_inst_row in out NOCOPY ben_pep_cache.g_pep_rec
50 );
51 --
52 procedure get_currpepcobj_cache
53 (p_person_id in number
54 ,p_pgm_id in number
55 ,p_ptip_id in number default null
56 ,p_pl_id in number
57 ,p_plip_id in number default null
58 ,p_opt_id in number
59 ,p_effective_date in date
60 --
61 ,p_ecrpep_rec in out NOCOPY g_ecrpep_rec
62 );
63 --
64 END ben_pep_cache1;