eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PENSION_FUNCTIONS dependencies on PQP_PENSION_TYPES_F

Line 4: type t_pension_info is table of pqp_pension_types_f%rowtype

1: Package pqp_pension_functions as
2: /* $Header: pqppenff.pkh 120.4.12010000.1 2008/07/28 11:21:09 appldev ship $ */
3:
4: type t_pension_info is table of pqp_pension_types_f%rowtype
5: index by Binary_Integer;
6:
7: TYPE r_tax_si_rec IS RECORD
8: ( tax_si_code varchar2(20)

Line 22: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

18: -- |---------------------< get_pension_type_details >--------------------------|
19: -- ----------------------------------------------------------------------------
20: --
21: function get_pension_type_details
22: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
23: ,p_date_earned in date
24: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
25: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
26: ,p_legislation_code in pqp_pension_types_f.legislation_code%TYPE

Line 25: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE

21: function get_pension_type_details
22: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
23: ,p_date_earned in date
24: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
25: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
26: ,p_legislation_code in pqp_pension_types_f.legislation_code%TYPE
27: ,p_column_name in varchar2
28: ,p_column_value out nocopy varchar2
29: ,p_error_message out nocopy varchar2

Line 26: ,p_legislation_code in pqp_pension_types_f.legislation_code%TYPE

22: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
23: ,p_date_earned in date
24: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
25: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
26: ,p_legislation_code in pqp_pension_types_f.legislation_code%TYPE
27: ,p_column_name in varchar2
28: ,p_column_value out nocopy varchar2
29: ,p_error_message out nocopy varchar2
30:

Line 38: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

34: -- |-------------------------< prorate_amount >-------------------------------|
35: -- ----------------------------------------------------------------------------
36: --
37: function prorate_amount
38: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
39: ,p_date_earned in date
40: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
41: ,p_amount in number
42: ,p_payroll_period in varchar2

Line 69: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

65: -- ----------------------------------------------------------------------------
66: --
67:
68: function get_abp_pension_salary
69: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
70: ,p_date_earned in date
71: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
72: ,p_payroll_id in pay_payroll_actions.payroll_id%TYPE
73: ,p_period_start_date in date

Line 101: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

97: -- |-----------------------< get_pension_salary >-----------------------------|
98: -- ----------------------------------------------------------------------------
99: --
100: function get_pension_salary
101: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
102: ,p_date_earned in date
103: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
104: ,p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE
105: ,p_salary_balance_name in varchar2

Line 109: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE DEFAULT -99

105: ,p_salary_balance_name in varchar2
106: ,p_payroll_period in varchar2
107: ,p_salary_balance_value out nocopy number
108: ,p_error_message out nocopy varchar2
109: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE DEFAULT -99
110: ) return NUMBER;
111:
112:
113: -- ----------------------------------------------------------------------------

Line 162: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

158:
159: FUNCTION get_bonus
160: ( p_date_earned in date
161: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
162: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
163: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
164: ,p_pay_period_salary in number
165: ,p_pay_period in varchar2
166: ,p_work_pattern in varchar2

Line 163: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE

159: FUNCTION get_bonus
160: ( p_date_earned in date
161: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
162: ,p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
163: ,p_pension_type_id in pqp_pension_types_f.pension_type_id%TYPE
164: ,p_pay_period_salary in number
165: ,p_pay_period in varchar2
166: ,p_work_pattern in varchar2
167: ,p_conversion_rule in varchar2

Line 205: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

201: -- |---------------------< get_abp_entry_value >--------------------------|
202: -- ----------------------------------------------------------------------------
203: --
204: function get_abp_entry_value
205: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
206: ,p_date_earned in date
207: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
208: ,p_element_type_id in number
209: ,p_input_value_name in varchar2

Line 217: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE

213: -- |-----------------------< get_avg_part_time_perc >-------------------------|
214: -- ----------------------------------------------------------------------------
215: --
216: function get_avg_part_time_perc
217: (p_business_group_id in pqp_pension_types_f.business_group_id%TYPE
218: ,p_date_earned in date
219: ,p_assignment_id in per_all_assignments_f.assignment_id%TYPE
220: ,p_assignment_action_id IN NUMBER
221: ,p_period_start_date in DATE

Line 258: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

254: -- |---------------------< get_pay_period_age >-------------------------------|
255: -- ----------------------------------------------------------------------------
256: --
257: FUNCTION get_pay_period_age
258: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
259: ,p_date_earned IN DATE
260: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
261: ,p_period_start_date IN DATE
262: ) RETURN NUMBER;

Line 270: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE

266: -- |--------------------------< get_bal_val >---------------------------------|
267: -- ----------------------------------------------------------------------------
268: --
269: FUNCTION get_bal_val
270: (p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
271: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
272: ,p_effective_date IN DATE
273: ,p_balance_name IN VARCHAR2
274: ,p_dimension_name IN VARCHAR2)