1 Package ben_elig_per_elc_chc_swi As
2 /* $Header: beepeswi.pkh 120.3 2006/01/06 05:29:54 narvenka noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_elig_per_elc_chc >-----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ben_elig_per_elc_chc_api.create_elig_per_elc_chc
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_elig_per_elc_chc
27 (p_validate in number default hr_api.g_false_num
28 ,p_elig_per_elctbl_chc_id out nocopy number
29 ,p_enrt_typ_cycl_cd in varchar2 default null
30 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
31 ,p_enrt_perd_end_dt in date default null
32 ,p_enrt_perd_strt_dt in date default null
33 ,p_enrt_cvg_strt_dt_rl in varchar2 default null
34 ,p_ctfn_rqd_flag in varchar2 default null
35 ,p_pil_elctbl_chc_popl_id in number default null
36 ,p_roll_crs_flag in varchar2 default null
37 ,p_crntly_enrd_flag in varchar2 default null
38 ,p_dflt_flag in varchar2 default null
39 ,p_elctbl_flag in varchar2 default null
40 ,p_mndtry_flag in varchar2 default null
41 ,p_in_pndg_wkflow_flag in varchar2 default null
42 ,p_dflt_enrt_dt in date default null
43 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
44 ,p_dpnt_cvg_strt_dt_rl in varchar2 default null
45 ,p_enrt_cvg_strt_dt in date default null
46 ,p_alws_dpnt_dsgn_flag in varchar2 default null
47 ,p_dpnt_dsgn_cd in varchar2 default null
48 ,p_ler_chg_dpnt_cvg_cd in varchar2 default null
49 ,p_erlst_deenrt_dt in date default null
50 ,p_procg_end_dt in date default null
51 ,p_comp_lvl_cd in varchar2 default null
52 ,p_pl_id in number default null
53 ,p_oipl_id in number default null
54 ,p_pgm_id in number default null
55 ,p_pgm_typ_cd in varchar2 default null
56 ,p_plip_id in number default null
57 ,p_ptip_id in number default null
58 ,p_pl_typ_id in number default null
59 ,p_oiplip_id in number default null
60 ,p_cmbn_plip_id in number default null
61 ,p_cmbn_ptip_id in number default null
62 ,p_cmbn_ptip_opt_id in number default null
63 ,p_assignment_id in number default null
64 ,p_spcl_rt_pl_id in number default null
65 ,p_spcl_rt_oipl_id in number default null
66 ,p_must_enrl_anthr_pl_id in number default null
67 ,p_int_elig_per_elctbl_chc_id in number default null
68 ,p_prtt_enrt_rslt_id in number default null
69 ,p_bnft_prvdr_pool_id in number default null
70 ,p_per_in_ler_id in number default null
71 ,p_yr_perd_id in number default null
72 ,p_auto_enrt_flag in varchar2 default null
73 ,p_business_group_id in number default null
74 ,p_pl_ordr_num in number default null
75 ,p_plip_ordr_num in number default null
76 ,p_ptip_ordr_num in number default null
77 ,p_oipl_ordr_num in number default null
78 ,p_comments in varchar2 default null
79 ,p_elig_flag in varchar2 default null
80 ,p_elig_ovrid_dt in date default null
81 ,p_elig_ovrid_person_id in number default null
82 ,p_inelig_rsn_cd in varchar2 default null
83 ,p_mgr_ovrid_dt in date default null
84 ,p_mgr_ovrid_person_id in number default null
85 ,p_ws_mgr_id in number default null
86 ,p_epe_attribute_category in varchar2 default null
87 ,p_epe_attribute1 in varchar2 default null
88 ,p_epe_attribute2 in varchar2 default null
89 ,p_epe_attribute3 in varchar2 default null
90 ,p_epe_attribute4 in varchar2 default null
91 ,p_epe_attribute5 in varchar2 default null
92 ,p_epe_attribute6 in varchar2 default null
93 ,p_epe_attribute7 in varchar2 default null
94 ,p_epe_attribute8 in varchar2 default null
95 ,p_epe_attribute9 in varchar2 default null
96 ,p_epe_attribute10 in varchar2 default null
97 ,p_epe_attribute11 in varchar2 default null
98 ,p_epe_attribute12 in varchar2 default null
99 ,p_epe_attribute13 in varchar2 default null
100 ,p_epe_attribute14 in varchar2 default null
101 ,p_epe_attribute15 in varchar2 default null
102 ,p_epe_attribute16 in varchar2 default null
103 ,p_epe_attribute17 in varchar2 default null
104 ,p_epe_attribute18 in varchar2 default null
105 ,p_epe_attribute19 in varchar2 default null
106 ,p_epe_attribute20 in varchar2 default null
107 ,p_epe_attribute21 in varchar2 default null
108 ,p_epe_attribute22 in varchar2 default null
109 ,p_epe_attribute23 in varchar2 default null
110 ,p_epe_attribute24 in varchar2 default null
111 ,p_epe_attribute25 in varchar2 default null
112 ,p_epe_attribute26 in varchar2 default null
113 ,p_epe_attribute27 in varchar2 default null
114 ,p_epe_attribute28 in varchar2 default null
115 ,p_epe_attribute29 in varchar2 default null
116 ,p_epe_attribute30 in varchar2 default null
117 ,p_cryfwd_elig_dpnt_cd in varchar2 default null
118 ,p_request_id in number default null
119 ,p_program_application_id in number default null
120 ,p_program_id in number default null
121 ,p_program_update_date in date default null
122 ,p_object_version_number out nocopy number
123 ,p_effective_date in date
124 ,p_enrt_perd_id in number default null
125 ,p_lee_rsn_id in number default null
126 ,p_cls_enrt_dt_to_use_cd in varchar2 default null
127 ,p_uom in varchar2 default null
128 ,p_acty_ref_perd_cd in varchar2 default null
129 ,p_approval_status_cd in varchar2 default null
130 ,p_return_status out nocopy varchar2
131 );
132 -- ----------------------------------------------------------------------------
133 -- |---------------------< create_perf_elig_per_elc_chc >---------------------|
134 -- ----------------------------------------------------------------------------
135 -- {Start of comments}
136 --
137 -- Description:
138 -- This procedure is the self-service wrapper procedure to the following
139 -- API: ben_elig_per_elc_chc_api.create_perf_elig_per_elc_chc
140 --
141 -- Pre-requisites
142 -- All 'IN' parameters to this procedure have been appropriately derived.
143 --
144 -- Post Success:
145 -- p_return_status will return value indicating success.
146 --
147 -- Post Failure:
148 -- p_return_status will return value indication failure.
149 --
150 -- Access Status:
151 -- Internal Development use only.
152 --
153 -- {End of comments}
154 -- ----------------------------------------------------------------------------
155 PROCEDURE create_perf_elig_per_elc_chc
156 (p_validate in number default hr_api.g_false_num
157 ,p_elig_per_elctbl_chc_id out nocopy number
158 ,p_enrt_typ_cycl_cd in varchar2 default null
159 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
160 ,p_enrt_perd_end_dt in date default null
161 ,p_enrt_perd_strt_dt in date default null
162 ,p_enrt_cvg_strt_dt_rl in varchar2 default null
163 ,p_ctfn_rqd_flag in varchar2 default null
164 ,p_pil_elctbl_chc_popl_id in number default null
165 ,p_roll_crs_flag in varchar2 default null
166 ,p_crntly_enrd_flag in varchar2 default null
167 ,p_dflt_flag in varchar2 default null
168 ,p_elctbl_flag in varchar2 default null
169 ,p_mndtry_flag in varchar2 default null
170 ,p_in_pndg_wkflow_flag in varchar2 default null
171 ,p_dflt_enrt_dt in date default null
172 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
173 ,p_dpnt_cvg_strt_dt_rl in varchar2 default null
174 ,p_enrt_cvg_strt_dt in date default null
175 ,p_alws_dpnt_dsgn_flag in varchar2 default null
176 ,p_dpnt_dsgn_cd in varchar2 default null
177 ,p_ler_chg_dpnt_cvg_cd in varchar2 default null
178 ,p_erlst_deenrt_dt in date default null
179 ,p_procg_end_dt in date default null
180 ,p_comp_lvl_cd in varchar2 default null
181 ,p_pl_id in number default null
182 ,p_oipl_id in number default null
183 ,p_pgm_id in number default null
184 ,p_pgm_typ_cd in varchar2 default null
185 ,p_plip_id in number default null
186 ,p_ptip_id in number default null
187 ,p_pl_typ_id in number default null
188 ,p_oiplip_id in number default null
189 ,p_cmbn_plip_id in number default null
190 ,p_cmbn_ptip_id in number default null
191 ,p_cmbn_ptip_opt_id in number default null
192 ,p_assignment_id in number default null
193 ,p_spcl_rt_pl_id in number default null
194 ,p_spcl_rt_oipl_id in number default null
195 ,p_must_enrl_anthr_pl_id in number default null
196 ,p_int_elig_per_elctbl_chc_id in number default null
197 ,p_prtt_enrt_rslt_id in number default null
198 ,p_bnft_prvdr_pool_id in number default null
199 ,p_per_in_ler_id in number default null
200 ,p_yr_perd_id in number default null
201 ,p_auto_enrt_flag in varchar2 default null
202 ,p_business_group_id in number default null
203 ,p_pl_ordr_num in number default null
204 ,p_plip_ordr_num in number default null
205 ,p_ptip_ordr_num in number default null
206 ,p_oipl_ordr_num in number default null
207 ,p_comments in varchar2 default null
208 ,p_elig_flag in varchar2 default null
209 ,p_elig_ovrid_dt in date default null
210 ,p_elig_ovrid_person_id in number default null
211 ,p_inelig_rsn_cd in varchar2 default null
212 ,p_mgr_ovrid_dt in date default null
213 ,p_mgr_ovrid_person_id in number default null
214 ,p_ws_mgr_id in number default null
215 ,p_epe_attribute_category in varchar2 default null
216 ,p_epe_attribute1 in varchar2 default null
217 ,p_epe_attribute2 in varchar2 default null
218 ,p_epe_attribute3 in varchar2 default null
219 ,p_epe_attribute4 in varchar2 default null
220 ,p_epe_attribute5 in varchar2 default null
221 ,p_epe_attribute6 in varchar2 default null
222 ,p_epe_attribute7 in varchar2 default null
223 ,p_epe_attribute8 in varchar2 default null
224 ,p_epe_attribute9 in varchar2 default null
225 ,p_epe_attribute10 in varchar2 default null
226 ,p_epe_attribute11 in varchar2 default null
227 ,p_epe_attribute12 in varchar2 default null
228 ,p_epe_attribute13 in varchar2 default null
229 ,p_epe_attribute14 in varchar2 default null
230 ,p_epe_attribute15 in varchar2 default null
231 ,p_epe_attribute16 in varchar2 default null
232 ,p_epe_attribute17 in varchar2 default null
233 ,p_epe_attribute18 in varchar2 default null
234 ,p_epe_attribute19 in varchar2 default null
235 ,p_epe_attribute20 in varchar2 default null
236 ,p_epe_attribute21 in varchar2 default null
237 ,p_epe_attribute22 in varchar2 default null
238 ,p_epe_attribute23 in varchar2 default null
239 ,p_epe_attribute24 in varchar2 default null
240 ,p_epe_attribute25 in varchar2 default null
241 ,p_epe_attribute26 in varchar2 default null
242 ,p_epe_attribute27 in varchar2 default null
243 ,p_epe_attribute28 in varchar2 default null
244 ,p_epe_attribute29 in varchar2 default null
245 ,p_epe_attribute30 in varchar2 default null
246 ,p_cryfwd_elig_dpnt_cd in varchar2 default null
247 ,p_request_id in number default null
248 ,p_program_application_id in number default null
249 ,p_program_id in number default null
250 ,p_program_update_date in date default null
251 ,p_object_version_number out nocopy number
252 ,p_effective_date in date
253 ,p_enrt_perd_id in number default null
254 ,p_lee_rsn_id in number default null
255 ,p_cls_enrt_dt_to_use_cd in varchar2 default null
256 ,p_uom in varchar2 default null
257 ,p_acty_ref_perd_cd in varchar2 default null
258 ,p_mode in varchar2 default null
259 ,p_approval_status_cd in varchar2 default null
260 ,p_return_status out nocopy varchar2
261 );
262 -- ----------------------------------------------------------------------------
263 -- |------------------------< delete_elig_per_elc_chc >-----------------------|
264 -- ----------------------------------------------------------------------------
265 -- {Start of comments}
266 --
267 -- Description:
268 -- This procedure is the self-service wrapper procedure to the following
269 -- API: ben_elig_per_elc_chc_api.delete_elig_per_elc_chc
270 --
271 -- Pre-requisites
272 -- All 'IN' parameters to this procedure have been appropriately derived.
273 --
274 -- Post Success:
275 -- p_return_status will return value indicating success.
276 --
277 -- Post Failure:
278 -- p_return_status will return value indication failure.
279 --
280 -- Access Status:
281 -- Internal Development use only.
282 --
283 -- {End of comments}
284 -- ----------------------------------------------------------------------------
285 PROCEDURE delete_elig_per_elc_chc
286 (p_validate in number default hr_api.g_false_num
287 ,p_elig_per_elctbl_chc_id in number
288 ,p_object_version_number in out nocopy number
289 ,p_effective_date in date
290 ,p_return_status out nocopy varchar2
291 );
292 -- ----------------------------------------------------------------------------
293 -- |----------------------------------< lck >---------------------------------|
294 -- ----------------------------------------------------------------------------
298 -- This procedure is the self-service wrapper procedure to the following
295 -- {Start of comments}
296 --
297 -- Description:
299 -- API: ben_elig_per_elc_chc_api.lck
300 --
301 -- Pre-requisites
302 -- All 'IN' parameters to this procedure have been appropriately derived.
303 --
304 -- Post Success:
305 -- p_return_status will return value indicating success.
306 --
307 -- Post Failure:
308 -- p_return_status will return value indication failure.
309 --
310 -- Access Status:
311 -- Internal Development use only.
312 --
313 -- {End of comments}
314 -- ----------------------------------------------------------------------------
315 PROCEDURE lck
316 (p_elig_per_elctbl_chc_id in number
317 ,p_object_version_number in number
318 ,p_return_status out nocopy varchar2
319 );
320 -- ----------------------------------------------------------------------------
321 -- |------------------------< update_elig_per_elc_chc >-----------------------|
322 -- ----------------------------------------------------------------------------
323 -- {Start of comments}
324 --
325 -- Description:
326 -- This procedure is the self-service wrapper procedure to the following
327 -- API: ben_elig_per_elc_chc_api.update_elig_per_elc_chc
328 --
329 -- Pre-requisites
330 -- All 'IN' parameters to this procedure have been appropriately derived.
331 --
332 -- Post Success:
333 -- p_return_status will return value indicating success.
334 --
335 -- Post Failure:
336 -- p_return_status will return value indication failure.
337 --
338 -- Access Status:
339 -- Internal Development use only.
340 --
341 -- {End of comments}
342 -- ----------------------------------------------------------------------------
343 PROCEDURE update_elig_per_elc_chc
344 (p_validate in number default hr_api.g_false_num
345 ,p_elig_per_elctbl_chc_id in number
346 ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
347 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
348 ,p_enrt_perd_end_dt in date default hr_api.g_date
349 ,p_enrt_perd_strt_dt in date default hr_api.g_date
350 ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
351 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
352 ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
353 ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
354 ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
355 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
356 ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
357 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
358 ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
359 ,p_dflt_enrt_dt in date default hr_api.g_date
360 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
361 ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
362 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
363 ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
364 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
365 ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
366 ,p_erlst_deenrt_dt in date default hr_api.g_date
367 ,p_procg_end_dt in date default hr_api.g_date
368 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
369 ,p_pl_id in number default hr_api.g_number
370 ,p_oipl_id in number default hr_api.g_number
371 ,p_pgm_id in number default hr_api.g_number
372 ,p_plip_id in number default hr_api.g_number
373 ,p_ptip_id in number default hr_api.g_number
374 ,p_pl_typ_id in number default hr_api.g_number
375 ,p_oiplip_id in number default hr_api.g_number
376 ,p_cmbn_plip_id in number default hr_api.g_number
377 ,p_cmbn_ptip_id in number default hr_api.g_number
378 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
379 ,p_assignment_id in number default hr_api.g_number
380 ,p_spcl_rt_pl_id in number default hr_api.g_number
381 ,p_spcl_rt_oipl_id in number default hr_api.g_number
382 ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
383 ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
384 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
385 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
386 ,p_per_in_ler_id in number default hr_api.g_number
387 ,p_yr_perd_id in number default hr_api.g_number
388 ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
389 ,p_business_group_id in number default hr_api.g_number
390 ,p_pl_ordr_num in number default hr_api.g_number
391 ,p_plip_ordr_num in number default hr_api.g_number
392 ,p_ptip_ordr_num in number default hr_api.g_number
396 ,p_elig_ovrid_dt in date default hr_api.g_date
393 ,p_oipl_ordr_num in number default hr_api.g_number
394 ,p_comments in varchar2 default hr_api.g_varchar2
395 ,p_elig_flag in varchar2 default hr_api.g_varchar2
397 ,p_elig_ovrid_person_id in number default hr_api.g_number
398 ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
399 ,p_mgr_ovrid_dt in date default hr_api.g_date
400 ,p_mgr_ovrid_person_id in number default hr_api.g_number
401 ,p_ws_mgr_id in number default hr_api.g_number
402 ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
403 ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
404 ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
405 ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
406 ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
407 ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
408 ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
409 ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
410 ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
411 ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
412 ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
413 ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
414 ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
415 ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
416 ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
417 ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
418 ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
419 ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
420 ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
421 ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
422 ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
423 ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
424 ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
425 ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
426 ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
427 ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
428 ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
429 ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
430 ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
431 ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
432 ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
433 ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
434 ,p_request_id in number default hr_api.g_number
435 ,p_program_application_id in number default hr_api.g_number
436 ,p_program_id in number default hr_api.g_number
437 ,p_program_update_date in date default hr_api.g_date
438 ,p_object_version_number in out nocopy number
439 ,p_effective_date in date
440 ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
441 ,p_return_status out nocopy varchar2
442 );
443 -- ----------------------------------------------------------------------------
444 -- |---------------------< update_perf_elig_per_elc_chc >---------------------|
445 -- ----------------------------------------------------------------------------
446 -- {Start of comments}
447 --
448 -- Description:
449 -- This procedure is the self-service wrapper procedure to the following
450 -- API: ben_elig_per_elc_chc_api.update_perf_elig_per_elc_chc
451 --
452 -- Pre-requisites
453 -- All 'IN' parameters to this procedure have been appropriately derived.
454 --
455 -- Post Success:
456 -- p_return_status will return value indicating success.
457 --
458 -- Post Failure:
459 -- p_return_status will return value indication failure.
460 --
461 -- Access Status:
462 -- Internal Development use only.
463 --
464 -- {End of comments}
465 -- ----------------------------------------------------------------------------
466 PROCEDURE update_perf_elig_per_elc_chc
467 (p_validate in number default hr_api.g_false_num
468 ,p_elig_per_elctbl_chc_id in number
469 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
470 ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
471 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
472 ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
473 ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
474 ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
475 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
476 ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
477 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
478 ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
479 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
480 ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
481 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
485 ,p_erlst_deenrt_dt in date default hr_api.g_date
482 ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
483 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
484 ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
486 ,p_procg_end_dt in date default hr_api.g_date
487 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
488 ,p_pl_id in number default hr_api.g_number
489 ,p_oipl_id in number default hr_api.g_number
490 ,p_pgm_id in number default hr_api.g_number
491 ,p_plip_id in number default hr_api.g_number
492 ,p_ptip_id in number default hr_api.g_number
493 ,p_pl_typ_id in number default hr_api.g_number
494 ,p_oiplip_id in number default hr_api.g_number
495 ,p_cmbn_plip_id in number default hr_api.g_number
496 ,p_cmbn_ptip_id in number default hr_api.g_number
497 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
498 ,p_assignment_id in number default hr_api.g_number
499 ,p_spcl_rt_pl_id in number default hr_api.g_number
500 ,p_spcl_rt_oipl_id in number default hr_api.g_number
501 ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
502 ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
503 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
504 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
505 ,p_per_in_ler_id in number default hr_api.g_number
506 ,p_yr_perd_id in number default hr_api.g_number
507 ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
508 ,p_business_group_id in number default hr_api.g_number
509 ,p_pl_ordr_num in number default hr_api.g_number
510 ,p_plip_ordr_num in number default hr_api.g_number
511 ,p_ptip_ordr_num in number default hr_api.g_number
512 ,p_oipl_ordr_num in number default hr_api.g_number
513 ,p_comments in varchar2 default hr_api.g_varchar2
514 ,p_elig_flag in varchar2 default hr_api.g_varchar2
515 ,p_elig_ovrid_dt in date default hr_api.g_date
516 ,p_elig_ovrid_person_id in number default hr_api.g_number
517 ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
518 ,p_mgr_ovrid_dt in date default hr_api.g_date
519 ,p_mgr_ovrid_person_id in number default hr_api.g_number
520 ,p_ws_mgr_id in number default hr_api.g_number
521 ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
522 ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
523 ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
524 ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
525 ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
526 ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
527 ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
528 ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
529 ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
530 ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
531 ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
532 ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
533 ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
534 ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
535 ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
536 ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
537 ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
538 ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
539 ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
540 ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
541 ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
542 ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
543 ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
544 ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
545 ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
546 ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
547 ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
548 ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
549 ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
550 ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
551 ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
552 ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
553 ,p_request_id in number default hr_api.g_number
554 ,p_program_application_id in number default hr_api.g_number
555 ,p_program_id in number default hr_api.g_number
556 ,p_program_update_date in date default hr_api.g_date
557 ,p_object_version_number in out nocopy number
558 ,p_effective_date in date
559 ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
560 ,p_return_status out nocopy varchar2
561 );
562
563 -- ----------------------------------------------------------------------------
564 -- |---------------------------< process_api >--------------------------------|
565 -- ----------------------------------------------------------------------------
566 procedure process_api
567 (
568 p_document in CLOB
569 ,p_return_status out nocopy VARCHAR2
570 ,p_validate in number default hr_api.g_false_num
571 ,p_effective_date in date default null
572 );
573
574 end ben_elig_per_elc_chc_swi;