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

APPS.PQH_CORPS_DEFINITIONS_API dependencies on HR_API

Line 223: when hr_api.cannot_find_prog_unit then

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'

Line 224: hr_api.cannot_find_prog_unit_error

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

Line 355: when hr_api.cannot_find_prog_unit then

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'

Line 356: hr_api.cannot_find_prog_unit_error

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

Line 372: raise hr_api.validate_enabled;

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

Line 384: when hr_api.validate_enabled then

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

Line 493: ,p_business_group_id in number default hr_api.g_number

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

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

Line 495: ,p_status_cd in varchar2 default hr_api.g_varchar2

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

Line 496: ,p_retirement_age in number default hr_api.g_number

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

Line 497: ,p_category_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

Line 498: ,p_starting_grade_step_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
502: ,p_date_to in date default hr_api.g_date

Line 499: ,p_type_of_ps 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
503: ,p_recruitment_end_date in date default hr_api.g_date

Line 500: ,p_corps_type_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
504: ,p_task_desc in varchar2 default hr_api.g_varchar2

Line 501: ,p_date_from in date default hr_api.g_date

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

Line 502: ,p_date_to in date default hr_api.g_date

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

Line 503: ,p_recruitment_end_date in date default hr_api.g_date

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

Line 504: ,p_task_desc 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

Line 505: ,p_secondment_threshold 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

Line 506: ,p_normal_hours in number default hr_api.g_number

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

Line 507: ,p_normal_hours_frequency 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

Line 508: ,p_minimum_hours in number default hr_api.g_number

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

Line 509: ,p_minimum_hours_frequency 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 530: ,p_attribute21 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

Line 531: ,p_attribute22 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

Line 532: ,p_attribute23 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

Line 533: ,p_attribute24 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

Line 534: ,p_attribute25 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

Line 535: ,p_attribute26 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

Line 536: ,p_attribute27 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

Line 537: ,p_attribute28 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

Line 538: ,p_attribute29 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
542: ,p_primary_prof_field_id in number default hr_api.g_number

Line 539: ,p_attribute30 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
543: ,p_starting_grade_id in number default hr_api.g_number

Line 540: ,p_attribute_category 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
544: ,p_ben_pgm_id in number default hr_api.g_number

Line 542: ,p_primary_prof_field_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

Line 543: ,p_starting_grade_id in number default hr_api.g_number

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

Line 544: ,p_ben_pgm_id in number default hr_api.g_number

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

Line 545: ,p_probation_period in number default hr_api.g_number

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

Line 546: ,p_probation_units in varchar2 default hr_api.g_varchar2

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

Line 630: when hr_api.cannot_find_prog_unit then

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'

Line 631: hr_api.cannot_find_prog_unit_error

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

Line 763: when hr_api.cannot_find_prog_unit then

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'

Line 764: hr_api.cannot_find_prog_unit_error

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

Line 780: raise hr_api.validate_enabled;

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

Line 791: when hr_api.validate_enabled then

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

Line 880: when hr_api.cannot_find_prog_unit then

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

Line 881: hr_api.cannot_find_prog_unit_error

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

Line 906: when hr_api.cannot_find_prog_unit then

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

Line 907: hr_api.cannot_find_prog_unit_error

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

Line 921: raise hr_api.validate_enabled;

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

Line 928: when hr_api.validate_enabled then

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