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