1 Package BEN_DETERMINE_ACTIVITY_BASE_RT AUTHID CURRENT_USER as
2 /* $Header: benactbr.pkh 120.2.12010000.1 2008/07/29 12:02:39 appldev ship $ */
3 --------------------------------------------------------------------------------
4 -- main
5 --------------------------------------------------------------------------------
6 PROCEDURE main
7 (p_currepe_row in ben_determine_rates.g_curr_epe_rec
8 := ben_determine_rates.g_def_curr_epe_rec
9 ,p_per_row in per_all_people_F%rowtype
10 := ben_determine_rates.g_def_curr_per_rec
11 ,p_asg_row in per_all_assignments_f%rowtype
12 := ben_determine_rates.g_def_curr_asg_rec
13 ,p_ast_row in per_assignment_status_types%rowtype
14 := ben_determine_rates.g_def_curr_ast_rec
15 ,p_adr_row in per_addresses%rowtype
16 := ben_determine_rates.g_def_curr_adr_rec
17 ,p_person_id IN number
18 ,p_elig_per_elctbl_chc_id IN number
19 ,p_enrt_bnft_id IN number default null
20 ,p_acty_base_rt_id IN number
21 ,p_effective_date IN date
22 ,p_lf_evt_ocrd_dt IN date default null
23 ,p_perform_rounding_flg IN boolean default true
24 ,p_calc_only_rt_val_flag in boolean default false
25 ,p_pl_id in number default null
26 ,p_oipl_id in number default null
27 ,p_pgm_id in number default null
28 ,p_pl_typ_id in number default null
29 ,p_per_in_ler_id in number default null
30 ,p_ler_id in number default null
31 ,p_bnft_amt in number default null
32 ,p_business_group_id in number default null
33 ,p_cal_val in number default null
34 ,p_parent_val in number default null
35 ,p_called_from_ss in boolean default false --6314463
36 ,p_val OUT NOCOPY number
37 ,p_mn_elcn_val OUT NOCOPY number
38 ,p_mx_elcn_val OUT NOCOPY number
39 ,p_ann_val OUT NOCOPY number
40 ,p_ann_mn_elcn_val OUT NOCOPY number
41 ,p_ann_mx_elcn_val OUT NOCOPY number
42 ,p_cmcd_val OUT NOCOPY number
43 ,p_cmcd_mn_elcn_val OUT NOCOPY number
44 ,p_cmcd_mx_elcn_val OUT NOCOPY number
45 ,p_cmcd_acty_ref_perd_cd OUT NOCOPY varchar2
46 ,p_incrmt_elcn_val OUT NOCOPY number
47 ,p_dflt_val OUT NOCOPY number
48 ,p_tx_typ_cd OUT NOCOPY varchar2
49 ,p_acty_typ_cd OUT NOCOPY varchar2
50 ,p_nnmntry_uom OUT NOCOPY varchar2
51 ,p_entr_val_at_enrt_flag OUT NOCOPY varchar2
52 ,p_dsply_on_enrt_flag OUT NOCOPY varchar2
53 ,p_use_to_calc_net_flx_cr_flag OUT NOCOPY varchar2
54 ,p_rt_usg_cd OUT NOCOPY varchar2
55 ,p_bnft_prvdr_pool_id OUT NOCOPY number
56 ,p_actl_prem_id OUT NOCOPY number
57 ,p_cvg_calc_amt_mthd_id OUT NOCOPY number
58 ,p_bnft_rt_typ_cd OUT NOCOPY varchar2
59 ,p_rt_typ_cd OUT NOCOPY varchar2
60 ,p_rt_mlt_cd OUT NOCOPY varchar2
61 ,p_comp_lvl_fctr_id OUT NOCOPY number
62 ,p_entr_ann_val_flag OUT NOCOPY varchar2
63 ,p_ptd_comp_lvl_fctr_id OUT NOCOPY number
64 ,p_clm_comp_lvl_fctr_id OUT NOCOPY number
65 ,p_ann_dflt_val OUT NOCOPY number
66 ,p_rt_strt_dt OUT NOCOPY date
67 ,p_rt_strt_dt_cd OUT NOCOPY varchar2
68 ,p_rt_strt_dt_rl OUT NOCOPY number
69 ,p_prtt_rt_val_id OUT NOCOPY number
70 ,p_dsply_mn_elcn_val OUT NOCOPY number
71 ,p_dsply_mx_elcn_val OUT NOCOPY number
72 ,p_pp_in_yr_used_num OUT NOCOPY number
73 ,p_ordr_num OUT NOCOPY number
74 ,p_iss_val OUT NOCOPY number
75 );
76
77 --------------------------------------------------------------------------------
78 -- main_w
79 --------------------------------------------------------------------------------
80 PROCEDURE main_w
81 (p_person_id IN number
82 ,p_elig_per_elctbl_chc_id IN number
83 ,p_enrt_bnft_id IN number default null
84 ,p_acty_base_rt_id IN number
85 ,p_effective_date IN date
86 ,p_lf_evt_ocrd_dt IN date default null
87 ,p_calc_only_rt_val_flag in varchar2 default 'N'
88 ,p_pl_id in number default null
89 ,p_oipl_id in number default null
90 ,p_pgm_id in number default null
91 ,p_pl_typ_id in number default null
92 ,p_per_in_ler_id in number default null
93 ,p_ler_id in number default null
94 ,p_bnft_amt in number default null
95 ,p_business_group_id in number default null
96 ,p_val OUT NOCOPY number
97 ,p_ann_val OUT NOCOPY number
98 ,p_cmcd_val OUT NOCOPY number);
99 --
100 l_icd_chc_rates_tab ben_icm_life_events.icd_chc_rates_tab;
101 --
102 end ben_determine_activity_base_rt;