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

APPS.IRC_SEARCH_CRITERIA_SWI dependencies on HR_API

Line 12: (p_validate in number default hr_api.g_false_num

8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< create_saved_search >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_saved_search
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_person_id in number
15: ,p_search_name in varchar2
16: ,p_location in varchar2 default null

Line 133: hr_api.constant_to_boolean

129: --
130: -- Convert constant values to their corresponding boolean value
131: --
132: l_validate :=
133: hr_api.constant_to_boolean
134: (p_constant_value => p_validate);
135: --
136: -- Register Surrogate ID or user key values
137: --

Line 292: (p_validate in number default hr_api.g_false_num

288: -- ----------------------------------------------------------------------------
289: -- |------------------------< create_vacancy_criteria >-----------------------|
290: -- ----------------------------------------------------------------------------
291: PROCEDURE create_vacancy_criteria
292: (p_validate in number default hr_api.g_false_num
293: ,p_vacancy_id in number
294: ,p_effective_date in date
295: ,p_location in varchar2 default null
296: ,p_employee in varchar2 default null

Line 402: hr_api.constant_to_boolean

398: --
399: -- Convert constant values to their corresponding boolean value
400: --
401: l_validate :=
402: hr_api.constant_to_boolean
403: (p_constant_value => p_validate);
404: --
405: -- Register Surrogate ID or user key values
406: --

Line 551: (p_validate in number default hr_api.g_false_num

547: -- ----------------------------------------------------------------------------
548: -- |--------------------------< delete_saved_search >-------------------------|
549: -- ----------------------------------------------------------------------------
550: PROCEDURE delete_saved_search
551: (p_validate in number default hr_api.g_false_num
552: ,p_search_criteria_id in number
553: ,p_object_version_number in number
554: ,p_return_status out nocopy varchar2
555: ) is

Line 581: hr_api.constant_to_boolean

577: --
578: -- Convert constant values to their corresponding boolean value
579: --
580: l_validate :=
581: hr_api.constant_to_boolean
582: (p_constant_value => p_validate);
583: --
584: -- Register Surrogate ID or user key values
585: --

Line 645: (p_validate in number default hr_api.g_false_num

641: -- ----------------------------------------------------------------------------
642: -- |------------------------< delete_vacancy_criteria >-----------------------|
643: -- ----------------------------------------------------------------------------
644: PROCEDURE delete_vacancy_criteria
645: (p_validate in number default hr_api.g_false_num
646: ,p_search_criteria_id in number
647: ,p_object_version_number in number
648: ,p_return_status out nocopy varchar2
649: ) is

Line 675: hr_api.constant_to_boolean

671: --
672: -- Convert constant values to their corresponding boolean value
673: --
674: l_validate :=
675: hr_api.constant_to_boolean
676: (p_constant_value => p_validate);
677: --
678: -- Register Surrogate ID or user key values
679: --

Line 739: (p_validate in number default hr_api.g_false_num

735: -- ----------------------------------------------------------------------------
736: -- |--------------------------< update_saved_search >-------------------------|
737: -- ----------------------------------------------------------------------------
738: PROCEDURE update_saved_search
739: (p_validate in number default hr_api.g_false_num
740: ,p_effective_date in date
741: ,p_search_criteria_id in number
742: ,p_person_id in number default hr_api.g_number
743: ,p_search_name in varchar2 default hr_api.g_varchar2

Line 742: ,p_person_id in number default hr_api.g_number

738: PROCEDURE update_saved_search
739: (p_validate in number default hr_api.g_false_num
740: ,p_effective_date in date
741: ,p_search_criteria_id in number
742: ,p_person_id in number default hr_api.g_number
743: ,p_search_name in varchar2 default hr_api.g_varchar2
744: ,p_location in varchar2 default hr_api.g_varchar2
745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746: ,p_geocode_location in varchar2 default hr_api.g_varchar2

Line 743: ,p_search_name in varchar2 default hr_api.g_varchar2

739: (p_validate in number default hr_api.g_false_num
740: ,p_effective_date in date
741: ,p_search_criteria_id in number
742: ,p_person_id in number default hr_api.g_number
743: ,p_search_name in varchar2 default hr_api.g_varchar2
744: ,p_location in varchar2 default hr_api.g_varchar2
745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746: ,p_geocode_location in varchar2 default hr_api.g_varchar2
747: ,p_geocode_country in varchar2 default hr_api.g_varchar2

Line 744: ,p_location in varchar2 default hr_api.g_varchar2

740: ,p_effective_date in date
741: ,p_search_criteria_id in number
742: ,p_person_id in number default hr_api.g_number
743: ,p_search_name in varchar2 default hr_api.g_varchar2
744: ,p_location in varchar2 default hr_api.g_varchar2
745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746: ,p_geocode_location in varchar2 default hr_api.g_varchar2
747: ,p_geocode_country in varchar2 default hr_api.g_varchar2
748: ,p_derived_location in varchar2 default hr_api.g_varchar2

Line 745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2

741: ,p_search_criteria_id in number
742: ,p_person_id in number default hr_api.g_number
743: ,p_search_name in varchar2 default hr_api.g_varchar2
744: ,p_location in varchar2 default hr_api.g_varchar2
745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746: ,p_geocode_location in varchar2 default hr_api.g_varchar2
747: ,p_geocode_country in varchar2 default hr_api.g_varchar2
748: ,p_derived_location in varchar2 default hr_api.g_varchar2
749: ,p_location_id in number default hr_api.g_number

Line 746: ,p_geocode_location in varchar2 default hr_api.g_varchar2

742: ,p_person_id in number default hr_api.g_number
743: ,p_search_name in varchar2 default hr_api.g_varchar2
744: ,p_location in varchar2 default hr_api.g_varchar2
745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746: ,p_geocode_location in varchar2 default hr_api.g_varchar2
747: ,p_geocode_country in varchar2 default hr_api.g_varchar2
748: ,p_derived_location in varchar2 default hr_api.g_varchar2
749: ,p_location_id in number default hr_api.g_number
750: ,p_longitude in number default hr_api.g_number

Line 747: ,p_geocode_country in varchar2 default hr_api.g_varchar2

743: ,p_search_name in varchar2 default hr_api.g_varchar2
744: ,p_location in varchar2 default hr_api.g_varchar2
745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746: ,p_geocode_location in varchar2 default hr_api.g_varchar2
747: ,p_geocode_country in varchar2 default hr_api.g_varchar2
748: ,p_derived_location in varchar2 default hr_api.g_varchar2
749: ,p_location_id in number default hr_api.g_number
750: ,p_longitude in number default hr_api.g_number
751: ,p_latitude in number default hr_api.g_number

Line 748: ,p_derived_location in varchar2 default hr_api.g_varchar2

744: ,p_location in varchar2 default hr_api.g_varchar2
745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746: ,p_geocode_location in varchar2 default hr_api.g_varchar2
747: ,p_geocode_country in varchar2 default hr_api.g_varchar2
748: ,p_derived_location in varchar2 default hr_api.g_varchar2
749: ,p_location_id in number default hr_api.g_number
750: ,p_longitude in number default hr_api.g_number
751: ,p_latitude in number default hr_api.g_number
752: ,p_employee in varchar2 default hr_api.g_varchar2

Line 749: ,p_location_id in number default hr_api.g_number

745: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746: ,p_geocode_location in varchar2 default hr_api.g_varchar2
747: ,p_geocode_country in varchar2 default hr_api.g_varchar2
748: ,p_derived_location in varchar2 default hr_api.g_varchar2
749: ,p_location_id in number default hr_api.g_number
750: ,p_longitude in number default hr_api.g_number
751: ,p_latitude in number default hr_api.g_number
752: ,p_employee in varchar2 default hr_api.g_varchar2
753: ,p_contractor in varchar2 default hr_api.g_varchar2

Line 750: ,p_longitude in number default hr_api.g_number

746: ,p_geocode_location in varchar2 default hr_api.g_varchar2
747: ,p_geocode_country in varchar2 default hr_api.g_varchar2
748: ,p_derived_location in varchar2 default hr_api.g_varchar2
749: ,p_location_id in number default hr_api.g_number
750: ,p_longitude in number default hr_api.g_number
751: ,p_latitude in number default hr_api.g_number
752: ,p_employee in varchar2 default hr_api.g_varchar2
753: ,p_contractor in varchar2 default hr_api.g_varchar2
754: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 751: ,p_latitude in number default hr_api.g_number

747: ,p_geocode_country in varchar2 default hr_api.g_varchar2
748: ,p_derived_location in varchar2 default hr_api.g_varchar2
749: ,p_location_id in number default hr_api.g_number
750: ,p_longitude in number default hr_api.g_number
751: ,p_latitude in number default hr_api.g_number
752: ,p_employee in varchar2 default hr_api.g_varchar2
753: ,p_contractor in varchar2 default hr_api.g_varchar2
754: ,p_employment_category in varchar2 default hr_api.g_varchar2
755: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 752: ,p_employee in varchar2 default hr_api.g_varchar2

748: ,p_derived_location in varchar2 default hr_api.g_varchar2
749: ,p_location_id in number default hr_api.g_number
750: ,p_longitude in number default hr_api.g_number
751: ,p_latitude in number default hr_api.g_number
752: ,p_employee in varchar2 default hr_api.g_varchar2
753: ,p_contractor in varchar2 default hr_api.g_varchar2
754: ,p_employment_category in varchar2 default hr_api.g_varchar2
755: ,p_keywords in varchar2 default hr_api.g_varchar2
756: ,p_travel_percentage in number default hr_api.g_number

Line 753: ,p_contractor in varchar2 default hr_api.g_varchar2

749: ,p_location_id in number default hr_api.g_number
750: ,p_longitude in number default hr_api.g_number
751: ,p_latitude in number default hr_api.g_number
752: ,p_employee in varchar2 default hr_api.g_varchar2
753: ,p_contractor in varchar2 default hr_api.g_varchar2
754: ,p_employment_category in varchar2 default hr_api.g_varchar2
755: ,p_keywords in varchar2 default hr_api.g_varchar2
756: ,p_travel_percentage in number default hr_api.g_number
757: ,p_min_salary in number default hr_api.g_number

Line 754: ,p_employment_category in varchar2 default hr_api.g_varchar2

750: ,p_longitude in number default hr_api.g_number
751: ,p_latitude in number default hr_api.g_number
752: ,p_employee in varchar2 default hr_api.g_varchar2
753: ,p_contractor in varchar2 default hr_api.g_varchar2
754: ,p_employment_category in varchar2 default hr_api.g_varchar2
755: ,p_keywords in varchar2 default hr_api.g_varchar2
756: ,p_travel_percentage in number default hr_api.g_number
757: ,p_min_salary in number default hr_api.g_number
758: ,p_salary_currency in varchar2 default hr_api.g_varchar2

Line 755: ,p_keywords in varchar2 default hr_api.g_varchar2

751: ,p_latitude in number default hr_api.g_number
752: ,p_employee in varchar2 default hr_api.g_varchar2
753: ,p_contractor in varchar2 default hr_api.g_varchar2
754: ,p_employment_category in varchar2 default hr_api.g_varchar2
755: ,p_keywords in varchar2 default hr_api.g_varchar2
756: ,p_travel_percentage in number default hr_api.g_number
757: ,p_min_salary in number default hr_api.g_number
758: ,p_salary_currency in varchar2 default hr_api.g_varchar2
759: ,p_salary_period in varchar2 default hr_api.g_varchar2

Line 756: ,p_travel_percentage in number default hr_api.g_number

752: ,p_employee in varchar2 default hr_api.g_varchar2
753: ,p_contractor in varchar2 default hr_api.g_varchar2
754: ,p_employment_category in varchar2 default hr_api.g_varchar2
755: ,p_keywords in varchar2 default hr_api.g_varchar2
756: ,p_travel_percentage in number default hr_api.g_number
757: ,p_min_salary in number default hr_api.g_number
758: ,p_salary_currency in varchar2 default hr_api.g_varchar2
759: ,p_salary_period in varchar2 default hr_api.g_varchar2
760: ,p_match_competence in varchar2 default hr_api.g_varchar2

Line 757: ,p_min_salary in number default hr_api.g_number

753: ,p_contractor in varchar2 default hr_api.g_varchar2
754: ,p_employment_category in varchar2 default hr_api.g_varchar2
755: ,p_keywords in varchar2 default hr_api.g_varchar2
756: ,p_travel_percentage in number default hr_api.g_number
757: ,p_min_salary in number default hr_api.g_number
758: ,p_salary_currency in varchar2 default hr_api.g_varchar2
759: ,p_salary_period in varchar2 default hr_api.g_varchar2
760: ,p_match_competence in varchar2 default hr_api.g_varchar2
761: ,p_match_qualification in varchar2 default hr_api.g_varchar2

Line 758: ,p_salary_currency in varchar2 default hr_api.g_varchar2

754: ,p_employment_category in varchar2 default hr_api.g_varchar2
755: ,p_keywords in varchar2 default hr_api.g_varchar2
756: ,p_travel_percentage in number default hr_api.g_number
757: ,p_min_salary in number default hr_api.g_number
758: ,p_salary_currency in varchar2 default hr_api.g_varchar2
759: ,p_salary_period in varchar2 default hr_api.g_varchar2
760: ,p_match_competence in varchar2 default hr_api.g_varchar2
761: ,p_match_qualification in varchar2 default hr_api.g_varchar2
762: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 759: ,p_salary_period in varchar2 default hr_api.g_varchar2

755: ,p_keywords in varchar2 default hr_api.g_varchar2
756: ,p_travel_percentage in number default hr_api.g_number
757: ,p_min_salary in number default hr_api.g_number
758: ,p_salary_currency in varchar2 default hr_api.g_varchar2
759: ,p_salary_period in varchar2 default hr_api.g_varchar2
760: ,p_match_competence in varchar2 default hr_api.g_varchar2
761: ,p_match_qualification in varchar2 default hr_api.g_varchar2
762: ,p_work_at_home in varchar2 default hr_api.g_varchar2
763: ,p_job_title in varchar2 default hr_api.g_varchar2

Line 760: ,p_match_competence in varchar2 default hr_api.g_varchar2

756: ,p_travel_percentage in number default hr_api.g_number
757: ,p_min_salary in number default hr_api.g_number
758: ,p_salary_currency in varchar2 default hr_api.g_varchar2
759: ,p_salary_period in varchar2 default hr_api.g_varchar2
760: ,p_match_competence in varchar2 default hr_api.g_varchar2
761: ,p_match_qualification in varchar2 default hr_api.g_varchar2
762: ,p_work_at_home in varchar2 default hr_api.g_varchar2
763: ,p_job_title in varchar2 default hr_api.g_varchar2
764: ,p_department in varchar2 default hr_api.g_varchar2

Line 761: ,p_match_qualification in varchar2 default hr_api.g_varchar2

757: ,p_min_salary in number default hr_api.g_number
758: ,p_salary_currency in varchar2 default hr_api.g_varchar2
759: ,p_salary_period in varchar2 default hr_api.g_varchar2
760: ,p_match_competence in varchar2 default hr_api.g_varchar2
761: ,p_match_qualification in varchar2 default hr_api.g_varchar2
762: ,p_work_at_home in varchar2 default hr_api.g_varchar2
763: ,p_job_title in varchar2 default hr_api.g_varchar2
764: ,p_department in varchar2 default hr_api.g_varchar2
765: ,p_professional_area in varchar2 default hr_api.g_varchar2

Line 762: ,p_work_at_home in varchar2 default hr_api.g_varchar2

758: ,p_salary_currency in varchar2 default hr_api.g_varchar2
759: ,p_salary_period in varchar2 default hr_api.g_varchar2
760: ,p_match_competence in varchar2 default hr_api.g_varchar2
761: ,p_match_qualification in varchar2 default hr_api.g_varchar2
762: ,p_work_at_home in varchar2 default hr_api.g_varchar2
763: ,p_job_title in varchar2 default hr_api.g_varchar2
764: ,p_department in varchar2 default hr_api.g_varchar2
765: ,p_professional_area in varchar2 default hr_api.g_varchar2
766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2

Line 763: ,p_job_title in varchar2 default hr_api.g_varchar2

759: ,p_salary_period in varchar2 default hr_api.g_varchar2
760: ,p_match_competence in varchar2 default hr_api.g_varchar2
761: ,p_match_qualification in varchar2 default hr_api.g_varchar2
762: ,p_work_at_home in varchar2 default hr_api.g_varchar2
763: ,p_job_title in varchar2 default hr_api.g_varchar2
764: ,p_department in varchar2 default hr_api.g_varchar2
765: ,p_professional_area in varchar2 default hr_api.g_varchar2
766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767: ,p_description in varchar2 default hr_api.g_varchar2

Line 764: ,p_department in varchar2 default hr_api.g_varchar2

760: ,p_match_competence in varchar2 default hr_api.g_varchar2
761: ,p_match_qualification in varchar2 default hr_api.g_varchar2
762: ,p_work_at_home in varchar2 default hr_api.g_varchar2
763: ,p_job_title in varchar2 default hr_api.g_varchar2
764: ,p_department in varchar2 default hr_api.g_varchar2
765: ,p_professional_area in varchar2 default hr_api.g_varchar2
766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767: ,p_description in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 765: ,p_professional_area in varchar2 default hr_api.g_varchar2

761: ,p_match_qualification in varchar2 default hr_api.g_varchar2
762: ,p_work_at_home in varchar2 default hr_api.g_varchar2
763: ,p_job_title in varchar2 default hr_api.g_varchar2
764: ,p_department in varchar2 default hr_api.g_varchar2
765: ,p_professional_area in varchar2 default hr_api.g_varchar2
766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767: ,p_description in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2

762: ,p_work_at_home in varchar2 default hr_api.g_varchar2
763: ,p_job_title in varchar2 default hr_api.g_varchar2
764: ,p_department in varchar2 default hr_api.g_varchar2
765: ,p_professional_area in varchar2 default hr_api.g_varchar2
766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767: ,p_description in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 767: ,p_description in varchar2 default hr_api.g_varchar2

763: ,p_job_title in varchar2 default hr_api.g_varchar2
764: ,p_department in varchar2 default hr_api.g_varchar2
765: ,p_professional_area in varchar2 default hr_api.g_varchar2
766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767: ,p_description in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 768: ,p_attribute_category in varchar2 default hr_api.g_varchar2

764: ,p_department in varchar2 default hr_api.g_varchar2
765: ,p_professional_area in varchar2 default hr_api.g_varchar2
766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767: ,p_description in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 769: ,p_attribute1 in varchar2 default hr_api.g_varchar2

765: ,p_professional_area in varchar2 default hr_api.g_varchar2
766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767: ,p_description in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 770: ,p_attribute2 in varchar2 default hr_api.g_varchar2

766: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767: ,p_description in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 771: ,p_attribute3 in varchar2 default hr_api.g_varchar2

767: ,p_description in varchar2 default hr_api.g_varchar2
768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 772: ,p_attribute4 in varchar2 default hr_api.g_varchar2

768: ,p_attribute_category in varchar2 default hr_api.g_varchar2
769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 773: ,p_attribute5 in varchar2 default hr_api.g_varchar2

769: ,p_attribute1 in varchar2 default hr_api.g_varchar2
770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 774: ,p_attribute6 in varchar2 default hr_api.g_varchar2

770: ,p_attribute2 in varchar2 default hr_api.g_varchar2
771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 775: ,p_attribute7 in varchar2 default hr_api.g_varchar2

771: ,p_attribute3 in varchar2 default hr_api.g_varchar2
772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 776: ,p_attribute8 in varchar2 default hr_api.g_varchar2

772: ,p_attribute4 in varchar2 default hr_api.g_varchar2
773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 777: ,p_attribute9 in varchar2 default hr_api.g_varchar2

773: ,p_attribute5 in varchar2 default hr_api.g_varchar2
774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 778: ,p_attribute10 in varchar2 default hr_api.g_varchar2

774: ,p_attribute6 in varchar2 default hr_api.g_varchar2
775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 779: ,p_attribute11 in varchar2 default hr_api.g_varchar2

775: ,p_attribute7 in varchar2 default hr_api.g_varchar2
776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 780: ,p_attribute12 in varchar2 default hr_api.g_varchar2

776: ,p_attribute8 in varchar2 default hr_api.g_varchar2
777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 781: ,p_attribute13 in varchar2 default hr_api.g_varchar2

777: ,p_attribute9 in varchar2 default hr_api.g_varchar2
778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 782: ,p_attribute14 in varchar2 default hr_api.g_varchar2

778: ,p_attribute10 in varchar2 default hr_api.g_varchar2
779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 783: ,p_attribute15 in varchar2 default hr_api.g_varchar2

779: ,p_attribute11 in varchar2 default hr_api.g_varchar2
780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 784: ,p_attribute16 in varchar2 default hr_api.g_varchar2

780: ,p_attribute12 in varchar2 default hr_api.g_varchar2
781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 785: ,p_attribute17 in varchar2 default hr_api.g_varchar2

781: ,p_attribute13 in varchar2 default hr_api.g_varchar2
782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 786: ,p_attribute18 in varchar2 default hr_api.g_varchar2

782: ,p_attribute14 in varchar2 default hr_api.g_varchar2
783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 787: ,p_attribute19 in varchar2 default hr_api.g_varchar2

783: ,p_attribute15 in varchar2 default hr_api.g_varchar2
784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 788: ,p_attribute20 in varchar2 default hr_api.g_varchar2

784: ,p_attribute16 in varchar2 default hr_api.g_varchar2
785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 789: ,p_attribute21 in varchar2 default hr_api.g_varchar2

785: ,p_attribute17 in varchar2 default hr_api.g_varchar2
786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 790: ,p_attribute22 in varchar2 default hr_api.g_varchar2

786: ,p_attribute18 in varchar2 default hr_api.g_varchar2
787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 791: ,p_attribute23 in varchar2 default hr_api.g_varchar2

787: ,p_attribute19 in varchar2 default hr_api.g_varchar2
788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 792: ,p_attribute24 in varchar2 default hr_api.g_varchar2

788: ,p_attribute20 in varchar2 default hr_api.g_varchar2
789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 793: ,p_attribute25 in varchar2 default hr_api.g_varchar2

789: ,p_attribute21 in varchar2 default hr_api.g_varchar2
790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 794: ,p_attribute26 in varchar2 default hr_api.g_varchar2

790: ,p_attribute22 in varchar2 default hr_api.g_varchar2
791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 795: ,p_attribute27 in varchar2 default hr_api.g_varchar2

791: ,p_attribute23 in varchar2 default hr_api.g_varchar2
792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

Line 796: ,p_attribute28 in varchar2 default hr_api.g_varchar2

792: ,p_attribute24 in varchar2 default hr_api.g_varchar2
793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

Line 797: ,p_attribute29 in varchar2 default hr_api.g_varchar2

793: ,p_attribute25 in varchar2 default hr_api.g_varchar2
794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

Line 798: ,p_attribute30 in varchar2 default hr_api.g_varchar2

794: ,p_attribute26 in varchar2 default hr_api.g_varchar2
795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

Line 799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

795: ,p_attribute27 in varchar2 default hr_api.g_varchar2
796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

Line 800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

796: ,p_attribute28 in varchar2 default hr_api.g_varchar2
797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

Line 801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

797: ,p_attribute29 in varchar2 default hr_api.g_varchar2
798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

Line 802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

798: ,p_attribute30 in varchar2 default hr_api.g_varchar2
799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

Line 803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

799: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

Line 804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

800: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

Line 805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

801: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

Line 806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

802: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

Line 807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

803: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

Line 808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

804: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

Line 809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

805: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

Line 810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

806: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

Line 811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

807: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

Line 812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

808: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

Line 813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

809: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

Line 814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

810: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

Line 815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

811: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

Line 816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

812: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

Line 817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

813: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

Line 818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

814: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

Line 819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

815: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

Line 820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

816: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

Line 821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

817: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

Line 822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

818: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

Line 823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

819: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

Line 824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

820: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
828: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

Line 825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

821: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
828: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
829: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

Line 826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

822: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
828: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
829: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
830: ,p_date_posted in varchar2 default hr_api.g_varchar2

Line 827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

823: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
828: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
829: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
830: ,p_date_posted in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number

Line 828: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

824: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
828: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
829: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
830: ,p_date_posted in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
832: ,p_return_status out nocopy varchar2

Line 829: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

825: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
828: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
829: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
830: ,p_date_posted in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
832: ,p_return_status out nocopy varchar2
833: ) is

Line 830: ,p_date_posted in varchar2 default hr_api.g_varchar2

826: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
828: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
829: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
830: ,p_date_posted in varchar2 default hr_api.g_varchar2
831: ,p_object_version_number in out nocopy number
832: ,p_return_status out nocopy varchar2
833: ) is
834: --

Line 861: hr_api.constant_to_boolean

857: --
858: -- Convert constant values to their corresponding boolean value
859: --
860: l_validate :=
861: hr_api.constant_to_boolean
862: (p_constant_value => p_validate);
863: --
864: -- Register Surrogate ID or user key values
865: --

Line 1017: (p_validate in number default hr_api.g_false_num

1013: -- ----------------------------------------------------------------------------
1014: -- |------------------------< update_vacancy_criteria >-----------------------|
1015: -- ----------------------------------------------------------------------------
1016: PROCEDURE update_vacancy_criteria
1017: (p_validate in number default hr_api.g_false_num
1018: ,p_search_criteria_id in number
1019: ,p_vacancy_id in number default hr_api.g_number
1020: ,p_effective_date in date
1021: ,p_location in varchar2 default hr_api.g_varchar2

Line 1019: ,p_vacancy_id in number default hr_api.g_number

1015: -- ----------------------------------------------------------------------------
1016: PROCEDURE update_vacancy_criteria
1017: (p_validate in number default hr_api.g_false_num
1018: ,p_search_criteria_id in number
1019: ,p_vacancy_id in number default hr_api.g_number
1020: ,p_effective_date in date
1021: ,p_location in varchar2 default hr_api.g_varchar2
1022: ,p_employee in varchar2 default hr_api.g_varchar2
1023: ,p_contractor in varchar2 default hr_api.g_varchar2

Line 1021: ,p_location in varchar2 default hr_api.g_varchar2

1017: (p_validate in number default hr_api.g_false_num
1018: ,p_search_criteria_id in number
1019: ,p_vacancy_id in number default hr_api.g_number
1020: ,p_effective_date in date
1021: ,p_location in varchar2 default hr_api.g_varchar2
1022: ,p_employee in varchar2 default hr_api.g_varchar2
1023: ,p_contractor in varchar2 default hr_api.g_varchar2
1024: ,p_employment_category in varchar2 default hr_api.g_varchar2
1025: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 1022: ,p_employee in varchar2 default hr_api.g_varchar2

1018: ,p_search_criteria_id in number
1019: ,p_vacancy_id in number default hr_api.g_number
1020: ,p_effective_date in date
1021: ,p_location in varchar2 default hr_api.g_varchar2
1022: ,p_employee in varchar2 default hr_api.g_varchar2
1023: ,p_contractor in varchar2 default hr_api.g_varchar2
1024: ,p_employment_category in varchar2 default hr_api.g_varchar2
1025: ,p_keywords in varchar2 default hr_api.g_varchar2
1026: ,p_travel_percentage in number default hr_api.g_number

Line 1023: ,p_contractor in varchar2 default hr_api.g_varchar2

1019: ,p_vacancy_id in number default hr_api.g_number
1020: ,p_effective_date in date
1021: ,p_location in varchar2 default hr_api.g_varchar2
1022: ,p_employee in varchar2 default hr_api.g_varchar2
1023: ,p_contractor in varchar2 default hr_api.g_varchar2
1024: ,p_employment_category in varchar2 default hr_api.g_varchar2
1025: ,p_keywords in varchar2 default hr_api.g_varchar2
1026: ,p_travel_percentage in number default hr_api.g_number
1027: ,p_min_salary in number default hr_api.g_number

Line 1024: ,p_employment_category in varchar2 default hr_api.g_varchar2

1020: ,p_effective_date in date
1021: ,p_location in varchar2 default hr_api.g_varchar2
1022: ,p_employee in varchar2 default hr_api.g_varchar2
1023: ,p_contractor in varchar2 default hr_api.g_varchar2
1024: ,p_employment_category in varchar2 default hr_api.g_varchar2
1025: ,p_keywords in varchar2 default hr_api.g_varchar2
1026: ,p_travel_percentage in number default hr_api.g_number
1027: ,p_min_salary in number default hr_api.g_number
1028: ,p_max_salary in number default hr_api.g_number

Line 1025: ,p_keywords in varchar2 default hr_api.g_varchar2

1021: ,p_location in varchar2 default hr_api.g_varchar2
1022: ,p_employee in varchar2 default hr_api.g_varchar2
1023: ,p_contractor in varchar2 default hr_api.g_varchar2
1024: ,p_employment_category in varchar2 default hr_api.g_varchar2
1025: ,p_keywords in varchar2 default hr_api.g_varchar2
1026: ,p_travel_percentage in number default hr_api.g_number
1027: ,p_min_salary in number default hr_api.g_number
1028: ,p_max_salary in number default hr_api.g_number
1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2

Line 1026: ,p_travel_percentage in number default hr_api.g_number

1022: ,p_employee in varchar2 default hr_api.g_varchar2
1023: ,p_contractor in varchar2 default hr_api.g_varchar2
1024: ,p_employment_category in varchar2 default hr_api.g_varchar2
1025: ,p_keywords in varchar2 default hr_api.g_varchar2
1026: ,p_travel_percentage in number default hr_api.g_number
1027: ,p_min_salary in number default hr_api.g_number
1028: ,p_max_salary in number default hr_api.g_number
1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030: ,p_salary_period in varchar2 default hr_api.g_varchar2

Line 1027: ,p_min_salary in number default hr_api.g_number

1023: ,p_contractor in varchar2 default hr_api.g_varchar2
1024: ,p_employment_category in varchar2 default hr_api.g_varchar2
1025: ,p_keywords in varchar2 default hr_api.g_varchar2
1026: ,p_travel_percentage in number default hr_api.g_number
1027: ,p_min_salary in number default hr_api.g_number
1028: ,p_max_salary in number default hr_api.g_number
1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030: ,p_salary_period in varchar2 default hr_api.g_varchar2
1031: ,p_professional_area in varchar2 default hr_api.g_varchar2

Line 1028: ,p_max_salary in number default hr_api.g_number

1024: ,p_employment_category in varchar2 default hr_api.g_varchar2
1025: ,p_keywords in varchar2 default hr_api.g_varchar2
1026: ,p_travel_percentage in number default hr_api.g_number
1027: ,p_min_salary in number default hr_api.g_number
1028: ,p_max_salary in number default hr_api.g_number
1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030: ,p_salary_period in varchar2 default hr_api.g_varchar2
1031: ,p_professional_area in varchar2 default hr_api.g_varchar2
1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2

1025: ,p_keywords in varchar2 default hr_api.g_varchar2
1026: ,p_travel_percentage in number default hr_api.g_number
1027: ,p_min_salary in number default hr_api.g_number
1028: ,p_max_salary in number default hr_api.g_number
1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030: ,p_salary_period in varchar2 default hr_api.g_varchar2
1031: ,p_professional_area in varchar2 default hr_api.g_varchar2
1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033: ,p_min_qual_level in number default hr_api.g_number

Line 1030: ,p_salary_period in varchar2 default hr_api.g_varchar2

1026: ,p_travel_percentage in number default hr_api.g_number
1027: ,p_min_salary in number default hr_api.g_number
1028: ,p_max_salary in number default hr_api.g_number
1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030: ,p_salary_period in varchar2 default hr_api.g_varchar2
1031: ,p_professional_area in varchar2 default hr_api.g_varchar2
1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033: ,p_min_qual_level in number default hr_api.g_number
1034: ,p_max_qual_level in number default hr_api.g_number

Line 1031: ,p_professional_area in varchar2 default hr_api.g_varchar2

1027: ,p_min_salary in number default hr_api.g_number
1028: ,p_max_salary in number default hr_api.g_number
1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030: ,p_salary_period in varchar2 default hr_api.g_varchar2
1031: ,p_professional_area in varchar2 default hr_api.g_varchar2
1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033: ,p_min_qual_level in number default hr_api.g_number
1034: ,p_max_qual_level in number default hr_api.g_number
1035: ,p_description in varchar2 default hr_api.g_varchar2

Line 1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1028: ,p_max_salary in number default hr_api.g_number
1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030: ,p_salary_period in varchar2 default hr_api.g_varchar2
1031: ,p_professional_area in varchar2 default hr_api.g_varchar2
1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033: ,p_min_qual_level in number default hr_api.g_number
1034: ,p_max_qual_level in number default hr_api.g_number
1035: ,p_description in varchar2 default hr_api.g_varchar2
1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1033: ,p_min_qual_level in number default hr_api.g_number

1029: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030: ,p_salary_period in varchar2 default hr_api.g_varchar2
1031: ,p_professional_area in varchar2 default hr_api.g_varchar2
1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033: ,p_min_qual_level in number default hr_api.g_number
1034: ,p_max_qual_level in number default hr_api.g_number
1035: ,p_description in varchar2 default hr_api.g_varchar2
1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1034: ,p_max_qual_level in number default hr_api.g_number

1030: ,p_salary_period in varchar2 default hr_api.g_varchar2
1031: ,p_professional_area in varchar2 default hr_api.g_varchar2
1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033: ,p_min_qual_level in number default hr_api.g_number
1034: ,p_max_qual_level in number default hr_api.g_number
1035: ,p_description in varchar2 default hr_api.g_varchar2
1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1035: ,p_description in varchar2 default hr_api.g_varchar2

1031: ,p_professional_area in varchar2 default hr_api.g_varchar2
1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033: ,p_min_qual_level in number default hr_api.g_number
1034: ,p_max_qual_level in number default hr_api.g_number
1035: ,p_description in varchar2 default hr_api.g_varchar2
1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1032: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033: ,p_min_qual_level in number default hr_api.g_number
1034: ,p_max_qual_level in number default hr_api.g_number
1035: ,p_description in varchar2 default hr_api.g_varchar2
1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1033: ,p_min_qual_level in number default hr_api.g_number
1034: ,p_max_qual_level in number default hr_api.g_number
1035: ,p_description in varchar2 default hr_api.g_varchar2
1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1034: ,p_max_qual_level in number default hr_api.g_number
1035: ,p_description in varchar2 default hr_api.g_varchar2
1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1035: ,p_description in varchar2 default hr_api.g_varchar2
1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1036: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1037: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1038: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1039: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1040: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1041: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1042: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1043: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1044: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1045: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1046: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1047: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1048: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1049: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1050: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1051: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1052: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1053: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1054: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1055: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1056: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1057: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1058: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1059: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

Line 1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1060: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

Line 1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1061: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

Line 1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1062: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

Line 1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

1063: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

Line 1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

1064: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

Line 1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

1065: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

Line 1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

1066: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

Line 1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

1067: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

Line 1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

1068: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

Line 1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

1069: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

Line 1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

1070: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

Line 1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

1071: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

Line 1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

1072: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

Line 1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

1073: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

Line 1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

1074: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

Line 1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

1075: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

Line 1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

1076: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

Line 1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

1077: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

Line 1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

1078: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

Line 1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

1079: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

Line 1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

1080: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

Line 1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

1081: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

Line 1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

1082: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

Line 1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

1083: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

Line 1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

1084: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

Line 1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

1085: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

Line 1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

1086: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

Line 1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

1087: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1095: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

Line 1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

1088: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1095: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1096: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

Line 1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

1089: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1095: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1096: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1097: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

Line 1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

1090: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1095: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1096: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1097: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1098: ,p_object_version_number in out nocopy number

Line 1095: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

1091: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1095: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1096: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1097: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1098: ,p_object_version_number in out nocopy number
1099: ,p_return_status out nocopy varchar2

Line 1096: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

1092: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1095: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1096: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1097: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1098: ,p_object_version_number in out nocopy number
1099: ,p_return_status out nocopy varchar2
1100: ) is

Line 1097: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

1093: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1095: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1096: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1097: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1098: ,p_object_version_number in out nocopy number
1099: ,p_return_status out nocopy varchar2
1100: ) is
1101: --

Line 1128: hr_api.constant_to_boolean

1124: --
1125: -- Convert constant values to their corresponding boolean value
1126: --
1127: l_validate :=
1128: hr_api.constant_to_boolean
1129: (p_constant_value => p_validate);
1130: --
1131: -- Register Surrogate ID or user key values
1132: --

Line 1274: (p_validate in number default hr_api.g_false_num

1270: -- ----------------------------------------------------------------------------
1271: -- |--------------------------< create_work_choices >-------------------------|
1272: -- ----------------------------------------------------------------------------
1273: PROCEDURE create_work_choices
1274: (p_validate in number default hr_api.g_false_num
1275: ,p_effective_date in date
1276: ,p_person_id in number
1277: ,p_location in varchar2 default null
1278: ,p_distance_to_location in varchar2 default null

Line 1392: hr_api.constant_to_boolean

1388: --
1389: -- Convert constant values to their corresponding boolean value
1390: --
1391: l_validate :=
1392: hr_api.constant_to_boolean
1393: (p_constant_value => p_validate);
1394: --
1395: -- Register Surrogate ID or user key values
1396: --

Line 1548: (p_validate in number default hr_api.g_false_num

1544: -- ----------------------------------------------------------------------------
1545: -- |--------------------------< delete_work_choices >-------------------------|
1546: -- ----------------------------------------------------------------------------
1547: PROCEDURE delete_work_choices
1548: (p_validate in number default hr_api.g_false_num
1549: ,p_search_criteria_id in number
1550: ,p_object_version_number in number
1551: ,p_return_status out nocopy varchar2
1552: ) is

Line 1578: hr_api.constant_to_boolean

1574: --
1575: -- Convert constant values to their corresponding boolean value
1576: --
1577: l_validate :=
1578: hr_api.constant_to_boolean
1579: (p_constant_value => p_validate);
1580: --
1581: -- Register Surrogate ID or user key values
1582: --

Line 1642: (p_validate in number default hr_api.g_false_num

1638: -- ----------------------------------------------------------------------------
1639: -- |--------------------------< update_work_choices >-------------------------|
1640: -- ----------------------------------------------------------------------------
1641: PROCEDURE update_work_choices
1642: (p_validate in number default hr_api.g_false_num
1643: ,p_effective_date in date
1644: ,p_search_criteria_id in number
1645: ,p_location in varchar2 default hr_api.g_varchar2
1646: ,p_distance_to_location in varchar2 default hr_api.g_varchar2

Line 1645: ,p_location in varchar2 default hr_api.g_varchar2

1641: PROCEDURE update_work_choices
1642: (p_validate in number default hr_api.g_false_num
1643: ,p_effective_date in date
1644: ,p_search_criteria_id in number
1645: ,p_location in varchar2 default hr_api.g_varchar2
1646: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1647: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649: ,p_derived_location in varchar2 default hr_api.g_varchar2

Line 1646: ,p_distance_to_location in varchar2 default hr_api.g_varchar2

1642: (p_validate in number default hr_api.g_false_num
1643: ,p_effective_date in date
1644: ,p_search_criteria_id in number
1645: ,p_location in varchar2 default hr_api.g_varchar2
1646: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1647: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649: ,p_derived_location in varchar2 default hr_api.g_varchar2
1650: ,p_location_id in number default hr_api.g_number

Line 1647: ,p_geocode_location in varchar2 default hr_api.g_varchar2

1643: ,p_effective_date in date
1644: ,p_search_criteria_id in number
1645: ,p_location in varchar2 default hr_api.g_varchar2
1646: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1647: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649: ,p_derived_location in varchar2 default hr_api.g_varchar2
1650: ,p_location_id in number default hr_api.g_number
1651: ,p_longitude in number default hr_api.g_number

Line 1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2

1644: ,p_search_criteria_id in number
1645: ,p_location in varchar2 default hr_api.g_varchar2
1646: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1647: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649: ,p_derived_location in varchar2 default hr_api.g_varchar2
1650: ,p_location_id in number default hr_api.g_number
1651: ,p_longitude in number default hr_api.g_number
1652: ,p_latitude in number default hr_api.g_number

Line 1649: ,p_derived_location in varchar2 default hr_api.g_varchar2

1645: ,p_location in varchar2 default hr_api.g_varchar2
1646: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1647: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649: ,p_derived_location in varchar2 default hr_api.g_varchar2
1650: ,p_location_id in number default hr_api.g_number
1651: ,p_longitude in number default hr_api.g_number
1652: ,p_latitude in number default hr_api.g_number
1653: ,p_employee in varchar2 default hr_api.g_varchar2

Line 1650: ,p_location_id in number default hr_api.g_number

1646: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1647: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649: ,p_derived_location in varchar2 default hr_api.g_varchar2
1650: ,p_location_id in number default hr_api.g_number
1651: ,p_longitude in number default hr_api.g_number
1652: ,p_latitude in number default hr_api.g_number
1653: ,p_employee in varchar2 default hr_api.g_varchar2
1654: ,p_contractor in varchar2 default hr_api.g_varchar2

Line 1651: ,p_longitude in number default hr_api.g_number

1647: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649: ,p_derived_location in varchar2 default hr_api.g_varchar2
1650: ,p_location_id in number default hr_api.g_number
1651: ,p_longitude in number default hr_api.g_number
1652: ,p_latitude in number default hr_api.g_number
1653: ,p_employee in varchar2 default hr_api.g_varchar2
1654: ,p_contractor in varchar2 default hr_api.g_varchar2
1655: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 1652: ,p_latitude in number default hr_api.g_number

1648: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649: ,p_derived_location in varchar2 default hr_api.g_varchar2
1650: ,p_location_id in number default hr_api.g_number
1651: ,p_longitude in number default hr_api.g_number
1652: ,p_latitude in number default hr_api.g_number
1653: ,p_employee in varchar2 default hr_api.g_varchar2
1654: ,p_contractor in varchar2 default hr_api.g_varchar2
1655: ,p_employment_category in varchar2 default hr_api.g_varchar2
1656: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 1653: ,p_employee in varchar2 default hr_api.g_varchar2

1649: ,p_derived_location in varchar2 default hr_api.g_varchar2
1650: ,p_location_id in number default hr_api.g_number
1651: ,p_longitude in number default hr_api.g_number
1652: ,p_latitude in number default hr_api.g_number
1653: ,p_employee in varchar2 default hr_api.g_varchar2
1654: ,p_contractor in varchar2 default hr_api.g_varchar2
1655: ,p_employment_category in varchar2 default hr_api.g_varchar2
1656: ,p_keywords in varchar2 default hr_api.g_varchar2
1657: ,p_travel_percentage in number default hr_api.g_number

Line 1654: ,p_contractor in varchar2 default hr_api.g_varchar2

1650: ,p_location_id in number default hr_api.g_number
1651: ,p_longitude in number default hr_api.g_number
1652: ,p_latitude in number default hr_api.g_number
1653: ,p_employee in varchar2 default hr_api.g_varchar2
1654: ,p_contractor in varchar2 default hr_api.g_varchar2
1655: ,p_employment_category in varchar2 default hr_api.g_varchar2
1656: ,p_keywords in varchar2 default hr_api.g_varchar2
1657: ,p_travel_percentage in number default hr_api.g_number
1658: ,p_min_salary in number default hr_api.g_number

Line 1655: ,p_employment_category in varchar2 default hr_api.g_varchar2

1651: ,p_longitude in number default hr_api.g_number
1652: ,p_latitude in number default hr_api.g_number
1653: ,p_employee in varchar2 default hr_api.g_varchar2
1654: ,p_contractor in varchar2 default hr_api.g_varchar2
1655: ,p_employment_category in varchar2 default hr_api.g_varchar2
1656: ,p_keywords in varchar2 default hr_api.g_varchar2
1657: ,p_travel_percentage in number default hr_api.g_number
1658: ,p_min_salary in number default hr_api.g_number
1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2

Line 1656: ,p_keywords in varchar2 default hr_api.g_varchar2

1652: ,p_latitude in number default hr_api.g_number
1653: ,p_employee in varchar2 default hr_api.g_varchar2
1654: ,p_contractor in varchar2 default hr_api.g_varchar2
1655: ,p_employment_category in varchar2 default hr_api.g_varchar2
1656: ,p_keywords in varchar2 default hr_api.g_varchar2
1657: ,p_travel_percentage in number default hr_api.g_number
1658: ,p_min_salary in number default hr_api.g_number
1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660: ,p_salary_period in varchar2 default hr_api.g_varchar2

Line 1657: ,p_travel_percentage in number default hr_api.g_number

1653: ,p_employee in varchar2 default hr_api.g_varchar2
1654: ,p_contractor in varchar2 default hr_api.g_varchar2
1655: ,p_employment_category in varchar2 default hr_api.g_varchar2
1656: ,p_keywords in varchar2 default hr_api.g_varchar2
1657: ,p_travel_percentage in number default hr_api.g_number
1658: ,p_min_salary in number default hr_api.g_number
1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660: ,p_salary_period in varchar2 default hr_api.g_varchar2
1661: ,p_match_competence in varchar2 default hr_api.g_varchar2

Line 1658: ,p_min_salary in number default hr_api.g_number

1654: ,p_contractor in varchar2 default hr_api.g_varchar2
1655: ,p_employment_category in varchar2 default hr_api.g_varchar2
1656: ,p_keywords in varchar2 default hr_api.g_varchar2
1657: ,p_travel_percentage in number default hr_api.g_number
1658: ,p_min_salary in number default hr_api.g_number
1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660: ,p_salary_period in varchar2 default hr_api.g_varchar2
1661: ,p_match_competence in varchar2 default hr_api.g_varchar2
1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2

Line 1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2

1655: ,p_employment_category in varchar2 default hr_api.g_varchar2
1656: ,p_keywords in varchar2 default hr_api.g_varchar2
1657: ,p_travel_percentage in number default hr_api.g_number
1658: ,p_min_salary in number default hr_api.g_number
1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660: ,p_salary_period in varchar2 default hr_api.g_varchar2
1661: ,p_match_competence in varchar2 default hr_api.g_varchar2
1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 1660: ,p_salary_period in varchar2 default hr_api.g_varchar2

1656: ,p_keywords in varchar2 default hr_api.g_varchar2
1657: ,p_travel_percentage in number default hr_api.g_number
1658: ,p_min_salary in number default hr_api.g_number
1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660: ,p_salary_period in varchar2 default hr_api.g_varchar2
1661: ,p_match_competence in varchar2 default hr_api.g_varchar2
1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664: ,p_job_title in varchar2 default hr_api.g_varchar2

Line 1661: ,p_match_competence in varchar2 default hr_api.g_varchar2

1657: ,p_travel_percentage in number default hr_api.g_number
1658: ,p_min_salary in number default hr_api.g_number
1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660: ,p_salary_period in varchar2 default hr_api.g_varchar2
1661: ,p_match_competence in varchar2 default hr_api.g_varchar2
1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664: ,p_job_title in varchar2 default hr_api.g_varchar2
1665: ,p_department in varchar2 default hr_api.g_varchar2

Line 1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2

1658: ,p_min_salary in number default hr_api.g_number
1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660: ,p_salary_period in varchar2 default hr_api.g_varchar2
1661: ,p_match_competence in varchar2 default hr_api.g_varchar2
1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664: ,p_job_title in varchar2 default hr_api.g_varchar2
1665: ,p_department in varchar2 default hr_api.g_varchar2
1666: ,p_professional_area in varchar2 default hr_api.g_varchar2

Line 1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1659: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660: ,p_salary_period in varchar2 default hr_api.g_varchar2
1661: ,p_match_competence in varchar2 default hr_api.g_varchar2
1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664: ,p_job_title in varchar2 default hr_api.g_varchar2
1665: ,p_department in varchar2 default hr_api.g_varchar2
1666: ,p_professional_area in varchar2 default hr_api.g_varchar2
1667: ,p_description in varchar2 default hr_api.g_varchar2

Line 1664: ,p_job_title in varchar2 default hr_api.g_varchar2

1660: ,p_salary_period in varchar2 default hr_api.g_varchar2
1661: ,p_match_competence in varchar2 default hr_api.g_varchar2
1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664: ,p_job_title in varchar2 default hr_api.g_varchar2
1665: ,p_department in varchar2 default hr_api.g_varchar2
1666: ,p_professional_area in varchar2 default hr_api.g_varchar2
1667: ,p_description in varchar2 default hr_api.g_varchar2
1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1665: ,p_department in varchar2 default hr_api.g_varchar2

1661: ,p_match_competence in varchar2 default hr_api.g_varchar2
1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664: ,p_job_title in varchar2 default hr_api.g_varchar2
1665: ,p_department in varchar2 default hr_api.g_varchar2
1666: ,p_professional_area in varchar2 default hr_api.g_varchar2
1667: ,p_description in varchar2 default hr_api.g_varchar2
1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1666: ,p_professional_area in varchar2 default hr_api.g_varchar2

1662: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664: ,p_job_title in varchar2 default hr_api.g_varchar2
1665: ,p_department in varchar2 default hr_api.g_varchar2
1666: ,p_professional_area in varchar2 default hr_api.g_varchar2
1667: ,p_description in varchar2 default hr_api.g_varchar2
1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1667: ,p_description in varchar2 default hr_api.g_varchar2

1663: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664: ,p_job_title in varchar2 default hr_api.g_varchar2
1665: ,p_department in varchar2 default hr_api.g_varchar2
1666: ,p_professional_area in varchar2 default hr_api.g_varchar2
1667: ,p_description in varchar2 default hr_api.g_varchar2
1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1664: ,p_job_title in varchar2 default hr_api.g_varchar2
1665: ,p_department in varchar2 default hr_api.g_varchar2
1666: ,p_professional_area in varchar2 default hr_api.g_varchar2
1667: ,p_description in varchar2 default hr_api.g_varchar2
1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1665: ,p_department in varchar2 default hr_api.g_varchar2
1666: ,p_professional_area in varchar2 default hr_api.g_varchar2
1667: ,p_description in varchar2 default hr_api.g_varchar2
1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1666: ,p_professional_area in varchar2 default hr_api.g_varchar2
1667: ,p_description in varchar2 default hr_api.g_varchar2
1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1667: ,p_description in varchar2 default hr_api.g_varchar2
1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1668: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1669: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1670: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1671: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1672: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1673: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1674: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1675: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1676: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1677: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1678: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1679: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1680: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1681: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1682: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1683: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1684: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1685: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1686: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1687: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1688: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1689: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1690: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1691: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

Line 1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1692: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

Line 1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1693: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

Line 1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1694: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

Line 1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

1695: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

Line 1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

1696: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

Line 1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

1697: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

Line 1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

1698: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

Line 1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

1699: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

Line 1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

1700: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

Line 1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

1701: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

Line 1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

1702: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

Line 1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

1703: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

Line 1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

1704: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

Line 1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

1705: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

Line 1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

1706: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

Line 1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

1707: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

Line 1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

1708: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

Line 1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

1709: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

Line 1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

1710: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

Line 1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

1711: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

Line 1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

1712: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

Line 1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

1713: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

Line 1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

1714: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

Line 1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

1715: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

Line 1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

1716: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

Line 1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

1717: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

Line 1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

1718: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

Line 1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

1719: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1727: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

Line 1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

1720: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1727: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1728: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

Line 1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

1721: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1727: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1728: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1729: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

Line 1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

1722: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1727: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1728: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1729: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1730: ,p_object_version_number in out nocopy number

Line 1727: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

1723: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1727: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1728: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1729: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1730: ,p_object_version_number in out nocopy number
1731: ,p_return_status out nocopy varchar2

Line 1728: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

1724: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1727: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1728: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1729: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1730: ,p_object_version_number in out nocopy number
1731: ,p_return_status out nocopy varchar2
1732: ) is

Line 1729: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

1725: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1727: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1728: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1729: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1730: ,p_object_version_number in out nocopy number
1731: ,p_return_status out nocopy varchar2
1732: ) is
1733: --

Line 1760: hr_api.constant_to_boolean

1756: --
1757: -- Convert constant values to their corresponding boolean value
1758: --
1759: l_validate :=
1760: hr_api.constant_to_boolean
1761: (p_constant_value => p_validate);
1762: --
1763: -- Register Surrogate ID or user key values
1764: --

Line 1917: ,p_validate in number default hr_api.g_false_num

1913: procedure process_vacancy_api
1914: (
1915: p_document in CLOB
1916: ,p_return_status out nocopy VARCHAR2
1917: ,p_validate in number default hr_api.g_false_num
1918: ,p_effective_date in date default null
1919: )
1920: IS
1921: l_postState VARCHAR2(2);