167: --
168: -- When in validation only mode raise the Validate_Enabled exception
169: --
170: --if p_validate then
171: -- raise hr_api.validate_enabled;
172: --end if;
173: --
174: -- Set all output arguments
175: --
178: --p_some_warning :=
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 70);
181: exception
182: when hr_api.validate_enabled then
183: --
184: -- As the Validate_Enabled exception has been raised
185: -- we must rollback to the savepoint
186: --
212: procedure update_vehicle_details
213: (p_effective_date in date default NULL
214: ,p_vehicle_details_id in number
215: ,p_object_version_number in out nocopy number
216: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
217: ,p_registration_number in varchar2 default hr_api.g_varchar2
218: ,p_make in varchar2 default hr_api.g_varchar2
219: ,p_model in varchar2 default hr_api.g_varchar2
220: ,p_date_first_registered in date default hr_api.g_date
213: (p_effective_date in date default NULL
214: ,p_vehicle_details_id in number
215: ,p_object_version_number in out nocopy number
216: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
217: ,p_registration_number in varchar2 default hr_api.g_varchar2
218: ,p_make in varchar2 default hr_api.g_varchar2
219: ,p_model in varchar2 default hr_api.g_varchar2
220: ,p_date_first_registered in date default hr_api.g_date
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
214: ,p_vehicle_details_id in number
215: ,p_object_version_number in out nocopy number
216: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
217: ,p_registration_number in varchar2 default hr_api.g_varchar2
218: ,p_make in varchar2 default hr_api.g_varchar2
219: ,p_model in varchar2 default hr_api.g_varchar2
220: ,p_date_first_registered in date default hr_api.g_date
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
215: ,p_object_version_number in out nocopy number
216: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
217: ,p_registration_number in varchar2 default hr_api.g_varchar2
218: ,p_make in varchar2 default hr_api.g_varchar2
219: ,p_model in varchar2 default hr_api.g_varchar2
220: ,p_date_first_registered in date default hr_api.g_date
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
216: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
217: ,p_registration_number in varchar2 default hr_api.g_varchar2
218: ,p_make in varchar2 default hr_api.g_varchar2
219: ,p_model in varchar2 default hr_api.g_varchar2
220: ,p_date_first_registered in date default hr_api.g_date
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
217: ,p_registration_number in varchar2 default hr_api.g_varchar2
218: ,p_make in varchar2 default hr_api.g_varchar2
219: ,p_model in varchar2 default hr_api.g_varchar2
220: ,p_date_first_registered in date default hr_api.g_date
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
225: ,p_list_price in number default hr_api.g_number
218: ,p_make in varchar2 default hr_api.g_varchar2
219: ,p_model in varchar2 default hr_api.g_varchar2
220: ,p_date_first_registered in date default hr_api.g_date
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
225: ,p_list_price in number default hr_api.g_number
226: ,p_business_group_id in number default hr_api.g_number
219: ,p_model in varchar2 default hr_api.g_varchar2
220: ,p_date_first_registered in date default hr_api.g_date
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
225: ,p_list_price in number default hr_api.g_number
226: ,p_business_group_id in number default hr_api.g_number
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
220: ,p_date_first_registered in date default hr_api.g_date
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
225: ,p_list_price in number default hr_api.g_number
226: ,p_business_group_id in number default hr_api.g_number
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
228: ,p_accessory_value_added_later in number default hr_api.g_number
221: ,p_engine_capacity_in_cc in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
225: ,p_list_price in number default hr_api.g_number
226: ,p_business_group_id in number default hr_api.g_number
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
228: ,p_accessory_value_added_later in number default hr_api.g_number
229: -- ,p_capital_contributions in number default hr_api.g_number
222: ,p_fuel_type in varchar2 default hr_api.g_varchar2
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
225: ,p_list_price in number default hr_api.g_number
226: ,p_business_group_id in number default hr_api.g_number
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
228: ,p_accessory_value_added_later in number default hr_api.g_number
229: -- ,p_capital_contributions in number default hr_api.g_number
230: -- ,p_private_use_contributions in number default hr_api.g_number
223: ,p_fuel_card in varchar2 default hr_api.g_varchar2
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
225: ,p_list_price in number default hr_api.g_number
226: ,p_business_group_id in number default hr_api.g_number
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
228: ,p_accessory_value_added_later in number default hr_api.g_number
229: -- ,p_capital_contributions in number default hr_api.g_number
230: -- ,p_private_use_contributions in number default hr_api.g_number
231: ,p_market_value_classic_car in number default hr_api.g_number
224: ,p_currency_code in varchar2 default hr_api.g_varchar2
225: ,p_list_price in number default hr_api.g_number
226: ,p_business_group_id in number default hr_api.g_number
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
228: ,p_accessory_value_added_later in number default hr_api.g_number
229: -- ,p_capital_contributions in number default hr_api.g_number
230: -- ,p_private_use_contributions in number default hr_api.g_number
231: ,p_market_value_classic_car in number default hr_api.g_number
232: ,p_co2_emissions in number default hr_api.g_number
225: ,p_list_price in number default hr_api.g_number
226: ,p_business_group_id in number default hr_api.g_number
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
228: ,p_accessory_value_added_later in number default hr_api.g_number
229: -- ,p_capital_contributions in number default hr_api.g_number
230: -- ,p_private_use_contributions in number default hr_api.g_number
231: ,p_market_value_classic_car in number default hr_api.g_number
232: ,p_co2_emissions in number default hr_api.g_number
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
226: ,p_business_group_id in number default hr_api.g_number
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
228: ,p_accessory_value_added_later in number default hr_api.g_number
229: -- ,p_capital_contributions in number default hr_api.g_number
230: -- ,p_private_use_contributions in number default hr_api.g_number
231: ,p_market_value_classic_car in number default hr_api.g_number
232: ,p_co2_emissions in number default hr_api.g_number
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
227: ,p_accessory_value_at_startdate in number default hr_api.g_number
228: ,p_accessory_value_added_later in number default hr_api.g_number
229: -- ,p_capital_contributions in number default hr_api.g_number
230: -- ,p_private_use_contributions in number default hr_api.g_number
231: ,p_market_value_classic_car in number default hr_api.g_number
232: ,p_co2_emissions in number default hr_api.g_number
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
228: ,p_accessory_value_added_later in number default hr_api.g_number
229: -- ,p_capital_contributions in number default hr_api.g_number
230: -- ,p_private_use_contributions in number default hr_api.g_number
231: ,p_market_value_classic_car in number default hr_api.g_number
232: ,p_co2_emissions in number default hr_api.g_number
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
229: -- ,p_capital_contributions in number default hr_api.g_number
230: -- ,p_private_use_contributions in number default hr_api.g_number
231: ,p_market_value_classic_car in number default hr_api.g_number
232: ,p_co2_emissions in number default hr_api.g_number
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
230: -- ,p_private_use_contributions in number default hr_api.g_number
231: ,p_market_value_classic_car in number default hr_api.g_number
232: ,p_co2_emissions in number default hr_api.g_number
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
231: ,p_market_value_classic_car in number default hr_api.g_number
232: ,p_co2_emissions in number default hr_api.g_number
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
232: ,p_co2_emissions in number default hr_api.g_number
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
233: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
237: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
238: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
239: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
240: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
241: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
242: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
243: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
244: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
245: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
246: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
247: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
248: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
249: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
250: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
251: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
252: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
253: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
254: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
255: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
256: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
257: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
258: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
259: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
260: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
261: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
262: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
263: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
264: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
265: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
266: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
274: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
267: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
274: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
275: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
268: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
274: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
275: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
276: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
269: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
274: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
275: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
276: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
277: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
270: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
274: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
275: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
276: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
277: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
278: ) is
271: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
274: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
275: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
276: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
277: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
278: ) is
279: --
272: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
274: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
275: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
276: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
277: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
278: ) is
279: --
280: -- Declare cursors and local variables
273: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
274: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
275: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
276: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
277: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
278: ) is
279: --
280: -- Declare cursors and local variables
281: --
371: --
372: -- When in validation only mode raise the Validate_Enabled exception
373: --
374: --if p_validate then
375: -- raise hr_api.validate_enabled;
376: --end if;
377: --
378: -- Set all output arguments
379: --
381: --p_some_warning :=
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 70);
384: exception
385: when hr_api.validate_enabled then
386: --
387: -- As the Validate_Enabled exception has been raised
388: -- we must rollback to the savepoint
389: --
444: --
445: -- When in validation only mode raise the Validate_Enabled exception
446: --
447: --if p_validate then
448: -- raise hr_api.validate_enabled;
449: --end if;
450: --
451: -- Set all output arguments
452: --
454: --p_some_warning :=
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 70);
457: exception
458: when hr_api.validate_enabled then
459: --
460: -- As the Validate_Enabled exception has been raised
461: -- we must rollback to the savepoint
462: --