1 Package pqh_rbc_rate_retrieval as
2 /* $Header: pqrbcpkg.pkh 120.3.12010000.1 2008/07/28 13:06:31 appldev ship $ */
3 --
4 --
5 Type g_rbc_rate_val_rec is record(minimum_rate pqh_rate_matrix_rates_f.min_rate_value%type,
6 maximum_rate pqh_rate_matrix_rates_f.min_rate_value%type,
7 mid_rate pqh_rate_matrix_rates_f.min_rate_value%type,
8 default_rate pqh_rate_matrix_rates_f.min_rate_value%type);
9 --
10 Type g_rbc_rate_val_tbl is table of g_rbc_rate_val_rec index by binary_integer;
11 --
12 -- Start of Changes to support PAYROLL EVENTS
13 --
14 Type g_rbc_factor_rec is record(rate_matrix_rate_id pqh_rate_matrix_rates_f.min_rate_value%type,
15 default_rate pqh_rate_matrix_rates_f.min_rate_value%type);
16 --
17 Type g_rbc_factor_tbl is table of g_rbc_factor_rec index by binary_integer;
18 --
19 -- End of Changes to support PAYROLL EVENTS
20 --
21 -- Main Rate retrieval function.
22 --
23 Type tc_ovrd_val is record(
24 column_name varchar2(30),
25 col_value varchar2(30));
26 --
27 Type tc_ovrd_tbl is table of tc_ovrd_val index by binary_integer;
28 --
29 g_entry_rec pay_element_entries_f%ROWTYPE;
30 --
31 g_ckf_rec pay_cost_allocation_keyflex%ROWTYPE;
32 --
33 g_entry_val_tbl tc_ovrd_tbl;
34 --
35 Procedure determine_rbc_rate
36 (p_element_entry_id IN number,
37 p_element_type_id IN number default null,
38 p_business_group_id IN number,
39 p_effective_date IN date,
40 p_rate_factors OUT nocopy g_rbc_factor_tbl,
41 p_rate_factor_cnt OUT nocopy number,
42 p_min_rate OUT nocopy number,
43 p_mid_rate OUT nocopy number,
44 p_max_rate OUT nocopy number,
45 p_rate OUT nocopy number);
46 --
47 Procedure determine_rbc_rate
48 (p_element_type_id IN number default null,
49 p_crit_rt_defn_id IN number default null,
50 p_person_id IN number default null,
51 p_assignment_id IN number default null,
52 p_business_group_id IN number,
53 p_effective_date IN date,
54 p_rate_factors OUT nocopy g_rbc_factor_tbl,
55 p_rate_factor_cnt OUT nocopy number,
56 p_min_rate OUT nocopy number,
57 p_mid_rate OUT nocopy number,
58 p_max_rate OUT nocopy number,
59 p_rate OUT nocopy number);
60 --
61 Procedure determine_rbc_rate
62 (p_element_type_id IN number default null,
63 p_crit_rt_defn_id IN number default null,
64 p_business_group_id IN number,
65 p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl,
66 p_effective_date IN date,
67 p_rate_factors OUT nocopy g_rbc_factor_tbl,
68 p_rate_factor_cnt OUT nocopy number,
69 p_min_rate OUT nocopy number,
70 p_mid_rate OUT nocopy number,
71 p_max_rate OUT nocopy number,
72 p_rate OUT nocopy number);
73 --
74 Function get_persons_rbc_rate
75 (p_element_type_id IN number default null,
76 p_crit_rt_defn_id IN number default null,
77 p_person_id IN number default null,
78 p_assignment_id IN number default null,
79 p_business_group_id IN number,
80 p_effective_date IN date)
81 return number;
82 --
83 Function get_persons_rbc_rate
84 (p_element_type_id IN number default null,
85 p_crit_rt_defn_id IN number default null,
86 p_business_group_id IN number,
87 p_criteria_list IN pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl,
88 p_effective_date IN date)
89 return number ;
90 --
91 Function get_ele_entry_rbc_rate
92 (p_element_entry_id IN number,
93 p_business_group_id IN number,
94 p_effective_date IN date)
95 return number;
96 --
97 Function get_ele_entry_rbc_rate
98 (p_element_entry_id IN number,
99 p_business_group_id IN number,
100 p_effective_date IN date,
101 p_element_type_id IN number)
102 return number;
103 --
104 End pqh_rbc_rate_retrieval;
105 --