33: * applicable during the start to end active date range. This date does not
34: * determine when the changes take effect.
35: * @param p_language_code Specifies to which language the translation values
36: * apply. You can set to the base or any installed language. The default value
37: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
38: * value.
39: * @param p_location_code Unique name of the location
40: * @param p_description Description of the location
41: * @param p_timezone_code Time zone of the location.
188: --
189: PROCEDURE create_location
190: ( p_validate IN BOOLEAN DEFAULT false
191: ,p_effective_date IN DATE
192: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
193: ,p_location_code IN VARCHAR2
194: ,p_description IN VARCHAR2 DEFAULT NULL
195: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
196: ,p_tp_header_id IN NUMBER DEFAULT NULL
299: * applicable during the start to end active date range. This date does not
300: * determine when the changes take effect.
301: * @param p_language_code Specifies to which language the translation values
302: * apply. You can set to the base or any installed language. The default value
303: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
304: * value.
305: * @param p_location_id Uniquely identifies the location to be updated.
306: * @param p_location_code Unique name of the location
307: * @param p_description Description of the location
450: --
451: PROCEDURE update_location
452: ( p_validate IN BOOLEAN DEFAULT false
453: ,p_effective_date IN DATE
454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
452: ( p_validate IN BOOLEAN DEFAULT false
453: ,p_effective_date IN DATE
454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
453: ,p_effective_date IN DATE
454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_object_version_number IN OUT NOCOPY NUMBER
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_object_version_number IN OUT NOCOPY NUMBER
536: );
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_object_version_number IN OUT NOCOPY NUMBER
536: );
537: --
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_object_version_number IN OUT NOCOPY NUMBER
536: );
537: --
538: -- ----------------------------------------------------------------------------
677: --
678: PROCEDURE create_location_legal_adr
679: ( p_validate IN BOOLEAN DEFAULT false
680: ,p_effective_date IN DATE
681: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
682: ,p_location_code IN VARCHAR2
683: ,p_description IN VARCHAR2 DEFAULT NULL
684: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
685: ,p_address_line_1 IN VARCHAR2 DEFAULT NULL
814: PROCEDURE update_location_legal_adr
815: ( p_validate IN BOOLEAN DEFAULT false
816: ,p_effective_date IN DATE
817: ,p_location_id IN NUMBER
818: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
819: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
820: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
821: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
815: ( p_validate IN BOOLEAN DEFAULT false
816: ,p_effective_date IN DATE
817: ,p_location_id IN NUMBER
818: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
819: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
820: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
821: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
816: ,p_effective_date IN DATE
817: ,p_location_id IN NUMBER
818: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
819: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
820: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
821: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
817: ,p_location_id IN NUMBER
818: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
819: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
820: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
821: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
818: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
819: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
820: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
821: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
819: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
820: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
821: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
820: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
821: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
821: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
822: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
823: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
824: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
825: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
826: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
827: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
828: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
829: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
830: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
831: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
832: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
833: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
834: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
835: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
836: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
837: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
838: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
839: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
847: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
840: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
847: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
848: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
841: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
847: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
848: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
849: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
842: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
847: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
848: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
849: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
850: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
843: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
847: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
848: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
849: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
850: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
851: ,p_object_version_number IN OUT NOCOPY NUMBER
844: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
847: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
848: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
849: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
850: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
851: ,p_object_version_number IN OUT NOCOPY NUMBER
852: );
845: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
847: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
848: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
849: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
850: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
851: ,p_object_version_number IN OUT NOCOPY NUMBER
852: );
853: --
846: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
847: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
848: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
849: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
850: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
851: ,p_object_version_number IN OUT NOCOPY NUMBER
852: );
853: --
854: --------------------------------------------------------------------------------