[Home] [Help]
PACKAGE: APPS.BEN_EPE_CACHE
Source
1 package ben_epe_cache AUTHID CURRENT_USER as
2 /* $Header: benepech.pkh 120.0 2005/05/28 08:59:10 appldev 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 07-Aug-00 mhoyes Created.
15 115.1 05-Jan-01 kmahendr added parameter per_in_ler_id
16 115.2 27-Jan-01 mhoyes Added new columns to cache for use with EFC
17 115.3 01-Aug-01 ikasire added in_pndg_wkflow_flag column to epe
18 115.4 13-Aug-01 mhoyes - Added bnft_prvdr_pool_id to type.
19 - Added EPE_GetEPEDets.
20 115.5 11-Dec-01 mhoyes - Added get_pilcobjepe_dets.
21 115.6 12-Apr-04 kmahendr - Added three columns to cache.
22 -----------------------------------------------------------------------------
23 */
24 --
25 type g_pilepe_inst_row is record
26 (elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type
27 ,business_group_id ben_elig_per_elctbl_chc.business_group_id%type
28 ,person_id ben_per_in_ler.person_id%type
29 ,ler_id ben_per_in_ler.ler_id%type
30 ,LF_EVT_OCRD_DT ben_per_in_ler.LF_EVT_OCRD_DT%type
31 ,per_in_ler_stat_cd ben_per_in_ler.per_in_ler_stat_cd%type
32 ,per_in_ler_id ben_elig_per_elctbl_chc.per_in_ler_id%type
33 ,pgm_id ben_elig_per_elctbl_chc.pgm_id%type
34 ,pl_typ_id ben_elig_per_elctbl_chc.pl_typ_id%type
35 ,ptip_id ben_elig_per_elctbl_chc.ptip_id%type
36 ,plip_id ben_elig_per_elctbl_chc.plip_id%type
37 ,pl_id ben_elig_per_elctbl_chc.pl_id%type
38 ,oipl_id ben_elig_per_elctbl_chc.oipl_id%type
39 ,oiplip_id ben_elig_per_elctbl_chc.oiplip_id%type
40 ,opt_id ben_opt_f.opt_id%type
41 ,enrt_perd_id ben_pil_elctbl_chc_popl.enrt_perd_id%type
42 ,lee_rsn_id ben_pil_elctbl_chc_popl.lee_rsn_id%type
43 ,enrt_perd_strt_dt ben_pil_elctbl_chc_popl.enrt_perd_strt_dt%type
44 ,prtt_enrt_rslt_id ben_elig_per_elctbl_chc.prtt_enrt_rslt_id%type
45 ,enrt_cvg_strt_dt ben_elig_per_elctbl_chc.enrt_cvg_strt_dt%type
46 ,enrt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.enrt_cvg_strt_dt_cd%type
47 ,enrt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.enrt_cvg_strt_dt_rl%type
48 ,yr_perd_id ben_elig_per_elctbl_chc.yr_perd_id%type
49 ,comp_lvl_cd ben_elig_per_elctbl_chc.comp_lvl_cd%type
50 ,cmbn_plip_id ben_elig_per_elctbl_chc.cmbn_plip_id%type
51 ,cmbn_ptip_id ben_elig_per_elctbl_chc.cmbn_ptip_id%type
52 ,cmbn_ptip_opt_id ben_elig_per_elctbl_chc.cmbn_ptip_opt_id%type
53 ,dflt_flag ben_elig_per_elctbl_chc.dflt_flag%type
54 ,ctfn_rqd_flag ben_elig_per_elctbl_chc.ctfn_rqd_flag%type
55 ,enrt_bnft_id number
56 ,val ben_enrt_bnft.val%type
57 ,acty_ref_perd_cd ben_pil_elctbl_chc_popl.acty_ref_perd_cd%type
58 ,prtn_strt_dt ben_elig_per_f.prtn_strt_dt%type
59 ,prtn_ovridn_flag ben_elig_per_f.prtn_ovridn_flag%type
60 ,prtn_ovridn_thru_dt ben_elig_per_f.prtn_ovridn_thru_dt%type
61 ,rt_age_val ben_elig_per_f.rt_age_val%type
62 ,rt_los_val ben_elig_per_f.rt_los_val%type
63 ,rt_hrs_wkd_val ben_elig_per_f.rt_hrs_wkd_val%type
64 ,rt_cmbn_age_n_los_val ben_elig_per_f.rt_cmbn_age_n_los_val%type
65 ,elctbl_flag ben_elig_per_elctbl_chc.elctbl_flag%type
66 ,object_version_number ben_elig_per_elctbl_chc.object_version_number%type
67 ,alws_dpnt_dsgn_flag ben_elig_per_elctbl_chc.alws_dpnt_dsgn_flag%type
68 ,dpnt_dsgn_cd ben_elig_per_elctbl_chc.dpnt_dsgn_cd%type
69 ,ler_chg_dpnt_cvg_cd ben_elig_per_elctbl_chc.ler_chg_dpnt_cvg_cd%type
70 ,dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%type
71 ,dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%type
72 ,in_pndg_wkflow_flag ben_elig_per_elctbl_chc.in_pndg_wkflow_flag%type
73 ,bnft_prvdr_pool_id ben_elig_per_elctbl_chc.bnft_prvdr_pool_id%type
74 ,elig_flag ben_elig_per_elctbl_chc.elig_flag%type
75 ,inelig_rsn_cd ben_elig_per_elctbl_chc.inelig_rsn_cd%type
76 ,fonm_cvg_strt_dt ben_elig_per_elctbl_chc.fonm_cvg_strt_dt%type
77 );
78 --
79 type g_pilepe_inst_tbl is table of g_pilepe_inst_row
80 index by binary_integer;
81 --
82 g_perepe_instance g_pilepe_inst_tbl;
83 --
84 g_currepe_row g_pilepe_inst_row;
85 g_currcobjepe_row g_pilepe_inst_row;
86 --
87 procedure get_perpilepe_list
88 (p_person_id in number
89 ,p_per_in_ler_id in number
90 ,p_inst_set in out NOCOPY g_pilepe_inst_tbl
91 );
92 --
93 g_enbepe_instance g_pilepe_inst_tbl;
94 --
95 procedure ENBEPE_GetEPEDets
96 (p_enrt_bnft_id in number
97 ,p_per_in_ler_id in number
98 ,p_inst_row in out NOCOPY g_pilepe_inst_row
99 );
100 --
101 g_epe_instance g_pilepe_inst_tbl;
102 --
103 procedure EPE_GetEPEDets
104 (p_elig_per_elctbl_chc_id in number
105 ,p_per_in_ler_id in number
106 ,p_inst_row in out NOCOPY g_pilepe_inst_row
107 );
108 --
109 procedure get_pilcobjepe_dets
110 (p_per_in_ler_id in number
111 ,p_pgm_id in number
112 ,p_pl_id in number
113 ,p_oipl_id in number
114 --
115 ,p_inst_row in out NOCOPY g_pilepe_inst_row
116 );
117 --
118 procedure init_context_pileperow;
119 --
120 procedure init_context_cobj_pileperow;
121 --
122 ------------------------------------------------------------------------
123 -- DELETE CACHED DATA
124 ------------------------------------------------------------------------
125 procedure clear_down_cache;
126 --
127 END ben_epe_cache;