177: ,p_information30 => p_information30
178: ,p_effective_date => l_effective_date
179: );
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'CREATE_PAY_SCALE'
184: ,p_hook_type => 'BP'
185: );
178: ,p_effective_date => l_effective_date
179: );
180: exception
181: when hr_api.cannot_find_prog_unit then
182: hr_api.cannot_find_prog_unit_error
183: (p_module_name => 'CREATE_PAY_SCALE'
184: ,p_hook_type => 'BP'
185: );
186: --
342: ,p_object_version_number => l_object_version_number
343: ,p_effective_date => l_effective_date
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_PAY_SCALE'
349: ,p_hook_type => 'AP'
350: );
343: ,p_effective_date => l_effective_date
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_PAY_SCALE'
349: ,p_hook_type => 'AP'
350: );
351: --
356: -- When in validation only mode raise the Validate_Enabled exception
357: --
358: if p_validate
359: then
360: raise hr_api.validate_enabled;
361: end if;
362: --
363: hr_utility.set_location(l_proc, 50);
364: --
370: hr_utility.set_location(' Leaving:' ||l_proc, 60);
371: --
372: exception
373: --
374: when hr_api.validate_enabled then
375: --
376: -- As the Validate_Enabled exception has been raised
377: -- we must rollback to the savepoint
378: --
410: --
411: procedure update_pay_scale
412: (p_validate in boolean default false
413: ,p_parent_spine_id in number
414: ,p_business_group_id in number default hr_api.g_number
415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_effective_date in date default hr_api.g_date
417: ,p_comments in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
411: procedure update_pay_scale
412: (p_validate in boolean default false
413: ,p_parent_spine_id in number
414: ,p_business_group_id in number default hr_api.g_number
415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_effective_date in date default hr_api.g_date
417: ,p_comments in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
412: (p_validate in boolean default false
413: ,p_parent_spine_id in number
414: ,p_business_group_id in number default hr_api.g_number
415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_effective_date in date default hr_api.g_date
417: ,p_comments in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
413: ,p_parent_spine_id in number
414: ,p_business_group_id in number default hr_api.g_number
415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_effective_date in date default hr_api.g_date
417: ,p_comments in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
421: ,p_request_id in number default hr_api.g_number
414: ,p_business_group_id in number default hr_api.g_number
415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_effective_date in date default hr_api.g_date
417: ,p_comments in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
421: ,p_request_id in number default hr_api.g_number
422: ,p_program_application_id in number default hr_api.g_number
415: ,p_name in varchar2 default hr_api.g_varchar2
416: ,p_effective_date in date default hr_api.g_date
417: ,p_comments in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
421: ,p_request_id in number default hr_api.g_number
422: ,p_program_application_id in number default hr_api.g_number
423: ,p_program_id in number default hr_api.g_number
416: ,p_effective_date in date default hr_api.g_date
417: ,p_comments in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
421: ,p_request_id in number default hr_api.g_number
422: ,p_program_application_id in number default hr_api.g_number
423: ,p_program_id in number default hr_api.g_number
424: ,p_program_update_date in date default hr_api.g_date
417: ,p_comments in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
421: ,p_request_id in number default hr_api.g_number
422: ,p_program_application_id in number default hr_api.g_number
423: ,p_program_id in number default hr_api.g_number
424: ,p_program_update_date in date default hr_api.g_date
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
418: ,p_increment_frequency in number default hr_api.g_number
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
421: ,p_request_id in number default hr_api.g_number
422: ,p_program_application_id in number default hr_api.g_number
423: ,p_program_id in number default hr_api.g_number
424: ,p_program_update_date in date default hr_api.g_date
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
419: ,p_increment_period in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
421: ,p_request_id in number default hr_api.g_number
422: ,p_program_application_id in number default hr_api.g_number
423: ,p_program_id in number default hr_api.g_number
424: ,p_program_update_date in date default hr_api.g_date
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
420: ,p_last_automatic_increment_dat in date default hr_api.g_date
421: ,p_request_id in number default hr_api.g_number
422: ,p_program_application_id in number default hr_api.g_number
423: ,p_program_id in number default hr_api.g_number
424: ,p_program_update_date in date default hr_api.g_date
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
421: ,p_request_id in number default hr_api.g_number
422: ,p_program_application_id in number default hr_api.g_number
423: ,p_program_id in number default hr_api.g_number
424: ,p_program_update_date in date default hr_api.g_date
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
422: ,p_program_application_id in number default hr_api.g_number
423: ,p_program_id in number default hr_api.g_number
424: ,p_program_update_date in date default hr_api.g_date
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
423: ,p_program_id in number default hr_api.g_number
424: ,p_program_update_date in date default hr_api.g_date
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
424: ,p_program_update_date in date default hr_api.g_date
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
425: ,p_attribute_category in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
426: ,p_attribute1 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
427: ,p_attribute2 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
428: ,p_attribute3 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
429: ,p_attribute4 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
430: ,p_attribute5 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
431: ,p_attribute6 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
432: ,p_attribute7 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
433: ,p_attribute8 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
434: ,p_attribute9 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
435: ,p_attribute10 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
436: ,p_attribute11 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
437: ,p_attribute12 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
438: ,p_attribute13 in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
439: ,p_attribute14 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
440: ,p_attribute15 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
441: ,p_attribute16 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
442: ,p_attribute17 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
443: ,p_attribute18 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
444: ,p_attribute19 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
445: ,p_attribute20 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
446: ,p_information_category in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
447: ,p_information1 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
448: ,p_information2 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
449: ,p_information3 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
450: ,p_information4 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
451: ,p_information5 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
452: ,p_information6 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
453: ,p_information7 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
454: ,p_information8 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
455: ,p_information9 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
456: ,p_information10 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
457: ,p_information11 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
458: ,p_information12 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
459: ,p_information13 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
460: ,p_information14 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
461: ,p_information15 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
462: ,p_information16 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
470: ,p_information24 in varchar2 default hr_api.g_varchar2
463: ,p_information17 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
470: ,p_information24 in varchar2 default hr_api.g_varchar2
471: ,p_information25 in varchar2 default hr_api.g_varchar2
464: ,p_information18 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
470: ,p_information24 in varchar2 default hr_api.g_varchar2
471: ,p_information25 in varchar2 default hr_api.g_varchar2
472: ,p_information26 in varchar2 default hr_api.g_varchar2
465: ,p_information19 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
470: ,p_information24 in varchar2 default hr_api.g_varchar2
471: ,p_information25 in varchar2 default hr_api.g_varchar2
472: ,p_information26 in varchar2 default hr_api.g_varchar2
473: ,p_information27 in varchar2 default hr_api.g_varchar2
466: ,p_information20 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
470: ,p_information24 in varchar2 default hr_api.g_varchar2
471: ,p_information25 in varchar2 default hr_api.g_varchar2
472: ,p_information26 in varchar2 default hr_api.g_varchar2
473: ,p_information27 in varchar2 default hr_api.g_varchar2
474: ,p_information28 in varchar2 default hr_api.g_varchar2
467: ,p_information21 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
470: ,p_information24 in varchar2 default hr_api.g_varchar2
471: ,p_information25 in varchar2 default hr_api.g_varchar2
472: ,p_information26 in varchar2 default hr_api.g_varchar2
473: ,p_information27 in varchar2 default hr_api.g_varchar2
474: ,p_information28 in varchar2 default hr_api.g_varchar2
475: ,p_information29 in varchar2 default hr_api.g_varchar2
468: ,p_information22 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
470: ,p_information24 in varchar2 default hr_api.g_varchar2
471: ,p_information25 in varchar2 default hr_api.g_varchar2
472: ,p_information26 in varchar2 default hr_api.g_varchar2
473: ,p_information27 in varchar2 default hr_api.g_varchar2
474: ,p_information28 in varchar2 default hr_api.g_varchar2
475: ,p_information29 in varchar2 default hr_api.g_varchar2
476: ,p_information30 in varchar2 default hr_api.g_varchar2
469: ,p_information23 in varchar2 default hr_api.g_varchar2
470: ,p_information24 in varchar2 default hr_api.g_varchar2
471: ,p_information25 in varchar2 default hr_api.g_varchar2
472: ,p_information26 in varchar2 default hr_api.g_varchar2
473: ,p_information27 in varchar2 default hr_api.g_varchar2
474: ,p_information28 in varchar2 default hr_api.g_varchar2
475: ,p_information29 in varchar2 default hr_api.g_varchar2
476: ,p_information30 in varchar2 default hr_api.g_varchar2
477: ,p_object_version_number in out nocopy number
470: ,p_information24 in varchar2 default hr_api.g_varchar2
471: ,p_information25 in varchar2 default hr_api.g_varchar2
472: ,p_information26 in varchar2 default hr_api.g_varchar2
473: ,p_information27 in varchar2 default hr_api.g_varchar2
474: ,p_information28 in varchar2 default hr_api.g_varchar2
475: ,p_information29 in varchar2 default hr_api.g_varchar2
476: ,p_information30 in varchar2 default hr_api.g_varchar2
477: ,p_object_version_number in out nocopy number
478: ) is
471: ,p_information25 in varchar2 default hr_api.g_varchar2
472: ,p_information26 in varchar2 default hr_api.g_varchar2
473: ,p_information27 in varchar2 default hr_api.g_varchar2
474: ,p_information28 in varchar2 default hr_api.g_varchar2
475: ,p_information29 in varchar2 default hr_api.g_varchar2
476: ,p_information30 in varchar2 default hr_api.g_varchar2
477: ,p_object_version_number in out nocopy number
478: ) is
479:
472: ,p_information26 in varchar2 default hr_api.g_varchar2
473: ,p_information27 in varchar2 default hr_api.g_varchar2
474: ,p_information28 in varchar2 default hr_api.g_varchar2
475: ,p_information29 in varchar2 default hr_api.g_varchar2
476: ,p_information30 in varchar2 default hr_api.g_varchar2
477: ,p_object_version_number in out nocopy number
478: ) is
479:
480: begin
558: --
559: procedure update_pay_scale
560: (p_validate in boolean default false
561: ,p_parent_spine_id in number
562: ,p_business_group_id in number default hr_api.g_number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_effective_date in date default hr_api.g_date
565: ,p_comments in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
559: procedure update_pay_scale
560: (p_validate in boolean default false
561: ,p_parent_spine_id in number
562: ,p_business_group_id in number default hr_api.g_number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_effective_date in date default hr_api.g_date
565: ,p_comments in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
560: (p_validate in boolean default false
561: ,p_parent_spine_id in number
562: ,p_business_group_id in number default hr_api.g_number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_effective_date in date default hr_api.g_date
565: ,p_comments in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
561: ,p_parent_spine_id in number
562: ,p_business_group_id in number default hr_api.g_number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_effective_date in date default hr_api.g_date
565: ,p_comments in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
569: ,p_request_id in number default hr_api.g_number
562: ,p_business_group_id in number default hr_api.g_number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_effective_date in date default hr_api.g_date
565: ,p_comments in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
569: ,p_request_id in number default hr_api.g_number
570: ,p_program_application_id in number default hr_api.g_number
563: ,p_name in varchar2 default hr_api.g_varchar2
564: ,p_effective_date in date default hr_api.g_date
565: ,p_comments in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
569: ,p_request_id in number default hr_api.g_number
570: ,p_program_application_id in number default hr_api.g_number
571: ,p_program_id in number default hr_api.g_number
564: ,p_effective_date in date default hr_api.g_date
565: ,p_comments in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
569: ,p_request_id in number default hr_api.g_number
570: ,p_program_application_id in number default hr_api.g_number
571: ,p_program_id in number default hr_api.g_number
572: ,p_program_update_date in date default hr_api.g_date
565: ,p_comments in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
569: ,p_request_id in number default hr_api.g_number
570: ,p_program_application_id in number default hr_api.g_number
571: ,p_program_id in number default hr_api.g_number
572: ,p_program_update_date in date default hr_api.g_date
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
566: ,p_increment_frequency in number default hr_api.g_number
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
569: ,p_request_id in number default hr_api.g_number
570: ,p_program_application_id in number default hr_api.g_number
571: ,p_program_id in number default hr_api.g_number
572: ,p_program_update_date in date default hr_api.g_date
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
567: ,p_increment_period in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
569: ,p_request_id in number default hr_api.g_number
570: ,p_program_application_id in number default hr_api.g_number
571: ,p_program_id in number default hr_api.g_number
572: ,p_program_update_date in date default hr_api.g_date
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
568: ,p_last_automatic_increment_dat in date default hr_api.g_date
569: ,p_request_id in number default hr_api.g_number
570: ,p_program_application_id in number default hr_api.g_number
571: ,p_program_id in number default hr_api.g_number
572: ,p_program_update_date in date default hr_api.g_date
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
569: ,p_request_id in number default hr_api.g_number
570: ,p_program_application_id in number default hr_api.g_number
571: ,p_program_id in number default hr_api.g_number
572: ,p_program_update_date in date default hr_api.g_date
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
570: ,p_program_application_id in number default hr_api.g_number
571: ,p_program_id in number default hr_api.g_number
572: ,p_program_update_date in date default hr_api.g_date
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
571: ,p_program_id in number default hr_api.g_number
572: ,p_program_update_date in date default hr_api.g_date
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
572: ,p_program_update_date in date default hr_api.g_date
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
573: ,p_attribute_category in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
574: ,p_attribute1 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
575: ,p_attribute2 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
576: ,p_attribute3 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
577: ,p_attribute4 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
578: ,p_attribute5 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
579: ,p_attribute6 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
580: ,p_attribute7 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
581: ,p_attribute8 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
582: ,p_attribute9 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
583: ,p_attribute10 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
584: ,p_attribute11 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
585: ,p_attribute12 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
586: ,p_attribute13 in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
587: ,p_attribute14 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
588: ,p_attribute15 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
589: ,p_attribute16 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
590: ,p_attribute17 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
591: ,p_attribute18 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
592: ,p_attribute19 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
593: ,p_attribute20 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
594: ,p_information_category in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
595: ,p_information1 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
596: ,p_information2 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
597: ,p_information3 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
598: ,p_information4 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
599: ,p_information5 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
600: ,p_information6 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
601: ,p_information7 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
602: ,p_information8 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
603: ,p_information9 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
604: ,p_information10 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
605: ,p_information11 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
606: ,p_information12 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
607: ,p_information13 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
608: ,p_information14 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
609: ,p_information15 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
610: ,p_information16 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
618: ,p_information24 in varchar2 default hr_api.g_varchar2
611: ,p_information17 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
618: ,p_information24 in varchar2 default hr_api.g_varchar2
619: ,p_information25 in varchar2 default hr_api.g_varchar2
612: ,p_information18 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
618: ,p_information24 in varchar2 default hr_api.g_varchar2
619: ,p_information25 in varchar2 default hr_api.g_varchar2
620: ,p_information26 in varchar2 default hr_api.g_varchar2
613: ,p_information19 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
618: ,p_information24 in varchar2 default hr_api.g_varchar2
619: ,p_information25 in varchar2 default hr_api.g_varchar2
620: ,p_information26 in varchar2 default hr_api.g_varchar2
621: ,p_information27 in varchar2 default hr_api.g_varchar2
614: ,p_information20 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
618: ,p_information24 in varchar2 default hr_api.g_varchar2
619: ,p_information25 in varchar2 default hr_api.g_varchar2
620: ,p_information26 in varchar2 default hr_api.g_varchar2
621: ,p_information27 in varchar2 default hr_api.g_varchar2
622: ,p_information28 in varchar2 default hr_api.g_varchar2
615: ,p_information21 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
618: ,p_information24 in varchar2 default hr_api.g_varchar2
619: ,p_information25 in varchar2 default hr_api.g_varchar2
620: ,p_information26 in varchar2 default hr_api.g_varchar2
621: ,p_information27 in varchar2 default hr_api.g_varchar2
622: ,p_information28 in varchar2 default hr_api.g_varchar2
623: ,p_information29 in varchar2 default hr_api.g_varchar2
616: ,p_information22 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
618: ,p_information24 in varchar2 default hr_api.g_varchar2
619: ,p_information25 in varchar2 default hr_api.g_varchar2
620: ,p_information26 in varchar2 default hr_api.g_varchar2
621: ,p_information27 in varchar2 default hr_api.g_varchar2
622: ,p_information28 in varchar2 default hr_api.g_varchar2
623: ,p_information29 in varchar2 default hr_api.g_varchar2
624: ,p_information30 in varchar2 default hr_api.g_varchar2
617: ,p_information23 in varchar2 default hr_api.g_varchar2
618: ,p_information24 in varchar2 default hr_api.g_varchar2
619: ,p_information25 in varchar2 default hr_api.g_varchar2
620: ,p_information26 in varchar2 default hr_api.g_varchar2
621: ,p_information27 in varchar2 default hr_api.g_varchar2
622: ,p_information28 in varchar2 default hr_api.g_varchar2
623: ,p_information29 in varchar2 default hr_api.g_varchar2
624: ,p_information30 in varchar2 default hr_api.g_varchar2
625: ,p_object_version_number in out nocopy number
618: ,p_information24 in varchar2 default hr_api.g_varchar2
619: ,p_information25 in varchar2 default hr_api.g_varchar2
620: ,p_information26 in varchar2 default hr_api.g_varchar2
621: ,p_information27 in varchar2 default hr_api.g_varchar2
622: ,p_information28 in varchar2 default hr_api.g_varchar2
623: ,p_information29 in varchar2 default hr_api.g_varchar2
624: ,p_information30 in varchar2 default hr_api.g_varchar2
625: ,p_object_version_number in out nocopy number
626: ,p_called_from in varchar2 -- added for bug 9328526
619: ,p_information25 in varchar2 default hr_api.g_varchar2
620: ,p_information26 in varchar2 default hr_api.g_varchar2
621: ,p_information27 in varchar2 default hr_api.g_varchar2
622: ,p_information28 in varchar2 default hr_api.g_varchar2
623: ,p_information29 in varchar2 default hr_api.g_varchar2
624: ,p_information30 in varchar2 default hr_api.g_varchar2
625: ,p_object_version_number in out nocopy number
626: ,p_called_from in varchar2 -- added for bug 9328526
627: ) is
620: ,p_information26 in varchar2 default hr_api.g_varchar2
621: ,p_information27 in varchar2 default hr_api.g_varchar2
622: ,p_information28 in varchar2 default hr_api.g_varchar2
623: ,p_information29 in varchar2 default hr_api.g_varchar2
624: ,p_information30 in varchar2 default hr_api.g_varchar2
625: ,p_object_version_number in out nocopy number
626: ,p_called_from in varchar2 -- added for bug 9328526
627: ) is
628:
728: ,p_information30 => p_information30
729: ,p_object_version_number => p_object_version_number
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_PAY_SCALE'
735: ,p_hook_type => 'BP'
736: );
729: ,p_object_version_number => p_object_version_number
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_PAY_SCALE'
735: ,p_hook_type => 'BP'
736: );
737: --
907: ,p_information30 => p_information30
908: ,p_object_version_number => l_object_version_number
909: );
910: exception
911: when hr_api.cannot_find_prog_unit then
912: hr_api.cannot_find_prog_unit_error
913: (p_module_name => 'UPDATE_PAY_SCALE'
914: ,p_hook_type => 'AP'
915: );
908: ,p_object_version_number => l_object_version_number
909: );
910: exception
911: when hr_api.cannot_find_prog_unit then
912: hr_api.cannot_find_prog_unit_error
913: (p_module_name => 'UPDATE_PAY_SCALE'
914: ,p_hook_type => 'AP'
915: );
916: --
921: -- When in validation only mode raise the Validate_Enabled exception
922: --
923: if p_validate
924: then
925: raise hr_api.validate_enabled;
926: end if;
927: --
928: hr_utility.set_location(l_proc, 50);
929: --
934: hr_utility.set_location(' Leaving:' ||l_proc, 60);
935: --
936: exception
937: --
938: when hr_api.validate_enabled then
939: --
940: -- As the Validate_Enabled exception has been raised
941: -- we must rollback to the savepoint
942: --
1028: ,p_parent_spine_id => p_parent_spine_id
1029: ,p_object_version_number => p_object_version_number
1030: );
1031: exception
1032: when hr_api.cannot_find_prog_unit then
1033: hr_api.cannot_find_prog_unit_error
1034: (p_module_name => 'DELETE_PAY_SCALE'
1035: ,p_hook_type => 'BP'
1036: );
1029: ,p_object_version_number => p_object_version_number
1030: );
1031: exception
1032: when hr_api.cannot_find_prog_unit then
1033: hr_api.cannot_find_prog_unit_error
1034: (p_module_name => 'DELETE_PAY_SCALE'
1035: ,p_hook_type => 'BP'
1036: );
1037: end;
1065: (p_validate => p_validate
1066: ,p_parent_spine_id => p_parent_spine_id
1067: ,p_object_version_number => p_object_version_number);
1068: exception
1069: when hr_api.cannot_find_prog_unit then
1070: hr_api.cannot_find_prog_unit_error
1071: (p_module_name => 'DELETE_PAY_SCALE'
1072: ,p_hook_type => 'AP'
1073: );
1066: ,p_parent_spine_id => p_parent_spine_id
1067: ,p_object_version_number => p_object_version_number);
1068: exception
1069: when hr_api.cannot_find_prog_unit then
1070: hr_api.cannot_find_prog_unit_error
1071: (p_module_name => 'DELETE_PAY_SCALE'
1072: ,p_hook_type => 'AP'
1073: );
1074: end;
1078: --
1079: -- When in validation only mode raise the Validate_Enabled exception
1080: --
1081: if p_validate then
1082: raise hr_api.validate_enabled;
1083: end if;
1084:
1085: hr_utility.set_location(' Leaving:'||l_proc, 100);
1086: exception
1083: end if;
1084:
1085: hr_utility.set_location(' Leaving:'||l_proc, 100);
1086: exception
1087: when hr_api.validate_enabled then
1088: hr_utility.set_location(' Leaving...:'||l_proc, 50);
1089: --
1090: -- As the Validate_Enabled exception has been raised
1091: -- we must rollback to the savepoint