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

APPS.HR_LOCATION_API dependencies on HR_API

Line 20: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

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

Line 134: hr_api.validate_language_code(p_language_code => l_language_code);

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

Line 228: WHEN hr_api.cannot_find_prog_unit THEN

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

Line 229: hr_api.cannot_find_prog_unit_error

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

Line 426: WHEN hr_api.cannot_find_prog_unit THEN

422: ,p_location_id => l_location_id
423: ,p_object_version_number => l_object_version_number
424: );
425: EXCEPTION
426: WHEN hr_api.cannot_find_prog_unit THEN
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'CREATE_LOCATION'
429: ,p_hook_type => 'AP'
430: );

Line 427: hr_api.cannot_find_prog_unit_error

423: ,p_object_version_number => l_object_version_number
424: );
425: EXCEPTION
426: WHEN hr_api.cannot_find_prog_unit THEN
427: hr_api.cannot_find_prog_unit_error
428: (p_module_name => 'CREATE_LOCATION'
429: ,p_hook_type => 'AP'
430: );
431: --

Line 440: RAISE hr_api.validate_enabled;

436: --
437: -- When in validation only mode raise the Validate_Enabled exception
438: --
439: IF p_validate THEN
440: RAISE hr_api.validate_enabled;
441: END IF;
442: -- Set all output arguments
443: --
444: p_location_id := l_location_id;

Line 449: WHEN hr_api.validate_enabled THEN

445: p_object_version_number := l_object_version_number;
446: --
447: EXCEPTION
448: --
449: WHEN hr_api.validate_enabled THEN
450: --
451: -- As the Validate_Enabled exception has been raised
452: -- we must rollback to the savepoint
453: --

Line 481: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

477: --
478: PROCEDURE update_location
479: ( p_validate IN BOOLEAN DEFAULT false
480: ,p_effective_date IN DATE
481: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
482: ,p_location_id IN NUMBER
483: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 483: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

479: ( p_validate IN BOOLEAN DEFAULT false
480: ,p_effective_date IN DATE
481: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
482: ,p_location_id IN NUMBER
483: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 484: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2

480: ,p_effective_date IN DATE
481: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
482: ,p_location_id IN NUMBER
483: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

481: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
482: ,p_location_id IN NUMBER
483: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number

482: ,p_location_id IN NUMBER
483: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

483: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

484: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

485: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number

Line 490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

486: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

487: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date

Line 492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2

488: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
496: ,p_operating_unit_id IN NUMBER DEFAULT NULL

Line 493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number

489: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
496: ,p_operating_unit_id IN NUMBER DEFAULT NULL
497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number

Line 494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

490: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
496: ,p_operating_unit_id IN NUMBER DEFAULT NULL
497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date

491: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
496: ,p_operating_unit_id IN NUMBER DEFAULT NULL
497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number

493: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
496: ,p_operating_unit_id IN NUMBER DEFAULT NULL
497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

494: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
496: ,p_operating_unit_id IN NUMBER DEFAULT NULL
497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

495: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
496: ,p_operating_unit_id IN NUMBER DEFAULT NULL
497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

496: ,p_operating_unit_id IN NUMBER DEFAULT NULL
497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number

Line 501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

497: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

498: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

499: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number

500: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

501: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2

502: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

503: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

504: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

505: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

506: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

507: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

508: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

509: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

510: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

511: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

512: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

513: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

514: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

515: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

516: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

517: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

518: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

519: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

520: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

521: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

522: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

523: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

524: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

525: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

526: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

527: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

528: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

529: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

530: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

531: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

532: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

533: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

534: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

535: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

536: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

537: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

538: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

539: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

540: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

541: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

542: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

543: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

544: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

545: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

546: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

547: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

548: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

549: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

550: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

551: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

552: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

553: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

554: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 559: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

555: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_object_version_number IN OUT NOCOPY NUMBER
563: ) IS

Line 560: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

556: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_object_version_number IN OUT NOCOPY NUMBER
563: ) IS
564: --

Line 561: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

557: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
558: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
559: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
560: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
561: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
562: ,p_object_version_number IN OUT NOCOPY NUMBER
563: ) IS
564: --
565: -- Declare cursors and local variables

Line 604: hr_api.validate_language_code(p_language_code => l_language_code);

600: -- instead of p_language_code from now on, to allow an IN OUT parameter to be
601: -- passed through.
602: --
603: l_language_code := p_language_code;
604: hr_api.validate_language_code(p_language_code => l_language_code);
605: hr_utility.set_location(l_proc, 20);
606:
607: if hr_general2.is_location_legal_adr(p_location_id => p_location_id) then
608: --

