1 package ben_derive_part_and_rate_prem as
2 /* $Header: bendrpre.pkh 120.0 2005/05/28 04:13:20 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Derive Participation and Rate Premium Routine
13 Purpose
14 This package is used to return or retrieve information that is
15 needed for rates and or factors.
16 History
17 Date Who Version What?
18 ---- --- ------- -----
19 23 Mar 00 G Perry 115.0 Created.
20
21 */
22 --------------------------------------------------------------------------------
23 --
24 -- Cache all derivable factor stuff for any particular plan or program or
25 -- oipl.
26 --
27 g_cache_pl_los_rt_rec ben_derive_part_and_rate_cache.g_cache_los_rec_table;
28 g_cache_oipl_los_rt_rec ben_derive_part_and_rate_cache.g_cache_los_rec_table;
29 --
30 g_cache_pl_age_rt_rec ben_derive_part_and_rate_cache.g_cache_age_rec_table;
31 g_cache_oipl_age_rt_rec ben_derive_part_and_rate_cache.g_cache_age_rec_table;
32 --
33 g_cache_pl_clf_rt_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_table;
34 g_cache_oipl_clf_rt_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_table;
35 --
36 g_cache_pl_cla_rt_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_table;
37 g_cache_oipl_cla_rt_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_table;
38 --
39 g_cache_pl_pff_rt_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_table;
40 g_cache_oipl_pff_rt_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_table;
41 --
42 g_cache_pl_hwf_rt_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_table;
43 g_cache_oipl_hwf_rt_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_table;
44 --
45 procedure get_los_rate
46 (p_pl_id in number,
47 p_oipl_id in number,
48 p_old_val in number default null,
49 p_new_val in number default null,
50 p_business_group_id in number,
51 p_effective_date in date,
52 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_los_rec_obj);
53 --
54 procedure get_age_rate
55 (p_pl_id in number,
56 p_oipl_id in number,
57 p_old_val in number default null,
58 p_new_val in number default null,
59 p_business_group_id in number,
60 p_effective_date in date,
61 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_age_rec_obj);
62 --
63 procedure get_comp_rate
64 (p_pl_id in number,
65 p_oipl_id in number,
66 p_old_val in number default null,
67 p_new_val in number default null,
68 p_business_group_id in number,
69 p_effective_date in date,
70 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_clf_rec_obj);
71 --
72 procedure get_comb_rate
73 (p_pl_id in number,
74 p_oipl_id in number,
75 p_old_val in number default null,
76 p_new_val in number default null,
77 p_business_group_id in number,
78 p_effective_date in date,
79 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_cla_rec_obj);
80 --
81 procedure get_pct_rate
82 (p_pl_id in number,
83 p_oipl_id in number,
84 p_old_val in number default null,
85 p_new_val in number default null,
86 p_business_group_id in number,
87 p_effective_date in date,
88 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_pff_rec_obj);
89 --
90 procedure get_hours_rate
91 (p_pl_id in number,
92 p_oipl_id in number,
93 p_old_val in number default null,
94 p_new_val in number default null,
95 p_business_group_id in number,
96 p_effective_date in date,
97 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj);
98 --
99 procedure clear_down_cache;
100 --
101 end ben_derive_part_and_rate_prem;
[Home] [Help]