[Home] [Help]
PACKAGE BODY: APPS.PQP_PCV_API
Source
1 Package Body pqp_pcv_api as
2 /* $Header: pqpcvapi.pkb 120.0 2005/05/29 01:54:57 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' pqp_pcv_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------------< create_configuration_value >--------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_configuration_value
13 (p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_business_group_id in number
16 ,p_legislation_code in varchar2 default null
17 ,p_pcv_attribute_category in varchar2 default null
18 ,p_pcv_attribute1 in varchar2 default null
19 ,p_pcv_attribute2 in varchar2 default null
20 ,p_pcv_attribute3 in varchar2 default null
21 ,p_pcv_attribute4 in varchar2 default null
22 ,p_pcv_attribute5 in varchar2 default null
23 ,p_pcv_attribute6 in varchar2 default null
24 ,p_pcv_attribute7 in varchar2 default null
25 ,p_pcv_attribute8 in varchar2 default null
26 ,p_pcv_attribute9 in varchar2 default null
27 ,p_pcv_attribute10 in varchar2 default null
28 ,p_pcv_attribute11 in varchar2 default null
29 ,p_pcv_attribute12 in varchar2 default null
30 ,p_pcv_attribute13 in varchar2 default null
31 ,p_pcv_attribute14 in varchar2 default null
32 ,p_pcv_attribute15 in varchar2 default null
33 ,p_pcv_attribute16 in varchar2 default null
34 ,p_pcv_attribute17 in varchar2 default null
35 ,p_pcv_attribute18 in varchar2 default null
36 ,p_pcv_attribute19 in varchar2 default null
37 ,p_pcv_attribute20 in varchar2 default null
38 ,p_pcv_information_category in varchar2 default null
39 ,p_pcv_information1 in varchar2 default null
40 ,p_pcv_information2 in varchar2 default null
41 ,p_pcv_information3 in varchar2 default null
42 ,p_pcv_information4 in varchar2 default null
43 ,p_pcv_information5 in varchar2 default null
44 ,p_pcv_information6 in varchar2 default null
45 ,p_pcv_information7 in varchar2 default null
46 ,p_pcv_information8 in varchar2 default null
47 ,p_pcv_information9 in varchar2 default null
48 ,p_pcv_information10 in varchar2 default null
49 ,p_pcv_information11 in varchar2 default null
50 ,p_pcv_information12 in varchar2 default null
51 ,p_pcv_information13 in varchar2 default null
52 ,p_pcv_information14 in varchar2 default null
53 ,p_pcv_information15 in varchar2 default null
54 ,p_pcv_information16 in varchar2 default null
55 ,p_pcv_information17 in varchar2 default null
56 ,p_pcv_information18 in varchar2 default null
57 ,p_pcv_information19 in varchar2 default null
58 ,p_pcv_information20 in varchar2 default null
59 ,p_configuration_value_id out nocopy number
60 ,p_object_version_number out nocopy number
61 ,p_configuration_name in varchar2 default null
62 ) is
63 --
64 -- Declare cursors and local variables
65 --
66 l_configuration_value_id number;
67 l_object_version_number number;
68 l_effective_date date;
69 l_proc varchar2(72) := g_package||'create_configuration_value';
70 begin
71 hr_utility.set_location('Entering:'|| l_proc, 10);
72 --
73 -- Issue a savepoint
74 --
75 savepoint create_configuration_value;
76 --
77 -- Remember IN OUT parameter IN values
78 --
79
80 --
81 -- Truncate the time portion from all IN date parameters
82 --
83 l_effective_date := trunc(p_effective_date);
84
85 --
86 -- Call Before Process User Hook
87 --
88
89 begin
90 pqp_pcv_bk1.create_configuration_value_b
91 (p_configuration_value_id => l_configuration_value_id
92 ,p_effective_date => l_effective_date
93 ,p_object_version_number => l_object_version_number
94 ,p_business_group_id => p_business_group_id
95 ,p_legislation_code => p_legislation_code
96 ,p_pcv_attribute_category => p_pcv_attribute_category
97 ,p_pcv_attribute1 => p_pcv_attribute1
98 ,p_pcv_attribute2 => p_pcv_attribute2
99 ,p_pcv_attribute3 => p_pcv_attribute3
100 ,p_pcv_attribute4 => p_pcv_attribute4
101 ,p_pcv_attribute5 => p_pcv_attribute5
102 ,p_pcv_attribute6 => p_pcv_attribute6
103 ,p_pcv_attribute7 => p_pcv_attribute7
104 ,p_pcv_attribute8 => p_pcv_attribute8
105 ,p_pcv_attribute9 => p_pcv_attribute9
106 ,p_pcv_attribute10 => p_pcv_attribute10
107 ,p_pcv_attribute11 => p_pcv_attribute11
108 ,p_pcv_attribute12 => p_pcv_attribute12
109 ,p_pcv_attribute13 => p_pcv_attribute13
110 ,p_pcv_attribute14 => p_pcv_attribute14
111 ,p_pcv_attribute15 => p_pcv_attribute15
112 ,p_pcv_attribute16 => p_pcv_attribute16
113 ,p_pcv_attribute17 => p_pcv_attribute17
114 ,p_pcv_attribute18 => p_pcv_attribute18
115 ,p_pcv_attribute19 => p_pcv_attribute19
116 ,p_pcv_attribute20 => p_pcv_attribute20
117 ,p_pcv_information_category => p_pcv_information_category
118 ,p_pcv_information1 => p_pcv_information1
119 ,p_pcv_information2 => p_pcv_information2
120 ,p_pcv_information3 => p_pcv_information3
121 ,p_pcv_information4 => p_pcv_information4
122 ,p_pcv_information5 => p_pcv_information5
123 ,p_pcv_information6 => p_pcv_information6
124 ,p_pcv_information7 => p_pcv_information7
125 ,p_pcv_information8 => p_pcv_information8
126 ,p_pcv_information9 => p_pcv_information9
127 ,p_pcv_information10 => p_pcv_information10
128 ,p_pcv_information11 => p_pcv_information11
129 ,p_pcv_information12 => p_pcv_information12
130 ,p_pcv_information13 => p_pcv_information13
131 ,p_pcv_information14 => p_pcv_information14
132 ,p_pcv_information15 => p_pcv_information15
133 ,p_pcv_information16 => p_pcv_information16
134 ,p_pcv_information17 => p_pcv_information17
135 ,p_pcv_information18 => p_pcv_information18
136 ,p_pcv_information19 => p_pcv_information19
137 ,p_pcv_information20 => p_pcv_information20
138 ,p_configuration_name => p_configuration_name
139
140 );
141 exception
142 when hr_api.cannot_find_prog_unit then
143 hr_api.cannot_find_prog_unit_error
144 (p_module_name => 'create_configuration_value'
145 ,p_hook_type => 'BP'
146 );
147 end;
148 --
149 -- Validation in addition to Row Handlers
150 --
151
152
153
154 --
155 -- Process Logic
156 --
157 pqp_pcv_ins.ins
158 (p_business_group_id => p_business_group_id
159 ,p_effective_date => l_effective_date
160 ,p_legislation_code => p_legislation_code
161 ,p_pcv_attribute_category => p_pcv_attribute_category
162 ,p_pcv_attribute1 => p_pcv_attribute1
163 ,p_pcv_attribute2 => p_pcv_attribute2
164 ,p_pcv_attribute3 => p_pcv_attribute3
165 ,p_pcv_attribute4 => p_pcv_attribute4
166 ,p_pcv_attribute5 => p_pcv_attribute5
167 ,p_pcv_attribute6 => p_pcv_attribute6
168 ,p_pcv_attribute7 => p_pcv_attribute7
169 ,p_pcv_attribute8 => p_pcv_attribute8
170 ,p_pcv_attribute9 => p_pcv_attribute9
171 ,p_pcv_attribute10 => p_pcv_attribute10
172 ,p_pcv_attribute11 => p_pcv_attribute11
173 ,p_pcv_attribute12 => p_pcv_attribute12
174 ,p_pcv_attribute13 => p_pcv_attribute13
175 ,p_pcv_attribute14 => p_pcv_attribute14
176 ,p_pcv_attribute15 => p_pcv_attribute15
177 ,p_pcv_attribute16 => p_pcv_attribute16
178 ,p_pcv_attribute17 => p_pcv_attribute17
179 ,p_pcv_attribute18 => p_pcv_attribute18
180 ,p_pcv_attribute19 => p_pcv_attribute19
181 ,p_pcv_attribute20 => p_pcv_attribute20
182 ,p_pcv_information_category => p_pcv_information_category
183 ,p_pcv_information1 => p_pcv_information1
184 ,p_pcv_information2 => p_pcv_information2
185 ,p_pcv_information3 => p_pcv_information3
186 ,p_pcv_information4 => p_pcv_information4
187 ,p_pcv_information5 => p_pcv_information5
188 ,p_pcv_information6 => p_pcv_information6
189 ,p_pcv_information7 => p_pcv_information7
190 ,p_pcv_information8 => p_pcv_information8
191 ,p_pcv_information9 => p_pcv_information9
192 ,p_pcv_information10 => p_pcv_information10
193 ,p_pcv_information11 => p_pcv_information11
194 ,p_pcv_information12 => p_pcv_information12
195 ,p_pcv_information13 => p_pcv_information13
196 ,p_pcv_information14 => p_pcv_information14
197 ,p_pcv_information15 => p_pcv_information15
198 ,p_pcv_information16 => p_pcv_information16
199 ,p_pcv_information17 => p_pcv_information17
200 ,p_pcv_information18 => p_pcv_information18
201 ,p_pcv_information19 => p_pcv_information19
202 ,p_pcv_information20 => p_pcv_information20
203 ,p_configuration_value_id => l_configuration_value_id
204 ,p_object_version_number => l_object_version_number
205 ,p_configuration_name => p_configuration_name
206 );
207
208 --
209 -- Call After Process User Hook
210 --
211 begin
212 pqp_pcv_bk1.create_configuration_value_a
213 (p_configuration_value_id => l_configuration_value_id
214 ,p_effective_date => l_effective_date
215 ,p_object_version_number => l_object_version_number
216 ,p_business_group_id => p_business_group_id
217 ,p_legislation_code => p_legislation_code
218 ,p_pcv_attribute_category => p_pcv_attribute_category
219 ,p_pcv_attribute1 => p_pcv_attribute1
220 ,p_pcv_attribute2 => p_pcv_attribute2
221 ,p_pcv_attribute3 => p_pcv_attribute3
222 ,p_pcv_attribute4 => p_pcv_attribute4
223 ,p_pcv_attribute5 => p_pcv_attribute5
224 ,p_pcv_attribute6 => p_pcv_attribute6
225 ,p_pcv_attribute7 => p_pcv_attribute7
226 ,p_pcv_attribute8 => p_pcv_attribute8
227 ,p_pcv_attribute9 => p_pcv_attribute9
228 ,p_pcv_attribute10 => p_pcv_attribute10
229 ,p_pcv_attribute11 => p_pcv_attribute11
230 ,p_pcv_attribute12 => p_pcv_attribute12
231 ,p_pcv_attribute13 => p_pcv_attribute13
232 ,p_pcv_attribute14 => p_pcv_attribute14
233 ,p_pcv_attribute15 => p_pcv_attribute15
234 ,p_pcv_attribute16 => p_pcv_attribute16
235 ,p_pcv_attribute17 => p_pcv_attribute17
236 ,p_pcv_attribute18 => p_pcv_attribute18
237 ,p_pcv_attribute19 => p_pcv_attribute19
238 ,p_pcv_attribute20 => p_pcv_attribute20
239 ,p_pcv_information_category => p_pcv_information_category
240 ,p_pcv_information1 => p_pcv_information1
241 ,p_pcv_information2 => p_pcv_information2
242 ,p_pcv_information3 => p_pcv_information3
243 ,p_pcv_information4 => p_pcv_information4
244 ,p_pcv_information5 => p_pcv_information5
245 ,p_pcv_information6 => p_pcv_information6
246 ,p_pcv_information7 => p_pcv_information7
247 ,p_pcv_information8 => p_pcv_information8
248 ,p_pcv_information9 => p_pcv_information9
249 ,p_pcv_information10 => p_pcv_information10
250 ,p_pcv_information11 => p_pcv_information11
251 ,p_pcv_information12 => p_pcv_information12
252 ,p_pcv_information13 => p_pcv_information13
253 ,p_pcv_information14 => p_pcv_information14
254 ,p_pcv_information15 => p_pcv_information15
255 ,p_pcv_information16 => p_pcv_information16
256 ,p_pcv_information17 => p_pcv_information17
257 ,p_pcv_information18 => p_pcv_information18
258 ,p_pcv_information19 => p_pcv_information19
259 ,p_pcv_information20 => p_pcv_information20
260 ,p_configuration_name => p_configuration_name
261
262 );
263 exception
264 when hr_api.cannot_find_prog_unit then
265 hr_api.cannot_find_prog_unit_error
266 (p_module_name => 'create_configuration_value'
267 ,p_hook_type => 'AP'
268 );
269 end;
270 --
271 -- When in validation only mode raise the Validate_Enabled exception
272 --
273 if p_validate then
274 raise hr_api.validate_enabled;
275 end if;
276 --
277 -- Set all IN OUT and OUT parameters with out values
278 --
279 p_configuration_value_id := l_configuration_value_id;
280 p_object_version_number := l_object_version_number;
281 --
282 hr_utility.set_location(' Leaving:'||l_proc, 70);
283 exception
284 when hr_api.validate_enabled then
285 --
286 -- As the Validate_Enabled exception has been raised
287 -- we must rollback to the savepoint
288 --
289 rollback to create_configuration_value;
290 --
291 -- Reset IN OUT parameters and set OUT parameters
292 -- (Any key or derived arguments must be set to null
293 -- when validation only mode is being used.)
294 --
295 p_configuration_value_id := null;
296 p_object_version_number := null;
297 hr_utility.set_location(' Leaving:'||l_proc, 80);
298 when others then
299 --
300 -- A validation or unexpected error has occured
301 --
302 rollback to create_configuration_value;
303 --
304 -- Reset IN OUT parameters and set all
305 -- OUT parameters, including warnings, to null
306 --
307 p_configuration_value_id := null;
308 p_object_version_number := null;
309 hr_utility.set_location(' Leaving:'||l_proc, 90);
310 raise;
311 end create_configuration_value;
312 --
313 --
314 -- ----------------------------------------------------------------------------
315 -- |--------------------------< update_configuration_value >--------------------------|
316 -- ----------------------------------------------------------------------------
317 --
318 procedure update_configuration_value
319 (p_validate in boolean default false
320 ,p_effective_date in date
321 ,p_business_group_id in number
322 ,p_configuration_value_id in number
323 ,p_legislation_code in varchar2 default hr_api.g_varchar2
324 ,p_pcv_attribute_category in varchar2 default hr_api.g_varchar2
325 ,p_pcv_attribute1 in varchar2 default hr_api.g_varchar2
326 ,p_pcv_attribute2 in varchar2 default hr_api.g_varchar2
327 ,p_pcv_attribute3 in varchar2 default hr_api.g_varchar2
328 ,p_pcv_attribute4 in varchar2 default hr_api.g_varchar2
332 ,p_pcv_attribute8 in varchar2 default hr_api.g_varchar2
329 ,p_pcv_attribute5 in varchar2 default hr_api.g_varchar2
330 ,p_pcv_attribute6 in varchar2 default hr_api.g_varchar2
331 ,p_pcv_attribute7 in varchar2 default hr_api.g_varchar2
333 ,p_pcv_attribute9 in varchar2 default hr_api.g_varchar2
334 ,p_pcv_attribute10 in varchar2 default hr_api.g_varchar2
335 ,p_pcv_attribute11 in varchar2 default hr_api.g_varchar2
336 ,p_pcv_attribute12 in varchar2 default hr_api.g_varchar2
337 ,p_pcv_attribute13 in varchar2 default hr_api.g_varchar2
338 ,p_pcv_attribute14 in varchar2 default hr_api.g_varchar2
339 ,p_pcv_attribute15 in varchar2 default hr_api.g_varchar2
340 ,p_pcv_attribute16 in varchar2 default hr_api.g_varchar2
341 ,p_pcv_attribute17 in varchar2 default hr_api.g_varchar2
342 ,p_pcv_attribute18 in varchar2 default hr_api.g_varchar2
343 ,p_pcv_attribute19 in varchar2 default hr_api.g_varchar2
344 ,p_pcv_attribute20 in varchar2 default hr_api.g_varchar2
345 ,p_pcv_information_category in varchar2 default hr_api.g_varchar2
346 ,p_pcv_information1 in varchar2 default hr_api.g_varchar2
347 ,p_pcv_information2 in varchar2 default hr_api.g_varchar2
348 ,p_pcv_information3 in varchar2 default hr_api.g_varchar2
349 ,p_pcv_information4 in varchar2 default hr_api.g_varchar2
350 ,p_pcv_information5 in varchar2 default hr_api.g_varchar2
351 ,p_pcv_information6 in varchar2 default hr_api.g_varchar2
352 ,p_pcv_information7 in varchar2 default hr_api.g_varchar2
353 ,p_pcv_information8 in varchar2 default hr_api.g_varchar2
354 ,p_pcv_information9 in varchar2 default hr_api.g_varchar2
355 ,p_pcv_information10 in varchar2 default hr_api.g_varchar2
356 ,p_pcv_information11 in varchar2 default hr_api.g_varchar2
357 ,p_pcv_information12 in varchar2 default hr_api.g_varchar2
358 ,p_pcv_information13 in varchar2 default hr_api.g_varchar2
359 ,p_pcv_information14 in varchar2 default hr_api.g_varchar2
360 ,p_pcv_information15 in varchar2 default hr_api.g_varchar2
361 ,p_pcv_information16 in varchar2 default hr_api.g_varchar2
362 ,p_pcv_information17 in varchar2 default hr_api.g_varchar2
363 ,p_pcv_information18 in varchar2 default hr_api.g_varchar2
364 ,p_pcv_information19 in varchar2 default hr_api.g_varchar2
365 ,p_pcv_information20 in varchar2 default hr_api.g_varchar2
366 ,p_object_version_number in out nocopy number
367 ,p_configuration_name in varchar2 default hr_api.g_varchar2
368 ) is
369 --
370 -- Declare cursors and local variables
371 --
372 l_object_version_number number;
373 l_effective_date date;
374 l_proc varchar2(72) := g_package||'update_configuration_value';
375 begin
376 hr_utility.set_location('Entering:'|| l_proc, 10);
377 --
378 -- Issue a savepoint
379 --
380 savepoint update_configuration_value;
381 --
382 -- Remember IN OUT parameter IN values
383 --
384 l_object_version_number := p_object_version_number;
385
386 --
387 -- Truncate the time portion from all IN date parameters
388 --
389 l_effective_date := trunc(p_effective_date);
390
391 --
392 -- Call Before Process User Hook
393 --
394 begin
395 pqp_pcv_bk2.update_configuration_value_b
396 (p_configuration_value_id => p_configuration_value_id
397 ,p_effective_date => l_effective_date
398 ,p_object_version_number => l_object_version_number
399 ,p_business_group_id => p_business_group_id
400 ,p_legislation_code => p_legislation_code
401 ,p_pcv_attribute_category => p_pcv_attribute_category
402 ,p_pcv_attribute1 => p_pcv_attribute1
403 ,p_pcv_attribute2 => p_pcv_attribute2
404 ,p_pcv_attribute3 => p_pcv_attribute3
405 ,p_pcv_attribute4 => p_pcv_attribute4
406 ,p_pcv_attribute5 => p_pcv_attribute5
407 ,p_pcv_attribute6 => p_pcv_attribute6
408 ,p_pcv_attribute7 => p_pcv_attribute7
409 ,p_pcv_attribute8 => p_pcv_attribute8
410 ,p_pcv_attribute9 => p_pcv_attribute9
411 ,p_pcv_attribute10 => p_pcv_attribute10
412 ,p_pcv_attribute11 => p_pcv_attribute11
413 ,p_pcv_attribute12 => p_pcv_attribute12
414 ,p_pcv_attribute13 => p_pcv_attribute13
415 ,p_pcv_attribute14 => p_pcv_attribute14
416 ,p_pcv_attribute15 => p_pcv_attribute15
417 ,p_pcv_attribute16 => p_pcv_attribute16
418 ,p_pcv_attribute17 => p_pcv_attribute17
419 ,p_pcv_attribute18 => p_pcv_attribute18
420 ,p_pcv_attribute19 => p_pcv_attribute19
421 ,p_pcv_attribute20 => p_pcv_attribute20
422 ,p_pcv_information_category => p_pcv_information_category
423 ,p_pcv_information1 => p_pcv_information1
424 ,p_pcv_information2 => p_pcv_information2
425 ,p_pcv_information3 => p_pcv_information3
426 ,p_pcv_information4 => p_pcv_information4
427 ,p_pcv_information5 => p_pcv_information5
431 ,p_pcv_information9 => p_pcv_information9
428 ,p_pcv_information6 => p_pcv_information6
429 ,p_pcv_information7 => p_pcv_information7
430 ,p_pcv_information8 => p_pcv_information8
432 ,p_pcv_information10 => p_pcv_information10
433 ,p_pcv_information11 => p_pcv_information11
434 ,p_pcv_information12 => p_pcv_information12
435 ,p_pcv_information13 => p_pcv_information13
436 ,p_pcv_information14 => p_pcv_information14
437 ,p_pcv_information15 => p_pcv_information15
438 ,p_pcv_information16 => p_pcv_information16
439 ,p_pcv_information17 => p_pcv_information17
440 ,p_pcv_information18 => p_pcv_information18
441 ,p_pcv_information19 => p_pcv_information19
442 ,p_pcv_information20 => p_pcv_information20
443 ,p_configuration_name => p_configuration_name
444
445 );
446 exception
447 when hr_api.cannot_find_prog_unit then
448 hr_api.cannot_find_prog_unit_error
449 (p_module_name => 'update_configuration_value'
450 ,p_hook_type => 'BP'
451 );
452 end;
453 --
454 -- Validation in addition to Row Handlers
455 --
456
457
458
459 --
460 -- Process Logic
461 --
462 pqp_pcv_upd.upd
463 (p_configuration_value_id => p_configuration_value_id
464 ,p_effective_date => l_effective_date
465 ,p_object_version_number => l_object_version_number
466 ,p_business_group_id => p_business_group_id
467 ,p_legislation_code => p_legislation_code
468 ,p_pcv_attribute_category => p_pcv_attribute_category
469 ,p_pcv_attribute1 => p_pcv_attribute1
470 ,p_pcv_attribute2 => p_pcv_attribute2
471 ,p_pcv_attribute3 => p_pcv_attribute3
472 ,p_pcv_attribute4 => p_pcv_attribute4
473 ,p_pcv_attribute5 => p_pcv_attribute5
474 ,p_pcv_attribute6 => p_pcv_attribute6
475 ,p_pcv_attribute7 => p_pcv_attribute7
476 ,p_pcv_attribute8 => p_pcv_attribute8
477 ,p_pcv_attribute9 => p_pcv_attribute9
478 ,p_pcv_attribute10 => p_pcv_attribute10
479 ,p_pcv_attribute11 => p_pcv_attribute11
480 ,p_pcv_attribute12 => p_pcv_attribute12
481 ,p_pcv_attribute13 => p_pcv_attribute13
482 ,p_pcv_attribute14 => p_pcv_attribute14
483 ,p_pcv_attribute15 => p_pcv_attribute15
484 ,p_pcv_attribute16 => p_pcv_attribute16
485 ,p_pcv_attribute17 => p_pcv_attribute17
486 ,p_pcv_attribute18 => p_pcv_attribute18
487 ,p_pcv_attribute19 => p_pcv_attribute19
488 ,p_pcv_attribute20 => p_pcv_attribute20
489 ,p_pcv_information_category => p_pcv_information_category
490 ,p_pcv_information1 => p_pcv_information1
491 ,p_pcv_information2 => p_pcv_information2
492 ,p_pcv_information3 => p_pcv_information3
493 ,p_pcv_information4 => p_pcv_information4
494 ,p_pcv_information5 => p_pcv_information5
495 ,p_pcv_information6 => p_pcv_information6
496 ,p_pcv_information7 => p_pcv_information7
497 ,p_pcv_information8 => p_pcv_information8
498 ,p_pcv_information9 => p_pcv_information9
499 ,p_pcv_information10 => p_pcv_information10
500 ,p_pcv_information11 => p_pcv_information11
501 ,p_pcv_information12 => p_pcv_information12
502 ,p_pcv_information13 => p_pcv_information13
503 ,p_pcv_information14 => p_pcv_information14
504 ,p_pcv_information15 => p_pcv_information15
505 ,p_pcv_information16 => p_pcv_information16
506 ,p_pcv_information17 => p_pcv_information17
507 ,p_pcv_information18 => p_pcv_information18
508 ,p_pcv_information19 => p_pcv_information19
509 ,p_pcv_information20 => p_pcv_information20
510 ,p_configuration_name => p_configuration_name
511 );
512
513 --
514 -- Call After Process User Hook
515 --
516 begin
517 pqp_pcv_bk2.update_configuration_value_a
518 (p_configuration_value_id => p_configuration_value_id
519 ,p_effective_date => l_effective_date
520 ,p_object_version_number => l_object_version_number
521 ,p_business_group_id => p_business_group_id
522 ,p_legislation_code => p_legislation_code
523 ,p_pcv_attribute_category => p_pcv_attribute_category
524 ,p_pcv_attribute1 => p_pcv_attribute1
525 ,p_pcv_attribute2 => p_pcv_attribute2
526 ,p_pcv_attribute3 => p_pcv_attribute3
527 ,p_pcv_attribute4 => p_pcv_attribute4
528 ,p_pcv_attribute5 => p_pcv_attribute5
529 ,p_pcv_attribute6 => p_pcv_attribute6
530 ,p_pcv_attribute7 => p_pcv_attribute7
531 ,p_pcv_attribute8 => p_pcv_attribute8
532 ,p_pcv_attribute9 => p_pcv_attribute9
536 ,p_pcv_attribute13 => p_pcv_attribute13
533 ,p_pcv_attribute10 => p_pcv_attribute10
534 ,p_pcv_attribute11 => p_pcv_attribute11
535 ,p_pcv_attribute12 => p_pcv_attribute12
537 ,p_pcv_attribute14 => p_pcv_attribute14
538 ,p_pcv_attribute15 => p_pcv_attribute15
539 ,p_pcv_attribute16 => p_pcv_attribute16
540 ,p_pcv_attribute17 => p_pcv_attribute17
541 ,p_pcv_attribute18 => p_pcv_attribute18
542 ,p_pcv_attribute19 => p_pcv_attribute19
543 ,p_pcv_attribute20 => p_pcv_attribute20
544 ,p_pcv_information_category => p_pcv_information_category
545 ,p_pcv_information1 => p_pcv_information1
546 ,p_pcv_information2 => p_pcv_information2
547 ,p_pcv_information3 => p_pcv_information3
548 ,p_pcv_information4 => p_pcv_information4
549 ,p_pcv_information5 => p_pcv_information5
550 ,p_pcv_information6 => p_pcv_information6
551 ,p_pcv_information7 => p_pcv_information7
552 ,p_pcv_information8 => p_pcv_information8
553 ,p_pcv_information9 => p_pcv_information9
554 ,p_pcv_information10 => p_pcv_information10
555 ,p_pcv_information11 => p_pcv_information11
556 ,p_pcv_information12 => p_pcv_information12
557 ,p_pcv_information13 => p_pcv_information13
558 ,p_pcv_information14 => p_pcv_information14
559 ,p_pcv_information15 => p_pcv_information15
560 ,p_pcv_information16 => p_pcv_information16
561 ,p_pcv_information17 => p_pcv_information17
562 ,p_pcv_information18 => p_pcv_information18
563 ,p_pcv_information19 => p_pcv_information19
564 ,p_pcv_information20 => p_pcv_information20
565 ,p_configuration_name => p_configuration_name
566
567 );
568 exception
569 when hr_api.cannot_find_prog_unit then
570 hr_api.cannot_find_prog_unit_error
571 (p_module_name => 'update_configuration_value'
572 ,p_hook_type => 'AP'
573 );
574 end;
575 --
576 -- When in validation only mode raise the Validate_Enabled exception
577 --
578 if p_validate then
579 raise hr_api.validate_enabled;
580 end if;
581 --
582 -- Set all IN OUT and OUT parameters with out values
583 --
584 p_object_version_number := l_object_version_number;
585 --
586 hr_utility.set_location(' Leaving:'||l_proc, 70);
587 exception
588 when hr_api.validate_enabled then
589 --
590 -- As the Validate_Enabled exception has been raised
591 -- we must rollback to the savepoint
592 --
593 rollback to update_configuration_value;
594 --
595 -- Reset IN OUT parameters and set OUT parameters
596 -- (Any key or derived arguments must be set to null
597 -- when validation only mode is being used.)
598 --
599 p_object_version_number := null;
600 hr_utility.set_location(' Leaving:'||l_proc, 80);
601 when others then
602 --
603 -- A validation or unexpected error has occured
604 --
605 rollback to update_configuration_value;
606 --
607 -- Reset IN OUT parameters and set all
608 -- OUT parameters, including warnings, to null
609 --
610 p_object_version_number := null;
611 hr_utility.set_location(' Leaving:'||l_proc, 90);
612 raise;
613 end update_configuration_value;
614 --
615 --
616 -- ----------------------------------------------------------------------------
617 -- |--------------------------< delete_configuration_value >--------------------------|
618 -- ----------------------------------------------------------------------------
619 --
620 procedure delete_configuration_value
621 (p_validate in boolean default false
622 ,p_business_group_id in number
623 ,p_configuration_value_id in number
624 ,p_object_version_number in number
625 ) is
626 --
627 -- Declare cursors and local variables
628 --
629 l_object_version_number number;
630 l_proc varchar2(72) := g_package||'delete_configuration_value';
631 begin
632 hr_utility.set_location('Entering:'|| l_proc, 10);
633 --
634 -- Issue a savepoint
635 --
636 savepoint delete_configuration_value;
637 --
638 -- Remember IN OUT parameter IN values
639 --
640 -- l_in_out_parameter := p_in_out_parameter;
641
642 --
643 -- Call Before Process User Hook
644 --
645 begin
646 pqp_pcv_bk3.delete_configuration_value_b
647 (p_configuration_value_id => p_configuration_value_id
648 ,p_object_version_number => p_object_version_number
649 );
650 exception
651 when hr_api.cannot_find_prog_unit then
652 hr_api.cannot_find_prog_unit_error
653 (p_module_name => 'delete_configuration_value'
654 ,p_hook_type => 'BP'
655 );
656 end;
657 --
658 -- Validation in addition to Row Handlers
659 --
660
661
662
663 --
664 -- Process Logic
665 --
666 pqp_pcv_del.del
667 (p_configuration_value_id => p_configuration_value_id
668 ,p_object_version_number => p_object_version_number
669 );
670
671 --
675 pqp_pcv_bk3.delete_configuration_value_a
672 -- Call After Process User Hook
673 --
674 begin
676 (p_configuration_value_id => p_configuration_value_id
677 ,p_object_version_number => p_object_version_number
678 );
679 exception
680 when hr_api.cannot_find_prog_unit then
681 hr_api.cannot_find_prog_unit_error
682 (p_module_name => 'delete_configuration_value'
683 ,p_hook_type => 'AP'
684 );
685 end;
686 --
687 -- When in validation only mode raise the Validate_Enabled exception
688 --
689 if p_validate then
690 raise hr_api.validate_enabled;
691 end if;
692 --
693 -- Set all IN OUT and OUT parameters with out values
694 --
695 -- p_object_version_number := l_object_version_number;
696 --
697 hr_utility.set_location(' Leaving:'||l_proc, 70);
698 exception
699 when hr_api.validate_enabled then
700 --
701 -- As the Validate_Enabled exception has been raised
702 -- we must rollback to the savepoint
703 --
704 rollback to delete_configuration_value;
705 --
706 -- Reset IN OUT parameters and set OUT parameters
707 -- (Any key or derived arguments must be set to null
708 -- when validation only mode is being used.)
709 --
710 -- p_object_version_number := null;
711 hr_utility.set_location(' Leaving:'||l_proc, 80);
712 when others then
713 --
714 -- A validation or unexpected error has occured
715 --
716 rollback to delete_configuration_value;
717 --
718 -- Reset IN OUT parameters and set all
719 -- OUT parameters, including warnings, to null
720 --
721 -- p_object_version_number := null;
722 hr_utility.set_location(' Leaving:'||l_proc, 90);
723 raise;
724 end delete_configuration_value;
725 --
726 end pqp_pcv_api;