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

APPS.PQH_ACCOMMODATIONS_API dependencies on HR_API

Line 229: when hr_api.cannot_find_prog_unit then

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

Line 230: hr_api.cannot_find_prog_unit_error

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;

Line 445: when hr_api.cannot_find_prog_unit then

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

Line 446: hr_api.cannot_find_prog_unit_error

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;

Line 455: raise hr_api.validate_enabled;

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

Line 467: when hr_api.validate_enabled then

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

Line 508: ,p_accommodation_name in varchar2 default hr_api.g_varchar2

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

Line 509: ,p_business_group_id in number default hr_api.g_number

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

Line 510: ,p_location_id in number default hr_api.g_number

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

Line 511: ,p_accommodation_desc 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

Line 512: ,p_accommodation_type 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

Line 513: ,p_style 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

Line 514: ,p_address_line_1 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

Line 515: ,p_address_line_2 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

Line 516: ,p_address_line_3 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

Line 517: ,p_town_or_city 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

Line 518: ,p_country 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

Line 519: ,p_postal_code 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

Line 520: ,p_region_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

Line 521: ,p_region_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

Line 522: ,p_region_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

Line 523: ,p_telephone_number_1 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

Line 524: ,p_telephone_number_2 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
528: ,p_floor_area_measure_unit in varchar2 default hr_api.g_varchar2

Line 525: ,p_telephone_number_3 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

Line 526: ,p_floor_number 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
530: ,p_family_size in number default hr_api.g_number

Line 527: ,p_floor_area 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

Line 528: ,p_floor_area_measure_unit 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

Line 529: ,p_main_rooms 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

Line 530: ,p_family_size in number default hr_api.g_number

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

Line 531: ,p_suitability_disabled 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

Line 532: ,p_rental_value 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
536: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 533: ,p_rental_value_currency 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

Line 534: ,p_owner 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

Line 535: ,p_comments 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

Line 536: ,p_information_category 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

Line 537: ,p_information1 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

Line 538: ,p_information2 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

Line 539: ,p_information3 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

Line 540: ,p_information4 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

Line 541: ,p_information5 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

Line 542: ,p_information6 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

Line 543: ,p_information7 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

Line 544: ,p_information8 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

Line 545: ,p_information9 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

Line 546: ,p_information10 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

Line 547: ,p_information11 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

Line 548: ,p_information12 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

Line 549: ,p_information13 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

Line 550: ,p_information14 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

Line 551: ,p_information15 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

Line 552: ,p_information16 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

Line 553: ,p_information17 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

Line 554: ,p_information18 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

Line 555: ,p_information19 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

Line 556: ,p_information20 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

Line 557: ,p_information21 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

Line 558: ,p_information22 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

Line 559: ,p_information23 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

Line 560: ,p_information24 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

Line 561: ,p_information25 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

Line 562: ,p_information26 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

Line 563: ,p_information27 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

Line 564: ,p_information28 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

Line 565: ,p_information29 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

Line 566: ,p_information30 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

Line 567: ,p_attribute_category 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

Line 568: ,p_attribute1 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

Line 569: ,p_attribute2 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

Line 570: ,p_attribute3 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

Line 571: ,p_attribute4 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

Line 572: ,p_attribute5 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

Line 573: ,p_attribute6 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

Line 574: ,p_attribute7 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

Line 575: ,p_attribute8 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

Line 576: ,p_attribute9 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

Line 577: ,p_attribute10 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

Line 578: ,p_attribute11 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

Line 579: ,p_attribute12 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

Line 580: ,p_attribute13 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

Line 581: ,p_attribute14 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

Line 582: ,p_attribute15 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

Line 583: ,p_attribute16 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

Line 584: ,p_attribute17 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

Line 585: ,p_attribute18 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

Line 586: ,p_attribute19 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

Line 587: ,p_attribute20 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

Line 588: ,p_attribute21 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

Line 589: ,p_attribute22 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

Line 590: ,p_attribute23 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

Line 591: ,p_attribute24 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

Line 592: ,p_attribute25 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

Line 593: ,p_attribute26 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

Line 594: ,p_attribute27 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

Line 595: ,p_attribute28 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
599: ,p_effective_end_date out nocopy date

Line 596: ,p_attribute29 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
600: ) is

Line 597: ,p_attribute30 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
601: --

Line 722: when hr_api.cannot_find_prog_unit then

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

Line 723: hr_api.cannot_find_prog_unit_error

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;

Line 940: when hr_api.cannot_find_prog_unit then

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

Line 941: hr_api.cannot_find_prog_unit_error

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;

Line 950: raise hr_api.validate_enabled;

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

Line 961: when hr_api.validate_enabled then

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

Line 1035: when hr_api.cannot_find_prog_unit then

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

Line 1036: hr_api.cannot_find_prog_unit_error

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;

Line 1073: when hr_api.cannot_find_prog_unit then

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

Line 1074: hr_api.cannot_find_prog_unit_error

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;

Line 1083: raise hr_api.validate_enabled;

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;

Line 1093: when hr_api.validate_enabled then

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