Line 657: /* nvl(p_address_line_1,hr_api.g_varchar2) <>

653: hr_utility.set_location(l_proc, 25);
654:
655: if (
656:
657: /* nvl(p_address_line_1,hr_api.g_varchar2) <>
658: nvl(l_address_line_1,hr_api.g_varchar2) OR
659: nvl(p_address_line_2,hr_api.g_varchar2) <>
660: nvl(l_address_line_2,hr_api.g_varchar2) OR
661: nvl(p_address_line_3,hr_api.g_varchar2) <>

Line 658: nvl(l_address_line_1,hr_api.g_varchar2) OR

654:
655: if (
656:
657: /* nvl(p_address_line_1,hr_api.g_varchar2) <>
658: nvl(l_address_line_1,hr_api.g_varchar2) OR
659: nvl(p_address_line_2,hr_api.g_varchar2) <>
660: nvl(l_address_line_2,hr_api.g_varchar2) OR
661: nvl(p_address_line_3,hr_api.g_varchar2) <>
662: nvl(l_address_line_3,hr_api.g_varchar2) OR

Line 659: nvl(p_address_line_2,hr_api.g_varchar2) <>

655: if (
656:
657: /* nvl(p_address_line_1,hr_api.g_varchar2) <>
658: nvl(l_address_line_1,hr_api.g_varchar2) OR
659: nvl(p_address_line_2,hr_api.g_varchar2) <>
660: nvl(l_address_line_2,hr_api.g_varchar2) OR
661: nvl(p_address_line_3,hr_api.g_varchar2) <>
662: nvl(l_address_line_3,hr_api.g_varchar2) OR
663: nvl(p_country,hr_api.g_varchar2) <>

Line 660: nvl(l_address_line_2,hr_api.g_varchar2) OR

656:
657: /* nvl(p_address_line_1,hr_api.g_varchar2) <>
658: nvl(l_address_line_1,hr_api.g_varchar2) OR
659: nvl(p_address_line_2,hr_api.g_varchar2) <>
660: nvl(l_address_line_2,hr_api.g_varchar2) OR
661: nvl(p_address_line_3,hr_api.g_varchar2) <>
662: nvl(l_address_line_3,hr_api.g_varchar2) OR
663: nvl(p_country,hr_api.g_varchar2) <>
664: nvl(l_country,hr_api.g_varchar2) OR */

Line 661: nvl(p_address_line_3,hr_api.g_varchar2) <>

657: /* nvl(p_address_line_1,hr_api.g_varchar2) <>
658: nvl(l_address_line_1,hr_api.g_varchar2) OR
659: nvl(p_address_line_2,hr_api.g_varchar2) <>
660: nvl(l_address_line_2,hr_api.g_varchar2) OR
661: nvl(p_address_line_3,hr_api.g_varchar2) <>
662: nvl(l_address_line_3,hr_api.g_varchar2) OR
663: nvl(p_country,hr_api.g_varchar2) <>
664: nvl(l_country,hr_api.g_varchar2) OR */
665: nvl(p_inactive_date,hr_api.g_date) <>

Line 662: nvl(l_address_line_3,hr_api.g_varchar2) OR

658: nvl(l_address_line_1,hr_api.g_varchar2) OR
659: nvl(p_address_line_2,hr_api.g_varchar2) <>
660: nvl(l_address_line_2,hr_api.g_varchar2) OR
661: nvl(p_address_line_3,hr_api.g_varchar2) <>
662: nvl(l_address_line_3,hr_api.g_varchar2) OR
663: nvl(p_country,hr_api.g_varchar2) <>
664: nvl(l_country,hr_api.g_varchar2) OR */
665: nvl(p_inactive_date,hr_api.g_date) <>
666: nvl(l_inactive_date,hr_api.g_date)

Line 663: nvl(p_country,hr_api.g_varchar2) <>

659: nvl(p_address_line_2,hr_api.g_varchar2) <>
660: nvl(l_address_line_2,hr_api.g_varchar2) OR
661: nvl(p_address_line_3,hr_api.g_varchar2) <>
662: nvl(l_address_line_3,hr_api.g_varchar2) OR
663: nvl(p_country,hr_api.g_varchar2) <>
664: nvl(l_country,hr_api.g_varchar2) OR */
665: nvl(p_inactive_date,hr_api.g_date) <>
666: nvl(l_inactive_date,hr_api.g_date)
667: /* OR

Line 664: nvl(l_country,hr_api.g_varchar2) OR */

