DBA Data[Home] [Help]

APPS.IRC_SEARCH_CRITERIA_API dependencies on HR_API

Line 223: when hr_api.cannot_find_prog_unit then

219: ,p_isc_information30 => p_isc_information30
220: ,p_date_posted => p_date_posted
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'CREATE_SAVED_SEARCH'
226: ,p_hook_type => 'BP'
227: );

Line 224: hr_api.cannot_find_prog_unit_error

220: ,p_date_posted => p_date_posted
221: );
222: exception
223: when hr_api.cannot_find_prog_unit then
224: hr_api.cannot_find_prog_unit_error
225: (p_module_name => 'CREATE_SAVED_SEARCH'
226: ,p_hook_type => 'BP'
227: );
228: end;

Line 428: when hr_api.cannot_find_prog_unit then

424: ,p_object_version_number => l_object_version_number
425: ,p_search_criteria_id => l_search_criteria_id
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'CREATE_SAVED_SEARCH'
431: ,p_hook_type => 'AP'
432: );

Line 429: hr_api.cannot_find_prog_unit_error

425: ,p_search_criteria_id => l_search_criteria_id
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'CREATE_SAVED_SEARCH'
431: ,p_hook_type => 'AP'
432: );
433: end;

Line 438: raise hr_api.validate_enabled;

434: --
435: -- When in validation only mode raise the Validate_Enabled exception
436: --
437: if p_validate then
438: raise hr_api.validate_enabled;
439: end if;
440: --
441: -- Set all output arguments
442: --

Line 448: when hr_api.validate_enabled then

444: p_object_version_number := l_object_version_number;
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 70);
447: exception
448: when hr_api.validate_enabled then
449: --
450: -- As the Validate_Enabled exception has been raised
451: -- we must rollback to the savepoint
452: --

Line 481: ,p_person_id in number default hr_api.g_number

