[Home] [Help]
PACKAGE: APPS.PAY_FF_FUNCTIONS
Source
1 PACKAGE PAY_FF_Functions as
2 /* $Header: pyfffunc.pkh 120.4.12000000.3 2007/03/15 09:54:27 kvsankar noship $ */
3 -----------------------------------------------------------------------------
4 -----------------------------------------------------------------------------
5 ----------------------------------------------------
6 -- Function to calculate Maximum Exclusion Allowance
7 ----------------------------------------------------
8 function Calc_max_excl_allow (
9 p_payroll_action_id in number,
10 p_ee_incld_annual_comp in number,
11 p_total_er_contr_prior_years in number,
12 p_years_of_service in number
13 )
14 Return number;
15 --------------------------------------
16 -- Function to calculate Overall Limit
17 --------------------------------------
18 Function Calc_overall_limit (
19 p_payroll_action_id in number,
20 p_ee_incld_annual_comp in number
21 )
22 Return Number;
23 --
24 --
25 ---------------------------------------
26 -- Function to calculate Any Year Limit
27 ---------------------------------------
28 Function Calc_any_year_limit (
29 p_payroll_action_id in number,
30 p_ee_incld_annual_comp in number,
31 p_total_er_contr_prior_years in number,
32 p_years_of_service in number
33 )
34 Return number;
35 --
36 --
37 -------------------------------------------------
38 -- Function to calculate year of separation Limit
39 -------------------------------------------------
40 Function Calc_year_of_sep_limit(
41 p_payroll_action_id in number,
42 p_assignment_id in number,
43 p_ee_incld_annual_comp in number,
44 p_total_er_contr_prior_years in number,
45 p_years_of_service in number
46 )
47 Return number;
48 --
49 --
50 -------------------------------------------------
51 -- Function to calculate effective deferral limit
52 -------------------------------------------------
53 Function Calc_elec_def_limit(
54 p_payroll_action_id in number,
55 p_catch_up in varchar2,
56 p_total_elec_def in number,
57 p_years_of_service in number,
58 p_catch_up_amt in number
59 )
60 Return number;
61 --
62 --
63 ------------------------------------------
64 -- Function to calculate length of service
65 ------------------------------------------
66 Function Calc_length_of_service(
67 p_payroll_action_id in number,
68 p_assignment_id in number,
69 p_dummy in varchar)
70 Return number;
71 --
72 ------------------------------------------
73 -- Function to check whether employee is
74 -- enrolled in both 403(b) and 457 plans
75 ------------------------------------------
76 ------------------------------------------
77 Function Check_if_emp_in_403b_457_plan(
78 p_payroll_action_id in number,
79 p_assignment_id in number,
80 p_dummy in VARCHAR)
81 Return varchar;
82 --
83 ------------------------------------------
84 -- Function to Get the 403B Limit
85 ------------------------------------------
86 Function Get_PQP_Limit(
87 p_effective_date IN DATE DEFAULT NULL,
88 p_payroll_action_id IN NUMBER DEFAULT NULL,
89 p_limit IN VARCHAR)
90 Return number;
91 --
92 ------------------------------------------
93
94 ------------------------------------------
95 -- Function to Get the Annual Salary
96 ------------------------------------------
97 Function Get_annual_salary (
98 p_payroll_action_id in number,
99 p_assignment_id in number,
100 p_as_of_date in date )
101 Return number;
102 --
103 ------------------------------------------
104 -- Function to get the 457 Limit
105 ------------------------------------------
106 Function get_457_annual_Limit(
107 p_effective_date IN DATE DEFAULT NULL,
108 p_payroll_action_id IN NUMBER DEFAULT NULL,
109 p_limit in varchar)
110 Return number;
111 ----------------------------------------------------
112 -- Function to calculate 457 limit
113 ----------------------------------------------------
114 function get_457_calc_limit (
115 p_payroll_action_id in number,
116 p_ee_incld_annual_comp in number
117 )
118 Return number;
119
120 ----------------------------------------------------
121 -- Function to calculate previously unused
122 ----------------------------------------------------
123 function calc_prev_unused (
124 p_assignment_id in number,
125 p_payroll_action_id in number,
126 p_dummy in varchar
127 )
128 return number;
129 ------------------------------------------
130 ----------------------------------------------------
131 -- Function to calculate 457 vested amount
132 ----------------------------------------------------
133 function get_457_vested_amt (
134 p_assignment_id in number,
135 p_payroll_action_id in number,
136 p_dummy in varchar)
137 return number;
138
139
140 ----------------------------------------------
141 --- Function Run Year
142 ----------------------------------------------
143 function Run_Year (
144 p_payroll_action_id in number,
145 p_dummy in varchar)
146 return number;
147
148 GLB_ORIGINAL_ENTRY_ID NUMBER;
149 GLB_TEMPLATE_EARNINGS NUMBER;
150 GLB_STOP_ENTRY_FLAG VARCHAR2(10);
151
152 function get_template_earnings (
153 p_ctx_original_entry_id NUMBER,
154 p_template_earnings NUMBER,
155 p_accrued_value NUMBER,
156 p_maximum_amount NUMBER,
157 p_prorate_start_date DATE,
158 p_prorate_end_date DATE,
159 p_payroll_start_date DATE,
160 p_payroll_end_date DATE,
161 p_stop_entry_flag OUT NOCOPY VARCHAR2,
162 p_clear_accrued_flag OUT NOCOPY VARCHAR2)
163 return number;
164
165 function check_authorization_date (
166 p_ctx_original_entry_id NUMBER,
167 p_auth_end_date DATE,
168 p_prorate_end_date DATE,
169 p_payroll_end_date DATE,
170 p_clear_accrued_flag OUT NOCOPY VARCHAR2)
171 return varchar2;
172
173
174 -- Global varibale for the function GET_CORRECT_FLSA_EARNINGS
175 -- Redeclared a new variable to store Original Entry ID as the previous
176 -- variable is set for the GET_TEMPLATE_EARNINGS function and can be
177 -- set before entering this function
178 GLB_PERIOD_EARNINGS number;
179 GLB_ORIGINAL_ENTRY_ID_2 number;
180
181 function get_earnings_calculation (
182 p_ctx_original_entry_id NUMBER,
183 p_adjust_flag VARCHAR2,
184 p_max_adjust_amount NUMBER,
185 p_total_earnings NUMBER,
186 p_period_earnings NUMBER,
187 p_prorate_end_date DATE,
188 p_payroll_end_date DATE)
189 return number;
190
191 GLB_RR_ORIGINAL_ENTRY_ID NUMBER;
192 GLB_RR_SAL_BASIS_ELEMENT VARCHAR2(1);
193 GLB_RED_REG_ELE VARCHAR2(1);
194 GLB_REG_ELEM VARCHAR2(80);
195
196 function GET_SALARY_BASIS_DETAIL(
197 original_entry_id NUMBER,
198 template_earning NUMBER,
199 hours_passed NUMBER,
200 red_reg_earnings NUMBER,
201 red_reg_hours NUMBER,
202 prorate_start DATE,
203 prorate_end DATE,
204 payroll_start_date DATE,
205 payroll_end_date DATE,
206 flsa_time_definition VARCHAR2,
207 stop_run_flag OUT NOCOPY VARCHAR2,
208 reduced_template_earnings OUT NOCOPY NUMBER,
209 reduced_hours_passed OUT NOCOPY NUMBER,
210 red_reg_adjust_amount NUMBER default 0.05,
211 red_reg_adjust_hours NUMBER default 0.01,
212 red_reg_raise_error VARCHAR2 default 'Y')
213 return varchar2;
214
215 GLB_TIME_DEFINITION_ID NUMBER;
216 GLB_TIME_DEFINITION_NAME VARCHAR2(80);
217 GLB_FLSA_TIME_DEFN VARCHAR2(1);
218
219 function get_time_definition(
220 TIME_DEFINITION_ID NUMBER)
221 RETURN VARCHAR2;
222
223 END pay_ff_functions;