1 Package pay_pl_sii_api as
2 /* $Header: pypsdapi.pkh 120.4 2006/04/24 23:37:08 nprasath noship $ */
3 /*#
4 * This package contains SII APIs for Poland.
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname SII details for Poland
8 */
9 -- ----------------------------------------------------------------------------
10 -- |-------------------------< create_pl_sii_details >-------------------------|
11 -- ----------------------------------------------------------------------------
12 -- { Start Of Comments}
13 --
14 -- Description:
15 -- This API creates a SII record for a Polish employee.
16
17 -- Prerequisites:
18 -- The Assignment/Person (p_per_or_asg_id) record must exist as of the effective
19 -- date (p_effective_date)
20 --
21 -- In Parameters:
22 -- Name Reqd Type Description
23 -- p_validate boolean If true, the database remains
24 -- unchanged. If false a valid
25 -- SII record is create in
26 -- the database.
27 -- p_effective_date Yes date The effective start date of the
28 -- SII
29 -- p_contract_category Yes varchar2 Contract Category for whom the
30 -- SII record applies
31 -- p_per_or_asg_id Yes number The Person/Assignment to whom
32 -- the SII record applies. If the
33 -- Contract Category is "CIVIL" then
34 -- this refers to the Person id. If
35 -- the Contract Category is "NORMAL"
36 -- then this refers to the Assignment
37 -- Id.
38 -- p_business_group_id Yes number The Employee's Business group
39 -- p_emp_social_security_info Yes varchar2 Employee Social Security
40 -- Information
41 -- p_old_age_contribution No varchar2 Old Age Contribution
42 -- Information
43 -- p_pension_contribution No varchar2 Pension Contribution
44 -- Information
45 -- p_sickness_contribution No varchar2 Sickness Contribution
46 -- Information
47 -- p_work_injury_contribution No varchar2 Work Injury Contribution
48 -- Information
49 -- p_labor_contribution No varchar2 Labor Contribution
50 -- Information
51 -- p_health_contribution No varchar2 Health Contribution
52 -- Information
53 -- p_unemployment_contribution No varchar2 Unemployment Contribution
54 -- Information
55 -- p_old_age_cont_end_reason No varchar2 Old Age Contribution End Reason
56 -- p_pension_cont_end_reason No varchar2 Pension Contribution End Reason
57 -- p_sickness_cont_end_reason No varchar2 Sickness Contribution End Reason
58 -- p_work_injury_cont_end_reason No varchar2 Work Injury Contribution End Reason
59 -- p_labor_fund_cont_end_reason No varchar2 Labor fund Contribution End Reason
60 -- p_health_cont_end_reason No varchar2 Health Contribution End Reason
61 -- p_unemployment_cont_end_reason No varchar2 Unemployment Contribution End
62 -- Reason
63
64
65 --
66 -- Post Success:
67 -- The API sets the following out parameters
68 --
69 -- Name Type Description
70 -- p_sii_details_id number Unique ID for the SII record created by
71 -- the API
72 -- p_object_version_number number Version number of the new SII record
73 -- p_effective_start_date date The effective start date for this
74 -- change
75 -- p_effective_end_date date The effective start date for this
76 -- change
77 -- p_effective_date_warning boolean Set to TRUE if the effective date has
78 -- has been reset to the Employee's/
79 -- Assignment's start date
80
81 -- Post Failure:
82 -- The API will not create the SII record and raises an error.
83 --
84 -- Access Status:
85 -- Internal Development Use Only.
86 --
87 -- {End Of Comments}
88 --
89 procedure create_pl_sii_details
90 (p_validate in boolean default false
91 ,p_effective_date in date
92 ,p_contract_category in varchar2
93 ,p_per_or_asg_id in number
94 ,p_business_group_id in number
95 ,p_emp_social_security_info in varchar2
96 ,p_old_age_contribution in varchar2 default null
97 ,p_pension_contribution in varchar2 default null
98 ,p_sickness_contribution in varchar2 default null
99 ,p_work_injury_contribution in varchar2 default null
100 ,p_labor_contribution in varchar2 default null
101 ,p_health_contribution in varchar2 default null
102 ,p_unemployment_contribution in varchar2 default null
103 ,p_old_age_cont_end_reason in varchar2 default null
104 ,p_pension_cont_end_reason in varchar2 default null
105 ,p_sickness_cont_end_reason in varchar2 default null
106 ,p_work_injury_cont_end_reason in varchar2 default null
107 ,p_labor_fund_cont_end_reason in varchar2 default null
108 ,p_health_cont_end_reason in varchar2 default null
109 ,p_unemployment_cont_end_reason in varchar2 default null
110 ,p_sii_details_id out nocopy number
111 ,p_object_version_number out nocopy number
112 ,p_effective_start_date out nocopy date
113 ,p_effective_end_date out nocopy date
114 ,p_effective_date_warning out nocopy boolean
115 );
116 --
117 --
118 -- ----------------------------------------------------------------------------
119 -- |----------------------< create_pl_civil_sii_details >-----------------------|
120 -- ----------------------------------------------------------------------------
121 -- {Start Of Comments}
122 --
123 /*#
124 * This API creates a SII record for a Polish employee with a
125 * civil contract category.
126 * User hook for this module should be placed against
127 * module name 'create_pl_sii_details'.
128 *
129 * <p><b>Licensing</b><br>
130 * This API is licensed for use with Human Resources.
131 *
132 * <p><b>Prerequisites</b><br>
133 * The assignment(p_assignment_id) record must exist as of the effective
134 * date (p_effective_date).
135 *
136 * <p><b> Post Success</b><br>
137 * A new SII record is created.
138 *
139 * <p><b> Post Failure</b><br>
140 * The API will not create the SII record and raises an error.
141 *
142 * @param p_validate If true, the database remains unchanged. If false,a valid
143 * SII record is created in the database.
144 * @param p_effective_date The effective start date of the SII record.
145 * @param p_assignment_id The assignment to whom the SII record applies.
146 * @param p_emp_social_security_info Employee social security information
147 * @param p_old_age_contribution Old age contribution information.Valid values
148 * for all contributions are defined by 'PL_CONTRIBUTION_TYPE' lookup type
149 * @param p_pension_contribution Pension contribution information
150 * @param p_sickness_contribution Sickness contribution information
151 * @param p_work_injury_contribution Work injury contribution information
152 * @param p_labor_contribution Labor contribution information
153 * @param p_health_contribution Health contribution information
154 * @param p_unemployment_contribution Unemployment contribution information
155 * @param p_sii_details_id If p_validate is false, then this uniquely
156 * identifies the created SII record. If p_validate is true, then set to null
157 * @param p_object_version_number If p_validate is false, then set to the
158 * version number of the new SII record.If p_validate is true, then set to null
159 * @param p_effective_start_date If p_validate is false, then set to the start
160 * date for this record.If p_validate is true, then set to null
161 * @param p_effective_end_date If p_validate is false, then set to the end date
162 * for this record.If p_validate is true, then set to null
163 * @param p_effective_date_warning If p_validate is false,Set to TRUE if the
164 * effective date has been reset to the date when the assignment first
165 * became a civil contract.If p_validate is true,then set to null
166 * @rep:displayname Create SII record for civil contract
167 * @rep:category BUSINESS_ENTITY HR_SOC_INS_CONTRIBUTIONS
168 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
169 * @rep:lifecycle active
170 * @rep:scope public
171 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
172 */
173 --
174 -- {End Of Comments}
175 --
176 procedure create_pl_civil_sii_details
177 (p_validate in boolean default false
178 ,p_effective_date in date
179 ,p_assignment_id in number
180 ,p_emp_social_security_info in varchar2
181 ,p_old_age_contribution in varchar2 default null
182 ,p_pension_contribution in varchar2 default null
183 ,p_sickness_contribution in varchar2 default null
184 ,p_work_injury_contribution in varchar2 default null
185 ,p_labor_contribution in varchar2 default null
186 ,p_health_contribution in varchar2 default null
187 ,p_unemployment_contribution in varchar2 default null
188 ,p_sii_details_id out nocopy number
189 ,p_object_version_number out nocopy number
190 ,p_effective_start_date out nocopy date
191 ,p_effective_end_date out nocopy date
192 ,p_effective_date_warning out nocopy boolean
193 );
194 --
195 --
196 --
197 -- ----------------------------------------------------------------------------
198 -- |---------------------< create_pl_normal_sii_details >----------------------|
199 -- ----------------------------------------------------------------------------
200 -- {Start Of Comments}
201 --
202 /*#
203 * This API creates a SII record for a Polish employee with a normal contract
204 * category.
205 * User hook for this module should be placed against
206 * module name 'create_pl_sii_details'
207 *
208 * <p><b>Licensing</b><br>
209 * This API is licensed for use with Human Resources.
210 *
211 * <p><b>Prerequisites</b><br>
212 * The person(p_person_id) record must exist as of the effective
213 * date (p_effective_date).
214 *
215 * <p><b> Post Success</b><br>
216 * A new SII record is created.
217 *
218 * <p><b> Post Failure</b><br>
219 * The API will not create the SII record and raises an error.
220 *
221 * @param p_validate If true, the database remains unchanged. If false,a valid
222 * SII record is created in the database.
223 * @param p_effective_date The effective start date of the SII record.
224 * @param p_person_id The person to whom the SII record applies.
225 * @param p_emp_social_security_info Employee social security information
226 * @param p_old_age_contribution Old age contribution information.Valid values
227 * for all contributions are defined by 'PL_CONTRIBUTION_TYPE' lookup type
231 * @param p_labor_contribution Labor contribution information
228 * @param p_pension_contribution Pension contribution information
229 * @param p_sickness_contribution Sickness contribution information
230 * @param p_work_injury_contribution Work injury contribution information
232 * @param p_health_contribution Health Contribution Information
233 * @param p_unemployment_contribution Unemployment contribution information
234 * @param p_sii_details_id If p_validate is false, then this uniquely
235 * identifies the created SII record created.If p_validate is true,
236 * then set to null
237 * @param p_object_version_number If p_validate is false, then set to the
238 * version number of the new SII record.If p_validate is true, then set to null
239 * @param p_effective_start_date If p_validate is false, then set to the start
240 * date for this record.If p_validate is true, then set to null
241 * @param p_effective_end_date If p_validate is false, then set to the end date
242 * for this record.If p_validate is true, then set to null
243 * @param p_effective_date_warning If p_validate is false,set to TRUE if the
244 * effective date has been reset to the employee's start date.If p_validate
245 * is true,then set to null
246 * @rep:displayname Create SII record for normal contract
247 * @rep:category BUSINESS_ENTITY HR_SOC_INS_CONTRIBUTIONS
248 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
249 * @rep:lifecycle active
250 * @rep:scope public
251 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
252 */
253 --
254 -- {End Of Comments}
255 --
256
257 procedure create_pl_normal_sii_details
258 (p_validate in boolean default false
259 ,p_effective_date in date
260 ,p_person_id in number
261 ,p_emp_social_security_info in varchar2
262 ,p_old_age_contribution in varchar2 default null
263 ,p_pension_contribution in varchar2 default null
264 ,p_sickness_contribution in varchar2 default null
265 ,p_work_injury_contribution in varchar2 default null
266 ,p_labor_contribution in varchar2 default null
267 ,p_health_contribution in varchar2 default null
268 ,p_unemployment_contribution in varchar2 default null
269 ,p_sii_details_id out nocopy number
270 ,p_object_version_number out nocopy number
271 ,p_effective_start_date out nocopy date
272 ,p_effective_end_date out nocopy date
273 ,p_effective_date_warning out nocopy boolean
274 );
275
276 --
277 --
278 --
279 -- ----------------------------------------------------------------------------
280 -- |----------------------< create_pl_lump_sii_details >-----------------------|
281 -- ----------------------------------------------------------------------------
282 -- {Start Of Comments}
283 --
284 /*#
285 * This API creates a SII record for a Polish employee with a lump sum
286 * contract category.
287 * User hook for this module should be placed against
288 * module name 'create_pl_sii_details'
289 *
290 * <p><b>Licensing</b><br>
291 * This API is licensed for use with Human Resources.
292 *
293 * <p><b>Prerequisites</b><br>
294 * The assignment(p_assignment_id) record must exist as of the effective
295 * date (p_effective_date).
296 *
297 * <p><b> Post Success</b><br>
298 * A new SII record is created.
299 *
300 * <p><b> Post Failure</b><br>
301 * The API will not create the SII record and raises an error.
302 *
303 * @param p_validate If true, the database remains unchanged. If false,a valid
304 * SII record is created in the database.
305 * @param p_effective_date The effective start date of the SII record.
306 * @param p_assignment_id The Assignment to whom the SII record applies.
307 * @param p_emp_social_security_info Employee social security information
308 * @param p_old_age_contribution Old age contribution information.Valid values
309 * for all contributions are defined by 'PL_CONTRIBUTION_TYPE' lookup type
310 * @param p_pension_contribution Pension contribution information
311 * @param p_sickness_contribution Sickness contribution information
312 * @param p_work_injury_contribution Work injury contribution information
313 * @param p_labor_contribution Labor contribution information
314 * @param p_health_contribution Health contribution information
315 * @param p_unemployment_contribution Unemployment contribution information
316 * @param p_sii_details_id If p_validate is false, then this uniquely
317 * identifies the created SII record. If p_validate is true, then set to null.
318 * @param p_object_version_number If p_validate is false, then set to the
319 * version number of the new SII record.If p_validate is true, then set to null
320 * @param p_effective_start_date If p_validate is false, then set to the start
321 * date for this record.If p_validate is true, then set to null
322 * @param p_effective_end_date If p_validate is false, then set to the end date
323 * for this record.If p_validate is true, then set to null
324 * @param p_effective_date_warning Set to TRUE if the effective date has been
325 * reset to the date when the assignment first became a lump sum contract
326 * @rep:displayname Create SII record for lump sum contract.
327 * @rep:category BUSINESS_ENTITY HR_SOC_INS_CONTRIBUTIONS
328 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
329 * @rep:lifecycle active
330 * @rep:scope public
331 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
332 */
333 -- {End Of Comments}
334 --
335 procedure create_pl_lump_sii_details
336 (p_validate in boolean default false
337 ,p_effective_date in date
338 ,p_assignment_id in number
339 ,p_emp_social_security_info in varchar2
343 ,p_work_injury_contribution in varchar2 default null
340 ,p_old_age_contribution in varchar2 default null
341 ,p_pension_contribution in varchar2 default null
342 ,p_sickness_contribution in varchar2 default null
344 ,p_labor_contribution in varchar2 default null
345 ,p_health_contribution in varchar2 default null
346 ,p_unemployment_contribution in varchar2 default null
347 ,p_sii_details_id out nocopy number
348 ,p_object_version_number out nocopy number
349 ,p_effective_start_date out nocopy date
350 ,p_effective_end_date out nocopy date
351 ,p_effective_date_warning out nocopy boolean
352 );
353 --
354 --
355 -- ----------------------------------------------------------------------------
356 -- |----------------------< create_pl_f_lump_sii_details >---------------------|
357 -- ----------------------------------------------------------------------------
358 -- {Start Of Comments}
359 --
360 /*#
361 * This API creates a SII record for a Polish employee with a foreign
362 * lump sum contract category.
363 * User hook for this module should be placed against
364 * module name 'create_pl_sii_details'
365 *
366 * <p><b>Licensing</b><br>
367 * This API is licensed for use with Human Resources.
368 *
369 * <p><b>Prerequisites</b><br>
370 * The assignment(p_assignment_id) record must exist as of the effective
371 * date (p_effective_date).
372 *
373 * <p><b> Post Success</b><br>
374 * A new SII record is created.
375 *
376 * <p><b> Post Failure</b><br>
377 * The API will not create the SII record and raises an error.
378 *
379 * @param p_validate If true, the database remains unchanged. If false,a valid
380 * SII record is created in the database.
381 * @param p_effective_date The effective start date of the SII record.
382 * @param p_assignment_id The Assignment to whom the SII record applies.
383 * @param p_emp_social_security_info Employee social security information
384 * @param p_old_age_contribution Old age contribution information.Valid values
385 * for all contributions are defined by 'PL_CONTRIBUTION_TYPE' lookup type
386 * @param p_pension_contribution Pension contribution information
387 * @param p_sickness_contribution Sickness contribution information
388 * @param p_work_injury_contribution Work injury contribution information
389 * @param p_labor_contribution Labor contribution information
390 * @param p_health_contribution Health contribution information
391 * @param p_unemployment_contribution Unemployment contribution information
392 * @param p_sii_details_id If p_validate is false, then this uniquely
393 * identifies the created SII record. If p_validate is true, then set to null
394 * @param p_object_version_number If p_validate is false, then set to the
395 * version of new SII record.If p_validate is true, then set to null
396 * @param p_effective_start_date If p_validate is false, then set to the start
397 * date for this record.If p_validate is true, then set to null
398 * @param p_effective_end_date If p_validate is false, then set to the end date
399 * for this record.If p_validate is true, then set to null
400 * @param p_effective_date_warning Set to TRUE if the effective date has been
401 * reset to the date when the assignment first became a foreign lump sum contract
402 * @rep:displayname Create SII record for foreign lump sum contract.
403 * @rep:category BUSINESS_ENTITY HR_SOC_INS_CONTRIBUTIONS
404 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
405 * @rep:lifecycle active
406 * @rep:scope public
407 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
408 */
409 --
410 -- {End Of Comments}
411 --
412 procedure create_pl_f_lump_sii_details
413 (p_validate in boolean default false
414 ,p_effective_date in date
415 ,p_assignment_id in number
416 ,p_emp_social_security_info in varchar2
417 ,p_old_age_contribution in varchar2 default null
418 ,p_pension_contribution in varchar2 default null
419 ,p_sickness_contribution in varchar2 default null
420 ,p_work_injury_contribution in varchar2 default null
421 ,p_labor_contribution in varchar2 default null
422 ,p_health_contribution in varchar2 default null
423 ,p_unemployment_contribution in varchar2 default null
424 ,p_sii_details_id out nocopy number
425 ,p_object_version_number out nocopy number
426 ,p_effective_start_date out nocopy date
427 ,p_effective_end_date out nocopy date
428 ,p_effective_date_warning out nocopy boolean
429 );
430 --
431 --
432 --
433 -- ----------------------------------------------------------------------------
434 -- |-------------------------< update_pl_sii_details >-------------------------|
435 -- ----------------------------------------------------------------------------
436 -- {Start Of Comments}
437 --
438 /*#
439 * This API updates the SII record of a Polish employee.
440 *
441 * <p><b>Licensing</b><br>
442 * This API is licensed for use with Human Resources.
443 *
444 * <p><b>Prerequisites</b><br>
445 * The SII record (p_sii_details_id) must exist as of the effective date of the
446 * update (p_effective_date)
447 *
448 * <p><b> Post Success</b><br>
449 * The API updates the SII record
450 *
451 * <p><b> Post Failure</b><br>
452 * The API does not update the SII record and raises an error.
453 *
454 * @param p_validate If true, the database remains unchanged. If false,
455 * SII record is updated in the database.
456 * @param p_effective_date Determines when the DateTrack operation comes into
457 * force
461 * particular record depend on the dates of previous record changes and the
458 * @param p_datetrack_update_mode Indicates which DateTrack mode to use when
459 * updating the record. You must set to either UPDATE, CORRECTION,
460 * UPDATE_OVERRIDE or UPDATE_CHANGE_INSERT. Modes available for use with a
462 * effective date of this change.
463 * @param p_sii_details_id Identifies the SII record to be updated
464 * @param p_emp_social_security_info Employee social security information
465 * @param p_old_age_contribution Old age contribution information.Valid values
466 * for all contributions are defined by 'PL_CONTRIBUTION_TYPE' lookup type
467 * @param p_pension_contribution Pension contribution information
468 * @param p_sickness_contribution Sickness contribution information
469 * @param p_work_injury_contribution Work injury contribution information
470 * @param p_labor_contribution Labor contribution information
471 * @param p_health_contribution Health contribution information
472 * @param p_unemployment_contribution Unemployment contribution information
473 * @param p_old_age_cont_end_reason Old age contribution end reason.Valid
474 * values for all end reasons are defined by 'PL_CONTRIBUTION_END_REASON'
475 * lookup type
476 * @param p_pension_cont_end_reason Pension contribution end reason
477 * @param p_sickness_cont_end_reason Sickness contribution end reason
478 * @param p_work_injury_cont_end_reason Work injury contribution end reason
479 * @param p_labor_fund_cont_end_reason Labor fund contribution end reason
480 * @param p_health_cont_end_reason Health contribution end reason
481 * @param p_unemployment_cont_end_reason Unemployment contribution end reason
482 * @param p_object_version_number Pass in the version number of the SII record
483 * to be updated. When the API completes, if p_validate is false, will be set
484 * to the new version number of the updated SII record. If p_validate is true
485 * will be set to the same value which was passed in.
486 * @param p_effective_start_date If p_validate is false, then set to the start
487 * date for this updated SII record which exists as of the effective date.If
488 * p_validate is true, then set to null
489 * @param p_effective_end_date If p_validate is false, then set to the end date
490 * for this updated SII record which exists as of the effective date.If
491 * p_validate is true, then set to null
492 * @rep:displayname Update SII record of Polish employee.
493 * @rep:category BUSINESS_ENTITY HR_SOC_INS_CONTRIBUTIONS
494 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
495 * @rep:lifecycle active
496 * @rep:scope public
497 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
498 */
499 --
500 -- {End Of Comments}
501 --
502 procedure update_pl_sii_details
503 (p_validate in boolean default false
504 ,p_effective_date in date
505 ,p_datetrack_update_mode in varchar2
506 ,p_sii_details_id in number
507 ,p_object_version_number in out nocopy number
508 ,p_emp_social_security_info in varchar2 default hr_api.g_varchar2
509 ,p_old_age_contribution in varchar2 default hr_api.g_varchar2
510 ,p_pension_contribution in varchar2 default hr_api.g_varchar2
511 ,p_sickness_contribution in varchar2 default hr_api.g_varchar2
512 ,p_work_injury_contribution in varchar2 default hr_api.g_varchar2
513 ,p_labor_contribution in varchar2 default hr_api.g_varchar2
514 ,p_health_contribution in varchar2 default hr_api.g_varchar2
515 ,p_unemployment_contribution in varchar2 default hr_api.g_varchar2
516 ,p_old_age_cont_end_reason in varchar2 default hr_api.g_varchar2
520 ,p_labor_fund_cont_end_reason in varchar2 default hr_api.g_varchar2
517 ,p_pension_cont_end_reason in varchar2 default hr_api.g_varchar2
518 ,p_sickness_cont_end_reason in varchar2 default hr_api.g_varchar2
519 ,p_work_injury_cont_end_reason in varchar2 default hr_api.g_varchar2
521 ,p_health_cont_end_reason in varchar2 default hr_api.g_varchar2
522 ,p_unemployment_cont_end_reason in varchar2 default hr_api.g_varchar2
523 ,p_effective_start_date out nocopy date
524 ,p_effective_end_date out nocopy date
525 );
526 --
527 --
528
529 -- ----------------------------------------------------------------------------
530 -- |-------------------------< delete_pl_sii_details >-------------------------|
531 -- ----------------------------------------------------------------------------
532 -- {Start Of Comments}
533 --
534 /*#
535 * This API deletes the SII record of a Polish Employee.
536 *
537 * <p><b>Licensing</b><br>
538 * This API is licensed for use with Human Resources.
539 *
540 * <p><b>Prerequisites</b><br>
541 * The SII record (p_sii_details_id) must exist as of the effective date of the
542 * delete (p_effective_date)
543 *
544 * <p><b> Post Success</b><br>
545 * The API deletes the SII record
546 *
547 * <p><b> Post Failure</b><br>
548 * The API does not delete the SII record and raises an error.
549 * @param p_validate If true, the database remains unchanged. If false,
550 * SII record is deleted in the database.
551 * @param p_effective_date Determines when the DateTrack operation comes into
552 * force
553 * @param p_datetrack_delete_mode Indicates which DateTrack mode to use when
554 * deleting the record. You must set to either ZAP, DELETE_NEXT_CHANGE or
555 * FUTURE_CHANGE. Modes available for use with a particular record depend on
556 * the dates of previous record changes and the effective date of this change.
557 * @param p_sii_details_id Identifies the SII record to be deleted
558 * @param p_object_version_number Pass in the version number of the SII record
559 * to be deleted. When the API completes, if p_validate is false, will be set
560 * to the new version number of the deleted SII record. If p_validate is true
561 * will be set to the same value which was passed in.
562 * @param p_effective_start_date If p_validate is false, then set to the start
563 * date for this updated SII record which exists as of the effective date.If
564 * p_validate is true, then set to null
565 * @param p_effective_end_date If p_validate is false, then set to the end date
566 * for this updated SII record which exists as of the effective date.If
567 * p_validate is true, then set to null
568 * @rep:displayname Delete SII record of Polish employee.
569 * @rep:category BUSINESS_ENTITY HR_SOC_INS_CONTRIBUTIONS
570 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
571 * @rep:lifecycle active
572 * @rep:scope public
573 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
574 */
575 -- {End Of Comments}
576 --
577 procedure delete_pl_sii_details
578 (p_validate in boolean default false
579 ,p_effective_date in date
580 ,p_datetrack_delete_mode in varchar2
581 ,p_sii_details_id in number
582 ,p_object_version_number in out nocopy number
583 ,p_effective_start_date out nocopy date
584 ,p_effective_end_date out nocopy date
585 );
586 --
587 --
588 end PAY_PL_SII_API;
[Home] [Help]