1 Package PQP_VEHICLE_ALLOCATIONS_API AUTHID CURRENT_USER as
2 /* $Header: pqvalapi.pkh 120.1 2005/10/02 02:28:38 aroussel $ */
3 /*#
4 * This package contains APIs to create, update or delete a Vehicle Allocation
5 * to an employee assignment.
6 * @rep:scope public
7 * @rep:product per
8 * @rep:displayname Vehicle Allocation
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------< create_vehicle_allocation >---------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API allocates a vehicle from the vehicle repository to an assignment.
18 *
19 * This API creates a vehicle allocation record for an assignment. The vehicle
20 * should already exist in the Vehicle Repository. Some of the attributes
21 * depends on whether it is a company or a private vehicle. Additional details
22 * related to the mileage reimbursements can also be stored. If 'Y' is passed
23 * to p_accross_assignments then the vehicle will be allocated to all
24 * assignments for that employee.
25 *
26 * <p><b>Licensing</b><br>
27 * This API is licensed for use with Human Resources.
28 *
29 * <p><b>Prerequisites</b><br>
30 * Vehicle should be present in the vehicle repository before allocating to an
31 * assignment.
32 *
33 * <p><b>Post Success</b><br>
34 * The vehicle allocation record will be successfully inserted into the
35 * database.
36 *
37 * <p><b>Post Failure</b><br>
38 * The vehicle allocation record will not be created and an error will be
39 * raised.
40 * @param p_validate If true, then validation alone will be performed and the
41 * database will remain unchanged. If false and all validation checks pass,
42 * then the database will be modified.
43 * @param p_effective_date Determines when the DateTrack operation comes into
44 * force.
45 * @param p_assignment_id Identifies the assignment for which you create the
46 * vehicle allocation record.
47 * @param p_business_group_id {@rep:casecolumn
48 * PQP_VEHICLE_ALLOCATIONS_F.BUSINESS_GROUP_ID}
49 * @param p_vehicle_repository_id {@rep:casecolumn
50 * PQP_VEHICLE_ALLOCATIONS_F.VEHICLE_REPOSITORY_ID}
51 * @param p_across_assignments {@rep:casecolumn
52 * PQP_VEHICLE_ALLOCATIONS_F.ACROSS_ASSIGNMENTS}
53 * @param p_usage_type {@rep:casecolumn PQP_VEHICLE_ALLOCATIONS_F.USAGE_TYPE}
54 * @param p_capital_contribution {@rep:casecolumn
55 * PQP_VEHICLE_ALLOCATIONS_F.CAPITAL_CONTRIBUTION}
56 * @param p_private_contribution {@rep:casecolumn
57 * PQP_VEHICLE_ALLOCATIONS_F.PRIVATE_CONTRIBUTION}
58 * @param p_default_vehicle {@rep:casecolumn
59 * PQP_VEHICLE_ALLOCATIONS_F.DEFAULT_VEHICLE}
60 * @param p_fuel_card {@rep:casecolumn PQP_VEHICLE_ALLOCATIONS_F.FUEL_CARD}
61 * @param p_fuel_card_number {@rep:casecolumn
62 * PQP_VEHICLE_ALLOCATIONS_F.FUEL_CARD_NUMBER}
63 * @param p_calculation_method {@rep:casecolumn
64 * PQP_VEHICLE_ALLOCATIONS_F.CALCULATION_METHOD}
65 * @param p_rates_table_id {@rep:casecolumn
66 * PQP_VEHICLE_ALLOCATIONS_F.RATES_TABLE_ID}
67 * @param p_element_type_id {@rep:casecolumn
68 * PQP_VEHICLE_ALLOCATIONS_F.ELEMENT_TYPE_ID}
69 * @param p_private_use_flag Indicates whether the company vehicle user can use
70 * this vehicle for private purposes.
71 * @param p_insurance_number The insurance details for the vehicle.
72 * @param p_insurance_expiry_date Insurance expiration date.
73 * @param p_val_attribute_category {@rep:casecolumn
74 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE_CATEGORY}
75 * @param p_val_attribute1 {@rep:casecolumn
76 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE1}
77 * @param p_val_attribute2 {@rep:casecolumn
78 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE2}
79 * @param p_val_attribute3 {@rep:casecolumn
80 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE3}
81 * @param p_val_attribute4 {@rep:casecolumn
82 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE4}
83 * @param p_val_attribute5 {@rep:casecolumn
84 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE5}
85 * @param p_val_attribute6 {@rep:casecolumn
86 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE6}
87 * @param p_val_attribute7 {@rep:casecolumn
88 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE7}
89 * @param p_val_attribute8 {@rep:casecolumn
90 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE8}
91 * @param p_val_attribute9 {@rep:casecolumn
92 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE9}
93 * @param p_val_attribute10 {@rep:casecolumn
94 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE10}
95 * @param p_val_attribute11 {@rep:casecolumn
96 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE11}
97 * @param p_val_attribute12 {@rep:casecolumn
98 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE12}
99 * @param p_val_attribute13 {@rep:casecolumn
100 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE13}
101 * @param p_val_attribute14 {@rep:casecolumn
102 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE14}
103 * @param p_val_attribute15 {@rep:casecolumn
104 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE15}
105 * @param p_val_attribute16 {@rep:casecolumn
106 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE16}
107 * @param p_val_attribute17 {@rep:casecolumn
108 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE17}
109 * @param p_val_attribute18 {@rep:casecolumn
110 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE18}
111 * @param p_val_attribute19 {@rep:casecolumn
112 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE19}
113 * @param p_val_attribute20 {@rep:casecolumn
114 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE20}
115 * @param p_val_information_category {@rep:casecolumn
116 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION_CATEGORY}
117 * @param p_val_information1 {@rep:casecolumn
118 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION1}
122 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION3}
119 * @param p_val_information2 {@rep:casecolumn
120 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION2}
121 * @param p_val_information3 {@rep:casecolumn
123 * @param p_val_information4 {@rep:casecolumn
124 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION4}
125 * @param p_val_information5 {@rep:casecolumn
126 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION5}
127 * @param p_val_information6 {@rep:casecolumn
128 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION6}
129 * @param p_val_information7 {@rep:casecolumn
130 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION7}
131 * @param p_val_information8 {@rep:casecolumn
132 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION8}
133 * @param p_val_information9 {@rep:casecolumn
134 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION9}
135 * @param p_val_information10 {@rep:casecolumn
136 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION10}
137 * @param p_val_information11 {@rep:casecolumn
138 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION11}
139 * @param p_val_information12 {@rep:casecolumn
140 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION12}
141 * @param p_val_information13 {@rep:casecolumn
142 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION13}
143 * @param p_val_information14 {@rep:casecolumn
144 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION14}
145 * @param p_val_information15 {@rep:casecolumn
146 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION15}
147 * @param p_val_information16 {@rep:casecolumn
148 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION16}
149 * @param p_val_information17 {@rep:casecolumn
150 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION17}
151 * @param p_val_information18 {@rep:casecolumn
152 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION18}
153 * @param p_val_information19 {@rep:casecolumn
154 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION19}
155 * @param p_val_information20 {@rep:casecolumn
156 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION20}
157 * @param p_fuel_benefit {@rep:casecolumn
158 * PQP_VEHICLE_ALLOCATIONS_F.FUEL_BENEFIT}
159 * @param p_sliding_rates_info The Sliding rates table information using the
160 * lookup PQP_SLIDING_RATES.
161 * @param p_vehicle_allocation_id {@rep:casecolumn
162 * PQP_VEHICLE_ALLOCATIONS_F.VEHICLE_ALLOCATION_ID}
163 * @param p_object_version_number If p_validate is false, then set to the
164 * version number of the allocated vehicle. If p_validate is true, then the
165 * value will be null.
166 * @param p_effective_start_date If p_validate is false, then set to the
167 * earliest effective start date for the allocated vehicle. If p_validate is
168 * true, then set to null.
169 * @param p_effective_end_date If p_validate is false, then set to the
170 * effective end date for the allocated vehicle. If p_validate is true, then
171 * set to null.
172 * @rep:displayname Create Vehicle Allocation
173 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
174 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
175 * @rep:scope public
176 * @rep:lifecycle active
177 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
178 */
179 --
180 -- {End Of Comments}
181 --
182 procedure create_vehicle_allocation
183 (p_validate in boolean default false
184 ,p_effective_date in date
185 ,p_assignment_id in number
186 ,p_business_group_id in number
187 ,p_vehicle_repository_id in number default null
188 ,p_across_assignments in varchar2 default null
189 ,p_usage_type in varchar2 default null
190 ,p_capital_contribution in number default null
191 ,p_private_contribution in number default null
192 ,p_default_vehicle in varchar2 default null
193 ,p_fuel_card in varchar2 default null
194 ,p_fuel_card_number in varchar2 default null
195 ,p_calculation_method in varchar2 default null
196 ,p_rates_table_id in number default null
197 ,p_element_type_id in number default null
198 ,p_private_use_flag in varchar2 default null
199 ,p_insurance_number in varchar2 default null
200 ,p_insurance_expiry_date in date default null
201 ,p_val_attribute_category in varchar2 default null
202 ,p_val_attribute1 in varchar2 default null
203 ,p_val_attribute2 in varchar2 default null
204 ,p_val_attribute3 in varchar2 default null
205 ,p_val_attribute4 in varchar2 default null
206 ,p_val_attribute5 in varchar2 default null
207 ,p_val_attribute6 in varchar2 default null
208 ,p_val_attribute7 in varchar2 default null
209 ,p_val_attribute8 in varchar2 default null
210 ,p_val_attribute9 in varchar2 default null
211 ,p_val_attribute10 in varchar2 default null
212 ,p_val_attribute11 in varchar2 default null
213 ,p_val_attribute12 in varchar2 default null
214 ,p_val_attribute13 in varchar2 default null
215 ,p_val_attribute14 in varchar2 default null
216 ,p_val_attribute15 in varchar2 default null
217 ,p_val_attribute16 in varchar2 default null
218 ,p_val_attribute17 in varchar2 default null
219 ,p_val_attribute18 in varchar2 default null
220 ,p_val_attribute19 in varchar2 default null
221 ,p_val_attribute20 in varchar2 default null
222 ,p_val_information_category in varchar2 default null
223 ,p_val_information1 in varchar2 default null
224 ,p_val_information2 in varchar2 default null
228 ,p_val_information6 in varchar2 default null
225 ,p_val_information3 in varchar2 default null
226 ,p_val_information4 in varchar2 default null
227 ,p_val_information5 in varchar2 default null
229 ,p_val_information7 in varchar2 default null
230 ,p_val_information8 in varchar2 default null
231 ,p_val_information9 in varchar2 default null
232 ,p_val_information10 in varchar2 default null
233 ,p_val_information11 in varchar2 default null
234 ,p_val_information12 in varchar2 default null
235 ,p_val_information13 in varchar2 default null
236 ,p_val_information14 in varchar2 default null
237 ,p_val_information15 in varchar2 default null
238 ,p_val_information16 in varchar2 default null
239 ,p_val_information17 in varchar2 default null
240 ,p_val_information18 in varchar2 default null
241 ,p_val_information19 in varchar2 default null
242 ,p_val_information20 in varchar2 default null
243 ,p_fuel_benefit in varchar2 default null
244 ,p_sliding_rates_info in varchar2 default null
245 ,p_vehicle_allocation_id out nocopy number
246 ,p_object_version_number out nocopy number
247 ,p_effective_start_date out nocopy date
248 ,p_effective_end_date out nocopy date
249 );
250 --
251 -- ----------------------------------------------------------------------------
252 -- |------------------------< update_vehicle_allocation >---------------------|
253 -- ----------------------------------------------------------------------------
254 --
255 -- {Start Of Comments}
256 /*#
257 * This API updates the details of the allocation of a vehicle.
258 *
259 * This API updates a vehicle allocation record for an assignment. The vehicle
260 * should already exist in the Vehicle Repository. Some of the attributes
261 * depends on whether it is a company or a private vehicle.
262 *
263 * <p><b>Licensing</b><br>
264 * This API is licensed for use with Human Resources.
265 *
266 * <p><b>Prerequisites</b><br>
267 * Vehicle repository and vehicle allocation should be present before updating
268 * a vehicle.
269 *
270 * <p><b>Post Success</b><br>
271 * The vehicle allocation record will be successfully updated into the
272 * database.
273 *
274 * <p><b>Post Failure</b><br>
275 * The vehicle allocation record will not be updated and an error will be
276 * raised.
277 * @param p_validate If true, then validation alone will be performed and the
278 * database will remain unchanged. If false and all validation checks pass,
279 * then the database will be modified.
280 * @param p_effective_date Determines when the DateTrack operation comes into
281 * force
282 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
283 * the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or
284 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
285 * depend on the dates of previous record changes and the effective date of
286 * this change.
287 * @param p_vehicle_allocation_id {@rep:casecolumn
288 * PQP_VEHICLE_ALLOCATIONS_F.VEHICLE_ALLOCATION_ID}
289 * @param p_object_version_number Pass in the current version number of the
290 * vehicle allocation to be updated. When the API completes, if p_validate is
291 * false, it will be set to the new version number of the updated vehicle
292 * allocation. If p_validate is true, it will be set to the same value which
293 * was passed in.
294 * @param p_assignment_id Identifies the assignment for which you create the
295 * vehicle allocation record.
296 * @param p_business_group_id {@rep:casecolumn
297 * PQP_VEHICLE_ALLOCATIONS_F.BUSINESS_GROUP_ID}
298 * @param p_vehicle_repository_id {@rep:casecolumn
299 * PQP_VEHICLE_ALLOCATIONS_F.VEHICLE_REPOSITORY_ID}
300 * @param p_across_assignments {@rep:casecolumn
301 * PQP_VEHICLE_ALLOCATIONS_F.ACROSS_ASSIGNMENTS}
302 * @param p_usage_type {@rep:casecolumn PQP_VEHICLE_ALLOCATIONS_F.USAGE_TYPE}
303 * @param p_capital_contribution {@rep:casecolumn
304 * PQP_VEHICLE_ALLOCATIONS_F.CAPITAL_CONTRIBUTION}
305 * @param p_private_contribution {@rep:casecolumn
306 * PQP_VEHICLE_ALLOCATIONS_F.PRIVATE_CONTRIBUTION}
307 * @param p_default_vehicle {@rep:casecolumn
308 * PQP_VEHICLE_ALLOCATIONS_F.DEFAULT_VEHICLE}
309 * @param p_fuel_card {@rep:casecolumn PQP_VEHICLE_ALLOCATIONS_F.FUEL_CARD}
310 * @param p_fuel_card_number {@rep:casecolumn
311 * PQP_VEHICLE_ALLOCATIONS_F.FUEL_CARD_NUMBER}
312 * @param p_calculation_method {@rep:casecolumn
313 * PQP_VEHICLE_ALLOCATIONS_F.CALCULATION_METHOD}
314 * @param p_rates_table_id {@rep:casecolumn
315 * PQP_VEHICLE_ALLOCATIONS_F.RATES_TABLE_ID}
316 * @param p_element_type_id {@rep:casecolumn
317 * PQP_VEHICLE_ALLOCATIONS_F.ELEMENT_TYPE_ID}
318 * @param p_private_use_flag Indicates whether the company vehicle user can use
319 * this vehicle for private purposes.
320 * @param p_insurance_number The insurance details for the vehicle.
321 * @param p_insurance_expiry_date Insurance expiration date.
322 * @param p_val_attribute_category {@rep:casecolumn
323 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE_CATEGORY}
324 * @param p_val_attribute1 {@rep:casecolumn
325 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE1}
326 * @param p_val_attribute2 {@rep:casecolumn
327 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE2}
328 * @param p_val_attribute3 {@rep:casecolumn
329 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE3}
330 * @param p_val_attribute4 {@rep:casecolumn
331 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE4}
332 * @param p_val_attribute5 {@rep:casecolumn
336 * @param p_val_attribute7 {@rep:casecolumn
333 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE5}
334 * @param p_val_attribute6 {@rep:casecolumn
335 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE6}
337 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE7}
338 * @param p_val_attribute8 {@rep:casecolumn
339 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE8}
340 * @param p_val_attribute9 {@rep:casecolumn
341 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE9}
342 * @param p_val_attribute10 {@rep:casecolumn
343 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE10}
344 * @param p_val_attribute11 {@rep:casecolumn
345 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE11}
346 * @param p_val_attribute12 {@rep:casecolumn
347 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE12}
348 * @param p_val_attribute13 {@rep:casecolumn
349 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE13}
350 * @param p_val_attribute14 {@rep:casecolumn
351 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE14}
352 * @param p_val_attribute15 {@rep:casecolumn
353 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE15}
354 * @param p_val_attribute16 {@rep:casecolumn
355 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE16}
356 * @param p_val_attribute17 {@rep:casecolumn
357 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE17}
358 * @param p_val_attribute18 {@rep:casecolumn
359 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE18}
360 * @param p_val_attribute19 {@rep:casecolumn
361 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE19}
362 * @param p_val_attribute20 {@rep:casecolumn
363 * PQP_VEHICLE_ALLOCATIONS_F.VAL_ATTRIBUTE20}
364 * @param p_val_information_category {@rep:casecolumn
365 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION_CATEGORY}
366 * @param p_val_information1 {@rep:casecolumn
367 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION1}
368 * @param p_val_information2 {@rep:casecolumn
369 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION2}
370 * @param p_val_information3 {@rep:casecolumn
371 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION3}
372 * @param p_val_information4 {@rep:casecolumn
373 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION4}
374 * @param p_val_information5 {@rep:casecolumn
375 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION5}
376 * @param p_val_information6 {@rep:casecolumn
377 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION6}
378 * @param p_val_information7 {@rep:casecolumn
379 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION7}
380 * @param p_val_information8 {@rep:casecolumn
381 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION8}
382 * @param p_val_information9 {@rep:casecolumn
383 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION9}
384 * @param p_val_information10 {@rep:casecolumn
385 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION10}
386 * @param p_val_information11 {@rep:casecolumn
387 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION11}
388 * @param p_val_information12 {@rep:casecolumn
389 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION12}
390 * @param p_val_information13 {@rep:casecolumn
391 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION13}
392 * @param p_val_information14 {@rep:casecolumn
393 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION14}
394 * @param p_val_information15 {@rep:casecolumn
395 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION15}
396 * @param p_val_information16 {@rep:casecolumn
397 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION16}
398 * @param p_val_information17 {@rep:casecolumn
399 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION17}
400 * @param p_val_information18 {@rep:casecolumn
401 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION18}
402 * @param p_val_information19 {@rep:casecolumn
403 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION19}
404 * @param p_val_information20 {@rep:casecolumn
405 * PQP_VEHICLE_ALLOCATIONS_F.VAL_INFORMATION20}
406 * @param p_fuel_benefit {@rep:casecolumn
407 * PQP_VEHICLE_ALLOCATIONS_F.FUEL_BENEFIT}
408 * @param p_sliding_rates_info The Sliding rates table information using the
409 * lookup PQP_SLIDING_RATES.
410 * @param p_effective_start_date If p_validate is false, then set to the
411 * effective start date on the updated vehicle allocation row which now exists
412 * as of the effective date. If p_validate is true, then set to null.
413 * @param p_effective_end_date If p_validate is false, then set to the
414 * effective end date on the updated Vehicle Allocation row which now exists as
415 * of the effective date. If p_validate is true, then set to null.
416 * @rep:displayname Update Vehicle Allocation
417 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
418 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
419 * @rep:scope public
420 * @rep:lifecycle active
421 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
422 */
423 --
424 -- {End Of Comments}
425 --
426 procedure update_vehicle_allocation
427 (p_validate in boolean default false
428 ,p_effective_date in date
429 ,p_datetrack_mode in varchar2
430 ,p_vehicle_allocation_id in number
431 ,p_object_version_number in out nocopy number
432 ,p_assignment_id in number default hr_api.g_number
433 ,p_business_group_id in number default hr_api.g_number
434 ,p_vehicle_repository_id in number default hr_api.g_number
435 ,p_across_assignments in varchar2 default hr_api.g_varchar2
436 ,p_usage_type in varchar2 default hr_api.g_varchar2
437 ,p_capital_contribution in number default hr_api.g_number
438 ,p_private_contribution in number default hr_api.g_number
439 ,p_default_vehicle in varchar2 default hr_api.g_varchar2
440 ,p_fuel_card in varchar2 default hr_api.g_varchar2
441 ,p_fuel_card_number in varchar2 default hr_api.g_varchar2
442 ,p_calculation_method in varchar2 default hr_api.g_varchar2
446 ,p_insurance_number in varchar2 default hr_api.g_varchar2
443 ,p_rates_table_id in number default hr_api.g_number
444 ,p_element_type_id in number default hr_api.g_number
445 ,p_private_use_flag in varchar2 default hr_api.g_varchar2
447 ,p_insurance_expiry_date in date default hr_api.g_date
448 ,p_val_attribute_category in varchar2 default hr_api.g_varchar2
449 ,p_val_attribute1 in varchar2 default hr_api.g_varchar2
450 ,p_val_attribute2 in varchar2 default hr_api.g_varchar2
451 ,p_val_attribute3 in varchar2 default hr_api.g_varchar2
452 ,p_val_attribute4 in varchar2 default hr_api.g_varchar2
453 ,p_val_attribute5 in varchar2 default hr_api.g_varchar2
454 ,p_val_attribute6 in varchar2 default hr_api.g_varchar2
455 ,p_val_attribute7 in varchar2 default hr_api.g_varchar2
456 ,p_val_attribute8 in varchar2 default hr_api.g_varchar2
457 ,p_val_attribute9 in varchar2 default hr_api.g_varchar2
458 ,p_val_attribute10 in varchar2 default hr_api.g_varchar2
459 ,p_val_attribute11 in varchar2 default hr_api.g_varchar2
460 ,p_val_attribute12 in varchar2 default hr_api.g_varchar2
461 ,p_val_attribute13 in varchar2 default hr_api.g_varchar2
462 ,p_val_attribute14 in varchar2 default hr_api.g_varchar2
463 ,p_val_attribute15 in varchar2 default hr_api.g_varchar2
464 ,p_val_attribute16 in varchar2 default hr_api.g_varchar2
465 ,p_val_attribute17 in varchar2 default hr_api.g_varchar2
466 ,p_val_attribute18 in varchar2 default hr_api.g_varchar2
467 ,p_val_attribute19 in varchar2 default hr_api.g_varchar2
468 ,p_val_attribute20 in varchar2 default hr_api.g_varchar2
469 ,p_val_information_category in varchar2 default hr_api.g_varchar2
470 ,p_val_information1 in varchar2 default hr_api.g_varchar2
471 ,p_val_information2 in varchar2 default hr_api.g_varchar2
472 ,p_val_information3 in varchar2 default hr_api.g_varchar2
473 ,p_val_information4 in varchar2 default hr_api.g_varchar2
474 ,p_val_information5 in varchar2 default hr_api.g_varchar2
475 ,p_val_information6 in varchar2 default hr_api.g_varchar2
476 ,p_val_information7 in varchar2 default hr_api.g_varchar2
477 ,p_val_information8 in varchar2 default hr_api.g_varchar2
478 ,p_val_information9 in varchar2 default hr_api.g_varchar2
479 ,p_val_information10 in varchar2 default hr_api.g_varchar2
480 ,p_val_information11 in varchar2 default hr_api.g_varchar2
481 ,p_val_information12 in varchar2 default hr_api.g_varchar2
482 ,p_val_information13 in varchar2 default hr_api.g_varchar2
483 ,p_val_information14 in varchar2 default hr_api.g_varchar2
484 ,p_val_information15 in varchar2 default hr_api.g_varchar2
485 ,p_val_information16 in varchar2 default hr_api.g_varchar2
486 ,p_val_information17 in varchar2 default hr_api.g_varchar2
487 ,p_val_information18 in varchar2 default hr_api.g_varchar2
488 ,p_val_information19 in varchar2 default hr_api.g_varchar2
489 ,p_val_information20 in varchar2 default hr_api.g_varchar2
490 ,p_fuel_benefit in varchar2 default hr_api.g_varchar2
491 ,p_sliding_rates_info in varchar2 default hr_api.g_varchar2
492 ,p_effective_start_date out nocopy date
493 ,p_effective_end_date out nocopy date
494 );
495 --
496 -- ----------------------------------------------------------------------------
497 -- |------------------------< delete_vehicle_allocation >---------------------|
498 -- ----------------------------------------------------------------------------
499 --
500 -- {Start Of Comments}
501 /*#
502 * This API deletes a vehicle allocation.
503 *
504 * This API deletes a vehicle allocation record for an assignment.If the
505 * vehicle was allocated to other assignments for that person, then it needs to
506 * be removed individually.
507 *
508 * <p><b>Licensing</b><br>
509 * This API is licensed for use with Human Resources.
510 *
511 * <p><b>Prerequisites</b><br>
512 * Vehicle allocation should be present before deleting a vehicle.
513 *
514 * <p><b>Post Success</b><br>
515 * The vehicle allocation record will be successfully deleted from the
516 * database.
517 *
518 * <p><b>Post Failure</b><br>
519 * The vehicle allocation record will not be deleted and an error will be
520 * raised.
521 * @param p_validate If true, then validation alone will be performed and the
522 * database will remain unchanged. If false and all validation checks pass,
523 * then the database will be modified.
524 * @param p_effective_date Determines when the DateTrack operation comes into
525 * force.
526 * @param p_datetrack_mode Indicates which DateTrack mode to use when deleting
527 * the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or
528 * DELETE_NEXT_CHANGE. Modes available for use with a particular record depend
529 * on the dates of previous record changes and the effective date of this
530 * change
531 * @param p_vehicle_allocation_id {@rep:casecolumn
532 * PQP_VEHICLE_ALLOCATIONS_F.VEHICLE_ALLOCATION_ID}
533 * @param p_object_version_number Current version number of the vehicle
534 * allocation to be deleted.
535 * @param p_effective_start_date If p_validate is false, then set to the
536 * effective start date for the deleted vehicle allocation row which now exists
537 * as of the effective date. If p_validate is true or all row instances have
538 * been deleted then set to null.
539 * @param p_effective_end_date If p_validate is false, then set to the
540 * effective end date for the created vehicle allocation. If p_validate is
541 * true, then set to null.
542 * @rep:displayname Delete Vehicle Allocation
543 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
544 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
545 * @rep:scope public
546 * @rep:lifecycle active
547 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
548 */
549 --
550 -- {End Of Comments}
551 --
552 procedure delete_vehicle_allocation
553 (p_validate in boolean default false
554 ,p_effective_date in date
555 ,p_datetrack_mode in varchar2
556 ,p_vehicle_allocation_id in number
557 ,p_object_version_number in out nocopy number
558 ,p_effective_start_date out nocopy date
559 ,p_effective_end_date out nocopy date
560 );
561
562 end PQP_VEHICLE_ALLOCATIONS_API;
[Home] [Help]