1 Package PQP_VEH_ALLOC_EXTRA_INFO_API as
2 /* $Header: pqvaiapi.pkh 120.0.12010000.3 2008/08/08 07:18:36 ubhat ship $ */
3 /*#
4 * This package contains vehicle allocation extra information APIs.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Vehicle Allocation Extra Information
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |-----------------------< create_veh_alloc_extra_info >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates vehicle allocation extra information for an allocation.
17 *
18 * Using this insert API you can create any additional information regarding
19 * the vehicle allocation.The extra information types are either delivered by
20 * the localization teams or created by the customers.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with Human Resources.
24 *
25 * <p><b>Prerequisites</b><br>
26 * Vehicle allocation should be present before creating a vehicle allocation
27 * extra information.
28 *
29 * <p><b>Post Success</b><br>
30 * The vehicle allocation extra information record will be successfully
31 * inserted into the database.
32 *
33 * <p><b>Post Failure</b><br>
34 * The vehicle allocation extra information record will not be created and an
35 * error will be raised.
36 *
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_vehicle_allocation_id The vehicle allocation id for which this
41 * extra information is created. Its a foreign key to PQP_VEHICLE_ALLOCATION_F.
42 * @param p_information_type Foreign key to PQP_VEH_ALLOC_INFO_TYPES to
43 * identify the type of information.
44 * @param p_vaei_attribute_category Descriptive flexfield column.
45 * @param p_vaei_attribute1 Descriptive flexfield column.
46 * @param p_vaei_attribute2 Descriptive flexfield column.
47 * @param p_vaei_attribute3 Descriptive flexfield column.
48 * @param p_vaei_attribute4 Descriptive flexfield column.
49 * @param p_vaei_attribute5 Descriptive flexfield column.
50 * @param p_vaei_attribute6 Descriptive flexfield column.
51 * @param p_vaei_attribute7 Descriptive flexfield column.
52 * @param p_vaei_attribute8 Descriptive flexfield column.
53 * @param p_vaei_attribute9 Descriptive flexfield column.
54 * @param p_vaei_attribute10 Descriptive flexfield column.
55 * @param p_vaei_attribute11 Descriptive flexfield column.
56 * @param p_vaei_attribute12 Descriptive flexfield column.
57 * @param p_vaei_attribute13 Descriptive flexfield column.
58 * @param p_vaei_attribute14 Descriptive flexfield column.
59 * @param p_vaei_attribute15 Descriptive flexfield column.
60 * @param p_vaei_attribute16 Descriptive flexfield column.
61 * @param p_vaei_attribute17 Descriptive flexfield column.
62 * @param p_vaei_attribute18 Descriptive flexfield column.
63 * @param p_vaei_attribute19 Descriptive flexfield column.
64 * @param p_vaei_attribute20 Descriptive flexfield column.
65 * @param p_vaei_information_category Developer descriptive flexfield column.
66 * @param p_vaei_information1 Developer descriptive flexfield column.
67 * @param p_vaei_information2 Developer descriptive flexfield column.
68 * @param p_vaei_information3 Developer descriptive flexfield column.
69 * @param p_vaei_information4 Developer descriptive flexfield column.
70 * @param p_vaei_information5 Developer descriptive flexfield column.
71 * @param p_vaei_information6 Developer descriptive flexfield column.
72 * @param p_vaei_information7 Developer descriptive flexfield column.
73 * @param p_vaei_information8 Developer descriptive flexfield column.
74 * @param p_vaei_information9 Developer descriptive flexfield column.
75 * @param p_vaei_information10 Developer descriptive flexfield column.
76 * @param p_vaei_information11 Developer descriptive flexfield column.
77 * @param p_vaei_information12 Developer descriptive flexfield column.
78 * @param p_vaei_information13 Developer descriptive flexfield column.
79 * @param p_vaei_information14 Developer descriptive flexfield column.
80 * @param p_vaei_information15 Developer descriptive flexfield column.
81 * @param p_vaei_information16 Developer descriptive flexfield column.
82 * @param p_vaei_information17 Developer descriptive flexfield column.
83 * @param p_vaei_information18 Developer descriptive flexfield column.
84 * @param p_vaei_information19 Developer descriptive flexfield column.
85 * @param p_vaei_information20 Developer descriptive flexfield column.
86 * @param p_vaei_information21 Developer descriptive flexfield column.
87 * @param p_vaei_information22 Developer descriptive flexfield column.
88 * @param p_vaei_information23 Developer descriptive flexfield column.
89 * @param p_vaei_information24 Developer descriptive flexfield column.
90 * @param p_vaei_information25 Developer descriptive flexfield column.
91 * @param p_vaei_information26 Developer descriptive flexfield column.
92 * @param p_vaei_information27 Developer descriptive flexfield column.
93 * @param p_vaei_information28 Developer descriptive flexfield column.
94 * @param p_vaei_information29 Developer descriptive flexfield column.
95 * @param p_vaei_information30 Developer descriptive flexfield column.
96 * @param p_request_id When the API is executed from a concurrent program set
97 * to the concurrent request identifier.
98 * @param p_program_application_id When the API is executed from a concurrent
99 * program set to the program's Application.
100 * @param p_program_id When the API is executed from a concurrent program set
101 * to the program's identifier.
102 * @param p_program_update_date When the API is executed from a concurrent
103 * program set to when the program was ran.
104 * @param p_veh_alloc_extra_info_id The primary key generated by the API for
105 * this record. If p_validate is true, then set to null.
106 * @param p_object_version_number If p_validate is false, then set to the
107 * version number of the created vehicle allocation extra information. If
108 * p_validate is true, then the value will be null.
109 * @rep:displayname Create Vehicle Allocation Extra Information
110 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
111 * @rep:lifecycle active
112 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
113 * @rep:scope public
114 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
115 */
116 --
117 -- {End Of Comments}
118 --
119 procedure create_veh_alloc_extra_info
120 (p_validate in boolean default false
121 ,p_vehicle_allocation_id in number
122 ,p_information_type in varchar2
123 ,p_vaei_attribute_category in varchar2 default null
124 ,p_vaei_attribute1 in varchar2 default null
125 ,p_vaei_attribute2 in varchar2 default null
126 ,p_vaei_attribute3 in varchar2 default null
127 ,p_vaei_attribute4 in varchar2 default null
128 ,p_vaei_attribute5 in varchar2 default null
129 ,p_vaei_attribute6 in varchar2 default null
130 ,p_vaei_attribute7 in varchar2 default null
131 ,p_vaei_attribute8 in varchar2 default null
132 ,p_vaei_attribute9 in varchar2 default null
133 ,p_vaei_attribute10 in varchar2 default null
134 ,p_vaei_attribute11 in varchar2 default null
135 ,p_vaei_attribute12 in varchar2 default null
136 ,p_vaei_attribute13 in varchar2 default null
137 ,p_vaei_attribute14 in varchar2 default null
138 ,p_vaei_attribute15 in varchar2 default null
139 ,p_vaei_attribute16 in varchar2 default null
140 ,p_vaei_attribute17 in varchar2 default null
141 ,p_vaei_attribute18 in varchar2 default null
142 ,p_vaei_attribute19 in varchar2 default null
143 ,p_vaei_attribute20 in varchar2 default null
144 ,p_vaei_information_category in varchar2 default null
145 ,p_vaei_information1 in varchar2 default null
146 ,p_vaei_information2 in varchar2 default null
147 ,p_vaei_information3 in varchar2 default null
148 ,p_vaei_information4 in varchar2 default null
149 ,p_vaei_information5 in varchar2 default null
150 ,p_vaei_information6 in varchar2 default null
151 ,p_vaei_information7 in varchar2 default null
152 ,p_vaei_information8 in varchar2 default null
153 ,p_vaei_information9 in varchar2 default null
154 ,p_vaei_information10 in varchar2 default null
155 ,p_vaei_information11 in varchar2 default null
156 ,p_vaei_information12 in varchar2 default null
157 ,p_vaei_information13 in varchar2 default null
158 ,p_vaei_information14 in varchar2 default null
159 ,p_vaei_information15 in varchar2 default null
160 ,p_vaei_information16 in varchar2 default null
161 ,p_vaei_information17 in varchar2 default null
162 ,p_vaei_information18 in varchar2 default null
163 ,p_vaei_information19 in varchar2 default null
164 ,p_vaei_information20 in varchar2 default null
165 ,p_vaei_information21 in varchar2 default null
166 ,p_vaei_information22 in varchar2 default null
167 ,p_vaei_information23 in varchar2 default null
168 ,p_vaei_information24 in varchar2 default null
169 ,p_vaei_information25 in varchar2 default null
170 ,p_vaei_information26 in varchar2 default null
171 ,p_vaei_information27 in varchar2 default null
172 ,p_vaei_information28 in varchar2 default null
173 ,p_vaei_information29 in varchar2 default null
174 ,p_vaei_information30 in varchar2 default null
175 ,p_request_id in number default null
176 ,p_program_application_id in number default null
177 ,p_program_id in number default null
178 ,p_program_update_date in date default null
179 ,p_veh_alloc_extra_info_id out nocopy number
180 ,p_object_version_number out nocopy number
181 );
182 --
183 -- ----------------------------------------------------------------------------
184 -- |-----------------------< update_veh_alloc_extra_info >--------------------|
185 -- ----------------------------------------------------------------------------
186 --
187 -- {Start Of Comments}
188 /*#
189 * This API updates vehicle allocation extra information.
190 *
191 * This is used to update a row for the additional information about vehicle
192 * allocation for an assignment.
193 *
194 * <p><b>Licensing</b><br>
195 * This API is licensed for use with Human Resources.
196 *
197 * <p><b>Prerequisites</b><br>
198 * Vehicle Allocation should be present before updating a vehicle allocation
199 * extra information.
200 *
201 * <p><b>Post Success</b><br>
202 * The Vehicle Allocation Extra Information record will be successfully updated
203 * into the database.
204 *
205 * <p><b>Post Failure</b><br>
206 * The Vehicle Allocation Extra Information record will not be updated and an
207 * error will be raised.
208 *
209 * @param p_validate If true, then validation alone will be performed and the
210 * database will remain unchanged. If false and all validation checks pass,
211 * then the database will be modified.
212 * @param p_veh_alloc_extra_info_id System generated primary key column using
213 * the sequence PQP_VEH_ALLOC_EXTRA_INFO_S.
214 * @param p_object_version_number Pass in the current version number of the
215 * vehicle allocation extra information to be updated. When the API completes
216 * if p_validate is false, will be set to the new version number of the updated
217 * vehicle allocation extra information. If p_validate is true will be set to
218 * the same value which was passed in.
219 * @param p_vehicle_allocation_id The vehicle allocation id for which this
220 * extra information is created. Its a foreign key to PQP_VEHICLE_ALLOCATION_F.
221 * @param p_information_type Foreign key to PQP_VEH_ALLOC_INFO_TYPES to
222 * identify the type of information.
223 * @param p_vaei_attribute_category Descriptive flexfield column.
224 * @param p_vaei_attribute1 Descriptive flexfield column.
225 * @param p_vaei_attribute2 Descriptive flexfield column.
226 * @param p_vaei_attribute3 Descriptive flexfield column.
227 * @param p_vaei_attribute4 Descriptive flexfield column.
228 * @param p_vaei_attribute5 Descriptive flexfield column.
229 * @param p_vaei_attribute6 Descriptive flexfield column.
230 * @param p_vaei_attribute7 Descriptive flexfield column.
231 * @param p_vaei_attribute8 Descriptive flexfield column.
232 * @param p_vaei_attribute9 Descriptive flexfield column.
233 * @param p_vaei_attribute10 Descriptive flexfield column.
234 * @param p_vaei_attribute11 Descriptive flexfield column.
235 * @param p_vaei_attribute12 Descriptive flexfield column.
236 * @param p_vaei_attribute13 Descriptive flexfield column.
237 * @param p_vaei_attribute14 Descriptive flexfield column.
238 * @param p_vaei_attribute15 Descriptive flexfield column.
239 * @param p_vaei_attribute16 Descriptive flexfield column.
240 * @param p_vaei_attribute17 Descriptive flexfield column.
241 * @param p_vaei_attribute18 Descriptive flexfield column.
242 * @param p_vaei_attribute19 Descriptive flexfield column.
243 * @param p_vaei_attribute20 Descriptive flexfield column.
244 * @param p_vaei_information_category Developer descriptive flexfield column.
245 * @param p_vaei_information1 Developer descriptive flexfield column.
246 * @param p_vaei_information2 Developer descriptive flexfield column.
247 * @param p_vaei_information3 Developer descriptive flexfield column.
248 * @param p_vaei_information4 Developer descriptive flexfield column.
249 * @param p_vaei_information5 Developer descriptive flexfield column.
250 * @param p_vaei_information6 Developer descriptive flexfield column.
251 * @param p_vaei_information7 Developer descriptive flexfield column.
252 * @param p_vaei_information8 Developer descriptive flexfield column.
253 * @param p_vaei_information9 Developer descriptive flexfield column.
254 * @param p_vaei_information10 Developer descriptive flexfield column.
255 * @param p_vaei_information11 Developer descriptive flexfield column.
256 * @param p_vaei_information12 Developer descriptive flexfield column.
257 * @param p_vaei_information13 Developer descriptive flexfield column.
258 * @param p_vaei_information14 Developer descriptive flexfield column.
259 * @param p_vaei_information15 Developer descriptive flexfield column.
260 * @param p_vaei_information16 Developer descriptive flexfield column.
261 * @param p_vaei_information17 Developer descriptive flexfield column.
262 * @param p_vaei_information18 Developer descriptive flexfield column.
263 * @param p_vaei_information19 Developer descriptive flexfield column.
264 * @param p_vaei_information20 Developer descriptive flexfield column.
265 * @param p_vaei_information21 Developer descriptive flexfield column.
266 * @param p_vaei_information22 Developer descriptive flexfield column.
267 * @param p_vaei_information23 Developer descriptive flexfield column.
268 * @param p_vaei_information24 Developer descriptive flexfield column.
269 * @param p_vaei_information25 Developer descriptive flexfield column.
270 * @param p_vaei_information26 Developer descriptive flexfield column.
271 * @param p_vaei_information27 Developer descriptive flexfield column.
272 * @param p_vaei_information28 Developer descriptive flexfield column.
273 * @param p_vaei_information29 Developer descriptive flexfield column.
274 * @param p_vaei_information30 Developer descriptive flexfield column.
275 * @param p_request_id When the API is executed from a concurrent program set
276 * to the concurrent request identifier.
277 * @param p_program_application_id When the API is executed from a concurrent
278 * program set to the program's Application.
279 * @param p_program_id When the API is executed from a concurrent program set
280 * to the program's identifier.
281 * @param p_program_update_date When the API is executed from a concurrent
282 * program set to when the program was ran.
283 * @rep:displayname Update Vehicle Allocation Extra Information
284 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
285 * @rep:lifecycle active
286 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
287 * @rep:scope public
288 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
289 */
290 --
291 -- {End Of Comments}
292 --
293 procedure update_veh_alloc_extra_info
294 (p_validate in boolean default false
295 ,p_veh_alloc_extra_info_id in number
296 ,p_object_version_number in out nocopy number
297 ,p_vehicle_allocation_id in number default hr_api.g_number
298 ,p_information_type in varchar2 default hr_api.g_varchar2
299 ,p_vaei_attribute_category in varchar2 default hr_api.g_varchar2
300 ,p_vaei_attribute1 in varchar2 default hr_api.g_varchar2
301 ,p_vaei_attribute2 in varchar2 default hr_api.g_varchar2
302 ,p_vaei_attribute3 in varchar2 default hr_api.g_varchar2
303 ,p_vaei_attribute4 in varchar2 default hr_api.g_varchar2
304 ,p_vaei_attribute5 in varchar2 default hr_api.g_varchar2
305 ,p_vaei_attribute6 in varchar2 default hr_api.g_varchar2
306 ,p_vaei_attribute7 in varchar2 default hr_api.g_varchar2
307 ,p_vaei_attribute8 in varchar2 default hr_api.g_varchar2
308 ,p_vaei_attribute9 in varchar2 default hr_api.g_varchar2
309 ,p_vaei_attribute10 in varchar2 default hr_api.g_varchar2
310 ,p_vaei_attribute11 in varchar2 default hr_api.g_varchar2
311 ,p_vaei_attribute12 in varchar2 default hr_api.g_varchar2
312 ,p_vaei_attribute13 in varchar2 default hr_api.g_varchar2
313 ,p_vaei_attribute14 in varchar2 default hr_api.g_varchar2
314 ,p_vaei_attribute15 in varchar2 default hr_api.g_varchar2
315 ,p_vaei_attribute16 in varchar2 default hr_api.g_varchar2
316 ,p_vaei_attribute17 in varchar2 default hr_api.g_varchar2
317 ,p_vaei_attribute18 in varchar2 default hr_api.g_varchar2
318 ,p_vaei_attribute19 in varchar2 default hr_api.g_varchar2
319 ,p_vaei_attribute20 in varchar2 default hr_api.g_varchar2
320 ,p_vaei_information_category in varchar2 default hr_api.g_varchar2
321 ,p_vaei_information1 in varchar2 default hr_api.g_varchar2
322 ,p_vaei_information2 in varchar2 default hr_api.g_varchar2
323 ,p_vaei_information3 in varchar2 default hr_api.g_varchar2
324 ,p_vaei_information4 in varchar2 default hr_api.g_varchar2
325 ,p_vaei_information5 in varchar2 default hr_api.g_varchar2
326 ,p_vaei_information6 in varchar2 default hr_api.g_varchar2
327 ,p_vaei_information7 in varchar2 default hr_api.g_varchar2
328 ,p_vaei_information8 in varchar2 default hr_api.g_varchar2
329 ,p_vaei_information9 in varchar2 default hr_api.g_varchar2
330 ,p_vaei_information10 in varchar2 default hr_api.g_varchar2
331 ,p_vaei_information11 in varchar2 default hr_api.g_varchar2
332 ,p_vaei_information12 in varchar2 default hr_api.g_varchar2
333 ,p_vaei_information13 in varchar2 default hr_api.g_varchar2
334 ,p_vaei_information14 in varchar2 default hr_api.g_varchar2
335 ,p_vaei_information15 in varchar2 default hr_api.g_varchar2
336 ,p_vaei_information16 in varchar2 default hr_api.g_varchar2
337 ,p_vaei_information17 in varchar2 default hr_api.g_varchar2
338 ,p_vaei_information18 in varchar2 default hr_api.g_varchar2
339 ,p_vaei_information19 in varchar2 default hr_api.g_varchar2
340 ,p_vaei_information20 in varchar2 default hr_api.g_varchar2
341 ,p_vaei_information21 in varchar2 default hr_api.g_varchar2
342 ,p_vaei_information22 in varchar2 default hr_api.g_varchar2
343 ,p_vaei_information23 in varchar2 default hr_api.g_varchar2
344 ,p_vaei_information24 in varchar2 default hr_api.g_varchar2
345 ,p_vaei_information25 in varchar2 default hr_api.g_varchar2
346 ,p_vaei_information26 in varchar2 default hr_api.g_varchar2
347 ,p_vaei_information27 in varchar2 default hr_api.g_varchar2
348 ,p_vaei_information28 in varchar2 default hr_api.g_varchar2
349 ,p_vaei_information29 in varchar2 default hr_api.g_varchar2
350 ,p_vaei_information30 in varchar2 default hr_api.g_varchar2
351 ,p_request_id in number default hr_api.g_number
352 ,p_program_application_id in number default hr_api.g_number
353 ,p_program_id in number default hr_api.g_number
354 ,p_program_update_date in date default hr_api.g_date
355
356 );
357 --
358 -- ----------------------------------------------------------------------------
359 -- |-----------------------< delete_veh_alloc_extra_info >--------------------|
360 -- ----------------------------------------------------------------------------
361 --
362 -- {Start Of Comments}
363 /*#
364 * This API deletes the vehicle allocation extra information row for an
365 * allocation.
366 *
367 *
368 * <p><b>Licensing</b><br>
369 * This API is licensed for use with Human Resources.
370 *
371 * <p><b>Prerequisites</b><br>
372 *
373 * <p><b>Post Success</b><br>
374 * The Vehicle Allocation Extra Information record will be successfully deleted
375 * from the database.
376 *
377 * <p><b>Post Failure</b><br>
378 * The Vehicle Allocation Extra Information record will not be deleted and an
379 * error will be raised.
380 *
381 * @param p_validate If true, then validation alone will be performed and the
382 * database will remain unchanged. If false and all validation checks pass,
383 * then the database will be modified.
384 * @param p_veh_alloc_extra_info_id System generated primary key column using
385 * the sequence PQP_VEH_ALLOC_EXTRA_INFO_S.
386 * @param p_object_version_number Current version number of the vehicle
387 * allocation extra information to be deleted.
388 * @rep:displayname Delete Vehicle Allocation Extra Information.
389 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
390 * @rep:lifecycle active
391 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
392 * @rep:scope public
393 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
394 */
395 --
396 -- {End Of Comments}
397 --
398 procedure delete_veh_alloc_extra_info
399 ( p_validate in boolean default false
400 ,p_veh_alloc_extra_info_id in number
401 ,p_object_version_number in number
402 );
403 end PQP_VEH_ALLOC_EXTRA_INFO_API;