1 Package ben_xrd_upd as
2 /* $Header: bexrdrhi.pkh 120.0 2005/05/28 12:39:21 appldev noship $ */
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 supplied with the work
45 -- rolled back.
46 --
47 -- Developer Implementation Notes:
48 -- None.
49 --
50 -- Access Status:
51 -- Internal Development Use Only.
52 --
53 -- {End Of Comments}
54 -- ----------------------------------------------------------------------------
55 Procedure upd
56 (
57 p_rec in out nocopy ben_xrd_shd.g_rec_type
58 );
59 --
60 -- ----------------------------------------------------------------------------
61 -- |---------------------------------< upd >----------------------------------|
62 -- ----------------------------------------------------------------------------
63 -- {Start Of Comments}
64 --
65 -- Description:
66 -- This procedure is the attribute interface for the update
67 -- process for the specified entity and is the outermost layer. The role
68 -- of this process is to update a fully validated row into the HR schema
69 -- passing back to the calling process, any system generated values
70 -- (e.g. object version number attributes). The processing of this
71 -- procedure is as follows:
72 -- 1) The attributes are converted into a local record structure by
73 -- calling the convert_args function.
74 -- 2) After the conversion has taken place, the corresponding record upd
75 -- interface process is executed.
76 -- 3) OUT parameters are then set to their corresponding record attributes.
77 --
78 -- Prerequisites:
79 --
80 -- In Parameters:
81 --
82 -- Post Success:
83 -- A fully validated row will be updated for the specified entity
84 -- without being committed.
85 --
86 -- Post Failure:
87 -- If an error has occurred, an error message will be supplied with the work
88 -- rolled back.
89 --
90 -- Developer Implementation Notes:
91 -- None.
92 --
93 -- Access Status:
94 -- Internal Development Use Only.
95 --
96 -- {End Of Comments}
97 -- ----------------------------------------------------------------------------
98 Procedure upd
99 (
100 p_ext_rslt_dtl_id in number,
101 p_prmy_sort_val in varchar2 default hr_api.g_varchar2,
102 p_scnd_sort_val in varchar2 default hr_api.g_varchar2,
103 p_thrd_sort_val in varchar2 default hr_api.g_varchar2,
104 p_trans_seq_num in number default hr_api.g_number,
105 p_rcrd_seq_num in number default hr_api.g_number,
106 p_ext_rslt_id in number default hr_api.g_number,
107 p_ext_rcd_id in number default hr_api.g_number,
108 p_person_id in number default hr_api.g_number,
109 p_business_group_id in number default hr_api.g_number,
110 p_ext_per_bg_id in number default hr_api.g_number,
111 p_val_01 in varchar2 default hr_api.g_varchar2,
112 p_val_02 in varchar2 default hr_api.g_varchar2,
113 p_val_03 in varchar2 default hr_api.g_varchar2,
114 p_val_04 in varchar2 default hr_api.g_varchar2,
115 p_val_05 in varchar2 default hr_api.g_varchar2,
116 p_val_06 in varchar2 default hr_api.g_varchar2,
117 p_val_07 in varchar2 default hr_api.g_varchar2,
118 p_val_08 in varchar2 default hr_api.g_varchar2,
119 p_val_09 in varchar2 default hr_api.g_varchar2,
120 p_val_10 in varchar2 default hr_api.g_varchar2,
121 p_val_11 in varchar2 default hr_api.g_varchar2,
122 p_val_12 in varchar2 default hr_api.g_varchar2,
123 p_val_13 in varchar2 default hr_api.g_varchar2,
124 p_val_14 in varchar2 default hr_api.g_varchar2,
125 p_val_15 in varchar2 default hr_api.g_varchar2,
126 p_val_16 in varchar2 default hr_api.g_varchar2,
127 p_val_17 in varchar2 default hr_api.g_varchar2,
128 p_val_19 in varchar2 default hr_api.g_varchar2,
129 p_val_18 in varchar2 default hr_api.g_varchar2,
130 p_val_20 in varchar2 default hr_api.g_varchar2,
131 p_val_21 in varchar2 default hr_api.g_varchar2,
132 p_val_22 in varchar2 default hr_api.g_varchar2,
133 p_val_23 in varchar2 default hr_api.g_varchar2,
134 p_val_24 in varchar2 default hr_api.g_varchar2,
135 p_val_25 in varchar2 default hr_api.g_varchar2,
136 p_val_26 in varchar2 default hr_api.g_varchar2,
137 p_val_27 in varchar2 default hr_api.g_varchar2,
138 p_val_28 in varchar2 default hr_api.g_varchar2,
139 p_val_29 in varchar2 default hr_api.g_varchar2,
140 p_val_30 in varchar2 default hr_api.g_varchar2,
141 p_val_31 in varchar2 default hr_api.g_varchar2,
142 p_val_32 in varchar2 default hr_api.g_varchar2,
143 p_val_33 in varchar2 default hr_api.g_varchar2,
144 p_val_34 in varchar2 default hr_api.g_varchar2,
145 p_val_35 in varchar2 default hr_api.g_varchar2,
146 p_val_36 in varchar2 default hr_api.g_varchar2,
147 p_val_37 in varchar2 default hr_api.g_varchar2,
148 p_val_38 in varchar2 default hr_api.g_varchar2,
149 p_val_39 in varchar2 default hr_api.g_varchar2,
150 p_val_40 in varchar2 default hr_api.g_varchar2,
151 p_val_41 in varchar2 default hr_api.g_varchar2,
152 p_val_42 in varchar2 default hr_api.g_varchar2,
153 p_val_43 in varchar2 default hr_api.g_varchar2,
154 p_val_44 in varchar2 default hr_api.g_varchar2,
155 p_val_45 in varchar2 default hr_api.g_varchar2,
156 p_val_46 in varchar2 default hr_api.g_varchar2,
157 p_val_47 in varchar2 default hr_api.g_varchar2,
158 p_val_48 in varchar2 default hr_api.g_varchar2,
159 p_val_49 in varchar2 default hr_api.g_varchar2,
160 p_val_50 in varchar2 default hr_api.g_varchar2,
161 p_val_51 in varchar2 default hr_api.g_varchar2,
162 p_val_52 in varchar2 default hr_api.g_varchar2,
163 p_val_53 in varchar2 default hr_api.g_varchar2,
164 p_val_54 in varchar2 default hr_api.g_varchar2,
165 p_val_55 in varchar2 default hr_api.g_varchar2,
166 p_val_56 in varchar2 default hr_api.g_varchar2,
167 p_val_57 in varchar2 default hr_api.g_varchar2,
168 p_val_58 in varchar2 default hr_api.g_varchar2,
169 p_val_59 in varchar2 default hr_api.g_varchar2,
170 p_val_60 in varchar2 default hr_api.g_varchar2,
171 p_val_61 in varchar2 default hr_api.g_varchar2,
172 p_val_62 in varchar2 default hr_api.g_varchar2,
173 p_val_63 in varchar2 default hr_api.g_varchar2,
174 p_val_64 in varchar2 default hr_api.g_varchar2,
175 p_val_65 in varchar2 default hr_api.g_varchar2,
176 p_val_66 in varchar2 default hr_api.g_varchar2,
177 p_val_67 in varchar2 default hr_api.g_varchar2,
178 p_val_68 in varchar2 default hr_api.g_varchar2,
179 p_val_69 in varchar2 default hr_api.g_varchar2,
180 p_val_70 in varchar2 default hr_api.g_varchar2,
181 p_val_71 in varchar2 default hr_api.g_varchar2,
182 p_val_72 in varchar2 default hr_api.g_varchar2,
183 p_val_73 in varchar2 default hr_api.g_varchar2,
184 p_val_74 in varchar2 default hr_api.g_varchar2,
185 p_val_75 in varchar2 default hr_api.g_varchar2,
186 p_val_76 in varchar2 default hr_api.g_varchar2 ,
187 p_val_77 in varchar2 default hr_api.g_varchar2 ,
188 p_val_78 in varchar2 default hr_api.g_varchar2 ,
189 p_val_79 in varchar2 default hr_api.g_varchar2 ,
190 p_val_80 in varchar2 default hr_api.g_varchar2 ,
191 p_val_81 in varchar2 default hr_api.g_varchar2 ,
192 p_val_82 in varchar2 default hr_api.g_varchar2 ,
193 p_val_83 in varchar2 default hr_api.g_varchar2 ,
194 p_val_84 in varchar2 default hr_api.g_varchar2 ,
195 p_val_85 in varchar2 default hr_api.g_varchar2 ,
196 p_val_86 in varchar2 default hr_api.g_varchar2 ,
197 p_val_87 in varchar2 default hr_api.g_varchar2 ,
198 p_val_88 in varchar2 default hr_api.g_varchar2 ,
199 p_val_89 in varchar2 default hr_api.g_varchar2 ,
200 p_val_90 in varchar2 default hr_api.g_varchar2 ,
201 p_val_91 in varchar2 default hr_api.g_varchar2 ,
202 p_val_92 in varchar2 default hr_api.g_varchar2 ,
203 p_val_93 in varchar2 default hr_api.g_varchar2 ,
204 p_val_94 in varchar2 default hr_api.g_varchar2 ,
205 p_val_95 in varchar2 default hr_api.g_varchar2 ,
206 p_val_96 in varchar2 default hr_api.g_varchar2 ,
207 p_val_97 in varchar2 default hr_api.g_varchar2 ,
208 p_val_98 in varchar2 default hr_api.g_varchar2 ,
209 p_val_99 in varchar2 default hr_api.g_varchar2 ,
210 p_val_100 in varchar2 default hr_api.g_varchar2 ,
211 p_val_101 in varchar2 default hr_api.g_varchar2 ,
212 p_val_102 in varchar2 default hr_api.g_varchar2 ,
213 p_val_103 in varchar2 default hr_api.g_varchar2 ,
214 p_val_104 in varchar2 default hr_api.g_varchar2 ,
215 p_val_105 in varchar2 default hr_api.g_varchar2 ,
216 p_val_106 in varchar2 default hr_api.g_varchar2 ,
217 p_val_107 in varchar2 default hr_api.g_varchar2 ,
218 p_val_108 in varchar2 default hr_api.g_varchar2 ,
219 p_val_109 in varchar2 default hr_api.g_varchar2 ,
220 p_val_110 in varchar2 default hr_api.g_varchar2 ,
221 p_val_111 in varchar2 default hr_api.g_varchar2 ,
222 p_val_112 in varchar2 default hr_api.g_varchar2 ,
223 p_val_113 in varchar2 default hr_api.g_varchar2 ,
224 p_val_114 in varchar2 default hr_api.g_varchar2 ,
225 p_val_115 in varchar2 default hr_api.g_varchar2 ,
226 p_val_116 in varchar2 default hr_api.g_varchar2 ,
227 p_val_117 in varchar2 default hr_api.g_varchar2 ,
228 p_val_119 in varchar2 default hr_api.g_varchar2 ,
229 p_val_118 in varchar2 default hr_api.g_varchar2 ,
230 p_val_120 in varchar2 default hr_api.g_varchar2 ,
231 p_val_121 in varchar2 default hr_api.g_varchar2 ,
232 p_val_122 in varchar2 default hr_api.g_varchar2 ,
233 p_val_123 in varchar2 default hr_api.g_varchar2 ,
234 p_val_124 in varchar2 default hr_api.g_varchar2 ,
235 p_val_125 in varchar2 default hr_api.g_varchar2 ,
236 p_val_126 in varchar2 default hr_api.g_varchar2 ,
237 p_val_127 in varchar2 default hr_api.g_varchar2 ,
238 p_val_128 in varchar2 default hr_api.g_varchar2 ,
239 p_val_129 in varchar2 default hr_api.g_varchar2 ,
240 p_val_130 in varchar2 default hr_api.g_varchar2 ,
241 p_val_131 in varchar2 default hr_api.g_varchar2 ,
242 p_val_132 in varchar2 default hr_api.g_varchar2 ,
243 p_val_133 in varchar2 default hr_api.g_varchar2 ,
244 p_val_134 in varchar2 default hr_api.g_varchar2 ,
245 p_val_135 in varchar2 default hr_api.g_varchar2 ,
246 p_val_136 in varchar2 default hr_api.g_varchar2 ,
247 p_val_137 in varchar2 default hr_api.g_varchar2 ,
248 p_val_138 in varchar2 default hr_api.g_varchar2 ,
252 p_val_142 in varchar2 default hr_api.g_varchar2 ,
249 p_val_139 in varchar2 default hr_api.g_varchar2 ,
250 p_val_140 in varchar2 default hr_api.g_varchar2 ,
251 p_val_141 in varchar2 default hr_api.g_varchar2 ,
253 p_val_143 in varchar2 default hr_api.g_varchar2 ,
254 p_val_144 in varchar2 default hr_api.g_varchar2 ,
255 p_val_145 in varchar2 default hr_api.g_varchar2 ,
256 p_val_146 in varchar2 default hr_api.g_varchar2 ,
257 p_val_147 in varchar2 default hr_api.g_varchar2 ,
258 p_val_148 in varchar2 default hr_api.g_varchar2 ,
259 p_val_149 in varchar2 default hr_api.g_varchar2 ,
260 p_val_150 in varchar2 default hr_api.g_varchar2 ,
261 p_val_151 in varchar2 default hr_api.g_varchar2 ,
262 p_val_152 in varchar2 default hr_api.g_varchar2 ,
263 p_val_153 in varchar2 default hr_api.g_varchar2 ,
264 p_val_154 in varchar2 default hr_api.g_varchar2 ,
265 p_val_155 in varchar2 default hr_api.g_varchar2 ,
266 p_val_156 in varchar2 default hr_api.g_varchar2 ,
267 p_val_157 in varchar2 default hr_api.g_varchar2 ,
268 p_val_158 in varchar2 default hr_api.g_varchar2 ,
269 p_val_159 in varchar2 default hr_api.g_varchar2 ,
270 p_val_160 in varchar2 default hr_api.g_varchar2 ,
271 p_val_161 in varchar2 default hr_api.g_varchar2 ,
272 p_val_162 in varchar2 default hr_api.g_varchar2 ,
273 p_val_163 in varchar2 default hr_api.g_varchar2 ,
274 p_val_164 in varchar2 default hr_api.g_varchar2 ,
275 p_val_165 in varchar2 default hr_api.g_varchar2 ,
276 p_val_166 in varchar2 default hr_api.g_varchar2 ,
277 p_val_167 in varchar2 default hr_api.g_varchar2 ,
278 p_val_168 in varchar2 default hr_api.g_varchar2 ,
279 p_val_169 in varchar2 default hr_api.g_varchar2 ,
280 p_val_170 in varchar2 default hr_api.g_varchar2 ,
281 p_val_171 in varchar2 default hr_api.g_varchar2 ,
282 p_val_172 in varchar2 default hr_api.g_varchar2 ,
283 p_val_173 in varchar2 default hr_api.g_varchar2 ,
284 p_val_174 in varchar2 default hr_api.g_varchar2 ,
285 p_val_175 in varchar2 default hr_api.g_varchar2 ,
286 p_val_176 in varchar2 default hr_api.g_varchar2 ,
287 p_val_177 in varchar2 default hr_api.g_varchar2 ,
288 p_val_178 in varchar2 default hr_api.g_varchar2 ,
289 p_val_179 in varchar2 default hr_api.g_varchar2 ,
290 p_val_180 in varchar2 default hr_api.g_varchar2 ,
291 p_val_181 in varchar2 default hr_api.g_varchar2 ,
292 p_val_182 in varchar2 default hr_api.g_varchar2 ,
293 p_val_183 in varchar2 default hr_api.g_varchar2 ,
294 p_val_184 in varchar2 default hr_api.g_varchar2 ,
295 p_val_185 in varchar2 default hr_api.g_varchar2 ,
296 p_val_186 in varchar2 default hr_api.g_varchar2 ,
297 p_val_187 in varchar2 default hr_api.g_varchar2 ,
298 p_val_188 in varchar2 default hr_api.g_varchar2 ,
299 p_val_189 in varchar2 default hr_api.g_varchar2 ,
300 p_val_190 in varchar2 default hr_api.g_varchar2 ,
301 p_val_191 in varchar2 default hr_api.g_varchar2 ,
302 p_val_192 in varchar2 default hr_api.g_varchar2 ,
303 p_val_193 in varchar2 default hr_api.g_varchar2 ,
304 p_val_194 in varchar2 default hr_api.g_varchar2 ,
305 p_val_195 in varchar2 default hr_api.g_varchar2 ,
306 p_val_196 in varchar2 default hr_api.g_varchar2 ,
307 p_val_197 in varchar2 default hr_api.g_varchar2 ,
308 p_val_198 in varchar2 default hr_api.g_varchar2 ,
309 p_val_199 in varchar2 default hr_api.g_varchar2 ,
310 p_val_200 in varchar2 default hr_api.g_varchar2 ,
311 p_val_201 in varchar2 default hr_api.g_varchar2 ,
312 p_val_202 in varchar2 default hr_api.g_varchar2 ,
313 p_val_203 in varchar2 default hr_api.g_varchar2 ,
314 p_val_204 in varchar2 default hr_api.g_varchar2 ,
315 p_val_205 in varchar2 default hr_api.g_varchar2 ,
316 p_val_206 in varchar2 default hr_api.g_varchar2 ,
317 p_val_207 in varchar2 default hr_api.g_varchar2 ,
318 p_val_208 in varchar2 default hr_api.g_varchar2 ,
319 p_val_209 in varchar2 default hr_api.g_varchar2 ,
320 p_val_210 in varchar2 default hr_api.g_varchar2 ,
321 p_val_211 in varchar2 default hr_api.g_varchar2 ,
322 p_val_212 in varchar2 default hr_api.g_varchar2 ,
323 p_val_213 in varchar2 default hr_api.g_varchar2 ,
324 p_val_214 in varchar2 default hr_api.g_varchar2 ,
325 p_val_215 in varchar2 default hr_api.g_varchar2 ,
326 p_val_216 in varchar2 default hr_api.g_varchar2 ,
327 p_val_217 in varchar2 default hr_api.g_varchar2 ,
328 p_val_219 in varchar2 default hr_api.g_varchar2 ,
329 p_val_218 in varchar2 default hr_api.g_varchar2 ,
330 p_val_220 in varchar2 default hr_api.g_varchar2 ,
331 p_val_221 in varchar2 default hr_api.g_varchar2 ,
332 p_val_222 in varchar2 default hr_api.g_varchar2 ,
333 p_val_223 in varchar2 default hr_api.g_varchar2 ,
334 p_val_224 in varchar2 default hr_api.g_varchar2 ,
335 p_val_225 in varchar2 default hr_api.g_varchar2 ,
336 p_val_226 in varchar2 default hr_api.g_varchar2 ,
337 p_val_227 in varchar2 default hr_api.g_varchar2 ,
338 p_val_228 in varchar2 default hr_api.g_varchar2 ,
339 p_val_229 in varchar2 default hr_api.g_varchar2 ,
340 p_val_230 in varchar2 default hr_api.g_varchar2 ,
341 p_val_231 in varchar2 default hr_api.g_varchar2 ,
342 p_val_232 in varchar2 default hr_api.g_varchar2 ,
343 p_val_233 in varchar2 default hr_api.g_varchar2 ,
344 p_val_234 in varchar2 default hr_api.g_varchar2 ,
345 p_val_235 in varchar2 default hr_api.g_varchar2 ,
346 p_val_236 in varchar2 default hr_api.g_varchar2 ,
347 p_val_237 in varchar2 default hr_api.g_varchar2 ,
348 p_val_238 in varchar2 default hr_api.g_varchar2 ,
349 p_val_239 in varchar2 default hr_api.g_varchar2 ,
350 p_val_240 in varchar2 default hr_api.g_varchar2 ,
351 p_val_241 in varchar2 default hr_api.g_varchar2 ,
352 p_val_242 in varchar2 default hr_api.g_varchar2 ,
353 p_val_243 in varchar2 default hr_api.g_varchar2 ,
354 p_val_244 in varchar2 default hr_api.g_varchar2 ,
355 p_val_245 in varchar2 default hr_api.g_varchar2 ,
356 p_val_246 in varchar2 default hr_api.g_varchar2 ,
357 p_val_247 in varchar2 default hr_api.g_varchar2 ,
358 p_val_248 in varchar2 default hr_api.g_varchar2 ,
359 p_val_249 in varchar2 default hr_api.g_varchar2 ,
360 p_val_250 in varchar2 default hr_api.g_varchar2 ,
361 p_val_251 in varchar2 default hr_api.g_varchar2 ,
362 p_val_252 in varchar2 default hr_api.g_varchar2 ,
363 p_val_253 in varchar2 default hr_api.g_varchar2 ,
364 p_val_254 in varchar2 default hr_api.g_varchar2 ,
365 p_val_255 in varchar2 default hr_api.g_varchar2 ,
366 p_val_256 in varchar2 default hr_api.g_varchar2 ,
367 p_val_257 in varchar2 default hr_api.g_varchar2 ,
368 p_val_258 in varchar2 default hr_api.g_varchar2 ,
369 p_val_259 in varchar2 default hr_api.g_varchar2 ,
370 p_val_260 in varchar2 default hr_api.g_varchar2 ,
371 p_val_261 in varchar2 default hr_api.g_varchar2 ,
372 p_val_262 in varchar2 default hr_api.g_varchar2 ,
373 p_val_263 in varchar2 default hr_api.g_varchar2 ,
374 p_val_264 in varchar2 default hr_api.g_varchar2 ,
375 p_val_265 in varchar2 default hr_api.g_varchar2 ,
376 p_val_266 in varchar2 default hr_api.g_varchar2 ,
377 p_val_267 in varchar2 default hr_api.g_varchar2 ,
378 p_val_268 in varchar2 default hr_api.g_varchar2 ,
379 p_val_269 in varchar2 default hr_api.g_varchar2 ,
380 p_val_270 in varchar2 default hr_api.g_varchar2 ,
381 p_val_271 in varchar2 default hr_api.g_varchar2 ,
382 p_val_272 in varchar2 default hr_api.g_varchar2 ,
383 p_val_273 in varchar2 default hr_api.g_varchar2 ,
384 p_val_274 in varchar2 default hr_api.g_varchar2 ,
385 p_val_275 in varchar2 default hr_api.g_varchar2 ,
386 p_val_276 in varchar2 default hr_api.g_varchar2 ,
387 p_val_277 in varchar2 default hr_api.g_varchar2 ,
388 p_val_278 in varchar2 default hr_api.g_varchar2 ,
389 p_val_279 in varchar2 default hr_api.g_varchar2 ,
390 p_val_280 in varchar2 default hr_api.g_varchar2 ,
391 p_val_281 in varchar2 default hr_api.g_varchar2 ,
392 p_val_282 in varchar2 default hr_api.g_varchar2 ,
393 p_val_283 in varchar2 default hr_api.g_varchar2 ,
394 p_val_284 in varchar2 default hr_api.g_varchar2 ,
395 p_val_285 in varchar2 default hr_api.g_varchar2 ,
396 p_val_286 in varchar2 default hr_api.g_varchar2 ,
397 p_val_287 in varchar2 default hr_api.g_varchar2 ,
398 p_val_288 in varchar2 default hr_api.g_varchar2 ,
399 p_val_289 in varchar2 default hr_api.g_varchar2 ,
400 p_val_290 in varchar2 default hr_api.g_varchar2 ,
401 p_val_291 in varchar2 default hr_api.g_varchar2 ,
402 p_val_292 in varchar2 default hr_api.g_varchar2 ,
403 p_val_293 in varchar2 default hr_api.g_varchar2 ,
404 p_val_294 in varchar2 default hr_api.g_varchar2 ,
405 p_val_295 in varchar2 default hr_api.g_varchar2 ,
406 p_val_296 in varchar2 default hr_api.g_varchar2 ,
407 p_val_297 in varchar2 default hr_api.g_varchar2 ,
408 p_val_298 in varchar2 default hr_api.g_varchar2 ,
409 p_val_299 in varchar2 default hr_api.g_varchar2 ,
410 p_val_300 in varchar2 default hr_api.g_varchar2 ,
411 p_group_val_01 in varchar2 default hr_api.g_varchar2,
412 p_group_val_02 in varchar2 default hr_api.g_varchar2,
413 p_program_application_id in number default hr_api.g_number,
414 p_program_id in number default hr_api.g_number,
415 p_program_update_date in date default hr_api.g_date,
416 p_request_id in number default hr_api.g_number,
417 p_object_version_number in out nocopy number ,
418 p_ext_rcd_in_file_id in number default hr_api.g_number
419 );
420 --
421 end ben_xrd_upd;