[Home] [Help]
PACKAGE BODY: APPS.PQH_COPY_ENTITY_RESULTS_API
Source
1 Package Body pqh_copy_entity_results_api as
2 /* $Header: pqcerapi.pkb 115.5 2002/11/27 04:43:10 rpasapul ship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' pqh_copy_entity_results_api.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< create_copy_entity_result >----------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure create_copy_entity_result
13 (p_validate in boolean default false
14 ,p_copy_entity_result_id out nocopy number
15 ,p_copy_entity_txn_id in number default null
16 ,p_result_type_cd in varchar2 default null
17 ,p_number_of_copies in number default null
18 ,p_status in varchar2 default null
19 ,p_src_copy_entity_result_id in number default null
20 ,p_information_category in varchar2 default null
21 ,p_information1 in varchar2 default null
22 ,p_information2 in varchar2 default null
23 ,p_information3 in varchar2 default null
24 ,p_information4 in varchar2 default null
25 ,p_information5 in varchar2 default null
26 ,p_information6 in varchar2 default null
27 ,p_information7 in varchar2 default null
28 ,p_information8 in varchar2 default null
29 ,p_information9 in varchar2 default null
30 ,p_information10 in varchar2 default null
31 ,p_information11 in varchar2 default null
32 ,p_information12 in varchar2 default null
33 ,p_information13 in varchar2 default null
34 ,p_information14 in varchar2 default null
35 ,p_information15 in varchar2 default null
36 ,p_information16 in varchar2 default null
37 ,p_information17 in varchar2 default null
38 ,p_information18 in varchar2 default null
39 ,p_information19 in varchar2 default null
40 ,p_information20 in varchar2 default null
41 ,p_information21 in varchar2 default null
42 ,p_information22 in varchar2 default null
43 ,p_information23 in varchar2 default null
44 ,p_information24 in varchar2 default null
45 ,p_information25 in varchar2 default null
46 ,p_information26 in varchar2 default null
47 ,p_information27 in varchar2 default null
48 ,p_information28 in varchar2 default null
49 ,p_information29 in varchar2 default null
50 ,p_information30 in varchar2 default null
51 ,p_information31 in varchar2 default null
52 ,p_information32 in varchar2 default null
53 ,p_information33 in varchar2 default null
54 ,p_information34 in varchar2 default null
55 ,p_information35 in varchar2 default null
56 ,p_information36 in varchar2 default null
57 ,p_information37 in varchar2 default null
58 ,p_information38 in varchar2 default null
59 ,p_information39 in varchar2 default null
60 ,p_information40 in varchar2 default null
61 ,p_information41 in varchar2 default null
62 ,p_information42 in varchar2 default null
63 ,p_information43 in varchar2 default null
64 ,p_information44 in varchar2 default null
65 ,p_information45 in varchar2 default null
66 ,p_information46 in varchar2 default null
67 ,p_information47 in varchar2 default null
68 ,p_information48 in varchar2 default null
69 ,p_information49 in varchar2 default null
70 ,p_information50 in varchar2 default null
71 ,p_information51 in varchar2 default null
72 ,p_information52 in varchar2 default null
73 ,p_information53 in varchar2 default null
74 ,p_information54 in varchar2 default null
75 ,p_information55 in varchar2 default null
76 ,p_information56 in varchar2 default null
77 ,p_information57 in varchar2 default null
78 ,p_information58 in varchar2 default null
79 ,p_information59 in varchar2 default null
80 ,p_information60 in varchar2 default null
81 ,p_information61 in varchar2 default null
82 ,p_information62 in varchar2 default null
83 ,p_information63 in varchar2 default null
84 ,p_information64 in varchar2 default null
85 ,p_information65 in varchar2 default null
86 ,p_information66 in varchar2 default null
87 ,p_information67 in varchar2 default null
88 ,p_information68 in varchar2 default null
89 ,p_information69 in varchar2 default null
90 ,p_information70 in varchar2 default null
91 ,p_information71 in varchar2 default null
92 ,p_information72 in varchar2 default null
93 ,p_information73 in varchar2 default null
94 ,p_information74 in varchar2 default null
95 ,p_information75 in varchar2 default null
96 ,p_information76 in varchar2 default null
97 ,p_information77 in varchar2 default null
98 ,p_information78 in varchar2 default null
99 ,p_information79 in varchar2 default null
100 ,p_information80 in varchar2 default null
101 ,p_information81 in varchar2 default null
102 ,p_information82 in varchar2 default null
103 ,p_information83 in varchar2 default null
104 ,p_information84 in varchar2 default null
105 ,p_information85 in varchar2 default null
106 ,p_information86 in varchar2 default null
107 ,p_information87 in varchar2 default null
108 ,p_information88 in varchar2 default null
109 ,p_information89 in varchar2 default null
110 ,p_information90 in varchar2 default null
111 ,p_information91 in varchar2 default null
112 ,p_information92 in varchar2 default null
113 ,p_information93 in varchar2 default null
114 ,p_information94 in varchar2 default null
115 ,p_information95 in varchar2 default null
116 ,p_information96 in varchar2 default null
117 ,p_information97 in varchar2 default null
118 ,p_information98 in varchar2 default null
119 ,p_information99 in varchar2 default null
120 ,p_information100 in varchar2 default null
121 ,p_information101 in varchar2 default null
122 ,p_information102 in varchar2 default null
123 ,p_information103 in varchar2 default null
124 ,p_information104 in varchar2 default null
125 ,p_information105 in varchar2 default null
126 ,p_information106 in varchar2 default null
127 ,p_information107 in varchar2 default null
128 ,p_information108 in varchar2 default null
129 ,p_information109 in varchar2 default null
130 ,p_information110 in varchar2 default null
131 ,p_information111 in varchar2 default null
132 ,p_information112 in varchar2 default null
133 ,p_information113 in varchar2 default null
134 ,p_information114 in varchar2 default null
135 ,p_information115 in varchar2 default null
136 ,p_information116 in varchar2 default null
137 ,p_information117 in varchar2 default null
138 ,p_information118 in varchar2 default null
139 ,p_information119 in varchar2 default null
140 ,p_information120 in varchar2 default null
141 ,p_information121 in varchar2 default null
142 ,p_information122 in varchar2 default null
143 ,p_information123 in varchar2 default null
144 ,p_information124 in varchar2 default null
145 ,p_information125 in varchar2 default null
146 ,p_information126 in varchar2 default null
147 ,p_information127 in varchar2 default null
148 ,p_information128 in varchar2 default null
149 ,p_information129 in varchar2 default null
150 ,p_information130 in varchar2 default null
151 ,p_information131 in varchar2 default null
152 ,p_information132 in varchar2 default null
153 ,p_information133 in varchar2 default null
154 ,p_information134 in varchar2 default null
155 ,p_information135 in varchar2 default null
156 ,p_information136 in varchar2 default null
157 ,p_information137 in varchar2 default null
158 ,p_information138 in varchar2 default null
159 ,p_information139 in varchar2 default null
160 ,p_information140 in varchar2 default null
161 ,p_information141 in varchar2 default null
162 ,p_information142 in varchar2 default null
163 ,p_information143 in varchar2 default null
164 ,p_information144 in varchar2 default null
165 ,p_information145 in varchar2 default null
166 ,p_information146 in varchar2 default null
167 ,p_information147 in varchar2 default null
168 ,p_information148 in varchar2 default null
169 ,p_information149 in varchar2 default null
170 ,p_information150 in varchar2 default null
171 ,p_information151 in varchar2 default null
172 ,p_information152 in varchar2 default null
173 ,p_information153 in varchar2 default null
174 ,p_information154 in varchar2 default null
175 ,p_information155 in varchar2 default null
176 ,p_information156 in varchar2 default null
177 ,p_information157 in varchar2 default null
178 ,p_information158 in varchar2 default null
179 ,p_information159 in varchar2 default null
180 ,p_information160 in varchar2 default null
181 ,p_information161 in varchar2 default null
182 ,p_information162 in varchar2 default null
183 ,p_information163 in varchar2 default null
184 ,p_information164 in varchar2 default null
185 ,p_information165 in varchar2 default null
186 ,p_information166 in varchar2 default null
187 ,p_information167 in varchar2 default null
188 ,p_information168 in varchar2 default null
189 ,p_information169 in varchar2 default null
190 ,p_information170 in varchar2 default null
191 ,p_information171 in varchar2 default null
192 ,p_information172 in varchar2 default null
193 ,p_information173 in varchar2 default null
194 ,p_information174 in varchar2 default null
195 ,p_information175 in varchar2 default null
196 ,p_information176 in varchar2 default null
197 ,p_information177 in varchar2 default null
198 ,p_information178 in varchar2 default null
199 ,p_information179 in varchar2 default null
200 ,p_information180 in varchar2 default null
201 ,p_information181 in varchar2 default null
202 ,p_information182 in varchar2 default null
203 ,p_information183 in varchar2 default null
204 ,p_information184 in varchar2 default null
205 ,p_information185 in varchar2 default null
206 ,p_information186 in varchar2 default null
207 ,p_information187 in varchar2 default null
208 ,p_information188 in varchar2 default null
209 ,p_information189 in varchar2 default null
210 ,p_information190 in varchar2 default null
211 ,p_mirror_entity_result_id in number default null
212 ,p_mirror_src_entity_result_id in number default null
213 ,p_parent_entity_result_id in number default null
214 ,p_table_route_id in number default null
215 ,p_long_attribute1 in long default null
216 ,p_object_version_number out nocopy number
217 ,p_effective_date in date
218 ) is
219 --
220 -- Declare cursors and local variables
221 --
222 l_copy_entity_result_id pqh_copy_entity_results.copy_entity_result_id%TYPE;
223 l_proc varchar2(72) := g_package||'create_copy_entity_result';
224 l_object_version_number pqh_copy_entity_results.object_version_number%TYPE;
225 --
226 begin
227 --
228 hr_utility.set_location('Entering:'|| l_proc, 10);
229 --
230 -- Issue a savepoint if operating in validation only mode
231 --
232 savepoint create_copy_entity_result;
233 --
234 hr_utility.set_location(l_proc, 20);
235 --
236 -- Process Logic
237 --
238 begin
239 --
240 -- Start of API User Hook for the before hook of create_copy_entity_result
241 --
242 pqh_copy_entity_results_bk1.create_copy_entity_result_b
243 (
244 p_copy_entity_txn_id => p_copy_entity_txn_id
245 ,p_result_type_cd => p_result_type_cd
246 ,p_number_of_copies => p_number_of_copies
247 ,p_status => p_status
248 ,p_src_copy_entity_result_id => p_src_copy_entity_result_id
249 ,p_information_category => p_information_category
250 ,p_information1 => p_information1
251 ,p_information2 => p_information2
252 ,p_information3 => p_information3
253 ,p_information4 => p_information4
254 ,p_information5 => p_information5
255 ,p_information6 => p_information6
256 ,p_information7 => p_information7
257 ,p_information8 => p_information8
258 ,p_information9 => p_information9
259 ,p_information10 => p_information10
260 ,p_information11 => p_information11
261 ,p_information12 => p_information12
262 ,p_information13 => p_information13
263 ,p_information14 => p_information14
264 ,p_information15 => p_information15
265 ,p_information16 => p_information16
266 ,p_information17 => p_information17
267 ,p_information18 => p_information18
268 ,p_information19 => p_information19
269 ,p_information20 => p_information20
270 ,p_information21 => p_information21
271 ,p_information22 => p_information22
272 ,p_information23 => p_information23
273 ,p_information24 => p_information24
274 ,p_information25 => p_information25
275 ,p_information26 => p_information26
276 ,p_information27 => p_information27
277 ,p_information28 => p_information28
278 ,p_information29 => p_information29
279 ,p_information30 => p_information30
280 ,p_information31 => p_information31
281 ,p_information32 => p_information32
282 ,p_information33 => p_information33
283 ,p_information34 => p_information34
284 ,p_information35 => p_information35
285 ,p_information36 => p_information36
286 ,p_information37 => p_information37
287 ,p_information38 => p_information38
288 ,p_information39 => p_information39
289 ,p_information40 => p_information40
290 ,p_information41 => p_information41
291 ,p_information42 => p_information42
292 ,p_information43 => p_information43
293 ,p_information44 => p_information44
294 ,p_information45 => p_information45
295 ,p_information46 => p_information46
296 ,p_information47 => p_information47
297 ,p_information48 => p_information48
298 ,p_information49 => p_information49
299 ,p_information50 => p_information50
300 ,p_information51 => p_information51
301 ,p_information52 => p_information52
302 ,p_information53 => p_information53
303 ,p_information54 => p_information54
304 ,p_information55 => p_information55
305 ,p_information56 => p_information56
306 ,p_information57 => p_information57
307 ,p_information58 => p_information58
308 ,p_information59 => p_information59
309 ,p_information60 => p_information60
310 ,p_information61 => p_information61
311 ,p_information62 => p_information62
312 ,p_information63 => p_information63
313 ,p_information64 => p_information64
314 ,p_information65 => p_information65
315 ,p_information66 => p_information66
316 ,p_information67 => p_information67
317 ,p_information68 => p_information68
318 ,p_information69 => p_information69
319 ,p_information70 => p_information70
320 ,p_information71 => p_information71
321 ,p_information72 => p_information72
322 ,p_information73 => p_information73
323 ,p_information74 => p_information74
324 ,p_information75 => p_information75
325 ,p_information76 => p_information76
326 ,p_information77 => p_information77
327 ,p_information78 => p_information78
328 ,p_information79 => p_information79
329 ,p_information80 => p_information80
330 ,p_information81 => p_information81
331 ,p_information82 => p_information82
332 ,p_information83 => p_information83
333 ,p_information84 => p_information84
334 ,p_information85 => p_information85
335 ,p_information86 => p_information86
336 ,p_information87 => p_information87
337 ,p_information88 => p_information88
338 ,p_information89 => p_information89
339 ,p_information90 => p_information90
340 ,p_information91 =>p_information91
341 ,p_information92 =>p_information92
342 ,p_information93 =>p_information93
343 ,p_information94 =>p_information94
344 ,p_information95 =>p_information95
345 ,p_information96 =>p_information96
346 ,p_information97 =>p_information97
347 ,p_information98 =>p_information98
348 ,p_information99 =>p_information99
349 ,p_information100 =>p_information100
350 ,p_information101 =>p_information101
351 ,p_information102 =>p_information102
352 ,p_information103 =>p_information103
353 ,p_information104 =>p_information104
354 ,p_information105 =>p_information105
355 ,p_information106 =>p_information106
356 ,p_information107 =>p_information107
357 ,p_information108 =>p_information108
358 ,p_information109 =>p_information109
359 ,p_information110 =>p_information110
360 ,p_information111 =>p_information111
361 ,p_information112 =>p_information112
362 ,p_information113 =>p_information113
363 ,p_information114 =>p_information114
364 ,p_information115 =>p_information115
365 ,p_information116 =>p_information116
366 ,p_information117 =>p_information117
367 ,p_information118 =>p_information118
368 ,p_information119 =>p_information119
369 ,p_information120 =>p_information120
370 ,p_information121 =>p_information121
371 ,p_information122 =>p_information122
372 ,p_information123 =>p_information123
373 ,p_information124 =>p_information124
374 ,p_information125 =>p_information125
375 ,p_information126 =>p_information126
376 ,p_information127 =>p_information127
377 ,p_information128 =>p_information128
378 ,p_information129 =>p_information129
379 ,p_information130 =>p_information130
380 ,p_information131 =>p_information131
381 ,p_information132 =>p_information132
382 ,p_information133 =>p_information133
383 ,p_information134 =>p_information134
384 ,p_information135 =>p_information135
385 ,p_information136 =>p_information136
386 ,p_information137 =>p_information137
387 ,p_information138 =>p_information138
388 ,p_information139 =>p_information139
389 ,p_information140 =>p_information140
390 ,p_information141 =>p_information141
391 ,p_information142 =>p_information142
392 ,p_information143 =>p_information143
393 ,p_information144 =>p_information144
394 ,p_information145 =>p_information145
395 ,p_information146 =>p_information146
396 ,p_information147 =>p_information147
397 ,p_information148 =>p_information148
398 ,p_information149 =>p_information149
399 ,p_information150 =>p_information150
400 ,p_information151 =>p_information151
401 ,p_information152 =>p_information152
402 ,p_information153 =>p_information153
403 ,p_information154 =>p_information154
404 ,p_information155 =>p_information155
405 ,p_information156 =>p_information156
406 ,p_information157 =>p_information157
407 ,p_information158 =>p_information158
408 ,p_information159 =>p_information159
409 ,p_information160 =>p_information160
410 ,p_information161 =>p_information161
411 ,p_information162 =>p_information162
412 ,p_information163 =>p_information163
413 ,p_information164 =>p_information164
414 ,p_information165 =>p_information165
415 ,p_information166 =>p_information166
416 ,p_information167 =>p_information167
417 ,p_information168 =>p_information168
418 ,p_information169 =>p_information169
419 ,p_information170 =>p_information170
420 ,p_information171 =>p_information171
421 ,p_information172 =>p_information172
422 ,p_information173 =>p_information173
423 ,p_information174 =>p_information174
424 ,p_information175 =>p_information175
425 ,p_information176 =>p_information176
426 ,p_information177 =>p_information177
427 ,p_information178 =>p_information178
428 ,p_information179 =>p_information179
429 ,p_information180 =>p_information180
430 ,p_information181 =>p_information181
431 ,p_information182 =>p_information182
432 ,p_information183 =>p_information183
433 ,p_information184 =>p_information184
434 ,p_information185 =>p_information185
435 ,p_information186 =>p_information186
436 ,p_information187 =>p_information187
437 ,p_information188 =>p_information188
438 ,p_information189 =>p_information189
439 ,p_information190 =>p_information190
440 ,p_mirror_entity_result_id =>p_mirror_entity_result_id
441 ,p_mirror_src_entity_result_id =>p_mirror_src_entity_result_id
442 ,p_parent_entity_result_id =>p_parent_entity_result_id
443 ,p_table_route_id =>p_table_route_id
444 ,p_long_attribute1 =>p_long_attribute1
445 ,p_effective_date => trunc(p_effective_date)
446 );
447 exception
448 when hr_api.cannot_find_prog_unit then
449 hr_api.cannot_find_prog_unit_error
450 (
451 p_module_name => 'CREATE_copy_entity_result'
452 ,p_hook_type => 'BP'
453 );
454 --
455 -- End of API User Hook for the before hook of create_copy_entity_results
456 --
457 end;
458 --
459 pqh_cer_ins.ins
460 (
461 p_copy_entity_result_id => l_copy_entity_result_id
462 ,p_copy_entity_txn_id => p_copy_entity_txn_id
463 ,p_result_type_cd => p_result_type_cd
464 ,p_number_of_copies => p_number_of_copies
465 ,p_status => p_status
466 ,p_src_copy_entity_result_id => p_src_copy_entity_result_id
467 ,p_information_category => p_information_category
468 ,p_information1 => p_information1
469 ,p_information2 => p_information2
470 ,p_information3 => p_information3
471 ,p_information4 => p_information4
472 ,p_information5 => p_information5
473 ,p_information6 => p_information6
474 ,p_information7 => p_information7
475 ,p_information8 => p_information8
476 ,p_information9 => p_information9
477 ,p_information10 => p_information10
478 ,p_information11 => p_information11
479 ,p_information12 => p_information12
480 ,p_information13 => p_information13
481 ,p_information14 => p_information14
482 ,p_information15 => p_information15
483 ,p_information16 => p_information16
484 ,p_information17 => p_information17
485 ,p_information18 => p_information18
486 ,p_information19 => p_information19
487 ,p_information20 => p_information20
488 ,p_information21 => p_information21
489 ,p_information22 => p_information22
490 ,p_information23 => p_information23
491 ,p_information24 => p_information24
492 ,p_information25 => p_information25
493 ,p_information26 => p_information26
494 ,p_information27 => p_information27
495 ,p_information28 => p_information28
496 ,p_information29 => p_information29
497 ,p_information30 => p_information30
498 ,p_information31 => p_information31
499 ,p_information32 => p_information32
500 ,p_information33 => p_information33
501 ,p_information34 => p_information34
502 ,p_information35 => p_information35
503 ,p_information36 => p_information36
504 ,p_information37 => p_information37
505 ,p_information38 => p_information38
506 ,p_information39 => p_information39
507 ,p_information40 => p_information40
508 ,p_information41 => p_information41
509 ,p_information42 => p_information42
510 ,p_information43 => p_information43
511 ,p_information44 => p_information44
512 ,p_information45 => p_information45
513 ,p_information46 => p_information46
514 ,p_information47 => p_information47
515 ,p_information48 => p_information48
516 ,p_information49 => p_information49
517 ,p_information50 => p_information50
518 ,p_information51 => p_information51
519 ,p_information52 => p_information52
520 ,p_information53 => p_information53
521 ,p_information54 => p_information54
522 ,p_information55 => p_information55
523 ,p_information56 => p_information56
524 ,p_information57 => p_information57
525 ,p_information58 => p_information58
526 ,p_information59 => p_information59
527 ,p_information60 => p_information60
528 ,p_information61 => p_information61
529 ,p_information62 => p_information62
530 ,p_information63 => p_information63
531 ,p_information64 => p_information64
532 ,p_information65 => p_information65
533 ,p_information66 => p_information66
534 ,p_information67 => p_information67
535 ,p_information68 => p_information68
536 ,p_information69 => p_information69
537 ,p_information70 => p_information70
538 ,p_information71 => p_information71
539 ,p_information72 => p_information72
540 ,p_information73 => p_information73
541 ,p_information74 => p_information74
542 ,p_information75 => p_information75
543 ,p_information76 => p_information76
544 ,p_information77 => p_information77
545 ,p_information78 => p_information78
546 ,p_information79 => p_information79
547 ,p_information80 => p_information80
548 ,p_information81 => p_information81
549 ,p_information82 => p_information82
550 ,p_information83 => p_information83
551 ,p_information84 => p_information84
552 ,p_information85 => p_information85
553 ,p_information86 => p_information86
554 ,p_information87 => p_information87
555 ,p_information88 => p_information88
556 ,p_information89 => p_information89
557 ,p_information90 => p_information90
558 ,p_information91 =>p_information91
559 ,p_information92 =>p_information92
560 ,p_information93 =>p_information93
561 ,p_information94 =>p_information94
562 ,p_information95 =>p_information95
563 ,p_information96 =>p_information96
564 ,p_information97 =>p_information97
565 ,p_information98 =>p_information98
566 ,p_information99 =>p_information99
567 ,p_information100 =>p_information100
568 ,p_information101 =>p_information101
569 ,p_information102 =>p_information102
570 ,p_information103 =>p_information103
571 ,p_information104 =>p_information104
572 ,p_information105 =>p_information105
573 ,p_information106 =>p_information106
574 ,p_information107 =>p_information107
575 ,p_information108 =>p_information108
576 ,p_information109 =>p_information109
577 ,p_information110 =>p_information110
578 ,p_information111 =>p_information111
579 ,p_information112 =>p_information112
580 ,p_information113 =>p_information113
581 ,p_information114 =>p_information114
582 ,p_information115 =>p_information115
583 ,p_information116 =>p_information116
584 ,p_information117 =>p_information117
585 ,p_information118 =>p_information118
586 ,p_information119 =>p_information119
587 ,p_information120 =>p_information120
588 ,p_information121 =>p_information121
589 ,p_information122 =>p_information122
590 ,p_information123 =>p_information123
591 ,p_information124 =>p_information124
592 ,p_information125 =>p_information125
593 ,p_information126 =>p_information126
594 ,p_information127 =>p_information127
595 ,p_information128 =>p_information128
596 ,p_information129 =>p_information129
597 ,p_information130 =>p_information130
598 ,p_information131 =>p_information131
599 ,p_information132 =>p_information132
600 ,p_information133 =>p_information133
601 ,p_information134 =>p_information134
602 ,p_information135 =>p_information135
603 ,p_information136 =>p_information136
604 ,p_information137 =>p_information137
605 ,p_information138 =>p_information138
606 ,p_information139 =>p_information139
607 ,p_information140 =>p_information140
608 ,p_information141 =>p_information141
609 ,p_information142 =>p_information142
610 ,p_information143 =>p_information143
611 ,p_information144 =>p_information144
612 ,p_information145 =>p_information145
613 ,p_information146 =>p_information146
614 ,p_information147 =>p_information147
615 ,p_information148 =>p_information148
616 ,p_information149 =>p_information149
617 ,p_information150 =>p_information150
618 ,p_information151 =>p_information151
619 ,p_information152 =>p_information152
620 ,p_information153 =>p_information153
621 ,p_information154 =>p_information154
622 ,p_information155 =>p_information155
623 ,p_information156 =>p_information156
624 ,p_information157 =>p_information157
625 ,p_information158 =>p_information158
626 ,p_information159 =>p_information159
627 ,p_information160 =>p_information160
628 ,p_information161 =>p_information161
629 ,p_information162 =>p_information162
630 ,p_information163 =>p_information163
631 ,p_information164 =>p_information164
632 ,p_information165 =>p_information165
633 ,p_information166 =>p_information166
634 ,p_information167 =>p_information167
635 ,p_information168 =>p_information168
636 ,p_information169 =>p_information169
637 ,p_information170 =>p_information170
638 ,p_information171 =>p_information171
639 ,p_information172 =>p_information172
640 ,p_information173 =>p_information173
641 ,p_information174 =>p_information174
642 ,p_information175 =>p_information175
643 ,p_information176 =>p_information176
644 ,p_information177 =>p_information177
645 ,p_information178 =>p_information178
646 ,p_information179 =>p_information179
647 ,p_information180 =>p_information180
648 ,p_information181 =>p_information181
649 ,p_information182 =>p_information182
650 ,p_information183 =>p_information183
651 ,p_information184 =>p_information184
652 ,p_information185 =>p_information185
653 ,p_information186 =>p_information186
654 ,p_information187 =>p_information187
655 ,p_information188 =>p_information188
656 ,p_information189 =>p_information189
657 ,p_information190 =>p_information190
658 ,p_mirror_entity_result_id =>p_mirror_entity_result_id
659 ,p_mirror_src_entity_result_id =>p_mirror_src_entity_result_id
660 ,p_parent_entity_result_id =>p_parent_entity_result_id
661 ,p_table_route_id =>p_table_route_id
662 ,p_long_attribute1 =>p_long_attribute1
663 ,p_object_version_number => l_object_version_number
664 ,p_effective_date => trunc(p_effective_date)
665 );
666 --
667 begin
668 --
669 -- Start of API User Hook for the after hook of create_copy_entity_results
670 --
671 pqh_copy_entity_results_bk1.create_copy_entity_result_a
672 (
673 p_copy_entity_result_id => l_copy_entity_result_id
674 ,p_copy_entity_txn_id => p_copy_entity_txn_id
675 ,p_result_type_cd => p_result_type_cd
676 ,p_number_of_copies => p_number_of_copies
677 ,p_status => p_status
678 ,p_src_copy_entity_result_id => p_src_copy_entity_result_id
679 ,p_information_category => p_information_category
680 ,p_information1 => p_information1
681 ,p_information2 => p_information2
682 ,p_information3 => p_information3
683 ,p_information4 => p_information4
684 ,p_information5 => p_information5
685 ,p_information6 => p_information6
686 ,p_information7 => p_information7
687 ,p_information8 => p_information8
688 ,p_information9 => p_information9
689 ,p_information10 => p_information10
690 ,p_information11 => p_information11
691 ,p_information12 => p_information12
692 ,p_information13 => p_information13
693 ,p_information14 => p_information14
694 ,p_information15 => p_information15
695 ,p_information16 => p_information16
696 ,p_information17 => p_information17
697 ,p_information18 => p_information18
698 ,p_information19 => p_information19
699 ,p_information20 => p_information20
700 ,p_information21 => p_information21
701 ,p_information22 => p_information22
702 ,p_information23 => p_information23
703 ,p_information24 => p_information24
704 ,p_information25 => p_information25
705 ,p_information26 => p_information26
706 ,p_information27 => p_information27
707 ,p_information28 => p_information28
708 ,p_information29 => p_information29
709 ,p_information30 => p_information30
710 ,p_information31 => p_information31
711 ,p_information32 => p_information32
712 ,p_information33 => p_information33
713 ,p_information34 => p_information34
714 ,p_information35 => p_information35
715 ,p_information36 => p_information36
716 ,p_information37 => p_information37
717 ,p_information38 => p_information38
718 ,p_information39 => p_information39
719 ,p_information40 => p_information40
720 ,p_information41 => p_information41
721 ,p_information42 => p_information42
722 ,p_information43 => p_information43
723 ,p_information44 => p_information44
724 ,p_information45 => p_information45
725 ,p_information46 => p_information46
726 ,p_information47 => p_information47
727 ,p_information48 => p_information48
728 ,p_information49 => p_information49
729 ,p_information50 => p_information50
730 ,p_information51 => p_information51
731 ,p_information52 => p_information52
732 ,p_information53 => p_information53
733 ,p_information54 => p_information54
734 ,p_information55 => p_information55
735 ,p_information56 => p_information56
736 ,p_information57 => p_information57
737 ,p_information58 => p_information58
738 ,p_information59 => p_information59
739 ,p_information60 => p_information60
740 ,p_information61 => p_information61
741 ,p_information62 => p_information62
742 ,p_information63 => p_information63
743 ,p_information64 => p_information64
744 ,p_information65 => p_information65
745 ,p_information66 => p_information66
746 ,p_information67 => p_information67
747 ,p_information68 => p_information68
748 ,p_information69 => p_information69
749 ,p_information70 => p_information70
750 ,p_information71 => p_information71
751 ,p_information72 => p_information72
752 ,p_information73 => p_information73
753 ,p_information74 => p_information74
754 ,p_information75 => p_information75
755 ,p_information76 => p_information76
756 ,p_information77 => p_information77
757 ,p_information78 => p_information78
758 ,p_information79 => p_information79
759 ,p_information80 => p_information80
760 ,p_information81 => p_information81
761 ,p_information82 => p_information82
762 ,p_information83 => p_information83
763 ,p_information84 => p_information84
764 ,p_information85 => p_information85
765 ,p_information86 => p_information86
766 ,p_information87 => p_information87
767 ,p_information88 => p_information88
768 ,p_information89 => p_information89
769 ,p_information90 => p_information90
770 ,p_information91 =>p_information91
771 ,p_information92 =>p_information92
772 ,p_information93 =>p_information93
773 ,p_information94 =>p_information94
774 ,p_information95 =>p_information95
775 ,p_information96 =>p_information96
776 ,p_information97 =>p_information97
777 ,p_information98 =>p_information98
778 ,p_information99 =>p_information99
779 ,p_information100 =>p_information100
780 ,p_information101 =>p_information101
781 ,p_information102 =>p_information102
782 ,p_information103 =>p_information103
783 ,p_information104 =>p_information104
784 ,p_information105 =>p_information105
785 ,p_information106 =>p_information106
786 ,p_information107 =>p_information107
787 ,p_information108 =>p_information108
788 ,p_information109 =>p_information109
789 ,p_information110 =>p_information110
790 ,p_information111 =>p_information111
791 ,p_information112 =>p_information112
792 ,p_information113 =>p_information113
793 ,p_information114 =>p_information114
794 ,p_information115 =>p_information115
795 ,p_information116 =>p_information116
796 ,p_information117 =>p_information117
797 ,p_information118 =>p_information118
798 ,p_information119 =>p_information119
799 ,p_information120 =>p_information120
800 ,p_information121 =>p_information121
801 ,p_information122 =>p_information122
802 ,p_information123 =>p_information123
803 ,p_information124 =>p_information124
804 ,p_information125 =>p_information125
805 ,p_information126 =>p_information126
806 ,p_information127 =>p_information127
807 ,p_information128 =>p_information128
808 ,p_information129 =>p_information129
809 ,p_information130 =>p_information130
810 ,p_information131 =>p_information131
811 ,p_information132 =>p_information132
812 ,p_information133 =>p_information133
813 ,p_information134 =>p_information134
814 ,p_information135 =>p_information135
815 ,p_information136 =>p_information136
816 ,p_information137 =>p_information137
817 ,p_information138 =>p_information138
818 ,p_information139 =>p_information139
819 ,p_information140 =>p_information140
820 ,p_information141 =>p_information141
821 ,p_information142 =>p_information142
822 ,p_information143 =>p_information143
823 ,p_information144 =>p_information144
824 ,p_information145 =>p_information145
825 ,p_information146 =>p_information146
826 ,p_information147 =>p_information147
827 ,p_information148 =>p_information148
828 ,p_information149 =>p_information149
829 ,p_information150 =>p_information150
830 ,p_information151 =>p_information151
831 ,p_information152 =>p_information152
832 ,p_information153 =>p_information153
833 ,p_information154 =>p_information154
834 ,p_information155 =>p_information155
835 ,p_information156 =>p_information156
836 ,p_information157 =>p_information157
837 ,p_information158 =>p_information158
838 ,p_information159 =>p_information159
839 ,p_information160 =>p_information160
840 ,p_information161 =>p_information161
841 ,p_information162 =>p_information162
842 ,p_information163 =>p_information163
843 ,p_information164 =>p_information164
844 ,p_information165 =>p_information165
845 ,p_information166 =>p_information166
846 ,p_information167 =>p_information167
847 ,p_information168 =>p_information168
848 ,p_information169 =>p_information169
849 ,p_information170 =>p_information170
850 ,p_information171 =>p_information171
851 ,p_information172 =>p_information172
852 ,p_information173 =>p_information173
853 ,p_information174 =>p_information174
854 ,p_information175 =>p_information175
855 ,p_information176 =>p_information176
856 ,p_information177 =>p_information177
857 ,p_information178 =>p_information178
858 ,p_information179 =>p_information179
859 ,p_information180 =>p_information180
860 ,p_information181 =>p_information181
861 ,p_information182 =>p_information182
862 ,p_information183 =>p_information183
863 ,p_information184 =>p_information184
864 ,p_information185 =>p_information185
865 ,p_information186 =>p_information186
866 ,p_information187 =>p_information187
867 ,p_information188 =>p_information188
868 ,p_information189 =>p_information189
869 ,p_information190 =>p_information190
870 ,p_mirror_entity_result_id =>p_mirror_entity_result_id
871 ,p_mirror_src_entity_result_id =>p_mirror_src_entity_result_id
872 ,p_parent_entity_result_id =>p_parent_entity_result_id
873 ,p_table_route_id =>p_table_route_id
874 ,p_long_attribute1 =>p_long_attribute1
875 ,p_object_version_number => l_object_version_number
876 ,p_effective_date => trunc(p_effective_date)
877 );
878 exception
879 when hr_api.cannot_find_prog_unit then
880 hr_api.cannot_find_prog_unit_error
881 (p_module_name => 'CREATE_copy_entity_result'
882 ,p_hook_type => 'AP'
883 );
884 --
885 -- End of API User Hook for the after hook of create_copy_entity_results
886 --
887 end;
888 --
889 hr_utility.set_location(l_proc, 60);
890 --
891 -- When in validation only mode raise the Validate_Enabled exception
892 --
893 if p_validate then
894 raise hr_api.validate_enabled;
895 end if;
896 --
897 -- Set all output arguments
898 --
899 p_copy_entity_result_id := l_copy_entity_result_id;
900 p_object_version_number := l_object_version_number;
901 --
902 hr_utility.set_location(' Leaving:'||l_proc, 70);
903 --
904 exception
905 --
906 when hr_api.validate_enabled then
907 --
908 -- As the Validate_Enabled exception has been raised
909 -- we must rollback to the savepoint
910 --
911 ROLLBACK TO create_copy_entity_result;
912 --
913 -- Only set output warning arguments
914 -- (Any key or derived arguments must be set to null
915 -- when validation only mode is being used.)
916 --
917 p_copy_entity_result_id := null;
918 p_object_version_number := null;
919 hr_utility.set_location(' Leaving:'||l_proc, 80);
920 --
921 when others then
922 p_copy_entity_result_id := null;
923 p_object_version_number := null;
924 --
925 -- A validation or unexpected error has occured
926 --
927 ROLLBACK TO create_copy_entity_result;
928 raise;
929 --
930 end create_copy_entity_result;
931 -- ----------------------------------------------------------------------------
932 -- |------------------------< update_copy_entity_result >--- ------------------|
933 -- ----------------------------------------------------------------------------
934 --
935 procedure update_copy_entity_result
936 (p_validate in boolean default false
937 ,p_copy_entity_result_id in number
938 ,p_copy_entity_txn_id in number default hr_api.g_number
939 ,p_result_type_cd in varchar2 default hr_api.g_varchar2
940 ,p_number_of_copies in number default hr_api.g_number
941 ,p_status in varchar2 default hr_api.g_varchar2
942 ,p_src_copy_entity_result_id in number default hr_api.g_number
943 ,p_information_category in varchar2 default hr_api.g_varchar2
944 ,p_information1 in varchar2 default hr_api.g_varchar2
945 ,p_information2 in varchar2 default hr_api.g_varchar2
946 ,p_information3 in varchar2 default hr_api.g_varchar2
947 ,p_information4 in varchar2 default hr_api.g_varchar2
948 ,p_information5 in varchar2 default hr_api.g_varchar2
949 ,p_information6 in varchar2 default hr_api.g_varchar2
950 ,p_information7 in varchar2 default hr_api.g_varchar2
951 ,p_information8 in varchar2 default hr_api.g_varchar2
952 ,p_information9 in varchar2 default hr_api.g_varchar2
953 ,p_information10 in varchar2 default hr_api.g_varchar2
954 ,p_information11 in varchar2 default hr_api.g_varchar2
955 ,p_information12 in varchar2 default hr_api.g_varchar2
956 ,p_information13 in varchar2 default hr_api.g_varchar2
957 ,p_information14 in varchar2 default hr_api.g_varchar2
958 ,p_information15 in varchar2 default hr_api.g_varchar2
959 ,p_information16 in varchar2 default hr_api.g_varchar2
960 ,p_information17 in varchar2 default hr_api.g_varchar2
961 ,p_information18 in varchar2 default hr_api.g_varchar2
962 ,p_information19 in varchar2 default hr_api.g_varchar2
963 ,p_information20 in varchar2 default hr_api.g_varchar2
964 ,p_information21 in varchar2 default hr_api.g_varchar2
965 ,p_information22 in varchar2 default hr_api.g_varchar2
966 ,p_information23 in varchar2 default hr_api.g_varchar2
967 ,p_information24 in varchar2 default hr_api.g_varchar2
968 ,p_information25 in varchar2 default hr_api.g_varchar2
969 ,p_information26 in varchar2 default hr_api.g_varchar2
970 ,p_information27 in varchar2 default hr_api.g_varchar2
971 ,p_information28 in varchar2 default hr_api.g_varchar2
972 ,p_information29 in varchar2 default hr_api.g_varchar2
973 ,p_information30 in varchar2 default hr_api.g_varchar2
974 ,p_information31 in varchar2 default hr_api.g_varchar2
975 ,p_information32 in varchar2 default hr_api.g_varchar2
976 ,p_information33 in varchar2 default hr_api.g_varchar2
977 ,p_information34 in varchar2 default hr_api.g_varchar2
978 ,p_information35 in varchar2 default hr_api.g_varchar2
979 ,p_information36 in varchar2 default hr_api.g_varchar2
980 ,p_information37 in varchar2 default hr_api.g_varchar2
981 ,p_information38 in varchar2 default hr_api.g_varchar2
982 ,p_information39 in varchar2 default hr_api.g_varchar2
983 ,p_information40 in varchar2 default hr_api.g_varchar2
984 ,p_information41 in varchar2 default hr_api.g_varchar2
985 ,p_information42 in varchar2 default hr_api.g_varchar2
986 ,p_information43 in varchar2 default hr_api.g_varchar2
987 ,p_information44 in varchar2 default hr_api.g_varchar2
988 ,p_information45 in varchar2 default hr_api.g_varchar2
989 ,p_information46 in varchar2 default hr_api.g_varchar2
990 ,p_information47 in varchar2 default hr_api.g_varchar2
991 ,p_information48 in varchar2 default hr_api.g_varchar2
992 ,p_information49 in varchar2 default hr_api.g_varchar2
993 ,p_information50 in varchar2 default hr_api.g_varchar2
994 ,p_information51 in varchar2 default hr_api.g_varchar2
995 ,p_information52 in varchar2 default hr_api.g_varchar2
996 ,p_information53 in varchar2 default hr_api.g_varchar2
997 ,p_information54 in varchar2 default hr_api.g_varchar2
998 ,p_information55 in varchar2 default hr_api.g_varchar2
999 ,p_information56 in varchar2 default hr_api.g_varchar2
1000 ,p_information57 in varchar2 default hr_api.g_varchar2
1001 ,p_information58 in varchar2 default hr_api.g_varchar2
1002 ,p_information59 in varchar2 default hr_api.g_varchar2
1003 ,p_information60 in varchar2 default hr_api.g_varchar2
1004 ,p_information61 in varchar2 default hr_api.g_varchar2
1005 ,p_information62 in varchar2 default hr_api.g_varchar2
1006 ,p_information63 in varchar2 default hr_api.g_varchar2
1007 ,p_information64 in varchar2 default hr_api.g_varchar2
1008 ,p_information65 in varchar2 default hr_api.g_varchar2
1009 ,p_information66 in varchar2 default hr_api.g_varchar2
1010 ,p_information67 in varchar2 default hr_api.g_varchar2
1011 ,p_information68 in varchar2 default hr_api.g_varchar2
1012 ,p_information69 in varchar2 default hr_api.g_varchar2
1013 ,p_information70 in varchar2 default hr_api.g_varchar2
1014 ,p_information71 in varchar2 default hr_api.g_varchar2
1015 ,p_information72 in varchar2 default hr_api.g_varchar2
1016 ,p_information73 in varchar2 default hr_api.g_varchar2
1017 ,p_information74 in varchar2 default hr_api.g_varchar2
1018 ,p_information75 in varchar2 default hr_api.g_varchar2
1019 ,p_information76 in varchar2 default hr_api.g_varchar2
1020 ,p_information77 in varchar2 default hr_api.g_varchar2
1021 ,p_information78 in varchar2 default hr_api.g_varchar2
1022 ,p_information79 in varchar2 default hr_api.g_varchar2
1023 ,p_information80 in varchar2 default hr_api.g_varchar2
1024 ,p_information81 in varchar2 default hr_api.g_varchar2
1025 ,p_information82 in varchar2 default hr_api.g_varchar2
1026 ,p_information83 in varchar2 default hr_api.g_varchar2
1027 ,p_information84 in varchar2 default hr_api.g_varchar2
1028 ,p_information85 in varchar2 default hr_api.g_varchar2
1029 ,p_information86 in varchar2 default hr_api.g_varchar2
1030 ,p_information87 in varchar2 default hr_api.g_varchar2
1031 ,p_information88 in varchar2 default hr_api.g_varchar2
1032 ,p_information89 in varchar2 default hr_api.g_varchar2
1033 ,p_information90 in varchar2 default hr_api.g_varchar2
1034 ,p_information91 in varchar2 default hr_api.g_varchar2
1035 ,p_information92 in varchar2 default hr_api.g_varchar2
1036 ,p_information93 in varchar2 default hr_api.g_varchar2
1037 ,p_information94 in varchar2 default hr_api.g_varchar2
1038 ,p_information95 in varchar2 default hr_api.g_varchar2
1039 ,p_information96 in varchar2 default hr_api.g_varchar2
1040 ,p_information97 in varchar2 default hr_api.g_varchar2
1041 ,p_information98 in varchar2 default hr_api.g_varchar2
1042 ,p_information99 in varchar2 default hr_api.g_varchar2
1043 ,p_information100 in varchar2 default hr_api.g_varchar2
1044 ,p_information101 in varchar2 default hr_api.g_varchar2
1045 ,p_information102 in varchar2 default hr_api.g_varchar2
1046 ,p_information103 in varchar2 default hr_api.g_varchar2
1047 ,p_information104 in varchar2 default hr_api.g_varchar2
1048 ,p_information105 in varchar2 default hr_api.g_varchar2
1049 ,p_information106 in varchar2 default hr_api.g_varchar2
1050 ,p_information107 in varchar2 default hr_api.g_varchar2
1051 ,p_information108 in varchar2 default hr_api.g_varchar2
1052 ,p_information109 in varchar2 default hr_api.g_varchar2
1053 ,p_information110 in varchar2 default hr_api.g_varchar2
1054 ,p_information111 in varchar2 default hr_api.g_varchar2
1055 ,p_information112 in varchar2 default hr_api.g_varchar2
1056 ,p_information113 in varchar2 default hr_api.g_varchar2
1057 ,p_information114 in varchar2 default hr_api.g_varchar2
1058 ,p_information115 in varchar2 default hr_api.g_varchar2
1059 ,p_information116 in varchar2 default hr_api.g_varchar2
1060 ,p_information117 in varchar2 default hr_api.g_varchar2
1061 ,p_information118 in varchar2 default hr_api.g_varchar2
1062 ,p_information119 in varchar2 default hr_api.g_varchar2
1063 ,p_information120 in varchar2 default hr_api.g_varchar2
1064 ,p_information121 in varchar2 default hr_api.g_varchar2
1065 ,p_information122 in varchar2 default hr_api.g_varchar2
1066 ,p_information123 in varchar2 default hr_api.g_varchar2
1067 ,p_information124 in varchar2 default hr_api.g_varchar2
1068 ,p_information125 in varchar2 default hr_api.g_varchar2
1069 ,p_information126 in varchar2 default hr_api.g_varchar2
1070 ,p_information127 in varchar2 default hr_api.g_varchar2
1071 ,p_information128 in varchar2 default hr_api.g_varchar2
1072 ,p_information129 in varchar2 default hr_api.g_varchar2
1073 ,p_information130 in varchar2 default hr_api.g_varchar2
1074 ,p_information131 in varchar2 default hr_api.g_varchar2
1075 ,p_information132 in varchar2 default hr_api.g_varchar2
1076 ,p_information133 in varchar2 default hr_api.g_varchar2
1077 ,p_information134 in varchar2 default hr_api.g_varchar2
1078 ,p_information135 in varchar2 default hr_api.g_varchar2
1079 ,p_information136 in varchar2 default hr_api.g_varchar2
1080 ,p_information137 in varchar2 default hr_api.g_varchar2
1081 ,p_information138 in varchar2 default hr_api.g_varchar2
1082 ,p_information139 in varchar2 default hr_api.g_varchar2
1083 ,p_information140 in varchar2 default hr_api.g_varchar2
1084 ,p_information141 in varchar2 default hr_api.g_varchar2
1085 ,p_information142 in varchar2 default hr_api.g_varchar2
1086 ,p_information143 in varchar2 default hr_api.g_varchar2
1087 ,p_information144 in varchar2 default hr_api.g_varchar2
1088 ,p_information145 in varchar2 default hr_api.g_varchar2
1089 ,p_information146 in varchar2 default hr_api.g_varchar2
1090 ,p_information147 in varchar2 default hr_api.g_varchar2
1091 ,p_information148 in varchar2 default hr_api.g_varchar2
1092 ,p_information149 in varchar2 default hr_api.g_varchar2
1093 ,p_information150 in varchar2 default hr_api.g_varchar2
1094 ,p_information151 in varchar2 default hr_api.g_varchar2
1095 ,p_information152 in varchar2 default hr_api.g_varchar2
1096 ,p_information153 in varchar2 default hr_api.g_varchar2
1097 ,p_information154 in varchar2 default hr_api.g_varchar2
1098 ,p_information155 in varchar2 default hr_api.g_varchar2
1099 ,p_information156 in varchar2 default hr_api.g_varchar2
1100 ,p_information157 in varchar2 default hr_api.g_varchar2
1101 ,p_information158 in varchar2 default hr_api.g_varchar2
1102 ,p_information159 in varchar2 default hr_api.g_varchar2
1103 ,p_information160 in varchar2 default hr_api.g_varchar2
1104 ,p_information161 in varchar2 default hr_api.g_varchar2
1105 ,p_information162 in varchar2 default hr_api.g_varchar2
1106 ,p_information163 in varchar2 default hr_api.g_varchar2
1107 ,p_information164 in varchar2 default hr_api.g_varchar2
1108 ,p_information165 in varchar2 default hr_api.g_varchar2
1109 ,p_information166 in varchar2 default hr_api.g_varchar2
1110 ,p_information167 in varchar2 default hr_api.g_varchar2
1111 ,p_information168 in varchar2 default hr_api.g_varchar2
1112 ,p_information169 in varchar2 default hr_api.g_varchar2
1113 ,p_information170 in varchar2 default hr_api.g_varchar2
1114 ,p_information171 in varchar2 default hr_api.g_varchar2
1115 ,p_information172 in varchar2 default hr_api.g_varchar2
1116 ,p_information173 in varchar2 default hr_api.g_varchar2
1117 ,p_information174 in varchar2 default hr_api.g_varchar2
1118 ,p_information175 in varchar2 default hr_api.g_varchar2
1119 ,p_information176 in varchar2 default hr_api.g_varchar2
1120 ,p_information177 in varchar2 default hr_api.g_varchar2
1121 ,p_information178 in varchar2 default hr_api.g_varchar2
1122 ,p_information179 in varchar2 default hr_api.g_varchar2
1123 ,p_information180 in varchar2 default hr_api.g_varchar2
1124 ,p_information181 in varchar2 default hr_api.g_varchar2
1125 ,p_information182 in varchar2 default hr_api.g_varchar2
1126 ,p_information183 in varchar2 default hr_api.g_varchar2
1127 ,p_information184 in varchar2 default hr_api.g_varchar2
1128 ,p_information185 in varchar2 default hr_api.g_varchar2
1129 ,p_information186 in varchar2 default hr_api.g_varchar2
1130 ,p_information187 in varchar2 default hr_api.g_varchar2
1131 ,p_information188 in varchar2 default hr_api.g_varchar2
1132 ,p_information189 in varchar2 default hr_api.g_varchar2
1133 ,p_information190 in varchar2 default hr_api.g_varchar2
1134 ,p_mirror_entity_result_id in number default hr_api.g_number
1135 ,p_mirror_src_entity_result_id in number default hr_api.g_number
1136 ,p_parent_entity_result_id in number default hr_api.g_number
1137 ,p_table_route_id in number default hr_api.g_number
1138 ,p_long_attribute1 in long
1139 ,p_object_version_number in out nocopy number
1140 ,p_effective_date in date
1141 ) is
1142 --
1143 -- Declare cursors and local variables
1144 --
1145 l_proc varchar2(72) := g_package||'update_copy_entity_result';
1146 l_object_version_number pqh_copy_entity_results.object_version_number%TYPE ;
1147 --
1148 begin
1149 --
1150 hr_utility.set_location('Entering:'|| l_proc, 10);
1151 --
1152 -- Issue a savepoint if operating in validation only mode
1153 --
1154 savepoint update_copy_entity_result;
1155 --
1156 hr_utility.set_location(l_proc, 20);
1157 --
1158 -- Process Logic
1159 --
1160 l_object_version_number := p_object_version_number;
1161 --
1162 begin
1163 --
1164 -- Start of API User Hook for the before hook of update_copy_entity_results
1165 --
1166 pqh_copy_entity_results_bk2.update_copy_entity_result_b
1167 (
1168 p_copy_entity_result_id => p_copy_entity_result_id
1169 ,p_copy_entity_txn_id => p_copy_entity_txn_id
1170 ,p_result_type_cd => p_result_type_cd
1171 ,p_number_of_copies => p_number_of_copies
1172 ,p_status => p_status
1173 ,p_src_copy_entity_result_id => p_src_copy_entity_result_id
1174 ,p_information_category => p_information_category
1175 ,p_information1 => p_information1
1176 ,p_information2 => p_information2
1177 ,p_information3 => p_information3
1178 ,p_information4 => p_information4
1179 ,p_information5 => p_information5
1180 ,p_information6 => p_information6
1181 ,p_information7 => p_information7
1182 ,p_information8 => p_information8
1183 ,p_information9 => p_information9
1184 ,p_information10 => p_information10
1185 ,p_information11 => p_information11
1186 ,p_information12 => p_information12
1187 ,p_information13 => p_information13
1188 ,p_information14 => p_information14
1189 ,p_information15 => p_information15
1190 ,p_information16 => p_information16
1191 ,p_information17 => p_information17
1192 ,p_information18 => p_information18
1193 ,p_information19 => p_information19
1194 ,p_information20 => p_information20
1195 ,p_information21 => p_information21
1196 ,p_information22 => p_information22
1197 ,p_information23 => p_information23
1198 ,p_information24 => p_information24
1199 ,p_information25 => p_information25
1200 ,p_information26 => p_information26
1201 ,p_information27 => p_information27
1202 ,p_information28 => p_information28
1203 ,p_information29 => p_information29
1204 ,p_information30 => p_information30
1205 ,p_information31 => p_information31
1206 ,p_information32 => p_information32
1207 ,p_information33 => p_information33
1208 ,p_information34 => p_information34
1209 ,p_information35 => p_information35
1210 ,p_information36 => p_information36
1211 ,p_information37 => p_information37
1212 ,p_information38 => p_information38
1213 ,p_information39 => p_information39
1214 ,p_information40 => p_information40
1215 ,p_information41 => p_information41
1216 ,p_information42 => p_information42
1217 ,p_information43 => p_information43
1218 ,p_information44 => p_information44
1219 ,p_information45 => p_information45
1220 ,p_information46 => p_information46
1221 ,p_information47 => p_information47
1222 ,p_information48 => p_information48
1223 ,p_information49 => p_information49
1224 ,p_information50 => p_information50
1225 ,p_information51 => p_information51
1226 ,p_information52 => p_information52
1227 ,p_information53 => p_information53
1228 ,p_information54 => p_information54
1229 ,p_information55 => p_information55
1230 ,p_information56 => p_information56
1231 ,p_information57 => p_information57
1232 ,p_information58 => p_information58
1233 ,p_information59 => p_information59
1234 ,p_information60 => p_information60
1235 ,p_information61 => p_information61
1236 ,p_information62 => p_information62
1237 ,p_information63 => p_information63
1238 ,p_information64 => p_information64
1239 ,p_information65 => p_information65
1240 ,p_information66 => p_information66
1241 ,p_information67 => p_information67
1242 ,p_information68 => p_information68
1243 ,p_information69 => p_information69
1244 ,p_information70 => p_information70
1245 ,p_information71 => p_information71
1246 ,p_information72 => p_information72
1247 ,p_information73 => p_information73
1248 ,p_information74 => p_information74
1249 ,p_information75 => p_information75
1250 ,p_information76 => p_information76
1251 ,p_information77 => p_information77
1252 ,p_information78 => p_information78
1253 ,p_information79 => p_information79
1254 ,p_information80 => p_information80
1255 ,p_information81 => p_information81
1256 ,p_information82 => p_information82
1257 ,p_information83 => p_information83
1258 ,p_information84 => p_information84
1259 ,p_information85 => p_information85
1260 ,p_information86 => p_information86
1261 ,p_information87 => p_information87
1262 ,p_information88 => p_information88
1263 ,p_information89 => p_information89
1264 ,p_information90 => p_information90
1265 ,p_information91 =>p_information91
1266 ,p_information92 =>p_information92
1267 ,p_information93 =>p_information93
1268 ,p_information94 =>p_information94
1269 ,p_information95 =>p_information95
1270 ,p_information96 =>p_information96
1271 ,p_information97 =>p_information97
1272 ,p_information98 =>p_information98
1273 ,p_information99 =>p_information99
1274 ,p_information100 =>p_information100
1275 ,p_information101 =>p_information101
1276 ,p_information102 =>p_information102
1277 ,p_information103 =>p_information103
1278 ,p_information104 =>p_information104
1279 ,p_information105 =>p_information105
1280 ,p_information106 =>p_information106
1281 ,p_information107 =>p_information107
1282 ,p_information108 =>p_information108
1283 ,p_information109 =>p_information109
1284 ,p_information110 =>p_information110
1285 ,p_information111 =>p_information111
1286 ,p_information112 =>p_information112
1287 ,p_information113 =>p_information113
1288 ,p_information114 =>p_information114
1289 ,p_information115 =>p_information115
1290 ,p_information116 =>p_information116
1291 ,p_information117 =>p_information117
1292 ,p_information118 =>p_information118
1293 ,p_information119 =>p_information119
1294 ,p_information120 =>p_information120
1295 ,p_information121 =>p_information121
1296 ,p_information122 =>p_information122
1297 ,p_information123 =>p_information123
1298 ,p_information124 =>p_information124
1299 ,p_information125 =>p_information125
1300 ,p_information126 =>p_information126
1301 ,p_information127 =>p_information127
1302 ,p_information128 =>p_information128
1303 ,p_information129 =>p_information129
1304 ,p_information130 =>p_information130
1305 ,p_information131 =>p_information131
1306 ,p_information132 =>p_information132
1307 ,p_information133 =>p_information133
1308 ,p_information134 =>p_information134
1309 ,p_information135 =>p_information135
1310 ,p_information136 =>p_information136
1311 ,p_information137 =>p_information137
1312 ,p_information138 =>p_information138
1313 ,p_information139 =>p_information139
1314 ,p_information140 =>p_information140
1315 ,p_information141 =>p_information141
1316 ,p_information142 =>p_information142
1317 ,p_information143 =>p_information143
1318 ,p_information144 =>p_information144
1319 ,p_information145 =>p_information145
1320 ,p_information146 =>p_information146
1321 ,p_information147 =>p_information147
1322 ,p_information148 =>p_information148
1323 ,p_information149 =>p_information149
1324 ,p_information150 =>p_information150
1325 ,p_information151 =>p_information151
1326 ,p_information152 =>p_information152
1327 ,p_information153 =>p_information153
1328 ,p_information154 =>p_information154
1329 ,p_information155 =>p_information155
1330 ,p_information156 =>p_information156
1331 ,p_information157 =>p_information157
1332 ,p_information158 =>p_information158
1333 ,p_information159 =>p_information159
1334 ,p_information160 =>p_information160
1335 ,p_information161 =>p_information161
1336 ,p_information162 =>p_information162
1337 ,p_information163 =>p_information163
1338 ,p_information164 =>p_information164
1339 ,p_information165 =>p_information165
1340 ,p_information166 =>p_information166
1341 ,p_information167 =>p_information167
1342 ,p_information168 =>p_information168
1343 ,p_information169 =>p_information169
1344 ,p_information170 =>p_information170
1345 ,p_information171 =>p_information171
1346 ,p_information172 =>p_information172
1347 ,p_information173 =>p_information173
1348 ,p_information174 =>p_information174
1349 ,p_information175 =>p_information175
1350 ,p_information176 =>p_information176
1351 ,p_information177 =>p_information177
1352 ,p_information178 =>p_information178
1353 ,p_information179 =>p_information179
1354 ,p_information180 =>p_information180
1355 ,p_information181 =>p_information181
1356 ,p_information182 =>p_information182
1357 ,p_information183 =>p_information183
1358 ,p_information184 =>p_information184
1359 ,p_information185 =>p_information185
1360 ,p_information186 =>p_information186
1361 ,p_information187 =>p_information187
1362 ,p_information188 =>p_information188
1363 ,p_information189 =>p_information189
1364 ,p_information190 =>p_information190
1365 ,p_mirror_entity_result_id =>p_mirror_entity_result_id
1366 ,p_mirror_src_entity_result_id =>p_mirror_src_entity_result_id
1367 ,p_parent_entity_result_id =>p_parent_entity_result_id
1368 ,p_table_route_id =>p_table_route_id
1369 ,p_long_attribute1 =>p_long_attribute1
1370 ,p_object_version_number => p_object_version_number
1371 ,p_effective_date => trunc(p_effective_date)
1372 );
1373 exception
1374 when hr_api.cannot_find_prog_unit then
1375 hr_api.cannot_find_prog_unit_error
1376 (p_module_name => 'UPDATE_copy_entity_result'
1377 ,p_hook_type => 'BP'
1378 );
1379 --
1380 -- End of API User Hook for the before hook of update_copy_entity_results
1381 --
1382 end;
1383 --
1384 pqh_cer_upd.upd
1385 (
1386 p_copy_entity_result_id => p_copy_entity_result_id
1387 ,p_copy_entity_txn_id => p_copy_entity_txn_id
1388 ,p_result_type_cd => p_result_type_cd
1389 ,p_number_of_copies => p_number_of_copies
1390 ,p_status => p_status
1391 ,p_src_copy_entity_result_id => p_src_copy_entity_result_id
1392 ,p_information_category => p_information_category
1393 ,p_information1 => p_information1
1394 ,p_information2 => p_information2
1395 ,p_information3 => p_information3
1396 ,p_information4 => p_information4
1397 ,p_information5 => p_information5
1398 ,p_information6 => p_information6
1399 ,p_information7 => p_information7
1400 ,p_information8 => p_information8
1401 ,p_information9 => p_information9
1402 ,p_information10 => p_information10
1403 ,p_information11 => p_information11
1404 ,p_information12 => p_information12
1405 ,p_information13 => p_information13
1406 ,p_information14 => p_information14
1407 ,p_information15 => p_information15
1408 ,p_information16 => p_information16
1409 ,p_information17 => p_information17
1410 ,p_information18 => p_information18
1411 ,p_information19 => p_information19
1412 ,p_information20 => p_information20
1413 ,p_information21 => p_information21
1414 ,p_information22 => p_information22
1415 ,p_information23 => p_information23
1416 ,p_information24 => p_information24
1417 ,p_information25 => p_information25
1418 ,p_information26 => p_information26
1419 ,p_information27 => p_information27
1420 ,p_information28 => p_information28
1421 ,p_information29 => p_information29
1422 ,p_information30 => p_information30
1423 ,p_information31 => p_information31
1424 ,p_information32 => p_information32
1425 ,p_information33 => p_information33
1426 ,p_information34 => p_information34
1427 ,p_information35 => p_information35
1428 ,p_information36 => p_information36
1429 ,p_information37 => p_information37
1430 ,p_information38 => p_information38
1431 ,p_information39 => p_information39
1432 ,p_information40 => p_information40
1433 ,p_information41 => p_information41
1434 ,p_information42 => p_information42
1435 ,p_information43 => p_information43
1436 ,p_information44 => p_information44
1437 ,p_information45 => p_information45
1438 ,p_information46 => p_information46
1439 ,p_information47 => p_information47
1440 ,p_information48 => p_information48
1441 ,p_information49 => p_information49
1442 ,p_information50 => p_information50
1443 ,p_information51 => p_information51
1444 ,p_information52 => p_information52
1445 ,p_information53 => p_information53
1446 ,p_information54 => p_information54
1447 ,p_information55 => p_information55
1448 ,p_information56 => p_information56
1449 ,p_information57 => p_information57
1450 ,p_information58 => p_information58
1451 ,p_information59 => p_information59
1452 ,p_information60 => p_information60
1453 ,p_information61 => p_information61
1454 ,p_information62 => p_information62
1455 ,p_information63 => p_information63
1456 ,p_information64 => p_information64
1457 ,p_information65 => p_information65
1458 ,p_information66 => p_information66
1459 ,p_information67 => p_information67
1460 ,p_information68 => p_information68
1461 ,p_information69 => p_information69
1462 ,p_information70 => p_information70
1463 ,p_information71 => p_information71
1464 ,p_information72 => p_information72
1465 ,p_information73 => p_information73
1466 ,p_information74 => p_information74
1467 ,p_information75 => p_information75
1468 ,p_information76 => p_information76
1469 ,p_information77 => p_information77
1470 ,p_information78 => p_information78
1471 ,p_information79 => p_information79
1472 ,p_information80 => p_information80
1473 ,p_information81 => p_information81
1474 ,p_information82 => p_information82
1475 ,p_information83 => p_information83
1476 ,p_information84 => p_information84
1477 ,p_information85 => p_information85
1478 ,p_information86 => p_information86
1479 ,p_information87 => p_information87
1480 ,p_information88 => p_information88
1481 ,p_information89 => p_information89
1482 ,p_information90 => p_information90
1483 ,p_information91 =>p_information91
1484 ,p_information92 =>p_information92
1485 ,p_information93 =>p_information93
1486 ,p_information94 =>p_information94
1487 ,p_information95 =>p_information95
1488 ,p_information96 =>p_information96
1489 ,p_information97 =>p_information97
1490 ,p_information98 =>p_information98
1491 ,p_information99 =>p_information99
1492 ,p_information100 =>p_information100
1493 ,p_information101 =>p_information101
1494 ,p_information102 =>p_information102
1495 ,p_information103 =>p_information103
1496 ,p_information104 =>p_information104
1497 ,p_information105 =>p_information105
1498 ,p_information106 =>p_information106
1499 ,p_information107 =>p_information107
1500 ,p_information108 =>p_information108
1501 ,p_information109 =>p_information109
1502 ,p_information110 =>p_information110
1503 ,p_information111 =>p_information111
1504 ,p_information112 =>p_information112
1505 ,p_information113 =>p_information113
1506 ,p_information114 =>p_information114
1507 ,p_information115 =>p_information115
1508 ,p_information116 =>p_information116
1509 ,p_information117 =>p_information117
1510 ,p_information118 =>p_information118
1511 ,p_information119 =>p_information119
1512 ,p_information120 =>p_information120
1513 ,p_information121 =>p_information121
1514 ,p_information122 =>p_information122
1515 ,p_information123 =>p_information123
1516 ,p_information124 =>p_information124
1517 ,p_information125 =>p_information125
1518 ,p_information126 =>p_information126
1519 ,p_information127 =>p_information127
1520 ,p_information128 =>p_information128
1521 ,p_information129 =>p_information129
1522 ,p_information130 =>p_information130
1523 ,p_information131 =>p_information131
1524 ,p_information132 =>p_information132
1525 ,p_information133 =>p_information133
1526 ,p_information134 =>p_information134
1527 ,p_information135 =>p_information135
1528 ,p_information136 =>p_information136
1529 ,p_information137 =>p_information137
1530 ,p_information138 =>p_information138
1531 ,p_information139 =>p_information139
1532 ,p_information140 =>p_information140
1533 ,p_information141 =>p_information141
1534 ,p_information142 =>p_information142
1535 ,p_information143 =>p_information143
1536 ,p_information144 =>p_information144
1537 ,p_information145 =>p_information145
1538 ,p_information146 =>p_information146
1539 ,p_information147 =>p_information147
1540 ,p_information148 =>p_information148
1541 ,p_information149 =>p_information149
1542 ,p_information150 =>p_information150
1543 ,p_information151 =>p_information151
1544 ,p_information152 =>p_information152
1545 ,p_information153 =>p_information153
1546 ,p_information154 =>p_information154
1547 ,p_information155 =>p_information155
1548 ,p_information156 =>p_information156
1549 ,p_information157 =>p_information157
1550 ,p_information158 =>p_information158
1551 ,p_information159 =>p_information159
1552 ,p_information160 =>p_information160
1553 ,p_information161 =>p_information161
1554 ,p_information162 =>p_information162
1555 ,p_information163 =>p_information163
1556 ,p_information164 =>p_information164
1557 ,p_information165 =>p_information165
1558 ,p_information166 =>p_information166
1559 ,p_information167 =>p_information167
1560 ,p_information168 =>p_information168
1561 ,p_information169 =>p_information169
1562 ,p_information170 =>p_information170
1563 ,p_information171 =>p_information171
1564 ,p_information172 =>p_information172
1565 ,p_information173 =>p_information173
1566 ,p_information174 =>p_information174
1567 ,p_information175 =>p_information175
1568 ,p_information176 =>p_information176
1569 ,p_information177 =>p_information177
1570 ,p_information178 =>p_information178
1571 ,p_information179 =>p_information179
1572 ,p_information180 =>p_information180
1573 ,p_information181 =>p_information181
1574 ,p_information182 =>p_information182
1575 ,p_information183 =>p_information183
1576 ,p_information184 =>p_information184
1577 ,p_information185 =>p_information185
1578 ,p_information186 =>p_information186
1579 ,p_information187 =>p_information187
1580 ,p_information188 =>p_information188
1581 ,p_information189 =>p_information189
1582 ,p_information190 =>p_information190
1583 ,p_mirror_entity_result_id =>p_mirror_entity_result_id
1584 ,p_mirror_src_entity_result_id =>p_mirror_src_entity_result_id
1585 ,p_parent_entity_result_id =>p_parent_entity_result_id
1586 ,p_table_route_id =>p_table_route_id
1587 ,p_long_attribute1 =>p_long_attribute1
1588 ,p_object_version_number => l_object_version_number
1589 ,p_effective_date => trunc(p_effective_date)
1590 );
1591 --
1592 begin
1593 --
1594 -- Start of API User Hook for the after hook of update_copy_entity_results
1595 --
1596 pqh_copy_entity_results_bk2.update_copy_entity_result_a
1597 (
1598 p_copy_entity_result_id => p_copy_entity_result_id
1599 ,p_copy_entity_txn_id => p_copy_entity_txn_id
1600 ,p_result_type_cd => p_result_type_cd
1601 ,p_number_of_copies => p_number_of_copies
1602 ,p_status => p_status
1603 ,p_src_copy_entity_result_id => p_src_copy_entity_result_id
1604 ,p_information_category => p_information_category
1605 ,p_information1 => p_information1
1606 ,p_information2 => p_information2
1607 ,p_information3 => p_information3
1608 ,p_information4 => p_information4
1609 ,p_information5 => p_information5
1610 ,p_information6 => p_information6
1611 ,p_information7 => p_information7
1612 ,p_information8 => p_information8
1613 ,p_information9 => p_information9
1614 ,p_information10 => p_information10
1615 ,p_information11 => p_information11
1616 ,p_information12 => p_information12
1617 ,p_information13 => p_information13
1618 ,p_information14 => p_information14
1619 ,p_information15 => p_information15
1620 ,p_information16 => p_information16
1621 ,p_information17 => p_information17
1622 ,p_information18 => p_information18
1623 ,p_information19 => p_information19
1624 ,p_information20 => p_information20
1625 ,p_information21 => p_information21
1626 ,p_information22 => p_information22
1627 ,p_information23 => p_information23
1628 ,p_information24 => p_information24
1629 ,p_information25 => p_information25
1630 ,p_information26 => p_information26
1631 ,p_information27 => p_information27
1632 ,p_information28 => p_information28
1633 ,p_information29 => p_information29
1634 ,p_information30 => p_information30
1635 ,p_information31 => p_information31
1636 ,p_information32 => p_information32
1637 ,p_information33 => p_information33
1638 ,p_information34 => p_information34
1639 ,p_information35 => p_information35
1640 ,p_information36 => p_information36
1641 ,p_information37 => p_information37
1642 ,p_information38 => p_information38
1643 ,p_information39 => p_information39
1644 ,p_information40 => p_information40
1645 ,p_information41 => p_information41
1646 ,p_information42 => p_information42
1647 ,p_information43 => p_information43
1648 ,p_information44 => p_information44
1649 ,p_information45 => p_information45
1650 ,p_information46 => p_information46
1651 ,p_information47 => p_information47
1652 ,p_information48 => p_information48
1653 ,p_information49 => p_information49
1654 ,p_information50 => p_information50
1655 ,p_information51 => p_information51
1656 ,p_information52 => p_information52
1657 ,p_information53 => p_information53
1658 ,p_information54 => p_information54
1659 ,p_information55 => p_information55
1660 ,p_information56 => p_information56
1661 ,p_information57 => p_information57
1662 ,p_information58 => p_information58
1663 ,p_information59 => p_information59
1664 ,p_information60 => p_information60
1665 ,p_information61 => p_information61
1666 ,p_information62 => p_information62
1667 ,p_information63 => p_information63
1668 ,p_information64 => p_information64
1669 ,p_information65 => p_information65
1670 ,p_information66 => p_information66
1671 ,p_information67 => p_information67
1672 ,p_information68 => p_information68
1673 ,p_information69 => p_information69
1674 ,p_information70 => p_information70
1675 ,p_information71 => p_information71
1676 ,p_information72 => p_information72
1677 ,p_information73 => p_information73
1678 ,p_information74 => p_information74
1679 ,p_information75 => p_information75
1680 ,p_information76 => p_information76
1681 ,p_information77 => p_information77
1682 ,p_information78 => p_information78
1683 ,p_information79 => p_information79
1684 ,p_information80 => p_information80
1685 ,p_information81 => p_information81
1686 ,p_information82 => p_information82
1687 ,p_information83 => p_information83
1688 ,p_information84 => p_information84
1689 ,p_information85 => p_information85
1690 ,p_information86 => p_information86
1691 ,p_information87 => p_information87
1692 ,p_information88 => p_information88
1693 ,p_information89 => p_information89
1694 ,p_information90 => p_information90
1695 ,p_information91 =>p_information91
1696 ,p_information92 =>p_information92
1697 ,p_information93 =>p_information93
1698 ,p_information94 =>p_information94
1699 ,p_information95 =>p_information95
1700 ,p_information96 =>p_information96
1701 ,p_information97 =>p_information97
1702 ,p_information98 =>p_information98
1703 ,p_information99 =>p_information99
1704 ,p_information100 =>p_information100
1705 ,p_information101 =>p_information101
1706 ,p_information102 =>p_information102
1707 ,p_information103 =>p_information103
1708 ,p_information104 =>p_information104
1709 ,p_information105 =>p_information105
1710 ,p_information106 =>p_information106
1711 ,p_information107 =>p_information107
1712 ,p_information108 =>p_information108
1713 ,p_information109 =>p_information109
1714 ,p_information110 =>p_information110
1715 ,p_information111 =>p_information111
1716 ,p_information112 =>p_information112
1717 ,p_information113 =>p_information113
1718 ,p_information114 =>p_information114
1719 ,p_information115 =>p_information115
1720 ,p_information116 =>p_information116
1721 ,p_information117 =>p_information117
1722 ,p_information118 =>p_information118
1723 ,p_information119 =>p_information119
1724 ,p_information120 =>p_information120
1725 ,p_information121 =>p_information121
1726 ,p_information122 =>p_information122
1727 ,p_information123 =>p_information123
1728 ,p_information124 =>p_information124
1729 ,p_information125 =>p_information125
1730 ,p_information126 =>p_information126
1731 ,p_information127 =>p_information127
1732 ,p_information128 =>p_information128
1733 ,p_information129 =>p_information129
1734 ,p_information130 =>p_information130
1735 ,p_information131 =>p_information131
1736 ,p_information132 =>p_information132
1737 ,p_information133 =>p_information133
1738 ,p_information134 =>p_information134
1739 ,p_information135 =>p_information135
1740 ,p_information136 =>p_information136
1741 ,p_information137 =>p_information137
1742 ,p_information138 =>p_information138
1743 ,p_information139 =>p_information139
1744 ,p_information140 =>p_information140
1745 ,p_information141 =>p_information141
1746 ,p_information142 =>p_information142
1747 ,p_information143 =>p_information143
1748 ,p_information144 =>p_information144
1749 ,p_information145 =>p_information145
1750 ,p_information146 =>p_information146
1751 ,p_information147 =>p_information147
1752 ,p_information148 =>p_information148
1753 ,p_information149 =>p_information149
1754 ,p_information150 =>p_information150
1755 ,p_information151 =>p_information151
1756 ,p_information152 =>p_information152
1757 ,p_information153 =>p_information153
1758 ,p_information154 =>p_information154
1759 ,p_information155 =>p_information155
1760 ,p_information156 =>p_information156
1761 ,p_information157 =>p_information157
1762 ,p_information158 =>p_information158
1763 ,p_information159 =>p_information159
1764 ,p_information160 =>p_information160
1765 ,p_information161 =>p_information161
1766 ,p_information162 =>p_information162
1767 ,p_information163 =>p_information163
1768 ,p_information164 =>p_information164
1769 ,p_information165 =>p_information165
1770 ,p_information166 =>p_information166
1771 ,p_information167 =>p_information167
1772 ,p_information168 =>p_information168
1773 ,p_information169 =>p_information169
1774 ,p_information170 =>p_information170
1775 ,p_information171 =>p_information171
1776 ,p_information172 =>p_information172
1777 ,p_information173 =>p_information173
1778 ,p_information174 =>p_information174
1779 ,p_information175 =>p_information175
1780 ,p_information176 =>p_information176
1781 ,p_information177 =>p_information177
1782 ,p_information178 =>p_information178
1783 ,p_information179 =>p_information179
1784 ,p_information180 =>p_information180
1785 ,p_information181 =>p_information181
1786 ,p_information182 =>p_information182
1787 ,p_information183 =>p_information183
1788 ,p_information184 =>p_information184
1789 ,p_information185 =>p_information185
1790 ,p_information186 =>p_information186
1791 ,p_information187 =>p_information187
1792 ,p_information188 =>p_information188
1793 ,p_information189 =>p_information189
1794 ,p_information190 =>p_information190
1795 ,p_mirror_entity_result_id =>p_mirror_entity_result_id
1796 ,p_mirror_src_entity_result_id =>p_mirror_src_entity_result_id
1797 ,p_parent_entity_result_id =>p_parent_entity_result_id
1798 ,p_table_route_id =>p_table_route_id
1799 ,p_long_attribute1 =>p_long_attribute1
1800 ,p_object_version_number => l_object_version_number
1801 ,p_effective_date => trunc(p_effective_date)
1802 );
1803 exception
1804 when hr_api.cannot_find_prog_unit then
1805 hr_api.cannot_find_prog_unit_error
1806 (p_module_name => 'UPDATE_copy_entity_result'
1807 ,p_hook_type => 'AP'
1808 );
1809 --
1810 -- End of API User Hook for the after hook of update_copy_entity_results
1811 --
1812 end;
1813 --
1814 hr_utility.set_location(l_proc, 60);
1815 --
1816 -- When in validation only mode raise the Validate_Enabled exception
1817 --
1818 if p_validate then
1819 raise hr_api.validate_enabled;
1820 end if;
1821 --
1822 -- Set all output arguments
1823 --
1824 p_object_version_number := l_object_version_number;
1825 --
1826 hr_utility.set_location(' Leaving:'||l_proc, 70);
1827 --
1828 exception
1829 --
1830 when hr_api.validate_enabled then
1831 --
1832 -- As the Validate_Enabled exception has been raised
1833 -- we must rollback to the savepoint
1834 --
1835 ROLLBACK TO update_copy_entity_result;
1836 --
1837 -- Only set output warning arguments
1838 -- (Any key or derived arguments must be set to null
1839 -- when validation only mode is being used.)
1840 --
1841 hr_utility.set_location(' Leaving:'||l_proc, 80);
1842 --
1843 when others then
1844 p_object_version_number := l_object_version_number;
1845 --
1846 -- A validation or unexpected error has occured
1847 --
1848 ROLLBACK TO update_copy_entity_result;
1849 raise;
1850 --
1851 end update_copy_entity_result;
1852 -- ----------------------------------------------------------------------------
1853 -- |------------------------< delete_copy_entity_result >----------------------|
1854 -- ----------------------------------------------------------------------------
1855 --
1856 procedure delete_copy_entity_result
1857 (p_validate in boolean default false
1858 ,p_copy_entity_result_id in number
1859 ,p_object_version_number in number
1860 ,p_effective_date in date
1861 ) is
1862 --
1863 -- Declare cursors and local variables
1864 --
1865 l_proc varchar2(72) := g_package||'update_copy_entity_result';
1866 l_object_version_number pqh_copy_entity_results.object_version_number%TYPE;
1867 --
1868 begin
1869 --
1870 hr_utility.set_location('Entering:'|| l_proc, 10);
1871 --
1872 -- Issue a savepoint if operating in validation only mode
1873 --
1874 savepoint delete_copy_entity_result;
1875 --
1876 hr_utility.set_location(l_proc, 20);
1877 --
1878 -- Process Logic
1879 --
1880 l_object_version_number := p_object_version_number;
1881 --
1882 --
1883 begin
1884 --
1885 -- Start of API User Hook for the before hook of delete_copy_entity_results
1886 --
1887 pqh_copy_entity_results_bk3.delete_copy_entity_result_b
1888 (
1889 p_copy_entity_result_id => p_copy_entity_result_id
1890 ,p_object_version_number => p_object_version_number
1891 ,p_effective_date => trunc(p_effective_date)
1892 );
1893 exception
1894 when hr_api.cannot_find_prog_unit then
1895 hr_api.cannot_find_prog_unit_error
1896 (p_module_name => 'DELETE_copy_entity_result'
1897 ,p_hook_type => 'BP'
1898 );
1899 --
1900 -- End of API User Hook for the before hook of delete_copy_entity_results
1901 --
1902 end;
1903 --
1904 pqh_cer_del.del
1905 (
1906 p_copy_entity_result_id => p_copy_entity_result_id
1907 ,p_object_version_number => l_object_version_number
1908 ,p_effective_date => p_effective_date
1909 );
1910 --
1911 begin
1912 --
1913 -- Start of API User Hook for the after hook of delete_copy_entity_results
1914 --
1915 pqh_copy_entity_results_bk3.delete_copy_entity_result_a
1916 (
1917 p_copy_entity_result_id => p_copy_entity_result_id
1918 ,p_object_version_number => l_object_version_number
1919 ,p_effective_date => trunc(p_effective_date)
1920 );
1921 exception
1922 when hr_api.cannot_find_prog_unit then
1923 hr_api.cannot_find_prog_unit_error
1924 (p_module_name => 'DELETE_copy_entity_result'
1925 ,p_hook_type => 'AP'
1926 );
1927 --
1928 -- End of API User Hook for the after hook of delete_copy_entity_results
1929 --
1930 end;
1931 --
1932 hr_utility.set_location(l_proc, 60);
1933 --
1934 -- When in validation only mode raise the Validate_Enabled exception
1935 --
1936 if p_validate then
1937 raise hr_api.validate_enabled;
1938 end if;
1939 --
1940 hr_utility.set_location(' Leaving:'||l_proc, 70);
1941 --
1942 exception
1943 --
1944 when hr_api.validate_enabled then
1945 --
1946 -- As the Validate_Enabled exception has been raised
1947 -- we must rollback to the savepoint
1948 --
1949 ROLLBACK TO delete_copy_entity_result;
1950 --
1951 -- Only set output warning arguments
1952 -- (Any key or derived arguments must be set to null
1953 -- when validation only mode is being used.)
1954 --
1955 --
1956 when others then
1957 --
1958 -- A validation or unexpected error has occured
1959 --
1960 ROLLBACK TO delete_copy_entity_result;
1961 raise;
1962 --
1963 end delete_copy_entity_result;
1964 --
1965 -- ----------------------------------------------------------------------------
1966 -- |-------------------------------< lck >------------------------------------|
1967 -- ----------------------------------------------------------------------------
1968 --
1969 procedure lck
1970 (
1971 p_copy_entity_result_id in number
1972 ,p_object_version_number in number
1973 ) is
1974 --
1975 --
1976 -- Declare cursors and local variables
1977 --
1978 l_proc varchar2(72) := g_package||'lck';
1979 --
1980 begin
1981 --
1982 hr_utility.set_location('Entering:'|| l_proc, 10);
1983 --
1984 pqh_cer_shd.lck
1985 (
1986 p_copy_entity_result_id => p_copy_entity_result_id
1987 ,p_object_version_number => p_object_version_number
1988 );
1989 --
1990 hr_utility.set_location(' Leaving:'||l_proc, 70);
1991 --
1992 end lck;
1993 --
1994 end pqh_copy_entity_results_api;