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 37: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

33: * applicable during the start to end active date range. This date does not
34: * determine when the changes take effect.
35: * @param p_language_code Specifies to which language the translation values
36: * apply. You can set to the base or any installed language. The default value
37: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
38: * value.
39: * @param p_location_code Unique name of the location
40: * @param p_description Description of the location
41: * @param p_timezone_code Time zone of the location.

Line 192: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

188: --
189: PROCEDURE create_location
190: ( p_validate IN BOOLEAN DEFAULT false
191: ,p_effective_date IN DATE
192: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
193: ,p_location_code IN VARCHAR2
194: ,p_description IN VARCHAR2 DEFAULT NULL
195: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
196: ,p_tp_header_id IN NUMBER DEFAULT NULL

Line 303: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function

299: * applicable during the start to end active date range. This date does not
300: * determine when the changes take effect.
301: * @param p_language_code Specifies to which language the translation values
302: * apply. You can set to the base or any installed language. The default value
303: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
304: * value.
305: * @param p_location_id Uniquely identifies the location to be updated.
306: * @param p_location_code Unique name of the location
307: * @param p_description Description of the location

Line 454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

450: --
451: PROCEDURE update_location
452: ( p_validate IN BOOLEAN DEFAULT false
453: ,p_effective_date IN DATE
454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

452: ( p_validate IN BOOLEAN DEFAULT false
453: ,p_effective_date IN DATE
454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2

453: ,p_effective_date IN DATE
454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

454: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number

455: ,p_location_id IN NUMBER
456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

456: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

457: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

458: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number

Line 463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

459: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

460: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date

Line 465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2

461: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL

Line 466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number

462: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number

Line 467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

463: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date

464: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
465: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number

466: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

467: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

468: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

469: ,p_operating_unit_id IN NUMBER DEFAULT NULL
470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number

Line 474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

470: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

471: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

472: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number

473: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2

474: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2

475: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2

476: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

477: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

478: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

479: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

480: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

481: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

482: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

483: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

484: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

485: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

486: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

487: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

488: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

489: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

490: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

491: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

492: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

493: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

494: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

495: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

496: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

497: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

498: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

499: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

500: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

501: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

502: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

503: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

504: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

505: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

506: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

507: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

508: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

509: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

510: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

511: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

512: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

513: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

514: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

515: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

516: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

517: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

518: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

519: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

520: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

521: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

522: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

523: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

524: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

525: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

526: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

527: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

528: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_object_version_number IN OUT NOCOPY NUMBER
536: );

Line 533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

529: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_object_version_number IN OUT NOCOPY NUMBER
536: );
537: --

Line 534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

530: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
531: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
532: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
533: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
534: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
535: ,p_object_version_number IN OUT NOCOPY NUMBER
536: );
537: --
538: -- ----------------------------------------------------------------------------

Line 692: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang

688: --
689: PROCEDURE create_location_legal_adr
690: ( p_validate IN BOOLEAN DEFAULT false
691: ,p_effective_date IN DATE
692: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
693: ,p_location_code IN VARCHAR2
694: ,p_description IN VARCHAR2 DEFAULT NULL
695: ,p_timezone_code IN VARCHAR2 DEFAULT NULL
696: ,p_address_line_1 IN VARCHAR2 DEFAULT NULL

Line 853: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2

849: PROCEDURE update_location_legal_adr
850: ( p_validate IN BOOLEAN DEFAULT false
851: ,p_effective_date IN DATE
852: ,p_location_id IN NUMBER
853: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
854: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
855: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 854: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

850: ( p_validate IN BOOLEAN DEFAULT false
851: ,p_effective_date IN DATE
852: ,p_location_id IN NUMBER
853: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
854: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
855: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date

Line 855: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

851: ,p_effective_date IN DATE
852: ,p_location_id IN NUMBER
853: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
854: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
855: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

852: ,p_location_id IN NUMBER
853: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
854: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
855: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

853: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
854: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
855: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date

854: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
855: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2

855: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

856: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

857: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
865: /* Added for bug8703747*/

Line 862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

858: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
865: /* Added for bug8703747*/
866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2

859: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
865: /* Added for bug8703747*/
866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2

860: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
861: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
865: /* Added for bug8703747*/
866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

862: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
865: /* Added for bug8703747*/
866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

863: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
865: /* Added for bug8703747*/
866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

864: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
865: /* Added for bug8703747*/
866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

865: /* Added for bug8703747*/
866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

866: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

867: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

868: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

869: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877: /*Changes end for bug8703747 */

Line 874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

870: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877: /*Changes end for bug8703747 */
878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

871: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877: /*Changes end for bug8703747 */
878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

872: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
873: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877: /*Changes end for bug8703747 */
878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2

874: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877: /*Changes end for bug8703747 */
878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2

875: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877: /*Changes end for bug8703747 */
878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2

876: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
877: /*Changes end for bug8703747 */
878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2

877: /*Changes end for bug8703747 */
878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2

878: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2

879: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2

880: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2

881: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2

882: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2

883: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2

884: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2

885: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2

886: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2

887: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2

888: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
896: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2

889: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
896: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
897: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2

890: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
896: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
897: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
898: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

Line 895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2

891: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
896: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
897: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
898: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
899: ,p_object_version_number IN OUT NOCOPY NUMBER

Line 896: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2

892: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
896: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
897: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
898: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
899: ,p_object_version_number IN OUT NOCOPY NUMBER
900: );

Line 897: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2

893: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
896: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
897: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
898: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
899: ,p_object_version_number IN OUT NOCOPY NUMBER
900: );
901: --

Line 898: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2

894: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
895: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
896: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
897: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
898: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
899: ,p_object_version_number IN OUT NOCOPY NUMBER
900: );
901: --
902: --------------------------------------------------------------------------------