660: nvl(l_address_line_2,hr_api.g_varchar2) OR
661: nvl(p_address_line_3,hr_api.g_varchar2) <>
662: nvl(l_address_line_3,hr_api.g_varchar2) OR
663: nvl(p_country,hr_api.g_varchar2) <>
664: nvl(l_country,hr_api.g_varchar2) OR */
665: nvl(p_inactive_date,hr_api.g_date) <>
666: nvl(l_inactive_date,hr_api.g_date)
667: /* OR
668: nvl(p_postal_code,hr_api.g_varchar2) <>

Line 665: nvl(p_inactive_date,hr_api.g_date) <>

661: nvl(p_address_line_3,hr_api.g_varchar2) <>
662: nvl(l_address_line_3,hr_api.g_varchar2) OR
663: nvl(p_country,hr_api.g_varchar2) <>
664: nvl(l_country,hr_api.g_varchar2) OR */
665: nvl(p_inactive_date,hr_api.g_date) <>
666: nvl(l_inactive_date,hr_api.g_date)
667: /* OR
668: nvl(p_postal_code,hr_api.g_varchar2) <>
669: nvl(l_postal_code,hr_api.g_varchar2) OR

Line 666: nvl(l_inactive_date,hr_api.g_date)

662: nvl(l_address_line_3,hr_api.g_varchar2) OR
663: nvl(p_country,hr_api.g_varchar2) <>
664: nvl(l_country,hr_api.g_varchar2) OR */
665: nvl(p_inactive_date,hr_api.g_date) <>
666: nvl(l_inactive_date,hr_api.g_date)
667: /* OR
668: nvl(p_postal_code,hr_api.g_varchar2) <>
669: nvl(l_postal_code,hr_api.g_varchar2) OR
670: nvl(p_region_1,hr_api.g_varchar2) <>

Line 668: nvl(p_postal_code,hr_api.g_varchar2) <>

664: nvl(l_country,hr_api.g_varchar2) OR */
665: nvl(p_inactive_date,hr_api.g_date) <>
666: nvl(l_inactive_date,hr_api.g_date)
667: /* OR
668: nvl(p_postal_code,hr_api.g_varchar2) <>
669: nvl(l_postal_code,hr_api.g_varchar2) OR
670: nvl(p_region_1,hr_api.g_varchar2) <>
671: nvl(l_region_1,hr_api.g_varchar2) OR
672: nvl(p_region_2,hr_api.g_varchar2) <>

Line 669: nvl(l_postal_code,hr_api.g_varchar2) OR

665: nvl(p_inactive_date,hr_api.g_date) <>
666: nvl(l_inactive_date,hr_api.g_date)
667: /* OR
668: nvl(p_postal_code,hr_api.g_varchar2) <>
669: nvl(l_postal_code,hr_api.g_varchar2) OR
670: nvl(p_region_1,hr_api.g_varchar2) <>
671: nvl(l_region_1,hr_api.g_varchar2) OR
672: nvl(p_region_2,hr_api.g_varchar2) <>
673: nvl(l_region_2,hr_api.g_varchar2) OR

Line 670: nvl(p_region_1,hr_api.g_varchar2) <>

666: nvl(l_inactive_date,hr_api.g_date)
667: /* OR
668: nvl(p_postal_code,hr_api.g_varchar2) <>
669: nvl(l_postal_code,hr_api.g_varchar2) OR
670: nvl(p_region_1,hr_api.g_varchar2) <>
671: nvl(l_region_1,hr_api.g_varchar2) OR
672: nvl(p_region_2,hr_api.g_varchar2) <>
673: nvl(l_region_2,hr_api.g_varchar2) OR
674: nvl(p_region_3,hr_api.g_varchar2) <>

Line 671: nvl(l_region_1,hr_api.g_varchar2) OR

667: /* OR
668: nvl(p_postal_code,hr_api.g_varchar2) <>
669: nvl(l_postal_code,hr_api.g_varchar2) OR
670: nvl(p_region_1,hr_api.g_varchar2) <>
671: nvl(l_region_1,hr_api.g_varchar2) OR
672: nvl(p_region_2,hr_api.g_varchar2) <>
673: nvl(l_region_2,hr_api.g_varchar2) OR
674: nvl(p_region_3,hr_api.g_varchar2) <>
675: nvl(l_region_3,hr_api.g_varchar2) OR

Line 672: nvl(p_region_2,hr_api.g_varchar2) <>

668: nvl(p_postal_code,hr_api.g_varchar2) <>
669: nvl(l_postal_code,hr_api.g_varchar2) OR
670: nvl(p_region_1,hr_api.g_varchar2) <>
671: nvl(l_region_1,hr_api.g_varchar2) OR
672: nvl(p_region_2,hr_api.g_varchar2) <>
673: nvl(l_region_2,hr_api.g_varchar2) OR
674: nvl(p_region_3,hr_api.g_varchar2) <>
675: nvl(l_region_3,hr_api.g_varchar2) OR
676: nvl(p_style,hr_api.g_varchar2) <>

Line 673: nvl(l_region_2,hr_api.g_varchar2) OR

669: nvl(l_postal_code,hr_api.g_varchar2) OR
670: nvl(p_region_1,hr_api.g_varchar2) <>
671: nvl(l_region_1,hr_api.g_varchar2) OR
672: nvl(p_region_2,hr_api.g_varchar2) <>
673: nvl(l_region_2,hr_api.g_varchar2) OR
674: nvl(p_region_3,hr_api.g_varchar2) <>
675: nvl(l_region_3,hr_api.g_varchar2) OR
676: nvl(p_style,hr_api.g_varchar2) <>
677: nvl(l_style,hr_api.g_varchar2) OR

Line 674: nvl(p_region_3,hr_api.g_varchar2) <>

670: nvl(p_region_1,hr_api.g_varchar2) <>
671: nvl(l_region_1,hr_api.g_varchar2) OR
672: nvl(p_region_2,hr_api.g_varchar2) <>
673: nvl(l_region_2,hr_api.g_varchar2) OR
674: nvl(p_region_3,hr_api.g_varchar2) <>
675: nvl(l_region_3,hr_api.g_varchar2) OR
676: nvl(p_style,hr_api.g_varchar2) <>
677: nvl(l_style,hr_api.g_varchar2) OR
678: nvl(p_town_or_city,hr_api.g_varchar2) <>

Line 675: nvl(l_region_3,hr_api.g_varchar2) OR

671: nvl(l_region_1,hr_api.g_varchar2) OR
672: nvl(p_region_2,hr_api.g_varchar2) <>
673: nvl(l_region_2,hr_api.g_varchar2) OR
674: nvl(p_region_3,hr_api.g_varchar2) <>
675: nvl(l_region_3,hr_api.g_varchar2) OR
676: nvl(p_style,hr_api.g_varchar2) <>
677: nvl(l_style,hr_api.g_varchar2) OR
678: nvl(p_town_or_city,hr_api.g_varchar2) <>
679: nvl(l_town_or_city,hr_api.g_varchar2) */

