1 package ben_evaluate_rate_profiles AUTHID CURRENT_USER as
2 /* $Header: benrtprf.pkh 120.0.12010000.1 2008/07/29 12:31:03 appldev ship $ */
3 --
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 Name
12 Variable Rate Profiles
13 Purpose
14 This package is used to determine benefit rates based on
15 profiles or rules associated with any person.
16 History
17 Date Who Version What?
18 -- -- --- ------- -----
19 07 Apr 98 T Guy 110.00 Created.
20 26 Aug 98 G Perry 115.2 Added header line.
21 22 Dec 98 T Guy 115.3 Added hrs_wrk, pct_fulltime
22 18 Jan 99 G Perry 115.4 LED V ED
23 09 Mar 99 T Mathers 115.5 Moved arcs header.
24 01 May 99 Shdas 115.6 Added parameters to check_rules.
25 27 may 99 maagrawa 115.7 Modified procedures to work
26 without a choice.
27 01 Jul 99 lmcdonal 115.8 Added check_ttl_prtt, check_ttl_cvg
28 03 Aug 99 lmcdonal 115.19 Add global rec structure. Add two
29 18 Aug 99 stee 115.20 Removed change_reason from
30 check_loa_rsn.
31 02 Nov 99 G Perry 115.12 Fixed procedure check_per_typ
32 to use all person type usages.
33 11 Nov 99 T Guy 115.13 Fixed parameters for derived fctrs
34 17 Nov 99 pbodla 115.14 Added acty_base_rt_id as parameter to
35 check_rules
36 19 Nov 99 pbodla 115.15 Added p_elig_per_elctbl_chc_id as
37 parameter to check_rules
38 27 Feb 00 lmcdonal 115.16 Added the profile flags to g_all_prfls
39 so that premium calcs will work.
40 27 Feb 00 lmcdonal 115.17 Ensure the second call to load
41 globals is only done when needed
42 by adding new parm.
43 29 Feb 00 lmcdonal 115.18 Bug 1220070. Added opt_id to
44 check_hrs_wkd, check_pct_fltm.
45 03 Mar 00 stee 115.19 Added pgm_id and pl_typ_id
46 to check_period_of_enrollment
47 for cobra by plan type.
48 06 Apr 00 lmcdonal 115.20 Make Check procedures private.
49 29 May 00 mhoyes 115.21 - Added defaulted record structures
50 to main.
51 28 Jun 00 mhoyes 115.22 - Added epe record to main.
52 11 Jan 01 ikasire 115.23 Bug 1566944 Added p_ler_id parameter to the
53 procedure check_period_of_enrollment
54 20 Sep 01 mhoyes 115.24 - Bug 1955152. Made g_profile_failed
55 and check_service_area public.
56 05-Jun-02 vsethi 115.25 Added code to handle the new rates flags
57 12-Jun-02 vsethi 115.26 Added code to handle the quartile and
58 performance rating
59 24-Sep-02 vsethi 115.28 - commented all the private procedure,
60 modified the call for check_sched_hrs
61
62 30-dec-2002 hmani 115.29 NoCopy changes
63 24-Jul-2003 mmudigon 115.30 Added rt_elig_prfl_flag to
64 g_all_prfls_rec
65 */
66
67 -- ------------------------------------------------------------------------------
68 --
69 -- Exceptions
70 --
71 g_profile_failed exception;
72 --
73 type g_all_prfls_rec is record
74 (vrbl_rt_prfl_id number,
75 match_cnt number,
76 match_cvg number,
77 val number,
78 asmt_to_use_cd varchar(30),
79 rt_hrly_slrd_flag varchar(30),
80 rt_pstl_cd_flag varchar(30),
81 rt_lbr_mmbr_flag varchar(30),
82 rt_lgl_enty_flag varchar(30),
83 rt_benfts_grp_flag varchar(30),
84 rt_wk_loc_flag varchar(30),
85 rt_brgng_unit_flag varchar(30),
86 rt_age_flag varchar(30),
87 rt_los_flag varchar(30),
88 rt_per_typ_flag varchar(30),
89 rt_fl_tm_pt_tm_flag varchar(30),
90 rt_ee_stat_flag varchar(30),
91 rt_grd_flag varchar(30),
92 rt_pct_fl_tm_flag varchar(30),
93 rt_asnt_set_flag varchar(30),
94 rt_hrs_wkd_flag varchar(30),
95 rt_comp_lvl_flag varchar(30),
96 rt_org_unit_flag varchar(30),
97 rt_loa_rsn_flag varchar(30),
98 rt_pyrl_flag varchar(30),
99 rt_schedd_hrs_flag varchar(30),
100 rt_py_bss_flag varchar(30),
101 rt_prfl_rl_flag varchar(30),
102 rt_cmbn_age_los_flag varchar(30),
103 rt_prtt_pl_flag varchar(30),
104 rt_svc_area_flag varchar(30),
105 rt_ppl_grp_flag varchar(30),
106 rt_dsbld_flag varchar(30),
107 rt_hlth_cvg_flag varchar(30),
108 rt_poe_flag varchar(30),
109 rt_ttl_cvg_vol_flag varchar(30),
110 rt_ttl_prtt_flag varchar(30),
111 rt_gndr_flag varchar(30),
112 rt_tbco_use_flag varchar(30),
113 rt_cntng_prtn_prfl_flag varchar(30),
114 rt_cbr_quald_bnf_flag varchar(30),
115 rt_optd_mdcr_flag varchar(30),
116 rt_lvg_rsn_flag varchar(30),
117 rt_pstn_flag varchar(30),
118 rt_comptncy_flag varchar(30),
119 rt_job_flag varchar(30),
120 rt_qual_titl_flag varchar(30),
121 rt_dpnt_cvrd_pl_flag varchar(30),
122 rt_dpnt_cvrd_plip_flag varchar(30),
123 rt_dpnt_cvrd_ptip_flag varchar(30),
124 rt_dpnt_cvrd_pgm_flag varchar(30),
125 rt_enrld_oipl_flag varchar(30),
126 rt_enrld_pl_flag varchar(30),
127 rt_enrld_plip_flag varchar(30),
128 rt_enrld_ptip_flag varchar(30),
129 rt_enrld_pgm_flag varchar(30),
130 rt_prtt_anthr_pl_flag varchar(30),
131 rt_othr_ptip_flag varchar(30),
132 rt_no_othr_cvg_flag varchar(30),
133 rt_dpnt_othr_ptip_flag varchar(30),
134 rt_qua_in_gr_flag varchar(30),
135 rt_perf_rtng_flag varchar(30),
136 rt_elig_prfl_flag varchar(30));
137
138 type g_all_prfls_table is table of g_all_prfls_rec
139 index by binary_integer;
140
141 g_all_prfls g_all_prfls_table;
142 g_no_match_cnt number ;
143 g_no_match_cvg number ;
144
145 g_use_prfls g_all_prfls_table;
146 g_num_of_prfls_used number ;
147 --
148 procedure init_globals ;
149
150 procedure main
151 (p_currepe_row in ben_determine_rates.g_curr_epe_rec
152 := ben_determine_rates.g_def_curr_epe_rec
153 ,p_per_row in per_all_people_F%rowtype
154 := ben_determine_rates.g_def_curr_per_rec
155 ,p_asg_row in per_all_assignments_f%rowtype
156 := ben_determine_rates.g_def_curr_asg_rec
157 ,p_ast_row in per_assignment_status_types%rowtype
158 := ben_determine_rates.g_def_curr_ast_rec
159 ,p_adr_row in per_addresses%rowtype
160 := ben_determine_rates.g_def_curr_adr_rec
161 ,p_person_id in number
162 ,p_elig_per_elctbl_chc_id in number
163 ,p_acty_base_rt_id in number default null
164 ,p_actl_prem_id in number default null
165 ,p_cvg_amt_calc_mthd_id in number default null
166 ,p_effective_date in date
167 ,p_lf_evt_ocrd_dt in date default null
168 ,p_calc_only_rt_val_flag in boolean default false
169 ,p_pgm_id in number default null
170 ,p_pl_id in number default null
171 ,p_pl_typ_id in number default null
172 ,p_oipl_id in number default null
173 ,p_per_in_ler_id in number default null
174 ,p_ler_id in number default null
175 ,p_business_group_id in number default null
176 ,p_ttl_prtt in number default null
177 ,p_ttl_cvg in number default null
178 ,p_all_prfls in boolean default false
179 ,p_use_globals in boolean default false
180 ,p_use_prfls in boolean default false
181 ,p_bnft_amt in number default null
182 ,p_vrbl_rt_prfl_id out nocopy number
183 );
184 /*
185 procedure check_brgng_unit
186 (p_vrbl_rt_prfl_id in number,
187 p_business_group_id in number,
188 p_effective_date in date,
189 p_lf_evt_ocrd_dt in date,
190 p_bargaining_unit_code in varchar2);
191 --
192 procedure check_benefits_grp
193 (p_vrbl_rt_prfl_id in number,
194 p_person_id in number,
195 p_business_group_id in number,
196 p_effective_date in date,
197 p_lf_evt_ocrd_dt in date,
198 p_benefit_group_id in number);
199 --
200 procedure check_ee_stat
201 (p_vrbl_rt_prfl_id in number,
202 p_person_id in number,
203 p_business_group_id in number,
204 p_effective_date in date,
205 p_lf_evt_ocrd_dt in date,
206 p_assignment_status_type_id in number);
207 --
208 procedure check_fl_tm_pt
209 (p_vrbl_rt_prfl_id in number,
210 p_person_id in number,
211 p_business_group_id in number,
212 p_effective_date in date,
213 p_lf_evt_ocrd_dt in date default null,
214 p_employment_category in varchar2);
215 --
216 procedure check_grade
217 (p_vrbl_rt_prfl_id in number,
218 p_person_id in number,
219 p_business_group_id in number,
220 p_effective_date in date,
221 p_lf_evt_ocrd_dt in date,
222 p_grade_id in number);
223 --
224 procedure check_hrs_wkd
225 (p_vrbl_rt_prfl_id in number,
226 p_person_id in number,
227 p_business_group_id in number,
228 p_effective_date in date,
229 p_lf_evt_ocrd_dt in date default null,
230 p_elig_per_elctbl_chc_id in number,
231 p_opt_id in number default null,
232 p_pl_id in number default null,
233 p_pgm_id in number default null);
234 --
235 procedure check_period_of_enrollment
236 (p_vrbl_rt_prfl_id in number,
237 p_business_group_id in number,
238 p_effective_date in date,
239 p_lf_evt_ocrd_dt in date default null,
240 p_person_id in number,
241 p_pgm_id in number default null,
242 p_pl_typ_id in number default null,
243 p_ler_id in number default null);
244 --
245 procedure check_lbr_union
246 (p_vrbl_rt_prfl_id in number,
247 p_person_id in number,
248 p_business_group_id in number,
249 p_effective_date in date,
250 p_lf_evt_ocrd_dt in date,
251 p_labour_union_member_flag in varchar2);
252 --
253 procedure check_loa_rsn
254 (p_vrbl_rt_prfl_id in number,
255 p_person_id in number,
256 p_business_group_id in number,
257 p_effective_date in date,
258 p_lf_evt_ocrd_dt in date);
259 --
260 procedure check_org_unit
261 (p_vrbl_rt_prfl_id in number,
262 p_person_id in number,
263 p_business_group_id in number,
264 p_effective_date in date,
265 p_lf_evt_ocrd_dt in date,
266 p_org_id in number);
267 --
268 procedure check_pct_fltm
269 (p_vrbl_rt_prfl_id in number,
270 p_person_id in number,
271 p_business_group_id in number,
272 p_effective_date in date,
273 p_lf_evt_ocrd_dt in date default null,
274 p_elig_per_elctbl_chc_id in number,
275 p_opt_id in number default null,
276 p_pl_id in number default null,
277 p_pgm_id in number default null);
278 --
279 procedure check_per_typ
280 (p_vrbl_rt_prfl_id in number,
281 p_person_id in number,
282 p_business_group_id in number,
283 p_effective_date in date,
284 p_lf_evt_ocrd_dt in date,
285 p_person_type in ben_person_object.g_cache_typ_table);
286 --
287 procedure check_zip_code_rng
288 (p_vrbl_rt_prfl_id in number,
289 p_person_id in number,
290 p_business_group_id in number,
291 p_effective_date in date,
292 p_lf_evt_ocrd_dt in date,
293 p_postal_code in varchar2);
294 --
295 procedure check_pyrl
296 (p_vrbl_rt_prfl_id in number,
297 p_person_id in number,
298 p_business_group_id in number,
299 p_effective_date in date,
300 p_lf_evt_ocrd_dt in date,
301 p_payroll_id in number);
302 --
303 procedure check_py_bss
304 (p_vrbl_rt_prfl_id in number,
305 p_person_id in number,
306 p_business_group_id in number,
307 p_effective_date in date,
308 p_lf_evt_ocrd_dt in date,
309 p_pay_basis_id in number);
310 --
311 procedure check_sched_hrs
312 (p_vrbl_rt_prfl_id in number
313 ,p_person_id in number
314 ,p_business_group_id in number
315 ,p_effective_date in date
316 ,p_lf_evt_ocrd_dt in date
317 ,p_normal_hrs in number
318 ,p_frequency in varchar2
319 ,p_per_in_ler_id in number
320 ,p_assignment_id in number
321 ,p_organization_id in number
322 ,p_pgm_id in number
323 ,p_pl_id in number
324 ,p_pl_typ_id in number
325 ,p_opt_id in number
326 ,p_oipl_id in number
327 ,p_ler_id in number
328 ,p_jurisdiction_code in varchar2 );
329 --
330 procedure check_wk_location
331 (p_vrbl_rt_prfl_id in number,
335 p_lf_evt_ocrd_dt in date,
332 p_person_id in number,
333 p_business_group_id in number,
334 p_effective_date in date,
336 p_location_id in number);
337 --
338 procedure check_lgl_enty
339 (p_vrbl_rt_prfl_id in number,
340 p_person_id in number,
341 p_business_group_id in number,
342 p_effective_date in date,
343 p_lf_evt_ocrd_dt in date,
344 p_gre_id in varchar2);
345 --
346 procedure check_gender
347 (p_vrbl_rt_prfl_id in number,
348 p_business_group_id in number,
349 p_effective_date in date,
350 p_lf_evt_ocrd_dt in date,
351 p_sex in varchar2);
352 --
353 procedure check_dsbld_cd
354 (p_vrbl_rt_prfl_id in number,
355 p_business_group_id in number,
356 p_effective_date in date,
357 p_lf_evt_ocrd_dt in date,
358 p_dsbld_cd in varchar2);
359 --
360 procedure check_tobacco
361 (p_vrbl_rt_prfl_id in number,
362 p_business_group_id in number,
363 p_effective_date in date,
364 p_lf_evt_ocrd_dt in date,
365 p_tobacco in varchar2);
366
367 procedure check_service_area
368 (p_vrbl_rt_prfl_id in number,
369 p_person_id in number,
370 p_business_group_id in number,
371 p_effective_date in date,
372 p_lf_evt_ocrd_dt in date,
373 p_postal_code in varchar2);
374 --
375 procedure check_hourly_salary
376 (p_vrbl_rt_prfl_id in number,
377 p_business_group_id in number,
378 p_effective_date in date,
379 p_lf_evt_ocrd_dt in date,
380 p_hrly_slry in varchar2);
381 --
382 procedure check_age
383 (p_vrbl_rt_prfl_id in number,
384 p_person_id in number,
385 p_business_group_id in number,
386 p_effective_date in date,
387 p_lf_evt_ocrd_dt in date default null,
388 p_elig_per_elctbl_chc_id in number,
389 p_pl_id in number default null,
390 p_pgm_id in number default null,
391 p_oipl_id in number default null,
392 p_per_in_ler_id in number default null);
393 --
394 procedure check_comp_level
395 (p_vrbl_rt_prfl_id in number,
396 p_person_id in number,
397 p_business_group_id in number,
398 p_effective_date in date,
399 p_lf_evt_ocrd_dt in date,
400 p_elig_per_elctbl_chc_id in number,
401 p_pl_id in number default null,
402 p_pgm_id in number default null,
403 p_oipl_id in number default null,
404 p_per_in_ler_id in number default null);
405 --
406 procedure check_los
407 (p_vrbl_rt_prfl_id in number,
408 p_person_id in number,
409 p_business_group_id in number,
410 p_effective_date in date,
411 p_lf_evt_ocrd_dt in date default null,
412 p_elig_per_elctbl_chc_id in number,
413 p_pl_id in number default null,
414 p_pgm_id in number default null,
415 p_oipl_id in number default null,
416 p_per_in_ler_id in number default null);
417
418 procedure check_age_los
419 (p_vrbl_rt_prfl_id in number,
420 p_person_id in number,
421 p_business_group_id in number,
422 p_effective_date in date,
423 p_lf_evt_ocrd_dt in date default null,
424 p_elig_per_elctbl_chc_id in number,
425 p_pl_id in number default null,
426 p_pgm_id in number default null,
427 p_oipl_id in number default null,
428 p_per_in_ler_id in number default null);
429 --
430 procedure check_ttl_prtt
431 (p_vrbl_rt_prfl_id in number
432 ,p_business_group_id in number
433 ,p_effective_date in date
434 ,p_lf_evt_ocrd_dt in date
435 ,p_ttl_prtt in number default null);
436
437 procedure check_ttl_cvg
438 (p_vrbl_rt_prfl_id in number
439 ,p_business_group_id in number
440 ,p_effective_date in date
441 ,p_lf_evt_ocrd_dt in date
442 ,p_ttl_cvg in number default null);
443
444 procedure check_rules
445 (p_vrbl_rt_prfl_id in number,
446 p_business_group_id in number,
447 p_effective_date in date,
451 p_pgm_id in number,
448 p_lf_evt_ocrd_dt in date,
449 p_assignment_id in number,
450 p_organization_id in number,
452 p_pl_id in number,
453 p_pl_typ_id in number,
454 p_opt_id in number,
455 p_ler_id in number,
456 p_acty_base_rt_id in number default null,
457 p_elig_per_elctbl_chc_id in number default null,
458 p_jurisdiction_code in varchar2
459 );
460
461
462 procedure check_people_group
463 (p_vrbl_rt_prfl_id in number
464 ,p_business_group_id in number
465 ,p_effective_date in date
466 ,p_lf_evt_ocrd_dt in date
467 ,p_people_group_id in varchar2);
468
469 -- --------------------------------------------------
470 -- Job
471 -- --------------------------------------------------
472 procedure check_job(p_vrbl_rt_prfl_id in number,
473 p_business_group_id in number,
474 p_effective_date in date,
475 p_lf_evt_ocrd_dt in date,
476 p_job_id in number);
477
478 -- --------------------------------------------------
479 -- Opted for Medicare
480 -- --------------------------------------------------
481 procedure check_optd_mdcr(p_vrbl_rt_prfl_id in number,
482 p_business_group_id in number,
483 p_effective_date in date,
484 p_lf_evt_ocrd_dt in date,
485 p_person_id in number);
486
487 -- --------------------------------------------------
488 -- Leaving Reason
489 -- --------------------------------------------------
490 procedure check_lvg_rsn(p_vrbl_rt_prfl_id in number,
491 p_business_group_id in number,
492 p_effective_date in date,
493 p_lf_evt_ocrd_dt in date,
494 p_person_id in number) ;
495
496 -- --------------------------------------------------
497 -- Cobra Qualified Beneficiary
498 -- --------------------------------------------------
499 procedure check_cbr_quald_bnf(p_vrbl_rt_prfl_id in number,
500 p_business_group_id in number,
501 p_effective_date in date,
502 p_person_id in number,
503 p_lf_evt_ocrd_dt in date) ;
504
505 -- --------------------------------------------------
506 -- Position
507 -- --------------------------------------------------
508 procedure check_pstn(p_vrbl_rt_prfl_id in number,
509 p_business_group_id in number,
510 p_asg_position_id in number,
511 p_effective_date in date,
512 p_lf_evt_ocrd_dt in date) ;
513
514 -- --------------------------------------------------
515 -- Competency
516 -- --------------------------------------------------
517 procedure check_comptncy(p_vrbl_rt_prfl_id in number,
518 p_business_group_id in number,
519 p_person_id in number,
520 p_effective_date date,
521 p_lf_evt_ocrd_dt date);
522
523 -- --------------------------------------------------
524 -- Qualification Titile
525 -- --------------------------------------------------
526 procedure check_qual_titl(p_vrbl_rt_prfl_id in number,
527 p_business_group_id in number,
528 p_person_id in number,
529 p_effective_date date,
530 p_lf_evt_ocrd_dt date);
531
532 -- --------------------------------------------------
533 -- DEPENDENT COVERED OTHER PLAN
534 -- --------------------------------------------------
535 procedure check_dpnt_cvrd_othr_pl(p_vrbl_rt_prfl_id in number,
536 p_business_group_id in number,
537 p_effective_date in date,
538 p_person_id in number ,
539 p_lf_evt_ocrd_dt in date);
540
541 -- --------------------------------------------------
542 -- DEPENDENT COVERED OTHER PLAN IN PROGRAM
543 -- --------------------------------------------------
544 procedure check_dpnt_cvrd_othr_plip (p_vrbl_rt_prfl_id in number,
545 p_business_group_id in number,
546 p_effective_date in date,
547 p_person_id in number ,
548 p_lf_evt_ocrd_dt in date);
549
550 -- --------------------------------------------------
551 -- DEPENDENT COVERED OTHER PLAN TYPE IN PROGRAM
552 -- --------------------------------------------------
553 procedure check_dpnt_cvrd_othr_ptip(p_vrbl_rt_prfl_id in number,
554 p_business_group_id in number,
555 p_effective_date in date,
556 p_person_id in number,
557 p_lf_evt_ocrd_dt in date) ;
558
559 -- --------------------------------------------------
560 -- DEPENDENT COVERED OTHER PROGRAM
561 -- --------------------------------------------------
562 procedure check_dpnt_cvrd_othr_pgm(p_vrbl_rt_prfl_id in number,
563 p_business_group_id in number,
567
564 p_effective_date in date,
565 p_person_id in number,
566 p_lf_evt_ocrd_dt in date) ;
568 -- --------------------------------------------------
569 -- ELIGIBLE FOR ANOTHER PLAN
570 -- --------------------------------------------------
571 procedure check_prtt_anthr_pl(p_vrbl_rt_prfl_id in number,
572 p_business_group_id in number,
573 p_person_id in number,
574 p_effective_date in date,
575 p_lf_evt_ocrd_dt in date);
576
577 -- --------------------------------------------------
578 -- ELIGIBLE FOR ANOTHER PLAN TYPE IN PROGRAM
579 -- --------------------------------------------------
580 procedure check_othr_ptip
581 (p_vrbl_rt_prfl_id in number
582 ,p_business_group_id in number
583 ,p_effective_date in date
584 ,p_lf_evt_ocrd_dt in date
585 ,p_person_id in number
586 ,p_per_in_ler_id in number default null ) ;
587
588 -- --------------------------------------------------------------------------
589 -- ENROLLED IN ANOTHER PLAN
590 -- --------------------------------------------------------------------------
591 procedure check_enrld_anthr_pl(p_vrbl_rt_prfl_id in number,
592 p_business_group_id in number,
593 p_pl_id in number,
594 p_person_id in number,
595 p_effective_date in date,
596 p_lf_evt_ocrd_dt in date) ;
597
598 -- --------------------------------------------------------------------------
599 -- ENROLLED IN ANOTHER OPTION IN PLAN.
600 -- --------------------------------------------------------------------------
601 procedure check_enrld_anthr_oipl(p_vrbl_rt_prfl_id in number,
602 p_business_group_id in number,
603 p_oipl_id in number,
604 p_person_id in number,
605 p_effective_date in date,
606 p_lf_evt_ocrd_dt in date);
607
608 -- --------------------------------------------------------------------------
609 -- ENROLLED OTHER PLAN TYPE IN PROGRAM.
610 -- --------------------------------------------------------------------------
611 procedure check_enrld_anthr_ptip(p_vrbl_rt_prfl_id in number,
612 p_business_group_id in number,
613 p_effective_date in date,
614 p_lf_evt_ocrd_dt in date) ;
615
616 -- --------------------------------------------------------------------------
617 -- ENROLLED IN ANOTHER PLAN IN PROGRAM.
618 -- --------------------------------------------------------------------------
619 procedure check_enrld_anthr_plip(p_vrbl_rt_prfl_id in number,
620 p_business_group_id in number,
621 p_person_id in number,
622 p_effective_date in date,
623 p_lf_evt_ocrd_dt in date);
624
625 -- --------------------------------------------------------------------------
626 -- ENROLLED IN ANOTHER PROGRAM.
627 -- --------------------------------------------------------------------------
628 procedure check_enrld_anthr_pgm
629 ( -- p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec ,
630 p_vrbl_rt_prfl_id in number
631 ,p_business_group_id in number
632 ,p_pgm_id in number
633 ,p_person_id in number
634 ,p_effective_date in date
635 ,p_lf_evt_ocrd_dt in date ) ;
636
637 -- --------------------------------------------------------------------------
638 -- DEPENDENT OTHER PLAN TYPE IN PROGRAM
639 -- --------------------------------------------------------------------------
640 procedure check_dpnt_othr_ptip
641 (p_vrbl_rt_prfl_id in number
642 ,p_business_group_id in number
643 ,p_effective_date in date
644 ,p_lf_evt_ocrd_dt in date
645 ,p_person_id in number
646 ,p_per_in_ler_id in number);
647
648 -- --------------------------------------------------
649 -- NO OTHER COVERAGE
650 -- --------------------------------------------------
651 procedure check_no_othr_cvg(p_vrbl_rt_prfl_id in number,
652 p_business_group_id in number,
653 p_person_id in number,
654 p_effective_date in date,
655 p_lf_evt_ocrd_dt in date) ;
656
657
658 -- --------------------------------------------------
659 -- Quartile in Grade
660 -- --------------------------------------------------
661 procedure check_qua_in_gr(p_vrbl_rt_prfl_id in number,
662 p_business_group_id in number,
663 p_person_id in number,
664 p_grade_id in number,
665 p_assignment_id in number,
666 p_effective_date date,
667 p_lf_evt_ocrd_dt date);
668
669 -- --------------------------------------------------
670 -- Performance Rating
671 -- --------------------------------------------------
672 procedure check_perf_rtng(p_vrbl_rt_prfl_id in number,
673 p_business_group_id in number,
674 p_assignment_id in number,
675 p_person_id in number,
676 p_effective_date date,
677 p_lf_evt_ocrd_dt date) ;
678 */
679
680 end ben_evaluate_rate_profiles;
[Home] [Help]