1 Package ben_cpe_shd AUTHID CURRENT_USER as
2 /* $Header: becperhi.pkh 120.0.12020000.2 2013/03/05 06:37:43 amnaraya ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Record Type Specification |
6 -- ----------------------------------------------------------------------------
7 --
8 Type g_rec_type Is Record
9 (copy_entity_result_id number(15)
10 ,copy_entity_txn_id number(15)
11 ,src_copy_entity_result_id number(15)
12 ,result_type_cd varchar2(30)
13 ,number_of_copies number(10)
14 ,mirror_entity_result_id number(15)
15 ,mirror_src_entity_result_id number(15)
16 ,parent_entity_result_id number(15)
17 ,pd_mirror_src_entity_result_id number(15)
18 ,pd_parent_entity_result_id number(15)
19 ,gs_mirror_src_entity_result_id number(15)
20 ,gs_parent_entity_result_id number(15)
21 ,table_name varchar2(30)
22 ,table_alias varchar2(30)
23 ,table_route_id number(15)
24 ,status varchar2(30)
25 ,dml_operation varchar2(30)
26 ,information_category varchar2(30)
27 ,information1 number(15)
28 ,information2 date
29 ,information3 date
30 ,information4 number(15)
31 ,information5 varchar2(600)
32 ,information6 varchar2(240)
33 ,information7 varchar2(240)
34 ,information8 varchar2(30)
35 ,information9 varchar2(240)
36 ,information10 date
37 ,information11 varchar2(30)
38 ,information12 varchar2(30)
39 ,information13 varchar2(30)
40 ,information14 varchar2(30)
41 ,information15 varchar2(30)
42 ,information16 varchar2(30)
43 ,information17 varchar2(30)
44 ,information18 varchar2(30)
45 ,information19 varchar2(30)
46 ,information20 varchar2(30)
47 ,information21 varchar2(30)
48 ,information22 varchar2(30)
49 ,information23 varchar2(30)
50 ,information24 varchar2(30)
51 ,information25 varchar2(30)
52 ,information26 varchar2(30)
53 ,information27 varchar2(30)
54 ,information28 varchar2(30)
55 ,information29 varchar2(30)
56 ,information30 varchar2(30)
57 ,information31 varchar2(30)
58 ,information32 varchar2(30)
59 ,information33 varchar2(30)
60 ,information34 varchar2(30)
61 ,information35 varchar2(30)
62 ,information36 varchar2(30)
63 ,information37 varchar2(30)
64 ,information38 varchar2(30)
65 ,information39 varchar2(30)
66 ,information40 varchar2(30)
67 ,information41 varchar2(30)
68 ,information42 varchar2(30)
69 ,information43 varchar2(30)
70 ,information44 varchar2(30)
71 ,information45 varchar2(30)
72 ,information46 varchar2(30)
73 ,information47 varchar2(30)
74 ,information48 varchar2(30)
75 ,information49 varchar2(30)
76 ,information50 varchar2(30)
77 ,information51 varchar2(30)
78 ,information52 varchar2(30)
79 ,information53 varchar2(30)
80 ,information54 varchar2(30)
81 ,information55 varchar2(30)
82 ,information56 varchar2(30)
83 ,information57 varchar2(30)
84 ,information58 varchar2(30)
85 ,information59 varchar2(30)
86 ,information60 varchar2(30)
87 ,information61 varchar2(30)
88 ,information62 varchar2(30)
89 ,information63 varchar2(30)
90 ,information64 varchar2(30)
91 ,information65 varchar2(30)
92 ,information66 varchar2(30)
93 ,information67 varchar2(30)
94 ,information68 varchar2(30)
95 ,information69 varchar2(30)
96 ,information70 varchar2(30)
97 ,information71 varchar2(30)
98 ,information72 varchar2(30)
99 ,information73 varchar2(30)
100 ,information74 varchar2(30)
101 ,information75 varchar2(30)
102 ,information76 varchar2(30)
103 ,information77 varchar2(30)
104 ,information78 varchar2(30)
105 ,information79 varchar2(30)
106 ,information80 varchar2(30)
107 ,information81 varchar2(30)
108 ,information82 varchar2(30)
109 ,information83 varchar2(30)
110 ,information84 varchar2(30)
111 ,information85 varchar2(30)
112 ,information86 varchar2(30)
113 ,information87 varchar2(30)
114 ,information88 varchar2(30)
115 ,information89 varchar2(30)
116 ,information90 varchar2(30)
117 ,information91 varchar2(30)
118 ,information92 varchar2(30)
119 ,information93 varchar2(30)
120 ,information94 varchar2(30)
121 ,information95 varchar2(30)
122 ,information96 varchar2(30)
123 ,information97 varchar2(30)
124 ,information98 varchar2(30)
125 ,information99 varchar2(30)
126 ,information100 varchar2(30)
127 ,information101 varchar2(30)
128 ,information102 varchar2(30)
129 ,information103 varchar2(30)
130 ,information104 varchar2(30)
131 ,information105 varchar2(30)
132 ,information106 varchar2(30)
133 ,information107 varchar2(30)
134 ,information108 varchar2(30)
135 ,information109 varchar2(30)
136 ,information110 varchar2(30)
137 ,information111 varchar2(150)
138 ,information112 varchar2(150)
139 ,information113 varchar2(150)
140 ,information114 varchar2(150)
141 ,information115 varchar2(150)
142 ,information116 varchar2(150)
143 ,information117 varchar2(150)
144 ,information118 varchar2(150)
145 ,information119 varchar2(150)
146 ,information120 varchar2(150)
147 ,information121 varchar2(150)
148 ,information122 varchar2(150)
149 ,information123 varchar2(150)
150 ,information124 varchar2(150)
151 ,information125 varchar2(150)
152 ,information126 varchar2(150)
153 ,information127 varchar2(150)
154 ,information128 varchar2(150)
155 ,information129 varchar2(150)
156 ,information130 varchar2(150)
157 ,information131 varchar2(150)
158 ,information132 varchar2(150)
159 ,information133 varchar2(150)
160 ,information134 varchar2(150)
161 ,information135 varchar2(150)
162 ,information136 varchar2(150)
163 ,information137 varchar2(150)
164 ,information138 varchar2(150)
165 ,information139 varchar2(150)
166 ,information140 varchar2(150)
167 ,information141 varchar2(150)
168 ,information142 varchar2(150)
169
170 /* Extra Reserved Columns
171 ,information143 varchar2(150)
172 ,information144 varchar2(150)
173 ,information145 varchar2(150)
174 ,information146 varchar2(150)
175 ,information147 varchar2(150)
176 ,information148 varchar2(150)
177 ,information149 varchar2(150)
178 ,information150 varchar2(150)
179 */
180 ,information151 varchar2(240)
181 ,information152 varchar2(240)
182 ,information153 varchar2(240)
183
184 /* Extra Reserved Columns
185 ,information154 varchar2(240)
186 ,information155 varchar2(240)
187 ,information156 varchar2(240)
188 ,information157 varchar2(240)
189 ,information158 varchar2(240)
190 ,information159 varchar2(240)
191 */
192 ,information160 number(15)
193 ,information161 number(15)
194 ,information162 number(15)
195
196 /* Extra Reserved Columns
197 ,information163 number(15)
198 ,information164 number(15)
199 ,information165 number(15)
200 */
201 ,information166 date
202 ,information167 date
203 ,information168 date
204 ,information169 number(15)
205 ,information170 varchar2(240)
206
207 /* Extra Reserved Columns
208 ,information171 varchar2(240)
209 ,information172 varchar2(240)
210 */
211 ,information173 varchar2(240)
212 ,information174 number(15)
213 ,information175 varchar2(240)
214 ,information176 number(15)
215 ,information177 varchar2(240)
216 ,information178 number(15)
217 ,information179 varchar2(240)
218 ,information180 number(15)
219 ,information181 varchar2(240)
220 ,information182 varchar2(240)
221
222 /* Extra Reserved Columns
223 ,information183 varchar2(240)
224 ,information184 varchar2(240)
225 */
226 --,information185 varchar2(240) --Bug 16372007
227 ,information185 varchar2(600) --Bug 16372007
228 ,information186 varchar2(240)
229 ,information187 varchar2(240)
230 ,information188 varchar2(240)
231
232 /* Extra Reserved Columns
233 ,information189 varchar2(240)
234 */
235 ,information190 varchar2(240)
236 ,information191 varchar2(240)
237 ,information192 varchar2(240)
238 ,information193 varchar2(240)
239 ,information194 varchar2(240)
240 ,information195 varchar2(240)
241 ,information196 varchar2(240)
242 ,information197 varchar2(240)
243 ,information198 varchar2(240)
244 ,information199 varchar2(240)
245
246 /* Extra Reserved Columns
247 ,information200 varchar2(240)
248 ,information201 varchar2(240)
249 ,information202 varchar2(240)
250 ,information203 varchar2(240)
251 ,information204 varchar2(240)
252 ,information205 varchar2(240)
253 ,information206 varchar2(240)
254 ,information207 varchar2(240)
255 ,information208 varchar2(240)
256 ,information209 varchar2(240)
257 ,information210 varchar2(240)
258 ,information211 varchar2(240)
259 ,information212 varchar2(240)
260 ,information213 varchar2(240)
261 ,information214 varchar2(240)
262 ,information215 varchar2(240)
263 */
264 ,information216 varchar2(600)
265 ,information217 varchar2(600)
266 ,information218 varchar2(600)
267 ,information219 varchar2(2000)
268 ,information220 varchar2(2000)
269 ,information221 number(15)
270 ,information222 number(15)
271 ,information223 number(15)
272 ,information224 number(15)
273 ,information225 number(15)
274 ,information226 number(15)
275 ,information227 number(15)
276 ,information228 number(15)
277 ,information229 number(15)
278 ,information230 number(15)
279 ,information231 number(15)
280 ,information232 number(15)
281 ,information233 number(15)
282 ,information234 number(15)
283 ,information235 number(15)
284 ,information236 number(15)
285 ,information237 number(15)
286 ,information238 number(15)
287 ,information239 number(15)
288 ,information240 number(15)
289 ,information241 number(15)
290 ,information242 number(15)
291 ,information243 number(15)
292 ,information244 number(15)
293 ,information245 number(15)
294 ,information246 number(15)
295 ,information247 number(15)
296 ,information248 number(15)
297 ,information249 number(15)
298 ,information250 number(15)
299 ,information251 number(15)
300 ,information252 number(15)
301 ,information253 number(15)
302 ,information254 number(15)
303 ,information255 number(15)
304 ,information256 number(15)
305 ,information257 number(15)
306 ,information258 number(15)
307 ,information259 number(15)
308 ,information260 number(15)
309 ,information261 number(15)
310 ,information262 number(15)
311 ,information263 number(15)
312 ,information264 number(15)
313 ,information265 number(15)
314 ,information266 number(15)
315 ,information267 number(15)
316 ,information268 number(15)
317 ,information269 number(15)
318 ,information270 number(15)
319 ,information271 number(15)
320 ,information272 number(15)
321 ,information273 number(15)
322 ,information274 number(15)
323 ,information275 number(15)
324 ,information276 number(15)
325 ,information277 number(15)
326 ,information278 number(15)
327 ,information279 number(15)
328 ,information280 number(15)
329 ,information281 number(15)
330 ,information282 number(15)
331 ,information283 number(15)
332 ,information284 number(15)
333 ,information285 number(15)
334 ,information286 number(15)
335 ,information287 number(22,9)
339 ,information291 number(22,9)
336 ,information288 number(22,9)
337 ,information289 number(22,9)
338 ,information290 number(22,9)
340 ,information292 number(22,9)
341 ,information293 number(38,15)
342 ,information294 number(38,15)
343 ,information295 number(38,15)
344 ,information296 number(38,15)
345 ,information297 number(38,15)
346 ,information298 number(38,15)
347 ,information299 number(38,15)
348 ,information300 number(38,15)
349 ,information301 number(38,15)
350 ,information302 number(38,15)
351 ,information303 number(38,15)
352 ,information304 number(38,15)
353
354 /* Extra Reserved Columns
355 ,information305 number(38,15)
356 */
357 ,information306 date
358 ,information307 date
359 ,information308 date
360 ,information309 date
361 ,information310 date
362 ,information311 date
363 ,information312 date
364 ,information313 date
365 ,information314 date
366 ,information315 date
367 ,information316 date
368 ,information317 date
369 ,information318 date
370 ,information319 date
371 ,information320 date
372
373 /* Extra Reserved Columns
374 ,information321 date
375 ,information322 date
376 */
377 ,information323 long
378 ,datetrack_mode varchar2(30)
379 ,object_version_number number(9)
380 -- ,datetrack_mode varchar2(30)
381 );
382 --
383 -- ----------------------------------------------------------------------------
384 -- | Global Definitions - Internal Development Use Only |
385 -- ----------------------------------------------------------------------------
386 --
387 g_old_rec g_rec_type; -- Global record definition
388 -- Global table name
389 g_tab_nam constant varchar2(30) := 'BEN_COPY_ENTITY_RESULTS';
390 g_api_dml boolean; -- Global api dml status
391 --
392 -- ----------------------------------------------------------------------------
393 -- |------------------------< return_api_dml_status >-------------------------|
394 -- ----------------------------------------------------------------------------
395 -- {Start Of Comments}
396 --
397 -- Description:
398 -- This function will return the current g_api_dml private global
399 -- boolean status.
400 -- The g_api_dml status determines if at the time of the function
401 -- being executed if a dml statement (i.e. INSERT, UPDATE or DELETE)
402 -- is being issued from within an api.
403 -- If the status is TRUE then a dml statement is being issued from
404 -- within this entity api.
405 -- This function is primarily to support database triggers which
406 -- need to maintain the object_version_number for non-supported
407 -- dml statements (i.e. dml statement issued outside of the api layer).
408 --
409 -- Prerequisites:
410 -- None.
411 --
412 -- In Parameters:
413 -- None.
414 --
415 -- Post Success:
416 -- Processing continues.
417 -- If the function returns a TRUE value then, dml is being executed from
418 -- within this api.
419 --
420 -- Post Failure:
421 -- None.
422 --
423 -- Access Status:
424 -- Internal Row Handler Use Only.
425 --
426 -- {End Of Comments}
427 -- ----------------------------------------------------------------------------
428 Function return_api_dml_status Return Boolean;
429 --
430 -- ----------------------------------------------------------------------------
431 -- |---------------------------< constraint_error >---------------------------|
432 -- ----------------------------------------------------------------------------
433 -- {Start Of Comments}
434 --
435 -- Description:
436 -- This procedure is called when a constraint has been violated (i.e.
437 -- The exception hr_api.check_integrity_violated,
438 -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
439 -- hr_api.unique_integrity_violated has been raised).
440 -- The exceptions can only be raised as follows:
441 -- 1) A check constraint can only be violated during an INSERT or UPDATE
442 -- dml operation.
443 -- 2) A parent integrity constraint can only be violated during an
444 -- INSERT or UPDATE dml operation.
445 -- 3) A child integrity constraint can only be violated during an
446 -- DELETE dml operation.
447 -- 4) A unique integrity constraint can only be violated during INSERT or
448 -- UPDATE dml operation.
449 --
450 -- Prerequisites:
451 -- 1) Either hr_api.check_integrity_violated,
452 -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
453 -- hr_api.unique_integrity_violated has been raised with the subsequent
454 -- stripping of the constraint name from the generated error message
455 -- text.
456 -- 2) Standalone validation test which corresponds with a constraint error.
457 --
458 -- In Parameter:
459 -- p_constraint_name is in upper format and is just the constraint name
460 -- (e.g. not prefixed by brackets, schema owner etc).
461 --
462 -- Post Success:
463 -- Development dependant.
464 --
465 -- Post Failure:
466 -- Developement dependant.
467 --
468 -- Developer Implementation Notes:
472 -- friendly defined error message).
469 -- For each constraint being checked the hr system package failure message
470 -- has been generated as a template only. These system error messages should
471 -- be modified as required (i.e. change the system failure message to a user
473 --
474 -- Access Status:
475 -- Internal Development Use Only.
476 --
477 -- {End Of Comments}
478 -- ----------------------------------------------------------------------------
479 Procedure constraint_error
480 (p_constraint_name in all_constraints.constraint_name%TYPE);
481 --
482 -- ----------------------------------------------------------------------------
483 -- |-----------------------------< api_updating >-----------------------------|
484 -- ----------------------------------------------------------------------------
485 -- {Start Of Comments}
486 --
487 -- Description:
488 -- This function is used to populate the g_old_rec record with the
489 -- current row from the database for the specified primary key
490 -- provided that the primary key exists and is valid and does not
491 -- already match the current g_old_rec. The function will always return
492 -- a TRUE value if the g_old_rec is populated with the current row.
493 -- A FALSE value will be returned if all of the primary key arguments
494 -- are null.
495 --
496 -- Prerequisites:
497 -- None.
498 --
499 -- In Parameters:
500 --
501 -- Post Success:
502 -- A value of TRUE will be returned indiciating that the g_old_rec
503 -- is current.
504 -- A value of FALSE will be returned if all of the primary key arguments
505 -- have a null value (this indicates that the row has not be inserted into
506 -- the Schema), and therefore could never have a corresponding row.
507 --
508 -- Post Failure:
509 -- A failure can only occur under two circumstances:
510 -- 1) The primary key is invalid (i.e. a row does not exist for the
511 -- specified primary key values).
512 -- 2) If an object_version_number exists but is NOT the same as the current
513 -- g_old_rec value.
514 --
515 -- Developer Implementation Notes:
516 -- None.
517 --
518 -- Access Status:
519 -- Internal Development Use Only.
520 --
521 -- {End Of Comments}
522 -- ----------------------------------------------------------------------------
523 Function api_updating
524 (p_copy_entity_result_id in number
525 ,p_object_version_number in number
526 ) Return Boolean;
527 --
528 -- ----------------------------------------------------------------------------
529 -- |---------------------------------< lck >----------------------------------|
530 -- ----------------------------------------------------------------------------
531 -- {Start of comments}
532 --
533 -- Description:
534 -- The Lck process has two main functions to perform. Firstly, the row to be
535 -- updated or deleted must be locked. The locking of the row will only be
536 -- successful if the row is not currently locked by another user.
537 -- Secondly, during the locking of the row, the row is selected into
538 -- the g_old_rec data structure which enables the current row values from
539 -- the server to be available to the api.
540 --
541 -- Prerequisites:
542 -- When attempting to call the lock the object version number (if defined)
543 -- is mandatory.
544 --
545 -- In Parameters:
546 -- The arguments to the Lck process are the primary key(s) which uniquely
547 -- identify the row and the object version number of row.
548 --
549 -- Post Success:
550 -- On successful completion of the Lck process the row to be updated or
551 -- deleted will be locked and selected into the global data structure
552 -- g_old_rec.
553 --
554 -- Post Failure:
555 -- The Lck process can fail for three reasons:
556 -- 1) When attempting to lock the row the row could already be locked by
557 -- another user. This will raise the HR_Api.Object_Locked exception.
558 -- 2) The row which is required to be locked doesn't exist in the HR Schema.
559 -- This error is trapped and reported using the message name
560 -- 'HR_7220_INVALID_PRIMARY_KEY'.
561 -- 3) The row although existing in the HR Schema has a different object
562 -- version number than the object version number specified.
563 -- This error is trapped and reported using the message name
564 -- 'HR_7155_OBJECT_INVALID'.
565 --
566 -- Developer Implementation Notes:
567 -- For each primary key and the object version number arguments add a
568 -- call to hr_api.mandatory_arg_error procedure to ensure that these
569 -- argument values are not null.
570 --
571 -- Access Status:
572 -- Internal Development Use Only.
573 --
574 -- {End of comments}
575 -- ----------------------------------------------------------------------------
576 Procedure lck
577 (p_copy_entity_result_id in number
578 ,p_object_version_number in number
579 );
580 --
581 -- ----------------------------------------------------------------------------
582 -- |-----------------------------< convert_args >-----------------------------|
583 -- ----------------------------------------------------------------------------
584 -- {Start Of Comments}
585 --
586 -- Description:
587 -- This function is used to turn attribute parameters into the record
588 -- structure parameter g_rec_type.
589 --
590 -- Prerequisites:
591 -- This is a private function and can only be called from the ins or upd
592 -- attribute processes.
593 --
594 -- In Parameters:
595 --
596 -- Post Success:
597 -- A returning record structure will be returned.
598 --
599 -- Post Failure:
600 -- No direct error handling is required within this function. Any possible
604 -- Developer Implementation Notes:
601 -- errors within this function will be a PL/SQL value error due to
602 -- conversion of datatypes or data lengths.
603 --
605 -- None.
606 --
607 -- Access Status:
608 -- Internal Row Handler Use Only.
609 --
610 -- {End Of Comments}
611 -- ----------------------------------------------------------------------------
612 Function convert_args
613 (p_copy_entity_result_id in number
614 ,p_copy_entity_txn_id in number
615 ,p_src_copy_entity_result_id in number
616 ,p_result_type_cd in varchar2
617 ,p_number_of_copies in number
618 ,p_mirror_entity_result_id in number
619 ,p_mirror_src_entity_result_id in number
620 ,p_parent_entity_result_id in number
621 ,p_pd_mr_src_entity_result_id in number
622 ,p_pd_parent_entity_result_id in number
623 ,p_gs_mr_src_entity_result_id in number
624 ,p_gs_parent_entity_result_id in number
625 ,p_table_name in varchar2
626 ,p_table_alias in varchar2
627 ,p_table_route_id in number
628 ,p_status in varchar2
629 ,p_dml_operation in varchar2
630 ,p_information_category in varchar2
631 ,p_information1 in number
632 ,p_information2 in date
633 ,p_information3 in date
634 ,p_information4 in number
635 ,p_information5 in varchar2
636 ,p_information6 in varchar2
637 ,p_information7 in varchar2
638 ,p_information8 in varchar2
639 ,p_information9 in varchar2
640 ,p_information10 in date
641 ,p_information11 in varchar2
642 ,p_information12 in varchar2
643 ,p_information13 in varchar2
644 ,p_information14 in varchar2
645 ,p_information15 in varchar2
646 ,p_information16 in varchar2
647 ,p_information17 in varchar2
648 ,p_information18 in varchar2
649 ,p_information19 in varchar2
650 ,p_information20 in varchar2
651 ,p_information21 in varchar2
652 ,p_information22 in varchar2
653 ,p_information23 in varchar2
654 ,p_information24 in varchar2
655 ,p_information25 in varchar2
656 ,p_information26 in varchar2
657 ,p_information27 in varchar2
658 ,p_information28 in varchar2
659 ,p_information29 in varchar2
660 ,p_information30 in varchar2
661 ,p_information31 in varchar2
662 ,p_information32 in varchar2
663 ,p_information33 in varchar2
664 ,p_information34 in varchar2
665 ,p_information35 in varchar2
666 ,p_information36 in varchar2
667 ,p_information37 in varchar2
668 ,p_information38 in varchar2
669 ,p_information39 in varchar2
670 ,p_information40 in varchar2
671 ,p_information41 in varchar2
672 ,p_information42 in varchar2
673 ,p_information43 in varchar2
674 ,p_information44 in varchar2
675 ,p_information45 in varchar2
676 ,p_information46 in varchar2
677 ,p_information47 in varchar2
678 ,p_information48 in varchar2
679 ,p_information49 in varchar2
680 ,p_information50 in varchar2
681 ,p_information51 in varchar2
682 ,p_information52 in varchar2
683 ,p_information53 in varchar2
684 ,p_information54 in varchar2
685 ,p_information55 in varchar2
686 ,p_information56 in varchar2
687 ,p_information57 in varchar2
688 ,p_information58 in varchar2
689 ,p_information59 in varchar2
690 ,p_information60 in varchar2
691 ,p_information61 in varchar2
692 ,p_information62 in varchar2
693 ,p_information63 in varchar2
694 ,p_information64 in varchar2
695 ,p_information65 in varchar2
696 ,p_information66 in varchar2
697 ,p_information67 in varchar2
698 ,p_information68 in varchar2
699 ,p_information69 in varchar2
700 ,p_information70 in varchar2
701 ,p_information71 in varchar2
702 ,p_information72 in varchar2
703 ,p_information73 in varchar2
704 ,p_information74 in varchar2
705 ,p_information75 in varchar2
706 ,p_information76 in varchar2
707 ,p_information77 in varchar2
708 ,p_information78 in varchar2
709 ,p_information79 in varchar2
710 ,p_information80 in varchar2
711 ,p_information81 in varchar2
712 ,p_information82 in varchar2
713 ,p_information83 in varchar2
714 ,p_information84 in varchar2
715 ,p_information85 in varchar2
716 ,p_information86 in varchar2
717 ,p_information87 in varchar2
718 ,p_information88 in varchar2
719 ,p_information89 in varchar2
720 ,p_information90 in varchar2
724 ,p_information94 in varchar2
721 ,p_information91 in varchar2
722 ,p_information92 in varchar2
723 ,p_information93 in varchar2
725 ,p_information95 in varchar2
726 ,p_information96 in varchar2
727 ,p_information97 in varchar2
728 ,p_information98 in varchar2
729 ,p_information99 in varchar2
730 ,p_information100 in varchar2
731 ,p_information101 in varchar2
732 ,p_information102 in varchar2
733 ,p_information103 in varchar2
734 ,p_information104 in varchar2
735 ,p_information105 in varchar2
736 ,p_information106 in varchar2
737 ,p_information107 in varchar2
738 ,p_information108 in varchar2
739 ,p_information109 in varchar2
740 ,p_information110 in varchar2
741 ,p_information111 in varchar2
742 ,p_information112 in varchar2
743 ,p_information113 in varchar2
744 ,p_information114 in varchar2
745 ,p_information115 in varchar2
746 ,p_information116 in varchar2
747 ,p_information117 in varchar2
748 ,p_information118 in varchar2
749 ,p_information119 in varchar2
750 ,p_information120 in varchar2
751 ,p_information121 in varchar2
752 ,p_information122 in varchar2
753 ,p_information123 in varchar2
754 ,p_information124 in varchar2
755 ,p_information125 in varchar2
756 ,p_information126 in varchar2
757 ,p_information127 in varchar2
758 ,p_information128 in varchar2
759 ,p_information129 in varchar2
760 ,p_information130 in varchar2
761 ,p_information131 in varchar2
762 ,p_information132 in varchar2
763 ,p_information133 in varchar2
764 ,p_information134 in varchar2
765 ,p_information135 in varchar2
766 ,p_information136 in varchar2
767 ,p_information137 in varchar2
768 ,p_information138 in varchar2
769 ,p_information139 in varchar2
770 ,p_information140 in varchar2
771 ,p_information141 in varchar2
772 ,p_information142 in varchar2
773
774 /* Extra Reserved Columns
775 ,p_information143 in varchar2
776 ,p_information144 in varchar2
777 ,p_information145 in varchar2
778 ,p_information146 in varchar2
779 ,p_information147 in varchar2
780 ,p_information148 in varchar2
781 ,p_information149 in varchar2
782 ,p_information150 in varchar2
783 */
784 ,p_information151 in varchar2
785 ,p_information152 in varchar2
786 ,p_information153 in varchar2
787
788 /* Extra Reserved Columns
789 ,p_information154 in varchar2
790 ,p_information155 in varchar2
791 ,p_information156 in varchar2
792 ,p_information157 in varchar2
793 ,p_information158 in varchar2
794 ,p_information159 in varchar2
795 */
796 ,p_information160 in number
797 ,p_information161 in number
798 ,p_information162 in number
799
800 /* Extra Reserved Columns
801 ,p_information163 in number
802 ,p_information164 in number
803 ,p_information165 in number
804 */
805 ,p_information166 in date
806 ,p_information167 in date
807 ,p_information168 in date
808 ,p_information169 in number
809 ,p_information170 in varchar2
810
811 /* Extra Reserved Columns
812 ,p_information171 in varchar2
813 ,p_information172 in varchar2
814 */
815 ,p_information173 in varchar2
816 ,p_information174 in number
817 ,p_information175 in varchar2
818 ,p_information176 in number
819 ,p_information177 in varchar2
820 ,p_information178 in number
821 ,p_information179 in varchar2
822 ,p_information180 in number
823 ,p_information181 in varchar2
824 ,p_information182 in varchar2
825
826 /* Extra Reserved Columns
827 ,p_information183 in varchar2
828 ,p_information184 in varchar2
829 */
830 ,p_information185 in varchar2
831 ,p_information186 in varchar2
832 ,p_information187 in varchar2
833 ,p_information188 in varchar2
834
835 /* Extra Reserved Columns
836 ,p_information189 in varchar2
837 */
838 ,p_information190 in varchar2
839 ,p_information191 in varchar2
840 ,p_information192 in varchar2
841 ,p_information193 in varchar2
842 ,p_information194 in varchar2
843 ,p_information195 in varchar2
844 ,p_information196 in varchar2
845 ,p_information197 in varchar2
846 ,p_information198 in varchar2
850 ,p_information200 in varchar2
847 ,p_information199 in varchar2
848
849 /* Extra Reserved Columns
851 ,p_information201 in varchar2
852 ,p_information202 in varchar2
853 ,p_information203 in varchar2
854 ,p_information204 in varchar2
855 ,p_information205 in varchar2
856 ,p_information206 in varchar2
857 ,p_information207 in varchar2
858 ,p_information208 in varchar2
859 ,p_information209 in varchar2
860 ,p_information210 in varchar2
861 ,p_information211 in varchar2
862 ,p_information212 in varchar2
863 ,p_information213 in varchar2
864 ,p_information214 in varchar2
865 ,p_information215 in varchar2
866 */
867 ,p_information216 in varchar2
868 ,p_information217 in varchar2
869 ,p_information218 in varchar2
870 ,p_information219 in varchar2
871 ,p_information220 in varchar2
872 ,p_information221 in number
873 ,p_information222 in number
874 ,p_information223 in number
875 ,p_information224 in number
876 ,p_information225 in number
877 ,p_information226 in number
878 ,p_information227 in number
879 ,p_information228 in number
880 ,p_information229 in number
881 ,p_information230 in number
882 ,p_information231 in number
883 ,p_information232 in number
884 ,p_information233 in number
885 ,p_information234 in number
886 ,p_information235 in number
887 ,p_information236 in number
888 ,p_information237 in number
889 ,p_information238 in number
890 ,p_information239 in number
891 ,p_information240 in number
892 ,p_information241 in number
893 ,p_information242 in number
894 ,p_information243 in number
895 ,p_information244 in number
896 ,p_information245 in number
897 ,p_information246 in number
898 ,p_information247 in number
899 ,p_information248 in number
900 ,p_information249 in number
901 ,p_information250 in number
902 ,p_information251 in number
903 ,p_information252 in number
904 ,p_information253 in number
905 ,p_information254 in number
906 ,p_information255 in number
907 ,p_information256 in number
908 ,p_information257 in number
909 ,p_information258 in number
910 ,p_information259 in number
911 ,p_information260 in number
912 ,p_information261 in number
913 ,p_information262 in number
914 ,p_information263 in number
915 ,p_information264 in number
916 ,p_information265 in number
917 ,p_information266 in number
918 ,p_information267 in number
919 ,p_information268 in number
920 ,p_information269 in number
921 ,p_information270 in number
922 ,p_information271 in number
923 ,p_information272 in number
924 ,p_information273 in number
925 ,p_information274 in number
926 ,p_information275 in number
927 ,p_information276 in number
928 ,p_information277 in number
929 ,p_information278 in number
930 ,p_information279 in number
931 ,p_information280 in number
932 ,p_information281 in number
933 ,p_information282 in number
934 ,p_information283 in number
935 ,p_information284 in number
936 ,p_information285 in number
937 ,p_information286 in number
938 ,p_information287 in number
939 ,p_information288 in number
940 ,p_information289 in number
941 ,p_information290 in number
942 ,p_information291 in number
943 ,p_information292 in number
944 ,p_information293 in number
945 ,p_information294 in number
946 ,p_information295 in number
947 ,p_information296 in number
948 ,p_information297 in number
949 ,p_information298 in number
950 ,p_information299 in number
951 ,p_information300 in number
952 ,p_information301 in number
953 ,p_information302 in number
954 ,p_information303 in number
955 ,p_information304 in number
956
957 /* Extra Reserved Columns
958 ,p_information305 in number
959 */
960 ,p_information306 in date
961 ,p_information307 in date
962 ,p_information308 in date
963 ,p_information309 in date
964 ,p_information310 in date
965 ,p_information311 in date
966 ,p_information312 in date
967 ,p_information313 in date
968 ,p_information314 in date
969 ,p_information315 in date
970 ,p_information316 in date
971 ,p_information317 in date
972 ,p_information318 in date
973 ,p_information319 in date
974 ,p_information320 in date
975
976 /* Extra Reserved Columns
977 ,p_information321 in date
978 ,p_information322 in date
979 */
980 ,p_information323 in long
981 ,p_datetrack_mode in varchar2
982 ,p_object_version_number in number
983 )
984 Return g_rec_type;
985 --
986 end ben_cpe_shd;