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;
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: --
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;
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: --
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;
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: --
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;
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: --
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;
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: --
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,
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;