eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.PQH_CER_UPD

Source


1 Package Body pqh_cer_upd as
2 /* $Header: pqcerrhi.pkb 115.6 2002/11/27 04:43:16 rpasapul ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |                     Private Global Definitions                           |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package  varchar2(33)	:= '  pqh_cer_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 update the specified row in the schema using the primary key in
21 --      the predicates.
22 --   3) To trap any constraint violations that may have occurred.
23 --   4) To raise any other errors.
24 --
25 -- Prerequisites:
26 --   This is an internal private procedure which must be called from the upd
27 --   procedure.
28 --
29 -- In Parameters:
30 --   A Pl/Sql record structre.
31 --
32 -- Post Success:
33 --   The specified row will be updated in the schema.
34 --
35 -- Post Failure:
36 --   If a check, unique or parent integrity constraint violation is raised the
37 --   constraint_error procedure will be called.
38 --
39 -- Developer Implementation Notes:
40 --   The update 'set' attribute list should be modified if any of your
41 --   attributes are not updateable.
42 --
43 -- Access Status:
44 --   Internal Row Handler Use Only.
45 --
46 -- {End Of Comments}
47 -- ----------------------------------------------------------------------------
48 Procedure update_dml(p_rec in out nocopy pqh_cer_shd.g_rec_type) is
49 --
50   l_proc  varchar2(72) := g_package||'update_dml';
51 --
52 Begin
53   hr_utility.set_location('Entering:'||l_proc, 5);
54   --
55   -- Increment the object version
56   --
57   p_rec.object_version_number := p_rec.object_version_number + 1;
58   --
59   -- Update the pqh_copy_entity_results Row
60   --
61   update pqh_copy_entity_results
62   set
63   copy_entity_txn_id                = p_rec.copy_entity_txn_id,
64   result_type_cd                    = p_rec.result_type_cd,
65   number_of_copies                  = p_rec.number_of_copies,
66   status                            = p_rec.status,
67   src_copy_entity_result_id         = p_rec.src_copy_entity_result_id,
68   information_category              = p_rec.information_category,
69   information1                      = p_rec.information1,
70   information2                      = p_rec.information2,
71   information3                      = p_rec.information3,
72   information4                      = p_rec.information4,
73   information5                      = p_rec.information5,
74   information6                      = p_rec.information6,
75   information7                      = p_rec.information7,
76   information8                      = p_rec.information8,
77   information9                      = p_rec.information9,
78   information10                     = p_rec.information10,
79   information11                     = p_rec.information11,
80   information12                     = p_rec.information12,
81   information13                     = p_rec.information13,
82   information14                     = p_rec.information14,
83   information15                     = p_rec.information15,
84   information16                     = p_rec.information16,
85   information17                     = p_rec.information17,
86   information18                     = p_rec.information18,
87   information19                     = p_rec.information19,
88   information20                     = p_rec.information20,
89   information21                     = p_rec.information21,
90   information22                     = p_rec.information22,
91   information23                     = p_rec.information23,
92   information24                     = p_rec.information24,
93   information25                     = p_rec.information25,
94   information26                     = p_rec.information26,
95   information27                     = p_rec.information27,
96   information28                     = p_rec.information28,
97   information29                     = p_rec.information29,
98   information30                     = p_rec.information30,
99   information31                     = p_rec.information31,
100   information32                     = p_rec.information32,
101   information33                     = p_rec.information33,
102   information34                     = p_rec.information34,
103   information35                     = p_rec.information35,
104   information36                     = p_rec.information36,
105   information37                     = p_rec.information37,
106   information38                     = p_rec.information38,
107   information39                     = p_rec.information39,
108   information40                     = p_rec.information40,
109   information41                     = p_rec.information41,
110   information42                     = p_rec.information42,
111   information43                     = p_rec.information43,
112   information44                     = p_rec.information44,
113   information45                     = p_rec.information45,
114   information46                     = p_rec.information46,
115   information47                     = p_rec.information47,
116   information48                     = p_rec.information48,
117   information49                     = p_rec.information49,
118   information50                     = p_rec.information50,
119   information51                     = p_rec.information51,
120   information52                     = p_rec.information52,
121   information53                     = p_rec.information53,
122   information54                     = p_rec.information54,
123   information55                     = p_rec.information55,
124   information56                     = p_rec.information56,
125   information57                     = p_rec.information57,
126   information58                     = p_rec.information58,
127   information59                     = p_rec.information59,
128   information60                     = p_rec.information60,
129   information61                     = p_rec.information61,
130   information62                     = p_rec.information62,
131   information63                     = p_rec.information63,
132   information64                     = p_rec.information64,
133   information65                     = p_rec.information65,
134   information66                     = p_rec.information66,
135   information67                     = p_rec.information67,
136   information68                     = p_rec.information68,
137   information69                     = p_rec.information69,
138   information70                     = p_rec.information70,
139   information71                     = p_rec.information71,
140   information72                     = p_rec.information72,
141   information73                     = p_rec.information73,
142   information74                     = p_rec.information74,
143   information75                     = p_rec.information75,
144   information76                     = p_rec.information76,
145   information77                     = p_rec.information77,
146   information78                     = p_rec.information78,
147   information79                     = p_rec.information79,
148   information80                     = p_rec.information80,
149   information81                     = p_rec.information81,
150   information82                     = p_rec.information82,
151   information83                     = p_rec.information83,
152   information84                     = p_rec.information84,
153   information85                     = p_rec.information85,
154   information86                     = p_rec.information86,
155   information87                     = p_rec.information87,
156   information88                     = p_rec.information88,
157   information89                     = p_rec.information89,
158   information90                     = p_rec.information90,
159   information91                     = p_rec.information91,
160   information92                     = p_rec.information92,
161   information93                     = p_rec.information93,
162   information94                     = p_rec.information94,
163   information95                     = p_rec.information95,
164   information96                     = p_rec.information96,
165   information97                     = p_rec.information97,
166   information98                     = p_rec.information98,
167   information99                     = p_rec.information99,
168   information100                    = p_rec.information100,
169   information101                    = p_rec.information101,
170   information102                    = p_rec.information102 ,
171   information103                    = p_rec.information103,
172   information104                    = p_rec.information104,
173   information105                    = p_rec.information105,
174   information106                    = p_rec.information106,
175   information107                    = p_rec.information107,
176   information108                    = p_rec.information108,
177   information109                    = p_rec.information109,
178   information110                    = p_rec.information110,
179   information111                    = p_rec.information111,
180   information112                    = p_rec.information112 ,
181   information113                    = p_rec.information113,
182   information114                    = p_rec.information114,
183   information115                    = p_rec.information115,
184   information116                    = p_rec.information116,
185   information117                    = p_rec.information117,
186   information118                    = p_rec.information118,
187   information119                    = p_rec.information119,
188   information120                    = p_rec.information120,
189   information121                    = p_rec.information121,
190   information122                    = p_rec.information122 ,
191   information123                    = p_rec.information123,
192   information124                    = p_rec.information124,
193   information125                    = p_rec.information125,
194   information126                    = p_rec.information126,
195   information127                    = p_rec.information127,
196   information128                    = p_rec.information128,
197   information129                    = p_rec.information129,
198   information130                    = p_rec.information130,
199   information131                    = p_rec.information131,
200   information132                    = p_rec.information132 ,
201   information133                    = p_rec.information133,
202   information134                    = p_rec.information134,
203   information135                    = p_rec.information135,
204   information136                    = p_rec.information136,
205   information137                    = p_rec.information137,
206   information138                    = p_rec.information138,
207   information139                    = p_rec.information139,
208   information140                    = p_rec.information140,
209   information141                    = p_rec.information141,
210   information142                    = p_rec.information142 ,
211   information143                    = p_rec.information143,
212   information144                    = p_rec.information144,
213   information145                    = p_rec.information145,
214   information146                    = p_rec.information146,
215   information147                    = p_rec.information147,
216   information148                    = p_rec.information148,
217   information149                    = p_rec.information149,
218   information150                    = p_rec.information150,
219   information151                    = p_rec.information151,
220   information152                    = p_rec.information152 ,
221   information153                    = p_rec.information153,
222   information154                    = p_rec.information154,
223   information155                    = p_rec.information155,
224   information156                    = p_rec.information156,
225   information157                    = p_rec.information157,
226   information158                    = p_rec.information158,
227   information159                    = p_rec.information159,
228   information160                    = p_rec.information160,
229   information161                    = p_rec.information161,
230   information162                    = p_rec.information162 ,
231   information163                    = p_rec.information163,
232   information164                    = p_rec.information164,
233   information165                    = p_rec.information165,
234   information166                    = p_rec.information166,
235   information167                    = p_rec.information167,
236   information168                    = p_rec.information168,
237   information169                    = p_rec.information169,
238   information170                    = p_rec.information170,
239   information171                    = p_rec.information171,
240   information172                    = p_rec.information172,
241   information173                    = p_rec.information173,
242   information174                    = p_rec.information174,
243   information175                    = p_rec.information175,
244   information176                    = p_rec.information176,
245   information177                    = p_rec.information177,
246   information178                    = p_rec.information178,
247   information179                    = p_rec.information179,
248   information180                    = p_rec.information180,
249   information181                    = p_rec.information181,
250   information182                    = p_rec.information182,
251   information183                    = p_rec.information183,
252   information184                    = p_rec.information184,
253   information185                    = p_rec.information185,
254   information186                    = p_rec.information186,
255   information187                    = p_rec.information187,
256   information188                    = p_rec.information188,
257   information189                    = p_rec.information189,
258   information190                    = p_rec.information190,
259   mirror_entity_result_id           = p_rec.mirror_entity_result_id,
260   mirror_src_entity_result_id       = p_rec.mirror_src_entity_result_id,
261   parent_entity_result_id           = p_rec.parent_entity_result_id,
262   table_route_id                    = p_rec.table_route_id,
263   long_attribute1                   = p_rec.long_attribute1,
264   object_version_number             = p_rec.object_version_number
265   where copy_entity_result_id = p_rec.copy_entity_result_id;
266   --
267   hr_utility.set_location(' Leaving:'||l_proc, 10);
268 --
269 Exception
270   When hr_api.check_integrity_violated Then
271     -- A check constraint has been violated
272     pqh_cer_shd.constraint_error
273       (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
274   When hr_api.parent_integrity_violated Then
275     -- Parent integrity has been violated
276     pqh_cer_shd.constraint_error
277       (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
278   When hr_api.unique_integrity_violated Then
279     -- Unique integrity has been violated
280     pqh_cer_shd.constraint_error
281       (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
282   When Others Then
283     Raise;
284 End update_dml;
285 --
286 -- ----------------------------------------------------------------------------
287 -- |------------------------------< pre_update >------------------------------|
288 -- ----------------------------------------------------------------------------
289 -- {Start Of Comments}
290 --
291 -- Description:
292 --   This private procedure contains any processing which is required before
293 --   the update dml.
294 --
295 -- Prerequisites:
296 --   This is an internal procedure which is called from the upd procedure.
297 --
298 -- In Parameters:
299 --   A Pl/Sql record structre.
300 --
301 -- Post Success:
302 --   Processing continues.
303 --
304 -- Post Failure:
305 --   If an error has occurred, an error message and exception will be raised
306 --   but not handled.
307 --
308 -- Developer Implementation Notes:
309 --   Any pre-processing required before the update dml is issued should be
310 --   coded within this procedure. It is important to note that any 3rd party
311 --   maintenance should be reviewed before placing in this procedure.
312 --
313 -- Access Status:
314 --   Internal Row Handler Use Only.
315 --
316 -- {End Of Comments}
317 -- ----------------------------------------------------------------------------
318 Procedure pre_update(p_rec in pqh_cer_shd.g_rec_type) is
319 --
320   l_proc  varchar2(72) := g_package||'pre_update';
321 --
322 Begin
323   hr_utility.set_location('Entering:'||l_proc, 5);
324   --
325   hr_utility.set_location(' Leaving:'||l_proc, 10);
326 End pre_update;
327 --
328 -- ----------------------------------------------------------------------------
329 -- |-----------------------------< post_update >------------------------------|
330 -- ----------------------------------------------------------------------------
331 -- {Start Of Comments}
332 --
333 -- Description:
334 --   This private procedure contains any processing which is required after the
335 --   update dml.
336 --
337 -- Prerequisites:
338 --   This is an internal procedure which is called from the upd procedure.
339 --
340 -- In Parameters:
341 --   A Pl/Sql record structre.
342 --
343 -- Post Success:
344 --   Processing continues.
345 --
346 -- Post Failure:
347 --   If an error has occurred, an error message and exception will be raised
348 --   but not handled.
349 --
350 -- Developer Implementation Notes:
351 --   Any post-processing required after the update dml is issued should be
352 --   coded within this procedure. It is important to note that any 3rd party
353 --   maintenance should be reviewed before placing in this procedure.
354 --
355 -- Access Status:
356 --   Internal Row Handler Use Only.
357 --
358 -- {End Of Comments}
359 -- ----------------------------------------------------------------------------
360 Procedure post_update(
361 p_effective_date in date,p_rec in pqh_cer_shd.g_rec_type) is
362 --
363   l_proc  varchar2(72) := g_package||'post_update';
364 --
365 Begin
366   hr_utility.set_location('Entering:'||l_proc, 5);
367 --
368   --
369   -- Start of API User Hook for post_update.
370   --
371   begin
372     --
373     pqh_cer_rku.after_update
374       (
375   p_copy_entity_result_id         =>p_rec.copy_entity_result_id
376  ,p_copy_entity_txn_id            =>p_rec.copy_entity_txn_id
377  ,p_result_type_cd                =>p_rec.result_type_cd
378  ,p_number_of_copies              =>p_rec.number_of_copies
379  ,p_status                        =>p_rec.status
380  ,p_src_copy_entity_result_id     =>p_rec.src_copy_entity_result_id
381  ,p_information_category          =>p_rec.information_category
382  ,p_information1                  =>p_rec.information1
383  ,p_information2                  =>p_rec.information2
384  ,p_information3                  =>p_rec.information3
385  ,p_information4                  =>p_rec.information4
386  ,p_information5                  =>p_rec.information5
387  ,p_information6                  =>p_rec.information6
388  ,p_information7                  =>p_rec.information7
389  ,p_information8                  =>p_rec.information8
390  ,p_information9                  =>p_rec.information9
391  ,p_information10                 =>p_rec.information10
392  ,p_information11                 =>p_rec.information11
393  ,p_information12                 =>p_rec.information12
394  ,p_information13                 =>p_rec.information13
395  ,p_information14                 =>p_rec.information14
396  ,p_information15                 =>p_rec.information15
397  ,p_information16                 =>p_rec.information16
398  ,p_information17                 =>p_rec.information17
399  ,p_information18                 =>p_rec.information18
400  ,p_information19                 =>p_rec.information19
401  ,p_information20                 =>p_rec.information20
402  ,p_information21                 =>p_rec.information21
403  ,p_information22                 =>p_rec.information22
404  ,p_information23                 =>p_rec.information23
405  ,p_information24                 =>p_rec.information24
406  ,p_information25                 =>p_rec.information25
407  ,p_information26                 =>p_rec.information26
408  ,p_information27                 =>p_rec.information27
409  ,p_information28                 =>p_rec.information28
410  ,p_information29                 =>p_rec.information29
411  ,p_information30                 =>p_rec.information30
412  ,p_information31                 =>p_rec.information31
413  ,p_information32                 =>p_rec.information32
414  ,p_information33                 =>p_rec.information33
415  ,p_information34                 =>p_rec.information34
416  ,p_information35                 =>p_rec.information35
417  ,p_information36                 =>p_rec.information36
418  ,p_information37                 =>p_rec.information37
419  ,p_information38                 =>p_rec.information38
420  ,p_information39                 =>p_rec.information39
421  ,p_information40                 =>p_rec.information40
422  ,p_information41                 =>p_rec.information41
423  ,p_information42                 =>p_rec.information42
424  ,p_information43                 =>p_rec.information43
425  ,p_information44                 =>p_rec.information44
426  ,p_information45                 =>p_rec.information45
427  ,p_information46                 =>p_rec.information46
428  ,p_information47                 =>p_rec.information47
429  ,p_information48                 =>p_rec.information48
430  ,p_information49                 =>p_rec.information49
431  ,p_information50                 =>p_rec.information50
432  ,p_information51                 =>p_rec.information51
433  ,p_information52                 =>p_rec.information52
434  ,p_information53                 =>p_rec.information53
435  ,p_information54                 =>p_rec.information54
436  ,p_information55                 =>p_rec.information55
437  ,p_information56                 =>p_rec.information56
438  ,p_information57                 =>p_rec.information57
439  ,p_information58                 =>p_rec.information58
440  ,p_information59                 =>p_rec.information59
441  ,p_information60                 =>p_rec.information60
442  ,p_information61                 =>p_rec.information61
443  ,p_information62                 =>p_rec.information62
444  ,p_information63                 =>p_rec.information63
445  ,p_information64                 =>p_rec.information64
446  ,p_information65                 =>p_rec.information65
447  ,p_information66                 =>p_rec.information66
448  ,p_information67                 =>p_rec.information67
449  ,p_information68                 =>p_rec.information68
450  ,p_information69                 =>p_rec.information69
451  ,p_information70                 =>p_rec.information70
452  ,p_information71                 =>p_rec.information71
453  ,p_information72                 =>p_rec.information72
454  ,p_information73                 =>p_rec.information73
455  ,p_information74                 =>p_rec.information74
456  ,p_information75                 =>p_rec.information75
457  ,p_information76                 =>p_rec.information76
458  ,p_information77                 =>p_rec.information77
459  ,p_information78                 =>p_rec.information78
460  ,p_information79                 =>p_rec.information79
461  ,p_information80                 =>p_rec.information80
462  ,p_information81                 =>p_rec.information81
463  ,p_information82                 =>p_rec.information82
464  ,p_information83                 =>p_rec.information83
465  ,p_information84                 =>p_rec.information84
466  ,p_information85                 =>p_rec.information85
467  ,p_information86                 =>p_rec.information86
468  ,p_information87                 =>p_rec.information87
469  ,p_information88                 =>p_rec.information88
470  ,p_information89                 =>p_rec.information89
471  ,p_information90                 =>p_rec.information90
472  ,p_information91                 =>p_rec.information91
473  ,p_information92                 =>p_rec.information92
474  ,p_information93                 =>p_rec.information93
475  ,p_information94                 =>p_rec.information94
476  ,p_information95                 =>p_rec.information95
477  ,p_information96                 =>p_rec.information96
478  ,p_information97                 =>p_rec.information97
479  ,p_information98                 =>p_rec.information98
480  ,p_information99                 =>p_rec.information99
481  ,p_information100                =>p_rec.information100
482  ,p_information101                =>p_rec.information101
483  ,p_information102                =>p_rec.information102
484  ,p_information103                =>p_rec.information103
485  ,p_information104                =>p_rec.information104
486  ,p_information105                =>p_rec.information105
487  ,p_information106                =>p_rec.information106
488  ,p_information107                =>p_rec.information107
489  ,p_information108                =>p_rec.information108
490  ,p_information109                =>p_rec.information109
491  ,p_information110                =>p_rec.information110
492  ,p_information111                =>p_rec.information111
493  ,p_information112                =>p_rec.information112
494  ,p_information113                =>p_rec.information113
495  ,p_information114                =>p_rec.information114
496  ,p_information115                =>p_rec.information115
497  ,p_information116                =>p_rec.information116
498  ,p_information117                =>p_rec.information117
499  ,p_information118                =>p_rec.information118
500  ,p_information119                =>p_rec.information119
501  ,p_information120                =>p_rec.information120
502  ,p_information121                =>p_rec.information121
503  ,p_information122                =>p_rec.information122
504  ,p_information123                =>p_rec.information123
505  ,p_information124                =>p_rec.information124
506  ,p_information125                =>p_rec.information125
507  ,p_information126                =>p_rec.information126
508  ,p_information127                =>p_rec.information127
509  ,p_information128                =>p_rec.information128
510  ,p_information129                =>p_rec.information129
511  ,p_information130                =>p_rec.information130
512  ,p_information131                =>p_rec.information131
513  ,p_information132                =>p_rec.information132
514  ,p_information133                =>p_rec.information133
515  ,p_information134                =>p_rec.information134
516  ,p_information135                =>p_rec.information135
517  ,p_information136                =>p_rec.information136
518  ,p_information137                =>p_rec.information137
519  ,p_information138                =>p_rec.information138
520  ,p_information139                =>p_rec.information139
521  ,p_information140                =>p_rec.information140
522  ,p_information141                =>p_rec.information141
523  ,p_information142                =>p_rec.information142
524  ,p_information143                =>p_rec.information143
525  ,p_information144                =>p_rec.information144
526  ,p_information145                =>p_rec.information145
527  ,p_information146                =>p_rec.information146
528  ,p_information147                =>p_rec.information147
529  ,p_information148                =>p_rec.information148
530  ,p_information149                =>p_rec.information149
531  ,p_information150                =>p_rec.information150
532  ,p_information151                =>p_rec.information151
533  ,p_information152                =>p_rec.information152
534  ,p_information153                =>p_rec.information153
535  ,p_information154                =>p_rec.information154
536  ,p_information155                =>p_rec.information155
537  ,p_information156                =>p_rec.information156
538  ,p_information157                =>p_rec.information157
539  ,p_information158                =>p_rec.information158
540  ,p_information159                =>p_rec.information159
541  ,p_information160                =>p_rec.information160
542  ,p_information161                =>p_rec.information161
543  ,p_information162                =>p_rec.information162
544  ,p_information163                =>p_rec.information163
545  ,p_information164                =>p_rec.information164
546  ,p_information165                =>p_rec.information165
547  ,p_information166                =>p_rec.information166
548  ,p_information167                =>p_rec.information167
549  ,p_information168                =>p_rec.information168
550  ,p_information169                =>p_rec.information169
551  ,p_information170                =>p_rec.information170
552  ,p_information171                =>p_rec.information171
553  ,p_information172                =>p_rec.information172
554  ,p_information173                =>p_rec.information173
555  ,p_information174                =>p_rec.information174
556  ,p_information175                =>p_rec.information175
557  ,p_information176                =>p_rec.information176
558  ,p_information177                =>p_rec.information177
559  ,p_information178                =>p_rec.information178
560  ,p_information179                =>p_rec.information179
561  ,p_information180                =>p_rec.information180
562  ,p_information181                =>p_rec.information181
563  ,p_information182                =>p_rec.information182
564  ,p_information183                =>p_rec.information183
565  ,p_information184                =>p_rec.information184
566  ,p_information185                =>p_rec.information185
567  ,p_information186                =>p_rec.information186
568  ,p_information187                =>p_rec.information187
569  ,p_information188                =>p_rec.information188
570  ,p_information189                =>p_rec.information189
571  ,p_information190                =>p_rec.information190
572  ,p_mirror_entity_result_id       =>p_rec.mirror_entity_result_id
573  ,p_mirror_src_entity_result_id   =>p_rec.mirror_src_entity_result_id
574  ,p_parent_entity_result_id       =>p_rec.parent_entity_result_id
575  ,p_table_route_id                =>p_rec.table_route_id
576  ,p_long_attribute1               =>p_rec.long_attribute1
577  ,p_object_version_number         =>p_rec.object_version_number
578  ,p_effective_date                =>p_effective_date
579  ,p_copy_entity_txn_id_o          =>pqh_cer_shd.g_old_rec.copy_entity_txn_id
580  ,p_result_type_cd_o              =>pqh_cer_shd.g_old_rec.result_type_cd
581  ,p_number_of_copies_o            =>pqh_cer_shd.g_old_rec.number_of_copies
582  ,p_status_o                      =>pqh_cer_shd.g_old_rec.status
583  ,p_src_copy_entity_result_id_o   =>pqh_cer_shd.g_old_rec.src_copy_entity_result_id
584  ,p_information_category_o        =>pqh_cer_shd.g_old_rec.information_category
585  ,p_information1_o                =>pqh_cer_shd.g_old_rec.information1
586  ,p_information2_o                =>pqh_cer_shd.g_old_rec.information2
587  ,p_information3_o                =>pqh_cer_shd.g_old_rec.information3
588  ,p_information4_o                =>pqh_cer_shd.g_old_rec.information4
589  ,p_information5_o                =>pqh_cer_shd.g_old_rec.information5
590  ,p_information6_o                =>pqh_cer_shd.g_old_rec.information6
591  ,p_information7_o                =>pqh_cer_shd.g_old_rec.information7
592  ,p_information8_o                =>pqh_cer_shd.g_old_rec.information8
593  ,p_information9_o                =>pqh_cer_shd.g_old_rec.information9
594  ,p_information10_o               =>pqh_cer_shd.g_old_rec.information10
595  ,p_information11_o               =>pqh_cer_shd.g_old_rec.information11
596  ,p_information12_o               =>pqh_cer_shd.g_old_rec.information12
597  ,p_information13_o               =>pqh_cer_shd.g_old_rec.information13
598  ,p_information14_o               =>pqh_cer_shd.g_old_rec.information14
599  ,p_information15_o               =>pqh_cer_shd.g_old_rec.information15
600  ,p_information16_o               =>pqh_cer_shd.g_old_rec.information16
601  ,p_information17_o               =>pqh_cer_shd.g_old_rec.information17
602  ,p_information18_o               =>pqh_cer_shd.g_old_rec.information18
603  ,p_information19_o               =>pqh_cer_shd.g_old_rec.information19
604  ,p_information20_o               =>pqh_cer_shd.g_old_rec.information20
605  ,p_information21_o               =>pqh_cer_shd.g_old_rec.information21
606  ,p_information22_o               =>pqh_cer_shd.g_old_rec.information22
607  ,p_information23_o               =>pqh_cer_shd.g_old_rec.information23
608  ,p_information24_o               =>pqh_cer_shd.g_old_rec.information24
609  ,p_information25_o               =>pqh_cer_shd.g_old_rec.information25
610  ,p_information26_o               =>pqh_cer_shd.g_old_rec.information26
611  ,p_information27_o               =>pqh_cer_shd.g_old_rec.information27
612  ,p_information28_o               =>pqh_cer_shd.g_old_rec.information28
613  ,p_information29_o               =>pqh_cer_shd.g_old_rec.information29
614  ,p_information30_o               =>pqh_cer_shd.g_old_rec.information30
615  ,p_information31_o               =>pqh_cer_shd.g_old_rec.information31
616  ,p_information32_o               =>pqh_cer_shd.g_old_rec.information32
617  ,p_information33_o               =>pqh_cer_shd.g_old_rec.information33
618  ,p_information34_o               =>pqh_cer_shd.g_old_rec.information34
619  ,p_information35_o               =>pqh_cer_shd.g_old_rec.information35
620  ,p_information36_o               =>pqh_cer_shd.g_old_rec.information36
621  ,p_information37_o               =>pqh_cer_shd.g_old_rec.information37
622  ,p_information38_o               =>pqh_cer_shd.g_old_rec.information38
623  ,p_information39_o               =>pqh_cer_shd.g_old_rec.information39
624  ,p_information40_o               =>pqh_cer_shd.g_old_rec.information40
625  ,p_information41_o               =>pqh_cer_shd.g_old_rec.information41
626  ,p_information42_o               =>pqh_cer_shd.g_old_rec.information42
627  ,p_information43_o               =>pqh_cer_shd.g_old_rec.information43
628  ,p_information44_o               =>pqh_cer_shd.g_old_rec.information44
629  ,p_information45_o               =>pqh_cer_shd.g_old_rec.information45
630  ,p_information46_o               =>pqh_cer_shd.g_old_rec.information46
631  ,p_information47_o               =>pqh_cer_shd.g_old_rec.information47
632  ,p_information48_o               =>pqh_cer_shd.g_old_rec.information48
633  ,p_information49_o               =>pqh_cer_shd.g_old_rec.information49
634  ,p_information50_o               =>pqh_cer_shd.g_old_rec.information50
635  ,p_information51_o               =>pqh_cer_shd.g_old_rec.information51
636  ,p_information52_o               =>pqh_cer_shd.g_old_rec.information52
637  ,p_information53_o               =>pqh_cer_shd.g_old_rec.information53
638  ,p_information54_o               =>pqh_cer_shd.g_old_rec.information54
639  ,p_information55_o               =>pqh_cer_shd.g_old_rec.information55
640  ,p_information56_o               =>pqh_cer_shd.g_old_rec.information56
641  ,p_information57_o               =>pqh_cer_shd.g_old_rec.information57
642  ,p_information58_o               =>pqh_cer_shd.g_old_rec.information58
643  ,p_information59_o               =>pqh_cer_shd.g_old_rec.information59
644  ,p_information60_o               =>pqh_cer_shd.g_old_rec.information60
645  ,p_information61_o               =>pqh_cer_shd.g_old_rec.information61
646  ,p_information62_o               =>pqh_cer_shd.g_old_rec.information62
647  ,p_information63_o               =>pqh_cer_shd.g_old_rec.information63
648  ,p_information64_o               =>pqh_cer_shd.g_old_rec.information64
649  ,p_information65_o               =>pqh_cer_shd.g_old_rec.information65
650  ,p_information66_o               =>pqh_cer_shd.g_old_rec.information66
651  ,p_information67_o               =>pqh_cer_shd.g_old_rec.information67
652  ,p_information68_o               =>pqh_cer_shd.g_old_rec.information68
653  ,p_information69_o               =>pqh_cer_shd.g_old_rec.information69
654  ,p_information70_o               =>pqh_cer_shd.g_old_rec.information70
655  ,p_information71_o               =>pqh_cer_shd.g_old_rec.information71
656  ,p_information72_o               =>pqh_cer_shd.g_old_rec.information72
657  ,p_information73_o               =>pqh_cer_shd.g_old_rec.information73
658  ,p_information74_o               =>pqh_cer_shd.g_old_rec.information74
659  ,p_information75_o               =>pqh_cer_shd.g_old_rec.information75
660  ,p_information76_o               =>pqh_cer_shd.g_old_rec.information76
661  ,p_information77_o               =>pqh_cer_shd.g_old_rec.information77
662  ,p_information78_o               =>pqh_cer_shd.g_old_rec.information78
663  ,p_information79_o               =>pqh_cer_shd.g_old_rec.information79
664  ,p_information80_o               =>pqh_cer_shd.g_old_rec.information80
665  ,p_information81_o               =>pqh_cer_shd.g_old_rec.information81
666  ,p_information82_o               =>pqh_cer_shd.g_old_rec.information82
667  ,p_information83_o               =>pqh_cer_shd.g_old_rec.information83
668  ,p_information84_o               =>pqh_cer_shd.g_old_rec.information84
669  ,p_information85_o               =>pqh_cer_shd.g_old_rec.information85
670  ,p_information86_o               =>pqh_cer_shd.g_old_rec.information86
671  ,p_information87_o               =>pqh_cer_shd.g_old_rec.information87
672  ,p_information88_o               =>pqh_cer_shd.g_old_rec.information88
673  ,p_information89_o               =>pqh_cer_shd.g_old_rec.information89
674  ,p_information90_o               =>pqh_cer_shd.g_old_rec.information90
675  ,p_information91_o               =>pqh_cer_shd.g_old_rec.information91
676  ,p_information92_o               =>pqh_cer_shd.g_old_rec.information92
677  ,p_information93_o               =>pqh_cer_shd.g_old_rec.information93
678  ,p_information94_o               =>pqh_cer_shd.g_old_rec.information94
679  ,p_information95_o               =>pqh_cer_shd.g_old_rec.information95
680  ,p_information96_o               =>pqh_cer_shd.g_old_rec.information96
681  ,p_information97_o               =>pqh_cer_shd.g_old_rec.information97
682  ,p_information98_o               =>pqh_cer_shd.g_old_rec.information98
683  ,p_information99_o               =>pqh_cer_shd.g_old_rec.information99
684  ,p_information100_o               =>pqh_cer_shd.g_old_rec.information100
685  ,p_information101_o               =>pqh_cer_shd.g_old_rec.information101
686  ,p_information102_o               =>pqh_cer_shd.g_old_rec.information102
687  ,p_information103_o               =>pqh_cer_shd.g_old_rec.information103
688  ,p_information104_o               =>pqh_cer_shd.g_old_rec.information104
689  ,p_information105_o               =>pqh_cer_shd.g_old_rec.information105
690  ,p_information106_o               =>pqh_cer_shd.g_old_rec.information106
691  ,p_information107_o               =>pqh_cer_shd.g_old_rec.information107
692  ,p_information108_o               =>pqh_cer_shd.g_old_rec.information108
693  ,p_information109_o               =>pqh_cer_shd.g_old_rec.information109
694  ,p_information110_o               =>pqh_cer_shd.g_old_rec.information110
695  ,p_information111_o               =>pqh_cer_shd.g_old_rec.information111
696  ,p_information112_o               =>pqh_cer_shd.g_old_rec.information112
697  ,p_information113_o               =>pqh_cer_shd.g_old_rec.information113
698  ,p_information114_o               =>pqh_cer_shd.g_old_rec.information114
699  ,p_information115_o               =>pqh_cer_shd.g_old_rec.information115
700  ,p_information116_o               =>pqh_cer_shd.g_old_rec.information116
701  ,p_information117_o               =>pqh_cer_shd.g_old_rec.information117
702  ,p_information118_o               =>pqh_cer_shd.g_old_rec.information118
703  ,p_information119_o               =>pqh_cer_shd.g_old_rec.information119
704  ,p_information120_o               =>pqh_cer_shd.g_old_rec.information120
705  ,p_information121_o               =>pqh_cer_shd.g_old_rec.information121
706  ,p_information122_o               =>pqh_cer_shd.g_old_rec.information122
707  ,p_information123_o               =>pqh_cer_shd.g_old_rec.information123
708  ,p_information124_o               =>pqh_cer_shd.g_old_rec.information124
709  ,p_information125_o               =>pqh_cer_shd.g_old_rec.information125
710  ,p_information126_o               =>pqh_cer_shd.g_old_rec.information126
711  ,p_information127_o               =>pqh_cer_shd.g_old_rec.information127
712  ,p_information128_o               =>pqh_cer_shd.g_old_rec.information128
713  ,p_information129_o               =>pqh_cer_shd.g_old_rec.information129
714  ,p_information130_o               =>pqh_cer_shd.g_old_rec.information130
715  ,p_information131_o               =>pqh_cer_shd.g_old_rec.information131
716  ,p_information132_o               =>pqh_cer_shd.g_old_rec.information132
717  ,p_information133_o               =>pqh_cer_shd.g_old_rec.information133
718  ,p_information134_o               =>pqh_cer_shd.g_old_rec.information134
719  ,p_information135_o               =>pqh_cer_shd.g_old_rec.information135
720  ,p_information136_o               =>pqh_cer_shd.g_old_rec.information136
721  ,p_information137_o               =>pqh_cer_shd.g_old_rec.information137
722  ,p_information138_o               =>pqh_cer_shd.g_old_rec.information138
723  ,p_information139_o               =>pqh_cer_shd.g_old_rec.information139
724  ,p_information140_o               =>pqh_cer_shd.g_old_rec.information140
725  ,p_information141_o               =>pqh_cer_shd.g_old_rec.information141
726  ,p_information142_o               =>pqh_cer_shd.g_old_rec.information142
727  ,p_information143_o               =>pqh_cer_shd.g_old_rec.information143
728  ,p_information144_o               =>pqh_cer_shd.g_old_rec.information144
729  ,p_information145_o               =>pqh_cer_shd.g_old_rec.information145
730  ,p_information146_o               =>pqh_cer_shd.g_old_rec.information146
731  ,p_information147_o               =>pqh_cer_shd.g_old_rec.information147
732  ,p_information148_o               =>pqh_cer_shd.g_old_rec.information148
733  ,p_information149_o               =>pqh_cer_shd.g_old_rec.information149
734  ,p_information150_o               =>pqh_cer_shd.g_old_rec.information150
735  ,p_information151_o               =>pqh_cer_shd.g_old_rec.information151
736  ,p_information152_o               =>pqh_cer_shd.g_old_rec.information152
737  ,p_information153_o               =>pqh_cer_shd.g_old_rec.information153
738  ,p_information154_o               =>pqh_cer_shd.g_old_rec.information154
739  ,p_information155_o               =>pqh_cer_shd.g_old_rec.information155
740  ,p_information156_o               =>pqh_cer_shd.g_old_rec.information156
741  ,p_information157_o               =>pqh_cer_shd.g_old_rec.information157
742  ,p_information158_o               =>pqh_cer_shd.g_old_rec.information158
743  ,p_information159_o               =>pqh_cer_shd.g_old_rec.information159
744  ,p_information160_o               =>pqh_cer_shd.g_old_rec.information160
745  ,p_information161_o               =>pqh_cer_shd.g_old_rec.information161
746  ,p_information162_o               =>pqh_cer_shd.g_old_rec.information162
747  ,p_information163_o               =>pqh_cer_shd.g_old_rec.information163
748  ,p_information164_o               =>pqh_cer_shd.g_old_rec.information164
749  ,p_information165_o               =>pqh_cer_shd.g_old_rec.information165
750  ,p_information166_o               =>pqh_cer_shd.g_old_rec.information166
751  ,p_information167_o               =>pqh_cer_shd.g_old_rec.information167
752  ,p_information168_o               =>pqh_cer_shd.g_old_rec.information168
753  ,p_information169_o               =>pqh_cer_shd.g_old_rec.information169
754  ,p_information170_o               =>pqh_cer_shd.g_old_rec.information170
755  ,p_information171_o               =>pqh_cer_shd.g_old_rec.information171
756  ,p_information172_o               =>pqh_cer_shd.g_old_rec.information172
757  ,p_information173_o               =>pqh_cer_shd.g_old_rec.information173
758  ,p_information174_o               =>pqh_cer_shd.g_old_rec.information174
759  ,p_information175_o               =>pqh_cer_shd.g_old_rec.information175
760  ,p_information176_o               =>pqh_cer_shd.g_old_rec.information176
761  ,p_information177_o               =>pqh_cer_shd.g_old_rec.information177
762  ,p_information178_o               =>pqh_cer_shd.g_old_rec.information178
763  ,p_information179_o               =>pqh_cer_shd.g_old_rec.information179
764  ,p_information180_o               =>pqh_cer_shd.g_old_rec.information180
765  ,p_information181_o               =>pqh_cer_shd.g_old_rec.information181
766  ,p_information182_o               =>pqh_cer_shd.g_old_rec.information182
767  ,p_information183_o               =>pqh_cer_shd.g_old_rec.information183
768  ,p_information184_o               =>pqh_cer_shd.g_old_rec.information184
769  ,p_information185_o               =>pqh_cer_shd.g_old_rec.information185
770  ,p_information186_o               =>pqh_cer_shd.g_old_rec.information186
771  ,p_information187_o               =>pqh_cer_shd.g_old_rec.information187
772  ,p_information188_o               =>pqh_cer_shd.g_old_rec.information188
773  ,p_information189_o               =>pqh_cer_shd.g_old_rec.information189
774  ,p_information190_o               =>pqh_cer_shd.g_old_rec.information190
775  ,p_mirror_entity_result_id_o      =>pqh_cer_shd.g_old_rec.mirror_entity_result_id
776  ,p_mirror_src_entity_result_ido   =>pqh_cer_shd.g_old_rec.mirror_src_entity_result_id
777  ,p_parent_entity_result_id_o      =>pqh_cer_shd.g_old_rec.parent_entity_result_id
778  ,p_table_route_id_o               =>pqh_cer_shd.g_old_rec.table_route_id
779  ,p_long_attribute1_o              =>pqh_cer_shd.g_old_rec.long_attribute1
780  ,p_object_version_number_o        =>pqh_cer_shd.g_old_rec.object_version_number
781       );
782     --
783   exception
784     --
785     when hr_api.cannot_find_prog_unit then
786       --
787       hr_api.cannot_find_prog_unit_error
788         (p_module_name => 'pqh_copy_entity_results'
789         ,p_hook_type   => 'AU');
790       --
791   end;
792   --
793   -- End of API User Hook for post_update.
794   --
795   --
796   hr_utility.set_location(' Leaving:'||l_proc, 10);
797 End post_update;
798 --
799 -- ----------------------------------------------------------------------------
800 -- |-----------------------------< convert_defs >-----------------------------|
801 -- ----------------------------------------------------------------------------
802 -- {Start Of Comments}
803 --
804 -- Description:
805 --   The Convert_Defs procedure has one very important function:
806 --   It must return the record structure for the row with all system defaulted
807 --   values converted into its corresponding parameter value for update. When
808 --   we attempt to update a row through the Upd process , certain
809 --   parameters can be defaulted which enables flexibility in the calling of
810 --   the upd process (e.g. only attributes which need to be updated need to be
811 --   specified). For the upd process to determine which attributes
812 --   have NOT been specified we need to check if the parameter has a reserved
813 --   system default value. Therefore, for all parameters which have a
814 --   corresponding reserved system default mechanism specified we need to
815 --   check if a system default is being used. If a system default is being
816 --   used then we convert the defaulted value into its corresponding attribute
817 --   value held in the g_old_rec data structure.
818 --
819 -- Prerequisites:
820 --   This private function can only be called from the upd process.
821 --
822 -- In Parameters:
823 --   A Pl/Sql record structre.
824 --
825 -- Post Success:
826 --   The record structure will be returned with all system defaulted parameter
827 --   values converted into its current row attribute value.
828 --
829 -- Post Failure:
830 --   No direct error handling is required within this function. Any possible
831 --   errors within this procedure will be a PL/SQL value error due to conversion
832 --   of datatypes or data lengths.
833 --
834 -- Developer Implementation Notes:
835 --   None.
836 --
837 -- Access Status:
838 --   Internal Row Handler Use Only.
839 --
840 -- {End Of Comments}
841 -- ----------------------------------------------------------------------------
842 Procedure convert_defs(p_rec in out nocopy pqh_cer_shd.g_rec_type) is
843 --
844   l_proc  varchar2(72) := g_package||'convert_defs';
845 --
846 Begin
847   --
848   hr_utility.set_location('Entering:'||l_proc, 5);
849   --
850   -- We must now examine each argument value in the
851   -- p_rec plsql record structure
852   -- to see if a system default is being used. If a system default
853   -- is being used then we must set to the 'current' argument value.
854   --
855   If (p_rec.copy_entity_txn_id = hr_api.g_number) then
856     p_rec.copy_entity_txn_id :=
857     pqh_cer_shd.g_old_rec.copy_entity_txn_id;
858   End If;
859   If (p_rec.result_type_cd = hr_api.g_varchar2) then
860     p_rec.result_type_cd :=
861     pqh_cer_shd.g_old_rec.result_type_cd;
862   End If;
863   If (p_rec.number_of_copies = hr_api.g_number) then
864     p_rec.number_of_copies :=
865     pqh_cer_shd.g_old_rec.number_of_copies;
866   End If;
867   If (p_rec.status = hr_api.g_varchar2) then
868     p_rec.status :=
869     pqh_cer_shd.g_old_rec.status;
870   End If;
871   If (p_rec.src_copy_entity_result_id = hr_api.g_number) then
872     p_rec.src_copy_entity_result_id :=
873     pqh_cer_shd.g_old_rec.src_copy_entity_result_id;
874   End If;
875   If (p_rec.information_category = hr_api.g_varchar2) then
876     p_rec.information_category :=
877     pqh_cer_shd.g_old_rec.information_category;
878   End If;
879   If (p_rec.information1 = hr_api.g_varchar2) then
880     p_rec.information1 :=
881     pqh_cer_shd.g_old_rec.information1;
882   End If;
883   If (p_rec.information2 = hr_api.g_varchar2) then
884     p_rec.information2 :=
885     pqh_cer_shd.g_old_rec.information2;
886   End If;
887   If (p_rec.information3 = hr_api.g_varchar2) then
888     p_rec.information3 :=
889     pqh_cer_shd.g_old_rec.information3;
890   End If;
891   If (p_rec.information4 = hr_api.g_varchar2) then
892     p_rec.information4 :=
893     pqh_cer_shd.g_old_rec.information4;
894   End If;
895   If (p_rec.information5 = hr_api.g_varchar2) then
896     p_rec.information5 :=
897     pqh_cer_shd.g_old_rec.information5;
898   End If;
899   If (p_rec.information6 = hr_api.g_varchar2) then
900     p_rec.information6 :=
901     pqh_cer_shd.g_old_rec.information6;
902   End If;
903   If (p_rec.information7 = hr_api.g_varchar2) then
904     p_rec.information7 :=
905     pqh_cer_shd.g_old_rec.information7;
906   End If;
907   If (p_rec.information8 = hr_api.g_varchar2) then
908     p_rec.information8 :=
909     pqh_cer_shd.g_old_rec.information8;
910   End If;
911   If (p_rec.information9 = hr_api.g_varchar2) then
912     p_rec.information9 :=
913     pqh_cer_shd.g_old_rec.information9;
914   End If;
915   If (p_rec.information10 = hr_api.g_varchar2) then
916     p_rec.information10 :=
917     pqh_cer_shd.g_old_rec.information10;
918   End If;
919   If (p_rec.information11 = hr_api.g_varchar2) then
920     p_rec.information11 :=
921     pqh_cer_shd.g_old_rec.information11;
922   End If;
923   If (p_rec.information12 = hr_api.g_varchar2) then
924     p_rec.information12 :=
925     pqh_cer_shd.g_old_rec.information12;
926   End If;
927   If (p_rec.information13 = hr_api.g_varchar2) then
928     p_rec.information13 :=
929     pqh_cer_shd.g_old_rec.information13;
930   End If;
931   If (p_rec.information14 = hr_api.g_varchar2) then
932     p_rec.information14 :=
933     pqh_cer_shd.g_old_rec.information14;
934   End If;
935   If (p_rec.information15 = hr_api.g_varchar2) then
936     p_rec.information15 :=
937     pqh_cer_shd.g_old_rec.information15;
938   End If;
939   If (p_rec.information16 = hr_api.g_varchar2) then
940     p_rec.information16 :=
941     pqh_cer_shd.g_old_rec.information16;
942   End If;
943   If (p_rec.information17 = hr_api.g_varchar2) then
944     p_rec.information17 :=
945     pqh_cer_shd.g_old_rec.information17;
946   End If;
947   If (p_rec.information18 = hr_api.g_varchar2) then
948     p_rec.information18 :=
949     pqh_cer_shd.g_old_rec.information18;
950   End If;
951   If (p_rec.information19 = hr_api.g_varchar2) then
952     p_rec.information19 :=
953     pqh_cer_shd.g_old_rec.information19;
954   End If;
955   If (p_rec.information20 = hr_api.g_varchar2) then
956     p_rec.information20 :=
957     pqh_cer_shd.g_old_rec.information20;
958   End If;
959   If (p_rec.information21 = hr_api.g_varchar2) then
960     p_rec.information21 :=
961     pqh_cer_shd.g_old_rec.information21;
962   End If;
963   If (p_rec.information22 = hr_api.g_varchar2) then
964     p_rec.information22 :=
965     pqh_cer_shd.g_old_rec.information22;
966   End If;
967   If (p_rec.information23 = hr_api.g_varchar2) then
968     p_rec.information23 :=
969     pqh_cer_shd.g_old_rec.information23;
970   End If;
971   If (p_rec.information24 = hr_api.g_varchar2) then
972     p_rec.information24 :=
973     pqh_cer_shd.g_old_rec.information24;
974   End If;
975   If (p_rec.information25 = hr_api.g_varchar2) then
976     p_rec.information25 :=
977     pqh_cer_shd.g_old_rec.information25;
978   End If;
979   If (p_rec.information26 = hr_api.g_varchar2) then
980     p_rec.information26 :=
981     pqh_cer_shd.g_old_rec.information26;
982   End If;
983   If (p_rec.information27 = hr_api.g_varchar2) then
984     p_rec.information27 :=
985     pqh_cer_shd.g_old_rec.information27;
986   End If;
987   If (p_rec.information28 = hr_api.g_varchar2) then
988     p_rec.information28 :=
989     pqh_cer_shd.g_old_rec.information28;
990   End If;
991   If (p_rec.information29 = hr_api.g_varchar2) then
992     p_rec.information29 :=
993     pqh_cer_shd.g_old_rec.information29;
994   End If;
995   If (p_rec.information30 = hr_api.g_varchar2) then
996     p_rec.information30 :=
997     pqh_cer_shd.g_old_rec.information30;
998   End If;
999   If (p_rec.information31 = hr_api.g_varchar2) then
1000     p_rec.information31 :=
1001     pqh_cer_shd.g_old_rec.information31;
1002   End If;
1003   If (p_rec.information32 = hr_api.g_varchar2) then
1004     p_rec.information32 :=
1005     pqh_cer_shd.g_old_rec.information32;
1006   End If;
1007   If (p_rec.information33 = hr_api.g_varchar2) then
1008     p_rec.information33 :=
1009     pqh_cer_shd.g_old_rec.information33;
1010   End If;
1011   If (p_rec.information34 = hr_api.g_varchar2) then
1012     p_rec.information34 :=
1013     pqh_cer_shd.g_old_rec.information34;
1014   End If;
1015   If (p_rec.information35 = hr_api.g_varchar2) then
1016     p_rec.information35 :=
1017     pqh_cer_shd.g_old_rec.information35;
1018   End If;
1019   If (p_rec.information36 = hr_api.g_varchar2) then
1020     p_rec.information36 :=
1021     pqh_cer_shd.g_old_rec.information36;
1022   End If;
1023   If (p_rec.information37 = hr_api.g_varchar2) then
1024     p_rec.information37 :=
1025     pqh_cer_shd.g_old_rec.information37;
1026   End If;
1027   If (p_rec.information38 = hr_api.g_varchar2) then
1028     p_rec.information38 :=
1029     pqh_cer_shd.g_old_rec.information38;
1030   End If;
1031   If (p_rec.information39 = hr_api.g_varchar2) then
1032     p_rec.information39 :=
1033     pqh_cer_shd.g_old_rec.information39;
1034   End If;
1035   If (p_rec.information40 = hr_api.g_varchar2) then
1036     p_rec.information40 :=
1037     pqh_cer_shd.g_old_rec.information40;
1038   End If;
1039   If (p_rec.information41 = hr_api.g_varchar2) then
1040     p_rec.information41 :=
1041     pqh_cer_shd.g_old_rec.information41;
1042   End If;
1043   If (p_rec.information42 = hr_api.g_varchar2) then
1044     p_rec.information42 :=
1045     pqh_cer_shd.g_old_rec.information42;
1046   End If;
1047   If (p_rec.information43 = hr_api.g_varchar2) then
1048     p_rec.information43 :=
1049     pqh_cer_shd.g_old_rec.information43;
1050   End If;
1051   If (p_rec.information44 = hr_api.g_varchar2) then
1052     p_rec.information44 :=
1053     pqh_cer_shd.g_old_rec.information44;
1054   End If;
1055   If (p_rec.information45 = hr_api.g_varchar2) then
1056     p_rec.information45 :=
1057     pqh_cer_shd.g_old_rec.information45;
1058   End If;
1059   If (p_rec.information46 = hr_api.g_varchar2) then
1060     p_rec.information46 :=
1061     pqh_cer_shd.g_old_rec.information46;
1062   End If;
1063   If (p_rec.information47 = hr_api.g_varchar2) then
1064     p_rec.information47 :=
1065     pqh_cer_shd.g_old_rec.information47;
1066   End If;
1067   If (p_rec.information48 = hr_api.g_varchar2) then
1068     p_rec.information48 :=
1069     pqh_cer_shd.g_old_rec.information48;
1070   End If;
1071   If (p_rec.information49 = hr_api.g_varchar2) then
1072     p_rec.information49 :=
1073     pqh_cer_shd.g_old_rec.information49;
1074   End If;
1075   If (p_rec.information50 = hr_api.g_varchar2) then
1076     p_rec.information50 :=
1077     pqh_cer_shd.g_old_rec.information50;
1078   End If;
1079   If (p_rec.information51 = hr_api.g_varchar2) then
1080     p_rec.information51 :=
1081     pqh_cer_shd.g_old_rec.information51;
1082   End If;
1083   If (p_rec.information52 = hr_api.g_varchar2) then
1084     p_rec.information52 :=
1085     pqh_cer_shd.g_old_rec.information52;
1086   End If;
1087   If (p_rec.information53 = hr_api.g_varchar2) then
1088     p_rec.information53 :=
1089     pqh_cer_shd.g_old_rec.information53;
1090   End If;
1091   If (p_rec.information54 = hr_api.g_varchar2) then
1092     p_rec.information54 :=
1093     pqh_cer_shd.g_old_rec.information54;
1094   End If;
1095   If (p_rec.information55 = hr_api.g_varchar2) then
1096     p_rec.information55 :=
1097     pqh_cer_shd.g_old_rec.information55;
1098   End If;
1099   If (p_rec.information56 = hr_api.g_varchar2) then
1100     p_rec.information56 :=
1101     pqh_cer_shd.g_old_rec.information56;
1102   End If;
1103   If (p_rec.information57 = hr_api.g_varchar2) then
1104     p_rec.information57 :=
1105     pqh_cer_shd.g_old_rec.information57;
1106   End If;
1107   If (p_rec.information58 = hr_api.g_varchar2) then
1108     p_rec.information58 :=
1109     pqh_cer_shd.g_old_rec.information58;
1110   End If;
1111   If (p_rec.information59 = hr_api.g_varchar2) then
1112     p_rec.information59 :=
1113     pqh_cer_shd.g_old_rec.information59;
1114   End If;
1115   If (p_rec.information60 = hr_api.g_varchar2) then
1116     p_rec.information60 :=
1117     pqh_cer_shd.g_old_rec.information60;
1118   End If;
1119   If (p_rec.information61 = hr_api.g_varchar2) then
1120     p_rec.information61 :=
1121     pqh_cer_shd.g_old_rec.information61;
1122   End If;
1123   If (p_rec.information62 = hr_api.g_varchar2) then
1124     p_rec.information62 :=
1125     pqh_cer_shd.g_old_rec.information62;
1126   End If;
1127   If (p_rec.information63 = hr_api.g_varchar2) then
1128     p_rec.information63 :=
1129     pqh_cer_shd.g_old_rec.information63;
1130   End If;
1131   If (p_rec.information64 = hr_api.g_varchar2) then
1132     p_rec.information64 :=
1133     pqh_cer_shd.g_old_rec.information64;
1134   End If;
1135   If (p_rec.information65 = hr_api.g_varchar2) then
1136     p_rec.information65 :=
1137     pqh_cer_shd.g_old_rec.information65;
1138   End If;
1139   If (p_rec.information66 = hr_api.g_varchar2) then
1140     p_rec.information66 :=
1141     pqh_cer_shd.g_old_rec.information66;
1142   End If;
1143   If (p_rec.information67 = hr_api.g_varchar2) then
1144     p_rec.information67 :=
1145     pqh_cer_shd.g_old_rec.information67;
1146   End If;
1147   If (p_rec.information68 = hr_api.g_varchar2) then
1148     p_rec.information68 :=
1149     pqh_cer_shd.g_old_rec.information68;
1150   End If;
1151   If (p_rec.information69 = hr_api.g_varchar2) then
1152     p_rec.information69 :=
1153     pqh_cer_shd.g_old_rec.information69;
1154   End If;
1155   If (p_rec.information70 = hr_api.g_varchar2) then
1156     p_rec.information70 :=
1157     pqh_cer_shd.g_old_rec.information70;
1158   End If;
1159   If (p_rec.information71 = hr_api.g_varchar2) then
1160     p_rec.information71 :=
1161     pqh_cer_shd.g_old_rec.information71;
1162   End If;
1163   If (p_rec.information72 = hr_api.g_varchar2) then
1164     p_rec.information72 :=
1165     pqh_cer_shd.g_old_rec.information72;
1166   End If;
1167   If (p_rec.information73 = hr_api.g_varchar2) then
1168     p_rec.information73 :=
1169     pqh_cer_shd.g_old_rec.information73;
1170   End If;
1171   If (p_rec.information74 = hr_api.g_varchar2) then
1172     p_rec.information74 :=
1173     pqh_cer_shd.g_old_rec.information74;
1174   End If;
1175   If (p_rec.information75 = hr_api.g_varchar2) then
1176     p_rec.information75 :=
1177     pqh_cer_shd.g_old_rec.information75;
1178   End If;
1179   If (p_rec.information76 = hr_api.g_varchar2) then
1180     p_rec.information76 :=
1181     pqh_cer_shd.g_old_rec.information76;
1182   End If;
1183   If (p_rec.information77 = hr_api.g_varchar2) then
1184     p_rec.information77 :=
1185     pqh_cer_shd.g_old_rec.information77;
1186   End If;
1187   If (p_rec.information78 = hr_api.g_varchar2) then
1188     p_rec.information78 :=
1189     pqh_cer_shd.g_old_rec.information78;
1190   End If;
1191   If (p_rec.information79 = hr_api.g_varchar2) then
1192     p_rec.information79 :=
1193     pqh_cer_shd.g_old_rec.information79;
1194   End If;
1195   If (p_rec.information80 = hr_api.g_varchar2) then
1196     p_rec.information80 :=
1197     pqh_cer_shd.g_old_rec.information80;
1198   End If;
1199   If (p_rec.information81 = hr_api.g_varchar2) then
1200     p_rec.information81 :=
1201     pqh_cer_shd.g_old_rec.information81;
1202   End If;
1203   If (p_rec.information82 = hr_api.g_varchar2) then
1204     p_rec.information82 :=
1205     pqh_cer_shd.g_old_rec.information82;
1206   End If;
1207   If (p_rec.information83 = hr_api.g_varchar2) then
1208     p_rec.information83 :=
1209     pqh_cer_shd.g_old_rec.information83;
1210   End If;
1211   If (p_rec.information84 = hr_api.g_varchar2) then
1212     p_rec.information84 :=
1213     pqh_cer_shd.g_old_rec.information84;
1214   End If;
1215   If (p_rec.information85 = hr_api.g_varchar2) then
1216     p_rec.information85 :=
1217     pqh_cer_shd.g_old_rec.information85;
1218   End If;
1219   If (p_rec.information86 = hr_api.g_varchar2) then
1220     p_rec.information86 :=
1221     pqh_cer_shd.g_old_rec.information86;
1222   End If;
1223   If (p_rec.information87 = hr_api.g_varchar2) then
1224     p_rec.information87 :=
1225     pqh_cer_shd.g_old_rec.information87;
1226   End If;
1227   If (p_rec.information88 = hr_api.g_varchar2) then
1228     p_rec.information88 :=
1229     pqh_cer_shd.g_old_rec.information88;
1230   End If;
1231   If (p_rec.information89 = hr_api.g_varchar2) then
1232     p_rec.information89 :=
1233     pqh_cer_shd.g_old_rec.information89;
1234   End If;
1235   If (p_rec.information90 = hr_api.g_varchar2) then
1236     p_rec.information90 :=
1237     pqh_cer_shd.g_old_rec.information90;
1238   End If;
1239   If (p_rec.information91 = hr_api.g_varchar2) then
1240     p_rec.information91 :=
1241     pqh_cer_shd.g_old_rec.information91;
1242   End If;
1243   If (p_rec.information92 = hr_api.g_varchar2) then
1244     p_rec.information92 :=
1245     pqh_cer_shd.g_old_rec.information92;
1246   End If;
1247   If (p_rec.information93 = hr_api.g_varchar2) then
1248     p_rec.information93 :=
1249     pqh_cer_shd.g_old_rec.information93;
1250   End If;
1251   If (p_rec.information94 = hr_api.g_varchar2) then
1252     p_rec.information94 :=
1253     pqh_cer_shd.g_old_rec.information94;
1254   End If;
1255   If (p_rec.information95 = hr_api.g_varchar2) then
1256     p_rec.information95 :=
1257     pqh_cer_shd.g_old_rec.information95;
1258   End If;
1259   If (p_rec.information96 = hr_api.g_varchar2) then
1260     p_rec.information96 :=
1261     pqh_cer_shd.g_old_rec.information96;
1262   End If;
1263   If (p_rec.information97 = hr_api.g_varchar2) then
1264     p_rec.information97 :=
1265     pqh_cer_shd.g_old_rec.information97;
1266   End If;
1267   If (p_rec.information98 = hr_api.g_varchar2) then
1268     p_rec.information98 :=
1269     pqh_cer_shd.g_old_rec.information98;
1270   End If;
1271   If (p_rec.information99 = hr_api.g_varchar2) then
1272     p_rec.information99 :=
1273     pqh_cer_shd.g_old_rec.information99;
1274   End If;
1275   If (p_rec.information100 = hr_api.g_varchar2) then
1276     p_rec.information100 :=
1277     pqh_cer_shd.g_old_rec.information100;
1278   End If;
1279   If (p_rec.information101 = hr_api.g_varchar2) then
1280     p_rec.information101 :=
1281     pqh_cer_shd.g_old_rec.information101;
1282   End If;
1283   If (p_rec.information102 = hr_api.g_varchar2) then
1284     p_rec.information102 :=
1285     pqh_cer_shd.g_old_rec.information102;
1286   End If;
1287   If (p_rec.information103 = hr_api.g_varchar2) then
1288     p_rec.information103 :=
1289     pqh_cer_shd.g_old_rec.information103;
1290   End If;
1291   If (p_rec.information104 = hr_api.g_varchar2) then
1292     p_rec.information104 :=
1293     pqh_cer_shd.g_old_rec.information104;
1294   End If;
1295   If (p_rec.information105 = hr_api.g_varchar2) then
1296     p_rec.information105 :=
1297     pqh_cer_shd.g_old_rec.information105;
1298   End If;
1299   If (p_rec.information106 = hr_api.g_varchar2) then
1300     p_rec.information106 :=
1301     pqh_cer_shd.g_old_rec.information106;
1302   End If;
1303   If (p_rec.information107 = hr_api.g_varchar2) then
1304     p_rec.information107 :=
1305     pqh_cer_shd.g_old_rec.information107;
1306   End If;
1307   If (p_rec.information108 = hr_api.g_varchar2) then
1308     p_rec.information108 :=
1309     pqh_cer_shd.g_old_rec.information108;
1310   End If;
1311   If (p_rec.information109 = hr_api.g_varchar2) then
1312     p_rec.information109 :=
1313     pqh_cer_shd.g_old_rec.information109;
1314   End If;
1315   If (p_rec.information110 = hr_api.g_varchar2) then
1316     p_rec.information110 :=
1317     pqh_cer_shd.g_old_rec.information110;
1318   End If;
1319   If (p_rec.information111 = hr_api.g_varchar2) then
1320     p_rec.information111 :=
1321     pqh_cer_shd.g_old_rec.information111;
1322   End If;
1323   If (p_rec.information112 = hr_api.g_varchar2) then
1324     p_rec.information112 :=
1325     pqh_cer_shd.g_old_rec.information112;
1326   End If;
1327   If (p_rec.information113 = hr_api.g_varchar2) then
1328     p_rec.information113 :=
1329     pqh_cer_shd.g_old_rec.information113;
1330   End If;
1331   If (p_rec.information114 = hr_api.g_varchar2) then
1332     p_rec.information114 :=
1333     pqh_cer_shd.g_old_rec.information114;
1334   End If;
1335   If (p_rec.information115 = hr_api.g_varchar2) then
1336     p_rec.information115 :=
1337     pqh_cer_shd.g_old_rec.information115;
1338   End If;
1339   If (p_rec.information116 = hr_api.g_varchar2) then
1340     p_rec.information116 :=
1341     pqh_cer_shd.g_old_rec.information116;
1342   End If;
1343   If (p_rec.information117 = hr_api.g_varchar2) then
1344     p_rec.information117 :=
1345     pqh_cer_shd.g_old_rec.information117;
1346   End If;
1347   If (p_rec.information118 = hr_api.g_varchar2) then
1348     p_rec.information118 :=
1349     pqh_cer_shd.g_old_rec.information118;
1350   End If;
1351   If (p_rec.information119 = hr_api.g_varchar2) then
1352     p_rec.information119 :=
1353     pqh_cer_shd.g_old_rec.information119;
1354   End If;
1355   If (p_rec.information120 = hr_api.g_varchar2) then
1356     p_rec.information120 :=
1357     pqh_cer_shd.g_old_rec.information120;
1358   End If;
1359   If (p_rec.information121 = hr_api.g_varchar2) then
1360     p_rec.information121 :=
1361     pqh_cer_shd.g_old_rec.information121;
1362   End If;
1363   If (p_rec.information122 = hr_api.g_varchar2) then
1364     p_rec.information122 :=
1365     pqh_cer_shd.g_old_rec.information122;
1366   End If;
1367   If (p_rec.information123 = hr_api.g_varchar2) then
1368     p_rec.information123 :=
1369     pqh_cer_shd.g_old_rec.information123;
1370   End If;
1371   If (p_rec.information124 = hr_api.g_varchar2) then
1372     p_rec.information124 :=
1373     pqh_cer_shd.g_old_rec.information124;
1374   End If;
1375   If (p_rec.information125 = hr_api.g_varchar2) then
1376     p_rec.information125 :=
1377     pqh_cer_shd.g_old_rec.information125;
1378   End If;
1379   If (p_rec.information126 = hr_api.g_varchar2) then
1380     p_rec.information126 :=
1381     pqh_cer_shd.g_old_rec.information126;
1382   End If;
1383   If (p_rec.information127 = hr_api.g_varchar2) then
1384     p_rec.information127 :=
1385     pqh_cer_shd.g_old_rec.information127;
1386   End If;
1387   If (p_rec.information128 = hr_api.g_varchar2) then
1388     p_rec.information128 :=
1389     pqh_cer_shd.g_old_rec.information128;
1390   End If;
1391   If (p_rec.information129 = hr_api.g_varchar2) then
1392     p_rec.information129 :=
1393     pqh_cer_shd.g_old_rec.information129;
1394   End If;
1395   If (p_rec.information130 = hr_api.g_varchar2) then
1396     p_rec.information130 :=
1397     pqh_cer_shd.g_old_rec.information130;
1398   End If;
1399   If (p_rec.information131 = hr_api.g_varchar2) then
1400     p_rec.information131 :=
1401     pqh_cer_shd.g_old_rec.information131;
1402   End If;
1403   If (p_rec.information132 = hr_api.g_varchar2) then
1404     p_rec.information132 :=
1405     pqh_cer_shd.g_old_rec.information132;
1406   End If;
1407   If (p_rec.information133 = hr_api.g_varchar2) then
1408     p_rec.information133 :=
1409     pqh_cer_shd.g_old_rec.information133;
1410   End If;
1411   If (p_rec.information134 = hr_api.g_varchar2) then
1412     p_rec.information134 :=
1413     pqh_cer_shd.g_old_rec.information134;
1414   End If;
1415   If (p_rec.information135 = hr_api.g_varchar2) then
1416     p_rec.information135 :=
1417     pqh_cer_shd.g_old_rec.information135;
1418   End If;
1419   If (p_rec.information136 = hr_api.g_varchar2) then
1420     p_rec.information136 :=
1421     pqh_cer_shd.g_old_rec.information136;
1422   End If;
1423   If (p_rec.information137 = hr_api.g_varchar2) then
1424     p_rec.information137 :=
1425     pqh_cer_shd.g_old_rec.information137;
1426   End If;
1427   If (p_rec.information138 = hr_api.g_varchar2) then
1428     p_rec.information138 :=
1429     pqh_cer_shd.g_old_rec.information138;
1430   End If;
1431   If (p_rec.information139 = hr_api.g_varchar2) then
1432     p_rec.information139 :=
1433     pqh_cer_shd.g_old_rec.information139;
1434   End If;
1435   If (p_rec.information140 = hr_api.g_varchar2) then
1436     p_rec.information140 :=
1437     pqh_cer_shd.g_old_rec.information140;
1438   End If;
1439   If (p_rec.information141 = hr_api.g_varchar2) then
1440     p_rec.information141 :=
1441     pqh_cer_shd.g_old_rec.information141;
1442   End If;
1443   If (p_rec.information142 = hr_api.g_varchar2) then
1444     p_rec.information142 :=
1445     pqh_cer_shd.g_old_rec.information142;
1446   End If;
1447   If (p_rec.information143 = hr_api.g_varchar2) then
1448     p_rec.information143 :=
1449     pqh_cer_shd.g_old_rec.information143;
1450   End If;
1451   If (p_rec.information144 = hr_api.g_varchar2) then
1452     p_rec.information144 :=
1453     pqh_cer_shd.g_old_rec.information144;
1454   End If;
1455   If (p_rec.information145 = hr_api.g_varchar2) then
1456     p_rec.information145 :=
1457     pqh_cer_shd.g_old_rec.information145;
1458   End If;
1459   If (p_rec.information146 = hr_api.g_varchar2) then
1460     p_rec.information146 :=
1461     pqh_cer_shd.g_old_rec.information146;
1462   End If;
1463   If (p_rec.information147 = hr_api.g_varchar2) then
1464     p_rec.information147 :=
1465     pqh_cer_shd.g_old_rec.information147;
1466   End If;
1467   If (p_rec.information148 = hr_api.g_varchar2) then
1468     p_rec.information148 :=
1469     pqh_cer_shd.g_old_rec.information148;
1470   End If;
1471   If (p_rec.information149 = hr_api.g_varchar2) then
1472     p_rec.information149 :=
1473     pqh_cer_shd.g_old_rec.information149;
1474   End If;
1475   If (p_rec.information150 = hr_api.g_varchar2) then
1476     p_rec.information150 :=
1477     pqh_cer_shd.g_old_rec.information150;
1478   End If;
1479   If (p_rec.information151 = hr_api.g_varchar2) then
1480     p_rec.information151 :=
1481     pqh_cer_shd.g_old_rec.information151;
1482   End If;
1483   If (p_rec.information152 = hr_api.g_varchar2) then
1484     p_rec.information152 :=
1485     pqh_cer_shd.g_old_rec.information152;
1486   End If;
1487   If (p_rec.information153 = hr_api.g_varchar2) then
1488     p_rec.information153 :=
1489     pqh_cer_shd.g_old_rec.information153;
1490   End If;
1491   If (p_rec.information154 = hr_api.g_varchar2) then
1492     p_rec.information154 :=
1493     pqh_cer_shd.g_old_rec.information154;
1494   End If;
1495   If (p_rec.information155 = hr_api.g_varchar2) then
1496     p_rec.information155 :=
1497     pqh_cer_shd.g_old_rec.information155;
1498   End If;
1499   If (p_rec.information156 = hr_api.g_varchar2) then
1500     p_rec.information156 :=
1501     pqh_cer_shd.g_old_rec.information156;
1502   End If;
1503   If (p_rec.information157 = hr_api.g_varchar2) then
1504     p_rec.information157 :=
1505     pqh_cer_shd.g_old_rec.information157;
1506   End If;
1507   If (p_rec.information158 = hr_api.g_varchar2) then
1508     p_rec.information158 :=
1509     pqh_cer_shd.g_old_rec.information158;
1510   End If;
1511   If (p_rec.information159 = hr_api.g_varchar2) then
1512     p_rec.information159 :=
1513     pqh_cer_shd.g_old_rec.information159;
1514   End If;
1515   If (p_rec.information160 = hr_api.g_varchar2) then
1516     p_rec.information160 :=
1517     pqh_cer_shd.g_old_rec.information160;
1518   End If;
1519   If (p_rec.information161 = hr_api.g_varchar2) then
1520     p_rec.information161 :=
1521     pqh_cer_shd.g_old_rec.information161;
1522   End If;
1523   If (p_rec.information162 = hr_api.g_varchar2) then
1524     p_rec.information162 :=
1525     pqh_cer_shd.g_old_rec.information162;
1526   End If;
1527   If (p_rec.information163 = hr_api.g_varchar2) then
1528     p_rec.information163 :=
1529     pqh_cer_shd.g_old_rec.information163;
1530   End If;
1531   If (p_rec.information164 = hr_api.g_varchar2) then
1532     p_rec.information164 :=
1533     pqh_cer_shd.g_old_rec.information164;
1534   End If;
1535   If (p_rec.information165 = hr_api.g_varchar2) then
1536     p_rec.information165 :=
1537     pqh_cer_shd.g_old_rec.information165;
1538   End If;
1539   If (p_rec.information166 = hr_api.g_varchar2) then
1540     p_rec.information166 :=
1541     pqh_cer_shd.g_old_rec.information166;
1542   End If;
1543   If (p_rec.information167 = hr_api.g_varchar2) then
1544     p_rec.information167 :=
1545     pqh_cer_shd.g_old_rec.information167;
1546   End If;
1547   If (p_rec.information168 = hr_api.g_varchar2) then
1548     p_rec.information168 :=
1549     pqh_cer_shd.g_old_rec.information168;
1550   End If;
1551   If (p_rec.information169 = hr_api.g_varchar2) then
1552     p_rec.information169 :=
1553     pqh_cer_shd.g_old_rec.information169;
1554   End If;
1555   If (p_rec.information170 = hr_api.g_varchar2) then
1556     p_rec.information170 :=
1557     pqh_cer_shd.g_old_rec.information170;
1558   End If;
1559   If (p_rec.information171 = hr_api.g_varchar2) then
1560     p_rec.information171 :=
1561     pqh_cer_shd.g_old_rec.information171;
1562   End If;
1563   If (p_rec.information172 = hr_api.g_varchar2) then
1564     p_rec.information172 :=
1565     pqh_cer_shd.g_old_rec.information172;
1566   End If;
1567   If (p_rec.information173 = hr_api.g_varchar2) then
1568     p_rec.information173 :=
1569     pqh_cer_shd.g_old_rec.information173;
1570   End If;
1571   If (p_rec.information174 = hr_api.g_varchar2) then
1572     p_rec.information174 :=
1573     pqh_cer_shd.g_old_rec.information174;
1574   End If;
1575   If (p_rec.information175 = hr_api.g_varchar2) then
1576     p_rec.information175 :=
1577     pqh_cer_shd.g_old_rec.information175;
1578   End If;
1579   If (p_rec.information176 = hr_api.g_varchar2) then
1580     p_rec.information176 :=
1581     pqh_cer_shd.g_old_rec.information176;
1582   End If;
1583   If (p_rec.information177 = hr_api.g_varchar2) then
1584     p_rec.information177 :=
1585     pqh_cer_shd.g_old_rec.information177;
1586   End If;
1587   If (p_rec.information178 = hr_api.g_varchar2) then
1588     p_rec.information178 :=
1589     pqh_cer_shd.g_old_rec.information178;
1590   End If;
1591   If (p_rec.information179 = hr_api.g_varchar2) then
1592     p_rec.information179 :=
1593     pqh_cer_shd.g_old_rec.information179;
1594   End If;
1595   If (p_rec.information180 = hr_api.g_varchar2) then
1596     p_rec.information180 :=
1597     pqh_cer_shd.g_old_rec.information180;
1598   End If;
1599 
1600   If (p_rec.information181 = hr_api.g_varchar2) then
1601     p_rec.information181 :=
1602     pqh_cer_shd.g_old_rec.information181;
1603   End If;
1604   If (p_rec.information182 = hr_api.g_varchar2) then
1605     p_rec.information182 :=
1606     pqh_cer_shd.g_old_rec.information182;
1607   End If;
1608   If (p_rec.information183 = hr_api.g_varchar2) then
1609     p_rec.information183 :=
1610     pqh_cer_shd.g_old_rec.information183;
1611   End If;
1612   If (p_rec.information184 = hr_api.g_varchar2) then
1613     p_rec.information184 :=
1614     pqh_cer_shd.g_old_rec.information184;
1615   End If;
1616   If (p_rec.information185 = hr_api.g_varchar2) then
1617     p_rec.information185 :=
1618     pqh_cer_shd.g_old_rec.information185;
1619   End If;
1620   If (p_rec.information186 = hr_api.g_varchar2) then
1621     p_rec.information186 :=
1622     pqh_cer_shd.g_old_rec.information186;
1623   End If;
1624   If (p_rec.information187 = hr_api.g_varchar2) then
1625     p_rec.information187 :=
1626     pqh_cer_shd.g_old_rec.information187;
1627   End If;
1628   If (p_rec.information188 = hr_api.g_varchar2) then
1629     p_rec.information188 :=
1630     pqh_cer_shd.g_old_rec.information188;
1631   End If;
1632   If (p_rec.information189 = hr_api.g_varchar2) then
1633     p_rec.information189 :=
1634     pqh_cer_shd.g_old_rec.information189;
1635   End If;
1636   If (p_rec.information190 = hr_api.g_varchar2) then
1637     p_rec.information190 :=
1638     pqh_cer_shd.g_old_rec.information190;
1639   End If;
1640   If (p_rec.mirror_entity_result_id = hr_api.g_number) then
1641     p_rec.mirror_entity_result_id :=
1642     pqh_cer_shd.g_old_rec.mirror_entity_result_id;
1643   End If;
1644   If (p_rec.mirror_src_entity_result_id = hr_api.g_number) then
1645     p_rec.mirror_src_entity_result_id :=
1646     pqh_cer_shd.g_old_rec.mirror_src_entity_result_id;
1647   End If;
1648   If (p_rec.parent_entity_result_id = hr_api.g_number) then
1649     p_rec.parent_entity_result_id :=
1650     pqh_cer_shd.g_old_rec.parent_entity_result_id;
1651   End If;
1652   If (p_rec.table_route_id = hr_api.g_number) then
1653     p_rec.table_route_id :=
1654     pqh_cer_shd.g_old_rec.table_route_id;
1655   End If;
1656   --
1657   hr_utility.set_location(' Leaving:'||l_proc, 10);
1658 --
1659 End convert_defs;
1660 --
1661 -- ----------------------------------------------------------------------------
1662 -- |---------------------------------< upd >----------------------------------|
1663 -- ----------------------------------------------------------------------------
1664 Procedure upd
1665   (
1666   p_effective_date in date,
1667   p_rec        in out nocopy pqh_cer_shd.g_rec_type
1668   ) is
1669 --
1670   l_proc  varchar2(72) := g_package||'upd';
1671 --
1672 Begin
1673   hr_utility.set_location('Entering:'||l_proc, 5);
1674   --
1675   -- We must lock the row which we need to update.
1676   --
1677   pqh_cer_shd.lck
1678 	(
1679 	p_rec.copy_entity_result_id,
1680 	p_rec.object_version_number
1681 	);
1682   --
1683   -- 1. During an update system defaults are used to determine if
1684   --    arguments have been defaulted or not. We must therefore
1685   --    derive the full record structure values to be updated.
1686   --
1687   -- 2. Call the supporting update validate operations.
1688   --
1689   convert_defs(p_rec);
1690   pqh_cer_bus.update_validate(p_rec
1691   ,p_effective_date);
1692   --
1693   -- Call the supporting pre-update operation
1694   --
1695   pre_update(p_rec);
1696   --
1697   -- Update the row.
1698   --
1699   update_dml(p_rec);
1700   --
1701   -- Call the supporting post-update operation
1702   --
1703   post_update(
1704 p_effective_date,p_rec);
1705 End upd;
1706 --
1707 -- ----------------------------------------------------------------------------
1708 -- |---------------------------------< upd >----------------------------------|
1709 -- ----------------------------------------------------------------------------
1710 Procedure upd
1711   (
1712   p_effective_date in date,
1713   p_copy_entity_result_id        in number,
1714   p_copy_entity_txn_id           in number           default hr_api.g_number,
1715   p_result_type_cd               in varchar2         default hr_api.g_varchar2,
1716   p_number_of_copies             in number           default hr_api.g_number  ,
1717   p_status                       in varchar2         default hr_api.g_varchar2,
1718   p_src_copy_entity_result_id    in number           default hr_api.g_number,
1719   p_information_category         in varchar2         default hr_api.g_varchar2,
1720   p_information1                 in varchar2         default hr_api.g_varchar2,
1721   p_information2                 in varchar2         default hr_api.g_varchar2,
1722   p_information3                 in varchar2         default hr_api.g_varchar2,
1723   p_information4                 in varchar2         default hr_api.g_varchar2,
1724   p_information5                 in varchar2         default hr_api.g_varchar2,
1725   p_information6                 in varchar2         default hr_api.g_varchar2,
1726   p_information7                 in varchar2         default hr_api.g_varchar2,
1727   p_information8                 in varchar2         default hr_api.g_varchar2,
1728   p_information9                 in varchar2         default hr_api.g_varchar2,
1729   p_information10                in varchar2         default hr_api.g_varchar2,
1730   p_information11                in varchar2         default hr_api.g_varchar2,
1731   p_information12                in varchar2         default hr_api.g_varchar2,
1732   p_information13                in varchar2         default hr_api.g_varchar2,
1733   p_information14                in varchar2         default hr_api.g_varchar2,
1734   p_information15                in varchar2         default hr_api.g_varchar2,
1735   p_information16                in varchar2         default hr_api.g_varchar2,
1736   p_information17                in varchar2         default hr_api.g_varchar2,
1737   p_information18                in varchar2         default hr_api.g_varchar2,
1738   p_information19                in varchar2         default hr_api.g_varchar2,
1739   p_information20                in varchar2         default hr_api.g_varchar2,
1740   p_information21                in varchar2         default hr_api.g_varchar2,
1741   p_information22                in varchar2         default hr_api.g_varchar2,
1742   p_information23                in varchar2         default hr_api.g_varchar2,
1743   p_information24                in varchar2         default hr_api.g_varchar2,
1744   p_information25                in varchar2         default hr_api.g_varchar2,
1745   p_information26                in varchar2         default hr_api.g_varchar2,
1746   p_information27                in varchar2         default hr_api.g_varchar2,
1747   p_information28                in varchar2         default hr_api.g_varchar2,
1748   p_information29                in varchar2         default hr_api.g_varchar2,
1749   p_information30                in varchar2         default hr_api.g_varchar2,
1750   p_information31                in varchar2         default hr_api.g_varchar2,
1751   p_information32                in varchar2         default hr_api.g_varchar2,
1752   p_information33                in varchar2         default hr_api.g_varchar2,
1753   p_information34                in varchar2         default hr_api.g_varchar2,
1754   p_information35                in varchar2         default hr_api.g_varchar2,
1755   p_information36                in varchar2         default hr_api.g_varchar2,
1756   p_information37                in varchar2         default hr_api.g_varchar2,
1757   p_information38                in varchar2         default hr_api.g_varchar2,
1758   p_information39                in varchar2         default hr_api.g_varchar2,
1759   p_information40                in varchar2         default hr_api.g_varchar2,
1760   p_information41                in varchar2         default hr_api.g_varchar2,
1761   p_information42                in varchar2         default hr_api.g_varchar2,
1762   p_information43                in varchar2         default hr_api.g_varchar2,
1763   p_information44                in varchar2         default hr_api.g_varchar2,
1764   p_information45                in varchar2         default hr_api.g_varchar2,
1765   p_information46                in varchar2         default hr_api.g_varchar2,
1766   p_information47                in varchar2         default hr_api.g_varchar2,
1767   p_information48                in varchar2         default hr_api.g_varchar2,
1768   p_information49                in varchar2         default hr_api.g_varchar2,
1769   p_information50                in varchar2         default hr_api.g_varchar2,
1770   p_information51                in varchar2         default hr_api.g_varchar2,
1771   p_information52                in varchar2         default hr_api.g_varchar2,
1772   p_information53                in varchar2         default hr_api.g_varchar2,
1773   p_information54                in varchar2         default hr_api.g_varchar2,
1774   p_information55                in varchar2         default hr_api.g_varchar2,
1775   p_information56                in varchar2         default hr_api.g_varchar2,
1776   p_information57                in varchar2         default hr_api.g_varchar2,
1777   p_information58                in varchar2         default hr_api.g_varchar2,
1778   p_information59                in varchar2         default hr_api.g_varchar2,
1779   p_information60                in varchar2         default hr_api.g_varchar2,
1780   p_information61                in varchar2         default hr_api.g_varchar2,
1781   p_information62                in varchar2         default hr_api.g_varchar2,
1782   p_information63                in varchar2         default hr_api.g_varchar2,
1783   p_information64                in varchar2         default hr_api.g_varchar2,
1784   p_information65                in varchar2         default hr_api.g_varchar2,
1785   p_information66                in varchar2         default hr_api.g_varchar2,
1786   p_information67                in varchar2         default hr_api.g_varchar2,
1787   p_information68                in varchar2         default hr_api.g_varchar2,
1788   p_information69                in varchar2         default hr_api.g_varchar2,
1789   p_information70                in varchar2         default hr_api.g_varchar2,
1790   p_information71                in varchar2         default hr_api.g_varchar2,
1791   p_information72                in varchar2         default hr_api.g_varchar2,
1792   p_information73                in varchar2         default hr_api.g_varchar2,
1793   p_information74                in varchar2         default hr_api.g_varchar2,
1794   p_information75                in varchar2         default hr_api.g_varchar2,
1795   p_information76                in varchar2         default hr_api.g_varchar2,
1796   p_information77                in varchar2         default hr_api.g_varchar2,
1797   p_information78                in varchar2         default hr_api.g_varchar2,
1798   p_information79                in varchar2         default hr_api.g_varchar2,
1799   p_information80                in varchar2         default hr_api.g_varchar2,
1800   p_information81                in varchar2         default hr_api.g_varchar2,
1801   p_information82                in varchar2         default hr_api.g_varchar2,
1802   p_information83                in varchar2         default hr_api.g_varchar2,
1803   p_information84                in varchar2         default hr_api.g_varchar2,
1804   p_information85                in varchar2         default hr_api.g_varchar2,
1805   p_information86                in varchar2         default hr_api.g_varchar2,
1806   p_information87                in varchar2         default hr_api.g_varchar2,
1807   p_information88                in varchar2         default hr_api.g_varchar2,
1808   p_information89                in varchar2         default hr_api.g_varchar2,
1809   p_information90                in varchar2         default hr_api.g_varchar2,
1810   p_information91                 in varchar2     default hr_api.g_varchar2,
1811   p_information92                 in varchar2     default hr_api.g_varchar2,
1812   p_information93                 in varchar2     default hr_api.g_varchar2,
1813   p_information94                 in varchar2     default hr_api.g_varchar2,
1814   p_information95                 in varchar2     default hr_api.g_varchar2,
1815   p_information96                 in varchar2     default hr_api.g_varchar2,
1816   p_information97                 in varchar2     default hr_api.g_varchar2,
1817   p_information98                 in varchar2     default hr_api.g_varchar2,
1818   p_information99                 in varchar2     default hr_api.g_varchar2,
1819   p_information100                in varchar2     default hr_api.g_varchar2,
1820   p_information101                in varchar2     default hr_api.g_varchar2,
1821   p_information102                in varchar2     default hr_api.g_varchar2,
1822   p_information103                in varchar2     default hr_api.g_varchar2,
1823   p_information104                in varchar2     default hr_api.g_varchar2,
1824   p_information105                in varchar2     default hr_api.g_varchar2,
1825   p_information106                in varchar2     default hr_api.g_varchar2,
1826   p_information107                in varchar2     default hr_api.g_varchar2,
1827   p_information108                in varchar2     default hr_api.g_varchar2,
1828   p_information109                in varchar2     default hr_api.g_varchar2,
1829   p_information110                in varchar2     default hr_api.g_varchar2,
1830   p_information111                in varchar2     default hr_api.g_varchar2,
1831   p_information112                in varchar2     default hr_api.g_varchar2,
1832   p_information113                in varchar2     default hr_api.g_varchar2,
1833   p_information114                in varchar2     default hr_api.g_varchar2,
1834   p_information115                in varchar2     default hr_api.g_varchar2,
1835   p_information116                in varchar2     default hr_api.g_varchar2,
1836   p_information117                in varchar2     default hr_api.g_varchar2,
1837   p_information118                in varchar2     default hr_api.g_varchar2,
1838   p_information119                in varchar2     default hr_api.g_varchar2,
1839   p_information120                in varchar2     default hr_api.g_varchar2,
1840   p_information121                in varchar2     default hr_api.g_varchar2,
1841   p_information122                in varchar2     default hr_api.g_varchar2,
1842   p_information123                in varchar2     default hr_api.g_varchar2,
1843   p_information124                in varchar2     default hr_api.g_varchar2,
1844   p_information125                in varchar2     default hr_api.g_varchar2,
1845   p_information126                in varchar2     default hr_api.g_varchar2,
1846   p_information127                in varchar2     default hr_api.g_varchar2,
1847   p_information128                in varchar2     default hr_api.g_varchar2,
1848   p_information129                in varchar2     default hr_api.g_varchar2,
1849   p_information130                in varchar2     default hr_api.g_varchar2,
1850   p_information131                in varchar2     default hr_api.g_varchar2,
1851   p_information132                in varchar2     default hr_api.g_varchar2,
1852   p_information133                in varchar2     default hr_api.g_varchar2,
1853   p_information134                in varchar2     default hr_api.g_varchar2,
1854   p_information135                in varchar2     default hr_api.g_varchar2,
1855   p_information136                in varchar2     default hr_api.g_varchar2,
1856   p_information137                in varchar2     default hr_api.g_varchar2,
1857   p_information138                in varchar2     default hr_api.g_varchar2,
1858   p_information139                in varchar2     default hr_api.g_varchar2,
1859   p_information140                in varchar2     default hr_api.g_varchar2,
1860   p_information141                in varchar2     default hr_api.g_varchar2,
1861   p_information142                in varchar2     default hr_api.g_varchar2,
1862   p_information143                in varchar2     default hr_api.g_varchar2,
1863   p_information144                in varchar2     default hr_api.g_varchar2,
1864   p_information145                in varchar2     default hr_api.g_varchar2,
1865   p_information146                in varchar2     default hr_api.g_varchar2,
1866   p_information147                in varchar2     default hr_api.g_varchar2,
1867   p_information148                in varchar2     default hr_api.g_varchar2,
1868   p_information149                in varchar2     default hr_api.g_varchar2,
1869   p_information150                in varchar2     default hr_api.g_varchar2,
1870   p_information151                in varchar2     default hr_api.g_varchar2,
1871   p_information152                in varchar2     default hr_api.g_varchar2,
1872   p_information153                in varchar2     default hr_api.g_varchar2,
1873   p_information154                in varchar2     default hr_api.g_varchar2,
1874   p_information155                in varchar2     default hr_api.g_varchar2,
1875   p_information156                in varchar2     default hr_api.g_varchar2,
1876   p_information157                in varchar2     default hr_api.g_varchar2,
1877   p_information158                in varchar2     default hr_api.g_varchar2,
1878   p_information159                in varchar2     default hr_api.g_varchar2,
1879   p_information160                in varchar2     default hr_api.g_varchar2,
1880   p_information161                in varchar2     default hr_api.g_varchar2,
1881   p_information162                in varchar2     default hr_api.g_varchar2,
1882   p_information163                in varchar2     default hr_api.g_varchar2,
1883   p_information164                in varchar2     default hr_api.g_varchar2,
1884   p_information165                in varchar2     default hr_api.g_varchar2,
1885   p_information166                in varchar2     default hr_api.g_varchar2,
1886   p_information167                in varchar2     default hr_api.g_varchar2,
1887   p_information168                in varchar2     default hr_api.g_varchar2,
1888   p_information169                in varchar2     default hr_api.g_varchar2,
1889   p_information170                in varchar2     default hr_api.g_varchar2,
1890   p_information171                in varchar2     default hr_api.g_varchar2,
1891   p_information172                in varchar2     default hr_api.g_varchar2,
1892   p_information173                in varchar2     default hr_api.g_varchar2,
1893   p_information174                in varchar2     default hr_api.g_varchar2,
1894   p_information175                in varchar2     default hr_api.g_varchar2,
1895   p_information176                in varchar2     default hr_api.g_varchar2,
1896   p_information177                in varchar2     default hr_api.g_varchar2,
1897   p_information178                in varchar2     default hr_api.g_varchar2,
1898   p_information179                in varchar2     default hr_api.g_varchar2,
1899   p_information180                in varchar2     default hr_api.g_varchar2,
1900   p_information181                in varchar2     default hr_api.g_varchar2,
1901   p_information182                in varchar2     default hr_api.g_varchar2,
1902   p_information183                in varchar2     default hr_api.g_varchar2,
1903   p_information184                in varchar2     default hr_api.g_varchar2,
1904   p_information185                in varchar2     default hr_api.g_varchar2,
1905   p_information186                in varchar2     default hr_api.g_varchar2,
1906   p_information187                in varchar2     default hr_api.g_varchar2,
1907   p_information188                in varchar2     default hr_api.g_varchar2,
1908   p_information189                in varchar2     default hr_api.g_varchar2,
1909   p_information190                in varchar2     default hr_api.g_varchar2,
1910   p_mirror_entity_result_id       in number       default hr_api.g_number,
1911   p_mirror_src_entity_result_id   in number       default hr_api.g_number,
1912   p_parent_entity_result_id       in number       default hr_api.g_number,
1913   p_table_route_id                in number       default hr_api.g_number,
1914   p_long_attribute1               in long,
1915   p_object_version_number        in out nocopy number
1916   ) is
1917 --
1918   l_rec	  pqh_cer_shd.g_rec_type;
1919   l_proc  varchar2(72) := g_package||'upd';
1920 --
1921 Begin
1922   hr_utility.set_location('Entering:'||l_proc, 5);
1923   --
1924   -- Call conversion function to turn arguments into the
1925   -- l_rec structure.
1926   --
1927   l_rec :=
1928   pqh_cer_shd.convert_args
1929   (
1930   p_copy_entity_result_id,
1931   p_copy_entity_txn_id,
1932   p_result_type_cd,
1933   p_number_of_copies,
1934   p_status,
1935   p_src_copy_entity_result_id,
1936   p_information_category,
1937   p_information1,
1938   p_information2,
1939   p_information3,
1940   p_information4,
1941   p_information5,
1942   p_information6,
1943   p_information7,
1944   p_information8,
1945   p_information9,
1946   p_information10,
1947   p_information11,
1948   p_information12,
1949   p_information13,
1950   p_information14,
1951   p_information15,
1952   p_information16,
1953   p_information17,
1954   p_information18,
1955   p_information19,
1956   p_information20,
1957   p_information21,
1958   p_information22,
1959   p_information23,
1960   p_information24,
1961   p_information25,
1962   p_information26,
1963   p_information27,
1964   p_information28,
1965   p_information29,
1966   p_information30,
1967   p_information31,
1968   p_information32,
1969   p_information33,
1970   p_information34,
1971   p_information35,
1972   p_information36,
1973   p_information37,
1974   p_information38,
1975   p_information39,
1976   p_information40,
1977   p_information41,
1978   p_information42,
1979   p_information43,
1980   p_information44,
1981   p_information45,
1982   p_information46,
1983   p_information47,
1984   p_information48,
1985   p_information49,
1986   p_information50,
1987   p_information51,
1988   p_information52,
1989   p_information53,
1990   p_information54,
1991   p_information55,
1992   p_information56,
1993   p_information57,
1994   p_information58,
1995   p_information59,
1996   p_information60,
1997   p_information61,
1998   p_information62,
1999   p_information63,
2000   p_information64,
2001   p_information65,
2002   p_information66,
2003   p_information67,
2004   p_information68,
2005   p_information69,
2006   p_information70,
2007   p_information71,
2008   p_information72,
2009   p_information73,
2010   p_information74,
2011   p_information75,
2012   p_information76,
2013   p_information77,
2014   p_information78,
2015   p_information79,
2016   p_information80,
2017   p_information81,
2018   p_information82,
2019   p_information83,
2020   p_information84,
2021   p_information85,
2022   p_information86,
2023   p_information87,
2024   p_information88,
2025   p_information89,
2026   p_information90,
2027   p_information91   ,
2028   p_information92   ,
2029   p_information93   ,
2030   p_information94   ,
2031   p_information95   ,
2032   p_information96   ,
2033   p_information97   ,
2034   p_information98   ,
2035   p_information99   ,
2036   p_information100  ,
2037   p_information101  ,
2038   p_information102  ,
2039   p_information103  ,
2040   p_information104  ,
2041   p_information105  ,
2042   p_information106  ,
2043   p_information107  ,
2044   p_information108  ,
2045   p_information109  ,
2046   p_information110  ,
2047   p_information111  ,
2048   p_information112  ,
2049   p_information113  ,
2050   p_information114  ,
2051   p_information115  ,
2052   p_information116  ,
2053   p_information117  ,
2054   p_information118  ,
2055   p_information119  ,
2056   p_information120  ,
2057   p_information121  ,
2058   p_information122  ,
2059   p_information123  ,
2060   p_information124  ,
2061   p_information125  ,
2062   p_information126  ,
2063   p_information127  ,
2064   p_information128  ,
2065   p_information129  ,
2066   p_information130  ,
2067   p_information131  ,
2068   p_information132  ,
2069   p_information133  ,
2070   p_information134  ,
2071   p_information135  ,
2072   p_information136  ,
2073   p_information137  ,
2074   p_information138  ,
2075   p_information139  ,
2076   p_information140  ,
2077   p_information141  ,
2078   p_information142  ,
2079   p_information143  ,
2080   p_information144  ,
2081   p_information145  ,
2082   p_information146  ,
2083   p_information147  ,
2084   p_information148  ,
2085   p_information149  ,
2086   p_information150  ,
2087   p_information151  ,
2088   p_information152  ,
2089   p_information153  ,
2090   p_information154  ,
2091   p_information155  ,
2092   p_information156  ,
2093   p_information157  ,
2094   p_information158  ,
2095   p_information159  ,
2096   p_information160  ,
2097   p_information161  ,
2098   p_information162  ,
2099   p_information163  ,
2100   p_information164  ,
2101   p_information165  ,
2102   p_information166  ,
2103   p_information167  ,
2104   p_information168  ,
2105   p_information169  ,
2106   p_information170  ,
2107   p_information171  ,
2108   p_information172  ,
2109   p_information173  ,
2110   p_information174  ,
2111   p_information175  ,
2112   p_information176  ,
2113   p_information177  ,
2114   p_information178  ,
2115   p_information179  ,
2116   p_information180  ,
2117   p_information181  ,
2118   p_information182  ,
2119   p_information183  ,
2120   p_information184  ,
2121   p_information185  ,
2122   p_information186  ,
2123   p_information187  ,
2124   p_information188  ,
2125   p_information189  ,
2126   p_information190  ,
2127   p_mirror_entity_result_id    ,
2128   p_mirror_src_entity_result_id,
2129   p_parent_entity_result_id    ,
2130   p_table_route_id             ,
2131   p_long_attribute1            ,
2132   p_object_version_number
2133   );
2134   --
2135   -- Having converted the arguments into the
2136   -- plsql record structure we call the corresponding record
2137   -- business process.
2138   --
2139   upd(
2140     p_effective_date,l_rec);
2141   p_object_version_number := l_rec.object_version_number;
2142   --
2143   hr_utility.set_location(' Leaving:'||l_proc, 10);
2144 End upd;
2145 --
2146 end pqh_cer_upd;