Line 676: nvl(p_style,hr_api.g_varchar2) <>

672: nvl(p_region_2,hr_api.g_varchar2) <>
673: nvl(l_region_2,hr_api.g_varchar2) OR
674: nvl(p_region_3,hr_api.g_varchar2) <>
675: nvl(l_region_3,hr_api.g_varchar2) OR
676: nvl(p_style,hr_api.g_varchar2) <>
677: nvl(l_style,hr_api.g_varchar2) OR
678: nvl(p_town_or_city,hr_api.g_varchar2) <>
679: nvl(l_town_or_city,hr_api.g_varchar2) */
680: ) then

Line 677: nvl(l_style,hr_api.g_varchar2) OR

673: nvl(l_region_2,hr_api.g_varchar2) OR
674: nvl(p_region_3,hr_api.g_varchar2) <>
675: nvl(l_region_3,hr_api.g_varchar2) OR
676: nvl(p_style,hr_api.g_varchar2) <>
677: nvl(l_style,hr_api.g_varchar2) OR
678: nvl(p_town_or_city,hr_api.g_varchar2) <>
679: nvl(l_town_or_city,hr_api.g_varchar2) */
680: ) then
681:

Line 678: nvl(p_town_or_city,hr_api.g_varchar2) <>

674: nvl(p_region_3,hr_api.g_varchar2) <>
675: nvl(l_region_3,hr_api.g_varchar2) OR
676: nvl(p_style,hr_api.g_varchar2) <>
677: nvl(l_style,hr_api.g_varchar2) OR
678: nvl(p_town_or_city,hr_api.g_varchar2) <>
679: nvl(l_town_or_city,hr_api.g_varchar2) */
680: ) then
681:
682: hr_utility.set_location(l_proc, 26);

Line 679: nvl(l_town_or_city,hr_api.g_varchar2) */

