1 Package PQP_VEHICLE_REPOSITORY_API as
2 /* $Header: pqvreapi.pkh 120.1 2005/10/02 02:28:58 aroussel $ */
3 /*#
4 * This package contains vehicle repository APIs that can be used to create,
5 * update or delete a vehicle in the repository.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Vehicle Repository
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------------< create_vehicle >--------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API creates a vehicle in the repository, for example, a company or a
18 * private vehicle.
19 *
20 * This API creates a vehicle in the repository, for example, a company or a
21 * private vehicle. The vehicle can be car, van or a motorcycle and all
22 * attributes related to that vehicle can be stored.
23 *
24 * <p><b>Licensing</b><br>
25 * This API is licensed for use with Human Resources.
26 *
27 * <p><b>Prerequisites</b><br>
28 * Business group should be present before creating a vehicle repository.
29 *
30 * <p><b>Post Success</b><br>
31 * The vehicle repository record will be successfully inserted into the
32 * database.
33 *
34 * <p><b>Post Failure</b><br>
35 * The vehicle repository record will not be created and an error will be
36 * raised.
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
40 * @param p_effective_date Determines when the DateTrack operation comes into
41 * force.
42 * @param p_registration_number {@rep:casecolumn
43 * PQP_VEHICLE_REPOSITORY_F.REGISTRATION_NUMBER}
44 * @param p_vehicle_type {@rep:casecolumn
45 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_TYPE}
46 * @param p_vehicle_id_number {@rep:casecolumn
47 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_ID_NUMBER}
48 * @param p_business_group_id {@rep:casecolumn
49 * PQP_VEHICLE_REPOSITORY_F.BUSINESS_GROUP_ID}
50 * @param p_make {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.MAKE}
51 * @param p_engine_capacity_in_cc {@rep:casecolumn
52 * PQP_VEHICLE_REPOSITORY_F.ENGINE_CAPACITY_IN_CC}
53 * @param p_fuel_type {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.FUEL_TYPE}
54 * @param p_currency_code {@rep:casecolumn
55 * PQP_VEHICLE_REPOSITORY_F.CURRENCY_CODE}
56 * @param p_vehicle_status {@rep:casecolumn
57 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_STATUS}
58 * @param p_vehicle_inactivity_reason {@rep:casecolumn
59 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_INACTIVITY_REASON}
60 * @param p_model {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.MODEL}
61 * @param p_initial_registration {@rep:casecolumn
62 * PQP_VEHICLE_REPOSITORY_F.INITIAL_REGISTRATION}
63 * @param p_last_registration_renew_date {@rep:casecolumn
64 * PQP_VEHICLE_REPOSITORY_F.LAST_REGISTRATION_RENEW_DATE}
65 * @param p_list_price {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.LIST_PRICE}
66 * @param p_accessory_value_at_startdate {@rep:casecolumn
67 * PQP_VEHICLE_REPOSITORY_F.ACCESSORY_VALUE_AT_STARTDATE}
68 * @param p_accessory_value_added_later {@rep:casecolumn
69 * PQP_VEHICLE_REPOSITORY_F.ACCESSORY_VALUE_ADDED_LATER}
70 * @param p_market_value_classic_car {@rep:casecolumn
71 * PQP_VEHICLE_REPOSITORY_F.MARKET_VALUE_CLASSIC_CAR}
72 * @param p_fiscal_ratings {@rep:casecolumn
73 * PQP_VEHICLE_REPOSITORY_F.FISCAL_RATINGS}
74 * @param p_fiscal_ratings_uom {@rep:casecolumn
75 * PQP_VEHICLE_REPOSITORY_F.FISCAL_RATINGS_UOM}
76 * @param p_vehicle_provider {@rep:casecolumn
77 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_PROVIDER}
78 * @param p_vehicle_ownership {@rep:casecolumn
79 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_OWNERSHIP}
80 * @param p_shared_vehicle {@rep:casecolumn
81 * PQP_VEHICLE_REPOSITORY_F.SHARED_VEHICLE}
82 * @param p_asset_number {@rep:casecolumn
83 * PQP_VEHICLE_REPOSITORY_F.ASSET_NUMBER}
84 * @param p_lease_contract_number {@rep:casecolumn
85 * PQP_VEHICLE_REPOSITORY_F.LEASE_CONTRACT_NUMBER}
86 * @param p_lease_contract_expiry_date {@rep:casecolumn
87 * PQP_VEHICLE_REPOSITORY_F.LEASE_CONTRACT_EXPIRY_DATE}
88 * @param p_taxation_method {@rep:casecolumn
89 * PQP_VEHICLE_REPOSITORY_F.TAXATION_METHOD}
90 * @param p_fleet_info {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.FLEET_INFO}
91 * @param p_fleet_transfer_date {@rep:casecolumn
92 * PQP_VEHICLE_REPOSITORY_F.FLEET_TRANSFER_DATE}
93 * @param p_color The color of the vehicle. The value is from the lookkup
94 * PQP_VEHICLE_COLOR.
95 * @param p_seating_capacity The passenger seating capacity for the vehicle.
96 * @param p_weight The weight of the vehicle, the unit of measure is stored in
97 * weight_uom column.
98 * @param p_weight_uom The unit of measure for the weight column. The value is
99 * from the lookup PQP_WEIGHT_UOM.
100 * @param p_model_year The model year for the vehicle.
101 * @param p_insurance_number The insurance details for the vehicle.
102 * @param p_insurance_expiry_date Insurance expiration date for the vehicle.
103 * @param p_comments Free text to store any comments.
104 * @param p_vre_attribute_category {@rep:casecolumn
105 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE_CATEGORY}
106 * @param p_vre_attribute1 {@rep:casecolumn
107 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE1}
108 * @param p_vre_attribute2 {@rep:casecolumn
109 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE2}
110 * @param p_vre_attribute3 {@rep:casecolumn
111 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE3}
112 * @param p_vre_attribute4 {@rep:casecolumn
113 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE4}
114 * @param p_vre_attribute5 {@rep:casecolumn
115 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE5}
116 * @param p_vre_attribute6 {@rep:casecolumn
117 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE6}
118 * @param p_vre_attribute7 {@rep:casecolumn
119 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE7}
120 * @param p_vre_attribute8 {@rep:casecolumn
121 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE8}
122 * @param p_vre_attribute9 {@rep:casecolumn
123 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE9}
124 * @param p_vre_attribute10 {@rep:casecolumn
125 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE10}
126 * @param p_vre_attribute11 {@rep:casecolumn
127 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE11}
128 * @param p_vre_attribute12 {@rep:casecolumn
129 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE12}
130 * @param p_vre_attribute13 {@rep:casecolumn
131 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE13}
132 * @param p_vre_attribute14 {@rep:casecolumn
133 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE14}
134 * @param p_vre_attribute15 {@rep:casecolumn
135 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE15}
136 * @param p_vre_attribute16 {@rep:casecolumn
137 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE16}
138 * @param p_vre_attribute17 {@rep:casecolumn
139 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE17}
140 * @param p_vre_attribute18 {@rep:casecolumn
141 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE18}
142 * @param p_vre_attribute19 {@rep:casecolumn
143 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE19}
144 * @param p_vre_attribute20 {@rep:casecolumn
145 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE20}
146 * @param p_vre_information_category {@rep:casecolumn
147 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION_CATEGORY}
148 * @param p_vre_information1 {@rep:casecolumn
149 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION1}
150 * @param p_vre_information2 {@rep:casecolumn
151 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION2}
152 * @param p_vre_information3 {@rep:casecolumn
153 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION3}
154 * @param p_vre_information4 {@rep:casecolumn
155 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION4}
156 * @param p_vre_information5 {@rep:casecolumn
157 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION5}
158 * @param p_vre_information6 {@rep:casecolumn
159 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION6}
160 * @param p_vre_information7 {@rep:casecolumn
161 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION7}
162 * @param p_vre_information8 {@rep:casecolumn
163 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION8}
164 * @param p_vre_information9 {@rep:casecolumn
165 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION9}
166 * @param p_vre_information10 {@rep:casecolumn
167 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION10}
168 * @param p_vre_information11 {@rep:casecolumn
169 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION11}
170 * @param p_vre_information12 {@rep:casecolumn
171 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION12}
172 * @param p_vre_information13 {@rep:casecolumn
173 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION13}
174 * @param p_vre_information14 {@rep:casecolumn
175 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION14}
176 * @param p_vre_information15 {@rep:casecolumn
177 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION15}
178 * @param p_vre_information16 {@rep:casecolumn
179 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION16}
180 * @param p_vre_information17 {@rep:casecolumn
181 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION17}
182 * @param p_vre_information18 {@rep:casecolumn
183 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION18}
184 * @param p_vre_information19 {@rep:casecolumn
185 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION19}
186 * @param p_vre_information20 {@rep:casecolumn
187 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION20}
188 * @param p_vehicle_repository_id {@rep:casecolumn
189 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_REPOSITORY_ID}
190 * @param p_object_version_number If p_validate is false, then set to the
191 * version number of the created Vehicle Repository. If p_validate is true,
192 * then the value will be null.
193 * @param p_effective_start_date If p_validate is false, then set to the
194 * earliest effective start date for the created Vehicle Repository. If
195 * p_validate is true, then set to null.
196 * @param p_effective_end_date If p_validate is false, then set to the
197 * effective end date for the createdVehicle Repository. If p_validate is true,
198 * then set to null.
199 * @rep:displayname Create Vehicle Repository
200 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
201 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
202 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
203 * @rep:scope public
204 * @rep:lifecycle active
205 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
206 */
207 --
208 -- {End Of Comments}
209 --
210 procedure create_vehicle
211 (p_validate in boolean default false
212 ,p_effective_date in date
213 ,p_registration_number in varchar2 default null
214 ,p_vehicle_type in varchar2
215 ,p_vehicle_id_number in varchar2 default null
216 ,p_business_group_id in number
217 ,p_make in varchar2
218 ,p_engine_capacity_in_cc in number default null
219 ,p_fuel_type in varchar2 default null
220 ,p_currency_code in varchar2 default null
221 ,p_vehicle_status in varchar2 default 'A'
222 ,p_vehicle_inactivity_reason in varchar2 default null
223 ,p_model in varchar2
224 ,p_initial_registration in date default null
225 ,p_last_registration_renew_date in date default null
226 ,p_list_price in number default null
227 ,p_accessory_value_at_startdate in number default null
228 ,p_accessory_value_added_later in number default null
229 ,p_market_value_classic_car in number default null
230 ,p_fiscal_ratings in number default null
231 ,p_fiscal_ratings_uom in varchar2 default null
232 ,p_vehicle_provider in varchar2 default null
233 ,p_vehicle_ownership in varchar2 default null
234 ,p_shared_vehicle in varchar2 default null
235 ,p_asset_number in varchar2 default null
236 ,p_lease_contract_number in varchar2 default null
237 ,p_lease_contract_expiry_date in date default null
238 ,p_taxation_method in varchar2 default null
239 ,p_fleet_info in varchar2 default null
240 ,p_fleet_transfer_date in date default null
241 ,p_color in varchar2 default null
242 ,p_seating_capacity in number default null
243 ,p_weight in number default null
244 ,p_weight_uom in varchar2 default null
245 ,p_model_year in number default null
246 ,p_insurance_number in varchar2 default null
247 ,p_insurance_expiry_date in date default null
248 ,p_comments in varchar2 default null
249 ,p_vre_attribute_category in varchar2 default null
250 ,p_vre_attribute1 in varchar2 default null
251 ,p_vre_attribute2 in varchar2 default null
252 ,p_vre_attribute3 in varchar2 default null
253 ,p_vre_attribute4 in varchar2 default null
254 ,p_vre_attribute5 in varchar2 default null
255 ,p_vre_attribute6 in varchar2 default null
256 ,p_vre_attribute7 in varchar2 default null
257 ,p_vre_attribute8 in varchar2 default null
258 ,p_vre_attribute9 in varchar2 default null
259 ,p_vre_attribute10 in varchar2 default null
260 ,p_vre_attribute11 in varchar2 default null
261 ,p_vre_attribute12 in varchar2 default null
262 ,p_vre_attribute13 in varchar2 default null
263 ,p_vre_attribute14 in varchar2 default null
264 ,p_vre_attribute15 in varchar2 default null
265 ,p_vre_attribute16 in varchar2 default null
266 ,p_vre_attribute17 in varchar2 default null
267 ,p_vre_attribute18 in varchar2 default null
268 ,p_vre_attribute19 in varchar2 default null
269 ,p_vre_attribute20 in varchar2 default null
270 ,p_vre_information_category in varchar2 default null
271 ,p_vre_information1 in varchar2 default null
272 ,p_vre_information2 in varchar2 default null
273 ,p_vre_information3 in varchar2 default null
274 ,p_vre_information4 in varchar2 default null
275 ,p_vre_information5 in varchar2 default null
276 ,p_vre_information6 in varchar2 default null
277 ,p_vre_information7 in varchar2 default null
278 ,p_vre_information8 in varchar2 default null
279 ,p_vre_information9 in varchar2 default null
280 ,p_vre_information10 in varchar2 default null
281 ,p_vre_information11 in varchar2 default null
282 ,p_vre_information12 in varchar2 default null
283 ,p_vre_information13 in varchar2 default null
284 ,p_vre_information14 in varchar2 default null
285 ,p_vre_information15 in varchar2 default null
286 ,p_vre_information16 in varchar2 default null
287 ,p_vre_information17 in varchar2 default null
288 ,p_vre_information18 in varchar2 default null
289 ,p_vre_information19 in varchar2 default null
290 ,p_vre_information20 in varchar2 default null
291 ,p_vehicle_repository_id out NOCOPY number
292 ,p_object_version_number out NOCOPY number
293 ,p_effective_start_date out NOCOPY date
294 ,p_effective_end_date out NOCOPY date
295 );
296 --
297 -- ----------------------------------------------------------------------------
298 -- |------------------------------< update_vehicle >--------------------------|
299 -- ----------------------------------------------------------------------------
300 --
301 -- {Start Of Comments}
302 /*#
303 * This API updates vehicle repository records.
304 *
305 * This API updates a vehicle in the repository. All attributes may not be
306 * changed if the vehicle is already allocated to an assignment.
307 *
308 * <p><b>Licensing</b><br>
309 * This API is licensed for use with Human Resources.
310 *
311 * <p><b>Prerequisites</b><br>
312 * Vehicle repository record should be present before updating a vehicle
313 * repository.
314 *
315 * <p><b>Post Success</b><br>
316 * The vehicle repository record will be successfully updated into the
317 * database.
318 *
319 * <p><b>Post Failure</b><br>
320 * The vehicle repository record will not be updated and an error will be
321 * raised.
322 * @param p_validate If true, then validation alone will be performed and the
323 * database will remain unchanged. If false and all validation checks pass,
324 * then the database will be modified.
325 * @param p_effective_date Determines when the DateTrack operation comes into
326 * force.
327 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
328 * the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or
329 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
330 * depend on the dates of previous record changes and the effective date of
331 * this change.
332 * @param p_vehicle_repository_id {@rep:casecolumn
333 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_REPOSITORY_ID}
334 * @param p_object_version_number Pass in the current version number of the
335 * vehicle repository to be updated. When the API completes if p_validate is
336 * false, will be set to the new version number of the updated Vehicle
340 * PQP_VEHICLE_REPOSITORY_F.REGISTRATION_NUMBER}
337 * Repository. If p_validate is true will be set to the same value which was
338 * passed in.
339 * @param p_registration_number {@rep:casecolumn
341 * @param p_vehicle_type {@rep:casecolumn
342 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_TYPE}
343 * @param p_vehicle_id_number {@rep:casecolumn
344 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_ID_NUMBER}
345 * @param p_business_group_id {@rep:casecolumn
346 * PQP_VEHICLE_REPOSITORY_F.BUSINESS_GROUP_ID}
347 * @param p_make {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.MAKE}
348 * @param p_engine_capacity_in_cc {@rep:casecolumn
349 * PQP_VEHICLE_REPOSITORY_F.ENGINE_CAPACITY_IN_CC}
350 * @param p_fuel_type {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.FUEL_TYPE}
351 * @param p_currency_code {@rep:casecolumn
352 * PQP_VEHICLE_REPOSITORY_F.CURRENCY_CODE}
353 * @param p_vehicle_status {@rep:casecolumn
354 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_STATUS}
355 * @param p_vehicle_inactivity_reason {@rep:casecolumn
356 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_INACTIVITY_REASON}
357 * @param p_model {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.MODEL}
358 * @param p_initial_registration {@rep:casecolumn
359 * PQP_VEHICLE_REPOSITORY_F.INITIAL_REGISTRATION}
360 * @param p_last_registration_renew_date {@rep:casecolumn
361 * PQP_VEHICLE_REPOSITORY_F.LAST_REGISTRATION_RENEW_DATE}
362 * @param p_list_price {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.LIST_PRICE}
363 * @param p_accessory_value_at_startdate {@rep:casecolumn
364 * PQP_VEHICLE_REPOSITORY_F.ACCESSORY_VALUE_AT_STARTDATE}
365 * @param p_accessory_value_added_later {@rep:casecolumn
366 * PQP_VEHICLE_REPOSITORY_F.ACCESSORY_VALUE_ADDED_LATER}
367 * @param p_market_value_classic_car {@rep:casecolumn
368 * PQP_VEHICLE_REPOSITORY_F.MARKET_VALUE_CLASSIC_CAR}
369 * @param p_fiscal_ratings {@rep:casecolumn
370 * PQP_VEHICLE_REPOSITORY_F.FISCAL_RATINGS}
371 * @param p_fiscal_ratings_uom {@rep:casecolumn
372 * PQP_VEHICLE_REPOSITORY_F.FISCAL_RATINGS_UOM}
373 * @param p_vehicle_provider {@rep:casecolumn
374 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_PROVIDER}
375 * @param p_vehicle_ownership {@rep:casecolumn
376 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_OWNERSHIP}
377 * @param p_shared_vehicle {@rep:casecolumn
378 * PQP_VEHICLE_REPOSITORY_F.SHARED_VEHICLE}
379 * @param p_asset_number {@rep:casecolumn
380 * PQP_VEHICLE_REPOSITORY_F.ASSET_NUMBER}
381 * @param p_lease_contract_number {@rep:casecolumn
382 * PQP_VEHICLE_REPOSITORY_F.LEASE_CONTRACT_NUMBER}
383 * @param p_lease_contract_expiry_date {@rep:casecolumn
384 * PQP_VEHICLE_REPOSITORY_F.LEASE_CONTRACT_EXPIRY_DATE}
385 * @param p_taxation_method {@rep:casecolumn
386 * PQP_VEHICLE_REPOSITORY_F.TAXATION_METHOD}
387 * @param p_fleet_info {@rep:casecolumn PQP_VEHICLE_REPOSITORY_F.FLEET_INFO}
388 * @param p_fleet_transfer_date {@rep:casecolumn
389 * PQP_VEHICLE_REPOSITORY_F.FLEET_TRANSFER_DATE}
390 * @param p_color The color of the vehicle. The value is from the lookkup
391 * PQP_VEHICLE_COLOR.
392 * @param p_seating_capacity The passenger seating capacity for the vehicle.
393 * @param p_weight The weight of the vehicle, the unit of measure is stored in
394 * weight_uom column.
395 * @param p_weight_uom The unit of measure for the weight column. The value is
396 * from the lookup PQP_WEIGHT_UOM.
397 * @param p_model_year The model year for the vehicle.
398 * @param p_insurance_number The insurance details for the vehicle.
399 * @param p_insurance_expiry_date Insurance expiration date for the vehicle.
400 * @param p_comments Free text to store any comments.
401 * @param p_vre_attribute_category {@rep:casecolumn
402 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE_CATEGORY}
403 * @param p_vre_attribute1 {@rep:casecolumn
404 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE1}
405 * @param p_vre_attribute2 {@rep:casecolumn
406 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE2}
407 * @param p_vre_attribute3 {@rep:casecolumn
408 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE3}
409 * @param p_vre_attribute4 {@rep:casecolumn
410 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE4}
411 * @param p_vre_attribute5 {@rep:casecolumn
412 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE5}
413 * @param p_vre_attribute6 {@rep:casecolumn
414 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE6}
415 * @param p_vre_attribute7 {@rep:casecolumn
416 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE7}
417 * @param p_vre_attribute8 {@rep:casecolumn
418 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE8}
419 * @param p_vre_attribute9 {@rep:casecolumn
420 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE9}
421 * @param p_vre_attribute10 {@rep:casecolumn
422 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE10}
423 * @param p_vre_attribute11 {@rep:casecolumn
424 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE11}
425 * @param p_vre_attribute12 {@rep:casecolumn
426 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE12}
427 * @param p_vre_attribute13 {@rep:casecolumn
428 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE13}
429 * @param p_vre_attribute14 {@rep:casecolumn
430 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE14}
431 * @param p_vre_attribute15 {@rep:casecolumn
432 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE15}
433 * @param p_vre_attribute16 {@rep:casecolumn
434 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE16}
435 * @param p_vre_attribute17 {@rep:casecolumn
436 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE17}
437 * @param p_vre_attribute18 {@rep:casecolumn
438 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE18}
439 * @param p_vre_attribute19 {@rep:casecolumn
440 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE19}
441 * @param p_vre_attribute20 {@rep:casecolumn
442 * PQP_VEHICLE_REPOSITORY_F.VRE_ATTRIBUTE20}
443 * @param p_vre_information_category {@rep:casecolumn
444 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION_CATEGORY}
445 * @param p_vre_information1 {@rep:casecolumn
446 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION1}
447 * @param p_vre_information2 {@rep:casecolumn
451 * @param p_vre_information4 {@rep:casecolumn
448 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION2}
449 * @param p_vre_information3 {@rep:casecolumn
450 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION3}
452 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION4}
453 * @param p_vre_information5 {@rep:casecolumn
454 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION5}
455 * @param p_vre_information6 {@rep:casecolumn
456 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION6}
457 * @param p_vre_information7 {@rep:casecolumn
458 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION7}
459 * @param p_vre_information8 {@rep:casecolumn
460 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION8}
461 * @param p_vre_information9 {@rep:casecolumn
462 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION9}
463 * @param p_vre_information10 {@rep:casecolumn
464 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION10}
465 * @param p_vre_information11 {@rep:casecolumn
466 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION11}
467 * @param p_vre_information12 {@rep:casecolumn
468 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION12}
469 * @param p_vre_information13 {@rep:casecolumn
470 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION13}
471 * @param p_vre_information14 {@rep:casecolumn
472 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION14}
473 * @param p_vre_information15 {@rep:casecolumn
474 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION15}
475 * @param p_vre_information16 {@rep:casecolumn
476 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION16}
477 * @param p_vre_information17 {@rep:casecolumn
478 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION17}
479 * @param p_vre_information18 {@rep:casecolumn
480 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION18}
481 * @param p_vre_information19 {@rep:casecolumn
482 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION19}
483 * @param p_vre_information20 {@rep:casecolumn
484 * PQP_VEHICLE_REPOSITORY_F.VRE_INFORMATION20}
485 * @param p_effective_start_date If p_validate is false, then set to the
486 * effective start date on the updated vehicle repository row which now exists
487 * as of the effective date. If p_validate is true, then set to null.
488 * @param p_effective_end_date If p_validate is false, then set to the
489 * effective end date on the updated vehicle repository row which now exists as
490 * of the effective date. If p_validate is true, then set to null.
491 * @rep:displayname Update Vehicle Repository
492 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
493 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
494 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
495 * @rep:scope public
496 * @rep:lifecycle active
497 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
498 */
499 --
500 -- {End Of Comments}
501 --
502 Procedure update_vehicle
503 (p_validate in boolean default false
504 ,p_effective_date in date
505 ,p_datetrack_mode in varchar2
506 ,p_vehicle_repository_id in number
507 ,p_object_version_number in out NOCOPY number
508 ,p_registration_number in varchar2 default hr_api.g_varchar2
509 ,p_vehicle_type in varchar2 default hr_api.g_varchar2
510 ,p_vehicle_id_number in varchar2 default hr_api.g_varchar2
511 ,p_business_group_id in number default hr_api.g_number
512 ,p_make in varchar2 default hr_api.g_varchar2
513 ,p_engine_capacity_in_cc in number default hr_api.g_number
514 ,p_fuel_type in varchar2 default hr_api.g_varchar2
515 ,p_currency_code in varchar2 default hr_api.g_varchar2
516 ,p_vehicle_status in varchar2 default hr_api.g_varchar2
517 ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
518 ,p_model in varchar2 default hr_api.g_varchar2
519 ,p_initial_registration in date default hr_api.g_date
520 ,p_last_registration_renew_date in date default hr_api.g_date
524 ,p_market_value_classic_car in number default hr_api.g_number
521 ,p_list_price in number default hr_api.g_number
522 ,p_accessory_value_at_startdate in number default hr_api.g_number
523 ,p_accessory_value_added_later in number default hr_api.g_number
525 ,p_fiscal_ratings in number default hr_api.g_number
526 ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
527 ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
528 ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
529 ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
530 ,p_asset_number in varchar2 default hr_api.g_varchar2
531 ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
532 ,p_lease_contract_expiry_date in date default hr_api.g_date
533 ,p_taxation_method in varchar2 default hr_api.g_varchar2
534 ,p_fleet_info in varchar2 default hr_api.g_varchar2
535 ,p_fleet_transfer_date in date default hr_api.g_date
536 ,p_color in varchar2 default hr_api.g_varchar2
537 ,p_seating_capacity in number default hr_api.g_number
538 ,p_weight in number default hr_api.g_number
539 ,p_weight_uom in varchar2 default hr_api.g_varchar2
540 ,p_model_year in number default hr_api.g_number
541 ,p_insurance_number in varchar2 default hr_api.g_varchar2
542 ,p_insurance_expiry_date in date default hr_api.g_date
543 ,p_comments in varchar2 default hr_api.g_varchar2
544 ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
545 ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
546 ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
547 ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
548 ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
549 ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
550 ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
551 ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
552 ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
553 ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
554 ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
555 ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
556 ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
557 ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
558 ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
559 ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
560 ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
561 ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
562 ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
563 ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
564 ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
565 ,p_vre_information_category in varchar2 default hr_api.g_varchar2
566 ,p_vre_information1 in varchar2 default hr_api.g_varchar2
567 ,p_vre_information2 in varchar2 default hr_api.g_varchar2
568 ,p_vre_information3 in varchar2 default hr_api.g_varchar2
569 ,p_vre_information4 in varchar2 default hr_api.g_varchar2
570 ,p_vre_information5 in varchar2 default hr_api.g_varchar2
571 ,p_vre_information6 in varchar2 default hr_api.g_varchar2
572 ,p_vre_information7 in varchar2 default hr_api.g_varchar2
576 ,p_vre_information11 in varchar2 default hr_api.g_varchar2
573 ,p_vre_information8 in varchar2 default hr_api.g_varchar2
574 ,p_vre_information9 in varchar2 default hr_api.g_varchar2
575 ,p_vre_information10 in varchar2 default hr_api.g_varchar2
577 ,p_vre_information12 in varchar2 default hr_api.g_varchar2
578 ,p_vre_information13 in varchar2 default hr_api.g_varchar2
579 ,p_vre_information14 in varchar2 default hr_api.g_varchar2
580 ,p_vre_information15 in varchar2 default hr_api.g_varchar2
581 ,p_vre_information16 in varchar2 default hr_api.g_varchar2
582 ,p_vre_information17 in varchar2 default hr_api.g_varchar2
583 ,p_vre_information18 in varchar2 default hr_api.g_varchar2
584 ,p_vre_information19 in varchar2 default hr_api.g_varchar2
585 ,p_vre_information20 in varchar2 default hr_api.g_varchar2
586 ,p_effective_start_date out NOCOPY date
587 ,p_effective_end_date out NOCOPY date
588 );
589 --
590 -- ----------------------------------------------------------------------------
591 -- |------------------------------< delete_vehicle >--------------------------|
592 -- ----------------------------------------------------------------------------
593 --
594 -- {Start Of Comments}
595 /*#
596 * This API deletes a vehicle in the repository.
597 *
598 *
599 * <p><b>Licensing</b><br>
600 * This API is licensed for use with Human Resources.
601 *
602 * <p><b>Prerequisites</b><br>
603 * Vehicle repository record should be present before deleting a vehicle
604 * repository and the vehicle should not be allocated for an assignment.
605 *
606 * <p><b>Post Success</b><br>
607 * The vehicle repository record will be successfully deleted from the
608 * database.
609 *
610 * <p><b>Post Failure</b><br>
611 * The vehicle repository record will not be deleted and an error will be
612 * raised.
613 * @param p_validate If true, then validation alone will be performed and the
614 * database will remain unchanged. If false and all validation checks pass,
615 * then the database will be modified.
616 * @param p_effective_date Determines when the DateTrack operation comes into
617 * force.
618 * @param p_datetrack_mode Indicates which DateTrack mode to use when deleting
619 * the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
620 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
621 * on the dates of previous record changes and the effective date of this
622 * change
623 * @param p_vehicle_repository_id {@rep:casecolumn
624 * PQP_VEHICLE_REPOSITORY_F.VEHICLE_REPOSITORY_ID}
625 * @param p_object_version_number Current version number of the vehicle
626 * allocation to be deleted.
627 * @param p_effective_start_date If p_validate is false, then set to the
628 * effective start date for the deleted vehicle repository row which now exists
629 * as of the effective date. If p_validate is true or all row instances have
630 * been deleted then set to null.
631 * @param p_effective_end_date If p_validate is false, then set to the
632 * effective end date for the deleted vehicle repository. If p_validate is
633 * true, then set to null.
634 * @rep:displayname Delete Vehicle Repository
635 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
636 * @rep:category MISC_EXTENSIONS HR_DATAPUMP
637 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
638 * @rep:scope public
639 * @rep:lifecycle active
640 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
641 */
642 --
643 -- {End Of Comments}
644 --
645 Procedure delete_vehicle
646 (p_validate in boolean default false
647 ,p_effective_date in date
648 ,p_datetrack_mode in varchar2
649 ,p_vehicle_repository_id in number
650 ,p_object_version_number in out NOCOPY number
651 ,p_effective_start_date out NOCOPY date
652 ,p_effective_end_date out NOCOPY date
653 );
654
655 end PQP_VEHICLE_REPOSITORY_API;
[Home] [Help]