[Home] [Help]
19: -- |-------------------------< abp_proration >-------------------------------|
20: -- ----------------------------------------------------------------------------
21: --
22: function abp_proration
23: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
24: ,p_date_earned in date
25: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
26: ,p_amount in number
27: ,p_payroll_period in varchar2
162:
163: FUNCTION get_abp_contribution
164: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
165: ,p_date_earned in date
166: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
167: ,p_payroll_action_id IN NUMBER
168: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE
169: ,p_conversion_rule in pqp_pension_types_f.threshold_conversion_rule%TYPE
170: ,p_basis_method in pqp_pension_types_f.pension_basis_calc_method%TYPE
164: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
165: ,p_date_earned in date
166: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
167: ,p_payroll_action_id IN NUMBER
168: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE
169: ,p_conversion_rule in pqp_pension_types_f.threshold_conversion_rule%TYPE
170: ,p_basis_method in pqp_pension_types_f.pension_basis_calc_method%TYPE
171: ,p_ee_contrib_type out NOCOPY number
172: ,p_ee_contrib_value out NOCOPY number
165: ,p_date_earned in date
166: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
167: ,p_payroll_action_id IN NUMBER
168: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE
169: ,p_conversion_rule in pqp_pension_types_f.threshold_conversion_rule%TYPE
170: ,p_basis_method in pqp_pension_types_f.pension_basis_calc_method%TYPE
171: ,p_ee_contrib_type out NOCOPY number
172: ,p_ee_contrib_value out NOCOPY number
173: ,p_er_contrib_type out NOCOPY number
166: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
167: ,p_payroll_action_id IN NUMBER
168: ,p_pension_sub_cat in pqp_pension_types_f.pension_sub_category%TYPE
169: ,p_conversion_rule in pqp_pension_types_f.threshold_conversion_rule%TYPE
170: ,p_basis_method in pqp_pension_types_f.pension_basis_calc_method%TYPE
171: ,p_ee_contrib_type out NOCOPY number
172: ,p_ee_contrib_value out NOCOPY number
173: ,p_er_contrib_type out NOCOPY number
174: ,p_er_contrib_value out NOCOPY number
183:
184: FUNCTION get_participation_date
185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
186: ,p_date_earned in date
187: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
188: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
189: ,p_start_date out NOCOPY date
190: )
191: RETURN number;
184: FUNCTION get_participation_date
185: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
186: ,p_date_earned in date
187: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
188: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
189: ,p_start_date out NOCOPY date
190: )
191: RETURN number;
192:
198:
199: FUNCTION get_assignment_attribute
200: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
201: ,p_date_earned in date
202: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
203: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
204: ,p_attrib_name in varchar2
205: ,p_attrib_value out NOCOPY varchar2
206: ,p_error_message out NOCOPY varchar2
199: FUNCTION get_assignment_attribute
200: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
201: ,p_date_earned in date
202: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
203: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
204: ,p_attrib_name in varchar2
205: ,p_attrib_value out NOCOPY varchar2
206: ,p_error_message out NOCOPY varchar2
207: )
216:
217: PROCEDURE get_participation_org
218: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
219: ,p_date_earned in date
220: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
221: ,p_asg_or_org out NOCOPY number
222: ,p_org_id out NOCOPY number
223: );
224:
257:
258: FUNCTION get_absence_adjustment
259: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
260: ,p_date_earned in date
261: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
262: ,p_dedn_amt in number
263: ,p_adjust_amt out NOCOPY number
264: ,p_error_message out NOCOPY varchar2
265: )
273:
274: FUNCTION get_proration_factor
275: (p_assignment_id in per_all_assignments_f.assignment_id%TYPE
276: ,p_date_earned in date
277: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
278: ,p_proration_factor out NOCOPY number
279: ,p_error_message out NOCOPY varchar2
280: )
281: RETURN number;
285: -- ------------------------------------------------------------------------
286: --
287: FUNCTION get_abp_calc_eff_dt
288: (p_date_earned IN DATE
289: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
290: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
291: ,p_effective_date OUT NOCOPY DATE
292: )
293: RETURN NUMBER;
297: -- ------------------------------------------------------------------------
298: --
299: FUNCTION get_proration_flag
300: (p_date_earned IN DATE
301: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
302: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
303: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE
304: ,p_element_type_id IN pay_element_types_f.element_type_id%TYPE
305: ,p_start_date IN DATE
312: -- ------------------------------------------------------------------------
313: --
314: FUNCTION get_eoy_bonus_percentage
315: (p_date_earned IN DATE
316: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
317: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
318: ,p_eoy_bonus_percentage OUT NOCOPY NUMBER
319: )
320: RETURN NUMBER;