eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.BEN_PLN_RKD

Source


1 package body ben_pln_RKD as
2 /* $Header: beplnrhi.pkb 120.8.12010000.2 2008/08/18 09:47:19 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2009/03/30 04:17:26 (YYYY/MM/DD HH24:MI:SS)
5 procedure AFTER_DELETE
6 (P_PL_ID in NUMBER
7 ,P_DATETRACK_MODE in VARCHAR2
8 ,P_VALIDATION_START_DATE in DATE
9 ,P_VALIDATION_END_DATE in DATE
10 ,P_EFFECTIVE_START_DATE in DATE
11 ,P_EFFECTIVE_END_DATE in DATE
12 ,P_EFFECTIVE_START_DATE_O in DATE
13 ,P_EFFECTIVE_END_DATE_O in DATE
14 ,P_NAME_O in VARCHAR2
15 ,P_ALWS_QDRO_FLAG_O in VARCHAR2
16 ,P_ALWS_QMCSO_FLAG_O in VARCHAR2
17 ,P_ALWS_REIMBMTS_FLAG_O in VARCHAR2
18 ,P_BNF_ADDL_INSTN_TXT_ALWD_FL_O in VARCHAR2
19 ,P_BNF_ADRS_RQD_FLAG_O in VARCHAR2
20 ,P_BNF_CNTNGT_BNFS_ALWD_FLAG_O in VARCHAR2
21 ,P_BNF_CTFN_RQD_FLAG_O in VARCHAR2
22 ,P_BNF_DOB_RQD_FLAG_O in VARCHAR2
23 ,P_BNF_DSGE_MNR_TTEE_RQD_FLAG_O in VARCHAR2
24 ,P_BNF_INCRMT_AMT_O in NUMBER
25 ,P_BNF_DFLT_BNF_CD_O in VARCHAR2
26 ,P_BNF_LEGV_ID_RQD_FLAG_O in VARCHAR2
27 ,P_BNF_MAY_DSGT_ORG_FLAG_O in VARCHAR2
28 ,P_BNF_MN_DSGNTBL_AMT_O in NUMBER
29 ,P_BNF_MN_DSGNTBL_PCT_VAL_O in NUMBER
30 ,P_RQD_PERD_ENRT_NENRT_VAL_O in NUMBER
31 ,P_ORDR_NUM_O in NUMBER
32 ,P_BNF_PCT_INCRMT_VAL_O in NUMBER
33 ,P_BNF_PCT_AMT_ALWD_CD_O in VARCHAR2
34 ,P_BNF_QDRO_RL_APLS_FLAG_O in VARCHAR2
35 ,P_DFLT_TO_ASN_PNDG_CTFN_CD_O in VARCHAR2
36 ,P_DFLT_TO_ASN_PNDG_CTFN_RL_O in NUMBER
37 ,P_DRVBL_FCTR_APLS_RTS_FLAG_O in VARCHAR2
38 ,P_DRVBL_FCTR_PRTN_ELIG_FLAG_O in VARCHAR2
39 ,P_DPNT_DSGN_CD_O in VARCHAR2
40 ,P_ELIG_APLS_FLAG_O in VARCHAR2
41 ,P_INVK_DCLN_PRTN_PL_FLAG_O in VARCHAR2
42 ,P_INVK_FLX_CR_PL_FLAG_O in VARCHAR2
43 ,P_IMPTD_INCM_CALC_CD_O in VARCHAR2
44 ,P_DRVBL_DPNT_ELIG_FLAG_O in VARCHAR2
45 ,P_TRK_INELIG_PER_FLAG_O in VARCHAR2
46 ,P_PL_CD_O in VARCHAR2
47 ,P_AUTO_ENRT_MTHD_RL_O in NUMBER
48 ,P_IVR_IDENT_O in VARCHAR2
49 ,P_URL_REF_NAME_O in VARCHAR2
50 ,P_CMPR_CLMS_TO_CVG_OR_BAL_CD_O in VARCHAR2
51 ,P_COBRA_PYMT_DUE_DY_NUM_O in NUMBER
52 ,P_DPNT_CVD_BY_OTHR_APLS_FLAG_O in VARCHAR2
53 ,P_ENRT_MTHD_CD_O in VARCHAR2
54 ,P_ENRT_CD_O in VARCHAR2
55 ,P_ENRT_CVG_STRT_DT_CD_O in VARCHAR2
56 ,P_ENRT_CVG_END_DT_CD_O in VARCHAR2
57 ,P_FRFS_APLY_FLAG_O in VARCHAR2
58 ,P_HC_PL_SUBJ_HCFA_APRVL_FLAG_O in VARCHAR2
59 ,P_HGHLY_CMPD_RL_APLS_FLAG_O in VARCHAR2
60 ,P_INCPTN_DT_O in DATE
61 ,P_MN_CVG_RL_O in NUMBER
62 ,P_MN_CVG_RQD_AMT_O in NUMBER
63 ,P_MN_OPTS_RQD_NUM_O in NUMBER
64 ,P_MX_CVG_ALWD_AMT_O in NUMBER
65 ,P_MX_CVG_RL_O in NUMBER
66 ,P_MX_OPTS_ALWD_NUM_O in NUMBER
67 ,P_MX_CVG_WCFN_MLT_NUM_O in NUMBER
68 ,P_MX_CVG_WCFN_AMT_O in NUMBER
69 ,P_MX_CVG_INCR_ALWD_AMT_O in NUMBER
70 ,P_MX_CVG_INCR_WCF_ALWD_AMT_O in NUMBER
71 ,P_MX_CVG_MLT_INCR_NUM_O in NUMBER
72 ,P_MX_CVG_MLT_INCR_WCF_NUM_O in NUMBER
73 ,P_MX_WTG_DT_TO_USE_CD_O in VARCHAR2
74 ,P_MX_WTG_DT_TO_USE_RL_O in NUMBER
75 ,P_MX_WTG_PERD_PRTE_UOM_O in VARCHAR2
76 ,P_MX_WTG_PERD_PRTE_VAL_O in NUMBER
77 ,P_MX_WTG_PERD_RL_O in NUMBER
78 ,P_NIP_DFLT_ENRT_CD_O in VARCHAR2
79 ,P_NIP_DFLT_ENRT_DET_RL_O in NUMBER
80 ,P_DPNT_ADRS_RQD_FLAG_O in VARCHAR2
81 ,P_DPNT_CVG_END_DT_CD_O in VARCHAR2
82 ,P_DPNT_CVG_END_DT_RL_O in NUMBER
83 ,P_DPNT_CVG_STRT_DT_CD_O in VARCHAR2
84 ,P_DPNT_CVG_STRT_DT_RL_O in NUMBER
85 ,P_DPNT_DOB_RQD_FLAG_O in VARCHAR2
86 ,P_DPNT_LEG_ID_RQD_FLAG_O in VARCHAR2
87 ,P_DPNT_NO_CTFN_RQD_FLAG_O in VARCHAR2
88 ,P_NO_MN_CVG_AMT_APLS_FLAG_O in VARCHAR2
89 ,P_NO_MN_CVG_INCR_APLS_FLAG_O in VARCHAR2
90 ,P_NO_MN_OPTS_NUM_APLS_FLAG_O in VARCHAR2
91 ,P_NO_MX_CVG_AMT_APLS_FLAG_O in VARCHAR2
92 ,P_NO_MX_CVG_INCR_APLS_FLAG_O in VARCHAR2
93 ,P_NO_MX_OPTS_NUM_APLS_FLAG_O in VARCHAR2
94 ,P_NIP_PL_UOM_O in VARCHAR2
95 ,P_RQD_PERD_ENRT_NENRT_UOM_O in VARCHAR2
96 ,P_NIP_ACTY_REF_PERD_CD_O in VARCHAR2
97 ,P_NIP_ENRT_INFO_RT_FREQ_CD_O in VARCHAR2
98 ,P_PER_CVRD_CD_O in VARCHAR2
99 ,P_ENRT_CVG_END_DT_RL_O in NUMBER
100 ,P_POSTELCN_EDIT_RL_O in NUMBER
101 ,P_ENRT_CVG_STRT_DT_RL_O in NUMBER
102 ,P_PRORT_PRTL_YR_CVG_RSTRN_CD_O in VARCHAR2
103 ,P_PRORT_PRTL_YR_CVG_RSTRN_RL_O in NUMBER
104 ,P_PRTN_ELIG_OVRID_ALWD_FLAG_O in VARCHAR2
105 ,P_SVGS_PL_FLAG_O in VARCHAR2
106 ,P_SUBJ_TO_IMPTD_INCM_TYP_CD_O in VARCHAR2
107 ,P_USE_ALL_ASNTS_ELIG_FLAG_O in VARCHAR2
108 ,P_USE_ALL_ASNTS_FOR_RT_FLAG_O in VARCHAR2
109 ,P_VSTG_APLS_FLAG_O in VARCHAR2
110 ,P_WVBL_FLAG_O in VARCHAR2
111 ,P_HC_SVC_TYP_CD_O in VARCHAR2
112 ,P_PL_STAT_CD_O in VARCHAR2
113 ,P_PRMRY_FNDG_MTHD_CD_O in VARCHAR2
114 ,P_RT_END_DT_CD_O in VARCHAR2
115 ,P_RT_END_DT_RL_O in NUMBER
116 ,P_RT_STRT_DT_RL_O in NUMBER
117 ,P_RT_STRT_DT_CD_O in VARCHAR2
118 ,P_BNF_DSGN_CD_O in VARCHAR2
119 ,P_PL_TYP_ID_O in NUMBER
120 ,P_BUSINESS_GROUP_ID_O in NUMBER
121 ,P_ENRT_PL_OPT_FLAG_O in VARCHAR2
122 ,P_BNFT_PRVDR_POOL_ID_O in NUMBER
123 ,P_MAY_ENRL_PL_N_OIPL_FLAG_O in VARCHAR2
124 ,P_ENRT_RL_O in NUMBER
125 ,P_RQD_PERD_ENRT_NENRT_RL_O in NUMBER
126 ,P_ALWS_UNRSTRCTD_ENRT_FLAG_O in VARCHAR2
127 ,P_BNFT_OR_OPTION_RSTRCTN_CD_O in VARCHAR2
128 ,P_CVG_INCR_R_DECR_ONLY_CD_O in VARCHAR2
129 ,P_UNSSPND_ENRT_CD_O in VARCHAR2
130 ,P_PLN_ATTRIBUTE_CATEGORY_O in VARCHAR2
131 ,P_PLN_ATTRIBUTE1_O in VARCHAR2
132 ,P_PLN_ATTRIBUTE2_O in VARCHAR2
133 ,P_PLN_ATTRIBUTE3_O in VARCHAR2
134 ,P_PLN_ATTRIBUTE4_O in VARCHAR2
135 ,P_PLN_ATTRIBUTE5_O in VARCHAR2
136 ,P_PLN_ATTRIBUTE6_O in VARCHAR2
137 ,P_PLN_ATTRIBUTE7_O in VARCHAR2
138 ,P_PLN_ATTRIBUTE8_O in VARCHAR2
139 ,P_PLN_ATTRIBUTE9_O in VARCHAR2
140 ,P_PLN_ATTRIBUTE10_O in VARCHAR2
141 ,P_PLN_ATTRIBUTE11_O in VARCHAR2
142 ,P_PLN_ATTRIBUTE12_O in VARCHAR2
143 ,P_PLN_ATTRIBUTE13_O in VARCHAR2
144 ,P_PLN_ATTRIBUTE14_O in VARCHAR2
145 ,P_PLN_ATTRIBUTE15_O in VARCHAR2
146 ,P_PLN_ATTRIBUTE16_O in VARCHAR2
147 ,P_PLN_ATTRIBUTE17_O in VARCHAR2
148 ,P_PLN_ATTRIBUTE18_O in VARCHAR2
149 ,P_PLN_ATTRIBUTE19_O in VARCHAR2
150 ,P_PLN_ATTRIBUTE20_O in VARCHAR2
151 ,P_PLN_ATTRIBUTE21_O in VARCHAR2
152 ,P_PLN_ATTRIBUTE22_O in VARCHAR2
153 ,P_PLN_ATTRIBUTE23_O in VARCHAR2
154 ,P_PLN_ATTRIBUTE24_O in VARCHAR2
155 ,P_PLN_ATTRIBUTE25_O in VARCHAR2
156 ,P_PLN_ATTRIBUTE26_O in VARCHAR2
157 ,P_PLN_ATTRIBUTE27_O in VARCHAR2
158 ,P_PLN_ATTRIBUTE28_O in VARCHAR2
159 ,P_PLN_ATTRIBUTE29_O in VARCHAR2
160 ,P_PLN_ATTRIBUTE30_O in VARCHAR2
161 ,P_SUSP_IF_CTFN_NOT_PRVD_FLAG_O in VARCHAR2
162 ,P_CTFN_DETERMINE_CD_O in VARCHAR2
163 ,P_SUSP_IF_DPNT_SSN_NT_PRV_CD_O in VARCHAR2
164 ,P_SUSP_IF_DPNT_DOB_NT_PRV_CD_O in VARCHAR2
165 ,P_SUSP_IF_DPNT_ADR_NT_PRV_CD_O in VARCHAR2
166 ,P_SUSP_IF_CTFN_NOT_DPNT_FLAG_O in VARCHAR2
167 ,P_SUSP_IF_BNF_SSN_NT_PRV_CD_O in VARCHAR2
168 ,P_SUSP_IF_BNF_DOB_NT_PRV_CD_O in VARCHAR2
169 ,P_SUSP_IF_BNF_ADR_NT_PRV_CD_O in VARCHAR2
170 ,P_SUSP_IF_CTFN_NOT_BNF_FLAG_O in VARCHAR2
171 ,P_DPNT_CTFN_DETERMINE_CD_O in VARCHAR2
172 ,P_BNF_CTFN_DETERMINE_CD_O in VARCHAR2
173 ,P_OBJECT_VERSION_NUMBER_O in NUMBER
174 ,P_ACTL_PREM_ID_O in NUMBER
175 ,P_VRFY_FMLY_MMBR_CD_O in VARCHAR2
176 ,P_VRFY_FMLY_MMBR_RL_O in NUMBER
177 ,P_ALWS_TMPRY_ID_CRD_FLAG_O in VARCHAR2
178 ,P_NIP_DFLT_FLAG_O in VARCHAR2
179 ,P_FRFS_DISTR_MTHD_CD_O in VARCHAR2
180 ,P_FRFS_DISTR_MTHD_RL_O in NUMBER
181 ,P_FRFS_CNTR_DET_CD_O in VARCHAR2
182 ,P_FRFS_DISTR_DET_CD_O in VARCHAR2
183 ,P_COST_ALLOC_KEYFLEX_1_ID_O in NUMBER
184 ,P_COST_ALLOC_KEYFLEX_2_ID_O in NUMBER
185 ,P_POST_TO_GL_FLAG_O in VARCHAR2
186 ,P_FRFS_VAL_DET_CD_O in VARCHAR2
187 ,P_FRFS_MX_CRYFWD_VAL_O in NUMBER
188 ,P_FRFS_PORTION_DET_CD_O in VARCHAR2
189 ,P_BNDRY_PERD_CD_O in VARCHAR2
190 ,P_SHORT_NAME_O in VARCHAR2
191 ,P_SHORT_CODE_O in VARCHAR2
192 ,P_LEGISLATION_CODE_O in VARCHAR2
193 ,P_LEGISLATION_SUBGROUP_O in VARCHAR2
194 ,P_GROUP_PL_ID_O in NUMBER
195 ,P_MAPPING_TABLE_NAME_O in VARCHAR2
196 ,P_MAPPING_TABLE_PK_ID_O in NUMBER
197 ,P_FUNCTION_CODE_O in VARCHAR2
198 ,P_PL_YR_NOT_APPLCBL_FLAG_O in VARCHAR2
199 ,P_USE_CSD_RSD_PRCCNG_CD_O in VARCHAR2
200 )is
201 begin
202 hr_utility.set_location('Entering: ben_pln_RKD.AFTER_DELETE', 10);
203 hr_utility.set_location(' Leaving: ben_pln_RKD.AFTER_DELETE', 20);
204 end AFTER_DELETE;
205 end ben_pln_RKD;