1 Package PQP_Pension_Types_swi As
2 /* $Header: pqptyswi.pkh 120.0.12000000.1 2007/01/16 04:29:10 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< create_pension_type >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqp_pension_types_api.create_pension_type
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 Procedure Create_Pension_Type
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_pension_type_name in varchar2
30 ,p_pension_category in varchar2
31 ,p_pension_provider_type in varchar2 default null
32 ,p_salary_calculation_method in varchar2 default null
33 ,p_threshold_conversion_rule in varchar2 default null
34 ,p_contribution_conversion_rule in varchar2 default null
35 ,p_er_annual_limit in number default null
36 ,p_ee_annual_limit in number default null
37 ,p_er_annual_salary_threshold in number default null
38 ,p_ee_annual_salary_threshold in number default null
39 ,p_business_group_id in number default null
40 ,p_legislation_code in varchar2 default null
41 ,p_description in varchar2 default null
42 ,p_minimum_age in number default null
43 ,p_ee_contribution_percent in number default null
44 ,p_maximum_age in number default null
45 ,p_er_contribution_percent in number default null
46 ,p_ee_annual_contribution in number default null
47 ,p_er_annual_contribution in number default null
48 ,p_annual_premium_amount in number default null
49 ,p_ee_contribution_bal_type_id in number default null
50 ,p_er_contribution_bal_type_id in number default null
51 ,p_balance_init_element_type_id in number default null
52 ,p_ee_contribution_fixed_rate in number default null --added for UK
53 ,p_er_contribution_fixed_rate in number default null --added for UK
54 ,p_pty_attribute_category in varchar2 default null
55 ,p_pty_attribute1 in varchar2 default null
56 ,p_pty_attribute2 in varchar2 default null
57 ,p_pty_attribute3 in varchar2 default null
58 ,p_pty_attribute4 in varchar2 default null
59 ,p_pty_attribute5 in varchar2 default null
60 ,p_pty_attribute6 in varchar2 default null
61 ,p_pty_attribute7 in varchar2 default null
62 ,p_pty_attribute8 in varchar2 default null
63 ,p_pty_attribute9 in varchar2 default null
64 ,p_pty_attribute10 in varchar2 default null
65 ,p_pty_attribute11 in varchar2 default null
66 ,p_pty_attribute12 in varchar2 default null
67 ,p_pty_attribute13 in varchar2 default null
68 ,p_pty_attribute14 in varchar2 default null
69 ,p_pty_attribute15 in varchar2 default null
70 ,p_pty_attribute16 in varchar2 default null
71 ,p_pty_attribute17 in varchar2 default null
72 ,p_pty_attribute18 in varchar2 default null
73 ,p_pty_attribute19 in varchar2 default null
74 ,p_pty_attribute20 in varchar2 default null
75 ,p_pty_information_category in varchar2 default null
76 ,p_pty_information1 in varchar2 default null
77 ,p_pty_information2 in varchar2 default null
78 ,p_pty_information3 in varchar2 default null
79 ,p_pty_information4 in varchar2 default null
80 ,p_pty_information5 in varchar2 default null
81 ,p_pty_information6 in varchar2 default null
82 ,p_pty_information7 in varchar2 default null
83 ,p_pty_information8 in varchar2 default null
84 ,p_pty_information9 in varchar2 default null
85 ,p_pty_information10 in varchar2 default null
86 ,p_pty_information11 in varchar2 default null
87 ,p_pty_information12 in varchar2 default null
88 ,p_pty_information13 in varchar2 default null
89 ,p_pty_information14 in varchar2 default null
90 ,p_pty_information15 in varchar2 default null
91 ,p_pty_information16 in varchar2 default null
92 ,p_pty_information17 in varchar2 default null
93 ,p_pty_information18 in varchar2 default null
94 ,p_pty_information19 in varchar2 default null
95 ,p_pty_information20 in varchar2 default null
96 ,p_special_pension_type_code in varchar2 default null -- added for NL Phase 2B
97 ,p_pension_sub_category in varchar2 default null -- added for NL Phase 2B
98 ,p_pension_basis_calc_method in varchar2 default null -- added for NL Phase 2B
99 ,p_pension_salary_balance in number default null -- added for NL Phase 2B
100 ,p_recurring_bonus_percent in number default null -- added for NL Phase 2B
101 ,p_non_recurring_bonus_percent in number default null -- added for NL Phase 2B
102 ,p_recurring_bonus_balance in number default null -- added for NL Phase 2B
103 ,p_non_recurring_bonus_balance in number default null -- added for NL Phase 2B
104 ,p_std_tax_reduction in varchar2 default null -- added for NL Phase 2B
105 ,p_spl_tax_reduction in varchar2 default null -- added for NL Phase 2B
106 ,p_sig_sal_spl_tax_reduction in varchar2 default null -- added for NL Phase 2B
107 ,p_sig_sal_non_tax_reduction in varchar2 default null -- added for NL Phase 2B
108 ,p_sig_sal_std_tax_reduction in varchar2 default null -- added for NL Phase 2B
109 ,p_sii_std_tax_reduction in varchar2 default null -- added for NL Phase 2B
110 ,p_sii_spl_tax_reduction in varchar2 default null -- added for NL Phase 2B
111 ,p_sii_non_tax_reduction in varchar2 default null -- added for NL Phase 2B
112 ,p_previous_year_bonus_included in varchar2 default null -- added for NL Phase 2B
113 ,p_recurring_bonus_period in varchar2 default null -- added for NL Phase 2B
114 ,p_non_recurring_bonus_period in varchar2 default null -- added for NL Phase 2B
115 ,p_ee_age_threshold in varchar2 default null -- added for ABP TAR Fixes
116 ,p_er_age_threshold in varchar2 default null -- added for ABP TAR Fixes
117 ,p_ee_age_contribution in varchar2 default null -- added for ABP TAR Fixes
118 ,p_er_age_contribution in varchar2 default null -- added for ABP TAR Fixes
119 ,p_pension_type_id out nocopy number
120 ,p_object_version_number out nocopy number
121 ,p_effective_start_date out nocopy date
122 ,p_effective_end_date out nocopy date
123 ,p_api_warning out nocopy varchar2
124 ,p_return_status out nocopy varchar2
125 );
126 -- ----------------------------------------------------------------------------
127 -- |--------------------------< Delete_Pension_Type >-------------------------|
128 -- ----------------------------------------------------------------------------
129 -- {Start of comments}
130 --
131 -- Description:
132 -- This procedure is the self-service wrapper procedure to the following
133 -- API: pqp_pension_types_api.delete_pension_type
134 --
135 -- Pre-requisites
136 -- All 'IN' parameters to this procedure have been appropriately derived.
137 --
138 -- Post Success:
139 -- p_return_status will return value indicating success.
140 --
141 -- Post Failure:
142 -- p_return_status will return value indication failure.
143 --
144 -- Access Status:
145 -- Internal Development use only.
146 --
147 -- {End of comments}
148 -- ----------------------------------------------------------------------------
149 Procedure Delete_Pension_Type
150 (p_validate in number default hr_api.g_false_num
151 ,p_effective_date in date
152 ,p_datetrack_mode in varchar2
153 ,p_pension_type_id in number
154 ,p_object_version_number in out nocopy number
155 ,p_effective_start_date out nocopy date
156 ,p_effective_end_date out nocopy date
157 ,p_return_status out nocopy varchar2
158 ,p_api_warning out nocopy varchar2
159 );
160 -- ----------------------------------------------------------------------------
161 -- |--------------------------< Update_Pension_Type >-------------------------|
162 -- ----------------------------------------------------------------------------
163 -- {Start of comments}
164 --
165 -- Description:
166 -- This procedure is the self-service wrapper procedure to the following
167 -- API: pqp_pension_types_api.update_pension_type
168 --
169 -- Pre-requisites
170 -- All 'IN' parameters to this procedure have been appropriately derived.
171 --
172 -- Post Success:
173 -- p_return_status will return value indicating success.
174 --
175 -- Post Failure:
176 -- p_return_status will return value indication failure.
177 --
178 -- Access Status:
179 -- Internal Development use only.
180 --
181 -- {End of comments}
182 -- ----------------------------------------------------------------------------
183 Procedure Update_Pension_Type
184 (p_validate in number default hr_api.g_false_num
185 ,p_effective_date in date
186 ,p_datetrack_mode in varchar2
187 ,p_pension_type_id in number
188 ,p_object_version_number in out nocopy number
189 ,p_pension_type_name in varchar2 default hr_api.g_varchar2
190 ,p_pension_category in varchar2 default hr_api.g_varchar2
191 ,p_pension_provider_type in varchar2 default hr_api.g_varchar2
192 ,p_salary_calculation_method in varchar2 default hr_api.g_varchar2
193 ,p_threshold_conversion_rule in varchar2 default hr_api.g_varchar2
194 ,p_contribution_conversion_rule in varchar2 default hr_api.g_varchar2
195 ,p_er_annual_limit in number default hr_api.g_number
196 ,p_ee_annual_limit in number default hr_api.g_number
197 ,p_er_annual_salary_threshold in number default hr_api.g_number
198 ,p_ee_annual_salary_threshold in number default hr_api.g_number
199 ,p_business_group_id in number default hr_api.g_number
200 ,p_legislation_code in varchar2 default hr_api.g_varchar2
201 ,p_description in varchar2 default hr_api.g_varchar2
202 ,p_minimum_age in number default hr_api.g_number
203 ,p_ee_contribution_percent in number default hr_api.g_number
204 ,p_maximum_age in number default hr_api.g_number
205 ,p_er_contribution_percent in number default hr_api.g_number
206 ,p_ee_annual_contribution in number default hr_api.g_number
207 ,p_er_annual_contribution in number default hr_api.g_number
208 ,p_annual_premium_amount in number default hr_api.g_number
209 ,p_ee_contribution_bal_type_id in number default hr_api.g_number
210 ,p_er_contribution_bal_type_id in number default hr_api.g_number
211 ,p_balance_init_element_type_id in number default hr_api.g_number
212 ,p_ee_contribution_fixed_rate in number default hr_api.g_number --added for UK
213 ,p_er_contribution_fixed_rate in number default hr_api.g_number --added for UK
214 ,p_pty_attribute_category in varchar2 default hr_api.g_varchar2
215 ,p_pty_attribute1 in varchar2 default hr_api.g_varchar2
216 ,p_pty_attribute2 in varchar2 default hr_api.g_varchar2
217 ,p_pty_attribute3 in varchar2 default hr_api.g_varchar2
218 ,p_pty_attribute4 in varchar2 default hr_api.g_varchar2
219 ,p_pty_attribute5 in varchar2 default hr_api.g_varchar2
220 ,p_pty_attribute6 in varchar2 default hr_api.g_varchar2
221 ,p_pty_attribute7 in varchar2 default hr_api.g_varchar2
222 ,p_pty_attribute8 in varchar2 default hr_api.g_varchar2
223 ,p_pty_attribute9 in varchar2 default hr_api.g_varchar2
224 ,p_pty_attribute10 in varchar2 default hr_api.g_varchar2
225 ,p_pty_attribute11 in varchar2 default hr_api.g_varchar2
226 ,p_pty_attribute12 in varchar2 default hr_api.g_varchar2
227 ,p_pty_attribute13 in varchar2 default hr_api.g_varchar2
228 ,p_pty_attribute14 in varchar2 default hr_api.g_varchar2
229 ,p_pty_attribute15 in varchar2 default hr_api.g_varchar2
230 ,p_pty_attribute16 in varchar2 default hr_api.g_varchar2
231 ,p_pty_attribute17 in varchar2 default hr_api.g_varchar2
232 ,p_pty_attribute18 in varchar2 default hr_api.g_varchar2
233 ,p_pty_attribute19 in varchar2 default hr_api.g_varchar2
234 ,p_pty_attribute20 in varchar2 default hr_api.g_varchar2
235 ,p_pty_information_category in varchar2 default hr_api.g_varchar2
236 ,p_pty_information1 in varchar2 default hr_api.g_varchar2
237 ,p_pty_information2 in varchar2 default hr_api.g_varchar2
238 ,p_pty_information3 in varchar2 default hr_api.g_varchar2
239 ,p_pty_information4 in varchar2 default hr_api.g_varchar2
240 ,p_pty_information5 in varchar2 default hr_api.g_varchar2
241 ,p_pty_information6 in varchar2 default hr_api.g_varchar2
242 ,p_pty_information7 in varchar2 default hr_api.g_varchar2
243 ,p_pty_information8 in varchar2 default hr_api.g_varchar2
244 ,p_pty_information9 in varchar2 default hr_api.g_varchar2
245 ,p_pty_information10 in varchar2 default hr_api.g_varchar2
246 ,p_pty_information11 in varchar2 default hr_api.g_varchar2
247 ,p_pty_information12 in varchar2 default hr_api.g_varchar2
248 ,p_pty_information13 in varchar2 default hr_api.g_varchar2
249 ,p_pty_information14 in varchar2 default hr_api.g_varchar2
250 ,p_pty_information15 in varchar2 default hr_api.g_varchar2
251 ,p_pty_information16 in varchar2 default hr_api.g_varchar2
252 ,p_pty_information17 in varchar2 default hr_api.g_varchar2
253 ,p_pty_information18 in varchar2 default hr_api.g_varchar2
254 ,p_pty_information19 in varchar2 default hr_api.g_varchar2
255 ,p_pty_information20 in varchar2 default hr_api.g_varchar2
256 ,p_special_pension_type_code in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
257 ,p_pension_sub_category in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
258 ,p_pension_basis_calc_method in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
259 ,p_pension_salary_balance in number default hr_api.g_number -- added for NL Phase 2B
260 ,p_recurring_bonus_percent in number default hr_api.g_number -- added for NL Phase 2B
261 ,p_non_recurring_bonus_percent in number default hr_api.g_number -- added for NL Phase 2B
262 ,p_recurring_bonus_balance in number default hr_api.g_number -- added for NL Phase 2B
263 ,p_non_recurring_bonus_balance in number default hr_api.g_number -- added for NL Phase 2B
264 ,p_std_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
265 ,p_spl_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
266 ,p_sig_sal_spl_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
267 ,p_sig_sal_non_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
268 ,p_sig_sal_std_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
269 ,p_sii_std_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
270 ,p_sii_spl_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
271 ,p_sii_non_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
272 ,p_previous_year_bonus_included in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
273 ,p_recurring_bonus_period in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
274 ,p_non_recurring_bonus_period in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
275 ,p_ee_age_threshold in varchar2 default hr_api.g_varchar2 -- added for ABP TAR Fixes
276 ,p_er_age_threshold in varchar2 default hr_api.g_varchar2 -- added for ABP TAR Fixes
277 ,p_ee_age_contribution in varchar2 default hr_api.g_varchar2 -- added for ABP TAR Fixes
278 ,p_er_age_contribution in varchar2 default hr_api.g_varchar2 -- added for ABP TAR Fixes
279 ,p_effective_start_date out nocopy date
280 ,p_effective_end_date out nocopy date
281 ,p_return_status out nocopy varchar2
282 ,p_api_warning out nocopy varchar2
283 );
284 end PQP_Pension_Types_swi;