[Home] [Help]
PACKAGE: APPS.BEN_PLAN_API
Source
1 Package ben_Plan_api AUTHID CURRENT_USER as
2 /* $Header: beplnapi.pkh 120.0.12020000.4 2013/02/01 08:53:55 amnaraya ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_Plan >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_name Yes varchar2
18 -- p_alws_qdro_flag Yes varchar2
19 -- p_alws_qmcso_flag Yes varchar2
20 -- p_alws_reimbmts_flag Yes varchar2
21 -- p_bnf_addl_instn_txt_alwd_flag Yes varchar2
22 -- p_bnf_adrs_rqd_flag Yes varchar2
23 -- p_bnf_cntngt_bnfs_alwd_flag Yes varchar2
24 -- p_bnf_ctfn_rqd_flag Yes varchar2
25 -- p_bnf_dob_rqd_flag Yes varchar2
26 -- p_bnf_dsge_mnr_ttee_rqd_flag Yes varchar2
27 -- p_bnf_incrmt_amt No number
28 -- p_bnf_dflt_bnf_cd No varchar2
29 -- p_bnf_legv_id_rqd_flag Yes varchar2
30 -- p_bnf_may_dsgt_org_flag Yes varchar2
31 -- p_bnf_mn_dsgntbl_amt No number
32 -- p_bnf_mn_dsgntbl_pct_val No number
33 -- p_rqd_perd_enrt_nenrt_val No number
34 -- p_ordr_num No number
35 -- p_bnf_pct_incrmt_val No number
36 -- p_bnf_pct_amt_alwd_cd No varchar2
37 -- p_bnf_qdro_rl_apls_flag Yes varchar2
38 -- p_dflt_to_asn_pndg_ctfn_cd No varchar2
39 -- p_dflt_to_asn_pndg_ctfn_rl No number
40 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
41 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
42 -- p_dpnt_dsgn_cd No varchar2
43 -- p_elig_apls_flag Yes varchar2
44 -- p_invk_dcln_prtn_pl_flag Yes varchar2
45 -- p_invk_flx_cr_pl_flag Yes varchar2
46 -- p_imptd_incm_calc_cd no varchar2
47 -- p_drvbl_dpnt_elig_flag Yes varchar2
48 -- p_trk_inelig_per_flag Yes varchar2
49 -- p_pl_cd Yes varchar2
50 -- p_auto_enrt_mthd_rl No number
51 -- p_ivr_ident No varchar2
52 -- p_url_ref_name No varchar2
53 -- p_cmpr_clms_to_cvg_or_bal_cd No varchar2
54 -- p_cobra_pymt_due_dy_num No number
55 -- p_dpnt_cvd_by_othr_apls_flag Yes varchar2
56 -- p_enrt_mthd_cd No varchar2
57 -- p_enrt_cd No varchar2
58 -- p_enrt_cvg_strt_dt_cd No varchar2
59 -- p_enrt_cvg_end_dt_cd No varchar2
60 -- p_frfs_aply_flag Yes varchar2
61 -- p_hc_pl_subj_hcfa_aprvl_flag Yes varchar2
62 -- p_hghly_cmpd_rl_apls_flag Yes varchar2
63 -- p_incptn_dt No date
64 -- p_mn_cvg_rl No number
65 -- p_mn_cvg_rqd_amt No number
66 -- p_mn_opts_rqd_num No number
67 -- p_mx_cvg_alwd_amt No number
71 -- p_mx_cvg_wcfn_amt No number
68 -- p_mx_cvg_rl No number
69 -- p_mx_opts_alwd_num No number
70 -- p_mx_cvg_wcfn_mlt_num No number
72 -- p_mx_cvg_incr_alwd_amt No number
73 -- p_mx_cvg_incr_wcf_alwd_amt No number
74 -- p_mx_cvg_mlt_incr_num No number
75 -- p_mx_cvg_mlt_incr_wcf_num No number
76 -- p_mx_wtg_dt_to_use_cd No varchar2
77 -- p_mx_wtg_dt_to_use_rl No number
78 -- p_mx_wtg_perd_prte_uom No varchar2
79 -- p_mx_wtg_perd_prte_val No number
80 -- p_mx_wtg_perd_rl No number
81 -- p_nip_dflt_enrt_cd No varchar2
82 -- p_nip_dflt_enrt_det_rl No number
83 -- p_dpnt_adrs_rqd_flag Yes varchar2
84 -- p_dpnt_cvg_end_dt_cd No varchar2
85 -- p_dpnt_cvg_end_dt_rl No number
86 -- p_dpnt_cvg_strt_dt_cd No varchar2
87 -- p_dpnt_cvg_strt_dt_rl No number
88 -- p_dpnt_dob_rqd_flag Yes varchar2
89 -- p_dpnt_leg_id_rqd_flag Yes varchar2
90 -- p_dpnt_no_ctfn_rqd_flag Yes varchar2
91 -- p_no_mn_cvg_amt_apls_flag Yes varchar2
92 -- p_no_mn_cvg_incr_apls_flag Yes varchar2
93 -- p_no_mn_opts_num_apls_flag Yes varchar2
94 -- p_no_mx_cvg_amt_apls_flag Yes varchar2
95 -- p_no_mx_cvg_incr_apls_flag Yes varchar2
96 -- p_no_mx_opts_num_apls_flag Yes varchar2
97 -- p_nip_pl_uom No varchar2
98 -- p_rqd_perd_enrt_nenrt_uom No varchar2
99 -- p_nip_acty_ref_perd_cd No varchar2
100 -- p_nip_enrt_info_rt_freq_cd No varchar2
101 -- p_per_cvrd_cd No varchar2
102 -- p_enrt_cvg_end_dt_rl No number
103 -- p_postelcn_edit_rl No number
104 -- p_enrt_cvg_strt_dt_rl No number
105 -- p_prort_prtl_yr_cvg_rstrn_cd No varchar2
106 -- p_prort_prtl_yr_cvg_rstrn_rl No number
107 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
108 -- p_svgs_pl_flag Yes varchar2
109 -- p_subj_to_imptd_incm_typ_cd Yes varchar2
110 -- p_use_all_asnts_elig_flag Yes varchar2
111 -- p_use_all_asnts_for_rt_flag Yes varchar2
112 -- p_vstg_apls_flag Yes varchar2
113 -- p_wvbl_flag Yes varchar2
114 -- p_hc_svc_typ_cd No varchar2
115 -- p_pl_stat_cd No varchar2
116 -- p_prmry_fndg_mthd_cd No varchar2
117 -- p_rt_end_dt_cd No varchar2
118 -- p_rt_end_dt_rl No number
119 -- p_rt_strt_dt_rl No number
120 -- p_rt_strt_dt_cd No varchar2
121 -- p_bnf_dsgn_cd No varchar2
122 -- p_pl_typ_id Yes number
123 -- p_business_group_id Yes number Business Group of Record
124 -- p_pln_attribute_category No varchar2 Descriptive Flexfield
125 -- p_pln_attribute1 No varchar2 Descriptive Flexfield
126 -- p_pln_attribute2 No varchar2 Descriptive Flexfield
127 -- p_pln_attribute3 No varchar2 Descriptive Flexfield
128 -- p_pln_attribute4 No varchar2 Descriptive Flexfield
129 -- p_pln_attribute5 No varchar2 Descriptive Flexfield
130 -- p_pln_attribute6 No varchar2 Descriptive Flexfield
131 -- p_pln_attribute7 No varchar2 Descriptive Flexfield
132 -- p_pln_attribute8 No varchar2 Descriptive Flexfield
133 -- p_pln_attribute9 No varchar2 Descriptive Flexfield
134 -- p_pln_attribute10 No varchar2 Descriptive Flexfield
135 -- p_pln_attribute11 No varchar2 Descriptive Flexfield
136 -- p_pln_attribute12 No varchar2 Descriptive Flexfield
137 -- p_pln_attribute13 No varchar2 Descriptive Flexfield
138 -- p_pln_attribute14 No varchar2 Descriptive Flexfield
139 -- p_pln_attribute15 No varchar2 Descriptive Flexfield
140 -- p_pln_attribute16 No varchar2 Descriptive Flexfield
141 -- p_pln_attribute17 No varchar2 Descriptive Flexfield
142 -- p_pln_attribute18 No varchar2 Descriptive Flexfield
143 -- p_pln_attribute19 No varchar2 Descriptive Flexfield
144 -- p_pln_attribute20 No varchar2 Descriptive Flexfield
145 -- p_pln_attribute21 No varchar2 Descriptive Flexfield
146 -- p_pln_attribute22 No varchar2 Descriptive Flexfield
147 -- p_pln_attribute23 No varchar2 Descriptive Flexfield
148 -- p_pln_attribute24 No varchar2 Descriptive Flexfield
149 -- p_pln_attribute25 No varchar2 Descriptive Flexfield
150 -- p_pln_attribute26 No varchar2 Descriptive Flexfield
151 -- p_pln_attribute27 No varchar2 Descriptive Flexfield
152 -- p_pln_attribute28 No varchar2 Descriptive Flexfield
153 -- p_pln_attribute29 No varchar2 Descriptive Flexfield
154 -- p_pln_attribute30 No varchar2 Descriptive Flexfield
155 -- p_actl_prem_id No number
156 -- p_effective_date Yes date Session Date.
157 -- p_vrfy_fmly_mmbr_cd No varchar2
158 -- p_vrfy_fmly_mmbr_rl No number
159 --
160 -- Post Success:
161 --
162 -- Out Parameters:
163 -- Name Type Description
164 -- p_pl_id Yes number PK of record
165 -- p_effective_start_date Yes date Effective Start Date of Record
166 -- p_effective_end_date Yes date Effective End Date of Record
167 -- p_object_version_number No number OVN of record
168 --
169 -- Post Failure:
173 --
170 --
171 -- Access Status:
172 -- Public.
174 -- {End Of Comments}
175 --
176 procedure create_Plan
177 (
178 p_validate in boolean default false
179 ,p_pl_id out nocopy number
180 ,p_effective_start_date out nocopy date
181 ,p_effective_end_date out nocopy date
182 ,p_name in varchar2 default null
183 ,p_alws_qdro_flag in varchar2 default 'N'
184 ,p_alws_qmcso_flag in varchar2 default 'N'
185 ,p_alws_reimbmts_flag in varchar2 default 'N'
186 ,p_bnf_addl_instn_txt_alwd_flag in varchar2 default 'N'
187 ,p_bnf_adrs_rqd_flag in varchar2 default 'N'
188 ,p_bnf_cntngt_bnfs_alwd_flag in varchar2 default 'N'
189 ,p_bnf_ctfn_rqd_flag in varchar2 default 'N'
190 ,p_bnf_dob_rqd_flag in varchar2 default 'N'
191 ,p_bnf_dsge_mnr_ttee_rqd_flag in varchar2 default 'N'
192 ,p_bnf_incrmt_amt in number default null
193 ,p_bnf_dflt_bnf_cd in varchar2 default null
194 ,p_bnf_legv_id_rqd_flag in varchar2 default 'N'
195 ,p_bnf_may_dsgt_org_flag in varchar2 default 'N'
196 ,p_bnf_mn_dsgntbl_amt in number default null
197 ,p_bnf_mn_dsgntbl_pct_val in number default null
198 ,p_rqd_perd_enrt_nenrt_val in number default null
199 ,p_ordr_num in number default null
200 ,p_bnf_pct_incrmt_val in number default null
201 ,p_bnf_pct_amt_alwd_cd in varchar2 default null
202 ,p_bnf_qdro_rl_apls_flag in varchar2 default 'N'
203 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default null
204 ,p_dflt_to_asn_pndg_ctfn_rl in number default null
205 ,p_drvbl_fctr_apls_rts_flag in varchar2 default 'N'
206 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default 'N'
207 ,p_dpnt_dsgn_cd in varchar2 default null
208 ,p_elig_apls_flag in varchar2 default 'N'
209 ,p_invk_dcln_prtn_pl_flag in varchar2 default 'N'
210 ,p_invk_flx_cr_pl_flag in varchar2 default 'N'
211 ,p_imptd_incm_calc_cd in varchar2 default null
212 ,p_drvbl_dpnt_elig_flag in varchar2 default 'N'
213 ,p_trk_inelig_per_flag in varchar2 default 'N'
214 ,p_pl_cd in varchar2 default null
215 ,p_auto_enrt_mthd_rl in number default null
216 ,p_ivr_ident in varchar2 default null
217 ,p_url_ref_name in varchar2 default null
218 ,p_cmpr_clms_to_cvg_or_bal_cd in varchar2 default null
219 ,p_cobra_pymt_due_dy_num in number default null
220 ,p_dpnt_cvd_by_othr_apls_flag in varchar2 default 'N'
221 ,p_enrt_mthd_cd in varchar2 default null
222 ,p_enrt_cd in varchar2 default null
223 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
224 ,p_enrt_cvg_end_dt_cd in varchar2 default null
225 ,p_frfs_aply_flag in varchar2 default 'N'
226 ,p_hc_pl_subj_hcfa_aprvl_flag in varchar2 default 'N'
227 ,p_hghly_cmpd_rl_apls_flag in varchar2 default 'N'
228 ,p_incptn_dt in date default null
229 ,p_mn_cvg_rl in number default null
230 ,p_mn_cvg_rqd_amt in number default null
231 ,p_mn_opts_rqd_num in number default null
232 ,p_mx_cvg_alwd_amt in number default null
233 ,p_mx_cvg_rl in number default null
234 ,p_mx_opts_alwd_num in number default null
235 ,p_mx_cvg_wcfn_mlt_num in number default null
236 ,p_mx_cvg_wcfn_amt in number default null
237 ,p_mx_cvg_incr_alwd_amt in number default null
238 ,p_mx_cvg_incr_wcf_alwd_amt in number default null
239 ,p_mx_cvg_mlt_incr_num in number default null
240 ,p_mx_cvg_mlt_incr_wcf_num in number default null
241 ,p_mx_wtg_dt_to_use_cd in varchar2 default null
242 ,p_mx_wtg_dt_to_use_rl in number default null
243 ,p_mx_wtg_perd_prte_uom in varchar2 default null
244 ,p_mx_wtg_perd_prte_val in number default null
245 ,p_mx_wtg_perd_rl in number default null
246 ,p_nip_dflt_enrt_cd in varchar2 default null
247 ,p_nip_dflt_enrt_det_rl in number default null
248 ,p_dpnt_adrs_rqd_flag in varchar2 default 'N'
249 ,p_dpnt_cvg_end_dt_cd in varchar2 default null
250 ,p_dpnt_cvg_end_dt_rl in number default null
251 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
252 ,p_dpnt_cvg_strt_dt_rl in number default null
253 ,p_dpnt_dob_rqd_flag in varchar2 default 'N'
254 ,p_dpnt_leg_id_rqd_flag in varchar2 default 'N'
255 ,p_dpnt_no_ctfn_rqd_flag in varchar2 default 'N'
256 ,p_no_mn_cvg_amt_apls_flag in varchar2 default 'N'
257 ,p_no_mn_cvg_incr_apls_flag in varchar2 default 'N'
258 ,p_no_mn_opts_num_apls_flag in varchar2 default 'N'
259 ,p_no_mx_cvg_amt_apls_flag in varchar2 default 'N'
260 ,p_no_mx_cvg_incr_apls_flag in varchar2 default 'N'
261 ,p_no_mx_opts_num_apls_flag in varchar2 default 'N'
262 ,p_nip_pl_uom in varchar2 default null
263 ,p_rqd_perd_enrt_nenrt_uom in varchar2 default null
264 ,p_nip_acty_ref_perd_cd in varchar2 default null
265 ,p_nip_enrt_info_rt_freq_cd in varchar2 default null
269 ,p_enrt_cvg_strt_dt_rl in number default null
266 ,p_per_cvrd_cd in varchar2 default null
267 ,p_enrt_cvg_end_dt_rl in number default null
268 ,p_postelcn_edit_rl in number default null
270 ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default null
271 ,p_prort_prtl_yr_cvg_rstrn_rl in number default null
272 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default 'N'
273 ,p_svgs_pl_flag in varchar2 default 'N'
274 ,p_subj_to_imptd_incm_typ_cd in varchar2 default null
275 ,p_use_all_asnts_elig_flag in varchar2 default 'N'
276 ,p_use_all_asnts_for_rt_flag in varchar2 default 'N'
277 ,p_vstg_apls_flag in varchar2 default 'N'
278 ,p_wvbl_flag in varchar2 default 'N'
279 ,p_hc_svc_typ_cd in varchar2 default null
280 ,p_pl_stat_cd in varchar2 default null
281 ,p_prmry_fndg_mthd_cd in varchar2 default null
282 ,p_rt_end_dt_cd in varchar2 default null
283 ,p_rt_end_dt_rl in number default null
284 ,p_rt_strt_dt_rl in number default null
285 ,p_rt_strt_dt_cd in varchar2 default null
286 ,p_bnf_dsgn_cd in varchar2 default null
287 ,p_pl_typ_id in number default null
288 ,p_business_group_id in number default null
289 ,p_enrt_pl_opt_flag in varchar2 default 'N'
290 ,p_bnft_prvdr_pool_id in number default null
291 ,p_MAY_ENRL_PL_N_OIPL_FLAG in VARCHAR2 default 'N'
292 ,p_ENRT_RL in NUMBER default null
293 ,p_rqd_perd_enrt_nenrt_rl in NUMBER default null
294 ,p_ALWS_UNRSTRCTD_ENRT_FLAG in VARCHAR2 default 'N'
295 ,p_BNFT_OR_OPTION_RSTRCTN_CD in VARCHAR2 default null
296 ,p_CVG_INCR_R_DECR_ONLY_CD in VARCHAR2 default null
297 ,p_unsspnd_enrt_cd in varchar2 default null
298 ,p_pln_attribute_category in varchar2 default null
299 ,p_pln_attribute1 in varchar2 default null
300 ,p_pln_attribute2 in varchar2 default null
301 ,p_pln_attribute3 in varchar2 default null
302 ,p_pln_attribute4 in varchar2 default null
303 ,p_pln_attribute5 in varchar2 default null
304 ,p_pln_attribute6 in varchar2 default null
305 ,p_pln_attribute7 in varchar2 default null
306 ,p_pln_attribute8 in varchar2 default null
307 ,p_pln_attribute9 in varchar2 default null
308 ,p_pln_attribute10 in varchar2 default null
309 ,p_pln_attribute11 in varchar2 default null
310 ,p_pln_attribute12 in varchar2 default null
311 ,p_pln_attribute13 in varchar2 default null
312 ,p_pln_attribute14 in varchar2 default null
313 ,p_pln_attribute15 in varchar2 default null
314 ,p_pln_attribute16 in varchar2 default null
315 ,p_pln_attribute17 in varchar2 default null
316 ,p_pln_attribute18 in varchar2 default null
317 ,p_pln_attribute19 in varchar2 default null
318 ,p_pln_attribute20 in varchar2 default null
319 ,p_pln_attribute21 in varchar2 default null
320 ,p_pln_attribute22 in varchar2 default null
321 ,p_pln_attribute23 in varchar2 default null
322 ,p_pln_attribute24 in varchar2 default null
323 ,p_pln_attribute25 in varchar2 default null
324 ,p_pln_attribute26 in varchar2 default null
325 ,p_pln_attribute27 in varchar2 default null
326 ,p_pln_attribute28 in varchar2 default null
327 ,p_pln_attribute29 in varchar2 default null
328 ,p_pln_attribute30 in varchar2 default null
329 ,p_susp_if_ctfn_not_prvd_flag in varchar2 default 'Y'
330 ,p_ctfn_determine_cd in varchar2 default null
331 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default null
332 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default null
333 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default null
334 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default 'Y'
335 ,p_susp_if_bnf_ssn_nt_prv_cd in varchar2 default null
336 ,p_susp_if_bnf_dob_nt_prv_cd in varchar2 default null
337 ,p_susp_if_bnf_adr_nt_prv_cd in varchar2 default null
338 ,p_susp_if_ctfn_not_bnf_flag in varchar2 default 'Y'
339 ,p_dpnt_ctfn_determine_cd in varchar2 default null
340 ,p_bnf_ctfn_determine_cd in varchar2 default null
341 ,p_object_version_number out nocopy number
342 ,p_actl_prem_id in number default null
343 ,p_effective_date in date
344 ,p_vrfy_fmly_mmbr_cd in varchar2 default null
345 ,p_vrfy_fmly_mmbr_rl in number default null
346 ,p_alws_tmpry_id_crd_flag in varchar2 default 'N'
347 ,p_nip_dflt_flag in varchar2 default 'N'
348 -- Forfeiture process
349 ,p_frfs_distr_mthd_cd in varchar2 default null
350 ,p_frfs_distr_mthd_rl in number default null
351 ,p_frfs_cntr_det_cd in varchar2 default null
352 ,p_frfs_distr_det_cd in varchar2 default null
353 ,p_cost_alloc_keyflex_1_id in number default null
354 ,p_cost_alloc_keyflex_2_id in number default null
355 ,p_post_to_gl_flag in varchar2 default 'N'
356 ,p_frfs_val_det_cd in varchar2 default null
360 ,p_short_name in varchar2 default null
357 ,p_frfs_mx_cryfwd_val in number default null
358 ,p_frfs_portion_det_cd in varchar2 default null
359 ,p_bndry_perd_cd in varchar2 default null
361 ,p_short_code in varchar2 default null
362 ,p_legislation_code in varchar2 default null
363 ,p_legislation_subgroup in varchar2 default null
364 ,p_group_pl_id in number default null
365 ,p_mapping_table_name in varchar2 default null
366 ,p_mapping_table_pk_id in number default null
367 ,p_function_code in varchar2 default null
368 ,p_pl_yr_not_applcbl_flag in varchar2 default 'N'
369 ,p_use_csd_rsd_prccng_cd in varchar2 default null
370 ,p_all_inelig in varchar2 default 'N'
371 );
372 -- ----------------------------------------------------------------------------
373 -- |------------------------< update_Plan >------------------------|
374 -- ----------------------------------------------------------------------------
375 -- {Start Of Comments}
376 --
377 -- Description:
378 --
379 -- Prerequisites:
380 --
381 --
382 -- In Parameters:
383 -- Name Reqd Type Description
384 -- p_validate Yes boolean Commit or Rollback.
385 -- p_pl_id Yes number PK of record
386 -- p_name Yes varchar2
387 -- p_alws_qdro_flag Yes varchar2
388 -- p_alws_qmcso_flag Yes varchar2
389 -- p_alws_reimbmts_flag Yes varchar2
390 -- p_bnf_addl_instn_txt_alwd_flag Yes varchar2
391 -- p_bnf_adrs_rqd_flag Yes varchar2
392 -- p_bnf_cntngt_bnfs_alwd_flag Yes varchar2
393 -- p_bnf_ctfn_rqd_flag Yes varchar2
394 -- p_bnf_dob_rqd_flag Yes varchar2
395 -- p_bnf_dsge_mnr_ttee_rqd_flag Yes varchar2
396 -- p_bnf_incrmt_amt No number
397 -- p_bnf_dflt_bnf_cd No varchar2
398 -- p_bnf_legv_id_rqd_flag Yes varchar2
399 -- p_bnf_may_dsgt_org_flag Yes varchar2
400 -- p_bnf_mn_dsgntbl_amt No number
401 -- p_bnf_mn_dsgntbl_pct_val No number
402 -- p_rqd_perd_enrt_nenrt_val No number
403 -- p_ordr_num No number
404 -- p_bnf_pct_incrmt_val No number
405 -- p_bnf_pct_amt_alwd_cd No varchar2
406 -- p_bnf_qdro_rl_apls_flag Yes varchar2
407 -- p_dflt_to_asn_pndg_ctfn_cd No varchar2
408 -- p_dflt_to_asn_pndg_ctfn_rl No number
409 -- p_drvbl_fctr_apls_rts_flag Yes varchar2
410 -- p_drvbl_fctr_prtn_elig_flag Yes varchar2
411 -- p_dpnt_dsgn_cd No varchar2
412 -- p_elig_apls_flag Yes varchar2
413 -- p_invk_dcln_prtn_pl_flag Yes varchar2
414 -- p_invk_flx_cr_pl_flag Yes varchar2
415 -- p_imptd_incm_calc_cd No varchar2
416 -- p_drvbl_dpnt_elig_flag Yes varchar2
417 -- p_trk_inelig_per_flag Yes varchar2
418 -- p_pl_cd Yes varchar2
419 -- p_auto_enrt_mthd_rl No number
420 -- p_ivr_ident No varchar2
421 -- p_url_ref_name No varchar2
422 -- p_cmpr_clms_to_cvg_or_bal_cd No varchar2
423 -- p_cobra_pymt_due_dy_num No number
424 -- p_dpnt_cvd_by_othr_apls_flag Yes varchar2
425 -- p_enrt_mthd_cd No varchar2
426 -- p_enrt_cd No varchar2
427 -- p_enrt_cvg_strt_dt_cd No varchar2
428 -- p_enrt_cvg_end_dt_cd No varchar2
429 -- p_frfs_aply_flag Yes varchar2
430 -- p_hc_pl_subj_hcfa_aprvl_flag Yes varchar2
431 -- p_hghly_cmpd_rl_apls_flag Yes varchar2
432 -- p_incptn_dt No date
433 -- p_mn_cvg_rl No number
434 -- p_mn_cvg_rqd_amt No number
435 -- p_mn_opts_rqd_num No number
436 -- p_mx_cvg_alwd_amt No number
437 -- p_mx_cvg_rl No number
438 -- p_mx_opts_alwd_num No number
439 -- p_mx_cvg_wcfn_mlt_num No number
440 -- p_mx_cvg_wcfn_amt No number
441 -- p_mx_cvg_incr_alwd_amt No number
442 -- p_mx_cvg_incr_wcf_alwd_amt No number
443 -- p_mx_cvg_mlt_incr_num No number
444 -- p_mx_cvg_mlt_incr_wcf_num No number
445 -- p_mx_wtg_dt_to_use_cd No varchar2
446 -- p_mx_wtg_dt_to_use_rl No number
447 -- p_mx_wtg_perd_prte_uom No varchar2
448 -- p_mx_wtg_perd_prte_val No number
449 -- p_mx_wtg_perd_rl No number
450 -- p_nip_dflt_enrt_cd No varchar2
451 -- p_nip_dflt_enrt_det_rl No number
452 -- p_dpnt_adrs_rqd_flag Yes varchar2
453 -- p_dpnt_cvg_end_dt_cd No varchar2
454 -- p_dpnt_cvg_end_dt_rl No number
455 -- p_dpnt_cvg_strt_dt_cd No varchar2
456 -- p_dpnt_cvg_strt_dt_rl No number
457 -- p_dpnt_dob_rqd_flag Yes varchar2
458 -- p_dpnt_leg_id_rqd_flag Yes varchar2
459 -- p_dpnt_no_ctfn_rqd_flag Yes varchar2
460 -- p_no_mn_cvg_amt_apls_flag Yes varchar2
461 -- p_no_mn_cvg_incr_apls_flag Yes varchar2
462 -- p_no_mn_opts_num_apls_flag Yes varchar2
463 -- p_no_mx_cvg_amt_apls_flag Yes varchar2
464 -- p_no_mx_cvg_incr_apls_flag Yes varchar2
465 -- p_no_mx_opts_num_apls_flag Yes varchar2
466 -- p_nip_pl_uom No varchar2
467 -- p_rqd_perd_enrt_nenrt_uom No varchar2
471 -- p_enrt_cvg_end_dt_rl No number
468 -- p_nip_acty_ref_perd_cd No varchar2
469 -- p_nip_enrt_info_rt_freq_cd No varchar2
470 -- p_per_cvrd_cd No varchar2
472 -- p_postelcn_edit_rl No number
473 -- p_enrt_cvg_strt_dt_rl No number
474 -- p_prort_prtl_yr_cvg_rstrn_cd No varchar2
475 -- p_prort_prtl_yr_cvg_rstrn_rl No number
476 -- p_prtn_elig_ovrid_alwd_flag Yes varchar2
477 -- p_svgs_pl_flag Yes varchar2
478 -- p_subj_to_imptd_incm_typ_cd Yes varchar2
479 -- p_use_all_asnts_elig_flag Yes varchar2
480 -- p_use_all_asnts_for_rt_flag Yes varchar2
481 -- p_vstg_apls_flag Yes varchar2
482 -- p_wvbl_flag Yes varchar2
483 -- p_hc_svc_typ_cd No varchar2
484 -- p_pl_stat_cd No varchar2
485 -- p_prmry_fndg_mthd_cd No varchar2
486 -- p_rt_end_dt_cd No varchar2
487 -- p_rt_end_dt_rl No number
488 -- p_rt_strt_dt_rl No number
489 -- p_rt_strt_dt_cd No varchar2
490 -- p_bnf_dsgn_cd No varchar2
491 -- p_pl_typ_id Yes number
492 -- p_business_group_id Yes number Business Group of Record
493 -- p_pln_attribute_category No varchar2 Descriptive Flexfield
494 -- p_pln_attribute1 No varchar2 Descriptive Flexfield
495 -- p_pln_attribute2 No varchar2 Descriptive Flexfield
496 -- p_pln_attribute3 No varchar2 Descriptive Flexfield
497 -- p_pln_attribute4 No varchar2 Descriptive Flexfield
498 -- p_pln_attribute5 No varchar2 Descriptive Flexfield
499 -- p_pln_attribute6 No varchar2 Descriptive Flexfield
500 -- p_pln_attribute7 No varchar2 Descriptive Flexfield
501 -- p_pln_attribute8 No varchar2 Descriptive Flexfield
502 -- p_pln_attribute9 No varchar2 Descriptive Flexfield
503 -- p_pln_attribute10 No varchar2 Descriptive Flexfield
504 -- p_pln_attribute11 No varchar2 Descriptive Flexfield
505 -- p_pln_attribute12 No varchar2 Descriptive Flexfield
506 -- p_pln_attribute13 No varchar2 Descriptive Flexfield
507 -- p_pln_attribute14 No varchar2 Descriptive Flexfield
508 -- p_pln_attribute15 No varchar2 Descriptive Flexfield
509 -- p_pln_attribute16 No varchar2 Descriptive Flexfield
510 -- p_pln_attribute17 No varchar2 Descriptive Flexfield
511 -- p_pln_attribute18 No varchar2 Descriptive Flexfield
512 -- p_pln_attribute19 No varchar2 Descriptive Flexfield
513 -- p_pln_attribute20 No varchar2 Descriptive Flexfield
514 -- p_pln_attribute21 No varchar2 Descriptive Flexfield
515 -- p_pln_attribute22 No varchar2 Descriptive Flexfield
516 -- p_pln_attribute23 No varchar2 Descriptive Flexfield
517 -- p_pln_attribute24 No varchar2 Descriptive Flexfield
518 -- p_pln_attribute25 No varchar2 Descriptive Flexfield
519 -- p_pln_attribute26 No varchar2 Descriptive Flexfield
520 -- p_pln_attribute27 No varchar2 Descriptive Flexfield
521 -- p_pln_attribute28 No varchar2 Descriptive Flexfield
522 -- p_pln_attribute29 No varchar2 Descriptive Flexfield
523 -- p_pln_attribute30 No varchar2 Descriptive Flexfield
524 -- p_actl_prem_id No number
525 -- p_effective_date Yes date Session Date.
526 -- p_datetrack_mode Yes varchar2 Datetrack mode.
527 -- p_vrfy_fmly_mmbr_cd No varchar2
528 -- p_vrfy_fmly_mmbr_rl No number
529 --
530 -- Post Success:
531 --
532 -- Name Type Description
533 -- p_effective_start_date Yes date Effective Start Date of Record
534 -- p_effective_end_date Yes date Effective End Date of Record
535 -- p_object_version_number No number OVN of record
536 --
537 -- Post Failure:
538 --
539 -- Access Status:
540 -- Public.
541 --
542 -- {End Of Comments}
543 --
544 procedure update_Plan
545 (
546 p_validate in boolean default false
547 ,p_pl_id in number
548 ,p_effective_start_date out nocopy date
549 ,p_effective_end_date out nocopy date
550 ,p_name in varchar2 default hr_api.g_varchar2
551 ,p_alws_qdro_flag in varchar2 default hr_api.g_varchar2
552 ,p_alws_qmcso_flag in varchar2 default hr_api.g_varchar2
553 ,p_alws_reimbmts_flag in varchar2 default hr_api.g_varchar2
554 ,p_bnf_addl_instn_txt_alwd_flag in varchar2 default hr_api.g_varchar2
555 ,p_bnf_adrs_rqd_flag in varchar2 default hr_api.g_varchar2
556 ,p_bnf_cntngt_bnfs_alwd_flag in varchar2 default hr_api.g_varchar2
557 ,p_bnf_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
558 ,p_bnf_dob_rqd_flag in varchar2 default hr_api.g_varchar2
559 ,p_bnf_dsge_mnr_ttee_rqd_flag in varchar2 default hr_api.g_varchar2
560 ,p_bnf_incrmt_amt in number default hr_api.g_number
561 ,p_bnf_dflt_bnf_cd in varchar2 default hr_api.g_varchar2
562 ,p_bnf_legv_id_rqd_flag in varchar2 default hr_api.g_varchar2
563 ,p_bnf_may_dsgt_org_flag in varchar2 default hr_api.g_varchar2
564 ,p_bnf_mn_dsgntbl_amt in number default hr_api.g_number
565 ,p_bnf_mn_dsgntbl_pct_val in number default hr_api.g_number
566 ,p_rqd_perd_enrt_nenrt_val in number default hr_api.g_number
567 ,p_ordr_num in number default hr_api.g_number
568 ,p_bnf_pct_incrmt_val in number default hr_api.g_number
569 ,p_bnf_pct_amt_alwd_cd in varchar2 default hr_api.g_varchar2
570 ,p_bnf_qdro_rl_apls_flag in varchar2 default hr_api.g_varchar2
571 ,p_dflt_to_asn_pndg_ctfn_cd in varchar2 default hr_api.g_varchar2
572 ,p_dflt_to_asn_pndg_ctfn_rl in number default hr_api.g_number
573 ,p_drvbl_fctr_apls_rts_flag in varchar2 default hr_api.g_varchar2
574 ,p_drvbl_fctr_prtn_elig_flag in varchar2 default hr_api.g_varchar2
575 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
576 ,p_elig_apls_flag in varchar2 default hr_api.g_varchar2
577 ,p_invk_dcln_prtn_pl_flag in varchar2 default hr_api.g_varchar2
578 ,p_invk_flx_cr_pl_flag in varchar2 default hr_api.g_varchar2
579 ,p_imptd_incm_calc_cd in varchar2 default hr_api.g_varchar2
580 ,p_drvbl_dpnt_elig_flag in varchar2 default hr_api.g_varchar2
581 ,p_trk_inelig_per_flag in varchar2 default hr_api.g_varchar2
582 ,p_pl_cd in varchar2 default hr_api.g_varchar2
583 ,p_auto_enrt_mthd_rl in number default hr_api.g_number
584 ,p_ivr_ident in varchar2 default hr_api.g_varchar2
585 ,p_url_ref_name in varchar2 default hr_api.g_varchar2
586 ,p_cmpr_clms_to_cvg_or_bal_cd in varchar2 default hr_api.g_varchar2
587 ,p_cobra_pymt_due_dy_num in number default hr_api.g_number
588 ,p_dpnt_cvd_by_othr_apls_flag in varchar2 default hr_api.g_varchar2
589 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
590 ,p_enrt_cd in varchar2 default hr_api.g_varchar2
591 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
592 ,p_enrt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
593 ,p_frfs_aply_flag in varchar2 default hr_api.g_varchar2
594 ,p_hc_pl_subj_hcfa_aprvl_flag in varchar2 default hr_api.g_varchar2
595 ,p_hghly_cmpd_rl_apls_flag in varchar2 default hr_api.g_varchar2
596 ,p_incptn_dt in date default hr_api.g_date
597 ,p_mn_cvg_rl in number default hr_api.g_number
598 ,p_mn_cvg_rqd_amt in number default hr_api.g_number
599 ,p_mn_opts_rqd_num in number default hr_api.g_number
600 ,p_mx_cvg_alwd_amt in number default hr_api.g_number
601 ,p_mx_cvg_rl in number default hr_api.g_number
602 ,p_mx_opts_alwd_num in number default hr_api.g_number
603 ,p_mx_cvg_wcfn_mlt_num in number default hr_api.g_number
604 ,p_mx_cvg_wcfn_amt in number default hr_api.g_number
605 ,p_mx_cvg_incr_alwd_amt in number default hr_api.g_number
606 ,p_mx_cvg_incr_wcf_alwd_amt in number default hr_api.g_number
607 ,p_mx_cvg_mlt_incr_num in number default hr_api.g_number
608 ,p_mx_cvg_mlt_incr_wcf_num in number default hr_api.g_number
609 ,p_mx_wtg_dt_to_use_cd in varchar2 default hr_api.g_varchar2
610 ,p_mx_wtg_dt_to_use_rl in number default hr_api.g_number
611 ,p_mx_wtg_perd_prte_uom in varchar2 default hr_api.g_varchar2
612 ,p_mx_wtg_perd_prte_val in number default hr_api.g_number
613 ,p_mx_wtg_perd_rl in number default hr_api.g_number
614 ,p_nip_dflt_enrt_cd in varchar2 default hr_api.g_varchar2
615 ,p_nip_dflt_enrt_det_rl in number default hr_api.g_number
616 ,p_dpnt_adrs_rqd_flag in varchar2 default hr_api.g_varchar2
617 ,p_dpnt_cvg_end_dt_cd in varchar2 default hr_api.g_varchar2
621 ,p_dpnt_dob_rqd_flag in varchar2 default hr_api.g_varchar2
618 ,p_dpnt_cvg_end_dt_rl in number default hr_api.g_number
619 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
620 ,p_dpnt_cvg_strt_dt_rl in number default hr_api.g_number
622 ,p_dpnt_leg_id_rqd_flag in varchar2 default hr_api.g_varchar2
623 ,p_dpnt_no_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
624 ,p_no_mn_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
625 ,p_no_mn_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
626 ,p_no_mn_opts_num_apls_flag in varchar2 default hr_api.g_varchar2
627 ,p_no_mx_cvg_amt_apls_flag in varchar2 default hr_api.g_varchar2
628 ,p_no_mx_cvg_incr_apls_flag in varchar2 default hr_api.g_varchar2
629 ,p_no_mx_opts_num_apls_flag in varchar2 default hr_api.g_varchar2
630 ,p_nip_pl_uom in varchar2 default hr_api.g_varchar2
631 ,p_rqd_perd_enrt_nenrt_uom in varchar2 default hr_api.g_varchar2
632 ,p_nip_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2
633 ,p_nip_enrt_info_rt_freq_cd in varchar2 default hr_api.g_varchar2
634 ,p_per_cvrd_cd in varchar2 default hr_api.g_varchar2
635 ,p_enrt_cvg_end_dt_rl in number default hr_api.g_number
636 ,p_postelcn_edit_rl in number default hr_api.g_number
637 ,p_enrt_cvg_strt_dt_rl in number default hr_api.g_number
638 ,p_prort_prtl_yr_cvg_rstrn_cd in varchar2 default hr_api.g_varchar2
639 ,p_prort_prtl_yr_cvg_rstrn_rl in number default hr_api.g_number
640 ,p_prtn_elig_ovrid_alwd_flag in varchar2 default hr_api.g_varchar2
641 ,p_svgs_pl_flag in varchar2 default hr_api.g_varchar2
642 ,p_subj_to_imptd_incm_typ_cd in varchar2 default hr_api.g_varchar2
643 ,p_use_all_asnts_elig_flag in varchar2 default hr_api.g_varchar2
644 ,p_use_all_asnts_for_rt_flag in varchar2 default hr_api.g_varchar2
645 ,p_vstg_apls_flag in varchar2 default hr_api.g_varchar2
646 ,p_wvbl_flag in varchar2 default hr_api.g_varchar2
647 ,p_hc_svc_typ_cd in varchar2 default hr_api.g_varchar2
648 ,p_pl_stat_cd in varchar2 default hr_api.g_varchar2
649 ,p_prmry_fndg_mthd_cd in varchar2 default hr_api.g_varchar2
650 ,p_rt_end_dt_cd in varchar2 default hr_api.g_varchar2
651 ,p_rt_end_dt_rl in number default hr_api.g_number
652 ,p_rt_strt_dt_rl in number default hr_api.g_number
653 ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
654 ,p_bnf_dsgn_cd in varchar2 default hr_api.g_varchar2
655 ,p_pl_typ_id in number default hr_api.g_number
656 ,p_business_group_id in number default hr_api.g_number
657 ,p_enrt_pl_opt_flag in varchar2 default hr_api.g_varchar2
658 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
659 ,p_MAY_ENRL_PL_N_OIPL_FLAG in VARCHAR2 default hr_api.g_VARCHAR2
660 ,p_ENRT_RL in NUMBER default hr_api.g_NUMBER
661 ,p_rqd_perd_enrt_nenrt_rl in NUMBER default hr_api.g_NUMBER
662 ,p_ALWS_UNRSTRCTD_ENRT_FLAG in VARCHAR2 default hr_api.g_VARCHAR2
663 ,p_BNFT_OR_OPTION_RSTRCTN_CD in VARCHAR2 default hr_api.g_VARCHAR2
664 ,p_CVG_INCR_R_DECR_ONLY_CD in VARCHAR2 default hr_api.g_VARCHAR2
665 ,p_unsspnd_enrt_cd in varchar2 default hr_api.g_varchar2
666 ,p_pln_attribute_category in varchar2 default hr_api.g_varchar2
667 ,p_pln_attribute1 in varchar2 default hr_api.g_varchar2
668 ,p_pln_attribute2 in varchar2 default hr_api.g_varchar2
669 ,p_pln_attribute3 in varchar2 default hr_api.g_varchar2
670 ,p_pln_attribute4 in varchar2 default hr_api.g_varchar2
671 ,p_pln_attribute5 in varchar2 default hr_api.g_varchar2
672 ,p_pln_attribute6 in varchar2 default hr_api.g_varchar2
673 ,p_pln_attribute7 in varchar2 default hr_api.g_varchar2
674 ,p_pln_attribute8 in varchar2 default hr_api.g_varchar2
675 ,p_pln_attribute9 in varchar2 default hr_api.g_varchar2
676 ,p_pln_attribute10 in varchar2 default hr_api.g_varchar2
677 ,p_pln_attribute11 in varchar2 default hr_api.g_varchar2
678 ,p_pln_attribute12 in varchar2 default hr_api.g_varchar2
679 ,p_pln_attribute13 in varchar2 default hr_api.g_varchar2
680 ,p_pln_attribute14 in varchar2 default hr_api.g_varchar2
681 ,p_pln_attribute15 in varchar2 default hr_api.g_varchar2
682 ,p_pln_attribute16 in varchar2 default hr_api.g_varchar2
683 ,p_pln_attribute17 in varchar2 default hr_api.g_varchar2
684 ,p_pln_attribute18 in varchar2 default hr_api.g_varchar2
685 ,p_pln_attribute19 in varchar2 default hr_api.g_varchar2
686 ,p_pln_attribute20 in varchar2 default hr_api.g_varchar2
687 ,p_pln_attribute21 in varchar2 default hr_api.g_varchar2
688 ,p_pln_attribute22 in varchar2 default hr_api.g_varchar2
689 ,p_pln_attribute23 in varchar2 default hr_api.g_varchar2
690 ,p_pln_attribute24 in varchar2 default hr_api.g_varchar2
691 ,p_pln_attribute25 in varchar2 default hr_api.g_varchar2
692 ,p_pln_attribute26 in varchar2 default hr_api.g_varchar2
693 ,p_pln_attribute27 in varchar2 default hr_api.g_varchar2
694 ,p_pln_attribute28 in varchar2 default hr_api.g_varchar2
698 ,p_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
695 ,p_pln_attribute29 in varchar2 default hr_api.g_varchar2
696 ,p_pln_attribute30 in varchar2 default hr_api.g_varchar2
697 ,p_susp_if_ctfn_not_prvd_flag in varchar2 default hr_api.g_varchar2
699 ,p_susp_if_dpnt_ssn_nt_prv_cd in varchar2 default hr_api.g_varchar2
700 ,p_susp_if_dpnt_dob_nt_prv_cd in varchar2 default hr_api.g_varchar2
701 ,p_susp_if_dpnt_adr_nt_prv_cd in varchar2 default hr_api.g_varchar2
702 ,p_susp_if_ctfn_not_dpnt_flag in varchar2 default hr_api.g_varchar2
703 ,p_susp_if_bnf_ssn_nt_prv_cd in varchar2 default hr_api.g_varchar2
704 ,p_susp_if_bnf_dob_nt_prv_cd in varchar2 default hr_api.g_varchar2
705 ,p_susp_if_bnf_adr_nt_prv_cd in varchar2 default hr_api.g_varchar2
706 ,p_susp_if_ctfn_not_bnf_flag in varchar2 default hr_api.g_varchar2
707 ,p_dpnt_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
708 ,p_bnf_ctfn_determine_cd in varchar2 default hr_api.g_varchar2
709 ,p_object_version_number in out nocopy number
710 ,p_actl_prem_id in number default hr_api.g_number
711 ,p_effective_date in date
712 ,p_datetrack_mode in varchar2
713 ,p_vrfy_fmly_mmbr_cd in varchar2 default hr_api.g_varchar2
714 ,p_vrfy_fmly_mmbr_rl in number default hr_api.g_number
715 ,p_alws_tmpry_id_crd_flag in varchar2 default hr_api.g_varchar2
716 ,p_nip_dflt_flag in varchar2 default hr_api.g_varchar2
717 ,p_frfs_distr_mthd_cd in varchar2 default hr_api.g_varchar2
718 ,p_frfs_distr_mthd_rl in number default hr_api.g_number
719 ,p_frfs_cntr_det_cd in varchar2 default hr_api.g_varchar2
720 ,p_frfs_distr_det_cd in varchar2 default hr_api.g_varchar2
721 ,p_cost_alloc_keyflex_1_id in number default hr_api.g_number
722 ,p_cost_alloc_keyflex_2_id in number default hr_api.g_number
723 ,p_post_to_gl_flag in varchar2 default hr_api.g_varchar2
724 ,p_frfs_val_det_cd in varchar2 default hr_api.g_varchar2
725 ,p_frfs_mx_cryfwd_val in number default hr_api.g_number
726 ,p_frfs_portion_det_cd in varchar2 default hr_api.g_varchar2
727 ,p_bndry_perd_cd in varchar2 default hr_api.g_varchar2
728 ,p_short_name in varchar2 default hr_api.g_varchar2
729 ,p_short_code in varchar2 default hr_api.g_varchar2
730 ,p_legislation_code in varchar2 default hr_api.g_varchar2
731 ,p_legislation_subgroup in varchar2 default hr_api.g_varchar2
732 ,p_group_pl_id in number default hr_api.g_number
733 ,p_mapping_table_name in varchar2 default hr_api.g_varchar2
734 ,p_mapping_table_pk_id in number default hr_api.g_number
735 ,p_function_code in varchar2 default hr_api.g_varchar2
736 ,p_pl_yr_not_applcbl_flag in varchar2 default hr_api.g_varchar2
737 ,p_use_csd_rsd_prccng_cd in varchar2 default hr_api.g_varchar2
738 ,p_all_inelig in varchar2 default hr_api.g_varchar2
739 ,p_bnf_exl_participant_flag in varchar2 default hr_api.g_varchar2 --Enh 16043887
740 );
741 --
742 -- ----------------------------------------------------------------------------
743 -- |------------------------< delete_Plan >------------------------|
744 -- ----------------------------------------------------------------------------
745 -- {Start Of Comments}
746 --
747 -- Description:
748 --
749 -- Prerequisites:
750 --
751 --
752 -- In Parameters:
753 -- Name Reqd Type Description
754 -- p_validate Yes boolean Commit or Rollback.
755 -- p_pl_id Yes number PK of record
756 -- p_effective_date Yes date Session Date.
757 -- p_datetrack_mode Yes varchar2 Datetrack mode.
758 --
759 -- Post Success:
760 --
761 -- Name Type Description
762 -- p_effective_start_date Yes date Effective Start Date of Record
763 -- p_effective_end_date Yes date Effective End Date of Record
764 -- p_object_version_number No number OVN of record
765 --
766 -- Post Failure:
767 --
768 -- Access Status:
769 -- Public.
770 --
771 -- {End Of Comments}
772 --
773 procedure delete_Plan
774 (
775 p_validate in boolean default false
776 ,p_pl_id in number
777 ,p_effective_start_date out nocopy date
778 ,p_effective_end_date out nocopy date
779 ,p_object_version_number in out nocopy number
780 ,p_effective_date in date
781 ,p_datetrack_mode in varchar2
782 );
783 --
784 -- ----------------------------------------------------------------------------
785 -- |----------------------------------< lck >---------------------------------|
786 -- ----------------------------------------------------------------------------
787 -- {Start Of Comments}
788 --
789 -- Description:
790 --
791 -- Prerequisites:
792 --
793 --
794 -- In Parameters:
795 -- Name Reqd Type Description
796 -- p_pl_id Yes number PK of record
797 -- p_object_version_number Yes number OVN of record
798 -- p_effective_date Yes date Session Date.
799 -- p_datetrack_mode Yes varchar2 Datetrack mode.
800 --
801 -- Post Success:
802 --
803 -- Name Type Description
804 -- p_validation_start_date Yes Derived Effective Start Date.
805 -- p_validation_end_date Yes Derived Effective End Date.
806 --
807 -- Post Failure:
808 --
809 -- Access Status:
810 -- Public.
811 --
812 -- {End Of Comments}
813 --
814 procedure lck
815 (
816 p_pl_id in number
817 ,p_object_version_number in number
818 ,p_effective_date in date
819 ,p_datetrack_mode in varchar2
820 ,p_validation_start_date out nocopy date
821 ,p_validation_end_date out nocopy date
822 );
823 --
824 end ben_Plan_api;