16: --
17: PROCEDURE create_generic_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
131: -- instead of p_language_code from now on, to allow an IN OUT parameter to
132: -- be passed through.
133: --
134: l_language_code := p_language_code;
135: hr_api.validate_language_code(p_language_code => l_language_code);
136: --
137: hr_utility.set_location(l_proc, 20);
138: --
139: -- Insert non-translatable rows into HR_LOCATIONS_ALL first
237: --
238: -- When in validation only mode raise the Validate_Enabled exception
239: --
240: IF p_validate THEN
241: RAISE hr_api.validate_enabled;
242: END IF;
243: --
244: -- Set all output arguments
245: --
249: hr_utility.set_location(' Leaving:'||l_proc, 70);
250: --
251: EXCEPTION
252: --
253: WHEN hr_api.validate_enabled THEN
254: --
255: -- As the Validate_Enabled exception has been raised
256: -- we must rollback to the savepoint
257: --
281: --
282: PROCEDURE update_generic_location
283: ( p_validate IN BOOLEAN DEFAULT false
284: ,p_effective_date IN DATE
285: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
286: ,p_location_id IN NUMBER
287: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
283: ( p_validate IN BOOLEAN DEFAULT false
284: ,p_effective_date IN DATE
285: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
286: ,p_location_id IN NUMBER
287: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
284: ,p_effective_date IN DATE
285: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
286: ,p_location_id IN NUMBER
287: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
285: ,p_language_code IN VARCHAR2 DEFAULT hr_api.userenv_lang
286: ,p_location_id IN NUMBER
287: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
286: ,p_location_id IN NUMBER
287: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
287: ,p_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
288: ,p_description IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
289: ,p_timezone_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
290: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
290: ,p_tp_header_id IN NUMBER DEFAULT hr_api.g_number
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
298: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
291: ,p_ece_tp_location_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
298: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
292: ,p_address_line_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
298: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
300: ,p_operating_unit_id IN NUMBER DEFAULT NULL
293: ,p_address_line_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
298: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
300: ,p_operating_unit_id IN NUMBER DEFAULT NULL
301: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
294: ,p_address_line_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
298: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
300: ,p_operating_unit_id IN NUMBER DEFAULT NULL
301: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
302: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
295: ,p_bill_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
296: ,p_country IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
298: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
300: ,p_operating_unit_id IN NUMBER DEFAULT NULL
301: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
302: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
297: ,p_designated_receiver_id IN NUMBER DEFAULT hr_api.g_number
298: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
300: ,p_operating_unit_id IN NUMBER DEFAULT NULL
301: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
302: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
298: ,p_in_organization_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
300: ,p_operating_unit_id IN NUMBER DEFAULT NULL
301: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
302: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
299: ,p_inactive_date IN DATE DEFAULT hr_api.g_date
300: ,p_operating_unit_id IN NUMBER DEFAULT NULL
301: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
302: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
300: ,p_operating_unit_id IN NUMBER DEFAULT NULL
301: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
302: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
301: ,p_inventory_organization_id IN NUMBER DEFAULT hr_api.g_number
302: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
302: ,p_office_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
303: ,p_postal_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
304: ,p_receiving_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
305: ,p_region_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
306: ,p_region_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
307: ,p_region_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
308: ,p_ship_to_location_id IN NUMBER DEFAULT hr_api.g_number
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
309: ,p_ship_to_site_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
310: ,p_style IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
311: ,p_tax_name IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
312: ,p_telephone_number_1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
313: ,p_telephone_number_2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
314: ,p_telephone_number_3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
315: ,p_town_or_city IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
316: ,p_loc_information13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
317: ,p_loc_information14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
318: ,p_loc_information15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
319: ,p_loc_information16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
320: ,p_loc_information17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
321: ,p_loc_information18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
322: ,p_loc_information19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
323: ,p_loc_information20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
324: ,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
325: ,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
326: ,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
327: ,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
328: ,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
329: ,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
330: ,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
331: ,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
332: ,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
333: ,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
334: ,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
335: ,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
336: ,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
337: ,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
338: ,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
339: ,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
340: ,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
341: ,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
342: ,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
343: ,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
344: ,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
345: ,p_global_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
346: ,p_global_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
347: ,p_global_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
348: ,p_global_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
349: ,p_global_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
350: ,p_global_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
351: ,p_global_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
352: ,p_global_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
353: ,p_global_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
354: ,p_global_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
355: ,p_global_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
356: ,p_global_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
357: ,p_global_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
358: ,p_global_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
366: ,p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
359: ,p_global_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
366: ,p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
367: ,p_object_version_number IN OUT NOCOPY NUMBER
360: ,p_global_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
366: ,p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
367: ,p_object_version_number IN OUT NOCOPY NUMBER
368: ) IS
361: ,p_global_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
366: ,p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
367: ,p_object_version_number IN OUT NOCOPY NUMBER
368: ) IS
369: --
362: ,p_global_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
363: ,p_global_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
364: ,p_global_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
365: ,p_global_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
366: ,p_legal_address_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
367: ,p_object_version_number IN OUT NOCOPY NUMBER
368: ) IS
369: --
370: -- Declare cursors and local variables
393: -- instead of p_language_code from now on, to allow an IN OUT parameter to be
394: -- passed through.
395: --
396: l_language_code := p_language_code;
397: hr_api.validate_language_code(p_language_code => l_language_code);
398: hr_utility.set_location(l_proc, 20);
399: --
400: --
401: -- Process Logic
502: --
503: -- When in validation only mode raise the Validate_Enabled exception
504: --
505: IF p_validate THEN
506: RAISE hr_api.validate_enabled;
507: END IF;
508: --
509: -- Set all output arguments. If p_validate was TRUE, this bit is
510: -- never reached, so p_object_version_number is passed back unchanged.
514: hr_utility.set_location(' Leaving:'||l_proc, 70);
515: --
516: EXCEPTION
517: --
518: WHEN hr_api.validate_enabled THEN
519: --
520: -- As the Validate_Enabled exception has been raised
521: -- we must rollback to the savepoint
522: --