675: nvl(l_region_3,hr_api.g_varchar2) OR
676: nvl(p_style,hr_api.g_varchar2) <>
677: nvl(l_style,hr_api.g_varchar2) OR
678: nvl(p_town_or_city,hr_api.g_varchar2) <>
679: nvl(l_town_or_city,hr_api.g_varchar2) */
680: ) then
681:
682: hr_utility.set_location(l_proc, 26);
683:

Line 786: WHEN hr_api.cannot_find_prog_unit THEN

782: ,p_global_attribute20 => p_global_attribute20
783: ,p_object_version_number => l_object_version_number
784: );
785: EXCEPTION
786: WHEN hr_api.cannot_find_prog_unit THEN
787: hr_api.cannot_find_prog_unit_error
788: (p_module_name => 'UPDATE_LOCATION'
789: ,p_hook_type => 'BP'
790: );

Line 787: hr_api.cannot_find_prog_unit_error

783: ,p_object_version_number => l_object_version_number
784: );
785: EXCEPTION
786: WHEN hr_api.cannot_find_prog_unit THEN
787: hr_api.cannot_find_prog_unit_error
788: (p_module_name => 'UPDATE_LOCATION'
789: ,p_hook_type => 'BP'
790: );
791: --

Line 979: WHEN hr_api.cannot_find_prog_unit THEN

975: ,p_global_attribute20 => p_global_attribute20
976: ,p_object_version_number => l_object_version_number
977: );
978: EXCEPTION
979: WHEN hr_api.cannot_find_prog_unit THEN
980: hr_api.cannot_find_prog_unit_error
981: (p_module_name => 'UPDATE_LOCATION'
982: ,p_hook_type => 'AP'
983: );

Line 980: hr_api.cannot_find_prog_unit_error

976: ,p_object_version_number => l_object_version_number
977: );
978: EXCEPTION
979: WHEN hr_api.cannot_find_prog_unit THEN
980: hr_api.cannot_find_prog_unit_error
981: (p_module_name => 'UPDATE_LOCATION'
982: ,p_hook_type => 'AP'
983: );
984: --

Line 994: RAISE hr_api.validate_enabled;

990: --
991: -- When in validation only mode raise the Validate_Enabled exception
992: --
993: IF p_validate THEN
994: RAISE hr_api.validate_enabled;
995: END IF;
996: --
997: -- Set all output arguments. If p_validate was TRUE, this bit is
998: -- never reached, so p_object_version_number is passed back unchanged.

Line 1006: WHEN hr_api.validate_enabled THEN

1002: hr_utility.set_location(' Leaving:'||l_proc, 70);
1003: --
1004: EXCEPTION
1005: --
1006: WHEN hr_api.validate_enabled THEN
1007: --
1008: -- As the Validate_Enabled exception has been raised
1009: -- we must rollback to the savepoint
1010: --

Line 1061: WHEN hr_api.cannot_find_prog_unit THEN

1057: p_location_id => p_location_id,
1058: p_object_version_number => p_object_version_number );
1059: --
1060: EXCEPTION
1061: WHEN hr_api.cannot_find_prog_unit THEN
1062: hr_api.cannot_find_prog_unit_error
1063: (p_module_name => 'DELETE_LOCATION'
1064: ,p_hook_type => 'BP'
1065: );

Line 1062: hr_api.cannot_find_prog_unit_error

1058: p_object_version_number => p_object_version_number );
1059: --
1060: EXCEPTION
1061: WHEN hr_api.cannot_find_prog_unit THEN
1062: hr_api.cannot_find_prog_unit_error
1063: (p_module_name => 'DELETE_LOCATION'
1064: ,p_hook_type => 'BP'
1065: );
1066: END;

Line 1097: WHEN hr_api.cannot_find_prog_unit THEN

1093: p_location_id => p_location_id,
1094: p_object_version_number => p_object_version_number );
1095: --
1096: EXCEPTION
1097: WHEN hr_api.cannot_find_prog_unit THEN
1098: hr_api.cannot_find_prog_unit_error
1099: (p_module_name => 'DELETE_LOCATION'
1100: ,p_hook_type => 'AP'
1101: );

Line 1098: hr_api.cannot_find_prog_unit_error

1094: p_object_version_number => p_object_version_number );
1095: --
1096: EXCEPTION
1097: WHEN hr_api.cannot_find_prog_unit THEN
1098: hr_api.cannot_find_prog_unit_error
1099: (p_module_name => 'DELETE_LOCATION'
1100: ,p_hook_type => 'AP'
1101: );
1102: END;

