[Home] [Help]
PACKAGE: APPS.BEN_PEP_CACHE
Source
1 package ben_pep_cache AUTHID CURRENT_USER as
2 /* $Header: benpepch.pkh 120.2 2005/10/21 01:58:56 abparekh 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 28-Jun-99 mhoyes Created.
15 115.1 05-Jul-00 mhoyes Upgraded.
16 115.2 11-Dec-01 mhoyes - Added get_pilplnpep_dets.
17 115.3 17-Apr-02 pbodla - Added lines for GSCC compliance.
18 115.4 12-Jul-02 mhoyes - Added get_curroiplippep_dets and
19 get_currplnpep_dets.
20 115.5 20-Aug-02 mhoyes - Added caching into get_currpepepo_dets based
21 on comp object list row values.
22 115.6 17-Mar-03 vsethi - Bug 2650247 added inelg_rsn_cd to g_pep_rec
23 record type
24 115.7 18-Feb-04 mhoyes - Bug 3412822. Revamp of eligibility cache.
25 115.8 06-Apr-04 mhoyes - Bug 3412822. Revamp of eligibility cache.
26 115.9 13-Oct-04 mhoyes - Bug 3950924. Added get_pilepo_dets11521.
27 115.10 04-May-05 mhoyes - Bug 4350303. Backed out nocopy due to
28 performance regression.
29 115.11 06-May-05 mhoyes - Bug 4350303. Removed obsolete procedures.
30 115.12 12-jun-05 mhoyes - Bug 4425771. Defined package locals as
31 globals.
32 115.13 20-Oct-05 abparekh - Bug 4646361 : Added NOCOPY hint to out parameters
33 -----------------------------------------------------------------------------
34 */
35 --
36 -- elig per
37 --
38 type g_pep_inst_tbl is table of ben_derive_part_and_rate_facts.g_cache_structure
39 index by binary_integer;
40 --
41 --
42 -- elig per
43 --
44 g_pilpep_lookup ben_cache.g_cache_lookup_table;
45 g_pilpep_instance g_pep_inst_tbl;
46 g_pilpep_cached boolean := FALSE;
47 --
48 -- Globals.
49 --
50 g_package varchar2(50) := 'ben_pep_cache.';
51 g_hash_key number := ben_hash_utility.get_hash_key;
52 g_hash_jump number := ben_hash_utility.get_hash_jump;
53 --
54 g_pilpep_effdt date;
55 g_pilpep_personid number;
56 g_optpilepo_effdt date;
57 g_optpilepo_personid number;
58 --
59 procedure get_pilpep_dets
60 (p_person_id in number
61 ,p_business_group_id in number
62 ,p_effective_date in date
63 ,p_pgm_id in number default null
64 ,p_ptip_id in number default null
65 ,p_pl_id in number default null
66 ,p_plip_id in number default null
67 ,p_date_sync in boolean default false
68 -- ,p_inst_row in out NOCOPY ben_derive_part_and_rate_facts.g_cache_structure
69 ,p_inst_row out nocopy ben_derive_part_and_rate_facts.g_cache_structure
70 );
71 --
72 type g_epo_inst_tbl is table of ben_derive_part_and_rate_facts.g_cache_structure
73 index by binary_integer;
74 --
75 g_optpilepo_lookup ben_cache.g_cache_lookup_table;
76 g_optpilepo_instance g_epo_inst_tbl;
77 g_optpilepo_cached boolean := FALSE;
78 --
79 procedure get_pilepo_dets
80 (p_person_id in number
81 ,p_business_group_id in number
82 ,p_effective_date in date
83 ,p_pgm_id in number default null
84 ,p_pl_id in number default null
85 ,p_opt_id in number default null
86 ,p_plip_id in number default null
87 ,p_date_sync in boolean default false
88 -- ,p_inst_row in out NOCOPY ben_derive_part_and_rate_facts.g_cache_structure
89 ,p_inst_row out nocopy ben_derive_part_and_rate_facts.g_cache_structure
90 );
91 --
92 type g_pep_rec is record
93 (elig_per_id number
94 ,elig_flag varchar2(30)
95 ,must_enrl_anthr_pl_id number
96 ,prtn_strt_dt date
97 ,prtn_end_dt date
98 ,inelg_rsn_cd varchar2(30) -- 2650247
99 );
100 --
101 procedure get_currpepepo_dets
102 (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
103 ,p_per_in_ler_id in number
104 ,p_effective_date in date
105 ,p_pgm_id in number
106 ,p_pl_id in number
107 ,p_oipl_id in number
108 ,p_opt_id in number
109 --
110 ,p_inst_row in out NOCOPY g_pep_rec
111 );
112 --
113 procedure get_curroiplippep_dets
114 (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
115 ,p_person_id in number
116 ,p_effective_date in date
117 --
118 ,p_inst_row in out NOCOPY g_pep_rec
119 );
120 --
121 procedure get_currplnpep_dets
122 (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
123 ,p_person_id in number
124 ,p_effective_date in date
125 --
126 ,p_inst_row in out NOCOPY g_pep_rec
127 );
128 --
129 ------------------------------------------------------------------------
130 -- DELETE CACHED DATA
131 ------------------------------------------------------------------------
132 procedure clear_down_cache;
133 procedure clear_down_pepcache;
134 procedure clear_down_epocache;
135 --
136 END ben_pep_cache;