477: procedure UPDATE_SAVED_SEARCH
478: (p_validate in boolean default false
479: ,p_effective_date in date
480: ,p_search_criteria_id in number
481: ,p_person_id in number default hr_api.g_number
482: ,p_search_name in varchar2 default hr_api.g_varchar2
483: ,p_location in varchar2 default hr_api.g_varchar2
484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485: ,p_geocode_location in varchar2 default hr_api.g_varchar2

Line 482: ,p_search_name in varchar2 default hr_api.g_varchar2

478: (p_validate in boolean default false
479: ,p_effective_date in date
480: ,p_search_criteria_id in number
481: ,p_person_id in number default hr_api.g_number
482: ,p_search_name in varchar2 default hr_api.g_varchar2
483: ,p_location in varchar2 default hr_api.g_varchar2
484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485: ,p_geocode_location in varchar2 default hr_api.g_varchar2
486: ,p_geocode_country in varchar2 default hr_api.g_varchar2

Line 483: ,p_location in varchar2 default hr_api.g_varchar2

479: ,p_effective_date in date
480: ,p_search_criteria_id in number
481: ,p_person_id in number default hr_api.g_number
482: ,p_search_name in varchar2 default hr_api.g_varchar2
483: ,p_location in varchar2 default hr_api.g_varchar2
484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485: ,p_geocode_location in varchar2 default hr_api.g_varchar2
486: ,p_geocode_country in varchar2 default hr_api.g_varchar2
487: ,p_derived_location in varchar2 default hr_api.g_varchar2

Line 484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2

480: ,p_search_criteria_id in number
481: ,p_person_id in number default hr_api.g_number
482: ,p_search_name in varchar2 default hr_api.g_varchar2
483: ,p_location in varchar2 default hr_api.g_varchar2
484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485: ,p_geocode_location in varchar2 default hr_api.g_varchar2
486: ,p_geocode_country in varchar2 default hr_api.g_varchar2
487: ,p_derived_location in varchar2 default hr_api.g_varchar2
488: ,p_location_id in number default hr_api.g_number

Line 485: ,p_geocode_location in varchar2 default hr_api.g_varchar2

481: ,p_person_id in number default hr_api.g_number
482: ,p_search_name in varchar2 default hr_api.g_varchar2
483: ,p_location in varchar2 default hr_api.g_varchar2
484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485: ,p_geocode_location in varchar2 default hr_api.g_varchar2
486: ,p_geocode_country in varchar2 default hr_api.g_varchar2
487: ,p_derived_location in varchar2 default hr_api.g_varchar2
488: ,p_location_id in number default hr_api.g_number
489: ,p_longitude in number default hr_api.g_number

Line 486: ,p_geocode_country in varchar2 default hr_api.g_varchar2

482: ,p_search_name in varchar2 default hr_api.g_varchar2
483: ,p_location in varchar2 default hr_api.g_varchar2
484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485: ,p_geocode_location in varchar2 default hr_api.g_varchar2
486: ,p_geocode_country in varchar2 default hr_api.g_varchar2
487: ,p_derived_location in varchar2 default hr_api.g_varchar2
488: ,p_location_id in number default hr_api.g_number
489: ,p_longitude in number default hr_api.g_number
490: ,p_latitude in number default hr_api.g_number

Line 487: ,p_derived_location in varchar2 default hr_api.g_varchar2

483: ,p_location in varchar2 default hr_api.g_varchar2
484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485: ,p_geocode_location in varchar2 default hr_api.g_varchar2
486: ,p_geocode_country in varchar2 default hr_api.g_varchar2
487: ,p_derived_location in varchar2 default hr_api.g_varchar2
488: ,p_location_id in number default hr_api.g_number
489: ,p_longitude in number default hr_api.g_number
490: ,p_latitude in number default hr_api.g_number
491: ,p_employee in varchar2 default hr_api.g_varchar2

Line 488: ,p_location_id in number default hr_api.g_number

484: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485: ,p_geocode_location in varchar2 default hr_api.g_varchar2
486: ,p_geocode_country in varchar2 default hr_api.g_varchar2
487: ,p_derived_location in varchar2 default hr_api.g_varchar2
488: ,p_location_id in number default hr_api.g_number
489: ,p_longitude in number default hr_api.g_number
490: ,p_latitude in number default hr_api.g_number
491: ,p_employee in varchar2 default hr_api.g_varchar2
492: ,p_contractor in varchar2 default hr_api.g_varchar2

Line 489: ,p_longitude in number default hr_api.g_number

485: ,p_geocode_location in varchar2 default hr_api.g_varchar2
486: ,p_geocode_country in varchar2 default hr_api.g_varchar2
487: ,p_derived_location in varchar2 default hr_api.g_varchar2
488: ,p_location_id in number default hr_api.g_number
489: ,p_longitude in number default hr_api.g_number
490: ,p_latitude in number default hr_api.g_number
491: ,p_employee in varchar2 default hr_api.g_varchar2
492: ,p_contractor in varchar2 default hr_api.g_varchar2
493: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 490: ,p_latitude in number default hr_api.g_number

486: ,p_geocode_country in varchar2 default hr_api.g_varchar2
487: ,p_derived_location in varchar2 default hr_api.g_varchar2
488: ,p_location_id in number default hr_api.g_number
489: ,p_longitude in number default hr_api.g_number
490: ,p_latitude in number default hr_api.g_number
491: ,p_employee in varchar2 default hr_api.g_varchar2
492: ,p_contractor in varchar2 default hr_api.g_varchar2
493: ,p_employment_category in varchar2 default hr_api.g_varchar2
494: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 491: ,p_employee in varchar2 default hr_api.g_varchar2

487: ,p_derived_location in varchar2 default hr_api.g_varchar2
488: ,p_location_id in number default hr_api.g_number
489: ,p_longitude in number default hr_api.g_number
490: ,p_latitude in number default hr_api.g_number
491: ,p_employee in varchar2 default hr_api.g_varchar2
492: ,p_contractor in varchar2 default hr_api.g_varchar2
493: ,p_employment_category in varchar2 default hr_api.g_varchar2
494: ,p_keywords in varchar2 default hr_api.g_varchar2
495: ,p_travel_percentage in number default hr_api.g_number

Line 492: ,p_contractor in varchar2 default hr_api.g_varchar2

488: ,p_location_id in number default hr_api.g_number
489: ,p_longitude in number default hr_api.g_number
490: ,p_latitude in number default hr_api.g_number
491: ,p_employee in varchar2 default hr_api.g_varchar2
492: ,p_contractor in varchar2 default hr_api.g_varchar2
493: ,p_employment_category in varchar2 default hr_api.g_varchar2
494: ,p_keywords in varchar2 default hr_api.g_varchar2
495: ,p_travel_percentage in number default hr_api.g_number
496: ,p_min_salary in number default hr_api.g_number

Line 493: ,p_employment_category in varchar2 default hr_api.g_varchar2

489: ,p_longitude in number default hr_api.g_number
490: ,p_latitude in number default hr_api.g_number
491: ,p_employee in varchar2 default hr_api.g_varchar2
492: ,p_contractor in varchar2 default hr_api.g_varchar2
493: ,p_employment_category in varchar2 default hr_api.g_varchar2
494: ,p_keywords in varchar2 default hr_api.g_varchar2
495: ,p_travel_percentage in number default hr_api.g_number
496: ,p_min_salary in number default hr_api.g_number
497: ,p_salary_currency in varchar2 default hr_api.g_varchar2

Line 494: ,p_keywords in varchar2 default hr_api.g_varchar2

490: ,p_latitude in number default hr_api.g_number
491: ,p_employee in varchar2 default hr_api.g_varchar2
492: ,p_contractor in varchar2 default hr_api.g_varchar2
493: ,p_employment_category in varchar2 default hr_api.g_varchar2
494: ,p_keywords in varchar2 default hr_api.g_varchar2
495: ,p_travel_percentage in number default hr_api.g_number
496: ,p_min_salary in number default hr_api.g_number
497: ,p_salary_currency in varchar2 default hr_api.g_varchar2
498: ,p_salary_period in varchar2 default hr_api.g_varchar2

Line 495: ,p_travel_percentage in number default hr_api.g_number

491: ,p_employee in varchar2 default hr_api.g_varchar2
492: ,p_contractor in varchar2 default hr_api.g_varchar2
493: ,p_employment_category in varchar2 default hr_api.g_varchar2
494: ,p_keywords in varchar2 default hr_api.g_varchar2
495: ,p_travel_percentage in number default hr_api.g_number
496: ,p_min_salary in number default hr_api.g_number
497: ,p_salary_currency in varchar2 default hr_api.g_varchar2
498: ,p_salary_period in varchar2 default hr_api.g_varchar2
499: ,p_match_competence in varchar2 default hr_api.g_varchar2

Line 496: ,p_min_salary in number default hr_api.g_number

492: ,p_contractor in varchar2 default hr_api.g_varchar2
493: ,p_employment_category in varchar2 default hr_api.g_varchar2
494: ,p_keywords in varchar2 default hr_api.g_varchar2
495: ,p_travel_percentage in number default hr_api.g_number
496: ,p_min_salary in number default hr_api.g_number
497: ,p_salary_currency in varchar2 default hr_api.g_varchar2
498: ,p_salary_period in varchar2 default hr_api.g_varchar2
499: ,p_match_competence in varchar2 default hr_api.g_varchar2
500: ,p_match_qualification in varchar2 default hr_api.g_varchar2

Line 497: ,p_salary_currency in varchar2 default hr_api.g_varchar2

493: ,p_employment_category in varchar2 default hr_api.g_varchar2
494: ,p_keywords in varchar2 default hr_api.g_varchar2
495: ,p_travel_percentage in number default hr_api.g_number
496: ,p_min_salary in number default hr_api.g_number
497: ,p_salary_currency in varchar2 default hr_api.g_varchar2
498: ,p_salary_period in varchar2 default hr_api.g_varchar2
499: ,p_match_competence in varchar2 default hr_api.g_varchar2
500: ,p_match_qualification in varchar2 default hr_api.g_varchar2
501: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 498: ,p_salary_period in varchar2 default hr_api.g_varchar2

494: ,p_keywords in varchar2 default hr_api.g_varchar2
495: ,p_travel_percentage in number default hr_api.g_number
496: ,p_min_salary in number default hr_api.g_number
497: ,p_salary_currency in varchar2 default hr_api.g_varchar2
498: ,p_salary_period in varchar2 default hr_api.g_varchar2
499: ,p_match_competence in varchar2 default hr_api.g_varchar2
500: ,p_match_qualification in varchar2 default hr_api.g_varchar2
501: ,p_work_at_home in varchar2 default hr_api.g_varchar2
502: ,p_job_title in varchar2 default hr_api.g_varchar2

Line 499: ,p_match_competence in varchar2 default hr_api.g_varchar2

495: ,p_travel_percentage in number default hr_api.g_number
496: ,p_min_salary in number default hr_api.g_number
497: ,p_salary_currency in varchar2 default hr_api.g_varchar2
498: ,p_salary_period in varchar2 default hr_api.g_varchar2
499: ,p_match_competence in varchar2 default hr_api.g_varchar2
500: ,p_match_qualification in varchar2 default hr_api.g_varchar2
501: ,p_work_at_home in varchar2 default hr_api.g_varchar2
502: ,p_job_title in varchar2 default hr_api.g_varchar2
503: ,p_department in varchar2 default hr_api.g_varchar2

Line 500: ,p_match_qualification in varchar2 default hr_api.g_varchar2

496: ,p_min_salary in number default hr_api.g_number
497: ,p_salary_currency in varchar2 default hr_api.g_varchar2
498: ,p_salary_period in varchar2 default hr_api.g_varchar2
499: ,p_match_competence in varchar2 default hr_api.g_varchar2
500: ,p_match_qualification in varchar2 default hr_api.g_varchar2
501: ,p_work_at_home in varchar2 default hr_api.g_varchar2
502: ,p_job_title in varchar2 default hr_api.g_varchar2
503: ,p_department in varchar2 default hr_api.g_varchar2
504: ,p_professional_area in varchar2 default hr_api.g_varchar2

Line 501: ,p_work_at_home in varchar2 default hr_api.g_varchar2

497: ,p_salary_currency in varchar2 default hr_api.g_varchar2
498: ,p_salary_period in varchar2 default hr_api.g_varchar2
499: ,p_match_competence in varchar2 default hr_api.g_varchar2
500: ,p_match_qualification in varchar2 default hr_api.g_varchar2
501: ,p_work_at_home in varchar2 default hr_api.g_varchar2
502: ,p_job_title in varchar2 default hr_api.g_varchar2
503: ,p_department in varchar2 default hr_api.g_varchar2
504: ,p_professional_area in varchar2 default hr_api.g_varchar2
505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2

Line 502: ,p_job_title in varchar2 default hr_api.g_varchar2

498: ,p_salary_period in varchar2 default hr_api.g_varchar2
499: ,p_match_competence in varchar2 default hr_api.g_varchar2
500: ,p_match_qualification in varchar2 default hr_api.g_varchar2
501: ,p_work_at_home in varchar2 default hr_api.g_varchar2
502: ,p_job_title in varchar2 default hr_api.g_varchar2
503: ,p_department in varchar2 default hr_api.g_varchar2
504: ,p_professional_area in varchar2 default hr_api.g_varchar2
505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506: ,p_description in varchar2 default hr_api.g_varchar2

Line 503: ,p_department in varchar2 default hr_api.g_varchar2

499: ,p_match_competence in varchar2 default hr_api.g_varchar2
500: ,p_match_qualification in varchar2 default hr_api.g_varchar2
501: ,p_work_at_home in varchar2 default hr_api.g_varchar2
502: ,p_job_title in varchar2 default hr_api.g_varchar2
503: ,p_department in varchar2 default hr_api.g_varchar2
504: ,p_professional_area in varchar2 default hr_api.g_varchar2
505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506: ,p_description in varchar2 default hr_api.g_varchar2
507: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 504: ,p_professional_area in varchar2 default hr_api.g_varchar2

500: ,p_match_qualification in varchar2 default hr_api.g_varchar2
501: ,p_work_at_home in varchar2 default hr_api.g_varchar2
502: ,p_job_title in varchar2 default hr_api.g_varchar2
503: ,p_department in varchar2 default hr_api.g_varchar2
504: ,p_professional_area in varchar2 default hr_api.g_varchar2
505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506: ,p_description in varchar2 default hr_api.g_varchar2
507: ,p_attribute_category in varchar2 default hr_api.g_varchar2
508: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2

501: ,p_work_at_home in varchar2 default hr_api.g_varchar2
502: ,p_job_title in varchar2 default hr_api.g_varchar2
503: ,p_department in varchar2 default hr_api.g_varchar2
504: ,p_professional_area in varchar2 default hr_api.g_varchar2
505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506: ,p_description in varchar2 default hr_api.g_varchar2
507: ,p_attribute_category in varchar2 default hr_api.g_varchar2
508: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 506: ,p_description in varchar2 default hr_api.g_varchar2

502: ,p_job_title in varchar2 default hr_api.g_varchar2
503: ,p_department in varchar2 default hr_api.g_varchar2
504: ,p_professional_area in varchar2 default hr_api.g_varchar2
505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506: ,p_description in varchar2 default hr_api.g_varchar2
507: ,p_attribute_category in varchar2 default hr_api.g_varchar2
508: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 507: ,p_attribute_category in varchar2 default hr_api.g_varchar2

503: ,p_department in varchar2 default hr_api.g_varchar2
504: ,p_professional_area in varchar2 default hr_api.g_varchar2
505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506: ,p_description in varchar2 default hr_api.g_varchar2
507: ,p_attribute_category in varchar2 default hr_api.g_varchar2
508: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 508: ,p_attribute1 in varchar2 default hr_api.g_varchar2

504: ,p_professional_area in varchar2 default hr_api.g_varchar2
505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506: ,p_description in varchar2 default hr_api.g_varchar2
507: ,p_attribute_category in varchar2 default hr_api.g_varchar2
508: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 509: ,p_attribute2 in varchar2 default hr_api.g_varchar2

505: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506: ,p_description in varchar2 default hr_api.g_varchar2
507: ,p_attribute_category in varchar2 default hr_api.g_varchar2
508: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 510: ,p_attribute3 in varchar2 default hr_api.g_varchar2

506: ,p_description in varchar2 default hr_api.g_varchar2
507: ,p_attribute_category in varchar2 default hr_api.g_varchar2
508: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_attribute6 in varchar2 default hr_api.g_varchar2
514: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 511: ,p_attribute4 in varchar2 default hr_api.g_varchar2

507: ,p_attribute_category in varchar2 default hr_api.g_varchar2
508: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_attribute6 in varchar2 default hr_api.g_varchar2
514: ,p_attribute7 in varchar2 default hr_api.g_varchar2
515: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 512: ,p_attribute5 in varchar2 default hr_api.g_varchar2

508: ,p_attribute1 in varchar2 default hr_api.g_varchar2
509: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_attribute6 in varchar2 default hr_api.g_varchar2
514: ,p_attribute7 in varchar2 default hr_api.g_varchar2
515: ,p_attribute8 in varchar2 default hr_api.g_varchar2
516: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 513: ,p_attribute6 in varchar2 default hr_api.g_varchar2

509: ,p_attribute2 in varchar2 default hr_api.g_varchar2
510: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_attribute6 in varchar2 default hr_api.g_varchar2
514: ,p_attribute7 in varchar2 default hr_api.g_varchar2
515: ,p_attribute8 in varchar2 default hr_api.g_varchar2
516: ,p_attribute9 in varchar2 default hr_api.g_varchar2
517: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 514: ,p_attribute7 in varchar2 default hr_api.g_varchar2

510: ,p_attribute3 in varchar2 default hr_api.g_varchar2
511: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_attribute6 in varchar2 default hr_api.g_varchar2
514: ,p_attribute7 in varchar2 default hr_api.g_varchar2
515: ,p_attribute8 in varchar2 default hr_api.g_varchar2
516: ,p_attribute9 in varchar2 default hr_api.g_varchar2
517: ,p_attribute10 in varchar2 default hr_api.g_varchar2
518: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 515: ,p_attribute8 in varchar2 default hr_api.g_varchar2

511: ,p_attribute4 in varchar2 default hr_api.g_varchar2
512: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_attribute6 in varchar2 default hr_api.g_varchar2
514: ,p_attribute7 in varchar2 default hr_api.g_varchar2
515: ,p_attribute8 in varchar2 default hr_api.g_varchar2
516: ,p_attribute9 in varchar2 default hr_api.g_varchar2
517: ,p_attribute10 in varchar2 default hr_api.g_varchar2
518: ,p_attribute11 in varchar2 default hr_api.g_varchar2
519: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 516: ,p_attribute9 in varchar2 default hr_api.g_varchar2

512: ,p_attribute5 in varchar2 default hr_api.g_varchar2
513: ,p_attribute6 in varchar2 default hr_api.g_varchar2
514: ,p_attribute7 in varchar2 default hr_api.g_varchar2
515: ,p_attribute8 in varchar2 default hr_api.g_varchar2
516: ,p_attribute9 in varchar2 default hr_api.g_varchar2
517: ,p_attribute10 in varchar2 default hr_api.g_varchar2
518: ,p_attribute11 in varchar2 default hr_api.g_varchar2
519: ,p_attribute12 in varchar2 default hr_api.g_varchar2
520: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 517: ,p_attribute10 in varchar2 default hr_api.g_varchar2

513: ,p_attribute6 in varchar2 default hr_api.g_varchar2
514: ,p_attribute7 in varchar2 default hr_api.g_varchar2
515: ,p_attribute8 in varchar2 default hr_api.g_varchar2
516: ,p_attribute9 in varchar2 default hr_api.g_varchar2
517: ,p_attribute10 in varchar2 default hr_api.g_varchar2
518: ,p_attribute11 in varchar2 default hr_api.g_varchar2
519: ,p_attribute12 in varchar2 default hr_api.g_varchar2
520: ,p_attribute13 in varchar2 default hr_api.g_varchar2
521: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 518: ,p_attribute11 in varchar2 default hr_api.g_varchar2

514: ,p_attribute7 in varchar2 default hr_api.g_varchar2
515: ,p_attribute8 in varchar2 default hr_api.g_varchar2
516: ,p_attribute9 in varchar2 default hr_api.g_varchar2
517: ,p_attribute10 in varchar2 default hr_api.g_varchar2
518: ,p_attribute11 in varchar2 default hr_api.g_varchar2
519: ,p_attribute12 in varchar2 default hr_api.g_varchar2
520: ,p_attribute13 in varchar2 default hr_api.g_varchar2
521: ,p_attribute14 in varchar2 default hr_api.g_varchar2
522: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 519: ,p_attribute12 in varchar2 default hr_api.g_varchar2

515: ,p_attribute8 in varchar2 default hr_api.g_varchar2
516: ,p_attribute9 in varchar2 default hr_api.g_varchar2
517: ,p_attribute10 in varchar2 default hr_api.g_varchar2
518: ,p_attribute11 in varchar2 default hr_api.g_varchar2
519: ,p_attribute12 in varchar2 default hr_api.g_varchar2
520: ,p_attribute13 in varchar2 default hr_api.g_varchar2
521: ,p_attribute14 in varchar2 default hr_api.g_varchar2
522: ,p_attribute15 in varchar2 default hr_api.g_varchar2
523: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 520: ,p_attribute13 in varchar2 default hr_api.g_varchar2

516: ,p_attribute9 in varchar2 default hr_api.g_varchar2
517: ,p_attribute10 in varchar2 default hr_api.g_varchar2
518: ,p_attribute11 in varchar2 default hr_api.g_varchar2
519: ,p_attribute12 in varchar2 default hr_api.g_varchar2
520: ,p_attribute13 in varchar2 default hr_api.g_varchar2
521: ,p_attribute14 in varchar2 default hr_api.g_varchar2
522: ,p_attribute15 in varchar2 default hr_api.g_varchar2
523: ,p_attribute16 in varchar2 default hr_api.g_varchar2
524: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 521: ,p_attribute14 in varchar2 default hr_api.g_varchar2

517: ,p_attribute10 in varchar2 default hr_api.g_varchar2
518: ,p_attribute11 in varchar2 default hr_api.g_varchar2
519: ,p_attribute12 in varchar2 default hr_api.g_varchar2
520: ,p_attribute13 in varchar2 default hr_api.g_varchar2
521: ,p_attribute14 in varchar2 default hr_api.g_varchar2
522: ,p_attribute15 in varchar2 default hr_api.g_varchar2
523: ,p_attribute16 in varchar2 default hr_api.g_varchar2
524: ,p_attribute17 in varchar2 default hr_api.g_varchar2
525: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 522: ,p_attribute15 in varchar2 default hr_api.g_varchar2

518: ,p_attribute11 in varchar2 default hr_api.g_varchar2
519: ,p_attribute12 in varchar2 default hr_api.g_varchar2
520: ,p_attribute13 in varchar2 default hr_api.g_varchar2
521: ,p_attribute14 in varchar2 default hr_api.g_varchar2
522: ,p_attribute15 in varchar2 default hr_api.g_varchar2
523: ,p_attribute16 in varchar2 default hr_api.g_varchar2
524: ,p_attribute17 in varchar2 default hr_api.g_varchar2
525: ,p_attribute18 in varchar2 default hr_api.g_varchar2
526: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 523: ,p_attribute16 in varchar2 default hr_api.g_varchar2

519: ,p_attribute12 in varchar2 default hr_api.g_varchar2
520: ,p_attribute13 in varchar2 default hr_api.g_varchar2
521: ,p_attribute14 in varchar2 default hr_api.g_varchar2
522: ,p_attribute15 in varchar2 default hr_api.g_varchar2
523: ,p_attribute16 in varchar2 default hr_api.g_varchar2
524: ,p_attribute17 in varchar2 default hr_api.g_varchar2
525: ,p_attribute18 in varchar2 default hr_api.g_varchar2
526: ,p_attribute19 in varchar2 default hr_api.g_varchar2
527: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 524: ,p_attribute17 in varchar2 default hr_api.g_varchar2

520: ,p_attribute13 in varchar2 default hr_api.g_varchar2
521: ,p_attribute14 in varchar2 default hr_api.g_varchar2
522: ,p_attribute15 in varchar2 default hr_api.g_varchar2
523: ,p_attribute16 in varchar2 default hr_api.g_varchar2
524: ,p_attribute17 in varchar2 default hr_api.g_varchar2
525: ,p_attribute18 in varchar2 default hr_api.g_varchar2
526: ,p_attribute19 in varchar2 default hr_api.g_varchar2
527: ,p_attribute20 in varchar2 default hr_api.g_varchar2
528: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 525: ,p_attribute18 in varchar2 default hr_api.g_varchar2

521: ,p_attribute14 in varchar2 default hr_api.g_varchar2
522: ,p_attribute15 in varchar2 default hr_api.g_varchar2
523: ,p_attribute16 in varchar2 default hr_api.g_varchar2
524: ,p_attribute17 in varchar2 default hr_api.g_varchar2
525: ,p_attribute18 in varchar2 default hr_api.g_varchar2
526: ,p_attribute19 in varchar2 default hr_api.g_varchar2
527: ,p_attribute20 in varchar2 default hr_api.g_varchar2
528: ,p_attribute21 in varchar2 default hr_api.g_varchar2
529: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 526: ,p_attribute19 in varchar2 default hr_api.g_varchar2

522: ,p_attribute15 in varchar2 default hr_api.g_varchar2
523: ,p_attribute16 in varchar2 default hr_api.g_varchar2
524: ,p_attribute17 in varchar2 default hr_api.g_varchar2
525: ,p_attribute18 in varchar2 default hr_api.g_varchar2
526: ,p_attribute19 in varchar2 default hr_api.g_varchar2
527: ,p_attribute20 in varchar2 default hr_api.g_varchar2
528: ,p_attribute21 in varchar2 default hr_api.g_varchar2
529: ,p_attribute22 in varchar2 default hr_api.g_varchar2
530: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 527: ,p_attribute20 in varchar2 default hr_api.g_varchar2

523: ,p_attribute16 in varchar2 default hr_api.g_varchar2
524: ,p_attribute17 in varchar2 default hr_api.g_varchar2
525: ,p_attribute18 in varchar2 default hr_api.g_varchar2
526: ,p_attribute19 in varchar2 default hr_api.g_varchar2
527: ,p_attribute20 in varchar2 default hr_api.g_varchar2
528: ,p_attribute21 in varchar2 default hr_api.g_varchar2
529: ,p_attribute22 in varchar2 default hr_api.g_varchar2
530: ,p_attribute23 in varchar2 default hr_api.g_varchar2
531: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 528: ,p_attribute21 in varchar2 default hr_api.g_varchar2

524: ,p_attribute17 in varchar2 default hr_api.g_varchar2
525: ,p_attribute18 in varchar2 default hr_api.g_varchar2
526: ,p_attribute19 in varchar2 default hr_api.g_varchar2
527: ,p_attribute20 in varchar2 default hr_api.g_varchar2
528: ,p_attribute21 in varchar2 default hr_api.g_varchar2
529: ,p_attribute22 in varchar2 default hr_api.g_varchar2
530: ,p_attribute23 in varchar2 default hr_api.g_varchar2
531: ,p_attribute24 in varchar2 default hr_api.g_varchar2
532: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 529: ,p_attribute22 in varchar2 default hr_api.g_varchar2

525: ,p_attribute18 in varchar2 default hr_api.g_varchar2
526: ,p_attribute19 in varchar2 default hr_api.g_varchar2
527: ,p_attribute20 in varchar2 default hr_api.g_varchar2
528: ,p_attribute21 in varchar2 default hr_api.g_varchar2
529: ,p_attribute22 in varchar2 default hr_api.g_varchar2
530: ,p_attribute23 in varchar2 default hr_api.g_varchar2
531: ,p_attribute24 in varchar2 default hr_api.g_varchar2
532: ,p_attribute25 in varchar2 default hr_api.g_varchar2
533: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 530: ,p_attribute23 in varchar2 default hr_api.g_varchar2

526: ,p_attribute19 in varchar2 default hr_api.g_varchar2
527: ,p_attribute20 in varchar2 default hr_api.g_varchar2
528: ,p_attribute21 in varchar2 default hr_api.g_varchar2
529: ,p_attribute22 in varchar2 default hr_api.g_varchar2
530: ,p_attribute23 in varchar2 default hr_api.g_varchar2
531: ,p_attribute24 in varchar2 default hr_api.g_varchar2
532: ,p_attribute25 in varchar2 default hr_api.g_varchar2
533: ,p_attribute26 in varchar2 default hr_api.g_varchar2
534: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 531: ,p_attribute24 in varchar2 default hr_api.g_varchar2

527: ,p_attribute20 in varchar2 default hr_api.g_varchar2
528: ,p_attribute21 in varchar2 default hr_api.g_varchar2
529: ,p_attribute22 in varchar2 default hr_api.g_varchar2
530: ,p_attribute23 in varchar2 default hr_api.g_varchar2
531: ,p_attribute24 in varchar2 default hr_api.g_varchar2
532: ,p_attribute25 in varchar2 default hr_api.g_varchar2
533: ,p_attribute26 in varchar2 default hr_api.g_varchar2
534: ,p_attribute27 in varchar2 default hr_api.g_varchar2
535: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 532: ,p_attribute25 in varchar2 default hr_api.g_varchar2

528: ,p_attribute21 in varchar2 default hr_api.g_varchar2
529: ,p_attribute22 in varchar2 default hr_api.g_varchar2
530: ,p_attribute23 in varchar2 default hr_api.g_varchar2
531: ,p_attribute24 in varchar2 default hr_api.g_varchar2
532: ,p_attribute25 in varchar2 default hr_api.g_varchar2
533: ,p_attribute26 in varchar2 default hr_api.g_varchar2
534: ,p_attribute27 in varchar2 default hr_api.g_varchar2
535: ,p_attribute28 in varchar2 default hr_api.g_varchar2
536: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 533: ,p_attribute26 in varchar2 default hr_api.g_varchar2

529: ,p_attribute22 in varchar2 default hr_api.g_varchar2
530: ,p_attribute23 in varchar2 default hr_api.g_varchar2
531: ,p_attribute24 in varchar2 default hr_api.g_varchar2
532: ,p_attribute25 in varchar2 default hr_api.g_varchar2
533: ,p_attribute26 in varchar2 default hr_api.g_varchar2
534: ,p_attribute27 in varchar2 default hr_api.g_varchar2
535: ,p_attribute28 in varchar2 default hr_api.g_varchar2
536: ,p_attribute29 in varchar2 default hr_api.g_varchar2
537: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 534: ,p_attribute27 in varchar2 default hr_api.g_varchar2

530: ,p_attribute23 in varchar2 default hr_api.g_varchar2
531: ,p_attribute24 in varchar2 default hr_api.g_varchar2
532: ,p_attribute25 in varchar2 default hr_api.g_varchar2
533: ,p_attribute26 in varchar2 default hr_api.g_varchar2
534: ,p_attribute27 in varchar2 default hr_api.g_varchar2
535: ,p_attribute28 in varchar2 default hr_api.g_varchar2
536: ,p_attribute29 in varchar2 default hr_api.g_varchar2
537: ,p_attribute30 in varchar2 default hr_api.g_varchar2
538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

Line 535: ,p_attribute28 in varchar2 default hr_api.g_varchar2

531: ,p_attribute24 in varchar2 default hr_api.g_varchar2
532: ,p_attribute25 in varchar2 default hr_api.g_varchar2
533: ,p_attribute26 in varchar2 default hr_api.g_varchar2
534: ,p_attribute27 in varchar2 default hr_api.g_varchar2
535: ,p_attribute28 in varchar2 default hr_api.g_varchar2
536: ,p_attribute29 in varchar2 default hr_api.g_varchar2
537: ,p_attribute30 in varchar2 default hr_api.g_varchar2
538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

Line 536: ,p_attribute29 in varchar2 default hr_api.g_varchar2

532: ,p_attribute25 in varchar2 default hr_api.g_varchar2
533: ,p_attribute26 in varchar2 default hr_api.g_varchar2
534: ,p_attribute27 in varchar2 default hr_api.g_varchar2
535: ,p_attribute28 in varchar2 default hr_api.g_varchar2
536: ,p_attribute29 in varchar2 default hr_api.g_varchar2
537: ,p_attribute30 in varchar2 default hr_api.g_varchar2
538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

Line 537: ,p_attribute30 in varchar2 default hr_api.g_varchar2

533: ,p_attribute26 in varchar2 default hr_api.g_varchar2
534: ,p_attribute27 in varchar2 default hr_api.g_varchar2
535: ,p_attribute28 in varchar2 default hr_api.g_varchar2
536: ,p_attribute29 in varchar2 default hr_api.g_varchar2
537: ,p_attribute30 in varchar2 default hr_api.g_varchar2
538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

Line 538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

534: ,p_attribute27 in varchar2 default hr_api.g_varchar2
535: ,p_attribute28 in varchar2 default hr_api.g_varchar2
536: ,p_attribute29 in varchar2 default hr_api.g_varchar2
537: ,p_attribute30 in varchar2 default hr_api.g_varchar2
538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

Line 539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

535: ,p_attribute28 in varchar2 default hr_api.g_varchar2
536: ,p_attribute29 in varchar2 default hr_api.g_varchar2
537: ,p_attribute30 in varchar2 default hr_api.g_varchar2
538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

Line 540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

536: ,p_attribute29 in varchar2 default hr_api.g_varchar2
537: ,p_attribute30 in varchar2 default hr_api.g_varchar2
538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

Line 541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

537: ,p_attribute30 in varchar2 default hr_api.g_varchar2
538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

Line 542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

538: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

Line 543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

539: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

Line 544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

540: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

Line 545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

541: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

Line 546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

542: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

Line 547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

543: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

Line 548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

544: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

Line 549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

545: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

Line 550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

546: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

Line 551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

547: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

Line 552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

548: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

Line 553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

549: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

Line 554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

550: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

Line 555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

551: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

Line 556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

552: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

Line 557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

553: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

Line 558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

554: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

Line 559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

555: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

Line 560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

556: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

Line 561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

557: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

Line 562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

558: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

Line 563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

559: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
567: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

Line 564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

560: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
567: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
568: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

Line 565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

561: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
567: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
568: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
569: ,p_date_posted in varchar2 default hr_api.g_varchar2

Line 566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

562: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
567: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
568: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
569: ,p_date_posted in varchar2 default hr_api.g_varchar2
570: ,p_object_version_number in out nocopy number

Line 567: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

563: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
567: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
568: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
569: ,p_date_posted in varchar2 default hr_api.g_varchar2
570: ,p_object_version_number in out nocopy number
571: ) is

Line 568: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

564: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
567: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
568: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
569: ,p_date_posted in varchar2 default hr_api.g_varchar2
570: ,p_object_version_number in out nocopy number
571: ) is
572: --

