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