[Home] [Help]
PACKAGE BODY: APPS.BEN_CPE_DEL
Source
1 Package Body ben_cpe_del as
2 /* $Header: becperhi.pkb 120.0 2005/05/28 01:12:31 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_cpe_del.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< delete_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml delete logic. The functions of
17 -- this procedure are as follows:
18 -- 1) To set and unset the g_api_dml status as required (as we are about to
19 -- perform dml).
20 -- 2) To delete the specified row from the schema using the primary key in
21 -- the predicates.
22 -- 3) To trap any constraint violations that may have occurred.
23 -- 4) To raise any other errors.
24 --
25 -- Prerequisites:
26 -- This is an internal private procedure which must be called from the del
27 -- procedure.
28 --
29 -- In Parameters:
30 -- A Pl/Sql record structre.
31 --
32 -- Post Success:
33 -- The specified row will be delete from the schema.
34 --
35 -- Post Failure:
36 -- On the delete dml failure it is important to note that we always reset the
37 -- g_api_dml status to false.
38 -- If a child integrity constraint violation is raised the
39 -- constraint_error procedure will be called.
40 -- If any other error is reported, the error will be raised after the
41 -- g_api_dml status is reset.
42 --
43 -- Developer Implementation Notes:
44 -- None.
45 --
46 -- Access Status:
47 -- Internal Row Handler Use Only.
48 --
49 -- {End Of Comments}
50 -- ----------------------------------------------------------------------------
51 Procedure delete_dml
52 (p_rec in ben_cpe_shd.g_rec_type
53 ) is
54 --
55 l_proc varchar2(72) := g_package||'delete_dml';
56 --
57 Begin
58 hr_utility.set_location('Entering:'||l_proc, 5);
59 --
60 ben_cpe_shd.g_api_dml := true; -- Set the api dml status
61 --
62 -- Delete the ben_copy_entity_results row.
63 --
64 delete from ben_copy_entity_results
65 where copy_entity_result_id = p_rec.copy_entity_result_id;
66 --
67 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
68 --
69 hr_utility.set_location(' Leaving:'||l_proc, 10);
70 --
71 Exception
72 When hr_api.child_integrity_violated then
73 -- Child integrity has been violated
74 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
75 ben_cpe_shd.constraint_error
76 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77 When Others Then
78 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
79 Raise;
80 End delete_dml;
81 --
82 -- ----------------------------------------------------------------------------
83 -- |------------------------------< pre_delete >------------------------------|
84 -- ----------------------------------------------------------------------------
85 -- {Start Of Comments}
86 --
87 -- Description:
88 -- This private procedure contains any processing which is required before
89 -- the delete dml.
90 --
91 -- Prerequisites:
92 -- This is an internal procedure which is called from the del procedure.
93 --
94 -- In Parameters:
95 -- A Pl/Sql record structre.
96 --
97 -- Post Success:
98 -- Processing continues.
99 --
100 -- Post Failure:
101 -- If an error has occurred, an error message and exception will be raised
102 -- but not handled.
103 --
104 -- Developer Implementation Notes:
105 -- Any pre-processing required before the delete dml is issued should be
106 -- coded within this procedure. It is important to note that any 3rd party
107 -- maintenance should be reviewed before placing in this procedure.
108 --
109 -- Access Status:
110 -- Internal Row Handler Use Only.
111 --
112 -- {End Of Comments}
113 -- ----------------------------------------------------------------------------
114 Procedure pre_delete(p_rec in ben_cpe_shd.g_rec_type) is
115 --
116 l_proc varchar2(72) := g_package||'pre_delete';
117 --
118 Begin
119 hr_utility.set_location('Entering:'||l_proc, 5);
120 --
121 hr_utility.set_location(' Leaving:'||l_proc, 10);
122 End pre_delete;
123 --
124 -- ----------------------------------------------------------------------------
125 -- |-----------------------------< post_delete >------------------------------|
126 -- ----------------------------------------------------------------------------
127 -- {Start Of Comments}
128 --
129 -- Description:
130 -- This private procedure contains any processing which is required after
131 -- the delete dml.
132 --
133 -- Prerequistes:
134 -- This is an internal procedure which is called from the del procedure.
135 --
136 -- In Parameters:
137 -- A Pl/Sql record structure.
138 --
139 -- Post Success:
140 -- Processing continues.
141 --
142 -- Post Failure:
143 -- If an error has occurred, an error message and exception will be raised
144 -- but not handled.
145 --
146 -- Developer Implementation Notes:
147 -- Any post-processing required after the delete dml is issued should be
148 -- coded within this procedure. It is important to note that any 3rd party
149 -- maintenance should be reviewed before placing in this procedure.
150 --
151 -- Access Status:
152 -- Internal Row Handler Use Only.
153 --
154 -- {End Of Comments}
155 -- -----------------------------------------------------------------------------
156 Procedure post_delete(p_rec in ben_cpe_shd.g_rec_type) is
157 --
158 l_proc varchar2(72) := g_package||'post_delete';
159 --
160 Begin
161 hr_utility.set_location('Entering:'||l_proc, 5);
162 begin
163 --
164 ben_cpe_rkd.after_delete
165 (p_copy_entity_result_id
166 => p_rec.copy_entity_result_id
167 ,p_copy_entity_txn_id_o
168 => ben_cpe_shd.g_old_rec.copy_entity_txn_id
169 ,p_src_copy_entity_result_id_o
170 => ben_cpe_shd.g_old_rec.src_copy_entity_result_id
171 ,p_result_type_cd_o
172 => ben_cpe_shd.g_old_rec.result_type_cd
173 ,p_number_of_copies_o
174 => ben_cpe_shd.g_old_rec.number_of_copies
175 ,p_mirror_entity_result_id_o
176 => ben_cpe_shd.g_old_rec.mirror_entity_result_id
177 ,p_mirror_src_entity_result_i_o
178 => ben_cpe_shd.g_old_rec.mirror_src_entity_result_id
179 ,p_parent_entity_result_id_o
180 => ben_cpe_shd.g_old_rec.parent_entity_result_id
181 ,p_pd_mr_src_entity_result_id_o
182 => ben_cpe_shd.g_old_rec.pd_mirror_src_entity_result_id
183 ,p_pd_parent_entity_result_id_o
184 => ben_cpe_shd.g_old_rec.pd_parent_entity_result_id
185 ,p_gs_mr_src_entity_result_id_o
186 => ben_cpe_shd.g_old_rec.gs_mirror_src_entity_result_id
187 ,p_gs_parent_entity_result_id_o
188 => ben_cpe_shd.g_old_rec.gs_parent_entity_result_id
189 ,p_table_name_o
190 => ben_cpe_shd.g_old_rec.table_name
191 ,p_table_alias_o
192 => ben_cpe_shd.g_old_rec.table_alias
193 ,p_table_route_id_o
194 => ben_cpe_shd.g_old_rec.table_route_id
195 ,p_status_o
196 => ben_cpe_shd.g_old_rec.status
197 ,p_dml_operation_o
198 => ben_cpe_shd.g_old_rec.dml_operation
199 ,p_information_category_o
200 => ben_cpe_shd.g_old_rec.information_category
201 ,p_information1_o
202 => ben_cpe_shd.g_old_rec.information1
203 ,p_information2_o
204 => ben_cpe_shd.g_old_rec.information2
205 ,p_information3_o
206 => ben_cpe_shd.g_old_rec.information3
207 ,p_information4_o
208 => ben_cpe_shd.g_old_rec.information4
209 ,p_information5_o
210 => ben_cpe_shd.g_old_rec.information5
211 ,p_information6_o
212 => ben_cpe_shd.g_old_rec.information6
213 ,p_information7_o
214 => ben_cpe_shd.g_old_rec.information7
215 ,p_information8_o
216 => ben_cpe_shd.g_old_rec.information8
217 ,p_information9_o
218 => ben_cpe_shd.g_old_rec.information9
219 ,p_information10_o
220 => ben_cpe_shd.g_old_rec.information10
221 ,p_information11_o
222 => ben_cpe_shd.g_old_rec.information11
223 ,p_information12_o
224 => ben_cpe_shd.g_old_rec.information12
225 ,p_information13_o
226 => ben_cpe_shd.g_old_rec.information13
227 ,p_information14_o
228 => ben_cpe_shd.g_old_rec.information14
229 ,p_information15_o
230 => ben_cpe_shd.g_old_rec.information15
231 ,p_information16_o
232 => ben_cpe_shd.g_old_rec.information16
233 ,p_information17_o
234 => ben_cpe_shd.g_old_rec.information17
235 ,p_information18_o
236 => ben_cpe_shd.g_old_rec.information18
237 ,p_information19_o
238 => ben_cpe_shd.g_old_rec.information19
239 ,p_information20_o
240 => ben_cpe_shd.g_old_rec.information20
241 ,p_information21_o
242 => ben_cpe_shd.g_old_rec.information21
243 ,p_information22_o
244 => ben_cpe_shd.g_old_rec.information22
245 ,p_information23_o
246 => ben_cpe_shd.g_old_rec.information23
247 ,p_information24_o
248 => ben_cpe_shd.g_old_rec.information24
249 ,p_information25_o
250 => ben_cpe_shd.g_old_rec.information25
251 ,p_information26_o
252 => ben_cpe_shd.g_old_rec.information26
253 ,p_information27_o
254 => ben_cpe_shd.g_old_rec.information27
255 ,p_information28_o
256 => ben_cpe_shd.g_old_rec.information28
257 ,p_information29_o
258 => ben_cpe_shd.g_old_rec.information29
259 ,p_information30_o
260 => ben_cpe_shd.g_old_rec.information30
261 ,p_information31_o
262 => ben_cpe_shd.g_old_rec.information31
263 ,p_information32_o
264 => ben_cpe_shd.g_old_rec.information32
265 ,p_information33_o
266 => ben_cpe_shd.g_old_rec.information33
267 ,p_information34_o
268 => ben_cpe_shd.g_old_rec.information34
269 ,p_information35_o
270 => ben_cpe_shd.g_old_rec.information35
271 ,p_information36_o
272 => ben_cpe_shd.g_old_rec.information36
273 ,p_information37_o
274 => ben_cpe_shd.g_old_rec.information37
275 ,p_information38_o
276 => ben_cpe_shd.g_old_rec.information38
277 ,p_information39_o
278 => ben_cpe_shd.g_old_rec.information39
279 ,p_information40_o
280 => ben_cpe_shd.g_old_rec.information40
281 ,p_information41_o
282 => ben_cpe_shd.g_old_rec.information41
283 ,p_information42_o
284 => ben_cpe_shd.g_old_rec.information42
285 ,p_information43_o
286 => ben_cpe_shd.g_old_rec.information43
287 ,p_information44_o
288 => ben_cpe_shd.g_old_rec.information44
289 ,p_information45_o
290 => ben_cpe_shd.g_old_rec.information45
291 ,p_information46_o
292 => ben_cpe_shd.g_old_rec.information46
293 ,p_information47_o
294 => ben_cpe_shd.g_old_rec.information47
295 ,p_information48_o
296 => ben_cpe_shd.g_old_rec.information48
297 ,p_information49_o
298 => ben_cpe_shd.g_old_rec.information49
299 ,p_information50_o
300 => ben_cpe_shd.g_old_rec.information50
301 ,p_information51_o
302 => ben_cpe_shd.g_old_rec.information51
303 ,p_information52_o
304 => ben_cpe_shd.g_old_rec.information52
305 ,p_information53_o
306 => ben_cpe_shd.g_old_rec.information53
307 ,p_information54_o
308 => ben_cpe_shd.g_old_rec.information54
309 ,p_information55_o
310 => ben_cpe_shd.g_old_rec.information55
311 ,p_information56_o
312 => ben_cpe_shd.g_old_rec.information56
313 ,p_information57_o
314 => ben_cpe_shd.g_old_rec.information57
315 ,p_information58_o
316 => ben_cpe_shd.g_old_rec.information58
317 ,p_information59_o
318 => ben_cpe_shd.g_old_rec.information59
319 ,p_information60_o
320 => ben_cpe_shd.g_old_rec.information60
321 ,p_information61_o
322 => ben_cpe_shd.g_old_rec.information61
323 ,p_information62_o
324 => ben_cpe_shd.g_old_rec.information62
325 ,p_information63_o
326 => ben_cpe_shd.g_old_rec.information63
327 ,p_information64_o
328 => ben_cpe_shd.g_old_rec.information64
329 ,p_information65_o
330 => ben_cpe_shd.g_old_rec.information65
331 ,p_information66_o
332 => ben_cpe_shd.g_old_rec.information66
333 ,p_information67_o
334 => ben_cpe_shd.g_old_rec.information67
335 ,p_information68_o
336 => ben_cpe_shd.g_old_rec.information68
337 ,p_information69_o
338 => ben_cpe_shd.g_old_rec.information69
339 ,p_information70_o
340 => ben_cpe_shd.g_old_rec.information70
341 ,p_information71_o
342 => ben_cpe_shd.g_old_rec.information71
343 ,p_information72_o
344 => ben_cpe_shd.g_old_rec.information72
345 ,p_information73_o
346 => ben_cpe_shd.g_old_rec.information73
347 ,p_information74_o
348 => ben_cpe_shd.g_old_rec.information74
349 ,p_information75_o
350 => ben_cpe_shd.g_old_rec.information75
351 ,p_information76_o
352 => ben_cpe_shd.g_old_rec.information76
353 ,p_information77_o
354 => ben_cpe_shd.g_old_rec.information77
355 ,p_information78_o
356 => ben_cpe_shd.g_old_rec.information78
357 ,p_information79_o
358 => ben_cpe_shd.g_old_rec.information79
359 ,p_information80_o
360 => ben_cpe_shd.g_old_rec.information80
361 ,p_information81_o
362 => ben_cpe_shd.g_old_rec.information81
363 ,p_information82_o
364 => ben_cpe_shd.g_old_rec.information82
365 ,p_information83_o
366 => ben_cpe_shd.g_old_rec.information83
367 ,p_information84_o
368 => ben_cpe_shd.g_old_rec.information84
369 ,p_information85_o
370 => ben_cpe_shd.g_old_rec.information85
371 ,p_information86_o
372 => ben_cpe_shd.g_old_rec.information86
373 ,p_information87_o
374 => ben_cpe_shd.g_old_rec.information87
375 ,p_information88_o
376 => ben_cpe_shd.g_old_rec.information88
377 ,p_information89_o
378 => ben_cpe_shd.g_old_rec.information89
379 ,p_information90_o
380 => ben_cpe_shd.g_old_rec.information90
384 => ben_cpe_shd.g_old_rec.information92
381 ,p_information91_o
382 => ben_cpe_shd.g_old_rec.information91
383 ,p_information92_o
385 ,p_information93_o
386 => ben_cpe_shd.g_old_rec.information93
387 ,p_information94_o
388 => ben_cpe_shd.g_old_rec.information94
389 ,p_information95_o
390 => ben_cpe_shd.g_old_rec.information95
391 ,p_information96_o
392 => ben_cpe_shd.g_old_rec.information96
393 ,p_information97_o
394 => ben_cpe_shd.g_old_rec.information97
395 ,p_information98_o
396 => ben_cpe_shd.g_old_rec.information98
397 ,p_information99_o
398 => ben_cpe_shd.g_old_rec.information99
399 ,p_information100_o
400 => ben_cpe_shd.g_old_rec.information100
401 ,p_information101_o
402 => ben_cpe_shd.g_old_rec.information101
403 ,p_information102_o
404 => ben_cpe_shd.g_old_rec.information102
405 ,p_information103_o
406 => ben_cpe_shd.g_old_rec.information103
407 ,p_information104_o
408 => ben_cpe_shd.g_old_rec.information104
409 ,p_information105_o
410 => ben_cpe_shd.g_old_rec.information105
411 ,p_information106_o
412 => ben_cpe_shd.g_old_rec.information106
413 ,p_information107_o
414 => ben_cpe_shd.g_old_rec.information107
415 ,p_information108_o
416 => ben_cpe_shd.g_old_rec.information108
417 ,p_information109_o
418 => ben_cpe_shd.g_old_rec.information109
419 ,p_information110_o
420 => ben_cpe_shd.g_old_rec.information110
421 ,p_information111_o
422 => ben_cpe_shd.g_old_rec.information111
423 ,p_information112_o
424 => ben_cpe_shd.g_old_rec.information112
425 ,p_information113_o
426 => ben_cpe_shd.g_old_rec.information113
427 ,p_information114_o
428 => ben_cpe_shd.g_old_rec.information114
429 ,p_information115_o
430 => ben_cpe_shd.g_old_rec.information115
431 ,p_information116_o
432 => ben_cpe_shd.g_old_rec.information116
433 ,p_information117_o
434 => ben_cpe_shd.g_old_rec.information117
435 ,p_information118_o
436 => ben_cpe_shd.g_old_rec.information118
437 ,p_information119_o
438 => ben_cpe_shd.g_old_rec.information119
439 ,p_information120_o
440 => ben_cpe_shd.g_old_rec.information120
441 ,p_information121_o
442 => ben_cpe_shd.g_old_rec.information121
443 ,p_information122_o
444 => ben_cpe_shd.g_old_rec.information122
445 ,p_information123_o
446 => ben_cpe_shd.g_old_rec.information123
447 ,p_information124_o
448 => ben_cpe_shd.g_old_rec.information124
449 ,p_information125_o
450 => ben_cpe_shd.g_old_rec.information125
451 ,p_information126_o
452 => ben_cpe_shd.g_old_rec.information126
453 ,p_information127_o
454 => ben_cpe_shd.g_old_rec.information127
455 ,p_information128_o
456 => ben_cpe_shd.g_old_rec.information128
457 ,p_information129_o
458 => ben_cpe_shd.g_old_rec.information129
459 ,p_information130_o
460 => ben_cpe_shd.g_old_rec.information130
461 ,p_information131_o
462 => ben_cpe_shd.g_old_rec.information131
463 ,p_information132_o
464 => ben_cpe_shd.g_old_rec.information132
465 ,p_information133_o
466 => ben_cpe_shd.g_old_rec.information133
467 ,p_information134_o
468 => ben_cpe_shd.g_old_rec.information134
469 ,p_information135_o
470 => ben_cpe_shd.g_old_rec.information135
471 ,p_information136_o
472 => ben_cpe_shd.g_old_rec.information136
473 ,p_information137_o
474 => ben_cpe_shd.g_old_rec.information137
475 ,p_information138_o
476 => ben_cpe_shd.g_old_rec.information138
477 ,p_information139_o
478 => ben_cpe_shd.g_old_rec.information139
479 ,p_information140_o
480 => ben_cpe_shd.g_old_rec.information140
481 ,p_information141_o
482 => ben_cpe_shd.g_old_rec.information141
483 ,p_information142_o
484 => ben_cpe_shd.g_old_rec.information142
485
486 /* Extra Reserved Columns
487 ,p_information143_o
488 => ben_cpe_shd.g_old_rec.information143
489 ,p_information144_o
490 => ben_cpe_shd.g_old_rec.information144
491 ,p_information145_o
492 => ben_cpe_shd.g_old_rec.information145
493 ,p_information146_o
494 => ben_cpe_shd.g_old_rec.information146
495 ,p_information147_o
496 => ben_cpe_shd.g_old_rec.information147
497 ,p_information148_o
498 => ben_cpe_shd.g_old_rec.information148
499 ,p_information149_o
500 => ben_cpe_shd.g_old_rec.information149
501 ,p_information150_o
502 => ben_cpe_shd.g_old_rec.information150
503 */
504
505 ,p_information151_o
506 => ben_cpe_shd.g_old_rec.information151
507 ,p_information152_o
508 => ben_cpe_shd.g_old_rec.information152
509 ,p_information153_o
510 => ben_cpe_shd.g_old_rec.information153
511
512 /* Extra Reserved Columns
513 ,p_information154_o
514 => ben_cpe_shd.g_old_rec.information154
515 ,p_information155_o
516 => ben_cpe_shd.g_old_rec.information155
517 ,p_information156_o
518 => ben_cpe_shd.g_old_rec.information156
522 => ben_cpe_shd.g_old_rec.information158
519 ,p_information157_o
520 => ben_cpe_shd.g_old_rec.information157
521 ,p_information158_o
523 ,p_information159_o
524 => ben_cpe_shd.g_old_rec.information159
525 */
526
527 ,p_information160_o
528 => ben_cpe_shd.g_old_rec.information160
529 ,p_information161_o
530 => ben_cpe_shd.g_old_rec.information161
531 ,p_information162_o
532 => ben_cpe_shd.g_old_rec.information162
533
534 /* Extra Reserved Columns
535 ,p_information163_o
536 => ben_cpe_shd.g_old_rec.information163
537 ,p_information164_o
538 => ben_cpe_shd.g_old_rec.information164
539 ,p_information165_o
540 => ben_cpe_shd.g_old_rec.information165
541 */
542
543 ,p_information166_o
544 => ben_cpe_shd.g_old_rec.information166
545 ,p_information167_o
546 => ben_cpe_shd.g_old_rec.information167
547 ,p_information168_o
548 => ben_cpe_shd.g_old_rec.information168
549 ,p_information169_o
550 => ben_cpe_shd.g_old_rec.information169
551 ,p_information170_o
552 => ben_cpe_shd.g_old_rec.information170
553
554 /* Extra Reserved Columns
555 ,p_information171_o
556 => ben_cpe_shd.g_old_rec.information171
557 ,p_information172_o
558 => ben_cpe_shd.g_old_rec.information172
559 */
560
561 ,p_information173_o
562 => ben_cpe_shd.g_old_rec.information173
563 ,p_information174_o
564 => ben_cpe_shd.g_old_rec.information174
565 ,p_information175_o
566 => ben_cpe_shd.g_old_rec.information175
567 ,p_information176_o
568 => ben_cpe_shd.g_old_rec.information176
569 ,p_information177_o
570 => ben_cpe_shd.g_old_rec.information177
571 ,p_information178_o
572 => ben_cpe_shd.g_old_rec.information178
573 ,p_information179_o
574 => ben_cpe_shd.g_old_rec.information179
575 ,p_information180_o
576 => ben_cpe_shd.g_old_rec.information180
577 ,p_information181_o
578 => ben_cpe_shd.g_old_rec.information181
579 ,p_information182_o
580 => ben_cpe_shd.g_old_rec.information182
581
582 /* Extra Reserved Columns
583 ,p_information183_o
584 => ben_cpe_shd.g_old_rec.information183
585 ,p_information184_o
586 => ben_cpe_shd.g_old_rec.information184
587 */
588
589 ,p_information185_o
590 => ben_cpe_shd.g_old_rec.information185
591 ,p_information186_o
592 => ben_cpe_shd.g_old_rec.information186
593 ,p_information187_o
594 => ben_cpe_shd.g_old_rec.information187
595 ,p_information188_o
596 => ben_cpe_shd.g_old_rec.information188
597
598 /* Extra Reserved Columns
599 ,p_information189_o
600 => ben_cpe_shd.g_old_rec.information189
601 */
602 ,p_information190_o
603 => ben_cpe_shd.g_old_rec.information190
604 ,p_information191_o
605 => ben_cpe_shd.g_old_rec.information191
606 ,p_information192_o
607 => ben_cpe_shd.g_old_rec.information192
608 ,p_information193_o
609 => ben_cpe_shd.g_old_rec.information193
610 ,p_information194_o
611 => ben_cpe_shd.g_old_rec.information194
612 ,p_information195_o
613 => ben_cpe_shd.g_old_rec.information195
614 ,p_information196_o
615 => ben_cpe_shd.g_old_rec.information196
616 ,p_information197_o
617 => ben_cpe_shd.g_old_rec.information197
618 ,p_information198_o
619 => ben_cpe_shd.g_old_rec.information198
620 ,p_information199_o
621 => ben_cpe_shd.g_old_rec.information199
622
623 /* Extra Reserved Columns
624 ,p_information200_o
625 => ben_cpe_shd.g_old_rec.information200
626 ,p_information201_o
627 => ben_cpe_shd.g_old_rec.information201
628 ,p_information202_o
629 => ben_cpe_shd.g_old_rec.information202
630 ,p_information203_o
631 => ben_cpe_shd.g_old_rec.information203
632 ,p_information204_o
633 => ben_cpe_shd.g_old_rec.information204
634 ,p_information205_o
635 => ben_cpe_shd.g_old_rec.information205
636 ,p_information206_o
637 => ben_cpe_shd.g_old_rec.information206
638 ,p_information207_o
639 => ben_cpe_shd.g_old_rec.information207
640 ,p_information208_o
641 => ben_cpe_shd.g_old_rec.information208
642 ,p_information209_o
643 => ben_cpe_shd.g_old_rec.information209
644 ,p_information210_o
645 => ben_cpe_shd.g_old_rec.information210
646 ,p_information211_o
647 => ben_cpe_shd.g_old_rec.information211
648 ,p_information212_o
649 => ben_cpe_shd.g_old_rec.information212
650 ,p_information213_o
651 => ben_cpe_shd.g_old_rec.information213
652 ,p_information214_o
653 => ben_cpe_shd.g_old_rec.information214
654 ,p_information215_o
655 => ben_cpe_shd.g_old_rec.information215
656 */
657
658 ,p_information216_o
659 => ben_cpe_shd.g_old_rec.information216
660 ,p_information217_o
661 => ben_cpe_shd.g_old_rec.information217
662 ,p_information218_o
666 ,p_information220_o
663 => ben_cpe_shd.g_old_rec.information218
664 ,p_information219_o
665 => ben_cpe_shd.g_old_rec.information219
667 => ben_cpe_shd.g_old_rec.information220
668
669 ,p_information221_o
670 => ben_cpe_shd.g_old_rec.information221
671 ,p_information222_o
672 => ben_cpe_shd.g_old_rec.information222
673 ,p_information223_o
674 => ben_cpe_shd.g_old_rec.information223
675 ,p_information224_o
676 => ben_cpe_shd.g_old_rec.information224
677 ,p_information225_o
678 => ben_cpe_shd.g_old_rec.information225
679 ,p_information226_o
680 => ben_cpe_shd.g_old_rec.information226
681 ,p_information227_o
682 => ben_cpe_shd.g_old_rec.information227
683 ,p_information228_o
684 => ben_cpe_shd.g_old_rec.information228
685 ,p_information229_o
686 => ben_cpe_shd.g_old_rec.information229
687 ,p_information230_o
688 => ben_cpe_shd.g_old_rec.information230
689 ,p_information231_o
690 => ben_cpe_shd.g_old_rec.information231
691 ,p_information232_o
692 => ben_cpe_shd.g_old_rec.information232
693 ,p_information233_o
694 => ben_cpe_shd.g_old_rec.information233
695 ,p_information234_o
696 => ben_cpe_shd.g_old_rec.information234
697 ,p_information235_o
698 => ben_cpe_shd.g_old_rec.information235
699 ,p_information236_o
700 => ben_cpe_shd.g_old_rec.information236
701 ,p_information237_o
702 => ben_cpe_shd.g_old_rec.information237
703 ,p_information238_o
704 => ben_cpe_shd.g_old_rec.information238
705 ,p_information239_o
706 => ben_cpe_shd.g_old_rec.information239
707 ,p_information240_o
708 => ben_cpe_shd.g_old_rec.information240
709 ,p_information241_o
710 => ben_cpe_shd.g_old_rec.information241
711 ,p_information242_o
712 => ben_cpe_shd.g_old_rec.information242
713 ,p_information243_o
714 => ben_cpe_shd.g_old_rec.information243
715 ,p_information244_o
716 => ben_cpe_shd.g_old_rec.information244
717 ,p_information245_o
718 => ben_cpe_shd.g_old_rec.information245
719 ,p_information246_o
720 => ben_cpe_shd.g_old_rec.information246
721 ,p_information247_o
722 => ben_cpe_shd.g_old_rec.information247
723 ,p_information248_o
724 => ben_cpe_shd.g_old_rec.information248
725 ,p_information249_o
726 => ben_cpe_shd.g_old_rec.information249
727 ,p_information250_o
728 => ben_cpe_shd.g_old_rec.information250
729 ,p_information251_o
730 => ben_cpe_shd.g_old_rec.information251
731 ,p_information252_o
732 => ben_cpe_shd.g_old_rec.information252
733 ,p_information253_o
734 => ben_cpe_shd.g_old_rec.information253
735 ,p_information254_o
736 => ben_cpe_shd.g_old_rec.information254
737 ,p_information255_o
738 => ben_cpe_shd.g_old_rec.information255
739 ,p_information256_o
740 => ben_cpe_shd.g_old_rec.information256
741 ,p_information257_o
742 => ben_cpe_shd.g_old_rec.information257
743 ,p_information258_o
744 => ben_cpe_shd.g_old_rec.information258
745 ,p_information259_o
746 => ben_cpe_shd.g_old_rec.information259
747 ,p_information260_o
748 => ben_cpe_shd.g_old_rec.information260
749 ,p_information261_o
750 => ben_cpe_shd.g_old_rec.information261
751 ,p_information262_o
752 => ben_cpe_shd.g_old_rec.information262
753 ,p_information263_o
754 => ben_cpe_shd.g_old_rec.information263
755 ,p_information264_o
756 => ben_cpe_shd.g_old_rec.information264
757 ,p_information265_o
758 => ben_cpe_shd.g_old_rec.information265
759 ,p_information266_o
760 => ben_cpe_shd.g_old_rec.information266
761 ,p_information267_o
762 => ben_cpe_shd.g_old_rec.information267
763 ,p_information268_o
764 => ben_cpe_shd.g_old_rec.information268
765 ,p_information269_o
766 => ben_cpe_shd.g_old_rec.information269
767 ,p_information270_o
768 => ben_cpe_shd.g_old_rec.information270
769 ,p_information271_o
770 => ben_cpe_shd.g_old_rec.information271
771 ,p_information272_o
772 => ben_cpe_shd.g_old_rec.information272
773 ,p_information273_o
774 => ben_cpe_shd.g_old_rec.information273
775 ,p_information274_o
776 => ben_cpe_shd.g_old_rec.information274
777 ,p_information275_o
778 => ben_cpe_shd.g_old_rec.information275
779 ,p_information276_o
780 => ben_cpe_shd.g_old_rec.information276
781 ,p_information277_o
782 => ben_cpe_shd.g_old_rec.information277
783 ,p_information278_o
784 => ben_cpe_shd.g_old_rec.information278
785 ,p_information279_o
786 => ben_cpe_shd.g_old_rec.information279
787 ,p_information280_o
788 => ben_cpe_shd.g_old_rec.information280
789 ,p_information281_o
790 => ben_cpe_shd.g_old_rec.information281
791 ,p_information282_o
792 => ben_cpe_shd.g_old_rec.information282
793 ,p_information283_o
794 => ben_cpe_shd.g_old_rec.information283
798 => ben_cpe_shd.g_old_rec.information285
795 ,p_information284_o
796 => ben_cpe_shd.g_old_rec.information284
797 ,p_information285_o
799 ,p_information286_o
800 => ben_cpe_shd.g_old_rec.information286
801 ,p_information287_o
802 => ben_cpe_shd.g_old_rec.information287
803 ,p_information288_o
804 => ben_cpe_shd.g_old_rec.information288
805 ,p_information289_o
806 => ben_cpe_shd.g_old_rec.information289
807 ,p_information290_o
808 => ben_cpe_shd.g_old_rec.information290
809 ,p_information291_o
810 => ben_cpe_shd.g_old_rec.information291
811 ,p_information292_o
812 => ben_cpe_shd.g_old_rec.information292
813 ,p_information293_o
814 => ben_cpe_shd.g_old_rec.information293
815 ,p_information294_o
816 => ben_cpe_shd.g_old_rec.information294
817 ,p_information295_o
818 => ben_cpe_shd.g_old_rec.information295
819 ,p_information296_o
820 => ben_cpe_shd.g_old_rec.information296
821 ,p_information297_o
822 => ben_cpe_shd.g_old_rec.information297
823 ,p_information298_o
824 => ben_cpe_shd.g_old_rec.information298
825 ,p_information299_o
826 => ben_cpe_shd.g_old_rec.information299
827 ,p_information300_o
828 => ben_cpe_shd.g_old_rec.information300
829 ,p_information301_o
830 => ben_cpe_shd.g_old_rec.information301
831 ,p_information302_o
832 => ben_cpe_shd.g_old_rec.information302
833 ,p_information303_o
834 => ben_cpe_shd.g_old_rec.information303
835 ,p_information304_o
836 => ben_cpe_shd.g_old_rec.information304
837
838 /* Extra Reserved Columns
839 ,p_information305_o
840 => ben_cpe_shd.g_old_rec.information305
841 */
842 ,p_information306_o
843 => ben_cpe_shd.g_old_rec.information306
844 ,p_information307_o
845 => ben_cpe_shd.g_old_rec.information307
846 ,p_information308_o
847 => ben_cpe_shd.g_old_rec.information308
848 ,p_information309_o
849 => ben_cpe_shd.g_old_rec.information309
850 ,p_information310_o
851 => ben_cpe_shd.g_old_rec.information310
852 ,p_information311_o
853 => ben_cpe_shd.g_old_rec.information311
854 ,p_information312_o
855 => ben_cpe_shd.g_old_rec.information312
856 ,p_information313_o
857 => ben_cpe_shd.g_old_rec.information313
858 ,p_information314_o
859 => ben_cpe_shd.g_old_rec.information314
860 ,p_information315_o
861 => ben_cpe_shd.g_old_rec.information315
862 ,p_information316_o
863 => ben_cpe_shd.g_old_rec.information316
864 ,p_information317_o
865 => ben_cpe_shd.g_old_rec.information317
866 ,p_information318_o
867 => ben_cpe_shd.g_old_rec.information318
868 ,p_information319_o
869 => ben_cpe_shd.g_old_rec.information319
870 ,p_information320_o
871 => ben_cpe_shd.g_old_rec.information320
872
873 /* Extra Reserved Columns
874 ,p_information321_o
875 => ben_cpe_shd.g_old_rec.information321
876 ,p_information322_o
877 => ben_cpe_shd.g_old_rec.information322
878 */
879 ,p_information323_o
880 => ben_cpe_shd.g_old_rec.information323
881
882 ,p_datetrack_mode_o
883 => ben_cpe_shd.g_old_rec.datetrack_mode
884 ,p_object_version_number_o
885 => ben_cpe_shd.g_old_rec.object_version_number
886 );
887 --
888 exception
889 --
890 when hr_api.cannot_find_prog_unit then
891 --
892 hr_api.cannot_find_prog_unit_error
893 (p_module_name => 'BEN_COPY_ENTITY_RESULTS'
894 ,p_hook_type => 'AD');
895 --
896 end;
897 --
898 hr_utility.set_location(' Leaving:'||l_proc, 10);
899 End post_delete;
900 --
901 -- ----------------------------------------------------------------------------
902 -- |---------------------------------< del >----------------------------------|
903 -- ----------------------------------------------------------------------------
904 Procedure del
905 (p_rec in ben_cpe_shd.g_rec_type
906 ) is
907 --
908 l_proc varchar2(72) := g_package||'del';
909 --
910 Begin
911 hr_utility.set_location('Entering:'||l_proc, 5);
912 --
913 -- We must lock the row which we need to delete.
914 --
915 ben_cpe_shd.lck
916 (p_rec.copy_entity_result_id
917 ,p_rec.object_version_number
918 );
919 --
920 -- Call the supporting delete validate operation
921 --
922 ben_cpe_bus.delete_validate(p_rec);
923 --
924 -- Call to raise any errors on multi-message list
925 hr_multi_message.end_validation_set;
926 --
927 -- Call the supporting pre-delete operation
928 --
929 ben_cpe_del.pre_delete(p_rec);
930 --
931 -- Delete the row.
932 --
933 ben_cpe_del.delete_dml(p_rec);
934 --
935 -- Call the supporting post-delete operation
936 --
937 ben_cpe_del.post_delete(p_rec);
938 --
939 -- Call to raise any errors on multi-message list
943 --
940 hr_multi_message.end_validation_set;
941 --
942 End del;
944 -- ----------------------------------------------------------------------------
945 -- |---------------------------------< del >----------------------------------|
946 -- ----------------------------------------------------------------------------
947 Procedure del
948 (p_copy_entity_result_id in number
949 ,p_object_version_number in number
950 ) is
951 --
952 l_rec ben_cpe_shd.g_rec_type;
953 l_proc varchar2(72) := g_package||'del';
954 --
955 Begin
956 hr_utility.set_location('Entering:'||l_proc, 5);
957 --
958 -- As the delete procedure accepts a plsql record structure we do need to
959 -- convert the arguments into the record structure.
960 -- We don't need to call the supplied conversion argument routine as we
961 -- only need a few attributes.
962 --
963 l_rec.copy_entity_result_id := p_copy_entity_result_id;
964 l_rec.object_version_number := p_object_version_number;
965 --
966 -- Having converted the arguments into the ben_cpe_rec
967 -- plsql record structure we must call the corresponding entity
968 -- business process
969 --
970 ben_cpe_del.del(l_rec);
971 --
972 hr_utility.set_location(' Leaving:'||l_proc, 10);
973 End del;
974 --
975 end ben_cpe_del;