Line 569: ,p_date_posted in varchar2 default hr_api.g_varchar2

565: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
567: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
568: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
569: ,p_date_posted in varchar2 default hr_api.g_varchar2
570: ,p_object_version_number in out nocopy number
571: ) is
572: --
573: -- Declare cursors and local variables

Line 690: when hr_api.cannot_find_prog_unit then

686: ,p_date_posted => p_date_posted
687: ,p_object_version_number => l_object_version_number
688: );
689: exception
690: when hr_api.cannot_find_prog_unit then
691: hr_api.cannot_find_prog_unit_error
692: (p_module_name => 'UPDATE_SAVED_SEARCH'
693: ,p_hook_type => 'BP'
694: );

Line 691: hr_api.cannot_find_prog_unit_error

687: ,p_object_version_number => l_object_version_number
688: );
689: exception
690: when hr_api.cannot_find_prog_unit then
691: hr_api.cannot_find_prog_unit_error
692: (p_module_name => 'UPDATE_SAVED_SEARCH'
693: ,p_hook_type => 'BP'
694: );
695: end;

Line 895: when hr_api.cannot_find_prog_unit then

891: ,p_date_posted => p_date_posted
892: ,p_object_version_number => l_object_version_number
893: );
894: exception
895: when hr_api.cannot_find_prog_unit then
896: hr_api.cannot_find_prog_unit_error
897: (p_module_name => 'UPDATE_SAVED_SEARCH'
898: ,p_hook_type => 'AP'
899: );

