[Home] [Help]
PACKAGE BODY: APPS.BEN_XRD_UPD
Source
1 Package Body ben_xrd_upd as
2 /* $Header: bexrdrhi.pkb 120.1 2006/02/06 11:28:36 tjesumic noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' ben_xrd_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.
42 -- If any other error is reported, the error will be raised after the
43 -- g_api_dml status is reset.
44 --
45 -- Developer Implementation Notes:
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(p_rec in out nocopy ben_xrd_shd.g_rec_type) is
55 --
56 l_proc varchar2(72) := g_package||'update_dml';
57 --
58 Begin
59 hr_utility.set_location('Entering:'||l_proc, 5);
60 --
61 -- Increment the object version
62 --
63 p_rec.object_version_number := p_rec.object_version_number + 1;
64 --
65 ben_xrd_shd.g_api_dml := true; -- Set the api dml status
66 --
67 -- Update the ben_ext_rslt_dtl Row
68 --
69 update ben_ext_rslt_dtl
70 set
71 ext_rslt_dtl_id = p_rec.ext_rslt_dtl_id,
72 prmy_sort_val = p_rec.prmy_sort_val,
73 scnd_sort_val = p_rec.scnd_sort_val,
74 thrd_sort_val = p_rec.thrd_sort_val,
75 trans_seq_num = p_rec.trans_seq_num,
76 rcrd_seq_num = p_rec.rcrd_seq_num,
77 ext_rslt_id = p_rec.ext_rslt_id,
78 ext_rcd_id = p_rec.ext_rcd_id,
79 person_id = p_rec.person_id,
80 business_group_id = p_rec.business_group_id,
81 ext_per_bg_id = p_rec.ext_per_bg_id,
82 val_01 = p_rec.val_01,
83 val_02 = p_rec.val_02,
84 val_03 = p_rec.val_03,
85 val_04 = p_rec.val_04,
86 val_05 = p_rec.val_05,
87 val_06 = p_rec.val_06,
88 val_07 = p_rec.val_07,
89 val_08 = p_rec.val_08,
90 val_09 = p_rec.val_09,
91 val_10 = p_rec.val_10,
92 val_11 = p_rec.val_11,
93 val_12 = p_rec.val_12,
94 val_13 = p_rec.val_13,
95 val_14 = p_rec.val_14,
96 val_15 = p_rec.val_15,
97 val_16 = p_rec.val_16,
98 val_17 = p_rec.val_17,
99 val_19 = p_rec.val_19,
100 val_18 = p_rec.val_18,
101 val_20 = p_rec.val_20,
102 val_21 = p_rec.val_21,
103 val_22 = p_rec.val_22,
104 val_23 = p_rec.val_23,
105 val_24 = p_rec.val_24,
106 val_25 = p_rec.val_25,
107 val_26 = p_rec.val_26,
108 val_27 = p_rec.val_27,
109 val_28 = p_rec.val_28,
110 val_29 = p_rec.val_29,
111 val_30 = p_rec.val_30,
112 val_31 = p_rec.val_31,
113 val_32 = p_rec.val_32,
114 val_33 = p_rec.val_33,
115 val_34 = p_rec.val_34,
116 val_35 = p_rec.val_35,
117 val_36 = p_rec.val_36,
118 val_37 = p_rec.val_37,
119 val_38 = p_rec.val_38,
120 val_39 = p_rec.val_39,
121 val_40 = p_rec.val_40,
122 val_41 = p_rec.val_41,
123 val_42 = p_rec.val_42,
124 val_43 = p_rec.val_43,
125 val_44 = p_rec.val_44,
126 val_45 = p_rec.val_45,
127 val_46 = p_rec.val_46,
128 val_47 = p_rec.val_47,
129 val_48 = p_rec.val_48,
130 val_49 = p_rec.val_49,
131 val_50 = p_rec.val_50,
132 val_51 = p_rec.val_51,
133 val_52 = p_rec.val_52,
134 val_53 = p_rec.val_53,
135 val_54 = p_rec.val_54,
136 val_55 = p_rec.val_55,
137 val_56 = p_rec.val_56,
138 val_57 = p_rec.val_57,
139 val_58 = p_rec.val_58,
140 val_59 = p_rec.val_59,
141 val_60 = p_rec.val_60,
142 val_61 = p_rec.val_61,
143 val_62 = p_rec.val_62,
144 val_63 = p_rec.val_63,
145 val_64 = p_rec.val_64,
146 val_65 = p_rec.val_65,
147 val_66 = p_rec.val_66,
148 val_67 = p_rec.val_67,
149 val_68 = p_rec.val_68,
150 val_69 = p_rec.val_69,
151 val_70 = p_rec.val_70,
152 val_71 = p_rec.val_71,
153 val_72 = p_rec.val_72,
154 val_73 = p_rec.val_73,
155 val_74 = p_rec.val_74,
156 val_75 = p_rec.val_75,
157 val_76 = p_rec.val_76,
158 val_77 = p_rec.val_77,
159 val_78 = p_rec.val_78,
160 val_79 = p_rec.val_79,
161 val_80 = p_rec.val_80,
162 val_81 = p_rec.val_81,
163 val_82 = p_rec.val_82,
164 val_83 = p_rec.val_83,
165 val_84 = p_rec.val_84,
166 val_85 = p_rec.val_85,
167 val_86 = p_rec.val_86,
168 val_87 = p_rec.val_87,
169 val_88 = p_rec.val_88,
170 val_89 = p_rec.val_89,
171 val_90 = p_rec.val_90,
172 val_91 = p_rec.val_91,
173 val_92 = p_rec.val_92,
174 val_93 = p_rec.val_93,
175 val_94 = p_rec.val_94,
176 val_95 = p_rec.val_95,
177 val_96 = p_rec.val_96,
178 val_97 = p_rec.val_97,
179 val_98 = p_rec.val_98,
180 val_99 = p_rec.val_99,
181 val_100 = p_rec.val_100,
182 val_101 = p_rec.val_101,
183 val_102 = p_rec.val_102,
184 val_103 = p_rec.val_103,
185 val_104 = p_rec.val_104,
186 val_105 = p_rec.val_105,
187 val_106 = p_rec.val_106,
188 val_107 = p_rec.val_107,
189 val_108 = p_rec.val_108,
190 val_109 = p_rec.val_109,
191 val_110 = p_rec.val_110,
192 val_111 = p_rec.val_111,
193 val_112 = p_rec.val_112,
194 val_113 = p_rec.val_113,
195 val_114 = p_rec.val_114,
196 val_115 = p_rec.val_115,
197 val_116 = p_rec.val_116,
198 val_117 = p_rec.val_117,
199 val_119 = p_rec.val_119,
200 val_118 = p_rec.val_118,
201 val_120 = p_rec.val_120,
202 val_121 = p_rec.val_121,
203 val_122 = p_rec.val_122,
204 val_123 = p_rec.val_123,
205 val_124 = p_rec.val_124,
206 val_125 = p_rec.val_125,
207 val_126 = p_rec.val_126,
208 val_127 = p_rec.val_127,
209 val_128 = p_rec.val_128,
210 val_129 = p_rec.val_129,
211 val_130 = p_rec.val_130,
212 val_131 = p_rec.val_131,
213 val_132 = p_rec.val_132,
214 val_133 = p_rec.val_133,
215 val_134 = p_rec.val_134,
216 val_135 = p_rec.val_135,
217 val_136 = p_rec.val_136,
218 val_137 = p_rec.val_137,
219 val_138 = p_rec.val_138,
220 val_139 = p_rec.val_139,
221 val_140 = p_rec.val_140,
222 val_141 = p_rec.val_141,
223 val_142 = p_rec.val_142,
224 val_143 = p_rec.val_143,
225 val_144 = p_rec.val_144,
226 val_145 = p_rec.val_145,
227 val_146 = p_rec.val_146,
228 val_147 = p_rec.val_147,
229 val_148 = p_rec.val_148,
230 val_149 = p_rec.val_149,
231 val_150 = p_rec.val_150,
232 val_151 = p_rec.val_151,
233 val_152 = p_rec.val_152,
234 val_153 = p_rec.val_153,
235 val_154 = p_rec.val_154,
236 val_155 = p_rec.val_155,
237 val_156 = p_rec.val_156,
238 val_157 = p_rec.val_157,
239 val_158 = p_rec.val_158,
240 val_159 = p_rec.val_159,
241 val_160 = p_rec.val_160,
242 val_161 = p_rec.val_161,
243 val_162 = p_rec.val_162,
244 val_163 = p_rec.val_163,
245 val_164 = p_rec.val_164,
246 val_165 = p_rec.val_165,
247 val_166 = p_rec.val_166,
248 val_167 = p_rec.val_167,
249 val_168 = p_rec.val_168,
250 val_169 = p_rec.val_169,
251 val_170 = p_rec.val_170,
252 val_171 = p_rec.val_171,
253 val_172 = p_rec.val_172,
254 val_173 = p_rec.val_173,
255 val_174 = p_rec.val_174,
256 val_175 = p_rec.val_175,
257 val_176 = p_rec.val_176,
258 val_177 = p_rec.val_177,
259 val_178 = p_rec.val_178,
260 val_179 = p_rec.val_179,
261 val_180 = p_rec.val_180,
262 val_181 = p_rec.val_181,
263 val_182 = p_rec.val_182,
264 val_183 = p_rec.val_183,
265 val_184 = p_rec.val_184,
266 val_185 = p_rec.val_185,
267 val_186 = p_rec.val_186,
268 val_187 = p_rec.val_187,
269 val_188 = p_rec.val_188,
270 val_189 = p_rec.val_189,
271 val_190 = p_rec.val_190,
272 val_191 = p_rec.val_191,
273 val_192 = p_rec.val_192,
274 val_193 = p_rec.val_193,
275 val_194 = p_rec.val_194,
276 val_195 = p_rec.val_195,
277 val_196 = p_rec.val_196,
278 val_197 = p_rec.val_197,
279 val_198 = p_rec.val_198,
280 val_199 = p_rec.val_199,
281 val_200 = p_rec.val_200,
282 val_201 = p_rec.val_201,
283 val_202 = p_rec.val_202,
284 val_203 = p_rec.val_203,
285 val_204 = p_rec.val_204,
286 val_205 = p_rec.val_205,
287 val_206 = p_rec.val_206,
288 val_207 = p_rec.val_207,
289 val_208 = p_rec.val_208,
290 val_209 = p_rec.val_209,
291 val_210 = p_rec.val_210,
292 val_211 = p_rec.val_211,
293 val_212 = p_rec.val_212,
294 val_213 = p_rec.val_213,
295 val_214 = p_rec.val_214,
296 val_215 = p_rec.val_215,
297 val_216 = p_rec.val_216,
298 val_217 = p_rec.val_217,
299 val_219 = p_rec.val_219,
300 val_218 = p_rec.val_218,
301 val_220 = p_rec.val_220,
302 val_221 = p_rec.val_221,
303 val_222 = p_rec.val_222,
304 val_223 = p_rec.val_223,
305 val_224 = p_rec.val_224,
306 val_225 = p_rec.val_225,
307 val_226 = p_rec.val_226,
308 val_227 = p_rec.val_227,
309 val_228 = p_rec.val_228,
310 val_229 = p_rec.val_229,
311 val_230 = p_rec.val_230,
312 val_231 = p_rec.val_231,
313 val_232 = p_rec.val_232,
314 val_233 = p_rec.val_233,
315 val_234 = p_rec.val_234,
316 val_235 = p_rec.val_235,
317 val_236 = p_rec.val_236,
318 val_237 = p_rec.val_237,
319 val_238 = p_rec.val_238,
320 val_239 = p_rec.val_239,
321 val_240 = p_rec.val_240,
322 val_241 = p_rec.val_241,
323 val_242 = p_rec.val_242,
324 val_243 = p_rec.val_243,
325 val_244 = p_rec.val_244,
326 val_245 = p_rec.val_245,
327 val_246 = p_rec.val_246,
328 val_247 = p_rec.val_247,
329 val_248 = p_rec.val_248,
330 val_249 = p_rec.val_249,
331 val_250 = p_rec.val_250,
332 val_251 = p_rec.val_251,
333 val_252 = p_rec.val_252,
334 val_253 = p_rec.val_253,
335 val_254 = p_rec.val_254,
336 val_255 = p_rec.val_255,
337 val_256 = p_rec.val_256,
338 val_257 = p_rec.val_257,
339 val_258 = p_rec.val_258,
340 val_259 = p_rec.val_259,
341 val_260 = p_rec.val_260,
342 val_261 = p_rec.val_261,
343 val_262 = p_rec.val_262,
344 val_263 = p_rec.val_263,
345 val_264 = p_rec.val_264,
346 val_265 = p_rec.val_265,
347 val_266 = p_rec.val_266,
348 val_267 = p_rec.val_267,
349 val_268 = p_rec.val_268,
350 val_269 = p_rec.val_269,
351 val_270 = p_rec.val_270,
352 val_271 = p_rec.val_271,
353 val_272 = p_rec.val_272,
354 val_273 = p_rec.val_273,
355 val_274 = p_rec.val_274,
356 val_275 = p_rec.val_275,
357 val_276 = p_rec.val_276,
358 val_277 = p_rec.val_277,
359 val_278 = p_rec.val_278,
360 val_279 = p_rec.val_279,
361 val_280 = p_rec.val_280,
362 val_281 = p_rec.val_281,
363 val_282 = p_rec.val_282,
364 val_283 = p_rec.val_283,
365 val_284 = p_rec.val_284,
366 val_285 = p_rec.val_285,
367 val_286 = p_rec.val_286,
368 val_287 = p_rec.val_287,
369 val_288 = p_rec.val_288,
370 val_289 = p_rec.val_289,
371 val_290 = p_rec.val_290,
372 val_291 = p_rec.val_291,
373 val_292 = p_rec.val_292,
374 val_293 = p_rec.val_293,
375 val_294 = p_rec.val_294,
376 val_295 = p_rec.val_295,
377 val_296 = p_rec.val_296,
378 val_297 = p_rec.val_297,
379 val_298 = p_rec.val_298,
380 val_299 = p_rec.val_299,
381 val_300 = p_rec.val_300,
382 group_val_01 = p_rec.group_val_01,
383 group_val_02 = p_rec.group_val_02,
384 program_application_id = p_rec.program_application_id,
385 program_id = p_rec.program_id,
386 program_update_date = p_rec.program_update_date,
387 request_id = p_rec.request_id,
388 object_version_number = p_rec.object_version_number,
389 ext_rcd_in_file_id = p_rec.ext_rcd_in_file_id
390 where ext_rslt_dtl_id = p_rec.ext_rslt_dtl_id;
391 --
392 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
393 --
394 hr_utility.set_location(' Leaving:'||l_proc, 10);
395 --
396 Exception
397 When hr_api.check_integrity_violated Then
398 -- A check constraint has been violated
399 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
400 ben_xrd_shd.constraint_error
401 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
402 When hr_api.parent_integrity_violated Then
403 -- Parent integrity has been violated
404 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
405 ben_xrd_shd.constraint_error
406 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
407 When hr_api.unique_integrity_violated Then
408 -- Unique integrity has been violated
409 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
410 ben_xrd_shd.constraint_error
411 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
412 When Others Then
413 ben_xrd_shd.g_api_dml := false; -- Unset the api dml status
414 Raise;
415 End update_dml;
416 --
417 -- ----------------------------------------------------------------------------
418 -- |------------------------------< pre_update >------------------------------|
419 -- ----------------------------------------------------------------------------
420 -- {Start Of Comments}
421 --
422 -- Description:
423 -- This private procedure contains any processing which is required before
424 -- the update dml.
425 --
426 -- Prerequisites:
427 -- This is an internal procedure which is called from the upd procedure.
428 --
429 -- In Parameters:
430 -- A Pl/Sql record structre.
431 --
432 -- Post Success:
433 -- Processing continues.
434 --
435 -- Post Failure:
436 -- If an error has occurred, an error message and exception will be raised
437 -- but not handled.
438 --
439 -- Developer Implementation Notes:
440 -- Any pre-processing required before the update dml is issued should be
441 -- coded within this procedure. It is important to note that any 3rd party
442 -- maintenance should be reviewed before placing in this procedure.
443 --
444 -- Access Status:
445 -- Internal Row Handler Use Only.
446 --
447 -- {End Of Comments}
448 -- ----------------------------------------------------------------------------
449 Procedure pre_update(p_rec in ben_xrd_shd.g_rec_type) is
450 --
451 l_proc varchar2(72) := g_package||'pre_update';
452 --
453 Begin
454 hr_utility.set_location('Entering:'||l_proc, 5);
455 --
456 hr_utility.set_location(' Leaving:'||l_proc, 10);
457 End pre_update;
458 --
459 -- ----------------------------------------------------------------------------
460 -- |-----------------------------< post_update >------------------------------|
461 -- ----------------------------------------------------------------------------
462 -- {Start Of Comments}
463 --
464 -- Description:
465 -- This private procedure contains any processing which is required after the
466 -- update dml.
467 --
468 -- Prerequisites:
469 -- This is an internal procedure which is called from the upd procedure.
470 --
471 -- In Parameters:
472 -- A Pl/Sql record structre.
473 --
474 -- Post Success:
475 -- Processing continues.
476 --
477 -- Post Failure:
478 -- If an error has occurred, an error message and exception will be raised
479 -- but not handled.
480 --
481 -- Developer Implementation Notes:
482 -- Any post-processing required after the update dml is issued should be
483 -- coded within this procedure. It is important to note that any 3rd party
484 -- maintenance should be reviewed before placing in this procedure.
485 --
486 -- Access Status:
487 -- Internal Row Handler Use Only.
488 --
489 -- {End Of Comments}
490 -- ----------------------------------------------------------------------------
491 Procedure post_update(p_rec in ben_xrd_shd.g_rec_type) is
492 --
493 l_proc varchar2(72) := g_package||'post_update';
494 --
495 Begin
496 hr_utility.set_location('Entering:'||l_proc, 5);
497 --
498 --
499 -- Start of API User Hook for post_update.
500 --
501 begin
502 --
503 ben_xrd_rku.after_update
504 (
505 p_ext_rslt_dtl_id =>p_rec.ext_rslt_dtl_id
506 ,p_prmy_sort_val =>p_rec.prmy_sort_val
507 ,p_scnd_sort_val =>p_rec.scnd_sort_val
508 ,p_thrd_sort_val =>p_rec.thrd_sort_val
509 ,p_trans_seq_num =>p_rec.trans_seq_num
510 ,p_rcrd_seq_num =>p_rec.rcrd_seq_num
511 ,p_ext_rslt_id =>p_rec.ext_rslt_id
512 ,p_ext_rcd_id =>p_rec.ext_rcd_id
513 ,p_person_id =>p_rec.person_id
514 ,p_business_group_id =>p_rec.business_group_id
515 ,p_ext_per_bg_id =>p_rec.ext_per_bg_id
516 ,p_val_01 =>p_rec.val_01
517 ,p_val_02 =>p_rec.val_02
518 ,p_val_03 =>p_rec.val_03
519 ,p_val_04 =>p_rec.val_04
520 ,p_val_05 =>p_rec.val_05
521 ,p_val_06 =>p_rec.val_06
522 ,p_val_07 =>p_rec.val_07
523 ,p_val_08 =>p_rec.val_08
524 ,p_val_09 =>p_rec.val_09
525 ,p_val_10 =>p_rec.val_10
526 ,p_val_11 =>p_rec.val_11
527 ,p_val_12 =>p_rec.val_12
528 ,p_val_13 =>p_rec.val_13
529 ,p_val_14 =>p_rec.val_14
530 ,p_val_15 =>p_rec.val_15
531 ,p_val_16 =>p_rec.val_16
532 ,p_val_17 =>p_rec.val_17
533 ,p_val_19 =>p_rec.val_19
534 ,p_val_18 =>p_rec.val_18
535 ,p_val_20 =>p_rec.val_20
536 ,p_val_21 =>p_rec.val_21
537 ,p_val_22 =>p_rec.val_22
538 ,p_val_23 =>p_rec.val_23
539 ,p_val_24 =>p_rec.val_24
540 ,p_val_25 =>p_rec.val_25
541 ,p_val_26 =>p_rec.val_26
542 ,p_val_27 =>p_rec.val_27
543 ,p_val_28 =>p_rec.val_28
544 ,p_val_29 =>p_rec.val_29
545 ,p_val_30 =>p_rec.val_30
546 ,p_val_31 =>p_rec.val_31
547 ,p_val_32 =>p_rec.val_32
548 ,p_val_33 =>p_rec.val_33
549 ,p_val_34 =>p_rec.val_34
550 ,p_val_35 =>p_rec.val_35
551 ,p_val_36 =>p_rec.val_36
552 ,p_val_37 =>p_rec.val_37
553 ,p_val_38 =>p_rec.val_38
554 ,p_val_39 =>p_rec.val_39
555 ,p_val_40 =>p_rec.val_40
556 ,p_val_41 =>p_rec.val_41
557 ,p_val_42 =>p_rec.val_42
558 ,p_val_43 =>p_rec.val_43
559 ,p_val_44 =>p_rec.val_44
560 ,p_val_45 =>p_rec.val_45
561 ,p_val_46 =>p_rec.val_46
562 ,p_val_47 =>p_rec.val_47
563 ,p_val_48 =>p_rec.val_48
564 ,p_val_49 =>p_rec.val_49
565 ,p_val_50 =>p_rec.val_50
566 ,p_val_51 =>p_rec.val_51
567 ,p_val_52 =>p_rec.val_52
568 ,p_val_53 =>p_rec.val_53
569 ,p_val_54 =>p_rec.val_54
570 ,p_val_55 =>p_rec.val_55
571 ,p_val_56 =>p_rec.val_56
572 ,p_val_57 =>p_rec.val_57
573 ,p_val_58 =>p_rec.val_58
574 ,p_val_59 =>p_rec.val_59
575 ,p_val_60 =>p_rec.val_60
576 ,p_val_61 =>p_rec.val_61
577 ,p_val_62 =>p_rec.val_62
578 ,p_val_63 =>p_rec.val_63
579 ,p_val_64 =>p_rec.val_64
580 ,p_val_65 =>p_rec.val_65
581 ,p_val_66 =>p_rec.val_66
582 ,p_val_67 =>p_rec.val_67
583 ,p_val_68 =>p_rec.val_68
584 ,p_val_69 =>p_rec.val_69
585 ,p_val_70 =>p_rec.val_70
586 ,p_val_71 =>p_rec.val_71
587 ,p_val_72 =>p_rec.val_72
588 ,p_val_73 =>p_rec.val_73
589 ,p_val_74 =>p_rec.val_74
590 ,p_val_75 =>p_rec.val_75
591 ,p_val_76 =>p_rec.val_76
592 ,p_val_77 =>p_rec.val_77
593 ,p_val_78 =>p_rec.val_78
594 ,p_val_79 =>p_rec.val_79
595 ,p_val_80 =>p_rec.val_80
596 ,p_val_81 =>p_rec.val_81
597 ,p_val_82 =>p_rec.val_82
598 ,p_val_83 =>p_rec.val_83
599 ,p_val_84 =>p_rec.val_84
600 ,p_val_85 =>p_rec.val_85
601 ,p_val_86 =>p_rec.val_86
602 ,p_val_87 =>p_rec.val_87
603 ,p_val_88 =>p_rec.val_88
604 ,p_val_89 =>p_rec.val_89
605 ,p_val_90 =>p_rec.val_90
606 ,p_val_91 =>p_rec.val_91
607 ,p_val_92 =>p_rec.val_92
608 ,p_val_93 =>p_rec.val_93
609 ,p_val_94 =>p_rec.val_94
610 ,p_val_95 =>p_rec.val_95
611 ,p_val_96 =>p_rec.val_96
612 ,p_val_97 =>p_rec.val_97
613 ,p_val_98 =>p_rec.val_98
614 ,p_val_99 =>p_rec.val_99
615 ,p_val_100 =>p_rec.val_100
616 ,p_val_101 =>p_rec.val_101
617 ,p_val_102 =>p_rec.val_102
618 ,p_val_103 =>p_rec.val_103
619 ,p_val_104 =>p_rec.val_104
620 ,p_val_105 =>p_rec.val_105
621 ,p_val_106 =>p_rec.val_106
622 ,p_val_107 =>p_rec.val_107
623 ,p_val_108 =>p_rec.val_108
624 ,p_val_109 =>p_rec.val_109
625 ,p_val_110 =>p_rec.val_110
626 ,p_val_111 =>p_rec.val_111
627 ,p_val_112 =>p_rec.val_112
628 ,p_val_113 =>p_rec.val_113
629 ,p_val_114 =>p_rec.val_114
630 ,p_val_115 =>p_rec.val_115
631 ,p_val_116 =>p_rec.val_116
632 ,p_val_117 =>p_rec.val_117
633 ,p_val_119 =>p_rec.val_119
634 ,p_val_118 =>p_rec.val_118
635 ,p_val_120 =>p_rec.val_120
636 ,p_val_121 =>p_rec.val_121
637 ,p_val_122 =>p_rec.val_122
638 ,p_val_123 =>p_rec.val_123
639 ,p_val_124 =>p_rec.val_124
640 ,p_val_125 =>p_rec.val_125
641 ,p_val_126 =>p_rec.val_126
642 ,p_val_127 =>p_rec.val_127
643 ,p_val_128 =>p_rec.val_128
644 ,p_val_129 =>p_rec.val_129
645 ,p_val_130 =>p_rec.val_130
646 ,p_val_131 =>p_rec.val_131
647 ,p_val_132 =>p_rec.val_132
648 ,p_val_133 =>p_rec.val_133
649 ,p_val_134 =>p_rec.val_134
650 ,p_val_135 =>p_rec.val_135
651 ,p_val_136 =>p_rec.val_136
652 ,p_val_137 =>p_rec.val_137
653 ,p_val_138 =>p_rec.val_138
654 ,p_val_139 =>p_rec.val_139
655 ,p_val_140 =>p_rec.val_140
656 ,p_val_141 =>p_rec.val_141
657 ,p_val_142 =>p_rec.val_142
658 ,p_val_143 =>p_rec.val_143
659 ,p_val_144 =>p_rec.val_144
660 ,p_val_145 =>p_rec.val_145
661 ,p_val_146 =>p_rec.val_146
662 ,p_val_147 =>p_rec.val_147
663 ,p_val_148 =>p_rec.val_148
664 ,p_val_149 =>p_rec.val_149
665 ,p_val_150 =>p_rec.val_150
666 ,p_val_151 =>p_rec.val_151
667 ,p_val_152 =>p_rec.val_152
668 ,p_val_153 =>p_rec.val_153
669 ,p_val_154 =>p_rec.val_154
670 ,p_val_155 =>p_rec.val_155
671 ,p_val_156 =>p_rec.val_156
672 ,p_val_157 =>p_rec.val_157
673 ,p_val_158 =>p_rec.val_158
674 ,p_val_159 =>p_rec.val_159
675 ,p_val_160 =>p_rec.val_160
676 ,p_val_161 =>p_rec.val_161
677 ,p_val_162 =>p_rec.val_162
678 ,p_val_163 =>p_rec.val_163
679 ,p_val_164 =>p_rec.val_164
680 ,p_val_165 =>p_rec.val_165
681 ,p_val_166 =>p_rec.val_166
682 ,p_val_167 =>p_rec.val_167
683 ,p_val_168 =>p_rec.val_168
684 ,p_val_169 =>p_rec.val_169
685 ,p_val_170 =>p_rec.val_170
686 ,p_val_171 =>p_rec.val_171
687 ,p_val_172 =>p_rec.val_172
688 ,p_val_173 =>p_rec.val_173
689 ,p_val_174 =>p_rec.val_174
690 ,p_val_175 =>p_rec.val_175
691 ,p_val_176 =>p_rec.val_176
692 ,p_val_177 =>p_rec.val_177
693 ,p_val_178 =>p_rec.val_178
694 ,p_val_179 =>p_rec.val_179
695 ,p_val_180 =>p_rec.val_180
696 ,p_val_181 =>p_rec.val_181
697 ,p_val_182 =>p_rec.val_182
698 ,p_val_183 =>p_rec.val_183
699 ,p_val_184 =>p_rec.val_184
700 ,p_val_185 =>p_rec.val_185
701 ,p_val_186 =>p_rec.val_186
702 ,p_val_187 =>p_rec.val_187
703 ,p_val_188 =>p_rec.val_188
704 ,p_val_189 =>p_rec.val_189
705 ,p_val_190 =>p_rec.val_190
706 ,p_val_191 =>p_rec.val_191
707 ,p_val_192 =>p_rec.val_192
708 ,p_val_193 =>p_rec.val_193
709 ,p_val_194 =>p_rec.val_194
710 ,p_val_195 =>p_rec.val_195
711 ,p_val_196 =>p_rec.val_196
712 ,p_val_197 =>p_rec.val_197
713 ,p_val_198 =>p_rec.val_198
714 ,p_val_199 =>p_rec.val_199
715 ,p_val_200 =>p_rec.val_200
716 ,p_val_201 =>p_rec.val_201
717 ,p_val_202 =>p_rec.val_202
718 ,p_val_203 =>p_rec.val_203
719 ,p_val_204 =>p_rec.val_204
720 ,p_val_205 =>p_rec.val_205
721 ,p_val_206 =>p_rec.val_206
722 ,p_val_207 =>p_rec.val_207
723 ,p_val_208 =>p_rec.val_208
724 ,p_val_209 =>p_rec.val_209
725 ,p_val_210 =>p_rec.val_210
726 ,p_val_211 =>p_rec.val_211
727 ,p_val_212 =>p_rec.val_212
728 ,p_val_213 =>p_rec.val_213
729 ,p_val_214 =>p_rec.val_214
730 ,p_val_215 =>p_rec.val_215
731 ,p_val_216 =>p_rec.val_216
732 ,p_val_217 =>p_rec.val_217
733 ,p_val_219 =>p_rec.val_219
734 ,p_val_218 =>p_rec.val_218
735 ,p_val_220 =>p_rec.val_220
736 ,p_val_221 =>p_rec.val_221
737 ,p_val_222 =>p_rec.val_222
738 ,p_val_223 =>p_rec.val_223
739 ,p_val_224 =>p_rec.val_224
740 ,p_val_225 =>p_rec.val_225
741 ,p_val_226 =>p_rec.val_226
742 ,p_val_227 =>p_rec.val_227
743 ,p_val_228 =>p_rec.val_228
744 ,p_val_229 =>p_rec.val_229
745 ,p_val_230 =>p_rec.val_230
746 ,p_val_231 =>p_rec.val_231
747 ,p_val_232 =>p_rec.val_232
748 ,p_val_233 =>p_rec.val_233
749 ,p_val_234 =>p_rec.val_234
750 ,p_val_235 =>p_rec.val_235
751 ,p_val_236 =>p_rec.val_236
752 ,p_val_237 =>p_rec.val_237
753 ,p_val_238 =>p_rec.val_238
754 ,p_val_239 =>p_rec.val_239
755 ,p_val_240 =>p_rec.val_240
756 ,p_val_241 =>p_rec.val_241
757 ,p_val_242 =>p_rec.val_242
758 ,p_val_243 =>p_rec.val_243
759 ,p_val_244 =>p_rec.val_244
760 ,p_val_245 =>p_rec.val_245
761 ,p_val_246 =>p_rec.val_246
762 ,p_val_247 =>p_rec.val_247
763 ,p_val_248 =>p_rec.val_248
764 ,p_val_249 =>p_rec.val_249
765 ,p_val_250 =>p_rec.val_250
766 ,p_val_251 =>p_rec.val_251
767 ,p_val_252 =>p_rec.val_252
768 ,p_val_253 =>p_rec.val_253
769 ,p_val_254 =>p_rec.val_254
770 ,p_val_255 =>p_rec.val_255
771 ,p_val_256 =>p_rec.val_256
772 ,p_val_257 =>p_rec.val_257
773 ,p_val_258 =>p_rec.val_258
774 ,p_val_259 =>p_rec.val_259
775 ,p_val_260 =>p_rec.val_260
776 ,p_val_261 =>p_rec.val_261
777 ,p_val_262 =>p_rec.val_262
778 ,p_val_263 =>p_rec.val_263
779 ,p_val_264 =>p_rec.val_264
780 ,p_val_265 =>p_rec.val_265
781 ,p_val_266 =>p_rec.val_266
782 ,p_val_267 =>p_rec.val_267
783 ,p_val_268 =>p_rec.val_268
784 ,p_val_269 =>p_rec.val_269
785 ,p_val_270 =>p_rec.val_270
786 ,p_val_271 =>p_rec.val_271
787 ,p_val_272 =>p_rec.val_272
788 ,p_val_273 =>p_rec.val_273
789 ,p_val_274 =>p_rec.val_274
790 ,p_val_275 =>p_rec.val_275
791 ,p_val_276 =>p_rec.val_276
792 ,p_val_277 =>p_rec.val_277
793 ,p_val_278 =>p_rec.val_278
794 ,p_val_279 =>p_rec.val_279
795 ,p_val_280 =>p_rec.val_280
796 ,p_val_281 =>p_rec.val_281
797 ,p_val_282 =>p_rec.val_282
798 ,p_val_283 =>p_rec.val_283
799 ,p_val_284 =>p_rec.val_284
800 ,p_val_285 =>p_rec.val_285
801 ,p_val_286 =>p_rec.val_286
802 ,p_val_287 =>p_rec.val_287
803 ,p_val_288 =>p_rec.val_288
804 ,p_val_289 =>p_rec.val_289
805 ,p_val_290 =>p_rec.val_290
806 ,p_val_291 =>p_rec.val_291
807 ,p_val_292 =>p_rec.val_292
808 ,p_val_293 =>p_rec.val_293
809 ,p_val_294 =>p_rec.val_294
810 ,p_val_295 =>p_rec.val_295
811 ,p_val_296 =>p_rec.val_296
812 ,p_val_297 =>p_rec.val_297
813 ,p_val_298 =>p_rec.val_298
814 ,p_val_299 =>p_rec.val_299
815 ,p_val_300 =>p_rec.val_300
816 ,p_group_val_01 => p_rec.group_val_01
817 ,p_group_val_02 => p_rec.group_val_02
818 ,p_program_application_id =>p_rec.program_application_id
819 ,p_program_id =>p_rec.program_id
820 ,p_program_update_date =>p_rec.program_update_date
821 ,p_request_id =>p_rec.request_id
822 ,p_object_version_number =>p_rec.object_version_number
823 ,p_ext_rcd_in_file_id =>p_rec.ext_rcd_in_file_id
824 ,p_prmy_sort_val_o =>ben_xrd_shd.g_old_rec.prmy_sort_val
825 ,p_scnd_sort_val_o =>ben_xrd_shd.g_old_rec.scnd_sort_val
826 ,p_thrd_sort_val_o =>ben_xrd_shd.g_old_rec.thrd_sort_val
827 ,p_trans_seq_num_o =>ben_xrd_shd.g_old_rec.trans_seq_num
828 ,p_rcrd_seq_num_o =>ben_xrd_shd.g_old_rec.rcrd_seq_num
829 ,p_ext_rslt_id_o =>ben_xrd_shd.g_old_rec.ext_rslt_id
830 ,p_ext_rcd_id_o =>ben_xrd_shd.g_old_rec.ext_rcd_id
831 ,p_person_id_o =>ben_xrd_shd.g_old_rec.person_id
832 ,p_business_group_id_o =>ben_xrd_shd.g_old_rec.business_group_id
833 ,p_ext_per_bg_id_o =>ben_xrd_shd.g_old_rec.ext_per_bg_id
834 ,p_val_01_o =>ben_xrd_shd.g_old_rec.val_01
835 ,p_val_02_o =>ben_xrd_shd.g_old_rec.val_02
836 ,p_val_03_o =>ben_xrd_shd.g_old_rec.val_03
837 ,p_val_04_o =>ben_xrd_shd.g_old_rec.val_04
838 ,p_val_05_o =>ben_xrd_shd.g_old_rec.val_05
839 ,p_val_06_o =>ben_xrd_shd.g_old_rec.val_06
840 ,p_val_07_o =>ben_xrd_shd.g_old_rec.val_07
841 ,p_val_08_o =>ben_xrd_shd.g_old_rec.val_08
842 ,p_val_09_o =>ben_xrd_shd.g_old_rec.val_09
843 ,p_val_10_o =>ben_xrd_shd.g_old_rec.val_10
844 ,p_val_11_o =>ben_xrd_shd.g_old_rec.val_11
845 ,p_val_12_o =>ben_xrd_shd.g_old_rec.val_12
846 ,p_val_13_o =>ben_xrd_shd.g_old_rec.val_13
847 ,p_val_14_o =>ben_xrd_shd.g_old_rec.val_14
848 ,p_val_15_o =>ben_xrd_shd.g_old_rec.val_15
849 ,p_val_16_o =>ben_xrd_shd.g_old_rec.val_16
850 ,p_val_17_o =>ben_xrd_shd.g_old_rec.val_17
851 ,p_val_19_o =>ben_xrd_shd.g_old_rec.val_19
852 ,p_val_18_o =>ben_xrd_shd.g_old_rec.val_18
853 ,p_val_20_o =>ben_xrd_shd.g_old_rec.val_20
854 ,p_val_21_o =>ben_xrd_shd.g_old_rec.val_21
855 ,p_val_22_o =>ben_xrd_shd.g_old_rec.val_22
856 ,p_val_23_o =>ben_xrd_shd.g_old_rec.val_23
857 ,p_val_24_o =>ben_xrd_shd.g_old_rec.val_24
858 ,p_val_25_o =>ben_xrd_shd.g_old_rec.val_25
859 ,p_val_26_o =>ben_xrd_shd.g_old_rec.val_26
860 ,p_val_27_o =>ben_xrd_shd.g_old_rec.val_27
861 ,p_val_28_o =>ben_xrd_shd.g_old_rec.val_28
862 ,p_val_29_o =>ben_xrd_shd.g_old_rec.val_29
863 ,p_val_30_o =>ben_xrd_shd.g_old_rec.val_30
864 ,p_val_31_o =>ben_xrd_shd.g_old_rec.val_31
865 ,p_val_32_o =>ben_xrd_shd.g_old_rec.val_32
866 ,p_val_33_o =>ben_xrd_shd.g_old_rec.val_33
867 ,p_val_34_o =>ben_xrd_shd.g_old_rec.val_34
868 ,p_val_35_o =>ben_xrd_shd.g_old_rec.val_35
869 ,p_val_36_o =>ben_xrd_shd.g_old_rec.val_36
870 ,p_val_37_o =>ben_xrd_shd.g_old_rec.val_37
871 ,p_val_38_o =>ben_xrd_shd.g_old_rec.val_38
872 ,p_val_39_o =>ben_xrd_shd.g_old_rec.val_39
873 ,p_val_40_o =>ben_xrd_shd.g_old_rec.val_40
874 ,p_val_41_o =>ben_xrd_shd.g_old_rec.val_41
875 ,p_val_42_o =>ben_xrd_shd.g_old_rec.val_42
876 ,p_val_43_o =>ben_xrd_shd.g_old_rec.val_43
877 ,p_val_44_o =>ben_xrd_shd.g_old_rec.val_44
878 ,p_val_45_o =>ben_xrd_shd.g_old_rec.val_45
879 ,p_val_46_o =>ben_xrd_shd.g_old_rec.val_46
880 ,p_val_47_o =>ben_xrd_shd.g_old_rec.val_47
881 ,p_val_48_o =>ben_xrd_shd.g_old_rec.val_48
882 ,p_val_49_o =>ben_xrd_shd.g_old_rec.val_49
883 ,p_val_50_o =>ben_xrd_shd.g_old_rec.val_50
884 ,p_val_51_o =>ben_xrd_shd.g_old_rec.val_51
885 ,p_val_52_o =>ben_xrd_shd.g_old_rec.val_52
886 ,p_val_53_o =>ben_xrd_shd.g_old_rec.val_53
887 ,p_val_54_o =>ben_xrd_shd.g_old_rec.val_54
888 ,p_val_55_o =>ben_xrd_shd.g_old_rec.val_55
889 ,p_val_56_o =>ben_xrd_shd.g_old_rec.val_56
890 ,p_val_57_o =>ben_xrd_shd.g_old_rec.val_57
891 ,p_val_58_o =>ben_xrd_shd.g_old_rec.val_58
892 ,p_val_59_o =>ben_xrd_shd.g_old_rec.val_59
893 ,p_val_60_o =>ben_xrd_shd.g_old_rec.val_60
894 ,p_val_61_o =>ben_xrd_shd.g_old_rec.val_61
895 ,p_val_62_o =>ben_xrd_shd.g_old_rec.val_62
896 ,p_val_63_o =>ben_xrd_shd.g_old_rec.val_63
897 ,p_val_64_o =>ben_xrd_shd.g_old_rec.val_64
898 ,p_val_65_o =>ben_xrd_shd.g_old_rec.val_65
899 ,p_val_66_o =>ben_xrd_shd.g_old_rec.val_66
900 ,p_val_67_o =>ben_xrd_shd.g_old_rec.val_67
901 ,p_val_68_o =>ben_xrd_shd.g_old_rec.val_68
902 ,p_val_69_o =>ben_xrd_shd.g_old_rec.val_69
903 ,p_val_70_o =>ben_xrd_shd.g_old_rec.val_70
904 ,p_val_71_o =>ben_xrd_shd.g_old_rec.val_71
905 ,p_val_72_o =>ben_xrd_shd.g_old_rec.val_72
906 ,p_val_73_o =>ben_xrd_shd.g_old_rec.val_73
907 ,p_val_74_o =>ben_xrd_shd.g_old_rec.val_74
908 ,p_val_75_o =>ben_xrd_shd.g_old_rec.val_75
909 ,p_val_76_o =>ben_xrd_shd.g_old_rec.val_76
910 ,p_val_77_o =>ben_xrd_shd.g_old_rec.val_77
911 ,p_val_78_o =>ben_xrd_shd.g_old_rec.val_78
912 ,p_val_79_o =>ben_xrd_shd.g_old_rec.val_79
913 ,p_val_80_o =>ben_xrd_shd.g_old_rec.val_80
914 ,p_val_81_o =>ben_xrd_shd.g_old_rec.val_81
915 ,p_val_82_o =>ben_xrd_shd.g_old_rec.val_82
916 ,p_val_83_o =>ben_xrd_shd.g_old_rec.val_83
917 ,p_val_84_o =>ben_xrd_shd.g_old_rec.val_84
918 ,p_val_85_o =>ben_xrd_shd.g_old_rec.val_85
919 ,p_val_86_o =>ben_xrd_shd.g_old_rec.val_86
920 ,p_val_87_o =>ben_xrd_shd.g_old_rec.val_87
921 ,p_val_88_o =>ben_xrd_shd.g_old_rec.val_88
922 ,p_val_89_o =>ben_xrd_shd.g_old_rec.val_89
923 ,p_val_90_o =>ben_xrd_shd.g_old_rec.val_90
924 ,p_val_91_o =>ben_xrd_shd.g_old_rec.val_91
925 ,p_val_92_o =>ben_xrd_shd.g_old_rec.val_92
926 ,p_val_93_o =>ben_xrd_shd.g_old_rec.val_93
927 ,p_val_94_o =>ben_xrd_shd.g_old_rec.val_94
928 ,p_val_95_o =>ben_xrd_shd.g_old_rec.val_95
929 ,p_val_96_o =>ben_xrd_shd.g_old_rec.val_96
930 ,p_val_97_o =>ben_xrd_shd.g_old_rec.val_97
931 ,p_val_98_o =>ben_xrd_shd.g_old_rec.val_98
932 ,p_val_99_o =>ben_xrd_shd.g_old_rec.val_99
933 ,p_val_100_o =>ben_xrd_shd.g_old_rec.val_100
934 ,p_val_101_o =>ben_xrd_shd.g_old_rec.val_101
935 ,p_val_102_o =>ben_xrd_shd.g_old_rec.val_102
936 ,p_val_103_o =>ben_xrd_shd.g_old_rec.val_103
937 ,p_val_104_o =>ben_xrd_shd.g_old_rec.val_104
938 ,p_val_105_o =>ben_xrd_shd.g_old_rec.val_105
939 ,p_val_106_o =>ben_xrd_shd.g_old_rec.val_106
940 ,p_val_107_o =>ben_xrd_shd.g_old_rec.val_107
941 ,p_val_108_o =>ben_xrd_shd.g_old_rec.val_108
942 ,p_val_109_o =>ben_xrd_shd.g_old_rec.val_109
943 ,p_val_110_o =>ben_xrd_shd.g_old_rec.val_110
944 ,p_val_111_o =>ben_xrd_shd.g_old_rec.val_111
945 ,p_val_112_o =>ben_xrd_shd.g_old_rec.val_112
946 ,p_val_113_o =>ben_xrd_shd.g_old_rec.val_113
947 ,p_val_114_o =>ben_xrd_shd.g_old_rec.val_114
948 ,p_val_115_o =>ben_xrd_shd.g_old_rec.val_115
949 ,p_val_116_o =>ben_xrd_shd.g_old_rec.val_116
950 ,p_val_117_o =>ben_xrd_shd.g_old_rec.val_117
951 ,p_val_119_o =>ben_xrd_shd.g_old_rec.val_119
952 ,p_val_118_o =>ben_xrd_shd.g_old_rec.val_118
953 ,p_val_120_o =>ben_xrd_shd.g_old_rec.val_120
954 ,p_val_121_o =>ben_xrd_shd.g_old_rec.val_121
955 ,p_val_122_o =>ben_xrd_shd.g_old_rec.val_122
956 ,p_val_123_o =>ben_xrd_shd.g_old_rec.val_123
957 ,p_val_124_o =>ben_xrd_shd.g_old_rec.val_124
958 ,p_val_125_o =>ben_xrd_shd.g_old_rec.val_125
959 ,p_val_126_o =>ben_xrd_shd.g_old_rec.val_126
960 ,p_val_127_o =>ben_xrd_shd.g_old_rec.val_127
961 ,p_val_128_o =>ben_xrd_shd.g_old_rec.val_128
962 ,p_val_129_o =>ben_xrd_shd.g_old_rec.val_129
963 ,p_val_130_o =>ben_xrd_shd.g_old_rec.val_130
964 ,p_val_131_o =>ben_xrd_shd.g_old_rec.val_131
965 ,p_val_132_o =>ben_xrd_shd.g_old_rec.val_132
966 ,p_val_133_o =>ben_xrd_shd.g_old_rec.val_133
967 ,p_val_134_o =>ben_xrd_shd.g_old_rec.val_134
968 ,p_val_135_o =>ben_xrd_shd.g_old_rec.val_135
969 ,p_val_136_o =>ben_xrd_shd.g_old_rec.val_136
970 ,p_val_137_o =>ben_xrd_shd.g_old_rec.val_137
971 ,p_val_138_o =>ben_xrd_shd.g_old_rec.val_138
972 ,p_val_139_o =>ben_xrd_shd.g_old_rec.val_139
973 ,p_val_140_o =>ben_xrd_shd.g_old_rec.val_140
974 ,p_val_141_o =>ben_xrd_shd.g_old_rec.val_141
975 ,p_val_142_o =>ben_xrd_shd.g_old_rec.val_142
976 ,p_val_143_o =>ben_xrd_shd.g_old_rec.val_143
977 ,p_val_144_o =>ben_xrd_shd.g_old_rec.val_144
978 ,p_val_145_o =>ben_xrd_shd.g_old_rec.val_145
979 ,p_val_146_o =>ben_xrd_shd.g_old_rec.val_146
980 ,p_val_147_o =>ben_xrd_shd.g_old_rec.val_147
981 ,p_val_148_o =>ben_xrd_shd.g_old_rec.val_148
982 ,p_val_149_o =>ben_xrd_shd.g_old_rec.val_149
983 ,p_val_150_o =>ben_xrd_shd.g_old_rec.val_150
984 ,p_val_151_o =>ben_xrd_shd.g_old_rec.val_151
985 ,p_val_152_o =>ben_xrd_shd.g_old_rec.val_152
986 ,p_val_153_o =>ben_xrd_shd.g_old_rec.val_153
987 ,p_val_154_o =>ben_xrd_shd.g_old_rec.val_154
988 ,p_val_155_o =>ben_xrd_shd.g_old_rec.val_155
989 ,p_val_156_o =>ben_xrd_shd.g_old_rec.val_156
990 ,p_val_157_o =>ben_xrd_shd.g_old_rec.val_157
991 ,p_val_158_o =>ben_xrd_shd.g_old_rec.val_158
992 ,p_val_159_o =>ben_xrd_shd.g_old_rec.val_159
993 ,p_val_160_o =>ben_xrd_shd.g_old_rec.val_160
994 ,p_val_161_o =>ben_xrd_shd.g_old_rec.val_161
995 ,p_val_162_o =>ben_xrd_shd.g_old_rec.val_162
996 ,p_val_163_o =>ben_xrd_shd.g_old_rec.val_163
997 ,p_val_164_o =>ben_xrd_shd.g_old_rec.val_164
998 ,p_val_165_o =>ben_xrd_shd.g_old_rec.val_165
999 ,p_val_166_o =>ben_xrd_shd.g_old_rec.val_166
1000 ,p_val_167_o =>ben_xrd_shd.g_old_rec.val_167
1001 ,p_val_168_o =>ben_xrd_shd.g_old_rec.val_168
1002 ,p_val_169_o =>ben_xrd_shd.g_old_rec.val_169
1003 ,p_val_170_o =>ben_xrd_shd.g_old_rec.val_170
1004 ,p_val_171_o =>ben_xrd_shd.g_old_rec.val_171
1005 ,p_val_172_o =>ben_xrd_shd.g_old_rec.val_172
1006 ,p_val_173_o =>ben_xrd_shd.g_old_rec.val_173
1007 ,p_val_174_o =>ben_xrd_shd.g_old_rec.val_174
1008 ,p_val_175_o =>ben_xrd_shd.g_old_rec.val_175
1009 ,p_val_176_o =>ben_xrd_shd.g_old_rec.val_176
1010 ,p_val_177_o =>ben_xrd_shd.g_old_rec.val_177
1011 ,p_val_178_o =>ben_xrd_shd.g_old_rec.val_178
1012 ,p_val_179_o =>ben_xrd_shd.g_old_rec.val_179
1013 ,p_val_180_o =>ben_xrd_shd.g_old_rec.val_180
1014 ,p_val_181_o =>ben_xrd_shd.g_old_rec.val_181
1015 ,p_val_182_o =>ben_xrd_shd.g_old_rec.val_182
1016 ,p_val_183_o =>ben_xrd_shd.g_old_rec.val_183
1017 ,p_val_184_o =>ben_xrd_shd.g_old_rec.val_184
1018 ,p_val_185_o =>ben_xrd_shd.g_old_rec.val_185
1019 ,p_val_186_o =>ben_xrd_shd.g_old_rec.val_186
1020 ,p_val_187_o =>ben_xrd_shd.g_old_rec.val_187
1021 ,p_val_188_o =>ben_xrd_shd.g_old_rec.val_188
1022 ,p_val_189_o =>ben_xrd_shd.g_old_rec.val_189
1023 ,p_val_190_o =>ben_xrd_shd.g_old_rec.val_190
1024 ,p_val_191_o =>ben_xrd_shd.g_old_rec.val_191
1025 ,p_val_192_o =>ben_xrd_shd.g_old_rec.val_192
1026 ,p_val_193_o =>ben_xrd_shd.g_old_rec.val_193
1027 ,p_val_194_o =>ben_xrd_shd.g_old_rec.val_194
1028 ,p_val_195_o =>ben_xrd_shd.g_old_rec.val_195
1029 ,p_val_196_o =>ben_xrd_shd.g_old_rec.val_196
1030 ,p_val_197_o =>ben_xrd_shd.g_old_rec.val_197
1031 ,p_val_198_o =>ben_xrd_shd.g_old_rec.val_198
1032 ,p_val_199_o =>ben_xrd_shd.g_old_rec.val_199
1033 ,p_val_200_o =>ben_xrd_shd.g_old_rec.val_200
1034 ,p_val_201_o =>ben_xrd_shd.g_old_rec.val_201
1035 ,p_val_202_o =>ben_xrd_shd.g_old_rec.val_202
1036 ,p_val_203_o =>ben_xrd_shd.g_old_rec.val_203
1037 ,p_val_204_o =>ben_xrd_shd.g_old_rec.val_204
1038 ,p_val_205_o =>ben_xrd_shd.g_old_rec.val_205
1039 ,p_val_206_o =>ben_xrd_shd.g_old_rec.val_206
1040 ,p_val_207_o =>ben_xrd_shd.g_old_rec.val_207
1041 ,p_val_208_o =>ben_xrd_shd.g_old_rec.val_208
1042 ,p_val_209_o =>ben_xrd_shd.g_old_rec.val_209
1043 ,p_val_210_o =>ben_xrd_shd.g_old_rec.val_210
1044 ,p_val_211_o =>ben_xrd_shd.g_old_rec.val_211
1045 ,p_val_212_o =>ben_xrd_shd.g_old_rec.val_212
1046 ,p_val_213_o =>ben_xrd_shd.g_old_rec.val_213
1047 ,p_val_214_o =>ben_xrd_shd.g_old_rec.val_214
1048 ,p_val_215_o =>ben_xrd_shd.g_old_rec.val_215
1049 ,p_val_216_o =>ben_xrd_shd.g_old_rec.val_216
1050 ,p_val_217_o =>ben_xrd_shd.g_old_rec.val_217
1051 ,p_val_219_o =>ben_xrd_shd.g_old_rec.val_219
1052 ,p_val_218_o =>ben_xrd_shd.g_old_rec.val_218
1053 ,p_val_220_o =>ben_xrd_shd.g_old_rec.val_220
1054 ,p_val_221_o =>ben_xrd_shd.g_old_rec.val_221
1055 ,p_val_222_o =>ben_xrd_shd.g_old_rec.val_222
1056 ,p_val_223_o =>ben_xrd_shd.g_old_rec.val_223
1057 ,p_val_224_o =>ben_xrd_shd.g_old_rec.val_224
1058 ,p_val_225_o =>ben_xrd_shd.g_old_rec.val_225
1059 ,p_val_226_o =>ben_xrd_shd.g_old_rec.val_226
1060 ,p_val_227_o =>ben_xrd_shd.g_old_rec.val_227
1061 ,p_val_228_o =>ben_xrd_shd.g_old_rec.val_228
1062 ,p_val_229_o =>ben_xrd_shd.g_old_rec.val_229
1063 ,p_val_230_o =>ben_xrd_shd.g_old_rec.val_230
1064 ,p_val_231_o =>ben_xrd_shd.g_old_rec.val_231
1065 ,p_val_232_o =>ben_xrd_shd.g_old_rec.val_232
1066 ,p_val_233_o =>ben_xrd_shd.g_old_rec.val_233
1067 ,p_val_234_o =>ben_xrd_shd.g_old_rec.val_234
1068 ,p_val_235_o =>ben_xrd_shd.g_old_rec.val_235
1069 ,p_val_236_o =>ben_xrd_shd.g_old_rec.val_236
1070 ,p_val_237_o =>ben_xrd_shd.g_old_rec.val_237
1071 ,p_val_238_o =>ben_xrd_shd.g_old_rec.val_238
1072 ,p_val_239_o =>ben_xrd_shd.g_old_rec.val_239
1073 ,p_val_240_o =>ben_xrd_shd.g_old_rec.val_240
1074 ,p_val_241_o =>ben_xrd_shd.g_old_rec.val_241
1075 ,p_val_242_o =>ben_xrd_shd.g_old_rec.val_242
1076 ,p_val_243_o =>ben_xrd_shd.g_old_rec.val_243
1077 ,p_val_244_o =>ben_xrd_shd.g_old_rec.val_244
1078 ,p_val_245_o =>ben_xrd_shd.g_old_rec.val_245
1079 ,p_val_246_o =>ben_xrd_shd.g_old_rec.val_246
1080 ,p_val_247_o =>ben_xrd_shd.g_old_rec.val_247
1081 ,p_val_248_o =>ben_xrd_shd.g_old_rec.val_248
1082 ,p_val_249_o =>ben_xrd_shd.g_old_rec.val_249
1083 ,p_val_250_o =>ben_xrd_shd.g_old_rec.val_250
1084 ,p_val_251_o =>ben_xrd_shd.g_old_rec.val_251
1085 ,p_val_252_o =>ben_xrd_shd.g_old_rec.val_252
1086 ,p_val_253_o =>ben_xrd_shd.g_old_rec.val_253
1087 ,p_val_254_o =>ben_xrd_shd.g_old_rec.val_254
1088 ,p_val_255_o =>ben_xrd_shd.g_old_rec.val_255
1089 ,p_val_256_o =>ben_xrd_shd.g_old_rec.val_256
1090 ,p_val_257_o =>ben_xrd_shd.g_old_rec.val_257
1091 ,p_val_258_o =>ben_xrd_shd.g_old_rec.val_258
1092 ,p_val_259_o =>ben_xrd_shd.g_old_rec.val_259
1093 ,p_val_260_o =>ben_xrd_shd.g_old_rec.val_260
1094 ,p_val_261_o =>ben_xrd_shd.g_old_rec.val_261
1095 ,p_val_262_o =>ben_xrd_shd.g_old_rec.val_262
1096 ,p_val_263_o =>ben_xrd_shd.g_old_rec.val_263
1097 ,p_val_264_o =>ben_xrd_shd.g_old_rec.val_264
1098 ,p_val_265_o =>ben_xrd_shd.g_old_rec.val_265
1099 ,p_val_266_o =>ben_xrd_shd.g_old_rec.val_266
1100 ,p_val_267_o =>ben_xrd_shd.g_old_rec.val_267
1101 ,p_val_268_o =>ben_xrd_shd.g_old_rec.val_268
1102 ,p_val_269_o =>ben_xrd_shd.g_old_rec.val_269
1103 ,p_val_270_o =>ben_xrd_shd.g_old_rec.val_270
1104 ,p_val_271_o =>ben_xrd_shd.g_old_rec.val_271
1105 ,p_val_272_o =>ben_xrd_shd.g_old_rec.val_272
1106 ,p_val_273_o =>ben_xrd_shd.g_old_rec.val_273
1107 ,p_val_274_o =>ben_xrd_shd.g_old_rec.val_274
1108 ,p_val_275_o =>ben_xrd_shd.g_old_rec.val_275
1109 ,p_val_276_o =>ben_xrd_shd.g_old_rec.val_276
1110 ,p_val_277_o =>ben_xrd_shd.g_old_rec.val_277
1111 ,p_val_278_o =>ben_xrd_shd.g_old_rec.val_278
1112 ,p_val_279_o =>ben_xrd_shd.g_old_rec.val_279
1113 ,p_val_280_o =>ben_xrd_shd.g_old_rec.val_280
1114 ,p_val_281_o =>ben_xrd_shd.g_old_rec.val_281
1115 ,p_val_282_o =>ben_xrd_shd.g_old_rec.val_282
1116 ,p_val_283_o =>ben_xrd_shd.g_old_rec.val_283
1117 ,p_val_284_o =>ben_xrd_shd.g_old_rec.val_284
1118 ,p_val_285_o =>ben_xrd_shd.g_old_rec.val_285
1119 ,p_val_286_o =>ben_xrd_shd.g_old_rec.val_286
1120 ,p_val_287_o =>ben_xrd_shd.g_old_rec.val_287
1121 ,p_val_288_o =>ben_xrd_shd.g_old_rec.val_288
1122 ,p_val_289_o =>ben_xrd_shd.g_old_rec.val_289
1123 ,p_val_290_o =>ben_xrd_shd.g_old_rec.val_290
1124 ,p_val_291_o =>ben_xrd_shd.g_old_rec.val_291
1125 ,p_val_292_o =>ben_xrd_shd.g_old_rec.val_292
1126 ,p_val_293_o =>ben_xrd_shd.g_old_rec.val_293
1127 ,p_val_294_o =>ben_xrd_shd.g_old_rec.val_294
1128 ,p_val_295_o =>ben_xrd_shd.g_old_rec.val_295
1129 ,p_val_296_o =>ben_xrd_shd.g_old_rec.val_296
1130 ,p_val_297_o =>ben_xrd_shd.g_old_rec.val_297
1131 ,p_val_298_o =>ben_xrd_shd.g_old_rec.val_298
1132 ,p_val_299_o =>ben_xrd_shd.g_old_rec.val_299
1133 ,p_val_300_o =>ben_xrd_shd.g_old_rec.val_300
1134 ,p_group_val_01_o =>ben_xrd_shd.g_old_rec.group_val_01
1135 ,p_group_val_02_o =>ben_xrd_shd.g_old_rec.group_val_02
1136 ,p_program_application_id_o =>ben_xrd_shd.g_old_rec.program_application_id
1137 ,p_program_id_o =>ben_xrd_shd.g_old_rec.program_id
1138 ,p_program_update_date_o =>ben_xrd_shd.g_old_rec.program_update_date
1139 ,p_request_id_o =>ben_xrd_shd.g_old_rec.request_id
1140 ,p_object_version_number_o =>ben_xrd_shd.g_old_rec.object_version_number
1141 ,p_ext_rcd_in_file_id_o =>ben_xrd_shd.g_old_rec.ext_rcd_in_file_id
1142 );
1143 --
1144 exception
1145 --
1146 when hr_api.cannot_find_prog_unit then
1147 --
1148 hr_api.cannot_find_prog_unit_error
1149 (p_module_name => 'ben_ext_rslt_dtl'
1150 ,p_hook_type => 'AU');
1151 --
1152 end;
1153 --
1154 -- End of API User Hook for post_update.
1155 --
1156 --
1157 hr_utility.set_location(' Leaving:'||l_proc, 10);
1158 End post_update;
1159 --
1160 -- ----------------------------------------------------------------------------
1161 -- |-----------------------------< convert_defs >-----------------------------|
1162 -- ----------------------------------------------------------------------------
1163 -- {Start Of Comments}
1164 --
1165 -- Description:
1166 -- The Convert_Defs procedure has one very important function:
1167 -- It must return the record structure for the row with all system defaulted
1168 -- values converted into its corresponding parameter value for update. When
1169 -- we attempt to update a row through the Upd process , certain
1170 -- parameters can be defaulted which enables flexibility in the calling of
1171 -- the upd process (e.g. only attributes which need to be updated need to be
1172 -- specified). For the upd process to determine which attributes
1173 -- have NOT been specified we need to check if the parameter has a reserved
1174 -- system default value. Therefore, for all parameters which have a
1175 -- corresponding reserved system default mechanism specified we need to
1176 -- check if a system default is being used. If a system default is being
1177 -- used then we convert the defaulted value into its corresponding attribute
1178 -- value held in the g_old_rec data structure.
1179 --
1180 -- Prerequisites:
1181 -- This private function can only be called from the upd process.
1182 --
1183 -- In Parameters:
1184 -- A Pl/Sql record structre.
1185 --
1186 -- Post Success:
1187 -- The record structure will be returned with all system defaulted parameter
1188 -- values converted into its current row attribute value.
1189 --
1190 -- Post Failure:
1191 -- No direct error handling is required within this function. Any possible
1192 -- errors within this procedure will be a PL/SQL value error due to conversion
1193 -- of datatypes or data lengths.
1194 --
1195 -- Developer Implementation Notes:
1196 -- None.
1197 --
1198 -- Access Status:
1199 -- Internal Row Handler Use Only.
1200 --
1201 -- {End Of Comments}
1202 -- ----------------------------------------------------------------------------
1203 Procedure convert_defs(p_rec in out nocopy ben_xrd_shd.g_rec_type) is
1204 --
1205 l_proc varchar2(72) := g_package||'convert_defs';
1206 --
1207 Begin
1208 --
1209 hr_utility.set_location('Entering:'||l_proc, 5);
1210 --
1211 -- We must now examine each argument value in the
1212 -- p_rec plsql record structure
1213 -- to see if a system default is being used. If a system default
1214 -- is being used then we must set to the 'current' argument value.
1215 --
1216 If (p_rec.prmy_sort_val = hr_api.g_varchar2) then
1217 p_rec.prmy_sort_val :=
1218 ben_xrd_shd.g_old_rec.prmy_sort_val;
1219 End If;
1220 If (p_rec.scnd_sort_val = hr_api.g_varchar2) then
1221 p_rec.scnd_sort_val :=
1222 ben_xrd_shd.g_old_rec.scnd_sort_val;
1223 End If;
1224 If (p_rec.thrd_sort_val = hr_api.g_varchar2) then
1225 p_rec.thrd_sort_val :=
1226 ben_xrd_shd.g_old_rec.thrd_sort_val;
1227 End If;
1228 If (p_rec.trans_seq_num = hr_api.g_number) then
1229 p_rec.trans_seq_num :=
1230 ben_xrd_shd.g_old_rec.trans_seq_num;
1231 End If;
1232 If (p_rec.rcrd_seq_num = hr_api.g_number) then
1233 p_rec.rcrd_seq_num :=
1234 ben_xrd_shd.g_old_rec.rcrd_seq_num;
1235 End If;
1236 If (p_rec.ext_rslt_id = hr_api.g_number) then
1237 p_rec.ext_rslt_id :=
1238 ben_xrd_shd.g_old_rec.ext_rslt_id;
1239 End If;
1240 If (p_rec.ext_rcd_id = hr_api.g_number) then
1241 p_rec.ext_rcd_id :=
1242 ben_xrd_shd.g_old_rec.ext_rcd_id;
1243 End If;
1244
1245 If (p_rec.ext_rcd_in_file_id = hr_api.g_number) then
1246 p_rec.ext_rcd_in_file_id :=
1247 ben_xrd_shd.g_old_rec.ext_rcd_in_file_id;
1248 End If;
1249
1250 If (p_rec.person_id = hr_api.g_number) then
1251 p_rec.person_id :=
1252 ben_xrd_shd.g_old_rec.person_id;
1253 End If;
1254 If (p_rec.business_group_id = hr_api.g_number) then
1255 p_rec.business_group_id :=
1256 ben_xrd_shd.g_old_rec.business_group_id;
1257 End If;
1258
1259 If (p_rec.ext_per_bg_id = hr_api.g_number) then
1260 p_rec.ext_per_bg_id :=
1261 ben_xrd_shd.g_old_rec.ext_per_bg_id;
1262 End If;
1263
1264 If (p_rec.val_01 = hr_api.g_varchar2) then
1265 p_rec.val_01 :=
1266 ben_xrd_shd.g_old_rec.val_01;
1267 End If;
1268 If (p_rec.val_02 = hr_api.g_varchar2) then
1269 p_rec.val_02 :=
1270 ben_xrd_shd.g_old_rec.val_02;
1271 End If;
1272 If (p_rec.val_03 = hr_api.g_varchar2) then
1273 p_rec.val_03 :=
1274 ben_xrd_shd.g_old_rec.val_03;
1275 End If;
1276 If (p_rec.val_04 = hr_api.g_varchar2) then
1277 p_rec.val_04 :=
1278 ben_xrd_shd.g_old_rec.val_04;
1279 End If;
1280 If (p_rec.val_05 = hr_api.g_varchar2) then
1281 p_rec.val_05 :=
1282 ben_xrd_shd.g_old_rec.val_05;
1283 End If;
1284 If (p_rec.val_06 = hr_api.g_varchar2) then
1285 p_rec.val_06 :=
1286 ben_xrd_shd.g_old_rec.val_06;
1287 End If;
1288 If (p_rec.val_07 = hr_api.g_varchar2) then
1289 p_rec.val_07 :=
1290 ben_xrd_shd.g_old_rec.val_07;
1291 End If;
1292 If (p_rec.val_08 = hr_api.g_varchar2) then
1293 p_rec.val_08 :=
1294 ben_xrd_shd.g_old_rec.val_08;
1295 End If;
1296 If (p_rec.val_09 = hr_api.g_varchar2) then
1297 p_rec.val_09 :=
1298 ben_xrd_shd.g_old_rec.val_09;
1299 End If;
1300 If (p_rec.val_10 = hr_api.g_varchar2) then
1301 p_rec.val_10 :=
1302 ben_xrd_shd.g_old_rec.val_10;
1303 End If;
1304 If (p_rec.val_11 = hr_api.g_varchar2) then
1305 p_rec.val_11 :=
1306 ben_xrd_shd.g_old_rec.val_11;
1307 End If;
1308 If (p_rec.val_12 = hr_api.g_varchar2) then
1309 p_rec.val_12 :=
1310 ben_xrd_shd.g_old_rec.val_12;
1311 End If;
1312 If (p_rec.val_13 = hr_api.g_varchar2) then
1313 p_rec.val_13 :=
1314 ben_xrd_shd.g_old_rec.val_13;
1315 End If;
1316 If (p_rec.val_14 = hr_api.g_varchar2) then
1317 p_rec.val_14 :=
1318 ben_xrd_shd.g_old_rec.val_14;
1319 End If;
1320 If (p_rec.val_15 = hr_api.g_varchar2) then
1321 p_rec.val_15 :=
1322 ben_xrd_shd.g_old_rec.val_15;
1323 End If;
1324 If (p_rec.val_16 = hr_api.g_varchar2) then
1325 p_rec.val_16 :=
1326 ben_xrd_shd.g_old_rec.val_16;
1327 End If;
1328 If (p_rec.val_17 = hr_api.g_varchar2) then
1329 p_rec.val_17 :=
1330 ben_xrd_shd.g_old_rec.val_17;
1331 End If;
1332 If (p_rec.val_19 = hr_api.g_varchar2) then
1333 p_rec.val_19 :=
1334 ben_xrd_shd.g_old_rec.val_19;
1335 End If;
1336 If (p_rec.val_18 = hr_api.g_varchar2) then
1337 p_rec.val_18 :=
1338 ben_xrd_shd.g_old_rec.val_18;
1339 End If;
1340 If (p_rec.val_20 = hr_api.g_varchar2) then
1341 p_rec.val_20 :=
1342 ben_xrd_shd.g_old_rec.val_20;
1343 End If;
1344 If (p_rec.val_21 = hr_api.g_varchar2) then
1345 p_rec.val_21 :=
1346 ben_xrd_shd.g_old_rec.val_21;
1347 End If;
1348 If (p_rec.val_22 = hr_api.g_varchar2) then
1349 p_rec.val_22 :=
1350 ben_xrd_shd.g_old_rec.val_22;
1351 End If;
1352 If (p_rec.val_23 = hr_api.g_varchar2) then
1353 p_rec.val_23 :=
1354 ben_xrd_shd.g_old_rec.val_23;
1355 End If;
1356 If (p_rec.val_24 = hr_api.g_varchar2) then
1357 p_rec.val_24 :=
1358 ben_xrd_shd.g_old_rec.val_24;
1359 End If;
1360 If (p_rec.val_25 = hr_api.g_varchar2) then
1361 p_rec.val_25 :=
1362 ben_xrd_shd.g_old_rec.val_25;
1363 End If;
1364 If (p_rec.val_26 = hr_api.g_varchar2) then
1365 p_rec.val_26 :=
1366 ben_xrd_shd.g_old_rec.val_26;
1367 End If;
1368 If (p_rec.val_27 = hr_api.g_varchar2) then
1369 p_rec.val_27 :=
1370 ben_xrd_shd.g_old_rec.val_27;
1371 End If;
1372 If (p_rec.val_28 = hr_api.g_varchar2) then
1373 p_rec.val_28 :=
1374 ben_xrd_shd.g_old_rec.val_28;
1375 End If;
1376 If (p_rec.val_29 = hr_api.g_varchar2) then
1377 p_rec.val_29 :=
1378 ben_xrd_shd.g_old_rec.val_29;
1379 End If;
1380 If (p_rec.val_30 = hr_api.g_varchar2) then
1381 p_rec.val_30 :=
1382 ben_xrd_shd.g_old_rec.val_30;
1383 End If;
1384 If (p_rec.val_31 = hr_api.g_varchar2) then
1385 p_rec.val_31 :=
1386 ben_xrd_shd.g_old_rec.val_31;
1387 End If;
1388 If (p_rec.val_32 = hr_api.g_varchar2) then
1389 p_rec.val_32 :=
1390 ben_xrd_shd.g_old_rec.val_32;
1391 End If;
1392 If (p_rec.val_33 = hr_api.g_varchar2) then
1393 p_rec.val_33 :=
1394 ben_xrd_shd.g_old_rec.val_33;
1395 End If;
1396 If (p_rec.val_34 = hr_api.g_varchar2) then
1397 p_rec.val_34 :=
1398 ben_xrd_shd.g_old_rec.val_34;
1399 End If;
1400 If (p_rec.val_35 = hr_api.g_varchar2) then
1401 p_rec.val_35 :=
1402 ben_xrd_shd.g_old_rec.val_35;
1403 End If;
1404 If (p_rec.val_36 = hr_api.g_varchar2) then
1405 p_rec.val_36 :=
1406 ben_xrd_shd.g_old_rec.val_36;
1407 End If;
1408 If (p_rec.val_37 = hr_api.g_varchar2) then
1409 p_rec.val_37 :=
1410 ben_xrd_shd.g_old_rec.val_37;
1411 End If;
1412 If (p_rec.val_38 = hr_api.g_varchar2) then
1413 p_rec.val_38 :=
1414 ben_xrd_shd.g_old_rec.val_38;
1415 End If;
1416 If (p_rec.val_39 = hr_api.g_varchar2) then
1417 p_rec.val_39 :=
1418 ben_xrd_shd.g_old_rec.val_39;
1419 End If;
1420 If (p_rec.val_40 = hr_api.g_varchar2) then
1421 p_rec.val_40 :=
1422 ben_xrd_shd.g_old_rec.val_40;
1423 End If;
1424 If (p_rec.val_41 = hr_api.g_varchar2) then
1425 p_rec.val_41 :=
1426 ben_xrd_shd.g_old_rec.val_41;
1427 End If;
1428 If (p_rec.val_42 = hr_api.g_varchar2) then
1429 p_rec.val_42 :=
1430 ben_xrd_shd.g_old_rec.val_42;
1431 End If;
1432 If (p_rec.val_43 = hr_api.g_varchar2) then
1433 p_rec.val_43 :=
1434 ben_xrd_shd.g_old_rec.val_43;
1435 End If;
1436 If (p_rec.val_44 = hr_api.g_varchar2) then
1437 p_rec.val_44 :=
1438 ben_xrd_shd.g_old_rec.val_44;
1439 End If;
1440 If (p_rec.val_45 = hr_api.g_varchar2) then
1441 p_rec.val_45 :=
1442 ben_xrd_shd.g_old_rec.val_45;
1443 End If;
1444 If (p_rec.val_46 = hr_api.g_varchar2) then
1445 p_rec.val_46 :=
1446 ben_xrd_shd.g_old_rec.val_46;
1447 End If;
1448 If (p_rec.val_47 = hr_api.g_varchar2) then
1449 p_rec.val_47 :=
1450 ben_xrd_shd.g_old_rec.val_47;
1451 End If;
1452 If (p_rec.val_48 = hr_api.g_varchar2) then
1453 p_rec.val_48 :=
1454 ben_xrd_shd.g_old_rec.val_48;
1455 End If;
1456 If (p_rec.val_49 = hr_api.g_varchar2) then
1457 p_rec.val_49 :=
1458 ben_xrd_shd.g_old_rec.val_49;
1459 End If;
1460 If (p_rec.val_50 = hr_api.g_varchar2) then
1461 p_rec.val_50 :=
1462 ben_xrd_shd.g_old_rec.val_50;
1463 End If;
1464 If (p_rec.val_51 = hr_api.g_varchar2) then
1465 p_rec.val_51 :=
1466 ben_xrd_shd.g_old_rec.val_51;
1467 End If;
1468 If (p_rec.val_52 = hr_api.g_varchar2) then
1469 p_rec.val_52 :=
1470 ben_xrd_shd.g_old_rec.val_52;
1471 End If;
1472 If (p_rec.val_53 = hr_api.g_varchar2) then
1473 p_rec.val_53 :=
1474 ben_xrd_shd.g_old_rec.val_53;
1475 End If;
1476 If (p_rec.val_54 = hr_api.g_varchar2) then
1477 p_rec.val_54 :=
1478 ben_xrd_shd.g_old_rec.val_54;
1479 End If;
1480 If (p_rec.val_55 = hr_api.g_varchar2) then
1481 p_rec.val_55 :=
1482 ben_xrd_shd.g_old_rec.val_55;
1483 End If;
1484 If (p_rec.val_56 = hr_api.g_varchar2) then
1485 p_rec.val_56 :=
1486 ben_xrd_shd.g_old_rec.val_56;
1487 End If;
1488 If (p_rec.val_57 = hr_api.g_varchar2) then
1489 p_rec.val_57 :=
1490 ben_xrd_shd.g_old_rec.val_57;
1491 End If;
1492 If (p_rec.val_58 = hr_api.g_varchar2) then
1493 p_rec.val_58 :=
1494 ben_xrd_shd.g_old_rec.val_58;
1495 End If;
1496 If (p_rec.val_59 = hr_api.g_varchar2) then
1497 p_rec.val_59 :=
1498 ben_xrd_shd.g_old_rec.val_59;
1499 End If;
1500 If (p_rec.val_60 = hr_api.g_varchar2) then
1501 p_rec.val_60 :=
1502 ben_xrd_shd.g_old_rec.val_60;
1503 End If;
1504 If (p_rec.val_61 = hr_api.g_varchar2) then
1505 p_rec.val_61 :=
1506 ben_xrd_shd.g_old_rec.val_61;
1507 End If;
1508 If (p_rec.val_62 = hr_api.g_varchar2) then
1509 p_rec.val_62 :=
1510 ben_xrd_shd.g_old_rec.val_62;
1511 End If;
1512 If (p_rec.val_63 = hr_api.g_varchar2) then
1513 p_rec.val_63 :=
1514 ben_xrd_shd.g_old_rec.val_63;
1515 End If;
1516 If (p_rec.val_64 = hr_api.g_varchar2) then
1517 p_rec.val_64 :=
1518 ben_xrd_shd.g_old_rec.val_64;
1519 End If;
1520 If (p_rec.val_65 = hr_api.g_varchar2) then
1521 p_rec.val_65 :=
1522 ben_xrd_shd.g_old_rec.val_65;
1523 End If;
1524 If (p_rec.val_66 = hr_api.g_varchar2) then
1525 p_rec.val_66 :=
1526 ben_xrd_shd.g_old_rec.val_66;
1527 End If;
1528 If (p_rec.val_67 = hr_api.g_varchar2) then
1529 p_rec.val_67 :=
1530 ben_xrd_shd.g_old_rec.val_67;
1531 End If;
1532 If (p_rec.val_68 = hr_api.g_varchar2) then
1533 p_rec.val_68 :=
1534 ben_xrd_shd.g_old_rec.val_68;
1535 End If;
1536 If (p_rec.val_69 = hr_api.g_varchar2) then
1537 p_rec.val_69 :=
1538 ben_xrd_shd.g_old_rec.val_69;
1539 End If;
1540 If (p_rec.val_70 = hr_api.g_varchar2) then
1541 p_rec.val_70 :=
1542 ben_xrd_shd.g_old_rec.val_70;
1543 End If;
1544 If (p_rec.val_71 = hr_api.g_varchar2) then
1545 p_rec.val_71 :=
1546 ben_xrd_shd.g_old_rec.val_71;
1547 End If;
1548 If (p_rec.val_72 = hr_api.g_varchar2) then
1549 p_rec.val_72 :=
1550 ben_xrd_shd.g_old_rec.val_72;
1551 End If;
1552 If (p_rec.val_73 = hr_api.g_varchar2) then
1553 p_rec.val_73 :=
1554 ben_xrd_shd.g_old_rec.val_73;
1555 End If;
1556 If (p_rec.val_74 = hr_api.g_varchar2) then
1557 p_rec.val_74 :=
1558 ben_xrd_shd.g_old_rec.val_74;
1559 End If;
1560 If (p_rec.val_75 = hr_api.g_varchar2) then
1561 p_rec.val_75 :=
1562 ben_xrd_shd.g_old_rec.val_75;
1563 End If;
1564 If (p_rec.val_76 = hr_api.g_varchar2) then
1565 p_rec.val_76 :=
1566 ben_xrd_shd.g_old_rec.val_76;
1567 End If;
1568 If (p_rec.val_77 = hr_api.g_varchar2) then
1569 p_rec.val_77 :=
1570 ben_xrd_shd.g_old_rec.val_77;
1571 End If;
1572 If (p_rec.val_78 = hr_api.g_varchar2) then
1573 p_rec.val_78 :=
1574 ben_xrd_shd.g_old_rec.val_78;
1575 End If;
1576 If (p_rec.val_79 = hr_api.g_varchar2) then
1577 p_rec.val_79 :=
1578 ben_xrd_shd.g_old_rec.val_79;
1579 End If;
1580 If (p_rec.val_80 = hr_api.g_varchar2) then
1581 p_rec.val_80 :=
1582 ben_xrd_shd.g_old_rec.val_80;
1583 End If;
1584 If (p_rec.val_81 = hr_api.g_varchar2) then
1585 p_rec.val_81 :=
1586 ben_xrd_shd.g_old_rec.val_81;
1587 End If;
1588 If (p_rec.val_82 = hr_api.g_varchar2) then
1589 p_rec.val_82 :=
1590 ben_xrd_shd.g_old_rec.val_82;
1591 End If;
1592 If (p_rec.val_83 = hr_api.g_varchar2) then
1593 p_rec.val_83 :=
1594 ben_xrd_shd.g_old_rec.val_83;
1595 End If;
1596 If (p_rec.val_84 = hr_api.g_varchar2) then
1597 p_rec.val_84 :=
1598 ben_xrd_shd.g_old_rec.val_84;
1599 End If;
1600 If (p_rec.val_85 = hr_api.g_varchar2) then
1601 p_rec.val_85 :=
1602 ben_xrd_shd.g_old_rec.val_85;
1603 End If;
1604 If (p_rec.val_86 = hr_api.g_varchar2) then
1605 p_rec.val_86 :=
1606 ben_xrd_shd.g_old_rec.val_86;
1607 End If;
1608 If (p_rec.val_87 = hr_api.g_varchar2) then
1609 p_rec.val_87 :=
1610 ben_xrd_shd.g_old_rec.val_87;
1611 End If;
1612 If (p_rec.val_88 = hr_api.g_varchar2) then
1613 p_rec.val_88 :=
1614 ben_xrd_shd.g_old_rec.val_88;
1615 End If;
1616 If (p_rec.val_89 = hr_api.g_varchar2) then
1617 p_rec.val_89 :=
1618 ben_xrd_shd.g_old_rec.val_89;
1619 End If;
1620 If (p_rec.val_90 = hr_api.g_varchar2) then
1621 p_rec.val_90 :=
1622 ben_xrd_shd.g_old_rec.val_90;
1623 End If;
1624 If (p_rec.val_91 = hr_api.g_varchar2) then
1625 p_rec.val_91 :=
1626 ben_xrd_shd.g_old_rec.val_91;
1627 End If;
1628 If (p_rec.val_92 = hr_api.g_varchar2) then
1629 p_rec.val_92 :=
1630 ben_xrd_shd.g_old_rec.val_92;
1631 End If;
1632 If (p_rec.val_93 = hr_api.g_varchar2) then
1633 p_rec.val_93 :=
1634 ben_xrd_shd.g_old_rec.val_93;
1635 End If;
1636 If (p_rec.val_94 = hr_api.g_varchar2) then
1637 p_rec.val_94 :=
1638 ben_xrd_shd.g_old_rec.val_94;
1639 End If;
1640 If (p_rec.val_95 = hr_api.g_varchar2) then
1641 p_rec.val_95 :=
1642 ben_xrd_shd.g_old_rec.val_95;
1643 End If;
1644 If (p_rec.val_96 = hr_api.g_varchar2) then
1645 p_rec.val_96 :=
1646 ben_xrd_shd.g_old_rec.val_96;
1647 End If;
1648 If (p_rec.val_97 = hr_api.g_varchar2) then
1649 p_rec.val_97 :=
1650 ben_xrd_shd.g_old_rec.val_97;
1651 End If;
1652 If (p_rec.val_98 = hr_api.g_varchar2) then
1653 p_rec.val_98 :=
1654 ben_xrd_shd.g_old_rec.val_98;
1655 End If;
1656 If (p_rec.val_99 = hr_api.g_varchar2) then
1657 p_rec.val_99 :=
1658 ben_xrd_shd.g_old_rec.val_99;
1659 End If;
1660 If (p_rec.val_100 = hr_api.g_varchar2) then
1661 p_rec.val_100 :=
1662 ben_xrd_shd.g_old_rec.val_100;
1663 End If;
1664 ---
1665 If (p_rec.val_101 = hr_api.g_varchar2) then
1666 p_rec.val_101 :=
1667 ben_xrd_shd.g_old_rec.val_101;
1668 End If;
1669 If (p_rec.val_102 = hr_api.g_varchar2) then
1670 p_rec.val_102 :=
1671 ben_xrd_shd.g_old_rec.val_102;
1672 End If;
1673 If (p_rec.val_103 = hr_api.g_varchar2) then
1674 p_rec.val_103 :=
1675 ben_xrd_shd.g_old_rec.val_103;
1676 End If;
1677 If (p_rec.val_104 = hr_api.g_varchar2) then
1678 p_rec.val_104 :=
1679 ben_xrd_shd.g_old_rec.val_104;
1680 End If;
1681 If (p_rec.val_105 = hr_api.g_varchar2) then
1682 p_rec.val_105 :=
1683 ben_xrd_shd.g_old_rec.val_105;
1684 End If;
1685 If (p_rec.val_106 = hr_api.g_varchar2) then
1686 p_rec.val_106 :=
1687 ben_xrd_shd.g_old_rec.val_106;
1688 End If;
1689 If (p_rec.val_107 = hr_api.g_varchar2) then
1690 p_rec.val_107 :=
1691 ben_xrd_shd.g_old_rec.val_107;
1692 End If;
1693 If (p_rec.val_108 = hr_api.g_varchar2) then
1694 p_rec.val_108 :=
1695 ben_xrd_shd.g_old_rec.val_108;
1696 End If;
1697 If (p_rec.val_109 = hr_api.g_varchar2) then
1698 p_rec.val_109 :=
1699 ben_xrd_shd.g_old_rec.val_109;
1700 End If;
1701 If (p_rec.val_110 = hr_api.g_varchar2) then
1702 p_rec.val_110 :=
1703 ben_xrd_shd.g_old_rec.val_110;
1704 End If;
1705 If (p_rec.val_111 = hr_api.g_varchar2) then
1706 p_rec.val_111 :=
1707 ben_xrd_shd.g_old_rec.val_111;
1708 End If;
1709 If (p_rec.val_112 = hr_api.g_varchar2) then
1710 p_rec.val_112 :=
1711 ben_xrd_shd.g_old_rec.val_112;
1712 End If;
1713 If (p_rec.val_113 = hr_api.g_varchar2) then
1714 p_rec.val_113 :=
1715 ben_xrd_shd.g_old_rec.val_113;
1716 End If;
1717 If (p_rec.val_114 = hr_api.g_varchar2) then
1718 p_rec.val_114 :=
1719 ben_xrd_shd.g_old_rec.val_114;
1720 End If;
1721 If (p_rec.val_115 = hr_api.g_varchar2) then
1722 p_rec.val_115 :=
1723 ben_xrd_shd.g_old_rec.val_115;
1724 End If;
1725 If (p_rec.val_116 = hr_api.g_varchar2) then
1726 p_rec.val_116 :=
1727 ben_xrd_shd.g_old_rec.val_116;
1728 End If;
1729 If (p_rec.val_117 = hr_api.g_varchar2) then
1730 p_rec.val_117 :=
1731 ben_xrd_shd.g_old_rec.val_117;
1732 End If;
1733 If (p_rec.val_119 = hr_api.g_varchar2) then
1734 p_rec.val_119 :=
1735 ben_xrd_shd.g_old_rec.val_119;
1736 End If;
1737 If (p_rec.val_118 = hr_api.g_varchar2) then
1738 p_rec.val_118 :=
1739 ben_xrd_shd.g_old_rec.val_118;
1740 End If;
1741 If (p_rec.val_120 = hr_api.g_varchar2) then
1742 p_rec.val_120 :=
1743 ben_xrd_shd.g_old_rec.val_120;
1744 End If;
1745 If (p_rec.val_121 = hr_api.g_varchar2) then
1746 p_rec.val_121 :=
1747 ben_xrd_shd.g_old_rec.val_121;
1748 End If;
1749 If (p_rec.val_122 = hr_api.g_varchar2) then
1750 p_rec.val_122 :=
1751 ben_xrd_shd.g_old_rec.val_122;
1752 End If;
1753 If (p_rec.val_123 = hr_api.g_varchar2) then
1754 p_rec.val_123 :=
1755 ben_xrd_shd.g_old_rec.val_123;
1756 End If;
1757 If (p_rec.val_124 = hr_api.g_varchar2) then
1758 p_rec.val_124 :=
1759 ben_xrd_shd.g_old_rec.val_124;
1760 End If;
1761 If (p_rec.val_125 = hr_api.g_varchar2) then
1762 p_rec.val_125 :=
1763 ben_xrd_shd.g_old_rec.val_125;
1764 End If;
1765 If (p_rec.val_126 = hr_api.g_varchar2) then
1766 p_rec.val_126 :=
1767 ben_xrd_shd.g_old_rec.val_126;
1768 End If;
1769 If (p_rec.val_127 = hr_api.g_varchar2) then
1770 p_rec.val_127 :=
1771 ben_xrd_shd.g_old_rec.val_127;
1772 End If;
1773 If (p_rec.val_128 = hr_api.g_varchar2) then
1774 p_rec.val_128 :=
1775 ben_xrd_shd.g_old_rec.val_128;
1776 End If;
1777 If (p_rec.val_129 = hr_api.g_varchar2) then
1778 p_rec.val_129 :=
1779 ben_xrd_shd.g_old_rec.val_129;
1780 End If;
1781 If (p_rec.val_130 = hr_api.g_varchar2) then
1782 p_rec.val_130 :=
1783 ben_xrd_shd.g_old_rec.val_130;
1784 End If;
1785 If (p_rec.val_131 = hr_api.g_varchar2) then
1786 p_rec.val_131 :=
1787 ben_xrd_shd.g_old_rec.val_131;
1788 End If;
1789 If (p_rec.val_132 = hr_api.g_varchar2) then
1790 p_rec.val_132 :=
1791 ben_xrd_shd.g_old_rec.val_132;
1792 End If;
1793 If (p_rec.val_133 = hr_api.g_varchar2) then
1794 p_rec.val_133 :=
1795 ben_xrd_shd.g_old_rec.val_133;
1796 End If;
1797 If (p_rec.val_134 = hr_api.g_varchar2) then
1798 p_rec.val_134 :=
1799 ben_xrd_shd.g_old_rec.val_134;
1800 End If;
1801 If (p_rec.val_135 = hr_api.g_varchar2) then
1802 p_rec.val_135 :=
1803 ben_xrd_shd.g_old_rec.val_135;
1804 End If;
1805 If (p_rec.val_136 = hr_api.g_varchar2) then
1806 p_rec.val_136 :=
1807 ben_xrd_shd.g_old_rec.val_136;
1808 End If;
1809 If (p_rec.val_137 = hr_api.g_varchar2) then
1810 p_rec.val_137 :=
1811 ben_xrd_shd.g_old_rec.val_137;
1812 End If;
1813 If (p_rec.val_138 = hr_api.g_varchar2) then
1814 p_rec.val_138 :=
1815 ben_xrd_shd.g_old_rec.val_138;
1816 End If;
1817 If (p_rec.val_139 = hr_api.g_varchar2) then
1818 p_rec.val_139 :=
1819 ben_xrd_shd.g_old_rec.val_139;
1820 End If;
1821 If (p_rec.val_140 = hr_api.g_varchar2) then
1822 p_rec.val_140 :=
1823 ben_xrd_shd.g_old_rec.val_140;
1824 End If;
1825 If (p_rec.val_141 = hr_api.g_varchar2) then
1826 p_rec.val_141 :=
1827 ben_xrd_shd.g_old_rec.val_141;
1828 End If;
1829 If (p_rec.val_142 = hr_api.g_varchar2) then
1830 p_rec.val_142 :=
1831 ben_xrd_shd.g_old_rec.val_142;
1832 End If;
1833 If (p_rec.val_143 = hr_api.g_varchar2) then
1834 p_rec.val_143 :=
1835 ben_xrd_shd.g_old_rec.val_143;
1836 End If;
1837 If (p_rec.val_144 = hr_api.g_varchar2) then
1838 p_rec.val_144 :=
1839 ben_xrd_shd.g_old_rec.val_144;
1840 End If;
1841 If (p_rec.val_145 = hr_api.g_varchar2) then
1842 p_rec.val_145 :=
1843 ben_xrd_shd.g_old_rec.val_145;
1844 End If;
1845 If (p_rec.val_146 = hr_api.g_varchar2) then
1846 p_rec.val_146 :=
1847 ben_xrd_shd.g_old_rec.val_146;
1848 End If;
1849 If (p_rec.val_147 = hr_api.g_varchar2) then
1850 p_rec.val_147 :=
1851 ben_xrd_shd.g_old_rec.val_147;
1852 End If;
1853 If (p_rec.val_148 = hr_api.g_varchar2) then
1854 p_rec.val_148 :=
1855 ben_xrd_shd.g_old_rec.val_148;
1856 End If;
1857 If (p_rec.val_149 = hr_api.g_varchar2) then
1858 p_rec.val_149 :=
1859 ben_xrd_shd.g_old_rec.val_149;
1860 End If;
1861 If (p_rec.val_150 = hr_api.g_varchar2) then
1862 p_rec.val_150 :=
1863 ben_xrd_shd.g_old_rec.val_150;
1864 End If;
1865 If (p_rec.val_151 = hr_api.g_varchar2) then
1866 p_rec.val_151 :=
1867 ben_xrd_shd.g_old_rec.val_151;
1868 End If;
1869 If (p_rec.val_152 = hr_api.g_varchar2) then
1870 p_rec.val_152 :=
1871 ben_xrd_shd.g_old_rec.val_152;
1872 End If;
1873 If (p_rec.val_153 = hr_api.g_varchar2) then
1874 p_rec.val_153 :=
1875 ben_xrd_shd.g_old_rec.val_153;
1876 End If;
1877 If (p_rec.val_154 = hr_api.g_varchar2) then
1878 p_rec.val_154 :=
1879 ben_xrd_shd.g_old_rec.val_154;
1880 End If;
1881 If (p_rec.val_155 = hr_api.g_varchar2) then
1882 p_rec.val_155 :=
1883 ben_xrd_shd.g_old_rec.val_155;
1884 End If;
1885 If (p_rec.val_156 = hr_api.g_varchar2) then
1886 p_rec.val_156 :=
1887 ben_xrd_shd.g_old_rec.val_156;
1888 End If;
1889 If (p_rec.val_157 = hr_api.g_varchar2) then
1890 p_rec.val_157 :=
1891 ben_xrd_shd.g_old_rec.val_157;
1892 End If;
1893 If (p_rec.val_158 = hr_api.g_varchar2) then
1894 p_rec.val_158 :=
1895 ben_xrd_shd.g_old_rec.val_158;
1896 End If;
1897 If (p_rec.val_159 = hr_api.g_varchar2) then
1898 p_rec.val_159 :=
1899 ben_xrd_shd.g_old_rec.val_159;
1900 End If;
1901 If (p_rec.val_160 = hr_api.g_varchar2) then
1902 p_rec.val_160 :=
1903 ben_xrd_shd.g_old_rec.val_160;
1904 End If;
1905 If (p_rec.val_161 = hr_api.g_varchar2) then
1906 p_rec.val_161 :=
1907 ben_xrd_shd.g_old_rec.val_161;
1908 End If;
1909 If (p_rec.val_162 = hr_api.g_varchar2) then
1910 p_rec.val_162 :=
1911 ben_xrd_shd.g_old_rec.val_162;
1912 End If;
1913 If (p_rec.val_163 = hr_api.g_varchar2) then
1914 p_rec.val_163 :=
1915 ben_xrd_shd.g_old_rec.val_163;
1916 End If;
1917 If (p_rec.val_164 = hr_api.g_varchar2) then
1918 p_rec.val_164 :=
1919 ben_xrd_shd.g_old_rec.val_164;
1920 End If;
1921 If (p_rec.val_165 = hr_api.g_varchar2) then
1922 p_rec.val_165 :=
1923 ben_xrd_shd.g_old_rec.val_165;
1924 End If;
1925 If (p_rec.val_166 = hr_api.g_varchar2) then
1926 p_rec.val_166 :=
1927 ben_xrd_shd.g_old_rec.val_166;
1928 End If;
1929 If (p_rec.val_167 = hr_api.g_varchar2) then
1930 p_rec.val_167 :=
1931 ben_xrd_shd.g_old_rec.val_167;
1932 End If;
1933 If (p_rec.val_168 = hr_api.g_varchar2) then
1934 p_rec.val_168 :=
1935 ben_xrd_shd.g_old_rec.val_168;
1936 End If;
1937 If (p_rec.val_169 = hr_api.g_varchar2) then
1938 p_rec.val_169 :=
1939 ben_xrd_shd.g_old_rec.val_169;
1940 End If;
1941 If (p_rec.val_170 = hr_api.g_varchar2) then
1942 p_rec.val_170 :=
1943 ben_xrd_shd.g_old_rec.val_170;
1944 End If;
1945 If (p_rec.val_171 = hr_api.g_varchar2) then
1946 p_rec.val_171 :=
1947 ben_xrd_shd.g_old_rec.val_171;
1948 End If;
1949 If (p_rec.val_172 = hr_api.g_varchar2) then
1950 p_rec.val_172 :=
1951 ben_xrd_shd.g_old_rec.val_172;
1952 End If;
1953 If (p_rec.val_173 = hr_api.g_varchar2) then
1954 p_rec.val_173 :=
1955 ben_xrd_shd.g_old_rec.val_173;
1956 End If;
1957 If (p_rec.val_174 = hr_api.g_varchar2) then
1958 p_rec.val_174 :=
1959 ben_xrd_shd.g_old_rec.val_174;
1960 End If;
1961 If (p_rec.val_175 = hr_api.g_varchar2) then
1962 p_rec.val_175 :=
1963 ben_xrd_shd.g_old_rec.val_175;
1964 End If;
1965 If (p_rec.val_176 = hr_api.g_varchar2) then
1966 p_rec.val_176 :=
1967 ben_xrd_shd.g_old_rec.val_176;
1968 End If;
1969 If (p_rec.val_177 = hr_api.g_varchar2) then
1970 p_rec.val_177 :=
1971 ben_xrd_shd.g_old_rec.val_177;
1972 End If;
1973 If (p_rec.val_178 = hr_api.g_varchar2) then
1974 p_rec.val_178 :=
1975 ben_xrd_shd.g_old_rec.val_178;
1976 End If;
1977 If (p_rec.val_179 = hr_api.g_varchar2) then
1978 p_rec.val_179 :=
1979 ben_xrd_shd.g_old_rec.val_179;
1980 End If;
1981 If (p_rec.val_180 = hr_api.g_varchar2) then
1982 p_rec.val_180 :=
1983 ben_xrd_shd.g_old_rec.val_180;
1984 End If;
1985 If (p_rec.val_181 = hr_api.g_varchar2) then
1986 p_rec.val_181 :=
1987 ben_xrd_shd.g_old_rec.val_181;
1988 End If;
1989 If (p_rec.val_182 = hr_api.g_varchar2) then
1990 p_rec.val_182 :=
1991 ben_xrd_shd.g_old_rec.val_182;
1992 End If;
1993 If (p_rec.val_183 = hr_api.g_varchar2) then
1994 p_rec.val_183 :=
1995 ben_xrd_shd.g_old_rec.val_183;
1996 End If;
1997 If (p_rec.val_184 = hr_api.g_varchar2) then
1998 p_rec.val_184 :=
1999 ben_xrd_shd.g_old_rec.val_184;
2000 End If;
2001 If (p_rec.val_185 = hr_api.g_varchar2) then
2002 p_rec.val_185 :=
2003 ben_xrd_shd.g_old_rec.val_185;
2004 End If;
2005 If (p_rec.val_186 = hr_api.g_varchar2) then
2006 p_rec.val_186 :=
2007 ben_xrd_shd.g_old_rec.val_186;
2008 End If;
2009 If (p_rec.val_187 = hr_api.g_varchar2) then
2010 p_rec.val_187 :=
2011 ben_xrd_shd.g_old_rec.val_187;
2012 End If;
2013 If (p_rec.val_188 = hr_api.g_varchar2) then
2014 p_rec.val_188 :=
2015 ben_xrd_shd.g_old_rec.val_188;
2016 End If;
2017 If (p_rec.val_189 = hr_api.g_varchar2) then
2018 p_rec.val_189 :=
2019 ben_xrd_shd.g_old_rec.val_189;
2020 End If;
2021 If (p_rec.val_190 = hr_api.g_varchar2) then
2022 p_rec.val_190 :=
2023 ben_xrd_shd.g_old_rec.val_190;
2024 End If;
2025 If (p_rec.val_191 = hr_api.g_varchar2) then
2026 p_rec.val_191 :=
2027 ben_xrd_shd.g_old_rec.val_191;
2028 End If;
2029 If (p_rec.val_192 = hr_api.g_varchar2) then
2030 p_rec.val_192 :=
2031 ben_xrd_shd.g_old_rec.val_192;
2032 End If;
2033 If (p_rec.val_193 = hr_api.g_varchar2) then
2034 p_rec.val_193 :=
2035 ben_xrd_shd.g_old_rec.val_193;
2036 End If;
2037 If (p_rec.val_194 = hr_api.g_varchar2) then
2038 p_rec.val_194 :=
2039 ben_xrd_shd.g_old_rec.val_194;
2040 End If;
2041 If (p_rec.val_195 = hr_api.g_varchar2) then
2042 p_rec.val_195 :=
2043 ben_xrd_shd.g_old_rec.val_195;
2044 End If;
2045 If (p_rec.val_196 = hr_api.g_varchar2) then
2046 p_rec.val_196 :=
2047 ben_xrd_shd.g_old_rec.val_196;
2048 End If;
2049 If (p_rec.val_197 = hr_api.g_varchar2) then
2050 p_rec.val_197 :=
2051 ben_xrd_shd.g_old_rec.val_197;
2052 End If;
2053 If (p_rec.val_198 = hr_api.g_varchar2) then
2054 p_rec.val_198 :=
2055 ben_xrd_shd.g_old_rec.val_198;
2056 End If;
2057 If (p_rec.val_199 = hr_api.g_varchar2) then
2058 p_rec.val_199 :=
2059 ben_xrd_shd.g_old_rec.val_199;
2060 End If;
2061 If (p_rec.val_200 = hr_api.g_varchar2) then
2062 p_rec.val_200 :=
2063 ben_xrd_shd.g_old_rec.val_200;
2064 End If;
2065 If (p_rec.val_201 = hr_api.g_varchar2) then
2066 p_rec.val_201 :=
2067 ben_xrd_shd.g_old_rec.val_201;
2068 End If;
2069 If (p_rec.val_202 = hr_api.g_varchar2) then
2070 p_rec.val_202 :=
2071 ben_xrd_shd.g_old_rec.val_202;
2072 End If;
2073 If (p_rec.val_203 = hr_api.g_varchar2) then
2074 p_rec.val_203 :=
2075 ben_xrd_shd.g_old_rec.val_203;
2076 End If;
2077 If (p_rec.val_204 = hr_api.g_varchar2) then
2078 p_rec.val_204 :=
2079 ben_xrd_shd.g_old_rec.val_204;
2080 End If;
2081 If (p_rec.val_205 = hr_api.g_varchar2) then
2082 p_rec.val_205 :=
2083 ben_xrd_shd.g_old_rec.val_205;
2084 End If;
2085 If (p_rec.val_206 = hr_api.g_varchar2) then
2086 p_rec.val_206 :=
2087 ben_xrd_shd.g_old_rec.val_206;
2088 End If;
2089 If (p_rec.val_207 = hr_api.g_varchar2) then
2090 p_rec.val_207 :=
2091 ben_xrd_shd.g_old_rec.val_207;
2092 End If;
2093 If (p_rec.val_208 = hr_api.g_varchar2) then
2094 p_rec.val_208 :=
2095 ben_xrd_shd.g_old_rec.val_208;
2096 End If;
2097 If (p_rec.val_209 = hr_api.g_varchar2) then
2098 p_rec.val_209 :=
2099 ben_xrd_shd.g_old_rec.val_209;
2100 End If;
2101 If (p_rec.val_210 = hr_api.g_varchar2) then
2102 p_rec.val_210 :=
2103 ben_xrd_shd.g_old_rec.val_210;
2104 End If;
2105 If (p_rec.val_211 = hr_api.g_varchar2) then
2106 p_rec.val_211 :=
2107 ben_xrd_shd.g_old_rec.val_211;
2108 End If;
2109 If (p_rec.val_212 = hr_api.g_varchar2) then
2110 p_rec.val_212 :=
2111 ben_xrd_shd.g_old_rec.val_212;
2112 End If;
2113 If (p_rec.val_213 = hr_api.g_varchar2) then
2114 p_rec.val_213 :=
2115 ben_xrd_shd.g_old_rec.val_213;
2116 End If;
2117 If (p_rec.val_214 = hr_api.g_varchar2) then
2118 p_rec.val_214 :=
2119 ben_xrd_shd.g_old_rec.val_214;
2120 End If;
2121 If (p_rec.val_215 = hr_api.g_varchar2) then
2122 p_rec.val_215 :=
2123 ben_xrd_shd.g_old_rec.val_215;
2124 End If;
2125 If (p_rec.val_216 = hr_api.g_varchar2) then
2126 p_rec.val_216 :=
2127 ben_xrd_shd.g_old_rec.val_216;
2128 End If;
2129 If (p_rec.val_217 = hr_api.g_varchar2) then
2130 p_rec.val_217 :=
2131 ben_xrd_shd.g_old_rec.val_217;
2132 End If;
2133 If (p_rec.val_219 = hr_api.g_varchar2) then
2134 p_rec.val_219 :=
2135 ben_xrd_shd.g_old_rec.val_219;
2136 End If;
2137 If (p_rec.val_218 = hr_api.g_varchar2) then
2138 p_rec.val_218 :=
2139 ben_xrd_shd.g_old_rec.val_218;
2140 End If;
2141 If (p_rec.val_220 = hr_api.g_varchar2) then
2142 p_rec.val_220 :=
2143 ben_xrd_shd.g_old_rec.val_220;
2144 End If;
2145 If (p_rec.val_221 = hr_api.g_varchar2) then
2146 p_rec.val_221 :=
2147 ben_xrd_shd.g_old_rec.val_221;
2148 End If;
2149 If (p_rec.val_222 = hr_api.g_varchar2) then
2150 p_rec.val_222 :=
2151 ben_xrd_shd.g_old_rec.val_222;
2152 End If;
2153 If (p_rec.val_223 = hr_api.g_varchar2) then
2154 p_rec.val_223 :=
2155 ben_xrd_shd.g_old_rec.val_223;
2156 End If;
2157 If (p_rec.val_224 = hr_api.g_varchar2) then
2158 p_rec.val_224 :=
2159 ben_xrd_shd.g_old_rec.val_224;
2160 End If;
2161 If (p_rec.val_225 = hr_api.g_varchar2) then
2162 p_rec.val_225 :=
2163 ben_xrd_shd.g_old_rec.val_225;
2164 End If;
2165 If (p_rec.val_226 = hr_api.g_varchar2) then
2166 p_rec.val_226 :=
2167 ben_xrd_shd.g_old_rec.val_226;
2168 End If;
2169 If (p_rec.val_227 = hr_api.g_varchar2) then
2170 p_rec.val_227 :=
2171 ben_xrd_shd.g_old_rec.val_227;
2172 End If;
2173 If (p_rec.val_228 = hr_api.g_varchar2) then
2174 p_rec.val_228 :=
2175 ben_xrd_shd.g_old_rec.val_228;
2176 End If;
2177 If (p_rec.val_229 = hr_api.g_varchar2) then
2178 p_rec.val_229 :=
2179 ben_xrd_shd.g_old_rec.val_229;
2180 End If;
2181 If (p_rec.val_230 = hr_api.g_varchar2) then
2182 p_rec.val_230 :=
2183 ben_xrd_shd.g_old_rec.val_230;
2184 End If;
2185 If (p_rec.val_231 = hr_api.g_varchar2) then
2186 p_rec.val_231 :=
2187 ben_xrd_shd.g_old_rec.val_231;
2188 End If;
2189 If (p_rec.val_232 = hr_api.g_varchar2) then
2190 p_rec.val_232 :=
2191 ben_xrd_shd.g_old_rec.val_232;
2192 End If;
2193 If (p_rec.val_233 = hr_api.g_varchar2) then
2194 p_rec.val_233 :=
2195 ben_xrd_shd.g_old_rec.val_233;
2196 End If;
2197 If (p_rec.val_234 = hr_api.g_varchar2) then
2198 p_rec.val_234 :=
2199 ben_xrd_shd.g_old_rec.val_234;
2200 End If;
2201 If (p_rec.val_235 = hr_api.g_varchar2) then
2202 p_rec.val_235 :=
2203 ben_xrd_shd.g_old_rec.val_235;
2204 End If;
2205 If (p_rec.val_236 = hr_api.g_varchar2) then
2206 p_rec.val_236 :=
2207 ben_xrd_shd.g_old_rec.val_236;
2208 End If;
2209 If (p_rec.val_237 = hr_api.g_varchar2) then
2210 p_rec.val_237 :=
2211 ben_xrd_shd.g_old_rec.val_237;
2212 End If;
2213 If (p_rec.val_238 = hr_api.g_varchar2) then
2214 p_rec.val_238 :=
2215 ben_xrd_shd.g_old_rec.val_238;
2216 End If;
2217 If (p_rec.val_239 = hr_api.g_varchar2) then
2218 p_rec.val_239 :=
2219 ben_xrd_shd.g_old_rec.val_239;
2220 End If;
2221 If (p_rec.val_240 = hr_api.g_varchar2) then
2222 p_rec.val_240 :=
2223 ben_xrd_shd.g_old_rec.val_240;
2224 End If;
2225 If (p_rec.val_241 = hr_api.g_varchar2) then
2226 p_rec.val_241 :=
2227 ben_xrd_shd.g_old_rec.val_241;
2228 End If;
2229 If (p_rec.val_242 = hr_api.g_varchar2) then
2230 p_rec.val_242 :=
2231 ben_xrd_shd.g_old_rec.val_242;
2232 End If;
2233 If (p_rec.val_243 = hr_api.g_varchar2) then
2234 p_rec.val_243 :=
2235 ben_xrd_shd.g_old_rec.val_243;
2236 End If;
2237 If (p_rec.val_244 = hr_api.g_varchar2) then
2238 p_rec.val_244 :=
2239 ben_xrd_shd.g_old_rec.val_244;
2240 End If;
2241 If (p_rec.val_245 = hr_api.g_varchar2) then
2242 p_rec.val_245 :=
2243 ben_xrd_shd.g_old_rec.val_245;
2244 End If;
2245 If (p_rec.val_246 = hr_api.g_varchar2) then
2246 p_rec.val_246 :=
2247 ben_xrd_shd.g_old_rec.val_246;
2248 End If;
2249 If (p_rec.val_247 = hr_api.g_varchar2) then
2250 p_rec.val_247 :=
2251 ben_xrd_shd.g_old_rec.val_247;
2252 End If;
2253 If (p_rec.val_248 = hr_api.g_varchar2) then
2254 p_rec.val_248 :=
2255 ben_xrd_shd.g_old_rec.val_248;
2256 End If;
2257 If (p_rec.val_249 = hr_api.g_varchar2) then
2258 p_rec.val_249 :=
2259 ben_xrd_shd.g_old_rec.val_249;
2260 End If;
2261 If (p_rec.val_250 = hr_api.g_varchar2) then
2262 p_rec.val_250 :=
2263 ben_xrd_shd.g_old_rec.val_250;
2264 End If;
2265 If (p_rec.val_251 = hr_api.g_varchar2) then
2266 p_rec.val_251 :=
2267 ben_xrd_shd.g_old_rec.val_251;
2268 End If;
2269 If (p_rec.val_252 = hr_api.g_varchar2) then
2270 p_rec.val_252 :=
2271 ben_xrd_shd.g_old_rec.val_252;
2272 End If;
2273 If (p_rec.val_253 = hr_api.g_varchar2) then
2274 p_rec.val_253 :=
2275 ben_xrd_shd.g_old_rec.val_253;
2276 End If;
2277 If (p_rec.val_254 = hr_api.g_varchar2) then
2278 p_rec.val_254 :=
2279 ben_xrd_shd.g_old_rec.val_254;
2280 End If;
2281 If (p_rec.val_255 = hr_api.g_varchar2) then
2282 p_rec.val_255 :=
2283 ben_xrd_shd.g_old_rec.val_255;
2284 End If;
2285 If (p_rec.val_256 = hr_api.g_varchar2) then
2286 p_rec.val_256 :=
2287 ben_xrd_shd.g_old_rec.val_256;
2288 End If;
2289 If (p_rec.val_257 = hr_api.g_varchar2) then
2290 p_rec.val_257 :=
2291 ben_xrd_shd.g_old_rec.val_257;
2292 End If;
2293 If (p_rec.val_258 = hr_api.g_varchar2) then
2294 p_rec.val_258 :=
2295 ben_xrd_shd.g_old_rec.val_258;
2296 End If;
2297 If (p_rec.val_259 = hr_api.g_varchar2) then
2298 p_rec.val_259 :=
2299 ben_xrd_shd.g_old_rec.val_259;
2300 End If;
2301 If (p_rec.val_260 = hr_api.g_varchar2) then
2302 p_rec.val_260 :=
2303 ben_xrd_shd.g_old_rec.val_260;
2304 End If;
2305 If (p_rec.val_261 = hr_api.g_varchar2) then
2306 p_rec.val_261 :=
2307 ben_xrd_shd.g_old_rec.val_261;
2308 End If;
2309 If (p_rec.val_262 = hr_api.g_varchar2) then
2310 p_rec.val_262 :=
2311 ben_xrd_shd.g_old_rec.val_262;
2312 End If;
2313 If (p_rec.val_263 = hr_api.g_varchar2) then
2314 p_rec.val_263 :=
2315 ben_xrd_shd.g_old_rec.val_263;
2316 End If;
2317 If (p_rec.val_264 = hr_api.g_varchar2) then
2318 p_rec.val_264 :=
2319 ben_xrd_shd.g_old_rec.val_264;
2320 End If;
2321 If (p_rec.val_265 = hr_api.g_varchar2) then
2322 p_rec.val_265 :=
2323 ben_xrd_shd.g_old_rec.val_265;
2324 End If;
2325 If (p_rec.val_266 = hr_api.g_varchar2) then
2326 p_rec.val_266 :=
2327 ben_xrd_shd.g_old_rec.val_266;
2328 End If;
2329 If (p_rec.val_267 = hr_api.g_varchar2) then
2330 p_rec.val_267 :=
2331 ben_xrd_shd.g_old_rec.val_267;
2332 End If;
2333 If (p_rec.val_268 = hr_api.g_varchar2) then
2334 p_rec.val_268 :=
2335 ben_xrd_shd.g_old_rec.val_268;
2336 End If;
2337 If (p_rec.val_269 = hr_api.g_varchar2) then
2338 p_rec.val_269 :=
2339 ben_xrd_shd.g_old_rec.val_269;
2340 End If;
2341 If (p_rec.val_270 = hr_api.g_varchar2) then
2342 p_rec.val_270 :=
2343 ben_xrd_shd.g_old_rec.val_270;
2344 End If;
2345 If (p_rec.val_271 = hr_api.g_varchar2) then
2346 p_rec.val_271 :=
2347 ben_xrd_shd.g_old_rec.val_271;
2348 End If;
2349 If (p_rec.val_272 = hr_api.g_varchar2) then
2350 p_rec.val_272 :=
2351 ben_xrd_shd.g_old_rec.val_272;
2352 End If;
2353 If (p_rec.val_273 = hr_api.g_varchar2) then
2354 p_rec.val_273 :=
2355 ben_xrd_shd.g_old_rec.val_273;
2356 End If;
2357 If (p_rec.val_274 = hr_api.g_varchar2) then
2358 p_rec.val_274 :=
2359 ben_xrd_shd.g_old_rec.val_274;
2360 End If;
2361 If (p_rec.val_275 = hr_api.g_varchar2) then
2362 p_rec.val_275 :=
2363 ben_xrd_shd.g_old_rec.val_275;
2364 End If;
2365 If (p_rec.val_276 = hr_api.g_varchar2) then
2366 p_rec.val_276 :=
2367 ben_xrd_shd.g_old_rec.val_276;
2368 End If;
2369 If (p_rec.val_277 = hr_api.g_varchar2) then
2370 p_rec.val_277 :=
2371 ben_xrd_shd.g_old_rec.val_277;
2372 End If;
2373 If (p_rec.val_278 = hr_api.g_varchar2) then
2374 p_rec.val_278 :=
2375 ben_xrd_shd.g_old_rec.val_278;
2376 End If;
2377 If (p_rec.val_279 = hr_api.g_varchar2) then
2378 p_rec.val_279 :=
2379 ben_xrd_shd.g_old_rec.val_279;
2380 End If;
2381 If (p_rec.val_280 = hr_api.g_varchar2) then
2382 p_rec.val_280 :=
2383 ben_xrd_shd.g_old_rec.val_280;
2384 End If;
2385 If (p_rec.val_281 = hr_api.g_varchar2) then
2386 p_rec.val_281 :=
2387 ben_xrd_shd.g_old_rec.val_281;
2388 End If;
2389 If (p_rec.val_282 = hr_api.g_varchar2) then
2390 p_rec.val_282 :=
2391 ben_xrd_shd.g_old_rec.val_282;
2392 End If;
2393 If (p_rec.val_283 = hr_api.g_varchar2) then
2394 p_rec.val_283 :=
2395 ben_xrd_shd.g_old_rec.val_283;
2396 End If;
2397 If (p_rec.val_284 = hr_api.g_varchar2) then
2398 p_rec.val_284 :=
2399 ben_xrd_shd.g_old_rec.val_284;
2400 End If;
2401 If (p_rec.val_285 = hr_api.g_varchar2) then
2402 p_rec.val_285 :=
2403 ben_xrd_shd.g_old_rec.val_285;
2404 End If;
2405 If (p_rec.val_286 = hr_api.g_varchar2) then
2406 p_rec.val_286 :=
2407 ben_xrd_shd.g_old_rec.val_286;
2408 End If;
2409 If (p_rec.val_287 = hr_api.g_varchar2) then
2410 p_rec.val_287 :=
2411 ben_xrd_shd.g_old_rec.val_287;
2412 End If;
2413 If (p_rec.val_288 = hr_api.g_varchar2) then
2414 p_rec.val_288 :=
2415 ben_xrd_shd.g_old_rec.val_288;
2416 End If;
2417 If (p_rec.val_289 = hr_api.g_varchar2) then
2418 p_rec.val_289 :=
2419 ben_xrd_shd.g_old_rec.val_289;
2420 End If;
2421 If (p_rec.val_290 = hr_api.g_varchar2) then
2422 p_rec.val_290 :=
2423 ben_xrd_shd.g_old_rec.val_290;
2424 End If;
2425 If (p_rec.val_291 = hr_api.g_varchar2) then
2426 p_rec.val_291 :=
2427 ben_xrd_shd.g_old_rec.val_291;
2428 End If;
2429 If (p_rec.val_292 = hr_api.g_varchar2) then
2430 p_rec.val_292 :=
2431 ben_xrd_shd.g_old_rec.val_292;
2432 End If;
2433 If (p_rec.val_293 = hr_api.g_varchar2) then
2434 p_rec.val_293 :=
2435 ben_xrd_shd.g_old_rec.val_293;
2436 End If;
2437 If (p_rec.val_294 = hr_api.g_varchar2) then
2438 p_rec.val_294 :=
2439 ben_xrd_shd.g_old_rec.val_294;
2440 End If;
2441 If (p_rec.val_295 = hr_api.g_varchar2) then
2442 p_rec.val_295 :=
2443 ben_xrd_shd.g_old_rec.val_295;
2444 End If;
2445 If (p_rec.val_296 = hr_api.g_varchar2) then
2446 p_rec.val_296 :=
2447 ben_xrd_shd.g_old_rec.val_296;
2448 End If;
2449 If (p_rec.val_297 = hr_api.g_varchar2) then
2450 p_rec.val_297 :=
2451 ben_xrd_shd.g_old_rec.val_297;
2452 End If;
2453 If (p_rec.val_298 = hr_api.g_varchar2) then
2454 p_rec.val_298 :=
2455 ben_xrd_shd.g_old_rec.val_298;
2456 End If;
2457 If (p_rec.val_299 = hr_api.g_varchar2) then
2458 p_rec.val_299 :=
2459 ben_xrd_shd.g_old_rec.val_299;
2460 End If;
2461 If (p_rec.val_300 = hr_api.g_varchar2) then
2462 p_rec.val_300 :=
2463 ben_xrd_shd.g_old_rec.val_300;
2464 End If;
2465
2466 If (p_rec.group_val_01 = hr_api.g_varchar2) then
2467 p_rec.group_val_01 :=
2468 ben_xrd_shd.g_old_rec.group_val_01;
2469 End If;
2470
2471 If (p_rec.group_val_02 = hr_api.g_varchar2) then
2472 p_rec.group_val_02 :=
2473 ben_xrd_shd.g_old_rec.group_val_02;
2474 End If;
2475
2476 --
2477 If (p_rec.program_application_id = hr_api.g_number) then
2478 p_rec.program_application_id :=
2479 ben_xrd_shd.g_old_rec.program_application_id;
2480 End If;
2481 If (p_rec.program_id = hr_api.g_number) then
2482 p_rec.program_id :=
2483 ben_xrd_shd.g_old_rec.program_id;
2484 End If;
2485 If (p_rec.program_update_date = hr_api.g_date) then
2486 p_rec.program_update_date :=
2487 ben_xrd_shd.g_old_rec.program_update_date;
2488 End If;
2489 If (p_rec.request_id = hr_api.g_number) then
2490 p_rec.request_id :=
2491 ben_xrd_shd.g_old_rec.request_id;
2492 End If;
2493
2494 --
2495 hr_utility.set_location(' Leaving:'||l_proc, 10);
2496 --
2497 End convert_defs;
2498 --
2499 -- ----------------------------------------------------------------------------
2500 -- |---------------------------------< upd >----------------------------------|
2501 -- ----------------------------------------------------------------------------
2502 Procedure upd
2503 (
2504 p_rec in out nocopy ben_xrd_shd.g_rec_type
2505 ) is
2506 --
2507 l_proc varchar2(72) := g_package||'upd';
2508 --
2509 Begin
2510 hr_utility.set_location('Entering:'||l_proc, 5);
2511 --
2512 -- We must lock the row which we need to update.
2513 --
2514 ben_xrd_shd.lck
2515 (
2516 p_rec.ext_rslt_dtl_id,
2517 p_rec.object_version_number
2518 );
2519 --
2520 -- 1. During an update system defaults are used to determine if
2521 -- arguments have been defaulted or not. We must therefore
2522 -- derive the full record structure values to be updated.
2523 --
2524 -- 2. Call the supporting update validate operations.
2525 --
2526 convert_defs(p_rec);
2527 ben_xrd_bus.update_validate(p_rec);
2528 --
2529 -- Call the supporting pre-update operation
2530 --
2531 pre_update(p_rec);
2532 --
2533 -- Update the row.
2534 --
2535 update_dml(p_rec);
2536 --
2537 -- Call the supporting post-update operation
2538 --
2539 post_update(p_rec);
2540 End upd;
2541 --
2542 -- ----------------------------------------------------------------------------
2543 -- |---------------------------------< upd >----------------------------------|
2544 -- ----------------------------------------------------------------------------
2545 Procedure upd
2546 (
2547 p_ext_rslt_dtl_id in number,
2548 p_prmy_sort_val in varchar2 default hr_api.g_varchar2,
2549 p_scnd_sort_val in varchar2 default hr_api.g_varchar2,
2550 p_thrd_sort_val in varchar2 default hr_api.g_varchar2,
2551 p_trans_seq_num in number default hr_api.g_number,
2552 p_rcrd_seq_num in number default hr_api.g_number,
2553 p_ext_rslt_id in number default hr_api.g_number,
2554 p_ext_rcd_id in number default hr_api.g_number,
2555 p_person_id in number default hr_api.g_number,
2556 p_business_group_id in number default hr_api.g_number,
2557 p_ext_per_bg_id in number default hr_api.g_number,
2558 p_val_01 in varchar2 default hr_api.g_varchar2,
2559 p_val_02 in varchar2 default hr_api.g_varchar2,
2560 p_val_03 in varchar2 default hr_api.g_varchar2,
2561 p_val_04 in varchar2 default hr_api.g_varchar2,
2562 p_val_05 in varchar2 default hr_api.g_varchar2,
2563 p_val_06 in varchar2 default hr_api.g_varchar2,
2564 p_val_07 in varchar2 default hr_api.g_varchar2,
2565 p_val_08 in varchar2 default hr_api.g_varchar2,
2566 p_val_09 in varchar2 default hr_api.g_varchar2,
2567 p_val_10 in varchar2 default hr_api.g_varchar2,
2568 p_val_11 in varchar2 default hr_api.g_varchar2,
2569 p_val_12 in varchar2 default hr_api.g_varchar2,
2570 p_val_13 in varchar2 default hr_api.g_varchar2,
2571 p_val_14 in varchar2 default hr_api.g_varchar2,
2572 p_val_15 in varchar2 default hr_api.g_varchar2,
2573 p_val_16 in varchar2 default hr_api.g_varchar2,
2574 p_val_17 in varchar2 default hr_api.g_varchar2,
2575 p_val_19 in varchar2 default hr_api.g_varchar2,
2576 p_val_18 in varchar2 default hr_api.g_varchar2,
2577 p_val_20 in varchar2 default hr_api.g_varchar2,
2578 p_val_21 in varchar2 default hr_api.g_varchar2,
2579 p_val_22 in varchar2 default hr_api.g_varchar2,
2580 p_val_23 in varchar2 default hr_api.g_varchar2,
2581 p_val_24 in varchar2 default hr_api.g_varchar2,
2582 p_val_25 in varchar2 default hr_api.g_varchar2,
2583 p_val_26 in varchar2 default hr_api.g_varchar2,
2584 p_val_27 in varchar2 default hr_api.g_varchar2,
2585 p_val_28 in varchar2 default hr_api.g_varchar2,
2586 p_val_29 in varchar2 default hr_api.g_varchar2,
2587 p_val_30 in varchar2 default hr_api.g_varchar2,
2588 p_val_31 in varchar2 default hr_api.g_varchar2,
2589 p_val_32 in varchar2 default hr_api.g_varchar2,
2590 p_val_33 in varchar2 default hr_api.g_varchar2,
2591 p_val_34 in varchar2 default hr_api.g_varchar2,
2592 p_val_35 in varchar2 default hr_api.g_varchar2,
2593 p_val_36 in varchar2 default hr_api.g_varchar2,
2594 p_val_37 in varchar2 default hr_api.g_varchar2,
2595 p_val_38 in varchar2 default hr_api.g_varchar2,
2596 p_val_39 in varchar2 default hr_api.g_varchar2,
2597 p_val_40 in varchar2 default hr_api.g_varchar2,
2598 p_val_41 in varchar2 default hr_api.g_varchar2,
2599 p_val_42 in varchar2 default hr_api.g_varchar2,
2600 p_val_43 in varchar2 default hr_api.g_varchar2,
2601 p_val_44 in varchar2 default hr_api.g_varchar2,
2602 p_val_45 in varchar2 default hr_api.g_varchar2,
2603 p_val_46 in varchar2 default hr_api.g_varchar2,
2604 p_val_47 in varchar2 default hr_api.g_varchar2,
2605 p_val_48 in varchar2 default hr_api.g_varchar2,
2606 p_val_49 in varchar2 default hr_api.g_varchar2,
2607 p_val_50 in varchar2 default hr_api.g_varchar2,
2608 p_val_51 in varchar2 default hr_api.g_varchar2,
2609 p_val_52 in varchar2 default hr_api.g_varchar2,
2610 p_val_53 in varchar2 default hr_api.g_varchar2,
2611 p_val_54 in varchar2 default hr_api.g_varchar2,
2612 p_val_55 in varchar2 default hr_api.g_varchar2,
2613 p_val_56 in varchar2 default hr_api.g_varchar2,
2614 p_val_57 in varchar2 default hr_api.g_varchar2,
2615 p_val_58 in varchar2 default hr_api.g_varchar2,
2616 p_val_59 in varchar2 default hr_api.g_varchar2,
2617 p_val_60 in varchar2 default hr_api.g_varchar2,
2618 p_val_61 in varchar2 default hr_api.g_varchar2,
2619 p_val_62 in varchar2 default hr_api.g_varchar2,
2620 p_val_63 in varchar2 default hr_api.g_varchar2,
2621 p_val_64 in varchar2 default hr_api.g_varchar2,
2622 p_val_65 in varchar2 default hr_api.g_varchar2,
2623 p_val_66 in varchar2 default hr_api.g_varchar2,
2624 p_val_67 in varchar2 default hr_api.g_varchar2,
2625 p_val_68 in varchar2 default hr_api.g_varchar2,
2626 p_val_69 in varchar2 default hr_api.g_varchar2,
2627 p_val_70 in varchar2 default hr_api.g_varchar2,
2628 p_val_71 in varchar2 default hr_api.g_varchar2,
2629 p_val_72 in varchar2 default hr_api.g_varchar2,
2630 p_val_73 in varchar2 default hr_api.g_varchar2,
2631 p_val_74 in varchar2 default hr_api.g_varchar2,
2632 p_val_75 in varchar2 default hr_api.g_varchar2,
2633 p_val_76 in varchar2 default hr_api.g_varchar2 ,
2634 p_val_77 in varchar2 default hr_api.g_varchar2 ,
2635 p_val_78 in varchar2 default hr_api.g_varchar2 ,
2636 p_val_79 in varchar2 default hr_api.g_varchar2 ,
2637 p_val_80 in varchar2 default hr_api.g_varchar2 ,
2638 p_val_81 in varchar2 default hr_api.g_varchar2 ,
2639 p_val_82 in varchar2 default hr_api.g_varchar2 ,
2640 p_val_83 in varchar2 default hr_api.g_varchar2 ,
2641 p_val_84 in varchar2 default hr_api.g_varchar2 ,
2642 p_val_85 in varchar2 default hr_api.g_varchar2 ,
2643 p_val_86 in varchar2 default hr_api.g_varchar2 ,
2644 p_val_87 in varchar2 default hr_api.g_varchar2 ,
2645 p_val_88 in varchar2 default hr_api.g_varchar2 ,
2646 p_val_89 in varchar2 default hr_api.g_varchar2 ,
2647 p_val_90 in varchar2 default hr_api.g_varchar2 ,
2648 p_val_91 in varchar2 default hr_api.g_varchar2 ,
2649 p_val_92 in varchar2 default hr_api.g_varchar2 ,
2650 p_val_93 in varchar2 default hr_api.g_varchar2 ,
2651 p_val_94 in varchar2 default hr_api.g_varchar2 ,
2652 p_val_95 in varchar2 default hr_api.g_varchar2 ,
2653 p_val_96 in varchar2 default hr_api.g_varchar2 ,
2654 p_val_97 in varchar2 default hr_api.g_varchar2 ,
2655 p_val_98 in varchar2 default hr_api.g_varchar2 ,
2656 p_val_99 in varchar2 default hr_api.g_varchar2 ,
2657 p_val_100 in varchar2 default hr_api.g_varchar2 ,
2658 p_val_101 in varchar2 default hr_api.g_varchar2 ,
2659 p_val_102 in varchar2 default hr_api.g_varchar2 ,
2660 p_val_103 in varchar2 default hr_api.g_varchar2 ,
2661 p_val_104 in varchar2 default hr_api.g_varchar2 ,
2662 p_val_105 in varchar2 default hr_api.g_varchar2 ,
2663 p_val_106 in varchar2 default hr_api.g_varchar2 ,
2664 p_val_107 in varchar2 default hr_api.g_varchar2 ,
2665 p_val_108 in varchar2 default hr_api.g_varchar2 ,
2666 p_val_109 in varchar2 default hr_api.g_varchar2 ,
2667 p_val_110 in varchar2 default hr_api.g_varchar2 ,
2668 p_val_111 in varchar2 default hr_api.g_varchar2 ,
2669 p_val_112 in varchar2 default hr_api.g_varchar2 ,
2670 p_val_113 in varchar2 default hr_api.g_varchar2 ,
2671 p_val_114 in varchar2 default hr_api.g_varchar2 ,
2672 p_val_115 in varchar2 default hr_api.g_varchar2 ,
2673 p_val_116 in varchar2 default hr_api.g_varchar2 ,
2674 p_val_117 in varchar2 default hr_api.g_varchar2 ,
2675 p_val_119 in varchar2 default hr_api.g_varchar2 ,
2676 p_val_118 in varchar2 default hr_api.g_varchar2 ,
2677 p_val_120 in varchar2 default hr_api.g_varchar2 ,
2678 p_val_121 in varchar2 default hr_api.g_varchar2 ,
2679 p_val_122 in varchar2 default hr_api.g_varchar2 ,
2680 p_val_123 in varchar2 default hr_api.g_varchar2 ,
2681 p_val_124 in varchar2 default hr_api.g_varchar2 ,
2682 p_val_125 in varchar2 default hr_api.g_varchar2 ,
2683 p_val_126 in varchar2 default hr_api.g_varchar2 ,
2684 p_val_127 in varchar2 default hr_api.g_varchar2 ,
2685 p_val_128 in varchar2 default hr_api.g_varchar2 ,
2686 p_val_129 in varchar2 default hr_api.g_varchar2 ,
2687 p_val_130 in varchar2 default hr_api.g_varchar2 ,
2688 p_val_131 in varchar2 default hr_api.g_varchar2 ,
2689 p_val_132 in varchar2 default hr_api.g_varchar2 ,
2690 p_val_133 in varchar2 default hr_api.g_varchar2 ,
2691 p_val_134 in varchar2 default hr_api.g_varchar2 ,
2692 p_val_135 in varchar2 default hr_api.g_varchar2 ,
2693 p_val_136 in varchar2 default hr_api.g_varchar2 ,
2694 p_val_137 in varchar2 default hr_api.g_varchar2 ,
2695 p_val_138 in varchar2 default hr_api.g_varchar2 ,
2696 p_val_139 in varchar2 default hr_api.g_varchar2 ,
2697 p_val_140 in varchar2 default hr_api.g_varchar2 ,
2698 p_val_141 in varchar2 default hr_api.g_varchar2 ,
2699 p_val_142 in varchar2 default hr_api.g_varchar2 ,
2700 p_val_143 in varchar2 default hr_api.g_varchar2 ,
2701 p_val_144 in varchar2 default hr_api.g_varchar2 ,
2702 p_val_145 in varchar2 default hr_api.g_varchar2 ,
2703 p_val_146 in varchar2 default hr_api.g_varchar2 ,
2704 p_val_147 in varchar2 default hr_api.g_varchar2 ,
2705 p_val_148 in varchar2 default hr_api.g_varchar2 ,
2706 p_val_149 in varchar2 default hr_api.g_varchar2 ,
2707 p_val_150 in varchar2 default hr_api.g_varchar2 ,
2708 p_val_151 in varchar2 default hr_api.g_varchar2 ,
2709 p_val_152 in varchar2 default hr_api.g_varchar2 ,
2710 p_val_153 in varchar2 default hr_api.g_varchar2 ,
2711 p_val_154 in varchar2 default hr_api.g_varchar2 ,
2712 p_val_155 in varchar2 default hr_api.g_varchar2 ,
2713 p_val_156 in varchar2 default hr_api.g_varchar2 ,
2714 p_val_157 in varchar2 default hr_api.g_varchar2 ,
2715 p_val_158 in varchar2 default hr_api.g_varchar2 ,
2716 p_val_159 in varchar2 default hr_api.g_varchar2 ,
2717 p_val_160 in varchar2 default hr_api.g_varchar2 ,
2718 p_val_161 in varchar2 default hr_api.g_varchar2 ,
2719 p_val_162 in varchar2 default hr_api.g_varchar2 ,
2720 p_val_163 in varchar2 default hr_api.g_varchar2 ,
2721 p_val_164 in varchar2 default hr_api.g_varchar2 ,
2722 p_val_165 in varchar2 default hr_api.g_varchar2 ,
2723 p_val_166 in varchar2 default hr_api.g_varchar2 ,
2724 p_val_167 in varchar2 default hr_api.g_varchar2 ,
2725 p_val_168 in varchar2 default hr_api.g_varchar2 ,
2726 p_val_169 in varchar2 default hr_api.g_varchar2 ,
2727 p_val_170 in varchar2 default hr_api.g_varchar2 ,
2728 p_val_171 in varchar2 default hr_api.g_varchar2 ,
2729 p_val_172 in varchar2 default hr_api.g_varchar2 ,
2730 p_val_173 in varchar2 default hr_api.g_varchar2 ,
2731 p_val_174 in varchar2 default hr_api.g_varchar2 ,
2732 p_val_175 in varchar2 default hr_api.g_varchar2 ,
2733 p_val_176 in varchar2 default hr_api.g_varchar2 ,
2734 p_val_177 in varchar2 default hr_api.g_varchar2 ,
2735 p_val_178 in varchar2 default hr_api.g_varchar2 ,
2736 p_val_179 in varchar2 default hr_api.g_varchar2 ,
2737 p_val_180 in varchar2 default hr_api.g_varchar2 ,
2738 p_val_181 in varchar2 default hr_api.g_varchar2 ,
2739 p_val_182 in varchar2 default hr_api.g_varchar2 ,
2740 p_val_183 in varchar2 default hr_api.g_varchar2 ,
2741 p_val_184 in varchar2 default hr_api.g_varchar2 ,
2742 p_val_185 in varchar2 default hr_api.g_varchar2 ,
2743 p_val_186 in varchar2 default hr_api.g_varchar2 ,
2744 p_val_187 in varchar2 default hr_api.g_varchar2 ,
2745 p_val_188 in varchar2 default hr_api.g_varchar2 ,
2746 p_val_189 in varchar2 default hr_api.g_varchar2 ,
2747 p_val_190 in varchar2 default hr_api.g_varchar2 ,
2748 p_val_191 in varchar2 default hr_api.g_varchar2 ,
2749 p_val_192 in varchar2 default hr_api.g_varchar2 ,
2750 p_val_193 in varchar2 default hr_api.g_varchar2 ,
2751 p_val_194 in varchar2 default hr_api.g_varchar2 ,
2752 p_val_195 in varchar2 default hr_api.g_varchar2 ,
2753 p_val_196 in varchar2 default hr_api.g_varchar2 ,
2754 p_val_197 in varchar2 default hr_api.g_varchar2 ,
2755 p_val_198 in varchar2 default hr_api.g_varchar2 ,
2756 p_val_199 in varchar2 default hr_api.g_varchar2 ,
2757 p_val_200 in varchar2 default hr_api.g_varchar2 ,
2758 p_val_201 in varchar2 default hr_api.g_varchar2 ,
2759 p_val_202 in varchar2 default hr_api.g_varchar2 ,
2760 p_val_203 in varchar2 default hr_api.g_varchar2 ,
2761 p_val_204 in varchar2 default hr_api.g_varchar2 ,
2762 p_val_205 in varchar2 default hr_api.g_varchar2 ,
2763 p_val_206 in varchar2 default hr_api.g_varchar2 ,
2764 p_val_207 in varchar2 default hr_api.g_varchar2 ,
2765 p_val_208 in varchar2 default hr_api.g_varchar2 ,
2766 p_val_209 in varchar2 default hr_api.g_varchar2 ,
2767 p_val_210 in varchar2 default hr_api.g_varchar2 ,
2768 p_val_211 in varchar2 default hr_api.g_varchar2 ,
2769 p_val_212 in varchar2 default hr_api.g_varchar2 ,
2770 p_val_213 in varchar2 default hr_api.g_varchar2 ,
2771 p_val_214 in varchar2 default hr_api.g_varchar2 ,
2772 p_val_215 in varchar2 default hr_api.g_varchar2 ,
2773 p_val_216 in varchar2 default hr_api.g_varchar2 ,
2774 p_val_217 in varchar2 default hr_api.g_varchar2 ,
2775 p_val_219 in varchar2 default hr_api.g_varchar2 ,
2776 p_val_218 in varchar2 default hr_api.g_varchar2 ,
2777 p_val_220 in varchar2 default hr_api.g_varchar2 ,
2778 p_val_221 in varchar2 default hr_api.g_varchar2 ,
2779 p_val_222 in varchar2 default hr_api.g_varchar2 ,
2780 p_val_223 in varchar2 default hr_api.g_varchar2 ,
2781 p_val_224 in varchar2 default hr_api.g_varchar2 ,
2782 p_val_225 in varchar2 default hr_api.g_varchar2 ,
2783 p_val_226 in varchar2 default hr_api.g_varchar2 ,
2784 p_val_227 in varchar2 default hr_api.g_varchar2 ,
2785 p_val_228 in varchar2 default hr_api.g_varchar2 ,
2786 p_val_229 in varchar2 default hr_api.g_varchar2 ,
2787 p_val_230 in varchar2 default hr_api.g_varchar2 ,
2788 p_val_231 in varchar2 default hr_api.g_varchar2 ,
2789 p_val_232 in varchar2 default hr_api.g_varchar2 ,
2790 p_val_233 in varchar2 default hr_api.g_varchar2 ,
2791 p_val_234 in varchar2 default hr_api.g_varchar2 ,
2792 p_val_235 in varchar2 default hr_api.g_varchar2 ,
2793 p_val_236 in varchar2 default hr_api.g_varchar2 ,
2794 p_val_237 in varchar2 default hr_api.g_varchar2 ,
2795 p_val_238 in varchar2 default hr_api.g_varchar2 ,
2796 p_val_239 in varchar2 default hr_api.g_varchar2 ,
2797 p_val_240 in varchar2 default hr_api.g_varchar2 ,
2798 p_val_241 in varchar2 default hr_api.g_varchar2 ,
2799 p_val_242 in varchar2 default hr_api.g_varchar2 ,
2800 p_val_243 in varchar2 default hr_api.g_varchar2 ,
2801 p_val_244 in varchar2 default hr_api.g_varchar2 ,
2802 p_val_245 in varchar2 default hr_api.g_varchar2 ,
2803 p_val_246 in varchar2 default hr_api.g_varchar2 ,
2804 p_val_247 in varchar2 default hr_api.g_varchar2 ,
2805 p_val_248 in varchar2 default hr_api.g_varchar2 ,
2806 p_val_249 in varchar2 default hr_api.g_varchar2 ,
2807 p_val_250 in varchar2 default hr_api.g_varchar2 ,
2808 p_val_251 in varchar2 default hr_api.g_varchar2 ,
2809 p_val_252 in varchar2 default hr_api.g_varchar2 ,
2810 p_val_253 in varchar2 default hr_api.g_varchar2 ,
2811 p_val_254 in varchar2 default hr_api.g_varchar2 ,
2812 p_val_255 in varchar2 default hr_api.g_varchar2 ,
2813 p_val_256 in varchar2 default hr_api.g_varchar2 ,
2814 p_val_257 in varchar2 default hr_api.g_varchar2 ,
2815 p_val_258 in varchar2 default hr_api.g_varchar2 ,
2816 p_val_259 in varchar2 default hr_api.g_varchar2 ,
2817 p_val_260 in varchar2 default hr_api.g_varchar2 ,
2818 p_val_261 in varchar2 default hr_api.g_varchar2 ,
2819 p_val_262 in varchar2 default hr_api.g_varchar2 ,
2820 p_val_263 in varchar2 default hr_api.g_varchar2 ,
2821 p_val_264 in varchar2 default hr_api.g_varchar2 ,
2822 p_val_265 in varchar2 default hr_api.g_varchar2 ,
2823 p_val_266 in varchar2 default hr_api.g_varchar2 ,
2824 p_val_267 in varchar2 default hr_api.g_varchar2 ,
2825 p_val_268 in varchar2 default hr_api.g_varchar2 ,
2826 p_val_269 in varchar2 default hr_api.g_varchar2 ,
2827 p_val_270 in varchar2 default hr_api.g_varchar2 ,
2828 p_val_271 in varchar2 default hr_api.g_varchar2 ,
2829 p_val_272 in varchar2 default hr_api.g_varchar2 ,
2830 p_val_273 in varchar2 default hr_api.g_varchar2 ,
2831 p_val_274 in varchar2 default hr_api.g_varchar2 ,
2832 p_val_275 in varchar2 default hr_api.g_varchar2 ,
2833 p_val_276 in varchar2 default hr_api.g_varchar2 ,
2834 p_val_277 in varchar2 default hr_api.g_varchar2 ,
2835 p_val_278 in varchar2 default hr_api.g_varchar2 ,
2836 p_val_279 in varchar2 default hr_api.g_varchar2 ,
2837 p_val_280 in varchar2 default hr_api.g_varchar2 ,
2838 p_val_281 in varchar2 default hr_api.g_varchar2 ,
2839 p_val_282 in varchar2 default hr_api.g_varchar2 ,
2840 p_val_283 in varchar2 default hr_api.g_varchar2 ,
2841 p_val_284 in varchar2 default hr_api.g_varchar2 ,
2842 p_val_285 in varchar2 default hr_api.g_varchar2 ,
2843 p_val_286 in varchar2 default hr_api.g_varchar2 ,
2844 p_val_287 in varchar2 default hr_api.g_varchar2 ,
2845 p_val_288 in varchar2 default hr_api.g_varchar2 ,
2846 p_val_289 in varchar2 default hr_api.g_varchar2 ,
2847 p_val_290 in varchar2 default hr_api.g_varchar2 ,
2848 p_val_291 in varchar2 default hr_api.g_varchar2 ,
2849 p_val_292 in varchar2 default hr_api.g_varchar2 ,
2850 p_val_293 in varchar2 default hr_api.g_varchar2 ,
2851 p_val_294 in varchar2 default hr_api.g_varchar2 ,
2852 p_val_295 in varchar2 default hr_api.g_varchar2 ,
2853 p_val_296 in varchar2 default hr_api.g_varchar2 ,
2854 p_val_297 in varchar2 default hr_api.g_varchar2 ,
2855 p_val_298 in varchar2 default hr_api.g_varchar2 ,
2856 p_val_299 in varchar2 default hr_api.g_varchar2 ,
2857 p_val_300 in varchar2 default hr_api.g_varchar2 ,
2858 p_group_val_01 in varchar2 default hr_api.g_varchar2 ,
2859 p_group_val_02 in varchar2 default hr_api.g_varchar2 ,
2860 p_program_application_id in number default hr_api.g_number,
2861 p_program_id in number default hr_api.g_number,
2862 p_program_update_date in date default hr_api.g_date,
2863 p_request_id in number default hr_api.g_number,
2864 p_object_version_number in out nocopy number ,
2865 p_ext_rcd_in_file_id in number default hr_api.g_number
2866 ) is
2867 --
2868 l_rec ben_xrd_shd.g_rec_type;
2869 l_proc varchar2(72) := g_package||'upd';
2870 --
2871 Begin
2872 hr_utility.set_location('Entering:'||l_proc, 5);
2873 --
2874 -- Call conversion function to turn arguments into the
2875 -- l_rec structure.
2876 --
2877 l_rec :=
2878 ben_xrd_shd.convert_args
2879 (
2880 p_ext_rslt_dtl_id,
2881 p_prmy_sort_val,
2882 p_scnd_sort_val,
2883 p_thrd_sort_val,
2884 p_trans_seq_num,
2885 p_rcrd_seq_num,
2886 p_ext_rslt_id,
2887 p_ext_rcd_id,
2888 p_person_id,
2889 p_business_group_id,
2890 p_ext_per_bg_id,
2891 p_val_01,
2892 p_val_02,
2893 p_val_03,
2894 p_val_04,
2895 p_val_05,
2896 p_val_06,
2897 p_val_07,
2898 p_val_08,
2899 p_val_09,
2900 p_val_10,
2901 p_val_11,
2902 p_val_12,
2903 p_val_13,
2904 p_val_14,
2905 p_val_15,
2906 p_val_16,
2907 p_val_17,
2908 p_val_19,
2909 p_val_18,
2910 p_val_20,
2911 p_val_21,
2912 p_val_22,
2913 p_val_23,
2914 p_val_24,
2915 p_val_25,
2916 p_val_26,
2917 p_val_27,
2918 p_val_28,
2919 p_val_29,
2920 p_val_30,
2921 p_val_31,
2922 p_val_32,
2923 p_val_33,
2924 p_val_34,
2925 p_val_35,
2926 p_val_36,
2927 p_val_37,
2928 p_val_38,
2929 p_val_39,
2930 p_val_40,
2931 p_val_41,
2932 p_val_42,
2933 p_val_43,
2934 p_val_44,
2935 p_val_45,
2936 p_val_46,
2937 p_val_47,
2938 p_val_48,
2939 p_val_49,
2940 p_val_50,
2941 p_val_51,
2942 p_val_52,
2943 p_val_53,
2944 p_val_54,
2945 p_val_55,
2946 p_val_56,
2947 p_val_57,
2948 p_val_58,
2949 p_val_59,
2950 p_val_60,
2951 p_val_61,
2952 p_val_62,
2953 p_val_63,
2954 p_val_64,
2955 p_val_65,
2956 p_val_66,
2957 p_val_67,
2958 p_val_68,
2959 p_val_69,
2960 p_val_70,
2961 p_val_71,
2962 p_val_72,
2963 p_val_73,
2964 p_val_74,
2965 p_val_75,
2966 p_val_76,
2967 p_val_77,
2968 p_val_78,
2969 p_val_79,
2970 p_val_80,
2971 p_val_81,
2972 p_val_82,
2973 p_val_83,
2974 p_val_84,
2975 p_val_85,
2976 p_val_86,
2977 p_val_87,
2978 p_val_88,
2979 p_val_89,
2980 p_val_90,
2981 p_val_91,
2982 p_val_92,
2983 p_val_93,
2984 p_val_94,
2985 p_val_95,
2986 p_val_96,
2987 p_val_97,
2988 p_val_98,
2989 p_val_99,
2990 p_val_100,
2991 p_val_101,
2992 p_val_102,
2993 p_val_103,
2994 p_val_104,
2995 p_val_105,
2996 p_val_106,
2997 p_val_107,
2998 p_val_108,
2999 p_val_109,
3000 p_val_110,
3001 p_val_111,
3002 p_val_112,
3003 p_val_113,
3004 p_val_114,
3005 p_val_115,
3006 p_val_116,
3007 p_val_117,
3008 p_val_119,
3009 p_val_118,
3010 p_val_120,
3011 p_val_121,
3012 p_val_122,
3013 p_val_123,
3014 p_val_124,
3015 p_val_125,
3016 p_val_126,
3017 p_val_127,
3018 p_val_128,
3019 p_val_129,
3020 p_val_130,
3021 p_val_131,
3022 p_val_132,
3023 p_val_133,
3024 p_val_134,
3025 p_val_135,
3026 p_val_136,
3027 p_val_137,
3028 p_val_138,
3029 p_val_139,
3030 p_val_140,
3031 p_val_141,
3032 p_val_142,
3033 p_val_143,
3034 p_val_144,
3035 p_val_145,
3036 p_val_146,
3037 p_val_147,
3038 p_val_148,
3039 p_val_149,
3040 p_val_150,
3041 p_val_151,
3042 p_val_152,
3043 p_val_153,
3044 p_val_154,
3045 p_val_155,
3046 p_val_156,
3047 p_val_157,
3048 p_val_158,
3049 p_val_159,
3050 p_val_160,
3051 p_val_161,
3052 p_val_162,
3053 p_val_163,
3054 p_val_164,
3055 p_val_165,
3056 p_val_166,
3057 p_val_167,
3058 p_val_168,
3059 p_val_169,
3060 p_val_170,
3061 p_val_171,
3062 p_val_172,
3063 p_val_173,
3064 p_val_174,
3065 p_val_175,
3066 p_val_176,
3067 p_val_177,
3068 p_val_178,
3069 p_val_179,
3070 p_val_180,
3071 p_val_181,
3072 p_val_182,
3073 p_val_183,
3074 p_val_184,
3075 p_val_185,
3076 p_val_186,
3077 p_val_187,
3078 p_val_188,
3079 p_val_189,
3080 p_val_190,
3081 p_val_191,
3082 p_val_192,
3083 p_val_193,
3084 p_val_194,
3085 p_val_195,
3086 p_val_196,
3087 p_val_197,
3088 p_val_198,
3089 p_val_199,
3090 p_val_200,
3091 p_val_201,
3092 p_val_202,
3093 p_val_203,
3094 p_val_204,
3095 p_val_205,
3096 p_val_206,
3097 p_val_207,
3098 p_val_208,
3099 p_val_209,
3100 p_val_210,
3101 p_val_211,
3102 p_val_212,
3103 p_val_213,
3104 p_val_214,
3105 p_val_215,
3106 p_val_216,
3107 p_val_217,
3108 p_val_219,
3109 p_val_218,
3110 p_val_220,
3111 p_val_221,
3112 p_val_222,
3113 p_val_223,
3114 p_val_224,
3115 p_val_225,
3116 p_val_226,
3117 p_val_227,
3118 p_val_228,
3119 p_val_229,
3120 p_val_230,
3121 p_val_231,
3122 p_val_232,
3123 p_val_233,
3124 p_val_234,
3125 p_val_235,
3126 p_val_236,
3127 p_val_237,
3128 p_val_238,
3129 p_val_239,
3130 p_val_240,
3131 p_val_241,
3132 p_val_242,
3133 p_val_243,
3134 p_val_244,
3135 p_val_245,
3136 p_val_246,
3137 p_val_247,
3138 p_val_248,
3139 p_val_249,
3140 p_val_250,
3141 p_val_251,
3142 p_val_252,
3143 p_val_253,
3144 p_val_254,
3145 p_val_255,
3146 p_val_256,
3147 p_val_257,
3148 p_val_258,
3149 p_val_259,
3150 p_val_260,
3151 p_val_261,
3152 p_val_262,
3153 p_val_263,
3154 p_val_264,
3155 p_val_265,
3156 p_val_266,
3157 p_val_267,
3158 p_val_268,
3159 p_val_269,
3160 p_val_270,
3161 p_val_271,
3162 p_val_272,
3163 p_val_273,
3164 p_val_274,
3165 p_val_275,
3166 p_val_276,
3167 p_val_277,
3168 p_val_278,
3169 p_val_279,
3170 p_val_280,
3171 p_val_281,
3172 p_val_282,
3173 p_val_283,
3174 p_val_284,
3175 p_val_285,
3176 p_val_286,
3177 p_val_287,
3178 p_val_288,
3179 p_val_289,
3180 p_val_290,
3181 p_val_291,
3182 p_val_292,
3183 p_val_293,
3184 p_val_294,
3185 p_val_295,
3186 p_val_296,
3187 p_val_297,
3188 p_val_298,
3189 p_val_299,
3190 p_val_300,
3191 p_group_val_01,
3192 p_group_val_02,
3193 p_program_application_id,
3194 p_program_id,
3195 p_program_update_date,
3196 p_request_id,
3197 p_object_version_number,
3198 p_ext_rcd_in_file_id
3199 );
3200 --
3201 -- Having converted the arguments into the
3202 -- plsql record structure we call the corresponding record
3203 -- business process.
3204 --
3205 upd(l_rec);
3206 p_object_version_number := l_rec.object_version_number;
3207 --
3208 hr_utility.set_location(' Leaving:'||l_proc, 10);
3209 End upd;
3210 --
3211 end ben_xrd_upd;