DBA Data[Home] [Help]

APPS.PQP_VEHICLE_DETAILS_API dependencies on HR_API

Line 171: -- raise hr_api.validate_enabled;

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

Line 182: when hr_api.validate_enabled then

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

Line 216: ,p_vehicle_type in varchar2 default hr_api.g_varchar2

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

Line 217: ,p_registration_number in varchar2 default hr_api.g_varchar2

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

Line 218: ,p_make in varchar2 default hr_api.g_varchar2

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

Line 219: ,p_model 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

Line 220: ,p_date_first_registered in date default hr_api.g_date

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

Line 221: ,p_engine_capacity_in_cc in number default hr_api.g_number

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

Line 222: ,p_fuel_type 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
226: ,p_business_group_id in number default hr_api.g_number

Line 223: ,p_fuel_card 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
227: ,p_accessory_value_at_startdate in number default hr_api.g_number

Line 224: ,p_currency_code 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
228: ,p_accessory_value_added_later in number default hr_api.g_number

Line 225: ,p_list_price 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

Line 226: ,p_business_group_id 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

Line 227: ,p_accessory_value_at_startdate 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

Line 228: ,p_accessory_value_added_later 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

Line 229: -- ,p_capital_contributions 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

Line 230: -- ,p_private_use_contributions 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
234: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2

Line 231: ,p_market_value_classic_car 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
235: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2

Line 232: ,p_co2_emissions 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
236: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2

Line 233: ,p_vehicle_provider 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

Line 234: ,p_vehicle_ownership 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

Line 235: ,p_vehicle_identification_numbe 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

Line 236: ,p_vhd_attribute_category 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

Line 237: ,p_vhd_attribute1 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

Line 238: ,p_vhd_attribute2 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

Line 239: ,p_vhd_attribute3 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

Line 240: ,p_vhd_attribute4 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

Line 241: ,p_vhd_attribute5 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

Line 242: ,p_vhd_attribute6 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

Line 243: ,p_vhd_attribute7 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

Line 244: ,p_vhd_attribute8 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

Line 245: ,p_vhd_attribute9 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

Line 246: ,p_vhd_attribute10 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

Line 247: ,p_vhd_attribute11 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

Line 248: ,p_vhd_attribute12 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

Line 249: ,p_vhd_attribute13 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

Line 250: ,p_vhd_attribute14 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

Line 251: ,p_vhd_attribute15 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

Line 252: ,p_vhd_attribute16 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

Line 253: ,p_vhd_attribute17 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

Line 254: ,p_vhd_attribute18 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

Line 255: ,p_vhd_attribute19 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

Line 256: ,p_vhd_attribute20 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

Line 257: ,p_vhd_information_category 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

Line 258: ,p_vhd_information1 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

Line 259: ,p_vhd_information2 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

Line 260: ,p_vhd_information3 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

Line 261: ,p_vhd_information4 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

Line 262: ,p_vhd_information5 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

Line 263: ,p_vhd_information6 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

Line 264: ,p_vhd_information7 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

Line 265: ,p_vhd_information8 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

Line 266: ,p_vhd_information9 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

Line 267: ,p_vhd_information10 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

Line 268: ,p_vhd_information11 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

Line 269: ,p_vhd_information12 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

Line 270: ,p_vhd_information13 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

Line 271: ,p_vhd_information14 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

Line 272: ,p_vhd_information15 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

Line 273: ,p_vhd_information16 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

Line 274: ,p_vhd_information17 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

Line 275: ,p_vhd_information18 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
279: --

Line 276: ,p_vhd_information19 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: --
280: -- Declare cursors and local variables

Line 277: ,p_vhd_information20 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
281: --

Line 375: -- raise hr_api.validate_enabled;

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

Line 385: when hr_api.validate_enabled then

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

Line 448: -- raise hr_api.validate_enabled;

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

Line 458: when hr_api.validate_enabled then

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