Line 896: hr_api.cannot_find_prog_unit_error

892: ,p_object_version_number => l_object_version_number
893: );
894: exception
895: when hr_api.cannot_find_prog_unit then
896: hr_api.cannot_find_prog_unit_error
897: (p_module_name => 'UPDATE_SAVED_SEARCH'
898: ,p_hook_type => 'AP'
899: );
900: end;

Line 905: raise hr_api.validate_enabled;

901: --
902: -- When in validation only mode raise the Validate_Enabled exception
903: --
904: if p_validate then
905: raise hr_api.validate_enabled;
906: end if;
907: --
908: -- Set all output arguments
909: --

Line 914: when hr_api.validate_enabled then

910: p_object_version_number := l_object_version_number;
911: --
912: hr_utility.set_location(' Leaving:'||l_proc, 70);
913: exception
914: when hr_api.validate_enabled then
915: --
916: -- As the Validate_Enabled exception has been raised
917: -- we must rollback to the savepoint
918: --

Line 975: when hr_api.cannot_find_prog_unit then

971: (p_search_criteria_id => p_search_criteria_id
972: ,p_object_version_number => p_object_version_number
973: );
974: exception
975: when hr_api.cannot_find_prog_unit then
976: hr_api.cannot_find_prog_unit_error
977: (p_module_name => 'DELETE_SAVED_SEARCH'
978: ,p_hook_type => 'BP'
979: );

Line 976: hr_api.cannot_find_prog_unit_error

972: ,p_object_version_number => p_object_version_number
973: );
974: exception
975: when hr_api.cannot_find_prog_unit then
976: hr_api.cannot_find_prog_unit_error
977: (p_module_name => 'DELETE_SAVED_SEARCH'
978: ,p_hook_type => 'BP'
979: );
980: end;

