1 Package ben_ELIG_PER_ELC_CHC_api AUTHID CURRENT_USER as
2 /* $Header: beepeapi.pkh 120.0 2005/05/28 02:36:42 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_ELIG_PER_ELC_CHC >------------------------|
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_enrt_typ_cycl_cd No varchar2
21 -- p_enrt_cvg_strt_dt_rl No varchar2
18 -- p_enrt_cvg_strt_dt_cd No varchar2
19 -- p_enrt_perd_end_dt No date
20 -- p_enrt_perd_strt_dt No date
22 -- p_rt_strt_dt No date
23 -- p_rt_strt_dt_rl No varchar2
24 -- p_rt_strt_dt_cd No varchar2
25 -- p_roll_crs_flag No varchar2
26 -- p_crntly_enrd_flag Yes varchar2
27 -- p_dflt_flag Yes varchar2
28 -- p_elctbl_flag Yes varchar2
29 -- p_mndtry_flag Yes varchar2
30 -- p_in_pndg_wkflow_flag No varchar2
31 -- p_dflt_enrt_dt No date
32 -- p_dpnt_cvg_strt_dt_cd No varchar2
33 -- p_dpnt_cvg_strt_dt_rl No varchar2
34 -- p_enrt_cvg_strt_dt No date
35 -- p_alws_dpnt_dsgn_flag Yes varchar2
36 -- p_dpnt_dsgn_cd No varchar2
37 -- p_ler_chg_dpnt_cvg_cd No varchar2
38 -- p_erlst_deenrt_dt No date
39 -- p_procg_end_dt No date
40 -- p_comp_lvl_cd No varchar2
41 -- p_pl_id Yes number
42 -- p_oipl_id No number
43 -- p_pgm_id No number
44 -- p_pgm_typ_cd No varchar2
45 -- p_plip_id No number
46 -- p_ptip_id No number
47 -- p_pl_typ_id No number
48 -- p_oiplip_id No number
49 -- p_cmbn_plip_id No number
50 -- p_cmbn_ptip_id No number
51 -- p_cmbn_ptip_opt_id No number
52 -- p_assignment_id No number
53 -- p_spcl_rt_pl_id Yes number
54 -- p_spcl_rt_oipl_id Yes number
55 -- p_must_enrl_anthr_pl_id Yes number
56 -- p_int_elig_per_elctbl_chc_id Yes number
57 -- p_prtt_enrt_rslt_id No number
58 -- p_bnft_prvdr_pool_id Yes number
59 -- p_per_in_ler_id Yes number
60 -- p_yr_perd_id No number
61 -- p_auto_enrt_flag No varchar2
62 -- p_business_group_id Yes number Business Group of Record
63 -- p_epe_attribute_category No varchar2 Descriptive Flexfield
64 -- p_epe_attribute1 No varchar2 Descriptive Flexfield
65 -- p_epe_attribute2 No varchar2 Descriptive Flexfield
66 -- p_epe_attribute3 No varchar2 Descriptive Flexfield
67 -- p_epe_attribute4 No varchar2 Descriptive Flexfield
68 -- p_epe_attribute5 No varchar2 Descriptive Flexfield
69 -- p_epe_attribute6 No varchar2 Descriptive Flexfield
70 -- p_epe_attribute7 No varchar2 Descriptive Flexfield
71 -- p_epe_attribute8 No varchar2 Descriptive Flexfield
72 -- p_epe_attribute9 No varchar2 Descriptive Flexfield
73 -- p_epe_attribute10 No varchar2 Descriptive Flexfield
74 -- p_epe_attribute11 No varchar2 Descriptive Flexfield
75 -- p_epe_attribute12 No varchar2 Descriptive Flexfield
76 -- p_epe_attribute13 No varchar2 Descriptive Flexfield
77 -- p_epe_attribute14 No varchar2 Descriptive Flexfield
78 -- p_epe_attribute15 No varchar2 Descriptive Flexfield
79 -- p_epe_attribute16 No varchar2 Descriptive Flexfield
80 -- p_epe_attribute17 No varchar2 Descriptive Flexfield
81 -- p_epe_attribute18 No varchar2 Descriptive Flexfield
82 -- p_epe_attribute19 No varchar2 Descriptive Flexfield
83 -- p_epe_attribute20 No varchar2 Descriptive Flexfield
84 -- p_epe_attribute21 No varchar2 Descriptive Flexfield
85 -- p_epe_attribute22 No varchar2 Descriptive Flexfield
86 -- p_epe_attribute23 No varchar2 Descriptive Flexfield
87 -- p_epe_attribute24 No varchar2 Descriptive Flexfield
88 -- p_epe_attribute25 No varchar2 Descriptive Flexfield
89 -- p_epe_attribute26 No varchar2 Descriptive Flexfield
90 -- p_epe_attribute27 No varchar2 Descriptive Flexfield
91 -- p_epe_attribute28 No varchar2 Descriptive Flexfield
92 -- p_epe_attribute29 No varchar2 Descriptive Flexfield
93 -- p_epe_attribute30 No varchar2 Descriptive Flexfield
94 -- p_approval_status_cd No varchar2
95 -- p_cryfwd_elig_dpnt_cd No varchar2
96 -- p_request_id No number
97 -- p_program_application_id No number
98 -- p_program_id No number
99 -- p_program_update_date No date
100 -- p_effective_date Yes date Session Date.
101 --
102 -- Post Success:
103 --
104 -- Out Parameters:
105 -- Name Type Description
106 -- p_elig_per_elctbl_chc_id Yes number PK of record
107 -- p_object_version_number No number OVN of record
108 --
109 -- Post Failure:
110 --
111 -- Access Status:
112 -- Public.
113 --
114 -- {End Of Comments}
115 --
116 procedure create_ELIG_PER_ELC_CHC
117 (
118 p_validate in boolean default false
119 ,p_elig_per_elctbl_chc_id out nocopy number
120 ,p_enrt_typ_cycl_cd in varchar2 default null
121 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
122 ,p_enrt_perd_end_dt in date default null
123 ,p_enrt_perd_strt_dt in date default null
124 ,p_enrt_cvg_strt_dt_rl in varchar2 default null
125 -- ,p_rt_strt_dt in date default null
126 -- ,p_rt_strt_dt_rl in varchar2 default null
127 -- ,p_rt_strt_dt_cd in varchar2 default null
128 ,p_ctfn_rqd_flag in varchar2 default 'N'
129 ,p_pil_elctbl_chc_popl_id in number default null
133 ,p_elctbl_flag in varchar2 default 'N'
130 ,p_roll_crs_flag in varchar2 default 'N'
131 ,p_crntly_enrd_flag in varchar2 default 'N'
132 ,p_dflt_flag in varchar2 default 'N'
134 ,p_mndtry_flag in varchar2 default 'N'
135 ,p_in_pndg_wkflow_flag in varchar2 default 'N'
136 ,p_dflt_enrt_dt in date default null
137 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
138 ,p_dpnt_cvg_strt_dt_rl in varchar2 default null
139 ,p_enrt_cvg_strt_dt in date default null
140 ,p_alws_dpnt_dsgn_flag in varchar2 default 'N'
141 ,p_dpnt_dsgn_cd in varchar2 default null
142 ,p_ler_chg_dpnt_cvg_cd in varchar2 default null
143 ,p_erlst_deenrt_dt in date default null
144 ,p_procg_end_dt in date default null
145 ,p_comp_lvl_cd in varchar2 default null
146 ,p_pl_id in number default null
147 ,p_oipl_id in number default null
148 ,p_pgm_id in number default null
149 ,p_pgm_typ_cd in varchar2 default null
150 ,p_plip_id in number default null
151 ,p_ptip_id in number default null
152 ,p_pl_typ_id in number default null
153 ,p_oiplip_id in number default null
154 ,p_cmbn_plip_id in number default null
155 ,p_cmbn_ptip_id in number default null
156 ,p_cmbn_ptip_opt_id in number default null
157 ,p_assignment_id in number default null
158 ,p_spcl_rt_pl_id in number default null
159 ,p_spcl_rt_oipl_id in number default null
160 ,p_must_enrl_anthr_pl_id in number default null
161 ,p_int_elig_per_elctbl_chc_id in number default null
162 ,p_prtt_enrt_rslt_id in number default null
163 ,p_bnft_prvdr_pool_id in number default null
164 ,p_per_in_ler_id in number default null
165 ,p_yr_perd_id in number default null
166 ,p_auto_enrt_flag in varchar2 default 'N'
167 ,p_business_group_id in number default null
168 ,p_pl_ordr_num in number default null
169 ,p_plip_ordr_num in number default null
170 ,p_ptip_ordr_num in number default null
171 ,p_oipl_ordr_num in number default null
172 -- cwb
173 ,p_comments in varchar2 default null
174 ,p_elig_flag in varchar2 default 'Y'
175 ,p_elig_ovrid_dt in date default null
176 ,p_elig_ovrid_person_id in number default null
177 ,p_inelig_rsn_cd in varchar2 default null
178 ,p_mgr_ovrid_dt in date default null
179 ,p_mgr_ovrid_person_id in number default null
180 ,p_ws_mgr_id in number default null
181 -- cwb
182 ,p_epe_attribute_category in varchar2 default null
183 ,p_epe_attribute1 in varchar2 default null
184 ,p_epe_attribute2 in varchar2 default null
185 ,p_epe_attribute3 in varchar2 default null
189 ,p_epe_attribute7 in varchar2 default null
186 ,p_epe_attribute4 in varchar2 default null
187 ,p_epe_attribute5 in varchar2 default null
188 ,p_epe_attribute6 in varchar2 default null
190 ,p_epe_attribute8 in varchar2 default null
191 ,p_epe_attribute9 in varchar2 default null
192 ,p_epe_attribute10 in varchar2 default null
193 ,p_epe_attribute11 in varchar2 default null
194 ,p_epe_attribute12 in varchar2 default null
195 ,p_epe_attribute13 in varchar2 default null
196 ,p_epe_attribute14 in varchar2 default null
197 ,p_epe_attribute15 in varchar2 default null
198 ,p_epe_attribute16 in varchar2 default null
199 ,p_epe_attribute17 in varchar2 default null
200 ,p_epe_attribute18 in varchar2 default null
201 ,p_epe_attribute19 in varchar2 default null
202 ,p_epe_attribute20 in varchar2 default null
203 ,p_epe_attribute21 in varchar2 default null
204 ,p_epe_attribute22 in varchar2 default null
205 ,p_epe_attribute23 in varchar2 default null
206 ,p_epe_attribute24 in varchar2 default null
207 ,p_epe_attribute25 in varchar2 default null
208 ,p_epe_attribute26 in varchar2 default null
209 ,p_epe_attribute27 in varchar2 default null
210 ,p_epe_attribute28 in varchar2 default null
211 ,p_epe_attribute29 in varchar2 default null
212 ,p_epe_attribute30 in varchar2 default null
213 ,p_approval_status_cd in varchar2 default null
214 ,p_fonm_cvg_strt_dt in date default null
215 ,p_cryfwd_elig_dpnt_cd in varchar2 default null
216 ,p_request_id in number default null
217 ,p_program_application_id in number default null
218 ,p_program_id in number default null
219 ,p_program_update_date in date default null
220 ,p_object_version_number out nocopy number
221 ,p_effective_date in date
222 ,p_enrt_perd_id in number default null
223 ,p_lee_rsn_id in number default null
224 ,p_cls_enrt_dt_to_use_cd in varchar2 default null
225 ,p_uom in varchar2 default null
226 ,p_acty_ref_perd_cd in varchar2 default null
227 );
228 --
229 -- Performance cover
230 --
231 procedure create_perf_ELIG_PER_ELC_CHC
232 (p_validate in boolean default false
233 ,p_elig_per_elctbl_chc_id out nocopy number
234 ,p_enrt_typ_cycl_cd in varchar2 default null
235 ,p_enrt_cvg_strt_dt_cd in varchar2 default null
236 ,p_enrt_perd_end_dt in date default null
237 ,p_enrt_perd_strt_dt in date default null
238 ,p_enrt_cvg_strt_dt_rl in varchar2 default null
239 ,p_ctfn_rqd_flag in varchar2 default 'N'
240 ,p_pil_elctbl_chc_popl_id in number default null
241 ,p_roll_crs_flag in varchar2 default 'N'
245 ,p_mndtry_flag in varchar2 default 'N'
242 ,p_crntly_enrd_flag in varchar2 default 'N'
243 ,p_dflt_flag in varchar2 default 'N'
244 ,p_elctbl_flag in varchar2 default 'N'
246 ,p_in_pndg_wkflow_flag in varchar2 default 'N'
247 ,p_dflt_enrt_dt in date default null
248 ,p_dpnt_cvg_strt_dt_cd in varchar2 default null
249 ,p_dpnt_cvg_strt_dt_rl in varchar2 default null
250 ,p_enrt_cvg_strt_dt in date default null
251 ,p_alws_dpnt_dsgn_flag in varchar2 default 'N'
252 ,p_dpnt_dsgn_cd in varchar2 default null
253 ,p_ler_chg_dpnt_cvg_cd in varchar2 default null
254 ,p_erlst_deenrt_dt in date default null
255 ,p_procg_end_dt in date default null
256 ,p_comp_lvl_cd in varchar2 default null
257 ,p_pl_id in number default null
258 ,p_oipl_id in number default null
259 ,p_pgm_id in number default null
260 ,p_pgm_typ_cd in varchar2 default null
261 ,p_plip_id in number default null
262 ,p_ptip_id in number default null
263 ,p_pl_typ_id in number default null
264 ,p_oiplip_id in number default null
265 ,p_cmbn_plip_id in number default null
266 ,p_cmbn_ptip_id in number default null
267 ,p_cmbn_ptip_opt_id in number default null
268 ,p_assignment_id in number default null
269 ,p_spcl_rt_pl_id in number default null
270 ,p_spcl_rt_oipl_id in number default null
271 ,p_must_enrl_anthr_pl_id in number default null
272 ,p_int_elig_per_elctbl_chc_id in number default null
273 ,p_prtt_enrt_rslt_id in number default null
274 ,p_bnft_prvdr_pool_id in number default null
275 ,p_per_in_ler_id in number default null
276 ,p_yr_perd_id in number default null
277 ,p_auto_enrt_flag in varchar2 default 'N'
278 ,p_business_group_id in number default null
279 ,p_pl_ordr_num in number default null
280 ,p_plip_ordr_num in number default null
281 ,p_ptip_ordr_num in number default null
282 ,p_oipl_ordr_num in number default null
283 -- cwb
284 ,p_comments in varchar2 default null
285 ,p_elig_flag in varchar2 default 'Y'
286 ,p_elig_ovrid_dt in date default null
287 ,p_elig_ovrid_person_id in number default null
288 ,p_inelig_rsn_cd in varchar2 default null
289 ,p_mgr_ovrid_dt in date default null
290 ,p_mgr_ovrid_person_id in number default null
291 ,p_ws_mgr_id in number default null
292 -- cwb
293 ,p_epe_attribute_category in varchar2 default null
294 ,p_epe_attribute1 in varchar2 default null
295 ,p_epe_attribute2 in varchar2 default null
296 ,p_epe_attribute3 in varchar2 default null
297 ,p_epe_attribute4 in varchar2 default null
298 ,p_epe_attribute5 in varchar2 default null
299 ,p_epe_attribute6 in varchar2 default null
300 ,p_epe_attribute7 in varchar2 default null
301 ,p_epe_attribute8 in varchar2 default null
302 ,p_epe_attribute9 in varchar2 default null
303 ,p_epe_attribute10 in varchar2 default null
304 ,p_epe_attribute11 in varchar2 default null
305 ,p_epe_attribute12 in varchar2 default null
306 ,p_epe_attribute13 in varchar2 default null
307 ,p_epe_attribute14 in varchar2 default null
308 ,p_epe_attribute15 in varchar2 default null
309 ,p_epe_attribute16 in varchar2 default null
310 ,p_epe_attribute17 in varchar2 default null
311 ,p_epe_attribute18 in varchar2 default null
312 ,p_epe_attribute19 in varchar2 default null
313 ,p_epe_attribute20 in varchar2 default null
314 ,p_epe_attribute21 in varchar2 default null
315 ,p_epe_attribute22 in varchar2 default null
316 ,p_epe_attribute23 in varchar2 default null
317 ,p_epe_attribute24 in varchar2 default null
318 ,p_epe_attribute25 in varchar2 default null
319 ,p_epe_attribute26 in varchar2 default null
320 ,p_epe_attribute27 in varchar2 default null
321 ,p_epe_attribute28 in varchar2 default null
322 ,p_epe_attribute29 in varchar2 default null
323 ,p_epe_attribute30 in varchar2 default null
324 ,p_approval_status_cd in varchar2 default null
325 ,p_fonm_cvg_strt_dt in date default null
326 ,p_cryfwd_elig_dpnt_cd in varchar2 default null
327 ,p_request_id in number default null
328 ,p_program_application_id in number default null
329 ,p_program_id in number default null
330 ,p_program_update_date in date default null
331 ,p_object_version_number out nocopy number
332 ,p_effective_date in date
333 ,p_enrt_perd_id in number default null
334 ,p_lee_rsn_id in number default null
335 ,p_cls_enrt_dt_to_use_cd in varchar2 default null
336 ,p_uom in varchar2 default null
337 ,p_acty_ref_perd_cd in varchar2 default null
338 -- CWB Changes
339 ,p_mode in varchar2 default null
340 );
341 -- ----------------------------------------------------------------------------
342 -- |------------------------< update_ELIG_PER_ELC_CHC >------------------------|
343 -- ----------------------------------------------------------------------------
344 -- {Start Of Comments}
345 --
346 -- Description:
347 --
348 -- Prerequisites:
349 --
350 --
351 -- In Parameters:
352 -- Name Reqd Type Description
353 -- p_validate Yes boolean Commit or Rollback.
354 -- p_elig_per_elctbl_chc_id Yes number PK of record
355 -- p_enrt_typ_cycl_cd No varchar2
356 -- p_enrt_cvg_strt_dt_cd No varchar2
360 -- p_rt_strt_dt No date
357 -- p_enrt_perd_end_dt No date
358 -- p_enrt_perd_strt_dt No date
359 -- p_enrt_cvg_strt_dt_rl No varchar2
361 -- p_rt_strt_dt_rl No varchar2
362 -- p_rt_strt_dt_cd No varchar2
363 -- p_roll_crs_flag No varchar2
364 -- p_crntly_enrd_flag Yes varchar2
365 -- p_dflt_flag Yes varchar2
366 -- p_elctbl_flag Yes varchar2
367 -- p_mndtry_flag Yes varchar2
368 -- p_in_pndg_wkflow_flag No varchar2
369 -- p_dflt_enrt_dt No date
370 -- p_dpnt_cvg_strt_dt_cd No varchar2
371 -- p_dpnt_cvg_strt_dt_rl No varchar2
372 -- p_enrt_cvg_strt_dt No date
373 -- p_alws_dpnt_dsgn_flag Yes varchar2
374 -- p_dpnt_dsgn_cd No varchar2
375 -- p_ler_chg_dpnt_cvg_cd No varchar2
376 -- p_erlst_deenrt_dt No date
377 -- p_procg_end_dt No date
378 -- p_comp_lvl_cd No varchar2
379 -- p_pl_id Yes number
380 -- p_oipl_id No number
381 -- p_pgm_id No number
382 -- p_plip_id No number
383 -- p_ptip_id No number
384 -- p_pl_typ_id No number
385 -- p_oiplip_id No number
386 -- p_cmbn_plip_id No number
387 -- p_cmbn_ptip_id No number
388 -- p_cmbn_ptip_opt_id No number
389 -- p_assignment_id No number
390 -- p_spcl_rt_pl_id Yes number
391 -- p_spcl_rt_oipl_id Yes number
392 -- p_must_enrl_anthr_pl_id Yes number
393 -- p_int_elig_per_elctbl_chc_id Yes number
394 -- p_prtt_enrt_rslt_id No number
395 -- p_bnft_prvdr_pool_id Yes number
396 -- p_per_in_ler_id Yes number
397 -- p_yr_perd_id No number
398 -- p_auto_enrt_flag No varchar2
399 -- p_business_group_id Yes number Business Group of Record
400 -- p_epe_attribute_category No varchar2 Descriptive Flexfield
401 -- p_epe_attribute1 No varchar2 Descriptive Flexfield
402 -- p_epe_attribute2 No varchar2 Descriptive Flexfield
403 -- p_epe_attribute3 No varchar2 Descriptive Flexfield
404 -- p_epe_attribute4 No varchar2 Descriptive Flexfield
405 -- p_epe_attribute5 No varchar2 Descriptive Flexfield
406 -- p_epe_attribute6 No varchar2 Descriptive Flexfield
407 -- p_epe_attribute7 No varchar2 Descriptive Flexfield
408 -- p_epe_attribute8 No varchar2 Descriptive Flexfield
409 -- p_epe_attribute9 No varchar2 Descriptive Flexfield
410 -- p_epe_attribute10 No varchar2 Descriptive Flexfield
411 -- p_epe_attribute11 No varchar2 Descriptive Flexfield
412 -- p_epe_attribute12 No varchar2 Descriptive Flexfield
413 -- p_epe_attribute13 No varchar2 Descriptive Flexfield
414 -- p_epe_attribute14 No varchar2 Descriptive Flexfield
415 -- p_epe_attribute15 No varchar2 Descriptive Flexfield
416 -- p_epe_attribute16 No varchar2 Descriptive Flexfield
417 -- p_epe_attribute17 No varchar2 Descriptive Flexfield
418 -- p_epe_attribute18 No varchar2 Descriptive Flexfield
419 -- p_epe_attribute19 No varchar2 Descriptive Flexfield
420 -- p_epe_attribute20 No varchar2 Descriptive Flexfield
421 -- p_epe_attribute21 No varchar2 Descriptive Flexfield
422 -- p_epe_attribute22 No varchar2 Descriptive Flexfield
423 -- p_epe_attribute23 No varchar2 Descriptive Flexfield
424 -- p_epe_attribute24 No varchar2 Descriptive Flexfield
425 -- p_epe_attribute25 No varchar2 Descriptive Flexfield
426 -- p_epe_attribute26 No varchar2 Descriptive Flexfield
427 -- p_epe_attribute27 No varchar2 Descriptive Flexfield
428 -- p_epe_attribute28 No varchar2 Descriptive Flexfield
429 -- p_epe_attribute29 No varchar2 Descriptive Flexfield
430 -- p_epe_attribute30 No varchar2 Descriptive Flexfield
431 -- p_cryfwd_elig_dpnt_cd No varchar2
432 -- p_request_id No number
433 -- p_program_application_id No number
434 -- p_program_id No number
435 -- p_program_update_date No date
436 -- p_effective_date Yes date Session Date.
437 --
438 -- Post Success:
439 --
440 -- Name Type Description
441 -- p_object_version_number No number OVN of record
442 --
443 -- Post Failure:
444 --
445 -- Access Status:
446 -- Public.
447 --
448 -- {End Of Comments}
449 --
450 procedure update_ELIG_PER_ELC_CHC
451 (
452 p_validate in boolean default false
453 ,p_elig_per_elctbl_chc_id in number
454 ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
455 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
456 ,p_enrt_perd_end_dt in date default hr_api.g_date
457 ,p_enrt_perd_strt_dt in date default hr_api.g_date
458 ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
459 -- ,p_rt_strt_dt in date default hr_api.g_date
460 -- ,p_rt_strt_dt_rl in varchar2 default hr_api.g_varchar2
461 -- ,p_rt_strt_dt_cd in varchar2 default hr_api.g_varchar2
462 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
463 ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
464 ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
465 ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
466 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
467 ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
468 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
469 ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
470 ,p_dflt_enrt_dt in date default hr_api.g_date
471 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
472 ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
473 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
474 ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
475 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
476 ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
477 ,p_erlst_deenrt_dt in date default hr_api.g_date
478 ,p_procg_end_dt in date default hr_api.g_date
479 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
480 ,p_pl_id in number default hr_api.g_number
481 ,p_oipl_id in number default hr_api.g_number
482 ,p_pgm_id in number default hr_api.g_number
483 ,p_plip_id in number default hr_api.g_number
484 ,p_ptip_id in number default hr_api.g_number
485 ,p_pl_typ_id in number default hr_api.g_number
486 ,p_oiplip_id in number default hr_api.g_number
487 ,p_cmbn_plip_id in number default hr_api.g_number
488 ,p_cmbn_ptip_id in number default hr_api.g_number
489 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
490 ,p_assignment_id in number default hr_api.g_number
491 ,p_spcl_rt_pl_id in number default hr_api.g_number
492 ,p_spcl_rt_oipl_id in number default hr_api.g_number
493 ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
494 ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
495 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
496 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
497 ,p_per_in_ler_id in number default hr_api.g_number
498 ,p_yr_perd_id in number default hr_api.g_number
499 ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
500 ,p_business_group_id in number default hr_api.g_number
501 ,p_pl_ordr_num in number default hr_api.g_number
502 ,p_plip_ordr_num in number default hr_api.g_number
503 ,p_ptip_ordr_num in number default hr_api.g_number
504 ,p_oipl_ordr_num in number default hr_api.g_number
505 -- cwb
506 ,p_comments in varchar2 default hr_api.g_varchar2
507 ,p_elig_flag in varchar2 default hr_api.g_varchar2
508 ,p_elig_ovrid_dt in date default hr_api.g_date
509 ,p_elig_ovrid_person_id in number default hr_api.g_number
510 ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
511 ,p_mgr_ovrid_dt in date default hr_api.g_date
512 ,p_mgr_ovrid_person_id in number default hr_api.g_number
513 ,p_ws_mgr_id in number default hr_api.g_number
514 -- cwb
515 ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
516 ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
517 ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
518 ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
519 ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
520 ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
521 ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
522 ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
523 ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
524 ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
525 ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
526 ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
527 ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
528 ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
529 ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
530 ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
531 ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
532 ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
533 ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
534 ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
535 ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
536 ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
537 ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
538 ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
539 ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
540 ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
541 ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
542 ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
543 ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
544 ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
545 ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
546 ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
547 ,p_fonm_cvg_strt_dt in date default hr_api.g_date
548 ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
549 ,p_request_id in number default hr_api.g_number
550 ,p_program_application_id in number default hr_api.g_number
551 ,p_program_id in number default hr_api.g_number
552 ,p_program_update_date in date default hr_api.g_date
553 ,p_object_version_number in out nocopy number
554 ,p_effective_date in date
555 );
556 --
557 -- Performance cover
558 --
559 procedure update_perf_ELIG_PER_ELC_CHC
560 (p_validate in boolean default false
561 ,p_elig_per_elctbl_chc_id in number
562 -- ,p_enrt_typ_cycl_cd in varchar2 default hr_api.g_varchar2
563 ,p_enrt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
564 -- ,p_enrt_perd_end_dt in date default hr_api.g_date
565 -- ,p_enrt_perd_strt_dt in date default hr_api.g_date
566 ,p_enrt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
567 ,p_ctfn_rqd_flag in varchar2 default hr_api.g_varchar2
568 ,p_pil_elctbl_chc_popl_id in number default hr_api.g_number
569 ,p_roll_crs_flag in varchar2 default hr_api.g_varchar2
570 ,p_crntly_enrd_flag in varchar2 default hr_api.g_varchar2
571 ,p_dflt_flag in varchar2 default hr_api.g_varchar2
572 ,p_elctbl_flag in varchar2 default hr_api.g_varchar2
573 ,p_mndtry_flag in varchar2 default hr_api.g_varchar2
574 ,p_in_pndg_wkflow_flag in varchar2 default hr_api.g_varchar2
575 -- ,p_dflt_enrt_dt in date default hr_api.g_date
576 ,p_dpnt_cvg_strt_dt_cd in varchar2 default hr_api.g_varchar2
577 ,p_dpnt_cvg_strt_dt_rl in varchar2 default hr_api.g_varchar2
578 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
579 ,p_alws_dpnt_dsgn_flag in varchar2 default hr_api.g_varchar2
580 ,p_dpnt_dsgn_cd in varchar2 default hr_api.g_varchar2
581 ,p_ler_chg_dpnt_cvg_cd in varchar2 default hr_api.g_varchar2
582 ,p_erlst_deenrt_dt in date default hr_api.g_date
583 ,p_procg_end_dt in date default hr_api.g_date
584 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
585 ,p_pl_id in number default hr_api.g_number
586 ,p_oipl_id in number default hr_api.g_number
587 ,p_pgm_id in number default hr_api.g_number
588 ,p_plip_id in number default hr_api.g_number
589 ,p_ptip_id in number default hr_api.g_number
590 ,p_pl_typ_id in number default hr_api.g_number
591 ,p_oiplip_id in number default hr_api.g_number
592 ,p_cmbn_plip_id in number default hr_api.g_number
593 ,p_cmbn_ptip_id in number default hr_api.g_number
594 ,p_cmbn_ptip_opt_id in number default hr_api.g_number
595 ,p_assignment_id in number default hr_api.g_number
596 ,p_spcl_rt_pl_id in number default hr_api.g_number
597 ,p_spcl_rt_oipl_id in number default hr_api.g_number
598 ,p_must_enrl_anthr_pl_id in number default hr_api.g_number
599 ,p_int_elig_per_elctbl_chc_id in number default hr_api.g_number
600 ,p_prtt_enrt_rslt_id in number default hr_api.g_number
601 ,p_bnft_prvdr_pool_id in number default hr_api.g_number
602 ,p_per_in_ler_id in number default hr_api.g_number
603 ,p_yr_perd_id in number default hr_api.g_number
604 ,p_auto_enrt_flag in varchar2 default hr_api.g_varchar2
605 ,p_business_group_id in number default hr_api.g_number
606 ,p_pl_ordr_num in number default hr_api.g_number
607 ,p_plip_ordr_num in number default hr_api.g_number
608 ,p_ptip_ordr_num in number default hr_api.g_number
609 ,p_oipl_ordr_num in number default hr_api.g_number
610 -- cwb
611 ,p_comments in varchar2 default hr_api.g_varchar2
612 ,p_elig_flag in varchar2 default hr_api.g_varchar2
613 ,p_elig_ovrid_dt in date default hr_api.g_date
614 ,p_elig_ovrid_person_id in number default hr_api.g_number
615 ,p_inelig_rsn_cd in varchar2 default hr_api.g_varchar2
616 ,p_mgr_ovrid_dt in date default hr_api.g_date
617 ,p_mgr_ovrid_person_id in number default hr_api.g_number
618 ,p_ws_mgr_id in number default hr_api.g_number
619 -- cwb
620 ,p_epe_attribute_category in varchar2 default hr_api.g_varchar2
621 ,p_epe_attribute1 in varchar2 default hr_api.g_varchar2
622 ,p_epe_attribute2 in varchar2 default hr_api.g_varchar2
623 ,p_epe_attribute3 in varchar2 default hr_api.g_varchar2
624 ,p_epe_attribute4 in varchar2 default hr_api.g_varchar2
625 ,p_epe_attribute5 in varchar2 default hr_api.g_varchar2
626 ,p_epe_attribute6 in varchar2 default hr_api.g_varchar2
627 ,p_epe_attribute7 in varchar2 default hr_api.g_varchar2
628 ,p_epe_attribute8 in varchar2 default hr_api.g_varchar2
629 ,p_epe_attribute9 in varchar2 default hr_api.g_varchar2
630 ,p_epe_attribute10 in varchar2 default hr_api.g_varchar2
631 ,p_epe_attribute11 in varchar2 default hr_api.g_varchar2
632 ,p_epe_attribute12 in varchar2 default hr_api.g_varchar2
633 ,p_epe_attribute13 in varchar2 default hr_api.g_varchar2
634 ,p_epe_attribute14 in varchar2 default hr_api.g_varchar2
635 ,p_epe_attribute15 in varchar2 default hr_api.g_varchar2
636 ,p_epe_attribute16 in varchar2 default hr_api.g_varchar2
637 ,p_epe_attribute17 in varchar2 default hr_api.g_varchar2
638 ,p_epe_attribute18 in varchar2 default hr_api.g_varchar2
639 ,p_epe_attribute19 in varchar2 default hr_api.g_varchar2
640 ,p_epe_attribute20 in varchar2 default hr_api.g_varchar2
641 ,p_epe_attribute21 in varchar2 default hr_api.g_varchar2
642 ,p_epe_attribute22 in varchar2 default hr_api.g_varchar2
643 ,p_epe_attribute23 in varchar2 default hr_api.g_varchar2
644 ,p_epe_attribute24 in varchar2 default hr_api.g_varchar2
645 ,p_epe_attribute25 in varchar2 default hr_api.g_varchar2
646 ,p_epe_attribute26 in varchar2 default hr_api.g_varchar2
647 ,p_epe_attribute27 in varchar2 default hr_api.g_varchar2
648 ,p_epe_attribute28 in varchar2 default hr_api.g_varchar2
649 ,p_epe_attribute29 in varchar2 default hr_api.g_varchar2
650 ,p_epe_attribute30 in varchar2 default hr_api.g_varchar2
651 ,p_approval_status_cd in varchar2 default hr_api.g_varchar2
652 ,p_fonm_cvg_strt_dt in date default hr_api.g_date
653 ,p_cryfwd_elig_dpnt_cd in varchar2 default hr_api.g_varchar2
654 ,p_request_id in number default hr_api.g_number
655 ,p_program_application_id in number default hr_api.g_number
656 ,p_program_id in number default hr_api.g_number
657 ,p_program_update_date in date default hr_api.g_date
658 ,p_object_version_number in out nocopy number
659 ,p_effective_date in date
660 );
661 --
662 -- ----------------------------------------------------------------------------
663 -- |------------------------< delete_ELIG_PER_ELC_CHC >------------------------|
664 -- ----------------------------------------------------------------------------
665 -- {Start Of Comments}
666 --
667 -- Description:
668 --
669 -- Prerequisites:
670 --
671 --
672 -- In Parameters:
673 -- Name Reqd Type Description
674 -- p_validate Yes boolean Commit or Rollback.
675 -- p_elig_per_elctbl_chc_id Yes number PK of record
676 -- p_effective_date Yes date Session Date.
677 --
678 -- Post Success:
679 --
680 -- Name Type Description
681 -- p_object_version_number No number OVN of record
682 --
683 -- Post Failure:
684 --
685 -- Access Status:
686 -- Public.
687 --
688 -- {End Of Comments}
689 --
690 procedure delete_ELIG_PER_ELC_CHC
691 (
692 p_validate in boolean default false
693 ,p_elig_per_elctbl_chc_id in number
694 ,p_object_version_number in out nocopy number
695 ,p_effective_date in date
696 );
697 --
698 -- ----------------------------------------------------------------------------
699 -- |----------------------------------< lck >---------------------------------|
700 -- ----------------------------------------------------------------------------
701 -- {Start Of Comments}
702 --
703 -- Description:
704 --
705 -- Prerequisites:
706 --
707 --
708 -- In Parameters:
709 -- Name Reqd Type Description
710 -- p_elig_per_elctbl_chc_id Yes number PK of record
711 -- p_object_version_number Yes number OVN of record
712 --
713 -- Post Success:
714 --
715 -- Name Type Description
716 --
717 -- Post Failure:
718 --
719 -- Access Status:
720 -- Public.
721 --
722 -- {End Of Comments}
723 --
724 procedure lck
725 (
726 p_elig_per_elctbl_chc_id in number
727 ,p_object_version_number in number
728 );
729 --
730 procedure CreOrSel_pil_elctbl_chc_popl
731 (p_per_in_ler_id in number
732 ,p_effective_date in date
733 ,p_business_group_id in number
734 ,p_pgm_id in number
735 ,p_plip_id in number
736 ,p_pl_id in number
737 ,p_oipl_id in number
738 ,p_yr_perd_id in number
739 ,p_uom in varchar2
740 ,p_acty_ref_perd_cd in varchar2
741 ,p_dflt_enrt_dt in date
742 ,p_cls_enrt_dt_to_use_cd in varchar2
743 ,p_enrt_typ_cycl_cd in varchar2
744 ,p_enrt_perd_end_dt in date
745 ,p_enrt_perd_strt_dt in date
746 ,p_procg_end_dt in date
747 ,p_lee_rsn_id in number
748 ,p_enrt_perd_id in number
749 ,p_request_id in number
750 ,p_program_application_id in number
751 ,p_program_id in number
752 ,p_program_update_date in date
753 ,p_ws_mgr_id in number
754 ,p_assignment_id in number
755 --
756 ,p_pil_elctbl_chc_popl_id out nocopy number
757 ,p_oiplip_id out nocopy number
758 );
759 --
760 end ben_ELIG_PER_ELC_CHC_api;
[Home] [Help]