1 Package pay_ie_paye_api AUTHID CURRENT_USER as
2 /* $Header: pyipdapi.pkh 120.11.12020000.2 2012/07/05 00:11:31 amnaraya ship $ */
3 /*#
4 * This package contains the PAYE Details API for Ireland.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname PAYE Detail for Ireland
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_ie_paye_details >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates PAYE Details for Ireland.
17 *
18 * A PAYE Detail record is created for an assignment. If P45 information is
19 * entered, balance adjustments are created for the P45 data.
20 *
21 * <p><b>Licensing</b><br>
22 * This API is licensed for use with Human Resources.
23 *
24 * <p><b>Prerequisites</b><br>
25 * The assignment must belong to a payroll. To enter P45 details the assignment
26 * must have the P45 Information Element linked.
27 *
28 * <p><b>Post Success</b><br>
29 * A PAYE Details record is created for the assignment.
30 *
31 * <p><b>Post Failure</b><br>
32 * No PAYE Detail records are created and an error is raised.
33 * @param p_validate If true, then validation alone will be performed and the
34 * database will remain unchanged. If false and all validation checks pass,
35 * then the database will be modified.
36 * @param p_effective_date Determines when the DateTrack operation comes into
37 * force.
38 * @param p_assignment_id Identifies the assignment for which you created the
39 * PAYE Details record.
40 * @param p_info_source Information Source uses IE_PAYE_INFO_SOURCE lookup to
41 * explain where the information has come from.
42 * @param p_tax_basis Tax Basis uses IE_PAYE_TAX_BASIS lookup for meaning.
43 * @param p_certificate_start_date Tax Certificate Start Date.
44 * @param p_tax_assess_basis Tax Assessment Basis uses IE_PAYE_ASSESS_BASIS
45 * lookup for meaning.
46 * @param p_certificate_issue_date Date the Tax Certificate was issued.
47 * @param p_certificate_end_date Tax Certificate End Date.
48 * @param p_weekly_tax_credit Weekly Tax Credit.
49 * @param p_weekly_std_rate_cut_off Weekly Standard Rate Cut Off.
50 * @param p_monthly_tax_credit Monthly Tax Credit.
51 * @param p_monthly_std_rate_cut_off Monthly Standard Rate Cut Off.
52 * @param p_tax_deducted_to_date This is the amount of tax deducted from
53 * previous employment, as detailed on the employee's P45.
54 * @param p_pay_to_date This is the amount of pay to date from previous
55 * employment, as detailed on the employee's P45.
56 * @param p_disability_benefit This is the amount of disability benefit
57 * received from previous employment, as detailed on the employee's P45.
58 * @param p_lump_sum_payment This is the amount of lump sum received from
59 * previous employment, as detailed on the employee's P45.
60 * @param p_paye_details_id If p_validate is false, then this uniquely
61 * identifies the PAYE details record created. If p_validate is true, then set
62 * to null.
63 * @param p_object_version_number If p_validate is false, then set to the
64 * version number of the created PAYE Details record. If p_validate is true,
65 * then the value will be null.
66 * @param p_effective_start_date If p_validate is false, then set to the
67 * earliest effective start date for the created PAYE Details record. If
68 * p_validate is true, then set to null.
69 * @param p_effective_end_date If p_validate is false, then set to the
70 * effective end date for the created PAYE Details record. If p_validate is
71 * true, then set to null.
72 * @param p_Tax_This_Employment Set to the Tax paid in this employment.
73 * @param p_Previous_Employment_Start_Dt Set to the start date of the
74 * previous employment.
75 * @param p_Previous_Employment_End_Date Set to the end date of the
76 * previous employment.
77 * @param p_Pay_This_Employment Set to the pay amount in this employment.
78 * @param p_PAYE_Previous_Employer Set to the PAYE paid to the previous
79 * employer.
80 * @param p_P45P3_Or_P46 Set to the type of report, P45 Part 3 or P46.
81 * @param p_Already_Submitted Set to Y if P45 Part 3 or P46 has already been
82 * submitted online, else set to N.
83 * @param p_yrly_tax_cred Tax credit per year
84 * @param p_yrly_tax_rate_1 Yearly Tax Rate1
85 * @param p_yrly_tax_rate_2 Yearly Tax Rate2
86 * @param p_mthly_tax_rate_2 Monthly Tax Rate2
87 * @param p_wkly_tax_rate_2 Weekly Tax Rate2
88 * @param p_tax_rate_3 Tax Rate3
89 * @param p_yrly_tax_rate_3 Yearly Tax Rate3
90 * @param p_mthly_tax_rate_3 Monthly Tax Rate3
91 * @param p_wkly_tax_rate_3 Weekly Tax Rate3
92 * @param p_tax_rate_4 Tax Rate4
93 * @param p_yrly_tax_rate_4 Yearly Tax Rate4
94 * @param p_mthly_tax_rate_4 Monthly Tax Rate4
95 * @param p_wkly_tax_rate_4 Weekly Tax Rate4
96 * @param p_tax_rate_5 Tax Rate5
97 * @param p_in_exempt_usc USC exemption flag
98 * @param p_total_usc_pay_todate This is the amount of usc to date from
99 * previous employment, as detailed on the employee's P45.
100 * @param p_total_usc_tax_todate This is the amount of usc deducted from
101 * previous employment, as detailed on the employee's P45.
102 * @param p_usc_rate_1 USC Rate1
103 * @param p_usc_yrly_cutoff_1 USC yearly Cutoff1
104 * @param p_usc_mthly_cutoff_1 USC Monthly Cutoff1
105 * @param p_usc_wkly_cutoff_1 USC Weekly Cutoff1
106 * @param p_usc_rate_2 USC Rate2
107 * @param p_usc_yrly_cutoff_2 USC yearly Cutoff2
108 * @param p_usc_mthly_cutoff_2 USC Monthly Cutoff2
109 * @param p_usc_wkly_cutoff_2 USC Weekly Cutoff2
110 * @param p_usc_rate_3 USC Rate3
111 * @param p_usc_yrly_cutoff_3 USC Yearly Cutoff3
112 * @param p_usc_mthly_cutoff_3 USC Monthly Cutoff3
113 * @param p_usc_wkly_cutoff_3 USC Weekly Cutoff2
114 * @param p_usc_rate_4 USC Rate4
115 * @param p_usc_yrly_cutoff_4 USC Yearly Cutoff4
116 * @param p_usc_mthly_cutoff_4 USC Monthly Cutoff4
117 * @param p_usc_wkly_cutoff_4 USC weekly Cutoff4
118 * @param p_usc_rate_5 USC Rate5
119 * @param p_usc_tax_basis uses IE_PAYE_TAX_BASIS lookup for meaning.
120 * @param p_usc_info_source Information Source uses IE_PAYE_INFO_SOURCE lookup
121 * @param p_usc_pay_this_employment Set to the USC Pay in this employment.
122 * @param p_usc_tax_this_employment Set to the USC deducted in this employment.
123 * @rep:displayname Create PAYE Detail for Ireland
124 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
125 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
126 * @rep:scope public
127 * @rep:lifecycle active
128 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
129 */
130 --
131 -- {End Of Comments}
132 --
133 procedure create_ie_paye_details
134 (p_validate in boolean default false
135 ,p_effective_date in date
136 ,p_assignment_id in number
137 ,p_info_source in varchar2
138 ,p_tax_basis in varchar2
139 ,p_certificate_start_date in date
140 ,p_tax_assess_basis in varchar2
141 ,p_certificate_issue_date in date default null
142 ,p_certificate_end_date in date default null
143 ,p_weekly_tax_credit in number default null
144 ,p_weekly_std_rate_cut_off in number default null
145 ,p_monthly_tax_credit in number default null
146 ,p_monthly_std_rate_cut_off in number default null
147 ,p_tax_deducted_to_date in number default null
148 ,p_pay_to_date in number default null
149 ,p_disability_benefit in number default null
150 ,p_lump_sum_payment in number default null
151 ,p_paye_details_id out nocopy number
152 ,p_object_version_number out nocopy number
153 ,p_effective_start_date out nocopy date
154 ,p_effective_end_date out nocopy date
155 ,p_Tax_This_Employment in Number default null
156 ,p_Previous_Employment_Start_Dt in date default null
157 ,p_Previous_Employment_End_Date in date default null
158 ,p_Pay_This_Employment in number default null
159 ,p_PAYE_Previous_Employer in varchar2 default null
160 ,p_P45P3_Or_P46 in varchar2 default null
161 ,p_Already_Submitted in varchar2 default null
162 --,p_P45P3_Or_P46_Processed in varchar2 default null
163 --13359423
164 ,p_yrly_tax_cred in number default null
165 ,p_yrly_tax_rate_1 in number default null
166 ,p_yrly_tax_rate_2 in number default null
167 ,p_mthly_tax_rate_2 in number default null
168 ,p_wkly_tax_rate_2 in number default null
169 ,p_tax_rate_3 in number default null
170 ,p_yrly_tax_rate_3 in number default null
171 ,p_mthly_tax_rate_3 in number default null
172 ,p_wkly_tax_rate_3 in number default null
173 ,p_tax_rate_4 in number default null
174 ,p_yrly_tax_rate_4 in number default null
175 ,p_mthly_tax_rate_4 in number default null
176 ,p_wkly_tax_rate_4 in number default null
177 ,p_tax_rate_5 in number default null
178 ,p_in_exempt_usc in varchar2 default null
179 ,p_total_usc_pay_todate in number default null
180 ,p_total_usc_tax_todate in number default null
181 ,p_usc_rate_1 in number default null
182 ,p_usc_yrly_cutoff_1 in number default null
183 ,p_usc_mthly_cutoff_1 in number default null
184 ,p_usc_wkly_cutoff_1 in number default null
185 ,p_usc_rate_2 in number default null
186 ,p_usc_yrly_cutoff_2 in number default null
187 ,p_usc_mthly_cutoff_2 in number default null
188 ,p_usc_wkly_cutoff_2 in number default null
189 ,p_usc_rate_3 in number default null
190 ,p_usc_yrly_cutoff_3 in number default null
191 ,p_usc_mthly_cutoff_3 in number default null
192 ,p_usc_wkly_cutoff_3 in number default null
193 ,p_usc_rate_4 in number default null
194 ,p_usc_yrly_cutoff_4 in number default null
195 ,p_usc_mthly_cutoff_4 in number default null
196 ,p_usc_wkly_cutoff_4 in number default null
197 ,p_usc_rate_5 in number default null
198 ,p_usc_tax_basis in varchar2 default null
199 ,p_usc_info_source in varchar2 default null
200 ,p_usc_pay_this_employment in number default null
201 ,p_usc_tax_this_employment in Number default null
202 --13359423
203 );
204 --
205 -- ----------------------------------------------------------------------------
206 -- |--------------------------< update_ie_paye_details >----------------------|
207 -- ----------------------------------------------------------------------------
208 --
209 -- {Start Of Comments}
210 /*#
211 * This API Updates PAYE Details for Ireland.
212 *
213 * A PAYE Detail record is Updated for an assignment. If P45 information is
214 * entered, then balance adjustments are updated for the P45 data.
215 *
216 * If P45 information is present for an assignment then user must pass the
217 * following parameters.
218 * p_tax_deducted_to_date
219 * p_pay_to_date
220 * p_total_usc_pay_todate
221 * p_total_usc_tax_todate
222 *
223 * <p><b>Licensing</b><br>
224 * This API is licensed for use with Human Resources.
225 *
226 * <p><b>Prerequisites</b><br>
227 * PAYE Details must exist for the assignment at the time of the update.
228 *
229 * <p><b>Post Success</b><br>
230 * A PAYE Details record is updated for the assignment.
231 *
232 * <p><b>Post Failure</b><br>
233 * No PAYE Detail records are updated and an error is raised.
234 * @param p_validate If true, then validation alone will be performed and the
235 * database will remain unchanged. If false and all validation checks pass,
236 * then the database will be modified.
237 * @param p_effective_date Determines when the DateTrack operation comes into
238 * force.
239 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
240 * updating the record. You must set to either UPDATE, CORRECTION,
241 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
242 * particular record depend on the dates of previous record changes and the
243 * effective date of this change.
244 * @param p_paye_details_id Identifies the PAYE details record to be modified.
245 * @param p_info_source Information Source uses IE_PAYE_INFO_SOURCE lookup to
246 * explain where the information has come from.
247 * @param p_tax_basis Tax Basis uses IE_PAYE_TAX_BASIS lookup for meaning.
248 * @param p_certificate_start_date Tax Certificate Start Date.
249 * @param p_tax_assess_basis Tax Assessment Basis uses IE_PAYE_ASSESS_BASIS
250 * lookup for meaning.
251 * @param p_certificate_issue_date Date the Tax Certificate was issued.
252 * @param p_certificate_end_date Tax Certificate End Date.
253 * @param p_weekly_tax_credit Weekly Tax Credit.
254 * @param p_weekly_std_rate_cut_off Weekly Standard Rate Cut Off.
255 * @param p_monthly_tax_credit Monthly Tax Credit.
256 * @param p_monthly_std_rate_cut_off Monthly Standard Rate Cut Off.
257 * @param p_tax_deducted_to_date This is the amount of tax deducted from
258 * previous employment, as detailed on the employee's P45.
259 * @param p_pay_to_date This is the amount of pay to date from previous
260 * employment, as detailed on the employee's P45.
261 * @param p_disability_benefit This is the amount of disability benefit
262 * received at previous employment, as detailed on the employee's P45.
263 * @param p_lump_sum_payment This is the amount of lump sum received at
264 * previous employment, as detailed on the employee's P45.
265 * @param p_object_version_number Pass in the current version number of the
266 * PAYE Details record to be updated. When the API completes if p_validate is
267 * false, will be set to the new version number of the updated PAYE Details
268 * record. If p_validate is true will be set to the same value which was passed
269 * in.
270 * @param p_effective_start_date If p_validate is false, then set to the
271 * effective start date on the updated PAYE Details row which now exists as of
272 * the effective date. If p_validate is true, then set to null.
273 * @param p_effective_end_date If p_validate is false, then set to the
274 * effective end date on the updated PAYE Details row which now exists as of
275 * the effective date. If p_validate is true, then set to null.
276 * @param p_Tax_This_Employment Set to the Tax paid in this employment.
277 * @param p_Previous_Employment_Start_Dt Set to the start date of the
278 * previous employment.
279 * @param p_Previous_Employment_End_Date Set to the end date of the
280 * previous employment.
281 * @param p_Pay_This_Employment Set to the pay amount in this employment.
282 * @param p_PAYE_Previous_Employer Set to the PAYE paid to the previous
283 * employer.
284 * @param p_P45P3_Or_P46 Set to the type of report, P45 Part 3 or P46.
285 * @param p_Already_Submitted Set to Y if P45 Part 3 or P46 has already been
286 * submitted online, else set to N.
287 * @param p_yrly_tax_cred Tax credit per year
288 * @param p_yrly_tax_rate_1 Yearly Tax Rate1
289 * @param p_yrly_tax_rate_2 Yearly Tax Rate2
290 * @param p_mthly_tax_rate_2 Monthly Tax Rate2
291 * @param p_wkly_tax_rate_2 Weekly Tax Rate2
292 * @param p_tax_rate_3 Tax Rate3
293 * @param p_yrly_tax_rate_3 Yearly Tax Rate3
294 * @param p_mthly_tax_rate_3 Monthly Tax Rate3
295 * @param p_wkly_tax_rate_3 Weekly Tax Rate3
296 * @param p_tax_rate_4 Tax Rate4
297 * @param p_yrly_tax_rate_4 Yearly Tax Rate4
298 * @param p_mthly_tax_rate_4 Monthly Tax Rate4
299 * @param p_wkly_tax_rate_4 Weekly Tax Rate4
300 * @param p_tax_rate_5 Tax Rate5
301 * @param p_in_exempt_usc USC exemption flag
302 * @param p_total_usc_pay_todate This is the amount of usc to date from
303 * previous employment, as detailed on the employee's P45.
304 * @param p_total_usc_tax_todate This is the amount of usc deducted from
305 * previous employment, as detailed on the employee's P45.
306 * @param p_usc_rate_1 USC Rate1
307 * @param p_usc_yrly_cutoff_1 USC yearly Cutoff1
308 * @param p_usc_mthly_cutoff_1 USC Monthly Cutoff1
309 * @param p_usc_wkly_cutoff_1 USC Weekly Cutoff1
310 * @param p_usc_rate_2 USC Rate2
314 * @param p_usc_rate_3 USC Rate3
311 * @param p_usc_yrly_cutoff_2 USC yearly Cutoff2
312 * @param p_usc_mthly_cutoff_2 USC Monthly Cutoff2
313 * @param p_usc_wkly_cutoff_2 USC Weekly Cutoff2
315 * @param p_usc_yrly_cutoff_3 USC Yearly Cutoff3
316 * @param p_usc_mthly_cutoff_3 USC Monthly Cutoff3
317 * @param p_usc_wkly_cutoff_3 USC Weekly Cutoff2
318 * @param p_usc_rate_4 USC Rate4
319 * @param p_usc_yrly_cutoff_4 USC Yearly Cutoff4
320 * @param p_usc_mthly_cutoff_4 USC Monthly Cutoff4
321 * @param p_usc_wkly_cutoff_4 USC weekly Cutoff4
322 * @param p_usc_rate_5 USC Rate5
323 * @param p_usc_tax_basis uses IE_PAYE_TAX_BASIS lookup for meaning.
324 * @param p_usc_info_source Information Source uses IE_PAYE_INFO_SOURCE lookup
325 * @param p_usc_pay_this_employment Set to the USC Pay in this employment.
326 * @param p_usc_tax_this_employment Set to the USC deducted in this employment.
327 * @rep:displayname Update PAYE Detail for Ireland
328 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
329 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
330 * @rep:scope public
331 * @rep:lifecycle active
332 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
333 */
334 --
335 -- {End Of Comments}
336 --
337 procedure update_ie_paye_details
338 (p_validate in boolean default false
339 ,p_effective_date in date
340 ,p_datetrack_update_mode in varchar2
341 ,p_paye_details_id in number
342 ,p_info_source in varchar2
343 ,p_tax_basis in varchar2
344 ,p_certificate_start_date in date
345 ,p_tax_assess_basis in varchar2
346 ,p_certificate_issue_date in date default null
347 ,p_certificate_end_date in date default null
348 ,p_weekly_tax_credit in number default null
349 ,p_weekly_std_rate_cut_off in number default null
350 ,p_monthly_tax_credit in number default null
351 ,p_monthly_std_rate_cut_off in number default null
352 ,p_tax_deducted_to_date in number default null
353 ,p_pay_to_date in number default null
354 ,p_disability_benefit in number default null
355 ,p_lump_sum_payment in number default null
356 ,p_object_version_number in out nocopy number
357 ,p_effective_start_date out nocopy date
358 ,p_effective_end_date out nocopy date
359 ,p_Tax_This_Employment in Number default null
360 ,p_Previous_Employment_Start_Dt in date default null
361 ,p_Previous_Employment_End_Date in date default null
362 ,p_Pay_This_Employment in number default null
363 ,p_PAYE_Previous_Employer in varchar2 default null
364 ,p_P45P3_Or_P46 in varchar2 default null
365 ,p_Already_Submitted in varchar2 default null
366 --,p_P45P3_Or_P46_Processed in varchar2 default null
367 --13359423
368 ,p_yrly_tax_cred in NUMBER default NULL
369 ,p_yrly_tax_rate_1 in number default null
370 ,p_yrly_tax_rate_2 in number default null
371 ,p_mthly_tax_rate_2 in number default null
372 ,p_wkly_tax_rate_2 in number default null
373 ,p_tax_rate_3 in number default null
374 ,p_yrly_tax_rate_3 in number default null
375 ,p_mthly_tax_rate_3 in number default null
376 ,p_wkly_tax_rate_3 in number default null
377 ,p_tax_rate_4 in number default null
378 ,p_yrly_tax_rate_4 in number default null
379 ,p_mthly_tax_rate_4 in number default null
380 ,p_wkly_tax_rate_4 in number default null
381 ,p_tax_rate_5 in number default null
382 ,p_in_exempt_usc in varchar2 default null
383 ,p_total_usc_pay_todate in number default null
384 ,p_total_usc_tax_todate in number default null
385 ,p_usc_rate_1 in number default null
386 ,p_usc_yrly_cutoff_1 in number default null
387 ,p_usc_mthly_cutoff_1 in number default null
388 ,p_usc_wkly_cutoff_1 in number default null
389 ,p_usc_rate_2 in number default null
390 ,p_usc_yrly_cutoff_2 in number default null
391 ,p_usc_mthly_cutoff_2 in number default null
392 ,p_usc_wkly_cutoff_2 in number default null
393 ,p_usc_rate_3 in number default null
394 ,p_usc_yrly_cutoff_3 in number default null
395 ,p_usc_mthly_cutoff_3 in number default null
396 ,p_usc_wkly_cutoff_3 in number default null
397 ,p_usc_rate_4 in number default null
398 ,p_usc_yrly_cutoff_4 in number default null
399 ,p_usc_mthly_cutoff_4 in number default null
400 ,p_usc_wkly_cutoff_4 in number default null
401 ,p_usc_rate_5 in number default null
402 ,p_usc_tax_basis in varchar2 default null
403 ,p_usc_info_source in varchar2 default null
404 ,p_usc_pay_this_employment in number default null
405 ,p_usc_tax_this_employment in Number default null
406
407 --13359423
408 );
409 --
410 -- ----------------------------------------------------------------------------
411 -- |--------------------------< delete_ie_paye_details >----------------------|
412 -- ----------------------------------------------------------------------------
413 --
414 -- {Start Of Comments}
415 /*#
416 * This API Deletes PAYE Details for Ireland.
417 *
418 * A PAYE Detail record is deleted for an assignment. If P45 information is
419 * entered, then balance adjustments are deleted for the P45 data.
420 *
421 * <p><b>Licensing</b><br>
422 * This API is licensed for use with Human Resources.
423 *
424 * <p><b>Prerequisites</b><br>
425 * PAYE Details must exist for the assignment at the time of the deletion.
426 *
427 * <p><b>Post Success</b><br>
428 * A PAYE Details record is deleted for the assignment.
429 *
430 * <p><b>Post Failure</b><br>
431 * No PAYE Details records are deleted and an error raised.
432 * @param p_validate If true, then validation alone will be performed and the
436 * force.
433 * database will remain unchanged. If false and all validation checks pass,
434 * then the database will be modified.
435 * @param p_effective_date Determines when the DateTrack operation comes into
437 * @param p_datetrack_delete_mode Indicates which DateTrack mode to use when
438 * deleting the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
439 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
440 * on the dates of previous record changes and the effective date of this
441 * change.
442 * @param p_paye_details_id Identifies the PAYE details record to be deleted.
443 * @param p_object_version_number Current version number of the PAYE Details
444 * record to be deleted.
445 * @param p_effective_start_date If p_validate is false, then set to the
446 * effective start date for the deleted PAYE Details row which now exists as of
447 * the effective date. If p_validate is true, or all row instances have been
448 * deleted, then set to null.
449 * @param p_effective_end_date If p_validate is false, then set to the
450 * effective end date for the deleted PAYE Details row which now exists as of
451 * the effective date. If p_validate is true, or all row instances have been
452 * deleted, then set to null.
453 * @rep:displayname Delete PAYE Detail for Ireland
454 * @rep:category BUSINESS_ENTITY PAY_EMP_TAX_INFO
455 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
456 * @rep:scope public
457 * @rep:lifecycle active
458 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
459 */
460 --
461 -- {End Of Comments}
462 --
463 procedure delete_ie_paye_details
464 (p_validate in boolean default false
465 ,p_effective_date in date
466 ,p_datetrack_delete_mode in varchar2
467 ,p_paye_details_id in number
468 ,p_object_version_number in out nocopy number
469 ,p_effective_start_date out nocopy date
470 ,p_effective_end_date out nocopy date
471 );
472 --
473 end pay_ie_paye_api;