8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_accommodation >-------------------------|
10: -- ----------------------------------------------------------------------------
11: PROCEDURE create_accommodation
12: (p_validate in number default hr_api.g_false_num
13: ,p_effective_date in date
14: ,p_accommodation_name in varchar2
15: ,p_business_group_id in number
16: ,p_location_id in number
131: --
132: -- Convert constant values to their corresponding boolean value
133: --
134: l_validate :=
135: hr_api.constant_to_boolean
136: (p_constant_value => p_validate);
137: --
138: -- Register Surrogate ID or user key values
139: --
296: -- ----------------------------------------------------------------------------
297: -- |-------------------------< delete_accommodation >-------------------------|
298: -- ----------------------------------------------------------------------------
299: PROCEDURE delete_accommodation
300: (p_validate in number default hr_api.g_false_num
301: ,p_effective_date in date
302: ,p_datetrack_mode in varchar2
303: ,p_accommodation_id in number
304: ,p_object_version_number in out nocopy number
332: --
333: -- Convert constant values to their corresponding boolean value
334: --
335: l_validate :=
336: hr_api.constant_to_boolean
337: (p_constant_value => p_validate);
338: --
339: -- Register Surrogate ID or user key values
340: --
406: -- ----------------------------------------------------------------------------
407: -- |-------------------------< update_accommodation >-------------------------|
408: -- ----------------------------------------------------------------------------
409: PROCEDURE update_accommodation
410: (p_validate in number default hr_api.g_false_num
411: ,p_effective_date in date
412: ,p_datetrack_mode in varchar2
413: ,p_accommodation_id in number
414: ,p_object_version_number in out nocopy number
411: ,p_effective_date in date
412: ,p_datetrack_mode in varchar2
413: ,p_accommodation_id in number
414: ,p_object_version_number in out nocopy number
415: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
416: ,p_business_group_id in number default hr_api.g_number
417: ,p_location_id in number default hr_api.g_number
418: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
412: ,p_datetrack_mode in varchar2
413: ,p_accommodation_id in number
414: ,p_object_version_number in out nocopy number
415: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
416: ,p_business_group_id in number default hr_api.g_number
417: ,p_location_id in number default hr_api.g_number
418: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
413: ,p_accommodation_id in number
414: ,p_object_version_number in out nocopy number
415: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
416: ,p_business_group_id in number default hr_api.g_number
417: ,p_location_id in number default hr_api.g_number
418: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
414: ,p_object_version_number in out nocopy number
415: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
416: ,p_business_group_id in number default hr_api.g_number
417: ,p_location_id in number default hr_api.g_number
418: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
415: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
416: ,p_business_group_id in number default hr_api.g_number
417: ,p_location_id in number default hr_api.g_number
418: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
416: ,p_business_group_id in number default hr_api.g_number
417: ,p_location_id in number default hr_api.g_number
418: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
417: ,p_location_id in number default hr_api.g_number
418: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
418: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
419: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
420: ,p_style in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
421: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
422: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
423: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
424: ,p_town_or_city in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
425: ,p_country in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
426: ,p_postal_code in varchar2 default hr_api.g_varchar2
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
427: ,p_region_1 in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
428: ,p_region_2 in varchar2 default hr_api.g_varchar2
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
429: ,p_region_3 in varchar2 default hr_api.g_varchar2
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
437: ,p_family_size in number default hr_api.g_number
430: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
437: ,p_family_size in number default hr_api.g_number
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
431: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
437: ,p_family_size in number default hr_api.g_number
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
432: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
437: ,p_family_size in number default hr_api.g_number
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
433: ,p_floor_number in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
437: ,p_family_size in number default hr_api.g_number
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
434: ,p_floor_area in number default hr_api.g_number
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
437: ,p_family_size in number default hr_api.g_number
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
435: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
437: ,p_family_size in number default hr_api.g_number
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
436: ,p_main_rooms in number default hr_api.g_number
437: ,p_family_size in number default hr_api.g_number
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
437: ,p_family_size in number default hr_api.g_number
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
438: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
439: ,p_rental_value in number default hr_api.g_number
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
440: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
441: ,p_owner in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
442: ,p_comments in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
443: ,p_information_category in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
444: ,p_information1 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
445: ,p_information2 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
446: ,p_information3 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
447: ,p_information4 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
448: ,p_information5 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
449: ,p_information6 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
450: ,p_information7 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
451: ,p_information8 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
452: ,p_information9 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
453: ,p_information10 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
454: ,p_information11 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
455: ,p_information12 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
456: ,p_information13 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
457: ,p_information14 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
458: ,p_information15 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
459: ,p_information16 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
460: ,p_information17 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
461: ,p_information18 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
462: ,p_information19 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
463: ,p_information20 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
464: ,p_information21 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
465: ,p_information22 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
466: ,p_information23 in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
467: ,p_information24 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
468: ,p_information25 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
469: ,p_information26 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
470: ,p_information27 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
471: ,p_information28 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
472: ,p_information29 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
473: ,p_information30 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
474: ,p_attribute_category in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
475: ,p_attribute1 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
476: ,p_attribute2 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
477: ,p_attribute3 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
478: ,p_attribute4 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
479: ,p_attribute5 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
480: ,p_attribute6 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
481: ,p_attribute7 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
482: ,p_attribute8 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
483: ,p_attribute9 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
484: ,p_attribute10 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
485: ,p_attribute11 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
486: ,p_attribute12 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
487: ,p_attribute13 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
488: ,p_attribute14 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
489: ,p_attribute15 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
490: ,p_attribute16 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
491: ,p_attribute17 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
492: ,p_attribute18 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
493: ,p_attribute19 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
501: ,p_attribute27 in varchar2 default hr_api.g_varchar2
494: ,p_attribute20 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
501: ,p_attribute27 in varchar2 default hr_api.g_varchar2
502: ,p_attribute28 in varchar2 default hr_api.g_varchar2
495: ,p_attribute21 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
501: ,p_attribute27 in varchar2 default hr_api.g_varchar2
502: ,p_attribute28 in varchar2 default hr_api.g_varchar2
503: ,p_attribute29 in varchar2 default hr_api.g_varchar2
496: ,p_attribute22 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
501: ,p_attribute27 in varchar2 default hr_api.g_varchar2
502: ,p_attribute28 in varchar2 default hr_api.g_varchar2
503: ,p_attribute29 in varchar2 default hr_api.g_varchar2
504: ,p_attribute30 in varchar2 default hr_api.g_varchar2
497: ,p_attribute23 in varchar2 default hr_api.g_varchar2
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
501: ,p_attribute27 in varchar2 default hr_api.g_varchar2
502: ,p_attribute28 in varchar2 default hr_api.g_varchar2
503: ,p_attribute29 in varchar2 default hr_api.g_varchar2
504: ,p_attribute30 in varchar2 default hr_api.g_varchar2
505: ,p_effective_start_date out nocopy date
498: ,p_attribute24 in varchar2 default hr_api.g_varchar2
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
501: ,p_attribute27 in varchar2 default hr_api.g_varchar2
502: ,p_attribute28 in varchar2 default hr_api.g_varchar2
503: ,p_attribute29 in varchar2 default hr_api.g_varchar2
504: ,p_attribute30 in varchar2 default hr_api.g_varchar2
505: ,p_effective_start_date out nocopy date
506: ,p_effective_end_date out nocopy date
499: ,p_attribute25 in varchar2 default hr_api.g_varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
501: ,p_attribute27 in varchar2 default hr_api.g_varchar2
502: ,p_attribute28 in varchar2 default hr_api.g_varchar2
503: ,p_attribute29 in varchar2 default hr_api.g_varchar2
504: ,p_attribute30 in varchar2 default hr_api.g_varchar2
505: ,p_effective_start_date out nocopy date
506: ,p_effective_end_date out nocopy date
507: ,p_return_status out nocopy varchar2
500: ,p_attribute26 in varchar2 default hr_api.g_varchar2
501: ,p_attribute27 in varchar2 default hr_api.g_varchar2
502: ,p_attribute28 in varchar2 default hr_api.g_varchar2
503: ,p_attribute29 in varchar2 default hr_api.g_varchar2
504: ,p_attribute30 in varchar2 default hr_api.g_varchar2
505: ,p_effective_start_date out nocopy date
506: ,p_effective_end_date out nocopy date
507: ,p_return_status out nocopy varchar2
508: ) is
532: --
533: -- Convert constant values to their corresponding boolean value
534: --
535: l_validate :=
536: hr_api.constant_to_boolean
537: (p_constant_value => p_validate);
538: --
539: -- Register Surrogate ID or user key values
540: --