1 Package ben_PRTT_ENRT_RESULT_api as
2 /* $Header: bepenapi.pkh 120.2.12010000.1 2008/07/29 12:46:49 appldev ship $ */
3 --
4 -- Global Variables:
5 --
6 g_multi_rows_validate boolean := TRUE;
7 -- g_debug boolean := FALSE;
8 g_enrollment_change boolean := FALSE;
9 -- ----------------------------------------------------------------------------
10 -- |------------------------< get_ben_pen_upd_dt_mode >------------------------|
11 -- ----------------------------------------------------------------------------
12 procedure get_ben_pen_upd_dt_mode
13 (p_effective_date in date
14 ,p_base_key_value in number
15 ,P_desired_datetrack_mode in varchar2
16 ,P_datetrack_allow in out nocopy varchar2
17 ,p_ler_typ_cd in varchar2 default null
18 );
19 --
20 -- ----------------------------------------------------------------------------
21 -- |------------------------< create_enrollment >------------------------|
22 -- ----------------------------------------------------------------------------
23 -- Description: Business Process on top of Create_Prtt_Enrt_Rslt procedure.
24 -- This process handle electable choice table.
25 --
26 -- Prerequisites:
27 --
28 -- Post Success:
29 --
30 -- Out Parameters:
31 -- Name Type Description
32 -- p_prtt_enrt_rslt_id Yes number PK of record
33 -- p_effective_start_date Yes date Effective Start Date of Record
34 -- p_effective_end_date Yes date Effective End Date of Record
35 -- p_object_version_number No number OVN of record
36 --
37 -- Post Failure:
38 --
39 -- Access Status:
40 -- Public.
41 --
42 -- {End Of Comments}
43 --
44 procedure create_enrollment
45 (p_validate in boolean default false
46 ,p_prtt_enrt_rslt_id out nocopy number
47 ,p_effective_start_date out nocopy date
48 ,p_effective_end_date out nocopy date
49 ,p_business_group_id in number default null
50 ,p_oipl_id in number default null
51 ,p_person_id in number default null
52 ,p_assignment_id in number default null
53 ,p_pgm_id in number default null
54 ,p_pl_id in number default null
55 ,p_rplcs_sspndd_rslt_id in number default null
56 ,p_ptip_id in number default null
57 ,p_pl_typ_id in number default null
58 ,p_ler_id in number default null
59 ,p_sspndd_flag in varchar2 default 'N'
60 ,p_called_from_sspnd in varchar2 default 'N'
61 ,p_prtt_is_cvrd_flag in varchar2 default 'N'
62 ,p_bnft_amt in number default null
63 ,p_uom in varchar2 default null
64 ,p_orgnl_enrt_dt in date default null
65 ,p_enrt_mthd_cd in varchar2 default null
66 ,p_enrt_ovridn_flag in varchar2 default 'N'
67 ,p_enrt_ovrid_rsn_cd in varchar2 default null
68 ,p_erlst_deenrt_dt in date default null
69 ,p_enrt_cvg_strt_dt in date default null
70 ,p_enrt_cvg_thru_dt in date default hr_api.g_eot
71 ,p_enrt_ovrid_thru_dt in date default null
72 ,p_pl_ordr_num in number default null
73 ,p_plip_ordr_num in number default null
74 ,p_ptip_ordr_num in number default null
75 ,p_oipl_ordr_num in number default null
76 ,p_pen_attribute_category in varchar2 default null
77 ,p_pen_attribute1 in varchar2 default null
78 ,p_pen_attribute2 in varchar2 default null
79 ,p_pen_attribute3 in varchar2 default null
80 ,p_pen_attribute4 in varchar2 default null
81 ,p_pen_attribute5 in varchar2 default null
82 ,p_pen_attribute6 in varchar2 default null
83 ,p_pen_attribute7 in varchar2 default null
84 ,p_pen_attribute8 in varchar2 default null
85 ,p_pen_attribute9 in varchar2 default null
86 ,p_pen_attribute10 in varchar2 default null
87 ,p_pen_attribute11 in varchar2 default null
88 ,p_pen_attribute12 in varchar2 default null
89 ,p_pen_attribute13 in varchar2 default null
90 ,p_pen_attribute14 in varchar2 default null
91 ,p_pen_attribute15 in varchar2 default null
92 ,p_pen_attribute16 in varchar2 default null
93 ,p_pen_attribute17 in varchar2 default null
94 ,p_pen_attribute18 in varchar2 default null
95 ,p_pen_attribute19 in varchar2 default null
96 ,p_pen_attribute20 in varchar2 default null
97 ,p_pen_attribute21 in varchar2 default null
98 ,p_pen_attribute22 in varchar2 default null
99 ,p_pen_attribute23 in varchar2 default null
100 ,p_pen_attribute24 in varchar2 default null
101 ,p_pen_attribute25 in varchar2 default null
102 ,p_pen_attribute26 in varchar2 default null
103 ,p_pen_attribute27 in varchar2 default null
104 ,p_pen_attribute28 in varchar2 default null
105 ,p_pen_attribute29 in varchar2 default null
106 ,p_pen_attribute30 in varchar2 default null
107 ,p_request_id in number default null
108 ,p_program_application_id in number default null
109 ,p_program_id in number default null
110 ,p_program_update_date in date default null
111 ,p_object_version_number out nocopy number
112 ,p_per_in_ler_id in number default null
113 ,p_bnft_typ_cd in varchar2 default null
114 ,p_bnft_ordr_num in number default null
115 ,p_prtt_enrt_rslt_stat_cd in varchar2 default null
116 ,p_bnft_nnmntry_uom in varchar2 default null
117 ,p_comp_lvl_cd in varchar2 default null
118 ,p_effective_date in date
119 ,p_multi_row_validate in boolean default TRUE
120 ,p_elig_per_elctbl_chc_id in number
121 ,p_prtt_enrt_rslt_id_o in number
122 ,p_suspend_flag out nocopy varchar2
123 ,p_prtt_enrt_interim_id out nocopy number
124 ,p_datetrack_mode in varchar2
125 ,p_dpnt_actn_warning out nocopy boolean
126 ,p_bnf_actn_warning out nocopy boolean
127 ,p_ctfn_actn_warning out nocopy boolean
128 ,p_enrt_bnft_id in Number default null
129 ,p_source in varchar2 default null
130 );
131 -- ----------------------------------------------------------------------------
132 -- |------------------------< create_PRTT_ENRT_RESULT >------------------------|
133 -- ----------------------------------------------------------------------------
134 --
135 -- Description:
136 --
137 -- Prerequisites:
138 --
139 -- In Parameters:
140 -- Name Reqd Type Description
141 -- p_validate Yes boolean Commit or Rollback.
142 -- p_business_group_id Yes number Business Group of Record
143 -- p_oipl_id No number
144 -- p_person_id Yes number
145 -- p_assignment_id No number
146 -- p_pgm_id No number
147 -- p_pl_id Yes number
148 -- p_rplcs_sspndd_rslt_id No number
149 -- p_ptip_id No number
150 -- p_pl_typ_id No number
151 -- p_ler_id Yes number
152 -- p_sspndd_flag Yes varchar2
153 -- p_prtt_is_cvrd_flag Yes varchar2
154 -- p_bnft_amt No number
155 -- p_uom No varchar2
156 -- p_orgnl_enrt_dt No date
157 -- p_enrt_mthd_cd Yes varchar2
158 -- p_no_lngr_elig_flag No varchar2
159 -- p_enrt_ovridn_flag Yes varchar2
160 -- p_enrt_ovrid_rsn_cd No varchar2
161 -- p_erlst_deenrt_dt No date
162 -- p_enrt_cvg_strt_dt No date
163 -- p_enrt_cvg_thru_dt No date
164 -- p_enrt_ovrid_thru_dt No date
165 -- p_pen_attribute_category No varchar2 Descriptive Flexfield
166 -- p_pen_attribute1 No varchar2 Descriptive Flexfield
167 -- p_pen_attribute2 No varchar2 Descriptive Flexfield
168 -- p_pen_attribute3 No varchar2 Descriptive Flexfield
169 -- p_pen_attribute4 No varchar2 Descriptive Flexfield
170 -- p_pen_attribute5 No varchar2 Descriptive Flexfield
171 -- p_pen_attribute6 No varchar2 Descriptive Flexfield
172 -- p_pen_attribute7 No varchar2 Descriptive Flexfield
173 -- p_pen_attribute8 No varchar2 Descriptive Flexfield
174 -- p_pen_attribute9 No varchar2 Descriptive Flexfield
175 -- p_pen_attribute10 No varchar2 Descriptive Flexfield
176 -- p_pen_attribute11 No varchar2 Descriptive Flexfield
177 -- p_pen_attribute12 No varchar2 Descriptive Flexfield
178 -- p_pen_attribute13 No varchar2 Descriptive Flexfield
179 -- p_pen_attribute14 No varchar2 Descriptive Flexfield
180 -- p_pen_attribute15 No varchar2 Descriptive Flexfield
181 -- p_pen_attribute16 No varchar2 Descriptive Flexfield
182 -- p_pen_attribute17 No varchar2 Descriptive Flexfield
183 -- p_pen_attribute18 No varchar2 Descriptive Flexfield
184 -- p_pen_attribute19 No varchar2 Descriptive Flexfield
185 -- p_pen_attribute20 No varchar2 Descriptive Flexfield
186 -- p_pen_attribute21 No varchar2 Descriptive Flexfield
187 -- p_pen_attribute22 No varchar2 Descriptive Flexfield
188 -- p_pen_attribute23 No varchar2 Descriptive Flexfield
189 -- p_pen_attribute24 No varchar2 Descriptive Flexfield
190 -- p_pen_attribute25 No varchar2 Descriptive Flexfield
191 -- p_pen_attribute26 No varchar2 Descriptive Flexfield
192 -- p_pen_attribute27 No varchar2 Descriptive Flexfield
193 -- p_pen_attribute28 No varchar2 Descriptive Flexfield
194 -- p_pen_attribute29 No varchar2 Descriptive Flexfield
195 -- p_pen_attribute30 No varchar2 Descriptive Flexfield
196 -- p_request_id No number
197 -- p_program_application_id No number
198 -- p_program_id No number
199 -- p_program_update_date No date
200 -- p_effective_date Yes date Session Date.
201 --
202 -- Post Success:
203 --
204 -- Out Parameters:
205 -- Name Type Description
206 -- p_prtt_enrt_rslt_id Yes number PK of record
207 -- p_effective_start_date Yes date Effective Start Date of Record
208 -- p_effective_end_date Yes date Effective End Date of Record
209 -- p_object_version_number No number OVN of record
210 --
211 -- Post Failure:
212 --
213 -- Access Status:
214 -- Public.
215 --
216 -- {End Of Comments}
217 --
218 procedure create_PRTT_ENRT_RESULT
219 (
220 p_validate in boolean default false
221 ,p_prtt_enrt_rslt_id out nocopy number
222 ,p_effective_start_date out nocopy date
223 ,p_effective_end_date out nocopy date
224 ,p_business_group_id in number default null
225 ,p_oipl_id in number default null
226 ,p_person_id in number default null
227 ,p_assignment_id in number default null
228 ,p_pgm_id in number default null
229 ,p_pl_id in number default null
230 ,p_rplcs_sspndd_rslt_id in number default null
231 ,p_ptip_id in number default null
232 ,p_pl_typ_id in number default null
233 ,p_ler_id in number default null
234 ,p_sspndd_flag in varchar2 default 'N'
235 ,p_prtt_is_cvrd_flag in varchar2 default 'N'
236 ,p_bnft_amt in number default null
237 ,p_uom in varchar2 default null
238 ,p_orgnl_enrt_dt in date default null
239 ,p_enrt_mthd_cd in varchar2 default null
240 ,p_no_lngr_elig_flag in varchar2 default 'N'
241 ,p_enrt_ovridn_flag in varchar2 default 'N'
242 ,p_enrt_ovrid_rsn_cd in varchar2 default null
243 ,p_erlst_deenrt_dt in date default null
244 ,p_enrt_cvg_strt_dt in date default null
245 ,p_enrt_cvg_thru_dt in date default hr_api.g_eot
246 ,p_enrt_ovrid_thru_dt in date default null
247 ,p_pl_ordr_num in number default null
248 ,p_plip_ordr_num in number default null
249 ,p_ptip_ordr_num in number default null
250 ,p_oipl_ordr_num in number default null
251 ,p_pen_attribute_category in varchar2 default null
252 ,p_pen_attribute1 in varchar2 default null
253 ,p_pen_attribute2 in varchar2 default null
254 ,p_pen_attribute3 in varchar2 default null
255 ,p_pen_attribute4 in varchar2 default null
256 ,p_pen_attribute5 in varchar2 default null
257 ,p_pen_attribute6 in varchar2 default null
258 ,p_pen_attribute7 in varchar2 default null
259 ,p_pen_attribute8 in varchar2 default null
260 ,p_pen_attribute9 in varchar2 default null
261 ,p_pen_attribute10 in varchar2 default null
262 ,p_pen_attribute11 in varchar2 default null
263 ,p_pen_attribute12 in varchar2 default null
264 ,p_pen_attribute13 in varchar2 default null
265 ,p_pen_attribute14 in varchar2 default null
266 ,p_pen_attribute15 in varchar2 default null
267 ,p_pen_attribute16 in varchar2 default null
268 ,p_pen_attribute17 in varchar2 default null
269 ,p_pen_attribute18 in varchar2 default null
270 ,p_pen_attribute19 in varchar2 default null
271 ,p_pen_attribute20 in varchar2 default null
272 ,p_pen_attribute21 in varchar2 default null
273 ,p_pen_attribute22 in varchar2 default null
274 ,p_pen_attribute23 in varchar2 default null
275 ,p_pen_attribute24 in varchar2 default null
276 ,p_pen_attribute25 in varchar2 default null
277 ,p_pen_attribute26 in varchar2 default null
278 ,p_pen_attribute27 in varchar2 default null
279 ,p_pen_attribute28 in varchar2 default null
280 ,p_pen_attribute29 in varchar2 default null
281 ,p_pen_attribute30 in varchar2 default null
282 ,p_request_id in number default null
283 ,p_program_application_id in number default null
284 ,p_program_id in number default null
285 ,p_program_update_date in date default null
286 ,p_object_version_number out nocopy number
287 ,p_per_in_ler_id in number default null
288 ,p_bnft_typ_cd in varchar2 default null
292 ,p_comp_lvl_cd in varchar2 default null
289 ,p_bnft_ordr_num in number default null
290 ,p_prtt_enrt_rslt_stat_cd in varchar2 default null
291 ,p_bnft_nnmntry_uom in varchar2 default null
293 ,p_effective_date in date
294 ,p_multi_row_validate in boolean default TRUE
295 );
296 -- ----------------------------------------------------------------------------
297 -- |------------------------< update_ENROLLMENT >------------------------|
298 -- ----------------------------------------------------------------------------
299 -- {Start Of Comments}
300 --
301 -- Description:
302 --
303 -- Prerequisites:
304 --
305 -- In Parameters:
306 --
307 -- Post Success:
308 --
309 -- Post Failure:
310 --
311 -- Access Status:
312 -- Public.
313 --
314 -- {End Of Comments}
315 --
316 procedure update_ENROLLMENT
317 (
318 p_validate in boolean default false
319 ,p_prtt_enrt_rslt_id in number
320 ,p_effective_start_date out nocopy date
321 ,p_effective_end_date out nocopy date
322 ,p_business_group_id in number default hr_api.g_number
323 ,p_oipl_id in number default hr_api.g_number
324 ,p_person_id in number default hr_api.g_number
325 ,p_assignment_id in number default hr_api.g_number
326 ,p_pgm_id in number default hr_api.g_number
327 ,p_pl_id in number default hr_api.g_number
328 ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
329 ,p_ptip_id in number default hr_api.g_number
330 ,p_pl_typ_id in number default hr_api.g_number
331 ,p_ler_id in number default hr_api.g_number
332 ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
333 ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
334 ,p_enrt_bnft_id in number default NULL
335 ,p_bnft_amt in number default hr_api.g_number
336 ,p_uom in varchar2 default hr_api.g_varchar2
337 ,p_orgnl_enrt_dt in date default hr_api.g_date
338 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
339 ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
340 ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
341 ,p_erlst_deenrt_dt in date default hr_api.g_date
342 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
343 ,p_enrt_cvg_thru_dt in date default hr_api.g_date
344 ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
345 ,p_pl_ordr_num in number default hr_api.g_number
346 ,p_plip_ordr_num in number default hr_api.g_number
347 ,p_ptip_ordr_num in number default hr_api.g_number
348 ,p_oipl_ordr_num in number default hr_api.g_number
349 ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
350 ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
351 ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
352 ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
353 ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
354 ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
355 ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
356 ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
357 ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
358 ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
359 ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
360 ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
361 ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
362 ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
363 ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
364 ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
365 ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
366 ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
367 ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
368 ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
369 ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
370 ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
371 ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
372 ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
373 ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
374 ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
375 ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
376 ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
377 ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
378 ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
379 ,p_pen_attribute30 in varchar2 default hr_api.g_varchar2
380 ,p_request_id in number default hr_api.g_number
381 ,p_program_application_id in number default hr_api.g_number
385 ,p_per_in_ler_id in number default hr_api.g_number
382 ,p_program_id in number default hr_api.g_number
383 ,p_program_update_date in date default hr_api.g_date
384 ,p_object_version_number in out nocopy number
386 ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
387 ,p_bnft_ordr_num in number default hr_api.g_number
388 ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
389 ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
390 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
391 ,p_effective_date in date
392 ,p_datetrack_mode in varchar2
393 ,p_multi_row_validate in boolean default TRUE
394 ,p_suspend_flag out nocopy varchar2
395 ,p_prtt_enrt_interim_id out nocopy number
396 ,p_dpnt_actn_warning out nocopy boolean
397 ,p_bnf_actn_warning out nocopy boolean
398 ,p_ctfn_actn_warning out nocopy boolean
399 );
400 -- ----------------------------------------------------------------------------
401 -- |------------------------< update_PRTT_ENRT_RESULT >------------------------|
402 -- ----------------------------------------------------------------------------
403 -- {Start Of Comments}
404 --
405 -- Description:
406 --
407 -- Prerequisites:
408 --
409 --
410 -- In Parameters:
411 -- Name Reqd Type Description
412 -- p_validate Yes boolean Commit or Rollback.
413 -- p_prtt_enrt_rslt_id Yes number PK of record
414 -- p_business_group_id Yes number Business Group of Record
415 -- p_oipl_id No number
416 -- p_person_id Yes number
417 -- p_assignment_id No number
418 -- p_pgm_id No number
419 -- p_pl_id Yes number
420 -- p_rplcs_sspndd_rslt_id No number
421 -- p_ptip_id No number
422 -- p_pl_typ_id No number
423 -- p_ler_id Yes number
424 -- p_sspndd_flag Yes varchar2
425 -- p_prtt_is_cvrd_flag Yes varchar2
426 -- p_bnft_amt No number
427 -- p_uom No varchar2
428 -- p_orgnl_enrt_dt No date
429 -- p_enrt_mthd_cd Yes varchar2
430 -- p_no_lngr_elig_flag No varchar2
431 -- p_enrt_ovridn_flag Yes varchar2
432 -- p_enrt_ovrid_rsn_cd No varchar2
433 -- p_erlst_deenrt_dt No date
434 -- p_enrt_cvg_strt_dt No date
435 -- p_enrt_cvg_thru_dt No date
436 -- p_enrt_ovrid_thru_dt No date
437 -- p_pen_attribute_category No varchar2 Descriptive Flexfield
438 -- p_pen_attribute1 No varchar2 Descriptive Flexfield
439 -- p_pen_attribute2 No varchar2 Descriptive Flexfield
440 -- p_pen_attribute3 No varchar2 Descriptive Flexfield
441 -- p_pen_attribute4 No varchar2 Descriptive Flexfield
442 -- p_pen_attribute5 No varchar2 Descriptive Flexfield
443 -- p_pen_attribute6 No varchar2 Descriptive Flexfield
444 -- p_pen_attribute7 No varchar2 Descriptive Flexfield
445 -- p_pen_attribute8 No varchar2 Descriptive Flexfield
446 -- p_pen_attribute9 No varchar2 Descriptive Flexfield
447 -- p_pen_attribute10 No varchar2 Descriptive Flexfield
448 -- p_pen_attribute11 No varchar2 Descriptive Flexfield
449 -- p_pen_attribute12 No varchar2 Descriptive Flexfield
450 -- p_pen_attribute13 No varchar2 Descriptive Flexfield
451 -- p_pen_attribute14 No varchar2 Descriptive Flexfield
452 -- p_pen_attribute15 No varchar2 Descriptive Flexfield
453 -- p_pen_attribute16 No varchar2 Descriptive Flexfield
454 -- p_pen_attribute17 No varchar2 Descriptive Flexfield
455 -- p_pen_attribute18 No varchar2 Descriptive Flexfield
456 -- p_pen_attribute19 No varchar2 Descriptive Flexfield
457 -- p_pen_attribute20 No varchar2 Descriptive Flexfield
458 -- p_pen_attribute21 No varchar2 Descriptive Flexfield
459 -- p_pen_attribute22 No varchar2 Descriptive Flexfield
460 -- p_pen_attribute23 No varchar2 Descriptive Flexfield
461 -- p_pen_attribute24 No varchar2 Descriptive Flexfield
462 -- p_pen_attribute25 No varchar2 Descriptive Flexfield
463 -- p_pen_attribute26 No varchar2 Descriptive Flexfield
464 -- p_pen_attribute27 No varchar2 Descriptive Flexfield
465 -- p_pen_attribute28 No varchar2 Descriptive Flexfield
466 -- p_pen_attribute29 No varchar2 Descriptive Flexfield
467 -- p_pen_attribute30 No varchar2 Descriptive Flexfield
468 -- p_request_id No number
469 -- p_program_application_id No number
470 -- p_program_id No number
471 -- p_program_update_date No date
472 -- p_effective_date Yes date Session Date.
473 -- p_datetrack_mode Yes varchar2 Datetrack mode.
474 --
475 -- Post Success:
476 --
477 -- Name Type Description
481 --
478 -- p_effective_start_date Yes date Effective Start Date of Record
479 -- p_effective_end_date Yes date Effective End Date of Record
480 -- p_object_version_number No number OVN of record
482 -- Post Failure:
483 --
484 -- Access Status:
485 -- Public.
486 --
487 -- {End Of Comments}
488 --
489 procedure update_PRTT_ENRT_RESULT
490 (
491 p_validate in boolean default false
492 ,p_prtt_enrt_rslt_id in number
493 ,p_effective_start_date out nocopy date
494 ,p_effective_end_date out nocopy date
495 ,p_business_group_id in number default hr_api.g_number
496 ,p_oipl_id in number default hr_api.g_number
497 ,p_person_id in number default hr_api.g_number
498 ,p_assignment_id in number default hr_api.g_number
499 ,p_pgm_id in number default hr_api.g_number
500 ,p_pl_id in number default hr_api.g_number
501 ,p_rplcs_sspndd_rslt_id in number default hr_api.g_number
502 ,p_ptip_id in number default hr_api.g_number
503 ,p_pl_typ_id in number default hr_api.g_number
504 ,p_ler_id in number default hr_api.g_number
505 ,p_sspndd_flag in varchar2 default hr_api.g_varchar2
506 ,p_prtt_is_cvrd_flag in varchar2 default hr_api.g_varchar2
507 ,p_bnft_amt in number default hr_api.g_number
508 ,p_uom in varchar2 default hr_api.g_varchar2
509 ,p_orgnl_enrt_dt in date default hr_api.g_date
510 ,p_enrt_mthd_cd in varchar2 default hr_api.g_varchar2
511 ,p_no_lngr_elig_flag in varchar2 default hr_api.g_varchar2
512 ,p_enrt_ovridn_flag in varchar2 default hr_api.g_varchar2
513 ,p_enrt_ovrid_rsn_cd in varchar2 default hr_api.g_varchar2
514 ,p_erlst_deenrt_dt in date default hr_api.g_date
515 ,p_enrt_cvg_strt_dt in date default hr_api.g_date
516 ,p_enrt_cvg_thru_dt in date default hr_api.g_date
517 ,p_enrt_ovrid_thru_dt in date default hr_api.g_date
518 ,p_pl_ordr_num in number default hr_api.g_number
519 ,p_plip_ordr_num in number default hr_api.g_number
520 ,p_ptip_ordr_num in number default hr_api.g_number
521 ,p_oipl_ordr_num in number default hr_api.g_number
522 ,p_pen_attribute_category in varchar2 default hr_api.g_varchar2
523 ,p_pen_attribute1 in varchar2 default hr_api.g_varchar2
524 ,p_pen_attribute2 in varchar2 default hr_api.g_varchar2
525 ,p_pen_attribute3 in varchar2 default hr_api.g_varchar2
526 ,p_pen_attribute4 in varchar2 default hr_api.g_varchar2
527 ,p_pen_attribute5 in varchar2 default hr_api.g_varchar2
528 ,p_pen_attribute6 in varchar2 default hr_api.g_varchar2
529 ,p_pen_attribute7 in varchar2 default hr_api.g_varchar2
530 ,p_pen_attribute8 in varchar2 default hr_api.g_varchar2
531 ,p_pen_attribute9 in varchar2 default hr_api.g_varchar2
532 ,p_pen_attribute10 in varchar2 default hr_api.g_varchar2
533 ,p_pen_attribute11 in varchar2 default hr_api.g_varchar2
534 ,p_pen_attribute12 in varchar2 default hr_api.g_varchar2
535 ,p_pen_attribute13 in varchar2 default hr_api.g_varchar2
536 ,p_pen_attribute14 in varchar2 default hr_api.g_varchar2
537 ,p_pen_attribute15 in varchar2 default hr_api.g_varchar2
538 ,p_pen_attribute16 in varchar2 default hr_api.g_varchar2
539 ,p_pen_attribute17 in varchar2 default hr_api.g_varchar2
540 ,p_pen_attribute18 in varchar2 default hr_api.g_varchar2
541 ,p_pen_attribute19 in varchar2 default hr_api.g_varchar2
542 ,p_pen_attribute20 in varchar2 default hr_api.g_varchar2
543 ,p_pen_attribute21 in varchar2 default hr_api.g_varchar2
544 ,p_pen_attribute22 in varchar2 default hr_api.g_varchar2
545 ,p_pen_attribute23 in varchar2 default hr_api.g_varchar2
546 ,p_pen_attribute24 in varchar2 default hr_api.g_varchar2
547 ,p_pen_attribute25 in varchar2 default hr_api.g_varchar2
548 ,p_pen_attribute26 in varchar2 default hr_api.g_varchar2
549 ,p_pen_attribute27 in varchar2 default hr_api.g_varchar2
550 ,p_pen_attribute28 in varchar2 default hr_api.g_varchar2
551 ,p_pen_attribute29 in varchar2 default hr_api.g_varchar2
552 ,p_pen_attribute30 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_per_in_ler_id in number default hr_api.g_number
559 ,p_bnft_typ_cd in varchar2 default hr_api.g_varchar2
560 ,p_bnft_ordr_num in number default hr_api.g_number
561 ,p_prtt_enrt_rslt_stat_cd in varchar2 default hr_api.g_varchar2
565 ,p_datetrack_mode in varchar2
562 ,p_bnft_nnmntry_uom in varchar2 default hr_api.g_varchar2
563 ,p_comp_lvl_cd in varchar2 default hr_api.g_varchar2
564 ,p_effective_date in date
566 ,p_multi_row_validate in boolean default TRUE
567 );
568 --
569 -- ----------------------------------------------------------------------------
570 -- |------------------------< void_enrollment >-------------------------------|
571 -- ----------------------------------------------------------------------------
572
573 procedure void_enrollment
574 (p_validate in boolean default false
575 ,p_per_in_ler_id in number
576 ,p_prtt_enrt_rslt_id in number
577 ,p_business_group_id in number
578 ,p_enrt_cvg_strt_dt in date default null
579 ,p_person_id in number default null
580 ,p_elig_per_elctbl_chc_id in number default null
581 ,p_epe_ovn in number default null
582 ,p_object_version_number in number default null
583 ,p_effective_date in date
584 ,p_datetrack_mode in varchar2
585 ,p_multi_row_validate in boolean default TRUE
586 ,p_source in varchar2 default null
587 ,p_enrt_bnft_id in number default null);
588
589 -- ----------------------------------------------------------------------------
590 -- |------------------------< delete_enrollment >------------------------|
591 -- ----------------------------------------------------------------------------
592 --
593 -- Description:
594 --
595 -- Prerequisites:
596 --
597 --
598 -- In Parameters:
599 -- Name Reqd Type Description
600 -- p_validate Yes boolean Commit or Rollback.
601 -- p_prtt_enrt_rslt_id Yes number PK of record
602 -- p_effective_date Yes date Session Date.
603 -- p_datetrack_mode Yes varchar2 Datetrack mode.
604 --
605 -- Post Success:
606 --
607 -- Name Type Description
608 -- p_effective_start_date Yes date Effective Start Date of Record
609 -- p_effective_end_date Yes date Effective End Date of Record
610 -- p_object_version_number No number OVN of record
611 --
612 -- Post Failure:
613 --
614 -- Access Status:
615 -- Public.
616 --
617 --
618 procedure delete_enrollment
619 (
620 p_validate in boolean default false
621 ,p_per_in_ler_id in number default NULL
622 ,p_lee_rsn_id in number default NULL
623 ,p_enrt_perd_id in number default NULL
624 ,p_prtt_enrt_rslt_id in number
625 ,p_business_group_id in number
626 ,p_effective_start_date out nocopy date
627 ,p_effective_end_date out nocopy date
628 ,p_object_version_number in out nocopy number
629 ,p_effective_date in date
630 ,p_datetrack_mode in varchar2
631 ,p_multi_row_validate in boolean default TRUE
632 ,p_source in varchar2 default null
633 ,p_enrt_cvg_thru_dt in date default null
634 ,p_mode in varchar2 default null
635 );
636 --
637 -- ----------------------------------------------------------------------------
638 -- |------------------------< delete_enrollment_w >------------------------|
639 -- ----------------------------------------------------------------------------
640 --
641 -- Description: Self-Service Wrapper procedure to handle exception
642 -- while calling delete_enrollment from SS
643 --
644 -- Prerequisites:
645 --
646 --
647 -- In Parameters:
648 -- Name Reqd Type Description
649 -- p_validate Yes boolean Commit or Rollback.
650 -- p_prtt_enrt_rslt_id Yes number PK of record
651 -- p_effective_date Yes date Session Date.
652 -- p_datetrack_mode Yes varchar2 Datetrack mode.
653 --
654 -- Post Success:
655 --
656 -- Name Type Description
657 -- p_effective_start_date Yes date Effective Start Date of Record
658 -- p_effective_end_date Yes date Effective End Date of Record
659 -- p_object_version_number No number OVN of record
660 --
661 -- Post Failure:
662 --
663 -- Access Status:
664 -- Public.
665 --
666 --
667 procedure delete_enrollment_w
668 (
669 p_validate in boolean default false
670 ,p_per_in_ler_id in number default NULL
671 ,p_lee_rsn_id in number default NULL
672 ,p_enrt_perd_id in number default NULL
673 ,p_prtt_enrt_rslt_id in number
674 ,p_business_group_id in number
675 ,p_effective_start_date out nocopy date
676 ,p_effective_end_date out nocopy date
677 ,p_object_version_number in out nocopy number
678 ,p_effective_date in date
679 ,p_datetrack_mode in varchar2
680 ,p_multi_row_validate in boolean default TRUE
681 ,p_source in varchar2 default null
682 ,p_enrt_cvg_thru_dt in date default null
686 -- ----------------------------------------------------------------------------
683 ,p_mode in varchar2 default null
684 );
685 --
687 -- |------------------------< delete_PRTT_ENRT_RESULT >------------------------|
688 -- ----------------------------------------------------------------------------
689 --
690 -- Description:
691 --
692 -- Prerequisites:
693 --
694 --
695 -- In Parameters:
696 -- Name Reqd Type Description
697 -- p_validate Yes boolean Commit or Rollback.
698 -- p_prtt_enrt_rslt_id Yes number PK of record
699 -- p_effective_date Yes date Session Date.
700 -- p_datetrack_mode Yes varchar2 Datetrack mode.
701 --
702 -- Post Success:
703 --
704 -- Name Type Description
705 -- p_effective_start_date Yes date Effective Start Date of Record
706 -- p_effective_end_date Yes date Effective End Date of Record
707 -- p_object_version_number No number OVN of record
708 --
709 -- Post Failure:
710 --
711 -- Access Status:
712 -- Public.
713 --
714 -- {End Of Comments}
715 --
716 procedure delete_PRTT_ENRT_RESULT
717 (
718 p_validate in boolean default false
719 ,p_prtt_enrt_rslt_id in number
720 ,p_effective_start_date out nocopy date
721 ,p_effective_end_date out nocopy date
722 ,p_object_version_number in out nocopy number
723 ,p_effective_date in date
724 ,p_datetrack_mode in varchar2
725 ,p_multi_row_validate in boolean default TRUE
726 );
727 --
728 -- ----------------------------------------------------------------------------
729 -- |----------------------------------< lck >---------------------------------|
730 -- ----------------------------------------------------------------------------
731 --
732 -- Description:
733 --
734 -- Prerequisites:
735 --
736 --
737 -- In Parameters:
738 -- Name Reqd Type Description
739 -- p_prtt_enrt_rslt_id Yes number PK of record
740 -- p_object_version_number Yes number OVN of record
741 -- p_effective_date Yes date Session Date.
742 -- p_datetrack_mode Yes varchar2 Datetrack mode.
743 --
744 -- Post Success:
745 --
746 -- Name Type Description
747 -- p_validation_start_date Yes Derived Effective Start Date.
748 -- p_validation_end_date Yes Derived Effective End Date.
749 --
750 -- Post Failure:
751 --
752 -- Access Status:
753 -- Public.
754 --
755 -- {End Of Comments}
756 --
757 procedure lck
758 (
759 p_prtt_enrt_rslt_id in number
760 ,p_object_version_number in number
761 ,p_effective_date in date
762 ,p_datetrack_mode in varchar2
763 ,p_validation_start_date out nocopy date
764 ,p_validation_end_date out nocopy date
765 );
766 --
767 -- ----------------------------------------------------------------------------
768 -- |----------------------------------< multi_row_edit >---------------------------------|
769 -- ----------------------------------------------------------------------------
770 --
771 -- Description:
772 -- This procedure will invoke the multi row edit procedure in Row handler
773 --
774 -- Prerequisites:
775 -- All rows must be enrolled or de-enrolled before this procedure is called.
776 --
777 -- In Parameters:
778 -- Name Reqd Type Description
779 -- p_person_id Yes number Person ID
780 -- p_effective_date Yes date
781 -- p_business_group_id Yes number
782 -- p_pgm_id Yes number
783 -- p_per_in_ler_id No Number
784 --
785 -- Post Success:
786 --
787 -- Name Type Description
788 -- p_validation_start_date Yes Derived Effective Start Date.
789 -- p_validation_end_date Yes Derived Effective End Date.
790 --
791 -- Post Failure:
792 --
793 -- Access Status:
794 -- Public.
795 --
796 --
797 procedure multi_rows_edit
798 (p_person_id in number,
799 p_effective_date in date,
800 p_business_group_id in number,
801 p_pgm_id in number,
802 p_per_in_ler_id in number default NULL,
803 p_include_erl in varchar2,
804 p_called_frm_ss in Boolean default FALSE
805 );
806 --
807 -- Overloaded
808 --
809 procedure multi_rows_edit
810 (p_person_id in number,
811 p_effective_date in date,
812 p_business_group_id in number,
813 p_pgm_id in number,
814 p_per_in_ler_id in number default NULL,
815 p_called_frm_ss in Boolean default FALSE
816 );
817
818 --Start Bug 5768795
819 procedure chk_coverage_across_plan_types
820 ( p_person_id in number,
821 p_effective_date in date,
822 p_lf_evt_ocrd_dt in date,
823 p_business_group_id in number,
824 p_pgm_id in number,
825 p_minimum_check_flag in varchar default 'Y',
829 -- ----------------------------------------------------------------------------
826 p_suspended_enrt_check_flag in varchar default 'Y');
827 --End Bug 5768795
828 --
830 -- |-------------------------< calc_dpnt_cvg_dt >------------------------------|
831 -- ----------------------------------------------------------------------------
832 --
833 -- Description:
834 -- This procedure will calculate the coverage end date and Rate end date.
835 --
836 -- Prerequisites:
837 -- Elig_elctbl_chc_Id or all Comp. objects and per_in_ler_id passed
838 --
839 -- In Parameters:
840 -- Name Reqd Type Description
841 -- p_calc_end_dt No boolean
842 -- P_calc_strt_dt No boolean
843 -- P_per_in_ler_id No Number
844 -- p_person_id No number
845 -- p_pgm_id No number
846 -- p_pl_id No number
847 -- p_oipl_id No number
848 -- p_ptip_id No number
849 -- p_ler_id No number
850 -- p_elig_per_elctbl_chc_id No number
851 -- p_enrt_cvg_end_dt No date
852 -- p_business_group_id Yes number
853 -- p_effective_date Yes date
854 --
855 -- Post Success:
856 --
857 -- Name Type Description
858 -- p_returned_strt_dt date
859 -- p_returned_end_dt date
860 --
861 -- Post Failure:
862 --
863 -- Access Status:
864 -- Public.
865 --
866 --
867 procedure calc_dpnt_cvg_dt
868 (p_calc_end_dt in boolean default FALSE
869 ,P_calc_strt_dt in boolean default FALSE
870 ,P_per_in_ler_id in number default NULL
871 ,p_person_id in number default NULL
872 ,p_pgm_id in number default NULL
873 ,p_pl_id in number default NULL
874 ,p_oipl_id in number default NULL
875 ,p_ptip_id in number default NULL
876 ,p_ler_id in number default NULL
877 ,p_elig_per_elctbl_chc_id in number default NULL
878 ,p_business_group_id in number
879 ,p_effective_date in date
880 ,p_enrt_cvg_end_dt in date default NULL
881 ,p_returned_strt_dt out nocopy date
882 ,p_returned_end_dt out nocopy date
883 );
884 --
885 -- ----------------------------------------------------------------------------
886 -- |-------------------------< calc_dpnt_cvg_dt >------------------------------|
887 -- ----------------------------------------------------------------------------
888 --
889 -- Description:
890 -- This procedure will calculate the coverage end date and Rate end date.
891 --
892 -- Prerequisites:
893 -- Elig_elctbl_chc_Id or all Comp. objects and per_in_ler_id passed
894 --
895 -- In Parameters:
896 -- Name Reqd Type Description
897 -- p_elig_per_elctbl_chc_id No number
898 -- p_pgm_id No number
899 -- p_pl_id No number
900 -- p_ptip_id No number
901 -- p_ler_id No number
902 -- p_effective_date Yes date
903 -- p_business_group_id Yes number
904 --
905 -- Post Success:
906 --
907 -- Name Type Description
908 -- p_cvg_strt_cd varchar2
909 -- p_cvg_strt_rl number
910 -- p_cvg_end_cd varchar2
911 -- p_cvg_end_rl number
912 --
913 -- Post Failure:
914 --
915 -- Access Status:
916 -- Private.
917 --
918 --
919 procedure determine_dpnt_cvg_dt_cd
920 (p_elig_per_elctbl_chc_id in number default NULL
921 ,p_pgm_id in number default NULL
922 ,p_pl_id in number default NULL
923 ,p_ptip_id in number default NULL
924 ,p_ler_id in number default NULL
925 ,p_effective_date in date
926 ,p_business_group_id in number
927 ,p_cvg_strt_cd out nocopy varchar2
928 ,p_cvg_strt_rl out nocopy number
929 ,p_cvg_end_cd out nocopy varchar2
930 ,p_cvg_end_rl out nocopy number
931 );
932 --
933 -- ----------------------------------------------------------------------------
934 -- |----------------------------< unhook_Bnf >---------------------------------|
935 -- ----------------------------------------------------------------------------
936 --
937 -- Description:
938 -- This procedure will unhook all benificiary for the participant.
939 --
940 -- Prerequisites:
941 --
942 --
943 -- In Parameters:
944 -- Name Reqd Type Description
945 -- p_validate No boolean
946 -- p_prtt_enrt_rslt_id No Number
947 -- p_business_group_id No Number
948 -- p_effective_date Yes date
949 -- p_datetrack_mode Yes varchar2
950 --
951 -- Post Success:
952 --
953 -- Name Type Description
954 --
955 -- Post Failure:
956 --
957 -- Access Status:
958 -- Private.
959 --
960 --
961 Procedure unhook_bnf
962 (p_validate in boolean default FALSE
963 ,p_prtt_enrt_rslt_id in number
964 ,p_per_in_ler_id in number
965 ,p_dsgn_thru_dt in date
966 ,p_business_group_id in number
967 ,p_effective_date in date
968 ,p_datetrack_mode in varchar2
969 ,p_rslt_delete_flag in boolean default FALSE
970 );
971 --
972 -- ----------------------------------------------------------------------------
973 -- |----------------------------< unhook_Dpnt >--------------------------------|
974 -- ----------------------------------------------------------------------------
975 --
976 -- Description:
977 -- This procedure will unhook all dependent for the participant.
978 --
979 -- Prerequisites:
980 --
981 --
982 -- In Parameters:
983 -- Name Reqd Type Description
984 -- p_validate Yes boolean
985 -- p_prtt_enrt_rslt_id Yes number
986 -- p_cvg_thru_dt Yes date
987 -- p_business_group_id Yes number
988 -- p_effective_date Yes date
989 -- p_datetrack_mode Yes varchar2
990 --
991 -- Post Success:
992 --
993 -- Name Type Description
994 --
995 -- Post Failure:
996 --
997 -- Access Status:
998 -- Private.
999 --
1000 --
1001 Procedure unhook_dpnt
1002 (p_validate in boolean default FALSE
1003 ,p_prtt_enrt_rslt_id in number
1004 ,p_per_in_ler_id in number
1005 ,p_cvg_thru_dt in date
1006 ,p_business_group_id in number
1007 ,p_effective_date in date
1008 ,p_datetrack_mode in varchar2
1009 ,p_rslt_delete_flag in Boolean default FALSE
1010 ,p_called_from in varchar2 default 'bepenapi'
1011 );
1012 --
1013 --
1014 -- ----------------------------------------------------------------------------
1015 -- |-----------------------< update_person_type_usages >-----------------------|
1016 -- ----------------------------------------------------------------------------
1017 --
1018 Procedure update_person_type_usages
1019 (p_person_id in number
1020 ,p_business_group_id in number
1021 ,p_effective_date in date
1022 );
1023 --
1024 end ben_PRTT_ENRT_RESULT_api;
[Home] [Help]