1 Package BEN_DETERMINE_VARIABLE_RATES AS
2 /* $Header: benvrbrt.pkh 120.0.12000000.1 2007/01/19 19:09:46 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name
11 Determine Variable Rates
12 Purpose:
13 Determine Variable rates for activity base rates, coverages, and actl premiums.
14 This process establishes if variable rate profiles or variable rate rules are
15 used, if profiles are used call evaluate profile process to determine profile to
16 use, if rules are used call fast formula to return value, and finally passes
17 back the value information for the first profile/rule that passes.
18
19 History:
20 Date Who Version What?
21 ---- --- ------- -----
22 2 Jun 97 Ty Hayden 110.0 Created.
23 7 Oct 98 T Guy 115.2 Implemented schema changes for
24 ben_enrt_rt
25 30-OCT-98 G PERRY 115.3 Removed Control m
26 18-Jan-99 G Perry 115.4 LED V ED
27 09 Mar 99 G Perry 115.5 IS to AS.
28 27 May 99 maagrawa 115.6 Modified the procedure to be called without
29 chc_id and pass the reqd. parameters instead.
30 21 Jun 99 lmcdonal 115.7 Moved limit check code into its own
31 procedure.
32 1 Jul 99 lmcdonal 115.8 removed limit check to benutils.
33 20-JUL-99 Gperry 115.9 genutils -> benutils package
34 rename.
35 29-May-00 mhoyes 115.10 - Added defaulted record structures.
36 28-Jun-00 mhoyes 115.11 - Added p_currepe_row to main.
37 21-mar-01 tilak 115.12 param ultmt_upt_lmt,ultmt_lwr_lmt added
38 01-apr-01 tilak 115.13 param ultmt_upt_lmt_calc_rl,ultmt_lwr_lmt_calc_rl added
39 26-Sep-01 kmahendr 115.14 - Added ann_mn_elcn_val, ann_mx_elcn_val param
40 13-Nov-02 vsethi 115.15 Bug 1210355, Added package variable g_vrbl_mlt_code
41 to store the mlt_code defined in profile
42 23-Dec-2002 rpgupta 115.16 Nocopy changes
43 */
44 --------------------------------------------------------------------------------
45
46 --------------------------------------------------------------------------------
47 -------------------------------- main -----------------------------------------
48 --------------------------------------------------------------------------------
49 PROCEDURE main
50 (p_currepe_row in ben_determine_rates.g_curr_epe_rec
51 := ben_determine_rates.g_def_curr_epe_rec
52 ,p_per_row in per_all_people_F%rowtype
53 := ben_determine_rates.g_def_curr_per_rec
54 ,p_asg_row in per_all_assignments_f%rowtype
55 := ben_determine_rates.g_def_curr_asg_rec
56 ,p_ast_row in per_assignment_status_types%rowtype
57 := ben_determine_rates.g_def_curr_ast_rec
58 ,p_adr_row in per_addresses%rowtype
59 := ben_determine_rates.g_def_curr_adr_rec
60 ,p_person_id IN number
61 ,p_elig_per_elctbl_chc_id IN number
62 ,p_enrt_bnft_id IN number default null
63 ,p_actl_prem_id IN number default null --\
64 ,p_acty_base_rt_id IN number default null -- Only one of these 3 have val.
65 ,p_cvg_amt_calc_mthd_id IN number default null --/
66 ,p_effective_date IN date
67 ,p_lf_evt_ocrd_dt IN date
68 ,p_calc_only_rt_val_flag in boolean default false
69 ,p_pgm_id in number default null
70 ,p_pl_id in number default null
71 ,p_oipl_id in number default null
72 ,p_pl_typ_id in number default null
73 ,p_per_in_ler_id in number default null
74 ,p_ler_id in number default null
75 ,p_business_group_id in number default null
76 ,p_bnft_amt in number default null
77 ,p_val out nocopy number
78 ,p_mn_elcn_val out nocopy number
79 ,p_mx_elcn_val out nocopy number
80 ,p_incrmnt_elcn_val out nocopy number
81 ,p_dflt_elcn_val out nocopy number
82 ,p_tx_typ_cd out nocopy varchar2
83 ,p_acty_typ_cd out nocopy varchar2
84 ,p_vrbl_rt_trtmt_cd out nocopy varchar2
85 ,p_ultmt_upr_lmt out nocopy number
86 ,p_ultmt_lwr_lmt out nocopy number
87 ,p_ultmt_upr_lmt_calc_rl out nocopy number
88 ,p_ultmt_lwr_lmt_calc_rl out nocopy number
89 ,p_ann_mn_elcn_val out nocopy number
90 ,p_ann_mx_elcn_val out nocopy number
91 );
92
93 -- Bug 1210355
94 g_vrbl_mlt_code varchar2(30);
95 --
96 end ben_determine_variable_rates;
[Home] [Help]