225: ,p_attribute29 => p_attribute29
226: ,p_attribute30 => p_attribute30
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'CREATE_ACCOMMODATION'
232: ,p_hook_type => 'BP'
233: );
226: ,p_attribute30 => p_attribute30
227: );
228: exception
229: when hr_api.cannot_find_prog_unit then
230: hr_api.cannot_find_prog_unit_error
231: (p_module_name => 'CREATE_ACCOMMODATION'
232: ,p_hook_type => 'BP'
233: );
234: end;
441: ,p_effective_start_date => l_effective_start_date
442: ,p_effective_end_date => l_effective_end_date
443: );
444: exception
445: when hr_api.cannot_find_prog_unit then
446: hr_api.cannot_find_prog_unit_error
447: (p_module_name => 'CREATE_ACCOMMODATION'
448: ,p_hook_type => 'AP'
449: );
442: ,p_effective_end_date => l_effective_end_date
443: );
444: exception
445: when hr_api.cannot_find_prog_unit then
446: hr_api.cannot_find_prog_unit_error
447: (p_module_name => 'CREATE_ACCOMMODATION'
448: ,p_hook_type => 'AP'
449: );
450: end;
451: --
452: -- When in validation only mode raise the Validate_Enabled exception
453: --
454: if p_validate then
455: raise hr_api.validate_enabled;
456: end if;
457: --
458: -- Set all output arguments
459: --
463: p_effective_end_date := l_effective_end_date;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: exception
467: when hr_api.validate_enabled then
468: --
469: -- As the Validate_Enabled exception has been raised
470: -- we must rollback to the savepoint
471: --
504: ,p_effective_date in date
505: ,p_datetrack_mode in varchar2
506: ,p_accommodation_id in number
507: ,p_object_version_number in out nocopy number
508: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
509: ,p_business_group_id in number default hr_api.g_number
510: ,p_location_id in number default hr_api.g_number
511: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
505: ,p_datetrack_mode in varchar2
506: ,p_accommodation_id in number
507: ,p_object_version_number in out nocopy number
508: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
509: ,p_business_group_id in number default hr_api.g_number
510: ,p_location_id in number default hr_api.g_number
511: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
506: ,p_accommodation_id in number
507: ,p_object_version_number in out nocopy number
508: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
509: ,p_business_group_id in number default hr_api.g_number
510: ,p_location_id in number default hr_api.g_number
511: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
507: ,p_object_version_number in out nocopy number
508: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
509: ,p_business_group_id in number default hr_api.g_number
510: ,p_location_id in number default hr_api.g_number
511: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
508: ,p_accommodation_name in varchar2 default hr_api.g_varchar2
509: ,p_business_group_id in number default hr_api.g_number
510: ,p_location_id in number default hr_api.g_number
511: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
509: ,p_business_group_id in number default hr_api.g_number
510: ,p_location_id in number default hr_api.g_number
511: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
510: ,p_location_id in number default hr_api.g_number
511: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
511: ,p_accommodation_desc in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
512: ,p_accommodation_type in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
513: ,p_style in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
514: ,p_address_line_1 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
515: ,p_address_line_2 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
516: ,p_address_line_3 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
517: ,p_town_or_city in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
518: ,p_country in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
519: ,p_postal_code in varchar2 default hr_api.g_varchar2
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
520: ,p_region_1 in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
521: ,p_region_2 in varchar2 default hr_api.g_varchar2
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
522: ,p_region_3 in varchar2 default hr_api.g_varchar2
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
530: ,p_family_size in number default hr_api.g_number
523: ,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
530: ,p_family_size in number default hr_api.g_number
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
524: ,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
530: ,p_family_size in number default hr_api.g_number
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
525: ,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
530: ,p_family_size in number default hr_api.g_number
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
526: ,p_floor_number in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
530: ,p_family_size in number default hr_api.g_number
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
527: ,p_floor_area in number default hr_api.g_number
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
530: ,p_family_size in number default hr_api.g_number
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
530: ,p_family_size in number default hr_api.g_number
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
529: ,p_main_rooms in number default hr_api.g_number
530: ,p_family_size in number default hr_api.g_number
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
530: ,p_family_size in number default hr_api.g_number
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
531: ,p_suitability_disabled in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
532: ,p_rental_value in number default hr_api.g_number
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
533: ,p_rental_value_currency in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
534: ,p_owner in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
535: ,p_comments in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
536: ,p_information_category in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
537: ,p_information1 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
538: ,p_information2 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
539: ,p_information3 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
540: ,p_information4 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
541: ,p_information5 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
542: ,p_information6 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
543: ,p_information7 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
544: ,p_information8 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
545: ,p_information9 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
546: ,p_information10 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
547: ,p_information11 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
548: ,p_information12 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
549: ,p_information13 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
550: ,p_information14 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
551: ,p_information15 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
552: ,p_information16 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
553: ,p_information17 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
554: ,p_information18 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
555: ,p_information19 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
556: ,p_information20 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
557: ,p_information21 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
558: ,p_information22 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
559: ,p_information23 in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
560: ,p_information24 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
561: ,p_information25 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
562: ,p_information26 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
563: ,p_information27 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
564: ,p_information28 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
565: ,p_information29 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
566: ,p_information30 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
567: ,p_attribute_category in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
568: ,p_attribute1 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
569: ,p_attribute2 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
570: ,p_attribute3 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
571: ,p_attribute4 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
572: ,p_attribute5 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
573: ,p_attribute6 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
574: ,p_attribute7 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
575: ,p_attribute8 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
576: ,p_attribute9 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
577: ,p_attribute10 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
578: ,p_attribute11 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
579: ,p_attribute12 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
580: ,p_attribute13 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
581: ,p_attribute14 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
582: ,p_attribute15 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
583: ,p_attribute16 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
584: ,p_attribute17 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
585: ,p_attribute18 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
586: ,p_attribute19 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
594: ,p_attribute27 in varchar2 default hr_api.g_varchar2
587: ,p_attribute20 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
594: ,p_attribute27 in varchar2 default hr_api.g_varchar2
595: ,p_attribute28 in varchar2 default hr_api.g_varchar2
588: ,p_attribute21 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
594: ,p_attribute27 in varchar2 default hr_api.g_varchar2
595: ,p_attribute28 in varchar2 default hr_api.g_varchar2
596: ,p_attribute29 in varchar2 default hr_api.g_varchar2
589: ,p_attribute22 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
594: ,p_attribute27 in varchar2 default hr_api.g_varchar2
595: ,p_attribute28 in varchar2 default hr_api.g_varchar2
596: ,p_attribute29 in varchar2 default hr_api.g_varchar2
597: ,p_attribute30 in varchar2 default hr_api.g_varchar2
590: ,p_attribute23 in varchar2 default hr_api.g_varchar2
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
594: ,p_attribute27 in varchar2 default hr_api.g_varchar2
595: ,p_attribute28 in varchar2 default hr_api.g_varchar2
596: ,p_attribute29 in varchar2 default hr_api.g_varchar2
597: ,p_attribute30 in varchar2 default hr_api.g_varchar2
598: ,p_effective_start_date out nocopy date
591: ,p_attribute24 in varchar2 default hr_api.g_varchar2
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
594: ,p_attribute27 in varchar2 default hr_api.g_varchar2
595: ,p_attribute28 in varchar2 default hr_api.g_varchar2
596: ,p_attribute29 in varchar2 default hr_api.g_varchar2
597: ,p_attribute30 in varchar2 default hr_api.g_varchar2
598: ,p_effective_start_date out nocopy date
599: ,p_effective_end_date out nocopy date
592: ,p_attribute25 in varchar2 default hr_api.g_varchar2
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
594: ,p_attribute27 in varchar2 default hr_api.g_varchar2
595: ,p_attribute28 in varchar2 default hr_api.g_varchar2
596: ,p_attribute29 in varchar2 default hr_api.g_varchar2
597: ,p_attribute30 in varchar2 default hr_api.g_varchar2
598: ,p_effective_start_date out nocopy date
599: ,p_effective_end_date out nocopy date
600: ) is
593: ,p_attribute26 in varchar2 default hr_api.g_varchar2
594: ,p_attribute27 in varchar2 default hr_api.g_varchar2
595: ,p_attribute28 in varchar2 default hr_api.g_varchar2
596: ,p_attribute29 in varchar2 default hr_api.g_varchar2
597: ,p_attribute30 in varchar2 default hr_api.g_varchar2
598: ,p_effective_start_date out nocopy date
599: ,p_effective_end_date out nocopy date
600: ) is
601: --
718: ,p_attribute29 => p_attribute29
719: ,p_attribute30 => p_attribute30
720: );
721: exception
722: when hr_api.cannot_find_prog_unit then
723: hr_api.cannot_find_prog_unit_error
724: (p_module_name => 'UPDATE_ACCOMMODATION'
725: ,p_hook_type => 'BP'
726: );
719: ,p_attribute30 => p_attribute30
720: );
721: exception
722: when hr_api.cannot_find_prog_unit then
723: hr_api.cannot_find_prog_unit_error
724: (p_module_name => 'UPDATE_ACCOMMODATION'
725: ,p_hook_type => 'BP'
726: );
727: end;
936: ,p_effective_start_date => l_effective_start_date
937: ,p_effective_end_date => l_effective_end_date
938: );
939: exception
940: when hr_api.cannot_find_prog_unit then
941: hr_api.cannot_find_prog_unit_error
942: (p_module_name => 'UPDATE_ACCOMMODATION'
943: ,p_hook_type => 'AP'
944: );
937: ,p_effective_end_date => l_effective_end_date
938: );
939: exception
940: when hr_api.cannot_find_prog_unit then
941: hr_api.cannot_find_prog_unit_error
942: (p_module_name => 'UPDATE_ACCOMMODATION'
943: ,p_hook_type => 'AP'
944: );
945: end;
946: --
947: -- When in validation only mode raise the Validate_Enabled exception
948: --
949: if p_validate then
950: raise hr_api.validate_enabled;
951: end if;
952: --
953: -- Set all output arguments
954: --
957: p_effective_end_date := l_effective_end_date;
958: --
959: hr_utility.set_location(' Leaving:'||l_proc, 70);
960: exception
961: when hr_api.validate_enabled then
962: --
963: -- As the Validate_Enabled exception has been raised
964: -- we must rollback to the savepoint
965: --
1031: ,p_accommodation_id => p_accommodation_id
1032: ,p_object_version_number => p_object_version_number
1033: );
1034: exception
1035: when hr_api.cannot_find_prog_unit then
1036: hr_api.cannot_find_prog_unit_error
1037: (p_module_name => 'DELETE_ACCOMMODATION'
1038: ,p_hook_type => 'BP'
1039: );
1032: ,p_object_version_number => p_object_version_number
1033: );
1034: exception
1035: when hr_api.cannot_find_prog_unit then
1036: hr_api.cannot_find_prog_unit_error
1037: (p_module_name => 'DELETE_ACCOMMODATION'
1038: ,p_hook_type => 'BP'
1039: );
1040: end;
1069: ,p_effective_start_date => l_effective_start_date
1070: ,p_effective_end_date => l_effective_end_date
1071: );
1072: exception
1073: when hr_api.cannot_find_prog_unit then
1074: hr_api.cannot_find_prog_unit_error
1075: (p_module_name => 'DELETE_ACCOMMODATION'
1076: ,p_hook_type => 'AP'
1077: );
1070: ,p_effective_end_date => l_effective_end_date
1071: );
1072: exception
1073: when hr_api.cannot_find_prog_unit then
1074: hr_api.cannot_find_prog_unit_error
1075: (p_module_name => 'DELETE_ACCOMMODATION'
1076: ,p_hook_type => 'AP'
1077: );
1078: end;
1079: --
1080: -- When in validation only mode raise the Validate_Enabled exception
1081: --
1082: if p_validate then
1083: raise hr_api.validate_enabled;
1084: end if;
1085: --
1086: p_object_version_number := p_object_version_number;
1087: p_effective_start_date := l_effective_start_date;
1089: --
1090: --
1091: hr_utility.set_location(' Leaving:'||l_proc, 70);
1092: exception
1093: when hr_api.validate_enabled then
1094: --
1095: -- As the Validate_Enabled exception has been raised
1096: -- we must rollback to the savepoint
1097: --