4 -- ----------------------------------------------------------------------------
1 Package ben_copy_entity_results_api AUTHID CURRENT_USER as
2 /* $Header: becpeapi.pkh 120.0 2005/05/28 01:12:11 appldev noship $ */
3 --
5 -- |------------------------< create_copy_entity_results >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
18 -- p_result_type_cd No varchar2
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_copy_entity_txn_id Yes number
19 -- p_number_of_copies No varchar2
20 -- p_status No varchar2
21 -- p_src_copy_entity_result_id No number
22 -- Name Reqd Type Description
23 -- p_validate Yes boolean Commit or Rollback.
24 -- p_effective_date yes date
25 -- p_copy_entity_txn_id yes number
26 -- p_result_type_cd yes varchar2
27 -- p_src_copy_entity_result_id no number
28 -- p_number_of_copies no number
29 -- p_mirror_entity_result_id no number
30 -- p_mirror_src_entity_result_id no number
31 -- p_parent_entity_result_id no number
32 -- p_pd_mirror_src_entity_result_ no number
33 -- p_pd_parent_entity_result_id no number
34 -- p_gs_mirror_src_entity_result_ no number
35 -- p_gs_parent_entity_result_id no number
36 -- p_table_name no varchar2
37 -- p_table_alias no varchar2
38 -- p_table_route_id no number
39 -- p_status no varchar2
40 -- p_dml_operation no varchar2
41 -- p_information_category no varchar2
42 -- p_information1 no number
43 -- p_information2 no date
44 -- p_information3 no date
45 -- p_information4 no number
46 -- p_information5 no varchar2
47 -- ..
48 -- p_information9 no varchar2
49 -- p_information10 no date
50 -- p_information11 no varchar2
51 -- ..
52 -- p_information159 no varchar2
53 -- p_information160 no number
54 -- ..
55 -- p_information165 no number
56 -- p_information166 no date
57 -- p_information167 no date
58 -- p_information168 no date
59 -- p_information169 no number
60 -- p_information170 no varchar2
61 -- ..
62 -- p_information173 no varchar2
63 -- p_information174 no number
64 -- p_information175 no varchar2
65 -- p_information176 no number
66 -- p_information177 no varchar2
67 -- p_information178 no number
68 -- p_information179 no varchar2
69 -- p_information180 no number
70 -- ..
71 -- p_information219 no varchar2
72 -- p_information220 no varchar2
73 -- p_information221 no number
74 -- ..
75 -- p_information305 no number
76 -- p_information306 no date
77 -- ..
78 -- p_information321 no date
79 -- p_information322 no date
80 -- p_datetrack_mode no varchar2
81 -- p_copy_entity_result_id yes nocopy number
82 -- p_object_version_number yes nocopy number
83 -- p_effective_date Yes date Session Date.
84 --
85 -- Post Success:
86 --
87 -- Out Parameters:
88 -- Name Type Description
89 -- p_copy_entity_result_id Yes number PK of record
90 -- p_object_version_number Yes number OVN of record
91 --
92 -- Post Failure:
93 --
94 -- Access Status:
95 -- Public.
96 --
97 -- {End Of Comments}
98 --
99 procedure create_copy_entity_results
100 (p_validate in boolean default false
101 ,p_effective_date in date
102 ,p_copy_entity_txn_id in number
103 ,p_result_type_cd in varchar2
104 ,p_src_copy_entity_result_id in number default null
105 ,p_number_of_copies in number default null
106 ,p_mirror_entity_result_id in number default null
107 ,p_mirror_src_entity_result_id in number default null
108 ,p_parent_entity_result_id in number default null
109 ,p_pd_mr_src_entity_result_id in number default null
110 ,p_pd_parent_entity_result_id in number default null
111 ,p_gs_mr_src_entity_result_id in number default null
112 ,p_gs_parent_entity_result_id in number default null
113 ,p_table_name in varchar2 default null
114 ,p_table_alias in varchar2 default null
115 ,p_table_route_id in number default null
116 ,p_status in varchar2 default null
117 ,p_dml_operation in varchar2 default null
118 ,p_information_category in varchar2 default null
119 ,p_information1 in number default null
120 ,p_information2 in date default null
121 ,p_information3 in date default null
122 ,p_information4 in number default null
123 ,p_information5 in varchar2 default null
124 ,p_information6 in varchar2 default null
125 ,p_information7 in varchar2 default null
126 ,p_information8 in varchar2 default null
130 ,p_information12 in varchar2 default null
127 ,p_information9 in varchar2 default null
128 ,p_information10 in date default null
129 ,p_information11 in varchar2 default null
131 ,p_information13 in varchar2 default null
132 ,p_information14 in varchar2 default null
133 ,p_information15 in varchar2 default null
134 ,p_information16 in varchar2 default null
135 ,p_information17 in varchar2 default null
136 ,p_information18 in varchar2 default null
137 ,p_information19 in varchar2 default null
138 ,p_information20 in varchar2 default null
139 ,p_information21 in varchar2 default null
140 ,p_information22 in varchar2 default null
141 ,p_information23 in varchar2 default null
142 ,p_information24 in varchar2 default null
143 ,p_information25 in varchar2 default null
144 ,p_information26 in varchar2 default null
145 ,p_information27 in varchar2 default null
146 ,p_information28 in varchar2 default null
147 ,p_information29 in varchar2 default null
148 ,p_information30 in varchar2 default null
149 ,p_information31 in varchar2 default null
150 ,p_information32 in varchar2 default null
151 ,p_information33 in varchar2 default null
152 ,p_information34 in varchar2 default null
153 ,p_information35 in varchar2 default null
154 ,p_information36 in varchar2 default null
155 ,p_information37 in varchar2 default null
156 ,p_information38 in varchar2 default null
157 ,p_information39 in varchar2 default null
158 ,p_information40 in varchar2 default null
159 ,p_information41 in varchar2 default null
160 ,p_information42 in varchar2 default null
161 ,p_information43 in varchar2 default null
162 ,p_information44 in varchar2 default null
163 ,p_information45 in varchar2 default null
164 ,p_information46 in varchar2 default null
165 ,p_information47 in varchar2 default null
166 ,p_information48 in varchar2 default null
167 ,p_information49 in varchar2 default null
168 ,p_information50 in varchar2 default null
169 ,p_information51 in varchar2 default null
170 ,p_information52 in varchar2 default null
171 ,p_information53 in varchar2 default null
172 ,p_information54 in varchar2 default null
173 ,p_information55 in varchar2 default null
174 ,p_information56 in varchar2 default null
175 ,p_information57 in varchar2 default null
176 ,p_information58 in varchar2 default null
177 ,p_information59 in varchar2 default null
178 ,p_information60 in varchar2 default null
179 ,p_information61 in varchar2 default null
180 ,p_information62 in varchar2 default null
181 ,p_information63 in varchar2 default null
182 ,p_information64 in varchar2 default null
183 ,p_information65 in varchar2 default null
184 ,p_information66 in varchar2 default null
185 ,p_information67 in varchar2 default null
186 ,p_information68 in varchar2 default null
187 ,p_information69 in varchar2 default null
188 ,p_information70 in varchar2 default null
189 ,p_information71 in varchar2 default null
190 ,p_information72 in varchar2 default null
191 ,p_information73 in varchar2 default null
192 ,p_information74 in varchar2 default null
193 ,p_information75 in varchar2 default null
194 ,p_information76 in varchar2 default null
195 ,p_information77 in varchar2 default null
196 ,p_information78 in varchar2 default null
197 ,p_information79 in varchar2 default null
198 ,p_information80 in varchar2 default null
199 ,p_information81 in varchar2 default null
200 ,p_information82 in varchar2 default null
201 ,p_information83 in varchar2 default null
202 ,p_information84 in varchar2 default null
203 ,p_information85 in varchar2 default null
204 ,p_information86 in varchar2 default null
205 ,p_information87 in varchar2 default null
206 ,p_information88 in varchar2 default null
207 ,p_information89 in varchar2 default null
208 ,p_information90 in varchar2 default null
209 ,p_information91 in varchar2 default null
210 ,p_information92 in varchar2 default null
211 ,p_information93 in varchar2 default null
212 ,p_information94 in varchar2 default null
213 ,p_information95 in varchar2 default null
214 ,p_information96 in varchar2 default null
215 ,p_information97 in varchar2 default null
219 ,p_information101 in varchar2 default null
216 ,p_information98 in varchar2 default null
217 ,p_information99 in varchar2 default null
218 ,p_information100 in varchar2 default null
220 ,p_information102 in varchar2 default null
221 ,p_information103 in varchar2 default null
222 ,p_information104 in varchar2 default null
223 ,p_information105 in varchar2 default null
224 ,p_information106 in varchar2 default null
225 ,p_information107 in varchar2 default null
226 ,p_information108 in varchar2 default null
227 ,p_information109 in varchar2 default null
228 ,p_information110 in varchar2 default null
229 ,p_information111 in varchar2 default null
230 ,p_information112 in varchar2 default null
231 ,p_information113 in varchar2 default null
232 ,p_information114 in varchar2 default null
233 ,p_information115 in varchar2 default null
234 ,p_information116 in varchar2 default null
235 ,p_information117 in varchar2 default null
236 ,p_information118 in varchar2 default null
237 ,p_information119 in varchar2 default null
238 ,p_information120 in varchar2 default null
239 ,p_information121 in varchar2 default null
240 ,p_information122 in varchar2 default null
241 ,p_information123 in varchar2 default null
242 ,p_information124 in varchar2 default null
243 ,p_information125 in varchar2 default null
244 ,p_information126 in varchar2 default null
245 ,p_information127 in varchar2 default null
246 ,p_information128 in varchar2 default null
247 ,p_information129 in varchar2 default null
248 ,p_information130 in varchar2 default null
249 ,p_information131 in varchar2 default null
250 ,p_information132 in varchar2 default null
251 ,p_information133 in varchar2 default null
252 ,p_information134 in varchar2 default null
253 ,p_information135 in varchar2 default null
254 ,p_information136 in varchar2 default null
255 ,p_information137 in varchar2 default null
256 ,p_information138 in varchar2 default null
257 ,p_information139 in varchar2 default null
258 ,p_information140 in varchar2 default null
259 ,p_information141 in varchar2 default null
260 ,p_information142 in varchar2 default null
261
262 /* Extra Reserved Columns
263 ,p_information143 in varchar2 default null
264 ,p_information144 in varchar2 default null
265 ,p_information145 in varchar2 default null
266 ,p_information146 in varchar2 default null
267 ,p_information147 in varchar2 default null
268 ,p_information148 in varchar2 default null
269 ,p_information149 in varchar2 default null
270 ,p_information150 in varchar2 default null
271 */
272 ,p_information151 in varchar2 default null
273 ,p_information152 in varchar2 default null
274 ,p_information153 in varchar2 default null
275
276 /* Extra Reserved Columns
277 ,p_information154 in varchar2 default null
278 ,p_information155 in varchar2 default null
279 ,p_information156 in varchar2 default null
280 ,p_information157 in varchar2 default null
281 ,p_information158 in varchar2 default null
282 ,p_information159 in varchar2 default null
283 */
284 ,p_information160 in number default null
285 ,p_information161 in number default null
286 ,p_information162 in number default null
287
288 /* Extra Reserved Columns
289 ,p_information163 in number default null
290 ,p_information164 in number default null
291 ,p_information165 in number default null
292 */
293 ,p_information166 in date default null
294 ,p_information167 in date default null
295 ,p_information168 in date default null
296 ,p_information169 in number default null
297 ,p_information170 in varchar2 default null
298
299 /* Extra Reserved Columns
300 ,p_information171 in varchar2 default null
301 ,p_information172 in varchar2 default null
302 */
303 ,p_information173 in varchar2 default null
304 ,p_information174 in number default null
305 ,p_information175 in varchar2 default null
306 ,p_information176 in number default null
307 ,p_information177 in varchar2 default null
308 ,p_information178 in number default null
309 ,p_information179 in varchar2 default null
310 ,p_information180 in number default null
311 ,p_information181 in varchar2 default null
312 ,p_information182 in varchar2 default null
313
314 /* Extra Reserved Columns
318 ,p_information185 in varchar2 default null
315 ,p_information183 in varchar2 default null
316 ,p_information184 in varchar2 default null
317 */
319 ,p_information186 in varchar2 default null
320 ,p_information187 in varchar2 default null
321 ,p_information188 in varchar2 default null
322
323 /* Extra Reserved Columns
324 ,p_information189 in varchar2 default null
325 */
326 ,p_information190 in varchar2 default null
327 ,p_information191 in varchar2 default null
328 ,p_information192 in varchar2 default null
329 ,p_information193 in varchar2 default null
330 ,p_information194 in varchar2 default null
331 ,p_information195 in varchar2 default null
332 ,p_information196 in varchar2 default null
333 ,p_information197 in varchar2 default null
334 ,p_information198 in varchar2 default null
335 ,p_information199 in varchar2 default null
336
337 /* Extra Reserved Columns
338 ,p_information200 in varchar2 default null
339 ,p_information201 in varchar2 default null
340 ,p_information202 in varchar2 default null
341 ,p_information203 in varchar2 default null
342 ,p_information204 in varchar2 default null
343 ,p_information205 in varchar2 default null
344 ,p_information206 in varchar2 default null
345 ,p_information207 in varchar2 default null
346 ,p_information208 in varchar2 default null
347 ,p_information209 in varchar2 default null
348 ,p_information210 in varchar2 default null
349 ,p_information211 in varchar2 default null
350 ,p_information212 in varchar2 default null
351 ,p_information213 in varchar2 default null
352 ,p_information214 in varchar2 default null
353 ,p_information215 in varchar2 default null
354 */
355 ,p_information216 in varchar2 default null
356 ,p_information217 in varchar2 default null
357 ,p_information218 in varchar2 default null
358 ,p_information219 in varchar2 default null
359 ,p_information220 in varchar2 default null
360 ,p_information221 in number default null
361 ,p_information222 in number default null
362 ,p_information223 in number default null
363 ,p_information224 in number default null
364 ,p_information225 in number default null
365 ,p_information226 in number default null
366 ,p_information227 in number default null
367 ,p_information228 in number default null
368 ,p_information229 in number default null
369 ,p_information230 in number default null
370 ,p_information231 in number default null
371 ,p_information232 in number default null
372 ,p_information233 in number default null
373 ,p_information234 in number default null
374 ,p_information235 in number default null
375 ,p_information236 in number default null
376 ,p_information237 in number default null
377 ,p_information238 in number default null
378 ,p_information239 in number default null
379 ,p_information240 in number default null
380 ,p_information241 in number default null
381 ,p_information242 in number default null
382 ,p_information243 in number default null
383 ,p_information244 in number default null
384 ,p_information245 in number default null
385 ,p_information246 in number default null
386 ,p_information247 in number default null
387 ,p_information248 in number default null
388 ,p_information249 in number default null
389 ,p_information250 in number default null
390 ,p_information251 in number default null
391 ,p_information252 in number default null
392 ,p_information253 in number default null
393 ,p_information254 in number default null
394 ,p_information255 in number default null
395 ,p_information256 in number default null
396 ,p_information257 in number default null
397 ,p_information258 in number default null
398 ,p_information259 in number default null
399 ,p_information260 in number default null
400 ,p_information261 in number default null
401 ,p_information262 in number default null
402 ,p_information263 in number default null
403 ,p_information264 in number default null
404 ,p_information265 in number default null
405 ,p_information266 in number default null
406 ,p_information267 in number default null
407 ,p_information268 in number default null
408 ,p_information269 in number default null
412 ,p_information273 in number default null
409 ,p_information270 in number default null
410 ,p_information271 in number default null
411 ,p_information272 in number default null
413 ,p_information274 in number default null
414 ,p_information275 in number default null
415 ,p_information276 in number default null
416 ,p_information277 in number default null
417 ,p_information278 in number default null
418 ,p_information279 in number default null
419 ,p_information280 in number default null
420 ,p_information281 in number default null
421 ,p_information282 in number default null
422 ,p_information283 in number default null
423 ,p_information284 in number default null
424 ,p_information285 in number default null
425 ,p_information286 in number default null
426 ,p_information287 in number default null
427 ,p_information288 in number default null
428 ,p_information289 in number default null
429 ,p_information290 in number default null
430 ,p_information291 in number default null
431 ,p_information292 in number default null
432 ,p_information293 in number default null
433 ,p_information294 in number default null
434 ,p_information295 in number default null
435 ,p_information296 in number default null
436 ,p_information297 in number default null
437 ,p_information298 in number default null
438 ,p_information299 in number default null
439 ,p_information300 in number default null
440 ,p_information301 in number default null
441 ,p_information302 in number default null
442 ,p_information303 in number default null
443 ,p_information304 in number default null
444
445 /* Extra Reserved Columns
446 ,p_information305 in number default null
447 */
448 ,p_information306 in date default null
449 ,p_information307 in date default null
450 ,p_information308 in date default null
451 ,p_information309 in date default null
452 ,p_information310 in date default null
453 ,p_information311 in date default null
454 ,p_information312 in date default null
455 ,p_information313 in date default null
456 ,p_information314 in date default null
457 ,p_information315 in date default null
458 ,p_information316 in date default null
459 ,p_information317 in date default null
460 ,p_information318 in date default null
461 ,p_information319 in date default null
462 ,p_information320 in date default null
463
464 /* Extra Reserved Columns
465 ,p_information321 in date default null
466 ,p_information322 in date default null
467 */
468 ,p_information323 in long default null
469 ,p_datetrack_mode in varchar2 default null
470 ,p_copy_entity_result_id out nocopy number
471 ,p_object_version_number out nocopy number
472 );
473 -- ----------------------------------------------------------------------------
474 -- |------------------------< update_copy_entity_results >------------------------|
475 -- ----------------------------------------------------------------------------
476 -- {Start Of Comments}
477 --
478 -- Description:
479 --
480 -- Prerequisites:
481 --
482 --
483 -- In Parameters:
484 -- Name Reqd Type Description
485 -- p_validate Yes boolean Commit or Rollback.
486 -- p_copy_entity_result_id Yes number PK of record
487 -- p_copy_entity_txn_id Yes number
488 -- p_number_of_copies No varchar2
489 -- p_status No varchar2
490 -- p_src_copy_entity_result_id No number
491 -- p_result_type_cd yes varchar2
492 -- p_mirror_entity_result_id no number
493 -- p_mirror_src_entity_result_id no number
494 -- p_parent_entity_result_id no number
495 -- p_pd_mirror_src_entity_result_ no number
496 -- p_pd_parent_entity_result_id no number
497 -- p_gs_mirror_src_entity_result_ no number
498 -- p_gs_parent_entity_result_id no number
499 -- p_table_name no varchar2
500 -- p_table_alias no varchar2
501 -- p_table_route_id no number
502 -- p_status no varchar2
503 -- p_dml_operation no varchar2
504 -- p_information_category no varchar2
505 -- p_information1 no number
506 -- p_information2 no date
507 -- p_information3 no date
508 -- p_information4 no number
509 -- p_information5 no varchar2
510 -- ..
511 -- p_information9 no varchar2
512 -- p_information10 no date
516 -- p_information160 no number
513 -- p_information11 no varchar2
514 -- ..
515 -- p_information159 no varchar2
517 -- ..
518 -- p_information165 no number
519 -- p_information166 no date
520 -- p_information167 no date
521 -- p_information168 no date
522 -- p_information169 no number
523 -- p_information170 no varchar2
524 -- ..
525 -- p_information173 no varchar2
526 -- p_information174 no number
527 -- p_information175 no varchar2
528 -- p_information176 no number
529 -- p_information177 no varchar2
530 -- p_information178 no number
531 -- p_information179 no varchar2
532 -- p_information180 no number
533 -- ..
534 -- p_information219 no varchar2
535 -- p_information220 no varchar2
536 -- p_information221 no number
537 -- ..
538 -- p_information305 no number
539 -- p_information306 no date
540 -- ..
541 -- p_information321 no date
542 -- p_information322 no date
543 -- p_datetrack_mode no varchar2
544 -- p_object_version_number yes nocopy number
545 -- p_effective_date Yes date Session Date.
546 --
547 -- Post Success:
548 --
549 -- Name Type Description
550 -- p_object_version_number Yes number OVN of record
551 --
552 -- Post Failure:
553 --
554 -- Access Status:
555 -- Public.
556 --
557 -- {End Of Comments}
558 --
559 procedure update_copy_entity_results
560 (p_validate in boolean default false
561 ,p_effective_date in date
562 ,p_copy_entity_result_id in number
563 ,p_object_version_number in out nocopy number
564 ,p_copy_entity_txn_id in number default hr_api.g_number
565 ,p_result_type_cd in varchar2 default hr_api.g_varchar2
566 ,p_src_copy_entity_result_id in number default hr_api.g_number
567 ,p_number_of_copies in number default hr_api.g_number
568 ,p_mirror_entity_result_id in number default hr_api.g_number
569 ,p_mirror_src_entity_result_id in number default hr_api.g_number
570 ,p_parent_entity_result_id in number default hr_api.g_number
571 ,p_pd_mr_src_entity_result_id in number default hr_api.g_number
572 ,p_pd_parent_entity_result_id in number default hr_api.g_number
573 ,p_gs_mr_src_entity_result_id in number default hr_api.g_number
574 ,p_gs_parent_entity_result_id in number default hr_api.g_number
575 ,p_table_name in varchar2 default hr_api.g_varchar2
576 ,p_table_alias in varchar2 default hr_api.g_varchar2
577 ,p_table_route_id in number default hr_api.g_number
578 ,p_status in varchar2 default hr_api.g_varchar2
579 ,p_dml_operation in varchar2 default hr_api.g_varchar2
580 ,p_information_category in varchar2 default hr_api.g_varchar2
581 ,p_information1 in number default hr_api.g_number
582 ,p_information2 in date default hr_api.g_date
583 ,p_information3 in date default hr_api.g_date
584 ,p_information4 in number default hr_api.g_number
585 ,p_information5 in varchar2 default hr_api.g_varchar2
586 ,p_information6 in varchar2 default hr_api.g_varchar2
587 ,p_information7 in varchar2 default hr_api.g_varchar2
588 ,p_information8 in varchar2 default hr_api.g_varchar2
589 ,p_information9 in varchar2 default hr_api.g_varchar2
590 ,p_information10 in date default hr_api.g_date
591 ,p_information11 in varchar2 default hr_api.g_varchar2
592 ,p_information12 in varchar2 default hr_api.g_varchar2
593 ,p_information13 in varchar2 default hr_api.g_varchar2
594 ,p_information14 in varchar2 default hr_api.g_varchar2
595 ,p_information15 in varchar2 default hr_api.g_varchar2
596 ,p_information16 in varchar2 default hr_api.g_varchar2
597 ,p_information17 in varchar2 default hr_api.g_varchar2
598 ,p_information18 in varchar2 default hr_api.g_varchar2
599 ,p_information19 in varchar2 default hr_api.g_varchar2
600 ,p_information20 in varchar2 default hr_api.g_varchar2
601 ,p_information21 in varchar2 default hr_api.g_varchar2
602 ,p_information22 in varchar2 default hr_api.g_varchar2
603 ,p_information23 in varchar2 default hr_api.g_varchar2
604 ,p_information24 in varchar2 default hr_api.g_varchar2
605 ,p_information25 in varchar2 default hr_api.g_varchar2
606 ,p_information26 in varchar2 default hr_api.g_varchar2
607 ,p_information27 in varchar2 default hr_api.g_varchar2
608 ,p_information28 in varchar2 default hr_api.g_varchar2
609 ,p_information29 in varchar2 default hr_api.g_varchar2
610 ,p_information30 in varchar2 default hr_api.g_varchar2
614 ,p_information34 in varchar2 default hr_api.g_varchar2
611 ,p_information31 in varchar2 default hr_api.g_varchar2
612 ,p_information32 in varchar2 default hr_api.g_varchar2
613 ,p_information33 in varchar2 default hr_api.g_varchar2
615 ,p_information35 in varchar2 default hr_api.g_varchar2
616 ,p_information36 in varchar2 default hr_api.g_varchar2
617 ,p_information37 in varchar2 default hr_api.g_varchar2
618 ,p_information38 in varchar2 default hr_api.g_varchar2
619 ,p_information39 in varchar2 default hr_api.g_varchar2
620 ,p_information40 in varchar2 default hr_api.g_varchar2
621 ,p_information41 in varchar2 default hr_api.g_varchar2
622 ,p_information42 in varchar2 default hr_api.g_varchar2
623 ,p_information43 in varchar2 default hr_api.g_varchar2
624 ,p_information44 in varchar2 default hr_api.g_varchar2
625 ,p_information45 in varchar2 default hr_api.g_varchar2
626 ,p_information46 in varchar2 default hr_api.g_varchar2
627 ,p_information47 in varchar2 default hr_api.g_varchar2
628 ,p_information48 in varchar2 default hr_api.g_varchar2
629 ,p_information49 in varchar2 default hr_api.g_varchar2
630 ,p_information50 in varchar2 default hr_api.g_varchar2
631 ,p_information51 in varchar2 default hr_api.g_varchar2
632 ,p_information52 in varchar2 default hr_api.g_varchar2
633 ,p_information53 in varchar2 default hr_api.g_varchar2
634 ,p_information54 in varchar2 default hr_api.g_varchar2
635 ,p_information55 in varchar2 default hr_api.g_varchar2
636 ,p_information56 in varchar2 default hr_api.g_varchar2
637 ,p_information57 in varchar2 default hr_api.g_varchar2
638 ,p_information58 in varchar2 default hr_api.g_varchar2
639 ,p_information59 in varchar2 default hr_api.g_varchar2
640 ,p_information60 in varchar2 default hr_api.g_varchar2
641 ,p_information61 in varchar2 default hr_api.g_varchar2
642 ,p_information62 in varchar2 default hr_api.g_varchar2
643 ,p_information63 in varchar2 default hr_api.g_varchar2
644 ,p_information64 in varchar2 default hr_api.g_varchar2
645 ,p_information65 in varchar2 default hr_api.g_varchar2
646 ,p_information66 in varchar2 default hr_api.g_varchar2
647 ,p_information67 in varchar2 default hr_api.g_varchar2
648 ,p_information68 in varchar2 default hr_api.g_varchar2
649 ,p_information69 in varchar2 default hr_api.g_varchar2
650 ,p_information70 in varchar2 default hr_api.g_varchar2
651 ,p_information71 in varchar2 default hr_api.g_varchar2
652 ,p_information72 in varchar2 default hr_api.g_varchar2
653 ,p_information73 in varchar2 default hr_api.g_varchar2
654 ,p_information74 in varchar2 default hr_api.g_varchar2
655 ,p_information75 in varchar2 default hr_api.g_varchar2
656 ,p_information76 in varchar2 default hr_api.g_varchar2
657 ,p_information77 in varchar2 default hr_api.g_varchar2
658 ,p_information78 in varchar2 default hr_api.g_varchar2
659 ,p_information79 in varchar2 default hr_api.g_varchar2
660 ,p_information80 in varchar2 default hr_api.g_varchar2
661 ,p_information81 in varchar2 default hr_api.g_varchar2
662 ,p_information82 in varchar2 default hr_api.g_varchar2
663 ,p_information83 in varchar2 default hr_api.g_varchar2
664 ,p_information84 in varchar2 default hr_api.g_varchar2
665 ,p_information85 in varchar2 default hr_api.g_varchar2
666 ,p_information86 in varchar2 default hr_api.g_varchar2
667 ,p_information87 in varchar2 default hr_api.g_varchar2
668 ,p_information88 in varchar2 default hr_api.g_varchar2
669 ,p_information89 in varchar2 default hr_api.g_varchar2
670 ,p_information90 in varchar2 default hr_api.g_varchar2
671 ,p_information91 in varchar2 default hr_api.g_varchar2
672 ,p_information92 in varchar2 default hr_api.g_varchar2
673 ,p_information93 in varchar2 default hr_api.g_varchar2
674 ,p_information94 in varchar2 default hr_api.g_varchar2
675 ,p_information95 in varchar2 default hr_api.g_varchar2
676 ,p_information96 in varchar2 default hr_api.g_varchar2
677 ,p_information97 in varchar2 default hr_api.g_varchar2
678 ,p_information98 in varchar2 default hr_api.g_varchar2
679 ,p_information99 in varchar2 default hr_api.g_varchar2
680 ,p_information100 in varchar2 default hr_api.g_varchar2
681 ,p_information101 in varchar2 default hr_api.g_varchar2
682 ,p_information102 in varchar2 default hr_api.g_varchar2
683 ,p_information103 in varchar2 default hr_api.g_varchar2
684 ,p_information104 in varchar2 default hr_api.g_varchar2
685 ,p_information105 in varchar2 default hr_api.g_varchar2
689 ,p_information109 in varchar2 default hr_api.g_varchar2
686 ,p_information106 in varchar2 default hr_api.g_varchar2
687 ,p_information107 in varchar2 default hr_api.g_varchar2
688 ,p_information108 in varchar2 default hr_api.g_varchar2
690 ,p_information110 in varchar2 default hr_api.g_varchar2
691 ,p_information111 in varchar2 default hr_api.g_varchar2
692 ,p_information112 in varchar2 default hr_api.g_varchar2
693 ,p_information113 in varchar2 default hr_api.g_varchar2
694 ,p_information114 in varchar2 default hr_api.g_varchar2
695 ,p_information115 in varchar2 default hr_api.g_varchar2
696 ,p_information116 in varchar2 default hr_api.g_varchar2
700 ,p_information120 in varchar2 default hr_api.g_varchar2
697 ,p_information117 in varchar2 default hr_api.g_varchar2
698 ,p_information118 in varchar2 default hr_api.g_varchar2
699 ,p_information119 in varchar2 default hr_api.g_varchar2
701 ,p_information121 in varchar2 default hr_api.g_varchar2
702 ,p_information122 in varchar2 default hr_api.g_varchar2
703 ,p_information123 in varchar2 default hr_api.g_varchar2
704 ,p_information124 in varchar2 default hr_api.g_varchar2
705 ,p_information125 in varchar2 default hr_api.g_varchar2
706 ,p_information126 in varchar2 default hr_api.g_varchar2
707 ,p_information127 in varchar2 default hr_api.g_varchar2
708 ,p_information128 in varchar2 default hr_api.g_varchar2
709 ,p_information129 in varchar2 default hr_api.g_varchar2
710 ,p_information130 in varchar2 default hr_api.g_varchar2
711 ,p_information131 in varchar2 default hr_api.g_varchar2
712 ,p_information132 in varchar2 default hr_api.g_varchar2
713 ,p_information133 in varchar2 default hr_api.g_varchar2
714 ,p_information134 in varchar2 default hr_api.g_varchar2
715 ,p_information135 in varchar2 default hr_api.g_varchar2
716 ,p_information136 in varchar2 default hr_api.g_varchar2
717 ,p_information137 in varchar2 default hr_api.g_varchar2
718 ,p_information138 in varchar2 default hr_api.g_varchar2
719 ,p_information139 in varchar2 default hr_api.g_varchar2
720 ,p_information140 in varchar2 default hr_api.g_varchar2
721 ,p_information141 in varchar2 default hr_api.g_varchar2
722 ,p_information142 in varchar2 default hr_api.g_varchar2
723
724 /* Extra Reserved Columns
725 ,p_information143 in varchar2 default hr_api.g_varchar2
726 ,p_information144 in varchar2 default hr_api.g_varchar2
727 ,p_information145 in varchar2 default hr_api.g_varchar2
728 ,p_information146 in varchar2 default hr_api.g_varchar2
729 ,p_information147 in varchar2 default hr_api.g_varchar2
730 ,p_information148 in varchar2 default hr_api.g_varchar2
731 ,p_information149 in varchar2 default hr_api.g_varchar2
732 ,p_information150 in varchar2 default hr_api.g_varchar2
733 */
734 ,p_information151 in varchar2 default hr_api.g_varchar2
735 ,p_information152 in varchar2 default hr_api.g_varchar2
736 ,p_information153 in varchar2 default hr_api.g_varchar2
737
738 /* Extra Reserved Columns
739 ,p_information154 in varchar2 default hr_api.g_varchar2
740 ,p_information155 in varchar2 default hr_api.g_varchar2
741 ,p_information156 in varchar2 default hr_api.g_varchar2
742 ,p_information157 in varchar2 default hr_api.g_varchar2
743 ,p_information158 in varchar2 default hr_api.g_varchar2
744 ,p_information159 in varchar2 default hr_api.g_varchar2
745 */
746
747 ,p_information160 in number default hr_api.g_number
748 ,p_information161 in number default hr_api.g_number
749 ,p_information162 in number default hr_api.g_number
750
751 /* Extra Reserved Columns
752 ,p_information163 in number default hr_api.g_number
753 ,p_information164 in number default hr_api.g_number
754 ,p_information165 in number default hr_api.g_number
755 */
756 ,p_information166 in date default hr_api.g_date
757 ,p_information167 in date default hr_api.g_date
758 ,p_information168 in date default hr_api.g_date
759 ,p_information169 in number default hr_api.g_number
760 ,p_information170 in varchar2 default hr_api.g_varchar2
761
762 /* Extra Reserved Columns
763 ,p_information171 in varchar2 default hr_api.g_varchar2
764 ,p_information172 in varchar2 default hr_api.g_varchar2
765 */
766 ,p_information173 in varchar2 default hr_api.g_varchar2
767 ,p_information174 in number default hr_api.g_number
768 ,p_information175 in varchar2 default hr_api.g_varchar2
769 ,p_information176 in number default hr_api.g_number
770 ,p_information177 in varchar2 default hr_api.g_varchar2
771 ,p_information178 in number default hr_api.g_number
772 ,p_information179 in varchar2 default hr_api.g_varchar2
773 ,p_information180 in number default hr_api.g_number
774 ,p_information181 in varchar2 default hr_api.g_varchar2
775 ,p_information182 in varchar2 default hr_api.g_varchar2
776
777 /* Extra Reserved Columns
778 ,p_information183 in varchar2 default hr_api.g_varchar2
779 ,p_information184 in varchar2 default hr_api.g_varchar2
780 */
781 ,p_information185 in varchar2 default hr_api.g_varchar2
782 ,p_information186 in varchar2 default hr_api.g_varchar2
783 ,p_information187 in varchar2 default hr_api.g_varchar2
784 ,p_information188 in varchar2 default hr_api.g_varchar2
785
786 /* Extra Reserved Columns
790 ,p_information191 in varchar2 default hr_api.g_varchar2
787 ,p_information189 in varchar2 default hr_api.g_varchar2
788 */
789 ,p_information190 in varchar2 default hr_api.g_varchar2
791 ,p_information192 in varchar2 default hr_api.g_varchar2
792 ,p_information193 in varchar2 default hr_api.g_varchar2
793 ,p_information194 in varchar2 default hr_api.g_varchar2
794 ,p_information195 in varchar2 default hr_api.g_varchar2
795 ,p_information196 in varchar2 default hr_api.g_varchar2
796 ,p_information197 in varchar2 default hr_api.g_varchar2
797 ,p_information198 in varchar2 default hr_api.g_varchar2
798 ,p_information199 in varchar2 default hr_api.g_varchar2
799
800 /* Extra Reserved Columns
801 ,p_information200 in varchar2 default hr_api.g_varchar2
802 ,p_information201 in varchar2 default hr_api.g_varchar2
803 ,p_information202 in varchar2 default hr_api.g_varchar2
804 ,p_information203 in varchar2 default hr_api.g_varchar2
805 ,p_information204 in varchar2 default hr_api.g_varchar2
806 ,p_information205 in varchar2 default hr_api.g_varchar2
807 ,p_information206 in varchar2 default hr_api.g_varchar2
808 ,p_information207 in varchar2 default hr_api.g_varchar2
809 ,p_information208 in varchar2 default hr_api.g_varchar2
810 ,p_information209 in varchar2 default hr_api.g_varchar2
811 ,p_information210 in varchar2 default hr_api.g_varchar2
812 ,p_information211 in varchar2 default hr_api.g_varchar2
813 ,p_information212 in varchar2 default hr_api.g_varchar2
814 ,p_information213 in varchar2 default hr_api.g_varchar2
815 ,p_information214 in varchar2 default hr_api.g_varchar2
816 ,p_information215 in varchar2 default hr_api.g_varchar2
817 */
818 ,p_information216 in varchar2 default hr_api.g_varchar2
819 ,p_information217 in varchar2 default hr_api.g_varchar2
820 ,p_information218 in varchar2 default hr_api.g_varchar2
821 ,p_information219 in varchar2 default hr_api.g_varchar2
822 ,p_information220 in varchar2 default hr_api.g_varchar2
823 ,p_information221 in number default hr_api.g_number
824 ,p_information222 in number default hr_api.g_number
825 ,p_information223 in number default hr_api.g_number
826 ,p_information224 in number default hr_api.g_number
827 ,p_information225 in number default hr_api.g_number
828 ,p_information226 in number default hr_api.g_number
829 ,p_information227 in number default hr_api.g_number
830 ,p_information228 in number default hr_api.g_number
831 ,p_information229 in number default hr_api.g_number
832 ,p_information230 in number default hr_api.g_number
833 ,p_information231 in number default hr_api.g_number
834 ,p_information232 in number default hr_api.g_number
835 ,p_information233 in number default hr_api.g_number
836 ,p_information234 in number default hr_api.g_number
837 ,p_information235 in number default hr_api.g_number
838 ,p_information236 in number default hr_api.g_number
839 ,p_information237 in number default hr_api.g_number
840 ,p_information238 in number default hr_api.g_number
841 ,p_information239 in number default hr_api.g_number
842 ,p_information240 in number default hr_api.g_number
843 ,p_information241 in number default hr_api.g_number
844 ,p_information242 in number default hr_api.g_number
845 ,p_information243 in number default hr_api.g_number
846 ,p_information244 in number default hr_api.g_number
847 ,p_information245 in number default hr_api.g_number
848 ,p_information246 in number default hr_api.g_number
849 ,p_information247 in number default hr_api.g_number
850 ,p_information248 in number default hr_api.g_number
851 ,p_information249 in number default hr_api.g_number
852 ,p_information250 in number default hr_api.g_number
853 ,p_information251 in number default hr_api.g_number
854 ,p_information252 in number default hr_api.g_number
855 ,p_information253 in number default hr_api.g_number
856 ,p_information254 in number default hr_api.g_number
857 ,p_information255 in number default hr_api.g_number
858 ,p_information256 in number default hr_api.g_number
859 ,p_information257 in number default hr_api.g_number
860 ,p_information258 in number default hr_api.g_number
861 ,p_information259 in number default hr_api.g_number
862 ,p_information260 in number default hr_api.g_number
863 ,p_information261 in number default hr_api.g_number
864 ,p_information262 in number default hr_api.g_number
865 ,p_information263 in number default hr_api.g_number
866 ,p_information264 in number default hr_api.g_number
867 ,p_information265 in number default hr_api.g_number
868 ,p_information266 in number default hr_api.g_number
872 ,p_information270 in number default hr_api.g_number
869 ,p_information267 in number default hr_api.g_number
870 ,p_information268 in number default hr_api.g_number
871 ,p_information269 in number default hr_api.g_number
873 ,p_information271 in number default hr_api.g_number
874 ,p_information272 in number default hr_api.g_number
875 ,p_information273 in number default hr_api.g_number
876 ,p_information274 in number default hr_api.g_number
877 ,p_information275 in number default hr_api.g_number
878 ,p_information276 in number default hr_api.g_number
879 ,p_information277 in number default hr_api.g_number
880 ,p_information278 in number default hr_api.g_number
881 ,p_information279 in number default hr_api.g_number
882 ,p_information280 in number default hr_api.g_number
883 ,p_information281 in number default hr_api.g_number
884 ,p_information282 in number default hr_api.g_number
885 ,p_information283 in number default hr_api.g_number
886 ,p_information284 in number default hr_api.g_number
887 ,p_information285 in number default hr_api.g_number
888 ,p_information286 in number default hr_api.g_number
889 ,p_information287 in number default hr_api.g_number
890 ,p_information288 in number default hr_api.g_number
891 ,p_information289 in number default hr_api.g_number
892 ,p_information290 in number default hr_api.g_number
893 ,p_information291 in number default hr_api.g_number
894 ,p_information292 in number default hr_api.g_number
895 ,p_information293 in number default hr_api.g_number
896 ,p_information294 in number default hr_api.g_number
897 ,p_information295 in number default hr_api.g_number
898 ,p_information296 in number default hr_api.g_number
899 ,p_information297 in number default hr_api.g_number
900 ,p_information298 in number default hr_api.g_number
901 ,p_information299 in number default hr_api.g_number
902 ,p_information300 in number default hr_api.g_number
903 ,p_information301 in number default hr_api.g_number
904 ,p_information302 in number default hr_api.g_number
905 ,p_information303 in number default hr_api.g_number
906 ,p_information304 in number default hr_api.g_number
907
908 /* Extra Reserved Columns
909 ,p_information305 in number default hr_api.g_number
910 */
911 ,p_information306 in date default hr_api.g_date
912 ,p_information307 in date default hr_api.g_date
913 ,p_information308 in date default hr_api.g_date
914 ,p_information309 in date default hr_api.g_date
915 ,p_information310 in date default hr_api.g_date
916 ,p_information311 in date default hr_api.g_date
917 ,p_information312 in date default hr_api.g_date
918 ,p_information313 in date default hr_api.g_date
919 ,p_information314 in date default hr_api.g_date
920 ,p_information315 in date default hr_api.g_date
921 ,p_information316 in date default hr_api.g_date
922 ,p_information317 in date default hr_api.g_date
923 ,p_information318 in date default hr_api.g_date
924 ,p_information319 in date default hr_api.g_date
925 ,p_information320 in date default hr_api.g_date
926
927 /* Extra Reserved Columns
928 ,p_information321 in date default hr_api.g_date
929 ,p_information322 in date default hr_api.g_date
930 */
931 ,p_information323 in long
932 ,p_datetrack_mode in varchar2 default hr_api.g_varchar2
933 );
934 --
935 -- ----------------------------------------------------------------------------
936 -- |------------------------< delete_copy_entity_results >------------------------|
937 -- ----------------------------------------------------------------------------
938 -- {Start Of Comments}
939 --
940 -- Description:
941 --
942 -- Prerequisites:
943 --
944 --
945 -- In Parameters:
946 -- Name Reqd Type Description
947 -- p_validate Yes boolean Commit or Rollback.
948 -- p_copy_entity_result_id Yes number PK of record
949 -- p_effective_date Yes date Session Date.
950 --
951 -- Post Success:
952 --
953 -- Name Type Description
954 -- p_object_version_number Yes number OVN of record
955 --
956 -- Post Failure:
957 --
958 -- Access Status:
959 -- Public.
960 --
961 -- {End Of Comments}
962 --
963 procedure delete_copy_entity_results
964 (
965 p_validate in boolean default false
966 ,p_copy_entity_result_id in number
967 ,p_object_version_number in number
968 ,p_effective_date in date
969 );
970 --
971 end ben_copy_entity_results_api;