[Home] [Help]
PACKAGE BODY: APPS.ZX_MIGR_AR_TAX_GROUP_LOOKUPS
Source
1 PACKAGE BODY ZX_MIGR_AR_TAX_GROUP_LOOKUPS AS
2 /* $Header: zxcondconstmigrb.pls 120.3 2006/08/18 12:47:52 asengupt ship $ */
3
4 -- Forward declarations
5 Procedure DISABLE_EXT_AR_TG_LOOKUPS;
6 Procedure Create_Lookups;
7
8 PG_DEBUG CONSTANT VARCHAR(1) default
9 NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
10
11 /*=========================================================================+
12 | PROCEDURE |
13 | migrate_condition_constraints |
14 | |
15 | DESCRIPTION |
16 | This routine migrates the lookups for AR Tax Group conditions and |
17 | constraints to eBTax rules model. |
18 | |
19 | SCOPE - PUBLIC |
20 | |
21 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
22 | |
23 | CALLED FROM |
24 | |
25 | NOTES |
26 | |
27 | MODIFICATION HISTORY |
28 | 15-Oct-04 Nilesh Patel Created. |
29 | |
30 |=========================================================================*/
31
32
33 PROCEDURE MIGRATE_CONDITION_CONSTRAINTS is
34 BEGIN
35
36 IF PG_DEBUG = 'Y' THEN
37 arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints(+)');
38 END IF;
39
40 Savepoint pre_migr_ar_tax_group_lookups;
41
42 Disable_Ext_Ar_Tg_Lookups;
43 Create_Lookups;
44
45 IF PG_DEBUG = 'Y' THEN
46 arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints(-)');
47 END IF;
48
49 EXCEPTION
50 WHEN OTHERS THEN
51 IF PG_DEBUG = 'Y' THEN
52 arp_util_tax.debug('Exception in ZX_MIGRATE_AR_TAX_GROUPS.Migrate_Condition_Constraints: '
53 || SQLCODE ||';'||SQLERRM);
54 END IF;
55
56 Rollback To pre_migr_ar_tax_group_lookups;
57 app_exception.raise_exception;
58
59 END;
60
61
62 /*=========================================================================+
63 | PROCEDURE |
64 | disable_ext_ar_tg_lookups |
65 | |
66 | DESCRIPTION |
67 | This routine makes the user extensible lookups for AR Tax Group |
68 | conditions and constraintes non-extensible during the upgrade |
69 | window. |
70 | |
71 | SCOPE - PUBLIC |
72 | |
73 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
74 | |
75 | CALLED FROM |
76 | |
77 | NOTES |
78 | |
79 | MODIFICATION HISTORY |
80 | 11-Oct-04 Nilesh Patel Created. |
81 | |
82 |=========================================================================*/
83
84
85 PROCEDURE DISABLE_EXT_AR_TG_LOOKUPS is
86 BEGIN
87
88 IF PG_DEBUG = 'Y' THEN
89 arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.disable_ext_ar_tg_lookups(+)');
90 END IF;
91
92 UPDATE FND_LOOKUP_TYPES
93 SET CUSTOMIZATION_LEVEL = 'S'
94 WHERE lookup_type in (
95 'TAX_CONDITION_TYPE',
96 'TAX_CONDITION_OPERATOR',
97 'TAX_CONDITION_FIELD',
98 'TAX_CONDITION_ENTITY',
99 'TAX_CONDITION_CLAUSE',
100 'TAX_CONDITION_ACTION_TYPE',
101 'TAX_CONDITION_ACTION_CODE',
102 'TAX_CONDITION_VALUE',
103 'AR_TAX_CLASSIFICATION')
104 AND CUSTOMIZATION_LEVEL = 'E'
105 AND APPLICATION_ID = 222;
106
107 IF PG_DEBUG = 'Y' THEN
108 arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.disable_ext_ar_tg_lookups(-)');
109 END IF;
110
111 END;
112
113
114
115 /*=========================================================================+
116 | PROCEDURE |
117 | Create_Lookups |
118 | |
119 | DESCRIPTION |
120 | This procedure is used to create lookups for AR Lookup types |
121 | TAX_CONDITION_TYPE |
122 | TAX_CONDITION_OPERATOR |
123 | TAX_CONDITION_FIELD |
124 | TAX_CONDITION_ENTITY |
125 | TAX_CONDITION_CLAUSE |
126 | TAX_CONDITION_ACTION_TYPE |
127 | TAX_CONDITION_ACTION_CODE |
128 | TAX_CONDITION_VALUE |
129 | AR_TAX_CLASSIFICATION |
130 | used in Tax Group conditions and constraints |
131 | |
132 | SCOPE - PUBLIC |
133 | |
134 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
135 | |
136 | CALLED FROM |
137 | MIGRATE_CONDITION_CONSTRAINTS |
138 | |
139 | NOTES |
140 | |
141 | MODIFICATION HISTORY |
142 | 08-Oct-04 Nilesh Patel Created. |
143 | |
144 |=========================================================================*/
145
146 PROCEDURE Create_Lookups IS
147 BEGIN
148
149 IF PG_DEBUG = 'Y' THEN
150 arp_util_tax.debug('Create_Lookups(+)');
151 END IF;
152
153 IF PG_DEBUG = 'Y' THEN
154 arp_util_tax.debug('creating FND_LOOKUP_TYPES....');
155 END IF;
156
157 INSERT ALL
158 WHEN (NOT EXISTS
159 (SELECT 1 FROM FND_LOOKUP_TYPES
160 WHERE LOOKUP_TYPE = 'ZX_CONDITION_TYPE'
161 AND APPLICATION_ID = 235)
162 ) THEN
163 INTO FND_LOOKUP_TYPES
164 (
165 APPLICATION_ID ,
166 LOOKUP_TYPE ,
167 CUSTOMIZATION_LEVEL ,
168 SECURITY_GROUP_ID ,
169 VIEW_APPLICATION_ID ,
170 CREATION_DATE ,
171 CREATED_BY ,
172 LAST_UPDATE_DATE ,
173 LAST_UPDATED_BY ,
174 LAST_UPDATE_LOGIN
175 )
176 VALUES
177 (
178 235 ,
179 'ZX_CONDITION_TYPE' ,
180 'S' ,
181 0 ,
182 0 ,
183 SYSDATE ,
184 fnd_global.user_id ,
185 SYSDATE ,
186 fnd_global.user_id ,
187 fnd_global.conc_login_id
188 )
189 WHEN (NOT EXISTS
190 (SELECT 1 FROM FND_LOOKUP_TYPES
191 WHERE LOOKUP_TYPE = 'ZX_CONDITION_OPERATOR'
192 AND APPLICATION_ID = 235)
193 ) THEN
194 INTO FND_LOOKUP_TYPES
195 (
196 APPLICATION_ID ,
197 LOOKUP_TYPE ,
198 CUSTOMIZATION_LEVEL ,
199 SECURITY_GROUP_ID ,
200 VIEW_APPLICATION_ID ,
201 CREATION_DATE ,
202 CREATED_BY ,
203 LAST_UPDATE_DATE ,
204 LAST_UPDATED_BY ,
205 LAST_UPDATE_LOGIN
206 )
207 VALUES
208 (
209 235 ,
210 'ZX_CONDITION_OPERATOR' ,
211 'S' ,
212 0 ,
213 0 ,
214 SYSDATE ,
215 fnd_global.user_id ,
216 SYSDATE ,
217 fnd_global.user_id ,
218 fnd_global.conc_login_id
219 )
220 WHEN (NOT EXISTS
221 (SELECT 1 FROM FND_LOOKUP_TYPES
222 WHERE LOOKUP_TYPE = 'ZX_CONDITION_FIELD'
223 AND APPLICATION_ID = 235)
224 ) THEN
225 INTO FND_LOOKUP_TYPES
226 (
227 APPLICATION_ID ,
228 LOOKUP_TYPE ,
229 CUSTOMIZATION_LEVEL ,
230 SECURITY_GROUP_ID ,
231 VIEW_APPLICATION_ID ,
232 CREATION_DATE ,
233 CREATED_BY ,
234 LAST_UPDATE_DATE ,
235 LAST_UPDATED_BY ,
236 LAST_UPDATE_LOGIN
237 )
238 VALUES
239 (
240 235 ,
241 'ZX_CONDITION_FIELD' ,
242 'S' ,
243 0 ,
244 0 ,
245 SYSDATE ,
246 fnd_global.user_id ,
247 SYSDATE ,
248 fnd_global.user_id ,
249 fnd_global.conc_login_id
250 )
251 WHEN (NOT EXISTS
252 (SELECT 1 FROM FND_LOOKUP_TYPES
253 WHERE LOOKUP_TYPE = 'ZX_CONDITION_ENTITY'
254 AND APPLICATION_ID = 235)
255 ) THEN
256 INTO FND_LOOKUP_TYPES
257 (
258 APPLICATION_ID ,
259 LOOKUP_TYPE ,
260 CUSTOMIZATION_LEVEL ,
261 SECURITY_GROUP_ID ,
262 VIEW_APPLICATION_ID ,
263 CREATION_DATE ,
264 CREATED_BY ,
265 LAST_UPDATE_DATE ,
266 LAST_UPDATED_BY ,
267 LAST_UPDATE_LOGIN
268 )
269 VALUES
270 (
271 235 ,
272 'ZX_CONDITION_ENTITY' ,
273 'S' ,
274 0 ,
275 0 ,
276 SYSDATE ,
277 fnd_global.user_id ,
278 SYSDATE ,
279 fnd_global.user_id ,
280 fnd_global.conc_login_id
281 )
282 WHEN (NOT EXISTS
283 (SELECT 1 FROM FND_LOOKUP_TYPES
284 WHERE LOOKUP_TYPE = 'ZX_CONDITION_CLAUSE'
285 AND APPLICATION_ID = 235)
286 ) THEN
287 INTO FND_LOOKUP_TYPES
288 (
289 APPLICATION_ID ,
290 LOOKUP_TYPE ,
291 CUSTOMIZATION_LEVEL ,
292 SECURITY_GROUP_ID ,
293 VIEW_APPLICATION_ID ,
294 CREATION_DATE ,
295 CREATED_BY ,
296 LAST_UPDATE_DATE ,
297 LAST_UPDATED_BY ,
298 LAST_UPDATE_LOGIN
299 )
300 VALUES
301 (
302 235 ,
303 'ZX_CONDITION_CLAUSE' ,
304 'S' ,
305 0 ,
306 0 ,
307 SYSDATE ,
308 fnd_global.user_id ,
309 SYSDATE ,
310 fnd_global.user_id ,
311 fnd_global.conc_login_id
312 )
313 WHEN (NOT EXISTS
314 (SELECT 1 FROM FND_LOOKUP_TYPES
315 WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_TYPE'
316 AND APPLICATION_ID = 235)
317 ) THEN
318 INTO FND_LOOKUP_TYPES
319 (
320 APPLICATION_ID ,
321 LOOKUP_TYPE ,
322 CUSTOMIZATION_LEVEL ,
323 SECURITY_GROUP_ID ,
324 VIEW_APPLICATION_ID ,
325 CREATION_DATE ,
326 CREATED_BY ,
327 LAST_UPDATE_DATE ,
328 LAST_UPDATED_BY ,
329 LAST_UPDATE_LOGIN
330 )
331 VALUES
332 (
333 235 ,
334 'ZX_CONDITION_ACTION_TYPE' ,
335 'S' ,
336 0 ,
337 0 ,
338 SYSDATE ,
339 fnd_global.user_id ,
340 SYSDATE ,
341 fnd_global.user_id ,
342 fnd_global.conc_login_id
343 )
344 WHEN (NOT EXISTS
345 (SELECT 1 FROM FND_LOOKUP_TYPES
346 WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_CODE'
347 AND APPLICATION_ID = 235)
348 ) THEN
349 INTO FND_LOOKUP_TYPES
350 (
351 APPLICATION_ID ,
352 LOOKUP_TYPE ,
353 CUSTOMIZATION_LEVEL ,
354 SECURITY_GROUP_ID ,
355 VIEW_APPLICATION_ID ,
356 CREATION_DATE ,
357 CREATED_BY ,
358 LAST_UPDATE_DATE ,
359 LAST_UPDATED_BY ,
360 LAST_UPDATE_LOGIN
361 )
362 VALUES
363 (
364 235 ,
365 'ZX_CONDITION_ACTION_CODE' ,
366 'S' ,
367 0 ,
368 0 ,
369 SYSDATE ,
370 fnd_global.user_id ,
371 SYSDATE ,
372 fnd_global.user_id ,
373 fnd_global.conc_login_id
374 )
375 WHEN (NOT EXISTS
376 (SELECT 1 FROM FND_LOOKUP_TYPES
377 WHERE LOOKUP_TYPE = 'ZX_CONDITION_VALUE'
378 AND APPLICATION_ID = 235)
379 ) THEN
380 INTO FND_LOOKUP_TYPES
381 (
382 APPLICATION_ID ,
383 LOOKUP_TYPE ,
384 CUSTOMIZATION_LEVEL ,
385 SECURITY_GROUP_ID ,
386 VIEW_APPLICATION_ID ,
387 CREATION_DATE ,
388 CREATED_BY ,
389 LAST_UPDATE_DATE ,
390 LAST_UPDATED_BY ,
391 LAST_UPDATE_LOGIN
392 )
393 VALUES
394 (
395 235 ,
396 'ZX_CONDITION_VALUE' ,
397 'E' ,
398 0 ,
399 0 ,
400 SYSDATE ,
401 fnd_global.user_id ,
402 SYSDATE ,
403 fnd_global.user_id ,
404 fnd_global.conc_login_id
405 )
406 WHEN (NOT EXISTS
407 (SELECT 1 FROM FND_LOOKUP_TYPES
408 WHERE LOOKUP_TYPE = 'ZX_TAX_CLASSIFICATION'
409 AND APPLICATION_ID = 235)
410 ) THEN
411 INTO FND_LOOKUP_TYPES
412 (
413 APPLICATION_ID ,
414 LOOKUP_TYPE ,
415 CUSTOMIZATION_LEVEL ,
416 SECURITY_GROUP_ID ,
417 VIEW_APPLICATION_ID ,
418 CREATION_DATE ,
419 CREATED_BY ,
420 LAST_UPDATE_DATE ,
421 LAST_UPDATED_BY ,
422 LAST_UPDATE_LOGIN
423 )
424 VALUES
425 (
426 235 ,
427 'ZX_TAX_CLASSIFICATION' ,
428 'E' ,
429 0 ,
430 0 ,
431 SYSDATE ,
432 fnd_global.user_id ,
433 SYSDATE ,
434 fnd_global.user_id ,
435 fnd_global.conc_login_id
436 )
437 SELECT 1 FROM DUAL;
438
439
440 IF PG_DEBUG = 'Y' THEN
441 arp_util_tax.debug('creating records in FND_LOOKUP_TYPES_TL...');
442 END IF;
443
444 INSERT INTO FND_LOOKUP_TYPES_TL
445 (
446 LOOKUP_TYPE,
447 SECURITY_GROUP_ID,
448 VIEW_APPLICATION_ID,
449 LANGUAGE,
450 SOURCE_LANG,
451 MEANING,
452 DESCRIPTION,
456 LAST_UPDATE_DATE,
453 CREATED_BY,
454 CREATION_DATE,
455 LAST_UPDATED_BY,
457 LAST_UPDATE_LOGIN
458 )
459 SELECT
460 types.lookup_type,
461 0 ,--SECURITY_GROUP_ID
462 0 ,--VIEW_APPLICATION_ID
463 L.LANGUAGE_CODE ,
464 userenv('LANG') ,
465 Initcap(types.lookup_type),--MEANING
466 types.lookup_type,--DESCRIPTION
467 fnd_global.user_id ,
468 SYSDATE ,
469 fnd_global.user_id ,
470 SYSDATE ,
471 fnd_global.conc_login_id
472 FROM FND_LOOKUP_TYPES types,
473 FND_LANGUAGES L
474 WHERE L.INSTALLED_FLAG in ('I', 'B')
475 AND types.lookup_type in (
476 'ZX_CONDITION_TYPE',
477 'ZX_CONDITION_OPERATOR',
478 'ZX_CONDITION_FIELD',
479 'ZX_CONDITION_ENTITY',
480 'ZX_CONDITION_CLAUSE',
481 'ZX_CONDITION_ACTION_TYPE',
482 'ZX_CONDITION_ACTION_CODE',
483 'ZX_CONDITION_VALUE',
484 'ZX_TAX_CLASSIFICATION')
485 AND not exists
486 (select 1
487 from fnd_lookup_types_tl sub
488 where sub.lookup_type = types.lookup_type
489 and sub.security_group_id = 0
490 and sub.view_application_id = 0
491 and sub.language = l.language_code);
492
493
494 IF PG_DEBUG = 'Y' THEN
495 arp_util_tax.debug('creating records in FND_LOOKUP_VALUES...');
496 END IF;
497
498 /* Insert lookup codes for the lookup types */
499 INSERT INTO FND_LOOKUP_VALUES
500 (
501 LOOKUP_TYPE ,
502 LANGUAGE ,
503 LOOKUP_CODE ,
504 MEANING ,
505 DESCRIPTION ,
506 ENABLED_FLAG ,
507 START_DATE_ACTIVE ,
508 END_DATE_ACTIVE ,
509 SOURCE_LANG ,
510 SECURITY_GROUP_ID ,
511 VIEW_APPLICATION_ID ,
512 TERRITORY_CODE ,
513 ATTRIBUTE_CATEGORY ,
514 ATTRIBUTE1 ,
515 ATTRIBUTE2 ,
516 ATTRIBUTE3 ,
517 ATTRIBUTE4 ,
518 ATTRIBUTE5 ,
519 ATTRIBUTE6 ,
520 ATTRIBUTE7 ,
521 ATTRIBUTE8 ,
522 ATTRIBUTE9 ,
523 ATTRIBUTE10 ,
524 ATTRIBUTE11 ,
525 ATTRIBUTE12 ,
526 ATTRIBUTE13 ,
527 ATTRIBUTE14 ,
528 ATTRIBUTE15 ,
529 TAG ,
530 CREATION_DATE ,
531 CREATED_BY ,
532 LAST_UPDATE_DATE ,
533 LAST_UPDATED_BY ,
534 LAST_UPDATE_LOGIN
535 )
536 SELECT
537 'ZX_CONDITION_TYPE',
538 l.language_code , -- LANGUAGE
539 lk.LOOKUP_CODE ,
540 lk.MEANING ,
541 lk.DESCRIPTION ,
542 'Y' ,--ENABLED_FLAG
543 lk.START_DATE_ACTIVE ,
544 NULL ,--END_DATE_ACTIVE
545 userenv('LANG') ,--SOURCE_LANG
546 0 ,--SECURITY_GROUP_ID
547 0 ,--VIEW_APPLICATION_ID
548 NULL ,--TERRITORY_CODE
549 NULL ,--ATTRIBUTE_CATEGORY
550 NULL ,--ATTRIBUTE1
551 NULL ,--ATTRIBUTE2
552 NULL ,--ATTRIBUTE3
553 NULL ,--ATTRIBUTE4
554 NULL ,--ATTRIBUTE5
555 NULL ,--ATTRIBUTE6
556 NULL ,--ATTRIBUTE7
557 NULL ,--ATTRIBUTE8
558 NULL ,--ATTRIBUTE9
559 NULL ,--ATTRIBUTE10
560 NULL ,--ATTRIBUTE11
561 NULL ,--ATTRIBUTE12
562 NULL ,--ATTRIBUTE13
563 NULL ,--ATTRIBUTE14
564 NULL ,--ATTRIBUTE15
565 NULL ,--TAG
566 SYSDATE ,
567 fnd_global.user_id ,
568 SYSDATE ,
569 fnd_global.user_id ,
570 fnd_global.conc_login_id
571 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
572 WHERE lk.lookup_type = 'TAX_CONDITION_TYPE'
573 AND view_application_id = 222
574 AND lk.language = 'US'
575 AND l.installed_flag in ('I', 'B')
576 AND not exists
577 (select '1'
578 from FND_LOOKUP_VALUES
579 where lookup_code = lk.lookup_code
580 and lookup_type = 'ZX_CONDITION_TYPE'
581 and language = l.LANGUAGE_CODE);
582
583 /* Insert lookup codes for the lookup types */
584 INSERT INTO FND_LOOKUP_VALUES
585 (
586 LOOKUP_TYPE ,
587 LANGUAGE ,
588 LOOKUP_CODE ,
589 MEANING ,
590 DESCRIPTION ,
591 ENABLED_FLAG ,
592 START_DATE_ACTIVE ,
593 END_DATE_ACTIVE ,
594 SOURCE_LANG ,
595 SECURITY_GROUP_ID ,
596 VIEW_APPLICATION_ID ,
597 TERRITORY_CODE ,
598 ATTRIBUTE_CATEGORY ,
599 ATTRIBUTE1 ,
600 ATTRIBUTE2 ,
601 ATTRIBUTE3 ,
602 ATTRIBUTE4 ,
603 ATTRIBUTE5 ,
607 ATTRIBUTE9 ,
604 ATTRIBUTE6 ,
605 ATTRIBUTE7 ,
606 ATTRIBUTE8 ,
608 ATTRIBUTE10 ,
609 ATTRIBUTE11 ,
610 ATTRIBUTE12 ,
611 ATTRIBUTE13 ,
612 ATTRIBUTE14 ,
613 ATTRIBUTE15 ,
614 TAG ,
615 CREATION_DATE ,
616 CREATED_BY ,
617 LAST_UPDATE_DATE ,
618 LAST_UPDATED_BY ,
619 LAST_UPDATE_LOGIN
620 )
621 SELECT
622 'ZX_CONDITION_OPERATOR',
623 l.language_code , -- LANGUAGE
624 lk.LOOKUP_CODE ,
625 lk.MEANING ,
626 lk.DESCRIPTION ,
627 'Y' ,--ENABLED_FLAG
628 lk.START_DATE_ACTIVE ,
629 NULL ,--END_DATE_ACTIVE
630 userenv('LANG') ,--SOURCE_LANG
631 0 ,--SECURITY_GROUP_ID
632 0 ,--VIEW_APPLICATION_ID
633 NULL ,--TERRITORY_CODE
634 NULL ,--ATTRIBUTE_CATEGORY
635 NULL ,--ATTRIBUTE1
636 NULL ,--ATTRIBUTE2
637 NULL ,--ATTRIBUTE3
638 NULL ,--ATTRIBUTE4
639 NULL ,--ATTRIBUTE5
640 NULL ,--ATTRIBUTE6
641 NULL ,--ATTRIBUTE7
642 NULL ,--ATTRIBUTE8
643 NULL ,--ATTRIBUTE9
644 NULL ,--ATTRIBUTE10
645 NULL ,--ATTRIBUTE11
646 NULL ,--ATTRIBUTE12
647 NULL ,--ATTRIBUTE13
648 NULL ,--ATTRIBUTE14
649 NULL ,--ATTRIBUTE15
650 NULL ,--TAG
651 SYSDATE ,
652 fnd_global.user_id ,
653 SYSDATE ,
654 fnd_global.user_id ,
655 fnd_global.conc_login_id
656 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
657 WHERE lk.lookup_type = 'TAX_CONDITION_OPERATOR'
658 AND view_application_id = 222
659 AND lk.language = 'US'
660 AND l.installed_flag in ('I', 'B')
661 AND not exists
662 (select '1'
663 from FND_LOOKUP_VALUES
664 where lookup_code = lk.lookup_code
665 and lookup_type = 'ZX_CONDITION_OPERATOR'
666 and language = l.LANGUAGE_CODE);
667
668 /* Insert lookup codes for the lookup types */
669 INSERT INTO FND_LOOKUP_VALUES
670 (
671 LOOKUP_TYPE ,
672 LANGUAGE ,
673 LOOKUP_CODE ,
674 MEANING ,
675 DESCRIPTION ,
676 ENABLED_FLAG ,
677 START_DATE_ACTIVE ,
678 END_DATE_ACTIVE ,
679 SOURCE_LANG ,
680 SECURITY_GROUP_ID ,
681 VIEW_APPLICATION_ID ,
682 TERRITORY_CODE ,
683 ATTRIBUTE_CATEGORY ,
684 ATTRIBUTE1 ,
685 ATTRIBUTE2 ,
686 ATTRIBUTE3 ,
687 ATTRIBUTE4 ,
688 ATTRIBUTE5 ,
689 ATTRIBUTE6 ,
690 ATTRIBUTE7 ,
691 ATTRIBUTE8 ,
692 ATTRIBUTE9 ,
693 ATTRIBUTE10 ,
694 ATTRIBUTE11 ,
695 ATTRIBUTE12 ,
696 ATTRIBUTE13 ,
697 ATTRIBUTE14 ,
698 ATTRIBUTE15 ,
699 TAG ,
700 CREATION_DATE ,
701 CREATED_BY ,
702 LAST_UPDATE_DATE ,
703 LAST_UPDATED_BY ,
704 LAST_UPDATE_LOGIN
705 )
706 SELECT
707 'ZX_CONDITION_FIELD',
708 l.language_code , -- LANGUAGE
709 lk.LOOKUP_CODE ,
710 lk.MEANING ,
711 lk.DESCRIPTION ,
712 'Y' ,--ENABLED_FLAG
713 lk.START_DATE_ACTIVE ,
714 NULL ,--END_DATE_ACTIVE
715 userenv('LANG') ,--SOURCE_LANG
716 0 ,--SECURITY_GROUP_ID
717 0 ,--VIEW_APPLICATION_ID
718 NULL ,--TERRITORY_CODE
719 NULL ,--ATTRIBUTE_CATEGORY
720 NULL ,--ATTRIBUTE1
721 NULL ,--ATTRIBUTE2
722 NULL ,--ATTRIBUTE3
723 NULL ,--ATTRIBUTE4
724 NULL ,--ATTRIBUTE5
725 NULL ,--ATTRIBUTE6
726 NULL ,--ATTRIBUTE7
727 NULL ,--ATTRIBUTE8
728 NULL ,--ATTRIBUTE9
729 NULL ,--ATTRIBUTE10
730 NULL ,--ATTRIBUTE11
731 NULL ,--ATTRIBUTE12
732 NULL ,--ATTRIBUTE13
733 NULL ,--ATTRIBUTE14
734 NULL ,--ATTRIBUTE15
735 NULL ,--TAG
736 SYSDATE ,
737 fnd_global.user_id ,
738 SYSDATE ,
739 fnd_global.user_id ,
740 fnd_global.conc_login_id
741 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
742 WHERE lk.lookup_type = 'TAX_CONDITION_FIELD'
743 AND view_application_id = 222
744 AND lk.language = 'US'
745 AND l.installed_flag in ('I', 'B')
746 AND not exists
747 (select '1'
748 from FND_LOOKUP_VALUES
752
749 where lookup_code = lk.lookup_code
750 and lookup_type = 'ZX_CONDITION_FIELD'
751 and language = l.LANGUAGE_CODE);
753 /* Insert lookup codes for the lookup types */
754 INSERT INTO FND_LOOKUP_VALUES
755 (
756 LOOKUP_TYPE ,
757 LANGUAGE ,
758 LOOKUP_CODE ,
759 MEANING ,
760 DESCRIPTION ,
761 ENABLED_FLAG ,
762 START_DATE_ACTIVE ,
763 END_DATE_ACTIVE ,
764 SOURCE_LANG ,
765 SECURITY_GROUP_ID ,
766 VIEW_APPLICATION_ID ,
767 TERRITORY_CODE ,
768 ATTRIBUTE_CATEGORY ,
769 ATTRIBUTE1 ,
770 ATTRIBUTE2 ,
771 ATTRIBUTE3 ,
772 ATTRIBUTE4 ,
773 ATTRIBUTE5 ,
774 ATTRIBUTE6 ,
775 ATTRIBUTE7 ,
776 ATTRIBUTE8 ,
777 ATTRIBUTE9 ,
778 ATTRIBUTE10 ,
779 ATTRIBUTE11 ,
780 ATTRIBUTE12 ,
781 ATTRIBUTE13 ,
782 ATTRIBUTE14 ,
783 ATTRIBUTE15 ,
784 TAG ,
785 CREATION_DATE ,
786 CREATED_BY ,
787 LAST_UPDATE_DATE ,
788 LAST_UPDATED_BY ,
789 LAST_UPDATE_LOGIN
790 )
791 SELECT
792 'ZX_CONDITION_ENTITY',
793 l.language_code , -- LANGUAGE
794 lk.LOOKUP_CODE ,
795 lk.MEANING ,
796 lk.DESCRIPTION ,
797 'Y' ,--ENABLED_FLAG
798 lk.START_DATE_ACTIVE ,
799 NULL ,--END_DATE_ACTIVE
800 userenv('LANG') ,--SOURCE_LANG
801 0 ,--SECURITY_GROUP_ID
802 0 ,--VIEW_APPLICATION_ID
803 NULL ,--TERRITORY_CODE
804 NULL ,--ATTRIBUTE_CATEGORY
805 NULL ,--ATTRIBUTE1
806 NULL ,--ATTRIBUTE2
807 NULL ,--ATTRIBUTE3
808 NULL ,--ATTRIBUTE4
809 NULL ,--ATTRIBUTE5
810 NULL ,--ATTRIBUTE6
811 NULL ,--ATTRIBUTE7
812 NULL ,--ATTRIBUTE8
813 NULL ,--ATTRIBUTE9
814 NULL ,--ATTRIBUTE10
815 NULL ,--ATTRIBUTE11
816 NULL ,--ATTRIBUTE12
817 NULL ,--ATTRIBUTE13
818 NULL ,--ATTRIBUTE14
819 NULL ,--ATTRIBUTE15
820 NULL ,--TAG
821 SYSDATE ,
822 fnd_global.user_id ,
823 SYSDATE ,
824 fnd_global.user_id ,
825 fnd_global.conc_login_id
826 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
827 WHERE lk.lookup_type = 'TAX_CONDITION_ENTITY'
828 AND view_application_id = 222
829 AND lk.language = 'US'
830 AND l.installed_flag in ('I', 'B')
831 AND not exists
832 (select '1'
833 from FND_LOOKUP_VALUES
834 where lookup_code = lk.lookup_code
835 and lookup_type = 'ZX_CONDITION_ENTITY'
836 and language = l.LANGUAGE_CODE);
837
838 /* Insert lookup codes for the lookup types */
839 INSERT INTO FND_LOOKUP_VALUES
840 (
841 LOOKUP_TYPE ,
842 LANGUAGE ,
843 LOOKUP_CODE ,
844 MEANING ,
845 DESCRIPTION ,
846 ENABLED_FLAG ,
847 START_DATE_ACTIVE ,
848 END_DATE_ACTIVE ,
849 SOURCE_LANG ,
850 SECURITY_GROUP_ID ,
851 VIEW_APPLICATION_ID ,
852 TERRITORY_CODE ,
853 ATTRIBUTE_CATEGORY ,
854 ATTRIBUTE1 ,
855 ATTRIBUTE2 ,
856 ATTRIBUTE3 ,
857 ATTRIBUTE4 ,
858 ATTRIBUTE5 ,
859 ATTRIBUTE6 ,
860 ATTRIBUTE7 ,
861 ATTRIBUTE8 ,
862 ATTRIBUTE9 ,
863 ATTRIBUTE10 ,
864 ATTRIBUTE11 ,
865 ATTRIBUTE12 ,
866 ATTRIBUTE13 ,
867 ATTRIBUTE14 ,
868 ATTRIBUTE15 ,
869 TAG ,
870 CREATION_DATE ,
871 CREATED_BY ,
872 LAST_UPDATE_DATE ,
873 LAST_UPDATED_BY ,
874 LAST_UPDATE_LOGIN
875 )
876 SELECT
877 'ZX_CONDITION_CLAUSE',
878 l.language_code , -- LANGUAGE
879 lk.LOOKUP_CODE ,
880 lk.MEANING ,
881 lk.DESCRIPTION ,
882 'Y' ,--ENABLED_FLAG
883 lk.START_DATE_ACTIVE ,
884 NULL ,--END_DATE_ACTIVE
885 userenv('LANG') ,--SOURCE_LANG
886 0 ,--SECURITY_GROUP_ID
887 0 ,--VIEW_APPLICATION_ID
888 NULL ,--TERRITORY_CODE
889 NULL ,--ATTRIBUTE_CATEGORY
890 NULL ,--ATTRIBUTE1
891 NULL ,--ATTRIBUTE2
892 NULL ,--ATTRIBUTE3
893 NULL ,--ATTRIBUTE4
894 NULL ,--ATTRIBUTE5
895 NULL ,--ATTRIBUTE6
896 NULL ,--ATTRIBUTE7
900 NULL ,--ATTRIBUTE11
897 NULL ,--ATTRIBUTE8
898 NULL ,--ATTRIBUTE9
899 NULL ,--ATTRIBUTE10
901 NULL ,--ATTRIBUTE12
902 NULL ,--ATTRIBUTE13
903 NULL ,--ATTRIBUTE14
904 NULL ,--ATTRIBUTE15
905 NULL ,--TAG
906 SYSDATE ,
907 fnd_global.user_id ,
908 SYSDATE ,
909 fnd_global.user_id ,
910 fnd_global.conc_login_id
911 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
912 WHERE lk.lookup_type = 'TAX_CONDITION_CLAUSE'
913 AND view_application_id = 222
914 AND lk.language = 'US'
915 AND l.installed_flag in ('I', 'B')
916 AND not exists
917 (select '1'
918 from FND_LOOKUP_VALUES
919 where lookup_code = lk.lookup_code
920 and lookup_type = 'ZX_CONDITION_CLAUSE'
921 and language = l.LANGUAGE_CODE);
922
923 /* Insert lookup codes for the lookup types */
924 INSERT INTO FND_LOOKUP_VALUES
925 (
926 LOOKUP_TYPE ,
927 LANGUAGE ,
928 LOOKUP_CODE ,
929 MEANING ,
930 DESCRIPTION ,
931 ENABLED_FLAG ,
932 START_DATE_ACTIVE ,
933 END_DATE_ACTIVE ,
934 SOURCE_LANG ,
935 SECURITY_GROUP_ID ,
936 VIEW_APPLICATION_ID ,
937 TERRITORY_CODE ,
938 ATTRIBUTE_CATEGORY ,
939 ATTRIBUTE1 ,
940 ATTRIBUTE2 ,
941 ATTRIBUTE3 ,
942 ATTRIBUTE4 ,
943 ATTRIBUTE5 ,
944 ATTRIBUTE6 ,
945 ATTRIBUTE7 ,
946 ATTRIBUTE8 ,
947 ATTRIBUTE9 ,
948 ATTRIBUTE10 ,
949 ATTRIBUTE11 ,
950 ATTRIBUTE12 ,
951 ATTRIBUTE13 ,
952 ATTRIBUTE14 ,
953 ATTRIBUTE15 ,
954 TAG ,
955 CREATION_DATE ,
956 CREATED_BY ,
957 LAST_UPDATE_DATE ,
958 LAST_UPDATED_BY ,
959 LAST_UPDATE_LOGIN
960 )
961 SELECT
962 'ZX_CONDITION_ACTION_TYPE',
963 l.language_code , -- LANGUAGE
964 lk.LOOKUP_CODE ,
965 lk.MEANING ,
966 lk.DESCRIPTION ,
967 'Y' ,--ENABLED_FLAG
968 lk.START_DATE_ACTIVE ,
969 NULL ,--END_DATE_ACTIVE
970 userenv('LANG') ,--SOURCE_LANG
971 0 ,--SECURITY_GROUP_ID
972 0 ,--VIEW_APPLICATION_ID
973 NULL ,--TERRITORY_CODE
974 NULL ,--ATTRIBUTE_CATEGORY
975 NULL ,--ATTRIBUTE1
976 NULL ,--ATTRIBUTE2
977 NULL ,--ATTRIBUTE3
978 NULL ,--ATTRIBUTE4
979 NULL ,--ATTRIBUTE5
980 NULL ,--ATTRIBUTE6
981 NULL ,--ATTRIBUTE7
982 NULL ,--ATTRIBUTE8
983 NULL ,--ATTRIBUTE9
984 NULL ,--ATTRIBUTE10
985 NULL ,--ATTRIBUTE11
986 NULL ,--ATTRIBUTE12
987 NULL ,--ATTRIBUTE13
988 NULL ,--ATTRIBUTE14
989 NULL ,--ATTRIBUTE15
990 NULL ,--TAG
991 SYSDATE ,
992 fnd_global.user_id ,
993 SYSDATE ,
994 fnd_global.user_id ,
995 fnd_global.conc_login_id
996 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
997 WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_TYPE'
998 AND view_application_id = 222
999 AND lk.language = 'US'
1000 AND l.installed_flag in ('I', 'B')
1001 AND not exists
1002 (select '1'
1003 from FND_LOOKUP_VALUES
1004 where lookup_code = lk.lookup_code
1005 and lookup_type = 'ZX_CONDITION_ACTION_TYPE'
1006 and language = l.LANGUAGE_CODE);
1007
1008 /* Insert lookup codes for the lookup types */
1009 INSERT INTO FND_LOOKUP_VALUES
1010 (
1011 LOOKUP_TYPE ,
1012 LANGUAGE ,
1013 LOOKUP_CODE ,
1014 MEANING ,
1015 DESCRIPTION ,
1016 ENABLED_FLAG ,
1017 START_DATE_ACTIVE ,
1018 END_DATE_ACTIVE ,
1019 SOURCE_LANG ,
1020 SECURITY_GROUP_ID ,
1021 VIEW_APPLICATION_ID ,
1022 TERRITORY_CODE ,
1023 ATTRIBUTE_CATEGORY ,
1024 ATTRIBUTE1 ,
1025 ATTRIBUTE2 ,
1026 ATTRIBUTE3 ,
1027 ATTRIBUTE4 ,
1028 ATTRIBUTE5 ,
1029 ATTRIBUTE6 ,
1030 ATTRIBUTE7 ,
1031 ATTRIBUTE8 ,
1032 ATTRIBUTE9 ,
1033 ATTRIBUTE10 ,
1034 ATTRIBUTE11 ,
1035 ATTRIBUTE12 ,
1036 ATTRIBUTE13 ,
1037 ATTRIBUTE14 ,
1038 ATTRIBUTE15 ,
1039 TAG ,
1040 CREATION_DATE ,
1041 CREATED_BY ,
1042 LAST_UPDATE_DATE ,
1043 LAST_UPDATED_BY ,
1044 LAST_UPDATE_LOGIN
1045 )
1046 SELECT
1047 'ZX_CONDITION_ACTION_CODE',
1048 l.language_code , -- LANGUAGE
1049 lk.LOOKUP_CODE ,
1050 lk.MEANING ,
1051 lk.DESCRIPTION ,
1052 'Y' ,--ENABLED_FLAG
1053 lk.START_DATE_ACTIVE ,
1054 NULL ,--END_DATE_ACTIVE
1055 userenv('LANG') ,--SOURCE_LANG
1056 0 ,--SECURITY_GROUP_ID
1057 0 ,--VIEW_APPLICATION_ID
1058 NULL ,--TERRITORY_CODE
1059 NULL ,--ATTRIBUTE_CATEGORY
1060 NULL ,--ATTRIBUTE1
1061 NULL ,--ATTRIBUTE2
1062 NULL ,--ATTRIBUTE3
1063 NULL ,--ATTRIBUTE4
1064 NULL ,--ATTRIBUTE5
1065 NULL ,--ATTRIBUTE6
1066 NULL ,--ATTRIBUTE7
1067 NULL ,--ATTRIBUTE8
1068 NULL ,--ATTRIBUTE9
1069 NULL ,--ATTRIBUTE10
1070 NULL ,--ATTRIBUTE11
1071 NULL ,--ATTRIBUTE12
1072 NULL ,--ATTRIBUTE13
1073 NULL ,--ATTRIBUTE14
1074 NULL ,--ATTRIBUTE15
1075 NULL ,--TAG
1076 SYSDATE ,
1077 fnd_global.user_id ,
1078 SYSDATE ,
1079 fnd_global.user_id ,
1080 fnd_global.conc_login_id
1081 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1082 WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_CODE'
1083 AND view_application_id = 222
1084 AND lk.language = 'US'
1085 AND l.installed_flag in ('I', 'B')
1086 AND not exists
1087 (select '1'
1088 from FND_LOOKUP_VALUES
1089 where lookup_code = lk.lookup_code
1090 and lookup_type = 'ZX_CONDITION_ACTION_CODE'
1091 and language = l.LANGUAGE_CODE);
1092
1093 /* Insert lookup codes for the lookup types */
1094 INSERT INTO FND_LOOKUP_VALUES
1095 (
1096 LOOKUP_TYPE ,
1097 LANGUAGE ,
1098 LOOKUP_CODE ,
1099 MEANING ,
1100 DESCRIPTION ,
1101 ENABLED_FLAG ,
1102 START_DATE_ACTIVE ,
1103 END_DATE_ACTIVE ,
1104 SOURCE_LANG ,
1105 SECURITY_GROUP_ID ,
1106 VIEW_APPLICATION_ID ,
1107 TERRITORY_CODE ,
1108 ATTRIBUTE_CATEGORY ,
1109 ATTRIBUTE1 ,
1110 ATTRIBUTE2 ,
1114 ATTRIBUTE6 ,
1111 ATTRIBUTE3 ,
1112 ATTRIBUTE4 ,
1113 ATTRIBUTE5 ,
1115 ATTRIBUTE7 ,
1116 ATTRIBUTE8 ,
1117 ATTRIBUTE9 ,
1118 ATTRIBUTE10 ,
1119 ATTRIBUTE11 ,
1120 ATTRIBUTE12 ,
1121 ATTRIBUTE13 ,
1122 ATTRIBUTE14 ,
1123 ATTRIBUTE15 ,
1124 TAG ,
1125 CREATION_DATE ,
1126 CREATED_BY ,
1127 LAST_UPDATE_DATE ,
1128 LAST_UPDATED_BY ,
1129 LAST_UPDATE_LOGIN
1130 )
1131 SELECT
1132 'ZX_CONDITION_VALUE',
1133 l.language_code , -- LANGUAGE
1134 lk.LOOKUP_CODE ,
1135 lk.MEANING ,
1136 lk.DESCRIPTION ,
1137 'Y' ,--ENABLED_FLAG
1138 lk.START_DATE_ACTIVE ,
1139 NULL ,--END_DATE_ACTIVE
1140 userenv('LANG') ,--SOURCE_LANG
1141 0 ,--SECURITY_GROUP_ID
1142 0 ,--VIEW_APPLICATION_ID
1143 NULL ,--TERRITORY_CODE
1144 NULL ,--ATTRIBUTE_CATEGORY
1145 NULL ,--ATTRIBUTE1
1146 NULL ,--ATTRIBUTE2
1147 NULL ,--ATTRIBUTE3
1148 NULL ,--ATTRIBUTE4
1149 NULL ,--ATTRIBUTE5
1150 NULL ,--ATTRIBUTE6
1151 NULL ,--ATTRIBUTE7
1152 NULL ,--ATTRIBUTE8
1153 NULL ,--ATTRIBUTE9
1154 NULL ,--ATTRIBUTE10
1155 NULL ,--ATTRIBUTE11
1156 NULL ,--ATTRIBUTE12
1157 NULL ,--ATTRIBUTE13
1158 NULL ,--ATTRIBUTE14
1159 NULL ,--ATTRIBUTE15
1160 NULL ,--TAG
1161 SYSDATE ,
1162 fnd_global.user_id ,
1163 SYSDATE ,
1164 fnd_global.user_id ,
1165 fnd_global.conc_login_id
1166 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1167 WHERE lk.lookup_type = 'TAX_CONDITION_VALUE'
1168 AND view_application_id = 222
1169 AND lk.language = 'US'
1170 AND l.installed_flag in ('I', 'B')
1171 AND not exists
1172 (select '1'
1173 from FND_LOOKUP_VALUES
1174 where lookup_code = lk.lookup_code
1175 and lookup_type = 'ZX_CONDITION_VALUE'
1176 and language = l.LANGUAGE_CODE);
1177
1178 /* Insert lookup codes for the lookup types */
1179 INSERT INTO FND_LOOKUP_VALUES
1180 (
1181 LOOKUP_TYPE ,
1182 LANGUAGE ,
1183 LOOKUP_CODE ,
1184 MEANING ,
1185 DESCRIPTION ,
1186 ENABLED_FLAG ,
1187 START_DATE_ACTIVE ,
1188 END_DATE_ACTIVE ,
1189 SOURCE_LANG ,
1190 SECURITY_GROUP_ID ,
1191 VIEW_APPLICATION_ID ,
1192 TERRITORY_CODE ,
1193 ATTRIBUTE_CATEGORY ,
1194 ATTRIBUTE1 ,
1195 ATTRIBUTE2 ,
1196 ATTRIBUTE3 ,
1197 ATTRIBUTE4 ,
1198 ATTRIBUTE5 ,
1199 ATTRIBUTE6 ,
1200 ATTRIBUTE7 ,
1201 ATTRIBUTE8 ,
1202 ATTRIBUTE9 ,
1203 ATTRIBUTE10 ,
1204 ATTRIBUTE11 ,
1205 ATTRIBUTE12 ,
1206 ATTRIBUTE13 ,
1207 ATTRIBUTE14 ,
1208 ATTRIBUTE15 ,
1209 TAG ,
1210 CREATION_DATE ,
1211 CREATED_BY ,
1212 LAST_UPDATE_DATE ,
1213 LAST_UPDATED_BY ,
1214 LAST_UPDATE_LOGIN
1215 )
1216 SELECT
1217 'ZX_TAX_CLASSIFICATION',
1218 l.language_code , -- LANGUAGE
1219 lk.LOOKUP_CODE ,
1220 lk.MEANING ,
1221 lk.DESCRIPTION ,
1222 'Y' ,--ENABLED_FLAG
1223 lk.START_DATE_ACTIVE ,
1224 NULL ,--END_DATE_ACTIVE
1225 userenv('LANG') ,--SOURCE_LANG
1226 0 ,--SECURITY_GROUP_ID
1227 0 ,--VIEW_APPLICATION_ID
1228 NULL ,--TERRITORY_CODE
1229 NULL ,--ATTRIBUTE_CATEGORY
1230 NULL ,--ATTRIBUTE1
1231 NULL ,--ATTRIBUTE2
1232 NULL ,--ATTRIBUTE3
1233 NULL ,--ATTRIBUTE4
1234 NULL ,--ATTRIBUTE5
1235 NULL ,--ATTRIBUTE6
1236 NULL ,--ATTRIBUTE7
1237 NULL ,--ATTRIBUTE8
1238 NULL ,--ATTRIBUTE9
1239 NULL ,--ATTRIBUTE10
1240 NULL ,--ATTRIBUTE11
1241 NULL ,--ATTRIBUTE12
1242 NULL ,--ATTRIBUTE13
1243 NULL ,--ATTRIBUTE14
1244 NULL ,--ATTRIBUTE15
1245 NULL ,--TAG
1246 SYSDATE ,
1247 fnd_global.user_id ,
1248 SYSDATE ,
1249 fnd_global.user_id ,
1250 fnd_global.conc_login_id
1251 FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1252 WHERE lk.lookup_type = 'AR_TAX_CLASSIFICATION'
1253 AND view_application_id = 222
1254 AND lk.language = 'US'
1258 from FND_LOOKUP_VALUES
1255 AND l.installed_flag in ('I', 'B')
1256 AND not exists
1257 (select '1'
1259 where lookup_code = lk.lookup_code
1260 and lookup_type = 'ZX_TAX_CLASSIFICATION'
1261 and language = l.LANGUAGE_CODE);
1262
1263 IF PG_DEBUG = 'Y' THEN
1264 arp_util_tax.debug('Create_Lookup(-)');
1265 END IF;
1266 Exception
1267 When others then
1268 IF PG_DEBUG = 'Y' THEN
1269 arp_util_tax.debug('Exception: ZX_MIGRATE_AR_TAX_GROUPS.Create_Lookup:' ||
1270 SQLCODE||' ; '||SQLERRM);
1271 END IF;
1272 raise;
1273 END Create_Lookups;
1274
1275 /*=========================================================================+
1276 | PROCEDURE |
1277 | end_date_cond_cons_lk |
1278 | |
1279 | DESCRIPTION |
1280 | This routine end dates the old lookups for AR Tax Group conditions |
1281 | and constraints in the downtime. |
1282 | |
1283 | SCOPE - PUBLIC |
1284 | |
1285 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1286 | |
1287 | CALLED FROM |
1288 | |
1289 | NOTES |
1290 | |
1291 | MODIFICATION HISTORY |
1292 | 15-Oct-04 Nilesh Patel Created. |
1293 | |
1294 |=========================================================================*/
1295
1296
1297 PROCEDURE end_date_cond_cons_lk is
1298 BEGIN
1299
1300 IF PG_DEBUG = 'Y' THEN
1301 arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk(+)');
1302 END IF;
1303
1304 UPDATE fnd_lookup_values
1305 SET ENABLED_FLAG = 'N',
1306 END_DATE_ACTIVE = SYSDATE
1307 WHERE lookup_type in (
1308 'ZX_CONDITION_TYPE',
1309 'ZX_CONDITION_OPERATOR',
1310 'ZX_CONDITION_FIELD',
1311 'ZX_CONDITION_ENTITY',
1312 'ZX_CONDITION_CLAUSE',
1313 'ZX_CONDITION_ACTION_TYPE',
1314 'ZX_CONDITION_ACTION_CODE',
1315 'ZX_CONDITION_VALUE',
1316 'ZX_TAX_CLASSIFICATION')
1317 AND view_application_id = 0;
1318
1319
1320 IF PG_DEBUG = 'Y' THEN
1321 arp_util_tax.debug('ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk(-)');
1322 END IF;
1323
1324 EXCEPTION
1325 WHEN OTHERS THEN
1326 IF PG_DEBUG = 'Y' THEN
1327 arp_util_tax.debug('Exception in ZX_MIGRATE_AR_TAX_GROUPS.end_date_cond_cons_lk: '||
1328 SQLCODE||' ; '||SQLERRM);
1329 END IF;
1330
1331 END end_date_cond_cons_lk;
1332
1333 END ZX_MIGR_AR_TAX_GROUP_LOOKUPS;