[Home] [Help]
Skip to content
PACKAGE BODY: APPS.BEN_PLAN_API
Source
4 -- Package Variables
1 Package Body ben_Plan_api as
2 /* $Header: beplnapi.pkb 120.0.12020000.3 2013/01/30 10:03:05 amnaraya ship $ */
3 --
5 --
6 g_package varchar2(33) := ' ben_Plan_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_Plan >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_Plan
13 (
14 p_validate in boolean default false
15 ,p_pl_id out nocopy number
16 ,p_effective_start_date out nocopy date
17 ,p_effective_end_date out nocopy date
18 ,p_name in varchar2 default null
19 ,p_alws_qdro_flag in varchar2 default 'N'
20 ,p_alws_qmcso_flag in varchar2 default 'N'
21 ,p_alws_reimbmts_flag in varchar2 default 'N'
22 ,p_bnf_addl_instn_txt_alwd_flag in varchar2 default 'N'
23 ,p_bnf_adrs_rqd_flag in varchar2 default 'N'
24 ,p_bnf_cntngt_bnfs_alwd_flag in varchar2 default 'N'
25 ,p_bnf_ctfn_rqd_flag in varchar2 default 'N'
26 ,p_bnf_dob_rqd_flag in varchar2 default 'N'
27 ,p_bnf_dsge_mnr_ttee_rqd_flag in varchar2 default 'N'
28 ,p_bnf_incrmt_amt in number default null
29 ,p_bnf_dflt_bnf_cd in varchar2 default null
30 ,p_bnf_legv_id_rqd_flag in varchar2 default 'N'
31 ,p_bnf_may_dsgt_org_flag in varchar2 default 'N'
32 ,p_bnf_mn_dsgntbl_amt in number default null
33 ,p_bnf_mn_dsgntbl_pct_val in number default null
34 ,p_rqd_perd_enrt_nenrt_val in number default null
35 ,p_ordr_num in number default null
36 ,p_bnf_pct_incrmt_val in number default null
37 ,p_bnf_pct_amt_alwd_cd in varchar2 default null
38 ,p_bnf_qdro_rl_apls_flag in varchar2 default 'N'
39 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default null
40 ,p_dflt_to_asn_pndg_ctfn_rl in number default null
41 ,p_drvbl_fctr_apls_rts_flag in varchar2 default 'N'
42 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default 'N'
43 ,p_dpnt_dsgn_cd in varchar2 default null
44 ,p_elig_apls_flag in varchar2 default 'N'
48 ,p_drvbl_dpnt_elig_flag in varchar2 default 'N'
45 ,p_invk_dcln_prtn_pl_flag in varchar2 default 'N'
46 ,p_invk_flx_cr_pl_flag in varchar2 default 'N'
47 ,p_imptd_incm_calc_cd in varchar2 default null
49 ,p_trk_inelig_per_flag in varchar2 default 'N'
50 ,p_pl_cd in varchar2 default null
51 ,p_auto_enrt_mthd_rl in number default null
52 ,p_ivr_ident in varchar2 default null
53 ,p_url_ref_name in varchar2 default null
54 ,p_cmpr_clms_to_cvg_or_bal_cd in varchar2 default null
55 ,p_cobra_pymt_due_dy_num in number default null
56 ,p_dpnt_cvd_by_othr_apls_flag in varchar2 default 'N'
57 ,p_enrt_mthd_cd in varchar2 default null
58 ,p_enrt_cd in varchar2 default null
59 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
60 ,p_enrt_cvg_end_dt_cd in varchar2 default null
61 ,p_frfs_aply_flag in varchar2 default 'N'
62 ,p_hc_pl_subj_hcfa_aprvl_flag in varchar2 default 'N'
63 ,p_hghly_cmpd_rl_apls_flag in varchar2 default 'N'
64 ,p_incptn_dt in date default null
65 ,p_mn_cvg_rl in number default null
66 ,p_mn_cvg_rqd_amt in number default null
67 ,p_mn_opts_rqd_num in number default null
68 ,p_mx_cvg_alwd_amt in number default null
69 ,p_mx_cvg_rl in number default null
70 ,p_mx_opts_alwd_num in number default null
71 ,p_mx_cvg_wcfn_mlt_num in number default null
72 ,p_mx_cvg_wcfn_amt in number default null
73 ,p_mx_cvg_incr_alwd_amt in number default null
74 ,p_mx_cvg_incr_wcf_alwd_amt in number default null
75 ,p_mx_cvg_mlt_incr_num in number default null
76 ,p_mx_cvg_mlt_incr_wcf_num in number default null
77 ,p_mx_wtg_dt_to_use_cd in varchar2 default null
78 ,p_mx_wtg_dt_to_use_rl in number default null
79 ,p_mx_wtg_perd_prte_uom in varchar2 default null
80 ,p_mx_wtg_perd_prte_val in number default null
81 ,p_mx_wtg_perd_rl in number default null
82 ,p_nip_dflt_enrt_cd in varchar2 default null
83 ,p_nip_dflt_enrt_det_rl in number default null
84 ,p_dpnt_adrs_rqd_flag in varchar2 default 'N'
85 ,p_dpnt_cvg_end_dt_cd in varchar2 default null
86 ,p_dpnt_cvg_end_dt_rl in number default null
87 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
88 ,p_dpnt_cvg_strt_dt_rl in number default null
89 ,p_dpnt_dob_rqd_flag in varchar2 default 'N'
90 ,p_dpnt_leg_id_rqd_flag in varchar2 default 'N'
91 ,p_dpnt_no_ctfn_rqd_flag in varchar2 default 'N'
92 ,p_no_mn_cvg_amt_apls_flag in varchar2 default 'N'
93 ,p_no_mn_cvg_incr_apls_flag in varchar2 default 'N'
94 ,p_no_mn_opts_num_apls_flag in varchar2 default 'N'
95 ,p_no_mx_cvg_amt_apls_flag in varchar2 default 'N'
96 ,p_no_mx_cvg_incr_apls_flag in varchar2 default 'N'
97 ,p_no_mx_opts_num_apls_flag in varchar2 default 'N'
98 ,p_nip_pl_uom in varchar2 default null
99 ,p_rqd_perd_enrt_nenrt_uom in varchar2 default null
100 ,p_nip_acty_ref_perd_cd in varchar2 default null
101 ,p_nip_enrt_info_rt_freq_cd in varchar2 default null
102 ,p_per_cvrd_cd in varchar2 default null
103 ,p_enrt_cvg_end_dt_rl in number default null
104 ,p_postelcn_edit_rl in number default null
105 ,p_enrt_cvg_strt_dt_rl in number default null
106 ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default null
107 ,p_prort_prtl_yr_cvg_rstrn_rl in number default null
108 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default 'N'
109 ,p_svgs_pl_flag in varchar2 default 'N'
110 ,p_subj_to_imptd_incm_typ_cd in varchar2 default null
111 ,p_use_all_asnts_elig_flag in varchar2 default 'N'
112 ,p_use_all_asnts_for_rt_flag in varchar2 default 'N'
113 ,p_vstg_apls_flag in varchar2 default 'N'
114 ,p_wvbl_flag in varchar2 default 'N'
115 ,p_hc_svc_typ_cd in varchar2 default null
116 ,p_pl_stat_cd in varchar2 default null
117 ,p_prmry_fndg_mthd_cd in varchar2 default null
118 ,p_rt_end_dt_cd in varchar2 default null
119 ,p_rt_end_dt_rl in number default null
120 ,p_rt_strt_dt_rl in number default null
121 ,p_rt_strt_dt_cd in varchar2 default null
122 ,p_bnf_dsgn_cd in varchar2 default null
123 ,p_pl_typ_id in number default null
124 ,p_business_group_id in number default null
125 ,p_enrt_pl_opt_flag in varchar2 default 'N'
126 ,p_bnft_prvdr_pool_id in number default null
127 ,p_may_enrl_pl_n_oipl_flag in varchar2 default 'N'
128 ,p_enrt_rl in number default null
129 ,p_rqd_perd_enrt_nenrt_rl in number default null
130 ,p_alws_unrstrctd_enrt_flag in varchar2 default 'N'
131 ,p_bnft_or_option_rstrctn_cd in varchar2 default null
132 ,p_cvg_incr_r_decr_only_cd in varchar2 default null
133 ,p_unsspnd_enrt_cd in varchar2 default null
134 ,p_pln_attribute_category in varchar2 default null
135 ,p_pln_attribute1 in varchar2 default null
139 ,p_pln_attribute5 in varchar2 default null
136 ,p_pln_attribute2 in varchar2 default null
137 ,p_pln_attribute3 in varchar2 default null
138 ,p_pln_attribute4 in varchar2 default null
140 ,p_pln_attribute6 in varchar2 default null
141 ,p_pln_attribute7 in varchar2 default null
142 ,p_pln_attribute8 in varchar2 default null
143 ,p_pln_attribute9 in varchar2 default null
144 ,p_pln_attribute10 in varchar2 default null
145 ,p_pln_attribute11 in varchar2 default null
146 ,p_pln_attribute12 in varchar2 default null
147 ,p_pln_attribute13 in varchar2 default null
148 ,p_pln_attribute14 in varchar2 default null
149 ,p_pln_attribute15 in varchar2 default null
150 ,p_pln_attribute16 in varchar2 default null
151 ,p_pln_attribute17 in varchar2 default null
152 ,p_pln_attribute18 in varchar2 default null
153 ,p_pln_attribute19 in varchar2 default null
154 ,p_pln_attribute20 in varchar2 default null
155 ,p_pln_attribute21 in varchar2 default null
156 ,p_pln_attribute22 in varchar2 default null
157 ,p_pln_attribute23 in varchar2 default null
158 ,p_pln_attribute24 in varchar2 default null
159 ,p_pln_attribute25 in varchar2 default null
160 ,p_pln_attribute26 in varchar2 default null
161 ,p_pln_attribute27 in varchar2 default null
162 ,p_pln_attribute28 in varchar2 default null
163 ,p_pln_attribute29 in varchar2 default null
164 ,p_pln_attribute30 in varchar2 default null
165 ,p_susp_if_ctfn_not_prvd_flag in varchar2 default 'Y'
166 ,p_ctfn_determine_cd in varchar2 default null
167 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default null
168 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default null
169 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default null
170 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default 'Y'
171 ,p_susp_if_bnf_ssn_nt_prv_cd in varchar2 default null
172 ,p_susp_if_bnf_dob_nt_prv_cd in varchar2 default null
173 ,p_susp_if_bnf_adr_nt_prv_cd in varchar2 default null
174 ,p_susp_if_ctfn_not_bnf_flag in varchar2 default 'Y'
175 ,p_dpnt_ctfn_determine_cd in varchar2 default null
176 ,p_bnf_ctfn_determine_cd in varchar2 default null
177 ,p_object_version_number out nocopy number
178 ,p_actl_prem_id in number default null
179 ,p_effective_date in date
180 ,p_vrfy_fmly_mmbr_cd in varchar2 default null
181 ,p_vrfy_fmly_mmbr_rl in number default null
182 ,p_alws_tmpry_id_crd_flag in varchar2 default 'N'
183 ,p_nip_dflt_flag in varchar2 default 'N'
184 ,p_frfs_distr_mthd_cd in varchar2 default null
185 ,p_frfs_distr_mthd_rl in number default null
186 ,p_frfs_cntr_det_cd in varchar2 default null
187 ,p_frfs_distr_det_cd in varchar2 default null
188 ,p_cost_alloc_keyflex_1_id in number default null
189 ,p_cost_alloc_keyflex_2_id in number default null
190 ,p_post_to_gl_flag in varchar2 default 'N'
191 ,p_frfs_val_det_cd in varchar2 default null
192 ,p_frfs_mx_cryfwd_val in number default null
193 ,p_frfs_portion_det_cd in varchar2 default null
194 ,p_bndry_perd_cd in varchar2 default null
195 ,p_short_name in varchar2 default null
196 ,p_short_code in varchar2 default null
197 ,p_legislation_code in varchar2 default null
198 ,p_legislation_subgroup in varchar2 default null
199 ,p_group_pl_id in number default null
200 ,p_mapping_table_name in varchar2 default null
201 ,p_mapping_table_pk_id in number default null
202 ,p_function_code in varchar2 default null
203 ,p_pl_yr_not_applcbl_flag in varchar2 default 'N'
204 ,p_use_csd_rsd_prccng_cd in varchar2 default null
205 ,p_all_inelig in varchar2 default 'N'
206 ) is
207 --
208 -- Declare cursors and local variables
209 --
210 l_pl_id ben_pl_f.pl_id%TYPE;
211 l_effective_start_date ben_pl_f.effective_start_date%TYPE;
212 l_effective_end_date ben_pl_f.effective_end_date%TYPE;
213 l_proc varchar2(72) := g_package||'create_Plan';
214 l_object_version_number ben_pl_f.object_version_number%TYPE;
215 --
216 begin
217 --
218 hr_utility.set_location('Entering:'|| l_proc, 10);
219 --
220 -- Issue a savepoint if operating in validation only mode
221 --
222 savepoint create_Plan;
223 --
224 hr_utility.set_location(l_proc, 20);
225 --
226 -- Process Logic
227 --
228 begin
229 --
230 -- Start of API User Hook for the before hook of create_Plan
231 --
232 ben_Plan_bk1.create_Plan_b
233 (
234 p_name => p_name
235 ,p_alws_qdro_flag => p_alws_qdro_flag
236 ,p_alws_qmcso_flag => p_alws_qmcso_flag
237 ,p_alws_reimbmts_flag => p_alws_reimbmts_flag
238 ,p_bnf_addl_instn_txt_alwd_flag => p_bnf_addl_instn_txt_alwd_flag
239 ,p_bnf_adrs_rqd_flag => p_bnf_adrs_rqd_flag
240 ,p_bnf_cntngt_bnfs_alwd_flag => p_bnf_cntngt_bnfs_alwd_flag
244 ,p_bnf_incrmt_amt => p_bnf_incrmt_amt
241 ,p_bnf_ctfn_rqd_flag => p_bnf_ctfn_rqd_flag
242 ,p_bnf_dob_rqd_flag => p_bnf_dob_rqd_flag
243 ,p_bnf_dsge_mnr_ttee_rqd_flag => p_bnf_dsge_mnr_ttee_rqd_flag
245 ,p_bnf_dflt_bnf_cd => p_bnf_dflt_bnf_cd
246 ,p_bnf_legv_id_rqd_flag => p_bnf_legv_id_rqd_flag
247 ,p_bnf_may_dsgt_org_flag => p_bnf_may_dsgt_org_flag
248 ,p_bnf_mn_dsgntbl_amt => p_bnf_mn_dsgntbl_amt
249 ,p_bnf_mn_dsgntbl_pct_val => p_bnf_mn_dsgntbl_pct_val
250 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
251 ,p_ordr_num => p_ordr_num
252 ,p_bnf_pct_incrmt_val => p_bnf_pct_incrmt_val
253 ,p_bnf_pct_amt_alwd_cd => p_bnf_pct_amt_alwd_cd
254 ,p_bnf_qdro_rl_apls_flag => p_bnf_qdro_rl_apls_flag
255 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
256 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
257 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
258 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
259 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
260 ,p_elig_apls_flag => p_elig_apls_flag
261 ,p_invk_dcln_prtn_pl_flag => p_invk_dcln_prtn_pl_flag
262 ,p_invk_flx_cr_pl_flag => p_invk_flx_cr_pl_flag
263 ,p_imptd_incm_calc_cd => p_imptd_incm_calc_cd
264 ,p_drvbl_dpnt_elig_flag => p_drvbl_dpnt_elig_flag
265 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
266 ,p_pl_cd => p_pl_cd
267 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
268 ,p_ivr_ident => p_ivr_ident
269 ,p_url_ref_name => p_url_ref_name
270 ,p_cmpr_clms_to_cvg_or_bal_cd => p_cmpr_clms_to_cvg_or_bal_cd
271 ,p_cobra_pymt_due_dy_num => p_cobra_pymt_due_dy_num
272 ,p_dpnt_cvd_by_othr_apls_flag => p_dpnt_cvd_by_othr_apls_flag
273 ,p_enrt_mthd_cd => p_enrt_mthd_cd
274 ,p_enrt_cd => p_enrt_cd
275 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
276 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
277 ,p_frfs_aply_flag => p_frfs_aply_flag
278 ,p_hc_pl_subj_hcfa_aprvl_flag => p_hc_pl_subj_hcfa_aprvl_flag
279 ,p_hghly_cmpd_rl_apls_flag => p_hghly_cmpd_rl_apls_flag
280 ,p_incptn_dt => p_incptn_dt
281 ,p_mn_cvg_rl => p_mn_cvg_rl
282 ,p_mn_cvg_rqd_amt => p_mn_cvg_rqd_amt
283 ,p_mn_opts_rqd_num => p_mn_opts_rqd_num
284 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
285 ,p_mx_cvg_rl => p_mx_cvg_rl
286 ,p_mx_opts_alwd_num => p_mx_opts_alwd_num
287 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
288 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
289 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
290 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
291 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
292 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
293 ,p_mx_wtg_dt_to_use_cd => p_mx_wtg_dt_to_use_cd
294 ,p_mx_wtg_dt_to_use_rl => p_mx_wtg_dt_to_use_rl
295 ,p_mx_wtg_perd_prte_uom => p_mx_wtg_perd_prte_uom
296 ,p_mx_wtg_perd_prte_val => p_mx_wtg_perd_prte_val
297 ,p_mx_wtg_perd_rl => p_mx_wtg_perd_rl
298 ,p_nip_dflt_enrt_cd => p_nip_dflt_enrt_cd
299 ,p_nip_dflt_enrt_det_rl => p_nip_dflt_enrt_det_rl
300 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
301 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
302 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
303 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
304 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
305 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
306 ,p_dpnt_leg_id_rqd_flag => p_dpnt_leg_id_rqd_flag
307 ,p_dpnt_no_ctfn_rqd_flag => p_dpnt_no_ctfn_rqd_flag
308 ,p_no_mn_cvg_amt_apls_flag => p_no_mn_cvg_amt_apls_flag
309 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
310 ,p_no_mn_opts_num_apls_flag => p_no_mn_opts_num_apls_flag
311 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
312 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
313 ,p_no_mx_opts_num_apls_flag => p_no_mx_opts_num_apls_flag
314 ,p_nip_pl_uom => p_nip_pl_uom
315 ,p_rqd_perd_enrt_nenrt_uom => p_rqd_perd_enrt_nenrt_uom
316 ,p_nip_acty_ref_perd_cd => p_nip_acty_ref_perd_cd
317 ,p_nip_enrt_info_rt_freq_cd => p_nip_enrt_info_rt_freq_cd
318 ,p_per_cvrd_cd => p_per_cvrd_cd
319 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
320 ,p_postelcn_edit_rl => p_postelcn_edit_rl
321 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
322 ,p_prort_prtl_yr_cvg_rstrn_cd => p_prort_prtl_yr_cvg_rstrn_cd
323 ,p_prort_prtl_yr_cvg_rstrn_rl => p_prort_prtl_yr_cvg_rstrn_rl
324 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
325 ,p_svgs_pl_flag => p_svgs_pl_flag
326 ,p_subj_to_imptd_incm_typ_cd => p_subj_to_imptd_incm_typ_cd
327 ,p_use_all_asnts_elig_flag => p_use_all_asnts_elig_flag
331 ,p_hc_svc_typ_cd => p_hc_svc_typ_cd
328 ,p_use_all_asnts_for_rt_flag => p_use_all_asnts_for_rt_flag
329 ,p_vstg_apls_flag => p_vstg_apls_flag
330 ,p_wvbl_flag => p_wvbl_flag
332 ,p_pl_stat_cd => p_pl_stat_cd
333 ,p_prmry_fndg_mthd_cd => p_prmry_fndg_mthd_cd
334 ,p_rt_end_dt_cd => p_rt_end_dt_cd
335 ,p_rt_end_dt_rl => p_rt_end_dt_rl
336 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
337 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
338 ,p_bnf_dsgn_cd => p_bnf_dsgn_cd
339 ,p_pl_typ_id => p_pl_typ_id
340 ,p_business_group_id => p_business_group_id
341 ,p_enrt_pl_opt_flag => p_enrt_pl_opt_flag
342 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
343 ,p_may_enrl_pl_n_oipl_flag => p_may_enrl_pl_n_oipl_flag
344 ,p_enrt_rl => p_enrt_rl
345 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
346 ,p_alws_unrstrctd_enrt_flag => p_alws_unrstrctd_enrt_flag
347 ,p_bnft_or_option_rstrctn_cd => p_bnft_or_option_rstrctn_cd
348 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
349 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
350 ,p_pln_attribute_category => p_pln_attribute_category
351 ,p_pln_attribute1 => p_pln_attribute1
352 ,p_pln_attribute2 => p_pln_attribute2
353 ,p_pln_attribute3 => p_pln_attribute3
354 ,p_pln_attribute4 => p_pln_attribute4
355 ,p_pln_attribute5 => p_pln_attribute5
356 ,p_pln_attribute6 => p_pln_attribute6
357 ,p_pln_attribute7 => p_pln_attribute7
358 ,p_pln_attribute8 => p_pln_attribute8
359 ,p_pln_attribute9 => p_pln_attribute9
360 ,p_pln_attribute10 => p_pln_attribute10
361 ,p_pln_attribute11 => p_pln_attribute11
362 ,p_pln_attribute12 => p_pln_attribute12
363 ,p_pln_attribute13 => p_pln_attribute13
364 ,p_pln_attribute14 => p_pln_attribute14
365 ,p_pln_attribute15 => p_pln_attribute15
366 ,p_pln_attribute16 => p_pln_attribute16
367 ,p_pln_attribute17 => p_pln_attribute17
368 ,p_pln_attribute18 => p_pln_attribute18
369 ,p_pln_attribute19 => p_pln_attribute19
370 ,p_pln_attribute20 => p_pln_attribute20
371 ,p_pln_attribute21 => p_pln_attribute21
372 ,p_pln_attribute22 => p_pln_attribute22
373 ,p_pln_attribute23 => p_pln_attribute23
374 ,p_pln_attribute24 => p_pln_attribute24
375 ,p_pln_attribute25 => p_pln_attribute25
376 ,p_pln_attribute26 => p_pln_attribute26
377 ,p_pln_attribute27 => p_pln_attribute27
378 ,p_pln_attribute28 => p_pln_attribute28
379 ,p_pln_attribute29 => p_pln_attribute29
380 ,p_pln_attribute30 => p_pln_attribute30
381 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
382 ,p_ctfn_determine_cd => p_ctfn_determine_cd
383 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
384 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
385 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
386 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
387 ,p_susp_if_bnf_ssn_nt_prv_cd => p_susp_if_bnf_ssn_nt_prv_cd
388 ,p_susp_if_bnf_dob_nt_prv_cd => p_susp_if_bnf_dob_nt_prv_cd
389 ,p_susp_if_bnf_adr_nt_prv_cd => p_susp_if_bnf_adr_nt_prv_cd
390 ,p_susp_if_ctfn_not_bnf_flag => p_susp_if_ctfn_not_bnf_flag
391 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
392 ,p_bnf_ctfn_determine_cd => p_bnf_ctfn_determine_cd
393 ,p_actl_prem_id => p_actl_prem_id
394 ,p_effective_date => trunc(p_effective_date)
395 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
396 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
397 ,p_alws_tmpry_id_crd_flag => p_alws_tmpry_id_crd_flag
398 ,p_nip_dflt_flag => p_nip_dflt_flag
399 ,p_frfs_distr_mthd_cd => p_frfs_distr_mthd_cd
400 ,p_frfs_distr_mthd_rl => p_frfs_distr_mthd_rl
401 ,p_frfs_cntr_det_cd => p_frfs_cntr_det_cd
402 ,p_frfs_distr_det_cd => p_frfs_distr_det_cd
403 ,p_cost_alloc_keyflex_1_id => p_cost_alloc_keyflex_1_id
404 ,p_cost_alloc_keyflex_2_id => p_cost_alloc_keyflex_2_id
405 ,p_post_to_gl_flag => p_post_to_gl_flag
406 ,p_frfs_val_det_cd => p_frfs_val_det_cd
407 ,p_frfs_mx_cryfwd_val => p_frfs_mx_cryfwd_val
408 ,p_frfs_portion_det_cd => p_frfs_portion_det_cd
409 ,p_bndry_perd_cd => p_bndry_perd_cd
410 ,p_short_name => p_short_name
411 ,p_short_code => p_short_code
412 ,p_legislation_code => p_legislation_code
413 ,p_legislation_subgroup => p_legislation_subgroup
414 ,p_group_pl_id => p_group_pl_id
415 ,p_mapping_table_name => p_mapping_table_name
416 ,p_mapping_table_pk_id => p_mapping_table_pk_id
417 ,p_function_code => p_function_code
418 ,p_pl_yr_not_applcbl_flag => p_pl_yr_not_applcbl_flag
422 exception
419 ,p_use_csd_rsd_prccng_cd => p_use_csd_rsd_prccng_cd
420 ,p_all_inelig => p_all_inelig
421 );
423 when hr_api.cannot_find_prog_unit then
424 hr_api.cannot_find_prog_unit_error
425 (
426 p_module_name => 'CREATE_Plan'
427 ,p_hook_type => 'BP'
428 );
429 --
430 -- End of API User Hook for the before hook of create_Plan
431 --
432 end;
433 --
434 ben_pln_ins.ins
435 (
436 p_pl_id => l_pl_id
437 ,p_effective_start_date => l_effective_start_date
438 ,p_effective_end_date => l_effective_end_date
439 ,p_name => p_name
440 ,p_alws_qdro_flag => p_alws_qdro_flag
441 ,p_alws_qmcso_flag => p_alws_qmcso_flag
442 ,p_alws_reimbmts_flag => p_alws_reimbmts_flag
443 ,p_bnf_addl_instn_txt_alwd_flag => p_bnf_addl_instn_txt_alwd_flag
444 ,p_bnf_adrs_rqd_flag => p_bnf_adrs_rqd_flag
445 ,p_bnf_cntngt_bnfs_alwd_flag => p_bnf_cntngt_bnfs_alwd_flag
446 ,p_bnf_ctfn_rqd_flag => p_bnf_ctfn_rqd_flag
447 ,p_bnf_dob_rqd_flag => p_bnf_dob_rqd_flag
448 ,p_bnf_dsge_mnr_ttee_rqd_flag => p_bnf_dsge_mnr_ttee_rqd_flag
449 ,p_bnf_incrmt_amt => p_bnf_incrmt_amt
450 ,p_bnf_dflt_bnf_cd => p_bnf_dflt_bnf_cd
451 ,p_bnf_legv_id_rqd_flag => p_bnf_legv_id_rqd_flag
452 ,p_bnf_may_dsgt_org_flag => p_bnf_may_dsgt_org_flag
453 ,p_bnf_mn_dsgntbl_amt => p_bnf_mn_dsgntbl_amt
454 ,p_bnf_mn_dsgntbl_pct_val => p_bnf_mn_dsgntbl_pct_val
455 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
456 ,p_ordr_num => p_ordr_num
457 ,p_bnf_pct_incrmt_val => p_bnf_pct_incrmt_val
458 ,p_bnf_pct_amt_alwd_cd => p_bnf_pct_amt_alwd_cd
459 ,p_bnf_qdro_rl_apls_flag => p_bnf_qdro_rl_apls_flag
460 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
461 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
462 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
463 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
464 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
465 ,p_elig_apls_flag => p_elig_apls_flag
466 ,p_invk_dcln_prtn_pl_flag => p_invk_dcln_prtn_pl_flag
467 ,p_invk_flx_cr_pl_flag => p_invk_flx_cr_pl_flag
468 ,p_imptd_incm_calc_cd => p_imptd_incm_calc_cd
469 ,p_drvbl_dpnt_elig_flag => p_drvbl_dpnt_elig_flag
470 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
471 ,p_pl_cd => p_pl_cd
472 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
473 ,p_ivr_ident => p_ivr_ident
474 ,p_url_ref_name => p_url_ref_name
475 ,p_cmpr_clms_to_cvg_or_bal_cd => p_cmpr_clms_to_cvg_or_bal_cd
476 ,p_cobra_pymt_due_dy_num => p_cobra_pymt_due_dy_num
477 ,p_dpnt_cvd_by_othr_apls_flag => p_dpnt_cvd_by_othr_apls_flag
478 ,p_enrt_mthd_cd => p_enrt_mthd_cd
479 ,p_enrt_cd => p_enrt_cd
480 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
481 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
482 ,p_frfs_aply_flag => p_frfs_aply_flag
483 ,p_hc_pl_subj_hcfa_aprvl_flag => p_hc_pl_subj_hcfa_aprvl_flag
484 ,p_hghly_cmpd_rl_apls_flag => p_hghly_cmpd_rl_apls_flag
485 ,p_incptn_dt => p_incptn_dt
486 ,p_mn_cvg_rl => p_mn_cvg_rl
487 ,p_mn_cvg_rqd_amt => p_mn_cvg_rqd_amt
488 ,p_mn_opts_rqd_num => p_mn_opts_rqd_num
489 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
490 ,p_mx_cvg_rl => p_mx_cvg_rl
491 ,p_mx_opts_alwd_num => p_mx_opts_alwd_num
492 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
493 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
494 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
495 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
496 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
497 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
498 ,p_mx_wtg_dt_to_use_cd => p_mx_wtg_dt_to_use_cd
499 ,p_mx_wtg_dt_to_use_rl => p_mx_wtg_dt_to_use_rl
500 ,p_mx_wtg_perd_prte_uom => p_mx_wtg_perd_prte_uom
501 ,p_mx_wtg_perd_prte_val => p_mx_wtg_perd_prte_val
502 ,p_mx_wtg_perd_rl => p_mx_wtg_perd_rl
503 ,p_nip_dflt_enrt_cd => p_nip_dflt_enrt_cd
504 ,p_nip_dflt_enrt_det_rl => p_nip_dflt_enrt_det_rl
505 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
506 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
507 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
508 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
509 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
510 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
511 ,p_dpnt_leg_id_rqd_flag => p_dpnt_leg_id_rqd_flag
512 ,p_dpnt_no_ctfn_rqd_flag => p_dpnt_no_ctfn_rqd_flag
513 ,p_no_mn_cvg_amt_apls_flag => p_no_mn_cvg_amt_apls_flag
514 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
515 ,p_no_mn_opts_num_apls_flag => p_no_mn_opts_num_apls_flag
516 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
517 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
518 ,p_no_mx_opts_num_apls_flag => p_no_mx_opts_num_apls_flag
519 ,p_nip_pl_uom => p_nip_pl_uom
520 ,p_rqd_perd_enrt_nenrt_uom => p_rqd_perd_enrt_nenrt_uom
524 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
521 ,p_nip_acty_ref_perd_cd => p_nip_acty_ref_perd_cd
522 ,p_nip_enrt_info_rt_freq_cd => p_nip_enrt_info_rt_freq_cd
523 ,p_per_cvrd_cd => p_per_cvrd_cd
525 ,p_postelcn_edit_rl => p_postelcn_edit_rl
526 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
527 ,p_prort_prtl_yr_cvg_rstrn_cd => p_prort_prtl_yr_cvg_rstrn_cd
528 ,p_prort_prtl_yr_cvg_rstrn_rl => p_prort_prtl_yr_cvg_rstrn_rl
529 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
530 ,p_svgs_pl_flag => p_svgs_pl_flag
531 ,p_subj_to_imptd_incm_typ_cd => p_subj_to_imptd_incm_typ_cd
532 ,p_use_all_asnts_elig_flag => p_use_all_asnts_elig_flag
533 ,p_use_all_asnts_for_rt_flag => p_use_all_asnts_for_rt_flag
534 ,p_vstg_apls_flag => p_vstg_apls_flag
535 ,p_wvbl_flag => p_wvbl_flag
536 ,p_hc_svc_typ_cd => p_hc_svc_typ_cd
537 ,p_pl_stat_cd => p_pl_stat_cd
538 ,p_prmry_fndg_mthd_cd => p_prmry_fndg_mthd_cd
539 ,p_rt_end_dt_cd => p_rt_end_dt_cd
540 ,p_rt_end_dt_rl => p_rt_end_dt_rl
541 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
542 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
543 ,p_bnf_dsgn_cd => p_bnf_dsgn_cd
544 ,p_pl_typ_id => p_pl_typ_id
545 ,p_business_group_id => p_business_group_id
546 ,p_enrt_pl_opt_flag => p_enrt_pl_opt_flag
547 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
548 ,p_may_enrl_pl_n_oipl_flag => p_may_enrl_pl_n_oipl_flag
549 ,p_enrt_rl => p_enrt_rl
550 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
551 ,p_alws_unrstrctd_enrt_flag => p_alws_unrstrctd_enrt_flag
552 ,p_bnft_or_option_rstrctn_cd => p_bnft_or_option_rstrctn_cd
553 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
554 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
555 ,p_pln_attribute_category => p_pln_attribute_category
556 ,p_pln_attribute1 => p_pln_attribute1
557 ,p_pln_attribute2 => p_pln_attribute2
558 ,p_pln_attribute3 => p_pln_attribute3
559 ,p_pln_attribute4 => p_pln_attribute4
560 ,p_pln_attribute5 => p_pln_attribute5
561 ,p_pln_attribute6 => p_pln_attribute6
562 ,p_pln_attribute7 => p_pln_attribute7
563 ,p_pln_attribute8 => p_pln_attribute8
564 ,p_pln_attribute9 => p_pln_attribute9
565 ,p_pln_attribute10 => p_pln_attribute10
566 ,p_pln_attribute11 => p_pln_attribute11
567 ,p_pln_attribute12 => p_pln_attribute12
568 ,p_pln_attribute13 => p_pln_attribute13
569 ,p_pln_attribute14 => p_pln_attribute14
570 ,p_pln_attribute15 => p_pln_attribute15
571 ,p_pln_attribute16 => p_pln_attribute16
572 ,p_pln_attribute17 => p_pln_attribute17
573 ,p_pln_attribute18 => p_pln_attribute18
574 ,p_pln_attribute19 => p_pln_attribute19
575 ,p_pln_attribute20 => p_pln_attribute20
576 ,p_pln_attribute21 => p_pln_attribute21
577 ,p_pln_attribute22 => p_pln_attribute22
578 ,p_pln_attribute23 => p_pln_attribute23
579 ,p_pln_attribute24 => p_pln_attribute24
580 ,p_pln_attribute25 => p_pln_attribute25
581 ,p_pln_attribute26 => p_pln_attribute26
582 ,p_pln_attribute27 => p_pln_attribute27
583 ,p_pln_attribute28 => p_pln_attribute28
584 ,p_pln_attribute29 => p_pln_attribute29
585 ,p_pln_attribute30 => p_pln_attribute30
586 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
587 ,p_ctfn_determine_cd => p_ctfn_determine_cd
588 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
589 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
590 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
591 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
592 ,p_susp_if_bnf_ssn_nt_prv_cd => p_susp_if_bnf_ssn_nt_prv_cd
593 ,p_susp_if_bnf_dob_nt_prv_cd => p_susp_if_bnf_dob_nt_prv_cd
594 ,p_susp_if_bnf_adr_nt_prv_cd => p_susp_if_bnf_adr_nt_prv_cd
595 ,p_susp_if_ctfn_not_bnf_flag => p_susp_if_ctfn_not_bnf_flag
596 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
597 ,p_bnf_ctfn_determine_cd => p_bnf_ctfn_determine_cd
598 ,p_object_version_number => l_object_version_number
599 ,p_actl_prem_id => p_actl_prem_id
600 ,p_effective_date => trunc(p_effective_date)
601 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
602 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
603 ,p_alws_tmpry_id_crd_flag => p_alws_tmpry_id_crd_flag
604 ,p_nip_dflt_flag => p_nip_dflt_flag
605 ,p_frfs_distr_mthd_cd => p_frfs_distr_mthd_cd
606 ,p_frfs_distr_mthd_rl => p_frfs_distr_mthd_rl
607 ,p_frfs_cntr_det_cd => p_frfs_cntr_det_cd
608 ,p_frfs_distr_det_cd => p_frfs_distr_det_cd
609 ,p_cost_alloc_keyflex_1_id => p_cost_alloc_keyflex_1_id
610 ,p_cost_alloc_keyflex_2_id => p_cost_alloc_keyflex_2_id
611 ,p_post_to_gl_flag => p_post_to_gl_flag
612 ,p_frfs_val_det_cd => p_frfs_val_det_cd
613 ,p_frfs_mx_cryfwd_val => p_frfs_mx_cryfwd_val
617 ,p_short_code => p_short_code
614 ,p_frfs_portion_det_cd => p_frfs_portion_det_cd
615 ,p_bndry_perd_cd => p_bndry_perd_cd
616 ,p_short_name => p_short_name
618 ,p_legislation_code => p_legislation_code
619 ,p_legislation_subgroup => p_legislation_subgroup
620 ,p_group_pl_id => p_group_pl_id
621 ,p_mapping_table_name => p_mapping_table_name
622 ,p_mapping_table_pk_id => p_mapping_table_pk_id
623 ,p_function_code => p_function_code
624 ,p_pl_yr_not_applcbl_flag => p_pl_yr_not_applcbl_flag
625 ,p_use_csd_rsd_prccng_cd => p_use_csd_rsd_prccng_cd
626 ,p_all_inelig => p_all_inelig
627 );
628 --
629 begin
630 --
631 -- Start of API User Hook for the after hook of create_Plan
632 --
633 ben_Plan_bk1.create_Plan_a
634 (
635 p_pl_id => l_pl_id
636 ,p_effective_start_date => l_effective_start_date
637 ,p_effective_end_date => l_effective_end_date
638 ,p_name => p_name
639 ,p_alws_qdro_flag => p_alws_qdro_flag
640 ,p_alws_qmcso_flag => p_alws_qmcso_flag
641 ,p_alws_reimbmts_flag => p_alws_reimbmts_flag
642 ,p_bnf_addl_instn_txt_alwd_flag => p_bnf_addl_instn_txt_alwd_flag
643 ,p_bnf_adrs_rqd_flag => p_bnf_adrs_rqd_flag
644 ,p_bnf_cntngt_bnfs_alwd_flag => p_bnf_cntngt_bnfs_alwd_flag
645 ,p_bnf_ctfn_rqd_flag => p_bnf_ctfn_rqd_flag
646 ,p_bnf_dob_rqd_flag => p_bnf_dob_rqd_flag
647 ,p_bnf_dsge_mnr_ttee_rqd_flag => p_bnf_dsge_mnr_ttee_rqd_flag
648 ,p_bnf_incrmt_amt => p_bnf_incrmt_amt
649 ,p_bnf_dflt_bnf_cd => p_bnf_dflt_bnf_cd
650 ,p_bnf_legv_id_rqd_flag => p_bnf_legv_id_rqd_flag
651 ,p_bnf_may_dsgt_org_flag => p_bnf_may_dsgt_org_flag
652 ,p_bnf_mn_dsgntbl_amt => p_bnf_mn_dsgntbl_amt
653 ,p_bnf_mn_dsgntbl_pct_val => p_bnf_mn_dsgntbl_pct_val
654 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
655 ,p_ordr_num => p_ordr_num
656 ,p_bnf_pct_incrmt_val => p_bnf_pct_incrmt_val
657 ,p_bnf_pct_amt_alwd_cd => p_bnf_pct_amt_alwd_cd
658 ,p_bnf_qdro_rl_apls_flag => p_bnf_qdro_rl_apls_flag
659 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
660 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
661 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
662 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
663 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
664 ,p_elig_apls_flag => p_elig_apls_flag
665 ,p_invk_dcln_prtn_pl_flag => p_invk_dcln_prtn_pl_flag
666 ,p_invk_flx_cr_pl_flag => p_invk_flx_cr_pl_flag
667 ,p_imptd_incm_calc_cd => p_imptd_incm_calc_cd
668 ,p_drvbl_dpnt_elig_flag => p_drvbl_dpnt_elig_flag
669 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
670 ,p_pl_cd => p_pl_cd
671 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
672 ,p_ivr_ident => p_ivr_ident
673 ,p_url_ref_name => p_url_ref_name
674 ,p_cmpr_clms_to_cvg_or_bal_cd => p_cmpr_clms_to_cvg_or_bal_cd
675 ,p_cobra_pymt_due_dy_num => p_cobra_pymt_due_dy_num
676 ,p_dpnt_cvd_by_othr_apls_flag => p_dpnt_cvd_by_othr_apls_flag
677 ,p_enrt_mthd_cd => p_enrt_mthd_cd
678 ,p_enrt_cd => p_enrt_cd
679 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
680 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
681 ,p_frfs_aply_flag => p_frfs_aply_flag
682 ,p_hc_pl_subj_hcfa_aprvl_flag => p_hc_pl_subj_hcfa_aprvl_flag
683 ,p_hghly_cmpd_rl_apls_flag => p_hghly_cmpd_rl_apls_flag
684 ,p_incptn_dt => p_incptn_dt
685 ,p_mn_cvg_rl => p_mn_cvg_rl
686 ,p_mn_cvg_rqd_amt => p_mn_cvg_rqd_amt
687 ,p_mn_opts_rqd_num => p_mn_opts_rqd_num
688 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
689 ,p_mx_cvg_rl => p_mx_cvg_rl
690 ,p_mx_opts_alwd_num => p_mx_opts_alwd_num
691 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
692 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
693 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
694 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
695 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
696 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
697 ,p_mx_wtg_dt_to_use_cd => p_mx_wtg_dt_to_use_cd
698 ,p_mx_wtg_dt_to_use_rl => p_mx_wtg_dt_to_use_rl
699 ,p_mx_wtg_perd_prte_uom => p_mx_wtg_perd_prte_uom
700 ,p_mx_wtg_perd_prte_val => p_mx_wtg_perd_prte_val
701 ,p_mx_wtg_perd_rl => p_mx_wtg_perd_rl
702 ,p_nip_dflt_enrt_cd => p_nip_dflt_enrt_cd
703 ,p_nip_dflt_enrt_det_rl => p_nip_dflt_enrt_det_rl
704 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
705 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
706 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
707 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
711 ,p_dpnt_no_ctfn_rqd_flag => p_dpnt_no_ctfn_rqd_flag
708 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
709 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
710 ,p_dpnt_leg_id_rqd_flag => p_dpnt_leg_id_rqd_flag
712 ,p_no_mn_cvg_amt_apls_flag => p_no_mn_cvg_amt_apls_flag
713 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
714 ,p_no_mn_opts_num_apls_flag => p_no_mn_opts_num_apls_flag
715 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
716 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
717 ,p_no_mx_opts_num_apls_flag => p_no_mx_opts_num_apls_flag
718 ,p_nip_pl_uom => p_nip_pl_uom
719 ,p_rqd_perd_enrt_nenrt_uom => p_rqd_perd_enrt_nenrt_uom
720 ,p_nip_acty_ref_perd_cd => p_nip_acty_ref_perd_cd
721 ,p_nip_enrt_info_rt_freq_cd => p_nip_enrt_info_rt_freq_cd
722 ,p_per_cvrd_cd => p_per_cvrd_cd
723 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
724 ,p_postelcn_edit_rl => p_postelcn_edit_rl
725 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
726 ,p_prort_prtl_yr_cvg_rstrn_cd => p_prort_prtl_yr_cvg_rstrn_cd
727 ,p_prort_prtl_yr_cvg_rstrn_rl => p_prort_prtl_yr_cvg_rstrn_rl
728 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
729 ,p_svgs_pl_flag => p_svgs_pl_flag
730 ,p_subj_to_imptd_incm_typ_cd => p_subj_to_imptd_incm_typ_cd
731 ,p_use_all_asnts_elig_flag => p_use_all_asnts_elig_flag
732 ,p_use_all_asnts_for_rt_flag => p_use_all_asnts_for_rt_flag
733 ,p_vstg_apls_flag => p_vstg_apls_flag
734 ,p_wvbl_flag => p_wvbl_flag
735 ,p_hc_svc_typ_cd => p_hc_svc_typ_cd
736 ,p_pl_stat_cd => p_pl_stat_cd
737 ,p_prmry_fndg_mthd_cd => p_prmry_fndg_mthd_cd
738 ,p_rt_end_dt_cd => p_rt_end_dt_cd
739 ,p_rt_end_dt_rl => p_rt_end_dt_rl
740 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
741 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
742 ,p_bnf_dsgn_cd => p_bnf_dsgn_cd
743 ,p_pl_typ_id => p_pl_typ_id
744 ,p_business_group_id => p_business_group_id
745 ,p_enrt_pl_opt_flag => p_enrt_pl_opt_flag
746 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
747 ,p_may_enrl_pl_n_oipl_flag => p_may_enrl_pl_n_oipl_flag
748 ,p_enrt_rl => p_enrt_rl
749 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
750 ,p_alws_unrstrctd_enrt_flag => p_alws_unrstrctd_enrt_flag
751 ,p_bnft_or_option_rstrctn_cd => p_bnft_or_option_rstrctn_cd
752 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
753 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
754 ,p_pln_attribute_category => p_pln_attribute_category
755 ,p_pln_attribute1 => p_pln_attribute1
756 ,p_pln_attribute2 => p_pln_attribute2
757 ,p_pln_attribute3 => p_pln_attribute3
758 ,p_pln_attribute4 => p_pln_attribute4
759 ,p_pln_attribute5 => p_pln_attribute5
760 ,p_pln_attribute6 => p_pln_attribute6
761 ,p_pln_attribute7 => p_pln_attribute7
762 ,p_pln_attribute8 => p_pln_attribute8
763 ,p_pln_attribute9 => p_pln_attribute9
764 ,p_pln_attribute10 => p_pln_attribute10
765 ,p_pln_attribute11 => p_pln_attribute11
766 ,p_pln_attribute12 => p_pln_attribute12
767 ,p_pln_attribute13 => p_pln_attribute13
768 ,p_pln_attribute14 => p_pln_attribute14
769 ,p_pln_attribute15 => p_pln_attribute15
770 ,p_pln_attribute16 => p_pln_attribute16
771 ,p_pln_attribute17 => p_pln_attribute17
772 ,p_pln_attribute18 => p_pln_attribute18
773 ,p_pln_attribute19 => p_pln_attribute19
774 ,p_pln_attribute20 => p_pln_attribute20
775 ,p_pln_attribute21 => p_pln_attribute21
776 ,p_pln_attribute22 => p_pln_attribute22
777 ,p_pln_attribute23 => p_pln_attribute23
778 ,p_pln_attribute24 => p_pln_attribute24
779 ,p_pln_attribute25 => p_pln_attribute25
780 ,p_pln_attribute26 => p_pln_attribute26
781 ,p_pln_attribute27 => p_pln_attribute27
782 ,p_pln_attribute28 => p_pln_attribute28
783 ,p_pln_attribute29 => p_pln_attribute29
784 ,p_pln_attribute30 => p_pln_attribute30
785 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
786 ,p_ctfn_determine_cd => p_ctfn_determine_cd
787 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
788 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
789 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
790 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
791 ,p_susp_if_bnf_ssn_nt_prv_cd => p_susp_if_bnf_ssn_nt_prv_cd
792 ,p_susp_if_bnf_dob_nt_prv_cd => p_susp_if_bnf_dob_nt_prv_cd
793 ,p_susp_if_bnf_adr_nt_prv_cd => p_susp_if_bnf_adr_nt_prv_cd
794 ,p_susp_if_ctfn_not_bnf_flag => p_susp_if_ctfn_not_bnf_flag
795 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
799 ,p_effective_date => trunc(p_effective_date)
796 ,p_bnf_ctfn_determine_cd => p_bnf_ctfn_determine_cd
797 ,p_object_version_number => l_object_version_number
798 ,p_actl_prem_id => p_actl_prem_id
800 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
801 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
802 ,p_alws_tmpry_id_crd_flag => p_alws_tmpry_id_crd_flag
803 ,p_nip_dflt_flag => p_nip_dflt_flag
804 ,p_frfs_distr_mthd_cd => p_frfs_distr_mthd_cd
805 ,p_frfs_distr_mthd_rl => p_frfs_distr_mthd_rl
806 ,p_frfs_cntr_det_cd => p_frfs_cntr_det_cd
807 ,p_frfs_distr_det_cd => p_frfs_distr_det_cd
808 ,p_cost_alloc_keyflex_1_id => p_cost_alloc_keyflex_1_id
809 ,p_cost_alloc_keyflex_2_id => p_cost_alloc_keyflex_2_id
810 ,p_post_to_gl_flag => p_post_to_gl_flag
811 ,p_frfs_val_det_cd => p_frfs_val_det_cd
812 ,p_frfs_mx_cryfwd_val => p_frfs_mx_cryfwd_val
813 ,p_frfs_portion_det_cd => p_frfs_portion_det_cd
814 ,p_bndry_perd_cd => p_bndry_perd_cd
815 ,p_short_name => p_short_name
816 ,p_short_code => p_short_code
817 ,p_legislation_code => p_legislation_code
818 ,p_legislation_subgroup => p_legislation_subgroup
819 ,p_group_pl_id => p_group_pl_id
820 ,p_mapping_table_name => p_mapping_table_name
821 ,p_mapping_table_pk_id => p_mapping_table_pk_id
822 ,p_function_code => p_function_code
823 ,p_pl_yr_not_applcbl_flag => p_pl_yr_not_applcbl_flag
824 ,p_use_csd_rsd_prccng_cd => p_use_csd_rsd_prccng_cd
825 ,p_all_inelig => p_all_inelig
826 );
827 exception
828 when hr_api.cannot_find_prog_unit then
829 hr_api.cannot_find_prog_unit_error
830 (p_module_name => 'CREATE_Plan'
831 ,p_hook_type => 'AP'
832 );
833 --
834 -- End of API User Hook for the after hook of create_Plan
835 --
836 end;
837 --
838 hr_utility.set_location(l_proc, 60);
839 --
840 -- When in validation only mode raise the Validate_Enabled exception
841 --
842 if p_validate then
843 raise hr_api.validate_enabled;
844 end if;
845 --
846 -- Set all output arguments
847 --
848 p_pl_id := l_pl_id;
849 p_effective_start_date := l_effective_start_date;
850 p_effective_end_date := l_effective_end_date;
851 p_object_version_number := l_object_version_number;
852 --
853 hr_utility.set_location(' Leaving:'||l_proc, 70);
854 --
855 exception
856 --
857 when hr_api.validate_enabled then
858 --
859 -- As the Validate_Enabled exception has been raised
860 -- we must rollback to the savepoint
861 --
862 ROLLBACK TO create_Plan;
863 --
864 -- Only set output warning arguments
865 -- (Any key or derived arguments must be set to null
866 -- when validation only mode is being used.)
867 --
868 p_pl_id := null;
869 p_effective_start_date := null;
870 p_effective_end_date := null;
871 p_object_version_number := null;
872 hr_utility.set_location(' Leaving:'||l_proc, 80);
873 --
874 when others then
875 --
876 -- A validation or unexpected error has occured
877 --
878 ROLLBACK TO create_Plan;
879 /* Inserted for nocopy changes */
880 p_pl_id := null;
881 p_effective_start_date := null;
882 p_effective_end_date := null;
883 p_object_version_number := null;
884 raise;
885 --
886 end create_Plan;
887 -- ----------------------------------------------------------------------------
888 -- |------------------------< update_Plan >--- ------------------|
889 -- ----------------------------------------------------------------------------
890 --
891 procedure update_Plan
892 (p_validate in boolean default false
893 ,p_pl_id in number
894 ,p_effective_start_date out nocopy date
895 ,p_effective_end_date out nocopy date
896 ,p_name in varchar2 default hr_api.g_varchar2
897 ,p_alws_qdro_flag in varchar2 default hr_api.g_varchar2
898 ,p_alws_qmcso_flag in varchar2 default hr_api.g_varchar2
899 ,p_alws_reimbmts_flag in varchar2 default hr_api.g_varchar2
900 ,p_bnf_addl_instn_txt_alwd_flag in varchar2 default hr_api.g_varchar2
901 ,p_bnf_adrs_rqd_flag in varchar2 default hr_api.g_varchar2
902 ,p_bnf_cntngt_bnfs_alwd_flag in varchar2 default hr_api.g_varchar2
903 ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
904 ,p_bnf_dob_rqd_flag in varchar2 default hr_api.g_varchar2
905 ,p_bnf_dsge_mnr_ttee_rqd_flag in varchar2 default hr_api.g_varchar2
906 ,p_bnf_incrmt_amt in number default hr_api.g_number
907 ,p_bnf_dflt_bnf_cd in varchar2 default hr_api.g_varchar2
908 ,p_bnf_legv_id_rqd_flag in varchar2 default hr_api.g_varchar2
909 ,p_bnf_may_dsgt_org_flag in varchar2 default hr_api.g_varchar2
910 ,p_bnf_mn_dsgntbl_amt in number default hr_api.g_number
911 ,p_bnf_mn_dsgntbl_pct_val in number default hr_api.g_number
912 ,p_rqd_perd_enrt_nenrt_val in number default hr_api.g_number
916 ,p_bnf_qdro_rl_apls_flag in varchar2 default hr_api.g_varchar2
913 ,p_ordr_num in number default hr_api.g_number
914 ,p_bnf_pct_incrmt_val in number default hr_api.g_number
915 ,p_bnf_pct_amt_alwd_cd in varchar2 default hr_api.g_varchar2
917 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
918 ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
919 ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
920 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
921 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
922 ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
923 ,p_invk_dcln_prtn_pl_flag in varchar2 default hr_api.g_varchar2
924 ,p_invk_flx_cr_pl_flag in varchar2 default hr_api.g_varchar2
925 ,p_imptd_incm_calc_cd in varchar2 default hr_api.g_varchar2
926 ,p_drvbl_dpnt_elig_flag in varchar2 default hr_api.g_varchar2
927 ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
928 ,p_pl_cd in varchar2 default hr_api.g_varchar2
929 ,p_auto_enrt_mthd_rl in number default hr_api.g_number
930 ,p_ivr_ident in varchar2 default hr_api.g_varchar2
931 ,p_url_ref_name in varchar2 default hr_api.g_varchar2
932 ,p_cmpr_clms_to_cvg_or_bal_cd in varchar2 default hr_api.g_varchar2
933 ,p_cobra_pymt_due_dy_num in number default hr_api.g_number
934 ,p_dpnt_cvd_by_othr_apls_flag in varchar2 default hr_api.g_varchar2
935 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
936 ,p_enrt_cd in varchar2 default hr_api.g_varchar2
937 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
938 ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
939 ,p_frfs_aply_flag in varchar2 default hr_api.g_varchar2
940 ,p_hc_pl_subj_hcfa_aprvl_flag in varchar2 default hr_api.g_varchar2
941 ,p_hghly_cmpd_rl_apls_flag in varchar2 default hr_api.g_varchar2
942 ,p_incptn_dt in date default hr_api.g_date
943 ,p_mn_cvg_rl in number default hr_api.g_number
944 ,p_mn_cvg_rqd_amt in number default hr_api.g_number
945 ,p_mn_opts_rqd_num in number default hr_api.g_number
946 ,p_mx_cvg_alwd_amt in number default hr_api.g_number
947 ,p_mx_cvg_rl in number default hr_api.g_number
948 ,p_mx_opts_alwd_num in number default hr_api.g_number
949 ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
950 ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
951 ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
952 ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
953 ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
954 ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
955 ,p_mx_wtg_dt_to_use_cd in varchar2 default hr_api.g_varchar2
956 ,p_mx_wtg_dt_to_use_rl in number default hr_api.g_number
957 ,p_mx_wtg_perd_prte_uom in varchar2 default hr_api.g_varchar2
958 ,p_mx_wtg_perd_prte_val in number default hr_api.g_number
959 ,p_mx_wtg_perd_rl in number default hr_api.g_number
960 ,p_nip_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
961 ,p_nip_dflt_enrt_det_rl in number default hr_api.g_number
962 ,p_dpnt_adrs_rqd_flag in varchar2 default hr_api.g_varchar2
963 ,p_dpnt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
964 ,p_dpnt_cvg_end_dt_rl in number default hr_api.g_number
965 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
966 ,p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number
967 ,p_dpnt_dob_rqd_flag in varchar2 default hr_api.g_varchar2
968 ,p_dpnt_leg_id_rqd_flag in varchar2 default hr_api.g_varchar2
969 ,p_dpnt_no_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
970 ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
971 ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
972 ,p_no_mn_opts_num_apls_flag in varchar2 default hr_api.g_varchar2
973 ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
974 ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
975 ,p_no_mx_opts_num_apls_flag in varchar2 default hr_api.g_varchar2
976 ,p_nip_pl_uom in varchar2 default hr_api.g_varchar2
977 ,p_rqd_perd_enrt_nenrt_uom in varchar2 default hr_api.g_varchar2
978 ,p_nip_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
979 ,p_nip_enrt_info_rt_freq_cd in varchar2 default hr_api.g_varchar2
980 ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
981 ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
982 ,p_postelcn_edit_rl in number default hr_api.g_number
983 ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
984 ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
985 ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
986 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
987 ,p_svgs_pl_flag in varchar2 default hr_api.g_varchar2
988 ,p_subj_to_imptd_incm_typ_cd in varchar2 default hr_api.g_varchar2
989 ,p_use_all_asnts_elig_flag in varchar2 default hr_api.g_varchar2
990 ,p_use_all_asnts_for_rt_flag in varchar2 default hr_api.g_varchar2
991 ,p_vstg_apls_flag in varchar2 default hr_api.g_varchar2
995 ,p_prmry_fndg_mthd_cd in varchar2 default hr_api.g_varchar2
992 ,p_wvbl_flag in varchar2 default hr_api.g_varchar2
993 ,p_hc_svc_typ_cd in varchar2 default hr_api.g_varchar2
994 ,p_pl_stat_cd in varchar2 default hr_api.g_varchar2
996 ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
997 ,p_rt_end_dt_rl in number default hr_api.g_number
998 ,p_rt_strt_dt_rl in number default hr_api.g_number
999 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
1000 ,p_bnf_dsgn_cd in varchar2 default hr_api.g_varchar2
1001 ,p_pl_typ_id in number default hr_api.g_number
1002 ,p_business_group_id in number default hr_api.g_number
1003 ,p_enrt_pl_opt_flag in varchar2 default hr_api.g_varchar2
1004 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
1005 ,p_may_enrl_pl_n_oipl_flag in varchar2 default hr_api.g_varchar2
1006 ,p_enrt_rl in number default hr_api.g_number
1007 ,p_rqd_perd_enrt_nenrt_rl in number default hr_api.g_number
1008 ,p_alws_unrstrctd_enrt_flag in varchar2 default hr_api.g_varchar2
1009 ,p_bnft_or_option_rstrctn_cd in varchar2 default hr_api.g_varchar2
1010 ,p_cvg_incr_r_decr_only_cd in varchar2 default hr_api.g_varchar2
1011 ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
1012 ,p_pln_attribute_category in varchar2 default hr_api.g_varchar2
1013 ,p_pln_attribute1 in varchar2 default hr_api.g_varchar2
1014 ,p_pln_attribute2 in varchar2 default hr_api.g_varchar2
1015 ,p_pln_attribute3 in varchar2 default hr_api.g_varchar2
1016 ,p_pln_attribute4 in varchar2 default hr_api.g_varchar2
1017 ,p_pln_attribute5 in varchar2 default hr_api.g_varchar2
1018 ,p_pln_attribute6 in varchar2 default hr_api.g_varchar2
1019 ,p_pln_attribute7 in varchar2 default hr_api.g_varchar2
1020 ,p_pln_attribute8 in varchar2 default hr_api.g_varchar2
1021 ,p_pln_attribute9 in varchar2 default hr_api.g_varchar2
1022 ,p_pln_attribute10 in varchar2 default hr_api.g_varchar2
1023 ,p_pln_attribute11 in varchar2 default hr_api.g_varchar2
1024 ,p_pln_attribute12 in varchar2 default hr_api.g_varchar2
1025 ,p_pln_attribute13 in varchar2 default hr_api.g_varchar2
1026 ,p_pln_attribute14 in varchar2 default hr_api.g_varchar2
1027 ,p_pln_attribute15 in varchar2 default hr_api.g_varchar2
1028 ,p_pln_attribute16 in varchar2 default hr_api.g_varchar2
1029 ,p_pln_attribute17 in varchar2 default hr_api.g_varchar2
1030 ,p_pln_attribute18 in varchar2 default hr_api.g_varchar2
1031 ,p_pln_attribute19 in varchar2 default hr_api.g_varchar2
1032 ,p_pln_attribute20 in varchar2 default hr_api.g_varchar2
1033 ,p_pln_attribute21 in varchar2 default hr_api.g_varchar2
1034 ,p_pln_attribute22 in varchar2 default hr_api.g_varchar2
1035 ,p_pln_attribute23 in varchar2 default hr_api.g_varchar2
1036 ,p_pln_attribute24 in varchar2 default hr_api.g_varchar2
1037 ,p_pln_attribute25 in varchar2 default hr_api.g_varchar2
1038 ,p_pln_attribute26 in varchar2 default hr_api.g_varchar2
1039 ,p_pln_attribute27 in varchar2 default hr_api.g_varchar2
1040 ,p_pln_attribute28 in varchar2 default hr_api.g_varchar2
1041 ,p_pln_attribute29 in varchar2 default hr_api.g_varchar2
1042 ,p_pln_attribute30 in varchar2 default hr_api.g_varchar2
1043 ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
1044 ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
1045 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default hr_api.g_varchar2
1046 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default hr_api.g_varchar2
1047 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default hr_api.g_varchar2
1048 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default hr_api.g_varchar2
1049 ,p_susp_if_bnf_ssn_nt_prv_cd in varchar2 default hr_api.g_varchar2
1050 ,p_susp_if_bnf_dob_nt_prv_cd in varchar2 default hr_api.g_varchar2
1051 ,p_susp_if_bnf_adr_nt_prv_cd in varchar2 default hr_api.g_varchar2
1052 ,p_susp_if_ctfn_not_bnf_flag in varchar2 default hr_api.g_varchar2
1053 ,p_dpnt_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
1054 ,p_bnf_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
1055 ,p_object_version_number in out nocopy number
1056 ,p_actl_prem_id in number default hr_api.g_number
1057 ,p_effective_date in date
1058 ,p_datetrack_mode in varchar2
1059 ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
1060 ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
1061 ,p_alws_tmpry_id_crd_flag in varchar2 default hr_api.g_varchar2
1062 ,p_nip_dflt_flag in varchar2 default hr_api.g_varchar2
1063 ,p_frfs_distr_mthd_cd in varchar2 default hr_api.g_varchar2
1064 ,p_frfs_distr_mthd_rl in number default hr_api.g_number
1065 ,p_frfs_cntr_det_cd in varchar2 default hr_api.g_varchar2
1066 ,p_frfs_distr_det_cd in varchar2 default hr_api.g_varchar2
1067 ,p_cost_alloc_keyflex_1_id in number default hr_api.g_number
1068 ,p_cost_alloc_keyflex_2_id in number default hr_api.g_number
1069 ,p_post_to_gl_flag in varchar2 default hr_api.g_varchar2
1070 ,p_frfs_val_det_cd in varchar2 default hr_api.g_varchar2
1074 ,p_short_name in varchar2 default hr_api.g_varchar2
1071 ,p_frfs_mx_cryfwd_val in number default hr_api.g_number
1072 ,p_frfs_portion_det_cd in varchar2 default hr_api.g_varchar2
1073 ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
1075 ,p_short_code in varchar2 default hr_api.g_varchar2
1076 ,p_legislation_code in varchar2 default hr_api.g_varchar2
1077 ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
1078 ,p_group_pl_id in number default hr_api.g_number
1079 ,p_mapping_table_name in varchar2 default hr_api.g_varchar2
1080 ,p_mapping_table_pk_id in number default hr_api.g_number
1081 ,p_function_code in varchar2 default hr_api.g_varchar2
1082 ,p_pl_yr_not_applcbl_flag in varchar2 default hr_api.g_varchar2
1083 ,p_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
1084 ,p_all_inelig in varchar2 default hr_api.g_varchar2
1085 ,p_bnf_exl_participant_flag in varchar2 default hr_api.g_varchar2 --Enh 16043887
1086 ) is
1087 --
1088 -- Declare cursors and local variables
1089 --
1090 l_proc varchar2(72) := g_package||'update_Plan';
1091 l_object_version_number ben_pl_f.object_version_number%TYPE;
1092 l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1093 l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1094 --
1095 begin
1096 --
1097 hr_utility.set_location('Entering:'|| l_proc, 10);
1098 --
1099 -- Issue a savepoint if operating in validation only mode
1100 --
1101 savepoint update_Plan;
1102 --
1103 hr_utility.set_location(l_proc, 20);
1104 --
1105 -- Process Logic
1106 --
1107 l_object_version_number := p_object_version_number;
1108 --
1109 begin
1110 --
1111 -- Start of API User Hook for the before hook of update_Plan
1112 --
1113 ben_Plan_bk2.update_Plan_b
1114 (p_pl_id => p_pl_id
1115 ,p_name => p_name
1116 ,p_alws_qdro_flag => p_alws_qdro_flag
1117 ,p_alws_qmcso_flag => p_alws_qmcso_flag
1118 ,p_alws_reimbmts_flag => p_alws_reimbmts_flag
1119 ,p_bnf_addl_instn_txt_alwd_flag => p_bnf_addl_instn_txt_alwd_flag
1120 ,p_bnf_adrs_rqd_flag => p_bnf_adrs_rqd_flag
1121 ,p_bnf_cntngt_bnfs_alwd_flag => p_bnf_cntngt_bnfs_alwd_flag
1122 ,p_bnf_ctfn_rqd_flag => p_bnf_ctfn_rqd_flag
1123 ,p_bnf_dob_rqd_flag => p_bnf_dob_rqd_flag
1124 ,p_bnf_dsge_mnr_ttee_rqd_flag => p_bnf_dsge_mnr_ttee_rqd_flag
1125 ,p_bnf_incrmt_amt => p_bnf_incrmt_amt
1126 ,p_bnf_dflt_bnf_cd => p_bnf_dflt_bnf_cd
1127 ,p_bnf_legv_id_rqd_flag => p_bnf_legv_id_rqd_flag
1128 ,p_bnf_may_dsgt_org_flag => p_bnf_may_dsgt_org_flag
1129 ,p_bnf_mn_dsgntbl_amt => p_bnf_mn_dsgntbl_amt
1130 ,p_bnf_mn_dsgntbl_pct_val => p_bnf_mn_dsgntbl_pct_val
1131 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
1132 ,p_ordr_num => p_ordr_num
1133 ,p_bnf_pct_incrmt_val => p_bnf_pct_incrmt_val
1134 ,p_bnf_pct_amt_alwd_cd => p_bnf_pct_amt_alwd_cd
1135 ,p_bnf_qdro_rl_apls_flag => p_bnf_qdro_rl_apls_flag
1136 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
1137 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
1138 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
1139 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
1140 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
1141 ,p_elig_apls_flag => p_elig_apls_flag
1142 ,p_invk_dcln_prtn_pl_flag => p_invk_dcln_prtn_pl_flag
1143 ,p_invk_flx_cr_pl_flag => p_invk_flx_cr_pl_flag
1144 ,p_imptd_incm_calc_cd => p_imptd_incm_calc_cd
1145 ,p_drvbl_dpnt_elig_flag => p_drvbl_dpnt_elig_flag
1146 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
1147 ,p_pl_cd => p_pl_cd
1148 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
1149 ,p_ivr_ident => p_ivr_ident
1150 ,p_url_ref_name => p_url_ref_name
1151 ,p_cmpr_clms_to_cvg_or_bal_cd => p_cmpr_clms_to_cvg_or_bal_cd
1152 ,p_cobra_pymt_due_dy_num => p_cobra_pymt_due_dy_num
1153 ,p_dpnt_cvd_by_othr_apls_flag => p_dpnt_cvd_by_othr_apls_flag
1154 ,p_enrt_mthd_cd => p_enrt_mthd_cd
1155 ,p_enrt_cd => p_enrt_cd
1156 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
1157 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
1158 ,p_frfs_aply_flag => p_frfs_aply_flag
1159 ,p_hc_pl_subj_hcfa_aprvl_flag => p_hc_pl_subj_hcfa_aprvl_flag
1160 ,p_hghly_cmpd_rl_apls_flag => p_hghly_cmpd_rl_apls_flag
1161 ,p_incptn_dt => p_incptn_dt
1162 ,p_mn_cvg_rl => p_mn_cvg_rl
1163 ,p_mn_cvg_rqd_amt => p_mn_cvg_rqd_amt
1164 ,p_mn_opts_rqd_num => p_mn_opts_rqd_num
1165 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
1166 ,p_mx_cvg_rl => p_mx_cvg_rl
1167 ,p_mx_opts_alwd_num => p_mx_opts_alwd_num
1168 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
1169 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
1170 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
1171 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
1172 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
1176 ,p_mx_wtg_perd_prte_uom => p_mx_wtg_perd_prte_uom
1173 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
1174 ,p_mx_wtg_dt_to_use_cd => p_mx_wtg_dt_to_use_cd
1175 ,p_mx_wtg_dt_to_use_rl => p_mx_wtg_dt_to_use_rl
1177 ,p_mx_wtg_perd_prte_val => p_mx_wtg_perd_prte_val
1178 ,p_mx_wtg_perd_rl => p_mx_wtg_perd_rl
1179 ,p_nip_dflt_enrt_cd => p_nip_dflt_enrt_cd
1180 ,p_nip_dflt_enrt_det_rl => p_nip_dflt_enrt_det_rl
1181 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
1182 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
1183 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
1184 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
1185 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
1186 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
1187 ,p_dpnt_leg_id_rqd_flag => p_dpnt_leg_id_rqd_flag
1188 ,p_dpnt_no_ctfn_rqd_flag => p_dpnt_no_ctfn_rqd_flag
1189 ,p_no_mn_cvg_amt_apls_flag => p_no_mn_cvg_amt_apls_flag
1190 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
1191 ,p_no_mn_opts_num_apls_flag => p_no_mn_opts_num_apls_flag
1192 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
1193 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
1194 ,p_no_mx_opts_num_apls_flag => p_no_mx_opts_num_apls_flag
1195 ,p_nip_pl_uom => p_nip_pl_uom
1196 ,p_rqd_perd_enrt_nenrt_uom => p_rqd_perd_enrt_nenrt_uom
1197 ,p_nip_acty_ref_perd_cd => p_nip_acty_ref_perd_cd
1198 ,p_nip_enrt_info_rt_freq_cd => p_nip_enrt_info_rt_freq_cd
1199 ,p_per_cvrd_cd => p_per_cvrd_cd
1200 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
1201 ,p_postelcn_edit_rl => p_postelcn_edit_rl
1202 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
1203 ,p_prort_prtl_yr_cvg_rstrn_cd => p_prort_prtl_yr_cvg_rstrn_cd
1204 ,p_prort_prtl_yr_cvg_rstrn_rl => p_prort_prtl_yr_cvg_rstrn_rl
1205 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
1206 ,p_svgs_pl_flag => p_svgs_pl_flag
1207 ,p_subj_to_imptd_incm_typ_cd => p_subj_to_imptd_incm_typ_cd
1208 ,p_use_all_asnts_elig_flag => p_use_all_asnts_elig_flag
1209 ,p_use_all_asnts_for_rt_flag => p_use_all_asnts_for_rt_flag
1210 ,p_vstg_apls_flag => p_vstg_apls_flag
1211 ,p_wvbl_flag => p_wvbl_flag
1212 ,p_hc_svc_typ_cd => p_hc_svc_typ_cd
1213 ,p_pl_stat_cd => p_pl_stat_cd
1214 ,p_prmry_fndg_mthd_cd => p_prmry_fndg_mthd_cd
1215 ,p_rt_end_dt_cd => p_rt_end_dt_cd
1216 ,p_rt_end_dt_rl => p_rt_end_dt_rl
1217 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
1218 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
1219 ,p_bnf_dsgn_cd => p_bnf_dsgn_cd
1220 ,p_pl_typ_id => p_pl_typ_id
1221 ,p_business_group_id => p_business_group_id
1222 ,p_enrt_pl_opt_flag => p_enrt_pl_opt_flag
1223 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
1224 ,p_may_enrl_pl_n_oipl_flag => p_may_enrl_pl_n_oipl_flag
1225 ,p_enrt_rl => p_enrt_rl
1226 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
1227 ,p_alws_unrstrctd_enrt_flag => p_alws_unrstrctd_enrt_flag
1228 ,p_bnft_or_option_rstrctn_cd => p_bnft_or_option_rstrctn_cd
1229 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
1230 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
1231 ,p_pln_attribute_category => p_pln_attribute_category
1232 ,p_pln_attribute1 => p_pln_attribute1
1233 ,p_pln_attribute2 => p_pln_attribute2
1234 ,p_pln_attribute3 => p_pln_attribute3
1235 ,p_pln_attribute4 => p_pln_attribute4
1236 ,p_pln_attribute5 => p_pln_attribute5
1237 ,p_pln_attribute6 => p_pln_attribute6
1238 ,p_pln_attribute7 => p_pln_attribute7
1239 ,p_pln_attribute8 => p_pln_attribute8
1240 ,p_pln_attribute9 => p_pln_attribute9
1241 ,p_pln_attribute10 => p_pln_attribute10
1242 ,p_pln_attribute11 => p_pln_attribute11
1243 ,p_pln_attribute12 => p_pln_attribute12
1244 ,p_pln_attribute13 => p_pln_attribute13
1245 ,p_pln_attribute14 => p_pln_attribute14
1246 ,p_pln_attribute15 => p_pln_attribute15
1247 ,p_pln_attribute16 => p_pln_attribute16
1248 ,p_pln_attribute17 => p_pln_attribute17
1249 ,p_pln_attribute18 => p_pln_attribute18
1250 ,p_pln_attribute19 => p_pln_attribute19
1251 ,p_pln_attribute20 => p_pln_attribute20
1252 ,p_pln_attribute21 => p_pln_attribute21
1253 ,p_pln_attribute22 => p_pln_attribute22
1254 ,p_pln_attribute23 => p_pln_attribute23
1255 ,p_pln_attribute24 => p_pln_attribute24
1256 ,p_pln_attribute25 => p_pln_attribute25
1257 ,p_pln_attribute26 => p_pln_attribute26
1258 ,p_pln_attribute27 => p_pln_attribute27
1259 ,p_pln_attribute28 => p_pln_attribute28
1260 ,p_pln_attribute29 => p_pln_attribute29
1261 ,p_pln_attribute30 => p_pln_attribute30
1265 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
1262 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
1263 ,p_ctfn_determine_cd => p_ctfn_determine_cd
1264 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
1266 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
1267 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
1268 ,p_susp_if_bnf_ssn_nt_prv_cd => p_susp_if_bnf_ssn_nt_prv_cd
1269 ,p_susp_if_bnf_dob_nt_prv_cd => p_susp_if_bnf_dob_nt_prv_cd
1270 ,p_susp_if_bnf_adr_nt_prv_cd => p_susp_if_bnf_adr_nt_prv_cd
1271 ,p_susp_if_ctfn_not_bnf_flag => p_susp_if_ctfn_not_bnf_flag
1272 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
1273 ,p_bnf_ctfn_determine_cd => p_bnf_ctfn_determine_cd
1274 ,p_object_version_number => p_object_version_number
1275 ,p_actl_prem_id => p_actl_prem_id
1276 ,p_effective_date => trunc(p_effective_date)
1277 ,p_datetrack_mode => p_datetrack_mode
1278 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
1279 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
1280 ,p_alws_tmpry_id_crd_flag => p_alws_tmpry_id_crd_flag
1281 ,p_nip_dflt_flag => p_nip_dflt_flag
1282 ,p_frfs_distr_mthd_cd => p_frfs_distr_mthd_cd
1283 ,p_frfs_distr_mthd_rl => p_frfs_distr_mthd_rl
1284 ,p_frfs_cntr_det_cd => p_frfs_cntr_det_cd
1285 ,p_frfs_distr_det_cd => p_frfs_distr_det_cd
1286 ,p_cost_alloc_keyflex_1_id => p_cost_alloc_keyflex_1_id
1287 ,p_cost_alloc_keyflex_2_id => p_cost_alloc_keyflex_2_id
1288 ,p_post_to_gl_flag => p_post_to_gl_flag
1289 ,p_frfs_val_det_cd => p_frfs_val_det_cd
1290 ,p_frfs_mx_cryfwd_val => p_frfs_mx_cryfwd_val
1291 ,p_frfs_portion_det_cd => p_frfs_portion_det_cd
1292 ,p_bndry_perd_cd => p_bndry_perd_cd
1293 ,p_short_name => p_short_name
1294 ,p_short_code => p_short_code
1295 ,p_legislation_code => p_legislation_code
1296 ,p_legislation_subgroup => p_legislation_subgroup
1297 ,p_group_pl_id => p_group_pl_id
1298 ,p_mapping_table_name => p_mapping_table_name
1299 ,p_mapping_table_pk_id => p_mapping_table_pk_id
1300 ,p_function_code => p_function_code
1301 ,p_pl_yr_not_applcbl_flag => p_pl_yr_not_applcbl_flag
1302 ,p_use_csd_rsd_prccng_cd => p_use_csd_rsd_prccng_cd
1303 ,p_all_inelig => p_all_inelig
1304 ,p_bnf_exl_participant_flag => p_bnf_exl_participant_flag --Enh 16043887
1305 );
1306 exception
1307 when hr_api.cannot_find_prog_unit then
1308 hr_api.cannot_find_prog_unit_error
1309 (p_module_name => 'UPDATE_Plan'
1310 ,p_hook_type => 'BP'
1311 );
1312 --
1313 -- End of API User Hook for the before hook of update_Plan
1314 --
1315 end;
1316 --
1317 ben_pln_upd.upd
1318 (
1319 p_pl_id => p_pl_id
1320 ,p_effective_start_date => l_effective_start_date
1321 ,p_effective_end_date => l_effective_end_date
1322 ,p_name => p_name
1323 ,p_alws_qdro_flag => p_alws_qdro_flag
1324 ,p_alws_qmcso_flag => p_alws_qmcso_flag
1325 ,p_alws_reimbmts_flag => p_alws_reimbmts_flag
1326 ,p_bnf_addl_instn_txt_alwd_flag => p_bnf_addl_instn_txt_alwd_flag
1327 ,p_bnf_adrs_rqd_flag => p_bnf_adrs_rqd_flag
1328 ,p_bnf_cntngt_bnfs_alwd_flag => p_bnf_cntngt_bnfs_alwd_flag
1329 ,p_bnf_ctfn_rqd_flag => p_bnf_ctfn_rqd_flag
1330 ,p_bnf_dob_rqd_flag => p_bnf_dob_rqd_flag
1331 ,p_bnf_dsge_mnr_ttee_rqd_flag => p_bnf_dsge_mnr_ttee_rqd_flag
1332 ,p_bnf_incrmt_amt => p_bnf_incrmt_amt
1333 ,p_bnf_dflt_bnf_cd => p_bnf_dflt_bnf_cd
1334 ,p_bnf_legv_id_rqd_flag => p_bnf_legv_id_rqd_flag
1335 ,p_bnf_may_dsgt_org_flag => p_bnf_may_dsgt_org_flag
1336 ,p_bnf_mn_dsgntbl_amt => p_bnf_mn_dsgntbl_amt
1337 ,p_bnf_mn_dsgntbl_pct_val => p_bnf_mn_dsgntbl_pct_val
1338 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
1339 ,p_ordr_num => p_ordr_num
1340 ,p_bnf_pct_incrmt_val => p_bnf_pct_incrmt_val
1341 ,p_bnf_pct_amt_alwd_cd => p_bnf_pct_amt_alwd_cd
1342 ,p_bnf_qdro_rl_apls_flag => p_bnf_qdro_rl_apls_flag
1343 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
1344 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
1345 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
1346 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
1347 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
1348 ,p_elig_apls_flag => p_elig_apls_flag
1349 ,p_invk_dcln_prtn_pl_flag => p_invk_dcln_prtn_pl_flag
1350 ,p_invk_flx_cr_pl_flag => p_invk_flx_cr_pl_flag
1351 ,p_imptd_incm_calc_cd => p_imptd_incm_calc_cd
1352 ,p_drvbl_dpnt_elig_flag => p_drvbl_dpnt_elig_flag
1353 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
1354 ,p_pl_cd => p_pl_cd
1355 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
1356 ,p_ivr_ident => p_ivr_ident
1357 ,p_url_ref_name => p_url_ref_name
1361 ,p_enrt_mthd_cd => p_enrt_mthd_cd
1358 ,p_cmpr_clms_to_cvg_or_bal_cd => p_cmpr_clms_to_cvg_or_bal_cd
1359 ,p_cobra_pymt_due_dy_num => p_cobra_pymt_due_dy_num
1360 ,p_dpnt_cvd_by_othr_apls_flag => p_dpnt_cvd_by_othr_apls_flag
1362 ,p_enrt_cd => p_enrt_cd
1363 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
1364 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
1365 ,p_frfs_aply_flag => p_frfs_aply_flag
1366 ,p_hc_pl_subj_hcfa_aprvl_flag => p_hc_pl_subj_hcfa_aprvl_flag
1367 ,p_hghly_cmpd_rl_apls_flag => p_hghly_cmpd_rl_apls_flag
1368 ,p_incptn_dt => p_incptn_dt
1369 ,p_mn_cvg_rl => p_mn_cvg_rl
1370 ,p_mn_cvg_rqd_amt => p_mn_cvg_rqd_amt
1371 ,p_mn_opts_rqd_num => p_mn_opts_rqd_num
1372 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
1373 ,p_mx_cvg_rl => p_mx_cvg_rl
1374 ,p_mx_opts_alwd_num => p_mx_opts_alwd_num
1375 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
1376 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
1377 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
1378 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
1379 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
1380 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
1381 ,p_mx_wtg_dt_to_use_cd => p_mx_wtg_dt_to_use_cd
1382 ,p_mx_wtg_dt_to_use_rl => p_mx_wtg_dt_to_use_rl
1383 ,p_mx_wtg_perd_prte_uom => p_mx_wtg_perd_prte_uom
1384 ,p_mx_wtg_perd_prte_val => p_mx_wtg_perd_prte_val
1385 ,p_mx_wtg_perd_rl => p_mx_wtg_perd_rl
1386 ,p_nip_dflt_enrt_cd => p_nip_dflt_enrt_cd
1387 ,p_nip_dflt_enrt_det_rl => p_nip_dflt_enrt_det_rl
1388 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
1389 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
1390 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
1391 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
1392 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
1393 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
1394 ,p_dpnt_leg_id_rqd_flag => p_dpnt_leg_id_rqd_flag
1395 ,p_dpnt_no_ctfn_rqd_flag => p_dpnt_no_ctfn_rqd_flag
1396 ,p_no_mn_cvg_amt_apls_flag => p_no_mn_cvg_amt_apls_flag
1397 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
1398 ,p_no_mn_opts_num_apls_flag => p_no_mn_opts_num_apls_flag
1399 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
1400 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
1401 ,p_no_mx_opts_num_apls_flag => p_no_mx_opts_num_apls_flag
1402 ,p_nip_pl_uom => p_nip_pl_uom
1403 ,p_rqd_perd_enrt_nenrt_uom => p_rqd_perd_enrt_nenrt_uom
1404 ,p_nip_acty_ref_perd_cd => p_nip_acty_ref_perd_cd
1405 ,p_nip_enrt_info_rt_freq_cd => p_nip_enrt_info_rt_freq_cd
1406 ,p_per_cvrd_cd => p_per_cvrd_cd
1407 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
1408 ,p_postelcn_edit_rl => p_postelcn_edit_rl
1409 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
1410 ,p_prort_prtl_yr_cvg_rstrn_cd => p_prort_prtl_yr_cvg_rstrn_cd
1411 ,p_prort_prtl_yr_cvg_rstrn_rl => p_prort_prtl_yr_cvg_rstrn_rl
1412 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
1413 ,p_svgs_pl_flag => p_svgs_pl_flag
1414 ,p_subj_to_imptd_incm_typ_cd => p_subj_to_imptd_incm_typ_cd
1415 ,p_use_all_asnts_elig_flag => p_use_all_asnts_elig_flag
1416 ,p_use_all_asnts_for_rt_flag => p_use_all_asnts_for_rt_flag
1417 ,p_vstg_apls_flag => p_vstg_apls_flag
1418 ,p_wvbl_flag => p_wvbl_flag
1419 ,p_hc_svc_typ_cd => p_hc_svc_typ_cd
1420 ,p_pl_stat_cd => p_pl_stat_cd
1421 ,p_prmry_fndg_mthd_cd => p_prmry_fndg_mthd_cd
1422 ,p_rt_end_dt_cd => p_rt_end_dt_cd
1423 ,p_rt_end_dt_rl => p_rt_end_dt_rl
1424 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
1425 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
1426 ,p_bnf_dsgn_cd => p_bnf_dsgn_cd
1427 ,p_pl_typ_id => p_pl_typ_id
1428 ,p_business_group_id => p_business_group_id
1429 ,p_enrt_pl_opt_flag => p_enrt_pl_opt_flag
1430 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
1431 ,p_may_enrl_pl_n_oipl_flag => p_may_enrl_pl_n_oipl_flag
1432 ,p_enrt_rl => p_enrt_rl
1433 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
1434 ,p_alws_unrstrctd_enrt_flag => p_alws_unrstrctd_enrt_flag
1435 ,p_bnft_or_option_rstrctn_cd => p_bnft_or_option_rstrctn_cd
1436 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
1437 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
1438 ,p_pln_attribute_category => p_pln_attribute_category
1439 ,p_pln_attribute1 => p_pln_attribute1
1440 ,p_pln_attribute2 => p_pln_attribute2
1441 ,p_pln_attribute3 => p_pln_attribute3
1442 ,p_pln_attribute4 => p_pln_attribute4
1443 ,p_pln_attribute5 => p_pln_attribute5
1444 ,p_pln_attribute6 => p_pln_attribute6
1445 ,p_pln_attribute7 => p_pln_attribute7
1446 ,p_pln_attribute8 => p_pln_attribute8
1447 ,p_pln_attribute9 => p_pln_attribute9
1448 ,p_pln_attribute10 => p_pln_attribute10
1449 ,p_pln_attribute11 => p_pln_attribute11
1450 ,p_pln_attribute12 => p_pln_attribute12
1454 ,p_pln_attribute16 => p_pln_attribute16
1451 ,p_pln_attribute13 => p_pln_attribute13
1452 ,p_pln_attribute14 => p_pln_attribute14
1453 ,p_pln_attribute15 => p_pln_attribute15
1455 ,p_pln_attribute17 => p_pln_attribute17
1456 ,p_pln_attribute18 => p_pln_attribute18
1457 ,p_pln_attribute19 => p_pln_attribute19
1458 ,p_pln_attribute20 => p_pln_attribute20
1459 ,p_pln_attribute21 => p_pln_attribute21
1460 ,p_pln_attribute22 => p_pln_attribute22
1461 ,p_pln_attribute23 => p_pln_attribute23
1462 ,p_pln_attribute24 => p_pln_attribute24
1463 ,p_pln_attribute25 => p_pln_attribute25
1464 ,p_pln_attribute26 => p_pln_attribute26
1465 ,p_pln_attribute27 => p_pln_attribute27
1466 ,p_pln_attribute28 => p_pln_attribute28
1467 ,p_pln_attribute29 => p_pln_attribute29
1468 ,p_pln_attribute30 => p_pln_attribute30
1469 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
1470 ,p_ctfn_determine_cd => p_ctfn_determine_cd
1471 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
1472 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
1473 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
1474 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
1475 ,p_susp_if_bnf_ssn_nt_prv_cd => p_susp_if_bnf_ssn_nt_prv_cd
1476 ,p_susp_if_bnf_dob_nt_prv_cd => p_susp_if_bnf_dob_nt_prv_cd
1477 ,p_susp_if_bnf_adr_nt_prv_cd => p_susp_if_bnf_adr_nt_prv_cd
1478 ,p_susp_if_ctfn_not_bnf_flag => p_susp_if_ctfn_not_bnf_flag
1479 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
1480 ,p_bnf_ctfn_determine_cd => p_bnf_ctfn_determine_cd
1481 ,p_object_version_number => l_object_version_number
1482 ,p_actl_prem_id => p_actl_prem_id
1483 ,p_effective_date => trunc(p_effective_date)
1484 ,p_datetrack_mode => p_datetrack_mode
1485 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
1486 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
1487 ,p_alws_tmpry_id_crd_flag => p_alws_tmpry_id_crd_flag
1488 ,p_nip_dflt_flag => p_nip_dflt_flag
1489 ,p_frfs_distr_mthd_cd => p_frfs_distr_mthd_cd
1490 ,p_frfs_distr_mthd_rl => p_frfs_distr_mthd_rl
1491 ,p_frfs_cntr_det_cd => p_frfs_cntr_det_cd
1492 ,p_frfs_distr_det_cd => p_frfs_distr_det_cd
1493 ,p_cost_alloc_keyflex_1_id => p_cost_alloc_keyflex_1_id
1494 ,p_cost_alloc_keyflex_2_id => p_cost_alloc_keyflex_2_id
1495 ,p_post_to_gl_flag => p_post_to_gl_flag
1496 ,p_frfs_val_det_cd => p_frfs_val_det_cd
1497 ,p_frfs_mx_cryfwd_val => p_frfs_mx_cryfwd_val
1498 ,p_frfs_portion_det_cd => p_frfs_portion_det_cd
1499 ,p_bndry_perd_cd => p_bndry_perd_cd
1500 ,p_short_name => p_short_name
1501 ,p_short_code => p_short_code
1502 ,p_legislation_code => p_legislation_code
1503 ,p_legislation_subgroup => p_legislation_subgroup
1504 ,p_group_pl_id => p_group_pl_id
1505 ,p_mapping_table_name => p_mapping_table_name
1506 ,p_mapping_table_pk_id => p_mapping_table_pk_id
1507 ,p_function_code => p_function_code
1508 ,p_pl_yr_not_applcbl_flag => p_pl_yr_not_applcbl_flag
1509 ,p_use_csd_rsd_prccng_cd => p_use_csd_rsd_prccng_cd
1510 ,p_all_inelig => p_all_inelig
1511 ,p_bnf_exl_participant_flag => p_bnf_exl_participant_flag --Enh 16043887
1512 );
1513 --
1514 --
1515 begin
1516 --
1517 -- Start of API User Hook for the after hook of update_Plan
1518 --
1519 ben_Plan_bk2.update_Plan_a
1520 (
1521 p_pl_id => p_pl_id
1522 ,p_effective_start_date => l_effective_start_date
1523 ,p_effective_end_date => l_effective_end_date
1524 ,p_name => p_name
1525 ,p_alws_qdro_flag => p_alws_qdro_flag
1526 ,p_alws_qmcso_flag => p_alws_qmcso_flag
1527 ,p_alws_reimbmts_flag => p_alws_reimbmts_flag
1528 ,p_bnf_addl_instn_txt_alwd_flag => p_bnf_addl_instn_txt_alwd_flag
1529 ,p_bnf_adrs_rqd_flag => p_bnf_adrs_rqd_flag
1530 ,p_bnf_cntngt_bnfs_alwd_flag => p_bnf_cntngt_bnfs_alwd_flag
1531 ,p_bnf_ctfn_rqd_flag => p_bnf_ctfn_rqd_flag
1532 ,p_bnf_dob_rqd_flag => p_bnf_dob_rqd_flag
1533 ,p_bnf_dsge_mnr_ttee_rqd_flag => p_bnf_dsge_mnr_ttee_rqd_flag
1534 ,p_bnf_incrmt_amt => p_bnf_incrmt_amt
1535 ,p_bnf_dflt_bnf_cd => p_bnf_dflt_bnf_cd
1536 ,p_bnf_legv_id_rqd_flag => p_bnf_legv_id_rqd_flag
1537 ,p_bnf_may_dsgt_org_flag => p_bnf_may_dsgt_org_flag
1538 ,p_bnf_mn_dsgntbl_amt => p_bnf_mn_dsgntbl_amt
1539 ,p_bnf_mn_dsgntbl_pct_val => p_bnf_mn_dsgntbl_pct_val
1540 ,p_rqd_perd_enrt_nenrt_val => p_rqd_perd_enrt_nenrt_val
1541 ,p_ordr_num => p_ordr_num
1542 ,p_bnf_pct_incrmt_val => p_bnf_pct_incrmt_val
1543 ,p_bnf_pct_amt_alwd_cd => p_bnf_pct_amt_alwd_cd
1544 ,p_bnf_qdro_rl_apls_flag => p_bnf_qdro_rl_apls_flag
1545 ,p_dflt_to_asn_pndg_ctfn_cd => p_dflt_to_asn_pndg_ctfn_cd
1549 ,p_dpnt_dsgn_cd => p_dpnt_dsgn_cd
1546 ,p_dflt_to_asn_pndg_ctfn_rl => p_dflt_to_asn_pndg_ctfn_rl
1547 ,p_drvbl_fctr_apls_rts_flag => p_drvbl_fctr_apls_rts_flag
1548 ,p_drvbl_fctr_prtn_elig_flag => p_drvbl_fctr_prtn_elig_flag
1550 ,p_elig_apls_flag => p_elig_apls_flag
1551 ,p_invk_dcln_prtn_pl_flag => p_invk_dcln_prtn_pl_flag
1552 ,p_invk_flx_cr_pl_flag => p_invk_flx_cr_pl_flag
1553 ,p_imptd_incm_calc_cd => p_imptd_incm_calc_cd
1554 ,p_drvbl_dpnt_elig_flag => p_drvbl_dpnt_elig_flag
1555 ,p_trk_inelig_per_flag => p_trk_inelig_per_flag
1556 ,p_pl_cd => p_pl_cd
1557 ,p_auto_enrt_mthd_rl => p_auto_enrt_mthd_rl
1558 ,p_ivr_ident => p_ivr_ident
1559 ,p_url_ref_name => p_url_ref_name
1560 ,p_cmpr_clms_to_cvg_or_bal_cd => p_cmpr_clms_to_cvg_or_bal_cd
1561 ,p_cobra_pymt_due_dy_num => p_cobra_pymt_due_dy_num
1562 ,p_dpnt_cvd_by_othr_apls_flag => p_dpnt_cvd_by_othr_apls_flag
1563 ,p_enrt_mthd_cd => p_enrt_mthd_cd
1564 ,p_enrt_cd => p_enrt_cd
1565 ,p_enrt_cvg_strt_dt_cd => p_enrt_cvg_strt_dt_cd
1566 ,p_enrt_cvg_end_dt_cd => p_enrt_cvg_end_dt_cd
1567 ,p_frfs_aply_flag => p_frfs_aply_flag
1568 ,p_hc_pl_subj_hcfa_aprvl_flag => p_hc_pl_subj_hcfa_aprvl_flag
1569 ,p_hghly_cmpd_rl_apls_flag => p_hghly_cmpd_rl_apls_flag
1570 ,p_incptn_dt => p_incptn_dt
1571 ,p_mn_cvg_rl => p_mn_cvg_rl
1572 ,p_mn_cvg_rqd_amt => p_mn_cvg_rqd_amt
1573 ,p_mn_opts_rqd_num => p_mn_opts_rqd_num
1574 ,p_mx_cvg_alwd_amt => p_mx_cvg_alwd_amt
1575 ,p_mx_cvg_rl => p_mx_cvg_rl
1576 ,p_mx_opts_alwd_num => p_mx_opts_alwd_num
1577 ,p_mx_cvg_wcfn_mlt_num => p_mx_cvg_wcfn_mlt_num
1578 ,p_mx_cvg_wcfn_amt => p_mx_cvg_wcfn_amt
1579 ,p_mx_cvg_incr_alwd_amt => p_mx_cvg_incr_alwd_amt
1580 ,p_mx_cvg_incr_wcf_alwd_amt => p_mx_cvg_incr_wcf_alwd_amt
1581 ,p_mx_cvg_mlt_incr_num => p_mx_cvg_mlt_incr_num
1582 ,p_mx_cvg_mlt_incr_wcf_num => p_mx_cvg_mlt_incr_wcf_num
1583 ,p_mx_wtg_dt_to_use_cd => p_mx_wtg_dt_to_use_cd
1584 ,p_mx_wtg_dt_to_use_rl => p_mx_wtg_dt_to_use_rl
1585 ,p_mx_wtg_perd_prte_uom => p_mx_wtg_perd_prte_uom
1586 ,p_mx_wtg_perd_prte_val => p_mx_wtg_perd_prte_val
1587 ,p_mx_wtg_perd_rl => p_mx_wtg_perd_rl
1588 ,p_nip_dflt_enrt_cd => p_nip_dflt_enrt_cd
1589 ,p_nip_dflt_enrt_det_rl => p_nip_dflt_enrt_det_rl
1590 ,p_dpnt_adrs_rqd_flag => p_dpnt_adrs_rqd_flag
1591 ,p_dpnt_cvg_end_dt_cd => p_dpnt_cvg_end_dt_cd
1592 ,p_dpnt_cvg_end_dt_rl => p_dpnt_cvg_end_dt_rl
1593 ,p_dpnt_cvg_strt_dt_cd => p_dpnt_cvg_strt_dt_cd
1594 ,p_dpnt_cvg_strt_dt_rl => p_dpnt_cvg_strt_dt_rl
1595 ,p_dpnt_dob_rqd_flag => p_dpnt_dob_rqd_flag
1596 ,p_dpnt_leg_id_rqd_flag => p_dpnt_leg_id_rqd_flag
1597 ,p_dpnt_no_ctfn_rqd_flag => p_dpnt_no_ctfn_rqd_flag
1598 ,p_no_mn_cvg_amt_apls_flag => p_no_mn_cvg_amt_apls_flag
1599 ,p_no_mn_cvg_incr_apls_flag => p_no_mn_cvg_incr_apls_flag
1600 ,p_no_mn_opts_num_apls_flag => p_no_mn_opts_num_apls_flag
1601 ,p_no_mx_cvg_amt_apls_flag => p_no_mx_cvg_amt_apls_flag
1602 ,p_no_mx_cvg_incr_apls_flag => p_no_mx_cvg_incr_apls_flag
1603 ,p_no_mx_opts_num_apls_flag => p_no_mx_opts_num_apls_flag
1604 ,p_nip_pl_uom => p_nip_pl_uom
1605 ,p_rqd_perd_enrt_nenrt_uom => p_rqd_perd_enrt_nenrt_uom
1606 ,p_nip_acty_ref_perd_cd => p_nip_acty_ref_perd_cd
1607 ,p_nip_enrt_info_rt_freq_cd => p_nip_enrt_info_rt_freq_cd
1608 ,p_per_cvrd_cd => p_per_cvrd_cd
1609 ,p_enrt_cvg_end_dt_rl => p_enrt_cvg_end_dt_rl
1610 ,p_postelcn_edit_rl => p_postelcn_edit_rl
1611 ,p_enrt_cvg_strt_dt_rl => p_enrt_cvg_strt_dt_rl
1612 ,p_prort_prtl_yr_cvg_rstrn_cd => p_prort_prtl_yr_cvg_rstrn_cd
1613 ,p_prort_prtl_yr_cvg_rstrn_rl => p_prort_prtl_yr_cvg_rstrn_rl
1614 ,p_prtn_elig_ovrid_alwd_flag => p_prtn_elig_ovrid_alwd_flag
1615 ,p_svgs_pl_flag => p_svgs_pl_flag
1616 ,p_subj_to_imptd_incm_typ_cd => p_subj_to_imptd_incm_typ_cd
1617 ,p_use_all_asnts_elig_flag => p_use_all_asnts_elig_flag
1618 ,p_use_all_asnts_for_rt_flag => p_use_all_asnts_for_rt_flag
1619 ,p_vstg_apls_flag => p_vstg_apls_flag
1620 ,p_wvbl_flag => p_wvbl_flag
1621 ,p_hc_svc_typ_cd => p_hc_svc_typ_cd
1622 ,p_pl_stat_cd => p_pl_stat_cd
1623 ,p_prmry_fndg_mthd_cd => p_prmry_fndg_mthd_cd
1624 ,p_rt_end_dt_cd => p_rt_end_dt_cd
1625 ,p_rt_end_dt_rl => p_rt_end_dt_rl
1626 ,p_rt_strt_dt_rl => p_rt_strt_dt_rl
1627 ,p_rt_strt_dt_cd => p_rt_strt_dt_cd
1628 ,p_bnf_dsgn_cd => p_bnf_dsgn_cd
1629 ,p_pl_typ_id => p_pl_typ_id
1630 ,p_business_group_id => p_business_group_id
1631 ,p_enrt_pl_opt_flag => p_enrt_pl_opt_flag
1632 ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
1633 ,p_may_enrl_pl_n_oipl_flag => p_may_enrl_pl_n_oipl_flag
1634 ,p_enrt_rl => p_enrt_rl
1638 ,p_cvg_incr_r_decr_only_cd => p_cvg_incr_r_decr_only_cd
1635 ,p_rqd_perd_enrt_nenrt_rl => p_rqd_perd_enrt_nenrt_rl
1636 ,p_alws_unrstrctd_enrt_flag => p_alws_unrstrctd_enrt_flag
1637 ,p_bnft_or_option_rstrctn_cd => p_bnft_or_option_rstrctn_cd
1639 ,p_unsspnd_enrt_cd => p_unsspnd_enrt_cd
1640 ,p_pln_attribute_category => p_pln_attribute_category
1641 ,p_pln_attribute1 => p_pln_attribute1
1642 ,p_pln_attribute2 => p_pln_attribute2
1643 ,p_pln_attribute3 => p_pln_attribute3
1644 ,p_pln_attribute4 => p_pln_attribute4
1645 ,p_pln_attribute5 => p_pln_attribute5
1646 ,p_pln_attribute6 => p_pln_attribute6
1647 ,p_pln_attribute7 => p_pln_attribute7
1648 ,p_pln_attribute8 => p_pln_attribute8
1649 ,p_pln_attribute9 => p_pln_attribute9
1650 ,p_pln_attribute10 => p_pln_attribute10
1651 ,p_pln_attribute11 => p_pln_attribute11
1652 ,p_pln_attribute12 => p_pln_attribute12
1653 ,p_pln_attribute13 => p_pln_attribute13
1654 ,p_pln_attribute14 => p_pln_attribute14
1655 ,p_pln_attribute15 => p_pln_attribute15
1656 ,p_pln_attribute16 => p_pln_attribute16
1657 ,p_pln_attribute17 => p_pln_attribute17
1658 ,p_pln_attribute18 => p_pln_attribute18
1659 ,p_pln_attribute19 => p_pln_attribute19
1660 ,p_pln_attribute20 => p_pln_attribute20
1661 ,p_pln_attribute21 => p_pln_attribute21
1662 ,p_pln_attribute22 => p_pln_attribute22
1663 ,p_pln_attribute23 => p_pln_attribute23
1664 ,p_pln_attribute24 => p_pln_attribute24
1665 ,p_pln_attribute25 => p_pln_attribute25
1666 ,p_pln_attribute26 => p_pln_attribute26
1667 ,p_pln_attribute27 => p_pln_attribute27
1668 ,p_pln_attribute28 => p_pln_attribute28
1669 ,p_pln_attribute29 => p_pln_attribute29
1670 ,p_pln_attribute30 => p_pln_attribute30
1671 ,p_susp_if_ctfn_not_prvd_flag => p_susp_if_ctfn_not_prvd_flag
1672 ,p_ctfn_determine_cd => p_ctfn_determine_cd
1673 ,p_susp_if_dpnt_ssn_nt_prv_cd => p_susp_if_dpnt_ssn_nt_prv_cd
1674 ,p_susp_if_dpnt_dob_nt_prv_cd => p_susp_if_dpnt_dob_nt_prv_cd
1675 ,p_susp_if_dpnt_adr_nt_prv_cd => p_susp_if_dpnt_adr_nt_prv_cd
1676 ,p_susp_if_ctfn_not_dpnt_flag => p_susp_if_ctfn_not_dpnt_flag
1677 ,p_susp_if_bnf_ssn_nt_prv_cd => p_susp_if_bnf_ssn_nt_prv_cd
1678 ,p_susp_if_bnf_dob_nt_prv_cd => p_susp_if_bnf_dob_nt_prv_cd
1679 ,p_susp_if_bnf_adr_nt_prv_cd => p_susp_if_bnf_adr_nt_prv_cd
1680 ,p_susp_if_ctfn_not_bnf_flag => p_susp_if_ctfn_not_bnf_flag
1681 ,p_dpnt_ctfn_determine_cd => p_dpnt_ctfn_determine_cd
1682 ,p_bnf_ctfn_determine_cd => p_bnf_ctfn_determine_cd
1683 ,p_object_version_number => l_object_version_number
1684 ,p_actl_prem_id => p_actl_prem_id
1685 ,p_effective_date => trunc(p_effective_date)
1686 ,p_datetrack_mode => p_datetrack_mode
1687 ,p_vrfy_fmly_mmbr_cd => p_vrfy_fmly_mmbr_cd
1688 ,p_vrfy_fmly_mmbr_rl => p_vrfy_fmly_mmbr_rl
1689 ,p_alws_tmpry_id_crd_flag => p_alws_tmpry_id_crd_flag
1690 ,p_nip_dflt_flag => p_nip_dflt_flag
1691 ,p_frfs_distr_mthd_cd => p_frfs_distr_mthd_cd
1692 ,p_frfs_distr_mthd_rl => p_frfs_distr_mthd_rl
1693 ,p_frfs_cntr_det_cd => p_frfs_cntr_det_cd
1694 ,p_frfs_distr_det_cd => p_frfs_distr_det_cd
1695 ,p_cost_alloc_keyflex_1_id => p_cost_alloc_keyflex_1_id
1696 ,p_cost_alloc_keyflex_2_id => p_cost_alloc_keyflex_2_id
1697 ,p_post_to_gl_flag => p_post_to_gl_flag
1698 ,p_frfs_val_det_cd => p_frfs_val_det_cd
1699 ,p_frfs_mx_cryfwd_val => p_frfs_mx_cryfwd_val
1700 ,p_frfs_portion_det_cd => p_frfs_portion_det_cd
1701 ,p_bndry_perd_cd => p_bndry_perd_cd
1702 ,p_short_name => p_short_name
1703 ,p_short_code => p_short_code
1704 ,p_legislation_code => p_legislation_code
1705 ,p_legislation_subgroup => p_legislation_subgroup
1706 ,p_group_pl_id => p_group_pl_id
1707 ,p_mapping_table_name => p_mapping_table_name
1708 ,p_mapping_table_pk_id => p_mapping_table_pk_id
1709 ,p_function_code => p_function_code
1710 ,p_pl_yr_not_applcbl_flag => p_pl_yr_not_applcbl_flag
1711 ,p_use_csd_rsd_prccng_cd => p_use_csd_rsd_prccng_cd
1712 ,p_all_inelig => p_all_inelig
1713 ,p_bnf_exl_participant_flag => p_bnf_exl_participant_flag --Enh 16043887
1714 );
1715 exception
1716 when hr_api.cannot_find_prog_unit then
1717 hr_api.cannot_find_prog_unit_error
1718 (p_module_name => 'UPDATE_Plan'
1719 ,p_hook_type => 'AP'
1720 );
1721 --
1722 -- End of API User Hook for the after hook of update_Plan
1723 --
1724 end;
1725 --
1726 hr_utility.set_location(l_proc, 60);
1727 --
1728 -- When in validation only mode raise the Validate_Enabled exception
1729 --
1730 if p_validate then
1731 raise hr_api.validate_enabled;
1732 end if;
1733 --
1734 -- Set all output arguments
1735 --
1736 p_object_version_number := l_object_version_number;
1740 hr_utility.set_location(' Leaving:'||l_proc, 70);
1737 p_effective_start_date := l_effective_start_date;
1738 p_effective_end_date := l_effective_end_date;
1739 --
1741 --
1742 exception
1743 --
1744 when hr_api.validate_enabled then
1745 --
1746 -- As the Validate_Enabled exception has been raised
1747 -- we must rollback to the savepoint
1748 --
1749 ROLLBACK TO update_Plan;
1750 --
1751 -- Only set output warning arguments
1752 -- (Any key or derived arguments must be set to null
1753 -- when validation only mode is being used.)
1754 --
1755 hr_utility.set_location(' Leaving:'||l_proc, 80);
1756 --
1757 when others then
1758 --
1759 -- A validation or unexpected error has occured
1760 --
1761 ROLLBACK TO update_Plan;
1762 /* Inserted for nocopy changes */
1763 p_object_version_number := l_object_version_number;
1764 p_effective_start_date := null;
1765 p_effective_end_date := null;
1766 raise;
1767 --
1768 end update_Plan;
1769 -- ----------------------------------------------------------------------------
1770 -- |------------------------< delete_Plan >----------------------|
1771 -- ----------------------------------------------------------------------------
1772 --
1773 procedure delete_Plan
1774 (p_validate in boolean default false
1775 ,p_pl_id in number
1776 ,p_effective_start_date out nocopy date
1777 ,p_effective_end_date out nocopy date
1778 ,p_object_version_number in out nocopy number
1779 ,p_effective_date in date
1780 ,p_datetrack_mode in varchar2
1781 ) is
1782 --
1783 -- Declare cursors and local variables
1784 --
1785 l_proc varchar2(72) := g_package||'update_Plan';
1786 l_object_version_number ben_pl_f.object_version_number%TYPE;
1787 l_effective_start_date ben_pl_f.effective_start_date%TYPE;
1788 l_effective_end_date ben_pl_f.effective_end_date%TYPE;
1789 --
1790 begin
1791 --
1792 hr_utility.set_location('Entering:'|| l_proc, 10);
1793 --
1794 -- Issue a savepoint if operating in validation only mode
1795 --
1796 savepoint delete_Plan;
1797 --
1798 hr_utility.set_location(l_proc, 20);
1799 --
1800 -- Process Logic
1801 --
1802 l_object_version_number := p_object_version_number;
1803 --
1804 --
1805 begin
1806 --
1807 -- Start of API User Hook for the before hook of delete_Plan
1808 --
1809 ben_Plan_bk3.delete_Plan_b
1810 (
1811 p_pl_id => p_pl_id
1815 );
1812 ,p_object_version_number => p_object_version_number
1813 ,p_effective_date => trunc(p_effective_date)
1814 ,p_datetrack_mode => p_datetrack_mode
1816 exception
1817 when hr_api.cannot_find_prog_unit then
1818 hr_api.cannot_find_prog_unit_error
1819 (p_module_name => 'DELETE_Plan'
1820 ,p_hook_type => 'BP'
1821 );
1822 --
1823 -- End of API User Hook for the before hook of delete_Plan
1824 --
1825 end;
1826 --
1827 ben_pln_del.del
1828 (
1829 p_pl_id => p_pl_id
1830 ,p_effective_start_date => l_effective_start_date
1831 ,p_effective_end_date => l_effective_end_date
1832 ,p_object_version_number => l_object_version_number
1833 ,p_effective_date => p_effective_date
1834 ,p_datetrack_mode => p_datetrack_mode
1835 );
1836 --
1837 begin
1838 --
1839 -- Start of API User Hook for the after hook of delete_Plan
1840 --
1841 ben_Plan_bk3.delete_Plan_a
1842 (p_pl_id => p_pl_id
1843 ,p_effective_start_date => l_effective_start_date
1844 ,p_effective_end_date => l_effective_end_date
1845 ,p_object_version_number => l_object_version_number
1846 ,p_effective_date => trunc(p_effective_date)
1847 ,p_datetrack_mode => p_datetrack_mode
1848 );
1849 exception
1850 when hr_api.cannot_find_prog_unit then
1851 hr_api.cannot_find_prog_unit_error
1852 (p_module_name => 'DELETE_Plan'
1853 ,p_hook_type => 'AP'
1854 );
1855 --
1856 -- End of API User Hook for the after hook of delete_Plan
1857 --
1858 end;
1859 --
1860 hr_utility.set_location(l_proc, 60);
1864 if p_validate then
1861 --
1862 -- When in validation only mode raise the Validate_Enabled exception
1863 --
1865 raise hr_api.validate_enabled;
1866 end if;
1867 --
1868 hr_utility.set_location(' Leaving:'||l_proc, 70);
1869 --
1870 exception
1871 --
1872 when hr_api.validate_enabled then
1873 --
1874 -- As the Validate_Enabled exception has been raised
1875 -- we must rollback to the savepoint
1876 --
1877 ROLLBACK TO delete_Plan;
1878 --
1879 -- Only set output warning arguments
1880 -- (Any key or derived arguments must be set to null
1881 -- when validation only mode is being used.)
1882 --
1883 p_effective_start_date := null;
1884 p_effective_end_date := null;
1885 --
1886 when others then
1887 --
1888 -- A validation or unexpected error has occured
1889 --
1890 ROLLBACK TO delete_Plan;
1891 /* Inserted for nocopy changes */
1892 p_object_version_number := l_object_version_number;
1893 p_effective_start_date := null;
1894 p_effective_end_date := null;
1895 raise;
1896 --
1897 end delete_Plan;
1898 --
1899 -- ----------------------------------------------------------------------------
1900 -- |-------------------------------< lck >------------------------------------|
1901 -- ----------------------------------------------------------------------------
1902 --
1903 procedure lck
1904 (
1905 p_pl_id in number
1906 ,p_object_version_number in number
1907 ,p_effective_date in date
1908 ,p_datetrack_mode in varchar2
1909 ,p_validation_start_date out nocopy date
1910 ,p_validation_end_date out nocopy date
1911 ) is
1912 --
1913 --
1914 -- Declare cursors and local variables
1915 --
1916 l_proc varchar2(72) := g_package||'lck';
1917 l_validation_start_date date;
1918 l_validation_end_date date;
1919 --
1920 begin
1921 --
1922 hr_utility.set_location('Entering:'|| l_proc, 10);
1923 --
1924 ben_pln_shd.lck
1925 (p_pl_id => p_pl_id
1926 ,p_validation_start_date => l_validation_start_date
1927 ,p_validation_end_date => l_validation_end_date
1928 ,p_object_version_number => p_object_version_number
1929 ,p_effective_date => p_effective_date
1930 ,p_datetrack_mode => p_datetrack_mode
1931 );
1932 --
1933 hr_utility.set_location(' Leaving:'||l_proc, 70);
1934 --
1935 end lck;
1936 --
1937 end ben_Plan_api;