Line 1110: RAISE hr_api.validate_enabled;

1106: --
1107: -- When in validation only mode raise the Validate_Enabled exception
1108: --
1109: IF p_validate THEN
1110: RAISE hr_api.validate_enabled;
1111: END IF;
1112: --
1113: --
1114: EXCEPTION

Line 1116: WHEN hr_api.validate_enabled THEN

1112: --
1113: --
1114: EXCEPTION
1115: --
1116: WHEN hr_api.validate_enabled THEN
1117: --
1118: -- As the Validate_Enabled exception has been raised
1119: -- we must rollback to the savepoint
1120: --

Line 1146: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

1142: --
1143: PROCEDURE create_location_legal_adr
1144: ( p_validate IN BOOLEAN DEFAULT false
1145: ,p_effective_date IN DATE
1146: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
1147: ,p_location_code IN VARCHAR2
1148: ,p_description IN VARCHAR2 DEFAULT NULL
1149: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
1150: ,p_address_line_1 IN VARCHAR2 DEFAULT NULL

Line 1229: hr_api.validate_language_code(p_language_code => l_language_code);

1225: -- instead of p_language_code from now on, to allow an IN OUT parameter to
1226: -- be passed through.
1227: --
1228: l_language_code := p_language_code;
1229: hr_api.validate_language_code(p_language_code => l_language_code);
1230: --
1231: hr_utility.set_location(l_proc, 20);
1232: --
1233:

Line 1292: WHEN hr_api.cannot_find_prog_unit THEN

1288: ,p_attribute20 => p_attribute20
1289: ,p_business_group_id => p_business_group_id
1290: );
1291: EXCEPTION
1292: WHEN hr_api.cannot_find_prog_unit THEN
1293: hr_api.cannot_find_prog_unit_error
1294: ( p_module_name => 'create_location_legal_adr'
1295: ,p_hook_type => 'BP'
1296: );

Line 1293: hr_api.cannot_find_prog_unit_error

1289: ,p_business_group_id => p_business_group_id
1290: );
1291: EXCEPTION
1292: WHEN hr_api.cannot_find_prog_unit THEN
1293: hr_api.cannot_find_prog_unit_error
1294: ( p_module_name => 'create_location_legal_adr'
1295: ,p_hook_type => 'BP'
1296: );
1297: --

Line 1423: WHEN hr_api.cannot_find_prog_unit THEN

1419: ,p_location_id => l_location_id
1420: ,p_object_version_number => l_object_version_number
1421: );
1422: EXCEPTION
1423: WHEN hr_api.cannot_find_prog_unit THEN
1424: hr_api.cannot_find_prog_unit_error
1425: (p_module_name => 'create_location_legal_adr'
1426: ,p_hook_type => 'AP'
1427: );

Line 1424: hr_api.cannot_find_prog_unit_error

1420: ,p_object_version_number => l_object_version_number
1421: );
1422: EXCEPTION
1423: WHEN hr_api.cannot_find_prog_unit THEN
1424: hr_api.cannot_find_prog_unit_error
1425: (p_module_name => 'create_location_legal_adr'
1426: ,p_hook_type => 'AP'
1427: );
1428: --

Line 1438: RAISE hr_api.validate_enabled;

1434: --
1435: -- When in validation only mode raise the Validate_Enabled exception
1436: --
1437: IF p_validate THEN
1438: RAISE hr_api.validate_enabled;
1439: END IF;
1440: --
1441: -- Set all output arguments
1442: --

Line 1447: WHEN hr_api.validate_enabled THEN

1443: p_location_id := l_location_id;
1444: p_object_version_number := l_object_version_number;
1445: EXCEPTION
1446: --
1447: WHEN hr_api.validate_enabled THEN
1448: --
1449: -- As the Validate_Enabled exception has been raised
1450: -- we must rollback to the savepoint
1451: --

Line 1480: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2

