1 Package BEN_DETERMINE_COVERAGE AUTHID CURRENT_USER as
2 /* $Header: bencvrge.pkh 120.0.12010000.1 2008/07/29 12:05:42 appldev ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name:
11 Determine Coverage
12
13 Purpose:
14 Determines proper coverages based on mlt_cd. Writes to BEN_ENRT_BNFT table.
15
16 History:
17 Date Who Version What?
18 ---- --- ------- -----
19 7 May 97 Ty Hayden 110.0 Created.
20 22 Oct 98 T Guy 115.2 No change.
21 18 Jan 99 G Perry 115.3 LED V ED
22 09 Mar 99 G Perry 115.4 IS to AS.
23 07-Jan-01 mhoyes 115.26 - Made round_val and
24 combine_with_variable_val public.
25 23-Jan-01 mhoyes 115.6 - Added calculate only mode for EFC.
26 23-Dec-02 lakrish 115.7 NOCOPY changes
27 */
28 --------------------------------------------------------------------------------
29 --
30 Type ENBValType is record
31 (enrt_bnft_id number
32 ,val number
33 ,mn_val number
34 ,mx_val number
35 ,mx_wout_ctfn_val number
36 ,incrmt_val number
37 ,dflt_val number
38 );
39 --
40 FUNCTION round_val
41 (p_val in number,
42 p_effective_date in date,
43 p_lf_evt_ocrd_dt in date,
44 p_rndg_cd in varchar2,
45 p_rndg_rl in number) return number;
46 --
47 PROCEDURE combine_with_variable_val
48 (p_vr_val in number,
49 p_val in number,
50 p_vr_trtmt_cd in varchar2,
51 p_combined_val out nocopy number);
52 --
53 PROCEDURE main
54 (p_calculate_only_mode in boolean default false
55 ,p_elig_per_elctbl_chc_id IN number
56 ,p_effective_date IN date
57 ,p_lf_evt_ocrd_dt IN date
58 ,p_perform_rounding_flg IN boolean default true
59 --
60 ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType
61 );
62 --
63 end ben_determine_coverage;
[Home] [Help]