1 Package pqp_pcv_api as
2 /* $Header: pqpcvapi.pkh 120.1 2005/10/02 02:45:10 aroussel $ */
3 /*#
4 * This package contains APIs for configuration values.
5 * @rep:scope public
6 * @rep:product PER
7 * @rep:displayname Configuration Value
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< create_configuration_value >--------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a configuration values record for a particular
17 * configuration type.
18 *
19 * The columns for the configuration values are determined in the flexfield for
20 * the configuration type. This is predefined by the product teams. The
21 * configuration type definition determines whether there can be multiple rows
22 * for a type.
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 * The configuration type and module need to be present in the configuration
29 * type and configuration module tables respectively.
30 *
31 * <p><b>Post Success</b><br>
32 * The configuration value record will be created in the table.
33 *
34 * <p><b>Post Failure</b><br>
35 * The configuration value record will be not be created and an error will be
36 * raised.
37 *
38 * @param p_validate If true, then validation alone will be performed and the
39 * database will remain unchanged. If false and all validation checks pass,
40 * then the database will be modified.
41 * @param p_effective_date Reference date for validating lookup values are
42 * applicable during the start to end active date range. This date does not
43 * determine when the changes take effect.
44 * @param p_business_group_id {@rep:casecolumn
45 * PQP_CONFIGURATION_VALUES.BUSINESS_GROUP_ID}
46 * @param p_legislation_code {@rep:casecolumn
47 * PQP_CONFIGURATION_VALUES.LEGISLATION_CODE}
48 * @param p_pcv_attribute_category {@rep:casecolumn
49 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE_CATEGORY}
50 * @param p_pcv_attribute1 {@rep:casecolumn
51 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE1}
52 * @param p_pcv_attribute2 {@rep:casecolumn
53 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE2}
54 * @param p_pcv_attribute3 {@rep:casecolumn
55 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE3}
56 * @param p_pcv_attribute4 {@rep:casecolumn
57 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE4}
58 * @param p_pcv_attribute5 {@rep:casecolumn
59 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE5}
60 * @param p_pcv_attribute6 {@rep:casecolumn
61 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE6}
62 * @param p_pcv_attribute7 {@rep:casecolumn
63 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE7}
64 * @param p_pcv_attribute8 {@rep:casecolumn
65 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE8}
66 * @param p_pcv_attribute9 {@rep:casecolumn
67 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE9}
68 * @param p_pcv_attribute10 {@rep:casecolumn
69 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE10}
70 * @param p_pcv_attribute11 {@rep:casecolumn
71 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE11}
72 * @param p_pcv_attribute12 {@rep:casecolumn
73 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE12}
74 * @param p_pcv_attribute13 {@rep:casecolumn
75 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE13}
76 * @param p_pcv_attribute14 {@rep:casecolumn
77 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE14}
78 * @param p_pcv_attribute15 {@rep:casecolumn
79 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE15}
80 * @param p_pcv_attribute16 {@rep:casecolumn
81 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE16}
82 * @param p_pcv_attribute17 {@rep:casecolumn
83 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE17}
84 * @param p_pcv_attribute18 {@rep:casecolumn
85 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE18}
86 * @param p_pcv_attribute19 {@rep:casecolumn
87 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE19}
88 * @param p_pcv_attribute20 {@rep:casecolumn
89 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE20}
90 * @param p_pcv_information_category {@rep:casecolumn
91 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION_CATEGORY}
92 * @param p_pcv_information1 {@rep:casecolumn
93 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION1}
94 * @param p_pcv_information2 {@rep:casecolumn
95 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION2}
96 * @param p_pcv_information3 {@rep:casecolumn
97 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION3}
98 * @param p_pcv_information4 {@rep:casecolumn
99 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION4}
100 * @param p_pcv_information5 {@rep:casecolumn
101 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION5}
102 * @param p_pcv_information6 {@rep:casecolumn
103 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION6}
104 * @param p_pcv_information7 {@rep:casecolumn
105 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION7}
106 * @param p_pcv_information8 {@rep:casecolumn
107 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION8}
108 * @param p_pcv_information9 {@rep:casecolumn
109 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION9}
110 * @param p_pcv_information10 {@rep:casecolumn
111 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION10}
112 * @param p_pcv_information11 {@rep:casecolumn
113 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION11}
114 * @param p_pcv_information12 {@rep:casecolumn
115 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION12}
116 * @param p_pcv_information13 {@rep:casecolumn
117 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION13}
118 * @param p_pcv_information14 {@rep:casecolumn
119 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION14}
120 * @param p_pcv_information15 {@rep:casecolumn
121 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION15}
122 * @param p_pcv_information16 {@rep:casecolumn
123 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION16}
124 * @param p_pcv_information17 {@rep:casecolumn
125 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION17}
126 * @param p_pcv_information18 {@rep:casecolumn
127 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION18}
128 * @param p_pcv_information19 {@rep:casecolumn
129 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION19}
130 * @param p_pcv_information20 {@rep:casecolumn
131 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION20}
132 * @param p_configuration_value_id The primary key generated for the
133 * configuration value record. If p_validate is true, then set to null.
134 * @param p_object_version_number If p_validate is false, then set to the
135 * version number of the created configuration value. If p_validate is true,
136 * then the value will be null.
137 * @param p_configuration_name A name to identify the unique row for the
138 * configuration values. This is used to identify the row when the
139 * configuration category can have more than one row.
140 * @rep:displayname Create Configuration Value
141 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
142 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
143 * @rep:lifecycle active
144 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
145 * @rep:scope public
146 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
147 */
148 --
149 -- {End Of Comments}
150 --
151 procedure create_configuration_value
152 (p_validate in boolean default false
153 ,p_effective_date in date
154 ,p_business_group_id in number
155 ,p_legislation_code in varchar2 default null
156 ,p_pcv_attribute_category in varchar2 default null
157 ,p_pcv_attribute1 in varchar2 default null
158 ,p_pcv_attribute2 in varchar2 default null
159 ,p_pcv_attribute3 in varchar2 default null
160 ,p_pcv_attribute4 in varchar2 default null
161 ,p_pcv_attribute5 in varchar2 default null
162 ,p_pcv_attribute6 in varchar2 default null
163 ,p_pcv_attribute7 in varchar2 default null
164 ,p_pcv_attribute8 in varchar2 default null
165 ,p_pcv_attribute9 in varchar2 default null
166 ,p_pcv_attribute10 in varchar2 default null
167 ,p_pcv_attribute11 in varchar2 default null
168 ,p_pcv_attribute12 in varchar2 default null
169 ,p_pcv_attribute13 in varchar2 default null
170 ,p_pcv_attribute14 in varchar2 default null
171 ,p_pcv_attribute15 in varchar2 default null
172 ,p_pcv_attribute16 in varchar2 default null
173 ,p_pcv_attribute17 in varchar2 default null
174 ,p_pcv_attribute18 in varchar2 default null
175 ,p_pcv_attribute19 in varchar2 default null
176 ,p_pcv_attribute20 in varchar2 default null
177 ,p_pcv_information_category in varchar2 default null
178 ,p_pcv_information1 in varchar2 default null
179 ,p_pcv_information2 in varchar2 default null
180 ,p_pcv_information3 in varchar2 default null
181 ,p_pcv_information4 in varchar2 default null
182 ,p_pcv_information5 in varchar2 default null
183 ,p_pcv_information6 in varchar2 default null
184 ,p_pcv_information7 in varchar2 default null
185 ,p_pcv_information8 in varchar2 default null
186 ,p_pcv_information9 in varchar2 default null
187 ,p_pcv_information10 in varchar2 default null
188 ,p_pcv_information11 in varchar2 default null
189 ,p_pcv_information12 in varchar2 default null
190 ,p_pcv_information13 in varchar2 default null
191 ,p_pcv_information14 in varchar2 default null
192 ,p_pcv_information15 in varchar2 default null
193 ,p_pcv_information16 in varchar2 default null
194 ,p_pcv_information17 in varchar2 default null
195 ,p_pcv_information18 in varchar2 default null
196 ,p_pcv_information19 in varchar2 default null
197 ,p_pcv_information20 in varchar2 default null
198 ,p_configuration_value_id out nocopy number
199 ,p_object_version_number out nocopy number
200 ,p_configuration_name in varchar2 default null
201 );
202 --
203 -- ----------------------------------------------------------------------------
204 -- |------------------------< update_configuration_value >--------------------|
205 -- ----------------------------------------------------------------------------
206 --
207 -- {Start Of Comments}
208 /*#
209 * This API updates a configuration values record for a particular
210 * configuration type.
211 *
212 * The columns for the configuration values are determined in the flexfield for
213 * the configuration type. This is predefined by the product teams. The
214 * configuration type definition determines whether there can be multiple rows
215 * for a type.
216 *
217 * <p><b>Licensing</b><br>
218 * This API is licensed for use with Human Resources.
219 *
220 * <p><b>Prerequisites</b><br>
221 * The configuration type and module need to be present in the configuration
222 * type and configuration module tables respectively.
223 *
224 * <p><b>Post Success</b><br>
225 * The configuration value record will be updated in the table.
226 *
227 * <p><b>Post Failure</b><br>
228 * The configuration value record will be not be updated and an error will be
229 * raised.
230 *
231 * @param p_validate If true, then validation alone will be performed and the
232 * database will remain unchanged. If false and all validation checks pass,
233 * then the database will be modified.
234 * @param p_effective_date Reference date for validating lookup values are
235 * applicable during the start to end active date range. This date does not
236 * determine when the changes take effect.
237 * @param p_business_group_id {@rep:casecolumn
238 * PQP_CONFIGURATION_VALUES.BUSINESS_GROUP_ID}
239 * @param p_configuration_value_id {@rep:casecolumn
240 * PQP_CONFIGURATION_VALUES.CONFIGURATION_VALUE_ID}
241 * @param p_legislation_code {@rep:casecolumn
242 * PQP_CONFIGURATION_VALUES.LEGISLATION_CODE}
243 * @param p_pcv_attribute_category {@rep:casecolumn
244 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE_CATEGORY}
245 * @param p_pcv_attribute1 {@rep:casecolumn
246 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE1}
247 * @param p_pcv_attribute2 {@rep:casecolumn
248 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE2}
249 * @param p_pcv_attribute3 {@rep:casecolumn
250 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE3}
251 * @param p_pcv_attribute4 {@rep:casecolumn
252 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE4}
253 * @param p_pcv_attribute5 {@rep:casecolumn
254 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE5}
255 * @param p_pcv_attribute6 {@rep:casecolumn
256 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE6}
257 * @param p_pcv_attribute7 {@rep:casecolumn
258 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE7}
259 * @param p_pcv_attribute8 {@rep:casecolumn
260 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE8}
261 * @param p_pcv_attribute9 {@rep:casecolumn
262 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE9}
263 * @param p_pcv_attribute10 {@rep:casecolumn
264 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE10}
265 * @param p_pcv_attribute11 {@rep:casecolumn
266 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE11}
267 * @param p_pcv_attribute12 {@rep:casecolumn
268 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE12}
269 * @param p_pcv_attribute13 {@rep:casecolumn
270 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE13}
271 * @param p_pcv_attribute14 {@rep:casecolumn
272 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE14}
273 * @param p_pcv_attribute15 {@rep:casecolumn
274 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE15}
275 * @param p_pcv_attribute16 {@rep:casecolumn
276 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE16}
277 * @param p_pcv_attribute17 {@rep:casecolumn
278 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE17}
279 * @param p_pcv_attribute18 {@rep:casecolumn
280 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE18}
281 * @param p_pcv_attribute19 {@rep:casecolumn
282 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE19}
283 * @param p_pcv_attribute20 {@rep:casecolumn
284 * PQP_CONFIGURATION_VALUES.PCV_ATTRIBUTE20}
285 * @param p_pcv_information_category {@rep:casecolumn
286 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION_CATEGORY}
287 * @param p_pcv_information1 {@rep:casecolumn
288 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION1}
289 * @param p_pcv_information2 {@rep:casecolumn
290 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION2}
291 * @param p_pcv_information3 {@rep:casecolumn
292 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION3}
293 * @param p_pcv_information4 {@rep:casecolumn
294 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION4}
295 * @param p_pcv_information5 {@rep:casecolumn
296 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION5}
297 * @param p_pcv_information6 {@rep:casecolumn
298 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION6}
299 * @param p_pcv_information7 {@rep:casecolumn
300 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION7}
301 * @param p_pcv_information8 {@rep:casecolumn
302 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION8}
303 * @param p_pcv_information9 {@rep:casecolumn
304 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION9}
305 * @param p_pcv_information10 {@rep:casecolumn
306 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION10}
307 * @param p_pcv_information11 {@rep:casecolumn
308 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION11}
309 * @param p_pcv_information12 {@rep:casecolumn
310 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION12}
311 * @param p_pcv_information13 {@rep:casecolumn
312 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION13}
313 * @param p_pcv_information14 {@rep:casecolumn
314 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION14}
315 * @param p_pcv_information15 {@rep:casecolumn
316 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION15}
317 * @param p_pcv_information16 {@rep:casecolumn
318 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION16}
319 * @param p_pcv_information17 {@rep:casecolumn
320 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION17}
321 * @param p_pcv_information18 {@rep:casecolumn
322 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION18}
323 * @param p_pcv_information19 {@rep:casecolumn
324 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION19}
325 * @param p_pcv_information20 {@rep:casecolumn
326 * PQP_CONFIGURATION_VALUES.PCV_INFORMATION20}
327 * @param p_object_version_number Pass in the current version number of the
331 * in.
328 * configuration value to be updated. When the API completes if p_validate is
329 * false, will be set to the new version number of the updated configuration
330 * value. If p_validate is true will be set to the same value which was passed
332 * @param p_configuration_name A name to identify the unique row for the
333 * configuration values. This is used to identify the row when the
334 * configuration category can have more than one row.
335 * @rep:displayname Update Configuration Value
336 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
337 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
338 * @rep:lifecycle active
339 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
340 * @rep:scope public
341 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
342 */
343 --
344 -- {End Of Comments}
345 --
346 procedure update_configuration_value
347 (p_validate in boolean default false
348 ,p_effective_date in date
349 ,p_business_group_id in number
350 ,p_configuration_value_id in number
351 ,p_legislation_code in varchar2 default hr_api.g_varchar2
352 ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
353 ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
354 ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
355 ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
356 ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
357 ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
358 ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
359 ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
360 ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
361 ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
362 ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
363 ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
364 ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
365 ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
366 ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
367 ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
368 ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
369 ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
370 ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
371 ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
372 ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
373 ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
374 ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
375 ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
376 ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
377 ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
378 ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
379 ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
380 ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
381 ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
382 ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
383 ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
384 ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
385 ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
386 ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
387 ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
388 ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
389 ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
390 ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
391 ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
392 ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
393 ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
394 ,p_object_version_number in out nocopy number
395 ,p_configuration_name in varchar2 default hr_api.g_varchar2
396 );
397 --
398 -- ----------------------------------------------------------------------------
399 -- |------------------------< delete_configuration_value >--------------------|
400 -- ----------------------------------------------------------------------------
401 --
402 -- {Start Of Comments}
403 /*#
404 * This API deletes a configuration values record for a particular
405 * configuration type.
406 *
407 * The columns for the configuration values are determined in the flexfield for
408 * the configuration type. This is predefined by the product teams. The
409 * configuration type definition determines whether there can be multiple rows
410 * for a type.
411 *
412 * <p><b>Licensing</b><br>
413 * This API is licensed for use with Human Resources.
414 *
415 * <p><b>Prerequisites</b><br>
416 *
417 * <p><b>Post Success</b><br>
418 * The configuration value record will be deleted in the table.
419 *
420 * <p><b>Post Failure</b><br>
421 * The configuration value record will be not be deleted and an error will be
422 * raised.
423 *
424 * @param p_validate If true, then validation alone will be performed and the
425 * database will remain unchanged. If false and all validation checks pass,
426 * then the database will be modified.
430 * PQP_CONFIGURATION_VALUES.CONFIGURATION_VALUE_ID}
427 * @param p_business_group_id {@rep:casecolumn
428 * PQP_CONFIGURATION_VALUES.BUSINESS_GROUP_ID}
429 * @param p_configuration_value_id {@rep:casecolumn
431 * @param p_object_version_number Current version number of the configuration
432 * value to be deleted.
433 * @rep:displayname Delete Configuration Value
434 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
435 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_ALLOCATION
436 * @rep:lifecycle active
437 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
438 * @rep:scope public
439 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
440 */
441 --
442 -- {End Of Comments}
443 --
444 procedure delete_configuration_value
445 (p_validate in boolean default false
446 ,p_business_group_id in number
447 ,p_configuration_value_id in number
448 ,p_object_version_number in number
449 );
450 --
451 end pqp_pcv_api;
[Home] [Help]