202: ,p_dis_information28 => p_dis_information28
203: ,p_dis_information29 => p_dis_information29
204: ,p_dis_information30 => p_dis_information30);
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'create_disability_b'
209: ,p_hook_type => 'BP'
210: );
203: ,p_dis_information29 => p_dis_information29
204: ,p_dis_information30 => p_dis_information30);
205: exception
206: when hr_api.cannot_find_prog_unit then
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'create_disability_b'
209: ,p_hook_type => 'BP'
210: );
211: end;
385: ,p_effective_start_date => l_effective_start_date
386: ,p_effective_end_date => l_effective_end_date
387: );
388: exception
389: when hr_api.cannot_find_prog_unit then
390: hr_api.cannot_find_prog_unit_error
391: (p_module_name => 'create_disability_a'
392: ,p_hook_type => 'AP'
393: );
386: ,p_effective_end_date => l_effective_end_date
387: );
388: exception
389: when hr_api.cannot_find_prog_unit then
390: hr_api.cannot_find_prog_unit_error
391: (p_module_name => 'create_disability_a'
392: ,p_hook_type => 'AP'
393: );
394: end;
426: --
427: -- When in validation only mode raise the Validate_Enabled exception
428: --
429: if p_validate then
430: raise hr_api.validate_enabled;
431: end if;
432: --
433: -- Set all output arguments
434: --
438: p_effective_end_date := l_effective_end_date;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 70);
441: exception
442: when hr_api.validate_enabled then
443: --
444: -- As the Validate_Enabled exception has been raised
445: -- we must rollback to the savepoint
446: --
483: ,p_effective_date in date
484: ,p_datetrack_mode in varchar2
485: ,p_disability_id in number
486: ,p_object_version_number in out nocopy number
487: ,p_category in varchar2 default hr_api.g_varchar2
488: ,p_status in varchar2 default hr_api.g_varchar2
489: ,p_quota_fte in number default hr_api.g_number
490: ,p_organization_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
484: ,p_datetrack_mode in varchar2
485: ,p_disability_id in number
486: ,p_object_version_number in out nocopy number
487: ,p_category in varchar2 default hr_api.g_varchar2
488: ,p_status in varchar2 default hr_api.g_varchar2
489: ,p_quota_fte in number default hr_api.g_number
490: ,p_organization_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
492: ,p_registration_date in date default hr_api.g_date
485: ,p_disability_id in number
486: ,p_object_version_number in out nocopy number
487: ,p_category in varchar2 default hr_api.g_varchar2
488: ,p_status in varchar2 default hr_api.g_varchar2
489: ,p_quota_fte in number default hr_api.g_number
490: ,p_organization_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
492: ,p_registration_date in date default hr_api.g_date
493: ,p_registration_exp_date in date default hr_api.g_date
486: ,p_object_version_number in out nocopy number
487: ,p_category in varchar2 default hr_api.g_varchar2
488: ,p_status in varchar2 default hr_api.g_varchar2
489: ,p_quota_fte in number default hr_api.g_number
490: ,p_organization_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
492: ,p_registration_date in date default hr_api.g_date
493: ,p_registration_exp_date in date default hr_api.g_date
494: ,p_description in varchar2 default hr_api.g_varchar2
487: ,p_category in varchar2 default hr_api.g_varchar2
488: ,p_status in varchar2 default hr_api.g_varchar2
489: ,p_quota_fte in number default hr_api.g_number
490: ,p_organization_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
492: ,p_registration_date in date default hr_api.g_date
493: ,p_registration_exp_date in date default hr_api.g_date
494: ,p_description in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
488: ,p_status in varchar2 default hr_api.g_varchar2
489: ,p_quota_fte in number default hr_api.g_number
490: ,p_organization_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
492: ,p_registration_date in date default hr_api.g_date
493: ,p_registration_exp_date in date default hr_api.g_date
494: ,p_description in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
496: ,p_reason in varchar2 default hr_api.g_varchar2
489: ,p_quota_fte in number default hr_api.g_number
490: ,p_organization_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
492: ,p_registration_date in date default hr_api.g_date
493: ,p_registration_exp_date in date default hr_api.g_date
494: ,p_description in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
496: ,p_reason in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
490: ,p_organization_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
492: ,p_registration_date in date default hr_api.g_date
493: ,p_registration_exp_date in date default hr_api.g_date
494: ,p_description in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
496: ,p_reason in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
491: ,p_registration_id in varchar2 default hr_api.g_varchar2
492: ,p_registration_date in date default hr_api.g_date
493: ,p_registration_exp_date in date default hr_api.g_date
494: ,p_description in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
496: ,p_reason in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
499: ,p_medical_assessment_id in number default hr_api.g_number
492: ,p_registration_date in date default hr_api.g_date
493: ,p_registration_exp_date in date default hr_api.g_date
494: ,p_description in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
496: ,p_reason in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
499: ,p_medical_assessment_id in number default hr_api.g_number
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
493: ,p_registration_exp_date in date default hr_api.g_date
494: ,p_description in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
496: ,p_reason in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
499: ,p_medical_assessment_id in number default hr_api.g_number
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
494: ,p_description in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
496: ,p_reason in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
499: ,p_medical_assessment_id in number default hr_api.g_number
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
495: ,p_degree in number default hr_api.g_number
496: ,p_reason in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
499: ,p_medical_assessment_id in number default hr_api.g_number
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
496: ,p_reason in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
499: ,p_medical_assessment_id in number default hr_api.g_number
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
497: ,p_work_restriction in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
499: ,p_medical_assessment_id in number default hr_api.g_number
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
498: ,p_incident_id in number default hr_api.g_number
499: ,p_medical_assessment_id in number default hr_api.g_number
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
499: ,p_medical_assessment_id in number default hr_api.g_number
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
500: ,p_pre_registration_job in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
501: ,p_attribute_category in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
502: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
503: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
504: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
505: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
506: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
507: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
508: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
509: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
510: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
511: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
512: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
513: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
514: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
515: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
516: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
517: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
518: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
519: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
520: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
521: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
522: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
523: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
524: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
525: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
526: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
527: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
528: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
529: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
530: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
531: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
532: ,p_dis_information_category in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
533: ,p_dis_information1 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
534: ,p_dis_information2 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
535: ,p_dis_information3 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
536: ,p_dis_information4 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
537: ,p_dis_information5 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
538: ,p_dis_information6 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
539: ,p_dis_information7 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
540: ,p_dis_information8 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
541: ,p_dis_information9 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
542: ,p_dis_information10 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
543: ,p_dis_information11 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
544: ,p_dis_information12 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
545: ,p_dis_information13 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
546: ,p_dis_information14 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
547: ,p_dis_information15 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
548: ,p_dis_information16 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
549: ,p_dis_information17 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
550: ,p_dis_information18 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
551: ,p_dis_information19 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
559: ,p_dis_information27 in varchar2 default hr_api.g_varchar2
552: ,p_dis_information20 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
559: ,p_dis_information27 in varchar2 default hr_api.g_varchar2
560: ,p_dis_information28 in varchar2 default hr_api.g_varchar2
553: ,p_dis_information21 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
559: ,p_dis_information27 in varchar2 default hr_api.g_varchar2
560: ,p_dis_information28 in varchar2 default hr_api.g_varchar2
561: ,p_dis_information29 in varchar2 default hr_api.g_varchar2
554: ,p_dis_information22 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
559: ,p_dis_information27 in varchar2 default hr_api.g_varchar2
560: ,p_dis_information28 in varchar2 default hr_api.g_varchar2
561: ,p_dis_information29 in varchar2 default hr_api.g_varchar2
562: ,p_dis_information30 in varchar2 default hr_api.g_varchar2
555: ,p_dis_information23 in varchar2 default hr_api.g_varchar2
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
559: ,p_dis_information27 in varchar2 default hr_api.g_varchar2
560: ,p_dis_information28 in varchar2 default hr_api.g_varchar2
561: ,p_dis_information29 in varchar2 default hr_api.g_varchar2
562: ,p_dis_information30 in varchar2 default hr_api.g_varchar2
563: ,p_effective_start_date out nocopy date
556: ,p_dis_information24 in varchar2 default hr_api.g_varchar2
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
559: ,p_dis_information27 in varchar2 default hr_api.g_varchar2
560: ,p_dis_information28 in varchar2 default hr_api.g_varchar2
561: ,p_dis_information29 in varchar2 default hr_api.g_varchar2
562: ,p_dis_information30 in varchar2 default hr_api.g_varchar2
563: ,p_effective_start_date out nocopy date
564: ,p_effective_end_date out nocopy date
557: ,p_dis_information25 in varchar2 default hr_api.g_varchar2
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
559: ,p_dis_information27 in varchar2 default hr_api.g_varchar2
560: ,p_dis_information28 in varchar2 default hr_api.g_varchar2
561: ,p_dis_information29 in varchar2 default hr_api.g_varchar2
562: ,p_dis_information30 in varchar2 default hr_api.g_varchar2
563: ,p_effective_start_date out nocopy date
564: ,p_effective_end_date out nocopy date
565: ) is
558: ,p_dis_information26 in varchar2 default hr_api.g_varchar2
559: ,p_dis_information27 in varchar2 default hr_api.g_varchar2
560: ,p_dis_information28 in varchar2 default hr_api.g_varchar2
561: ,p_dis_information29 in varchar2 default hr_api.g_varchar2
562: ,p_dis_information30 in varchar2 default hr_api.g_varchar2
563: ,p_effective_start_date out nocopy date
564: ,p_effective_end_date out nocopy date
565: ) is
566: --
612: -- 2) link a new causal medical assessment to the disability, if supplied.
613: -- (if a disability_id has not yet been set for the medical assessment record)
614:
615: if (p_medical_assessment_id is null) or
616: ((p_medical_assessment_id is not null) and (p_medical_assessment_id <> hr_api.g_number)) then
617: --
618: -- always execute the cursor if not default value, to determine state of
619: -- any medical_assessment record for the disability
620: --
767: ,p_dis_information28 => p_dis_information28
768: ,p_dis_information29 => p_dis_information29
769: ,p_dis_information30 => p_dis_information30);
770: exception
771: when hr_api.cannot_find_prog_unit then
772: hr_api.cannot_find_prog_unit_error
773: (p_module_name => 'update_disability_b'
774: ,p_hook_type => 'BP'
775: );
768: ,p_dis_information29 => p_dis_information29
769: ,p_dis_information30 => p_dis_information30);
770: exception
771: when hr_api.cannot_find_prog_unit then
772: hr_api.cannot_find_prog_unit_error
773: (p_module_name => 'update_disability_b'
774: ,p_hook_type => 'BP'
775: );
776: end;
947: ,p_effective_start_date => l_effective_start_date
948: ,p_effective_end_date => l_effective_end_date
949: );
950: exception
951: when hr_api.cannot_find_prog_unit then
952: hr_api.cannot_find_prog_unit_error
953: (p_module_name => 'update_disability_a'
954: ,p_hook_type => 'AP'
955: );
948: ,p_effective_end_date => l_effective_end_date
949: );
950: exception
951: when hr_api.cannot_find_prog_unit then
952: hr_api.cannot_find_prog_unit_error
953: (p_module_name => 'update_disability_a'
954: ,p_hook_type => 'AP'
955: );
956: end;
958: --
959: -- When in validation only mode raise the Validate_Enabled exception
960: --
961: if p_validate then
962: raise hr_api.validate_enabled;
963: end if;
964: --
965: -- Set all output arguments
966: --
969: p_effective_end_date := l_effective_end_date;
970: --
971: hr_utility.set_location(' Leaving:'||l_proc, 70);
972: exception
973: when hr_api.validate_enabled then
974: --
975: -- As the Validate_Enabled exception has been raised
976: -- we must rollback to the savepoint
977: --
1061: ,p_object_version_number => l_object_version_number
1062: );
1063: --
1064: exception
1065: when hr_api.cannot_find_prog_unit then
1066: hr_api.cannot_find_prog_unit_error
1067: (p_module_name => 'delete_disability_b'
1068: ,p_hook_type => 'BP'
1069: );
1062: );
1063: --
1064: exception
1065: when hr_api.cannot_find_prog_unit then
1066: hr_api.cannot_find_prog_unit_error
1067: (p_module_name => 'delete_disability_b'
1068: ,p_hook_type => 'BP'
1069: );
1070: --
1118: ,p_effective_start_date => l_effective_start_date
1119: ,p_effective_end_date => l_effective_end_date
1120: );
1121: exception
1122: when hr_api.cannot_find_prog_unit then
1123: hr_api.cannot_find_prog_unit_error
1124: (p_module_name => 'delete_disability_a'
1125: ,p_hook_type => 'AP'
1126: );
1119: ,p_effective_end_date => l_effective_end_date
1120: );
1121: exception
1122: when hr_api.cannot_find_prog_unit then
1123: hr_api.cannot_find_prog_unit_error
1124: (p_module_name => 'delete_disability_a'
1125: ,p_hook_type => 'AP'
1126: );
1127: --
1135: --
1136: p_object_version_number := l_object_version_number;
1137: --
1138: if p_validate then
1139: raise hr_api.validate_enabled;
1140: end if;
1141: --
1142: -- Set all output arguments (returned by some dt modes only)
1143: --
1146: hr_utility.set_location(' Leaving:'||l_proc, 70);
1147: --
1148: exception
1149: --
1150: when hr_api.validate_enabled then
1151: --
1152: -- As the Validate_Enabled exception has been raised
1153: -- we must rollback to the savepoint
1154: --