Line 999: when hr_api.cannot_find_prog_unit then

995: (p_search_criteria_id => p_search_criteria_id
996: ,p_object_version_number => p_object_version_number
997: );
998: exception
999: when hr_api.cannot_find_prog_unit then
1000: hr_api.cannot_find_prog_unit_error
1001: (p_module_name => 'DELETE_SAVED_SEARCH'
1002: ,p_hook_type => 'AP'
1003: );

Line 1000: hr_api.cannot_find_prog_unit_error

996: ,p_object_version_number => p_object_version_number
997: );
998: exception
999: when hr_api.cannot_find_prog_unit then
1000: hr_api.cannot_find_prog_unit_error
1001: (p_module_name => 'DELETE_SAVED_SEARCH'
1002: ,p_hook_type => 'AP'
1003: );
1004: end;

Line 1009: raise hr_api.validate_enabled;

1005: --
1006: -- When in validation only mode raise the Validate_Enabled exception
1007: --
1008: if p_validate then
1009: raise hr_api.validate_enabled;
1010: end if;
1011: --
1012: -- Set all output arguments
1013: --

Line 1017: when hr_api.validate_enabled then

1013: --
1014: --
1015: hr_utility.set_location(' Leaving:'||l_proc, 70);
1016: exception
1017: when hr_api.validate_enabled then
1018: --
1019: -- As the Validate_Enabled exception has been raised
1020: -- we must rollback to the savepoint
1021: --

Line 1230: when hr_api.cannot_find_prog_unit then

1226: ,p_isc_information29 => p_isc_information29
1227: ,p_isc_information30 => p_isc_information30
1228: );
1229: exception
1230: when hr_api.cannot_find_prog_unit then
1231: hr_api.cannot_find_prog_unit_error
1232: (p_module_name => 'CREATE_VACANCY_CRITERIA'
1233: ,p_hook_type => 'BP'
1234: );

Line 1231: hr_api.cannot_find_prog_unit_error

1227: ,p_isc_information30 => p_isc_information30
1228: );
1229: exception
1230: when hr_api.cannot_find_prog_unit then
1231: hr_api.cannot_find_prog_unit_error
1232: (p_module_name => 'CREATE_VACANCY_CRITERIA'
1233: ,p_hook_type => 'BP'
1234: );
1235: end;

Line 1413: when hr_api.cannot_find_prog_unit then

1409: ,p_object_version_number => l_object_version_number
1410: ,p_search_criteria_id => l_search_criteria_id
1411: );
1412: exception
1413: when hr_api.cannot_find_prog_unit then
1414: hr_api.cannot_find_prog_unit_error
1415: (p_module_name => 'CREATE_VACANCY_CRITERIA'
1416: ,p_hook_type => 'AP'
1417: );

Line 1414: hr_api.cannot_find_prog_unit_error

1410: ,p_search_criteria_id => l_search_criteria_id
1411: );
1412: exception
1413: when hr_api.cannot_find_prog_unit then
1414: hr_api.cannot_find_prog_unit_error
1415: (p_module_name => 'CREATE_VACANCY_CRITERIA'
1416: ,p_hook_type => 'AP'
1417: );
1418: end;

Line 1423: raise hr_api.validate_enabled;

1419: --
1420: -- When in validation only mode raise the Validate_Enabled exception
1421: --
1422: if p_validate then
1423: raise hr_api.validate_enabled;
1424: end if;
1425: --
1426: -- Set all output arguments
1427: --

Line 1433: when hr_api.validate_enabled then

1429: p_object_version_number := l_object_version_number;
1430: --
1431: hr_utility.set_location(' Leaving:'||l_proc, 70);
1432: exception
1433: when hr_api.validate_enabled then
1434: --
1435: -- As the Validate_Enabled exception has been raised
1436: -- we must rollback to the savepoint
1437: --

Line 1465: ,p_vacancy_id in number default hr_api.g_number

1461: --
1462: procedure UPDATE_VACANCY_CRITERIA
1463: (p_validate in boolean default false
1464: ,p_search_criteria_id in number
1465: ,p_vacancy_id in number default hr_api.g_number
1466: ,p_effective_date in date
1467: ,p_location in varchar2 default hr_api.g_varchar2
1468: ,p_employee in varchar2 default hr_api.g_varchar2
1469: ,p_contractor in varchar2 default hr_api.g_varchar2

Line 1467: ,p_location in varchar2 default hr_api.g_varchar2

1463: (p_validate in boolean default false
1464: ,p_search_criteria_id in number
1465: ,p_vacancy_id in number default hr_api.g_number
1466: ,p_effective_date in date
1467: ,p_location in varchar2 default hr_api.g_varchar2
1468: ,p_employee in varchar2 default hr_api.g_varchar2
1469: ,p_contractor in varchar2 default hr_api.g_varchar2
1470: ,p_employment_category in varchar2 default hr_api.g_varchar2
1471: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 1468: ,p_employee in varchar2 default hr_api.g_varchar2

1464: ,p_search_criteria_id in number
1465: ,p_vacancy_id in number default hr_api.g_number
1466: ,p_effective_date in date
1467: ,p_location in varchar2 default hr_api.g_varchar2
1468: ,p_employee in varchar2 default hr_api.g_varchar2
1469: ,p_contractor in varchar2 default hr_api.g_varchar2
1470: ,p_employment_category in varchar2 default hr_api.g_varchar2
1471: ,p_keywords in varchar2 default hr_api.g_varchar2
1472: ,p_travel_percentage in number default hr_api.g_number

Line 1469: ,p_contractor in varchar2 default hr_api.g_varchar2

1465: ,p_vacancy_id in number default hr_api.g_number
1466: ,p_effective_date in date
1467: ,p_location in varchar2 default hr_api.g_varchar2
1468: ,p_employee in varchar2 default hr_api.g_varchar2
1469: ,p_contractor in varchar2 default hr_api.g_varchar2
1470: ,p_employment_category in varchar2 default hr_api.g_varchar2
1471: ,p_keywords in varchar2 default hr_api.g_varchar2
1472: ,p_travel_percentage in number default hr_api.g_number
1473: ,p_min_salary in number default hr_api.g_number

Line 1470: ,p_employment_category in varchar2 default hr_api.g_varchar2

1466: ,p_effective_date in date
1467: ,p_location in varchar2 default hr_api.g_varchar2
1468: ,p_employee in varchar2 default hr_api.g_varchar2
1469: ,p_contractor in varchar2 default hr_api.g_varchar2
1470: ,p_employment_category in varchar2 default hr_api.g_varchar2
1471: ,p_keywords in varchar2 default hr_api.g_varchar2
1472: ,p_travel_percentage in number default hr_api.g_number
1473: ,p_min_salary in number default hr_api.g_number
1474: ,p_max_salary in number default hr_api.g_number

Line 1471: ,p_keywords in varchar2 default hr_api.g_varchar2

1467: ,p_location in varchar2 default hr_api.g_varchar2
1468: ,p_employee in varchar2 default hr_api.g_varchar2
1469: ,p_contractor in varchar2 default hr_api.g_varchar2
1470: ,p_employment_category in varchar2 default hr_api.g_varchar2
1471: ,p_keywords in varchar2 default hr_api.g_varchar2
1472: ,p_travel_percentage in number default hr_api.g_number
1473: ,p_min_salary in number default hr_api.g_number
1474: ,p_max_salary in number default hr_api.g_number
1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2

Line 1472: ,p_travel_percentage in number default hr_api.g_number

1468: ,p_employee in varchar2 default hr_api.g_varchar2
1469: ,p_contractor in varchar2 default hr_api.g_varchar2
1470: ,p_employment_category in varchar2 default hr_api.g_varchar2
1471: ,p_keywords in varchar2 default hr_api.g_varchar2
1472: ,p_travel_percentage in number default hr_api.g_number
1473: ,p_min_salary in number default hr_api.g_number
1474: ,p_max_salary in number default hr_api.g_number
1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476: ,p_salary_period in varchar2 default hr_api.g_varchar2

Line 1473: ,p_min_salary in number default hr_api.g_number

1469: ,p_contractor in varchar2 default hr_api.g_varchar2
1470: ,p_employment_category in varchar2 default hr_api.g_varchar2
1471: ,p_keywords in varchar2 default hr_api.g_varchar2
1472: ,p_travel_percentage in number default hr_api.g_number
1473: ,p_min_salary in number default hr_api.g_number
1474: ,p_max_salary in number default hr_api.g_number
1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476: ,p_salary_period in varchar2 default hr_api.g_varchar2
1477: ,p_professional_area in varchar2 default hr_api.g_varchar2

Line 1474: ,p_max_salary in number default hr_api.g_number

1470: ,p_employment_category in varchar2 default hr_api.g_varchar2
1471: ,p_keywords in varchar2 default hr_api.g_varchar2
1472: ,p_travel_percentage in number default hr_api.g_number
1473: ,p_min_salary in number default hr_api.g_number
1474: ,p_max_salary in number default hr_api.g_number
1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476: ,p_salary_period in varchar2 default hr_api.g_varchar2
1477: ,p_professional_area in varchar2 default hr_api.g_varchar2
1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2

1471: ,p_keywords in varchar2 default hr_api.g_varchar2
1472: ,p_travel_percentage in number default hr_api.g_number
1473: ,p_min_salary in number default hr_api.g_number
1474: ,p_max_salary in number default hr_api.g_number
1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476: ,p_salary_period in varchar2 default hr_api.g_varchar2
1477: ,p_professional_area in varchar2 default hr_api.g_varchar2
1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479: ,p_min_qual_level in number default hr_api.g_number

Line 1476: ,p_salary_period in varchar2 default hr_api.g_varchar2

1472: ,p_travel_percentage in number default hr_api.g_number
1473: ,p_min_salary in number default hr_api.g_number
1474: ,p_max_salary in number default hr_api.g_number
1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476: ,p_salary_period in varchar2 default hr_api.g_varchar2
1477: ,p_professional_area in varchar2 default hr_api.g_varchar2
1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479: ,p_min_qual_level in number default hr_api.g_number
1480: ,p_max_qual_level in number default hr_api.g_number

Line 1477: ,p_professional_area in varchar2 default hr_api.g_varchar2

1473: ,p_min_salary in number default hr_api.g_number
1474: ,p_max_salary in number default hr_api.g_number
1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476: ,p_salary_period in varchar2 default hr_api.g_varchar2
1477: ,p_professional_area in varchar2 default hr_api.g_varchar2
1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479: ,p_min_qual_level in number default hr_api.g_number
1480: ,p_max_qual_level in number default hr_api.g_number
1481: ,p_description in varchar2 default hr_api.g_varchar2

Line 1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1474: ,p_max_salary in number default hr_api.g_number
1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476: ,p_salary_period in varchar2 default hr_api.g_varchar2
1477: ,p_professional_area in varchar2 default hr_api.g_varchar2
1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479: ,p_min_qual_level in number default hr_api.g_number
1480: ,p_max_qual_level in number default hr_api.g_number
1481: ,p_description in varchar2 default hr_api.g_varchar2
1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1479: ,p_min_qual_level in number default hr_api.g_number

1475: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476: ,p_salary_period in varchar2 default hr_api.g_varchar2
1477: ,p_professional_area in varchar2 default hr_api.g_varchar2
1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479: ,p_min_qual_level in number default hr_api.g_number
1480: ,p_max_qual_level in number default hr_api.g_number
1481: ,p_description in varchar2 default hr_api.g_varchar2
1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1480: ,p_max_qual_level in number default hr_api.g_number

1476: ,p_salary_period in varchar2 default hr_api.g_varchar2
1477: ,p_professional_area in varchar2 default hr_api.g_varchar2
1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479: ,p_min_qual_level in number default hr_api.g_number
1480: ,p_max_qual_level in number default hr_api.g_number
1481: ,p_description in varchar2 default hr_api.g_varchar2
1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1481: ,p_description in varchar2 default hr_api.g_varchar2

1477: ,p_professional_area in varchar2 default hr_api.g_varchar2
1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479: ,p_min_qual_level in number default hr_api.g_number
1480: ,p_max_qual_level in number default hr_api.g_number
1481: ,p_description in varchar2 default hr_api.g_varchar2
1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1478: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479: ,p_min_qual_level in number default hr_api.g_number
1480: ,p_max_qual_level in number default hr_api.g_number
1481: ,p_description in varchar2 default hr_api.g_varchar2
1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1479: ,p_min_qual_level in number default hr_api.g_number
1480: ,p_max_qual_level in number default hr_api.g_number
1481: ,p_description in varchar2 default hr_api.g_varchar2
1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1480: ,p_max_qual_level in number default hr_api.g_number
1481: ,p_description in varchar2 default hr_api.g_varchar2
1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1481: ,p_description in varchar2 default hr_api.g_varchar2
1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1482: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1483: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1484: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1485: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1486: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1487: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1488: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1489: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1490: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1491: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1492: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1493: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1494: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1495: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1496: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1497: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1498: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1499: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1500: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1501: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1502: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1503: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1504: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1505: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

Line 1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1506: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

Line 1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1507: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

Line 1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1508: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

Line 1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

1509: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

Line 1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

1510: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

Line 1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

1511: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

Line 1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

1512: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

Line 1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

1513: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

Line 1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

1514: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

Line 1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

1515: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

Line 1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

1516: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

Line 1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

1517: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

Line 1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

1518: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

Line 1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

1519: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

Line 1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

1520: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

Line 1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

1521: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

Line 1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

1522: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

Line 1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

1523: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

Line 1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

1524: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

Line 1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

1525: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

Line 1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

1526: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

Line 1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

1527: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

Line 1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

1528: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

Line 1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

1529: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

Line 1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

1530: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

Line 1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

1531: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

Line 1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

1532: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

Line 1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

1533: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1541: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

Line 1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

1534: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1541: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1542: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

Line 1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

1535: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1541: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1542: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1543: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

Line 1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

1536: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1541: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1542: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1543: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1544: ,p_object_version_number in out nocopy number

Line 1541: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

1537: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1541: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1542: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1543: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1544: ,p_object_version_number in out nocopy number
1545: ) is

Line 1542: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

1538: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1541: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1542: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1543: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1544: ,p_object_version_number in out nocopy number
1545: ) is
1546: --

