[Home] [Help]
PACKAGE BODY: APPS.PER_BF_PROC_ASSIGNMENT_API
Source
1 Package Body PER_BF_PROC_ASSIGNMENT_API as
2 /* $Header: pebpaapi.pkb 115.4 2002/12/02 13:04:34 apholt noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(35) := 'PER_BF_PROC_ASSIGNMENT_API.';
7 --
8 -- ---------------------------------------------------------------------------
9 -- |-----------------------< check_row_exists >------------------------------|
10 -- ---------------------------------------------------------------------------
11 PROCEDURE chk_row_exists(p_assignment_id in number
12 ,p_payroll_run_id in number) IS
13 --
14 -- Cursors
15 CURSOR csr_find_row IS
16 SELECT 'Y'
17 FROM per_bf_processed_assignments
18 WHERE payroll_run_id = p_payroll_run_id
19 AND assignment_id = p_assignment_id;
20 --
21 l_exists varchar2(1);
22 --
23 BEGIN
24 --
25 OPEN csr_find_row;
26 FETCH csr_find_row INTO l_exists;
27 --
28 IF csr_find_row%FOUND THEN
29 CLOSE csr_find_row;
30 --
31 -- Row already exists for assignment/payroll combination
32 -- Raise error
33 hr_utility.set_message(800,'PER_289340_BF_PROC_ASGN_EXISTS');
34 hr_utility.raise_error;
35 END IF;
36 CLOSE csr_find_row;
37 --
38 END chk_row_exists;
39
40 --
41 -- ----------------------------------------------------------------------------
42 -- |--------------------< create_processed_assignment >-----------------------|
43 -- ----------------------------------------------------------------------------
44 --
45 procedure create_processed_assignment
46 (p_validate in boolean default false
47 ,p_effective_date in date
48 ,p_assignment_id in number
49 ,p_payroll_run_id in number
50 ,p_bpa_attribute_category in varchar2 default null
51 ,p_bpa_attribute1 in varchar2 default null
52 ,p_bpa_attribute2 in varchar2 default null
53 ,p_bpa_attribute3 in varchar2 default null
54 ,p_bpa_attribute4 in varchar2 default null
55 ,p_bpa_attribute5 in varchar2 default null
56 ,p_bpa_attribute6 in varchar2 default null
57 ,p_bpa_attribute7 in varchar2 default null
58 ,p_bpa_attribute8 in varchar2 default null
59 ,p_bpa_attribute9 in varchar2 default null
60 ,p_bpa_attribute10 in varchar2 default null
61 ,p_bpa_attribute11 in varchar2 default null
62 ,p_bpa_attribute12 in varchar2 default null
63 ,p_bpa_attribute13 in varchar2 default null
64 ,p_bpa_attribute14 in varchar2 default null
65 ,p_bpa_attribute15 in varchar2 default null
66 ,p_bpa_attribute16 in varchar2 default null
67 ,p_bpa_attribute17 in varchar2 default null
68 ,p_bpa_attribute18 in varchar2 default null
69 ,p_bpa_attribute19 in varchar2 default null
70 ,p_bpa_attribute20 in varchar2 default null
71 ,p_bpa_attribute21 in varchar2 default null
72 ,p_bpa_attribute22 in varchar2 default null
73 ,p_bpa_attribute23 in varchar2 default null
74 ,p_bpa_attribute24 in varchar2 default null
75 ,p_bpa_attribute25 in varchar2 default null
76 ,p_bpa_attribute26 in varchar2 default null
77 ,p_bpa_attribute27 in varchar2 default null
78 ,p_bpa_attribute28 in varchar2 default null
79 ,p_bpa_attribute29 in varchar2 default null
80 ,p_bpa_attribute30 in varchar2 default null
81 ,p_processed_assignment_id out nocopy number
82 ,p_processed_assignment_ovn out nocopy number
83 ) is
84 --
85 -- Declare cursors and local variables
86 --
87 l_processed_assignment_id
88 PER_BF_PROCESSED_ASSIGNMENTS.processed_assignment_id%TYPE;
89 l_processed_assignment_ovn
90 PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;
91 --
92 l_proc varchar2(72) := g_package||'create_processed_assignment';
93 --
94 begin
95 hr_utility.set_location('Entering:'|| l_proc, 10);
96 --
97 -- Issue a savepoint
98 --
99 savepoint create_processed_assignment;
100 hr_utility.set_location(l_proc, 20);
101 --
102 -- Truncate the time portion from all IN date parameters
103 --
104 --
105 --
106 -- Call Before Process User Hook
107 --
108 begin
109 PER_BF_PROC_ASSIGNMENT_BK1.CREATE_PROCESSED_ASSIGNMENT_B
110 (p_effective_date => p_effective_date
111 ,p_assignment_id => p_assignment_id
112 ,p_payroll_run_id => p_payroll_run_id
113 ,p_bpa_attribute_category => p_bpa_attribute_category
114 ,p_bpa_attribute1 => p_bpa_attribute1
115 ,p_bpa_attribute2 => p_bpa_attribute2
116 ,p_bpa_attribute3 => p_bpa_attribute3
117 ,p_bpa_attribute4 => p_bpa_attribute4
118 ,p_bpa_attribute5 => p_bpa_attribute5
119 ,p_bpa_attribute6 => p_bpa_attribute6
120 ,p_bpa_attribute7 => p_bpa_attribute7
121 ,p_bpa_attribute8 => p_bpa_attribute8
122 ,p_bpa_attribute9 => p_bpa_attribute9
123 ,p_bpa_attribute10 => p_bpa_attribute10
124 ,p_bpa_attribute11 => p_bpa_attribute11
125 ,p_bpa_attribute12 => p_bpa_attribute12
126 ,p_bpa_attribute13 => p_bpa_attribute13
127 ,p_bpa_attribute14 => p_bpa_attribute14
128 ,p_bpa_attribute15 => p_bpa_attribute15
129 ,p_bpa_attribute16 => p_bpa_attribute16
130 ,p_bpa_attribute17 => p_bpa_attribute17
131 ,p_bpa_attribute18 => p_bpa_attribute18
132 ,p_bpa_attribute19 => p_bpa_attribute19
133 ,p_bpa_attribute20 => p_bpa_attribute20
134 ,p_bpa_attribute21 => p_bpa_attribute21
135 ,p_bpa_attribute22 => p_bpa_attribute22
136 ,p_bpa_attribute23 => p_bpa_attribute23
137 ,p_bpa_attribute24 => p_bpa_attribute24
138 ,p_bpa_attribute25 => p_bpa_attribute25
139 ,p_bpa_attribute26 => p_bpa_attribute26
140 ,p_bpa_attribute27 => p_bpa_attribute27
141 ,p_bpa_attribute28 => p_bpa_attribute28
142 ,p_bpa_attribute29 => p_bpa_attribute29
143 ,p_bpa_attribute30 => p_bpa_attribute30
144 );
145 --
146 exception
147 when hr_api.cannot_find_prog_unit then
148 hr_api.cannot_find_prog_unit_error
149 (p_module_name => 'CREATE_PROCESSED_ASSIGNMENT'
150 ,p_hook_type => 'BP'
151 );
152 end;
153 hr_utility.set_location(l_proc, 30);
154 --
155 -- Validation in addition to Row Handlers
156 --
157 chk_row_exists(p_assignment_id => p_assignment_id
158 ,p_payroll_run_id => p_payroll_run_id);
159 --
160 --
161 -- Process Logic
162 --
163 per_bpa_ins.ins
164 (p_effective_date => p_effective_date
165 ,p_payroll_run_id => p_payroll_run_id
166 ,p_bpa_attribute_category => p_bpa_attribute_category
167 ,p_bpa_attribute1 => p_bpa_attribute1
168 ,p_bpa_attribute2 => p_bpa_attribute2
169 ,p_bpa_attribute3 => p_bpa_attribute3
170 ,p_bpa_attribute4 => p_bpa_attribute4
171 ,p_bpa_attribute5 => p_bpa_attribute5
172 ,p_bpa_attribute6 => p_bpa_attribute6
173 ,p_bpa_attribute7 => p_bpa_attribute7
174 ,p_bpa_attribute8 => p_bpa_attribute8
175 ,p_bpa_attribute9 => p_bpa_attribute9
176 ,p_bpa_attribute10 => p_bpa_attribute10
177 ,p_bpa_attribute11 => p_bpa_attribute11
178 ,p_bpa_attribute12 => p_bpa_attribute12
179 ,p_bpa_attribute13 => p_bpa_attribute13
180 ,p_bpa_attribute14 => p_bpa_attribute14
181 ,p_bpa_attribute15 => p_bpa_attribute15
182 ,p_bpa_attribute16 => p_bpa_attribute16
183 ,p_bpa_attribute17 => p_bpa_attribute17
184 ,p_bpa_attribute18 => p_bpa_attribute18
185 ,p_bpa_attribute19 => p_bpa_attribute19
186 ,p_bpa_attribute20 => p_bpa_attribute20
187 ,p_bpa_attribute21 => p_bpa_attribute21
188 ,p_bpa_attribute22 => p_bpa_attribute22
189 ,p_bpa_attribute23 => p_bpa_attribute23
190 ,p_bpa_attribute24 => p_bpa_attribute24
191 ,p_bpa_attribute25 => p_bpa_attribute25
192 ,p_bpa_attribute26 => p_bpa_attribute26
193 ,p_bpa_attribute27 => p_bpa_attribute27
194 ,p_bpa_attribute28 => p_bpa_attribute28
195 ,p_bpa_attribute29 => p_bpa_attribute29
196 ,p_bpa_attribute30 => p_bpa_attribute30
197 ,p_assignment_id => p_assignment_id
198 ,p_processed_assignment_id => l_processed_assignment_id
199 ,p_object_version_number => l_processed_assignment_ovn
200 );
201 --
202 --
203 hr_utility.set_location(l_proc, 50);
204 --
205 -- Call After Process User Hook
206 --
207 begin
208 PER_BF_PROC_ASSIGNMENT_BK1.CREATE_PROCESSED_ASSIGNMENT_A
209 (p_effective_date => p_effective_date
210 ,p_assignment_id => p_assignment_id
211 ,p_payroll_run_id => p_payroll_run_id
212 ,p_bpa_attribute_category => p_bpa_attribute_category
213 ,p_bpa_attribute1 => p_bpa_attribute1
214 ,p_bpa_attribute2 => p_bpa_attribute2
215 ,p_bpa_attribute3 => p_bpa_attribute3
216 ,p_bpa_attribute4 => p_bpa_attribute4
217 ,p_bpa_attribute5 => p_bpa_attribute5
218 ,p_bpa_attribute6 => p_bpa_attribute6
219 ,p_bpa_attribute7 => p_bpa_attribute7
220 ,p_bpa_attribute8 => p_bpa_attribute8
221 ,p_bpa_attribute9 => p_bpa_attribute9
222 ,p_bpa_attribute10 => p_bpa_attribute10
223 ,p_bpa_attribute11 => p_bpa_attribute11
224 ,p_bpa_attribute12 => p_bpa_attribute12
225 ,p_bpa_attribute13 => p_bpa_attribute13
226 ,p_bpa_attribute14 => p_bpa_attribute14
227 ,p_bpa_attribute15 => p_bpa_attribute15
228 ,p_bpa_attribute16 => p_bpa_attribute16
229 ,p_bpa_attribute17 => p_bpa_attribute17
230 ,p_bpa_attribute18 => p_bpa_attribute18
231 ,p_bpa_attribute19 => p_bpa_attribute19
232 ,p_bpa_attribute20 => p_bpa_attribute20
233 ,p_bpa_attribute21 => p_bpa_attribute21
234 ,p_bpa_attribute22 => p_bpa_attribute22
235 ,p_bpa_attribute23 => p_bpa_attribute23
236 ,p_bpa_attribute24 => p_bpa_attribute24
237 ,p_bpa_attribute25 => p_bpa_attribute25
238 ,p_bpa_attribute26 => p_bpa_attribute26
239 ,p_bpa_attribute27 => p_bpa_attribute27
240 ,p_bpa_attribute28 => p_bpa_attribute28
241 ,p_bpa_attribute29 => p_bpa_attribute29
242 ,p_bpa_attribute30 => p_bpa_attribute30
243 ,p_processed_assignment_id => l_processed_assignment_id
244 ,p_processed_assignment_ovn => l_processed_assignment_ovn
245 );
246 exception
247 when hr_api.cannot_find_prog_unit then
248 hr_api.cannot_find_prog_unit_error
249 (p_module_name => 'CREATE_PROCESSED_ASSIGNMENT'
250 ,p_hook_type => 'AP'
251 );
252 end;
253 hr_utility.set_location(l_proc, 60);
254 --
255 -- When in validation only mode raise the Validate_Enabled exception
256 --
257 if p_validate then
258 raise hr_api.validate_enabled;
259 end if;
260 --
261 -- Set all output arguments
262 --
263 p_processed_assignment_id := l_processed_assignment_id;
264 p_processed_assignment_ovn:= l_processed_assignment_ovn;
265 --
266 hr_utility.set_location(' Leaving:'||l_proc, 70);
267 exception
268 when hr_api.validate_enabled then
269 --
270 -- As the Validate_Enabled exception has been raised
271 -- we must rollback to the savepoint
272 --
273 rollback to create_processed_assignment;
274 --
275 -- Only set output warning arguments
276 -- (Any key or derived arguments must be set to null
277 -- when validation only mode is being used.)
278 --
279 p_processed_assignment_id := null;
280 p_processed_assignment_ovn:= null;
281 --
282 hr_utility.set_location(' Leaving:'||l_proc, 80);
283 when others then
284 --
285 -- A validation or unexpected error has occured
286 --
287 rollback to create_processed_assignment;
288 --set out variables
289 p_processed_assignment_id := null;
290 p_processed_assignment_ovn:= null;
291 hr_utility.set_location(' Leaving:'||l_proc, 90);
292 raise;
293 end CREATE_PROCESSED_ASSIGNMENT;
294 --
295 -- ----------------------------------------------------------------------------
296 -- |--------------------< update_processed_assignment >-----------------------|
297 -- ----------------------------------------------------------------------------
298 --
299 procedure update_processed_assignment
300 (p_validate in boolean default false
301 ,p_effective_date in date
302 ,p_processed_assignment_id in number
303 ,p_bpa_attribute_category in varchar2 default hr_api.g_varchar2
304 ,p_bpa_attribute1 in varchar2 default hr_api.g_varchar2
305 ,p_bpa_attribute2 in varchar2 default hr_api.g_varchar2
306 ,p_bpa_attribute3 in varchar2 default hr_api.g_varchar2
307 ,p_bpa_attribute4 in varchar2 default hr_api.g_varchar2
308 ,p_bpa_attribute5 in varchar2 default hr_api.g_varchar2
309 ,p_bpa_attribute6 in varchar2 default hr_api.g_varchar2
310 ,p_bpa_attribute7 in varchar2 default hr_api.g_varchar2
311 ,p_bpa_attribute8 in varchar2 default hr_api.g_varchar2
312 ,p_bpa_attribute9 in varchar2 default hr_api.g_varchar2
313 ,p_bpa_attribute10 in varchar2 default hr_api.g_varchar2
317 ,p_bpa_attribute14 in varchar2 default hr_api.g_varchar2
314 ,p_bpa_attribute11 in varchar2 default hr_api.g_varchar2
315 ,p_bpa_attribute12 in varchar2 default hr_api.g_varchar2
316 ,p_bpa_attribute13 in varchar2 default hr_api.g_varchar2
318 ,p_bpa_attribute15 in varchar2 default hr_api.g_varchar2
319 ,p_bpa_attribute16 in varchar2 default hr_api.g_varchar2
320 ,p_bpa_attribute17 in varchar2 default hr_api.g_varchar2
321 ,p_bpa_attribute18 in varchar2 default hr_api.g_varchar2
322 ,p_bpa_attribute19 in varchar2 default hr_api.g_varchar2
323 ,p_bpa_attribute20 in varchar2 default hr_api.g_varchar2
324 ,p_bpa_attribute21 in varchar2 default hr_api.g_varchar2
325 ,p_bpa_attribute22 in varchar2 default hr_api.g_varchar2
326 ,p_bpa_attribute23 in varchar2 default hr_api.g_varchar2
327 ,p_bpa_attribute24 in varchar2 default hr_api.g_varchar2
328 ,p_bpa_attribute25 in varchar2 default hr_api.g_varchar2
329 ,p_bpa_attribute26 in varchar2 default hr_api.g_varchar2
330 ,p_bpa_attribute27 in varchar2 default hr_api.g_varchar2
331 ,p_bpa_attribute28 in varchar2 default hr_api.g_varchar2
332 ,p_bpa_attribute29 in varchar2 default hr_api.g_varchar2
333 ,p_bpa_attribute30 in varchar2 default hr_api.g_varchar2
334 ,p_processed_assignment_ovn in out nocopy number
335 ) is
336 --
337 -- Declare cursors and local variables
338 --
339 l_processed_assignment_id NUMBER;
340 --
341 l_processed_assignment_ovn
342 PER_BF_PROCESSED_ASSIGNMENTS.object_version_number%TYPE;
343 --
344 l_proc varchar2(72) := g_package||'update_processed_assignment';
345 begin
346 hr_utility.set_location('Entering:'|| l_proc, 10);
347 --
348 -- Issue a savepoint
349 --
350 savepoint update_processed_assignment;
351 hr_utility.set_location(l_proc, 20);
352 --
353 -- Truncate the time portion from all IN date parameters
354 --
355 --
356 --
357 -- Call Before Process User Hook
358 --
359 begin
360 PER_BF_PROC_ASSIGNMENT_BK2.UPDATE_PROCESSED_ASSIGNMENT_B
361 (p_effective_date => p_effective_date
362 ,p_bpa_attribute_category => p_bpa_attribute_category
363 ,p_bpa_attribute1 => p_bpa_attribute1
364 ,p_bpa_attribute2 => p_bpa_attribute2
365 ,p_bpa_attribute3 => p_bpa_attribute3
366 ,p_bpa_attribute4 => p_bpa_attribute4
367 ,p_bpa_attribute5 => p_bpa_attribute5
368 ,p_bpa_attribute6 => p_bpa_attribute6
369 ,p_bpa_attribute7 => p_bpa_attribute7
370 ,p_bpa_attribute8 => p_bpa_attribute8
371 ,p_bpa_attribute9 => p_bpa_attribute9
372 ,p_bpa_attribute10 => p_bpa_attribute10
373 ,p_bpa_attribute11 => p_bpa_attribute11
374 ,p_bpa_attribute12 => p_bpa_attribute12
375 ,p_bpa_attribute13 => p_bpa_attribute13
376 ,p_bpa_attribute14 => p_bpa_attribute14
377 ,p_bpa_attribute15 => p_bpa_attribute15
378 ,p_bpa_attribute16 => p_bpa_attribute16
379 ,p_bpa_attribute17 => p_bpa_attribute17
380 ,p_bpa_attribute18 => p_bpa_attribute18
381 ,p_bpa_attribute19 => p_bpa_attribute19
382 ,p_bpa_attribute20 => p_bpa_attribute20
383 ,p_bpa_attribute21 => p_bpa_attribute21
384 ,p_bpa_attribute22 => p_bpa_attribute22
385 ,p_bpa_attribute23 => p_bpa_attribute23
386 ,p_bpa_attribute24 => p_bpa_attribute24
387 ,p_bpa_attribute25 => p_bpa_attribute25
388 ,p_bpa_attribute26 => p_bpa_attribute26
389 ,p_bpa_attribute27 => p_bpa_attribute27
390 ,p_bpa_attribute28 => p_bpa_attribute28
391 ,p_bpa_attribute29 => p_bpa_attribute29
392 ,p_bpa_attribute30 => p_bpa_attribute30
393 ,p_processed_assignment_id => p_processed_assignment_id
394 ,p_processed_assignment_ovn => p_processed_assignment_ovn
395 );
396 --
397 exception
398 when hr_api.cannot_find_prog_unit then
399 hr_api.cannot_find_prog_unit_error
400 (p_module_name => 'UPDATE_PROCESSED_ASSIGNMENT'
401 ,p_hook_type => 'BP'
402 );
403 end;
404 hr_utility.set_location(l_proc, 30);
405 --
406 -- Process Logic
407 --
408 l_processed_assignment_ovn := p_processed_assignment_ovn;
409 --
410 per_bpa_upd.upd
411 (p_effective_date => p_effective_date
412 ,p_processed_assignment_id => p_processed_assignment_id
413 ,p_bpa_attribute_category => p_bpa_attribute_category
414 ,p_bpa_attribute1 => p_bpa_attribute1
415 ,p_bpa_attribute2 => p_bpa_attribute2
416 ,p_bpa_attribute3 => p_bpa_attribute3
420 ,p_bpa_attribute7 => p_bpa_attribute7
417 ,p_bpa_attribute4 => p_bpa_attribute4
418 ,p_bpa_attribute5 => p_bpa_attribute5
419 ,p_bpa_attribute6 => p_bpa_attribute6
421 ,p_bpa_attribute8 => p_bpa_attribute8
422 ,p_bpa_attribute9 => p_bpa_attribute9
423 ,p_bpa_attribute10 => p_bpa_attribute10
424 ,p_bpa_attribute11 => p_bpa_attribute11
425 ,p_bpa_attribute12 => p_bpa_attribute12
426 ,p_bpa_attribute13 => p_bpa_attribute13
427 ,p_bpa_attribute14 => p_bpa_attribute14
428 ,p_bpa_attribute15 => p_bpa_attribute15
429 ,p_bpa_attribute16 => p_bpa_attribute16
430 ,p_bpa_attribute17 => p_bpa_attribute17
431 ,p_bpa_attribute18 => p_bpa_attribute18
432 ,p_bpa_attribute19 => p_bpa_attribute19
433 ,p_bpa_attribute20 => p_bpa_attribute20
434 ,p_bpa_attribute21 => p_bpa_attribute21
435 ,p_bpa_attribute22 => p_bpa_attribute22
436 ,p_bpa_attribute23 => p_bpa_attribute23
437 ,p_bpa_attribute24 => p_bpa_attribute24
438 ,p_bpa_attribute25 => p_bpa_attribute25
439 ,p_bpa_attribute26 => p_bpa_attribute26
440 ,p_bpa_attribute27 => p_bpa_attribute27
441 ,p_bpa_attribute28 => p_bpa_attribute28
442 ,p_bpa_attribute29 => p_bpa_attribute29
443 ,p_bpa_attribute30 => p_bpa_attribute30
444 ,p_object_version_number => l_processed_assignment_ovn
445 );
446 --
447 --
448 hr_utility.set_location(l_proc, 50);
449 --
450 -- Call After Process User Hook
451 --
452 begin
453 PER_BF_PROC_ASSIGNMENT_BK2.UPDATE_PROCESSED_ASSIGNMENT_A
454 (p_effective_date => p_effective_date
455 ,p_processed_assignment_id => p_processed_assignment_id
456 ,p_bpa_attribute_category => p_bpa_attribute_category
457 ,p_bpa_attribute1 => p_bpa_attribute1
458 ,p_bpa_attribute2 => p_bpa_attribute2
459 ,p_bpa_attribute3 => p_bpa_attribute3
460 ,p_bpa_attribute4 => p_bpa_attribute4
461 ,p_bpa_attribute5 => p_bpa_attribute5
462 ,p_bpa_attribute6 => p_bpa_attribute6
463 ,p_bpa_attribute7 => p_bpa_attribute7
464 ,p_bpa_attribute8 => p_bpa_attribute8
465 ,p_bpa_attribute9 => p_bpa_attribute9
466 ,p_bpa_attribute10 => p_bpa_attribute10
467 ,p_bpa_attribute11 => p_bpa_attribute11
468 ,p_bpa_attribute12 => p_bpa_attribute12
469 ,p_bpa_attribute13 => p_bpa_attribute13
470 ,p_bpa_attribute14 => p_bpa_attribute14
471 ,p_bpa_attribute15 => p_bpa_attribute15
472 ,p_bpa_attribute16 => p_bpa_attribute16
473 ,p_bpa_attribute17 => p_bpa_attribute17
474 ,p_bpa_attribute18 => p_bpa_attribute18
475 ,p_bpa_attribute19 => p_bpa_attribute19
476 ,p_bpa_attribute20 => p_bpa_attribute20
477 ,p_bpa_attribute21 => p_bpa_attribute21
478 ,p_bpa_attribute22 => p_bpa_attribute22
479 ,p_bpa_attribute23 => p_bpa_attribute23
480 ,p_bpa_attribute24 => p_bpa_attribute24
481 ,p_bpa_attribute25 => p_bpa_attribute25
482 ,p_bpa_attribute26 => p_bpa_attribute26
483 ,p_bpa_attribute27 => p_bpa_attribute27
484 ,p_bpa_attribute28 => p_bpa_attribute28
485 ,p_bpa_attribute29 => p_bpa_attribute29
486 ,p_bpa_attribute30 => p_bpa_attribute30
487 ,p_processed_assignment_ovn => l_processed_assignment_ovn
488 );
489 exception
490 when hr_api.cannot_find_prog_unit then
491 hr_api.cannot_find_prog_unit_error
492 (p_module_name => 'UPDATE_PROCESSED_ASSIGNMENT'
493 ,p_hook_type => 'AP'
494 );
495 end;
496 hr_utility.set_location(l_proc, 60);
497 --
498 -- When in validation only mode raise the Validate_Enabled exception
499 --
500 if p_validate then
501 raise hr_api.validate_enabled;
502 end if;
503 --
504 -- Set all output arguments
505 --
506 p_processed_assignment_ovn := l_processed_assignment_ovn;
507 --
508 hr_utility.set_location(' Leaving:'||l_proc, 70);
509 exception
510 when hr_api.validate_enabled then
511 --
512 -- As the Validate_Enabled exception has been raised
513 -- we must rollback to the savepoint
514 --
515 rollback to update_processed_assignment;
516 --
517 -- Only set output warning arguments
518 -- (Any key or derived arguments must be set to null
519 -- when validation only mode is being used.)
520 --
521 p_processed_assignment_ovn := null;
522 --
523 hr_utility.set_location(' Leaving:'||l_proc, 80);
524 when others then
525 --
526 -- A validation or unexpected error has occured
527 --
528 rollback to update_processed_assignment;
532 raise;
529 --set out variables
530 p_processed_assignment_ovn := null;
531 hr_utility.set_location(' Leaving:'||l_proc, 90);
533 end UPDATE_PROCESSED_ASSIGNMENT;
534 --
535 -- ----------------------------------------------------------------------------
536 -- |-------------------< delete_processed_assignment >------------------------|
537 -- ----------------------------------------------------------------------------
538 --
539 procedure delete_processed_assignment
540 (p_validate in boolean default false
541 ,p_processed_assignment_id in number
542 ,p_processed_assignment_ovn in number
543 ) is
544 --
545 -- Declare cursors and local variables
546 --
547 l_proc varchar2(72) := g_package||'delete_processed_assignment';
548 --
549 begin
550 hr_utility.set_location('Entering:'|| l_proc, 10);
551 --
552 -- Issue a savepoint
553 --
554 savepoint delete_processed_assignment;
555 hr_utility.set_location(l_proc, 20);
556 --
557 -- Truncate the time portion from all IN date parameters
558 --
559 --
560 -- Call Before Process User Hook
561 --
562 begin
563 PER_BF_PROC_ASSIGNMENT_BK3.DELETE_PROCESSED_ASSIGNMENT_B
564 (p_processed_assignment_id => p_processed_assignment_id
565 ,p_processed_assignment_ovn => p_processed_assignment_ovn
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 => 'DELETE_PROCESSED_ASSIGNMENT'
572 ,p_hook_type => 'BP'
573 );
574 end;
575 hr_utility.set_location(l_proc, 30);
576 --
577 -- Validation in addition to Row Handlers
578 --
579 --
580 hr_utility.set_location(l_proc, 40);
581 --
582 -- Process Logic
583 --
584 per_bpa_del.del
585 (p_processed_assignment_id => p_processed_assignment_id
586 ,p_object_version_number => p_processed_assignment_ovn
587 );
588 --
589 --
590 hr_utility.set_location(l_proc, 50);
591 --
592 -- Call After Process User Hook
593 --
594 begin
595 PER_BF_PROC_ASSIGNMENT_BK3.DELETE_PROCESSED_ASSIGNMENT_A
596 (
597 p_processed_assignment_id => p_processed_assignment_id
598 ,p_processed_assignment_ovn => p_processed_assignment_ovn
599 );
600 exception
601 when hr_api.cannot_find_prog_unit then
602 hr_api.cannot_find_prog_unit_error
603 (p_module_name => 'DELETE_PROCESSED_ASSIGNMENT'
604 ,p_hook_type => 'AP'
605 );
606 end;
607 hr_utility.set_location(l_proc, 60);
608 --
609 -- When in validation only mode raise the Validate_Enabled exception
610 --
611 if p_validate then
612 raise hr_api.validate_enabled;
613 end if;
614 --
615 -- Set all output arguments
616 --
617 hr_utility.set_location(' Leaving:'||l_proc, 70);
618 exception
619 when hr_api.validate_enabled then
620 --
621 -- As the Validate_Enabled exception has been raised
622 -- we must rollback to the savepoint
623 --
624 rollback to delete_processed_assignment;
625 --
626 -- Only set output warning arguments
627 -- (Any key or derived arguments must be set to null
628 -- when validation only mode is being used.)
629 --
630 hr_utility.set_location(' Leaving:'||l_proc, 80);
631 when others then
632 --
633 -- A validation or unexpected error has occured
634 --
635 rollback to delete_processed_assignment;
636 hr_utility.set_location(' Leaving:'||l_proc, 90);
637 raise;
638 end DELETE_PROCESSED_ASSIGNMENT;
639 --
640 end PER_BF_PROC_ASSIGNMENT_API;