10: -- |--------------------------< create_absence_type >-------------------------|
11: -- ----------------------------------------------------------------------------
12: procedure create_absence_type
13: (p_validate in boolean default false
14: ,p_language_code in varchar2 default hr_api.userenv_lang
15: ,p_business_group_id in number default null
16: ,p_input_value_id in number default null
17: ,p_date_effective in date
18: ,p_date_end in out nocopy date
100: -- instead of p_language_code from now on, to allow an IN OUT parameter to
101: -- be passed through.
102: --
103: l_language_code := p_language_code;
104: hr_api.validate_language_code(p_language_code => l_language_code);
105: --
106: --
107: -- Call Before Process User Hook
108: --
165: ,p_advance_pay => p_advance_pay
166: ,p_absence_overlap_flag => p_absence_overlap_flag
167: );
168: exception
169: when hr_api.cannot_find_prog_unit then
170: hr_api.cannot_find_prog_unit_error
171: (p_module_name => 'create_absence_type'
172: ,p_hook_type => 'BP'
173: );
166: ,p_absence_overlap_flag => p_absence_overlap_flag
167: );
168: exception
169: when hr_api.cannot_find_prog_unit then
170: hr_api.cannot_find_prog_unit_error
171: (p_module_name => 'create_absence_type'
172: ,p_hook_type => 'BP'
173: );
174: end;
326: ,p_absence_attendance_type_id => l_absence_attendance_type_id
327: ,p_object_version_number => l_object_version_number
328: );
329: exception
330: when hr_api.cannot_find_prog_unit then
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'create_absence_type'
333: ,p_hook_type => 'AP'
334: );
327: ,p_object_version_number => l_object_version_number
328: );
329: exception
330: when hr_api.cannot_find_prog_unit then
331: hr_api.cannot_find_prog_unit_error
332: (p_module_name => 'create_absence_type'
333: ,p_hook_type => 'AP'
334: );
335: end;
336: --
337: -- When in validation only mode raise the Validate_Enabled exception
338: --
339: if p_validate then
340: raise hr_api.validate_enabled;
341: end if;
342: --
343: -- Set all IN OUT and OUT parameters with out values
344: --
351: hr_utility.set_location(' Leaving:'||l_proc, 70);
352: end if;
353: --
354: exception
355: when hr_api.validate_enabled then
356: --
357: -- As the Validate_Enabled exception has been raised
358: -- we must rollback to the savepoint
359: --
396: -- ----------------------------------------------------------------------------
397: procedure update_absence_type
398: (p_validate in boolean default false
399: ,p_absence_attendance_type_id in number
400: ,p_language_code in varchar2 default hr_api.userenv_lang
401: ,p_input_value_id in number default hr_api.g_number
402: ,p_date_effective in date default hr_api.g_date
403: ,p_date_end in out nocopy date
404: ,p_name in varchar2 default hr_api.g_varchar2
397: procedure update_absence_type
398: (p_validate in boolean default false
399: ,p_absence_attendance_type_id in number
400: ,p_language_code in varchar2 default hr_api.userenv_lang
401: ,p_input_value_id in number default hr_api.g_number
402: ,p_date_effective in date default hr_api.g_date
403: ,p_date_end in out nocopy date
404: ,p_name in varchar2 default hr_api.g_varchar2
405: ,p_absence_category in varchar2 default hr_api.g_varchar2
398: (p_validate in boolean default false
399: ,p_absence_attendance_type_id in number
400: ,p_language_code in varchar2 default hr_api.userenv_lang
401: ,p_input_value_id in number default hr_api.g_number
402: ,p_date_effective in date default hr_api.g_date
403: ,p_date_end in out nocopy date
404: ,p_name in varchar2 default hr_api.g_varchar2
405: ,p_absence_category in varchar2 default hr_api.g_varchar2
406: ,p_comments in varchar2 default hr_api.g_varchar2
400: ,p_language_code in varchar2 default hr_api.userenv_lang
401: ,p_input_value_id in number default hr_api.g_number
402: ,p_date_effective in date default hr_api.g_date
403: ,p_date_end in out nocopy date
404: ,p_name in varchar2 default hr_api.g_varchar2
405: ,p_absence_category in varchar2 default hr_api.g_varchar2
406: ,p_comments in varchar2 default hr_api.g_varchar2
407: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
401: ,p_input_value_id in number default hr_api.g_number
402: ,p_date_effective in date default hr_api.g_date
403: ,p_date_end in out nocopy date
404: ,p_name in varchar2 default hr_api.g_varchar2
405: ,p_absence_category in varchar2 default hr_api.g_varchar2
406: ,p_comments in varchar2 default hr_api.g_varchar2
407: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
402: ,p_date_effective in date default hr_api.g_date
403: ,p_date_end in out nocopy date
404: ,p_name in varchar2 default hr_api.g_varchar2
405: ,p_absence_category in varchar2 default hr_api.g_varchar2
406: ,p_comments in varchar2 default hr_api.g_varchar2
407: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
403: ,p_date_end in out nocopy date
404: ,p_name in varchar2 default hr_api.g_varchar2
405: ,p_absence_category in varchar2 default hr_api.g_varchar2
406: ,p_comments in varchar2 default hr_api.g_varchar2
407: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
404: ,p_name in varchar2 default hr_api.g_varchar2
405: ,p_absence_category in varchar2 default hr_api.g_varchar2
406: ,p_comments in varchar2 default hr_api.g_varchar2
407: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
405: ,p_absence_category in varchar2 default hr_api.g_varchar2
406: ,p_comments in varchar2 default hr_api.g_varchar2
407: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
406: ,p_comments in varchar2 default hr_api.g_varchar2
407: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
407: ,p_hours_or_days in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
408: ,p_inc_or_dec_flag in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
409: ,p_attribute_category in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
410: ,p_attribute1 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
411: ,p_attribute2 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
412: ,p_attribute3 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
413: ,p_attribute4 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
414: ,p_attribute5 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
415: ,p_attribute6 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
416: ,p_attribute7 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
417: ,p_attribute8 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
418: ,p_attribute9 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
419: ,p_attribute10 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
420: ,p_attribute11 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
421: ,p_attribute12 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
422: ,p_attribute13 in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
423: ,p_attribute14 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
424: ,p_attribute15 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
425: ,p_attribute16 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
426: ,p_attribute17 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
427: ,p_attribute18 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
428: ,p_attribute19 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
429: ,p_attribute20 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
430: ,p_information_category in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
431: ,p_information1 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
432: ,p_information2 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
433: ,p_information3 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
434: ,p_information4 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
435: ,p_information5 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
436: ,p_information6 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
437: ,p_information7 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
445: ,p_information15 in varchar2 default hr_api.g_varchar2
438: ,p_information8 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
445: ,p_information15 in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
439: ,p_information9 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
445: ,p_information15 in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
440: ,p_information10 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
445: ,p_information15 in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
448: ,p_information18 in varchar2 default hr_api.g_varchar2
441: ,p_information11 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
445: ,p_information15 in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
448: ,p_information18 in varchar2 default hr_api.g_varchar2
449: ,p_information19 in varchar2 default hr_api.g_varchar2
442: ,p_information12 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
445: ,p_information15 in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
448: ,p_information18 in varchar2 default hr_api.g_varchar2
449: ,p_information19 in varchar2 default hr_api.g_varchar2
450: ,p_information20 in varchar2 default hr_api.g_varchar2
443: ,p_information13 in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
445: ,p_information15 in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
448: ,p_information18 in varchar2 default hr_api.g_varchar2
449: ,p_information19 in varchar2 default hr_api.g_varchar2
450: ,p_information20 in varchar2 default hr_api.g_varchar2
451: ,p_user_role in varchar2 default hr_api.g_varchar2
444: ,p_information14 in varchar2 default hr_api.g_varchar2
445: ,p_information15 in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
448: ,p_information18 in varchar2 default hr_api.g_varchar2
449: ,p_information19 in varchar2 default hr_api.g_varchar2
450: ,p_information20 in varchar2 default hr_api.g_varchar2
451: ,p_user_role in varchar2 default hr_api.g_varchar2
452: ,p_assignment_status_type_id in number default hr_api.g_number
445: ,p_information15 in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
448: ,p_information18 in varchar2 default hr_api.g_varchar2
449: ,p_information19 in varchar2 default hr_api.g_varchar2
450: ,p_information20 in varchar2 default hr_api.g_varchar2
451: ,p_user_role in varchar2 default hr_api.g_varchar2
452: ,p_assignment_status_type_id in number default hr_api.g_number
453: ,p_advance_pay in varchar2 default hr_api.g_varchar2
446: ,p_information16 in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
448: ,p_information18 in varchar2 default hr_api.g_varchar2
449: ,p_information19 in varchar2 default hr_api.g_varchar2
450: ,p_information20 in varchar2 default hr_api.g_varchar2
451: ,p_user_role in varchar2 default hr_api.g_varchar2
452: ,p_assignment_status_type_id in number default hr_api.g_number
453: ,p_advance_pay in varchar2 default hr_api.g_varchar2
454: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
447: ,p_information17 in varchar2 default hr_api.g_varchar2
448: ,p_information18 in varchar2 default hr_api.g_varchar2
449: ,p_information19 in varchar2 default hr_api.g_varchar2
450: ,p_information20 in varchar2 default hr_api.g_varchar2
451: ,p_user_role in varchar2 default hr_api.g_varchar2
452: ,p_assignment_status_type_id in number default hr_api.g_number
453: ,p_advance_pay in varchar2 default hr_api.g_varchar2
454: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
455: ,p_object_version_number in out nocopy number
448: ,p_information18 in varchar2 default hr_api.g_varchar2
449: ,p_information19 in varchar2 default hr_api.g_varchar2
450: ,p_information20 in varchar2 default hr_api.g_varchar2
451: ,p_user_role in varchar2 default hr_api.g_varchar2
452: ,p_assignment_status_type_id in number default hr_api.g_number
453: ,p_advance_pay in varchar2 default hr_api.g_varchar2
454: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
455: ,p_object_version_number in out nocopy number
456: ) is
449: ,p_information19 in varchar2 default hr_api.g_varchar2
450: ,p_information20 in varchar2 default hr_api.g_varchar2
451: ,p_user_role in varchar2 default hr_api.g_varchar2
452: ,p_assignment_status_type_id in number default hr_api.g_number
453: ,p_advance_pay in varchar2 default hr_api.g_varchar2
454: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
455: ,p_object_version_number in out nocopy number
456: ) is
457: --
450: ,p_information20 in varchar2 default hr_api.g_varchar2
451: ,p_user_role in varchar2 default hr_api.g_varchar2
452: ,p_assignment_status_type_id in number default hr_api.g_number
453: ,p_advance_pay in varchar2 default hr_api.g_varchar2
454: ,p_absence_overlap_flag in varchar2 default hr_api.g_varchar2
455: ,p_object_version_number in out nocopy number
456: ) is
457: --
458: -- Declare cursors and local variables
493: -- instead of p_language_code from now on, to allow an IN OUT parameter to
494: -- be passed through.
495: --
496: l_language_code := p_language_code;
497: hr_api.validate_language_code(p_language_code => l_language_code);
498: --
499: --
500: -- Call Before Process User Hook
501: --
559: ,p_absence_overlap_flag => p_absence_overlap_flag
560: ,p_object_version_number => l_object_version_number
561: );
562: exception
563: when hr_api.cannot_find_prog_unit then
564: hr_api.cannot_find_prog_unit_error
565: (p_module_name => 'update_absence_type'
566: ,p_hook_type => 'BP'
567: );
560: ,p_object_version_number => l_object_version_number
561: );
562: exception
563: when hr_api.cannot_find_prog_unit then
564: hr_api.cannot_find_prog_unit_error
565: (p_module_name => 'update_absence_type'
566: ,p_hook_type => 'BP'
567: );
568: end;
579: hr_utility.set_location('Entering:'|| l_proc, 20);
580: end if;
581: --
582: if l_derived_rec.business_group_id is null
583: and nvl(p_input_value_id,hr_api.g_number) <> hr_api.g_number then
584: fnd_message.set_name('PER','PER_449173_ABB_NO_BG_NO_INPUT');
585: fnd_message.raise_error;
586: end if;
587: --
727: ,p_absence_overlap_flag => p_absence_overlap_flag
728: ,p_object_version_number => l_object_version_number
729: );
730: exception
731: when hr_api.cannot_find_prog_unit then
732: hr_api.cannot_find_prog_unit_error
733: (p_module_name => 'update_absence_type'
734: ,p_hook_type => 'AP'
735: );
728: ,p_object_version_number => l_object_version_number
729: );
730: exception
731: when hr_api.cannot_find_prog_unit then
732: hr_api.cannot_find_prog_unit_error
733: (p_module_name => 'update_absence_type'
734: ,p_hook_type => 'AP'
735: );
736: end;
737: --
738: -- When in validation only mode raise the Validate_Enabled exception
739: --
740: if p_validate then
741: raise hr_api.validate_enabled;
742: end if;
743: --
744: -- Set all IN OUT and OUT parameters with out values
745: --
750: hr_utility.set_location(' Leaving:'||l_proc, 60);
751: end if;
752: --
753: exception
754: when hr_api.validate_enabled then
755: --
756: -- As the Validate_Enabled exception has been raised
757: -- we must rollback to the savepoint
758: --
815: (p_absence_attendance_type_id => p_absence_attendance_type_id
816: ,p_object_version_number => p_object_version_number
817: );
818: exception
819: when hr_api.cannot_find_prog_unit then
820: hr_api.cannot_find_prog_unit_error
821: (p_module_name => 'delete_absence_type'
822: ,p_hook_type => 'BP'
823: );
816: ,p_object_version_number => p_object_version_number
817: );
818: exception
819: when hr_api.cannot_find_prog_unit then
820: hr_api.cannot_find_prog_unit_error
821: (p_module_name => 'delete_absence_type'
822: ,p_hook_type => 'BP'
823: );
824: end;
854: (p_absence_attendance_type_id => p_absence_attendance_type_id
855: ,p_object_version_number => p_object_version_number
856: );
857: exception
858: when hr_api.cannot_find_prog_unit then
859: hr_api.cannot_find_prog_unit_error
860: (p_module_name => 'delete_absence_type'
861: ,p_hook_type => 'AP'
862: );
855: ,p_object_version_number => p_object_version_number
856: );
857: exception
858: when hr_api.cannot_find_prog_unit then
859: hr_api.cannot_find_prog_unit_error
860: (p_module_name => 'delete_absence_type'
861: ,p_hook_type => 'AP'
862: );
863: end;
864: --
865: -- When in validation only mode raise the Validate_Enabled exception
866: --
867: if p_validate then
868: raise hr_api.validate_enabled;
869: end if;
870: --
871: if g_debug then
872: hr_utility.set_location(' Leaving:'||l_proc, 70);
871: if g_debug then
872: hr_utility.set_location(' Leaving:'||l_proc, 70);
873: end if;
874: exception
875: when hr_api.validate_enabled then
876: --
877: -- As the Validate_Enabled exception has been raised
878: -- we must rollback to the savepoint
879: --