1 package BEN_CWB_PERSON_INFO_PKG AUTHID CURRENT_USER as
2 /* $Header: bencwbpi.pkh 120.1 2006/02/16 07:47:13 krmahade noship $ */
3 --
4 -- --------------------------------------------------------------------------
5 -- |---------------------------< get_years_in_job >--------------------------|
6 -- --------------------------------------------------------------------------
7 -- This function computes the years in job
8 function get_years_in_job(p_assignment_id in number
9 ,p_job_id in number
10 ,p_effective_date in date
11 ,p_asg_effective_start_date in date)
12 return number;
13 --
14 -- --------------------------------------------------------------------------
15 -- |-------------------------< get_years_in_position >-----------------------|
16 -- --------------------------------------------------------------------------
17 -- This function computes the years in position
18 function get_years_in_position(p_assignment_id in number
19 ,p_position_id in number
20 ,p_effective_date in date
21 ,p_asg_effective_start_date in date)
22 return number;
23 --
24 -- --------------------------------------------------------------------------
25 -- |--------------------------< get_years_in_grade >-------------------------|
26 -- --------------------------------------------------------------------------
27 -- This function computes the years in grade
28 function get_years_in_grade(p_assignment_id in number
29 ,p_grade_id in number
30 ,p_effective_date in date
31 ,p_asg_effective_start_date in date)
32 return number;
33 --
34 -- --------------------------------------------------------------------------
35 -- |----------------------------< get_grd_min_val >--------------------------|
36 -- --------------------------------------------------------------------------
37 -- This function computes the years in grade
38 function get_grd_min_val(p_grade_id in number
39 ,p_rate_id in number
40 ,p_effective_date in date)
41 return number;
42 --
43 -- --------------------------------------------------------------------------
44 -- |----------------------------< get_grd_max_val >--------------------------|
45 -- --------------------------------------------------------------------------
46 -- This function computes the years in grade
47 function get_grd_max_val(p_grade_id in number
48 ,p_rate_id in number
49 ,p_effective_date in date)
50 return number;
51 --
52 -- --------------------------------------------------------------------------
53 -- |---------------------------< get_grd_mid_point >-------------------------|
54 -- --------------------------------------------------------------------------
55 -- This function computes the years in grade
56 function get_grd_mid_point(p_grade_id in number
57 ,p_rate_id in number
58 ,p_effective_date in date)
59 return number;
60 --
61 -- --------------------------------------------------------------------------
62 -- |-------------------------< refresh_person_info >-------------------------|
63 -- --------------------------------------------------------------------------
64 -- Description
65 -- This procedure refreshes the person information in ben_cwb_person_info
66 -- table for a given group_per_in_ler_id and effective_date. This
67 -- effective_date is used while fetching the data from date track tables, if
68 -- ben_cwb_pl_dsgn cotains null as effective_date
69 --
70 procedure refresh_person_info(p_group_per_in_ler_id in number
71 ,p_effective_date in date
72 ,p_called_from_benmngle in boolean default false);
73 --
74 -- --------------------------------------------------------------------------
75 -- |--------------------< refresh_person_info_group_pl >---------------------|
76 -- --------------------------------------------------------------------------
77 -- Description
78 -- This procedure refreshes the person information in ben_cwb_person_info
79 -- for all the persons for a group plan, life event occured date.
80 -- p_effective_date will be used as freeze date while fetching the data from
81 -- data tracked tables if the effective_date in ben_cwb_pl_dsgn is null.
82
83 procedure refresh_person_info_group_pl(p_group_pl_id in number
84 ,p_lf_evt_ocrd_dt in date
85 ,p_effective_date in date);
86 -- --------------------------------------------------------------------------
87 -- |--------------------------< get_grd_quartile >---------------------------|
88 -- --------------------------------------------------------------------------
89 -- Description
90 -- This procedure calculates the grade quartile for given base salary,
91 -- minimum, maximum and midpoint of grade
92 function get_grd_quartile(p_salary in number
93 ,p_min in number
94 ,p_max in number
95 ,p_mid in number)
96 return varchar2;
97 --
98 -- --------------------------------------------------------------------------
99 -- |--------------------------< get_grd_quintile >---------------------------|
100 -- --------------------------------------------------------------------------
101 -- Description
102 -- This procedure calculates the grade quintile for given base salary,
103 -- minimum and maximum of grade
104 function get_grd_quintile(p_salary in number
105 ,p_min in number
106 ,p_max in number)
107 return varchar2;
108 --
109 --
110 -- --------------------------------------------------------------------------
111 -- |---------------------------< get_grd_decile >----------------------------|
112 -- --------------------------------------------------------------------------
113 -- Description
114 -- This procedure calculates the grade decile for given base salary,
115 -- minimum and maximum of grade
116 function get_grd_decile(p_salary in number
117 ,p_min in number
118 ,p_max in number)
119 return varchar2;
120 --
121 -- --------------------------------------------------------------------------
122 -- |--------------------------< get_grd_comparatio >-------------------------|
123 -- --------------------------------------------------------------------------
124 -- Description
125 -- This procedure calculates the grade quartile for given base salary,
126 -- and midpoint of a grade
127 function get_grd_comparatio(p_salary in number
128 ,p_mid in number)
129 return number;
130 --
131 -- --------------------------------------------------------------------------
132 -- |--------------------------< refresh_from_master >-------------------------|
133 -- --------------------------------------------------------------------------
134 -- Description
135 -- This procedure is used only by the admin page to refresh the person info.
136 --
137 procedure refresh_from_master(p_group_per_in_ler_id in number
138 ,p_effective_date in date);
139 --
140 function get_salary_currency(p_input_value_id in number
141 ,p_effective_date in date)
142 return varchar2;
143 --
144 --
145 -- --------------------------------------------------------------------------
146 -- |---------------------------< get_fte_factor >---------------------------|
147 -- --------------------------------------------------------------------------
148 FUNCTION get_fte_factor(p_assignment_id IN NUMBER
149 ,p_effective_date IN DATE)
150 return number;
151 --
152 --
153 -- --------------------------------------------------------------------------
154 -- |------------------------< get_grd_pct_in_range >------------------------|
155 -- --------------------------------------------------------------------------
156 function get_grd_pct_in_range(p_salary in number
157 ,p_min in number
158 ,p_max in number)
159 return number;
160 --
161 end BEN_CWB_PERSON_INFO_PKG;