[Home] [Help]
PACKAGE BODY: APPS.BEN_CPE_UPD
Source
1 Package Body ben_cpe_upd 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_upd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< update_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This procedure controls the actual dml update logic. The processing of
17 -- this procedure is:
18 -- 1) Increment the object_version_number by 1 if the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 2) To set and unset the g_api_dml status as required (as we are about to
21 -- perform dml).
22 -- 3) To update the specified row in the schema using the primary key in
23 -- the predicates.
24 -- 4) To trap any constraint violations that may have occurred.
25 -- 5) To raise any other errors.
26 --
27 -- Prerequisites:
28 -- This is an internal private procedure which must be called from the upd
29 -- procedure.
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specified row will be updated in the schema.
36 --
37 -- Post Failure:
38 -- On the update dml failure it is important to note that we always reset the
39 -- g_api_dml status to false.
40 -- If a check, unique or parent integrity constraint violation is raised the
41 -- constraint_error procedure will be called.
45 -- Developer Implementation Notes:
42 -- If any other error is reported, the error will be raised after the
43 -- g_api_dml status is reset.
44 --
46 -- The update 'set' attribute list should be modified if any of your
47 -- attributes are not updateable.
48 --
49 -- Access Status:
50 -- Internal Row Handler Use Only.
51 --
52 -- {End Of Comments}
53 -- ----------------------------------------------------------------------------
54 Procedure update_dml
55 (p_rec in out nocopy ben_cpe_shd.g_rec_type
56 ) is
57 --
58 l_proc varchar2(72) := g_package||'update_dml';
59 --
60 Begin
61 hr_utility.set_location('Entering:'||l_proc, 5);
62 --
63 -- Increment the object version
64 p_rec.object_version_number := p_rec.object_version_number + 1;
65 --
66 ben_cpe_shd.g_api_dml := true; -- Set the api dml status
67 --
68 -- Update the ben_copy_entity_results Row
69 --
70 update ben_copy_entity_results
71 set
72 copy_entity_result_id = p_rec.copy_entity_result_id
73 ,copy_entity_txn_id = p_rec.copy_entity_txn_id
74 ,src_copy_entity_result_id = p_rec.src_copy_entity_result_id
75 ,result_type_cd = p_rec.result_type_cd
76 ,number_of_copies = p_rec.number_of_copies
77 ,mirror_entity_result_id = p_rec.mirror_entity_result_id
78 ,mirror_src_entity_result_id = p_rec.mirror_src_entity_result_id
79 ,parent_entity_result_id = p_rec.parent_entity_result_id
80 ,pd_mirror_src_entity_result_id = p_rec.pd_mirror_src_entity_result_id
81 ,pd_parent_entity_result_id = p_rec.pd_parent_entity_result_id
82 ,gs_mirror_src_entity_result_id = p_rec.gs_mirror_src_entity_result_id
83 ,gs_parent_entity_result_id = p_rec.gs_parent_entity_result_id
84 ,table_name = p_rec.table_name
85 ,table_alias = p_rec.table_alias
86 ,table_route_id = p_rec.table_route_id
87 ,status = p_rec.status
88 ,dml_operation = p_rec.dml_operation
89 ,information_category = p_rec.information_category
90 ,information1 = p_rec.information1
91 ,information2 = p_rec.information2
92 ,information3 = p_rec.information3
93 ,information4 = p_rec.information4
94 ,information5 = p_rec.information5
95 ,information6 = p_rec.information6
96 ,information7 = p_rec.information7
97 ,information8 = p_rec.information8
98 ,information9 = p_rec.information9
99 ,information10 = p_rec.information10
100 ,information11 = p_rec.information11
101 ,information12 = p_rec.information12
102 ,information13 = p_rec.information13
103 ,information14 = p_rec.information14
104 ,information15 = p_rec.information15
105 ,information16 = p_rec.information16
106 ,information17 = p_rec.information17
107 ,information18 = p_rec.information18
108 ,information19 = p_rec.information19
109 ,information20 = p_rec.information20
110 ,information21 = p_rec.information21
111 ,information22 = p_rec.information22
112 ,information23 = p_rec.information23
113 ,information24 = p_rec.information24
114 ,information25 = p_rec.information25
115 ,information26 = p_rec.information26
116 ,information27 = p_rec.information27
117 ,information28 = p_rec.information28
118 ,information29 = p_rec.information29
119 ,information30 = p_rec.information30
120 ,information31 = p_rec.information31
121 ,information32 = p_rec.information32
122 ,information33 = p_rec.information33
123 ,information34 = p_rec.information34
124 ,information35 = p_rec.information35
125 ,information36 = p_rec.information36
126 ,information37 = p_rec.information37
127 ,information38 = p_rec.information38
128 ,information39 = p_rec.information39
129 ,information40 = p_rec.information40
130 ,information41 = p_rec.information41
131 ,information42 = p_rec.information42
132 ,information43 = p_rec.information43
133 ,information44 = p_rec.information44
134 ,information45 = p_rec.information45
135 ,information46 = p_rec.information46
136 ,information47 = p_rec.information47
137 ,information48 = p_rec.information48
138 ,information49 = p_rec.information49
139 ,information50 = p_rec.information50
140 ,information51 = p_rec.information51
141 ,information52 = p_rec.information52
142 ,information53 = p_rec.information53
143 ,information54 = p_rec.information54
144 ,information55 = p_rec.information55
145 ,information56 = p_rec.information56
146 ,information57 = p_rec.information57
147 ,information58 = p_rec.information58
148 ,information59 = p_rec.information59
149 ,information60 = p_rec.information60
150 ,information61 = p_rec.information61
151 ,information62 = p_rec.information62
152 ,information63 = p_rec.information63
156 ,information67 = p_rec.information67
153 ,information64 = p_rec.information64
154 ,information65 = p_rec.information65
155 ,information66 = p_rec.information66
157 ,information68 = p_rec.information68
158 ,information69 = p_rec.information69
159 ,information70 = p_rec.information70
160 ,information71 = p_rec.information71
161 ,information72 = p_rec.information72
162 ,information73 = p_rec.information73
163 ,information74 = p_rec.information74
164 ,information75 = p_rec.information75
165 ,information76 = p_rec.information76
166 ,information77 = p_rec.information77
167 ,information78 = p_rec.information78
168 ,information79 = p_rec.information79
169 ,information80 = p_rec.information80
170 ,information81 = p_rec.information81
171 ,information82 = p_rec.information82
172 ,information83 = p_rec.information83
173 ,information84 = p_rec.information84
174 ,information85 = p_rec.information85
175 ,information86 = p_rec.information86
176 ,information87 = p_rec.information87
177 ,information88 = p_rec.information88
178 ,information89 = p_rec.information89
179 ,information90 = p_rec.information90
180 ,information91 = p_rec.information91
181 ,information92 = p_rec.information92
182 ,information93 = p_rec.information93
183 ,information94 = p_rec.information94
184 ,information95 = p_rec.information95
185 ,information96 = p_rec.information96
186 ,information97 = p_rec.information97
187 ,information98 = p_rec.information98
188 ,information99 = p_rec.information99
189 ,information100 = p_rec.information100
190 ,information101 = p_rec.information101
191 ,information102 = p_rec.information102
192 ,information103 = p_rec.information103
193 ,information104 = p_rec.information104
194 ,information105 = p_rec.information105
195 ,information106 = p_rec.information106
196 ,information107 = p_rec.information107
197 ,information108 = p_rec.information108
198 ,information109 = p_rec.information109
199 ,information110 = p_rec.information110
200 ,information111 = p_rec.information111
201 ,information112 = p_rec.information112
202 ,information113 = p_rec.information113
203 ,information114 = p_rec.information114
204 ,information115 = p_rec.information115
205 ,information116 = p_rec.information116
206 ,information117 = p_rec.information117
207 ,information118 = p_rec.information118
208 ,information119 = p_rec.information119
209 ,information120 = p_rec.information120
210 ,information121 = p_rec.information121
211 ,information122 = p_rec.information122
212 ,information123 = p_rec.information123
213 ,information124 = p_rec.information124
214 ,information125 = p_rec.information125
215 ,information126 = p_rec.information126
216 ,information127 = p_rec.information127
217 ,information128 = p_rec.information128
218 ,information129 = p_rec.information129
219 ,information130 = p_rec.information130
220 ,information131 = p_rec.information131
221 ,information132 = p_rec.information132
222 ,information133 = p_rec.information133
223 ,information134 = p_rec.information134
224 ,information135 = p_rec.information135
225 ,information136 = p_rec.information136
226 ,information137 = p_rec.information137
227 ,information138 = p_rec.information138
228 ,information139 = p_rec.information139
229 ,information140 = p_rec.information140
230 ,information141 = p_rec.information141
231 ,information142 = p_rec.information142
232
233 /* Extra Reserved Columns
234 ,information143 = p_rec.information143
235 ,information144 = p_rec.information144
236 ,information145 = p_rec.information145
237 ,information146 = p_rec.information146
238 ,information147 = p_rec.information147
239 ,information148 = p_rec.information148
240 ,information149 = p_rec.information149
241 ,information150 = p_rec.information150
242 */
243 ,information151 = p_rec.information151
244 ,information152 = p_rec.information152
245 ,information153 = p_rec.information153
246
247 /* Extra Reserved Columns
248 ,information154 = p_rec.information154
249 ,information155 = p_rec.information155
250 ,information156 = p_rec.information156
251 ,information157 = p_rec.information157
252 ,information158 = p_rec.information158
253 ,information159 = p_rec.information159
254 */
255 ,information160 = p_rec.information160
256 ,information161 = p_rec.information161
257 ,information162 = p_rec.information162
258
259 /* Extra Reserved Columns
260 ,information163 = p_rec.information163
261 ,information164 = p_rec.information164
262 ,information165 = p_rec.information165
263 */
264 ,information166 = p_rec.information166
265 ,information167 = p_rec.information167
266 ,information168 = p_rec.information168
267 ,information169 = p_rec.information169
268 ,information170 = p_rec.information170
269
270 /* Extra Reserved Columns
271 ,information171 = p_rec.information171
272 ,information172 = p_rec.information172
273 */
274 ,information173 = p_rec.information173
275 ,information174 = p_rec.information174
276 ,information175 = p_rec.information175
277 ,information176 = p_rec.information176
278 ,information177 = p_rec.information177
279 ,information178 = p_rec.information178
280 ,information179 = p_rec.information179
281 ,information180 = p_rec.information180
282 ,information181 = p_rec.information181
283 ,information182 = p_rec.information182
284
285 /* Extra Reserved Columns
286 ,information183 = p_rec.information183
287 ,information184 = p_rec.information184
288 */
289 ,information185 = p_rec.information185
290 ,information186 = p_rec.information186
291 ,information187 = p_rec.information187
292 ,information188 = p_rec.information188
293
294 /* Extra Reserved Columns
295 ,information189 = p_rec.information189
296 */
297 ,information190 = p_rec.information190
298 ,information191 = p_rec.information191
299 ,information192 = p_rec.information192
300 ,information193 = p_rec.information193
301 ,information194 = p_rec.information194
302 ,information195 = p_rec.information195
303 ,information196 = p_rec.information196
304 ,information197 = p_rec.information197
305 ,information198 = p_rec.information198
306 ,information199 = p_rec.information199
307
308 /* Extra Reserved Columns
309 ,information200 = p_rec.information200
310 ,information201 = p_rec.information201
311 ,information202 = p_rec.information202
312 ,information203 = p_rec.information203
313 ,information204 = p_rec.information204
314 ,information205 = p_rec.information205
315 ,information206 = p_rec.information206
316 ,information207 = p_rec.information207
317 ,information208 = p_rec.information208
318 ,information209 = p_rec.information209
319 ,information210 = p_rec.information210
320 ,information211 = p_rec.information211
321 ,information212 = p_rec.information212
322 ,information213 = p_rec.information213
323 ,information214 = p_rec.information214
324 ,information215 = p_rec.information215
325 */
326 ,information216 = p_rec.information216
327 ,information217 = p_rec.information217
328 ,information218 = p_rec.information218
329 ,information219 = p_rec.information219
330 ,information220 = p_rec.information220
331 ,information221 = p_rec.information221
332 ,information222 = p_rec.information222
333 ,information223 = p_rec.information223
334 ,information224 = p_rec.information224
335 ,information225 = p_rec.information225
336 ,information226 = p_rec.information226
337 ,information227 = p_rec.information227
338 ,information228 = p_rec.information228
339 ,information229 = p_rec.information229
340 ,information230 = p_rec.information230
341 ,information231 = p_rec.information231
342 ,information232 = p_rec.information232
343 ,information233 = p_rec.information233
344 ,information234 = p_rec.information234
345 ,information235 = p_rec.information235
346 ,information236 = p_rec.information236
347 ,information237 = p_rec.information237
348 ,information238 = p_rec.information238
349 ,information239 = p_rec.information239
350 ,information240 = p_rec.information240
354 ,information244 = p_rec.information244
351 ,information241 = p_rec.information241
352 ,information242 = p_rec.information242
353 ,information243 = p_rec.information243
355 ,information245 = p_rec.information245
356 ,information246 = p_rec.information246
357 ,information247 = p_rec.information247
358 ,information248 = p_rec.information248
359 ,information249 = p_rec.information249
360 ,information250 = p_rec.information250
361 ,information251 = p_rec.information251
362 ,information252 = p_rec.information252
363 ,information253 = p_rec.information253
364 ,information254 = p_rec.information254
365 ,information255 = p_rec.information255
366 ,information256 = p_rec.information256
367 ,information257 = p_rec.information257
368 ,information258 = p_rec.information258
369 ,information259 = p_rec.information259
370 ,information260 = p_rec.information260
371 ,information261 = p_rec.information261
372 ,information262 = p_rec.information262
373 ,information263 = p_rec.information263
374 ,information264 = p_rec.information264
375 ,information265 = p_rec.information265
376 ,information266 = p_rec.information266
377 ,information267 = p_rec.information267
378 ,information268 = p_rec.information268
379 ,information269 = p_rec.information269
380 ,information270 = p_rec.information270
381 ,information271 = p_rec.information271
382 ,information272 = p_rec.information272
383 ,information273 = p_rec.information273
384 ,information274 = p_rec.information274
385 ,information275 = p_rec.information275
386 ,information276 = p_rec.information276
387 ,information277 = p_rec.information277
388 ,information278 = p_rec.information278
389 ,information279 = p_rec.information279
390 ,information280 = p_rec.information280
391 ,information281 = p_rec.information281
392 ,information282 = p_rec.information282
393 ,information283 = p_rec.information283
394 ,information284 = p_rec.information284
395 ,information285 = p_rec.information285
396 ,information286 = p_rec.information286
397 ,information287 = p_rec.information287
398 ,information288 = p_rec.information288
399 ,information289 = p_rec.information289
400 ,information290 = p_rec.information290
401 ,information291 = p_rec.information291
402 ,information292 = p_rec.information292
403 ,information293 = p_rec.information293
404 ,information294 = p_rec.information294
405 ,information295 = p_rec.information295
406 ,information296 = p_rec.information296
407 ,information297 = p_rec.information297
408 ,information298 = p_rec.information298
409 ,information299 = p_rec.information299
410 ,information300 = p_rec.information300
411 ,information301 = p_rec.information301
412 ,information302 = p_rec.information302
413 ,information303 = p_rec.information303
414 ,information304 = p_rec.information304
415
416 /* Extra Reserved Columns
417 ,information305 = p_rec.information305
418 */
419 ,information306 = p_rec.information306
420 ,information307 = p_rec.information307
421 ,information308 = p_rec.information308
422 ,information309 = p_rec.information309
423 ,information310 = p_rec.information310
424 ,information311 = p_rec.information311
425 ,information312 = p_rec.information312
426 ,information313 = p_rec.information313
427 ,information314 = p_rec.information314
428 ,information315 = p_rec.information315
429 ,information316 = p_rec.information316
430 ,information317 = p_rec.information317
431 ,information318 = p_rec.information318
432 ,information319 = p_rec.information319
433 ,information320 = p_rec.information320
434
435 /* Extra Reserved Columns
436 ,information321 = p_rec.information321
437 ,information322 = p_rec.information322
438 */
439 ,information323 = p_rec.information323
440 ,datetrack_mode = p_rec.datetrack_mode
441 ,object_version_number = p_rec.object_version_number
442 where copy_entity_result_id = p_rec.copy_entity_result_id;
443 --
444 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
445 --
446 hr_utility.set_location(' Leaving:'||l_proc, 10);
447 --
448 Exception
449 When hr_api.check_integrity_violated Then
450 -- A check constraint has been violated
451 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
452 ben_cpe_shd.constraint_error
453 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
454 When hr_api.parent_integrity_violated Then
455 -- Parent integrity has been violated
459 When hr_api.unique_integrity_violated Then
456 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
457 ben_cpe_shd.constraint_error
458 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
460 -- Unique integrity has been violated
461 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
462 ben_cpe_shd.constraint_error
463 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
464 When Others Then
465 ben_cpe_shd.g_api_dml := false; -- Unset the api dml status
466 Raise;
467 End update_dml;
468 --
469 -- ----------------------------------------------------------------------------
470 -- |------------------------------< pre_update >------------------------------|
471 -- ----------------------------------------------------------------------------
472 -- {Start Of Comments}
473 --
474 -- Description:
475 -- This private procedure contains any processing which is required before
476 -- the update dml.
477 --
478 -- Prerequisites:
479 -- This is an internal procedure which is called from the upd procedure.
480 --
481 -- In Parameters:
482 -- A Pl/Sql record structure.
483 --
484 -- Post Success:
485 -- Processing continues.
486 --
487 -- Post Failure:
488 -- If an error has occurred, an error message and exception wil be raised
489 -- but not handled.
490 --
491 -- Developer Implementation Notes:
492 -- Any pre-processing required before the update dml is issued should be
493 -- coded within this procedure. It is important to note that any 3rd party
494 -- maintenance should be reviewed before placing in this procedure.
495 --
496 -- Access Status:
497 -- Internal Row Handler Use Only.
498 --
499 -- {End Of Comments}
500 -- ----------------------------------------------------------------------------
501 Procedure pre_update
502 (p_rec in ben_cpe_shd.g_rec_type
503 ) is
504 --
505 l_proc varchar2(72) := g_package||'pre_update';
506 --
507 Begin
508 hr_utility.set_location('Entering:'||l_proc, 5);
509 --
510 hr_utility.set_location(' Leaving:'||l_proc, 10);
511 End pre_update;
512 --
513 -- ----------------------------------------------------------------------------
514 -- |-----------------------------< post_update >------------------------------|
515 -- ----------------------------------------------------------------------------
516 -- {Start Of Comments}
517 --
518 -- Description:
519 -- This private procedure contains any processing which is required after
520 -- the update dml.
521 --
522 -- Prerequisites:
523 -- This is an internal procedure which is called from the upd procedure.
524 --
525 -- In Parameters:
526 -- A Pl/Sql record structure.
527 --
528 -- Post Success:
529 -- Processing continues.
530 --
531 -- Post Failure:
532 -- If an error has occurred, an error message and exception will be raised
533 -- but not handled.
534 --
535 -- Developer Implementation Notes:
536 -- Any post-processing required after the update dml is issued should be
537 -- coded within this procedure. It is important to note that any 3rd party
538 -- maintenance should be reviewed before placing in this procedure.
539 --
540 -- Access Status:
541 -- Internal Row Handler Use Only.
542 --
543 -- {End Of Comments}
544 -- ----------------------------------------------------------------------------
545 Procedure post_update
546 (p_effective_date in date
547 ,p_rec in ben_cpe_shd.g_rec_type
548 ) is
549 --
550 l_proc varchar2(72) := g_package||'post_update';
551 --
552 Begin
553 hr_utility.set_location('Entering:'||l_proc, 5);
554 begin
555 --
556 ben_cpe_rku.after_update
557 (p_effective_date => p_effective_date
558 ,p_copy_entity_result_id
559 => p_rec.copy_entity_result_id
560 ,p_copy_entity_txn_id
561 => p_rec.copy_entity_txn_id
562 ,p_src_copy_entity_result_id
563 => p_rec.src_copy_entity_result_id
564 ,p_result_type_cd
565 => p_rec.result_type_cd
566 ,p_number_of_copies
567 => p_rec.number_of_copies
568 ,p_mirror_entity_result_id
569 => p_rec.mirror_entity_result_id
570 ,p_mirror_src_entity_result_id
571 => p_rec.mirror_src_entity_result_id
572 ,p_parent_entity_result_id
573 => p_rec.parent_entity_result_id
574 ,p_pd_mr_src_entity_result_id
575 => p_rec.pd_mirror_src_entity_result_id
576 ,p_pd_parent_entity_result_id
577 => p_rec.pd_parent_entity_result_id
578 ,p_gs_mr_src_entity_result_id
579 => p_rec.gs_mirror_src_entity_result_id
580 ,p_gs_parent_entity_result_id
581 => p_rec.gs_parent_entity_result_id
582 ,p_table_name
583 => p_rec.table_name
584 ,p_table_alias
585 => p_rec.table_alias
586 ,p_table_route_id
587 => p_rec.table_route_id
588 ,p_status
589 => p_rec.status
590 ,p_dml_operation
591 => p_rec.dml_operation
592 ,p_information_category
593 => p_rec.information_category
594 ,p_information1
595 => p_rec.information1
596 ,p_information2
597 => p_rec.information2
598 ,p_information3
599 => p_rec.information3
600 ,p_information4
601 => p_rec.information4
602 ,p_information5
603 => p_rec.information5
604 ,p_information6
605 => p_rec.information6
606 ,p_information7
607 => p_rec.information7
608 ,p_information8
609 => p_rec.information8
610 ,p_information9
611 => p_rec.information9
612 ,p_information10
613 => p_rec.information10
617 => p_rec.information12
614 ,p_information11
615 => p_rec.information11
616 ,p_information12
618 ,p_information13
619 => p_rec.information13
620 ,p_information14
621 => p_rec.information14
622 ,p_information15
623 => p_rec.information15
624 ,p_information16
625 => p_rec.information16
626 ,p_information17
627 => p_rec.information17
628 ,p_information18
629 => p_rec.information18
630 ,p_information19
631 => p_rec.information19
632 ,p_information20
633 => p_rec.information20
634 ,p_information21
635 => p_rec.information21
636 ,p_information22
637 => p_rec.information22
638 ,p_information23
639 => p_rec.information23
640 ,p_information24
641 => p_rec.information24
642 ,p_information25
643 => p_rec.information25
644 ,p_information26
645 => p_rec.information26
646 ,p_information27
647 => p_rec.information27
648 ,p_information28
649 => p_rec.information28
650 ,p_information29
651 => p_rec.information29
652 ,p_information30
653 => p_rec.information30
654 ,p_information31
655 => p_rec.information31
656 ,p_information32
657 => p_rec.information32
658 ,p_information33
659 => p_rec.information33
660 ,p_information34
661 => p_rec.information34
662 ,p_information35
663 => p_rec.information35
664 ,p_information36
665 => p_rec.information36
666 ,p_information37
667 => p_rec.information37
668 ,p_information38
669 => p_rec.information38
670 ,p_information39
671 => p_rec.information39
672 ,p_information40
673 => p_rec.information40
674 ,p_information41
675 => p_rec.information41
676 ,p_information42
677 => p_rec.information42
678 ,p_information43
679 => p_rec.information43
680 ,p_information44
681 => p_rec.information44
682 ,p_information45
683 => p_rec.information45
684 ,p_information46
685 => p_rec.information46
686 ,p_information47
687 => p_rec.information47
688 ,p_information48
689 => p_rec.information48
690 ,p_information49
691 => p_rec.information49
692 ,p_information50
693 => p_rec.information50
694 ,p_information51
695 => p_rec.information51
696 ,p_information52
697 => p_rec.information52
698 ,p_information53
699 => p_rec.information53
700 ,p_information54
701 => p_rec.information54
702 ,p_information55
703 => p_rec.information55
704 ,p_information56
705 => p_rec.information56
706 ,p_information57
707 => p_rec.information57
708 ,p_information58
709 => p_rec.information58
710 ,p_information59
711 => p_rec.information59
712 ,p_information60
713 => p_rec.information60
714 ,p_information61
715 => p_rec.information61
716 ,p_information62
717 => p_rec.information62
718 ,p_information63
719 => p_rec.information63
720 ,p_information64
721 => p_rec.information64
722 ,p_information65
723 => p_rec.information65
724 ,p_information66
725 => p_rec.information66
726 ,p_information67
727 => p_rec.information67
728 ,p_information68
729 => p_rec.information68
730 ,p_information69
731 => p_rec.information69
732 ,p_information70
733 => p_rec.information70
734 ,p_information71
735 => p_rec.information71
736 ,p_information72
737 => p_rec.information72
738 ,p_information73
739 => p_rec.information73
740 ,p_information74
741 => p_rec.information74
742 ,p_information75
743 => p_rec.information75
744 ,p_information76
745 => p_rec.information76
746 ,p_information77
747 => p_rec.information77
748 ,p_information78
749 => p_rec.information78
750 ,p_information79
751 => p_rec.information79
752 ,p_information80
753 => p_rec.information80
754 ,p_information81
755 => p_rec.information81
756 ,p_information82
757 => p_rec.information82
758 ,p_information83
759 => p_rec.information83
760 ,p_information84
761 => p_rec.information84
762 ,p_information85
763 => p_rec.information85
764 ,p_information86
765 => p_rec.information86
766 ,p_information87
767 => p_rec.information87
768 ,p_information88
769 => p_rec.information88
770 ,p_information89
771 => p_rec.information89
772 ,p_information90
773 => p_rec.information90
774 ,p_information91
775 => p_rec.information91
776 ,p_information92
777 => p_rec.information92
778 ,p_information93
779 => p_rec.information93
780 ,p_information94
781 => p_rec.information94
782 ,p_information95
783 => p_rec.information95
784 ,p_information96
785 => p_rec.information96
786 ,p_information97
787 => p_rec.information97
788 ,p_information98
789 => p_rec.information98
790 ,p_information99
791 => p_rec.information99
792 ,p_information100
796 ,p_information102
793 => p_rec.information100
794 ,p_information101
795 => p_rec.information101
797 => p_rec.information102
798 ,p_information103
799 => p_rec.information103
800 ,p_information104
801 => p_rec.information104
802 ,p_information105
803 => p_rec.information105
804 ,p_information106
805 => p_rec.information106
806 ,p_information107
807 => p_rec.information107
808 ,p_information108
809 => p_rec.information108
810 ,p_information109
811 => p_rec.information109
812 ,p_information110
813 => p_rec.information110
814 ,p_information111
815 => p_rec.information111
816 ,p_information112
817 => p_rec.information112
818 ,p_information113
819 => p_rec.information113
820 ,p_information114
821 => p_rec.information114
822 ,p_information115
823 => p_rec.information115
824 ,p_information116
825 => p_rec.information116
826 ,p_information117
827 => p_rec.information117
828 ,p_information118
829 => p_rec.information118
830 ,p_information119
831 => p_rec.information119
832 ,p_information120
833 => p_rec.information120
834 ,p_information121
835 => p_rec.information121
836 ,p_information122
837 => p_rec.information122
838 ,p_information123
839 => p_rec.information123
840 ,p_information124
841 => p_rec.information124
842 ,p_information125
843 => p_rec.information125
844 ,p_information126
845 => p_rec.information126
846 ,p_information127
847 => p_rec.information127
848 ,p_information128
849 => p_rec.information128
850 ,p_information129
851 => p_rec.information129
852 ,p_information130
853 => p_rec.information130
854 ,p_information131
855 => p_rec.information131
856 ,p_information132
857 => p_rec.information132
858 ,p_information133
859 => p_rec.information133
860 ,p_information134
861 => p_rec.information134
862 ,p_information135
863 => p_rec.information135
864 ,p_information136
865 => p_rec.information136
866 ,p_information137
867 => p_rec.information137
868 ,p_information138
869 => p_rec.information138
870 ,p_information139
871 => p_rec.information139
872 ,p_information140
873 => p_rec.information140
874 ,p_information141
875 => p_rec.information141
876 ,p_information142
877 => p_rec.information142
878
879 /* Extra Reserved Columns
880 ,p_information143
881 => p_rec.information143
882 ,p_information144
883 => p_rec.information144
884 ,p_information145
885 => p_rec.information145
886 ,p_information146
887 => p_rec.information146
888 ,p_information147
889 => p_rec.information147
890 ,p_information148
891 => p_rec.information148
892 ,p_information149
893 => p_rec.information149
894 ,p_information150
895 => p_rec.information150
896 */
897 ,p_information151
898 => p_rec.information151
899 ,p_information152
900 => p_rec.information152
901 ,p_information153
902 => p_rec.information153
903
904 /* Extra Reserved Columns
905 ,p_information154
906 => p_rec.information154
907 ,p_information155
908 => p_rec.information155
909 ,p_information156
910 => p_rec.information156
911 ,p_information157
912 => p_rec.information157
913 ,p_information158
914 => p_rec.information158
915 ,p_information159
916 => p_rec.information159
917 */
918
919 ,p_information160
920 => p_rec.information160
921 ,p_information161
922 => p_rec.information161
923 ,p_information162
924 => p_rec.information162
925
926 /* Extra Reserved Columns
927 ,p_information163
928 => p_rec.information163
929 ,p_information164
930 => p_rec.information164
931 ,p_information165
932 => p_rec.information165
933 */
934
935 ,p_information166
936 => p_rec.information166
937 ,p_information167
938 => p_rec.information167
939 ,p_information168
940 => p_rec.information168
941 ,p_information169
942 => p_rec.information169
943 ,p_information170
944 => p_rec.information170
945
946 /* Extra Reserved Columns
947 ,p_information171
948 => p_rec.information171
949 ,p_information172
950 => p_rec.information172
951 */
952
953 ,p_information173
954 => p_rec.information173
955 ,p_information174
956 => p_rec.information174
957 ,p_information175
958 => p_rec.information175
959 ,p_information176
960 => p_rec.information176
961 ,p_information177
962 => p_rec.information177
963 ,p_information178
964 => p_rec.information178
965 ,p_information179
966 => p_rec.information179
967 ,p_information180
968 => p_rec.information180
969 ,p_information181
970 => p_rec.information181
974 /* Extra Reserved Columns
971 ,p_information182
972 => p_rec.information182
973
975 ,p_information183
976 => p_rec.information183
977 ,p_information184
978 => p_rec.information184
979 */
980
981 ,p_information185
982 => p_rec.information185
983 ,p_information186
984 => p_rec.information186
985 ,p_information187
986 => p_rec.information187
987 ,p_information188
988 => p_rec.information188
989
990 /* Extra Reserved Columns
991 ,p_information189
992 => p_rec.information189
993 */
994 ,p_information190
995 => p_rec.information190
996 ,p_information191
997 => p_rec.information191
998 ,p_information192
999 => p_rec.information192
1000 ,p_information193
1001 => p_rec.information193
1002 ,p_information194
1003 => p_rec.information194
1004 ,p_information195
1005 => p_rec.information195
1006 ,p_information196
1007 => p_rec.information196
1008 ,p_information197
1009 => p_rec.information197
1010 ,p_information198
1011 => p_rec.information198
1012 ,p_information199
1013 => p_rec.information199
1014
1015 /* Extra Reserved Columns
1016 ,p_information200
1017 => p_rec.information200
1018 ,p_information201
1019 => p_rec.information201
1020 ,p_information202
1021 => p_rec.information202
1022 ,p_information203
1023 => p_rec.information203
1024 ,p_information204
1025 => p_rec.information204
1026 ,p_information205
1027 => p_rec.information205
1028 ,p_information206
1029 => p_rec.information206
1030 ,p_information207
1031 => p_rec.information207
1032 ,p_information208
1033 => p_rec.information208
1034 ,p_information209
1035 => p_rec.information209
1036 ,p_information210
1037 => p_rec.information210
1038 ,p_information211
1039 => p_rec.information211
1040 ,p_information212
1041 => p_rec.information212
1042 ,p_information213
1043 => p_rec.information213
1044 ,p_information214
1045 => p_rec.information214
1046 ,p_information215
1047 => p_rec.information215
1048 */
1049
1050 ,p_information216
1051 => p_rec.information216
1052 ,p_information217
1053 => p_rec.information217
1054 ,p_information218
1055 => p_rec.information218
1056 ,p_information219
1057 => p_rec.information219
1058 ,p_information220
1059 => p_rec.information220
1060
1061 ,p_information221
1062 => p_rec.information221
1063 ,p_information222
1064 => p_rec.information222
1065 ,p_information223
1066 => p_rec.information223
1067 ,p_information224
1068 => p_rec.information224
1069 ,p_information225
1070 => p_rec.information225
1071 ,p_information226
1072 => p_rec.information226
1073 ,p_information227
1074 => p_rec.information227
1075 ,p_information228
1076 => p_rec.information228
1077 ,p_information229
1078 => p_rec.information229
1079 ,p_information230
1080 => p_rec.information230
1081 ,p_information231
1082 => p_rec.information231
1083 ,p_information232
1084 => p_rec.information232
1085 ,p_information233
1086 => p_rec.information233
1087 ,p_information234
1088 => p_rec.information234
1089 ,p_information235
1090 => p_rec.information235
1091 ,p_information236
1092 => p_rec.information236
1093 ,p_information237
1094 => p_rec.information237
1095 ,p_information238
1096 => p_rec.information238
1097 ,p_information239
1098 => p_rec.information239
1099 ,p_information240
1100 => p_rec.information240
1101 ,p_information241
1102 => p_rec.information241
1103 ,p_information242
1104 => p_rec.information242
1105 ,p_information243
1106 => p_rec.information243
1107 ,p_information244
1108 => p_rec.information244
1109 ,p_information245
1110 => p_rec.information245
1111 ,p_information246
1112 => p_rec.information246
1113 ,p_information247
1114 => p_rec.information247
1115 ,p_information248
1116 => p_rec.information248
1117 ,p_information249
1118 => p_rec.information249
1119 ,p_information250
1120 => p_rec.information250
1121 ,p_information251
1122 => p_rec.information251
1123 ,p_information252
1124 => p_rec.information252
1125 ,p_information253
1126 => p_rec.information253
1127 ,p_information254
1128 => p_rec.information254
1129 ,p_information255
1130 => p_rec.information255
1131 ,p_information256
1132 => p_rec.information256
1133 ,p_information257
1134 => p_rec.information257
1135 ,p_information258
1136 => p_rec.information258
1137 ,p_information259
1138 => p_rec.information259
1139 ,p_information260
1140 => p_rec.information260
1141 ,p_information261
1142 => p_rec.information261
1143 ,p_information262
1144 => p_rec.information262
1145 ,p_information263
1149 ,p_information265
1146 => p_rec.information263
1147 ,p_information264
1148 => p_rec.information264
1150 => p_rec.information265
1151 ,p_information266
1152 => p_rec.information266
1153 ,p_information267
1154 => p_rec.information267
1155 ,p_information268
1156 => p_rec.information268
1157 ,p_information269
1158 => p_rec.information269
1159 ,p_information270
1160 => p_rec.information270
1161 ,p_information271
1162 => p_rec.information271
1163 ,p_information272
1164 => p_rec.information272
1165 ,p_information273
1166 => p_rec.information273
1167 ,p_information274
1168 => p_rec.information274
1169 ,p_information275
1170 => p_rec.information275
1171 ,p_information276
1172 => p_rec.information276
1173 ,p_information277
1174 => p_rec.information277
1175 ,p_information278
1176 => p_rec.information278
1177 ,p_information279
1178 => p_rec.information279
1179 ,p_information280
1180 => p_rec.information280
1181 ,p_information281
1182 => p_rec.information281
1183 ,p_information282
1184 => p_rec.information282
1185 ,p_information283
1186 => p_rec.information283
1187 ,p_information284
1188 => p_rec.information284
1189 ,p_information285
1190 => p_rec.information285
1191 ,p_information286
1192 => p_rec.information286
1193 ,p_information287
1194 => p_rec.information287
1195 ,p_information288
1196 => p_rec.information288
1197 ,p_information289
1198 => p_rec.information289
1199 ,p_information290
1200 => p_rec.information290
1201 ,p_information291
1202 => p_rec.information291
1203 ,p_information292
1204 => p_rec.information292
1205 ,p_information293
1206 => p_rec.information293
1207 ,p_information294
1208 => p_rec.information294
1209 ,p_information295
1210 => p_rec.information295
1211 ,p_information296
1212 => p_rec.information296
1213 ,p_information297
1214 => p_rec.information297
1215 ,p_information298
1216 => p_rec.information298
1217 ,p_information299
1218 => p_rec.information299
1219 ,p_information300
1220 => p_rec.information300
1221 ,p_information301
1222 => p_rec.information301
1223 ,p_information302
1224 => p_rec.information302
1225 ,p_information303
1226 => p_rec.information303
1227 ,p_information304
1228 => p_rec.information304
1229
1230 /* Extra Reserved Columns
1231 ,p_information305
1232 => p_rec.information305
1233 */
1234 ,p_information306
1235 => p_rec.information306
1236 ,p_information307
1237 => p_rec.information307
1238 ,p_information308
1239 => p_rec.information308
1240 ,p_information309
1241 => p_rec.information309
1242 ,p_information310
1243 => p_rec.information310
1244 ,p_information311
1245 => p_rec.information311
1246 ,p_information312
1247 => p_rec.information312
1248 ,p_information313
1249 => p_rec.information313
1250 ,p_information314
1251 => p_rec.information314
1252 ,p_information315
1253 => p_rec.information315
1254 ,p_information316
1255 => p_rec.information316
1256 ,p_information317
1257 => p_rec.information317
1258 ,p_information318
1259 => p_rec.information318
1260 ,p_information319
1261 => p_rec.information319
1262 ,p_information320
1263 => p_rec.information320
1264
1265 /* Extra Reserved Columns
1266 ,p_information321
1267 => p_rec.information321
1268 ,p_information322
1269 => p_rec.information322
1270 */
1271
1272 ,p_information323
1273 => p_rec.information323
1274
1275 ,p_datetrack_mode
1276 => p_rec.datetrack_mode
1277 ,p_object_version_number
1278 => p_rec.object_version_number
1279 ,p_copy_entity_txn_id_o
1280 => ben_cpe_shd.g_old_rec.copy_entity_txn_id
1281 ,p_src_copy_entity_result_id_o
1282 => ben_cpe_shd.g_old_rec.src_copy_entity_result_id
1283 ,p_result_type_cd_o
1284 => ben_cpe_shd.g_old_rec.result_type_cd
1285 ,p_number_of_copies_o
1286 => ben_cpe_shd.g_old_rec.number_of_copies
1287 ,p_mirror_entity_result_id_o
1288 => ben_cpe_shd.g_old_rec.mirror_entity_result_id
1289 ,p_mirror_src_entity_result_i_o
1290 => ben_cpe_shd.g_old_rec.mirror_src_entity_result_id
1291 ,p_parent_entity_result_id_o
1292 => ben_cpe_shd.g_old_rec.parent_entity_result_id
1293 ,p_pd_mr_src_entity_result_id_o
1294 => ben_cpe_shd.g_old_rec.pd_mirror_src_entity_result_id
1295 ,p_pd_parent_entity_result_id_o
1296 => ben_cpe_shd.g_old_rec.pd_parent_entity_result_id
1297 ,p_gs_mr_src_entity_result_id_o
1298 => ben_cpe_shd.g_old_rec.gs_mirror_src_entity_result_id
1299 ,p_gs_parent_entity_result_id_o
1300 => ben_cpe_shd.g_old_rec.gs_parent_entity_result_id
1301 ,p_table_name_o
1302 => ben_cpe_shd.g_old_rec.table_name
1303 ,p_table_alias_o
1304 => ben_cpe_shd.g_old_rec.table_alias
1305 ,p_table_route_id_o
1306 => ben_cpe_shd.g_old_rec.table_route_id
1307 ,p_status_o
1308 => ben_cpe_shd.g_old_rec.status
1309 ,p_dml_operation_o
1310 => ben_cpe_shd.g_old_rec.dml_operation
1311 ,p_information_category_o
1312 => ben_cpe_shd.g_old_rec.information_category
1313 ,p_information1_o
1317 ,p_information3_o
1314 => ben_cpe_shd.g_old_rec.information1
1315 ,p_information2_o
1316 => ben_cpe_shd.g_old_rec.information2
1318 => ben_cpe_shd.g_old_rec.information3
1319 ,p_information4_o
1320 => ben_cpe_shd.g_old_rec.information4
1321 ,p_information5_o
1322 => ben_cpe_shd.g_old_rec.information5
1323 ,p_information6_o
1324 => ben_cpe_shd.g_old_rec.information6
1325 ,p_information7_o
1326 => ben_cpe_shd.g_old_rec.information7
1327 ,p_information8_o
1328 => ben_cpe_shd.g_old_rec.information8
1329 ,p_information9_o
1330 => ben_cpe_shd.g_old_rec.information9
1331 ,p_information10_o
1332 => ben_cpe_shd.g_old_rec.information10
1333 ,p_information11_o
1334 => ben_cpe_shd.g_old_rec.information11
1335 ,p_information12_o
1336 => ben_cpe_shd.g_old_rec.information12
1337 ,p_information13_o
1338 => ben_cpe_shd.g_old_rec.information13
1339 ,p_information14_o
1340 => ben_cpe_shd.g_old_rec.information14
1341 ,p_information15_o
1342 => ben_cpe_shd.g_old_rec.information15
1343 ,p_information16_o
1344 => ben_cpe_shd.g_old_rec.information16
1345 ,p_information17_o
1346 => ben_cpe_shd.g_old_rec.information17
1347 ,p_information18_o
1348 => ben_cpe_shd.g_old_rec.information18
1349 ,p_information19_o
1350 => ben_cpe_shd.g_old_rec.information19
1351 ,p_information20_o
1352 => ben_cpe_shd.g_old_rec.information20
1353 ,p_information21_o
1354 => ben_cpe_shd.g_old_rec.information21
1355 ,p_information22_o
1356 => ben_cpe_shd.g_old_rec.information22
1357 ,p_information23_o
1358 => ben_cpe_shd.g_old_rec.information23
1359 ,p_information24_o
1360 => ben_cpe_shd.g_old_rec.information24
1361 ,p_information25_o
1362 => ben_cpe_shd.g_old_rec.information25
1363 ,p_information26_o
1364 => ben_cpe_shd.g_old_rec.information26
1365 ,p_information27_o
1366 => ben_cpe_shd.g_old_rec.information27
1367 ,p_information28_o
1368 => ben_cpe_shd.g_old_rec.information28
1369 ,p_information29_o
1370 => ben_cpe_shd.g_old_rec.information29
1371 ,p_information30_o
1372 => ben_cpe_shd.g_old_rec.information30
1373 ,p_information31_o
1374 => ben_cpe_shd.g_old_rec.information31
1375 ,p_information32_o
1376 => ben_cpe_shd.g_old_rec.information32
1377 ,p_information33_o
1378 => ben_cpe_shd.g_old_rec.information33
1379 ,p_information34_o
1380 => ben_cpe_shd.g_old_rec.information34
1381 ,p_information35_o
1382 => ben_cpe_shd.g_old_rec.information35
1383 ,p_information36_o
1384 => ben_cpe_shd.g_old_rec.information36
1385 ,p_information37_o
1386 => ben_cpe_shd.g_old_rec.information37
1387 ,p_information38_o
1388 => ben_cpe_shd.g_old_rec.information38
1389 ,p_information39_o
1390 => ben_cpe_shd.g_old_rec.information39
1391 ,p_information40_o
1392 => ben_cpe_shd.g_old_rec.information40
1393 ,p_information41_o
1394 => ben_cpe_shd.g_old_rec.information41
1395 ,p_information42_o
1396 => ben_cpe_shd.g_old_rec.information42
1397 ,p_information43_o
1398 => ben_cpe_shd.g_old_rec.information43
1399 ,p_information44_o
1400 => ben_cpe_shd.g_old_rec.information44
1401 ,p_information45_o
1402 => ben_cpe_shd.g_old_rec.information45
1403 ,p_information46_o
1404 => ben_cpe_shd.g_old_rec.information46
1405 ,p_information47_o
1406 => ben_cpe_shd.g_old_rec.information47
1407 ,p_information48_o
1408 => ben_cpe_shd.g_old_rec.information48
1409 ,p_information49_o
1410 => ben_cpe_shd.g_old_rec.information49
1411 ,p_information50_o
1412 => ben_cpe_shd.g_old_rec.information50
1413 ,p_information51_o
1414 => ben_cpe_shd.g_old_rec.information51
1415 ,p_information52_o
1416 => ben_cpe_shd.g_old_rec.information52
1417 ,p_information53_o
1418 => ben_cpe_shd.g_old_rec.information53
1419 ,p_information54_o
1420 => ben_cpe_shd.g_old_rec.information54
1421 ,p_information55_o
1422 => ben_cpe_shd.g_old_rec.information55
1423 ,p_information56_o
1424 => ben_cpe_shd.g_old_rec.information56
1425 ,p_information57_o
1426 => ben_cpe_shd.g_old_rec.information57
1427 ,p_information58_o
1428 => ben_cpe_shd.g_old_rec.information58
1429 ,p_information59_o
1430 => ben_cpe_shd.g_old_rec.information59
1431 ,p_information60_o
1432 => ben_cpe_shd.g_old_rec.information60
1433 ,p_information61_o
1434 => ben_cpe_shd.g_old_rec.information61
1435 ,p_information62_o
1436 => ben_cpe_shd.g_old_rec.information62
1437 ,p_information63_o
1438 => ben_cpe_shd.g_old_rec.information63
1439 ,p_information64_o
1440 => ben_cpe_shd.g_old_rec.information64
1441 ,p_information65_o
1442 => ben_cpe_shd.g_old_rec.information65
1443 ,p_information66_o
1444 => ben_cpe_shd.g_old_rec.information66
1445 ,p_information67_o
1446 => ben_cpe_shd.g_old_rec.information67
1447 ,p_information68_o
1448 => ben_cpe_shd.g_old_rec.information68
1449 ,p_information69_o
1450 => ben_cpe_shd.g_old_rec.information69
1451 ,p_information70_o
1452 => ben_cpe_shd.g_old_rec.information70
1453 ,p_information71_o
1454 => ben_cpe_shd.g_old_rec.information71
1455 ,p_information72_o
1456 => ben_cpe_shd.g_old_rec.information72
1457 ,p_information73_o
1458 => ben_cpe_shd.g_old_rec.information73
1459 ,p_information74_o
1460 => ben_cpe_shd.g_old_rec.information74
1461 ,p_information75_o
1465 ,p_information77_o
1462 => ben_cpe_shd.g_old_rec.information75
1463 ,p_information76_o
1464 => ben_cpe_shd.g_old_rec.information76
1466 => ben_cpe_shd.g_old_rec.information77
1467 ,p_information78_o
1468 => ben_cpe_shd.g_old_rec.information78
1469 ,p_information79_o
1470 => ben_cpe_shd.g_old_rec.information79
1471 ,p_information80_o
1472 => ben_cpe_shd.g_old_rec.information80
1473 ,p_information81_o
1474 => ben_cpe_shd.g_old_rec.information81
1475 ,p_information82_o
1476 => ben_cpe_shd.g_old_rec.information82
1477 ,p_information83_o
1478 => ben_cpe_shd.g_old_rec.information83
1479 ,p_information84_o
1480 => ben_cpe_shd.g_old_rec.information84
1481 ,p_information85_o
1482 => ben_cpe_shd.g_old_rec.information85
1483 ,p_information86_o
1484 => ben_cpe_shd.g_old_rec.information86
1485 ,p_information87_o
1486 => ben_cpe_shd.g_old_rec.information87
1487 ,p_information88_o
1488 => ben_cpe_shd.g_old_rec.information88
1489 ,p_information89_o
1490 => ben_cpe_shd.g_old_rec.information89
1491 ,p_information90_o
1492 => ben_cpe_shd.g_old_rec.information90
1493 ,p_information91_o
1494 => ben_cpe_shd.g_old_rec.information91
1495 ,p_information92_o
1496 => ben_cpe_shd.g_old_rec.information92
1497 ,p_information93_o
1498 => ben_cpe_shd.g_old_rec.information93
1499 ,p_information94_o
1500 => ben_cpe_shd.g_old_rec.information94
1501 ,p_information95_o
1502 => ben_cpe_shd.g_old_rec.information95
1503 ,p_information96_o
1504 => ben_cpe_shd.g_old_rec.information96
1505 ,p_information97_o
1506 => ben_cpe_shd.g_old_rec.information97
1507 ,p_information98_o
1508 => ben_cpe_shd.g_old_rec.information98
1509 ,p_information99_o
1510 => ben_cpe_shd.g_old_rec.information99
1511 ,p_information100_o
1512 => ben_cpe_shd.g_old_rec.information100
1513 ,p_information101_o
1514 => ben_cpe_shd.g_old_rec.information101
1515 ,p_information102_o
1516 => ben_cpe_shd.g_old_rec.information102
1517 ,p_information103_o
1518 => ben_cpe_shd.g_old_rec.information103
1519 ,p_information104_o
1520 => ben_cpe_shd.g_old_rec.information104
1521 ,p_information105_o
1522 => ben_cpe_shd.g_old_rec.information105
1523 ,p_information106_o
1524 => ben_cpe_shd.g_old_rec.information106
1525 ,p_information107_o
1526 => ben_cpe_shd.g_old_rec.information107
1527 ,p_information108_o
1528 => ben_cpe_shd.g_old_rec.information108
1529 ,p_information109_o
1530 => ben_cpe_shd.g_old_rec.information109
1531 ,p_information110_o
1532 => ben_cpe_shd.g_old_rec.information110
1533 ,p_information111_o
1534 => ben_cpe_shd.g_old_rec.information111
1535 ,p_information112_o
1536 => ben_cpe_shd.g_old_rec.information112
1537 ,p_information113_o
1538 => ben_cpe_shd.g_old_rec.information113
1539 ,p_information114_o
1540 => ben_cpe_shd.g_old_rec.information114
1541 ,p_information115_o
1542 => ben_cpe_shd.g_old_rec.information115
1543 ,p_information116_o
1544 => ben_cpe_shd.g_old_rec.information116
1545 ,p_information117_o
1546 => ben_cpe_shd.g_old_rec.information117
1547 ,p_information118_o
1548 => ben_cpe_shd.g_old_rec.information118
1549 ,p_information119_o
1550 => ben_cpe_shd.g_old_rec.information119
1551 ,p_information120_o
1552 => ben_cpe_shd.g_old_rec.information120
1553 ,p_information121_o
1554 => ben_cpe_shd.g_old_rec.information121
1555 ,p_information122_o
1556 => ben_cpe_shd.g_old_rec.information122
1557 ,p_information123_o
1558 => ben_cpe_shd.g_old_rec.information123
1559 ,p_information124_o
1560 => ben_cpe_shd.g_old_rec.information124
1561 ,p_information125_o
1562 => ben_cpe_shd.g_old_rec.information125
1563 ,p_information126_o
1564 => ben_cpe_shd.g_old_rec.information126
1565 ,p_information127_o
1566 => ben_cpe_shd.g_old_rec.information127
1567 ,p_information128_o
1568 => ben_cpe_shd.g_old_rec.information128
1569 ,p_information129_o
1570 => ben_cpe_shd.g_old_rec.information129
1571 ,p_information130_o
1572 => ben_cpe_shd.g_old_rec.information130
1573 ,p_information131_o
1574 => ben_cpe_shd.g_old_rec.information131
1575 ,p_information132_o
1576 => ben_cpe_shd.g_old_rec.information132
1577 ,p_information133_o
1578 => ben_cpe_shd.g_old_rec.information133
1579 ,p_information134_o
1580 => ben_cpe_shd.g_old_rec.information134
1581 ,p_information135_o
1582 => ben_cpe_shd.g_old_rec.information135
1583 ,p_information136_o
1584 => ben_cpe_shd.g_old_rec.information136
1585 ,p_information137_o
1586 => ben_cpe_shd.g_old_rec.information137
1587 ,p_information138_o
1588 => ben_cpe_shd.g_old_rec.information138
1589 ,p_information139_o
1590 => ben_cpe_shd.g_old_rec.information139
1591 ,p_information140_o
1592 => ben_cpe_shd.g_old_rec.information140
1593 ,p_information141_o
1594 => ben_cpe_shd.g_old_rec.information141
1595 ,p_information142_o
1596 => ben_cpe_shd.g_old_rec.information142
1597
1598 /* Extra Reserved Columns
1599 ,p_information143_o
1600 => ben_cpe_shd.g_old_rec.information143
1601 ,p_information144_o
1602 => ben_cpe_shd.g_old_rec.information144
1603 ,p_information145_o
1604 => ben_cpe_shd.g_old_rec.information145
1605 ,p_information146_o
1606 => ben_cpe_shd.g_old_rec.information146
1607 ,p_information147_o
1608 => ben_cpe_shd.g_old_rec.information147
1612 => ben_cpe_shd.g_old_rec.information149
1609 ,p_information148_o
1610 => ben_cpe_shd.g_old_rec.information148
1611 ,p_information149_o
1613 ,p_information150_o
1614 => ben_cpe_shd.g_old_rec.information150
1615 */
1616 ,p_information151_o
1617 => ben_cpe_shd.g_old_rec.information151
1618 ,p_information152_o
1619 => ben_cpe_shd.g_old_rec.information152
1620 ,p_information153_o
1621 => ben_cpe_shd.g_old_rec.information153
1622
1623 /* Extra Reserved Columns
1624 ,p_information154_o
1625 => ben_cpe_shd.g_old_rec.information154
1626 ,p_information155_o
1627 => ben_cpe_shd.g_old_rec.information155
1628 ,p_information156_o
1629 => ben_cpe_shd.g_old_rec.information156
1630 ,p_information157_o
1631 => ben_cpe_shd.g_old_rec.information157
1632 ,p_information158_o
1633 => ben_cpe_shd.g_old_rec.information158
1634 ,p_information159_o
1635 => ben_cpe_shd.g_old_rec.information159
1636 */
1637
1638 ,p_information160_o
1639 => ben_cpe_shd.g_old_rec.information160
1640 ,p_information161_o
1641 => ben_cpe_shd.g_old_rec.information161
1642 ,p_information162_o
1643 => ben_cpe_shd.g_old_rec.information162
1644
1645 /* Extra Reserved Columns
1646 ,p_information163_o
1647 => ben_cpe_shd.g_old_rec.information163
1648 ,p_information164_o
1649 => ben_cpe_shd.g_old_rec.information164
1650 ,p_information165_o
1651 => ben_cpe_shd.g_old_rec.information165
1652 */
1653
1654 ,p_information166_o
1655 => ben_cpe_shd.g_old_rec.information166
1656 ,p_information167_o
1657 => ben_cpe_shd.g_old_rec.information167
1658 ,p_information168_o
1659 => ben_cpe_shd.g_old_rec.information168
1660 ,p_information169_o
1661 => ben_cpe_shd.g_old_rec.information169
1662 ,p_information170_o
1663 => ben_cpe_shd.g_old_rec.information170
1664
1665 /* Extra Reserved Columns
1666 ,p_information171_o
1667 => ben_cpe_shd.g_old_rec.information171
1668 ,p_information172_o
1669 => ben_cpe_shd.g_old_rec.information172
1670 */
1671
1672 ,p_information173_o
1673 => ben_cpe_shd.g_old_rec.information173
1674 ,p_information174_o
1675 => ben_cpe_shd.g_old_rec.information174
1676 ,p_information175_o
1677 => ben_cpe_shd.g_old_rec.information175
1678 ,p_information176_o
1679 => ben_cpe_shd.g_old_rec.information176
1680 ,p_information177_o
1681 => ben_cpe_shd.g_old_rec.information177
1682 ,p_information178_o
1683 => ben_cpe_shd.g_old_rec.information178
1684 ,p_information179_o
1685 => ben_cpe_shd.g_old_rec.information179
1686 ,p_information180_o
1687 => ben_cpe_shd.g_old_rec.information180
1688 ,p_information181_o
1689 => ben_cpe_shd.g_old_rec.information181
1690 ,p_information182_o
1691 => ben_cpe_shd.g_old_rec.information182
1692
1693 /* Extra Reserved Columns
1694 ,p_information183_o
1695 => ben_cpe_shd.g_old_rec.information183
1696 ,p_information184_o
1697 => ben_cpe_shd.g_old_rec.information184
1698 */
1699 ,p_information185_o
1700 => ben_cpe_shd.g_old_rec.information185
1701 ,p_information186_o
1702 => ben_cpe_shd.g_old_rec.information186
1703 ,p_information187_o
1704 => ben_cpe_shd.g_old_rec.information187
1705 ,p_information188_o
1706 => ben_cpe_shd.g_old_rec.information188
1707
1708 /* Extra Reserved Columns
1709 ,p_information189_o
1710 => ben_cpe_shd.g_old_rec.information189
1711 */
1712 ,p_information190_o
1713 => ben_cpe_shd.g_old_rec.information190
1714 ,p_information191_o
1715 => ben_cpe_shd.g_old_rec.information191
1716 ,p_information192_o
1717 => ben_cpe_shd.g_old_rec.information192
1718 ,p_information193_o
1719 => ben_cpe_shd.g_old_rec.information193
1720 ,p_information194_o
1721 => ben_cpe_shd.g_old_rec.information194
1722 ,p_information195_o
1723 => ben_cpe_shd.g_old_rec.information195
1724 ,p_information196_o
1725 => ben_cpe_shd.g_old_rec.information196
1726 ,p_information197_o
1727 => ben_cpe_shd.g_old_rec.information197
1728 ,p_information198_o
1729 => ben_cpe_shd.g_old_rec.information198
1730 ,p_information199_o
1731 => ben_cpe_shd.g_old_rec.information199
1732
1733 /* Extra Reserved Columns
1734 ,p_information200_o
1735 => ben_cpe_shd.g_old_rec.information200
1736 ,p_information201_o
1737 => ben_cpe_shd.g_old_rec.information201
1738 ,p_information202_o
1739 => ben_cpe_shd.g_old_rec.information202
1740 ,p_information203_o
1741 => ben_cpe_shd.g_old_rec.information203
1742 ,p_information204_o
1743 => ben_cpe_shd.g_old_rec.information204
1744 ,p_information205_o
1745 => ben_cpe_shd.g_old_rec.information205
1746 ,p_information206_o
1747 => ben_cpe_shd.g_old_rec.information206
1748 ,p_information207_o
1749 => ben_cpe_shd.g_old_rec.information207
1750 ,p_information208_o
1751 => ben_cpe_shd.g_old_rec.information208
1752 ,p_information209_o
1753 => ben_cpe_shd.g_old_rec.information209
1754 ,p_information210_o
1755 => ben_cpe_shd.g_old_rec.information210
1756 ,p_information211_o
1757 => ben_cpe_shd.g_old_rec.information211
1758 ,p_information212_o
1759 => ben_cpe_shd.g_old_rec.information212
1760 ,p_information213_o
1761 => ben_cpe_shd.g_old_rec.information213
1762 ,p_information214_o
1763 => ben_cpe_shd.g_old_rec.information214
1764 ,p_information215_o
1765 => ben_cpe_shd.g_old_rec.information215
1766 */
1767
1768 ,p_information216_o
1769 => ben_cpe_shd.g_old_rec.information216
1770 ,p_information217_o
1771 => ben_cpe_shd.g_old_rec.information217
1772 ,p_information218_o
1773 => ben_cpe_shd.g_old_rec.information218
1774 ,p_information219_o
1775 => ben_cpe_shd.g_old_rec.information219
1776 ,p_information220_o
1777 => ben_cpe_shd.g_old_rec.information220
1778
1779 ,p_information221_o
1780 => ben_cpe_shd.g_old_rec.information221
1781 ,p_information222_o
1782 => ben_cpe_shd.g_old_rec.information222
1783 ,p_information223_o
1784 => ben_cpe_shd.g_old_rec.information223
1785 ,p_information224_o
1786 => ben_cpe_shd.g_old_rec.information224
1787 ,p_information225_o
1788 => ben_cpe_shd.g_old_rec.information225
1789 ,p_information226_o
1790 => ben_cpe_shd.g_old_rec.information226
1791 ,p_information227_o
1792 => ben_cpe_shd.g_old_rec.information227
1793 ,p_information228_o
1794 => ben_cpe_shd.g_old_rec.information228
1795 ,p_information229_o
1796 => ben_cpe_shd.g_old_rec.information229
1797 ,p_information230_o
1798 => ben_cpe_shd.g_old_rec.information230
1799 ,p_information231_o
1800 => ben_cpe_shd.g_old_rec.information231
1801 ,p_information232_o
1802 => ben_cpe_shd.g_old_rec.information232
1803 ,p_information233_o
1804 => ben_cpe_shd.g_old_rec.information233
1805 ,p_information234_o
1806 => ben_cpe_shd.g_old_rec.information234
1807 ,p_information235_o
1808 => ben_cpe_shd.g_old_rec.information235
1809 ,p_information236_o
1810 => ben_cpe_shd.g_old_rec.information236
1811 ,p_information237_o
1812 => ben_cpe_shd.g_old_rec.information237
1813 ,p_information238_o
1814 => ben_cpe_shd.g_old_rec.information238
1815 ,p_information239_o
1816 => ben_cpe_shd.g_old_rec.information239
1817 ,p_information240_o
1818 => ben_cpe_shd.g_old_rec.information240
1819 ,p_information241_o
1820 => ben_cpe_shd.g_old_rec.information241
1821 ,p_information242_o
1822 => ben_cpe_shd.g_old_rec.information242
1823 ,p_information243_o
1824 => ben_cpe_shd.g_old_rec.information243
1825 ,p_information244_o
1826 => ben_cpe_shd.g_old_rec.information244
1827 ,p_information245_o
1828 => ben_cpe_shd.g_old_rec.information245
1829 ,p_information246_o
1830 => ben_cpe_shd.g_old_rec.information246
1831 ,p_information247_o
1832 => ben_cpe_shd.g_old_rec.information247
1833 ,p_information248_o
1834 => ben_cpe_shd.g_old_rec.information248
1835 ,p_information249_o
1836 => ben_cpe_shd.g_old_rec.information249
1837 ,p_information250_o
1838 => ben_cpe_shd.g_old_rec.information250
1839 ,p_information251_o
1840 => ben_cpe_shd.g_old_rec.information251
1841 ,p_information252_o
1842 => ben_cpe_shd.g_old_rec.information252
1843 ,p_information253_o
1844 => ben_cpe_shd.g_old_rec.information253
1845 ,p_information254_o
1846 => ben_cpe_shd.g_old_rec.information254
1847 ,p_information255_o
1848 => ben_cpe_shd.g_old_rec.information255
1849 ,p_information256_o
1850 => ben_cpe_shd.g_old_rec.information256
1851 ,p_information257_o
1852 => ben_cpe_shd.g_old_rec.information257
1853 ,p_information258_o
1854 => ben_cpe_shd.g_old_rec.information258
1855 ,p_information259_o
1856 => ben_cpe_shd.g_old_rec.information259
1857 ,p_information260_o
1858 => ben_cpe_shd.g_old_rec.information260
1859 ,p_information261_o
1860 => ben_cpe_shd.g_old_rec.information261
1861 ,p_information262_o
1862 => ben_cpe_shd.g_old_rec.information262
1863 ,p_information263_o
1864 => ben_cpe_shd.g_old_rec.information263
1865 ,p_information264_o
1866 => ben_cpe_shd.g_old_rec.information264
1867 ,p_information265_o
1868 => ben_cpe_shd.g_old_rec.information265
1869 ,p_information266_o
1870 => ben_cpe_shd.g_old_rec.information266
1871 ,p_information267_o
1872 => ben_cpe_shd.g_old_rec.information267
1873 ,p_information268_o
1874 => ben_cpe_shd.g_old_rec.information268
1875 ,p_information269_o
1876 => ben_cpe_shd.g_old_rec.information269
1877 ,p_information270_o
1878 => ben_cpe_shd.g_old_rec.information270
1879 ,p_information271_o
1880 => ben_cpe_shd.g_old_rec.information271
1881 ,p_information272_o
1882 => ben_cpe_shd.g_old_rec.information272
1883 ,p_information273_o
1884 => ben_cpe_shd.g_old_rec.information273
1885 ,p_information274_o
1886 => ben_cpe_shd.g_old_rec.information274
1887 ,p_information275_o
1888 => ben_cpe_shd.g_old_rec.information275
1889 ,p_information276_o
1890 => ben_cpe_shd.g_old_rec.information276
1891 ,p_information277_o
1892 => ben_cpe_shd.g_old_rec.information277
1893 ,p_information278_o
1894 => ben_cpe_shd.g_old_rec.information278
1895 ,p_information279_o
1896 => ben_cpe_shd.g_old_rec.information279
1897 ,p_information280_o
1898 => ben_cpe_shd.g_old_rec.information280
1899 ,p_information281_o
1900 => ben_cpe_shd.g_old_rec.information281
1901 ,p_information282_o
1902 => ben_cpe_shd.g_old_rec.information282
1903 ,p_information283_o
1904 => ben_cpe_shd.g_old_rec.information283
1905 ,p_information284_o
1906 => ben_cpe_shd.g_old_rec.information284
1907 ,p_information285_o
1908 => ben_cpe_shd.g_old_rec.information285
1909 ,p_information286_o
1910 => ben_cpe_shd.g_old_rec.information286
1911 ,p_information287_o
1912 => ben_cpe_shd.g_old_rec.information287
1913 ,p_information288_o
1914 => ben_cpe_shd.g_old_rec.information288
1915 ,p_information289_o
1916 => ben_cpe_shd.g_old_rec.information289
1917 ,p_information290_o
1918 => ben_cpe_shd.g_old_rec.information290
1919 ,p_information291_o
1920 => ben_cpe_shd.g_old_rec.information291
1921 ,p_information292_o
1922 => ben_cpe_shd.g_old_rec.information292
1923 ,p_information293_o
1924 => ben_cpe_shd.g_old_rec.information293
1925 ,p_information294_o
1926 => ben_cpe_shd.g_old_rec.information294
1927 ,p_information295_o
1928 => ben_cpe_shd.g_old_rec.information295
1929 ,p_information296_o
1930 => ben_cpe_shd.g_old_rec.information296
1931 ,p_information297_o
1932 => ben_cpe_shd.g_old_rec.information297
1933 ,p_information298_o
1934 => ben_cpe_shd.g_old_rec.information298
1935 ,p_information299_o
1936 => ben_cpe_shd.g_old_rec.information299
1937 ,p_information300_o
1938 => ben_cpe_shd.g_old_rec.information300
1939 ,p_information301_o
1940 => ben_cpe_shd.g_old_rec.information301
1941 ,p_information302_o
1942 => ben_cpe_shd.g_old_rec.information302
1943 ,p_information303_o
1944 => ben_cpe_shd.g_old_rec.information303
1945 ,p_information304_o
1946 => ben_cpe_shd.g_old_rec.information304
1947
1948 /* Extra Reserved Columns
1949 ,p_information305_o
1950 => ben_cpe_shd.g_old_rec.information305
1951 */
1952
1953 ,p_information306_o
1954 => ben_cpe_shd.g_old_rec.information306
1955 ,p_information307_o
1956 => ben_cpe_shd.g_old_rec.information307
1957 ,p_information308_o
1958 => ben_cpe_shd.g_old_rec.information308
1959 ,p_information309_o
1960 => ben_cpe_shd.g_old_rec.information309
1961 ,p_information310_o
1962 => ben_cpe_shd.g_old_rec.information310
1963 ,p_information311_o
1964 => ben_cpe_shd.g_old_rec.information311
1965 ,p_information312_o
1966 => ben_cpe_shd.g_old_rec.information312
1967 ,p_information313_o
1968 => ben_cpe_shd.g_old_rec.information313
1969 ,p_information314_o
1970 => ben_cpe_shd.g_old_rec.information314
1971 ,p_information315_o
1972 => ben_cpe_shd.g_old_rec.information315
1973 ,p_information316_o
1974 => ben_cpe_shd.g_old_rec.information316
1975 ,p_information317_o
1976 => ben_cpe_shd.g_old_rec.information317
1977 ,p_information318_o
1978 => ben_cpe_shd.g_old_rec.information318
1979 ,p_information319_o
1980 => ben_cpe_shd.g_old_rec.information319
1981 ,p_information320_o
1982 => ben_cpe_shd.g_old_rec.information320
1983
1984 /* Extra Reserved Columns
1985 ,p_information321_o
1986 => ben_cpe_shd.g_old_rec.information321
1987 ,p_information322_o
1988 => ben_cpe_shd.g_old_rec.information322
1989 */
1990
1991 ,p_information323_o
1992 => ben_cpe_shd.g_old_rec.information323
1993
1994 ,p_datetrack_mode_o
1995 => ben_cpe_shd.g_old_rec.datetrack_mode
1996 ,p_object_version_number_o
1997 => ben_cpe_shd.g_old_rec.object_version_number
1998 );
1999 --
2000 exception
2001 --
2002 when hr_api.cannot_find_prog_unit then
2003 --
2004 hr_api.cannot_find_prog_unit_error
2005 (p_module_name => 'BEN_COPY_ENTITY_RESULTS'
2006 ,p_hook_type => 'AU');
2007 --
2008 end;
2009 --
2010 hr_utility.set_location(' Leaving:'||l_proc, 10);
2011 End post_update;
2012 --
2013 -- ----------------------------------------------------------------------------
2014 -- |-----------------------------< convert_defs >-----------------------------|
2015 -- ----------------------------------------------------------------------------
2016 -- {Start Of Comments}
2017 --
2018 -- Description:
2019 -- The Convert_Defs procedure has one very important function:
2020 -- It must return the record structure for the row with all system defaulted
2021 -- values converted into its corresponding parameter value for update. When
2022 -- we attempt to update a row through the Upd process , certain
2023 -- parameters can be defaulted which enables flexibility in the calling of
2024 -- the upd process (e.g. only attributes which need to be updated need to be
2025 -- specified). For the upd process to determine which attributes
2026 -- have NOT been specified we need to check if the parameter has a reserved
2027 -- system default value. Therefore, for all parameters which have a
2028 -- corresponding reserved system default mechanism specified we need to
2029 -- check if a system default is being used. If a system default is being
2030 -- used then we convert the defaulted value into its corresponding attribute
2031 -- value held in the g_old_rec data structure.
2032 --
2033 -- Prerequisites:
2034 -- This private function can only be called from the upd process.
2035 --
2036 -- In Parameters:
2037 -- A Pl/Sql record structure.
2038 --
2039 -- Post Success:
2040 -- The record structure will be returned with all system defaulted parameter
2041 -- values converted into its current row attribute value.
2042 --
2043 -- Post Failure:
2044 -- No direct error handling is required within this function. Any possible
2045 -- errors within this procedure will be a PL/SQL value error due to
2046 -- conversion of datatypes or data lengths.
2047 --
2048 -- Developer Implementation Notes:
2049 -- None.
2050 --
2051 -- Access Status:
2052 -- Internal Row Handler Use Only.
2053 --
2054 -- {End Of Comments}
2055 -- ----------------------------------------------------------------------------
2056 Procedure convert_defs
2057 (p_rec in out nocopy ben_cpe_shd.g_rec_type
2058 ) is
2059 --
2060 Begin
2061 --
2062 -- We must now examine each argument value in the
2063 -- p_rec plsql record structure
2064 -- to see if a system default is being used. If a system default
2065 -- is being used then we must set to the 'current' argument value.
2066 --
2067 If (p_rec.copy_entity_txn_id = hr_api.g_number) then
2068 p_rec.copy_entity_txn_id :=
2069 ben_cpe_shd.g_old_rec.copy_entity_txn_id;
2070 End If;
2071 If (p_rec.src_copy_entity_result_id = hr_api.g_number) then
2072 p_rec.src_copy_entity_result_id :=
2073 ben_cpe_shd.g_old_rec.src_copy_entity_result_id;
2074 End If;
2075 If (p_rec.result_type_cd = hr_api.g_varchar2) then
2076 p_rec.result_type_cd :=
2077 ben_cpe_shd.g_old_rec.result_type_cd;
2078 End If;
2079 If (p_rec.number_of_copies = hr_api.g_number) then
2080 p_rec.number_of_copies :=
2081 ben_cpe_shd.g_old_rec.number_of_copies;
2082 End If;
2083 If (p_rec.mirror_entity_result_id = hr_api.g_number) then
2084 p_rec.mirror_entity_result_id :=
2085 ben_cpe_shd.g_old_rec.mirror_entity_result_id;
2086 End If;
2087 If (p_rec.mirror_src_entity_result_id = hr_api.g_number) then
2088 p_rec.mirror_src_entity_result_id :=
2089 ben_cpe_shd.g_old_rec.mirror_src_entity_result_id;
2090 End If;
2091 If (p_rec.parent_entity_result_id = hr_api.g_number) then
2092 p_rec.parent_entity_result_id :=
2093 ben_cpe_shd.g_old_rec.parent_entity_result_id;
2094 End If;
2095 If (p_rec.pd_mirror_src_entity_result_id = hr_api.g_number) then
2096 p_rec.pd_mirror_src_entity_result_id :=
2097 ben_cpe_shd.g_old_rec.pd_mirror_src_entity_result_id;
2098 End If;
2099 If (p_rec.pd_parent_entity_result_id = hr_api.g_number) then
2100 p_rec.pd_parent_entity_result_id :=
2101 ben_cpe_shd.g_old_rec.pd_parent_entity_result_id;
2102 End If;
2103 If (p_rec.gs_mirror_src_entity_result_id = hr_api.g_number) then
2104 p_rec.gs_mirror_src_entity_result_id :=
2105 ben_cpe_shd.g_old_rec.gs_mirror_src_entity_result_id;
2106 End If;
2107 If (p_rec.gs_parent_entity_result_id = hr_api.g_number) then
2108 p_rec.gs_parent_entity_result_id :=
2109 ben_cpe_shd.g_old_rec.gs_parent_entity_result_id;
2110 End If;
2111 If (p_rec.table_name = hr_api.g_varchar2) then
2112 p_rec.table_name :=
2113 ben_cpe_shd.g_old_rec.table_name;
2114 End If;
2115 If (p_rec.table_alias = hr_api.g_varchar2) then
2116 p_rec.table_alias :=
2117 ben_cpe_shd.g_old_rec.table_alias;
2118 End If;
2119 If (p_rec.table_route_id = hr_api.g_number) then
2120 p_rec.table_route_id :=
2121 ben_cpe_shd.g_old_rec.table_route_id;
2122 End If;
2123 If (p_rec.status = hr_api.g_varchar2) then
2124 p_rec.status :=
2125 ben_cpe_shd.g_old_rec.status;
2126 End If;
2127 If (p_rec.dml_operation = hr_api.g_varchar2) then
2128 p_rec.dml_operation :=
2129 ben_cpe_shd.g_old_rec.dml_operation;
2130 End If;
2131 If (p_rec.information_category = hr_api.g_varchar2) then
2132 p_rec.information_category :=
2133 ben_cpe_shd.g_old_rec.information_category;
2134 End If;
2138 End If;
2135 If (p_rec.information1 = hr_api.g_number) then
2136 p_rec.information1 :=
2137 ben_cpe_shd.g_old_rec.information1;
2139 If (p_rec.information2 = hr_api.g_date) then
2140 p_rec.information2 :=
2141 ben_cpe_shd.g_old_rec.information2;
2142 End If;
2143 If (p_rec.information3 = hr_api.g_date) then
2144 p_rec.information3 :=
2145 ben_cpe_shd.g_old_rec.information3;
2146 End If;
2147 If (p_rec.information4 = hr_api.g_number) then
2148 p_rec.information4 :=
2149 ben_cpe_shd.g_old_rec.information4;
2150 End If;
2151 If (p_rec.information5 = hr_api.g_varchar2) then
2152 p_rec.information5 :=
2153 ben_cpe_shd.g_old_rec.information5;
2154 End If;
2155 If (p_rec.information6 = hr_api.g_varchar2) then
2156 p_rec.information6 :=
2157 ben_cpe_shd.g_old_rec.information6;
2158 End If;
2159 If (p_rec.information7 = hr_api.g_varchar2) then
2160 p_rec.information7 :=
2161 ben_cpe_shd.g_old_rec.information7;
2162 End If;
2163 If (p_rec.information8 = hr_api.g_varchar2) then
2164 p_rec.information8 :=
2165 ben_cpe_shd.g_old_rec.information8;
2166 End If;
2167 If (p_rec.information9 = hr_api.g_varchar2) then
2168 p_rec.information9 :=
2169 ben_cpe_shd.g_old_rec.information9;
2170 End If;
2171 If (p_rec.information10 = hr_api.g_date) then
2172 p_rec.information10 :=
2173 ben_cpe_shd.g_old_rec.information10;
2174 End If;
2175 If (p_rec.information11 = hr_api.g_varchar2) then
2176 p_rec.information11 :=
2177 ben_cpe_shd.g_old_rec.information11;
2178 End If;
2179 If (p_rec.information12 = hr_api.g_varchar2) then
2180 p_rec.information12 :=
2181 ben_cpe_shd.g_old_rec.information12;
2182 End If;
2183 If (p_rec.information13 = hr_api.g_varchar2) then
2184 p_rec.information13 :=
2185 ben_cpe_shd.g_old_rec.information13;
2186 End If;
2187 If (p_rec.information14 = hr_api.g_varchar2) then
2188 p_rec.information14 :=
2189 ben_cpe_shd.g_old_rec.information14;
2190 End If;
2191 If (p_rec.information15 = hr_api.g_varchar2) then
2192 p_rec.information15 :=
2193 ben_cpe_shd.g_old_rec.information15;
2194 End If;
2195 If (p_rec.information16 = hr_api.g_varchar2) then
2196 p_rec.information16 :=
2197 ben_cpe_shd.g_old_rec.information16;
2198 End If;
2199 If (p_rec.information17 = hr_api.g_varchar2) then
2200 p_rec.information17 :=
2201 ben_cpe_shd.g_old_rec.information17;
2202 End If;
2203 If (p_rec.information18 = hr_api.g_varchar2) then
2204 p_rec.information18 :=
2205 ben_cpe_shd.g_old_rec.information18;
2206 End If;
2207 If (p_rec.information19 = hr_api.g_varchar2) then
2208 p_rec.information19 :=
2209 ben_cpe_shd.g_old_rec.information19;
2210 End If;
2211 If (p_rec.information20 = hr_api.g_varchar2) then
2212 p_rec.information20 :=
2213 ben_cpe_shd.g_old_rec.information20;
2214 End If;
2215 If (p_rec.information21 = hr_api.g_varchar2) then
2216 p_rec.information21 :=
2217 ben_cpe_shd.g_old_rec.information21;
2218 End If;
2219 If (p_rec.information22 = hr_api.g_varchar2) then
2220 p_rec.information22 :=
2221 ben_cpe_shd.g_old_rec.information22;
2222 End If;
2223 If (p_rec.information23 = hr_api.g_varchar2) then
2224 p_rec.information23 :=
2225 ben_cpe_shd.g_old_rec.information23;
2226 End If;
2227 If (p_rec.information24 = hr_api.g_varchar2) then
2228 p_rec.information24 :=
2229 ben_cpe_shd.g_old_rec.information24;
2230 End If;
2231 If (p_rec.information25 = hr_api.g_varchar2) then
2232 p_rec.information25 :=
2233 ben_cpe_shd.g_old_rec.information25;
2234 End If;
2235 If (p_rec.information26 = hr_api.g_varchar2) then
2236 p_rec.information26 :=
2237 ben_cpe_shd.g_old_rec.information26;
2238 End If;
2239 If (p_rec.information27 = hr_api.g_varchar2) then
2240 p_rec.information27 :=
2241 ben_cpe_shd.g_old_rec.information27;
2242 End If;
2243 If (p_rec.information28 = hr_api.g_varchar2) then
2244 p_rec.information28 :=
2245 ben_cpe_shd.g_old_rec.information28;
2246 End If;
2247 If (p_rec.information29 = hr_api.g_varchar2) then
2248 p_rec.information29 :=
2249 ben_cpe_shd.g_old_rec.information29;
2250 End If;
2251 If (p_rec.information30 = hr_api.g_varchar2) then
2252 p_rec.information30 :=
2253 ben_cpe_shd.g_old_rec.information30;
2254 End If;
2255 If (p_rec.information31 = hr_api.g_varchar2) then
2256 p_rec.information31 :=
2257 ben_cpe_shd.g_old_rec.information31;
2258 End If;
2259 If (p_rec.information32 = hr_api.g_varchar2) then
2260 p_rec.information32 :=
2261 ben_cpe_shd.g_old_rec.information32;
2262 End If;
2263 If (p_rec.information33 = hr_api.g_varchar2) then
2264 p_rec.information33 :=
2265 ben_cpe_shd.g_old_rec.information33;
2266 End If;
2267 If (p_rec.information34 = hr_api.g_varchar2) then
2268 p_rec.information34 :=
2269 ben_cpe_shd.g_old_rec.information34;
2270 End If;
2271 If (p_rec.information35 = hr_api.g_varchar2) then
2272 p_rec.information35 :=
2273 ben_cpe_shd.g_old_rec.information35;
2274 End If;
2275 If (p_rec.information36 = hr_api.g_varchar2) then
2276 p_rec.information36 :=
2277 ben_cpe_shd.g_old_rec.information36;
2278 End If;
2279 If (p_rec.information37 = hr_api.g_varchar2) then
2280 p_rec.information37 :=
2281 ben_cpe_shd.g_old_rec.information37;
2282 End If;
2283 If (p_rec.information38 = hr_api.g_varchar2) then
2284 p_rec.information38 :=
2285 ben_cpe_shd.g_old_rec.information38;
2286 End If;
2287 If (p_rec.information39 = hr_api.g_varchar2) then
2288 p_rec.information39 :=
2289 ben_cpe_shd.g_old_rec.information39;
2290 End If;
2294 End If;
2291 If (p_rec.information40 = hr_api.g_varchar2) then
2292 p_rec.information40 :=
2293 ben_cpe_shd.g_old_rec.information40;
2295 If (p_rec.information41 = hr_api.g_varchar2) then
2296 p_rec.information41 :=
2297 ben_cpe_shd.g_old_rec.information41;
2298 End If;
2299 If (p_rec.information42 = hr_api.g_varchar2) then
2300 p_rec.information42 :=
2301 ben_cpe_shd.g_old_rec.information42;
2302 End If;
2303 If (p_rec.information43 = hr_api.g_varchar2) then
2304 p_rec.information43 :=
2305 ben_cpe_shd.g_old_rec.information43;
2306 End If;
2307 If (p_rec.information44 = hr_api.g_varchar2) then
2308 p_rec.information44 :=
2309 ben_cpe_shd.g_old_rec.information44;
2310 End If;
2311 If (p_rec.information45 = hr_api.g_varchar2) then
2312 p_rec.information45 :=
2313 ben_cpe_shd.g_old_rec.information45;
2314 End If;
2315 If (p_rec.information46 = hr_api.g_varchar2) then
2316 p_rec.information46 :=
2317 ben_cpe_shd.g_old_rec.information46;
2318 End If;
2319 If (p_rec.information47 = hr_api.g_varchar2) then
2320 p_rec.information47 :=
2321 ben_cpe_shd.g_old_rec.information47;
2322 End If;
2323 If (p_rec.information48 = hr_api.g_varchar2) then
2324 p_rec.information48 :=
2325 ben_cpe_shd.g_old_rec.information48;
2326 End If;
2327 If (p_rec.information49 = hr_api.g_varchar2) then
2328 p_rec.information49 :=
2329 ben_cpe_shd.g_old_rec.information49;
2330 End If;
2331 If (p_rec.information50 = hr_api.g_varchar2) then
2332 p_rec.information50 :=
2333 ben_cpe_shd.g_old_rec.information50;
2334 End If;
2335 If (p_rec.information51 = hr_api.g_varchar2) then
2336 p_rec.information51 :=
2337 ben_cpe_shd.g_old_rec.information51;
2338 End If;
2339 If (p_rec.information52 = hr_api.g_varchar2) then
2340 p_rec.information52 :=
2341 ben_cpe_shd.g_old_rec.information52;
2342 End If;
2343 If (p_rec.information53 = hr_api.g_varchar2) then
2344 p_rec.information53 :=
2345 ben_cpe_shd.g_old_rec.information53;
2346 End If;
2347 If (p_rec.information54 = hr_api.g_varchar2) then
2348 p_rec.information54 :=
2349 ben_cpe_shd.g_old_rec.information54;
2350 End If;
2351 If (p_rec.information55 = hr_api.g_varchar2) then
2352 p_rec.information55 :=
2353 ben_cpe_shd.g_old_rec.information55;
2354 End If;
2355 If (p_rec.information56 = hr_api.g_varchar2) then
2356 p_rec.information56 :=
2357 ben_cpe_shd.g_old_rec.information56;
2358 End If;
2359 If (p_rec.information57 = hr_api.g_varchar2) then
2360 p_rec.information57 :=
2361 ben_cpe_shd.g_old_rec.information57;
2362 End If;
2363 If (p_rec.information58 = hr_api.g_varchar2) then
2364 p_rec.information58 :=
2365 ben_cpe_shd.g_old_rec.information58;
2366 End If;
2367 If (p_rec.information59 = hr_api.g_varchar2) then
2368 p_rec.information59 :=
2369 ben_cpe_shd.g_old_rec.information59;
2370 End If;
2371 If (p_rec.information60 = hr_api.g_varchar2) then
2372 p_rec.information60 :=
2373 ben_cpe_shd.g_old_rec.information60;
2374 End If;
2375 If (p_rec.information61 = hr_api.g_varchar2) then
2376 p_rec.information61 :=
2377 ben_cpe_shd.g_old_rec.information61;
2378 End If;
2379 If (p_rec.information62 = hr_api.g_varchar2) then
2380 p_rec.information62 :=
2381 ben_cpe_shd.g_old_rec.information62;
2382 End If;
2383 If (p_rec.information63 = hr_api.g_varchar2) then
2384 p_rec.information63 :=
2385 ben_cpe_shd.g_old_rec.information63;
2386 End If;
2387 If (p_rec.information64 = hr_api.g_varchar2) then
2388 p_rec.information64 :=
2389 ben_cpe_shd.g_old_rec.information64;
2390 End If;
2391 If (p_rec.information65 = hr_api.g_varchar2) then
2392 p_rec.information65 :=
2393 ben_cpe_shd.g_old_rec.information65;
2394 End If;
2395 If (p_rec.information66 = hr_api.g_varchar2) then
2396 p_rec.information66 :=
2397 ben_cpe_shd.g_old_rec.information66;
2398 End If;
2399 If (p_rec.information67 = hr_api.g_varchar2) then
2400 p_rec.information67 :=
2401 ben_cpe_shd.g_old_rec.information67;
2402 End If;
2403 If (p_rec.information68 = hr_api.g_varchar2) then
2404 p_rec.information68 :=
2405 ben_cpe_shd.g_old_rec.information68;
2406 End If;
2407 If (p_rec.information69 = hr_api.g_varchar2) then
2408 p_rec.information69 :=
2409 ben_cpe_shd.g_old_rec.information69;
2410 End If;
2411 If (p_rec.information70 = hr_api.g_varchar2) then
2412 p_rec.information70 :=
2413 ben_cpe_shd.g_old_rec.information70;
2414 End If;
2415 If (p_rec.information71 = hr_api.g_varchar2) then
2416 p_rec.information71 :=
2417 ben_cpe_shd.g_old_rec.information71;
2418 End If;
2419 If (p_rec.information72 = hr_api.g_varchar2) then
2420 p_rec.information72 :=
2421 ben_cpe_shd.g_old_rec.information72;
2422 End If;
2423 If (p_rec.information73 = hr_api.g_varchar2) then
2424 p_rec.information73 :=
2425 ben_cpe_shd.g_old_rec.information73;
2426 End If;
2427 If (p_rec.information74 = hr_api.g_varchar2) then
2428 p_rec.information74 :=
2429 ben_cpe_shd.g_old_rec.information74;
2430 End If;
2431 If (p_rec.information75 = hr_api.g_varchar2) then
2432 p_rec.information75 :=
2433 ben_cpe_shd.g_old_rec.information75;
2434 End If;
2435 If (p_rec.information76 = hr_api.g_varchar2) then
2436 p_rec.information76 :=
2437 ben_cpe_shd.g_old_rec.information76;
2438 End If;
2439 If (p_rec.information77 = hr_api.g_varchar2) then
2440 p_rec.information77 :=
2441 ben_cpe_shd.g_old_rec.information77;
2442 End If;
2443 If (p_rec.information78 = hr_api.g_varchar2) then
2444 p_rec.information78 :=
2445 ben_cpe_shd.g_old_rec.information78;
2446 End If;
2450 End If;
2447 If (p_rec.information79 = hr_api.g_varchar2) then
2448 p_rec.information79 :=
2449 ben_cpe_shd.g_old_rec.information79;
2451 If (p_rec.information80 = hr_api.g_varchar2) then
2452 p_rec.information80 :=
2453 ben_cpe_shd.g_old_rec.information80;
2454 End If;
2455 If (p_rec.information81 = hr_api.g_varchar2) then
2456 p_rec.information81 :=
2457 ben_cpe_shd.g_old_rec.information81;
2458 End If;
2459 If (p_rec.information82 = hr_api.g_varchar2) then
2460 p_rec.information82 :=
2461 ben_cpe_shd.g_old_rec.information82;
2462 End If;
2463 If (p_rec.information83 = hr_api.g_varchar2) then
2464 p_rec.information83 :=
2465 ben_cpe_shd.g_old_rec.information83;
2466 End If;
2467 If (p_rec.information84 = hr_api.g_varchar2) then
2468 p_rec.information84 :=
2469 ben_cpe_shd.g_old_rec.information84;
2470 End If;
2471 If (p_rec.information85 = hr_api.g_varchar2) then
2472 p_rec.information85 :=
2473 ben_cpe_shd.g_old_rec.information85;
2474 End If;
2475 If (p_rec.information86 = hr_api.g_varchar2) then
2476 p_rec.information86 :=
2477 ben_cpe_shd.g_old_rec.information86;
2478 End If;
2479 If (p_rec.information87 = hr_api.g_varchar2) then
2480 p_rec.information87 :=
2481 ben_cpe_shd.g_old_rec.information87;
2482 End If;
2483 If (p_rec.information88 = hr_api.g_varchar2) then
2484 p_rec.information88 :=
2485 ben_cpe_shd.g_old_rec.information88;
2486 End If;
2487 If (p_rec.information89 = hr_api.g_varchar2) then
2488 p_rec.information89 :=
2489 ben_cpe_shd.g_old_rec.information89;
2490 End If;
2491 If (p_rec.information90 = hr_api.g_varchar2) then
2492 p_rec.information90 :=
2493 ben_cpe_shd.g_old_rec.information90;
2494 End If;
2495 If (p_rec.information91 = hr_api.g_varchar2) then
2496 p_rec.information91 :=
2497 ben_cpe_shd.g_old_rec.information91;
2498 End If;
2499 If (p_rec.information92 = hr_api.g_varchar2) then
2500 p_rec.information92 :=
2501 ben_cpe_shd.g_old_rec.information92;
2502 End If;
2503 If (p_rec.information93 = hr_api.g_varchar2) then
2504 p_rec.information93 :=
2505 ben_cpe_shd.g_old_rec.information93;
2506 End If;
2507 If (p_rec.information94 = hr_api.g_varchar2) then
2508 p_rec.information94 :=
2509 ben_cpe_shd.g_old_rec.information94;
2510 End If;
2511 If (p_rec.information95 = hr_api.g_varchar2) then
2512 p_rec.information95 :=
2513 ben_cpe_shd.g_old_rec.information95;
2514 End If;
2515 If (p_rec.information96 = hr_api.g_varchar2) then
2516 p_rec.information96 :=
2517 ben_cpe_shd.g_old_rec.information96;
2518 End If;
2519 If (p_rec.information97 = hr_api.g_varchar2) then
2520 p_rec.information97 :=
2521 ben_cpe_shd.g_old_rec.information97;
2522 End If;
2523 If (p_rec.information98 = hr_api.g_varchar2) then
2524 p_rec.information98 :=
2525 ben_cpe_shd.g_old_rec.information98;
2526 End If;
2527 If (p_rec.information99 = hr_api.g_varchar2) then
2528 p_rec.information99 :=
2529 ben_cpe_shd.g_old_rec.information99;
2530 End If;
2531 If (p_rec.information100 = hr_api.g_varchar2) then
2532 p_rec.information100 :=
2533 ben_cpe_shd.g_old_rec.information100;
2534 End If;
2535 If (p_rec.information101 = hr_api.g_varchar2) then
2536 p_rec.information101 :=
2537 ben_cpe_shd.g_old_rec.information101;
2538 End If;
2539 If (p_rec.information102 = hr_api.g_varchar2) then
2540 p_rec.information102 :=
2541 ben_cpe_shd.g_old_rec.information102;
2542 End If;
2543 If (p_rec.information103 = hr_api.g_varchar2) then
2544 p_rec.information103 :=
2545 ben_cpe_shd.g_old_rec.information103;
2546 End If;
2547 If (p_rec.information104 = hr_api.g_varchar2) then
2548 p_rec.information104 :=
2549 ben_cpe_shd.g_old_rec.information104;
2550 End If;
2551 If (p_rec.information105 = hr_api.g_varchar2) then
2552 p_rec.information105 :=
2553 ben_cpe_shd.g_old_rec.information105;
2554 End If;
2555 If (p_rec.information106 = hr_api.g_varchar2) then
2556 p_rec.information106 :=
2557 ben_cpe_shd.g_old_rec.information106;
2558 End If;
2559 If (p_rec.information107 = hr_api.g_varchar2) then
2560 p_rec.information107 :=
2561 ben_cpe_shd.g_old_rec.information107;
2562 End If;
2563 If (p_rec.information108 = hr_api.g_varchar2) then
2564 p_rec.information108 :=
2565 ben_cpe_shd.g_old_rec.information108;
2566 End If;
2567 If (p_rec.information109 = hr_api.g_varchar2) then
2568 p_rec.information109 :=
2569 ben_cpe_shd.g_old_rec.information109;
2570 End If;
2571 If (p_rec.information110 = hr_api.g_varchar2) then
2572 p_rec.information110 :=
2573 ben_cpe_shd.g_old_rec.information110;
2574 End If;
2575 If (p_rec.information111 = hr_api.g_varchar2) then
2576 p_rec.information111 :=
2577 ben_cpe_shd.g_old_rec.information111;
2578 End If;
2579 If (p_rec.information112 = hr_api.g_varchar2) then
2580 p_rec.information112 :=
2581 ben_cpe_shd.g_old_rec.information112;
2582 End If;
2583 If (p_rec.information113 = hr_api.g_varchar2) then
2584 p_rec.information113 :=
2585 ben_cpe_shd.g_old_rec.information113;
2586 End If;
2587 If (p_rec.information114 = hr_api.g_varchar2) then
2588 p_rec.information114 :=
2589 ben_cpe_shd.g_old_rec.information114;
2590 End If;
2591 If (p_rec.information115 = hr_api.g_varchar2) then
2592 p_rec.information115 :=
2593 ben_cpe_shd.g_old_rec.information115;
2594 End If;
2595 If (p_rec.information116 = hr_api.g_varchar2) then
2596 p_rec.information116 :=
2597 ben_cpe_shd.g_old_rec.information116;
2598 End If;
2599 If (p_rec.information117 = hr_api.g_varchar2) then
2600 p_rec.information117 :=
2604 p_rec.information118 :=
2601 ben_cpe_shd.g_old_rec.information117;
2602 End If;
2603 If (p_rec.information118 = hr_api.g_varchar2) then
2605 ben_cpe_shd.g_old_rec.information118;
2606 End If;
2607 If (p_rec.information119 = hr_api.g_varchar2) then
2608 p_rec.information119 :=
2609 ben_cpe_shd.g_old_rec.information119;
2610 End If;
2611 If (p_rec.information120 = hr_api.g_varchar2) then
2612 p_rec.information120 :=
2613 ben_cpe_shd.g_old_rec.information120;
2614 End If;
2615 If (p_rec.information121 = hr_api.g_varchar2) then
2616 p_rec.information121 :=
2617 ben_cpe_shd.g_old_rec.information121;
2618 End If;
2619 If (p_rec.information122 = hr_api.g_varchar2) then
2620 p_rec.information122 :=
2621 ben_cpe_shd.g_old_rec.information122;
2622 End If;
2623 If (p_rec.information123 = hr_api.g_varchar2) then
2624 p_rec.information123 :=
2625 ben_cpe_shd.g_old_rec.information123;
2626 End If;
2627 If (p_rec.information124 = hr_api.g_varchar2) then
2628 p_rec.information124 :=
2629 ben_cpe_shd.g_old_rec.information124;
2630 End If;
2631 If (p_rec.information125 = hr_api.g_varchar2) then
2632 p_rec.information125 :=
2633 ben_cpe_shd.g_old_rec.information125;
2634 End If;
2635 If (p_rec.information126 = hr_api.g_varchar2) then
2636 p_rec.information126 :=
2637 ben_cpe_shd.g_old_rec.information126;
2638 End If;
2639 If (p_rec.information127 = hr_api.g_varchar2) then
2640 p_rec.information127 :=
2641 ben_cpe_shd.g_old_rec.information127;
2642 End If;
2643 If (p_rec.information128 = hr_api.g_varchar2) then
2644 p_rec.information128 :=
2645 ben_cpe_shd.g_old_rec.information128;
2646 End If;
2647 If (p_rec.information129 = hr_api.g_varchar2) then
2648 p_rec.information129 :=
2649 ben_cpe_shd.g_old_rec.information129;
2650 End If;
2651 If (p_rec.information130 = hr_api.g_varchar2) then
2652 p_rec.information130 :=
2653 ben_cpe_shd.g_old_rec.information130;
2654 End If;
2655 If (p_rec.information131 = hr_api.g_varchar2) then
2656 p_rec.information131 :=
2657 ben_cpe_shd.g_old_rec.information131;
2658 End If;
2659 If (p_rec.information132 = hr_api.g_varchar2) then
2660 p_rec.information132 :=
2661 ben_cpe_shd.g_old_rec.information132;
2662 End If;
2663 If (p_rec.information133 = hr_api.g_varchar2) then
2664 p_rec.information133 :=
2665 ben_cpe_shd.g_old_rec.information133;
2666 End If;
2667 If (p_rec.information134 = hr_api.g_varchar2) then
2668 p_rec.information134 :=
2669 ben_cpe_shd.g_old_rec.information134;
2670 End If;
2671 If (p_rec.information135 = hr_api.g_varchar2) then
2672 p_rec.information135 :=
2673 ben_cpe_shd.g_old_rec.information135;
2674 End If;
2675 If (p_rec.information136 = hr_api.g_varchar2) then
2676 p_rec.information136 :=
2677 ben_cpe_shd.g_old_rec.information136;
2678 End If;
2679 If (p_rec.information137 = hr_api.g_varchar2) then
2680 p_rec.information137 :=
2681 ben_cpe_shd.g_old_rec.information137;
2682 End If;
2683 If (p_rec.information138 = hr_api.g_varchar2) then
2684 p_rec.information138 :=
2685 ben_cpe_shd.g_old_rec.information138;
2686 End If;
2687 If (p_rec.information139 = hr_api.g_varchar2) then
2688 p_rec.information139 :=
2689 ben_cpe_shd.g_old_rec.information139;
2690 End If;
2691 If (p_rec.information140 = hr_api.g_varchar2) then
2692 p_rec.information140 :=
2693 ben_cpe_shd.g_old_rec.information140;
2694 End If;
2695 If (p_rec.information141 = hr_api.g_varchar2) then
2696 p_rec.information141 :=
2697 ben_cpe_shd.g_old_rec.information141;
2698 End If;
2699 If (p_rec.information142 = hr_api.g_varchar2) then
2700 p_rec.information142 :=
2701 ben_cpe_shd.g_old_rec.information142;
2702 End If;
2703
2704 /* Extra Reserved Columns
2705 If (p_rec.information143 = hr_api.g_varchar2) then
2706 p_rec.information143 :=
2707 ben_cpe_shd.g_old_rec.information143;
2708 End If;
2709 If (p_rec.information144 = hr_api.g_varchar2) then
2710 p_rec.information144 :=
2711 ben_cpe_shd.g_old_rec.information144;
2712 End If;
2713 If (p_rec.information145 = hr_api.g_varchar2) then
2714 p_rec.information145 :=
2715 ben_cpe_shd.g_old_rec.information145;
2716 End If;
2717 If (p_rec.information146 = hr_api.g_varchar2) then
2718 p_rec.information146 :=
2719 ben_cpe_shd.g_old_rec.information146;
2720 End If;
2721 If (p_rec.information147 = hr_api.g_varchar2) then
2722 p_rec.information147 :=
2723 ben_cpe_shd.g_old_rec.information147;
2724 End If;
2725 If (p_rec.information148 = hr_api.g_varchar2) then
2726 p_rec.information148 :=
2727 ben_cpe_shd.g_old_rec.information148;
2728 End If;
2729 If (p_rec.information149 = hr_api.g_varchar2) then
2730 p_rec.information149 :=
2731 ben_cpe_shd.g_old_rec.information149;
2732 End If;
2733 If (p_rec.information150 = hr_api.g_varchar2) then
2734 p_rec.information150 :=
2735 ben_cpe_shd.g_old_rec.information150;
2736 End If;
2737
2738 */
2739
2740 If (p_rec.information151 = hr_api.g_varchar2) then
2741 p_rec.information151 :=
2742 ben_cpe_shd.g_old_rec.information151;
2743 End If;
2744 If (p_rec.information152 = hr_api.g_varchar2) then
2745 p_rec.information152 :=
2746 ben_cpe_shd.g_old_rec.information152;
2747 End If;
2748 If (p_rec.information153 = hr_api.g_varchar2) then
2749 p_rec.information153 :=
2750 ben_cpe_shd.g_old_rec.information153;
2751 End If;
2752
2753 /* Extra Reserved Columns
2754 If (p_rec.information154 = hr_api.g_varchar2) then
2755 p_rec.information154 :=
2756 ben_cpe_shd.g_old_rec.information154;
2757 End If;
2761 End If;
2758 If (p_rec.information155 = hr_api.g_varchar2) then
2759 p_rec.information155 :=
2760 ben_cpe_shd.g_old_rec.information155;
2762 If (p_rec.information156 = hr_api.g_varchar2) then
2763 p_rec.information156 :=
2764 ben_cpe_shd.g_old_rec.information156;
2765 End If;
2766 If (p_rec.information157 = hr_api.g_varchar2) then
2767 p_rec.information157 :=
2768 ben_cpe_shd.g_old_rec.information157;
2769 End If;
2770 If (p_rec.information158 = hr_api.g_varchar2) then
2771 p_rec.information158 :=
2772 ben_cpe_shd.g_old_rec.information158;
2773 End If;
2774 If (p_rec.information159 = hr_api.g_varchar2) then
2775 p_rec.information159 :=
2776 ben_cpe_shd.g_old_rec.information159;
2777 End If;
2778 */
2779
2780 If (p_rec.information160 = hr_api.g_number) then
2781 p_rec.information160 :=
2782 ben_cpe_shd.g_old_rec.information160;
2783 End If;
2784 If (p_rec.information161 = hr_api.g_number) then
2785 p_rec.information161 :=
2786 ben_cpe_shd.g_old_rec.information161;
2787 End If;
2788 If (p_rec.information162 = hr_api.g_number) then
2789 p_rec.information162 :=
2790 ben_cpe_shd.g_old_rec.information162;
2791 End If;
2792
2793 /* Extra Reserved Columns
2794 If (p_rec.information163 = hr_api.g_number) then
2795 p_rec.information163 :=
2796 ben_cpe_shd.g_old_rec.information163;
2797 End If;
2798 If (p_rec.information164 = hr_api.g_number) then
2799 p_rec.information164 :=
2800 ben_cpe_shd.g_old_rec.information164;
2801 End If;
2802 If (p_rec.information165 = hr_api.g_number) then
2803 p_rec.information165 :=
2804 ben_cpe_shd.g_old_rec.information165;
2805 End If;
2806 */
2807
2808 If (p_rec.information166 = hr_api.g_date) then
2809 p_rec.information166 :=
2810 ben_cpe_shd.g_old_rec.information166;
2811 End If;
2812 If (p_rec.information167 = hr_api.g_date) then
2813 p_rec.information167 :=
2814 ben_cpe_shd.g_old_rec.information167;
2815 End If;
2816 If (p_rec.information168 = hr_api.g_date) then
2817 p_rec.information168 :=
2818 ben_cpe_shd.g_old_rec.information168;
2819 End If;
2820 If (p_rec.information169 = hr_api.g_number) then
2821 p_rec.information169 :=
2822 ben_cpe_shd.g_old_rec.information169;
2823 End If;
2824 If (p_rec.information170 = hr_api.g_varchar2) then
2825 p_rec.information170 :=
2826 ben_cpe_shd.g_old_rec.information170;
2827 End If;
2828
2829 /* Extra Reserved Columns
2830 If (p_rec.information171 = hr_api.g_varchar2) then
2831 p_rec.information171 :=
2832 ben_cpe_shd.g_old_rec.information171;
2833 End If;
2834 If (p_rec.information172 = hr_api.g_varchar2) then
2835 p_rec.information172 :=
2836 ben_cpe_shd.g_old_rec.information172;
2837 End If;
2838 */
2839
2840 If (p_rec.information173 = hr_api.g_varchar2) then
2841 p_rec.information173 :=
2842 ben_cpe_shd.g_old_rec.information173;
2843 End If;
2844 If (p_rec.information174 = hr_api.g_number) then
2845 p_rec.information174 :=
2846 ben_cpe_shd.g_old_rec.information174;
2847 End If;
2848 If (p_rec.information175 = hr_api.g_varchar2) then
2849 p_rec.information175 :=
2850 ben_cpe_shd.g_old_rec.information175;
2851 End If;
2852 If (p_rec.information176 = hr_api.g_number) then
2853 p_rec.information176 :=
2854 ben_cpe_shd.g_old_rec.information176;
2855 End If;
2856 If (p_rec.information177 = hr_api.g_varchar2) then
2857 p_rec.information177 :=
2858 ben_cpe_shd.g_old_rec.information177;
2859 End If;
2860 If (p_rec.information178 = hr_api.g_number) then
2861 p_rec.information178 :=
2862 ben_cpe_shd.g_old_rec.information178;
2863 End If;
2864 If (p_rec.information179 = hr_api.g_varchar2) then
2865 p_rec.information179 :=
2866 ben_cpe_shd.g_old_rec.information179;
2867 End If;
2868 If (p_rec.information180 = hr_api.g_number) then
2869 p_rec.information180 :=
2870 ben_cpe_shd.g_old_rec.information180;
2871 End If;
2872 If (p_rec.information181 = hr_api.g_varchar2) then
2873 p_rec.information181 :=
2874 ben_cpe_shd.g_old_rec.information181;
2875 End If;
2876 If (p_rec.information182 = hr_api.g_varchar2) then
2877 p_rec.information182 :=
2878 ben_cpe_shd.g_old_rec.information182;
2879 End If;
2880
2881 /* Extra Reserved Columns
2882 If (p_rec.information183 = hr_api.g_varchar2) then
2883 p_rec.information183 :=
2884 ben_cpe_shd.g_old_rec.information183;
2885 End If;
2886 If (p_rec.information184 = hr_api.g_varchar2) then
2887 p_rec.information184 :=
2888 ben_cpe_shd.g_old_rec.information184;
2889 End If;
2890 */
2891
2892 If (p_rec.information185 = hr_api.g_varchar2) then
2893 p_rec.information185 :=
2894 ben_cpe_shd.g_old_rec.information185;
2895 End If;
2896 If (p_rec.information186 = hr_api.g_varchar2) then
2897 p_rec.information186 :=
2898 ben_cpe_shd.g_old_rec.information186;
2899 End If;
2900 If (p_rec.information187 = hr_api.g_varchar2) then
2901 p_rec.information187 :=
2902 ben_cpe_shd.g_old_rec.information187;
2903 End If;
2904 If (p_rec.information188 = hr_api.g_varchar2) then
2905 p_rec.information188 :=
2906 ben_cpe_shd.g_old_rec.information188;
2907 End If;
2908
2912 ben_cpe_shd.g_old_rec.information189;
2909 /* Extra Reserved Columns
2910 If (p_rec.information189 = hr_api.g_varchar2) then
2911 p_rec.information189 :=
2913 End If;
2914 */
2915 If (p_rec.information190 = hr_api.g_varchar2) then
2916 p_rec.information190 :=
2917 ben_cpe_shd.g_old_rec.information190;
2918 End If;
2919 If (p_rec.information191 = hr_api.g_varchar2) then
2920 p_rec.information191 :=
2921 ben_cpe_shd.g_old_rec.information191;
2922 End If;
2923 If (p_rec.information192 = hr_api.g_varchar2) then
2924 p_rec.information192 :=
2925 ben_cpe_shd.g_old_rec.information192;
2926 End If;
2927 If (p_rec.information193 = hr_api.g_varchar2) then
2928 p_rec.information193 :=
2929 ben_cpe_shd.g_old_rec.information193;
2930 End If;
2931 If (p_rec.information194 = hr_api.g_varchar2) then
2932 p_rec.information194 :=
2933 ben_cpe_shd.g_old_rec.information194;
2934 End If;
2935 If (p_rec.information195 = hr_api.g_varchar2) then
2936 p_rec.information195 :=
2937 ben_cpe_shd.g_old_rec.information195;
2938 End If;
2939 If (p_rec.information196 = hr_api.g_varchar2) then
2940 p_rec.information196 :=
2941 ben_cpe_shd.g_old_rec.information196;
2942 End If;
2943 If (p_rec.information197 = hr_api.g_varchar2) then
2944 p_rec.information197 :=
2945 ben_cpe_shd.g_old_rec.information197;
2946 End If;
2947 If (p_rec.information198 = hr_api.g_varchar2) then
2948 p_rec.information198 :=
2949 ben_cpe_shd.g_old_rec.information198;
2950 End If;
2951 If (p_rec.information199 = hr_api.g_varchar2) then
2952 p_rec.information199 :=
2953 ben_cpe_shd.g_old_rec.information199;
2954 End If;
2955
2956 /* Extra Reserved Columns
2957 If (p_rec.information200 = hr_api.g_varchar2) then
2958 p_rec.information200 :=
2959 ben_cpe_shd.g_old_rec.information200;
2960 End If;
2961 If (p_rec.information201 = hr_api.g_varchar2) then
2962 p_rec.information201 :=
2963 ben_cpe_shd.g_old_rec.information201;
2964 End If;
2965 If (p_rec.information202 = hr_api.g_varchar2) then
2966 p_rec.information202 :=
2967 ben_cpe_shd.g_old_rec.information202;
2968 End If;
2969 If (p_rec.information203 = hr_api.g_varchar2) then
2970 p_rec.information203 :=
2971 ben_cpe_shd.g_old_rec.information203;
2972 End If;
2973 If (p_rec.information204 = hr_api.g_varchar2) then
2974 p_rec.information204 :=
2975 ben_cpe_shd.g_old_rec.information204;
2976 End If;
2977 If (p_rec.information205 = hr_api.g_varchar2) then
2978 p_rec.information205 :=
2979 ben_cpe_shd.g_old_rec.information205;
2980 End If;
2981 If (p_rec.information206 = hr_api.g_varchar2) then
2982 p_rec.information206 :=
2983 ben_cpe_shd.g_old_rec.information206;
2984 End If;
2985 If (p_rec.information207 = hr_api.g_varchar2) then
2986 p_rec.information207 :=
2987 ben_cpe_shd.g_old_rec.information207;
2988 End If;
2989 If (p_rec.information208 = hr_api.g_varchar2) then
2990 p_rec.information208 :=
2991 ben_cpe_shd.g_old_rec.information208;
2992 End If;
2993 If (p_rec.information209 = hr_api.g_varchar2) then
2994 p_rec.information209 :=
2995 ben_cpe_shd.g_old_rec.information209;
2996 End If;
2997 If (p_rec.information210 = hr_api.g_varchar2) then
2998 p_rec.information210 :=
2999 ben_cpe_shd.g_old_rec.information210;
3000 End If;
3001 If (p_rec.information211 = hr_api.g_varchar2) then
3002 p_rec.information211 :=
3003 ben_cpe_shd.g_old_rec.information211;
3004 End If;
3005 If (p_rec.information212 = hr_api.g_varchar2) then
3006 p_rec.information212 :=
3007 ben_cpe_shd.g_old_rec.information212;
3008 End If;
3009 If (p_rec.information213 = hr_api.g_varchar2) then
3010 p_rec.information213 :=
3011 ben_cpe_shd.g_old_rec.information213;
3012 End If;
3013 If (p_rec.information214 = hr_api.g_varchar2) then
3014 p_rec.information214 :=
3015 ben_cpe_shd.g_old_rec.information214;
3016 End If;
3017 If (p_rec.information215 = hr_api.g_varchar2) then
3018 p_rec.information215 :=
3019 ben_cpe_shd.g_old_rec.information215;
3020 End If;
3021 */
3022
3023 If (p_rec.information216 = hr_api.g_varchar2) then
3024 p_rec.information216 :=
3025 ben_cpe_shd.g_old_rec.information216;
3026 End If;
3027 If (p_rec.information217 = hr_api.g_varchar2) then
3028 p_rec.information217 :=
3029 ben_cpe_shd.g_old_rec.information217;
3030 End If;
3031 If (p_rec.information218 = hr_api.g_varchar2) then
3032 p_rec.information218 :=
3033 ben_cpe_shd.g_old_rec.information218;
3034 End If;
3035 If (p_rec.information219 = hr_api.g_varchar2) then
3036 p_rec.information219 :=
3037 ben_cpe_shd.g_old_rec.information219;
3038 End If;
3039 If (p_rec.information220 = hr_api.g_varchar2) then
3040 p_rec.information220 :=
3041 ben_cpe_shd.g_old_rec.information220;
3042 End If;
3043 If (p_rec.information221 = hr_api.g_number) then
3044 p_rec.information221 :=
3045 ben_cpe_shd.g_old_rec.information221;
3046 End If;
3047 If (p_rec.information222 = hr_api.g_number) then
3048 p_rec.information222 :=
3049 ben_cpe_shd.g_old_rec.information222;
3050 End If;
3051 If (p_rec.information223 = hr_api.g_number) then
3052 p_rec.information223 :=
3053 ben_cpe_shd.g_old_rec.information223;
3054 End If;
3055 If (p_rec.information224 = hr_api.g_number) then
3056 p_rec.information224 :=
3057 ben_cpe_shd.g_old_rec.information224;
3058 End If;
3059 If (p_rec.information225 = hr_api.g_number) then
3060 p_rec.information225 :=
3061 ben_cpe_shd.g_old_rec.information225;
3062 End If;
3063 If (p_rec.information226 = hr_api.g_number) then
3064 p_rec.information226 :=
3068 p_rec.information227 :=
3065 ben_cpe_shd.g_old_rec.information226;
3066 End If;
3067 If (p_rec.information227 = hr_api.g_number) then
3069 ben_cpe_shd.g_old_rec.information227;
3070 End If;
3071 If (p_rec.information228 = hr_api.g_number) then
3072 p_rec.information228 :=
3073 ben_cpe_shd.g_old_rec.information228;
3074 End If;
3075 If (p_rec.information229 = hr_api.g_number) then
3076 p_rec.information229 :=
3077 ben_cpe_shd.g_old_rec.information229;
3078 End If;
3079 If (p_rec.information230 = hr_api.g_number) then
3080 p_rec.information230 :=
3081 ben_cpe_shd.g_old_rec.information230;
3082 End If;
3083 If (p_rec.information231 = hr_api.g_number) then
3084 p_rec.information231 :=
3085 ben_cpe_shd.g_old_rec.information231;
3086 End If;
3087 If (p_rec.information232 = hr_api.g_number) then
3088 p_rec.information232 :=
3089 ben_cpe_shd.g_old_rec.information232;
3090 End If;
3091 If (p_rec.information233 = hr_api.g_number) then
3092 p_rec.information233 :=
3093 ben_cpe_shd.g_old_rec.information233;
3094 End If;
3095 If (p_rec.information234 = hr_api.g_number) then
3096 p_rec.information234 :=
3097 ben_cpe_shd.g_old_rec.information234;
3098 End If;
3099 If (p_rec.information235 = hr_api.g_number) then
3100 p_rec.information235 :=
3101 ben_cpe_shd.g_old_rec.information235;
3102 End If;
3103 If (p_rec.information236 = hr_api.g_number) then
3104 p_rec.information236 :=
3105 ben_cpe_shd.g_old_rec.information236;
3106 End If;
3107 If (p_rec.information237 = hr_api.g_number) then
3108 p_rec.information237 :=
3109 ben_cpe_shd.g_old_rec.information237;
3110 End If;
3111 If (p_rec.information238 = hr_api.g_number) then
3112 p_rec.information238 :=
3113 ben_cpe_shd.g_old_rec.information238;
3114 End If;
3115 If (p_rec.information239 = hr_api.g_number) then
3116 p_rec.information239 :=
3117 ben_cpe_shd.g_old_rec.information239;
3118 End If;
3119 If (p_rec.information240 = hr_api.g_number) then
3120 p_rec.information240 :=
3121 ben_cpe_shd.g_old_rec.information240;
3122 End If;
3123 If (p_rec.information241 = hr_api.g_number) then
3124 p_rec.information241 :=
3125 ben_cpe_shd.g_old_rec.information241;
3126 End If;
3127 If (p_rec.information242 = hr_api.g_number) then
3128 p_rec.information242 :=
3129 ben_cpe_shd.g_old_rec.information242;
3130 End If;
3131 If (p_rec.information243 = hr_api.g_number) then
3132 p_rec.information243 :=
3133 ben_cpe_shd.g_old_rec.information243;
3134 End If;
3135 If (p_rec.information244 = hr_api.g_number) then
3136 p_rec.information244 :=
3137 ben_cpe_shd.g_old_rec.information244;
3138 End If;
3139 If (p_rec.information245 = hr_api.g_number) then
3140 p_rec.information245 :=
3141 ben_cpe_shd.g_old_rec.information245;
3142 End If;
3143 If (p_rec.information246 = hr_api.g_number) then
3144 p_rec.information246 :=
3145 ben_cpe_shd.g_old_rec.information246;
3146 End If;
3147 If (p_rec.information247 = hr_api.g_number) then
3148 p_rec.information247 :=
3149 ben_cpe_shd.g_old_rec.information247;
3150 End If;
3151 If (p_rec.information248 = hr_api.g_number) then
3152 p_rec.information248 :=
3153 ben_cpe_shd.g_old_rec.information248;
3154 End If;
3155 If (p_rec.information249 = hr_api.g_number) then
3156 p_rec.information249 :=
3157 ben_cpe_shd.g_old_rec.information249;
3158 End If;
3159 If (p_rec.information250 = hr_api.g_number) then
3160 p_rec.information250 :=
3161 ben_cpe_shd.g_old_rec.information250;
3162 End If;
3163 If (p_rec.information251 = hr_api.g_number) then
3164 p_rec.information251 :=
3165 ben_cpe_shd.g_old_rec.information251;
3166 End If;
3167 If (p_rec.information252 = hr_api.g_number) then
3168 p_rec.information252 :=
3169 ben_cpe_shd.g_old_rec.information252;
3170 End If;
3171 If (p_rec.information253 = hr_api.g_number) then
3172 p_rec.information253 :=
3173 ben_cpe_shd.g_old_rec.information253;
3174 End If;
3175 If (p_rec.information254 = hr_api.g_number) then
3176 p_rec.information254 :=
3177 ben_cpe_shd.g_old_rec.information254;
3178 End If;
3179 If (p_rec.information255 = hr_api.g_number) then
3180 p_rec.information255 :=
3181 ben_cpe_shd.g_old_rec.information255;
3182 End If;
3183 If (p_rec.information256 = hr_api.g_number) then
3184 p_rec.information256 :=
3185 ben_cpe_shd.g_old_rec.information256;
3186 End If;
3187 If (p_rec.information257 = hr_api.g_number) then
3188 p_rec.information257 :=
3189 ben_cpe_shd.g_old_rec.information257;
3190 End If;
3191 If (p_rec.information258 = hr_api.g_number) then
3192 p_rec.information258 :=
3193 ben_cpe_shd.g_old_rec.information258;
3194 End If;
3195 If (p_rec.information259 = hr_api.g_number) then
3196 p_rec.information259 :=
3197 ben_cpe_shd.g_old_rec.information259;
3198 End If;
3199 If (p_rec.information260 = hr_api.g_number) then
3200 p_rec.information260 :=
3201 ben_cpe_shd.g_old_rec.information260;
3202 End If;
3203 If (p_rec.information261 = hr_api.g_number) then
3204 p_rec.information261 :=
3205 ben_cpe_shd.g_old_rec.information261;
3206 End If;
3207 If (p_rec.information262 = hr_api.g_number) then
3208 p_rec.information262 :=
3209 ben_cpe_shd.g_old_rec.information262;
3210 End If;
3211 If (p_rec.information263 = hr_api.g_number) then
3212 p_rec.information263 :=
3213 ben_cpe_shd.g_old_rec.information263;
3214 End If;
3215 If (p_rec.information264 = hr_api.g_number) then
3216 p_rec.information264 :=
3217 ben_cpe_shd.g_old_rec.information264;
3218 End If;
3219 If (p_rec.information265 = hr_api.g_number) then
3220 p_rec.information265 :=
3221 ben_cpe_shd.g_old_rec.information265;
3222 End If;
3223 If (p_rec.information266 = hr_api.g_number) then
3224 p_rec.information266 :=
3225 ben_cpe_shd.g_old_rec.information266;
3226 End If;
3227 If (p_rec.information267 = hr_api.g_number) then
3228 p_rec.information267 :=
3229 ben_cpe_shd.g_old_rec.information267;
3230 End If;
3231 If (p_rec.information268 = hr_api.g_number) then
3232 p_rec.information268 :=
3233 ben_cpe_shd.g_old_rec.information268;
3234 End If;
3235 If (p_rec.information269 = hr_api.g_number) then
3236 p_rec.information269 :=
3237 ben_cpe_shd.g_old_rec.information269;
3238 End If;
3239 If (p_rec.information270 = hr_api.g_number) then
3240 p_rec.information270 :=
3241 ben_cpe_shd.g_old_rec.information270;
3242 End If;
3243 If (p_rec.information271 = hr_api.g_number) then
3244 p_rec.information271 :=
3245 ben_cpe_shd.g_old_rec.information271;
3246 End If;
3247 If (p_rec.information272 = hr_api.g_number) then
3248 p_rec.information272 :=
3249 ben_cpe_shd.g_old_rec.information272;
3250 End If;
3251 If (p_rec.information273 = hr_api.g_number) then
3252 p_rec.information273 :=
3253 ben_cpe_shd.g_old_rec.information273;
3254 End If;
3255 If (p_rec.information274 = hr_api.g_number) then
3256 p_rec.information274 :=
3257 ben_cpe_shd.g_old_rec.information274;
3258 End If;
3259 If (p_rec.information275 = hr_api.g_number) then
3260 p_rec.information275 :=
3261 ben_cpe_shd.g_old_rec.information275;
3262 End If;
3263 If (p_rec.information276 = hr_api.g_number) then
3264 p_rec.information276 :=
3265 ben_cpe_shd.g_old_rec.information276;
3266 End If;
3267 If (p_rec.information277 = hr_api.g_number) then
3268 p_rec.information277 :=
3269 ben_cpe_shd.g_old_rec.information277;
3270 End If;
3271 If (p_rec.information278 = hr_api.g_number) then
3272 p_rec.information278 :=
3273 ben_cpe_shd.g_old_rec.information278;
3274 End If;
3275 If (p_rec.information279 = hr_api.g_number) then
3276 p_rec.information279 :=
3277 ben_cpe_shd.g_old_rec.information279;
3278 End If;
3279 If (p_rec.information280 = hr_api.g_number) then
3280 p_rec.information280 :=
3281 ben_cpe_shd.g_old_rec.information280;
3282 End If;
3283 If (p_rec.information281 = hr_api.g_number) then
3284 p_rec.information281 :=
3285 ben_cpe_shd.g_old_rec.information281;
3286 End If;
3287 If (p_rec.information282 = hr_api.g_number) then
3288 p_rec.information282 :=
3289 ben_cpe_shd.g_old_rec.information282;
3290 End If;
3291 If (p_rec.information283 = hr_api.g_number) then
3292 p_rec.information283 :=
3293 ben_cpe_shd.g_old_rec.information283;
3294 End If;
3295 If (p_rec.information284 = hr_api.g_number) then
3296 p_rec.information284 :=
3297 ben_cpe_shd.g_old_rec.information284;
3298 End If;
3299 If (p_rec.information285 = hr_api.g_number) then
3300 p_rec.information285 :=
3301 ben_cpe_shd.g_old_rec.information285;
3302 End If;
3303 If (p_rec.information286 = hr_api.g_number) then
3304 p_rec.information286 :=
3305 ben_cpe_shd.g_old_rec.information286;
3306 End If;
3307 If (p_rec.information287 = hr_api.g_number) then
3308 p_rec.information287 :=
3309 ben_cpe_shd.g_old_rec.information287;
3310 End If;
3311 If (p_rec.information288 = hr_api.g_number) then
3312 p_rec.information288 :=
3313 ben_cpe_shd.g_old_rec.information288;
3314 End If;
3315 If (p_rec.information289 = hr_api.g_number) then
3316 p_rec.information289 :=
3317 ben_cpe_shd.g_old_rec.information289;
3318 End If;
3319 If (p_rec.information290 = hr_api.g_number) then
3320 p_rec.information290 :=
3321 ben_cpe_shd.g_old_rec.information290;
3322 End If;
3323 If (p_rec.information291 = hr_api.g_number) then
3324 p_rec.information291 :=
3325 ben_cpe_shd.g_old_rec.information291;
3326 End If;
3327 If (p_rec.information292 = hr_api.g_number) then
3328 p_rec.information292 :=
3329 ben_cpe_shd.g_old_rec.information292;
3330 End If;
3331 If (p_rec.information293 = hr_api.g_number) then
3332 p_rec.information293 :=
3333 ben_cpe_shd.g_old_rec.information293;
3334 End If;
3335 If (p_rec.information294 = hr_api.g_number) then
3336 p_rec.information294 :=
3337 ben_cpe_shd.g_old_rec.information294;
3338 End If;
3339 If (p_rec.information295 = hr_api.g_number) then
3340 p_rec.information295 :=
3341 ben_cpe_shd.g_old_rec.information295;
3342 End If;
3343 If (p_rec.information296 = hr_api.g_number) then
3344 p_rec.information296 :=
3345 ben_cpe_shd.g_old_rec.information296;
3346 End If;
3347 If (p_rec.information297 = hr_api.g_number) then
3348 p_rec.information297 :=
3349 ben_cpe_shd.g_old_rec.information297;
3350 End If;
3351 If (p_rec.information298 = hr_api.g_number) then
3352 p_rec.information298 :=
3353 ben_cpe_shd.g_old_rec.information298;
3354 End If;
3355 If (p_rec.information299 = hr_api.g_number) then
3356 p_rec.information299 :=
3357 ben_cpe_shd.g_old_rec.information299;
3358 End If;
3359 If (p_rec.information300 = hr_api.g_number) then
3360 p_rec.information300 :=
3361 ben_cpe_shd.g_old_rec.information300;
3362 End If;
3363 If (p_rec.information301 = hr_api.g_number) then
3364 p_rec.information301 :=
3365 ben_cpe_shd.g_old_rec.information301;
3366 End If;
3367 If (p_rec.information302 = hr_api.g_number) then
3368 p_rec.information302 :=
3369 ben_cpe_shd.g_old_rec.information302;
3370 End If;
3371 If (p_rec.information303 = hr_api.g_number) then
3372 p_rec.information303 :=
3373 ben_cpe_shd.g_old_rec.information303;
3374 End If;
3375 If (p_rec.information304 = hr_api.g_number) then
3376 p_rec.information304 :=
3377 ben_cpe_shd.g_old_rec.information304;
3378 End If;
3379
3380 /* Extra Reserved Columns
3381 If (p_rec.information305 = hr_api.g_number) then
3382 p_rec.information305 :=
3383 ben_cpe_shd.g_old_rec.information305;
3384 End If;
3385 */
3386
3387 If (p_rec.information306 = hr_api.g_date) then
3388 p_rec.information306 :=
3389 ben_cpe_shd.g_old_rec.information306;
3390 End If;
3391 If (p_rec.information307 = hr_api.g_date) then
3392 p_rec.information307 :=
3393 ben_cpe_shd.g_old_rec.information307;
3394 End If;
3395 If (p_rec.information308 = hr_api.g_date) then
3396 p_rec.information308 :=
3397 ben_cpe_shd.g_old_rec.information308;
3398 End If;
3399 If (p_rec.information309 = hr_api.g_date) then
3400 p_rec.information309 :=
3401 ben_cpe_shd.g_old_rec.information309;
3402 End If;
3403 If (p_rec.information310 = hr_api.g_date) then
3404 p_rec.information310 :=
3405 ben_cpe_shd.g_old_rec.information310;
3406 End If;
3407 If (p_rec.information311 = hr_api.g_date) then
3408 p_rec.information311 :=
3409 ben_cpe_shd.g_old_rec.information311;
3410 End If;
3411 If (p_rec.information312 = hr_api.g_date) then
3412 p_rec.information312 :=
3413 ben_cpe_shd.g_old_rec.information312;
3414 End If;
3415 If (p_rec.information313 = hr_api.g_date) then
3416 p_rec.information313 :=
3417 ben_cpe_shd.g_old_rec.information313;
3418 End If;
3419 If (p_rec.information314 = hr_api.g_date) then
3420 p_rec.information314 :=
3421 ben_cpe_shd.g_old_rec.information314;
3422 End If;
3423 If (p_rec.information315 = hr_api.g_date) then
3424 p_rec.information315 :=
3425 ben_cpe_shd.g_old_rec.information315;
3426 End If;
3427 If (p_rec.information316 = hr_api.g_date) then
3428 p_rec.information316 :=
3429 ben_cpe_shd.g_old_rec.information316;
3430 End If;
3431 If (p_rec.information317 = hr_api.g_date) then
3432 p_rec.information317 :=
3433 ben_cpe_shd.g_old_rec.information317;
3434 End If;
3435 If (p_rec.information318 = hr_api.g_date) then
3436 p_rec.information318 :=
3437 ben_cpe_shd.g_old_rec.information318;
3438 End If;
3439 If (p_rec.information319 = hr_api.g_date) then
3440 p_rec.information319 :=
3441 ben_cpe_shd.g_old_rec.information319;
3442 End If;
3443 If (p_rec.information320 = hr_api.g_date) then
3444 p_rec.information320 :=
3445 ben_cpe_shd.g_old_rec.information320;
3446 End If;
3447
3448 /* Extra Reserved Columns
3449 If (p_rec.information321 = hr_api.g_date) then
3450 p_rec.information321 :=
3451 ben_cpe_shd.g_old_rec.information321;
3452 End If;
3453 If (p_rec.information322 = hr_api.g_date) then
3454 p_rec.information322 :=
3455 ben_cpe_shd.g_old_rec.information322;
3456 End If;
3457 */
3458
3459 /*
3460 If (p_rec.information323 = hr_api.g_long) then
3461 p_rec.information323 :=
3462 ben_cpe_shd.g_old_rec.information323;
3463 End If;
3464 */
3465 If (p_rec.datetrack_mode = hr_api.g_varchar2) then
3466 p_rec.datetrack_mode :=
3467 ben_cpe_shd.g_old_rec.datetrack_mode;
3468 End If;
3469 --
3470 End convert_defs;
3471 --
3472 -- ----------------------------------------------------------------------------
3473 -- |---------------------------------< upd >----------------------------------|
3474 -- ----------------------------------------------------------------------------
3475 Procedure upd
3476 (p_effective_date in date
3477 ,p_rec in out nocopy ben_cpe_shd.g_rec_type
3478 ) is
3479 --
3480 l_proc varchar2(72) := g_package||'upd';
3481 --
3482 Begin
3483 hr_utility.set_location('Entering:'||l_proc, 5);
3484 --
3485 -- We must lock the row which we need to update.
3486 --
3487 ben_cpe_shd.lck
3488 (p_rec.copy_entity_result_id
3489 ,p_rec.object_version_number
3490 );
3491 --
3492 -- 1. During an update system defaults are used to determine if
3493 -- arguments have been defaulted or not. We must therefore
3494 -- derive the full record structure values to be updated.
3495 --
3496 -- 2. Call the supporting update validate operations.
3497 --
3498 convert_defs(p_rec);
3499 ben_cpe_bus.update_validate
3500 (p_effective_date
3501 ,p_rec
3502 );
3503 --
3504 -- Call to raise any errors on multi-message list
3505 hr_multi_message.end_validation_set;
3506 --
3507 -- Call the supporting pre-update operation
3508 --
3509 ben_cpe_upd.pre_update(p_rec);
3510 --
3511 -- Update the row.
3512 --
3513 ben_cpe_upd.update_dml(p_rec);
3514 --
3515 -- Call the supporting post-update operation
3516 --
3517 ben_cpe_upd.post_update
3518 (p_effective_date
3519 ,p_rec
3520 );
3521 --
3522 -- Call to raise any errors on multi-message list
3523 hr_multi_message.end_validation_set;
3524 End upd;
3525 --
3526 -- ----------------------------------------------------------------------------
3527 -- |---------------------------------< upd >----------------------------------|
3528 -- ----------------------------------------------------------------------------
3529 Procedure upd
3530 (p_effective_date in date
3531 ,p_copy_entity_result_id in number
3532 ,p_object_version_number in out nocopy number
3533 ,p_copy_entity_txn_id in number default hr_api.g_number
3534 ,p_result_type_cd in varchar2 default hr_api.g_varchar2
3535 ,p_src_copy_entity_result_id in number default hr_api.g_number
3536 ,p_number_of_copies in number default hr_api.g_number
3537 ,p_mirror_entity_result_id in number default hr_api.g_number
3538 ,p_mirror_src_entity_result_id in number default hr_api.g_number
3539 ,p_parent_entity_result_id in number default hr_api.g_number
3540 ,p_pd_mr_src_entity_result_id in number default hr_api.g_number
3541 ,p_pd_parent_entity_result_id in number default hr_api.g_number
3542 ,p_gs_mr_src_entity_result_id in number default hr_api.g_number
3543 ,p_gs_parent_entity_result_id in number default hr_api.g_number
3544 ,p_table_name in varchar2 default hr_api.g_varchar2
3545 ,p_table_alias in varchar2 default hr_api.g_varchar2
3546 ,p_table_route_id in number default hr_api.g_number
3547 ,p_status in varchar2 default hr_api.g_varchar2
3548 ,p_dml_operation in varchar2 default hr_api.g_varchar2
3549 ,p_information_category in varchar2 default hr_api.g_varchar2
3550 ,p_information1 in number default hr_api.g_number
3551 ,p_information2 in date default hr_api.g_date
3552 ,p_information3 in date default hr_api.g_date
3553 ,p_information4 in number default hr_api.g_number
3554 ,p_information5 in varchar2 default hr_api.g_varchar2
3555 ,p_information6 in varchar2 default hr_api.g_varchar2
3556 ,p_information7 in varchar2 default hr_api.g_varchar2
3557 ,p_information8 in varchar2 default hr_api.g_varchar2
3558 ,p_information9 in varchar2 default hr_api.g_varchar2
3559 ,p_information10 in date default hr_api.g_date
3560 ,p_information11 in varchar2 default hr_api.g_varchar2
3561 ,p_information12 in varchar2 default hr_api.g_varchar2
3562 ,p_information13 in varchar2 default hr_api.g_varchar2
3563 ,p_information14 in varchar2 default hr_api.g_varchar2
3564 ,p_information15 in varchar2 default hr_api.g_varchar2
3565 ,p_information16 in varchar2 default hr_api.g_varchar2
3566 ,p_information17 in varchar2 default hr_api.g_varchar2
3567 ,p_information18 in varchar2 default hr_api.g_varchar2
3568 ,p_information19 in varchar2 default hr_api.g_varchar2
3569 ,p_information20 in varchar2 default hr_api.g_varchar2
3570 ,p_information21 in varchar2 default hr_api.g_varchar2
3571 ,p_information22 in varchar2 default hr_api.g_varchar2
3572 ,p_information23 in varchar2 default hr_api.g_varchar2
3573 ,p_information24 in varchar2 default hr_api.g_varchar2
3574 ,p_information25 in varchar2 default hr_api.g_varchar2
3575 ,p_information26 in varchar2 default hr_api.g_varchar2
3576 ,p_information27 in varchar2 default hr_api.g_varchar2
3577 ,p_information28 in varchar2 default hr_api.g_varchar2
3578 ,p_information29 in varchar2 default hr_api.g_varchar2
3579 ,p_information30 in varchar2 default hr_api.g_varchar2
3580 ,p_information31 in varchar2 default hr_api.g_varchar2
3581 ,p_information32 in varchar2 default hr_api.g_varchar2
3582 ,p_information33 in varchar2 default hr_api.g_varchar2
3583 ,p_information34 in varchar2 default hr_api.g_varchar2
3584 ,p_information35 in varchar2 default hr_api.g_varchar2
3585 ,p_information36 in varchar2 default hr_api.g_varchar2
3586 ,p_information37 in varchar2 default hr_api.g_varchar2
3587 ,p_information38 in varchar2 default hr_api.g_varchar2
3588 ,p_information39 in varchar2 default hr_api.g_varchar2
3589 ,p_information40 in varchar2 default hr_api.g_varchar2
3590 ,p_information41 in varchar2 default hr_api.g_varchar2
3591 ,p_information42 in varchar2 default hr_api.g_varchar2
3592 ,p_information43 in varchar2 default hr_api.g_varchar2
3593 ,p_information44 in varchar2 default hr_api.g_varchar2
3594 ,p_information45 in varchar2 default hr_api.g_varchar2
3595 ,p_information46 in varchar2 default hr_api.g_varchar2
3596 ,p_information47 in varchar2 default hr_api.g_varchar2
3597 ,p_information48 in varchar2 default hr_api.g_varchar2
3598 ,p_information49 in varchar2 default hr_api.g_varchar2
3599 ,p_information50 in varchar2 default hr_api.g_varchar2
3600 ,p_information51 in varchar2 default hr_api.g_varchar2
3601 ,p_information52 in varchar2 default hr_api.g_varchar2
3602 ,p_information53 in varchar2 default hr_api.g_varchar2
3603 ,p_information54 in varchar2 default hr_api.g_varchar2
3604 ,p_information55 in varchar2 default hr_api.g_varchar2
3605 ,p_information56 in varchar2 default hr_api.g_varchar2
3606 ,p_information57 in varchar2 default hr_api.g_varchar2
3607 ,p_information58 in varchar2 default hr_api.g_varchar2
3608 ,p_information59 in varchar2 default hr_api.g_varchar2
3609 ,p_information60 in varchar2 default hr_api.g_varchar2
3610 ,p_information61 in varchar2 default hr_api.g_varchar2
3611 ,p_information62 in varchar2 default hr_api.g_varchar2
3612 ,p_information63 in varchar2 default hr_api.g_varchar2
3613 ,p_information64 in varchar2 default hr_api.g_varchar2
3614 ,p_information65 in varchar2 default hr_api.g_varchar2
3615 ,p_information66 in varchar2 default hr_api.g_varchar2
3616 ,p_information67 in varchar2 default hr_api.g_varchar2
3617 ,p_information68 in varchar2 default hr_api.g_varchar2
3618 ,p_information69 in varchar2 default hr_api.g_varchar2
3619 ,p_information70 in varchar2 default hr_api.g_varchar2
3620 ,p_information71 in varchar2 default hr_api.g_varchar2
3621 ,p_information72 in varchar2 default hr_api.g_varchar2
3622 ,p_information73 in varchar2 default hr_api.g_varchar2
3623 ,p_information74 in varchar2 default hr_api.g_varchar2
3624 ,p_information75 in varchar2 default hr_api.g_varchar2
3625 ,p_information76 in varchar2 default hr_api.g_varchar2
3626 ,p_information77 in varchar2 default hr_api.g_varchar2
3627 ,p_information78 in varchar2 default hr_api.g_varchar2
3628 ,p_information79 in varchar2 default hr_api.g_varchar2
3629 ,p_information80 in varchar2 default hr_api.g_varchar2
3630 ,p_information81 in varchar2 default hr_api.g_varchar2
3631 ,p_information82 in varchar2 default hr_api.g_varchar2
3632 ,p_information83 in varchar2 default hr_api.g_varchar2
3633 ,p_information84 in varchar2 default hr_api.g_varchar2
3634 ,p_information85 in varchar2 default hr_api.g_varchar2
3635 ,p_information86 in varchar2 default hr_api.g_varchar2
3636 ,p_information87 in varchar2 default hr_api.g_varchar2
3637 ,p_information88 in varchar2 default hr_api.g_varchar2
3638 ,p_information89 in varchar2 default hr_api.g_varchar2
3639 ,p_information90 in varchar2 default hr_api.g_varchar2
3640 ,p_information91 in varchar2 default hr_api.g_varchar2
3641 ,p_information92 in varchar2 default hr_api.g_varchar2
3642 ,p_information93 in varchar2 default hr_api.g_varchar2
3643 ,p_information94 in varchar2 default hr_api.g_varchar2
3644 ,p_information95 in varchar2 default hr_api.g_varchar2
3645 ,p_information96 in varchar2 default hr_api.g_varchar2
3646 ,p_information97 in varchar2 default hr_api.g_varchar2
3647 ,p_information98 in varchar2 default hr_api.g_varchar2
3648 ,p_information99 in varchar2 default hr_api.g_varchar2
3649 ,p_information100 in varchar2 default hr_api.g_varchar2
3650 ,p_information101 in varchar2 default hr_api.g_varchar2
3651 ,p_information102 in varchar2 default hr_api.g_varchar2
3652 ,p_information103 in varchar2 default hr_api.g_varchar2
3653 ,p_information104 in varchar2 default hr_api.g_varchar2
3654 ,p_information105 in varchar2 default hr_api.g_varchar2
3658 ,p_information109 in varchar2 default hr_api.g_varchar2
3655 ,p_information106 in varchar2 default hr_api.g_varchar2
3656 ,p_information107 in varchar2 default hr_api.g_varchar2
3657 ,p_information108 in varchar2 default hr_api.g_varchar2
3659 ,p_information110 in varchar2 default hr_api.g_varchar2
3660 ,p_information111 in varchar2 default hr_api.g_varchar2
3661 ,p_information112 in varchar2 default hr_api.g_varchar2
3662 ,p_information113 in varchar2 default hr_api.g_varchar2
3663 ,p_information114 in varchar2 default hr_api.g_varchar2
3664 ,p_information115 in varchar2 default hr_api.g_varchar2
3665 ,p_information116 in varchar2 default hr_api.g_varchar2
3666 ,p_information117 in varchar2 default hr_api.g_varchar2
3667 ,p_information118 in varchar2 default hr_api.g_varchar2
3668 ,p_information119 in varchar2 default hr_api.g_varchar2
3669 ,p_information120 in varchar2 default hr_api.g_varchar2
3670 ,p_information121 in varchar2 default hr_api.g_varchar2
3671 ,p_information122 in varchar2 default hr_api.g_varchar2
3672 ,p_information123 in varchar2 default hr_api.g_varchar2
3673 ,p_information124 in varchar2 default hr_api.g_varchar2
3674 ,p_information125 in varchar2 default hr_api.g_varchar2
3675 ,p_information126 in varchar2 default hr_api.g_varchar2
3676 ,p_information127 in varchar2 default hr_api.g_varchar2
3677 ,p_information128 in varchar2 default hr_api.g_varchar2
3678 ,p_information129 in varchar2 default hr_api.g_varchar2
3679 ,p_information130 in varchar2 default hr_api.g_varchar2
3680 ,p_information131 in varchar2 default hr_api.g_varchar2
3681 ,p_information132 in varchar2 default hr_api.g_varchar2
3682 ,p_information133 in varchar2 default hr_api.g_varchar2
3683 ,p_information134 in varchar2 default hr_api.g_varchar2
3684 ,p_information135 in varchar2 default hr_api.g_varchar2
3685 ,p_information136 in varchar2 default hr_api.g_varchar2
3686 ,p_information137 in varchar2 default hr_api.g_varchar2
3687 ,p_information138 in varchar2 default hr_api.g_varchar2
3688 ,p_information139 in varchar2 default hr_api.g_varchar2
3689 ,p_information140 in varchar2 default hr_api.g_varchar2
3690 ,p_information141 in varchar2 default hr_api.g_varchar2
3691 ,p_information142 in varchar2 default hr_api.g_varchar2
3692
3693 /* Extra Reserved Columns
3694 ,p_information143 in varchar2 default hr_api.g_varchar2
3695 ,p_information144 in varchar2 default hr_api.g_varchar2
3696 ,p_information145 in varchar2 default hr_api.g_varchar2
3697 ,p_information146 in varchar2 default hr_api.g_varchar2
3698 ,p_information147 in varchar2 default hr_api.g_varchar2
3699 ,p_information148 in varchar2 default hr_api.g_varchar2
3700 ,p_information149 in varchar2 default hr_api.g_varchar2
3701 ,p_information150 in varchar2 default hr_api.g_varchar2
3702 */
3703 ,p_information151 in varchar2 default hr_api.g_varchar2
3704 ,p_information152 in varchar2 default hr_api.g_varchar2
3705 ,p_information153 in varchar2 default hr_api.g_varchar2
3706
3707 /* Extra Reserved Columns
3708 ,p_information154 in varchar2 default hr_api.g_varchar2
3709 ,p_information155 in varchar2 default hr_api.g_varchar2
3710 ,p_information156 in varchar2 default hr_api.g_varchar2
3711 ,p_information157 in varchar2 default hr_api.g_varchar2
3712 ,p_information158 in varchar2 default hr_api.g_varchar2
3713 ,p_information159 in varchar2 default hr_api.g_varchar2
3714 */
3715 ,p_information160 in number default hr_api.g_number
3716 ,p_information161 in number default hr_api.g_number
3717 ,p_information162 in number default hr_api.g_number
3718
3719 /* Extra Reserved Columns
3720 ,p_information163 in number default hr_api.g_number
3721 ,p_information164 in number default hr_api.g_number
3722 ,p_information165 in number default hr_api.g_number
3723 */
3724 ,p_information166 in date default hr_api.g_date
3725 ,p_information167 in date default hr_api.g_date
3726 ,p_information168 in date default hr_api.g_date
3727 ,p_information169 in number default hr_api.g_number
3728 ,p_information170 in varchar2 default hr_api.g_varchar2
3729
3730 /* Extra Reserved Columns
3731 ,p_information171 in varchar2 default hr_api.g_varchar2
3732 ,p_information172 in varchar2 default hr_api.g_varchar2
3733 */
3734 ,p_information173 in varchar2 default hr_api.g_varchar2
3735 ,p_information174 in number default hr_api.g_number
3736 ,p_information175 in varchar2 default hr_api.g_varchar2
3737 ,p_information176 in number default hr_api.g_number
3738 ,p_information177 in varchar2 default hr_api.g_varchar2
3739 ,p_information178 in number default hr_api.g_number
3740 ,p_information179 in varchar2 default hr_api.g_varchar2
3741 ,p_information180 in number default hr_api.g_number
3742 ,p_information181 in varchar2 default hr_api.g_varchar2
3746 ,p_information183 in varchar2 default hr_api.g_varchar2
3743 ,p_information182 in varchar2 default hr_api.g_varchar2
3744
3745 /* Extra Reserved Columns
3747 ,p_information184 in varchar2 default hr_api.g_varchar2
3748 */
3749 ,p_information185 in varchar2 default hr_api.g_varchar2
3750 ,p_information186 in varchar2 default hr_api.g_varchar2
3751 ,p_information187 in varchar2 default hr_api.g_varchar2
3752 ,p_information188 in varchar2 default hr_api.g_varchar2
3753
3754 /* Extra Reserved Columns
3755 ,p_information189 in varchar2 default hr_api.g_varchar2
3756 */
3757 ,p_information190 in varchar2 default hr_api.g_varchar2
3758 ,p_information191 in varchar2 default hr_api.g_varchar2
3759 ,p_information192 in varchar2 default hr_api.g_varchar2
3760 ,p_information193 in varchar2 default hr_api.g_varchar2
3761 ,p_information194 in varchar2 default hr_api.g_varchar2
3762 ,p_information195 in varchar2 default hr_api.g_varchar2
3763 ,p_information196 in varchar2 default hr_api.g_varchar2
3764 ,p_information197 in varchar2 default hr_api.g_varchar2
3765 ,p_information198 in varchar2 default hr_api.g_varchar2
3766 ,p_information199 in varchar2 default hr_api.g_varchar2
3767
3768 /* Extra Reserved Columns
3769 ,p_information200 in varchar2 default hr_api.g_varchar2
3770 ,p_information201 in varchar2 default hr_api.g_varchar2
3771 ,p_information202 in varchar2 default hr_api.g_varchar2
3772 ,p_information203 in varchar2 default hr_api.g_varchar2
3773 ,p_information204 in varchar2 default hr_api.g_varchar2
3774 ,p_information205 in varchar2 default hr_api.g_varchar2
3775 ,p_information206 in varchar2 default hr_api.g_varchar2
3776 ,p_information207 in varchar2 default hr_api.g_varchar2
3777 ,p_information208 in varchar2 default hr_api.g_varchar2
3778 ,p_information209 in varchar2 default hr_api.g_varchar2
3779 ,p_information210 in varchar2 default hr_api.g_varchar2
3780 ,p_information211 in varchar2 default hr_api.g_varchar2
3781 ,p_information212 in varchar2 default hr_api.g_varchar2
3782 ,p_information213 in varchar2 default hr_api.g_varchar2
3783 ,p_information214 in varchar2 default hr_api.g_varchar2
3784 ,p_information215 in varchar2 default hr_api.g_varchar2
3785 */
3786 ,p_information216 in varchar2 default hr_api.g_varchar2
3787 ,p_information217 in varchar2 default hr_api.g_varchar2
3788 ,p_information218 in varchar2 default hr_api.g_varchar2
3789 ,p_information219 in varchar2 default hr_api.g_varchar2
3790 ,p_information220 in varchar2 default hr_api.g_varchar2
3791 ,p_information221 in number default hr_api.g_number
3792 ,p_information222 in number default hr_api.g_number
3793 ,p_information223 in number default hr_api.g_number
3794 ,p_information224 in number default hr_api.g_number
3795 ,p_information225 in number default hr_api.g_number
3796 ,p_information226 in number default hr_api.g_number
3797 ,p_information227 in number default hr_api.g_number
3798 ,p_information228 in number default hr_api.g_number
3799 ,p_information229 in number default hr_api.g_number
3800 ,p_information230 in number default hr_api.g_number
3801 ,p_information231 in number default hr_api.g_number
3802 ,p_information232 in number default hr_api.g_number
3803 ,p_information233 in number default hr_api.g_number
3804 ,p_information234 in number default hr_api.g_number
3805 ,p_information235 in number default hr_api.g_number
3806 ,p_information236 in number default hr_api.g_number
3807 ,p_information237 in number default hr_api.g_number
3808 ,p_information238 in number default hr_api.g_number
3809 ,p_information239 in number default hr_api.g_number
3810 ,p_information240 in number default hr_api.g_number
3811 ,p_information241 in number default hr_api.g_number
3812 ,p_information242 in number default hr_api.g_number
3813 ,p_information243 in number default hr_api.g_number
3814 ,p_information244 in number default hr_api.g_number
3815 ,p_information245 in number default hr_api.g_number
3816 ,p_information246 in number default hr_api.g_number
3817 ,p_information247 in number default hr_api.g_number
3818 ,p_information248 in number default hr_api.g_number
3819 ,p_information249 in number default hr_api.g_number
3820 ,p_information250 in number default hr_api.g_number
3821 ,p_information251 in number default hr_api.g_number
3822 ,p_information252 in number default hr_api.g_number
3823 ,p_information253 in number default hr_api.g_number
3824 ,p_information254 in number default hr_api.g_number
3825 ,p_information255 in number default hr_api.g_number
3826 ,p_information256 in number default hr_api.g_number
3830 ,p_information260 in number default hr_api.g_number
3827 ,p_information257 in number default hr_api.g_number
3828 ,p_information258 in number default hr_api.g_number
3829 ,p_information259 in number default hr_api.g_number
3831 ,p_information261 in number default hr_api.g_number
3832 ,p_information262 in number default hr_api.g_number
3833 ,p_information263 in number default hr_api.g_number
3834 ,p_information264 in number default hr_api.g_number
3835 ,p_information265 in number default hr_api.g_number
3836 ,p_information266 in number default hr_api.g_number
3837 ,p_information267 in number default hr_api.g_number
3838 ,p_information268 in number default hr_api.g_number
3839 ,p_information269 in number default hr_api.g_number
3840 ,p_information270 in number default hr_api.g_number
3841 ,p_information271 in number default hr_api.g_number
3842 ,p_information272 in number default hr_api.g_number
3843 ,p_information273 in number default hr_api.g_number
3844 ,p_information274 in number default hr_api.g_number
3845 ,p_information275 in number default hr_api.g_number
3846 ,p_information276 in number default hr_api.g_number
3847 ,p_information277 in number default hr_api.g_number
3848 ,p_information278 in number default hr_api.g_number
3849 ,p_information279 in number default hr_api.g_number
3850 ,p_information280 in number default hr_api.g_number
3851 ,p_information281 in number default hr_api.g_number
3852 ,p_information282 in number default hr_api.g_number
3853 ,p_information283 in number default hr_api.g_number
3854 ,p_information284 in number default hr_api.g_number
3855 ,p_information285 in number default hr_api.g_number
3856 ,p_information286 in number default hr_api.g_number
3857 ,p_information287 in number default hr_api.g_number
3858 ,p_information288 in number default hr_api.g_number
3859 ,p_information289 in number default hr_api.g_number
3860 ,p_information290 in number default hr_api.g_number
3861 ,p_information291 in number default hr_api.g_number
3862 ,p_information292 in number default hr_api.g_number
3863 ,p_information293 in number default hr_api.g_number
3864 ,p_information294 in number default hr_api.g_number
3865 ,p_information295 in number default hr_api.g_number
3866 ,p_information296 in number default hr_api.g_number
3867 ,p_information297 in number default hr_api.g_number
3868 ,p_information298 in number default hr_api.g_number
3869 ,p_information299 in number default hr_api.g_number
3870 ,p_information300 in number default hr_api.g_number
3871 ,p_information301 in number default hr_api.g_number
3872 ,p_information302 in number default hr_api.g_number
3873 ,p_information303 in number default hr_api.g_number
3874 ,p_information304 in number default hr_api.g_number
3875
3876 /* Extra Reserved Columns
3877 ,p_information305 in number default hr_api.g_number
3878 */
3879 ,p_information306 in date default hr_api.g_date
3880 ,p_information307 in date default hr_api.g_date
3881 ,p_information308 in date default hr_api.g_date
3882 ,p_information309 in date default hr_api.g_date
3883 ,p_information310 in date default hr_api.g_date
3884 ,p_information311 in date default hr_api.g_date
3885 ,p_information312 in date default hr_api.g_date
3886 ,p_information313 in date default hr_api.g_date
3887 ,p_information314 in date default hr_api.g_date
3888 ,p_information315 in date default hr_api.g_date
3889 ,p_information316 in date default hr_api.g_date
3890 ,p_information317 in date default hr_api.g_date
3891 ,p_information318 in date default hr_api.g_date
3892 ,p_information319 in date default hr_api.g_date
3893 ,p_information320 in date default hr_api.g_date
3894
3895 /* Extra Reserved Columns
3896 ,p_information321 in date default hr_api.g_date
3897 ,p_information322 in date default hr_api.g_date
3898 */
3899 ,p_information323 in long
3900 ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
3901 ) is
3902 --
3903 l_rec ben_cpe_shd.g_rec_type;
3904 l_proc varchar2(72) := g_package||'upd';
3905 --
3906 Begin
3907 hr_utility.set_location('Entering:'||l_proc, 5);
3908 --
3909 -- Call conversion function to turn arguments into the
3910 -- l_rec structure.
3911 --
3912 l_rec :=
3913 ben_cpe_shd.convert_args
3914 (p_copy_entity_result_id
3915 ,p_copy_entity_txn_id
3916 ,p_src_copy_entity_result_id
3917 ,p_result_type_cd
3918 ,p_number_of_copies
3919 ,p_mirror_entity_result_id
3920 ,p_mirror_src_entity_result_id
3921 ,p_parent_entity_result_id
3922 ,p_pd_mr_src_entity_result_id
3923 ,p_pd_parent_entity_result_id
3924 ,p_gs_mr_src_entity_result_id
3925 ,p_gs_parent_entity_result_id
3926 ,p_table_name
3927 ,p_table_alias
3928 ,p_table_route_id
3929 ,p_status
3930 ,p_dml_operation
3931 ,p_information_category
3932 ,p_information1
3933 ,p_information2
3934 ,p_information3
3935 ,p_information4
3936 ,p_information5
3937 ,p_information6
3938 ,p_information7
3939 ,p_information8
3940 ,p_information9
3941 ,p_information10
3942 ,p_information11
3943 ,p_information12
3944 ,p_information13
3945 ,p_information14
3946 ,p_information15
3947 ,p_information16
3948 ,p_information17
3949 ,p_information18
3950 ,p_information19
3951 ,p_information20
3952 ,p_information21
3953 ,p_information22
3954 ,p_information23
3955 ,p_information24
3956 ,p_information25
3957 ,p_information26
3958 ,p_information27
3959 ,p_information28
3960 ,p_information29
3961 ,p_information30
3962 ,p_information31
3963 ,p_information32
3964 ,p_information33
3965 ,p_information34
3966 ,p_information35
3967 ,p_information36
3968 ,p_information37
3969 ,p_information38
3970 ,p_information39
3971 ,p_information40
3972 ,p_information41
3973 ,p_information42
3974 ,p_information43
3975 ,p_information44
3976 ,p_information45
3977 ,p_information46
3978 ,p_information47
3979 ,p_information48
3980 ,p_information49
3981 ,p_information50
3982 ,p_information51
3983 ,p_information52
3984 ,p_information53
3985 ,p_information54
3986 ,p_information55
3987 ,p_information56
3988 ,p_information57
3989 ,p_information58
3990 ,p_information59
3991 ,p_information60
3992 ,p_information61
3993 ,p_information62
3994 ,p_information63
3995 ,p_information64
3996 ,p_information65
3997 ,p_information66
3998 ,p_information67
3999 ,p_information68
4000 ,p_information69
4001 ,p_information70
4002 ,p_information71
4003 ,p_information72
4004 ,p_information73
4005 ,p_information74
4006 ,p_information75
4007 ,p_information76
4008 ,p_information77
4009 ,p_information78
4010 ,p_information79
4011 ,p_information80
4012 ,p_information81
4013 ,p_information82
4014 ,p_information83
4015 ,p_information84
4016 ,p_information85
4017 ,p_information86
4018 ,p_information87
4019 ,p_information88
4020 ,p_information89
4021 ,p_information90
4022 ,p_information91
4023 ,p_information92
4024 ,p_information93
4025 ,p_information94
4026 ,p_information95
4027 ,p_information96
4028 ,p_information97
4029 ,p_information98
4030 ,p_information99
4031 ,p_information100
4032 ,p_information101
4033 ,p_information102
4034 ,p_information103
4035 ,p_information104
4036 ,p_information105
4037 ,p_information106
4038 ,p_information107
4039 ,p_information108
4040 ,p_information109
4041 ,p_information110
4042 ,p_information111
4043 ,p_information112
4044 ,p_information113
4045 ,p_information114
4046 ,p_information115
4047 ,p_information116
4048 ,p_information117
4049 ,p_information118
4050 ,p_information119
4051 ,p_information120
4052 ,p_information121
4053 ,p_information122
4054 ,p_information123
4055 ,p_information124
4056 ,p_information125
4057 ,p_information126
4058 ,p_information127
4059 ,p_information128
4060 ,p_information129
4061 ,p_information130
4062 ,p_information131
4063 ,p_information132
4064 ,p_information133
4065 ,p_information134
4066 ,p_information135
4067 ,p_information136
4068 ,p_information137
4069 ,p_information138
4070 ,p_information139
4071 ,p_information140
4072 ,p_information141
4073 ,p_information142
4074
4075 /* Extra Reserved Columns
4076 ,p_information143
4077 ,p_information144
4078 ,p_information145
4079 ,p_information146
4080 ,p_information147
4081 ,p_information148
4082 ,p_information149
4083 ,p_information150
4084 */
4085 ,p_information151
4086 ,p_information152
4087 ,p_information153
4088
4089 /* Extra Reserved Columns
4090 ,p_information154
4091 ,p_information155
4092 ,p_information156
4093 ,p_information157
4094 ,p_information158
4095 ,p_information159
4096 */
4097 ,p_information160
4098 ,p_information161
4099 ,p_information162
4100
4101 /* Extra Reserved Columns
4102 ,p_information163
4103 ,p_information164
4104 ,p_information165
4105 */
4106 ,p_information166
4107 ,p_information167
4108 ,p_information168
4109 ,p_information169
4110 ,p_information170
4111
4112 /* Extra Reserved Columns
4113 ,p_information171
4114 ,p_information172
4115 */
4116 ,p_information173
4117 ,p_information174
4118 ,p_information175
4119 ,p_information176
4120 ,p_information177
4121 ,p_information178
4122 ,p_information179
4123 ,p_information180
4124 ,p_information181
4125 ,p_information182
4126
4127 /* Extra Reserved Columns
4128 ,p_information183
4129 ,p_information184
4130 */
4131 ,p_information185
4132 ,p_information186
4133 ,p_information187
4134 ,p_information188
4135
4136 /* Extra Reserved Columns
4137 ,p_information189
4138 */
4139 ,p_information190
4140 ,p_information191
4141 ,p_information192
4142 ,p_information193
4143 ,p_information194
4144 ,p_information195
4145 ,p_information196
4146 ,p_information197
4147 ,p_information198
4148 ,p_information199
4149
4150 /* Extra Reserved Columns
4151 ,p_information200
4152 ,p_information201
4153 ,p_information202
4154 ,p_information203
4155 ,p_information204
4156 ,p_information205
4157 ,p_information206
4158 ,p_information207
4159 ,p_information208
4160 ,p_information209
4161 ,p_information210
4162 ,p_information211
4163 ,p_information212
4164 ,p_information213
4165 ,p_information214
4166 ,p_information215
4167 */
4168 ,p_information216
4169 ,p_information217
4170 ,p_information218
4171 ,p_information219
4172 ,p_information220
4173 ,p_information221
4174 ,p_information222
4175 ,p_information223
4176 ,p_information224
4177 ,p_information225
4178 ,p_information226
4179 ,p_information227
4180 ,p_information228
4181 ,p_information229
4182 ,p_information230
4183 ,p_information231
4184 ,p_information232
4185 ,p_information233
4186 ,p_information234
4187 ,p_information235
4188 ,p_information236
4189 ,p_information237
4190 ,p_information238
4191 ,p_information239
4192 ,p_information240
4193 ,p_information241
4194 ,p_information242
4195 ,p_information243
4196 ,p_information244
4197 ,p_information245
4198 ,p_information246
4199 ,p_information247
4200 ,p_information248
4201 ,p_information249
4202 ,p_information250
4203 ,p_information251
4204 ,p_information252
4205 ,p_information253
4206 ,p_information254
4207 ,p_information255
4208 ,p_information256
4209 ,p_information257
4210 ,p_information258
4211 ,p_information259
4212 ,p_information260
4213 ,p_information261
4214 ,p_information262
4215 ,p_information263
4216 ,p_information264
4217 ,p_information265
4218 ,p_information266
4219 ,p_information267
4220 ,p_information268
4221 ,p_information269
4222 ,p_information270
4223 ,p_information271
4224 ,p_information272
4225 ,p_information273
4226 ,p_information274
4227 ,p_information275
4228 ,p_information276
4229 ,p_information277
4230 ,p_information278
4231 ,p_information279
4232 ,p_information280
4233 ,p_information281
4234 ,p_information282
4235 ,p_information283
4236 ,p_information284
4237 ,p_information285
4238 ,p_information286
4239 ,p_information287
4240 ,p_information288
4241 ,p_information289
4242 ,p_information290
4243 ,p_information291
4244 ,p_information292
4245 ,p_information293
4246 ,p_information294
4247 ,p_information295
4248 ,p_information296
4249 ,p_information297
4250 ,p_information298
4251 ,p_information299
4252 ,p_information300
4253 ,p_information301
4254 ,p_information302
4255 ,p_information303
4256 ,p_information304
4257
4258 /* Extra Reserved Columns
4259 ,p_information305
4260 */
4261 ,p_information306
4262 ,p_information307
4263 ,p_information308
4264 ,p_information309
4265 ,p_information310
4266 ,p_information311
4267 ,p_information312
4268 ,p_information313
4269 ,p_information314
4270 ,p_information315
4271 ,p_information316
4272 ,p_information317
4273 ,p_information318
4274 ,p_information319
4275 ,p_information320
4276
4277 /* Extra Reserved Columns
4278 ,p_information321
4279 ,p_information322
4280 */
4281 ,p_information323
4282 ,p_datetrack_mode
4283 ,p_object_version_number
4284 );
4285 --
4286 -- Having converted the arguments into the
4287 -- plsql record structure we call the corresponding record
4288 -- business process.
4289 --
4290 ben_cpe_upd.upd
4291 (p_effective_date
4292 ,l_rec
4293 );
4294 p_object_version_number := l_rec.object_version_number;
4295 --
4296 hr_utility.set_location(' Leaving:'||l_proc, 10);
4297 End upd;
4298 --
4299 end ben_cpe_upd;