1 Package ben_xrd_shd AUTHID CURRENT_USER as
2 /* $Header: bexrdrhi.pkh 120.0 2005/05/28 12:39:21 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Record Type Specification |
6 -- ----------------------------------------------------------------------------
7 --
8
9 Type g_rec_type Is Record
10 (
11 ext_rslt_dtl_id number(15),
12 prmy_sort_val varchar2(600),
13 scnd_sort_val varchar2(600),
14 thrd_sort_val varchar2(600),
15 trans_seq_num number(15),
16 rcrd_seq_num number(15),
17 ext_rslt_id number(15),
18 ext_rcd_id number(15),
19 person_id number(15),
20 business_group_id number(15),
21 ext_per_bg_id number(15),
22 val_01 varchar2(600),
23 val_02 varchar2(600),
24 val_03 varchar2(600),
25 val_04 varchar2(600),
26 val_05 varchar2(600),
27 val_06 varchar2(600),
28 val_07 varchar2(600),
29 val_08 varchar2(600),
30 val_09 varchar2(600),
31 val_10 varchar2(600),
32 val_11 varchar2(600),
33 val_12 varchar2(600),
34 val_13 varchar2(600),
35 val_14 varchar2(600),
36 val_15 varchar2(600),
37 val_16 varchar2(600),
38 val_17 varchar2(600),
39 val_19 varchar2(600),
40 val_18 varchar2(600),
41 val_20 varchar2(600),
42 val_21 varchar2(600),
43 val_22 varchar2(600),
44 val_23 varchar2(600),
45 val_24 varchar2(600),
46 val_25 varchar2(600),
47 val_26 varchar2(600),
48 val_27 varchar2(600),
49 val_28 varchar2(600),
50 val_29 varchar2(600),
51 val_30 varchar2(600),
52 val_31 varchar2(600),
53 val_32 varchar2(600),
54 val_33 varchar2(600),
55 val_34 varchar2(600),
56 val_35 varchar2(600),
57 val_36 varchar2(600),
58 val_37 varchar2(600),
59 val_38 varchar2(600),
60 val_39 varchar2(600),
61 val_40 varchar2(600),
62 val_41 varchar2(600),
63 val_42 varchar2(600),
64 val_43 varchar2(600),
65 val_44 varchar2(600),
66 val_45 varchar2(600),
67 val_46 varchar2(600),
68 val_47 varchar2(600),
69 val_48 varchar2(600),
70 val_49 varchar2(600),
71 val_50 varchar2(600),
72 val_51 varchar2(600),
73 val_52 varchar2(600),
74 val_53 varchar2(600),
75 val_54 varchar2(600),
76 val_55 varchar2(600),
77 val_56 varchar2(600),
78 val_57 varchar2(600),
79 val_58 varchar2(600),
80 val_59 varchar2(600),
81 val_60 varchar2(600),
82 val_61 varchar2(600),
83 val_62 varchar2(600),
84 val_63 varchar2(600),
85 val_64 varchar2(600),
86 val_65 varchar2(600),
87 val_66 varchar2(600),
88 val_67 varchar2(600),
89 val_68 varchar2(600),
90 val_69 varchar2(600),
91 val_70 varchar2(600),
92 val_71 varchar2(600),
93 val_72 varchar2(600),
94 val_73 varchar2(600),
95 val_74 varchar2(600),
96 val_75 varchar2(600),
97 val_76 varchar2(600),
98 val_77 varchar2(600),
99 val_78 varchar2(600),
100 val_79 varchar2(600),
101 val_80 varchar2(600),
102 val_81 varchar2(600),
103 val_82 varchar2(600),
104 val_83 varchar2(600),
105 val_84 varchar2(600),
106 val_85 varchar2(600),
107 val_86 varchar2(600),
108 val_87 varchar2(600),
109 val_88 varchar2(600),
110 val_89 varchar2(600),
111 val_90 varchar2(600),
112 val_91 varchar2(600),
113 val_92 varchar2(600),
114 val_93 varchar2(600),
115 val_94 varchar2(600),
116 val_95 varchar2(600),
117 val_96 varchar2(600),
118 val_97 varchar2(600),
119 val_98 varchar2(600),
120 val_99 varchar2(600),
121 val_100 varchar2(600),
122 val_101 varchar2(600),
123 val_102 varchar2(600),
124 val_103 varchar2(600),
125 val_104 varchar2(600),
126 val_105 varchar2(600),
127 val_106 varchar2(600),
128 val_107 varchar2(600),
129 val_108 varchar2(600),
130 val_109 varchar2(600),
131 val_110 varchar2(600),
132 val_111 varchar2(600),
133 val_112 varchar2(600),
134 val_113 varchar2(600),
135 val_114 varchar2(600),
136 val_115 varchar2(600),
137 val_116 varchar2(600),
138 val_117 varchar2(600),
139 val_119 varchar2(600),
140 val_118 varchar2(600),
141 val_120 varchar2(600),
142 val_121 varchar2(600),
143 val_122 varchar2(600),
144 val_123 varchar2(600),
145 val_124 varchar2(600),
146 val_125 varchar2(600),
147 val_126 varchar2(600),
148 val_127 varchar2(600),
149 val_128 varchar2(600),
150 val_129 varchar2(600),
151 val_130 varchar2(600),
152 val_131 varchar2(600),
153 val_132 varchar2(600),
154 val_133 varchar2(600),
155 val_134 varchar2(600),
156 val_135 varchar2(600),
157 val_136 varchar2(600),
158 val_137 varchar2(600),
159 val_138 varchar2(600),
160 val_139 varchar2(600),
161 val_140 varchar2(600),
162 val_141 varchar2(600),
163 val_142 varchar2(600),
164 val_143 varchar2(600),
165 val_144 varchar2(600),
166 val_145 varchar2(600),
167 val_146 varchar2(600),
168 val_147 varchar2(600),
169 val_148 varchar2(600),
170 val_149 varchar2(600),
171 val_150 varchar2(600),
172 val_151 varchar2(600),
173 val_152 varchar2(600),
174 val_153 varchar2(600),
175 val_154 varchar2(600),
176 val_155 varchar2(600),
177 val_156 varchar2(600),
178 val_157 varchar2(600),
179 val_158 varchar2(600),
180 val_159 varchar2(600),
181 val_160 varchar2(600),
182 val_161 varchar2(600),
183 val_162 varchar2(600),
184 val_163 varchar2(600),
185 val_164 varchar2(600),
186 val_165 varchar2(600),
187 val_166 varchar2(600),
188 val_167 varchar2(600),
189 val_168 varchar2(600),
190 val_169 varchar2(600),
191 val_170 varchar2(600),
192 val_171 varchar2(600),
193 val_172 varchar2(600),
194 val_173 varchar2(600),
195 val_174 varchar2(600),
196 val_175 varchar2(600),
197 val_176 varchar2(600),
198 val_177 varchar2(600),
199 val_178 varchar2(600),
200 val_179 varchar2(600),
201 val_180 varchar2(600),
202 val_181 varchar2(600),
203 val_182 varchar2(600),
204 val_183 varchar2(600),
205 val_184 varchar2(600),
206 val_185 varchar2(600),
207 val_186 varchar2(600),
208 val_187 varchar2(600),
209 val_188 varchar2(600),
210 val_189 varchar2(600),
211 val_190 varchar2(600),
212 val_191 varchar2(600),
213 val_192 varchar2(600),
214 val_193 varchar2(600),
215 val_194 varchar2(600),
216 val_195 varchar2(600),
217 val_196 varchar2(600),
218 val_197 varchar2(600),
219 val_198 varchar2(600),
220 val_199 varchar2(600),
221 val_200 varchar2(600),
222 val_201 varchar2(600),
223 val_202 varchar2(600),
224 val_203 varchar2(600),
225 val_204 varchar2(600),
226 val_205 varchar2(600),
227 val_206 varchar2(600),
228 val_207 varchar2(600),
229 val_208 varchar2(600),
230 val_209 varchar2(600),
231 val_210 varchar2(600),
232 val_211 varchar2(600),
233 val_212 varchar2(600),
234 val_213 varchar2(600),
235 val_214 varchar2(600),
236 val_215 varchar2(600),
237 val_216 varchar2(600),
238 val_217 varchar2(600),
239 val_219 varchar2(600),
240 val_218 varchar2(600),
241 val_220 varchar2(600),
242 val_221 varchar2(600),
243 val_222 varchar2(600),
244 val_223 varchar2(600),
245 val_224 varchar2(600),
246 val_225 varchar2(600),
247 val_226 varchar2(600),
248 val_227 varchar2(600),
249 val_228 varchar2(600),
250 val_229 varchar2(600),
251 val_230 varchar2(600),
252 val_231 varchar2(600),
253 val_232 varchar2(600),
254 val_233 varchar2(600),
255 val_234 varchar2(600),
256 val_235 varchar2(600),
257 val_236 varchar2(600),
258 val_237 varchar2(600),
259 val_238 varchar2(600),
260 val_239 varchar2(600),
261 val_240 varchar2(600),
262 val_241 varchar2(600),
263 val_242 varchar2(600),
264 val_243 varchar2(600),
265 val_244 varchar2(600),
266 val_245 varchar2(600),
267 val_246 varchar2(600),
268 val_247 varchar2(600),
269 val_248 varchar2(600),
270 val_249 varchar2(600),
271 val_250 varchar2(600),
272 val_251 varchar2(600),
273 val_252 varchar2(600),
274 val_253 varchar2(600),
275 val_254 varchar2(600),
276 val_255 varchar2(600),
277 val_256 varchar2(600),
278 val_257 varchar2(600),
279 val_258 varchar2(600),
280 val_259 varchar2(600),
281 val_260 varchar2(600),
282 val_261 varchar2(600),
283 val_262 varchar2(600),
284 val_263 varchar2(600),
285 val_264 varchar2(600),
286 val_265 varchar2(600),
287 val_266 varchar2(600),
288 val_267 varchar2(600),
289 val_268 varchar2(600),
290 val_269 varchar2(600),
291 val_270 varchar2(600),
292 val_271 varchar2(600),
293 val_272 varchar2(600),
294 val_273 varchar2(600),
295 val_274 varchar2(600),
296 val_275 varchar2(600),
297 val_276 varchar2(600),
298 val_277 varchar2(600),
299 val_278 varchar2(600),
300 val_279 varchar2(600),
301 val_280 varchar2(600),
302 val_281 varchar2(600),
303 val_282 varchar2(600),
304 val_283 varchar2(600),
305 val_284 varchar2(600),
306 val_285 varchar2(600),
307 val_286 varchar2(600),
308 val_287 varchar2(600),
309 val_288 varchar2(600),
310 val_289 varchar2(600),
311 val_290 varchar2(600),
312 val_291 varchar2(600),
313 val_292 varchar2(600),
314 val_293 varchar2(600),
315 val_294 varchar2(600),
316 val_295 varchar2(600),
317 val_296 varchar2(600),
318 val_297 varchar2(600),
319 val_298 varchar2(600),
323 group_val_02 varchar2(600),
320 val_299 varchar2(600),
321 val_300 varchar2(600),
322 group_val_01 varchar2(600),
324 program_application_id number(15),
325 program_id number(15),
326 program_update_date date,
327 request_id number(15),
328 object_version_number number(9) ,
329 ext_rcd_in_file_id number(15)
330 );
331 --
332
333
334
335 --
336 -- ----------------------------------------------------------------------------
337 -- | Global Definitions - Internal Development Use Only |
338 -- ----------------------------------------------------------------------------
339 --
340 g_old_rec g_rec_type; -- Global record definition
341 g_api_dml boolean; -- Global api dml status
342 --
343 -- ----------------------------------------------------------------------------
344 -- |------------------------< return_api_dml_status >-------------------------|
345 -- ----------------------------------------------------------------------------
346 -- {Start Of Comments}
347 --
348 -- Description:
349 -- This function will return the current g_api_dml private global
350 -- boolean status.
351 -- The g_api_dml status determines if at the time of the function
352 -- being executed if a dml statement (i.e. INSERT, UPDATE or DELETE)
353 -- is being issued from within an api.
354 -- If the status is TRUE then a dml statement is being issued from
355 -- within this entity api.
356 -- This function is primarily to support database triggers which
357 -- need to maintain the object_version_number for non-supported
358 -- dml statements (i.e. dml statement issued outside of the api layer).
359 --
360 -- Prerequisites:
361 -- None.
362 --
363 -- In Parameters:
364 -- None.
365 --
366 -- Post Success:
367 -- Processing continues.
368 -- If the function returns a TRUE value then, dml is being executed from
369 -- within this api.
370 --
371 -- Post Failure:
372 -- None.
373 --
374 -- Access Status:
375 -- Internal Row Handler Use Only.
376 --
377 -- {End Of Comments}
378 -- ----------------------------------------------------------------------------
379 Function return_api_dml_status Return Boolean;
380 --
381 -- ----------------------------------------------------------------------------
382 -- |---------------------------< constraint_error >---------------------------|
383 -- ----------------------------------------------------------------------------
384 -- {Start Of Comments}
385 --
386 -- Description:
387 -- This procedure is called when a constraint has been violated (i.e.
388 -- The exception hr_api.check_integrity_violated,
389 -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
390 -- hr_api.unique_integrity_violated has been raised).
391 -- The exceptions can only be raised as follows:
392 -- 1) A check constraint can only be violated during an INSERT or UPDATE
393 -- dml operation.
394 -- 2) A parent integrity constraint can only be violated during an
395 -- INSERT or UPDATE dml operation.
396 -- 3) A child integrity constraint can only be violated during an
397 -- DELETE dml operation.
398 -- 4) A unique integrity constraint can only be violated during INSERT or
399 -- UPDATE dml operation.
400 --
401 -- Prerequisites:
402 -- 1) Either hr_api.check_integrity_violated,
403 -- hr_api.parent_integrity_violated, hr_api.child_integrity_violated or
404 -- hr_api.unique_integrity_violated has been raised with the subsequent
405 -- stripping of the constraint name from the generated error message
406 -- text.
407 -- 2) Standalone validation test which corresponds with a constraint error.
408 --
409 -- In Parameter:
410 -- p_constraint_name is in upper format and is just the constraint name
411 -- (e.g. not prefixed by brackets, schema owner etc).
412 --
413 -- Post Success:
414 -- Development dependant.
415 --
416 -- Post Failure:
417 -- Developement dependant.
418 --
419 -- Developer Implementation Notes:
420 -- For each constraint being checked the hr system package failure message
421 -- has been generated as a template only. These system error messages should
422 -- be modified as required (i.e. change the system failure message to a user
423 -- friendly defined error message).
424 --
425 -- Access Status:
426 -- Internal Development Use Only.
427 --
428 -- {End Of Comments}
429 -- ----------------------------------------------------------------------------
430 Procedure constraint_error
431 (p_constraint_name in all_constraints.constraint_name%TYPE);
432 --
433 -- ----------------------------------------------------------------------------
434 -- |-----------------------------< api_updating >-----------------------------|
435 -- ----------------------------------------------------------------------------
436 -- {Start Of Comments}
437 --
438 -- Description:
439 -- This function is used to populate the g_old_rec record with the
440 -- current row from the database for the specified primary key
441 -- provided that the primary key exists and is valid and does not
445 -- are null.
442 -- already match the current g_old_rec. The function will always return
443 -- a TRUE value if the g_old_rec is populated with the current row.
444 -- A FALSE value will be returned if all of the primary key arguments
446 --
447 -- Prerequisites:
448 -- None.
449 --
450 -- In Parameters:
451 --
452 -- Post Success:
453 -- A value of TRUE will be returned indiciating that the g_old_rec
454 -- is current.
455 -- A value of FALSE will be returned if all of the primary key arguments
456 -- have a null value (this indicates that the row has not be inserted into
457 -- the Schema), and therefore could never have a corresponding row.
458 --
459 -- Post Failure:
460 -- A failure can only occur under two circumstances:
461 -- 1) The primary key is invalid (i.e. a row does not exist for the
462 -- specified primary key values).
463 -- 2) If an object_version_number exists but is NOT the same as the current
464 -- g_old_rec value.
465 --
466 -- Developer Implementation Notes:
467 -- None.
468 --
469 -- Access Status:
470 -- Internal Development Use Only.
471 --
472 -- {End Of Comments}
473 -- ----------------------------------------------------------------------------
474 Function api_updating
475 (
476 p_ext_rslt_dtl_id in number,
477 p_object_version_number in number
478 ) Return Boolean;
479 --
480 -- ----------------------------------------------------------------------------
481 -- |---------------------------------< lck >----------------------------------|
482 -- ----------------------------------------------------------------------------
483 -- {Start Of Comments}
484 --
485 -- Description:
486 -- The Lck process has two main functions to perform. Firstly, the row to be
487 -- updated or deleted must be locked. The locking of the row will only be
488 -- successful if the row is not currently locked by another user.
489 -- Secondly, during the locking of the row, the row is selected into
490 -- the g_old_rec data structure which enables the current row values from the
491 -- server to be available to the api.
492 --
493 -- Prerequisites:
494 -- When attempting to call the lock the object version number (if defined)
495 -- is mandatory.
496 --
497 -- In Parameters:
498 -- The arguments to the Lck process are the primary key(s) which uniquely
499 -- identify the row and the object version number of row.
500 --
501 -- Post Success:
502 -- On successful completion of the Lck process the row to be updated or
503 -- deleted will be locked and selected into the global data structure
504 -- g_old_rec.
505 --
506 -- Post Failure:
507 -- The Lck process can fail for three reasons:
508 -- 1) When attempting to lock the row the row could already be locked by
509 -- another user. This will raise the HR_Api.Object_Locked exception.
510 -- 2) The row which is required to be locked doesn't exist in the HR Schema.
511 -- This error is trapped and reported using the message name
512 -- 'HR_7220_INVALID_PRIMARY_KEY'.
513 -- 3) The row although existing in the HR Schema has a different object
514 -- version number than the object version number specified.
515 -- This error is trapped and reported using the message name
516 -- 'HR_7155_OBJECT_INVALID'.
517 --
518 -- Developer Implementation Notes:
519 -- For each primary key and the object version number arguments add a
520 -- call to hr_api.mandatory_arg_error procedure to ensure that these
521 -- argument values are not null.
522 --
523 -- Access Status:
524 -- Internal Development Use Only.
525 --
526 -- {End Of Comments}
527 -- ----------------------------------------------------------------------------
528 Procedure lck
529 (
530 p_ext_rslt_dtl_id in number,
531 p_object_version_number in number
532 );
533 --
534 -- ----------------------------------------------------------------------------
535 -- |-----------------------------< convert_args >-----------------------------|
536 -- ----------------------------------------------------------------------------
537 -- {Start Of Comments}
538 --
539 -- Description:
540 -- This function is used to turn attribute parameters into the record
541 -- structure parameter g_rec_type.
542 --
543 -- Prerequisites:
544 -- This is a private function and can only be called from the ins or upd
545 -- attribute processes.
546 --
547 -- In Parameters:
548 --
549 -- Post Success:
550 -- A returning record structure will be returned.
551 --
552 -- Post Failure:
553 -- No direct error handling is required within this function. Any possible
554 -- errors within this function will be a PL/SQL value error due to conversion
555 -- of datatypes or data lengths.
556 --
557 -- Developer Implementation Notes:
558 -- None.
559 --
560 -- Access Status:
561 -- Internal Row Handler Use Only.
562 --
563 -- {End Of Comments}
564 -- ----------------------------------------------------------------------------
565 Function convert_args
566 (
567 p_ext_rslt_dtl_id in number,
568 p_prmy_sort_val in varchar2,
569 p_scnd_sort_val in varchar2,
570 p_thrd_sort_val in varchar2,
571 p_trans_seq_num in number,
572 p_rcrd_seq_num in number,
576 p_business_group_id in number,
573 p_ext_rslt_id in number,
574 p_ext_rcd_id in number,
575 p_person_id in number,
577 p_ext_per_bg_id in number,
578 p_val_01 in varchar2,
579 p_val_02 in varchar2,
580 p_val_03 in varchar2,
581 p_val_04 in varchar2,
582 p_val_05 in varchar2,
583 p_val_06 in varchar2,
584 p_val_07 in varchar2,
585 p_val_08 in varchar2,
586 p_val_09 in varchar2,
587 p_val_10 in varchar2,
588 p_val_11 in varchar2,
589 p_val_12 in varchar2,
590 p_val_13 in varchar2,
591 p_val_14 in varchar2,
592 p_val_15 in varchar2,
593 p_val_16 in varchar2,
594 p_val_17 in varchar2,
595 p_val_19 in varchar2,
596 p_val_18 in varchar2,
597 p_val_20 in varchar2,
598 p_val_21 in varchar2,
599 p_val_22 in varchar2,
600 p_val_23 in varchar2,
601 p_val_24 in varchar2,
602 p_val_25 in varchar2,
603 p_val_26 in varchar2,
604 p_val_27 in varchar2,
605 p_val_28 in varchar2,
606 p_val_29 in varchar2,
607 p_val_30 in varchar2,
608 p_val_31 in varchar2,
609 p_val_32 in varchar2,
610 p_val_33 in varchar2,
611 p_val_34 in varchar2,
612 p_val_35 in varchar2,
613 p_val_36 in varchar2,
614 p_val_37 in varchar2,
615 p_val_38 in varchar2,
616 p_val_39 in varchar2,
617 p_val_40 in varchar2,
618 p_val_41 in varchar2,
619 p_val_42 in varchar2,
620 p_val_43 in varchar2,
621 p_val_44 in varchar2,
622 p_val_45 in varchar2,
623 p_val_46 in varchar2,
624 p_val_47 in varchar2,
625 p_val_48 in varchar2,
626 p_val_49 in varchar2,
627 p_val_50 in varchar2,
628 p_val_51 in varchar2,
629 p_val_52 in varchar2,
630 p_val_53 in varchar2,
631 p_val_54 in varchar2,
632 p_val_55 in varchar2,
633 p_val_56 in varchar2,
634 p_val_57 in varchar2,
635 p_val_58 in varchar2,
636 p_val_59 in varchar2,
637 p_val_60 in varchar2,
638 p_val_61 in varchar2,
639 p_val_62 in varchar2,
640 p_val_63 in varchar2,
641 p_val_64 in varchar2,
642 p_val_65 in varchar2,
643 p_val_66 in varchar2,
644 p_val_67 in varchar2,
645 p_val_68 in varchar2,
646 p_val_69 in varchar2,
647 p_val_70 in varchar2,
648 p_val_71 in varchar2,
649 p_val_72 in varchar2,
650 p_val_73 in varchar2,
651 p_val_74 in varchar2,
652 p_val_75 in varchar2,
653 p_val_76 in varchar2,
654 p_val_77 in varchar2,
655 p_val_78 in varchar2,
656 p_val_79 in varchar2,
657 p_val_80 in varchar2,
658 p_val_81 in varchar2,
659 p_val_82 in varchar2,
660 p_val_83 in varchar2,
661 p_val_84 in varchar2,
662 p_val_85 in varchar2,
663 p_val_86 in varchar2,
664 p_val_87 in varchar2,
665 p_val_88 in varchar2,
666 p_val_89 in varchar2,
667 p_val_90 in varchar2,
668 p_val_91 in varchar2,
669 p_val_92 in varchar2,
670 p_val_93 in varchar2,
671 p_val_94 in varchar2,
672 p_val_95 in varchar2,
673 p_val_96 in varchar2,
674 p_val_97 in varchar2,
675 p_val_98 in varchar2,
676 p_val_99 in varchar2,
677 p_val_100 in varchar2,
678 p_val_101 in varchar2,
679 p_val_102 in varchar2,
680 p_val_103 in varchar2,
681 p_val_104 in varchar2,
685 p_val_108 in varchar2,
682 p_val_105 in varchar2,
683 p_val_106 in varchar2,
684 p_val_107 in varchar2,
686 p_val_109 in varchar2,
687 p_val_110 in varchar2,
688 p_val_111 in varchar2,
689 p_val_112 in varchar2,
690 p_val_113 in varchar2,
691 p_val_114 in varchar2,
692 p_val_115 in varchar2,
693 p_val_116 in varchar2,
694 p_val_117 in varchar2,
695 p_val_119 in varchar2,
696 p_val_118 in varchar2,
697 p_val_120 in varchar2,
698 p_val_121 in varchar2,
699 p_val_122 in varchar2,
700 p_val_123 in varchar2,
701 p_val_124 in varchar2,
702 p_val_125 in varchar2,
703 p_val_126 in varchar2,
704 p_val_127 in varchar2,
705 p_val_128 in varchar2,
706 p_val_129 in varchar2,
707 p_val_130 in varchar2,
708 p_val_131 in varchar2,
709 p_val_132 in varchar2,
710 p_val_133 in varchar2,
711 p_val_134 in varchar2,
712 p_val_135 in varchar2,
713 p_val_136 in varchar2,
714 p_val_137 in varchar2,
715 p_val_138 in varchar2,
716 p_val_139 in varchar2,
717 p_val_140 in varchar2,
718 p_val_141 in varchar2,
719 p_val_142 in varchar2,
720 p_val_143 in varchar2,
721 p_val_144 in varchar2,
722 p_val_145 in varchar2,
723 p_val_146 in varchar2,
724 p_val_147 in varchar2,
725 p_val_148 in varchar2,
726 p_val_149 in varchar2,
727 p_val_150 in varchar2,
728 p_val_151 in varchar2,
729 p_val_152 in varchar2,
730 p_val_153 in varchar2,
731 p_val_154 in varchar2,
732 p_val_155 in varchar2,
733 p_val_156 in varchar2,
734 p_val_157 in varchar2,
735 p_val_158 in varchar2,
736 p_val_159 in varchar2,
737 p_val_160 in varchar2,
738 p_val_161 in varchar2,
739 p_val_162 in varchar2,
740 p_val_163 in varchar2,
741 p_val_164 in varchar2,
742 p_val_165 in varchar2,
743 p_val_166 in varchar2,
744 p_val_167 in varchar2,
745 p_val_168 in varchar2,
746 p_val_169 in varchar2,
747 p_val_170 in varchar2,
748 p_val_171 in varchar2,
749 p_val_172 in varchar2,
750 p_val_173 in varchar2,
751 p_val_174 in varchar2,
752 p_val_175 in varchar2,
753 p_val_176 in varchar2,
754 p_val_177 in varchar2,
755 p_val_178 in varchar2,
756 p_val_179 in varchar2,
757 p_val_180 in varchar2,
758 p_val_181 in varchar2,
759 p_val_182 in varchar2,
760 p_val_183 in varchar2,
761 p_val_184 in varchar2,
762 p_val_185 in varchar2,
763 p_val_186 in varchar2,
764 p_val_187 in varchar2,
765 p_val_188 in varchar2,
766 p_val_189 in varchar2,
767 p_val_190 in varchar2,
768 p_val_191 in varchar2,
769 p_val_192 in varchar2,
770 p_val_193 in varchar2,
771 p_val_194 in varchar2,
772 p_val_195 in varchar2,
773 p_val_196 in varchar2,
774 p_val_197 in varchar2,
775 p_val_198 in varchar2,
776 p_val_199 in varchar2,
777 p_val_200 in varchar2,
778 p_val_201 in varchar2,
779 p_val_202 in varchar2,
780 p_val_203 in varchar2,
781 p_val_204 in varchar2,
782 p_val_205 in varchar2,
783 p_val_206 in varchar2,
784 p_val_207 in varchar2,
785 p_val_208 in varchar2,
786 p_val_209 in varchar2,
787 p_val_210 in varchar2,
788 p_val_211 in varchar2,
789 p_val_212 in varchar2,
790 p_val_213 in varchar2,
791 p_val_214 in varchar2,
792 p_val_215 in varchar2,
793 p_val_216 in varchar2,
794 p_val_217 in varchar2,
795 p_val_219 in varchar2,
796 p_val_218 in varchar2,
797 p_val_220 in varchar2,
798 p_val_221 in varchar2,
799 p_val_222 in varchar2,
800 p_val_223 in varchar2,
801 p_val_224 in varchar2,
802 p_val_225 in varchar2,
803 p_val_226 in varchar2,
804 p_val_227 in varchar2,
805 p_val_228 in varchar2,
806 p_val_229 in varchar2,
807 p_val_230 in varchar2,
808 p_val_231 in varchar2,
809 p_val_232 in varchar2,
810 p_val_233 in varchar2,
811 p_val_234 in varchar2,
812 p_val_235 in varchar2,
813 p_val_236 in varchar2,
814 p_val_237 in varchar2,
815 p_val_238 in varchar2,
816 p_val_239 in varchar2,
817 p_val_240 in varchar2,
818 p_val_241 in varchar2,
819 p_val_242 in varchar2,
820 p_val_243 in varchar2,
821 p_val_244 in varchar2,
822 p_val_245 in varchar2,
823 p_val_246 in varchar2,
824 p_val_247 in varchar2,
828 p_val_251 in varchar2,
825 p_val_248 in varchar2,
826 p_val_249 in varchar2,
827 p_val_250 in varchar2,
829 p_val_252 in varchar2,
830 p_val_253 in varchar2,
831 p_val_254 in varchar2,
832 p_val_255 in varchar2,
833 p_val_256 in varchar2,
834 p_val_257 in varchar2,
835 p_val_258 in varchar2,
839 p_val_262 in varchar2,
836 p_val_259 in varchar2,
837 p_val_260 in varchar2,
838 p_val_261 in varchar2,
840 p_val_263 in varchar2,
841 p_val_264 in varchar2,
842 p_val_265 in varchar2,
843 p_val_266 in varchar2,
844 p_val_267 in varchar2,
845 p_val_268 in varchar2,
846 p_val_269 in varchar2,
847 p_val_270 in varchar2,
848 p_val_271 in varchar2,
849 p_val_272 in varchar2,
850 p_val_273 in varchar2,
851 p_val_274 in varchar2,
852 p_val_275 in varchar2,
853 p_val_276 in varchar2,
854 p_val_277 in varchar2,
855 p_val_278 in varchar2,
856 p_val_279 in varchar2,
857 p_val_280 in varchar2,
858 p_val_281 in varchar2,
859 p_val_282 in varchar2,
860 p_val_283 in varchar2,
861 p_val_284 in varchar2,
862 p_val_285 in varchar2,
863 p_val_286 in varchar2,
864 p_val_287 in varchar2,
865 p_val_288 in varchar2,
866 p_val_289 in varchar2,
867 p_val_290 in varchar2,
868 p_val_291 in varchar2,
869 p_val_292 in varchar2,
870 p_val_293 in varchar2,
871 p_val_294 in varchar2,
872 p_val_295 in varchar2,
873 p_val_296 in varchar2,
874 p_val_297 in varchar2,
875 p_val_298 in varchar2,
876 p_val_299 in varchar2,
877 p_val_300 in varchar2,
878 p_group_val_01 in varchar2,
879 p_group_val_02 in varchar2,
880 p_program_application_id in number,
881 p_program_id in number,
882 p_program_update_date in date,
883 p_request_id in number,
884 p_object_version_number in number,
885 p_ext_rcd_in_file_id in number
886 )
887 Return g_rec_type;
888 --
889 end ben_xrd_shd;