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