219: ,p_probation_period => p_probation_period
220: ,p_probation_units => p_probation_units
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (
226: p_module_name => 'create_corps_definition'
227: ,p_hook_type => 'BP'
220: ,p_probation_units => p_probation_units
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (
226: p_module_name => 'create_corps_definition'
227: ,p_hook_type => 'BP'
228: );
351: ,p_probation_period => p_probation_period
352: ,p_probation_units => p_probation_units
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (
358: p_module_name => 'create_corps_definition'
359: ,p_hook_type => 'AP'
352: ,p_probation_units => p_probation_units
353: );
354: exception
355: when hr_api.cannot_find_prog_unit then
356: hr_api.cannot_find_prog_unit_error
357: (
358: p_module_name => 'create_corps_definition'
359: ,p_hook_type => 'AP'
360: );
368: --
369: -- When in validation only mode raise the Validate_Enabled exception
370: --
371: if p_validate then
372: raise hr_api.validate_enabled;
373: end if;
374: --
375: -- Set all output arguments
376: --
380: hr_utility.set_location(' Leaving:'||l_proc, 70);
381: --
382: exception
383: --
384: when hr_api.validate_enabled then
385: --
386: -- As the Validate_Enabled exception has been raised
387: -- we must rollback to the savepoint
388: --
489: (
490: p_validate in boolean default false
491: ,p_effective_date in date
492: ,p_corps_definition_id in number
493: ,p_business_group_id in number default hr_api.g_number
494: ,p_name in varchar2 default hr_api.g_varchar2
495: ,p_status_cd in varchar2 default hr_api.g_varchar2
496: ,p_retirement_age in number default hr_api.g_number
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
490: p_validate in boolean default false
491: ,p_effective_date in date
492: ,p_corps_definition_id in number
493: ,p_business_group_id in number default hr_api.g_number
494: ,p_name in varchar2 default hr_api.g_varchar2
495: ,p_status_cd in varchar2 default hr_api.g_varchar2
496: ,p_retirement_age in number default hr_api.g_number
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
498: ,p_starting_grade_step_id in number default hr_api.g_number
491: ,p_effective_date in date
492: ,p_corps_definition_id in number
493: ,p_business_group_id in number default hr_api.g_number
494: ,p_name in varchar2 default hr_api.g_varchar2
495: ,p_status_cd in varchar2 default hr_api.g_varchar2
496: ,p_retirement_age in number default hr_api.g_number
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
498: ,p_starting_grade_step_id in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
492: ,p_corps_definition_id in number
493: ,p_business_group_id in number default hr_api.g_number
494: ,p_name in varchar2 default hr_api.g_varchar2
495: ,p_status_cd in varchar2 default hr_api.g_varchar2
496: ,p_retirement_age in number default hr_api.g_number
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
498: ,p_starting_grade_step_id in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
493: ,p_business_group_id in number default hr_api.g_number
494: ,p_name in varchar2 default hr_api.g_varchar2
495: ,p_status_cd in varchar2 default hr_api.g_varchar2
496: ,p_retirement_age in number default hr_api.g_number
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
498: ,p_starting_grade_step_id in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501: ,p_date_from in date default hr_api.g_date
494: ,p_name in varchar2 default hr_api.g_varchar2
495: ,p_status_cd in varchar2 default hr_api.g_varchar2
496: ,p_retirement_age in number default hr_api.g_number
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
498: ,p_starting_grade_step_id in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501: ,p_date_from in date default hr_api.g_date
502: ,p_date_to in date default hr_api.g_date
495: ,p_status_cd in varchar2 default hr_api.g_varchar2
496: ,p_retirement_age in number default hr_api.g_number
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
498: ,p_starting_grade_step_id in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501: ,p_date_from in date default hr_api.g_date
502: ,p_date_to in date default hr_api.g_date
503: ,p_recruitment_end_date in date default hr_api.g_date
496: ,p_retirement_age in number default hr_api.g_number
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
498: ,p_starting_grade_step_id in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501: ,p_date_from in date default hr_api.g_date
502: ,p_date_to in date default hr_api.g_date
503: ,p_recruitment_end_date in date default hr_api.g_date
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
497: ,p_category_cd in varchar2 default hr_api.g_varchar2
498: ,p_starting_grade_step_id in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501: ,p_date_from in date default hr_api.g_date
502: ,p_date_to in date default hr_api.g_date
503: ,p_recruitment_end_date in date default hr_api.g_date
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
498: ,p_starting_grade_step_id in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501: ,p_date_from in date default hr_api.g_date
502: ,p_date_to in date default hr_api.g_date
503: ,p_recruitment_end_date in date default hr_api.g_date
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
506: ,p_normal_hours in number default hr_api.g_number
499: ,p_type_of_ps in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501: ,p_date_from in date default hr_api.g_date
502: ,p_date_to in date default hr_api.g_date
503: ,p_recruitment_end_date in date default hr_api.g_date
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
506: ,p_normal_hours in number default hr_api.g_number
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
500: ,p_corps_type_cd in varchar2 default hr_api.g_varchar2
501: ,p_date_from in date default hr_api.g_date
502: ,p_date_to in date default hr_api.g_date
503: ,p_recruitment_end_date in date default hr_api.g_date
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
506: ,p_normal_hours in number default hr_api.g_number
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
501: ,p_date_from in date default hr_api.g_date
502: ,p_date_to in date default hr_api.g_date
503: ,p_recruitment_end_date in date default hr_api.g_date
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
506: ,p_normal_hours in number default hr_api.g_number
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
502: ,p_date_to in date default hr_api.g_date
503: ,p_recruitment_end_date in date default hr_api.g_date
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
506: ,p_normal_hours in number default hr_api.g_number
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
503: ,p_recruitment_end_date in date default hr_api.g_date
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
506: ,p_normal_hours in number default hr_api.g_number
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
504: ,p_task_desc in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
506: ,p_normal_hours in number default hr_api.g_number
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
505: ,p_secondment_threshold in number default hr_api.g_number
506: ,p_normal_hours in number default hr_api.g_number
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
506: ,p_normal_hours in number default hr_api.g_number
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
507: ,p_normal_hours_frequency in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
508: ,p_minimum_hours in number default hr_api.g_number
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
509: ,p_minimum_hours_frequency in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
510: ,p_attribute1 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
511: ,p_attribute2 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
512: ,p_attribute3 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
513: ,p_attribute4 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
514: ,p_attribute5 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
515: ,p_attribute6 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
516: ,p_attribute7 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
517: ,p_attribute8 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
518: ,p_attribute9 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
519: ,p_attribute10 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
520: ,p_attribute11 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
521: ,p_attribute12 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
522: ,p_attribute13 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
523: ,p_attribute14 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
524: ,p_attribute15 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
525: ,p_attribute16 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
526: ,p_attribute17 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
527: ,p_attribute18 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
528: ,p_attribute19 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
529: ,p_attribute20 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
537: ,p_attribute28 in varchar2 default hr_api.g_varchar2
530: ,p_attribute21 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
537: ,p_attribute28 in varchar2 default hr_api.g_varchar2
538: ,p_attribute29 in varchar2 default hr_api.g_varchar2
531: ,p_attribute22 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
537: ,p_attribute28 in varchar2 default hr_api.g_varchar2
538: ,p_attribute29 in varchar2 default hr_api.g_varchar2
539: ,p_attribute30 in varchar2 default hr_api.g_varchar2
532: ,p_attribute23 in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
537: ,p_attribute28 in varchar2 default hr_api.g_varchar2
538: ,p_attribute29 in varchar2 default hr_api.g_varchar2
539: ,p_attribute30 in varchar2 default hr_api.g_varchar2
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
533: ,p_attribute24 in varchar2 default hr_api.g_varchar2
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
537: ,p_attribute28 in varchar2 default hr_api.g_varchar2
538: ,p_attribute29 in varchar2 default hr_api.g_varchar2
539: ,p_attribute30 in varchar2 default hr_api.g_varchar2
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_object_version_number in out nocopy number
534: ,p_attribute25 in varchar2 default hr_api.g_varchar2
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
537: ,p_attribute28 in varchar2 default hr_api.g_varchar2
538: ,p_attribute29 in varchar2 default hr_api.g_varchar2
539: ,p_attribute30 in varchar2 default hr_api.g_varchar2
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_object_version_number in out nocopy number
542: ,p_primary_prof_field_id in number default hr_api.g_number
535: ,p_attribute26 in varchar2 default hr_api.g_varchar2
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
537: ,p_attribute28 in varchar2 default hr_api.g_varchar2
538: ,p_attribute29 in varchar2 default hr_api.g_varchar2
539: ,p_attribute30 in varchar2 default hr_api.g_varchar2
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_object_version_number in out nocopy number
542: ,p_primary_prof_field_id in number default hr_api.g_number
543: ,p_starting_grade_id in number default hr_api.g_number
536: ,p_attribute27 in varchar2 default hr_api.g_varchar2
537: ,p_attribute28 in varchar2 default hr_api.g_varchar2
538: ,p_attribute29 in varchar2 default hr_api.g_varchar2
539: ,p_attribute30 in varchar2 default hr_api.g_varchar2
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_object_version_number in out nocopy number
542: ,p_primary_prof_field_id in number default hr_api.g_number
543: ,p_starting_grade_id in number default hr_api.g_number
544: ,p_ben_pgm_id in number default hr_api.g_number
538: ,p_attribute29 in varchar2 default hr_api.g_varchar2
539: ,p_attribute30 in varchar2 default hr_api.g_varchar2
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_object_version_number in out nocopy number
542: ,p_primary_prof_field_id in number default hr_api.g_number
543: ,p_starting_grade_id in number default hr_api.g_number
544: ,p_ben_pgm_id in number default hr_api.g_number
545: ,p_probation_period in number default hr_api.g_number
546: ,p_probation_units in varchar2 default hr_api.g_varchar2
539: ,p_attribute30 in varchar2 default hr_api.g_varchar2
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_object_version_number in out nocopy number
542: ,p_primary_prof_field_id in number default hr_api.g_number
543: ,p_starting_grade_id in number default hr_api.g_number
544: ,p_ben_pgm_id in number default hr_api.g_number
545: ,p_probation_period in number default hr_api.g_number
546: ,p_probation_units in varchar2 default hr_api.g_varchar2
547: ) is
540: ,p_attribute_category in varchar2 default hr_api.g_varchar2
541: ,p_object_version_number in out nocopy number
542: ,p_primary_prof_field_id in number default hr_api.g_number
543: ,p_starting_grade_id in number default hr_api.g_number
544: ,p_ben_pgm_id in number default hr_api.g_number
545: ,p_probation_period in number default hr_api.g_number
546: ,p_probation_units in varchar2 default hr_api.g_varchar2
547: ) is
548: --
541: ,p_object_version_number in out nocopy number
542: ,p_primary_prof_field_id in number default hr_api.g_number
543: ,p_starting_grade_id in number default hr_api.g_number
544: ,p_ben_pgm_id in number default hr_api.g_number
545: ,p_probation_period in number default hr_api.g_number
546: ,p_probation_units in varchar2 default hr_api.g_varchar2
547: ) is
548: --
549: -- Declare cursors and local variables
542: ,p_primary_prof_field_id in number default hr_api.g_number
543: ,p_starting_grade_id in number default hr_api.g_number
544: ,p_ben_pgm_id in number default hr_api.g_number
545: ,p_probation_period in number default hr_api.g_number
546: ,p_probation_units in varchar2 default hr_api.g_varchar2
547: ) is
548: --
549: -- Declare cursors and local variables
550: --
626: ,p_probation_period => p_probation_period
627: ,p_probation_units => p_probation_units
628: );
629: exception
630: when hr_api.cannot_find_prog_unit then
631: hr_api.cannot_find_prog_unit_error
632: (
633: p_module_name => 'update_corps_definition'
634: ,p_hook_type => 'BP'
627: ,p_probation_units => p_probation_units
628: );
629: exception
630: when hr_api.cannot_find_prog_unit then
631: hr_api.cannot_find_prog_unit_error
632: (
633: p_module_name => 'update_corps_definition'
634: ,p_hook_type => 'BP'
635: );
759: ,p_probation_period => p_probation_period
760: ,p_probation_units => p_probation_units
761: );
762: exception
763: when hr_api.cannot_find_prog_unit then
764: hr_api.cannot_find_prog_unit_error
765: (
766: p_module_name => 'update_corps_definition'
767: ,p_hook_type => 'AP'
760: ,p_probation_units => p_probation_units
761: );
762: exception
763: when hr_api.cannot_find_prog_unit then
764: hr_api.cannot_find_prog_unit_error
765: (
766: p_module_name => 'update_corps_definition'
767: ,p_hook_type => 'AP'
768: );
776: --
777: -- When in validation only mode raise the Validate_Enabled exception
778: --
779: if p_validate then
780: raise hr_api.validate_enabled;
781: end if;
782: --
783: -- Set all output arguments
784: --
787: hr_utility.set_location(' Leaving:'||l_proc, 70);
788: --
789: exception
790: --
791: when hr_api.validate_enabled then
792: --
793: -- As the Validate_Enabled exception has been raised
794: -- we must rollback to the savepoint
795: --
876: p_corps_definition_id => p_corps_definition_id
877: ,p_object_version_number => p_object_version_number
878: );
879: exception
880: when hr_api.cannot_find_prog_unit then
881: hr_api.cannot_find_prog_unit_error
882: (p_module_name => 'delete_corps_definition'
883: ,p_hook_type => 'BP'
884: );
877: ,p_object_version_number => p_object_version_number
878: );
879: exception
880: when hr_api.cannot_find_prog_unit then
881: hr_api.cannot_find_prog_unit_error
882: (p_module_name => 'delete_corps_definition'
883: ,p_hook_type => 'BP'
884: );
885: --
902: p_corps_definition_id => p_corps_definition_id
903: ,p_object_version_number => l_object_version_number
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'delete_corps_definition'
909: ,p_hook_type => 'AP'
910: );
903: ,p_object_version_number => l_object_version_number
904: );
905: exception
906: when hr_api.cannot_find_prog_unit then
907: hr_api.cannot_find_prog_unit_error
908: (p_module_name => 'delete_corps_definition'
909: ,p_hook_type => 'AP'
910: );
911: --
917: --
918: -- When in validation only mode raise the Validate_Enabled exception
919: --
920: if p_validate then
921: raise hr_api.validate_enabled;
922: end if;
923: --
924: hr_utility.set_location(' Leaving:'||l_proc, 70);
925: --
924: hr_utility.set_location(' Leaving:'||l_proc, 70);
925: --
926: exception
927: --
928: when hr_api.validate_enabled then
929: --
930: -- As the Validate_Enabled exception has been raised
931: -- we must rollback to the savepoint
932: --