[Home] [Help]
PACKAGE BODY: APPS.BEN_PLAN_COPY_LOADER
Source
1 Package Body ben_plan_copy_loader as
2 /* $Header: becetupd.pkb 120.0 2005/05/28 01:01:24 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Global Definitions - Internal Development Use Only |
6 -- ----------------------------------------------------------------------------
7 -- ----------------------------------------------------------------------------
8 -- |-----------------------------< load_row >---------------------------------|
9 -- ----------------------------------------------------------------------------
10 --
11 l_proc varchar2(200) := 'Ben_plan_copy_loader.';
12 l_found boolean;
13
14 --
15 -- BUG: 4354708: Added the following procedure
16 procedure delete_PLAN_DESIGN_TXN
17 (p_validate in number default 0 -- default false
18 ,p_copy_entity_txn_id in number
19 ,p_cet_object_version_number in number
20 ,p_effective_date in date
21 ) is
22 --
23 -- Declare cursors and local variables
24 --
25 l_proc varchar2(72) := 'delete_PLAN_DESIGN_TXN';
26 l_object_version_number pqh_copy_entity_txns.object_version_number%TYPE;
27 --
28 cursor c_copy_entity_txn is
29 select object_version_number
30 from pqh_copy_entity_txns
31 where copy_entity_txn_id = p_copy_entity_txn_id;
32 --
33 /* cursor c_copy_entity_attrib is
34 select copy_entity_attrib_id,cea_object_version_number
35 from ben_copy_entity_txns_vw
36 where copy_entity_txn_id = p_copy_entity_txn_id;
37 --
38 cursor c_cer is
39 select cer.*
40 from ben_copy_entity_results cer
41 where COPY_ENTITY_TXN_ID = p_COPY_ENTITY_TXN_ID;
42 --
43 l_copy_entity_attrib_id pqh_copy_entity_attribs.copy_entity_attrib_id%TYPE;
44 l_cea_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE;
45 l_cer_object_version_number pqh_copy_entity_attribs.object_version_number%TYPE; */
46
47 begin
48 --
49 hr_utility.set_location('Entering:'|| l_proc, 10);
50 --
51 -- Issue a savepoint if operating in validation only mode
52 --
53 pqh_cet_bus.chk_completed_target_err ( p_copy_entity_txn_id );
54 --
55 savepoint delete_PLAN_DESIGN_TXN;
56 --
57 hr_utility.set_location(l_proc, 20);
58 --
59 -- Process Logic
60 --
61 l_object_version_number := p_cet_object_version_number;
62
63 -- BUG: 4354708 : Removed all references to API calls.
64 -- Directly calling DELETE STATEMENTS.
65 --
66 /*
67 BEN_PLAN_DESIGN_TXNS_API.delete_plan_design_result
68 ( p_validate => p_validate
69 ,p_copy_entity_txn_id => p_copy_entity_txn_id
70 ,p_effective_date => p_effective_date
71 );
72 */
73 OPEN c_copy_entity_txn;
74 FETCH c_copy_entity_txn into l_object_version_number;
75 CLOSE c_copy_entity_txn;
76 --
77 IF (l_object_version_number = p_cet_object_version_number) THEN
78 --
79 DELETE FROM PQH_COPY_ENTITY_RESULTS
80 WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
81 --
82 DELETE FROM BEN_COPY_ENTITY_RESULTS
83 WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
84 --
85 DELETE FROM PQH_COPY_ENTITY_ATTRIBS
86 WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
87 --
88 DELETE FROM PQH_COPY_ENTITY_TXNS
89 WHERE COPY_ENTITY_TXN_ID = p_copy_entity_txn_id;
90 --
91 END IF;
92
93 /*
94 open c_copy_entity_attrib;
95 fetch c_copy_entity_attrib
96 into l_copy_entity_attrib_id,l_cea_object_version_number;
97 close c_copy_entity_attrib;
98 --
99 PQH_COPY_ENTITY_ATTRIBS_api.delete_COPY_ENTITY_ATTRIB
100 (p_validate => false
101 ,p_copy_entity_attrib_id => l_copy_entity_attrib_id
102 ,p_object_version_number => l_cea_object_version_number
103 ,p_effective_date => p_effective_date
104 );
105 --
106 -- Delete Log records
107 delete from pqh_process_log
108 where txn_id = p_copy_entity_txn_id
109 and module_cd = 'PDC_CP';
110
111 PQH_COPY_ENTITY_TXNS_api.delete_COPY_ENTITY_TXN
112 (p_validate => false
113 ,p_copy_entity_txn_id => p_copy_entity_txn_id
114 ,p_object_version_number => l_object_version_number
115 ,p_effective_date => p_effective_date
116 );
117 hr_utility.set_location(l_proc, 40);
118 --
119 */
120 --
121 hr_utility.set_location(l_proc, 30);
122 --
123 -- When in validation only mode raise the Validate_Enabled exception
124 --
125 if p_validate = 1 then
126 raise hr_API.validate_enabled;
127 end if;
128 --
129 hr_utility.set_location(' Leaving:'||l_proc, 40);
130 --
131 exception
132 --
133 when hr_API.validate_enabled then
134 --
135 -- As the Validate_Enabled exception has been raised
136 -- we must rollback to the savepoint
137 --
138 ROLLBACK TO delete_PLAN_DESIGN_TXN;
139 --
140 -- Only set output warning arguments
141 -- (Any key or derived arguments must be set to null
142 -- when validation only mode is being used.)
143 --
144 --
145 when others then
146 --
147 -- A validation or unexpected error has occured
148 --
149 ROLLBACK TO delete_PLAN_DESIGN_TXN;
150 raise;
151 --
152 end delete_PLAN_DESIGN_TXN;
153 --
154
155 Procedure load_cet_row
156 (
157 p_DISPLAY_NAME VARCHAR2
158 ,p_SRC_EFFECTIVE_DATE VARCHAR2
159 ,p_OWNER VARCHAR2
160 ,p_CONTEXT VARCHAR2
161 ,p_TRANS_CATEGORY_NAME VARCHAR2
162 ,p_ACTION_DATE VARCHAR2
163 ,p_REPLACEMENT_TYPE_CD VARCHAR2
164 ,p_START_WITH VARCHAR2
165 ,p_INCREMENT_BY VARCHAR2
166 ,p_NUMBER_OF_COPIES VARCHAR2
167 ,p_STATUS VARCHAR2
168 ,p_CONTEXT_BUSINESS_GROUP VARCHAR2
169 ) is
170
171 -- Bug : 4354708
172 l_last_update_date date;
173 l_last_updated_by number(15);
174 l_last_update_login number(15);
175 l_created_by number(15);
176 l_creation_date date;
177 l_schema varchar2(100);
178 l_industry varchar2(100);
179 l_install_status varchar2(100);
180 -- Bug : 4354708
181
182 cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
183 select copy_entity_txn_id ,object_version_number
184 from pqh_copy_entity_txns cet
185 where cet.display_name = p_display_name
186 and cet.context_business_group_id = v_context_business_group_id
187 and cet.transaction_category_id = v_transaction_category_id ;
188 -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date ;
189 --
190 cursor c2 is
191 select transaction_category_id
192 from pqh_transaction_categories tc
193 where tc.short_name = p_TRANS_CATEGORY_NAME ;
194 --
195 cursor c3 is
196 select business_group_id
197 from per_business_groups bg
198 where bg.short_name = p_CONTEXT_BUSINESS_GROUP ;
199
200 -- Bug : 4354708
201 cursor c_trig_cet is
202 select null
203 from all_triggers
204 where table_name = 'PQH_COPY_ENTITY_TXNS'
205 and trigger_name = 'PQH_COPY_ENTITY_TXNS_WHO'
206 and table_owner = l_schema
207 and status = 'ENABLED';
208 --Bug : 4354708
209
210 --
211 l_dummy varchar2(30) ;
212 l_copy_entity_txn_id number(15);
213 l_object_version_number number(7) := 1 ;
214 l_transaction_category_id number(15);
215 l_table_route_id number(15);
216 l_business_group_id number(15);
217 --
218 l_start_with pqh_copy_entity_txns.start_with%type := 'BEN_PDC_TRGT_DTL_PAGE';
219 l_status pqh_copy_entity_txns.status%type := 'IMPORTED';
220 l_old_copy_entity_txn_id number ;
221 l_ovn number ;
222 l_datestamp varchar2(30) := to_char(sysdate,'DD-MON-YYYY HH:MI:SS') ;
223 --
224
225 begin
226 hr_utility.set_location('Entering:'||l_proc, 5);
227 --
228 /* For seeded FHR copy process, set context_business_group_id to 0 */
229 if p_DISPLAY_NAME = 'GHR_FEHB_SEED_PROGRAM_DESIGN'
230 or p_DISPLAY_NAME = 'GHR_TSP_SEED_PROGRAM_DESIGN'
231 or p_DISPLAY_NAME = 'GHR_TSP_CATCHUP_SEED_PROGRAM_DESIGN'
232 then
233 l_business_group_id := 0;
234 else
235 l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
236 end if;
237 --
238 open c2 ;
239 hr_utility.set_location(' Step 30 ',30);
240 fetch c2 into l_transaction_category_id ;
241 if c2%notfound then
242 -- Throw error
243 close c2 ;
244 return ;
245 else
246 g_perf_transaction_category_id := l_transaction_category_id;
247 end if ;
248 close c2;
249 --
250 open c1(l_business_group_id , l_transaction_category_id) ;
251 --
252 hr_utility.set_location(' Step 10 ',10);
253 fetch c1 into l_old_copy_entity_txn_id,l_ovn ;
254 --
255 if c1%found then
256 -- close c1 ;
257 -- Now Update the displayName of the old transaction with timestamp appended.
258 --
259 update pqh_copy_entity_txns
260 set display_name = display_name||l_datestamp
261 where copy_entity_txn_id = l_old_copy_entity_txn_id ;
262 --
263 -- Raise exception through error
264 --return ;
265 --else
266 end if ;
267 close c1 ;
268 ---
269 -- Bug : 4354708:
270 --
271 l_found := fnd_installation.get_app_info ('PER', l_install_status, l_industry, l_schema);
272 --
273 open c_trig_cet;
274 fetch c_trig_cet into l_dummy;
275 if c_trig_cet%notfound then
276 --
277 -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_TXNS
278 -- Set WHO columns
279 l_last_update_date := sysdate;
280 l_last_updated_by := fnd_global.user_id;
281 l_last_update_login := fnd_global.login_id;
282 l_created_by := fnd_global.user_id;
283 l_creation_date := sysdate;
284 --
285 else
286 --
287 l_last_update_date := null;
288 l_last_updated_by := null;
289 l_last_update_login := null;
290 l_created_by := null;
291 l_creation_date := null;
292 --
293 end if;
294 --
295 close c_trig_cet;
296 --
297 --Bug : 4354708:
298 --
299 -- Insert a record
300 Begin
301 hr_utility.set_location('Entering C2 :'||l_proc, 5);
302 --
303 /*
304 open c2 ;
305 hr_utility.set_location(' Step 30 ',30);
306 fetch c2 into l_transaction_category_id ;
307 if c2%notfound then
308 -- Throw error
309 close c2 ;
310 return ;
311 end if ;
312 close c2;
313 */
314 --
315 /*
316 open c3 ;
317 hr_utility.set_location(' Step 40 ',40);
318 fetch c3 into l_business_group_id ;
319 close c3;
320 */
321 --
322 select pqh_copy_entity_txns_s.nextval into l_copy_entity_txn_id
323 from dual ;
324 hr_utility.set_location(' Step 50 ',50);
325 --
326 -- Insert the row into: pqh_copy_entity_txns
327 --
328 insert into pqh_copy_entity_txns
329 ( copy_entity_txn_id,
330 transaction_category_id,
331 txn_category_attribute_id,
332 context_business_group_id,
333 datetrack_mode,
334 context ,
335 action_date ,
336 src_effective_date,
337 number_of_copies ,
338 display_name,
339 replacement_type_cd,
340 start_with,
341 increment_by,
342 status,
343 object_version_number,
344 last_update_date, --Bug : 4354708
345 last_updated_by,
346 last_update_login,
347 created_by,
348 creation_date --Bug : 4354708
349 )
350 Values
351 ( l_copy_entity_txn_id,
352 l_transaction_category_id,
353 null,
354 nvl(l_business_group_id,0),
355 null,
356 p_context ,
357 to_date(p_action_date ,'DD/MM/YYYY'),
358 to_date(p_src_effective_date,'DD/MM/YYYY'),
359 to_number(p_number_of_copies) ,
360 p_display_name,
361 p_replacement_type_cd,
362 l_start_with,
366 l_last_update_date, --Bug : 4354708
363 to_number(p_increment_by) ,
364 l_status,
365 l_object_version_number,
367 l_last_updated_by,
368 l_last_update_login,
369 l_created_by,
370 l_creation_date --Bug : 4354708
371 );
372 --
373 g_perf_copy_entity_txn_id := l_copy_entity_txn_id;
374 if l_old_copy_entity_txn_id is not null then
375 --
376 -- 4354708 Remove API calls and directly call delete statements.
377 -- SEED115 has API dependencies. Hence removed all calls to APIs.
378 --BEN_PLAN_DESIGN_TXNS_API.delete_PLAN_DESIGN_TXN
379 delete_PLAN_DESIGN_TXN
380 (p_copy_entity_txn_id =>l_old_copy_entity_txn_id
381 ,p_cet_object_version_number =>l_ovn
382 ,p_effective_date =>to_date(p_src_effective_date,'DD/MM/YYYY')
383 );
384 --
385 end if;
386 --
387 hr_utility.set_location(' Leaving:'||l_proc, 10);
388 Exception
389 When hr_api.check_integrity_violated Then
390 -- A check constraint has been violated
391 pqh_cet_shd.constraint_error
392 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
393 When hr_api.parent_integrity_violated Then
394 -- Parent integrity has been violated
395 pqh_cet_shd.constraint_error
396 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
397 When hr_api.unique_integrity_violated Then
398 -- Unique integrity has been violated
399 pqh_cet_shd.constraint_error
400 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
401 When Others Then
402 Raise;
403 End ;
404 end ;
405 Procedure load_cea_row
406 (
407 p_DISPLAY_NAME VARCHAR2
408 ,p_SRC_EFFECTIVE_DATE VARCHAR2
409 ,p_OWNER VARCHAR2
410 ,p_TRANS_CATEGORY_NAME VARCHAR2
411 ,p_row_type_cd VARCHAR2
412 ,p_information_category VARCHAR2
413 ,p_information1 VARCHAR2
414 ,p_information2 VARCHAR2
415 ,p_information3 VARCHAR2
416 ,p_information4 VARCHAR2
417 ,p_information5 VARCHAR2
418 ,p_information6 VARCHAR2
419 ,p_information7 VARCHAR2
420 ,p_information8 VARCHAR2
421 ,p_information9 VARCHAR2
422 ,p_information10 VARCHAR2
423 ,p_information11 VARCHAR2
424 ,p_information12 VARCHAR2
425 ,p_information13 VARCHAR2
426 ,p_information14 VARCHAR2
427 ,p_information15 VARCHAR2
428 ,p_information16 VARCHAR2
429 ,p_information17 VARCHAR2
430 ,p_information18 VARCHAR2
431 ,p_information19 VARCHAR2
432 ,p_information20 VARCHAR2
433 ,p_information21 VARCHAR2
434 ,p_information22 VARCHAR2
435 ,p_information23 VARCHAR2
436 ,p_information24 VARCHAR2
437 ,p_information25 VARCHAR2
438 ,p_information26 VARCHAR2
439 ,p_information27 VARCHAR2
440 ,p_information28 VARCHAR2
441 ,p_information29 VARCHAR2
442 ,p_information30 VARCHAR2
443 ) is
444 -- Bug : 4354708
445 l_last_update_date date;
446 l_last_updated_by number(15);
447 l_last_update_login number(15);
448 l_created_by number(15);
449 l_creation_date date;
450 l_schema varchar2(100);
451 l_industry varchar2(100);
452 l_install_status varchar2(100);
453 -- Bug : 4354708
454 --
455 cursor c2 is
456 select transaction_category_id
457 from pqh_transaction_categories tc
458 where tc.short_name = p_TRANS_CATEGORY_NAME ;
459 --
460 cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
461 select null
462 from pqh_copy_entity_txns cet,
463 pqh_copy_entity_attribs cea
464 where cet.display_name = p_display_name
465 and cet.context_business_group_id = v_context_business_group_id
466 and cet.transaction_category_id = v_transaction_category_id
467 -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date
468 and cet.copy_entity_txn_id = cea.copy_entity_txn_id ;
469 --
470 cursor c3(v_context_business_group_id number, v_transaction_category_id number) is
471 select copy_entity_txn_id
472 from pqh_copy_entity_txns cet
473 where cet.display_name = p_display_name
477
474 and cet.context_business_group_id = v_context_business_group_id
475 and cet.transaction_category_id = v_transaction_category_id ;
476 -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date ;
478 --Bug : 4354708
479 cursor c_trig_cea is
480 select null
481 from all_triggers
482 where table_name = 'PQH_COPY_ENTITY_ATTRIBS'
483 and trigger_name = 'PQH_COPY_ENTITY_ATTRIBS_WHO'
484 and table_owner = l_schema
485 and status = 'ENABLED';
486 --Bug : 4354708
487
488 --
489 l_dummy varchar2(30) ;
490 l_copy_entity_txn_id number(15);
491 l_object_version_number number(7) := 1 ;
492 l_copy_entity_attrib_id number(15);
493 l_business_group_id number ;
494 l_transaction_category_id number ;
495 --
496 l_target_typ_cd pqh_copy_entity_attribs.information3%type := 'BEN_PDIMPT';
497 begin
498 --
499 /* For seeded FHR copy process, set context_business_group_id to 0 */
500 if p_DISPLAY_NAME = 'GHR_FEHB_SEED_PROGRAM_DESIGN' then
501 l_business_group_id := 0;
502 else
503 l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
504 end if;
505 --
506 if g_perf_transaction_category_id is null then
507 open c2 ;
508 hr_utility.set_location(' Step 30 ',30);
509 fetch c2 into l_transaction_category_id ;
510 g_perf_transaction_category_id := l_transaction_category_id;
511 if c2%notfound then
512 -- Throw error
513 close c2 ;
514 return ;
515 end if ;
516 close c2;
517 else
518 l_transaction_category_id := g_perf_transaction_category_id;
519 end if;
520 --
521 -- Bug : 4354708
522 --
523 l_found := fnd_installation.get_app_info ('PER', l_install_status, l_industry, l_schema);
524 --
525 open c_trig_cea;
526 fetch c_trig_cea into l_dummy;
527 if c_trig_cea%notfound then
528 --
529 -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_ATTRIBS
530 -- Set WHO columns
531 l_last_update_date := sysdate;
532 l_last_updated_by := fnd_global.user_id;
533 l_last_update_login := fnd_global.login_id;
534 l_created_by := fnd_global.user_id;
535 l_creation_date := sysdate;
536 --
537 else
538 --
539 l_last_update_date := null;
540 l_last_updated_by := null;
541 l_last_update_login := null;
542 l_created_by := null;
543 l_creation_date := null;
544 --
545 end if;
546 --
547 close c_trig_cea;
548 --
549 --Bug : 4354708
550 --
551 --
552 open c1(l_business_group_id , l_transaction_category_id) ;
553 fetch c1 into l_dummy ;
554 if c1%found then
555 -- Raise exception through error
556 close c1 ;
557 return ;
558 else
559 close c1 ;
560 -- Insert a record
561 Begin
562 if g_perf_copy_entity_txn_id is null then
563 open c3 (l_business_group_id , l_transaction_category_id);
564 fetch c3 into l_copy_entity_txn_id ;
565 g_perf_copy_entity_txn_id := l_copy_entity_txn_id;
566 close c3;
567 else
568 l_copy_entity_txn_id := g_perf_copy_entity_txn_id;
569 end if;
570 select pqh_copy_entity_attribs_s.nextval into l_copy_entity_attrib_id
571 from dual ;
572 --
573 -- Insert the row into: pqh_copy_entity_attribs
574 --
575 hr_utility.set_location('Entering:'||l_proc, 5);
576 insert into pqh_copy_entity_attribs
577 ( copy_entity_attrib_id,
578 copy_entity_txn_id,
579 row_type_cd,
580 information_category,
581 information1,
582 information2,
583 information3,
584 information4,
585 information5,
586 information6,
587 information7,
588 information8,
589 information9,
590 information10,
591 information11,
592 information12,
593 information13,
594 information14,
595 information15,
596 information16,
597 information17,
598 information18,
599 information19,
600 information20,
601 information21,
602 information22,
606 information26,
603 information23,
604 information24,
605 information25,
607 information27,
608 information28,
609 information29,
610 information30,
611 object_version_number,
612 last_update_date, --Bug : 4354708
613 last_updated_by,
614 last_update_login,
615 created_by,
616 creation_date --Bug : 4354708
617 )
618 Values
619 ( l_copy_entity_attrib_id,
620 l_copy_entity_txn_id,
621 p_row_type_cd,
622 p_information_category,
623 p_information1,
624 p_information2,
625 l_target_typ_cd,
626 p_information4,
627 p_information5,
628 p_information6,
629 p_information7,
630 p_information8,
631 p_information9,
632 p_information10,
633 p_information11,
634 p_information12,
635 p_information13,
636 p_information14,
637 p_information15,
638 p_information16,
639 p_information17,
640 p_information18,
641 p_information19,
642 p_information20,
643 p_information21,
644 p_information22,
645 p_information23,
646 p_information24,
647 p_information25,
648 p_information26,
649 p_information27,
650 p_information28,
651 p_information29,
652 p_information30,
653 l_object_version_number,
654 l_last_update_date, --Bug : 4354708
655 l_last_updated_by,
656 l_last_update_login,
657 l_created_by,
658 l_creation_date --Bug : 4354708
659 );
660 --
661 hr_utility.set_location(' Leaving:'||l_proc, 10);
662 Exception
663 When hr_api.check_integrity_violated Then
664 -- A check constraint has been violated
665 pqh_cea_shd.constraint_error
666 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
667 When hr_api.parent_integrity_violated Then
668 -- Parent integrity has been violated
669 pqh_cea_shd.constraint_error
670 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
671 When hr_api.unique_integrity_violated Then
672 -- Unique integrity has been violated
673 pqh_cea_shd.constraint_error
674 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
675 When Others Then
676 Raise;
677 End ;
678 end if ;
679 null;
680 end ;
681 --
682 Procedure load_cer_row
683 (
684 p_DISPLAY_NAME VARCHAR2
685 ,p_SRC_EFFECTIVE_DATE VARCHAR2
686 ,p_OWNER VARCHAR2
687 ,p_TRANS_CATEGORY_NAME VARCHAR2
688 ,p_RESULT_TYPE_CD VARCHAR2
689 ,p_NUMBER_OF_COPIES VARCHAR2
690 ,p_STATUS VARCHAR2
691 ,p_information_category VARCHAR2
692 ,p_information1 VARCHAR2
693 ,p_information2 VARCHAR2
694 ,p_information3 VARCHAR2
695 ,p_information4 VARCHAR2
696 ,p_information5 VARCHAR2
697 ,p_information6 VARCHAR2
698 ,p_information7 VARCHAR2
699 ,p_information8 VARCHAR2
700 ,p_information9 VARCHAR2
701 ,p_information10 VARCHAR2
702 ,p_information11 VARCHAR2
703 ,p_information12 VARCHAR2
704 ,p_information13 VARCHAR2
705 ,p_information14 VARCHAR2
706 ,p_information15 VARCHAR2
707 ,p_information16 VARCHAR2
708 ,p_information17 VARCHAR2
709 ,p_information18 VARCHAR2
710 ,p_information19 VARCHAR2
711 ,p_information20 VARCHAR2
712 ,p_information21 VARCHAR2
713 ,p_information22 VARCHAR2
714 ,p_information23 VARCHAR2
715 ,p_information24 VARCHAR2
716 ,p_information25 VARCHAR2
717 ,p_information26 VARCHAR2
718 ,p_information27 VARCHAR2
719 ,p_information28 VARCHAR2
720 ,p_information29 VARCHAR2
721 ,p_information30 VARCHAR2
722 ,p_information31 VARCHAR2
723 ,p_information32 VARCHAR2
724 ,p_information33 VARCHAR2
725 ,p_information34 VARCHAR2
726 ,p_information35 VARCHAR2
727 ,p_information36 VARCHAR2
728 ,p_information37 VARCHAR2
729 ,p_information38 VARCHAR2
730 ,p_information39 VARCHAR2
731 ,p_information40 VARCHAR2
735 ,p_information44 VARCHAR2
732 ,p_information41 VARCHAR2
733 ,p_information42 VARCHAR2
734 ,p_information43 VARCHAR2
736 ,p_information45 VARCHAR2
737 ,p_information46 VARCHAR2
738 ,p_information47 VARCHAR2
739 ,p_information48 VARCHAR2
740 ,p_information49 VARCHAR2
741 ,p_information50 VARCHAR2
742 ,p_information51 VARCHAR2
743 ,p_information52 VARCHAR2
744 ,p_information53 VARCHAR2
745 ,p_information54 VARCHAR2
746 ,p_information55 VARCHAR2
747 ,p_information56 VARCHAR2
748 ,p_information57 VARCHAR2
749 ,p_information58 VARCHAR2
750 ,p_information59 VARCHAR2
751 ,p_information60 VARCHAR2
752 ,p_information61 VARCHAR2
753 ,p_information62 VARCHAR2
754 ,p_information63 VARCHAR2
755 ,p_information64 VARCHAR2
756 ,p_information65 VARCHAR2
757 ,p_information66 VARCHAR2
758 ,p_information67 VARCHAR2
759 ,p_information68 VARCHAR2
760 ,p_information69 VARCHAR2
761 ,p_information70 VARCHAR2
762 ,p_information71 VARCHAR2
763 ,p_information72 VARCHAR2
764 ,p_information73 VARCHAR2
765 ,p_information74 VARCHAR2
766 ,p_information75 VARCHAR2
767 ,p_information76 VARCHAR2
768 ,p_information77 VARCHAR2
769 ,p_information78 VARCHAR2
770 ,p_information79 VARCHAR2
771 ,p_information80 VARCHAR2
772 ,p_information81 VARCHAR2
773 ,p_information82 VARCHAR2
774 ,p_information83 VARCHAR2
775 ,p_information84 VARCHAR2
776 ,p_information85 VARCHAR2
777 ,p_information86 VARCHAR2
778 ,p_information87 VARCHAR2
779 ,p_information88 VARCHAR2
780 ,p_information89 VARCHAR2
781 ,p_information90 VARCHAR2
782 ,p_information91 VARCHAR2
783 ,p_information92 VARCHAR2
784 ,p_information93 VARCHAR2
785 ,p_information94 VARCHAR2
786 ,p_information95 VARCHAR2
787 ,p_information96 VARCHAR2
788 ,p_information97 VARCHAR2
789 ,p_information98 VARCHAR2
790 ,p_information99 VARCHAR2
791 ,p_information100 VARCHAR2
792 ,p_information101 VARCHAR2
793 ,p_information102 VARCHAR2
794 ,p_information103 VARCHAR2
795 ,p_information104 VARCHAR2
796 ,p_information105 VARCHAR2
797 ,p_information106 VARCHAR2
798 ,p_information107 VARCHAR2
799 ,p_information108 VARCHAR2
800 ,p_information109 VARCHAR2
801 ,p_information110 VARCHAR2
802 ,p_information111 VARCHAR2
803 ,p_information112 VARCHAR2
804 ,p_information113 VARCHAR2
805 ,p_information114 VARCHAR2
806 ,p_information115 VARCHAR2
807 ,p_information116 VARCHAR2
808 ,p_information117 VARCHAR2
809 ,p_information118 VARCHAR2
810 ,p_information119 VARCHAR2
811 ,p_information120 VARCHAR2
812 ,p_information121 VARCHAR2
813 ,p_information122 VARCHAR2
814 ,p_information123 VARCHAR2
815 ,p_information124 VARCHAR2
816 ,p_information125 VARCHAR2
817 ,p_information126 VARCHAR2
818 ,p_information127 VARCHAR2
819 ,p_information128 VARCHAR2
820 ,p_information129 VARCHAR2
821 ,p_information130 VARCHAR2
822 ,p_information131 VARCHAR2
823 ,p_information132 VARCHAR2
824 ,p_information133 VARCHAR2
825 ,p_information134 VARCHAR2
826 ,p_information135 VARCHAR2
827 ,p_information136 VARCHAR2
828 ,p_information137 VARCHAR2
829 ,p_information138 VARCHAR2
830 ,p_information139 VARCHAR2
831 ,p_information140 VARCHAR2
832 ,p_information141 VARCHAR2
833 ,p_information142 VARCHAR2
834 ,p_information143 VARCHAR2
835 ,p_information144 VARCHAR2
836 ,p_information145 VARCHAR2
837 ,p_information146 VARCHAR2
838 ,p_information147 VARCHAR2
839 ,p_information148 VARCHAR2
843 ,p_information152 VARCHAR2
840 ,p_information149 VARCHAR2
841 ,p_information150 VARCHAR2
842 ,p_information151 VARCHAR2
844 ,p_information153 VARCHAR2
845 ,p_information154 VARCHAR2
846 ,p_information155 VARCHAR2
847 ,p_information156 VARCHAR2
848 ,p_information157 VARCHAR2
849 ,p_information158 VARCHAR2
850 ,p_information159 VARCHAR2
851 ,p_information160 VARCHAR2
852 ,p_information161 VARCHAR2
853 ,p_information162 VARCHAR2
854 ,p_information163 VARCHAR2
855 ,p_information164 VARCHAR2
856 ,p_information165 VARCHAR2
857 ,p_information166 VARCHAR2
858 ,p_information167 VARCHAR2
859 ,p_information168 VARCHAR2
860 ,p_information169 VARCHAR2
861 ,p_information170 VARCHAR2
862 ,p_information171 VARCHAR2
863 ,p_information172 VARCHAR2
864 ,p_information173 VARCHAR2
865 ,p_information174 VARCHAR2
866 ,p_information175 VARCHAR2
867 ,p_information176 VARCHAR2
868 ,p_information177 VARCHAR2
869 ,p_information178 VARCHAR2
870 ,p_information179 VARCHAR2
871 ,p_information180 VARCHAR2
872 ,p_information181 VARCHAR2
873 ,p_information182 VARCHAR2
874 ,p_information183 VARCHAR2
875 ,p_information184 VARCHAR2
876 ,p_information185 VARCHAR2
877 ,p_information186 VARCHAR2
878 ,p_information187 VARCHAR2
879 ,p_information188 VARCHAR2
880 ,p_information189 VARCHAR2
881 ,p_information190 VARCHAR2
882 ,p_table_alias VARCHAR2
883 ,p_mirror_entity_result_id VARCHAR2
884 ,p_mirror_src_entity_result_id VARCHAR2
885 ,p_parent_entity_result_id VARCHAR2
886 ,p_long_attribute1 VARCHAR2
887 ) is
888 -- Bug : 4354708
889 l_last_update_date date;
890 l_last_updated_by number(15);
891 l_last_update_login number(15);
892 l_created_by number(15);
893 l_creation_date date;
894 l_schema varchar2(100);
895 l_industry varchar2(100);
896 l_install_status varchar2(100);
897 -- Bug : 4354708
898 cursor c2 is
899 select transaction_category_id
900 from pqh_transaction_categories tc
901 where tc.short_name = p_TRANS_CATEGORY_NAME ;
902 --
903 cursor c1(v_context_business_group_id number, v_transaction_category_id number) is
904 select null
905 from pqh_copy_entity_txns cet,
906 pqh_copy_entity_results cer
907 where cet.display_name = p_display_name
908 and cet.context_business_group_id = v_context_business_group_id
909 and cet.transaction_category_id = v_transaction_category_id
910 -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date
911 and cet.copy_entity_txn_id = cer.copy_entity_txn_id
912 and ( p_mirror_entity_result_id is null or
913 cer.mirror_entity_result_id = to_number(p_mirror_entity_result_id) )
914 and ( p_mirror_src_entity_result_id is null or
915 cer.mirror_src_entity_result_id = to_number(p_mirror_src_entity_result_id)) ;
916 --
917 cursor c3(v_context_business_group_id number, v_transaction_category_id number) is
918 select copy_entity_txn_id
919 from pqh_copy_entity_txns cet
920 where cet.display_name = p_display_name
921 and cet.context_business_group_id = v_context_business_group_id
922 and cet.transaction_category_id = v_transaction_category_id ;
923 -- and to_char(cet.src_effective_date,'DD/MM/YYYY') = p_src_effective_date ;
924 --
925 cursor c4 is
926 select table_route_id
927 from pqh_table_route tr
928 where table_alias = p_table_alias
929 and tr.from_clause = 'OAB' ;
930 --
931 --Bug : 4354708
932 cursor c_trig_cer is
933 select null
934 from all_triggers
935 where table_name = 'PQH_COPY_ENTITY_RESULTS'
936 and trigger_name = 'PQH_COPY_ENTITY_RESULTS_WHO'
937 and table_owner = l_schema
938 and status = 'ENABLED';
939 --Bug : 4354708
940
941 l_dummy varchar2(30) ;
942 l_copy_entity_txn_id number(15);
943 l_object_version_number number(7) := 1 ;
944 l_copy_entity_attrib_id number(15);
945 l_table_route_id number(15);
946 l_copy_entity_result_id number(15);
947 l_business_group_id number ;
948 l_transaction_category_id number ;
949 --
950 begin
951 --
952 /* For seeded FHR copy process, set context_business_group_id to 0 */
953 if p_DISPLAY_NAME = 'GHR_FEHB_SEED_PROGRAM_DESIGN' then
954 l_business_group_id := 0;
955 else
956 l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
960 open c2 ;
957 end if;
958 --
959 if g_perf_transaction_category_id is null then
961 hr_utility.set_location(' Step 30 ',30);
962 fetch c2 into l_transaction_category_id ;
963 g_perf_transaction_category_id := l_transaction_category_id;
964 if c2%notfound then
965 -- Throw error
966 close c2 ;
967 return ;
968 end if ;
969 close c2;
970 else
971 l_transaction_category_id := g_perf_transaction_category_id;
972 end if;
973 --
974 /*
975 open c1(l_business_group_id , l_transaction_category_id) ;
976 fetch c1 into l_dummy ;
977 if c1%found then
978 -- Raise exception through error
979 close c1;
980 return ;
981 else
982 close c1;
983 -- Insert a record
984 */
985
986 --
987 -- Bug : 4354708
988 --
989 l_found := fnd_installation.get_app_info ('PER', l_install_status, l_industry, l_schema);
990 --
991 open c_trig_cer;
992 fetch c_trig_cer into l_dummy;
993 if c_trig_cer%notfound then
994 --
995 -- WHO Trigger is not defined on the table PQH_COPY_ENTITY_RESULTS
996 -- Set WHO columns
997 l_last_update_date := sysdate;
998 l_last_updated_by := fnd_global.user_id;
999 l_last_update_login := fnd_global.login_id;
1000 l_created_by := fnd_global.user_id;
1001 l_creation_date := sysdate;
1002 --
1003 else
1004 --
1005 l_last_update_date := null;
1006 l_last_updated_by := null;
1007 l_last_update_login := null;
1008 l_created_by := null;
1009 l_creation_date := null;
1010 --
1011 end if;
1012 --
1013 close c_trig_cer;
1014 --
1015 --Bug : 4354708
1016 --
1017
1018 Begin
1019 if g_perf_copy_entity_txn_id is null then
1020 open c3(l_business_group_id , l_transaction_category_id) ;
1021 fetch c3 into l_copy_entity_txn_id ;
1022 g_perf_copy_entity_txn_id := l_copy_entity_txn_id;
1023 close c3;
1024 else
1025 l_copy_entity_txn_id := g_perf_copy_entity_txn_id;
1026 end if;
1027 --
1028 open c4 ;
1029 fetch c4 into l_table_route_id ;
1030 close c4;
1031 --
1032 /*
1033 select pqh_copy_entity_results_s.nextval into l_copy_entity_result_id
1034 from dual ;
1035 */
1036 --
1037 insert into pqh_copy_entity_results
1038 ( copy_entity_result_id,
1039 copy_entity_txn_id,
1040 result_type_cd,
1041 number_of_copies,
1042 status,
1043 src_copy_entity_result_id,
1044 information_category,
1045 information1,
1046 information2,
1047 information3,
1048 information4,
1049 information5,
1050 information6,
1051 information7,
1052 information8,
1053 information9,
1054 information10,
1055 information11,
1056 information12,
1057 information13,
1058 information14,
1059 information15,
1060 information16,
1061 information17,
1062 information18,
1063 information19,
1064 information20,
1065 information21,
1066 information22,
1067 information23,
1068 information24,
1069 information25,
1070 information26,
1071 information27,
1072 information28,
1073 information29,
1074 information30,
1075 information31,
1076 information32,
1077 information33,
1078 information34,
1079 information35,
1080 information36,
1081 information37,
1082 information38,
1083 information39,
1084 information40,
1085 information41,
1086 information42,
1087 information43,
1088 information44,
1089 information45,
1090 information46,
1091 information47,
1092 information48,
1093 information49,
1094 information50,
1095 information51,
1096 information52,
1097 information53,
1098 information54,
1099 information55,
1100 information56,
1101 information57,
1102 information58,
1103 information59,
1104 information60,
1105 information61,
1106 information62,
1107 information63,
1108 information64,
1109 information65,
1110 information66,
1111 information67,
1112 information68,
1113 information69,
1114 information70,
1115 information71,
1116 information72,
1117 information73,
1118 information74,
1119 information75,
1120 information76,
1121 information77,
1122 information78,
1123 information79,
1124 information80,
1125 information81,
1126 information82,
1127 information83,
1128 information84,
1129 information85,
1130 information86,
1131 information87,
1132 information88,
1133 information89,
1134 information90,
1135 information91 ,
1136 information92 ,
1137 information93 ,
1138 information94 ,
1139 information95 ,
1140 information96 ,
1141 information97 ,
1142 information98 ,
1143 information99 ,
1144 information100 ,
1145 information101 ,
1146 information102 ,
1147 information103 ,
1148 information104 ,
1149 information105 ,
1150 information106 ,
1151 information107 ,
1152 information108 ,
1153 information109 ,
1154 information110 ,
1155 information111 ,
1156 information112 ,
1157 information113 ,
1158 information114 ,
1159 information115 ,
1160 information116 ,
1161 information117 ,
1162 information118 ,
1163 information119 ,
1164 information120 ,
1165 information121 ,
1166 information122 ,
1167 information123 ,
1168 information124 ,
1169 information125 ,
1170 information126 ,
1171 information127 ,
1172 information128 ,
1173 information129 ,
1174 information130 ,
1175 information131 ,
1176 information132 ,
1177 information133 ,
1178 information134 ,
1179 information135 ,
1180 information136 ,
1181 information137 ,
1182 information138 ,
1183 information139 ,
1184 information140 ,
1185 information141 ,
1186 information142 ,
1187 information143 ,
1188 information144 ,
1189 information145 ,
1190 information146 ,
1191 information147 ,
1192 information148 ,
1193 information149 ,
1194 information150 ,
1195 information151 ,
1196 information152 ,
1197 information153 ,
1198 information154 ,
1199 information155 ,
1200 information156 ,
1201 information157 ,
1202 information158 ,
1203 information159 ,
1204 information160 ,
1205 information161 ,
1206 information162 ,
1207 information163 ,
1208 information164 ,
1209 information165 ,
1210 information166 ,
1211 information167 ,
1212 information168 ,
1213 information169 ,
1214 information170 ,
1215 information171 ,
1216 information172 ,
1217 information173 ,
1218 information174 ,
1219 information175 ,
1220 information176 ,
1221 information177 ,
1222 information178 ,
1223 information179 ,
1224 information180 ,
1225 information181 ,
1226 information182 ,
1227 information183 ,
1228 information184 ,
1229 information185 ,
1230 information186 ,
1231 information187 ,
1232 information188 ,
1233 information189 ,
1234 information190 ,
1235 object_version_number ,
1236 table_route_id ,
1237 mirror_entity_result_id,
1238 mirror_src_entity_result_id,
1239 parent_entity_result_id,
1240 long_attribute1,
1241 last_update_date, --Bug : 4354708
1242 last_updated_by,
1243 last_update_login,
1244 created_by,
1245 creation_date --Bug : 4354708
1246 )
1247 Values
1248 ( pqh_copy_entity_results_s.nextval, -- l_copy_entity_result_id,
1249 l_copy_entity_txn_id,
1250 p_result_type_cd,
1251 to_number(p_number_of_copies),
1255 p_information1,
1252 p_status,
1253 null, -- p_src_copy_entity_result_id,
1254 p_information_category,
1256 p_information2,
1257 p_information3,
1258 p_information4,
1259 p_information5,
1260 p_information6,
1261 p_information7,
1262 p_information8,
1263 p_information9,
1264 p_information10,
1265 p_information11,
1266 p_information12,
1267 p_information13,
1268 p_information14,
1269 p_information15,
1270 p_information16,
1271 p_information17,
1272 p_information18,
1273 p_information19,
1274 p_information20,
1275 p_information21,
1276 p_information22,
1277 p_information23,
1278 p_information24,
1279 p_information25,
1280 p_information26,
1281 p_information27,
1282 p_information28,
1283 p_information29,
1284 p_information30,
1285 p_information31,
1286 p_information32,
1287 p_information33,
1288 p_information34,
1289 p_information35,
1290 p_information36,
1291 p_information37,
1292 p_information38,
1293 p_information39,
1294 p_information40,
1295 p_information41,
1296 p_information42,
1297 p_information43,
1298 p_information44,
1299 p_information45,
1300 p_information46,
1301 p_information47,
1302 p_information48,
1303 p_information49,
1304 p_information50,
1305 p_information51,
1306 p_information52,
1307 p_information53,
1308 p_information54,
1309 p_information55,
1310 p_information56,
1311 p_information57,
1312 p_information58,
1313 p_information59,
1314 p_information60,
1315 p_information61,
1316 p_information62,
1317 p_information63,
1318 p_information64,
1319 p_information65,
1320 p_information66,
1321 p_information67,
1322 p_information68,
1323 p_information69,
1324 p_information70,
1325 p_information71,
1326 p_information72,
1327 p_information73,
1328 p_information74,
1329 p_information75,
1330 p_information76,
1331 p_information77,
1332 p_information78,
1333 p_information79,
1334 p_information80,
1335 p_information81,
1336 p_information82,
1337 p_information83,
1338 p_information84,
1339 p_information85,
1340 p_information86,
1341 p_information87,
1342 p_information88,
1343 p_information89,
1344 p_information90,
1345 p_information91 ,
1346 p_information92 ,
1347 p_information93 ,
1348 p_information94 ,
1349 p_information95 ,
1350 p_information96 ,
1351 p_information97 ,
1352 p_information98 ,
1353 p_information99 ,
1354 p_information100 ,
1355 p_information101 ,
1356 p_information102 ,
1357 p_information103 ,
1358 p_information104 ,
1359 p_information105 ,
1360 p_information106 ,
1361 p_information107 ,
1362 p_information108 ,
1363 p_information109 ,
1364 p_information110 ,
1365 p_information111 ,
1366 p_information112 ,
1367 p_information113 ,
1368 p_information114 ,
1369 p_information115 ,
1370 p_information116 ,
1371 p_information117 ,
1372 p_information118 ,
1373 p_information119 ,
1374 p_information120 ,
1375 p_information121 ,
1376 p_information122 ,
1377 p_information123 ,
1378 p_information124 ,
1379 p_information125 ,
1380 p_information126 ,
1381 p_information127 ,
1382 p_information128 ,
1383 p_information129 ,
1384 p_information130 ,
1385 p_information131 ,
1386 p_information132 ,
1387 p_information133 ,
1388 p_information134 ,
1389 p_information135 ,
1390 p_information136 ,
1391 p_information137 ,
1392 p_information138 ,
1393 p_information139 ,
1397 p_information143 ,
1394 p_information140 ,
1395 p_information141 ,
1396 p_information142 ,
1398 p_information144 ,
1399 p_information145 ,
1400 p_information146 ,
1401 p_information147 ,
1402 p_information148 ,
1403 p_information149 ,
1404 p_information150 ,
1405 p_information151 ,
1406 p_information152 ,
1407 p_information153 ,
1408 p_information154 ,
1409 p_information155 ,
1410 p_information156 ,
1411 p_information157 ,
1412 p_information158 ,
1413 p_information159 ,
1414 p_information160 ,
1415 p_information161 ,
1416 p_information162 ,
1417 p_information163 ,
1418 p_information164 ,
1419 p_information165 ,
1420 p_information166 ,
1421 p_information167 ,
1422 p_information168 ,
1423 p_information169 ,
1424 p_information170 ,
1425 p_information171 ,
1426 p_information172 ,
1427 p_information173 ,
1428 p_information174 ,
1429 p_information175 ,
1430 p_information176 ,
1431 p_information177 ,
1432 p_information178 ,
1433 p_information179 ,
1434 p_information180 ,
1435 p_information181 ,
1436 p_information182 ,
1437 p_information183 ,
1438 p_information184 ,
1439 p_information185 ,
1440 p_information186 ,
1441 p_information187 ,
1442 p_information188 ,
1443 p_information189 ,
1444 p_information190 ,
1445 l_object_version_number ,
1446 l_table_route_id ,
1447 to_number(p_mirror_entity_result_id) ,
1448 to_number(p_mirror_src_entity_result_id),
1449 to_number(p_parent_entity_result_id),
1450 p_long_attribute1 ,
1451 l_last_update_date, --Bug : 4354708
1452 l_last_updated_by,
1453 l_last_update_login,
1454 l_created_by,
1455 l_creation_date --Bug : 4354708
1456 );
1457 --
1458 hr_utility.set_location(' Leaving:'||l_proc, 10);
1459 Exception
1460 When hr_api.check_integrity_violated Then
1461 -- A check constraint has been violated
1462 pqh_cer_shd.constraint_error
1463 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1464 When hr_api.parent_integrity_violated Then
1465 -- Parent integrity has been violated
1466 pqh_cer_shd.constraint_error
1467 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1468 When hr_api.unique_integrity_violated Then
1469 -- Unique integrity has been violated
1470 pqh_cer_shd.constraint_error
1471 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
1472 When Others Then
1473 Raise;
1474 End ;
1475 -- end if ;
1476 end;
1477 --
1478 Procedure load_cpe_row
1479 (
1480 p_DISPLAY_NAME VARCHAR2
1481 ,p_SRC_EFFECTIVE_DATE VARCHAR2
1482 ,p_OWNER VARCHAR2
1483 ,p_MIRROR_ENTITY_RESULT_ID VARCHAR2
1484 ,p_MODE VARCHAR2
1485 ,p_TRANS_CATEGORY_NAME VARCHAR2 DEFAULT NULL
1486 ,p_RESULT_TYPE_CD VARCHAR2 DEFAULT NULL
1487 ,p_NUMBER_OF_COPIES VARCHAR2 DEFAULT NULL
1488 ,p_STATUS VARCHAR2 DEFAULT NULL
1489 ,p_mirror_src_entity_result_id VARCHAR2 DEFAULT NULL
1490 ,p_parent_entity_result_id VARCHAR2 DEFAULT NULL
1491 ,p_pd_mr_src_entity_result_id VARCHAR2 DEFAULT NULL
1492 ,p_pd_parent_entity_result_id VARCHAR2 DEFAULT NULL
1493 ,p_gs_mr_src_entity_result_id VARCHAR2 DEFAULT NULL
1494 ,p_gs_parent_entity_result_id VARCHAR2 DEFAULT NULL
1495 ,p_table_name VARCHAR2 DEFAULT NULL
1496 ,p_dml_operation VARCHAR2 DEFAULT NULL
1497 ,p_information_category VARCHAR2 DEFAULT NULL
1498 ,p_information1 VARCHAR2 DEFAULT NULL
1499 ,p_information2 VARCHAR2 DEFAULT NULL
1500 ,p_information3 VARCHAR2 DEFAULT NULL
1501 ,p_information4 VARCHAR2 DEFAULT NULL
1502 ,p_information5 VARCHAR2 DEFAULT NULL
1503 ,p_information6 VARCHAR2 DEFAULT NULL
1504 ,p_information7 VARCHAR2 DEFAULT NULL
1505 ,p_information8 VARCHAR2 DEFAULT NULL
1506 ,p_information9 VARCHAR2 DEFAULT NULL
1507 ,p_information10 VARCHAR2 DEFAULT NULL
1508 ,p_information11 VARCHAR2 DEFAULT NULL
1512 ,p_information15 VARCHAR2 DEFAULT NULL
1509 ,p_information12 VARCHAR2 DEFAULT NULL
1510 ,p_information13 VARCHAR2 DEFAULT NULL
1511 ,p_information14 VARCHAR2 DEFAULT NULL
1513 ,p_information16 VARCHAR2 DEFAULT NULL
1514 ,p_information17 VARCHAR2 DEFAULT NULL
1515 ,p_information18 VARCHAR2 DEFAULT NULL
1516 ,p_information19 VARCHAR2 DEFAULT NULL
1517 ,p_information20 VARCHAR2 DEFAULT NULL
1518 ,p_information21 VARCHAR2 DEFAULT NULL
1519 ,p_information22 VARCHAR2 DEFAULT NULL
1520 ,p_information23 VARCHAR2 DEFAULT NULL
1521 ,p_information24 VARCHAR2 DEFAULT NULL
1522 ,p_information25 VARCHAR2 DEFAULT NULL
1523 ,p_information26 VARCHAR2 DEFAULT NULL
1524 ,p_information27 VARCHAR2 DEFAULT NULL
1525 ,p_information28 VARCHAR2 DEFAULT NULL
1526 ,p_information29 VARCHAR2 DEFAULT NULL
1527 ,p_information30 VARCHAR2 DEFAULT NULL
1528 ,p_information31 VARCHAR2 DEFAULT NULL
1529 ,p_information32 VARCHAR2 DEFAULT NULL
1530 ,p_information33 VARCHAR2 DEFAULT NULL
1531 ,p_information34 VARCHAR2 DEFAULT NULL
1532 ,p_information35 VARCHAR2 DEFAULT NULL
1533 ,p_information36 VARCHAR2 DEFAULT NULL
1534 ,p_information37 VARCHAR2 DEFAULT NULL
1535 ,p_information38 VARCHAR2 DEFAULT NULL
1536 ,p_information39 VARCHAR2 DEFAULT NULL
1537 ,p_information40 VARCHAR2 DEFAULT NULL
1538 ,p_information41 VARCHAR2 DEFAULT NULL
1539 ,p_information42 VARCHAR2 DEFAULT NULL
1540 ,p_information43 VARCHAR2 DEFAULT NULL
1541 ,p_information44 VARCHAR2 DEFAULT NULL
1542 ,p_information45 VARCHAR2 DEFAULT NULL
1543 ,p_information46 VARCHAR2 DEFAULT NULL
1544 ,p_information47 VARCHAR2 DEFAULT NULL
1545 ,p_information48 VARCHAR2 DEFAULT NULL
1546 ,p_information49 VARCHAR2 DEFAULT NULL
1547 ,p_information50 VARCHAR2 DEFAULT NULL
1548 ,p_information51 VARCHAR2 DEFAULT NULL
1549 ,p_information52 VARCHAR2 DEFAULT NULL
1550 ,p_information53 VARCHAR2 DEFAULT NULL
1551 ,p_information54 VARCHAR2 DEFAULT NULL
1552 ,p_information55 VARCHAR2 DEFAULT NULL
1553 ,p_information56 VARCHAR2 DEFAULT NULL
1554 ,p_information57 VARCHAR2 DEFAULT NULL
1555 ,p_information58 VARCHAR2 DEFAULT NULL
1556 ,p_information59 VARCHAR2 DEFAULT NULL
1557 ,p_information60 VARCHAR2 DEFAULT NULL
1558 ,p_information61 VARCHAR2 DEFAULT NULL
1559 ,p_information62 VARCHAR2 DEFAULT NULL
1560 ,p_information63 VARCHAR2 DEFAULT NULL
1561 ,p_information64 VARCHAR2 DEFAULT NULL
1562 ,p_information65 VARCHAR2 DEFAULT NULL
1563 ,p_information66 VARCHAR2 DEFAULT NULL
1564 ,p_information67 VARCHAR2 DEFAULT NULL
1565 ,p_information68 VARCHAR2 DEFAULT NULL
1566 ,p_information69 VARCHAR2 DEFAULT NULL
1567 ,p_information70 VARCHAR2 DEFAULT NULL
1568 ,p_information71 VARCHAR2 DEFAULT NULL
1569 ,p_information72 VARCHAR2 DEFAULT NULL
1570 ,p_information73 VARCHAR2 DEFAULT NULL
1571 ,p_information74 VARCHAR2 DEFAULT NULL
1572 ,p_information75 VARCHAR2 DEFAULT NULL
1573 ,p_information76 VARCHAR2 DEFAULT NULL
1574 ,p_information77 VARCHAR2 DEFAULT NULL
1575 ,p_information78 VARCHAR2 DEFAULT NULL
1576 ,p_information79 VARCHAR2 DEFAULT NULL
1577 ,p_information80 VARCHAR2 DEFAULT NULL
1578 ,p_information81 VARCHAR2 DEFAULT NULL
1579 ,p_information82 VARCHAR2 DEFAULT NULL
1580 ,p_information83 VARCHAR2 DEFAULT NULL
1581 ,p_information84 VARCHAR2 DEFAULT NULL
1582 ,p_information85 VARCHAR2 DEFAULT NULL
1583 ,p_information86 VARCHAR2 DEFAULT NULL
1584 ,p_information87 VARCHAR2 DEFAULT NULL
1585 ,p_information88 VARCHAR2 DEFAULT NULL
1586 ,p_information89 VARCHAR2 DEFAULT NULL
1587 ,p_information90 VARCHAR2 DEFAULT NULL
1588 ,p_information91 VARCHAR2 DEFAULT NULL
1589 ,p_information92 VARCHAR2 DEFAULT NULL
1590 ,p_information93 VARCHAR2 DEFAULT NULL
1591 ,p_information94 VARCHAR2 DEFAULT NULL
1595 ,p_information98 VARCHAR2 DEFAULT NULL
1592 ,p_information95 VARCHAR2 DEFAULT NULL
1593 ,p_information96 VARCHAR2 DEFAULT NULL
1594 ,p_information97 VARCHAR2 DEFAULT NULL
1596 ,p_information99 VARCHAR2 DEFAULT NULL
1597 ,p_information100 VARCHAR2 DEFAULT NULL
1598 ,p_information101 VARCHAR2 DEFAULT NULL
1599 ,p_information102 VARCHAR2 DEFAULT NULL
1600 ,p_information103 VARCHAR2 DEFAULT NULL
1601 ,p_information104 VARCHAR2 DEFAULT NULL
1602 ,p_information105 VARCHAR2 DEFAULT NULL
1603 ,p_information106 VARCHAR2 DEFAULT NULL
1604 ,p_information107 VARCHAR2 DEFAULT NULL
1605 ,p_information108 VARCHAR2 DEFAULT NULL
1606 ,p_information109 VARCHAR2 DEFAULT NULL
1607 ,p_information110 VARCHAR2 DEFAULT NULL
1608 ,p_information111 VARCHAR2 DEFAULT NULL
1609 ,p_information112 VARCHAR2 DEFAULT NULL
1610 ,p_information113 VARCHAR2 DEFAULT NULL
1611 ,p_information114 VARCHAR2 DEFAULT NULL
1612 ,p_information115 VARCHAR2 DEFAULT NULL
1613 ,p_information116 VARCHAR2 DEFAULT NULL
1614 ,p_information117 VARCHAR2 DEFAULT NULL
1615 ,p_information118 VARCHAR2 DEFAULT NULL
1616 ,p_information119 VARCHAR2 DEFAULT NULL
1617 ,p_information120 VARCHAR2 DEFAULT NULL
1618 ,p_information121 VARCHAR2 DEFAULT NULL
1619 ,p_information122 VARCHAR2 DEFAULT NULL
1620 ,p_information123 VARCHAR2 DEFAULT NULL
1621 ,p_information124 VARCHAR2 DEFAULT NULL
1622 ,p_information125 VARCHAR2 DEFAULT NULL
1623 ,p_information126 VARCHAR2 DEFAULT NULL
1624 ,p_information127 VARCHAR2 DEFAULT NULL
1625 ,p_information128 VARCHAR2 DEFAULT NULL
1626 ,p_information129 VARCHAR2 DEFAULT NULL
1627 ,p_information130 VARCHAR2 DEFAULT NULL
1628 ,p_information131 VARCHAR2 DEFAULT NULL
1629 ,p_information132 VARCHAR2 DEFAULT NULL
1630 ,p_information133 VARCHAR2 DEFAULT NULL
1631 ,p_information134 VARCHAR2 DEFAULT NULL
1632 ,p_information135 VARCHAR2 DEFAULT NULL
1633 ,p_information136 VARCHAR2 DEFAULT NULL
1634 ,p_information137 VARCHAR2 DEFAULT NULL
1635 ,p_information138 VARCHAR2 DEFAULT NULL
1636 ,p_information139 VARCHAR2 DEFAULT NULL
1637 ,p_information140 VARCHAR2 DEFAULT NULL
1638 ,p_information141 VARCHAR2 DEFAULT NULL
1639 ,p_information142 VARCHAR2 DEFAULT NULL
1640
1641 /* Extra Reserved Columns
1642 ,p_information143 VARCHAR2 DEFAULT NULL
1643 ,p_information144 VARCHAR2 DEFAULT NULL
1644 ,p_information145 VARCHAR2 DEFAULT NULL
1645 ,p_information146 VARCHAR2 DEFAULT NULL
1646 ,p_information147 VARCHAR2 DEFAULT NULL
1647 ,p_information148 VARCHAR2 DEFAULT NULL
1648 ,p_information149 VARCHAR2 DEFAULT NULL
1649 ,p_information150 VARCHAR2 DEFAULT NULL
1650 */
1651 ,p_information151 VARCHAR2 DEFAULT NULL
1652 ,p_information152 VARCHAR2 DEFAULT NULL
1653 ,p_information153 VARCHAR2 DEFAULT NULL
1654
1655 /* Extra Reserved Columns
1656 ,p_information154 VARCHAR2 DEFAULT NULL
1657 ,p_information155 VARCHAR2 DEFAULT NULL
1658 ,p_information156 VARCHAR2 DEFAULT NULL
1659 ,p_information157 VARCHAR2 DEFAULT NULL
1660 ,p_information158 VARCHAR2 DEFAULT NULL
1661 ,p_information159 VARCHAR2 DEFAULT NULL
1662 */
1663 ,p_information160 VARCHAR2 DEFAULT NULL
1664 ,p_information161 VARCHAR2 DEFAULT NULL
1665 ,p_information162 VARCHAR2 DEFAULT NULL
1666
1667 /* Extra Reserved Columns
1668 ,p_information163 VARCHAR2 DEFAULT NULL
1669 ,p_information164 VARCHAR2 DEFAULT NULL
1670 ,p_information165 VARCHAR2 DEFAULT NULL
1671 */
1672 ,p_information166 VARCHAR2 DEFAULT NULL
1673 ,p_information167 VARCHAR2 DEFAULT NULL
1674 ,p_information168 VARCHAR2 DEFAULT NULL
1675 ,p_information169 VARCHAR2 DEFAULT NULL
1676 ,p_information170 VARCHAR2 DEFAULT NULL
1677
1678 /* Extra Reserved Columns
1679 ,p_information171 VARCHAR2 DEFAULT NULL
1680 ,p_information172 VARCHAR2 DEFAULT NULL
1681 */
1682 ,p_information173 VARCHAR2 DEFAULT NULL
1683 ,p_information174 VARCHAR2 DEFAULT NULL
1687 ,p_information178 VARCHAR2 DEFAULT NULL
1684 ,p_information175 VARCHAR2 DEFAULT NULL
1685 ,p_information176 VARCHAR2 DEFAULT NULL
1686 ,p_information177 VARCHAR2 DEFAULT NULL
1688 ,p_information179 VARCHAR2 DEFAULT NULL
1689 ,p_information180 VARCHAR2 DEFAULT NULL
1690 ,p_information181 VARCHAR2 DEFAULT NULL
1691 ,p_information182 VARCHAR2 DEFAULT NULL
1692
1693 /* Extra Reserved Columns
1694 ,p_information183 VARCHAR2 DEFAULT NULL
1695 ,p_information184 VARCHAR2 DEFAULT NULL
1696 */
1697 ,p_information185 VARCHAR2 DEFAULT NULL
1698 ,p_information186 VARCHAR2 DEFAULT NULL
1699 ,p_information187 VARCHAR2 DEFAULT NULL
1700 ,p_information188 VARCHAR2 DEFAULT NULL
1701
1702 /* Extra Reserved Columns
1703 ,p_information189 VARCHAR2 DEFAULT NULL
1704 */
1705 ,p_information190 VARCHAR2 DEFAULT NULL
1706 ,p_information191 VARCHAR2 DEFAULT NULL
1707 ,p_information192 VARCHAR2 DEFAULT NULL
1708 ,p_information193 VARCHAR2 DEFAULT NULL
1709 ,p_information194 VARCHAR2 DEFAULT NULL
1710 ,p_information195 VARCHAR2 DEFAULT NULL
1711 ,p_information196 VARCHAR2 DEFAULT NULL
1712 ,p_information197 VARCHAR2 DEFAULT NULL
1713 ,p_information198 VARCHAR2 DEFAULT NULL
1714 ,p_information199 VARCHAR2 DEFAULT NULL
1715
1716 /* Extra Reserved Columns
1717 ,p_information200 VARCHAR2 DEFAULT NULL
1718 ,p_information201 VARCHAR2 DEFAULT NULL
1719 ,p_information202 VARCHAR2 DEFAULT NULL
1720 ,p_information203 VARCHAR2 DEFAULT NULL
1721 ,p_information204 VARCHAR2 DEFAULT NULL
1722 ,p_information205 VARCHAR2 DEFAULT NULL
1723 ,p_information206 VARCHAR2 DEFAULT NULL
1724 ,p_information207 VARCHAR2 DEFAULT NULL
1725 ,p_information208 VARCHAR2 DEFAULT NULL
1726 ,p_information209 VARCHAR2 DEFAULT NULL
1727 ,p_information210 VARCHAR2 DEFAULT NULL
1728 ,p_information211 VARCHAR2 DEFAULT NULL
1729 ,p_information212 VARCHAR2 DEFAULT NULL
1730 ,p_information213 VARCHAR2 DEFAULT NULL
1731 ,p_information214 VARCHAR2 DEFAULT NULL
1732 ,p_information215 VARCHAR2 DEFAULT NULL
1733 */
1734 ,p_information216 VARCHAR2 DEFAULT NULL
1735 ,p_information217 VARCHAR2 DEFAULT NULL
1736 ,p_information218 VARCHAR2 DEFAULT NULL
1737 ,p_information219 VARCHAR2 DEFAULT NULL
1738 ,p_information220 VARCHAR2 DEFAULT NULL
1739 ,p_information221 VARCHAR2 DEFAULT NULL
1740 ,p_information222 VARCHAR2 DEFAULT NULL
1741 ,p_information223 VARCHAR2 DEFAULT NULL
1742 ,p_information224 VARCHAR2 DEFAULT NULL
1743 ,p_information225 VARCHAR2 DEFAULT NULL
1744 ,p_information226 VARCHAR2 DEFAULT NULL
1745 ,p_information227 VARCHAR2 DEFAULT NULL
1746 ,p_information228 VARCHAR2 DEFAULT NULL
1747 ,p_information229 VARCHAR2 DEFAULT NULL
1748 ,p_information230 VARCHAR2 DEFAULT NULL
1749 ,p_information231 VARCHAR2 DEFAULT NULL
1750 ,p_information232 VARCHAR2 DEFAULT NULL
1751 ,p_information233 VARCHAR2 DEFAULT NULL
1752 ,p_information234 VARCHAR2 DEFAULT NULL
1753 ,p_information235 VARCHAR2 DEFAULT NULL
1754 ,p_information236 VARCHAR2 DEFAULT NULL
1755 ,p_information237 VARCHAR2 DEFAULT NULL
1756 ,p_information238 VARCHAR2 DEFAULT NULL
1757 ,p_information239 VARCHAR2 DEFAULT NULL
1758 ,p_information240 VARCHAR2 DEFAULT NULL
1759 ,p_information241 VARCHAR2 DEFAULT NULL
1760 ,p_information242 VARCHAR2 DEFAULT NULL
1761 ,p_information243 VARCHAR2 DEFAULT NULL
1762 ,p_information244 VARCHAR2 DEFAULT NULL
1763 ,p_information245 VARCHAR2 DEFAULT NULL
1764 ,p_information246 VARCHAR2 DEFAULT NULL
1765 ,p_information247 VARCHAR2 DEFAULT NULL
1766 ,p_information248 VARCHAR2 DEFAULT NULL
1767 ,p_information249 VARCHAR2 DEFAULT NULL
1768 ,p_information250 VARCHAR2 DEFAULT NULL
1769 ,p_information251 VARCHAR2 DEFAULT NULL
1770 ,p_information252 VARCHAR2 DEFAULT NULL
1771 ,p_information253 VARCHAR2 DEFAULT NULL
1772 ,p_information254 VARCHAR2 DEFAULT NULL
1773 ,p_information255 VARCHAR2 DEFAULT NULL
1774 ,p_information256 VARCHAR2 DEFAULT NULL
1775 ,p_information257 VARCHAR2 DEFAULT NULL
1779 ,p_information261 VARCHAR2 DEFAULT NULL
1776 ,p_information258 VARCHAR2 DEFAULT NULL
1777 ,p_information259 VARCHAR2 DEFAULT NULL
1778 ,p_information260 VARCHAR2 DEFAULT NULL
1780 ,p_information262 VARCHAR2 DEFAULT NULL
1781 ,p_information263 VARCHAR2 DEFAULT NULL
1782 ,p_information264 VARCHAR2 DEFAULT NULL
1783 ,p_information265 VARCHAR2 DEFAULT NULL
1784 ,p_information266 VARCHAR2 DEFAULT NULL
1785 ,p_information267 VARCHAR2 DEFAULT NULL
1786 ,p_information268 VARCHAR2 DEFAULT NULL
1787 ,p_information269 VARCHAR2 DEFAULT NULL
1788 ,p_information270 VARCHAR2 DEFAULT NULL
1789 ,p_information271 VARCHAR2 DEFAULT NULL
1790 ,p_information272 VARCHAR2 DEFAULT NULL
1791 ,p_information273 VARCHAR2 DEFAULT NULL
1792 ,p_information274 VARCHAR2 DEFAULT NULL
1793 ,p_information275 VARCHAR2 DEFAULT NULL
1794 ,p_information276 VARCHAR2 DEFAULT NULL
1795 ,p_information277 VARCHAR2 DEFAULT NULL
1796 ,p_information278 VARCHAR2 DEFAULT NULL
1797 ,p_information279 VARCHAR2 DEFAULT NULL
1798 ,p_information280 VARCHAR2 DEFAULT NULL
1799 ,p_information281 VARCHAR2 DEFAULT NULL
1800 ,p_information282 VARCHAR2 DEFAULT NULL
1801 ,p_information283 VARCHAR2 DEFAULT NULL
1802 ,p_information284 VARCHAR2 DEFAULT NULL
1803 ,p_information285 VARCHAR2 DEFAULT NULL
1804 ,p_information286 VARCHAR2 DEFAULT NULL
1805 ,p_information287 VARCHAR2 DEFAULT NULL
1806 ,p_information288 VARCHAR2 DEFAULT NULL
1807 ,p_information289 VARCHAR2 DEFAULT NULL
1808 ,p_information290 VARCHAR2 DEFAULT NULL
1809 ,p_information291 VARCHAR2 DEFAULT NULL
1810 ,p_information292 VARCHAR2 DEFAULT NULL
1811 ,p_information293 VARCHAR2 DEFAULT NULL
1812 ,p_information294 VARCHAR2 DEFAULT NULL
1813 ,p_information295 VARCHAR2 DEFAULT NULL
1814 ,p_information296 VARCHAR2 DEFAULT NULL
1815 ,p_information297 VARCHAR2 DEFAULT NULL
1816 ,p_information298 VARCHAR2 DEFAULT NULL
1817 ,p_information299 VARCHAR2 DEFAULT NULL
1818 ,p_information300 VARCHAR2 DEFAULT NULL
1819 ,p_information301 VARCHAR2 DEFAULT NULL
1820 ,p_information302 VARCHAR2 DEFAULT NULL
1821 ,p_information303 VARCHAR2 DEFAULT NULL
1822 ,p_information304 VARCHAR2 DEFAULT NULL
1823
1824 /* Extra Reserved Columns
1825 ,p_information305 VARCHAR2 DEFAULT NULL
1826 */
1827 ,p_information306 VARCHAR2 DEFAULT NULL
1828 ,p_information307 VARCHAR2 DEFAULT NULL
1829 ,p_information308 VARCHAR2 DEFAULT NULL
1830 ,p_information309 VARCHAR2 DEFAULT NULL
1831 ,p_information310 VARCHAR2 DEFAULT NULL
1832 ,p_information311 VARCHAR2 DEFAULT NULL
1833 ,p_information312 VARCHAR2 DEFAULT NULL
1834 ,p_information313 VARCHAR2 DEFAULT NULL
1835 ,p_information314 VARCHAR2 DEFAULT NULL
1836 ,p_information315 VARCHAR2 DEFAULT NULL
1837 ,p_information316 VARCHAR2 DEFAULT NULL
1838 ,p_information317 VARCHAR2 DEFAULT NULL
1839 ,p_information318 VARCHAR2 DEFAULT NULL
1840 ,p_information319 VARCHAR2 DEFAULT NULL
1841 ,p_information320 VARCHAR2 DEFAULT NULL
1842
1843 /* Extra Reserved Columns
1844 ,p_information321 VARCHAR2 DEFAULT NULL
1845 ,p_information322 VARCHAR2 DEFAULT NULL
1846 */
1847 ,p_information323 VARCHAR2 DEFAULT NULL
1848 ,p_datetrack_mode VARCHAR2 DEFAULT NULL
1849 ,p_table_alias VARCHAR2 DEFAULT NULL
1850 ) is
1851 -- Bug : 4354708
1852 l_last_update_date date;
1853 l_last_updated_by number(15);
1854 l_last_update_login number(15);
1855 l_created_by number(15);
1856 l_creation_date date;
1857 l_schema varchar2(100);
1858 l_industry varchar2(100);
1859 l_install_status varchar2(100);
1860 -- Bug : 4354708
1861 cursor c2 is
1862 select transaction_category_id
1863 from pqh_transaction_categories tc
1864 where tc.short_name = g_TRANS_CATEGORY_NAME ;
1865 --
1866 cursor c3(v_context_business_group_id number, v_transaction_category_id number) is
1867 select copy_entity_txn_id
1868 from pqh_copy_entity_txns cet
1869 where cet.display_name = p_display_name
1870 and cet.context_business_group_id = v_context_business_group_id
1871 and cet.transaction_category_id = v_transaction_category_id;
1872 --
1873 cursor c4 is
1877 and tr.from_clause = 'OAB' ;
1874 select table_route_id
1875 from pqh_table_route tr
1876 where table_alias = p_table_alias
1878
1879 --Bug : 4354708
1880 cursor c_trig_cpe is
1881 select null
1882 from all_triggers
1883 where table_name = 'BEN_COPY_ENTITY_RESULTS'
1884 and trigger_name = 'BEN_COPY_ENTITY_RESULTS_WHO'
1885 and table_owner = l_schema
1886 and status = 'ENABLED';
1887 --Bug : 4354708
1888 --
1889 l_dummy varchar2(30) ;
1890 l_copy_entity_txn_id number(15);
1891 l_object_version_number number(7) := 1 ;
1892 l_copy_entity_attrib_id number(15);
1893 l_table_route_id number(15);
1894 l_copy_entity_result_id number(15);
1895 l_business_group_id number ;
1896 l_transaction_category_id number ;
1897 --
1898 begin
1899 --
1900 /* For seeded FHR copy process, set context_business_group_id to 0 */
1901 if p_DISPLAY_NAME = 'GHR_FEHB_SEED_PROGRAM_DESIGN' then
1902 l_business_group_id := 0;
1903 else
1904 l_business_group_id := fnd_global.PER_BUSINESS_GROUP_ID ;
1905 end if;
1906 --
1907 if p_mode = 'BEGIN' then
1908
1909 g_DISPLAY_NAME := p_DISPLAY_NAME;
1910 g_SRC_EFFECTIVE_DATE := p_SRC_EFFECTIVE_DATE;
1911 g_MIRROR_ENTITY_RESULT_ID := p_MIRROR_ENTITY_RESULT_ID;
1912 g_OWNER := p_OWNER;
1913 g_TRANS_CATEGORY_NAME := p_TRANS_CATEGORY_NAME;
1914 g_RESULT_TYPE_CD := p_RESULT_TYPE_CD;
1915 g_NUMBER_OF_COPIES := p_NUMBER_OF_COPIES;
1916 g_STATUS := p_STATUS;
1917 g_mirror_src_entity_result_id := p_mirror_src_entity_result_id;
1918 g_parent_entity_result_id := p_parent_entity_result_id;
1919 g_pd_mr_src_entity_result_id := p_pd_mr_src_entity_result_id;
1920 g_pd_parent_entity_result_id := p_pd_parent_entity_result_id;
1921 g_gs_mr_src_entity_result_id := p_gs_mr_src_entity_result_id;
1922 g_gs_parent_entity_result_id := p_gs_parent_entity_result_id;
1923 g_table_name := p_table_name;
1924 g_dml_operation := p_dml_operation;
1925 g_information_category := p_information_category;
1926 g_information1 := p_information1;
1927 g_information2 := p_information2;
1928 g_information3 := p_information3;
1929 g_information4 := p_information4;
1930 g_information5 := p_information5;
1931 g_information6 := p_information6;
1932 g_information7 := p_information7;
1933 g_information8 := p_information8;
1934 g_information9 := p_information9;
1935 g_information10 := p_information10;
1936 g_information11 := p_information11;
1937 g_information12 := p_information12;
1938 g_information13 := p_information13;
1939 g_information14 := p_information14;
1940 g_information15 := p_information15;
1941 g_information16 := p_information16;
1942 g_information17 := p_information17;
1943 g_information18 := p_information18;
1944 g_information19 := p_information19;
1945 g_information20 := p_information20;
1946 g_information21 := p_information21;
1947 g_information22 := p_information22;
1948 g_information23 := p_information23;
1949 g_information24 := p_information24;
1950 g_information25 := p_information25;
1951 g_information26 := p_information26;
1952 g_information27 := p_information27;
1953 g_information28 := p_information28;
1954 g_information29 := p_information29;
1955 g_information30 := p_information30;
1956 g_information31 := p_information31;
1957 g_information32 := p_information32;
1958 g_information33 := p_information33;
1959 g_information34 := p_information34;
1960 g_information35 := p_information35;
1961 g_information36 := p_information36;
1962 g_information37 := p_information37;
1963 g_information38 := p_information38;
1964 g_information39 := p_information39;
1965 g_information40 := p_information40;
1966 g_information41 := p_information41;
1967 g_information42 := p_information42;
1968 g_information43 := p_information43;
1969 g_information44 := p_information44;
1970 g_information45 := p_information45;
1971 g_information46 := p_information46;
1972 g_information47 := p_information47;
1973 g_information48 := p_information48;
1974 g_information49 := p_information49;
1975 g_information50 := p_information50;
1976 g_information51 := p_information51;
1980 g_information55 := p_information55;
1977 g_information52 := p_information52;
1978 g_information53 := p_information53;
1979 g_information54 := p_information54;
1981 g_information56 := p_information56;
1982 g_information57 := p_information57;
1983 g_information58 := p_information58;
1984 g_information59 := p_information59;
1985 g_information60 := p_information60;
1986 g_information61 := p_information61;
1987 g_information62 := p_information62;
1988 g_information63 := p_information63;
1989 g_information64 := p_information64;
1990 g_information65 := p_information65;
1991 g_information66 := p_information66;
1992 g_information67 := p_information67;
1993 g_information68 := p_information68;
1994 g_information69 := p_information69;
1995 g_information70 := p_information70;
1996 g_information71 := p_information71;
1997 g_information72 := p_information72;
1998 g_information73 := p_information73;
1999 g_information74 := p_information74;
2000 g_information75 := p_information75;
2001 g_information76 := p_information76;
2002 g_information77 := p_information77;
2003 g_information78 := p_information78;
2004 g_information79 := p_information79;
2005 g_information80 := p_information80;
2006 g_information81 := p_information81;
2007 g_information82 := p_information82;
2008 g_information83 := p_information83;
2009 g_information84 := p_information84;
2010 g_information85 := p_information85;
2011 g_information86 := p_information86;
2012 g_information87 := p_information87;
2013 g_information88 := p_information88;
2014 g_information89 := p_information89;
2015 g_information90 := p_information90;
2016
2017 elsif p_mode = 'END' then
2018
2019 if (g_DISPLAY_NAME is not null and p_DISPLAY_NAME = g_DISPLAY_NAME)
2020 and (g_SRC_EFFECTIVE_DATE is not null and p_SRC_EFFECTIVE_DATE = g_SRC_EFFECTIVE_DATE)
2021 and (g_MIRROR_ENTITY_RESULT_ID is not null and p_MIRROR_ENTITY_RESULT_ID = g_MIRROR_ENTITY_RESULT_ID)
2022 then
2023
2024 if g_perf_transaction_category_id is null then
2025 open c2 ;
2026 hr_utility.set_location(' Step 30 ',30);
2027 fetch c2 into l_transaction_category_id ;
2028 g_perf_transaction_category_id := l_transaction_category_id;
2029 if c2%notfound then
2030 -- Throw error
2031 close c2 ;
2032 return ;
2033 end if ;
2034 close c2;
2035 else
2036 l_transaction_category_id := g_perf_transaction_category_id;
2037 end if;
2038 --
2039 --
2040 -- Bug : 4354708
2041 --
2042 l_found := fnd_installation.get_app_info ('BEN', l_install_status, l_industry, l_schema);
2043 --
2044 open c_trig_cpe;
2045 fetch c_trig_cpe into l_dummy;
2046 if c_trig_cpe%notfound then
2047 --
2048 -- WHO Trigger is not defined on the table BEN_COPY_ENTITY_RESULTS
2049 -- Set WHO columns
2050 l_last_update_date := sysdate;
2051 l_last_updated_by := fnd_global.user_id;
2052 l_last_update_login := fnd_global.login_id;
2053 l_created_by := fnd_global.user_id;
2054 l_creation_date := sysdate;
2055 --
2056 else
2057 --
2058 l_last_update_date := null;
2059 l_last_updated_by := null;
2060 l_last_update_login := null;
2061 l_created_by := null;
2062 l_creation_date := null;
2063 --
2064 end if;
2065 --
2066 close c_trig_cpe;
2067 --
2068 --Bug : 4354708
2069 --
2070 Begin
2071
2072 if g_perf_copy_entity_txn_id is null then
2073 open c3(l_business_group_id , l_transaction_category_id) ;
2074 fetch c3 into l_copy_entity_txn_id ;
2075 g_perf_copy_entity_txn_id := l_copy_entity_txn_id;
2076 close c3;
2077 else
2078 l_copy_entity_txn_id := g_perf_copy_entity_txn_id;
2079 end if;
2080 --
2081 open c4 ;
2082 fetch c4 into l_table_route_id ;
2083 close c4;
2084 --
2085
2086 insert into ben_copy_entity_results
2087 ( copy_entity_result_id
2088 ,copy_entity_txn_id
2089 ,src_copy_entity_result_id
2090 ,result_type_cd
2091 ,number_of_copies
2092 ,mirror_entity_result_id
2093 ,mirror_src_entity_result_id
2094 ,parent_entity_result_id
2095 ,pd_mirror_src_entity_result_id
2096 ,pd_parent_entity_result_id
2100 ,table_route_id
2097 ,gs_mirror_src_entity_result_id
2098 ,gs_parent_entity_result_id
2099 ,table_name
2101 ,status
2102 ,dml_operation
2103 ,information_category
2104 ,information1
2105 ,information2
2106 ,information3
2107 ,information4
2108 ,information5
2109 ,information6
2110 ,information7
2111 ,information8
2112 ,information9
2113 ,information10
2114 ,information11
2115 ,information12
2116 ,information13
2117 ,information14
2118 ,information15
2119 ,information16
2120 ,information17
2121 ,information18
2122 ,information19
2123 ,information20
2124 ,information21
2125 ,information22
2126 ,information23
2127 ,information24
2128 ,information25
2129 ,information26
2130 ,information27
2131 ,information28
2132 ,information29
2133 ,information30
2134 ,information31
2135 ,information32
2136 ,information33
2137 ,information34
2138 ,information35
2139 ,information36
2140 ,information37
2141 ,information38
2142 ,information39
2143 ,information40
2144 ,information41
2145 ,information42
2146 ,information43
2147 ,information44
2148 ,information45
2149 ,information46
2150 ,information47
2151 ,information48
2152 ,information49
2153 ,information50
2154 ,information51
2155 ,information52
2156 ,information53
2157 ,information54
2158 ,information55
2159 ,information56
2160 ,information57
2161 ,information58
2162 ,information59
2163 ,information60
2164 ,information61
2165 ,information62
2166 ,information63
2167 ,information64
2168 ,information65
2169 ,information66
2170 ,information67
2171 ,information68
2172 ,information69
2173 ,information70
2174 ,information71
2175 ,information72
2176 ,information73
2177 ,information74
2178 ,information75
2179 ,information76
2180 ,information77
2181 ,information78
2182 ,information79
2183 ,information80
2184 ,information81
2185 ,information82
2186 ,information83
2187 ,information84
2188 ,information85
2189 ,information86
2190 ,information87
2191 ,information88
2192 ,information89
2193 ,information90
2194 ,information91
2195 ,information92
2196 ,information93
2197 ,information94
2198 ,information95
2199 ,information96
2200 ,information97
2201 ,information98
2202 ,information99
2203 ,information100
2204 ,information101
2205 ,information102
2206 ,information103
2207 ,information104
2208 ,information105
2209 ,information106
2210 ,information107
2211 ,information108
2212 ,information109
2213 ,information110
2214 ,information111
2215 ,information112
2216 ,information113
2217 ,information114
2218 ,information115
2219 ,information116
2220 ,information117
2221 ,information118
2222 ,information119
2223 ,information120
2224 ,information121
2225 ,information122
2226 ,information123
2227 ,information124
2228 ,information125
2229 ,information126
2230 ,information127
2231 ,information128
2232 ,information129
2233 ,information130
2234 ,information131
2235 ,information132
2236 ,information133
2237 ,information134
2238 ,information135
2239 ,information136
2240 ,information137
2241 ,information138
2242 ,information139
2243 ,information140
2244 ,information141
2245 ,information142
2246
2247 /* Extra Reserved Columns
2248 ,information143
2249 ,information144
2250 ,information145
2251 ,information146
2252 ,information147
2253 ,information148
2254 ,information149
2255 ,information150
2256 */
2257 ,information151
2258 ,information152
2259 ,information153
2260
2261 /* Extra Reserved Columns
2262 ,information154
2263 ,information155
2264 ,information156
2265 ,information157
2266 ,information158
2267 ,information159
2268 */
2269 ,information160
2270 ,information161
2271 ,information162
2272
2273 /* Extra Reserved Columns
2274 ,information163
2275 ,information164
2276 ,information165
2277 */
2278 ,information166
2279 ,information167
2280 ,information168
2281 ,information169
2282 ,information170
2283
2284 /* Extra Reserved Columns
2285 ,information171
2286 ,information172
2287 */
2288 ,information173
2289 ,information174
2290 ,information175
2291 ,information176
2292 ,information177
2293 ,information178
2294 ,information179
2295 ,information180
2296 ,information181
2297 ,information182
2298
2299 /* Extra Reserved Columns
2300 ,information183
2301 ,information184
2302 */
2303 ,information185
2304 ,information186
2305 ,information187
2306 ,information188
2307
2308 /* Extra Reserved Columns
2309 ,information189
2310 */
2311 ,information190
2312 ,information191
2313 ,information192
2314 ,information193
2315 ,information194
2316 ,information195
2317 ,information196
2318 ,information197
2319 ,information198
2320 ,information199
2321
2322 /* Extra Reserved Columns
2323 ,information200
2324 ,information201
2325 ,information202
2326 ,information203
2327 ,information204
2328 ,information205
2329 ,information206
2330 ,information207
2331 ,information208
2332 ,information209
2333 ,information210
2334 ,information211
2335 ,information212
2336 ,information213
2337 ,information214
2338 ,information215
2339 */
2340 ,information216
2341 ,information217
2342 ,information218
2343 ,information219
2344 ,information220
2345 ,information221
2346 ,information222
2347 ,information223
2348 ,information224
2349 ,information225
2350 ,information226
2351 ,information227
2352 ,information228
2353 ,information229
2354 ,information230
2355 ,information231
2356 ,information232
2357 ,information233
2358 ,information234
2359 ,information235
2360 ,information236
2361 ,information237
2362 ,information238
2363 ,information239
2364 ,information240
2365 ,information241
2366 ,information242
2367 ,information243
2368 ,information244
2369 ,information245
2370 ,information246
2371 ,information247
2372 ,information248
2373 ,information249
2374 ,information250
2375 ,information251
2376 ,information252
2377 ,information253
2378 ,information254
2379 ,information255
2380 ,information256
2381 ,information257
2382 ,information258
2383 ,information259
2384 ,information260
2385 ,information261
2386 ,information262
2387 ,information263
2388 ,information264
2389 ,information265
2390 ,information266
2391 ,information267
2392 ,information268
2396 ,information272
2393 ,information269
2394 ,information270
2395 ,information271
2397 ,information273
2398 ,information274
2399 ,information275
2400 ,information276
2401 ,information277
2402 ,information278
2403 ,information279
2404 ,information280
2405 ,information281
2406 ,information282
2407 ,information283
2408 ,information284
2409 ,information285
2410 ,information286
2411 ,information287
2412 ,information288
2413 ,information289
2414 ,information290
2415 ,information291
2416 ,information292
2417 ,information293
2418 ,information294
2419 ,information295
2420 ,information296
2421 ,information297
2422 ,information298
2423 ,information299
2424 ,information300
2425 ,information301
2426 ,information302
2427 ,information303
2428 ,information304
2429
2430 /* Extra Reserved Columns
2431 ,information305
2432 */
2433 ,information306
2434 ,information307
2435 ,information308
2436 ,information309
2437 ,information310
2438 ,information311
2439 ,information312
2440 ,information313
2441 ,information314
2442 ,information315
2443 ,information316
2444 ,information317
2445 ,information318
2446 ,information319
2447 ,information320
2448
2449 /* Extra Reserved Columns
2450 ,information321
2451 ,information322
2452 */
2453 ,information323
2454 ,datetrack_mode
2455 ,table_alias
2456 ,object_version_number
2457 ,last_update_date --Bug : 4354708
2458 ,last_updated_by
2459 ,last_update_login
2460 ,created_by
2461 ,creation_date --Bug : 4354708
2462 )
2463 Values
2464 ( ben_copy_entity_results_s.nextval
2465 ,l_copy_entity_txn_id
2466 ,NULL -- g_src_copy_entity_result_id -- Start global variables
2467 ,g_result_type_cd
2468 ,to_number(g_number_of_copies)
2469 ,to_number(g_mirror_entity_result_id)
2470 ,to_number(g_mirror_src_entity_result_id)
2471 ,to_number(g_parent_entity_result_id)
2472 ,to_number(g_pd_mr_src_entity_result_id)
2473 ,to_number(g_pd_parent_entity_result_id)
2474 ,to_number(g_gs_mr_src_entity_result_id)
2475 ,to_number(g_gs_parent_entity_result_id)
2476 ,g_table_name
2477 ,l_table_route_id
2478 ,g_status
2479 ,g_dml_operation
2480 ,g_information_category
2481 ,to_number(g_information1)
2482 ,to_date(g_information2,'DD/MM/YYYY')
2483 ,to_date(g_information3,'DD/MM/YYYY')
2484 ,to_number(g_information4)
2485 ,g_information5
2486 ,g_information6
2487 ,g_information7
2488 ,g_information8
2489 ,g_information9
2490 ,to_date(g_information10,'DD/MM/YYYY')
2491 ,g_information11
2492 ,g_information12
2493 ,g_information13
2494 ,g_information14
2495 ,g_information15
2496 ,g_information16
2497 ,g_information17
2498 ,g_information18
2499 ,g_information19
2500 ,g_information20
2501 ,g_information21
2502 ,g_information22
2503 ,g_information23
2504 ,g_information24
2505 ,g_information25
2506 ,g_information26
2507 ,g_information27
2508 ,g_information28
2509 ,g_information29
2510 ,g_information30
2511 ,g_information31
2512 ,g_information32
2513 ,g_information33
2514 ,g_information34
2515 ,g_information35
2516 ,g_information36
2517 ,g_information37
2518 ,g_information38
2519 ,g_information39
2520 ,g_information40
2521 ,g_information41
2522 ,g_information42
2523 ,g_information43
2524 ,g_information44
2525 ,g_information45
2526 ,g_information46
2527 ,g_information47
2528 ,g_information48
2529 ,g_information49
2530 ,g_information50
2531 ,g_information51
2532 ,g_information52
2533 ,g_information53
2534 ,g_information54
2535 ,g_information55
2536 ,g_information56
2537 ,g_information57
2538 ,g_information58
2539 ,g_information59
2540 ,g_information60
2541 ,g_information61
2542 ,g_information62
2543 ,g_information63
2544 ,g_information64
2545 ,g_information65
2546 ,g_information66
2547 ,g_information67
2548 ,g_information68
2549 ,g_information69
2550 ,g_information70
2551 ,g_information71
2552 ,g_information72
2553 ,g_information73
2554 ,g_information74
2555 ,g_information75
2559 ,g_information79
2556 ,g_information76
2557 ,g_information77
2558 ,g_information78
2560 ,g_information80
2561 ,g_information81
2562 ,g_information82
2563 ,g_information83
2564 ,g_information84
2565 ,g_information85
2566 ,g_information86
2567 ,g_information87
2568 ,g_information88
2569 ,g_information89
2570 ,g_information90 -- End global variables
2571 ,p_information91
2572 ,p_information92
2573 ,p_information93
2574 ,p_information94
2575 ,p_information95
2576 ,p_information96
2577 ,p_information97
2578 ,p_information98
2579 ,p_information99
2580 ,p_information100
2581 ,p_information101
2582 ,p_information102
2583 ,p_information103
2584 ,p_information104
2585 ,p_information105
2586 ,p_information106
2587 ,p_information107
2588 ,p_information108
2589 ,p_information109
2590 ,p_information110
2591 ,p_information111
2592 ,p_information112
2593 ,p_information113
2594 ,p_information114
2595 ,p_information115
2596 ,p_information116
2597 ,p_information117
2598 ,p_information118
2599 ,p_information119
2600 ,p_information120
2601 ,p_information121
2602 ,p_information122
2603 ,p_information123
2604 ,p_information124
2605 ,p_information125
2606 ,p_information126
2607 ,p_information127
2608 ,p_information128
2609 ,p_information129
2610 ,p_information130
2611 ,p_information131
2612 ,p_information132
2613 ,p_information133
2614 ,p_information134
2615 ,p_information135
2616 ,p_information136
2617 ,p_information137
2618 ,p_information138
2619 ,p_information139
2620 ,p_information140
2621 ,p_information141
2622 ,p_information142
2623
2624 /* Extra Reserved Columns
2625 ,p_information143
2626 ,p_information144
2627 ,p_information145
2628 ,p_information146
2629 ,p_information147
2630 ,p_information148
2631 ,p_information149
2632 ,p_information150
2633 */
2634 ,p_information151
2635 ,p_information152
2636 ,p_information153
2637
2638 /* Extra Reserved Columns
2639 ,p_information154
2640 ,p_information155
2641 ,p_information156
2642 ,p_information157
2643 ,p_information158
2644 ,p_information159
2645 */
2646 ,to_number(p_information160)
2647 ,to_number(p_information161)
2648 ,to_number(p_information162)
2649
2650 /* Extra Reserved Columns
2651 ,to_number(p_information163)
2652 ,to_number(p_information164)
2653 ,to_number(p_information165)
2654 */
2655
2656 ,to_date(p_information166,'DD/MM/YYYY')
2657 ,to_date(p_information167,'DD/MM/YYYY')
2658 ,to_date(p_information168,'DD/MM/YYYY')
2659 ,to_number(p_information169)
2660 ,p_information170
2661
2662 /* Extra Reserved Columns
2663 ,p_information171
2664 ,p_information172
2665 */
2666 ,p_information173
2667 ,to_number(p_information174)
2668 ,p_information175
2669 ,to_number(p_information176)
2670 ,p_information177
2671 ,to_number(p_information178)
2672 ,p_information179
2673 ,to_number(p_information180)
2674 ,p_information181
2675 ,p_information182
2676
2677 /* Extra Reserved Columns
2678 ,p_information183
2679 ,p_information184
2680 */
2681 ,p_information185
2682 ,p_information186
2683 ,p_information187
2684 ,p_information188
2685
2686 /* Extra Reserved Columns
2687 ,p_information189
2688 */
2689 ,p_information190
2690 ,p_information191
2691 ,p_information192
2692 ,p_information193
2693 ,p_information194
2694 ,p_information195
2695 ,p_information196
2696 ,p_information197
2697 ,p_information198
2698 ,p_information199
2699
2700 /* Extra Reserved Columns
2701 ,p_information200
2702 ,p_information201
2703 ,p_information202
2704 ,p_information203
2705 ,p_information204
2706 ,p_information205
2707 ,p_information206
2708 ,p_information207
2709 ,p_information208
2710 ,p_information209
2711 ,p_information210
2712 ,p_information211
2713 ,p_information212
2714 ,p_information213
2715 ,p_information214
2716 ,p_information215
2717 */
2718 ,p_information216
2722 ,p_information220
2719 ,p_information217
2720 ,p_information218
2721 ,p_information219
2723 ,to_number(p_information221)
2724 ,to_number(p_information222)
2725 ,to_number(p_information223)
2726 ,to_number(p_information224)
2727 ,to_number(p_information225)
2728 ,to_number(p_information226)
2729 ,to_number(p_information227)
2730 ,to_number(p_information228)
2731 ,to_number(p_information229)
2732 ,to_number(p_information230)
2733 ,to_number(p_information231)
2734 ,to_number(p_information232)
2735 ,to_number(p_information233)
2736 ,to_number(p_information234)
2737 ,to_number(p_information235)
2738 ,to_number(p_information236)
2739 ,to_number(p_information237)
2740 ,to_number(p_information238)
2741 ,to_number(p_information239)
2742 ,to_number(p_information240)
2743 ,to_number(p_information241)
2744 ,to_number(p_information242)
2745 ,to_number(p_information243)
2746 ,to_number(p_information244)
2747 ,to_number(p_information245)
2748 ,to_number(p_information246)
2749 ,to_number(p_information247)
2750 ,to_number(p_information248)
2751 ,to_number(p_information249)
2752 ,to_number(p_information250)
2753 ,to_number(p_information251)
2754 ,to_number(p_information252)
2755 ,to_number(p_information253)
2756 ,to_number(p_information254)
2757 ,to_number(p_information255)
2758 ,to_number(p_information256)
2759 ,to_number(p_information257)
2760 ,to_number(p_information258)
2761 ,to_number(p_information259)
2762 ,to_number(p_information260)
2763 ,to_number(p_information261)
2764 ,to_number(p_information262)
2765 ,to_number(p_information263)
2766 ,to_number(p_information264)
2767 ,to_number(p_information265)
2768 ,to_number(p_information266)
2769 ,to_number(p_information267)
2770 ,to_number(p_information268)
2771 ,to_number(p_information269)
2772 ,to_number(p_information270)
2773 ,to_number(p_information271)
2774 ,to_number(p_information272)
2775 ,to_number(p_information273)
2776 ,to_number(p_information274)
2777 ,to_number(p_information275)
2778 ,to_number(p_information276)
2779 ,to_number(p_information277)
2780 ,to_number(p_information278)
2781 ,to_number(p_information279)
2782 ,to_number(p_information280)
2783 ,to_number(p_information281)
2784 ,to_number(p_information282)
2785 ,to_number(p_information283)
2786 ,to_number(p_information284)
2787 ,to_number(p_information285)
2788 ,to_number(p_information286)
2789 ,to_number(p_information287)
2790 ,to_number(p_information288)
2791 ,to_number(p_information289)
2792 ,to_number(p_information290)
2793 ,to_number(p_information291)
2794 ,to_number(p_information292)
2795 ,to_number(p_information293)
2796 ,to_number(p_information294)
2797 ,to_number(p_information295)
2798 ,to_number(p_information296)
2799 ,to_number(p_information297)
2800 ,to_number(p_information298)
2801 ,to_number(p_information299)
2802 ,to_number(p_information300)
2803 ,to_number(p_information301)
2804 ,to_number(p_information302)
2805 ,to_number(p_information303)
2806 ,to_number(p_information304)
2807
2808 /* Extra Reserved Columns
2809 ,to_number(p_information305)
2810 */
2811 ,to_date(p_information306,'DD/MM/YYYY')
2812 ,to_date(p_information307,'DD/MM/YYYY')
2813 ,to_date(p_information308,'DD/MM/YYYY')
2814 ,to_date(p_information309,'DD/MM/YYYY')
2815 ,to_date(p_information310,'DD/MM/YYYY')
2816 ,to_date(p_information311,'DD/MM/YYYY')
2817 ,to_date(p_information312,'DD/MM/YYYY')
2818 ,to_date(p_information313,'DD/MM/YYYY')
2819 ,to_date(p_information314,'DD/MM/YYYY')
2820 ,to_date(p_information315,'DD/MM/YYYY')
2821 ,to_date(p_information316,'DD/MM/YYYY')
2822 ,to_date(p_information317,'DD/MM/YYYY')
2823 ,to_date(p_information318,'DD/MM/YYYY')
2824 ,to_date(p_information319,'DD/MM/YYYY')
2825 ,to_date(p_information320,'DD/MM/YYYY')
2826
2827 /* Extra Reserved Columns
2828 ,to_date(p_information321,'DD/MM/YYYY')
2829 ,to_date(p_information322,'DD/MM/YYYY')
2830 */
2831 ,p_information323
2832 ,p_datetrack_mode
2833 ,p_table_alias
2834 ,l_object_version_number
2835 ,l_last_update_date --Bug : 4354708
2836 ,l_last_updated_by
2837 ,l_last_update_login
2838 ,l_created_by
2839 ,l_creation_date --Bug : 4354708
2840 );
2841
2842 --
2843 hr_utility.set_location(' Leaving:'||l_proc, 10);
2844 Exception
2845 When hr_api.check_integrity_violated Then
2846 -- A check constraint has been violated
2847 pqh_cer_shd.constraint_error
2848 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2849 When hr_api.parent_integrity_violated Then
2850 -- Parent integrity has been violated
2851 pqh_cer_shd.constraint_error
2852 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2853 When hr_api.unique_integrity_violated Then
2854 -- Unique integrity has been violated
2855 pqh_cer_shd.constraint_error
2856 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
2857 When Others Then
2858 Raise;
2859 End ;
2860 end if;
2861 end if; -- p_mode
2862 end;
2863
2864 end ben_plan_copy_loader;