DBA Data[Home] [Help]

PACKAGE: APPS.PQH_COPY_ENTITY_RESULTS_API

Source


1 Package pqh_copy_entity_results_api as
2 /* $Header: pqcerapi.pkh 120.0 2005/05/29 01:41:11 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_copy_entity_result >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 --   Name                           Reqd Type     Description
16 --   p_validate                     Yes  boolean  Commit or Rollback.
17 --   p_copy_entity_txn_id           Yes  number
18 --   p_result_type_cd               No   varchar2
19 --   p_number_of_copies             No   varchar2
20 --   p_status                       No   varchar2
21 --   p_src_copy_entity_result_id    No   number
22 --   p_information_category         No   varchar2
23 --   p_information1                 No   varchar2
24 --   p_information2                 No   varchar2
25 --   p_information3                 No   varchar2
26 --   p_information4                 No   varchar2
27 --   p_information5                 No   varchar2
28 --   p_information6                 No   varchar2
29 --   p_information7                 No   varchar2
30 --   p_information8                 No   varchar2
31 --   p_information9                 No   varchar2
32 --   p_information10                No   varchar2
33 --   p_information11                No   varchar2
34 --   p_information12                No   varchar2
35 --   p_information13                No   varchar2
36 --   p_information14                No   varchar2
37 --   p_information15                No   varchar2
38 --   p_information16                No   varchar2
39 --   p_information17                No   varchar2
40 --   p_information18                No   varchar2
41 --   p_information19                No   varchar2
42 --   p_information20                No   varchar2
43 --   p_information21                No   varchar2
44 --   p_information22                No   varchar2
45 --   p_information23                No   varchar2
46 --   p_information24                No   varchar2
47 --   p_information25                No   varchar2
48 --   p_information26                No   varchar2
49 --   p_information27                No   varchar2
50 --   p_information28                No   varchar2
51 --   p_information29                No   varchar2
52 --   p_information30                No   varchar2
53 --   p_information31                No   varchar2
54 --   p_information32                No   varchar2
55 --   p_information33                No   varchar2
56 --   p_information34                No   varchar2
57 --   p_information35                No   varchar2
58 --   p_information36                No   varchar2
59 --   p_information37                No   varchar2
60 --   p_information38                No   varchar2
61 --   p_information39                No   varchar2
62 --   p_information40                No   varchar2
63 --   p_information41                No   varchar2
64 --   p_information42                No   varchar2
65 --   p_information43                No   varchar2
66 --   p_information44                No   varchar2
67 --   p_information45                No   varchar2
68 --   p_information46                No   varchar2
69 --   p_information47                No   varchar2
70 --   p_information48                No   varchar2
71 --   p_information49                No   varchar2
72 --   p_information50                No   varchar2
73 --   p_information51                No   varchar2
74 --   p_information52                No   varchar2
75 --   p_information53                No   varchar2
76 --   p_information54                No   varchar2
77 --   p_information55                No   varchar2
78 --   p_information56                No   varchar2
79 --   p_information57                No   varchar2
80 --   p_information58                No   varchar2
81 --   p_information59                No   varchar2
82 --   p_information60                No   varchar2
83 --   p_information61                No   varchar2
84 --   p_information62                No   varchar2
85 --   p_information63                No   varchar2
86 --   p_information64                No   varchar2
87 --   p_information65                No   varchar2
88 --   p_information66                No   varchar2
89 --   p_information67                No   varchar2
90 --   p_information68                No   varchar2
91 --   p_information69                No   varchar2
92 --   p_information70                No   varchar2
93 --   p_information71                No   varchar2
94 --   p_information72                No   varchar2
95 --   p_information73                No   varchar2
96 --   p_information74                No   varchar2
97 --   p_information75                No   varchar2
98 --   p_information76                No   varchar2
99 --   p_information77                No   varchar2
100 --   p_information78                No   varchar2
101 --   p_information79                No   varchar2
102 --   p_information80                No   varchar2
103 --   p_information81                No   varchar2
104 --   p_information82                No   varchar2
105 --   p_information83                No   varchar2
106 --   p_information84                No   varchar2
107 --   p_information85                No   varchar2
108 --   p_information86                No   varchar2
109 --   p_information87                No   varchar2
110 --   p_information88                No   varchar2
111 --   p_information89                No   varchar2
112 --   p_information90                No   varchar2
113 --   ...
114 --   p_information190               No   varchar2
115 --   p_mirror_entity_result_id      No   number
116 --   p_mirror_src_entity_result_id  No   number
117 --   p_parent_entity_result_id      No   number
118 --   p_table_route_id               No   number
119 --   p_long_attribute1              No   long
120 --   p_effective_date           Yes  date      Session Date.
121 --
122 -- Post Success:
123 --
124 -- Out Parameters:
125 --   Name                                Type     Description
126 --   p_copy_entity_result_id        Yes  number    PK of record
127 --   p_object_version_number        Yes  number    OVN of record
128 --
129 -- Post Failure:
130 --
131 -- Access Status:
132 --   Public.
133 --
134 -- {End Of Comments}
135 --
136 procedure create_copy_entity_result
137 (
138    p_validate                       in boolean    default false
139   ,p_copy_entity_result_id          out nocopy number
140   ,p_copy_entity_txn_id             in  number    default null
141   ,p_result_type_cd                 in  varchar2  default null
142   ,p_number_of_copies               in  number    default null
143   ,p_status                         in  varchar2  default null
144   ,p_src_copy_entity_result_id      in  number    default null
145   ,p_information_category           in  varchar2  default null
146   ,p_information1                   in  varchar2  default null
147   ,p_information2                   in  varchar2  default null
148   ,p_information3                   in  varchar2  default null
149   ,p_information4                   in  varchar2  default null
150   ,p_information5                   in  varchar2  default null
151   ,p_information6                   in  varchar2  default null
152   ,p_information7                   in  varchar2  default null
153   ,p_information8                   in  varchar2  default null
154   ,p_information9                   in  varchar2  default null
155   ,p_information10                  in  varchar2  default null
156   ,p_information11                  in  varchar2  default null
157   ,p_information12                  in  varchar2  default null
158   ,p_information13                  in  varchar2  default null
159   ,p_information14                  in  varchar2  default null
160   ,p_information15                  in  varchar2  default null
161   ,p_information16                  in  varchar2  default null
162   ,p_information17                  in  varchar2  default null
163   ,p_information18                  in  varchar2  default null
164   ,p_information19                  in  varchar2  default null
165   ,p_information20                  in  varchar2  default null
166   ,p_information21                  in  varchar2  default null
167   ,p_information22                  in  varchar2  default null
168   ,p_information23                  in  varchar2  default null
169   ,p_information24                  in  varchar2  default null
170   ,p_information25                  in  varchar2  default null
171   ,p_information26                  in  varchar2  default null
172   ,p_information27                  in  varchar2  default null
173   ,p_information28                  in  varchar2  default null
174   ,p_information29                  in  varchar2  default null
175   ,p_information30                  in  varchar2  default null
176   ,p_information31                  in  varchar2  default null
177   ,p_information32                  in  varchar2  default null
178   ,p_information33                  in  varchar2  default null
179   ,p_information34                  in  varchar2  default null
180   ,p_information35                  in  varchar2  default null
181   ,p_information36                  in  varchar2  default null
182   ,p_information37                  in  varchar2  default null
183   ,p_information38                  in  varchar2  default null
184   ,p_information39                  in  varchar2  default null
185   ,p_information40                  in  varchar2  default null
186   ,p_information41                  in  varchar2  default null
187   ,p_information42                  in  varchar2  default null
188   ,p_information43                  in  varchar2  default null
189   ,p_information44                  in  varchar2  default null
190   ,p_information45                  in  varchar2  default null
191   ,p_information46                  in  varchar2  default null
192   ,p_information47                  in  varchar2  default null
193   ,p_information48                  in  varchar2  default null
194   ,p_information49                  in  varchar2  default null
195   ,p_information50                  in  varchar2  default null
196   ,p_information51                  in  varchar2  default null
197   ,p_information52                  in  varchar2  default null
198   ,p_information53                  in  varchar2  default null
199   ,p_information54                  in  varchar2  default null
200   ,p_information55                  in  varchar2  default null
201   ,p_information56                  in  varchar2  default null
202   ,p_information57                  in  varchar2  default null
203   ,p_information58                  in  varchar2  default null
204   ,p_information59                  in  varchar2  default null
205   ,p_information60                  in  varchar2  default null
206   ,p_information61                  in  varchar2  default null
207   ,p_information62                  in  varchar2  default null
208   ,p_information63                  in  varchar2  default null
209   ,p_information64                  in  varchar2  default null
210   ,p_information65                  in  varchar2  default null
211   ,p_information66                  in  varchar2  default null
212   ,p_information67                  in  varchar2  default null
213   ,p_information68                  in  varchar2  default null
214   ,p_information69                  in  varchar2  default null
215   ,p_information70                  in  varchar2  default null
216   ,p_information71                  in  varchar2  default null
217   ,p_information72                  in  varchar2  default null
218   ,p_information73                  in  varchar2  default null
219   ,p_information74                  in  varchar2  default null
220   ,p_information75                  in  varchar2  default null
221   ,p_information76                  in  varchar2  default null
222   ,p_information77                  in  varchar2  default null
223   ,p_information78                  in  varchar2  default null
224   ,p_information79                  in  varchar2  default null
225   ,p_information80                  in  varchar2  default null
226   ,p_information81                  in  varchar2  default null
227   ,p_information82                  in  varchar2  default null
228   ,p_information83                  in  varchar2  default null
229   ,p_information84                  in  varchar2  default null
230   ,p_information85                  in  varchar2  default null
231   ,p_information86                  in  varchar2  default null
232   ,p_information87                  in  varchar2  default null
233   ,p_information88                  in  varchar2  default null
234   ,p_information89                  in  varchar2  default null
235   ,p_information90                  in  varchar2  default null
236   ,p_information91                 in varchar2 default null
237   ,p_information92                 in varchar2 default null
238   ,p_information93                 in varchar2 default null
239   ,p_information94                 in varchar2 default null
240   ,p_information95                 in varchar2 default null
241   ,p_information96                 in varchar2 default null
242   ,p_information97                 in varchar2 default null
243   ,p_information98                 in varchar2 default null
244   ,p_information99                 in varchar2 default null
245   ,p_information100                in varchar2 default null
246   ,p_information101                in varchar2 default null
247   ,p_information102                in varchar2 default null
248   ,p_information103                in varchar2 default null
249   ,p_information104                in varchar2 default null
250   ,p_information105                in varchar2 default null
251   ,p_information106                in varchar2 default null
252   ,p_information107                in varchar2 default null
253   ,p_information108                in varchar2 default null
254   ,p_information109                in varchar2 default null
255   ,p_information110                in varchar2 default null
256   ,p_information111                in varchar2 default null
257   ,p_information112                in varchar2 default null
258   ,p_information113                in varchar2 default null
259   ,p_information114                in varchar2 default null
260   ,p_information115                in varchar2 default null
261   ,p_information116                in varchar2 default null
262   ,p_information117                in varchar2 default null
263   ,p_information118                in varchar2 default null
264   ,p_information119                in varchar2 default null
265   ,p_information120                in varchar2 default null
266   ,p_information121                in varchar2 default null
267   ,p_information122                in varchar2 default null
268   ,p_information123                in varchar2 default null
269   ,p_information124                in varchar2 default null
270   ,p_information125                in varchar2 default null
271   ,p_information126                in varchar2 default null
272   ,p_information127                in varchar2 default null
273   ,p_information128                in varchar2 default null
274   ,p_information129                in varchar2 default null
275   ,p_information130                in varchar2 default null
276   ,p_information131                in varchar2 default null
277   ,p_information132                in varchar2 default null
278   ,p_information133                in varchar2 default null
279   ,p_information134                in varchar2 default null
280   ,p_information135                in varchar2 default null
281   ,p_information136                in varchar2 default null
282   ,p_information137                in varchar2 default null
283   ,p_information138                in varchar2 default null
284   ,p_information139                in varchar2 default null
285   ,p_information140                in varchar2 default null
286   ,p_information141                in varchar2 default null
287   ,p_information142                in varchar2 default null
288   ,p_information143                in varchar2 default null
289   ,p_information144                in varchar2 default null
290   ,p_information145                in varchar2 default null
291   ,p_information146                in varchar2 default null
292   ,p_information147                in varchar2 default null
293   ,p_information148                in varchar2 default null
294   ,p_information149                in varchar2 default null
295   ,p_information150                in varchar2 default null
296   ,p_information151                in varchar2 default null
297   ,p_information152                in varchar2 default null
298   ,p_information153                in varchar2 default null
299   ,p_information154                in varchar2 default null
300   ,p_information155                in varchar2 default null
301   ,p_information156                in varchar2 default null
302   ,p_information157                in varchar2 default null
303   ,p_information158                in varchar2 default null
304   ,p_information159                in varchar2 default null
308   ,p_information163                in varchar2 default null
305   ,p_information160                in varchar2 default null
306   ,p_information161                in varchar2 default null
307   ,p_information162                in varchar2 default null
309   ,p_information164                in varchar2 default null
310   ,p_information165                in varchar2 default null
311   ,p_information166                in varchar2 default null
312   ,p_information167                in varchar2 default null
313   ,p_information168                in varchar2 default null
314   ,p_information169                in varchar2 default null
315   ,p_information170                in varchar2 default null
316   ,p_information171                in varchar2 default null
317   ,p_information172                in varchar2 default null
318   ,p_information173                in varchar2 default null
319   ,p_information174                in varchar2 default null
320   ,p_information175                in varchar2 default null
321   ,p_information176                in varchar2 default null
322   ,p_information177                in varchar2 default null
323   ,p_information178                in varchar2 default null
324   ,p_information179                in varchar2 default null
325   ,p_information180                in varchar2 default null
326   ,p_information181                in varchar2 default null
327   ,p_information182                in varchar2 default null
328   ,p_information183                in varchar2 default null
329   ,p_information184                in varchar2 default null
330   ,p_information185                in varchar2 default null
331   ,p_information186                in varchar2 default null
332   ,p_information187                in varchar2 default null
333   ,p_information188                in varchar2 default null
334   ,p_information189                in varchar2 default null
335   ,p_information190                in varchar2 default null
336   ,p_mirror_entity_result_id       in  number  default null
337   ,p_mirror_src_entity_result_id   in  number  default null
338   ,p_parent_entity_result_id       in  number  default null
339   ,p_table_route_id                in  number  default null
340   ,p_long_attribute1               in  long    default null
341   ,p_object_version_number        out nocopy  number
342   ,p_effective_date                in  date
343  );
344 -- ----------------------------------------------------------------------------
345 -- |------------------------< update_copy_entity_result >------------------------|
346 -- ----------------------------------------------------------------------------
347 -- {Start Of Comments}
348 --
349 -- Description:
350 --
351 -- Prerequisites:
352 --
353 --
354 -- In Parameters:
355 --   Name                           Reqd Type     Description
356 --   p_validate                     Yes  boolean  Commit or Rollback.
357 --   p_copy_entity_result_id        Yes  number    PK of record
358 --   p_copy_entity_txn_id           Yes  number
359 --   p_result_type_cd               No   varchar2
360 --   p_number_of_copes              No   varchar2
361 --   p_status                       No   varchar2
362 --   p_src_copy_entity_result_id    No   number
363 --   p_information_category         No   varchar2
364 --   p_information1                 No   varchar2
365 --   p_information2                 No   varchar2
366 --   p_information3                 No   varchar2
367 --   p_information4                 No   varchar2
368 --   p_information5                 No   varchar2
369 --   p_information6                 No   varchar2
370 --   p_information7                 No   varchar2
371 --   p_information8                 No   varchar2
372 --   p_information9                 No   varchar2
373 --   p_information10                No   varchar2
374 --   p_information11                No   varchar2
375 --   p_information12                No   varchar2
376 --   p_information13                No   varchar2
377 --   p_information14                No   varchar2
378 --   p_information15                No   varchar2
379 --   p_information16                No   varchar2
380 --   p_information17                No   varchar2
381 --   p_information18                No   varchar2
382 --   p_information19                No   varchar2
383 --   p_information20                No   varchar2
384 --   p_information21                No   varchar2
385 --   p_information22                No   varchar2
386 --   p_information23                No   varchar2
387 --   p_information24                No   varchar2
388 --   p_information25                No   varchar2
389 --   p_information26                No   varchar2
390 --   p_information27                No   varchar2
391 --   p_information28                No   varchar2
392 --   p_information29                No   varchar2
393 --   p_information30                No   varchar2
394 --   p_information31                No   varchar2
395 --   p_information32                No   varchar2
396 --   p_information33                No   varchar2
397 --   p_information34                No   varchar2
398 --   p_information35                No   varchar2
399 --   p_information36                No   varchar2
400 --   p_information37                No   varchar2
401 --   p_information38                No   varchar2
402 --   p_information39                No   varchar2
403 --   p_information40                No   varchar2
404 --   p_information41                No   varchar2
405 --   p_information42                No   varchar2
406 --   p_information43                No   varchar2
407 --   p_information44                No   varchar2
411 --   p_information48                No   varchar2
408 --   p_information45                No   varchar2
409 --   p_information46                No   varchar2
410 --   p_information47                No   varchar2
412 --   p_information49                No   varchar2
413 --   p_information50                No   varchar2
414 --   p_information51                No   varchar2
415 --   p_information52                No   varchar2
416 --   p_information53                No   varchar2
417 --   p_information54                No   varchar2
418 --   p_information55                No   varchar2
419 --   p_information56                No   varchar2
420 --   p_information57                No   varchar2
421 --   p_information58                No   varchar2
422 --   p_information59                No   varchar2
423 --   p_information60                No   varchar2
424 --   p_information61                No   varchar2
425 --   p_information62                No   varchar2
426 --   p_information63                No   varchar2
427 --   p_information64                No   varchar2
428 --   p_information65                No   varchar2
429 --   p_information66                No   varchar2
430 --   p_information67                No   varchar2
431 --   p_information68                No   varchar2
432 --   p_information69                No   varchar2
433 --   p_information70                No   varchar2
434 --   p_information71                No   varchar2
435 --   p_information72                No   varchar2
436 --   p_information73                No   varchar2
437 --   p_information74                No   varchar2
438 --   p_information75                No   varchar2
439 --   p_information76                No   varchar2
440 --   p_information77                No   varchar2
441 --   p_information78                No   varchar2
442 --   p_information79                No   varchar2
443 --   p_information80                No   varchar2
444 --   p_information81                No   varchar2
445 --   p_information82                No   varchar2
446 --   p_information83                No   varchar2
447 --   p_information84                No   varchar2
448 --   p_information85                No   varchar2
449 --   p_information86                No   varchar2
450 --   p_information87                No   varchar2
451 --   p_information88                No   varchar2
452 --   p_information89                No   varchar2
453 --   p_information90                No   varchar2
454 --   ...
455 --   p_information190               No   varchar2
456 --   p_mirror_entity_result_id      No   number
457 --   p_mirror_src_entity_result_id  No   number
458 --   p_parent_entity_result_id      No   number
459 --   p_table_route_id               No   number
460 --   p_long_attribute1              Yes  long
461 --   p_effective_date          Yes  date       Session Date.
462 --
463 -- Post Success:
464 --
465 --   Name                           Type     Description
466 --   p_object_version_number        Yes  number    OVN of record
467 --
468 -- Post Failure:
469 --
470 -- Access Status:
471 --   Public.
472 --
473 -- {End Of Comments}
474 --
475 procedure update_copy_entity_result
476   (
477    p_validate                       in boolean    default false
478   ,p_copy_entity_result_id          in  number
479   ,p_copy_entity_txn_id             in  number    default hr_api.g_number
480   ,p_result_type_cd                 in  varchar2  default hr_api.g_varchar2
481   ,p_number_of_copies               in  number    default hr_api.g_number
482   ,p_status                         in  varchar2  default hr_api.g_varchar2
483   ,p_src_copy_entity_result_id      in  number    default hr_api.g_number
484   ,p_information_category           in  varchar2  default hr_api.g_varchar2
485   ,p_information1                   in  varchar2  default hr_api.g_varchar2
486   ,p_information2                   in  varchar2  default hr_api.g_varchar2
487   ,p_information3                   in  varchar2  default hr_api.g_varchar2
488   ,p_information4                   in  varchar2  default hr_api.g_varchar2
489   ,p_information5                   in  varchar2  default hr_api.g_varchar2
490   ,p_information6                   in  varchar2  default hr_api.g_varchar2
491   ,p_information7                   in  varchar2  default hr_api.g_varchar2
492   ,p_information8                   in  varchar2  default hr_api.g_varchar2
493   ,p_information9                   in  varchar2  default hr_api.g_varchar2
494   ,p_information10                  in  varchar2  default hr_api.g_varchar2
495   ,p_information11                  in  varchar2  default hr_api.g_varchar2
496   ,p_information12                  in  varchar2  default hr_api.g_varchar2
497   ,p_information13                  in  varchar2  default hr_api.g_varchar2
498   ,p_information14                  in  varchar2  default hr_api.g_varchar2
499   ,p_information15                  in  varchar2  default hr_api.g_varchar2
500   ,p_information16                  in  varchar2  default hr_api.g_varchar2
501   ,p_information17                  in  varchar2  default hr_api.g_varchar2
502   ,p_information18                  in  varchar2  default hr_api.g_varchar2
503   ,p_information19                  in  varchar2  default hr_api.g_varchar2
504   ,p_information20                  in  varchar2  default hr_api.g_varchar2
505   ,p_information21                  in  varchar2  default hr_api.g_varchar2
506   ,p_information22                  in  varchar2  default hr_api.g_varchar2
507   ,p_information23                  in  varchar2  default hr_api.g_varchar2
508   ,p_information24                  in  varchar2  default hr_api.g_varchar2
509   ,p_information25                  in  varchar2  default hr_api.g_varchar2
513   ,p_information29                  in  varchar2  default hr_api.g_varchar2
510   ,p_information26                  in  varchar2  default hr_api.g_varchar2
511   ,p_information27                  in  varchar2  default hr_api.g_varchar2
512   ,p_information28                  in  varchar2  default hr_api.g_varchar2
514   ,p_information30                  in  varchar2  default hr_api.g_varchar2
515   ,p_information31                  in  varchar2  default hr_api.g_varchar2
516   ,p_information32                  in  varchar2  default hr_api.g_varchar2
517   ,p_information33                  in  varchar2  default hr_api.g_varchar2
518   ,p_information34                  in  varchar2  default hr_api.g_varchar2
519   ,p_information35                  in  varchar2  default hr_api.g_varchar2
520   ,p_information36                  in  varchar2  default hr_api.g_varchar2
521   ,p_information37                  in  varchar2  default hr_api.g_varchar2
522   ,p_information38                  in  varchar2  default hr_api.g_varchar2
523   ,p_information39                  in  varchar2  default hr_api.g_varchar2
524   ,p_information40                  in  varchar2  default hr_api.g_varchar2
525   ,p_information41                  in  varchar2  default hr_api.g_varchar2
526   ,p_information42                  in  varchar2  default hr_api.g_varchar2
527   ,p_information43                  in  varchar2  default hr_api.g_varchar2
528   ,p_information44                  in  varchar2  default hr_api.g_varchar2
529   ,p_information45                  in  varchar2  default hr_api.g_varchar2
530   ,p_information46                  in  varchar2  default hr_api.g_varchar2
531   ,p_information47                  in  varchar2  default hr_api.g_varchar2
532   ,p_information48                  in  varchar2  default hr_api.g_varchar2
533   ,p_information49                  in  varchar2  default hr_api.g_varchar2
534   ,p_information50                  in  varchar2  default hr_api.g_varchar2
535   ,p_information51                  in  varchar2  default hr_api.g_varchar2
536   ,p_information52                  in  varchar2  default hr_api.g_varchar2
537   ,p_information53                  in  varchar2  default hr_api.g_varchar2
538   ,p_information54                  in  varchar2  default hr_api.g_varchar2
539   ,p_information55                  in  varchar2  default hr_api.g_varchar2
540   ,p_information56                  in  varchar2  default hr_api.g_varchar2
541   ,p_information57                  in  varchar2  default hr_api.g_varchar2
542   ,p_information58                  in  varchar2  default hr_api.g_varchar2
543   ,p_information59                  in  varchar2  default hr_api.g_varchar2
544   ,p_information60                  in  varchar2  default hr_api.g_varchar2
545   ,p_information61                  in  varchar2  default hr_api.g_varchar2
546   ,p_information62                  in  varchar2  default hr_api.g_varchar2
547   ,p_information63                  in  varchar2  default hr_api.g_varchar2
548   ,p_information64                  in  varchar2  default hr_api.g_varchar2
549   ,p_information65                  in  varchar2  default hr_api.g_varchar2
550   ,p_information66                  in  varchar2  default hr_api.g_varchar2
551   ,p_information67                  in  varchar2  default hr_api.g_varchar2
552   ,p_information68                  in  varchar2  default hr_api.g_varchar2
553   ,p_information69                  in  varchar2  default hr_api.g_varchar2
554   ,p_information70                  in  varchar2  default hr_api.g_varchar2
555   ,p_information71                  in  varchar2  default hr_api.g_varchar2
556   ,p_information72                  in  varchar2  default hr_api.g_varchar2
557   ,p_information73                  in  varchar2  default hr_api.g_varchar2
558   ,p_information74                  in  varchar2  default hr_api.g_varchar2
559   ,p_information75                  in  varchar2  default hr_api.g_varchar2
560   ,p_information76                  in  varchar2  default hr_api.g_varchar2
561   ,p_information77                  in  varchar2  default hr_api.g_varchar2
562   ,p_information78                  in  varchar2  default hr_api.g_varchar2
563   ,p_information79                  in  varchar2  default hr_api.g_varchar2
564   ,p_information80                  in  varchar2  default hr_api.g_varchar2
565   ,p_information81                  in  varchar2  default hr_api.g_varchar2
566   ,p_information82                  in  varchar2  default hr_api.g_varchar2
567   ,p_information83                  in  varchar2  default hr_api.g_varchar2
571   ,p_information87                  in  varchar2  default hr_api.g_varchar2
568   ,p_information84                  in  varchar2  default hr_api.g_varchar2
569   ,p_information85                  in  varchar2  default hr_api.g_varchar2
570   ,p_information86                  in  varchar2  default hr_api.g_varchar2
572   ,p_information88                  in  varchar2  default hr_api.g_varchar2
573   ,p_information89                  in  varchar2  default hr_api.g_varchar2
574   ,p_information90                  in  varchar2  default hr_api.g_varchar2
575   ,p_information91                 in varchar2     default hr_api.g_varchar2
576   ,p_information92                 in varchar2     default hr_api.g_varchar2
577   ,p_information93                 in varchar2     default hr_api.g_varchar2
578   ,p_information94                 in varchar2     default hr_api.g_varchar2
579   ,p_information95                 in varchar2     default hr_api.g_varchar2
580   ,p_information96                 in varchar2     default hr_api.g_varchar2
581   ,p_information97                 in varchar2     default hr_api.g_varchar2
582   ,p_information98                 in varchar2     default hr_api.g_varchar2
583   ,p_information99                 in varchar2     default hr_api.g_varchar2
584   ,p_information100                in varchar2     default hr_api.g_varchar2
585   ,p_information101                in varchar2     default hr_api.g_varchar2
586   ,p_information102                in varchar2     default hr_api.g_varchar2
587   ,p_information103                in varchar2     default hr_api.g_varchar2
588   ,p_information104                in varchar2     default hr_api.g_varchar2
589   ,p_information105                in varchar2     default hr_api.g_varchar2
590   ,p_information106                in varchar2     default hr_api.g_varchar2
591   ,p_information107                in varchar2     default hr_api.g_varchar2
592   ,p_information108                in varchar2     default hr_api.g_varchar2
593   ,p_information109                in varchar2     default hr_api.g_varchar2
594   ,p_information110                in varchar2     default hr_api.g_varchar2
595   ,p_information111                in varchar2     default hr_api.g_varchar2
596   ,p_information112                in varchar2     default hr_api.g_varchar2
597   ,p_information113                in varchar2     default hr_api.g_varchar2
598   ,p_information114                in varchar2     default hr_api.g_varchar2
599   ,p_information115                in varchar2     default hr_api.g_varchar2
600   ,p_information116                in varchar2     default hr_api.g_varchar2
601   ,p_information117                in varchar2     default hr_api.g_varchar2
602   ,p_information118                in varchar2     default hr_api.g_varchar2
603   ,p_information119                in varchar2     default hr_api.g_varchar2
604   ,p_information120                in varchar2     default hr_api.g_varchar2
605   ,p_information121                in varchar2     default hr_api.g_varchar2
606   ,p_information122                in varchar2     default hr_api.g_varchar2
607   ,p_information123                in varchar2     default hr_api.g_varchar2
608   ,p_information124                in varchar2     default hr_api.g_varchar2
609   ,p_information125                in varchar2     default hr_api.g_varchar2
610   ,p_information126                in varchar2     default hr_api.g_varchar2
611   ,p_information127                in varchar2     default hr_api.g_varchar2
612   ,p_information128                in varchar2     default hr_api.g_varchar2
613   ,p_information129                in varchar2     default hr_api.g_varchar2
614   ,p_information130                in varchar2     default hr_api.g_varchar2
615   ,p_information131                in varchar2     default hr_api.g_varchar2
616   ,p_information132                in varchar2     default hr_api.g_varchar2
617   ,p_information133                in varchar2     default hr_api.g_varchar2
618   ,p_information134                in varchar2     default hr_api.g_varchar2
619   ,p_information135                in varchar2     default hr_api.g_varchar2
620   ,p_information136                in varchar2     default hr_api.g_varchar2
621   ,p_information137                in varchar2     default hr_api.g_varchar2
622   ,p_information138                in varchar2     default hr_api.g_varchar2
623   ,p_information139                in varchar2     default hr_api.g_varchar2
624   ,p_information140                in varchar2     default hr_api.g_varchar2
625   ,p_information141                in varchar2     default hr_api.g_varchar2
626   ,p_information142                in varchar2     default hr_api.g_varchar2
627   ,p_information143                in varchar2     default hr_api.g_varchar2
628   ,p_information144                in varchar2     default hr_api.g_varchar2
629   ,p_information145                in varchar2     default hr_api.g_varchar2
630   ,p_information146                in varchar2     default hr_api.g_varchar2
631   ,p_information147                in varchar2     default hr_api.g_varchar2
632   ,p_information148                in varchar2     default hr_api.g_varchar2
633   ,p_information149                in varchar2     default hr_api.g_varchar2
634   ,p_information150                in varchar2     default hr_api.g_varchar2
635   ,p_information151                in varchar2     default hr_api.g_varchar2
636   ,p_information152                in varchar2     default hr_api.g_varchar2
637   ,p_information153                in varchar2     default hr_api.g_varchar2
638   ,p_information154                in varchar2     default hr_api.g_varchar2
639   ,p_information155                in varchar2     default hr_api.g_varchar2
640   ,p_information156                in varchar2     default hr_api.g_varchar2
641   ,p_information157                in varchar2     default hr_api.g_varchar2
645   ,p_information161                in varchar2     default hr_api.g_varchar2
642   ,p_information158                in varchar2     default hr_api.g_varchar2
643   ,p_information159                in varchar2     default hr_api.g_varchar2
644   ,p_information160                in varchar2     default hr_api.g_varchar2
646   ,p_information162                in varchar2     default hr_api.g_varchar2
647   ,p_information163                in varchar2     default hr_api.g_varchar2
648   ,p_information164                in varchar2     default hr_api.g_varchar2
649   ,p_information165                in varchar2     default hr_api.g_varchar2
650   ,p_information166                in varchar2     default hr_api.g_varchar2
651   ,p_information167                in varchar2     default hr_api.g_varchar2
652   ,p_information168                in varchar2     default hr_api.g_varchar2
653   ,p_information169                in varchar2     default hr_api.g_varchar2
654   ,p_information170                in varchar2     default hr_api.g_varchar2
655   ,p_information171                in varchar2     default hr_api.g_varchar2
656   ,p_information172                in varchar2     default hr_api.g_varchar2
657   ,p_information173                in varchar2     default hr_api.g_varchar2
658   ,p_information174                in varchar2     default hr_api.g_varchar2
659   ,p_information175                in varchar2     default hr_api.g_varchar2
660   ,p_information176                in varchar2     default hr_api.g_varchar2
661   ,p_information177                in varchar2     default hr_api.g_varchar2
662   ,p_information178                in varchar2     default hr_api.g_varchar2
663   ,p_information179                in varchar2     default hr_api.g_varchar2
664   ,p_information180                in varchar2     default hr_api.g_varchar2
665   ,p_information181                in varchar2     default hr_api.g_varchar2
666   ,p_information182                in varchar2     default hr_api.g_varchar2
667   ,p_information183                in varchar2     default hr_api.g_varchar2
668   ,p_information184                in varchar2     default hr_api.g_varchar2
669   ,p_information185                in varchar2     default hr_api.g_varchar2
670   ,p_information186                in varchar2     default hr_api.g_varchar2
671   ,p_information187                in varchar2     default hr_api.g_varchar2
672   ,p_information188                in varchar2     default hr_api.g_varchar2
673   ,p_information189                in varchar2     default hr_api.g_varchar2
674   ,p_information190                in varchar2     default hr_api.g_varchar2
675   ,p_mirror_entity_result_id       in number       default hr_api.g_number
676   ,p_mirror_src_entity_result_id   in number       default hr_api.g_number
677   ,p_parent_entity_result_id       in number       default hr_api.g_number
678   ,p_table_route_id                in number       default hr_api.g_number
679   ,p_long_attribute1               in long
680   ,p_object_version_number     in out nocopy number
681   ,p_effective_date                in date
682   );
683 --
684 -- ----------------------------------------------------------------------------
685 -- |------------------------< delete_copy_entity_result >------------------------|
686 -- ----------------------------------------------------------------------------
687 -- {Start Of Comments}
688 --
689 -- Description:
690 --
691 -- Prerequisites:
692 --
693 --
694 -- In Parameters:
695 --   Name                           Reqd Type     Description
696 --   p_validate                     Yes  boolean  Commit or Rollback.
697 --   p_copy_entity_result_id        Yes  number    PK of record
698 --   p_effective_date          Yes  date     Session Date.
699 --
700 -- Post Success:
701 --
702 --   Name                           Type     Description
703 --   p_object_version_number        Yes  number    OVN of record
704 --
705 -- Post Failure:
706 --
707 -- Access Status:
708 --   Public.
709 --
710 -- {End Of Comments}
711 --
712 procedure delete_copy_entity_result
713   (
714    p_validate                       in boolean        default false
715   ,p_copy_entity_result_id          in  number
716   ,p_object_version_number          in  number
717   ,p_effective_date            in date
718   );
719 --
720 end pqh_copy_entity_results_api;