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