eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_ABSENCE_TYPE_API dependencies on HR_API

Line 14: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 104: hr_api.validate_language_code(p_language_code => l_language_code);

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: --

Line 169: when hr_api.cannot_find_prog_unit then

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: );

Line 170: hr_api.cannot_find_prog_unit_error

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;

Line 330: when hr_api.cannot_find_prog_unit then

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: );

Line 331: hr_api.cannot_find_prog_unit_error

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;

Line 340: raise hr_api.validate_enabled;

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: --

Line 355: when hr_api.validate_enabled then

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: --

Line 400: ,p_language_code in varchar2 default hr_api.userenv_lang

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

Line 401: ,p_input_value_id in number default hr_api.g_number

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

Line 402: ,p_date_effective in date default hr_api.g_date

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

Line 404: ,p_name 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

Line 405: ,p_absence_category 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

Line 406: ,p_comments 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

Line 407: ,p_hours_or_days 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

Line 408: ,p_inc_or_dec_flag 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

Line 409: ,p_attribute_category 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

Line 410: ,p_attribute1 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

Line 411: ,p_attribute2 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

Line 412: ,p_attribute3 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

Line 413: ,p_attribute4 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

Line 414: ,p_attribute5 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

Line 415: ,p_attribute6 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

Line 416: ,p_attribute7 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

Line 417: ,p_attribute8 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

Line 418: ,p_attribute9 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

Line 419: ,p_attribute10 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

Line 420: ,p_attribute11 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

Line 421: ,p_attribute12 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

Line 422: ,p_attribute13 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

Line 423: ,p_attribute14 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

Line 424: ,p_attribute15 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

Line 425: ,p_attribute16 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

Line 426: ,p_attribute17 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

Line 427: ,p_attribute18 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

Line 428: ,p_attribute19 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

Line 429: ,p_attribute20 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

Line 430: ,p_information_category 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

Line 431: ,p_information1 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

Line 432: ,p_information2 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

Line 433: ,p_information3 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

Line 434: ,p_information4 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

Line 435: ,p_information5 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

Line 436: ,p_information6 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

Line 437: ,p_information7 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

Line 438: ,p_information8 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

Line 439: ,p_information9 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

Line 440: ,p_information10 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

Line 441: ,p_information11 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

Line 442: ,p_information12 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

Line 443: ,p_information13 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

Line 444: ,p_information14 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

Line 445: ,p_information15 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

Line 446: ,p_information16 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

Line 447: ,p_information17 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

Line 448: ,p_information18 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

Line 449: ,p_information19 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
453: ,p_advance_pay in varchar2 default hr_api.g_varchar2

Line 450: ,p_information20 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

Line 451: ,p_user_role 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

Line 452: ,p_assignment_status_type_id in number default hr_api.g_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

Line 453: ,p_advance_pay 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
457: --

Line 454: ,p_absence_overlap_flag 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: --
458: -- Declare cursors and local variables

Line 497: hr_api.validate_language_code(p_language_code => l_language_code);

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: --

Line 563: when hr_api.cannot_find_prog_unit then

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: );

Line 564: hr_api.cannot_find_prog_unit_error

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;

Line 583: and nvl(p_input_value_id,hr_api.g_number) <> hr_api.g_number then

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: --

Line 731: when hr_api.cannot_find_prog_unit then

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: );

Line 732: hr_api.cannot_find_prog_unit_error

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;

Line 741: raise hr_api.validate_enabled;

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: --

Line 754: when hr_api.validate_enabled then

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: --

Line 819: when hr_api.cannot_find_prog_unit then

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: );

Line 820: hr_api.cannot_find_prog_unit_error

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;

Line 858: when hr_api.cannot_find_prog_unit then

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: );

Line 859: hr_api.cannot_find_prog_unit_error

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;

Line 868: raise hr_api.validate_enabled;

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);

Line 875: when hr_api.validate_enabled then

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: --