181: ,p_ac_information30 => p_ac_information30
182: ,p_comments => p_comments
183: );
184: exception
185: when hr_api.cannot_find_prog_unit then
186: hr_api.cannot_find_prog_unit_error
187: (p_module_name => 'CREATE_PERSON_ABSENCE_CASE'
188: ,p_hook_type => 'BP'
189: );
182: ,p_comments => p_comments
183: );
184: exception
185: when hr_api.cannot_find_prog_unit then
186: hr_api.cannot_find_prog_unit_error
187: (p_module_name => 'CREATE_PERSON_ABSENCE_CASE'
188: ,p_hook_type => 'BP'
189: );
190: end;
342: ,p_absence_case_id => l_absence_case_id
343: ,p_object_version_number => l_object_version_number
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'CREATE_PERSON_ABSENCE_CASE'
349: ,p_hook_type => 'AP'
350: );
343: ,p_object_version_number => l_object_version_number
344: );
345: exception
346: when hr_api.cannot_find_prog_unit then
347: hr_api.cannot_find_prog_unit_error
348: (p_module_name => 'CREATE_PERSON_ABSENCE_CASE'
349: ,p_hook_type => 'AP'
350: );
351: end;
352: --
353: -- When in validation only mode raise the Validate_Enabled exception
354: --
355: if p_validate then
356: raise hr_api.validate_enabled;
357: end if;
358: --
359: -- Set all output arguments
360: --
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365:
366: exception
367: when hr_api.validate_enabled then
368: --
369: -- As the Validate_Enabled exception has been raised
370: -- we must rollback to the savepoint
371: --
396: --
397: procedure update_person_absence_case
398: (p_validate in boolean default false
399: ,p_absence_case_id in number
400: ,p_name in varchar2 default hr_api.g_varchar2
401: ,p_incident_id in number default hr_api.g_number
402: ,p_absence_category in varchar2 default null
403: ,p_ac_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_attribute1 in varchar2 default hr_api.g_varchar2
397: procedure update_person_absence_case
398: (p_validate in boolean default false
399: ,p_absence_case_id in number
400: ,p_name in varchar2 default hr_api.g_varchar2
401: ,p_incident_id in number default hr_api.g_number
402: ,p_absence_category in varchar2 default null
403: ,p_ac_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_attribute2 in varchar2 default hr_api.g_varchar2
399: ,p_absence_case_id in number
400: ,p_name in varchar2 default hr_api.g_varchar2
401: ,p_incident_id in number default hr_api.g_number
402: ,p_absence_category in varchar2 default null
403: ,p_ac_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
400: ,p_name in varchar2 default hr_api.g_varchar2
401: ,p_incident_id in number default hr_api.g_number
402: ,p_absence_category in varchar2 default null
403: ,p_ac_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
401: ,p_incident_id in number default hr_api.g_number
402: ,p_absence_category in varchar2 default null
403: ,p_ac_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
402: ,p_absence_category in varchar2 default null
403: ,p_ac_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
403: ,p_ac_attribute_category in varchar2 default hr_api.g_varchar2
404: ,p_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
404: ,p_attribute1 in varchar2 default hr_api.g_varchar2
405: ,p_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
405: ,p_attribute2 in varchar2 default hr_api.g_varchar2
406: ,p_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
406: ,p_attribute3 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
407: ,p_attribute4 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
408: ,p_attribute5 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
409: ,p_attribute6 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
410: ,p_attribute7 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
411: ,p_attribute8 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
412: ,p_attribute9 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
413: ,p_attribute10 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
414: ,p_attribute11 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
415: ,p_attribute12 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
416: ,p_attribute13 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
417: ,p_attribute14 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
418: ,p_attribute15 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
419: ,p_attribute16 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
420: ,p_attribute17 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
421: ,p_attribute18 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
422: ,p_attribute19 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
423: ,p_attribute20 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
424: ,p_attribute21 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
425: ,p_attribute22 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
426: ,p_attribute23 in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
427: ,p_attribute24 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
428: ,p_attribute25 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
429: ,p_attribute26 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
430: ,p_attribute27 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
431: ,p_attribute28 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
432: ,p_attribute29 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
433: ,p_attribute30 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
434: ,p_ac_information_category in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
435: ,p_ac_information1 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
436: ,p_ac_information2 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
437: ,p_ac_information3 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
438: ,p_ac_information4 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
439: ,p_ac_information5 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
440: ,p_ac_information6 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
441: ,p_ac_information7 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
442: ,p_ac_information8 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
443: ,p_ac_information9 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
444: ,p_ac_information10 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
445: ,p_ac_information11 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
446: ,p_ac_information12 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
447: ,p_ac_information13 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
448: ,p_ac_information14 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
449: ,p_ac_information15 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
450: ,p_ac_information16 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
451: ,p_ac_information17 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
452: ,p_ac_information18 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
453: ,p_ac_information19 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
454: ,p_ac_information20 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
462: ,p_ac_information28 in varchar2 default hr_api.g_varchar2
455: ,p_ac_information21 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
462: ,p_ac_information28 in varchar2 default hr_api.g_varchar2
463: ,p_ac_information29 in varchar2 default hr_api.g_varchar2
456: ,p_ac_information22 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
462: ,p_ac_information28 in varchar2 default hr_api.g_varchar2
463: ,p_ac_information29 in varchar2 default hr_api.g_varchar2
464: ,p_ac_information30 in varchar2 default hr_api.g_varchar2
457: ,p_ac_information23 in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
462: ,p_ac_information28 in varchar2 default hr_api.g_varchar2
463: ,p_ac_information29 in varchar2 default hr_api.g_varchar2
464: ,p_ac_information30 in varchar2 default hr_api.g_varchar2
465: ,p_comments in varchar2 default hr_api.g_varchar2
458: ,p_ac_information24 in varchar2 default hr_api.g_varchar2
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
462: ,p_ac_information28 in varchar2 default hr_api.g_varchar2
463: ,p_ac_information29 in varchar2 default hr_api.g_varchar2
464: ,p_ac_information30 in varchar2 default hr_api.g_varchar2
465: ,p_comments in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
459: ,p_ac_information25 in varchar2 default hr_api.g_varchar2
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
462: ,p_ac_information28 in varchar2 default hr_api.g_varchar2
463: ,p_ac_information29 in varchar2 default hr_api.g_varchar2
464: ,p_ac_information30 in varchar2 default hr_api.g_varchar2
465: ,p_comments in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ) is
460: ,p_ac_information26 in varchar2 default hr_api.g_varchar2
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
462: ,p_ac_information28 in varchar2 default hr_api.g_varchar2
463: ,p_ac_information29 in varchar2 default hr_api.g_varchar2
464: ,p_ac_information30 in varchar2 default hr_api.g_varchar2
465: ,p_comments in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ) is
468: --
461: ,p_ac_information27 in varchar2 default hr_api.g_varchar2
462: ,p_ac_information28 in varchar2 default hr_api.g_varchar2
463: ,p_ac_information29 in varchar2 default hr_api.g_varchar2
464: ,p_ac_information30 in varchar2 default hr_api.g_varchar2
465: ,p_comments in varchar2 default hr_api.g_varchar2
466: ,p_object_version_number in out nocopy number
467: ) is
468: --
469: -- Declare cursors and local variables
563: ,p_ac_information30 => p_ac_information30
564: ,p_comments => p_comments
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'UPDATE_PERSON_ABSENCE'
570: ,p_hook_type => 'BP'
571: );
564: ,p_comments => p_comments
565: );
566: exception
567: when hr_api.cannot_find_prog_unit then
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'UPDATE_PERSON_ABSENCE'
570: ,p_hook_type => 'BP'
571: );
572: end;
728: ,p_ac_information30 => p_ac_information30
729: ,p_comments => p_comments
730: );
731: exception
732: when hr_api.cannot_find_prog_unit then
733: hr_api.cannot_find_prog_unit_error
734: (p_module_name => 'UPDATE_PERSON_ABSENCE_CASE'
735: ,p_hook_type => 'AP'
736: );
729: ,p_comments => p_comments
730: );
731: exception
732: when hr_api.cannot_find_prog_unit then
733: hr_api.cannot_find_prog_unit_error
734: (p_module_name => 'UPDATE_PERSON_ABSENCE_CASE'
735: ,p_hook_type => 'AP'
736: );
737: end;
739: --
740: -- When in validation only mode raise the Validate_Enabled exception
741: --
742: if p_validate then
743: raise hr_api.validate_enabled;
744: end if;
745: --
746: hr_utility.set_location(' Leaving:'||l_proc, 90);
747: exception
744: end if;
745: --
746: hr_utility.set_location(' Leaving:'||l_proc, 90);
747: exception
748: when hr_api.validate_enabled then
749: --
750: -- As the Validate_Enabled exception has been raised
751: -- we must rollback to the savepoint
752: --
797: (p_absence_case_id => p_absence_case_id
798: ,p_object_version_number => p_object_version_number
799: );
800: exception
801: when hr_api.cannot_find_prog_unit then
802: hr_api.cannot_find_prog_unit_error
803: (p_module_name => 'DELETE_PERSON_ABSENCE_CASE'
804: ,p_hook_type => 'BP'
805: );
798: ,p_object_version_number => p_object_version_number
799: );
800: exception
801: when hr_api.cannot_find_prog_unit then
802: hr_api.cannot_find_prog_unit_error
803: (p_module_name => 'DELETE_PERSON_ABSENCE_CASE'
804: ,p_hook_type => 'BP'
805: );
806: end;
834: (p_absence_case_id => p_absence_case_id
835: ,p_object_version_number => p_object_version_number
836: );
837: exception
838: when hr_api.cannot_find_prog_unit then
839: hr_api.cannot_find_prog_unit_error
840: (p_module_name => 'DELETE_PERSON_ABSENCE_CASE'
841: ,p_hook_type => 'AP'
842: );
835: ,p_object_version_number => p_object_version_number
836: );
837: exception
838: when hr_api.cannot_find_prog_unit then
839: hr_api.cannot_find_prog_unit_error
840: (p_module_name => 'DELETE_PERSON_ABSENCE_CASE'
841: ,p_hook_type => 'AP'
842: );
843: end;
844: --
845: -- When in validation only mode raise the Validate_Enabled exception
846: --
847: if p_validate then
848: raise hr_api.validate_enabled;
849: end if;
850:
851: --
852: hr_utility.set_location(' Leaving:'||l_proc, 70);
850:
851: --
852: hr_utility.set_location(' Leaving:'||l_proc, 70);
853: exception
854: when hr_api.validate_enabled then
855: --
856: -- As the Validate_Enabled exception has been raised
857: -- we must rollback to the savepoint
858: --