1 Package PQP_VEH_REPOS_EXTRA_INFO_API as
2 /* $Header: pqvriapi.pkh 120.0.12010000.3 2008/08/08 07:23:57 ubhat ship $ */
3 /*#
4 * This package contains vehicle repository extra information APIs.
5 * The extra information types are either delivered by the product or created
6 * by the customer. Extra information types store additional information
7 * regarding the vehicle, that is not already supported by the module.
8 * @rep:scope public
9 * @rep:product PER
10 * @rep:displayname Vehicle Repository Extra Information
11 */
12 --
13 -- ----------------------------------------------------------------------------
14 -- |-----------------------< create_veh_repos_extra_info >--------------------|
15 -- ----------------------------------------------------------------------------
16 --
17 -- {Start Of Comments}
18 /*#
19 * This API creates vehicle repository extra information.
20 *
21 * The information type and the data stored in each of the columns is defined
22 * in the flexfield. Each of the column data is dependend on the valueset of
23 * the individual segments.
24 *
25 * <p><b>Licensing</b><br>
26 * This API is licensed for use with Human Resources.
27 *
28 * <p><b>Prerequisites</b><br>
29 * Vehicle Repository record should be present before creating a vehicle
30 * repository extra information.
31 *
32 * <p><b>Post Success</b><br>
33 * The Vehicle Repository Extra Information record will be successfully
34 * inserted into the database.
35 *
36 * <p><b>Post Failure</b><br>
37 * The Vehicle Repository Extra Information record will not be created and an
38 * error will be raised.
39 *
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_vehicle_repository_id The vehicle for which the extra information
44 * is created. It is a foreign key to PQP_VEHICLE_REPOSITORY_F.
45 * @param p_information_type Foreign key to PQP_VEH_REPOS_INFO_TYPES to
46 * identify the type of information.
47 * @param p_vrei_attribute_category Descriptive flexfield column. It identifies
48 * the data stored in the flexfield.
49 * @param p_vrei_attribute1 Descriptive flexfield column.
50 * @param p_vrei_attribute2 Descriptive flexfield column.
51 * @param p_vrei_attribute3 Descriptive flexfield column.
52 * @param p_vrei_attribute4 Descriptive flexfield column.
53 * @param p_vrei_attribute5 Descriptive flexfield column.
54 * @param p_vrei_attribute6 Descriptive flexfield column.
55 * @param p_vrei_attribute7 Descriptive flexfield column.
56 * @param p_vrei_attribute8 Descriptive flexfield column.
57 * @param p_vrei_attribute9 Descriptive flexfield column.
58 * @param p_vrei_attribute10 Descriptive flexfield column.
59 * @param p_vrei_attribute11 Descriptive flexfield column.
60 * @param p_vrei_attribute12 Descriptive flexfield column.
61 * @param p_vrei_attribute13 Descriptive flexfield column.
62 * @param p_vrei_attribute14 Descriptive flexfield column.
63 * @param p_vrei_attribute15 Descriptive flexfield column.
64 * @param p_vrei_attribute16 Descriptive flexfield column.
65 * @param p_vrei_attribute17 Descriptive flexfield column.
66 * @param p_vrei_attribute18 Descriptive flexfield column.
67 * @param p_vrei_attribute19 Descriptive flexfield column.
68 * @param p_vrei_attribute20 Descriptive flexfield column.
69 * @param p_vrei_information_category Developer descriptive flexfield column.
70 * @param p_vrei_information1 Developer descriptive flexfield column.
71 * @param p_vrei_information2 Developer descriptive flexfield column.
72 * @param p_vrei_information3 Developer descriptive flexfield column.
73 * @param p_vrei_information4 Developer descriptive flexfield column.
74 * @param p_vrei_information5 Developer descriptive flexfield column.
75 * @param p_vrei_information6 Developer descriptive flexfield column.
76 * @param p_vrei_information7 Developer descriptive flexfield column.
77 * @param p_vrei_information8 Developer descriptive flexfield column.
78 * @param p_vrei_information9 Developer descriptive flexfield column.
79 * @param p_vrei_information10 Developer descriptive flexfield column.
80 * @param p_vrei_information11 Developer descriptive flexfield column.
81 * @param p_vrei_information12 Developer descriptive flexfield column.
82 * @param p_vrei_information13 Developer descriptive flexfield column.
83 * @param p_vrei_information14 Developer descriptive flexfield column.
84 * @param p_vrei_information15 Developer descriptive flexfield column.
85 * @param p_vrei_information16 Developer descriptive flexfield column.
86 * @param p_vrei_information17 Developer descriptive flexfield column.
87 * @param p_vrei_information18 Developer descriptive flexfield column.
88 * @param p_vrei_information19 Developer descriptive flexfield column.
89 * @param p_vrei_information20 Developer descriptive flexfield column.
90 * @param p_vrei_information21 Developer descriptive flexfield column.
91 * @param p_vrei_information22 Developer descriptive flexfield column.
92 * @param p_vrei_information23 Developer descriptive flexfield column.
93 * @param p_vrei_information24 Developer descriptive flexfield column.
94 * @param p_vrei_information25 Developer descriptive flexfield column.
95 * @param p_vrei_information26 Developer descriptive flexfield column.
96 * @param p_vrei_information27 Developer descriptive flexfield column.
97 * @param p_vrei_information28 Developer descriptive flexfield column.
98 * @param p_vrei_information29 Developer descriptive flexfield column.
99 * @param p_vrei_information30 Developer descriptive flexfield column.
100 * @param p_request_id When the API is executed from a concurrent program set
101 * to the concurrent request identifier.
102 * @param p_program_application_id When the API is executed from a concurrent
103 * program set to the program's Application.
104 * @param p_program_id When the API is executed from a concurrent program set
105 * to the program's identifier.
106 * @param p_program_update_date When the API is executed from a concurrent
107 * program set to when the program was ran.
108 * @param p_veh_repos_extra_info_id The primary key generated for the vehicle
109 * repository extra information record. If p_validate is true, then set to
110 * null.
111 * @param p_object_version_number If p_validate is false, then set to the
112 * version number of the created vehicle repository extra information. If
113 * p_validate is true, then the value will be null.
114 * @rep:displayname Create Vehicle Repository Extra Information
115 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
116 * @rep:lifecycle active
117 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
118 * @rep:scope public
119 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
120 */
121 --
122 -- {End Of Comments}
123 --
124 procedure create_veh_repos_extra_info
125 (p_validate in boolean default false
126 ,p_vehicle_repository_id in number
127 ,p_information_type in varchar2
128 ,p_vrei_attribute_category in varchar2 default null
129 ,p_vrei_attribute1 in varchar2 default null
130 ,p_vrei_attribute2 in varchar2 default null
131 ,p_vrei_attribute3 in varchar2 default null
132 ,p_vrei_attribute4 in varchar2 default null
133 ,p_vrei_attribute5 in varchar2 default null
134 ,p_vrei_attribute6 in varchar2 default null
135 ,p_vrei_attribute7 in varchar2 default null
136 ,p_vrei_attribute8 in varchar2 default null
137 ,p_vrei_attribute9 in varchar2 default null
138 ,p_vrei_attribute10 in varchar2 default null
139 ,p_vrei_attribute11 in varchar2 default null
140 ,p_vrei_attribute12 in varchar2 default null
141 ,p_vrei_attribute13 in varchar2 default null
142 ,p_vrei_attribute14 in varchar2 default null
143 ,p_vrei_attribute15 in varchar2 default null
144 ,p_vrei_attribute16 in varchar2 default null
145 ,p_vrei_attribute17 in varchar2 default null
146 ,p_vrei_attribute18 in varchar2 default null
147 ,p_vrei_attribute19 in varchar2 default null
148 ,p_vrei_attribute20 in varchar2 default null
149 ,p_vrei_information_category in varchar2 default null
150 ,p_vrei_information1 in varchar2 default null
151 ,p_vrei_information2 in varchar2 default null
152 ,p_vrei_information3 in varchar2 default null
153 ,p_vrei_information4 in varchar2 default null
154 ,p_vrei_information5 in varchar2 default null
155 ,p_vrei_information6 in varchar2 default null
156 ,p_vrei_information7 in varchar2 default null
157 ,p_vrei_information8 in varchar2 default null
158 ,p_vrei_information9 in varchar2 default null
159 ,p_vrei_information10 in varchar2 default null
160 ,p_vrei_information11 in varchar2 default null
161 ,p_vrei_information12 in varchar2 default null
162 ,p_vrei_information13 in varchar2 default null
163 ,p_vrei_information14 in varchar2 default null
164 ,p_vrei_information15 in varchar2 default null
165 ,p_vrei_information16 in varchar2 default null
166 ,p_vrei_information17 in varchar2 default null
167 ,p_vrei_information18 in varchar2 default null
168 ,p_vrei_information19 in varchar2 default null
169 ,p_vrei_information20 in varchar2 default null
170 ,p_vrei_information21 in varchar2 default null
171 ,p_vrei_information22 in varchar2 default null
172 ,p_vrei_information23 in varchar2 default null
173 ,p_vrei_information24 in varchar2 default null
174 ,p_vrei_information25 in varchar2 default null
175 ,p_vrei_information26 in varchar2 default null
176 ,p_vrei_information27 in varchar2 default null
177 ,p_vrei_information28 in varchar2 default null
178 ,p_vrei_information29 in varchar2 default null
179 ,p_vrei_information30 in varchar2 default null
180 ,p_request_id in number default null
181 ,p_program_application_id in number default null
182 ,p_program_id in number default null
183 ,p_program_update_date in date default null
184 ,p_veh_repos_extra_info_id out nocopy number
185 ,p_object_version_number out nocopy number
186 );
187 --
188 -- ----------------------------------------------------------------------------
189 -- |-----------------------< update_veh_repos_extra_info >--------------------|
190 -- ----------------------------------------------------------------------------
191 --
192 -- {Start Of Comments}
193 /*#
194 * This API updates vehicle repository extra information.
195 *
196 * The information type and the data stored in each of the columns is defined
197 * in the flexfield. You can update the columns based on the definition of the
198 * value set for each of the individual segments.
199 *
200 * <p><b>Licensing</b><br>
201 * This API is licensed for use with Human Resources.
202 *
203 * <p><b>Prerequisites</b><br>
204 * Vehicle Repository record should be present before updating a vehicle
205 * repository extra information.
206 *
207 * <p><b>Post Success</b><br>
208 * The Vehicle Repository Extra Information record will be successfully updated
209 * in the database.
210 *
211 * <p><b>Post Failure</b><br>
212 * The Vehicle Repository Extra Information record will not be updated and an
213 * error will be raised.
214 *
215 * @param p_validate If true, then validation alone will be performed and the
216 * database will remain unchanged. If false and all validation checks pass,
217 * then the database will be modified.
218 * @param p_veh_repos_extra_info_id System generated primary key column using
219 * the sequence PQP_VEH_REPOS_EXTRA_INFO_S.
220 * @param p_object_version_number Pass in the current version number of the
221 * vehicle repository extra information to be updated. When the API completes
222 * if p_validate is false, will be set to the new version number of the updated
223 * vehicle repository extra information. If p_validate is true will be set to
224 * the same value which was passed in.
225 * @param p_vehicle_repository_id The vehicle for which the extra information
226 * is created. It is a foreign key to PQP_VEHICLE_REPOSITORY_F.
227 * @param p_information_type Foreign key to PQP_VEH_REPOS_INFO_TYPES to
228 * identify the type of information.
229 * @param p_vrei_attribute_category Descriptive flexfield column. It identifies
230 * the data stored in the flexfield.
231 * @param p_vrei_attribute1 Descriptive flexfield column.
232 * @param p_vrei_attribute2 Descriptive flexfield column.
233 * @param p_vrei_attribute3 Descriptive flexfield column.
234 * @param p_vrei_attribute4 Descriptive flexfield column.
235 * @param p_vrei_attribute5 Descriptive flexfield column.
236 * @param p_vrei_attribute6 Descriptive flexfield column.
237 * @param p_vrei_attribute7 Descriptive flexfield column.
238 * @param p_vrei_attribute8 Descriptive flexfield column.
239 * @param p_vrei_attribute9 Descriptive flexfield column.
240 * @param p_vrei_attribute10 Descriptive flexfield column.
241 * @param p_vrei_attribute11 Descriptive flexfield column.
242 * @param p_vrei_attribute12 Descriptive flexfield column.
243 * @param p_vrei_attribute13 Descriptive flexfield column.
244 * @param p_vrei_attribute14 Descriptive flexfield column.
245 * @param p_vrei_attribute15 Descriptive flexfield column.
246 * @param p_vrei_attribute16 Descriptive flexfield column.
247 * @param p_vrei_attribute17 Descriptive flexfield column.
248 * @param p_vrei_attribute18 Descriptive flexfield column.
249 * @param p_vrei_attribute19 Descriptive flexfield column.
250 * @param p_vrei_attribute20 Descriptive flexfield column.
251 * @param p_vrei_information_category Developer descriptive flexfield column.
252 * @param p_vrei_information1 Developer descriptive flexfield column.
253 * @param p_vrei_information2 Developer descriptive flexfield column.
254 * @param p_vrei_information3 Developer descriptive flexfield column.
255 * @param p_vrei_information4 Developer descriptive flexfield column.
256 * @param p_vrei_information5 Developer descriptive flexfield column.
257 * @param p_vrei_information6 Developer descriptive flexfield column.
258 * @param p_vrei_information7 Developer descriptive flexfield column.
259 * @param p_vrei_information8 Developer descriptive flexfield column.
260 * @param p_vrei_information9 Developer descriptive flexfield column.
261 * @param p_vrei_information10 Developer descriptive flexfield column.
262 * @param p_vrei_information11 Developer descriptive flexfield column.
263 * @param p_vrei_information12 Developer descriptive flexfield column.
264 * @param p_vrei_information13 Developer descriptive flexfield column.
265 * @param p_vrei_information14 Developer descriptive flexfield column.
266 * @param p_vrei_information15 Developer descriptive flexfield column.
267 * @param p_vrei_information16 Developer descriptive flexfield column.
268 * @param p_vrei_information17 Developer descriptive flexfield column.
269 * @param p_vrei_information18 Developer descriptive flexfield column.
270 * @param p_vrei_information19 Developer descriptive flexfield column.
271 * @param p_vrei_information20 Developer descriptive flexfield column.
272 * @param p_vrei_information21 Developer descriptive flexfield column.
273 * @param p_vrei_information22 Developer descriptive flexfield column.
274 * @param p_vrei_information23 Developer descriptive flexfield column.
275 * @param p_vrei_information24 Developer descriptive flexfield column.
276 * @param p_vrei_information25 Developer descriptive flexfield column.
277 * @param p_vrei_information26 Developer descriptive flexfield column.
278 * @param p_vrei_information27 Developer descriptive flexfield column.
279 * @param p_vrei_information28 Developer descriptive flexfield column.
280 * @param p_vrei_information29 Developer descriptive flexfield column.
281 * @param p_vrei_information30 Developer descriptive flexfield column.
282 * @param p_request_id When the API is executed from a concurrent program set
283 * to the concurrent request identifier.
284 * @param p_program_application_id When the API is executed from a concurrent
285 * program set to the program's Application.
286 * @param p_program_id When the API is executed from a concurrent program set
287 * to the program's identifier.
288 * @param p_program_update_date When the API is executed from a concurrent
289 * program set to when the program was ran.
290 * @rep:displayname Update Vehicle Repository Extra Information
291 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
292 * @rep:lifecycle active
293 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
294 * @rep:scope public
295 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
296 */
297 --
298 -- {End Of Comments}
299 --
300 procedure update_veh_repos_extra_info
301 (p_validate in boolean default false
302 ,p_veh_repos_extra_info_id in number
303 ,p_object_version_number in out nocopy number
304 ,p_vehicle_repository_id in number default hr_api.g_number
305 ,p_information_type in varchar2 default hr_api.g_varchar2
306 ,p_vrei_attribute_category in varchar2 default hr_api.g_varchar2
307 ,p_vrei_attribute1 in varchar2 default hr_api.g_varchar2
308 ,p_vrei_attribute2 in varchar2 default hr_api.g_varchar2
309 ,p_vrei_attribute3 in varchar2 default hr_api.g_varchar2
310 ,p_vrei_attribute4 in varchar2 default hr_api.g_varchar2
311 ,p_vrei_attribute5 in varchar2 default hr_api.g_varchar2
312 ,p_vrei_attribute6 in varchar2 default hr_api.g_varchar2
313 ,p_vrei_attribute7 in varchar2 default hr_api.g_varchar2
314 ,p_vrei_attribute8 in varchar2 default hr_api.g_varchar2
315 ,p_vrei_attribute9 in varchar2 default hr_api.g_varchar2
316 ,p_vrei_attribute10 in varchar2 default hr_api.g_varchar2
317 ,p_vrei_attribute11 in varchar2 default hr_api.g_varchar2
318 ,p_vrei_attribute12 in varchar2 default hr_api.g_varchar2
319 ,p_vrei_attribute13 in varchar2 default hr_api.g_varchar2
320 ,p_vrei_attribute14 in varchar2 default hr_api.g_varchar2
321 ,p_vrei_attribute15 in varchar2 default hr_api.g_varchar2
322 ,p_vrei_attribute16 in varchar2 default hr_api.g_varchar2
323 ,p_vrei_attribute17 in varchar2 default hr_api.g_varchar2
324 ,p_vrei_attribute18 in varchar2 default hr_api.g_varchar2
325 ,p_vrei_attribute19 in varchar2 default hr_api.g_varchar2
326 ,p_vrei_attribute20 in varchar2 default hr_api.g_varchar2
327 ,p_vrei_information_category in varchar2 default hr_api.g_varchar2
328 ,p_vrei_information1 in varchar2 default hr_api.g_varchar2
329 ,p_vrei_information2 in varchar2 default hr_api.g_varchar2
330 ,p_vrei_information3 in varchar2 default hr_api.g_varchar2
331 ,p_vrei_information4 in varchar2 default hr_api.g_varchar2
332 ,p_vrei_information5 in varchar2 default hr_api.g_varchar2
333 ,p_vrei_information6 in varchar2 default hr_api.g_varchar2
334 ,p_vrei_information7 in varchar2 default hr_api.g_varchar2
335 ,p_vrei_information8 in varchar2 default hr_api.g_varchar2
336 ,p_vrei_information9 in varchar2 default hr_api.g_varchar2
337 ,p_vrei_information10 in varchar2 default hr_api.g_varchar2
338 ,p_vrei_information11 in varchar2 default hr_api.g_varchar2
339 ,p_vrei_information12 in varchar2 default hr_api.g_varchar2
340 ,p_vrei_information13 in varchar2 default hr_api.g_varchar2
341 ,p_vrei_information14 in varchar2 default hr_api.g_varchar2
342 ,p_vrei_information15 in varchar2 default hr_api.g_varchar2
343 ,p_vrei_information16 in varchar2 default hr_api.g_varchar2
344 ,p_vrei_information17 in varchar2 default hr_api.g_varchar2
345 ,p_vrei_information18 in varchar2 default hr_api.g_varchar2
346 ,p_vrei_information19 in varchar2 default hr_api.g_varchar2
347 ,p_vrei_information20 in varchar2 default hr_api.g_varchar2
348 ,p_vrei_information21 in varchar2 default hr_api.g_varchar2
349 ,p_vrei_information22 in varchar2 default hr_api.g_varchar2
350 ,p_vrei_information23 in varchar2 default hr_api.g_varchar2
351 ,p_vrei_information24 in varchar2 default hr_api.g_varchar2
352 ,p_vrei_information25 in varchar2 default hr_api.g_varchar2
353 ,p_vrei_information26 in varchar2 default hr_api.g_varchar2
354 ,p_vrei_information27 in varchar2 default hr_api.g_varchar2
355 ,p_vrei_information28 in varchar2 default hr_api.g_varchar2
356 ,p_vrei_information29 in varchar2 default hr_api.g_varchar2
357 ,p_vrei_information30 in varchar2 default hr_api.g_varchar2
358 ,p_request_id in number default hr_api.g_number
359 ,p_program_application_id in number default hr_api.g_number
360 ,p_program_id in number default hr_api.g_number
361 ,p_program_update_date in date default hr_api.g_date
362
363 );
364 --
365 -- ----------------------------------------------------------------------------
366 -- |-----------------------< delete_veh_repos_extra_info >--------------------|
367 -- ----------------------------------------------------------------------------
368 --
369 -- {Start Of Comments}
370 /*#
371 * This API deletes vehicle repository extra information.
372 *
373 * Only one row can be deleted at a time.
374 *
375 * <p><b>Licensing</b><br>
376 * This API is licensed for use with Human Resources.
377 *
378 * <p><b>Prerequisites</b><br>
379 *
380 * <p><b>Post Success</b><br>
381 * The Vehicle Repository Extra Information record will be successfully deleted
382 * from the database.
383 *
384 * <p><b>Post Failure</b><br>
385 * The Vehicle Repository Extra Information record will not be deleted and an
386 * error will be raised.
387 *
388 * @param p_validate If true, then validation alone will be performed and the
389 * database will remain unchanged. If false and all validation checks pass,
390 * then the database will be modified.
391 * @param p_veh_repos_extra_info_id System generated primary key column using
392 * the sequence PQP_VEH_REPOS_EXTRA_INFO_S.
393 * @param p_object_version_number Current version number of the vehicle
394 * repository extra information to be deleted.
395 * @rep:displayname Delete Vehicle Repository Extra Information
396 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
397 * @rep:lifecycle active
398 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
399 * @rep:scope public
400 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
401 */
402 --
403 -- {End Of Comments}
404 --
405 procedure delete_veh_repos_extra_info
406 ( p_validate in boolean default false
407 ,p_veh_repos_extra_info_id in number
408 ,p_object_version_number in number
409 );
410 end PQP_VEH_REPOS_EXTRA_INFO_API;