Line 1543: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

1539: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1541: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1542: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1543: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1544: ,p_object_version_number in out nocopy number
1545: ) is
1546: --
1547: -- Declare cursors and local variables

Line 1653: when hr_api.cannot_find_prog_unit then

1649: ,p_isc_information30 => p_isc_information30
1650: ,p_object_version_number => l_object_version_number
1651: );
1652: exception
1653: when hr_api.cannot_find_prog_unit then
1654: hr_api.cannot_find_prog_unit_error
1655: (p_module_name => 'UPDATE_VACANCY_CRITERIA'
1656: ,p_hook_type => 'BP'
1657: );

Line 1654: hr_api.cannot_find_prog_unit_error

1650: ,p_object_version_number => l_object_version_number
1651: );
1652: exception
1653: when hr_api.cannot_find_prog_unit then
1654: hr_api.cannot_find_prog_unit_error
1655: (p_module_name => 'UPDATE_VACANCY_CRITERIA'
1656: ,p_hook_type => 'BP'
1657: );
1658: end;

Line 1836: when hr_api.cannot_find_prog_unit then

1832: ,p_isc_information30 => p_isc_information30
1833: ,p_object_version_number => l_object_version_number
1834: );
1835: exception
1836: when hr_api.cannot_find_prog_unit then
1837: hr_api.cannot_find_prog_unit_error
1838: (p_module_name => 'UPDATE_VACANCY_CRITERIA'
1839: ,p_hook_type => 'AP'
1840: );

Line 1837: hr_api.cannot_find_prog_unit_error

1833: ,p_object_version_number => l_object_version_number
1834: );
1835: exception
1836: when hr_api.cannot_find_prog_unit then
1837: hr_api.cannot_find_prog_unit_error
1838: (p_module_name => 'UPDATE_VACANCY_CRITERIA'
1839: ,p_hook_type => 'AP'
1840: );
1841: end;

Line 1846: raise hr_api.validate_enabled;

1842: --
1843: -- When in validation only mode raise the Validate_Enabled exception
1844: --
1845: if p_validate then
1846: raise hr_api.validate_enabled;
1847: end if;
1848: --
1849: -- Set all output arguments
1850: --

Line 1855: when hr_api.validate_enabled then

1851: p_object_version_number := l_object_version_number;
1852: --
1853: hr_utility.set_location(' Leaving:'||l_proc, 70);
1854: exception
1855: when hr_api.validate_enabled then
1856: --
1857: -- As the Validate_Enabled exception has been raised
1858: -- we must rollback to the savepoint
1859: --

Line 1916: when hr_api.cannot_find_prog_unit then

1912: (p_search_criteria_id => p_search_criteria_id
1913: ,p_object_version_number => p_object_version_number
1914: );
1915: exception
1916: when hr_api.cannot_find_prog_unit then
1917: hr_api.cannot_find_prog_unit_error
1918: (p_module_name => 'DELETE_VACANCY_CRITERIA'
1919: ,p_hook_type => 'BP'
1920: );

Line 1917: hr_api.cannot_find_prog_unit_error

1913: ,p_object_version_number => p_object_version_number
1914: );
1915: exception
1916: when hr_api.cannot_find_prog_unit then
1917: hr_api.cannot_find_prog_unit_error
1918: (p_module_name => 'DELETE_VACANCY_CRITERIA'
1919: ,p_hook_type => 'BP'
1920: );
1921: end;

Line 1940: when hr_api.cannot_find_prog_unit then

1936: (p_search_criteria_id => p_search_criteria_id
1937: ,p_object_version_number => p_object_version_number
1938: );
1939: exception
1940: when hr_api.cannot_find_prog_unit then
1941: hr_api.cannot_find_prog_unit_error
1942: (p_module_name => 'DELETE_VACANCY_CRITERIA'
1943: ,p_hook_type => 'AP'
1944: );

Line 1941: hr_api.cannot_find_prog_unit_error

1937: ,p_object_version_number => p_object_version_number
1938: );
1939: exception
1940: when hr_api.cannot_find_prog_unit then
1941: hr_api.cannot_find_prog_unit_error
1942: (p_module_name => 'DELETE_VACANCY_CRITERIA'
1943: ,p_hook_type => 'AP'
1944: );
1945: end;

Line 1950: raise hr_api.validate_enabled;

1946: --
1947: -- When in validation only mode raise the Validate_Enabled exception
1948: --
1949: if p_validate then
1950: raise hr_api.validate_enabled;
1951: end if;
1952: --
1953: -- Set all output arguments
1954: --

Line 1958: when hr_api.validate_enabled then

1954: --
1955: --
1956: hr_utility.set_location(' Leaving:'||l_proc, 70);
1957: exception
1958: when hr_api.validate_enabled then
1959: --
1960: -- As the Validate_Enabled exception has been raised
1961: -- we must rollback to the savepoint
1962: --

Line 2189: when hr_api.cannot_find_prog_unit then

2185: ,p_isc_information29 => p_isc_information29
2186: ,p_isc_information30 => p_isc_information30
2187: );
2188: exception
2189: when hr_api.cannot_find_prog_unit then
2190: hr_api.cannot_find_prog_unit_error
2191: (p_module_name => 'CREATE_WORK_CHOICES'
2192: ,p_hook_type => 'BP'
2193: );

Line 2190: hr_api.cannot_find_prog_unit_error

2186: ,p_isc_information30 => p_isc_information30
2187: );
2188: exception
2189: when hr_api.cannot_find_prog_unit then
2190: hr_api.cannot_find_prog_unit_error
2191: (p_module_name => 'CREATE_WORK_CHOICES'
2192: ,p_hook_type => 'BP'
2193: );
2194: end;

Line 2389: when hr_api.cannot_find_prog_unit then

2385: ,p_object_version_number => l_object_version_number
2386: ,p_search_criteria_id => l_search_criteria_id
2387: );
2388: exception
2389: when hr_api.cannot_find_prog_unit then
2390: hr_api.cannot_find_prog_unit_error
2391: (p_module_name => 'CREATE_WORK_CHOICES'
2392: ,p_hook_type => 'AP'
2393: );