1476: PROCEDURE update_location_legal_adr
1477: ( p_validate IN BOOLEAN DEFAULT false
1478: ,p_effective_date IN DATE
1479: ,p_location_id IN NUMBER
1480: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1481: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

1477: ( p_validate IN BOOLEAN DEFAULT false
1478: ,p_effective_date IN DATE
1479: ,p_location_id IN NUMBER
1480: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date

Line 1482: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1478: ,p_effective_date IN DATE
1479: ,p_location_id IN NUMBER
1480: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1479: ,p_location_id IN NUMBER
1480: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1480: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
1481: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date

1481: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1482: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

1482: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1483: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1484: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1492: /* Added for bug8703747*/

Line 1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1485: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1492: /* Added for bug8703747*/
1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2

1486: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1492: /* Added for bug8703747*/
1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

1487: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1488: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1492: /* Added for bug8703747*/
1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1489: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1492: /* Added for bug8703747*/
1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1490: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1492: /* Added for bug8703747*/
1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1491: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
1492: /* Added for bug8703747*/
1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1492: /* Added for bug8703747*/
1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1493: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1494: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1495: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1496: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1504: /*Changes end for bug8703747 */

Line 1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1497: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1504: /*Changes end for bug8703747 */
1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1498: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1504: /*Changes end for bug8703747 */
1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1499: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1500: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1504: /*Changes end for bug8703747 */
1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

1501: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1504: /*Changes end for bug8703747 */
1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1502: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1504: /*Changes end for bug8703747 */
1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1503: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1504: /*Changes end for bug8703747 */
1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1504: /*Changes end for bug8703747 */
1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1505: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1506: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1507: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1508: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1509: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1510: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1511: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1512: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1513: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1514: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1515: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1523: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1516: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1523: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1524: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1517: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1523: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1524: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1525: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1518: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1523: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1524: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1525: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1526: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 1523: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1519: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1523: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1524: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1525: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1526: ,p_object_version_number IN OUT NOCOPY NUMBER
1527: ) IS

Line 1524: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1520: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1523: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1524: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1525: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1526: ,p_object_version_number IN OUT NOCOPY NUMBER
1527: ) IS
1528: --

Line 1525: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

1521: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1522: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1523: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1524: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1525: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
1526: ,p_object_version_number IN OUT NOCOPY NUMBER
1527: ) IS
1528: --
1529: -- Declare cursors and local variables

Line 1604: WHEN hr_api.cannot_find_prog_unit THEN

1600: ,p_attribute20 => p_attribute20
1601: ,p_object_version_number => l_object_version_number
1602: );
1603: EXCEPTION
1604: WHEN hr_api.cannot_find_prog_unit THEN
1605: hr_api.cannot_find_prog_unit_error
1606: (p_module_name => 'update_location_legal_adr'
1607: ,p_hook_type => 'BP'
1608: );

Line 1605: hr_api.cannot_find_prog_unit_error

1601: ,p_object_version_number => l_object_version_number
1602: );
1603: EXCEPTION
1604: WHEN hr_api.cannot_find_prog_unit THEN
1605: hr_api.cannot_find_prog_unit_error
1606: (p_module_name => 'update_location_legal_adr'
1607: ,p_hook_type => 'BP'
1608: );
1609: --

Line 1725: WHEN hr_api.cannot_find_prog_unit THEN

1721: ,p_attribute20 => p_attribute20
1722: ,p_object_version_number => l_object_version_number
1723: );
1724: EXCEPTION
1725: WHEN hr_api.cannot_find_prog_unit THEN
1726: hr_api.cannot_find_prog_unit_error
1727: (p_module_name => 'update_location_legal_adr'
1728: ,p_hook_type => 'AP'
1729: );

Line 1726: hr_api.cannot_find_prog_unit_error

1722: ,p_object_version_number => l_object_version_number
1723: );
1724: EXCEPTION
1725: WHEN hr_api.cannot_find_prog_unit THEN
1726: hr_api.cannot_find_prog_unit_error
1727: (p_module_name => 'update_location_legal_adr'
1728: ,p_hook_type => 'AP'
1729: );
1730: --

Line 1740: RAISE hr_api.validate_enabled;

1736: --
1737: -- When in validation only mode raise the Validate_Enabled exception
1738: --
1739: IF p_validate THEN
1740: RAISE hr_api.validate_enabled;
1741: END IF;
1742: --
1743: -- Set all output arguments. If p_validate was TRUE, this bit is
1744: -- never reached, so p_object_version_number is passed back unchanged.

Line 1752: WHEN hr_api.validate_enabled THEN

1748: hr_utility.set_location(' Leaving:'||l_proc, 70);
1749: --
1750: EXCEPTION
1751: --
1752: WHEN hr_api.validate_enabled THEN
1753: --
1754: -- As the Validate_Enabled exception has been raised
1755: -- we must rollback to the savepoint
1756: --

Line 1830: WHEN hr_api.cannot_find_prog_unit THEN

1826: ,p_object_version_number => l_object_version_number
1827: );
1828:
1829: EXCEPTION
1830: WHEN hr_api.cannot_find_prog_unit THEN
1831: hr_api.cannot_find_prog_unit_error
1832: (p_module_name => 'disable_location_legal_adr'
1833: ,p_hook_type => 'BP'
1834: );

