[Home] [Help]
PACKAGE: APPS.BEN_REINSTATE_EPE_CACHE
Source
1 package ben_reinstate_epe_cache AUTHID CURRENT_USER as
2 /* $Header: berepech.pkh 120.0 2005/05/28 11:38:55 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 01-Apr-05 ikasire Created.
15 -----------------------------------------------------------------------------
16 */
17 --
18 type g_pilepe_inst_row is record
19 ( ALWS_DPNT_DSGN_FLAG BEN_ELIG_PER_ELCTBL_CHC.ALWS_DPNT_DSGN_FLAG%type
20 ,APPROVAL_STATUS_CD BEN_ELIG_PER_ELCTBL_CHC.APPROVAL_STATUS_CD%type
21 ,ASSIGNMENT_ID BEN_ELIG_PER_ELCTBL_CHC.ASSIGNMENT_ID%type
22 ,AUTO_ENRT_FLAG BEN_ELIG_PER_ELCTBL_CHC.AUTO_ENRT_FLAG%type
23 ,BNFT_PRVDR_POOL_ID BEN_ELIG_PER_ELCTBL_CHC.BNFT_PRVDR_POOL_ID%type
24 ,BUSINESS_GROUP_ID BEN_ELIG_PER_ELCTBL_CHC.BUSINESS_GROUP_ID%type
25 ,CMBN_PLIP_ID BEN_ELIG_PER_ELCTBL_CHC.CMBN_PLIP_ID%type
26 ,CMBN_PTIP_ID BEN_ELIG_PER_ELCTBL_CHC.CMBN_PTIP_ID%type
27 ,CMBN_PTIP_OPT_ID BEN_ELIG_PER_ELCTBL_CHC.CMBN_PTIP_OPT_ID%type
28 ,COMP_LVL_CD BEN_ELIG_PER_ELCTBL_CHC.COMP_LVL_CD%type
29 ,CRNTLY_ENRD_FLAG BEN_ELIG_PER_ELCTBL_CHC.CRNTLY_ENRD_FLAG%type
30 ,CRYFWD_ELIG_DPNT_CD BEN_ELIG_PER_ELCTBL_CHC.CRYFWD_ELIG_DPNT_CD%type
31 ,CTFN_RQD_FLAG BEN_ELIG_PER_ELCTBL_CHC.CTFN_RQD_FLAG%type
32 ,DFLT_FLAG BEN_ELIG_PER_ELCTBL_CHC.DFLT_FLAG%type
33 ,DPNT_CVG_STRT_DT_CD BEN_ELIG_PER_ELCTBL_CHC.DPNT_CVG_STRT_DT_CD%type
34 ,DPNT_CVG_STRT_DT_RL BEN_ELIG_PER_ELCTBL_CHC.DPNT_CVG_STRT_DT_RL%type
35 ,DPNT_DSGN_CD BEN_ELIG_PER_ELCTBL_CHC.DPNT_DSGN_CD%type
36 ,ELCTBL_FLAG BEN_ELIG_PER_ELCTBL_CHC.ELCTBL_FLAG%type
37 ,ELIG_FLAG BEN_ELIG_PER_ELCTBL_CHC.ELIG_FLAG%type
38 ,ELIG_OVRID_DT BEN_ELIG_PER_ELCTBL_CHC.ELIG_OVRID_DT%type
39 ,ELIG_OVRID_PERSON_ID BEN_ELIG_PER_ELCTBL_CHC.ELIG_OVRID_PERSON_ID%type
40 ,ELIG_PER_ELCTBL_CHC_ID BEN_ELIG_PER_ELCTBL_CHC.ELIG_PER_ELCTBL_CHC_ID%type
41 ,ENRT_CVG_STRT_DT BEN_ELIG_PER_ELCTBL_CHC.ENRT_CVG_STRT_DT%type
42 ,ENRT_CVG_STRT_DT_CD BEN_ELIG_PER_ELCTBL_CHC.ENRT_CVG_STRT_DT_CD%type
43 ,ENRT_CVG_STRT_DT_RL BEN_ELIG_PER_ELCTBL_CHC.ENRT_CVG_STRT_DT_RL%type
44 ,ERLST_DEENRT_DT BEN_ELIG_PER_ELCTBL_CHC.ERLST_DEENRT_DT%type
45 ,FONM_CVG_STRT_DT BEN_ELIG_PER_ELCTBL_CHC.FONM_CVG_STRT_DT%type
46 ,INELIG_RSN_CD BEN_ELIG_PER_ELCTBL_CHC.INELIG_RSN_CD%type
47 ,INTERIM_ELIG_PER_ELCTBL_CHC_ID BEN_ELIG_PER_ELCTBL_CHC.INTERIM_ELIG_PER_ELCTBL_CHC_ID%type
48 ,IN_PNDG_WKFLOW_FLAG BEN_ELIG_PER_ELCTBL_CHC.IN_PNDG_WKFLOW_FLAG%type
49 ,LER_CHG_DPNT_CVG_CD BEN_ELIG_PER_ELCTBL_CHC.LER_CHG_DPNT_CVG_CD%type
50 ,MGR_OVRID_DT BEN_ELIG_PER_ELCTBL_CHC.MGR_OVRID_DT%type
51 ,MGR_OVRID_PERSON_ID BEN_ELIG_PER_ELCTBL_CHC.MGR_OVRID_PERSON_ID%type
52 ,MNDTRY_FLAG BEN_ELIG_PER_ELCTBL_CHC.MNDTRY_FLAG%type
53 ,MUST_ENRL_ANTHR_PL_ID BEN_ELIG_PER_ELCTBL_CHC.MUST_ENRL_ANTHR_PL_ID%type
54 ,OBJECT_VERSION_NUMBER BEN_ELIG_PER_ELCTBL_CHC.OBJECT_VERSION_NUMBER%type
55 ,OIPLIP_ID BEN_ELIG_PER_ELCTBL_CHC.OIPLIP_ID%type
56 ,OIPL_ID BEN_ELIG_PER_ELCTBL_CHC.OIPL_ID%type
57 ,OIPL_ORDR_NUM BEN_ELIG_PER_ELCTBL_CHC.OIPL_ORDR_NUM%type
58 ,PER_IN_LER_ID BEN_ELIG_PER_ELCTBL_CHC.PER_IN_LER_ID%type
59 ,PGM_ID BEN_ELIG_PER_ELCTBL_CHC.PGM_ID%type
60 ,PIL_ELCTBL_CHC_POPL_ID BEN_ELIG_PER_ELCTBL_CHC.PIL_ELCTBL_CHC_POPL_ID%type
61 ,PLIP_ID BEN_ELIG_PER_ELCTBL_CHC.PLIP_ID%type
62 ,PLIP_ORDR_NUM BEN_ELIG_PER_ELCTBL_CHC.PLIP_ORDR_NUM%type
63 ,PL_ID BEN_ELIG_PER_ELCTBL_CHC.PL_ID%type
64 ,PL_ORDR_NUM BEN_ELIG_PER_ELCTBL_CHC.PL_ORDR_NUM%type
65 ,PL_TYP_ID BEN_ELIG_PER_ELCTBL_CHC.PL_TYP_ID%type
66 ,PROCG_END_DT BEN_ELIG_PER_ELCTBL_CHC.PROCG_END_DT%type
67 ,PRTT_ENRT_RSLT_ID BEN_ELIG_PER_ELCTBL_CHC.PRTT_ENRT_RSLT_ID%type
68 ,PTIP_ID BEN_ELIG_PER_ELCTBL_CHC.PTIP_ID%type
69 ,PTIP_ORDR_NUM BEN_ELIG_PER_ELCTBL_CHC.PTIP_ORDR_NUM%type
70 ,ROLL_CRS_FLAG BEN_ELIG_PER_ELCTBL_CHC.ROLL_CRS_FLAG%type
71 ,SPCL_RT_OIPL_ID BEN_ELIG_PER_ELCTBL_CHC.SPCL_RT_OIPL_ID%type
72 ,SPCL_RT_PL_ID BEN_ELIG_PER_ELCTBL_CHC.SPCL_RT_PL_ID%type
73 ,WS_MGR_ID BEN_ELIG_PER_ELCTBL_CHC.WS_MGR_ID%type
74 ,YR_PERD_ID BEN_ELIG_PER_ELCTBL_CHC.YR_PERD_ID%type
75 );
76 --
77 type g_pilepe_inst_tbl is table of g_pilepe_inst_row
78 index by binary_integer;
79 --
80 g_currepe_row g_pilepe_inst_row;
81 g_currcobjepe_row g_pilepe_inst_row;
82 --
83 procedure get_perpilepe_list
84 (p_per_in_ler_id in number
85 ,p_inst_set in out NOCOPY g_pilepe_inst_tbl
86 );
87 --
88 g_epe_instance g_pilepe_inst_tbl;
89 --
90 procedure EPE_GetEPEDets
91 (p_elig_per_elctbl_chc_id in number
92 ,p_per_in_ler_id in number
93 ,p_inst_row in out NOCOPY g_pilepe_inst_row
94 );
95 --
96 procedure get_pilcobjepe_dets
97 (p_per_in_ler_id in number
98 ,p_pgm_id in number
99 ,p_pl_id in number
100 ,p_oipl_id in number
101 --
102 ,p_inst_row in out NOCOPY g_pilepe_inst_row
103 );
104 --
105 procedure init_context_pileperow;
106 --
107 procedure init_context_cobj_pileperow;
108 --
109 ------------------------------------------------------------------------
110 -- DELETE CACHED DATA
111 ------------------------------------------------------------------------
112 procedure clear_down_cache;
113 --
114 END ben_reinstate_epe_cache;