Line 2390: hr_api.cannot_find_prog_unit_error

2386: ,p_search_criteria_id => l_search_criteria_id
2387: );
2388: exception
2389: when hr_api.cannot_find_prog_unit then
2390: hr_api.cannot_find_prog_unit_error
2391: (p_module_name => 'CREATE_WORK_CHOICES'
2392: ,p_hook_type => 'AP'
2393: );
2394: end;

Line 2399: raise hr_api.validate_enabled;

2395: --
2396: -- When in validation only mode raise the Validate_Enabled exception
2397: --
2398: if p_validate then
2399: raise hr_api.validate_enabled;
2400: end if;
2401: --
2402: -- Set all output arguments
2403: --

Line 2409: when hr_api.validate_enabled then

2405: p_object_version_number := l_object_version_number;
2406: --
2407: hr_utility.set_location(' Leaving:'||l_proc, 70);
2408: exception
2409: when hr_api.validate_enabled then
2410: --
2411: -- As the Validate_Enabled exception has been raised
2412: -- we must rollback to the savepoint
2413: --

Line 2442: ,p_location in varchar2 default hr_api.g_varchar2

2438: procedure UPDATE_WORK_CHOICES
2439: (p_validate in boolean default false
2440: ,p_effective_date in date
2441: ,p_search_criteria_id in number
2442: ,p_location in varchar2 default hr_api.g_varchar2
2443: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
2444: ,p_geocode_location in varchar2 default hr_api.g_varchar2
2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446: ,p_derived_location in varchar2 default hr_api.g_varchar2

Line 2443: ,p_distance_to_location in varchar2 default hr_api.g_varchar2

2439: (p_validate in boolean default false
2440: ,p_effective_date in date
2441: ,p_search_criteria_id in number
2442: ,p_location in varchar2 default hr_api.g_varchar2
2443: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
2444: ,p_geocode_location in varchar2 default hr_api.g_varchar2
2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446: ,p_derived_location in varchar2 default hr_api.g_varchar2
2447: ,p_location_id in number default hr_api.g_number

Line 2444: ,p_geocode_location in varchar2 default hr_api.g_varchar2

2440: ,p_effective_date in date
2441: ,p_search_criteria_id in number
2442: ,p_location in varchar2 default hr_api.g_varchar2
2443: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
2444: ,p_geocode_location in varchar2 default hr_api.g_varchar2
2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446: ,p_derived_location in varchar2 default hr_api.g_varchar2
2447: ,p_location_id in number default hr_api.g_number
2448: ,p_longitude in number default hr_api.g_number

Line 2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2

2441: ,p_search_criteria_id in number
2442: ,p_location in varchar2 default hr_api.g_varchar2
2443: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
2444: ,p_geocode_location in varchar2 default hr_api.g_varchar2
2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446: ,p_derived_location in varchar2 default hr_api.g_varchar2
2447: ,p_location_id in number default hr_api.g_number
2448: ,p_longitude in number default hr_api.g_number
2449: ,p_latitude in number default hr_api.g_number

Line 2446: ,p_derived_location in varchar2 default hr_api.g_varchar2

2442: ,p_location in varchar2 default hr_api.g_varchar2
2443: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
2444: ,p_geocode_location in varchar2 default hr_api.g_varchar2
2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446: ,p_derived_location in varchar2 default hr_api.g_varchar2
2447: ,p_location_id in number default hr_api.g_number
2448: ,p_longitude in number default hr_api.g_number
2449: ,p_latitude in number default hr_api.g_number
2450: ,p_employee in varchar2 default hr_api.g_varchar2

Line 2447: ,p_location_id in number default hr_api.g_number

2443: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
2444: ,p_geocode_location in varchar2 default hr_api.g_varchar2
2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446: ,p_derived_location in varchar2 default hr_api.g_varchar2
2447: ,p_location_id in number default hr_api.g_number
2448: ,p_longitude in number default hr_api.g_number
2449: ,p_latitude in number default hr_api.g_number
2450: ,p_employee in varchar2 default hr_api.g_varchar2
2451: ,p_contractor in varchar2 default hr_api.g_varchar2

Line 2448: ,p_longitude in number default hr_api.g_number

2444: ,p_geocode_location in varchar2 default hr_api.g_varchar2
2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446: ,p_derived_location in varchar2 default hr_api.g_varchar2
2447: ,p_location_id in number default hr_api.g_number
2448: ,p_longitude in number default hr_api.g_number
2449: ,p_latitude in number default hr_api.g_number
2450: ,p_employee in varchar2 default hr_api.g_varchar2
2451: ,p_contractor in varchar2 default hr_api.g_varchar2
2452: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 2449: ,p_latitude in number default hr_api.g_number

2445: ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446: ,p_derived_location in varchar2 default hr_api.g_varchar2
2447: ,p_location_id in number default hr_api.g_number
2448: ,p_longitude in number default hr_api.g_number
2449: ,p_latitude in number default hr_api.g_number
2450: ,p_employee in varchar2 default hr_api.g_varchar2
2451: ,p_contractor in varchar2 default hr_api.g_varchar2
2452: ,p_employment_category in varchar2 default hr_api.g_varchar2
2453: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 2450: ,p_employee in varchar2 default hr_api.g_varchar2

2446: ,p_derived_location in varchar2 default hr_api.g_varchar2
2447: ,p_location_id in number default hr_api.g_number
2448: ,p_longitude in number default hr_api.g_number
2449: ,p_latitude in number default hr_api.g_number
2450: ,p_employee in varchar2 default hr_api.g_varchar2
2451: ,p_contractor in varchar2 default hr_api.g_varchar2
2452: ,p_employment_category in varchar2 default hr_api.g_varchar2
2453: ,p_keywords in varchar2 default hr_api.g_varchar2
2454: ,p_travel_percentage in number default hr_api.g_number

Line 2451: ,p_contractor in varchar2 default hr_api.g_varchar2

2447: ,p_location_id in number default hr_api.g_number
2448: ,p_longitude in number default hr_api.g_number
2449: ,p_latitude in number default hr_api.g_number
2450: ,p_employee in varchar2 default hr_api.g_varchar2
2451: ,p_contractor in varchar2 default hr_api.g_varchar2
2452: ,p_employment_category in varchar2 default hr_api.g_varchar2
2453: ,p_keywords in varchar2 default hr_api.g_varchar2
2454: ,p_travel_percentage in number default hr_api.g_number
2455: ,p_min_salary in number default hr_api.g_number

Line 2452: ,p_employment_category in varchar2 default hr_api.g_varchar2

2448: ,p_longitude in number default hr_api.g_number
2449: ,p_latitude in number default hr_api.g_number
2450: ,p_employee in varchar2 default hr_api.g_varchar2
2451: ,p_contractor in varchar2 default hr_api.g_varchar2
2452: ,p_employment_category in varchar2 default hr_api.g_varchar2
2453: ,p_keywords in varchar2 default hr_api.g_varchar2
2454: ,p_travel_percentage in number default hr_api.g_number
2455: ,p_min_salary in number default hr_api.g_number
2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2

Line 2453: ,p_keywords in varchar2 default hr_api.g_varchar2

2449: ,p_latitude in number default hr_api.g_number
2450: ,p_employee in varchar2 default hr_api.g_varchar2
2451: ,p_contractor in varchar2 default hr_api.g_varchar2
2452: ,p_employment_category in varchar2 default hr_api.g_varchar2
2453: ,p_keywords in varchar2 default hr_api.g_varchar2
2454: ,p_travel_percentage in number default hr_api.g_number
2455: ,p_min_salary in number default hr_api.g_number
2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457: ,p_salary_period in varchar2 default hr_api.g_varchar2

Line 2454: ,p_travel_percentage in number default hr_api.g_number

2450: ,p_employee in varchar2 default hr_api.g_varchar2
2451: ,p_contractor in varchar2 default hr_api.g_varchar2
2452: ,p_employment_category in varchar2 default hr_api.g_varchar2
2453: ,p_keywords in varchar2 default hr_api.g_varchar2
2454: ,p_travel_percentage in number default hr_api.g_number
2455: ,p_min_salary in number default hr_api.g_number
2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457: ,p_salary_period in varchar2 default hr_api.g_varchar2
2458: ,p_match_competence in varchar2 default hr_api.g_varchar2

Line 2455: ,p_min_salary in number default hr_api.g_number

2451: ,p_contractor in varchar2 default hr_api.g_varchar2
2452: ,p_employment_category in varchar2 default hr_api.g_varchar2
2453: ,p_keywords in varchar2 default hr_api.g_varchar2
2454: ,p_travel_percentage in number default hr_api.g_number
2455: ,p_min_salary in number default hr_api.g_number
2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457: ,p_salary_period in varchar2 default hr_api.g_varchar2
2458: ,p_match_competence in varchar2 default hr_api.g_varchar2
2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2

Line 2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2

2452: ,p_employment_category in varchar2 default hr_api.g_varchar2
2453: ,p_keywords in varchar2 default hr_api.g_varchar2
2454: ,p_travel_percentage in number default hr_api.g_number
2455: ,p_min_salary in number default hr_api.g_number
2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457: ,p_salary_period in varchar2 default hr_api.g_varchar2
2458: ,p_match_competence in varchar2 default hr_api.g_varchar2
2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 2457: ,p_salary_period in varchar2 default hr_api.g_varchar2

2453: ,p_keywords in varchar2 default hr_api.g_varchar2
2454: ,p_travel_percentage in number default hr_api.g_number
2455: ,p_min_salary in number default hr_api.g_number
2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457: ,p_salary_period in varchar2 default hr_api.g_varchar2
2458: ,p_match_competence in varchar2 default hr_api.g_varchar2
2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461: ,p_job_title in varchar2 default hr_api.g_varchar2

Line 2458: ,p_match_competence in varchar2 default hr_api.g_varchar2

2454: ,p_travel_percentage in number default hr_api.g_number
2455: ,p_min_salary in number default hr_api.g_number
2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457: ,p_salary_period in varchar2 default hr_api.g_varchar2
2458: ,p_match_competence in varchar2 default hr_api.g_varchar2
2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461: ,p_job_title in varchar2 default hr_api.g_varchar2
2462: ,p_department in varchar2 default hr_api.g_varchar2

Line 2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2

2455: ,p_min_salary in number default hr_api.g_number
2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457: ,p_salary_period in varchar2 default hr_api.g_varchar2
2458: ,p_match_competence in varchar2 default hr_api.g_varchar2
2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461: ,p_job_title in varchar2 default hr_api.g_varchar2
2462: ,p_department in varchar2 default hr_api.g_varchar2
2463: ,p_professional_area in varchar2 default hr_api.g_varchar2

Line 2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2

2456: ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457: ,p_salary_period in varchar2 default hr_api.g_varchar2
2458: ,p_match_competence in varchar2 default hr_api.g_varchar2
2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461: ,p_job_title in varchar2 default hr_api.g_varchar2
2462: ,p_department in varchar2 default hr_api.g_varchar2
2463: ,p_professional_area in varchar2 default hr_api.g_varchar2
2464: ,p_description in varchar2 default hr_api.g_varchar2

Line 2461: ,p_job_title in varchar2 default hr_api.g_varchar2

2457: ,p_salary_period in varchar2 default hr_api.g_varchar2
2458: ,p_match_competence in varchar2 default hr_api.g_varchar2
2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461: ,p_job_title in varchar2 default hr_api.g_varchar2
2462: ,p_department in varchar2 default hr_api.g_varchar2
2463: ,p_professional_area in varchar2 default hr_api.g_varchar2
2464: ,p_description in varchar2 default hr_api.g_varchar2
2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 2462: ,p_department in varchar2 default hr_api.g_varchar2

2458: ,p_match_competence in varchar2 default hr_api.g_varchar2
2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461: ,p_job_title in varchar2 default hr_api.g_varchar2
2462: ,p_department in varchar2 default hr_api.g_varchar2
2463: ,p_professional_area in varchar2 default hr_api.g_varchar2
2464: ,p_description in varchar2 default hr_api.g_varchar2
2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 2463: ,p_professional_area in varchar2 default hr_api.g_varchar2

2459: ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461: ,p_job_title in varchar2 default hr_api.g_varchar2
2462: ,p_department in varchar2 default hr_api.g_varchar2
2463: ,p_professional_area in varchar2 default hr_api.g_varchar2
2464: ,p_description in varchar2 default hr_api.g_varchar2
2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 2464: ,p_description in varchar2 default hr_api.g_varchar2

2460: ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461: ,p_job_title in varchar2 default hr_api.g_varchar2
2462: ,p_department in varchar2 default hr_api.g_varchar2
2463: ,p_professional_area in varchar2 default hr_api.g_varchar2
2464: ,p_description in varchar2 default hr_api.g_varchar2
2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2

2461: ,p_job_title in varchar2 default hr_api.g_varchar2
2462: ,p_department in varchar2 default hr_api.g_varchar2
2463: ,p_professional_area in varchar2 default hr_api.g_varchar2
2464: ,p_description in varchar2 default hr_api.g_varchar2
2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2

2462: ,p_department in varchar2 default hr_api.g_varchar2
2463: ,p_professional_area in varchar2 default hr_api.g_varchar2
2464: ,p_description in varchar2 default hr_api.g_varchar2
2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2

2463: ,p_professional_area in varchar2 default hr_api.g_varchar2
2464: ,p_description in varchar2 default hr_api.g_varchar2
2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2

2464: ,p_description in varchar2 default hr_api.g_varchar2
2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2

2465: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2

2466: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2

2467: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2

2468: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2

2469: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2

2470: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2

2471: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2

2472: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2

2473: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2

2474: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2

2475: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2

2476: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2

2477: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2

2478: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2

2479: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2

2480: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2

2481: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2

2482: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2

2483: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2

2484: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2

2485: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2

2486: ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2

2487: ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2

2488: ,p_attribute23 in varchar2 default hr_api.g_varchar2
2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

Line 2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2

2489: ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

Line 2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2

2490: ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

Line 2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2

2491: ,p_attribute26 in varchar2 default hr_api.g_varchar2
2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

Line 2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

2492: ,p_attribute27 in varchar2 default hr_api.g_varchar2
2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

Line 2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

2493: ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

Line 2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

2494: ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

Line 2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

2495: ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

Line 2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

2496: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

Line 2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

2497: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

Line 2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

2498: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

Line 2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

2499: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

Line 2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

2500: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

Line 2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

2501: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

Line 2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

2502: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

Line 2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

2503: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

Line 2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

2504: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

Line 2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

2505: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

Line 2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

2506: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

Line 2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

2507: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

Line 2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

2508: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

Line 2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

2509: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

Line 2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

2510: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

Line 2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

2511: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

Line 2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

2512: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

Line 2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

2513: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

Line 2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

2514: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

Line 2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

2515: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

Line 2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

2516: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
2524: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

Line 2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

2517: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
2524: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
2525: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

Line 2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

2518: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
2524: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
2525: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
2526: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

Line 2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

2519: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
2524: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
2525: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
2526: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
2527: ,p_object_version_number in out nocopy number

Line 2524: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

2520: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
2524: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
2525: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
2526: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
2527: ,p_object_version_number in out nocopy number
2528: ) is

Line 2525: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

2521: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
2524: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
2525: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
2526: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
2527: ,p_object_version_number in out nocopy number
2528: ) is
2529: --

