1 PACKAGE PQP_NL_PGGM_FUNCTIONS as
2 /* $Header: pqpnlpgg.pkh 120.3 2006/08/29 17:23:46 sashriva noship $ */
3
4 g_pkg_name varchar2(80) := 'pqp_nl_pggm_functions.';
5
6 TYPE r_version_info IS RECORD
7 (version_id NUMBER);
8
9 TYPE t_version_info is TABLE OF r_version_info
10 INDEX BY BINARY_INTEGER;
11
12 g_version_info t_version_info;
13
14 -- ----------------------------------------------------------------------------
15 -- |------------------------<CHECK_ELIGIBILITY >-------------------------------|
16 -- ----------------------------------------------------------------------------
17 --
18 FUNCTION CHECK_ELIGIBILITY
19 (p_date_earned IN DATE
20 ,p_business_group_id IN NUMBER
21 ,p_person_age IN NUMBER
22 ,p_pension_type_id IN NUMBER
23 ,p_eligible OUT NOCOPY NUMBER
24 ,p_err_message OUT NOCOPY VARCHAR2
25 )
26 RETURN NUMBER;
27
28 -- ----------------------------------------------------------------------------
29 -- |------------------------<GET_CONTRIBUTION >-------------------------------|
30 -- ----------------------------------------------------------------------------
31 --
32 FUNCTION GET_CONTRIBUTION
33 (p_assignment_id IN NUMBER
34 ,p_date_earned IN DATE
35 ,p_business_group_id IN NUMBER
36 ,p_ee_or_total IN NUMBER
37 ,p_pension_type_id IN NUMBER
38 ,p_contrib_value OUT NOCOPY NUMBER
39 ,p_err_message OUT NOCOPY VARCHAR2
40 )
41 RETURN NUMBER;
42
43 -- ----------------------------------------------------------------------------
44 -- |------------------------<GET_PENSION_BASIS >-------------------------------|
45 -- ----------------------------------------------------------------------------
46 --
47 FUNCTION GET_PENSION_BASIS
48 (p_payroll_action_id IN NUMBER
49 ,p_date_earned IN DATE
50 ,p_business_group_id IN NUMBER
51 ,p_person_age IN NUMBER
52 ,p_pension_type_id IN NUMBER
53 ,p_pension_salary IN NUMBER
54 ,p_part_time_percentage IN NUMBER
55 ,p_pension_basis OUT NOCOPY NUMBER
56 ,p_err_message OUT NOCOPY VARCHAR2
57 ,p_avlb_thld IN OUT NOCOPY NUMBER
58 ,p_used_thld IN OUT NOCOPY NUMBER
59 )
60 RETURN NUMBER;
61
62 -- ----------------------------------------------------------------------------
63 -- |---------------------------<DO_PRORATION >---------------------------------|
64 -- ----------------------------------------------------------------------------
65 --
66 FUNCTION DO_PRORATION
67 (p_assignment_id IN NUMBER
68 ,p_payroll_action_id IN NUMBER
69 ,p_period_start_date IN DATE
70 ,p_period_end_date IN DATE
71 ,p_dedn_amount IN OUT NOCOPY NUMBER
72 ,p_err_message OUT NOCOPY VARCHAR2
73 )
74 RETURN NUMBER;
75
76 -- ----------------------------------------------------------------------------
77 -- |------------------------<GET_PENSION_SALARY >------------------------------|
78 -- ----------------------------------------------------------------------------
79 --
80 FUNCTION GET_PENSION_SALARY
81 (p_assignment_id IN NUMBER
82 ,p_date_earned IN DATE
83 ,p_business_group_id IN NUMBER
84 ,p_payroll_id IN NUMBER
85 ,p_period_start_date IN DATE
86 ,p_period_end_date IN DATE
87 ,p_scale_salary IN NUMBER
88 ,p_scale_salary_h IN NUMBER
89 ,p_scale_salary_e IN NUMBER
90 ,p_ft_rec_payments IN NUMBER
91 ,p_ft_rec_payments_h IN NUMBER
92 ,p_ft_rec_payments_e IN NUMBER
93 ,p_pt_rec_payments IN NUMBER
94 ,p_pt_rec_payments_h IN NUMBER
95 ,p_pt_rec_payments_e IN NUMBER
96 ,p_salary_balance_value OUT NOCOPY NUMBER
97 ,p_err_message OUT NOCOPY VARCHAR2
98 ,p_err_message1 OUT NOCOPY VARCHAR2
99 ,p_err_message2 OUT NOCOPY VARCHAR2
100 )
101 RETURN NUMBER;
102
103 -- ----------------------------------------------------------------------------
104 -- |----------------------<GET_PART_TIME_PERCENTAGE >--------------------------|
105 -- ----------------------------------------------------------------------------
106 --
107 FUNCTION GET_PART_TIME_PERCENTAGE
108 (p_assignment_id IN NUMBER
109 ,p_payroll_action_id IN NUMBER
110 ,p_date_earned IN DATE
111 ,p_business_group_id IN NUMBER
112 ,p_period_start_date IN DATE
113 ,p_period_end_date IN DATE
114 ,p_override_value IN NUMBER
115 ,p_parental_leave IN VARCHAR2
116 ,p_extra_hours IN NUMBER
117 ,p_hours_worked OUT NOCOPY NUMBER
118 ,p_total_hours OUT NOCOPY NUMBER
119 ,p_part_time_percentage OUT NOCOPY NUMBER
120 ,p_err_message OUT NOCOPY VARCHAR2
121 )
122 RETURN NUMBER;
123
124 -- ----------------------------------------------------------------------------
125 -- |----------------------<GET_INCI_WKR_CODE >--------------------------------|
126 -- ----------------------------------------------------------------------------
127 FUNCTION GET_INCI_WKR_CODE
128 (p_assignment_id IN NUMBER
129 ,p_business_group_id IN NUMBER
130 ,p_date_earned IN DATE
131 ,p_result_value OUT NOCOPY VARCHAR2
132 ,p_err_message OUT NOCOPY VARCHAR2
133 )
134 RETURN NUMBER;
135
136 END PQP_NL_PGGM_FUNCTIONS;