Line 1831: hr_api.cannot_find_prog_unit_error

1827: );
1828:
1829: EXCEPTION
1830: WHEN hr_api.cannot_find_prog_unit THEN
1831: hr_api.cannot_find_prog_unit_error
1832: (p_module_name => 'disable_location_legal_adr'
1833: ,p_hook_type => 'BP'
1834: );
1835: --

Line 1867: WHEN hr_api.cannot_find_prog_unit THEN

1863: ,p_object_version_number => l_object_version_number
1864: );
1865:
1866: EXCEPTION
1867: WHEN hr_api.cannot_find_prog_unit THEN
1868: hr_api.cannot_find_prog_unit_error
1869: (p_module_name => 'disable_location_legal_adr'
1870: ,p_hook_type => 'AP'
1871: );

Line 1868: hr_api.cannot_find_prog_unit_error

1864: );
1865:
1866: EXCEPTION
1867: WHEN hr_api.cannot_find_prog_unit THEN
1868: hr_api.cannot_find_prog_unit_error
1869: (p_module_name => 'disable_location_legal_adr'
1870: ,p_hook_type => 'AP'
1871: );
1872: --

Line 1880: RAISE hr_api.validate_enabled;

1876: --
1877: -- When in validation only mode raise the Validate_Enabled exception
1878: --
1879: IF p_validate THEN
1880: RAISE hr_api.validate_enabled;
1881: END IF;
1882: -- Set all output arguments. If p_validate was TRUE, this bit is
1883: -- never reached, so p_object_version_number is passed back unchanged.
1884: --

Line 1890: WHEN hr_api.validate_enabled THEN

1886: --
1887: hr_utility.set_location(' Leaving:'||l_proc, 70);
1888: EXCEPTION
1889: --
1890: WHEN hr_api.validate_enabled THEN
1891: --
1892: -- As the Validate_Enabled exception has been raised
1893: -- we must rollback to the savepoint
1894: --

Line 1960: WHEN hr_api.cannot_find_prog_unit THEN

1956: ,p_object_version_number => l_object_version_number
1957: );
1958:
1959: EXCEPTION
1960: WHEN hr_api.cannot_find_prog_unit THEN
1961: hr_api.cannot_find_prog_unit_error
1962: (p_module_name => 'enable_location_legal_adr'
1963: ,p_hook_type => 'BP'
1964: );

Line 1961: hr_api.cannot_find_prog_unit_error

1957: );
1958:
1959: EXCEPTION
1960: WHEN hr_api.cannot_find_prog_unit THEN
1961: hr_api.cannot_find_prog_unit_error
1962: (p_module_name => 'enable_location_legal_adr'
1963: ,p_hook_type => 'BP'
1964: );
1965: --

Line 1996: WHEN hr_api.cannot_find_prog_unit THEN

1992: ,p_location_id => p_location_id
1993: ,p_object_version_number => l_object_version_number
1994: );
1995: EXCEPTION
1996: WHEN hr_api.cannot_find_prog_unit THEN
1997: hr_api.cannot_find_prog_unit_error
1998: (p_module_name => 'enable_location_legal_adr'
1999: ,p_hook_type => 'AP'
2000: );

Line 1997: hr_api.cannot_find_prog_unit_error

1993: ,p_object_version_number => l_object_version_number
1994: );
1995: EXCEPTION
1996: WHEN hr_api.cannot_find_prog_unit THEN
1997: hr_api.cannot_find_prog_unit_error
1998: (p_module_name => 'enable_location_legal_adr'
1999: ,p_hook_type => 'AP'
2000: );
2001: --

Line 2009: RAISE hr_api.validate_enabled;

2005: --
2006: -- When in validation only mode raise the Validate_Enabled exception
2007: --
2008: IF p_validate THEN
2009: RAISE hr_api.validate_enabled;
2010: END IF;
2011: -- Set all output arguments. If p_validate was TRUE, this bit is
2012: -- never reached, so p_object_version_number is passed back unchanged.
2013: --

Line 2019: WHEN hr_api.validate_enabled THEN

2015: --
2016: hr_utility.set_location(' Leaving:'||l_proc, 70);
2017: EXCEPTION
2018: --
2019: WHEN hr_api.validate_enabled THEN
2020: --
2021: -- As the Validate_Enabled exception has been raised
2022: -- we must rollback to the savepoint
2023: --