Line 2526: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

2522: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
2524: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
2525: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
2526: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
2527: ,p_object_version_number in out nocopy number
2528: ) is
2529: --
2530: -- Declare cursors and local variables

Line 2643: when hr_api.cannot_find_prog_unit then

2639: ,p_isc_information30 => p_isc_information30
2640: ,p_object_version_number => l_object_version_number
2641: );
2642: exception
2643: when hr_api.cannot_find_prog_unit then
2644: hr_api.cannot_find_prog_unit_error
2645: (p_module_name => 'UPDATE_WORK_CHOICES'
2646: ,p_hook_type => 'BP'
2647: );

Line 2644: hr_api.cannot_find_prog_unit_error

2640: ,p_object_version_number => l_object_version_number
2641: );
2642: exception
2643: when hr_api.cannot_find_prog_unit then
2644: hr_api.cannot_find_prog_unit_error
2645: (p_module_name => 'UPDATE_WORK_CHOICES'
2646: ,p_hook_type => 'BP'
2647: );
2648: end;

Line 2840: when hr_api.cannot_find_prog_unit then

2836: ,p_isc_information30 => p_isc_information30
2837: ,p_object_version_number => l_object_version_number
2838: );
2839: exception
2840: when hr_api.cannot_find_prog_unit then
2841: hr_api.cannot_find_prog_unit_error
2842: (p_module_name => 'UPDATE_WORK_CHOICES'
2843: ,p_hook_type => 'AP'
2844: );

Line 2841: hr_api.cannot_find_prog_unit_error

2837: ,p_object_version_number => l_object_version_number
2838: );
2839: exception
2840: when hr_api.cannot_find_prog_unit then
2841: hr_api.cannot_find_prog_unit_error
2842: (p_module_name => 'UPDATE_WORK_CHOICES'
2843: ,p_hook_type => 'AP'
2844: );
2845: end;

Line 2850: raise hr_api.validate_enabled;

2846: --
2847: -- When in validation only mode raise the Validate_Enabled exception
2848: --
2849: if p_validate then
2850: raise hr_api.validate_enabled;
2851: end if;
2852: --
2853: -- Set all output arguments
2854: --

Line 2859: when hr_api.validate_enabled then

2855: p_object_version_number := l_object_version_number;
2856: --
2857: hr_utility.set_location(' Leaving:'||l_proc, 70);
2858: exception
2859: when hr_api.validate_enabled then
2860: --
2861: -- As the Validate_Enabled exception has been raised
2862: -- we must rollback to the savepoint
2863: --

Line 2920: when hr_api.cannot_find_prog_unit then

2916: (p_search_criteria_id => p_search_criteria_id
2917: ,p_object_version_number => p_object_version_number
2918: );
2919: exception
2920: when hr_api.cannot_find_prog_unit then
2921: hr_api.cannot_find_prog_unit_error
2922: (p_module_name => 'DELETE_WORK_CHOICES'
2923: ,p_hook_type => 'BP'
2924: );

Line 2921: hr_api.cannot_find_prog_unit_error

2917: ,p_object_version_number => p_object_version_number
2918: );
2919: exception
2920: when hr_api.cannot_find_prog_unit then
2921: hr_api.cannot_find_prog_unit_error
2922: (p_module_name => 'DELETE_WORK_CHOICES'
2923: ,p_hook_type => 'BP'
2924: );
2925: end;

Line 2944: when hr_api.cannot_find_prog_unit then

2940: (p_search_criteria_id => p_search_criteria_id
2941: ,p_object_version_number => p_object_version_number
2942: );
2943: exception
2944: when hr_api.cannot_find_prog_unit then
2945: hr_api.cannot_find_prog_unit_error
2946: (p_module_name => 'DELETE_WORK_CHOICES'
2947: ,p_hook_type => 'AP'
2948: );

Line 2945: hr_api.cannot_find_prog_unit_error

2941: ,p_object_version_number => p_object_version_number
2942: );
2943: exception
2944: when hr_api.cannot_find_prog_unit then
2945: hr_api.cannot_find_prog_unit_error
2946: (p_module_name => 'DELETE_WORK_CHOICES'
2947: ,p_hook_type => 'AP'
2948: );
2949: end;

Line 2954: raise hr_api.validate_enabled;

2950: --
2951: -- When in validation only mode raise the Validate_Enabled exception
2952: --
2953: if p_validate then
2954: raise hr_api.validate_enabled;
2955: end if;
2956: --
2957: -- Set all output arguments
2958: --

Line 2962: when hr_api.validate_enabled then

2958: --
2959: --
2960: hr_utility.set_location(' Leaving:'||l_proc, 70);
2961: exception
2962: when hr_api.validate_enabled then
2963: --
2964: -- As the Validate_Enabled exception has been raised
2965: -- we must rollback to the savepoint
2966: --