DBA Data[Home] [Help]

PACKAGE: APPS.BEN_CPE_UPD

Source


1 Package ben_cpe_upd AUTHID CURRENT_USER as
2 /* $Header: becperhi.pkh 120.0.12020000.2 2013/03/05 06:37:43 amnaraya ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------------< upd >---------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --   This procedure is the record interface for the update
11 --   process for the specified entity. The role of this process is
12 --   to update a fully validated row for the HR schema passing back
13 --   to the calling process, any system generated values (e.g.
14 --   object version number attribute). This process is the main
15 --   backbone of the upd business process. The processing of this
16 --   procedure is as follows:
17 --   1) The row to be updated is locked and selected into the record
18 --      structure g_old_rec.
19 --   2) Because on update parameters which are not part of the update do not
20 --      have to be defaulted, we need to build up the updated row by
21 --      converting any system defaulted parameters to their corresponding
22 --      value.
23 --   3) The controlling validation process update_validate is then executed
24 --      which will execute all private and public validation business rule
25 --      processes.
26 --   4) The pre_update process is then executed which enables any
27 --      logic to be processed before the update dml process is executed.
28 --   5) The update_dml process will physical perform the update dml into the
29 --      specified entity.
30 --   6) The post_update process is then executed which enables any
31 --      logic to be processed after the update dml process.
32 --
33 -- Prerequisites:
34 --   The main parameters to the business process have to be in the record
35 --   format.
36 --
37 -- In Parameters:
38 --
39 -- Post Success:
40 --   The specified row will be fully validated and updated for the specified
41 --   entity without being committed.
42 --
43 -- Post Failure:
44 --   If an error has occurred, an error message will be raised.
45 --
46 -- Developer Implementation Notes:
47 --   None.
48 --
49 -- Access Status:
50 --   Internal Development Use Only.
51 --
52 -- {End Of Comments}
53 -- ----------------------------------------------------------------------------
54 Procedure upd
55   (p_effective_date               in date
56   ,p_rec                          in out nocopy ben_cpe_shd.g_rec_type
57   );
58 --
59 -- ----------------------------------------------------------------------------
60 -- |---------------------------------< upd >----------------------------------|
61 -- ----------------------------------------------------------------------------
62 -- {Start Of Comments}
63 --
64 -- Description:
68 --   passing back to the calling process, any system generated values
65 --   This procedure is the attribute interface for the update
66 --   process for the specified entity and is the outermost layer. The role
67 --   of this process is to update a fully validated row into the HR schema
69 --   (e.g. object version number attributes). The processing of this
70 --   procedure is as follows:
71 --   1) The attributes are converted into a local record structure by
72 --      calling the convert_args function.
73 --   2) After the conversion has taken place, the corresponding record upd
74 --      interface process is executed.
75 --   3) OUT parameters are then set to their corresponding record attributes.
76 --
77 -- Prerequisites:
78 --
79 -- In Parameters:
80 --
81 -- Post Success:
82 --   A fully validated row will be updated for the specified entity
83 --   without being committed.
84 --
85 -- Post Failure:
86 --   If an error has occurred, an error message will be raised.
87 --
88 -- Developer Implementation Notes:
89 --   None.
90 --
91 -- Access Status:
92 --   Internal Development Use Only.
93 --
94 -- {End Of Comments}
95 -- ----------------------------------------------------------------------------
96 Procedure upd
97   (p_effective_date               in     date
98   ,p_copy_entity_result_id        in     number
99   ,p_object_version_number        in out nocopy number
100   ,p_copy_entity_txn_id           in     number    default hr_api.g_number
101   ,p_result_type_cd               in     varchar2  default hr_api.g_varchar2
102   ,p_src_copy_entity_result_id    in     number    default hr_api.g_number
103   ,p_number_of_copies             in     number    default hr_api.g_number
104   ,p_mirror_entity_result_id      in     number    default hr_api.g_number
105   ,p_mirror_src_entity_result_id  in     number    default hr_api.g_number
106   ,p_parent_entity_result_id      in     number    default hr_api.g_number
107   ,p_pd_mr_src_entity_result_id   in     number    default hr_api.g_number
108   ,p_pd_parent_entity_result_id   in     number    default hr_api.g_number
109   ,p_gs_mr_src_entity_result_id   in     number    default hr_api.g_number
110   ,p_gs_parent_entity_result_id   in     number    default hr_api.g_number
111   ,p_table_name                   in     varchar2  default hr_api.g_varchar2
112   ,p_table_alias                  in     varchar2  default hr_api.g_varchar2
113   ,p_table_route_id               in     number    default hr_api.g_number
114   ,p_status                       in     varchar2  default hr_api.g_varchar2
115   ,p_dml_operation                in     varchar2  default hr_api.g_varchar2
116   ,p_information_category         in     varchar2  default hr_api.g_varchar2
117   ,p_information1                 in     number    default hr_api.g_number
118   ,p_information2                 in     date      default hr_api.g_date
119   ,p_information3                 in     date      default hr_api.g_date
120   ,p_information4                 in     number    default hr_api.g_number
121   ,p_information5                 in     varchar2  default hr_api.g_varchar2
122   ,p_information6                 in     varchar2  default hr_api.g_varchar2
123   ,p_information7                 in     varchar2  default hr_api.g_varchar2
124   ,p_information8                 in     varchar2  default hr_api.g_varchar2
125   ,p_information9                 in     varchar2  default hr_api.g_varchar2
126   ,p_information10                in     date      default hr_api.g_date
127   ,p_information11                in     varchar2  default hr_api.g_varchar2
128   ,p_information12                in     varchar2  default hr_api.g_varchar2
129   ,p_information13                in     varchar2  default hr_api.g_varchar2
130   ,p_information14                in     varchar2  default hr_api.g_varchar2
131   ,p_information15                in     varchar2  default hr_api.g_varchar2
132   ,p_information16                in     varchar2  default hr_api.g_varchar2
133   ,p_information17                in     varchar2  default hr_api.g_varchar2
134   ,p_information18                in     varchar2  default hr_api.g_varchar2
135   ,p_information19                in     varchar2  default hr_api.g_varchar2
136   ,p_information20                in     varchar2  default hr_api.g_varchar2
137   ,p_information21                in     varchar2  default hr_api.g_varchar2
138   ,p_information22                in     varchar2  default hr_api.g_varchar2
139   ,p_information23                in     varchar2  default hr_api.g_varchar2
140   ,p_information24                in     varchar2  default hr_api.g_varchar2
141   ,p_information25                in     varchar2  default hr_api.g_varchar2
142   ,p_information26                in     varchar2  default hr_api.g_varchar2
143   ,p_information27                in     varchar2  default hr_api.g_varchar2
144   ,p_information28                in     varchar2  default hr_api.g_varchar2
145   ,p_information29                in     varchar2  default hr_api.g_varchar2
146   ,p_information30                in     varchar2  default hr_api.g_varchar2
147   ,p_information31                in     varchar2  default hr_api.g_varchar2
148   ,p_information32                in     varchar2  default hr_api.g_varchar2
149   ,p_information33                in     varchar2  default hr_api.g_varchar2
150   ,p_information34                in     varchar2  default hr_api.g_varchar2
151   ,p_information35                in     varchar2  default hr_api.g_varchar2
152   ,p_information36                in     varchar2  default hr_api.g_varchar2
153   ,p_information37                in     varchar2  default hr_api.g_varchar2
154   ,p_information38                in     varchar2  default hr_api.g_varchar2
155   ,p_information39                in     varchar2  default hr_api.g_varchar2
156   ,p_information40                in     varchar2  default hr_api.g_varchar2
157   ,p_information41                in     varchar2  default hr_api.g_varchar2
161   ,p_information45                in     varchar2  default hr_api.g_varchar2
158   ,p_information42                in     varchar2  default hr_api.g_varchar2
159   ,p_information43                in     varchar2  default hr_api.g_varchar2
160   ,p_information44                in     varchar2  default hr_api.g_varchar2
162   ,p_information46                in     varchar2  default hr_api.g_varchar2
163   ,p_information47                in     varchar2  default hr_api.g_varchar2
164   ,p_information48                in     varchar2  default hr_api.g_varchar2
165   ,p_information49                in     varchar2  default hr_api.g_varchar2
166   ,p_information50                in     varchar2  default hr_api.g_varchar2
167   ,p_information51                in     varchar2  default hr_api.g_varchar2
168   ,p_information52                in     varchar2  default hr_api.g_varchar2
169   ,p_information53                in     varchar2  default hr_api.g_varchar2
170   ,p_information54                in     varchar2  default hr_api.g_varchar2
171   ,p_information55                in     varchar2  default hr_api.g_varchar2
172   ,p_information56                in     varchar2  default hr_api.g_varchar2
173   ,p_information57                in     varchar2  default hr_api.g_varchar2
174   ,p_information58                in     varchar2  default hr_api.g_varchar2
175   ,p_information59                in     varchar2  default hr_api.g_varchar2
176   ,p_information60                in     varchar2  default hr_api.g_varchar2
177   ,p_information61                in     varchar2  default hr_api.g_varchar2
178   ,p_information62                in     varchar2  default hr_api.g_varchar2
179   ,p_information63                in     varchar2  default hr_api.g_varchar2
180   ,p_information64                in     varchar2  default hr_api.g_varchar2
181   ,p_information65                in     varchar2  default hr_api.g_varchar2
182   ,p_information66                in     varchar2  default hr_api.g_varchar2
183   ,p_information67                in     varchar2  default hr_api.g_varchar2
184   ,p_information68                in     varchar2  default hr_api.g_varchar2
185   ,p_information69                in     varchar2  default hr_api.g_varchar2
186   ,p_information70                in     varchar2  default hr_api.g_varchar2
187   ,p_information71                in     varchar2  default hr_api.g_varchar2
188   ,p_information72                in     varchar2  default hr_api.g_varchar2
189   ,p_information73                in     varchar2  default hr_api.g_varchar2
190   ,p_information74                in     varchar2  default hr_api.g_varchar2
191   ,p_information75                in     varchar2  default hr_api.g_varchar2
192   ,p_information76                in     varchar2  default hr_api.g_varchar2
193   ,p_information77                in     varchar2  default hr_api.g_varchar2
194   ,p_information78                in     varchar2  default hr_api.g_varchar2
195   ,p_information79                in     varchar2  default hr_api.g_varchar2
196   ,p_information80                in     varchar2  default hr_api.g_varchar2
197   ,p_information81                in     varchar2  default hr_api.g_varchar2
198   ,p_information82                in     varchar2  default hr_api.g_varchar2
199   ,p_information83                in     varchar2  default hr_api.g_varchar2
200   ,p_information84                in     varchar2  default hr_api.g_varchar2
201   ,p_information85                in     varchar2  default hr_api.g_varchar2
202   ,p_information86                in     varchar2  default hr_api.g_varchar2
203   ,p_information87                in     varchar2  default hr_api.g_varchar2
204   ,p_information88                in     varchar2  default hr_api.g_varchar2
205   ,p_information89                in     varchar2  default hr_api.g_varchar2
206   ,p_information90                in     varchar2  default hr_api.g_varchar2
207   ,p_information91                in     varchar2  default hr_api.g_varchar2
208   ,p_information92                in     varchar2  default hr_api.g_varchar2
209   ,p_information93                in     varchar2  default hr_api.g_varchar2
210   ,p_information94                in     varchar2  default hr_api.g_varchar2
211   ,p_information95                in     varchar2  default hr_api.g_varchar2
212   ,p_information96                in     varchar2  default hr_api.g_varchar2
213   ,p_information97                in     varchar2  default hr_api.g_varchar2
214   ,p_information98                in     varchar2  default hr_api.g_varchar2
215   ,p_information99                in     varchar2  default hr_api.g_varchar2
216   ,p_information100               in     varchar2  default hr_api.g_varchar2
217   ,p_information101               in     varchar2  default hr_api.g_varchar2
218   ,p_information102               in     varchar2  default hr_api.g_varchar2
219   ,p_information103               in     varchar2  default hr_api.g_varchar2
220   ,p_information104               in     varchar2  default hr_api.g_varchar2
221   ,p_information105               in     varchar2  default hr_api.g_varchar2
222   ,p_information106               in     varchar2  default hr_api.g_varchar2
223   ,p_information107               in     varchar2  default hr_api.g_varchar2
224   ,p_information108               in     varchar2  default hr_api.g_varchar2
225   ,p_information109               in     varchar2  default hr_api.g_varchar2
226   ,p_information110               in     varchar2  default hr_api.g_varchar2
227   ,p_information111               in     varchar2  default hr_api.g_varchar2
228   ,p_information112               in     varchar2  default hr_api.g_varchar2
229   ,p_information113               in     varchar2  default hr_api.g_varchar2
230   ,p_information114               in     varchar2  default hr_api.g_varchar2
231   ,p_information115               in     varchar2  default hr_api.g_varchar2
232   ,p_information116               in     varchar2  default hr_api.g_varchar2
233   ,p_information117               in     varchar2  default hr_api.g_varchar2
234   ,p_information118               in     varchar2  default hr_api.g_varchar2
235   ,p_information119               in     varchar2  default hr_api.g_varchar2
236   ,p_information120               in     varchar2  default hr_api.g_varchar2
240   ,p_information124               in     varchar2  default hr_api.g_varchar2
237   ,p_information121               in     varchar2  default hr_api.g_varchar2
238   ,p_information122               in     varchar2  default hr_api.g_varchar2
239   ,p_information123               in     varchar2  default hr_api.g_varchar2
241   ,p_information125               in     varchar2  default hr_api.g_varchar2
242   ,p_information126               in     varchar2  default hr_api.g_varchar2
243   ,p_information127               in     varchar2  default hr_api.g_varchar2
244   ,p_information128               in     varchar2  default hr_api.g_varchar2
245   ,p_information129               in     varchar2  default hr_api.g_varchar2
246   ,p_information130               in     varchar2  default hr_api.g_varchar2
247   ,p_information131               in     varchar2  default hr_api.g_varchar2
248   ,p_information132               in     varchar2  default hr_api.g_varchar2
249   ,p_information133               in     varchar2  default hr_api.g_varchar2
250   ,p_information134               in     varchar2  default hr_api.g_varchar2
251   ,p_information135               in     varchar2  default hr_api.g_varchar2
252   ,p_information136               in     varchar2  default hr_api.g_varchar2
253   ,p_information137               in     varchar2  default hr_api.g_varchar2
254   ,p_information138               in     varchar2  default hr_api.g_varchar2
255   ,p_information139               in     varchar2  default hr_api.g_varchar2
256   ,p_information140               in     varchar2  default hr_api.g_varchar2
257   ,p_information141               in     varchar2  default hr_api.g_varchar2
258   ,p_information142               in     varchar2  default hr_api.g_varchar2
259 
260   /* Extra Reserved Columns
261   ,p_information143               in     varchar2  default hr_api.g_varchar2
262   ,p_information144               in     varchar2  default hr_api.g_varchar2
263   ,p_information145               in     varchar2  default hr_api.g_varchar2
264   ,p_information146               in     varchar2  default hr_api.g_varchar2
265   ,p_information147               in     varchar2  default hr_api.g_varchar2
266   ,p_information148               in     varchar2  default hr_api.g_varchar2
267   ,p_information149               in     varchar2  default hr_api.g_varchar2
268   ,p_information150               in     varchar2  default hr_api.g_varchar2
269   */
270   ,p_information151               in     varchar2  default hr_api.g_varchar2
271   ,p_information152               in     varchar2  default hr_api.g_varchar2
272   ,p_information153               in     varchar2  default hr_api.g_varchar2
273 
274   /* Extra Reserved Columns
275   ,p_information154               in     varchar2  default hr_api.g_varchar2
276   ,p_information155               in     varchar2  default hr_api.g_varchar2
277   ,p_information156               in     varchar2  default hr_api.g_varchar2
278   ,p_information157               in     varchar2  default hr_api.g_varchar2
279   ,p_information158               in     varchar2  default hr_api.g_varchar2
280   ,p_information159               in     varchar2  default hr_api.g_varchar2
281   */
282   ,p_information160               in     number    default hr_api.g_number
283   ,p_information161               in     number    default hr_api.g_number
284   ,p_information162               in     number    default hr_api.g_number
285 
286   /* Extra Reserved Columns
287   ,p_information163               in     number    default hr_api.g_number
288   ,p_information164               in     number    default hr_api.g_number
289   ,p_information165               in     number    default hr_api.g_number
290   */
291   ,p_information166               in     date      default hr_api.g_date
292   ,p_information167               in     date      default hr_api.g_date
293   ,p_information168               in     date      default hr_api.g_date
294   ,p_information169               in     number    default hr_api.g_number
295   ,p_information170               in     varchar2  default hr_api.g_varchar2
296 
297   /* Extra Reserved Columns
298   ,p_information171               in     varchar2  default hr_api.g_varchar2
299   ,p_information172               in     varchar2  default hr_api.g_varchar2
300   */
301   ,p_information173               in     varchar2  default hr_api.g_varchar2
302   ,p_information174               in     number    default hr_api.g_number
303   ,p_information175               in     varchar2  default hr_api.g_varchar2
304   ,p_information176               in     number    default hr_api.g_number
305   ,p_information177               in     varchar2  default hr_api.g_varchar2
306   ,p_information178               in     number    default hr_api.g_number
307   ,p_information179               in     varchar2  default hr_api.g_varchar2
308   ,p_information180               in     number    default hr_api.g_number
309   ,p_information181               in     varchar2  default hr_api.g_varchar2
310   ,p_information182               in     varchar2  default hr_api.g_varchar2
311 
312   /* Extra Reserved Columns
313   ,p_information183               in     varchar2  default hr_api.g_varchar2
314   ,p_information184               in     varchar2  default hr_api.g_varchar2
315   */
316   ,p_information185               in     varchar2  default hr_api.g_varchar2
317   ,p_information186               in     varchar2  default hr_api.g_varchar2
318   ,p_information187               in     varchar2  default hr_api.g_varchar2
319   ,p_information188               in     varchar2  default hr_api.g_varchar2
320 
321   /* Extra Reserved Columns
322   ,p_information189               in     varchar2  default hr_api.g_varchar2
323   */
324   ,p_information190               in     varchar2  default hr_api.g_varchar2
325   ,p_information191               in     varchar2  default hr_api.g_varchar2
326   ,p_information192               in     varchar2  default hr_api.g_varchar2
330   ,p_information196               in     varchar2  default hr_api.g_varchar2
327   ,p_information193               in     varchar2  default hr_api.g_varchar2
328   ,p_information194               in     varchar2  default hr_api.g_varchar2
329   ,p_information195               in     varchar2  default hr_api.g_varchar2
331   ,p_information197               in     varchar2  default hr_api.g_varchar2
332   ,p_information198               in     varchar2  default hr_api.g_varchar2
333   ,p_information199               in     varchar2  default hr_api.g_varchar2
334 
335   /* Extra Reserved Columns
336   ,p_information200               in     varchar2  default hr_api.g_varchar2
337   ,p_information201               in     varchar2  default hr_api.g_varchar2
338   ,p_information202               in     varchar2  default hr_api.g_varchar2
339   ,p_information203               in     varchar2  default hr_api.g_varchar2
340   ,p_information204               in     varchar2  default hr_api.g_varchar2
341   ,p_information205               in     varchar2  default hr_api.g_varchar2
342   ,p_information206               in     varchar2  default hr_api.g_varchar2
343   ,p_information207               in     varchar2  default hr_api.g_varchar2
344   ,p_information208               in     varchar2  default hr_api.g_varchar2
345   ,p_information209               in     varchar2  default hr_api.g_varchar2
346   ,p_information210               in     varchar2  default hr_api.g_varchar2
347   ,p_information211               in     varchar2  default hr_api.g_varchar2
348   ,p_information212               in     varchar2  default hr_api.g_varchar2
349   ,p_information213               in     varchar2  default hr_api.g_varchar2
350   ,p_information214               in     varchar2  default hr_api.g_varchar2
351   ,p_information215               in     varchar2  default hr_api.g_varchar2
352   */
353   ,p_information216               in     varchar2  default hr_api.g_varchar2
354   ,p_information217               in     varchar2  default hr_api.g_varchar2
355   ,p_information218               in     varchar2  default hr_api.g_varchar2
356   ,p_information219               in     varchar2  default hr_api.g_varchar2
357   ,p_information220               in     varchar2  default hr_api.g_varchar2
358   ,p_information221               in     number    default hr_api.g_number
359   ,p_information222               in     number    default hr_api.g_number
360   ,p_information223               in     number    default hr_api.g_number
361   ,p_information224               in     number    default hr_api.g_number
362   ,p_information225               in     number    default hr_api.g_number
363   ,p_information226               in     number    default hr_api.g_number
364   ,p_information227               in     number    default hr_api.g_number
365   ,p_information228               in     number    default hr_api.g_number
366   ,p_information229               in     number    default hr_api.g_number
367   ,p_information230               in     number    default hr_api.g_number
368   ,p_information231               in     number    default hr_api.g_number
369   ,p_information232               in     number    default hr_api.g_number
370   ,p_information233               in     number    default hr_api.g_number
371   ,p_information234               in     number    default hr_api.g_number
372   ,p_information235               in     number    default hr_api.g_number
373   ,p_information236               in     number    default hr_api.g_number
374   ,p_information237               in     number    default hr_api.g_number
375   ,p_information238               in     number    default hr_api.g_number
376   ,p_information239               in     number    default hr_api.g_number
377   ,p_information240               in     number    default hr_api.g_number
378   ,p_information241               in     number    default hr_api.g_number
379   ,p_information242               in     number    default hr_api.g_number
380   ,p_information243               in     number    default hr_api.g_number
381   ,p_information244               in     number    default hr_api.g_number
382   ,p_information245               in     number    default hr_api.g_number
383   ,p_information246               in     number    default hr_api.g_number
384   ,p_information247               in     number    default hr_api.g_number
385   ,p_information248               in     number    default hr_api.g_number
386   ,p_information249               in     number    default hr_api.g_number
387   ,p_information250               in     number    default hr_api.g_number
388   ,p_information251               in     number    default hr_api.g_number
389   ,p_information252               in     number    default hr_api.g_number
390   ,p_information253               in     number    default hr_api.g_number
391   ,p_information254               in     number    default hr_api.g_number
392   ,p_information255               in     number    default hr_api.g_number
393   ,p_information256               in     number    default hr_api.g_number
394   ,p_information257               in     number    default hr_api.g_number
395   ,p_information258               in     number    default hr_api.g_number
396   ,p_information259               in     number    default hr_api.g_number
397   ,p_information260               in     number    default hr_api.g_number
398   ,p_information261               in     number    default hr_api.g_number
399   ,p_information262               in     number    default hr_api.g_number
400   ,p_information263               in     number    default hr_api.g_number
401   ,p_information264               in     number    default hr_api.g_number
402   ,p_information265               in     number    default hr_api.g_number
403   ,p_information266               in     number    default hr_api.g_number
404   ,p_information267               in     number    default hr_api.g_number
405   ,p_information268               in     number    default hr_api.g_number
406   ,p_information269               in     number    default hr_api.g_number
407   ,p_information270               in     number    default hr_api.g_number
408   ,p_information271               in     number    default hr_api.g_number
409   ,p_information272               in     number    default hr_api.g_number
410   ,p_information273               in     number    default hr_api.g_number
411   ,p_information274               in     number    default hr_api.g_number
412   ,p_information275               in     number    default hr_api.g_number
413   ,p_information276               in     number    default hr_api.g_number
414   ,p_information277               in     number    default hr_api.g_number
415   ,p_information278               in     number    default hr_api.g_number
416   ,p_information279               in     number    default hr_api.g_number
417   ,p_information280               in     number    default hr_api.g_number
418   ,p_information281               in     number    default hr_api.g_number
419   ,p_information282               in     number    default hr_api.g_number
420   ,p_information283               in     number    default hr_api.g_number
421   ,p_information284               in     number    default hr_api.g_number
422   ,p_information285               in     number    default hr_api.g_number
423   ,p_information286               in     number    default hr_api.g_number
424   ,p_information287               in     number    default hr_api.g_number
425   ,p_information288               in     number    default hr_api.g_number
426   ,p_information289               in     number    default hr_api.g_number
427   ,p_information290               in     number    default hr_api.g_number
428   ,p_information291               in     number    default hr_api.g_number
429   ,p_information292               in     number    default hr_api.g_number
430   ,p_information293               in     number    default hr_api.g_number
431   ,p_information294               in     number    default hr_api.g_number
432   ,p_information295               in     number    default hr_api.g_number
433   ,p_information296               in     number    default hr_api.g_number
434   ,p_information297               in     number    default hr_api.g_number
435   ,p_information298               in     number    default hr_api.g_number
436   ,p_information299               in     number    default hr_api.g_number
437   ,p_information300               in     number    default hr_api.g_number
438   ,p_information301               in     number    default hr_api.g_number
439   ,p_information302               in     number    default hr_api.g_number
440   ,p_information303               in     number    default hr_api.g_number
441   ,p_information304               in     number    default hr_api.g_number
442 
443   /* Extra Reserved Columns
444   ,p_information305               in     number    default hr_api.g_number
445   */
446   ,p_information306               in     date      default hr_api.g_date
447   ,p_information307               in     date      default hr_api.g_date
448   ,p_information308               in     date      default hr_api.g_date
449   ,p_information309               in     date      default hr_api.g_date
450   ,p_information310               in     date      default hr_api.g_date
451   ,p_information311               in     date      default hr_api.g_date
452   ,p_information312               in     date      default hr_api.g_date
453   ,p_information313               in     date      default hr_api.g_date
454   ,p_information314               in     date      default hr_api.g_date
455   ,p_information315               in     date      default hr_api.g_date
456   ,p_information316               in     date      default hr_api.g_date
457   ,p_information317               in     date      default hr_api.g_date
458   ,p_information318               in     date      default hr_api.g_date
459   ,p_information319               in     date      default hr_api.g_date
460   ,p_information320               in     date      default hr_api.g_date
461 
462   /* Extra Reserved Columns
463   ,p_information321               in     date      default hr_api.g_date
464   ,p_information322               in     date      default hr_api.g_date
465   */
466   ,p_information323               in     long
467   ,p_datetrack_mode               in     varchar2  default hr_api.g_varchar2
468   );
469 --
470 end ben_cpe_upd;