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