[Home] [Help]
PACKAGE: APPS.PQP_PENSION_TYPES_API
Source
1 Package PQP_Pension_Types_api As
2 /* $Header: pqptyapi.pkh 120.1.12000000.1 2007/01/16 04:28:57 appldev noship $ */
3 /*#
4 * This package contains pension type APIs to create, update or delete pension
5 * types.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Pension Type for Netherlands, United Kingdom and Hungary
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |---------------------------< create_pension_type >------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a pension type used to calculate of pension deductions.
18 *
19 * Various attributes can be recorded at the pension type level. Annual limits,
20 * salary threshold , contribution percentages and conversion rules are some of
21 * the details that can be associated with a pension type.
22 *
23 * <p><b>Licensing</b><br>
24 * This API is licensed for use with Human Resources.
25 *
26 * <p><b>Prerequisites</b><br>
27 * The organization must exist on the effective date.
28 *
29 * <p><b>Post Success</b><br>
30 * The pension type will be successfully inserted into the database. For the
31 * Netherlands localization, pension type balances and the balance
32 * initialization element will be created.
33 *
34 * <p><b>Post Failure</b><br>
35 * The pension type will not be created and an error will be raised.
36 * @param p_validate If true, then validation alone will be performed and the
37 * database will remain unchanged. If false and all validation checks pass,
38 * then the database will be modified.
39 * @param p_effective_date Determines when the DateTrack operation comes into
40 * force
41 * @param p_pension_type_name {@rep:casecolumn
42 * PQP_PENSION_TYPES_F.PENSION_TYPE_NAME}
43 * @param p_pension_category {@rep:casecolumn
44 * PQP_PENSION_TYPES_F.PENSION_CATEGORY}
45 * @param p_pension_provider_type {@rep:casecolumn
46 * PQP_PENSION_TYPES_F.PENSION_PROVIDER_TYPE}
47 * @param p_salary_calculation_method {@rep:casecolumn
48 * PQP_PENSION_TYPES_F.SALARY_CALCULATION_METHOD}
49 * @param p_threshold_conversion_rule {@rep:casecolumn
50 * PQP_PENSION_TYPES_F.THRESHOLD_CONVERSION_RULE}
51 * @param p_contribution_conversion_rule {@rep:casecolumn
52 * PQP_PENSION_TYPES_F.CONTRIBUTION_CONVERSION_RULE}
53 * @param p_er_annual_limit {@rep:casecolumn
54 * PQP_PENSION_TYPES_F.ER_ANNUAL_LIMIT}
55 * @param p_ee_annual_limit {@rep:casecolumn
56 * PQP_PENSION_TYPES_F.EE_ANNUAL_LIMIT}
57 * @param p_er_annual_salary_threshold {@rep:casecolumn
58 * PQP_PENSION_TYPES_F.EE_ANNUAL_SALARY_THRESHOLD}
59 * @param p_ee_annual_salary_threshold {@rep:casecolumn
60 * PQP_PENSION_TYPES_F.ER_ANNUAL_SALARY_THRESHOLD}
61 * @param p_business_group_id {@rep:casecolumn
62 * PQP_PENSION_TYPES_F.BUSINESS_GROUP_ID}
63 * @param p_legislation_code {@rep:casecolumn
64 * PQP_PENSION_TYPES_F.LEGISLATION_CODE}
65 * @param p_description {@rep:casecolumn PQP_PENSION_TYPES_F.DESCRIPTION}
66 * @param p_minimum_age {@rep:casecolumn PQP_PENSION_TYPES_F.MINIMUM_AGE}
67 * @param p_ee_contribution_percent {@rep:casecolumn
68 * PQP_PENSION_TYPES_F.EE_CONTRIBUTION_PERCENT}
69 * @param p_maximum_age {@rep:casecolumn PQP_PENSION_TYPES_F.MAXIMUM_AGE}
70 * @param p_er_contribution_percent {@rep:casecolumn
71 * PQP_PENSION_TYPES_F.ER_CONTRIBUTION_PERCENT}
72 * @param p_ee_annual_contribution {@rep:casecolumn
73 * PQP_PENSION_TYPES_F.EE_ANNUAL_CONTRIBUTION}
74 * @param p_er_annual_contribution {@rep:casecolumn
75 * PQP_PENSION_TYPES_F.ER_ANNUAL_CONTRIBUTION}
76 * @param p_annual_premium_amount {@rep:casecolumn
77 * PQP_PENSION_TYPES_F.ANNUAL_PREMIUM_AMOUNT}
78 * @param p_ee_contribution_bal_type_id {@rep:casecolumn
79 * PQP_PENSION_TYPES_F.EE_CONTRIBUTION_BAL_TYPE_ID}
80 * @param p_er_contribution_bal_type_id {@rep:casecolumn
81 * PQP_PENSION_TYPES_F.ER_CONTRIBUTION_BAL_TYPE_ID}
82 * @param p_balance_init_element_type_id {@rep:casecolumn
83 * PQP_PENSION_TYPES_F.BALANCE_INIT_ELEMENT_TYPE_ID}
84 * @param p_ee_contribution_fixed_rate {@rep:casecolumn
85 * PQP_PENSION_TYPES_F.EE_CONTRIBUTION_FIXED_RATE}
86 * @param p_er_contribution_fixed_rate {@rep:casecolumn
87 * PQP_PENSION_TYPES_F.ER_CONTRIBUTION_FIXED_RATE}
88 * @param p_pty_attribute_category {@rep:casecolumn
89 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE_CATEGORY}
90 * @param p_pty_attribute1 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE1}
91 * @param p_pty_attribute2 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE2}
92 * @param p_pty_attribute3 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE3}
93 * @param p_pty_attribute4 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE4}
94 * @param p_pty_attribute5 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE5}
95 * @param p_pty_attribute6 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE6}
96 * @param p_pty_attribute7 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE7}
97 * @param p_pty_attribute8 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE8}
98 * @param p_pty_attribute9 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE9}
99 * @param p_pty_attribute10 {@rep:casecolumn
100 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE10}
101 * @param p_pty_attribute11 {@rep:casecolumn
102 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE11}
103 * @param p_pty_attribute12 {@rep:casecolumn
104 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE12}
105 * @param p_pty_attribute13 {@rep:casecolumn
106 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE13}
107 * @param p_pty_attribute14 {@rep:casecolumn
108 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE14}
109 * @param p_pty_attribute15 {@rep:casecolumn
110 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE15}
111 * @param p_pty_attribute16 {@rep:casecolumn
112 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE16}
113 * @param p_pty_attribute17 {@rep:casecolumn
114 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE17}
115 * @param p_pty_attribute18 {@rep:casecolumn
116 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE18}
117 * @param p_pty_attribute19 {@rep:casecolumn
118 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE19}
119 * @param p_pty_attribute20 {@rep:casecolumn
120 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE20}
121 * @param p_pty_information_category {@rep:casecolumn
122 * PQP_PENSION_TYPES_F.PTY_INFORMATION_CATEGORY}
123 * @param p_pty_information1 {@rep:casecolumn
124 * PQP_PENSION_TYPES_F.PTY_INFORMATION1}
125 * @param p_pty_information2 {@rep:casecolumn
126 * PQP_PENSION_TYPES_F.PTY_INFORMATION2}
127 * @param p_pty_information3 {@rep:casecolumn
128 * PQP_PENSION_TYPES_F.PTY_INFORMATION3}
129 * @param p_pty_information4 {@rep:casecolumn
130 * PQP_PENSION_TYPES_F.PTY_INFORMATION4}
131 * @param p_pty_information5 {@rep:casecolumn
132 * PQP_PENSION_TYPES_F.PTY_INFORMATION5}
133 * @param p_pty_information6 {@rep:casecolumn
134 * PQP_PENSION_TYPES_F.PTY_INFORMATION6}
135 * @param p_pty_information7 {@rep:casecolumn
136 * PQP_PENSION_TYPES_F.PTY_INFORMATION7}
137 * @param p_pty_information8 {@rep:casecolumn
138 * PQP_PENSION_TYPES_F.PTY_INFORMATION8}
139 * @param p_pty_information9 {@rep:casecolumn
140 * PQP_PENSION_TYPES_F.PTY_INFORMATION9}
141 * @param p_pty_information10 {@rep:casecolumn
142 * PQP_PENSION_TYPES_F.PTY_INFORMATION10}
143 * @param p_pty_information11 {@rep:casecolumn
144 * PQP_PENSION_TYPES_F.PTY_INFORMATION11}
145 * @param p_pty_information12 {@rep:casecolumn
146 * PQP_PENSION_TYPES_F.PTY_INFORMATION12}
147 * @param p_pty_information13 {@rep:casecolumn
148 * PQP_PENSION_TYPES_F.PTY_INFORMATION13}
149 * @param p_pty_information14 {@rep:casecolumn
150 * PQP_PENSION_TYPES_F.PTY_INFORMATION14}
151 * @param p_pty_information15 {@rep:casecolumn
152 * PQP_PENSION_TYPES_F.PTY_INFORMATION15}
153 * @param p_pty_information16 {@rep:casecolumn
154 * PQP_PENSION_TYPES_F.PTY_INFORMATION16}
155 * @param p_pty_information17 {@rep:casecolumn
156 * PQP_PENSION_TYPES_F.PTY_INFORMATION17}
157 * @param p_pty_information18 {@rep:casecolumn
158 * PQP_PENSION_TYPES_F.PTY_INFORMATION18}
159 * @param p_pty_information19 {@rep:casecolumn
160 * PQP_PENSION_TYPES_F.PTY_INFORMATION19}
161 * @param p_pty_information20 {@rep:casecolumn
162 * PQP_PENSION_TYPES_F.PTY_INFORMATION20}
163 * @param p_special_pension_type_code {@rep:casecolumn
164 * PQP_PENSION_TYPES_F.SPECIAL_PENSION_TYPE_CODE}
165 * @param p_pension_sub_category {@rep:casecolumn
166 * PQP_PENSION_TYPES_F.PENSION_SUB_CATEGORY}
167 * @param p_pension_basis_calc_method {@rep:casecolumn
168 * PQP_PENSION_TYPES_F.PENSION_BASIS_CALC_METHOD}
169 * @param p_pension_salary_balance {@rep:casecolumn
170 * PQP_PENSION_TYPES_F.PENSION_SALARY_BALANCE}
171 * @param p_recurring_bonus_percent {@rep:casecolumn
172 * PQP_PENSION_TYPES_F.RECURRING_BONUS_PERCENT}
173 * @param p_non_recurring_bonus_percent {@rep:casecolumn
174 * PQP_PENSION_TYPES_F.NON_RECURRING_BONUS_PERCENT}
175 * @param p_recurring_bonus_balance {@rep:casecolumn
176 * PQP_PENSION_TYPES_F.RECURRING_BONUS_BALANCE}
177 * @param p_non_recurring_bonus_balance {@rep:casecolumn
178 * PQP_PENSION_TYPES_F.NON_RECURRING_BONUS_BALANCE}
179 * @param p_std_tax_reduction {@rep:casecolumn
180 * PQP_PENSION_TYPES_F.STD_TAX_REDUCTION}
181 * @param p_spl_tax_reduction {@rep:casecolumn
182 * PQP_PENSION_TYPES_F.SPL_TAX_REDUCTION}
183 * @param p_sig_sal_spl_tax_reduction {@rep:casecolumn
184 * PQP_PENSION_TYPES_F.SIG_SAL_SPL_TAX_REDUCTION}
185 * @param p_sig_sal_non_tax_reduction {@rep:casecolumn
186 * PQP_PENSION_TYPES_F.SIG_SAL_NON_TAX_REDUCTION}
187 * @param p_sig_sal_std_tax_reduction {@rep:casecolumn
188 * PQP_PENSION_TYPES_F.SIG_SAL_STD_TAX_REDUCTION}
189 * @param p_sii_std_tax_reduction {@rep:casecolumn
190 * PQP_PENSION_TYPES_F.SII_STD_TAX_REDUCTION}
191 * @param p_sii_spl_tax_reduction {@rep:casecolumn
192 * PQP_PENSION_TYPES_F.SII_SPL_TAX_REDUCTION}
193 * @param p_sii_non_tax_reduction {@rep:casecolumn
194 * PQP_PENSION_TYPES_F.SII_NON_TAX_REDUCTION}
195 * @param p_previous_year_bonus_included {@rep:casecolumn
196 * PQP_PENSION_TYPES_F.PREVIOUS_YEAR_BONUS_INCLUDED}
197 * @param p_recurring_bonus_period {@rep:casecolumn
198 * PQP_PENSION_TYPES_F.RECURRING_BONUS_PERIOD}
199 * @param p_non_recurring_bonus_period {@rep:casecolumn
200 * PQP_PENSION_TYPES_F.NON_RECURRING_BONUS_PERIOD}
201 * @param p_ee_age_threshold {@rep:casecolumn
202 * PQP_PENSION_TYPES_F.EE_AGE_THRESHOLD}
203 * @param p_er_age_threshold {@rep:casecolumn
204 * PQP_PENSION_TYPES_F.ER_AGE_THRESHOLD}
205 * @param p_ee_age_contribution {@rep:casecolumn
206 * PQP_PENSION_TYPES_F.EE_AGE_CONTRIBUTION}
207 * @param p_er_age_contribution {@rep:casecolumn
208 * PQP_PENSION_TYPES_F.ER_AGE_CONTRIBUTION}
209 * @param p_pension_type_id If p_validate is false, then this uniquely
210 * identifies that pension type created. If p_validate is true then set to
211 * null.
212 * @param p_object_version_number If p_validate is false, then set to the
213 * version number of the created pension type. If p_validate is true, then the
214 * value will be null.
215 * @param p_effective_start_date If p_validate is false, then set to the
216 * earliest effective start date for the created pension type. If p_validate is
217 * true, then it is set to null.
218 * @param p_effective_end_date If p_validate is false, then set to the
219 * effective end date for the created pension type. If p_validate is true, then
220 * set to null.
221 * @param p_api_warning Holds warning messages raised by the API.
222 * @rep:displayname Create Pension Type
223 * @rep:category BUSINESS_ENTITY PQP_PENSION_AND_SAVING_TYPE
224 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
225 * @rep:scope public
226 * @rep:lifecycle active
227 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
228 */
229 --
230 -- {End Of Comments}
231 --
232 Procedure Create_Pension_Type
233 (p_validate in Boolean default false
234 ,p_effective_date in date
235 ,p_pension_type_name in varchar2
236 ,p_pension_category in varchar2
237 ,p_pension_provider_type in varchar2
238 ,p_salary_calculation_method in varchar2
239 ,p_threshold_conversion_rule in varchar2
240 ,p_contribution_conversion_rule in varchar2
241 ,p_er_annual_limit in number
242 ,p_ee_annual_limit in number
243 ,p_er_annual_salary_threshold in number
244 ,p_ee_annual_salary_threshold in number
245 ,p_business_group_id in number default null
246 ,p_legislation_code in varchar2 default null
247 ,p_description in varchar2 default null
248 ,p_minimum_age in number default null
249 ,p_ee_contribution_percent in number default null
250 ,p_maximum_age in number default null
251 ,p_er_contribution_percent in number default null
252 ,p_ee_annual_contribution in number default null
253 ,p_er_annual_contribution in number default null
254 ,p_annual_premium_amount in number default null
255 ,p_ee_contribution_bal_type_id in number default null
256 ,p_er_contribution_bal_type_id in number default null
257 ,p_balance_init_element_type_id in number default null
258 ,p_ee_contribution_fixed_rate in number default null --added for UK
259 ,p_er_contribution_fixed_rate in number default null --added for UK
260 ,p_pty_attribute_category in varchar2 default null
261 ,p_pty_attribute1 in varchar2 default null
262 ,p_pty_attribute2 in varchar2 default null
263 ,p_pty_attribute3 in varchar2 default null
264 ,p_pty_attribute4 in varchar2 default null
265 ,p_pty_attribute5 in varchar2 default null
266 ,p_pty_attribute6 in varchar2 default null
267 ,p_pty_attribute7 in varchar2 default null
268 ,p_pty_attribute8 in varchar2 default null
269 ,p_pty_attribute9 in varchar2 default null
270 ,p_pty_attribute10 in varchar2 default null
271 ,p_pty_attribute11 in varchar2 default null
272 ,p_pty_attribute12 in varchar2 default null
273 ,p_pty_attribute13 in varchar2 default null
274 ,p_pty_attribute14 in varchar2 default null
275 ,p_pty_attribute15 in varchar2 default null
276 ,p_pty_attribute16 in varchar2 default null
277 ,p_pty_attribute17 in varchar2 default null
278 ,p_pty_attribute18 in varchar2 default null
279 ,p_pty_attribute19 in varchar2 default null
280 ,p_pty_attribute20 in varchar2 default null
281 ,p_pty_information_category in varchar2 default null
282 ,p_pty_information1 in varchar2 default null
283 ,p_pty_information2 in varchar2 default null
284 ,p_pty_information3 in varchar2 default null
285 ,p_pty_information4 in varchar2 default null
286 ,p_pty_information5 in varchar2 default null
287 ,p_pty_information6 in varchar2 default null
288 ,p_pty_information7 in varchar2 default null
289 ,p_pty_information8 in varchar2 default null
290 ,p_pty_information9 in varchar2 default null
291 ,p_pty_information10 in varchar2 default null
292 ,p_pty_information11 in varchar2 default null
293 ,p_pty_information12 in varchar2 default null
294 ,p_pty_information13 in varchar2 default null
295 ,p_pty_information14 in varchar2 default null
296 ,p_pty_information15 in varchar2 default null
297 ,p_pty_information16 in varchar2 default null
298 ,p_pty_information17 in varchar2 default null
299 ,p_pty_information18 in varchar2 default null
300 ,p_pty_information19 in varchar2 default null
304 ,p_pension_basis_calc_method in varchar2 default null -- added for NL Phase 2B
301 ,p_pty_information20 in varchar2 default null
302 ,p_special_pension_type_code in varchar2 default null -- added for NL Phase 2B
303 ,p_pension_sub_category in varchar2 default null -- added for NL Phase 2B
305 ,p_pension_salary_balance in number default null -- added for NL Phase 2B
306 ,p_recurring_bonus_percent in number default null -- added for NL Phase 2B
307 ,p_non_recurring_bonus_percent in number default null -- added for NL Phase 2B
308 ,p_recurring_bonus_balance in number default null -- added for NL Phase 2B
309 ,p_non_recurring_bonus_balance in number default null -- added for NL Phase 2B
310 ,p_std_tax_reduction in varchar2 default null -- added for NL Phase 2B
311 ,p_spl_tax_reduction in varchar2 default null -- added for NL Phase 2B
312 ,p_sig_sal_spl_tax_reduction in varchar2 default null -- added for NL Phase 2B
313 ,p_sig_sal_non_tax_reduction in varchar2 default null -- added for NL Phase 2B
314 ,p_sig_sal_std_tax_reduction in varchar2 default null -- added for NL Phase 2B
315 ,p_sii_std_tax_reduction in varchar2 default null -- added for NL Phase 2B
316 ,p_sii_spl_tax_reduction in varchar2 default null -- added for NL Phase 2B
317 ,p_sii_non_tax_reduction in varchar2 default null -- added for NL Phase 2B
318 ,p_previous_year_bonus_included in varchar2 default null -- added for NL Phase 2B
319 ,p_recurring_bonus_period in varchar2 default null -- added for NL Phase 2B
320 ,p_non_recurring_bonus_period in varchar2 default null -- added for NL Phase 2B
321 ,p_ee_age_threshold in varchar2 default null -- added for ABP TAR fixes
322 ,p_er_age_threshold in varchar2 default null -- added for ABP TAR fixes
323 ,p_ee_age_contribution in varchar2 default null -- added for ABP TAR fixes
324 ,p_er_age_contribution in varchar2 default null -- added for ABP TAR fixes
325 ,p_pension_type_id out nocopy number
326 ,p_object_version_number out nocopy number
327 ,p_effective_start_date out nocopy date
328 ,p_effective_end_date out nocopy date
329 ,p_api_warning out nocopy varchar2
330 );
331 --
332 -- ----------------------------------------------------------------------------
333 -- |---------------------------< update_pension_type >------------------------|
334 -- ----------------------------------------------------------------------------
335 --
336 -- {Start Of Comments}
337 /*#
338 * This API updates a pension type.
339 *
340 * Various attributes can be updated at the pension type level. Annual limits,
341 * salary threshold , contribution percentages and conversion rules are some of
342 * the details that can be updated for a pension type.
343 *
344 * <p><b>Licensing</b><br>
345 * This API is licensed for use with Human Resources.
346 *
347 * <p><b>Prerequisites</b><br>
348 * The organization and pension type must exist on the effective date.
349 *
350 * <p><b>Restricted Usage Notes</b><br>
351 * Pension type name, pension category and pension sub category cannot be
352 * updated.
353 *
354 * <p><b>Post Success</b><br>
355 * The pension type will be successfully updated in the database.
356 *
357 * <p><b>Post Failure</b><br>
358 * The pension type will not be updated and an error will be raised.
359 * @param p_validate If true, then validation alone will be performed and the
360 * database will remain unchanged. If false and all validation checks pass,
361 * then the database will be modified.
362 * @param p_effective_date Determines when the DateTrack operation comes into
363 * force
364 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
365 * the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or
366 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
367 * depend on the dates of previous record changes and the effective date of
368 * this change.
369 * @param p_pension_type_id {@rep:casecolumn
370 * PQP_PENSION_TYPES_F.PENSION_TYPE_ID}
371 * @param p_object_version_number Pass in the current version number of the
372 * pension type to be updated. When the API completes, if p_validate is false
373 * then it will be set to the new version number of the updated pension type.
374 * If p_validate is true then it will be set to the same value which was passed
375 * in.
376 * @param p_pension_type_name {@rep:casecolumn
377 * PQP_PENSION_TYPES_F.PENSION_TYPE_NAME}
378 * @param p_pension_category {@rep:casecolumn
379 * PQP_PENSION_TYPES_F.PENSION_CATEGORY}
380 * @param p_pension_provider_type {@rep:casecolumn
381 * PQP_PENSION_TYPES_F.PENSION_PROVIDER_TYPE}
382 * @param p_salary_calculation_method {@rep:casecolumn
383 * PQP_PENSION_TYPES_F.SALARY_CALCULATION_METHOD}
384 * @param p_threshold_conversion_rule {@rep:casecolumn
385 * PQP_PENSION_TYPES_F.THRESHOLD_CONVERSION_RULE}
386 * @param p_contribution_conversion_rule {@rep:casecolumn
387 * PQP_PENSION_TYPES_F.CONTRIBUTION_CONVERSION_RULE}
388 * @param p_er_annual_limit {@rep:casecolumn
389 * PQP_PENSION_TYPES_F.ER_ANNUAL_LIMIT}
390 * @param p_ee_annual_limit {@rep:casecolumn
391 * PQP_PENSION_TYPES_F.EE_ANNUAL_LIMIT}
392 * @param p_er_annual_salary_threshold {@rep:casecolumn
393 * PQP_PENSION_TYPES_F.EE_ANNUAL_SALARY_THRESHOLD}
394 * @param p_ee_annual_salary_threshold {@rep:casecolumn
398 * @param p_legislation_code {@rep:casecolumn
395 * PQP_PENSION_TYPES_F.ER_ANNUAL_SALARY_THRESHOLD}
396 * @param p_business_group_id {@rep:casecolumn
397 * PQP_PENSION_TYPES_F.BUSINESS_GROUP_ID}
399 * PQP_PENSION_TYPES_F.LEGISLATION_CODE}
400 * @param p_description {@rep:casecolumn PQP_PENSION_TYPES_F.DESCRIPTION}
401 * @param p_minimum_age {@rep:casecolumn PQP_PENSION_TYPES_F.MINIMUM_AGE}
402 * @param p_ee_contribution_percent {@rep:casecolumn
403 * PQP_PENSION_TYPES_F.EE_CONTRIBUTION_PERCENT}
404 * @param p_maximum_age {@rep:casecolumn PQP_PENSION_TYPES_F.MAXIMUM_AGE}
405 * @param p_er_contribution_percent {@rep:casecolumn
406 * PQP_PENSION_TYPES_F.ER_CONTRIBUTION_PERCENT}
407 * @param p_ee_annual_contribution {@rep:casecolumn
408 * PQP_PENSION_TYPES_F.EE_ANNUAL_CONTRIBUTION}
409 * @param p_er_annual_contribution {@rep:casecolumn
410 * PQP_PENSION_TYPES_F.ER_ANNUAL_CONTRIBUTION}
411 * @param p_annual_premium_amount {@rep:casecolumn
412 * PQP_PENSION_TYPES_F.ANNUAL_PREMIUM_AMOUNT}
413 * @param p_ee_contribution_bal_type_id {@rep:casecolumn
414 * PQP_PENSION_TYPES_F.EE_CONTRIBUTION_BAL_TYPE_ID}
415 * @param p_er_contribution_bal_type_id {@rep:casecolumn
416 * PQP_PENSION_TYPES_F.ER_CONTRIBUTION_BAL_TYPE_ID}
417 * @param p_balance_init_element_type_id {@rep:casecolumn
418 * PQP_PENSION_TYPES_F.BALANCE_INIT_ELEMENT_TYPE_ID}
419 * @param p_ee_contribution_fixed_rate {@rep:casecolumn
420 * PQP_PENSION_TYPES_F.EE_CONTRIBUTION_FIXED_RATE}
421 * @param p_er_contribution_fixed_rate {@rep:casecolumn
422 * PQP_PENSION_TYPES_F.ER_CONTRIBUTION_FIXED_RATE}
423 * @param p_pty_attribute_category {@rep:casecolumn
424 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE_CATEGORY}
425 * @param p_pty_attribute1 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE1}
426 * @param p_pty_attribute2 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE2}
427 * @param p_pty_attribute3 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE3}
428 * @param p_pty_attribute4 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE4}
429 * @param p_pty_attribute5 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE5}
430 * @param p_pty_attribute6 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE6}
431 * @param p_pty_attribute7 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE7}
432 * @param p_pty_attribute8 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE8}
433 * @param p_pty_attribute9 {@rep:casecolumn PQP_PENSION_TYPES_F.PTY_ATTRIBUTE9}
434 * @param p_pty_attribute10 {@rep:casecolumn
435 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE10}
436 * @param p_pty_attribute11 {@rep:casecolumn
437 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE11}
438 * @param p_pty_attribute12 {@rep:casecolumn
439 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE12}
440 * @param p_pty_attribute13 {@rep:casecolumn
441 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE13}
442 * @param p_pty_attribute14 {@rep:casecolumn
443 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE14}
444 * @param p_pty_attribute15 {@rep:casecolumn
445 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE15}
446 * @param p_pty_attribute16 {@rep:casecolumn
447 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE16}
448 * @param p_pty_attribute17 {@rep:casecolumn
449 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE17}
450 * @param p_pty_attribute18 {@rep:casecolumn
451 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE18}
452 * @param p_pty_attribute19 {@rep:casecolumn
453 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE19}
454 * @param p_pty_attribute20 {@rep:casecolumn
455 * PQP_PENSION_TYPES_F.PTY_ATTRIBUTE20}
456 * @param p_pty_information_category {@rep:casecolumn
457 * PQP_PENSION_TYPES_F.PTY_INFORMATION_CATEGORY}
458 * @param p_pty_information1 {@rep:casecolumn
459 * PQP_PENSION_TYPES_F.PTY_INFORMATION1}
460 * @param p_pty_information2 {@rep:casecolumn
461 * PQP_PENSION_TYPES_F.PTY_INFORMATION2}
462 * @param p_pty_information3 {@rep:casecolumn
463 * PQP_PENSION_TYPES_F.PTY_INFORMATION3}
464 * @param p_pty_information4 {@rep:casecolumn
465 * PQP_PENSION_TYPES_F.PTY_INFORMATION4}
466 * @param p_pty_information5 {@rep:casecolumn
467 * PQP_PENSION_TYPES_F.PTY_INFORMATION5}
468 * @param p_pty_information6 {@rep:casecolumn
469 * PQP_PENSION_TYPES_F.PTY_INFORMATION6}
470 * @param p_pty_information7 {@rep:casecolumn
471 * PQP_PENSION_TYPES_F.PTY_INFORMATION7}
472 * @param p_pty_information8 {@rep:casecolumn
473 * PQP_PENSION_TYPES_F.PTY_INFORMATION8}
474 * @param p_pty_information9 {@rep:casecolumn
475 * PQP_PENSION_TYPES_F.PTY_INFORMATION9}
476 * @param p_pty_information10 {@rep:casecolumn
477 * PQP_PENSION_TYPES_F.PTY_INFORMATION10}
478 * @param p_pty_information11 {@rep:casecolumn
479 * PQP_PENSION_TYPES_F.PTY_INFORMATION11}
480 * @param p_pty_information12 {@rep:casecolumn
481 * PQP_PENSION_TYPES_F.PTY_INFORMATION12}
482 * @param p_pty_information13 {@rep:casecolumn
483 * PQP_PENSION_TYPES_F.PTY_INFORMATION13}
484 * @param p_pty_information14 {@rep:casecolumn
485 * PQP_PENSION_TYPES_F.PTY_INFORMATION14}
486 * @param p_pty_information15 {@rep:casecolumn
487 * PQP_PENSION_TYPES_F.PTY_INFORMATION15}
488 * @param p_pty_information16 {@rep:casecolumn
489 * PQP_PENSION_TYPES_F.PTY_INFORMATION16}
490 * @param p_pty_information17 {@rep:casecolumn
491 * PQP_PENSION_TYPES_F.PTY_INFORMATION17}
492 * @param p_pty_information18 {@rep:casecolumn
493 * PQP_PENSION_TYPES_F.PTY_INFORMATION18}
494 * @param p_pty_information19 {@rep:casecolumn
495 * PQP_PENSION_TYPES_F.PTY_INFORMATION19}
496 * @param p_pty_information20 {@rep:casecolumn
497 * PQP_PENSION_TYPES_F.PTY_INFORMATION20}
498 * @param p_special_pension_type_code {@rep:casecolumn
499 * PQP_PENSION_TYPES_F.SPECIAL_PENSION_TYPE_CODE}
500 * @param p_pension_sub_category {@rep:casecolumn
501 * PQP_PENSION_TYPES_F.PENSION_SUB_CATEGORY}
505 * PQP_PENSION_TYPES_F.PENSION_SALARY_BALANCE}
502 * @param p_pension_basis_calc_method {@rep:casecolumn
503 * PQP_PENSION_TYPES_F.PENSION_BASIS_CALC_METHOD}
504 * @param p_pension_salary_balance {@rep:casecolumn
506 * @param p_recurring_bonus_percent {@rep:casecolumn
507 * PQP_PENSION_TYPES_F.RECURRING_BONUS_PERCENT}
508 * @param p_non_recurring_bonus_percent {@rep:casecolumn
509 * PQP_PENSION_TYPES_F.NON_RECURRING_BONUS_PERCENT}
510 * @param p_recurring_bonus_balance {@rep:casecolumn
511 * PQP_PENSION_TYPES_F.RECURRING_BONUS_BALANCE}
512 * @param p_non_recurring_bonus_balance {@rep:casecolumn
513 * PQP_PENSION_TYPES_F.NON_RECURRING_BONUS_BALANCE}
514 * @param p_std_tax_reduction {@rep:casecolumn
515 * PQP_PENSION_TYPES_F.STD_TAX_REDUCTION}
516 * @param p_spl_tax_reduction {@rep:casecolumn
517 * PQP_PENSION_TYPES_F.SPL_TAX_REDUCTION}
518 * @param p_sig_sal_spl_tax_reduction {@rep:casecolumn
519 * PQP_PENSION_TYPES_F.SIG_SAL_SPL_TAX_REDUCTION}
520 * @param p_sig_sal_non_tax_reduction {@rep:casecolumn
521 * PQP_PENSION_TYPES_F.SIG_SAL_NON_TAX_REDUCTION}
522 * @param p_sig_sal_std_tax_reduction {@rep:casecolumn
523 * PQP_PENSION_TYPES_F.SIG_SAL_STD_TAX_REDUCTION}
524 * @param p_sii_std_tax_reduction {@rep:casecolumn
525 * PQP_PENSION_TYPES_F.SII_STD_TAX_REDUCTION}
526 * @param p_sii_spl_tax_reduction {@rep:casecolumn
527 * PQP_PENSION_TYPES_F.SII_SPL_TAX_REDUCTION}
528 * @param p_sii_non_tax_reduction {@rep:casecolumn
529 * PQP_PENSION_TYPES_F.SII_NON_TAX_REDUCTION}
530 * @param p_previous_year_bonus_included {@rep:casecolumn
531 * PQP_PENSION_TYPES_F.PREVIOUS_YEAR_BONUS_INCLUDED}
532 * @param p_recurring_bonus_period {@rep:casecolumn
533 * PQP_PENSION_TYPES_F.RECURRING_BONUS_PERIOD}
534 * @param p_non_recurring_bonus_period {@rep:casecolumn
535 * PQP_PENSION_TYPES_F.NON_RECURRING_BONUS_PERIOD}
536 * @param p_ee_age_threshold {@rep:casecolumn
537 * PQP_PENSION_TYPES_F.EE_AGE_THRESHOLD}
538 * @param p_er_age_threshold {@rep:casecolumn
539 * PQP_PENSION_TYPES_F.ER_AGE_THRESHOLD}
540 * @param p_ee_age_contribution {@rep:casecolumn
541 * PQP_PENSION_TYPES_F.EE_AGE_CONTRIBUTION}
542 * @param p_er_age_contribution {@rep:casecolumn
543 * PQP_PENSION_TYPES_F.ER_AGE_CONTRIBUTION}
544 * @param p_effective_start_date If p_validate is false, then set to the
545 * effective start date on the updated pension type row which now exists as of
546 * the effective date. If p_validate is true, then set to null.
547 * @param p_effective_end_date If p_validate is false, then set to the
548 * effective end date for the created pension type. If p_validate is true, then
549 * set to null.
550 * @param p_api_warning Holds warning messages raised by the API.
551 * @rep:displayname Update Pension Type
552 * @rep:category BUSINESS_ENTITY PQP_PENSION_AND_SAVING_TYPE
553 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
554 * @rep:scope public
555 * @rep:lifecycle active
556 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
557 */
558 --
559 -- {End Of Comments}
560 --
561 Procedure Update_Pension_Type
562 (p_validate in Boolean default false
563 ,p_effective_date in date
564 ,p_datetrack_mode in varchar2
565 ,p_pension_type_id in number
566 ,p_object_version_number in out nocopy number
567 ,p_pension_type_name in varchar2 default hr_api.g_varchar2
568 ,p_pension_category in varchar2 default hr_api.g_varchar2
569 ,p_pension_provider_type in varchar2 default hr_api.g_varchar2
570 ,p_salary_calculation_method in varchar2 default hr_api.g_varchar2
571 ,p_threshold_conversion_rule in varchar2 default hr_api.g_varchar2
572 ,p_contribution_conversion_rule in varchar2 default hr_api.g_varchar2
573 ,p_er_annual_limit in number default hr_api.g_number
574 ,p_ee_annual_limit in number default hr_api.g_number
575 ,p_er_annual_salary_threshold in number default hr_api.g_number
576 ,p_ee_annual_salary_threshold in number default hr_api.g_number
577 ,p_business_group_id in number default hr_api.g_number
578 ,p_legislation_code in varchar2 default hr_api.g_varchar2
579 ,p_description in varchar2 default hr_api.g_varchar2
580 ,p_minimum_age in number default hr_api.g_number
581 ,p_ee_contribution_percent in number default hr_api.g_number
582 ,p_maximum_age in number default hr_api.g_number
583 ,p_er_contribution_percent in number default hr_api.g_number
584 ,p_ee_annual_contribution in number default hr_api.g_number
585 ,p_er_annual_contribution in number default hr_api.g_number
586 ,p_annual_premium_amount in number default hr_api.g_number
587 ,p_ee_contribution_bal_type_id in number default hr_api.g_number
588 ,p_er_contribution_bal_type_id in number default hr_api.g_number
589 ,p_balance_init_element_type_id in number default hr_api.g_number
590 ,p_ee_contribution_fixed_rate in number default hr_api.g_number --added for UK
591 ,p_er_contribution_fixed_rate in number default hr_api.g_number --added for UK
592 ,p_pty_attribute_category in varchar2 default hr_api.g_varchar2
593 ,p_pty_attribute1 in varchar2 default hr_api.g_varchar2
594 ,p_pty_attribute2 in varchar2 default hr_api.g_varchar2
595 ,p_pty_attribute3 in varchar2 default hr_api.g_varchar2
596 ,p_pty_attribute4 in varchar2 default hr_api.g_varchar2
600 ,p_pty_attribute8 in varchar2 default hr_api.g_varchar2
597 ,p_pty_attribute5 in varchar2 default hr_api.g_varchar2
598 ,p_pty_attribute6 in varchar2 default hr_api.g_varchar2
599 ,p_pty_attribute7 in varchar2 default hr_api.g_varchar2
601 ,p_pty_attribute9 in varchar2 default hr_api.g_varchar2
602 ,p_pty_attribute10 in varchar2 default hr_api.g_varchar2
603 ,p_pty_attribute11 in varchar2 default hr_api.g_varchar2
604 ,p_pty_attribute12 in varchar2 default hr_api.g_varchar2
605 ,p_pty_attribute13 in varchar2 default hr_api.g_varchar2
606 ,p_pty_attribute14 in varchar2 default hr_api.g_varchar2
607 ,p_pty_attribute15 in varchar2 default hr_api.g_varchar2
608 ,p_pty_attribute16 in varchar2 default hr_api.g_varchar2
609 ,p_pty_attribute17 in varchar2 default hr_api.g_varchar2
610 ,p_pty_attribute18 in varchar2 default hr_api.g_varchar2
611 ,p_pty_attribute19 in varchar2 default hr_api.g_varchar2
612 ,p_pty_attribute20 in varchar2 default hr_api.g_varchar2
613 ,p_pty_information_category in varchar2 default hr_api.g_varchar2
614 ,p_pty_information1 in varchar2 default hr_api.g_varchar2
615 ,p_pty_information2 in varchar2 default hr_api.g_varchar2
616 ,p_pty_information3 in varchar2 default hr_api.g_varchar2
617 ,p_pty_information4 in varchar2 default hr_api.g_varchar2
618 ,p_pty_information5 in varchar2 default hr_api.g_varchar2
619 ,p_pty_information6 in varchar2 default hr_api.g_varchar2
620 ,p_pty_information7 in varchar2 default hr_api.g_varchar2
621 ,p_pty_information8 in varchar2 default hr_api.g_varchar2
622 ,p_pty_information9 in varchar2 default hr_api.g_varchar2
623 ,p_pty_information10 in varchar2 default hr_api.g_varchar2
624 ,p_pty_information11 in varchar2 default hr_api.g_varchar2
625 ,p_pty_information12 in varchar2 default hr_api.g_varchar2
626 ,p_pty_information13 in varchar2 default hr_api.g_varchar2
627 ,p_pty_information14 in varchar2 default hr_api.g_varchar2
628 ,p_pty_information15 in varchar2 default hr_api.g_varchar2
629 ,p_pty_information16 in varchar2 default hr_api.g_varchar2
630 ,p_pty_information17 in varchar2 default hr_api.g_varchar2
631 ,p_pty_information18 in varchar2 default hr_api.g_varchar2
632 ,p_pty_information19 in varchar2 default hr_api.g_varchar2
633 ,p_pty_information20 in varchar2 default hr_api.g_varchar2
634 ,p_special_pension_type_code in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
635 ,p_pension_sub_category in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
636 ,p_pension_basis_calc_method in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
637 ,p_pension_salary_balance in number default hr_api.g_number -- added for NL Phase 2B
638 ,p_recurring_bonus_percent in number default hr_api.g_number -- added for NL Phase 2B
639 ,p_non_recurring_bonus_percent in number default hr_api.g_number -- added for NL Phase 2B
640 ,p_recurring_bonus_balance in number default hr_api.g_number -- added for NL Phase 2B
641 ,p_non_recurring_bonus_balance in number default hr_api.g_number -- added for NL Phase 2B
642 ,p_std_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
643 ,p_spl_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
644 ,p_sig_sal_spl_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
645 ,p_sig_sal_non_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
646 ,p_sig_sal_std_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
647 ,p_sii_std_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
648 ,p_sii_spl_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
649 ,p_sii_non_tax_reduction in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
650 ,p_previous_year_bonus_included in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
651 ,p_recurring_bonus_period in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
652 ,p_non_recurring_bonus_period in varchar2 default hr_api.g_varchar2 -- added for NL Phase 2B
653 ,p_ee_age_threshold in varchar2 default hr_api.g_varchar2 -- added for ABP TAR fixes
654 ,p_er_age_threshold in varchar2 default hr_api.g_varchar2 -- added for ABP TAR fixes
655 ,p_ee_age_contribution in varchar2 default hr_api.g_varchar2 -- added for ABP TAR fixes
656 ,p_er_age_contribution in varchar2 default hr_api.g_varchar2 -- added for ABP TAR fixes
657 ,p_effective_start_date out nocopy date
658 ,p_effective_end_date out nocopy date
659 ,p_api_warning out nocopy varchar2
660 );
661 --
662 -- ----------------------------------------------------------------------------
663 -- |---------------------------< delete_pension_type >------------------------|
664 -- ----------------------------------------------------------------------------
665 --
666 -- {Start Of Comments}
667 /*#
668 * This API deletes a pension type.
669 *
670 * The pension type API deletes a pension type.
671 *
675 * <p><b>Prerequisites</b><br>
672 * <p><b>Licensing</b><br>
673 * This API is licensed for use with Human Resources.
674 *
676 * The organization and pension type must exist on the effective date. The
677 * pension type should not be attached to a provider and should not have any
678 * pension schemes.
679 *
680 * <p><b>Restricted Usage Notes</b><br>
681 * A pension type cannot be deleted if it is attached to a pension provider or
682 * referenced in a pension scheme.
683 *
684 * <p><b>Post Success</b><br>
685 * The pension type will be successfully deleted in the database.
686 *
687 * <p><b>Post Failure</b><br>
688 * The pension type will not be deleted and an error will be raised.
689 * @param p_validate If true, then validation alone will be performed and the
690 * database will remain unchanged. If false and all validation checks pass,
691 * then the database will be modified.
692 * @param p_effective_date Determines when the DateTrack operation comes into
693 * force
694 * @param p_datetrack_mode Indicates which DateTrack mode to use when deleting
695 * the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
696 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
697 * on the dates of previous record changes and the effective date of this
698 * change.
699 * @param p_pension_type_id {@rep:casecolumn
700 * PQP_PENSION_TYPES_F.PENSION_TYPE_ID}
701 * @param p_object_version_number Current version number of the pension type to
702 * be deleted.
703 * @param p_effective_start_date If p_validate is false, then set to the
704 * effective start date for the deleted pension type row which now exists as of
705 * the effective date. If p_validate is true, or all row instances have been
706 * deleted, then set to null.
707 * @param p_effective_end_date If p_validate is false, then set to the
708 * effective end date for the created pension type. If p_validate is true, then
709 * set to null.
710 * @param p_api_warning Holds warning messages raised by the API.
711 * @rep:displayname Delete Pension Type
712 * @rep:category BUSINESS_ENTITY PQP_PENSION_AND_SAVING_TYPE
713 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
714 * @rep:scope public
715 * @rep:lifecycle active
716 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
717 */
718 --
719 -- {End Of Comments}
720 --
721 Procedure Delete_Pension_Type
722 (p_validate in Boolean default false
723 ,p_effective_date in date
724 ,p_datetrack_mode in varchar2
725 ,p_pension_type_id in number
726 ,p_object_version_number in out nocopy number
727 ,p_effective_start_date out nocopy date
728 ,p_effective_end_date out nocopy date
729 ,p_api_warning out nocopy varchar2
730 );
731 --
732 end PQP_Pension_Types_api;