1 package ben_derive_part_and_rate_cvg as
2 /* $Header: bendrcvg.pkh 120.0 2005/05/28 04:12:06 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 Coverage 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 g_cache_plip_los_rt_rec ben_derive_part_and_rate_cache.g_cache_los_rec_table;
30 --
31 g_cache_pl_age_rt_rec ben_derive_part_and_rate_cache.g_cache_age_rec_table;
32 g_cache_oipl_age_rt_rec ben_derive_part_and_rate_cache.g_cache_age_rec_table;
33 g_cache_plip_age_rt_rec ben_derive_part_and_rate_cache.g_cache_age_rec_table;
34 --
35 g_cache_pl_clf_rt_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_table;
36 g_cache_oipl_clf_rt_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_table;
37 g_cache_plip_clf_rt_rec ben_derive_part_and_rate_cache.g_cache_clf_rec_table;
38 --
39 g_cache_pl_cla_rt_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_table;
40 g_cache_oipl_cla_rt_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_table;
41 g_cache_plip_cla_rt_rec ben_derive_part_and_rate_cache.g_cache_cla_rec_table;
42 --
43 g_cache_pl_pff_rt_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_table;
44 g_cache_oipl_pff_rt_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_table;
45 g_cache_plip_pff_rt_rec ben_derive_part_and_rate_cache.g_cache_pff_rec_table;
46 --
47 g_cache_pl_hwf_rt_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_table;
48 g_cache_oipl_hwf_rt_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_table;
49 g_cache_plip_hwf_rt_rec ben_derive_part_and_rate_cache.g_cache_hwf_rec_table;
50 --
51 procedure get_los_rate
52 (p_pl_id in number,
53 p_oipl_id in number,
54 p_plip_id in number,
55 p_old_val in number default null,
56 p_new_val in number default null,
57 p_business_group_id in number,
58 p_effective_date in date,
59 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_los_rec_obj);
60 --
61 procedure get_age_rate
62 (p_pl_id in number,
63 p_oipl_id in number,
64 p_plip_id in number,
65 p_old_val in number default null,
66 p_new_val in number default null,
67 p_business_group_id in number,
68 p_effective_date in date,
69 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_age_rec_obj);
70 --
71 procedure get_comp_rate
72 (p_pl_id in number,
73 p_oipl_id in number,
74 p_plip_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_clf_rec_obj);
80 --
81 procedure get_comb_rate
82 (p_pl_id in number,
83 p_oipl_id in number,
84 p_plip_id in number,
85 p_old_val in number default null,
86 p_new_val in number default null,
87 p_business_group_id in number,
88 p_effective_date in date,
89 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_cla_rec_obj);
90 --
91 procedure get_pct_rate
92 (p_pl_id in number,
93 p_oipl_id in number,
94 p_plip_id in number,
95 p_old_val in number default null,
96 p_new_val in number default null,
97 p_business_group_id in number,
98 p_effective_date in date,
99 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_pff_rec_obj);
100 --
101 procedure get_hours_rate
102 (p_pl_id in number,
103 p_oipl_id in number,
104 p_plip_id in number,
105 p_old_val in number default null,
106 p_new_val in number default null,
107 p_business_group_id in number,
108 p_effective_date in date,
109 p_rec out nocopy ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj);
110 --
111 procedure clear_down_cache;
112 --
113 end ben_derive_part_and_rate_cvg;