[Home] [Help]
16: --
17: PROCEDURE create_location
18: ( p_validate IN BOOLEAN DEFAULT false
19: ,p_effective_date IN DATE
20: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
21: ,p_location_code IN VARCHAR2
22: ,p_description IN VARCHAR2 DEFAULT NULL
23: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
24: ,p_tp_header_id IN NUMBER DEFAULT NULL
130: -- instead of p_language_code from now on, to allow an IN OUT parameter to
131: -- be passed through.
132: --
133: l_language_code := p_language_code;
134: hr_api.validate_language_code(p_language_code => l_language_code);
135: --
136: hr_utility.set_location(l_proc, 20);
137: --
138: BEGIN
224: ,p_global_attribute20 => p_global_attribute20
225: ,p_business_group_id => p_business_group_id
226: );
227: EXCEPTION
228: WHEN hr_api.cannot_find_prog_unit THEN
229: hr_api.cannot_find_prog_unit_error
230: ( p_module_name => 'CREATE_LOCATION'
231: ,p_hook_type => 'BP'
232: );
225: ,p_business_group_id => p_business_group_id
226: );
227: EXCEPTION
228: WHEN hr_api.cannot_find_prog_unit THEN
229: hr_api.cannot_find_prog_unit_error
230: ( p_module_name => 'CREATE_LOCATION'
231: ,p_hook_type => 'BP'
232: );
233: --
421: ,p_location_id => l_location_id
422: ,p_object_version_number => l_object_version_number
423: );
424: EXCEPTION
425: WHEN hr_api.cannot_find_prog_unit THEN
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'CREATE_LOCATION'
428: ,p_hook_type => 'AP'
429: );
422: ,p_object_version_number => l_object_version_number
423: );
424: EXCEPTION
425: WHEN hr_api.cannot_find_prog_unit THEN
426: hr_api.cannot_find_prog_unit_error
427: (p_module_name => 'CREATE_LOCATION'
428: ,p_hook_type => 'AP'
429: );
430: --
435: --
436: -- When in validation only mode raise the Validate_Enabled exception
437: --
438: IF p_validate THEN
439: RAISE hr_api.validate_enabled;
440: END IF;
441: -- Set all output arguments
442: --
443: p_location_id := l_location_id;
444: p_object_version_number := l_object_version_number;
445: --
446: EXCEPTION
447: --
448: WHEN hr_api.validate_enabled THEN
449: --
450: -- As the Validate_Enabled exception has been raised
451: -- we must rollback to the savepoint
452: --
476: --
477: PROCEDURE update_location
478: ( p_validate IN BOOLEAN DEFAULT false
479: ,p_effective_date IN DATE
480: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
481: ,p_location_id IN NUMBER
482: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
478: ( p_validate IN BOOLEAN DEFAULT false
479: ,p_effective_date IN DATE
480: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
481: ,p_location_id IN NUMBER
482: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_effective_date IN DATE
480: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
481: ,p_location_id IN NUMBER
482: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
481: ,p_location_id IN NUMBER
482: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_location_id IN NUMBER
482: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
485: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
493: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
493: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
487: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
493: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
495: ,p_operating_unit_id IN NUMBER DEFAULT NULL
488: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
493: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
495: ,p_operating_unit_id IN NUMBER DEFAULT NULL
496: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
489: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
493: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
495: ,p_operating_unit_id IN NUMBER DEFAULT NULL
496: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
497: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
493: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
495: ,p_operating_unit_id IN NUMBER DEFAULT NULL
496: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
497: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
493: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
495: ,p_operating_unit_id IN NUMBER DEFAULT NULL
496: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
497: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
495: ,p_operating_unit_id IN NUMBER DEFAULT NULL
496: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
497: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
495: ,p_operating_unit_id IN NUMBER DEFAULT NULL
496: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
497: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_operating_unit_id IN NUMBER DEFAULT NULL
496: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
497: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
496: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
497: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_object_version_number IN OUT NOCOPY NUMBER
554: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_object_version_number IN OUT NOCOPY NUMBER
562: ) IS
555: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_object_version_number IN OUT NOCOPY NUMBER
562: ) IS
563: --
556: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_object_version_number IN OUT NOCOPY NUMBER
562: ) IS
563: --
564: -- Declare cursors and local variables
599: -- instead of p_language_code from now on, to allow an IN OUT parameter to be
600: -- passed through.
601: --
602: l_language_code := p_language_code;
603: hr_api.validate_language_code(p_language_code => l_language_code);
604: hr_utility.set_location(l_proc, 20);
605:
606: if hr_general2.is_location_legal_adr(p_location_id => p_location_id) then
607: --
651: hr_utility.set_location(l_proc, 25);
652:
653: if (
654:
655: nvl(p_address_line_1,hr_api.g_varchar2) <>
656: nvl(l_address_line_1,hr_api.g_varchar2) OR
657: nvl(p_address_line_2,hr_api.g_varchar2) <>
658: nvl(l_address_line_2,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
652:
653: if (
654:
655: nvl(p_address_line_1,hr_api.g_varchar2) <>
656: nvl(l_address_line_1,hr_api.g_varchar2) OR
657: nvl(p_address_line_2,hr_api.g_varchar2) <>
658: nvl(l_address_line_2,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
653: if (
654:
655: nvl(p_address_line_1,hr_api.g_varchar2) <>
656: nvl(l_address_line_1,hr_api.g_varchar2) OR
657: nvl(p_address_line_2,hr_api.g_varchar2) <>
658: nvl(l_address_line_2,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
654:
655: nvl(p_address_line_1,hr_api.g_varchar2) <>
656: nvl(l_address_line_1,hr_api.g_varchar2) OR
657: nvl(p_address_line_2,hr_api.g_varchar2) <>
658: nvl(l_address_line_2,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
655: nvl(p_address_line_1,hr_api.g_varchar2) <>
656: nvl(l_address_line_1,hr_api.g_varchar2) OR
657: nvl(p_address_line_2,hr_api.g_varchar2) <>
658: nvl(l_address_line_2,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
656: nvl(l_address_line_1,hr_api.g_varchar2) OR
657: nvl(p_address_line_2,hr_api.g_varchar2) <>
658: nvl(l_address_line_2,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
657: nvl(p_address_line_2,hr_api.g_varchar2) <>
658: nvl(l_address_line_2,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
658: nvl(l_address_line_2,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
659: nvl(p_address_line_3,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
660: nvl(l_address_line_3,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
661: nvl(p_country,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
669: nvl(p_region_2,hr_api.g_varchar2) <>
662: nvl(l_country,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
669: nvl(p_region_2,hr_api.g_varchar2) <>
670: nvl(l_region_2,hr_api.g_varchar2) OR
663: nvl(p_inactive_date,hr_api.g_date) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
669: nvl(p_region_2,hr_api.g_varchar2) <>
670: nvl(l_region_2,hr_api.g_varchar2) OR
671: nvl(p_region_3,hr_api.g_varchar2) <>
664: nvl(l_inactive_date,hr_api.g_date) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
669: nvl(p_region_2,hr_api.g_varchar2) <>
670: nvl(l_region_2,hr_api.g_varchar2) OR
671: nvl(p_region_3,hr_api.g_varchar2) <>
672: nvl(l_region_3,hr_api.g_varchar2) OR
665: nvl(p_postal_code,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
669: nvl(p_region_2,hr_api.g_varchar2) <>
670: nvl(l_region_2,hr_api.g_varchar2) OR
671: nvl(p_region_3,hr_api.g_varchar2) <>
672: nvl(l_region_3,hr_api.g_varchar2) OR
673: nvl(p_style,hr_api.g_varchar2) <>
666: nvl(l_postal_code,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
669: nvl(p_region_2,hr_api.g_varchar2) <>
670: nvl(l_region_2,hr_api.g_varchar2) OR
671: nvl(p_region_3,hr_api.g_varchar2) <>
672: nvl(l_region_3,hr_api.g_varchar2) OR
673: nvl(p_style,hr_api.g_varchar2) <>
674: nvl(l_style,hr_api.g_varchar2) OR
667: nvl(p_region_1,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
669: nvl(p_region_2,hr_api.g_varchar2) <>
670: nvl(l_region_2,hr_api.g_varchar2) OR
671: nvl(p_region_3,hr_api.g_varchar2) <>
672: nvl(l_region_3,hr_api.g_varchar2) OR
673: nvl(p_style,hr_api.g_varchar2) <>
674: nvl(l_style,hr_api.g_varchar2) OR
675: nvl(p_town_or_city,hr_api.g_varchar2) <>
668: nvl(l_region_1,hr_api.g_varchar2) OR
669: nvl(p_region_2,hr_api.g_varchar2) <>
670: nvl(l_region_2,hr_api.g_varchar2) OR
671: nvl(p_region_3,hr_api.g_varchar2) <>
672: nvl(l_region_3,hr_api.g_varchar2) OR
673: nvl(p_style,hr_api.g_varchar2) <>
674: nvl(l_style,hr_api.g_varchar2) OR
675: nvl(p_town_or_city,hr_api.g_varchar2) <>
676: nvl(l_town_or_city,hr_api.g_varchar2)
669: nvl(p_region_2,hr_api.g_varchar2) <>
670: nvl(l_region_2,hr_api.g_varchar2) OR
671: nvl(p_region_3,hr_api.g_varchar2) <>
672: nvl(l_region_3,hr_api.g_varchar2) OR
673: nvl(p_style,hr_api.g_varchar2) <>
674: nvl(l_style,hr_api.g_varchar2) OR
675: nvl(p_town_or_city,hr_api.g_varchar2) <>
676: nvl(l_town_or_city,hr_api.g_varchar2)
677: )
670: nvl(l_region_2,hr_api.g_varchar2) OR
671: nvl(p_region_3,hr_api.g_varchar2) <>
672: nvl(l_region_3,hr_api.g_varchar2) OR
673: nvl(p_style,hr_api.g_varchar2) <>
674: nvl(l_style,hr_api.g_varchar2) OR
675: nvl(p_town_or_city,hr_api.g_varchar2) <>
676: nvl(l_town_or_city,hr_api.g_varchar2)
677: )
678: then
671: nvl(p_region_3,hr_api.g_varchar2) <>
672: nvl(l_region_3,hr_api.g_varchar2) OR
673: nvl(p_style,hr_api.g_varchar2) <>
674: nvl(l_style,hr_api.g_varchar2) OR
675: nvl(p_town_or_city,hr_api.g_varchar2) <>
676: nvl(l_town_or_city,hr_api.g_varchar2)
677: )
678: then
679:
672: nvl(l_region_3,hr_api.g_varchar2) OR
673: nvl(p_style,hr_api.g_varchar2) <>
674: nvl(l_style,hr_api.g_varchar2) OR
675: nvl(p_town_or_city,hr_api.g_varchar2) <>
676: nvl(l_town_or_city,hr_api.g_varchar2)
677: )
678: then
679:
680: hr_utility.set_location(l_proc, 26);
780: ,p_global_attribute20 => p_global_attribute20
781: ,p_object_version_number => l_object_version_number
782: );
783: EXCEPTION
784: WHEN hr_api.cannot_find_prog_unit THEN
785: hr_api.cannot_find_prog_unit_error
786: (p_module_name => 'UPDATE_LOCATION'
787: ,p_hook_type => 'BP'
788: );
781: ,p_object_version_number => l_object_version_number
782: );
783: EXCEPTION
784: WHEN hr_api.cannot_find_prog_unit THEN
785: hr_api.cannot_find_prog_unit_error
786: (p_module_name => 'UPDATE_LOCATION'
787: ,p_hook_type => 'BP'
788: );
789: --
972: ,p_global_attribute20 => p_global_attribute20
973: ,p_object_version_number => l_object_version_number
974: );
975: EXCEPTION
976: WHEN hr_api.cannot_find_prog_unit THEN
977: hr_api.cannot_find_prog_unit_error
978: (p_module_name => 'UPDATE_LOCATION'
979: ,p_hook_type => 'AP'
980: );
973: ,p_object_version_number => l_object_version_number
974: );
975: EXCEPTION
976: WHEN hr_api.cannot_find_prog_unit THEN
977: hr_api.cannot_find_prog_unit_error
978: (p_module_name => 'UPDATE_LOCATION'
979: ,p_hook_type => 'AP'
980: );
981: --
987: --
988: -- When in validation only mode raise the Validate_Enabled exception
989: --
990: IF p_validate THEN
991: RAISE hr_api.validate_enabled;
992: END IF;
993: --
994: -- Set all output arguments. If p_validate was TRUE, this bit is
995: -- never reached, so p_object_version_number is passed back unchanged.
999: hr_utility.set_location(' Leaving:'||l_proc, 70);
1000: --
1001: EXCEPTION
1002: --
1003: WHEN hr_api.validate_enabled THEN
1004: --
1005: -- As the Validate_Enabled exception has been raised
1006: -- we must rollback to the savepoint
1007: --
1054: p_location_id => p_location_id,
1055: p_object_version_number => p_object_version_number );
1056: --
1057: EXCEPTION
1058: WHEN hr_api.cannot_find_prog_unit THEN
1059: hr_api.cannot_find_prog_unit_error
1060: (p_module_name => 'DELETE_LOCATION'
1061: ,p_hook_type => 'BP'
1062: );
1055: p_object_version_number => p_object_version_number );
1056: --
1057: EXCEPTION
1058: WHEN hr_api.cannot_find_prog_unit THEN
1059: hr_api.cannot_find_prog_unit_error
1060: (p_module_name => 'DELETE_LOCATION'
1061: ,p_hook_type => 'BP'
1062: );
1063: END;
1090: p_location_id => p_location_id,
1091: p_object_version_number => p_object_version_number );
1092: --
1093: EXCEPTION
1094: WHEN hr_api.cannot_find_prog_unit THEN
1095: hr_api.cannot_find_prog_unit_error
1096: (p_module_name => 'DELETE_LOCATION'
1097: ,p_hook_type => 'AP'
1098: );
1091: p_object_version_number => p_object_version_number );
1092: --
1093: EXCEPTION
1094: WHEN hr_api.cannot_find_prog_unit THEN
1095: hr_api.cannot_find_prog_unit_error
1096: (p_module_name => 'DELETE_LOCATION'
1097: ,p_hook_type => 'AP'
1098: );
1099: END;
1103: --
1104: -- When in validation only mode raise the Validate_Enabled exception
1105: --
1106: IF p_validate THEN
1107: RAISE hr_api.validate_enabled;
1108: END IF;
1109: --
1110: --
1111: EXCEPTION
1109: --
1110: --
1111: EXCEPTION
1112: --
1113: WHEN hr_api.validate_enabled THEN
1114: --
1115: -- As the Validate_Enabled exception has been raised
1116: -- we must rollback to the savepoint
1117: --
1139: --
1140: PROCEDURE create_location_legal_adr
1141: ( p_validate IN BOOLEAN DEFAULT false
1142: ,p_effective_date IN DATE
1143: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1144: ,p_location_code IN VARCHAR2
1145: ,p_description IN VARCHAR2 DEFAULT NULL
1146: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
1147: ,p_address_line_1 IN VARCHAR2 DEFAULT NULL
1209: -- instead of p_language_code from now on, to allow an IN OUT parameter to
1210: -- be passed through.
1211: --
1212: l_language_code := p_language_code;
1213: hr_api.validate_language_code(p_language_code => l_language_code);
1214: --
1215: hr_utility.set_location(l_proc, 20);
1216: --
1217:
1259: ,p_attribute20 => p_attribute20
1260: ,p_business_group_id => p_business_group_id
1261: );
1262: EXCEPTION
1263: WHEN hr_api.cannot_find_prog_unit THEN
1264: hr_api.cannot_find_prog_unit_error
1265: ( p_module_name => 'create_location_legal_adr'
1266: ,p_hook_type => 'BP'
1267: );
1260: ,p_business_group_id => p_business_group_id
1261: );
1262: EXCEPTION
1263: WHEN hr_api.cannot_find_prog_unit THEN
1264: hr_api.cannot_find_prog_unit_error
1265: ( p_module_name => 'create_location_legal_adr'
1266: ,p_hook_type => 'BP'
1267: );
1268: --
1364: ,p_location_id => l_location_id
1365: ,p_object_version_number => l_object_version_number
1366: );
1367: EXCEPTION
1368: WHEN hr_api.cannot_find_prog_unit THEN
1369: hr_api.cannot_find_prog_unit_error
1370: (p_module_name => 'create_location_legal_adr'
1371: ,p_hook_type => 'AP'
1372: );
1365: ,p_object_version_number => l_object_version_number
1366: );
1367: EXCEPTION
1368: WHEN hr_api.cannot_find_prog_unit THEN
1369: hr_api.cannot_find_prog_unit_error
1370: (p_module_name => 'create_location_legal_adr'
1371: ,p_hook_type => 'AP'
1372: );
1373: --
1379: --
1380: -- When in validation only mode raise the Validate_Enabled exception
1381: --
1382: IF p_validate THEN
1383: RAISE hr_api.validate_enabled;
1384: END IF;
1385: --
1386: -- Set all output arguments
1387: --
1388: p_location_id := l_location_id;
1389: p_object_version_number := l_object_version_number;
1390: EXCEPTION
1391: --
1392: WHEN hr_api.validate_enabled THEN
1393: --
1394: -- As the Validate_Enabled exception has been raised
1395: -- we must rollback to the savepoint
1396: --
1421: PROCEDURE update_location_legal_adr
1422: ( p_validate IN BOOLEAN DEFAULT false
1423: ,p_effective_date IN DATE
1424: ,p_location_id IN NUMBER
1425: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1422: ( p_validate IN BOOLEAN DEFAULT false
1423: ,p_effective_date IN DATE
1424: ,p_location_id IN NUMBER
1425: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1423: ,p_effective_date IN DATE
1424: ,p_location_id IN NUMBER
1425: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1424: ,p_location_id IN NUMBER
1425: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1425: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1426: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1427: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1428: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1429: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1430: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1431: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1432: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1433: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1434: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1435: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1436: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1437: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1438: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1439: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1440: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1441: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1442: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1443: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1444: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1445: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1446: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1447: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1448: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1449: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1450: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1458: ,p_object_version_number IN OUT NOCOPY NUMBER
1451: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1458: ,p_object_version_number IN OUT NOCOPY NUMBER
1459: ) IS
1452: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1458: ,p_object_version_number IN OUT NOCOPY NUMBER
1459: ) IS
1460: --
1453: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1454: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1455: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1456: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1457: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1458: ,p_object_version_number IN OUT NOCOPY NUMBER
1459: ) IS
1460: --
1461: -- Declare cursors and local variables
1519: ,p_attribute20 => p_attribute20
1520: ,p_object_version_number => l_object_version_number
1521: );
1522: EXCEPTION
1523: WHEN hr_api.cannot_find_prog_unit THEN
1524: hr_api.cannot_find_prog_unit_error
1525: (p_module_name => 'update_location_legal_adr'
1526: ,p_hook_type => 'BP'
1527: );
1520: ,p_object_version_number => l_object_version_number
1521: );
1522: EXCEPTION
1523: WHEN hr_api.cannot_find_prog_unit THEN
1524: hr_api.cannot_find_prog_unit_error
1525: (p_module_name => 'update_location_legal_adr'
1526: ,p_hook_type => 'BP'
1527: );
1528: --
1614: ,p_attribute20 => p_attribute20
1615: ,p_object_version_number => l_object_version_number
1616: );
1617: EXCEPTION
1618: WHEN hr_api.cannot_find_prog_unit THEN
1619: hr_api.cannot_find_prog_unit_error
1620: (p_module_name => 'update_location_legal_adr'
1621: ,p_hook_type => 'AP'
1622: );
1615: ,p_object_version_number => l_object_version_number
1616: );
1617: EXCEPTION
1618: WHEN hr_api.cannot_find_prog_unit THEN
1619: hr_api.cannot_find_prog_unit_error
1620: (p_module_name => 'update_location_legal_adr'
1621: ,p_hook_type => 'AP'
1622: );
1623: --
1629: --
1630: -- When in validation only mode raise the Validate_Enabled exception
1631: --
1632: IF p_validate THEN
1633: RAISE hr_api.validate_enabled;
1634: END IF;
1635: --
1636: -- Set all output arguments. If p_validate was TRUE, this bit is
1637: -- never reached, so p_object_version_number is passed back unchanged.
1641: hr_utility.set_location(' Leaving:'||l_proc, 70);
1642: --
1643: EXCEPTION
1644: --
1645: WHEN hr_api.validate_enabled THEN
1646: --
1647: -- As the Validate_Enabled exception has been raised
1648: -- we must rollback to the savepoint
1649: --
1719: ,p_object_version_number => l_object_version_number
1720: );
1721:
1722: EXCEPTION
1723: WHEN hr_api.cannot_find_prog_unit THEN
1724: hr_api.cannot_find_prog_unit_error
1725: (p_module_name => 'disable_location_legal_adr'
1726: ,p_hook_type => 'BP'
1727: );
1720: );
1721:
1722: EXCEPTION
1723: WHEN hr_api.cannot_find_prog_unit THEN
1724: hr_api.cannot_find_prog_unit_error
1725: (p_module_name => 'disable_location_legal_adr'
1726: ,p_hook_type => 'BP'
1727: );
1728: --
1756: ,p_object_version_number => l_object_version_number
1757: );
1758:
1759: EXCEPTION
1760: WHEN hr_api.cannot_find_prog_unit THEN
1761: hr_api.cannot_find_prog_unit_error
1762: (p_module_name => 'disable_location_legal_adr'
1763: ,p_hook_type => 'AP'
1764: );
1757: );
1758:
1759: EXCEPTION
1760: WHEN hr_api.cannot_find_prog_unit THEN
1761: hr_api.cannot_find_prog_unit_error
1762: (p_module_name => 'disable_location_legal_adr'
1763: ,p_hook_type => 'AP'
1764: );
1765: --
1769: --
1770: -- When in validation only mode raise the Validate_Enabled exception
1771: --
1772: IF p_validate THEN
1773: RAISE hr_api.validate_enabled;
1774: END IF;
1775: -- Set all output arguments. If p_validate was TRUE, this bit is
1776: -- never reached, so p_object_version_number is passed back unchanged.
1777: --
1779: --
1780: hr_utility.set_location(' Leaving:'||l_proc, 70);
1781: EXCEPTION
1782: --
1783: WHEN hr_api.validate_enabled THEN
1784: --
1785: -- As the Validate_Enabled exception has been raised
1786: -- we must rollback to the savepoint
1787: --
1849: ,p_object_version_number => l_object_version_number
1850: );
1851:
1852: EXCEPTION
1853: WHEN hr_api.cannot_find_prog_unit THEN
1854: hr_api.cannot_find_prog_unit_error
1855: (p_module_name => 'enable_location_legal_adr'
1856: ,p_hook_type => 'BP'
1857: );
1850: );
1851:
1852: EXCEPTION
1853: WHEN hr_api.cannot_find_prog_unit THEN
1854: hr_api.cannot_find_prog_unit_error
1855: (p_module_name => 'enable_location_legal_adr'
1856: ,p_hook_type => 'BP'
1857: );
1858: --
1885: ,p_location_id => p_location_id
1886: ,p_object_version_number => l_object_version_number
1887: );
1888: EXCEPTION
1889: WHEN hr_api.cannot_find_prog_unit THEN
1890: hr_api.cannot_find_prog_unit_error
1891: (p_module_name => 'enable_location_legal_adr'
1892: ,p_hook_type => 'AP'
1893: );
1886: ,p_object_version_number => l_object_version_number
1887: );
1888: EXCEPTION
1889: WHEN hr_api.cannot_find_prog_unit THEN
1890: hr_api.cannot_find_prog_unit_error
1891: (p_module_name => 'enable_location_legal_adr'
1892: ,p_hook_type => 'AP'
1893: );
1894: --
1898: --
1899: -- When in validation only mode raise the Validate_Enabled exception
1900: --
1901: IF p_validate THEN
1902: RAISE hr_api.validate_enabled;
1903: END IF;
1904: -- Set all output arguments. If p_validate was TRUE, this bit is
1905: -- never reached, so p_object_version_number is passed back unchanged.
1906: --
1908: --
1909: hr_utility.set_location(' Leaving:'||l_proc, 70);
1910: EXCEPTION
1911: --
1912: WHEN hr_api.validate_enabled THEN
1913: --
1914: -- As the Validate_Enabled exception has been raised
1915: -- we must rollback to the savepoint
1916: --