1 Package per_disability_api as
2 /* $Header: pedisapi.pkh 120.1 2005/10/02 02:14:49 aroussel $ */
3 /*#
4 * This package contains APIs which maintain a history of any disabilities a
5 * person may have.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Disability
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |----------------------------< create_disability >-------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a disability record for a person.
18 *
19 * The disability entity holds details describing the registered type of
20 * disability the person has, its extent, any restrictions to work which it
21 * causes, and how the disability changes over time. The disability may also be
22 * linked to a work incident.
23 *
24 * <p><b>Licensing</b><br>
25 * This API is licensed for use with Human Resources.
26 *
27 * <p><b>Prerequisites</b><br>
28 * The person must exist on the validation start date.
29 *
30 * <p><b>Post Success</b><br>
31 * The API has created the disability for the person.
32 *
33 * <p><b>Post Failure</b><br>
34 * The API does not create the disability and raises an error.
35 * @param p_validate If true, then validation alone will be performed and the
36 * database will remain unchanged. If false and all validation checks pass,
37 * then the database will be modified.
38 * @param p_effective_date Determines when the DateTrack operation comes into
39 * force.
40 * @param p_person_id Identifies the person for whom you create the disability
41 * record.
42 * @param p_category The official category of the disability the person has.
43 * Valid values are defined by the 'DISABILITY_CATEGORY' lookup type.
44 * @param p_status The status of the disability record. Valid values are
45 * defined by the 'DISABILITY_STATUS' lookup type.
46 * @param p_quota_fte The full time earnings measure that is accorded to the
47 * person due to the disability. The default value created is 1.00.
48 * @param p_organization_id Uniquely identifies the official disability
49 * organisation the person is registered with.
50 * @param p_registration_id The registration code given to the person by the
51 * disability organisation.
52 * @param p_registration_date The date the person was registered disabled.
53 * @param p_registration_exp_date The date the disability registration expires.
54 * @param p_description Text description of the disability.
55 * @param p_degree The percentage degree of disability the person has. This is
56 * an officially assessed figure, provided during the process of disability
57 * registration.
58 * @param p_reason The reason for disability. Valid values are defined by the
59 * 'DISABILITY_REASON' lookup type.
60 * @param p_work_restriction Text describing any restrictions to work the
61 * disabled person has.
62 * @param p_incident_id Uniquely identifies a work incident record which is
63 * being linked as a causal factor in the disability.
64 * @param p_medical_assessment_id Uniquely identifies the medical assessment
65 * record for this disability.
66 * @param p_pre_registration_job The name of the job the person was doing on
67 * the date they were registered disabled.
68 * @param p_attribute_category This context value determines which flexfield
69 * structure to use with the descriptive flexfield segments.
70 * @param p_attribute1 Descriptive flexfield segment.
71 * @param p_attribute2 Descriptive flexfield segment.
72 * @param p_attribute3 Descriptive flexfield segment.
73 * @param p_attribute4 Descriptive flexfield segment.
74 * @param p_attribute5 Descriptive flexfield segment.
75 * @param p_attribute6 Descriptive flexfield segment.
76 * @param p_attribute7 Descriptive flexfield segment.
77 * @param p_attribute8 Descriptive flexfield segment.
78 * @param p_attribute9 Descriptive flexfield segment.
79 * @param p_attribute10 Descriptive flexfield segment.
80 * @param p_attribute11 Descriptive flexfield segment.
81 * @param p_attribute12 Descriptive flexfield segment.
82 * @param p_attribute13 Descriptive flexfield segment.
83 * @param p_attribute14 Descriptive flexfield segment.
84 * @param p_attribute15 Descriptive flexfield segment.
85 * @param p_attribute16 Descriptive flexfield segment.
86 * @param p_attribute17 Descriptive flexfield segment.
87 * @param p_attribute18 Descriptive flexfield segment.
88 * @param p_attribute19 Descriptive flexfield segment.
89 * @param p_attribute20 Descriptive flexfield segment.
90 * @param p_attribute21 Descriptive flexfield segment.
91 * @param p_attribute22 Descriptive flexfield segment.
92 * @param p_attribute23 Descriptive flexfield segment.
93 * @param p_attribute24 Descriptive flexfield segment.
94 * @param p_attribute25 Descriptive flexfield segment.
95 * @param p_attribute26 Descriptive flexfield segment.
96 * @param p_attribute27 Descriptive flexfield segment.
97 * @param p_attribute28 Descriptive flexfield segment.
98 * @param p_attribute29 Descriptive flexfield segment.
99 * @param p_attribute30 Descriptive flexfield segment.
100 * @param p_dis_information_category This context value determines which
101 * Flexfield Structure to use with the Developer Descriptive flexfield
102 * segments.
103 * @param p_dis_information1 Developer Descriptive flexfield segment.
104 * @param p_dis_information2 Developer Descriptive flexfield segment.
105 * @param p_dis_information3 Developer Descriptive flexfield segment.
106 * @param p_dis_information4 Developer Descriptive flexfield segment.
107 * @param p_dis_information5 Developer Descriptive flexfield segment.
108 * @param p_dis_information6 Developer Descriptive flexfield segment.
109 * @param p_dis_information7 Developer Descriptive flexfield segment.
110 * @param p_dis_information8 Developer Descriptive flexfield segment.
111 * @param p_dis_information9 Developer Descriptive flexfield segment.
112 * @param p_dis_information10 Developer Descriptive flexfield segment.
113 * @param p_dis_information11 Developer Descriptive flexfield segment.
114 * @param p_dis_information12 Developer Descriptive flexfield segment.
115 * @param p_dis_information13 Developer Descriptive flexfield segment.
116 * @param p_dis_information14 Developer Descriptive flexfield segment.
117 * @param p_dis_information15 Developer Descriptive flexfield segment.
118 * @param p_dis_information16 Developer Descriptive flexfield segment.
119 * @param p_dis_information17 Developer Descriptive flexfield segment.
120 * @param p_dis_information18 Developer Descriptive flexfield segment.
121 * @param p_dis_information19 Developer Descriptive flexfield segment.
122 * @param p_dis_information20 Developer Descriptive flexfield segment.
123 * @param p_dis_information21 Developer Descriptive flexfield segment.
124 * @param p_dis_information22 Developer Descriptive flexfield segment.
125 * @param p_dis_information23 Developer Descriptive flexfield segment.
126 * @param p_dis_information24 Developer Descriptive flexfield segment.
127 * @param p_dis_information25 Developer Descriptive flexfield segment.
128 * @param p_dis_information26 Developer Descriptive flexfield segment.
129 * @param p_dis_information27 Developer Descriptive flexfield segment.
130 * @param p_dis_information28 Developer Descriptive flexfield segment.
131 * @param p_dis_information29 Developer Descriptive flexfield segment.
132 * @param p_dis_information30 Developer Descriptive flexfield segment.
133 * @param p_disability_id If p_validate is false, uniquely identifies the
134 * disability created by the API. If p_validate is true then set to null.
135 * @param p_object_version_number If p_validate is false, then set to the
136 * version number of the created disability. If p_validate is true, then the
137 * value will be null.
138 * @param p_effective_start_date If p_validate is false, then set to the
139 * earliest effective start date for the created disability. If p_validate is
140 * true, then set to null.
141 * @param p_effective_end_date If p_validate is false, then set to the
142 * effective end date for the created disability. If p_validate is true, then
143 * set to null.
144 * @rep:displayname Create Disability
145 * @rep:category BUSINESS_ENTITY PER_DISABILITY
146 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
147 * @rep:scope public
148 * @rep:lifecycle active
149 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
150 */
151 --
152 -- {End Of Comments}
153 --
154 procedure create_disability
155 (p_validate in boolean default false
156 ,p_effective_date in date
157 ,p_person_id in number
158 ,p_category in varchar2
159 ,p_status in varchar2
160 ,p_quota_fte in number default 1.00
161 ,p_organization_id in number default null
162 ,p_registration_id in varchar2 default null
163 ,p_registration_date in date default null
164 ,p_registration_exp_date in date default null
165 ,p_description in varchar2 default null
166 ,p_degree in number default null
167 ,p_reason in varchar2 default null
168 ,p_work_restriction in varchar2 default null
169 ,p_incident_id in number default null
170 ,p_medical_assessment_id in number default null
171 ,p_pre_registration_job in varchar2 default null
172 ,p_attribute_category in varchar2 default null
173 ,p_attribute1 in varchar2 default null
174 ,p_attribute2 in varchar2 default null
175 ,p_attribute3 in varchar2 default null
176 ,p_attribute4 in varchar2 default null
177 ,p_attribute5 in varchar2 default null
178 ,p_attribute6 in varchar2 default null
179 ,p_attribute7 in varchar2 default null
180 ,p_attribute8 in varchar2 default null
181 ,p_attribute9 in varchar2 default null
182 ,p_attribute10 in varchar2 default null
183 ,p_attribute11 in varchar2 default null
184 ,p_attribute12 in varchar2 default null
185 ,p_attribute13 in varchar2 default null
186 ,p_attribute14 in varchar2 default null
187 ,p_attribute15 in varchar2 default null
188 ,p_attribute16 in varchar2 default null
189 ,p_attribute17 in varchar2 default null
190 ,p_attribute18 in varchar2 default null
191 ,p_attribute19 in varchar2 default null
192 ,p_attribute20 in varchar2 default null
193 ,p_attribute21 in varchar2 default null
194 ,p_attribute22 in varchar2 default null
195 ,p_attribute23 in varchar2 default null
196 ,p_attribute24 in varchar2 default null
197 ,p_attribute25 in varchar2 default null
198 ,p_attribute26 in varchar2 default null
199 ,p_attribute27 in varchar2 default null
200 ,p_attribute28 in varchar2 default null
201 ,p_attribute29 in varchar2 default null
202 ,p_attribute30 in varchar2 default null
203 ,p_dis_information_category in varchar2 default null
204 ,p_dis_information1 in varchar2 default null
205 ,p_dis_information2 in varchar2 default null
206 ,p_dis_information3 in varchar2 default null
207 ,p_dis_information4 in varchar2 default null
208 ,p_dis_information5 in varchar2 default null
209 ,p_dis_information6 in varchar2 default null
210 ,p_dis_information7 in varchar2 default null
211 ,p_dis_information8 in varchar2 default null
212 ,p_dis_information9 in varchar2 default null
213 ,p_dis_information10 in varchar2 default null
214 ,p_dis_information11 in varchar2 default null
215 ,p_dis_information12 in varchar2 default null
216 ,p_dis_information13 in varchar2 default null
217 ,p_dis_information14 in varchar2 default null
218 ,p_dis_information15 in varchar2 default null
219 ,p_dis_information16 in varchar2 default null
220 ,p_dis_information17 in varchar2 default null
221 ,p_dis_information18 in varchar2 default null
222 ,p_dis_information19 in varchar2 default null
223 ,p_dis_information20 in varchar2 default null
224 ,p_dis_information21 in varchar2 default null
225 ,p_dis_information22 in varchar2 default null
226 ,p_dis_information23 in varchar2 default null
227 ,p_dis_information24 in varchar2 default null
228 ,p_dis_information25 in varchar2 default null
229 ,p_dis_information26 in varchar2 default null
230 ,p_dis_information27 in varchar2 default null
231 ,p_dis_information28 in varchar2 default null
232 ,p_dis_information29 in varchar2 default null
233 ,p_dis_information30 in varchar2 default null
234 ,p_disability_id out nocopy number
235 ,p_object_version_number out nocopy number
236 ,p_effective_start_date out nocopy date
237 ,p_effective_end_date out nocopy date
238 );
239 --
240 -- ----------------------------------------------------------------------------
241 -- |----------------------------< update_disability >-------------------------|
242 -- ----------------------------------------------------------------------------
243 --
244 -- {Start Of Comments}
245 /*#
246 * This API updates a disability record for a person.
247 *
248 * The disability entity holds details describing the registered type of
249 * disability the person has, its extent, any restrictions to work which it
250 * causes, and how the disability changes over time. The disability may also be
251 * linked to a work incident.
252 *
253 * <p><b>Licensing</b><br>
254 * This API is licensed for use with Human Resources.
255 *
256 * <p><b>Prerequisites</b><br>
257 * The disability record must exist.
258 *
259 * <p><b>Post Success</b><br>
260 * The disability record is updated.
261 *
262 * <p><b>Post Failure</b><br>
263 * The API does not update the disability record and raises an error.
264 * @param p_validate If true, then validation alone will be performed and the
265 * database will remain unchanged. If false and all validation checks pass,
266 * then the database will be modified.
267 * @param p_effective_date Determines when the DateTrack operation comes into
268 * force.
269 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
270 * the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or
271 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
272 * depend on the dates of previous record changes and the effective date of
273 * this change.
274 * @param p_disability_id Uniquely identifies the disability to be updated.
275 * @param p_object_version_number Pass in the current version number of the
276 * disability to be updated. When the API completes if p_validate is false,
277 * will be set to the new version number of the updated disability. If
278 * p_validate is true will be set to the same value which was passed in.
279 * @param p_category The official category of the disability the person has.
280 * Valid values are defined by the 'DISABILITY_CATEGORY' lookup type.
281 * @param p_status The status of the disability record. Valid values are
282 * defined by the 'DISABILITY_STATUS' lookup type.
283 * @param p_quota_fte The full time earnings measure that is accorded to the
284 * person due to the disability. The default value created is 1.00.
285 * @param p_organization_id Uniquely identifies the official disability
286 * organisation the person is registered with.
287 * @param p_registration_id The registration code given to the person by the
288 * disability organisation.
289 * @param p_registration_date The date the person was registered disabled.
290 * @param p_registration_exp_date The date the disability registration expires.
291 * @param p_description Text description of the disability.
292 * @param p_degree The percentage degree of disability the person has. This is
293 * an officially assessed figure, provided during the process of disability
294 * registration.
298 * disabled person has.
295 * @param p_reason The reason for disability. Valid values are defined by the
296 * 'DISABILITY_REASON' lookup type.
297 * @param p_work_restriction Text describing any restrictions to work the
299 * @param p_incident_id Uniquely identifies a work incident record which is
300 * being linked as a causal factor in the disability.
301 * @param p_medical_assessment_id Uniquely identifies the medical assessment
302 * record for this disability.
303 * @param p_pre_registration_job The name of the job the person was doing on
304 * the date they were registered disabled.
305 * @param p_attribute_category This context value determines which flexfield
306 * structure to use with the descriptive flexfield segments.
307 * @param p_attribute1 Descriptive flexfield segment.
308 * @param p_attribute2 Descriptive flexfield segment.
309 * @param p_attribute3 Descriptive flexfield segment.
310 * @param p_attribute4 Descriptive flexfield segment.
311 * @param p_attribute5 Descriptive flexfield segment.
312 * @param p_attribute6 Descriptive flexfield segment.
313 * @param p_attribute7 Descriptive flexfield segment.
314 * @param p_attribute8 Descriptive flexfield segment.
315 * @param p_attribute9 Descriptive flexfield segment.
316 * @param p_attribute10 Descriptive flexfield segment.
317 * @param p_attribute11 Descriptive flexfield segment.
318 * @param p_attribute12 Descriptive flexfield segment.
319 * @param p_attribute13 Descriptive flexfield segment.
320 * @param p_attribute14 Descriptive flexfield segment.
321 * @param p_attribute15 Descriptive flexfield segment.
322 * @param p_attribute16 Descriptive flexfield segment.
323 * @param p_attribute17 Descriptive flexfield segment.
324 * @param p_attribute18 Descriptive flexfield segment.
325 * @param p_attribute19 Descriptive flexfield segment.
326 * @param p_attribute20 Descriptive flexfield segment.
327 * @param p_attribute21 Descriptive flexfield segment.
328 * @param p_attribute22 Descriptive flexfield segment.
329 * @param p_attribute23 Descriptive flexfield segment.
330 * @param p_attribute24 Descriptive flexfield segment.
331 * @param p_attribute25 Descriptive flexfield segment.
332 * @param p_attribute26 Descriptive flexfield segment.
333 * @param p_attribute27 Descriptive flexfield segment.
334 * @param p_attribute28 Descriptive flexfield segment.
335 * @param p_attribute29 Descriptive flexfield segment.
336 * @param p_attribute30 Descriptive flexfield segment.
337 * @param p_dis_information_category This context value determines which
338 * Flexfield Structure to use with the Developer Descriptive flexfield
339 * segments.
340 * @param p_dis_information1 Developer Descriptive flexfield segment.
341 * @param p_dis_information2 Developer Descriptive flexfield segment.
342 * @param p_dis_information3 Developer Descriptive flexfield segment.
343 * @param p_dis_information4 Developer Descriptive flexfield segment.
344 * @param p_dis_information5 Developer Descriptive flexfield segment.
345 * @param p_dis_information6 Developer Descriptive flexfield segment.
346 * @param p_dis_information7 Developer Descriptive flexfield segment.
347 * @param p_dis_information8 Developer Descriptive flexfield segment.
348 * @param p_dis_information9 Developer Descriptive flexfield segment.
349 * @param p_dis_information10 Developer Descriptive flexfield segment.
350 * @param p_dis_information11 Developer Descriptive flexfield segment.
351 * @param p_dis_information12 Developer Descriptive flexfield segment.
352 * @param p_dis_information13 Developer Descriptive flexfield segment.
353 * @param p_dis_information14 Developer Descriptive flexfield segment.
354 * @param p_dis_information15 Developer Descriptive flexfield segment.
355 * @param p_dis_information16 Developer Descriptive flexfield segment.
356 * @param p_dis_information17 Developer Descriptive flexfield segment.
357 * @param p_dis_information18 Developer Descriptive flexfield segment.
358 * @param p_dis_information19 Developer Descriptive flexfield segment.
359 * @param p_dis_information20 Developer Descriptive flexfield segment.
360 * @param p_dis_information21 Developer Descriptive flexfield segment.
361 * @param p_dis_information22 Developer Descriptive flexfield segment.
362 * @param p_dis_information23 Developer Descriptive flexfield segment.
363 * @param p_dis_information24 Developer Descriptive flexfield segment.
364 * @param p_dis_information25 Developer Descriptive flexfield segment.
365 * @param p_dis_information26 Developer Descriptive flexfield segment.
366 * @param p_dis_information27 Developer Descriptive flexfield segment.
367 * @param p_dis_information28 Developer Descriptive flexfield segment.
368 * @param p_dis_information29 Developer Descriptive flexfield segment.
369 * @param p_dis_information30 Developer Descriptive flexfield segment.
370 * @param p_effective_start_date If p_validate is false, then set to the
371 * effective start date on the updated disability row which now exists as of
372 * the effective date. If p_validate is true, then set to null.
373 * @param p_effective_end_date If p_validate is false, then set to the
374 * effective end date on the updated disability row which now exists as of the
375 * effective date. If p_validate is true, then set to null.
376 * @rep:displayname Update Disability
377 * @rep:category BUSINESS_ENTITY PER_DISABILITY
378 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
379 * @rep:scope public
380 * @rep:lifecycle active
381 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
382 */
383 --
384 -- {End Of Comments}
385 --
386 procedure update_disability
387 (p_validate in boolean default false
388 ,p_effective_date in date
392 ,p_category in varchar2 default hr_api.g_varchar2
389 ,p_datetrack_mode in varchar2
390 ,p_disability_id in number
391 ,p_object_version_number in out nocopy number
393 ,p_status in varchar2 default hr_api.g_varchar2
394 ,p_quota_fte in number default hr_api.g_number
395 ,p_organization_id in number default hr_api.g_number
396 ,p_registration_id in varchar2 default hr_api.g_varchar2
397 ,p_registration_date in date default hr_api.g_date
398 ,p_registration_exp_date in date default hr_api.g_date
399 ,p_description in varchar2 default hr_api.g_varchar2
400 ,p_degree in number default hr_api.g_number
401 ,p_reason in varchar2 default hr_api.g_varchar2
402 ,p_work_restriction in varchar2 default hr_api.g_varchar2
403 ,p_incident_id in number default hr_api.g_number
404 ,p_medical_assessment_id in number default hr_api.g_number
405 ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
406 ,p_attribute_category in varchar2 default hr_api.g_varchar2
407 ,p_attribute1 in varchar2 default hr_api.g_varchar2
408 ,p_attribute2 in varchar2 default hr_api.g_varchar2
409 ,p_attribute3 in varchar2 default hr_api.g_varchar2
410 ,p_attribute4 in varchar2 default hr_api.g_varchar2
411 ,p_attribute5 in varchar2 default hr_api.g_varchar2
412 ,p_attribute6 in varchar2 default hr_api.g_varchar2
413 ,p_attribute7 in varchar2 default hr_api.g_varchar2
414 ,p_attribute8 in varchar2 default hr_api.g_varchar2
415 ,p_attribute9 in varchar2 default hr_api.g_varchar2
416 ,p_attribute10 in varchar2 default hr_api.g_varchar2
417 ,p_attribute11 in varchar2 default hr_api.g_varchar2
418 ,p_attribute12 in varchar2 default hr_api.g_varchar2
419 ,p_attribute13 in varchar2 default hr_api.g_varchar2
420 ,p_attribute14 in varchar2 default hr_api.g_varchar2
421 ,p_attribute15 in varchar2 default hr_api.g_varchar2
422 ,p_attribute16 in varchar2 default hr_api.g_varchar2
423 ,p_attribute17 in varchar2 default hr_api.g_varchar2
424 ,p_attribute18 in varchar2 default hr_api.g_varchar2
425 ,p_attribute19 in varchar2 default hr_api.g_varchar2
426 ,p_attribute20 in varchar2 default hr_api.g_varchar2
427 ,p_attribute21 in varchar2 default hr_api.g_varchar2
428 ,p_attribute22 in varchar2 default hr_api.g_varchar2
429 ,p_attribute23 in varchar2 default hr_api.g_varchar2
430 ,p_attribute24 in varchar2 default hr_api.g_varchar2
431 ,p_attribute25 in varchar2 default hr_api.g_varchar2
432 ,p_attribute26 in varchar2 default hr_api.g_varchar2
433 ,p_attribute27 in varchar2 default hr_api.g_varchar2
434 ,p_attribute28 in varchar2 default hr_api.g_varchar2
435 ,p_attribute29 in varchar2 default hr_api.g_varchar2
436 ,p_attribute30 in varchar2 default hr_api.g_varchar2
437 ,p_dis_information_category in varchar2 default hr_api.g_varchar2
438 ,p_dis_information1 in varchar2 default hr_api.g_varchar2
439 ,p_dis_information2 in varchar2 default hr_api.g_varchar2
440 ,p_dis_information3 in varchar2 default hr_api.g_varchar2
441 ,p_dis_information4 in varchar2 default hr_api.g_varchar2
442 ,p_dis_information5 in varchar2 default hr_api.g_varchar2
443 ,p_dis_information6 in varchar2 default hr_api.g_varchar2
444 ,p_dis_information7 in varchar2 default hr_api.g_varchar2
445 ,p_dis_information8 in varchar2 default hr_api.g_varchar2
446 ,p_dis_information9 in varchar2 default hr_api.g_varchar2
447 ,p_dis_information10 in varchar2 default hr_api.g_varchar2
448 ,p_dis_information11 in varchar2 default hr_api.g_varchar2
449 ,p_dis_information12 in varchar2 default hr_api.g_varchar2
450 ,p_dis_information13 in varchar2 default hr_api.g_varchar2
451 ,p_dis_information14 in varchar2 default hr_api.g_varchar2
452 ,p_dis_information15 in varchar2 default hr_api.g_varchar2
453 ,p_dis_information16 in varchar2 default hr_api.g_varchar2
454 ,p_dis_information17 in varchar2 default hr_api.g_varchar2
455 ,p_dis_information18 in varchar2 default hr_api.g_varchar2
456 ,p_dis_information19 in varchar2 default hr_api.g_varchar2
457 ,p_dis_information20 in varchar2 default hr_api.g_varchar2
458 ,p_dis_information21 in varchar2 default hr_api.g_varchar2
459 ,p_dis_information22 in varchar2 default hr_api.g_varchar2
460 ,p_dis_information23 in varchar2 default hr_api.g_varchar2
461 ,p_dis_information24 in varchar2 default hr_api.g_varchar2
462 ,p_dis_information25 in varchar2 default hr_api.g_varchar2
463 ,p_dis_information26 in varchar2 default hr_api.g_varchar2
467 ,p_dis_information30 in varchar2 default hr_api.g_varchar2
464 ,p_dis_information27 in varchar2 default hr_api.g_varchar2
465 ,p_dis_information28 in varchar2 default hr_api.g_varchar2
466 ,p_dis_information29 in varchar2 default hr_api.g_varchar2
468 ,p_effective_start_date out nocopy date
469 ,p_effective_end_date out nocopy date
470 );
471 --
472 -- ----------------------------------------------------------------------------
473 -- |----------------------------< delete_disability >-------------------------|
474 -- ----------------------------------------------------------------------------
475 --
476 -- {Start Of Comments}
477 /*#
478 * This API deletes a disability record for a person.
479 *
480 * The disability entity holds details describing the registered type of
481 * disability the person has, its extent, any restrictions to work which it
482 * causes, and how the disability changes over time. The disability may also be
483 * linked to a work incident.
484 *
485 * <p><b>Licensing</b><br>
486 * This API is licensed for use with Human Resources.
487 *
488 * <p><b>Prerequisites</b><br>
489 * The disability record to be deleted must already exist.
490 *
491 * <p><b>Post Success</b><br>
492 * The disability record is deleted.
493 *
494 * <p><b>Post Failure</b><br>
495 * The API does not delete the disability and raises an error.
496 * @param p_validate If true, then validation alone will be performed and the
497 * database will remain unchanged. If false and all validation checks pass,
498 * then the database will be modified.
499 * @param p_effective_date Determines when the DateTrack operation comes into
500 * force.
501 * @param p_datetrack_mode Indicates which DateTrack mode to use when deleting
502 * the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
503 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
504 * on the dates of previous record changes and the effective date of this
505 * change.
506 * @param p_disability_id Uniquely identifies the disability to be deleted.
507 * @param p_object_version_number Current version number of the disability to
508 * be deleted.
509 * @param p_effective_start_date If p_validate is false, then set to the
510 * effective start date for the deleted disability row which now exists as of
511 * the effective date. If p_validate is true or all row instances have been
512 * deleted then set to null.
513 * @param p_effective_end_date If p_validate is false, then set to the
514 * effective end date for the deleted disability row which now exists as of the
515 * effective date. If p_validate is true or all row instances have been deleted
516 * then set to null.
517 * @rep:displayname Delete Disability
518 * @rep:category BUSINESS_ENTITY PER_DISABILITY
519 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
520 * @rep:scope public
521 * @rep:lifecycle active
522 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
523 */
524 --
525 -- {End Of Comments}
526 --
527 procedure delete_disability
528 (p_validate in boolean default false
529 ,p_effective_date in date
530 ,p_datetrack_mode in varchar2
531 ,p_disability_id in number
532 ,p_object_version_number in out nocopy number
533 ,p_effective_start_date out nocopy date
534 ,p_effective_end_date out nocopy date
535 );
536 --
537 end per_disability_api;