506: /* For AP and AR LookupType */
507:
508: INSERT ALL
509: WHEN (NOT EXISTS
510: (SELECT 1 FROM FND_LOOKUP_TYPES
511: WHERE LOOKUP_TYPE = 'ZX_INPUT_CLASSIFICATIONS')
512: ) THEN
513: INTO FND_LOOKUP_TYPES
514: (
509: WHEN (NOT EXISTS
510: (SELECT 1 FROM FND_LOOKUP_TYPES
511: WHERE LOOKUP_TYPE = 'ZX_INPUT_CLASSIFICATIONS')
512: ) THEN
513: INTO FND_LOOKUP_TYPES
514: (
515: APPLICATION_ID ,
516: LOOKUP_TYPE ,
517: CUSTOMIZATION_LEVEL ,
536: fnd_global.user_id ,
537: fnd_global.conc_login_id
538: )
539: WHEN (NOT EXISTS
540: (SELECT 1 FROM FND_LOOKUP_TYPES
541: WHERE LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS')
542: ) THEN
543: INTO FND_LOOKUP_TYPES
544: (
539: WHEN (NOT EXISTS
540: (SELECT 1 FROM FND_LOOKUP_TYPES
541: WHERE LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS')
542: ) THEN
543: INTO FND_LOOKUP_TYPES
544: (
545: APPLICATION_ID ,
546: LOOKUP_TYPE ,
547: CUSTOMIZATION_LEVEL ,
566: fnd_global.user_id ,
567: fnd_global.conc_login_id
568: )
569: WHEN (NOT EXISTS
570: (SELECT 1 FROM FND_LOOKUP_TYPES
571: WHERE LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
572: ) THEN
573: INTO FND_LOOKUP_TYPES
574: (
569: WHEN (NOT EXISTS
570: (SELECT 1 FROM FND_LOOKUP_TYPES
571: WHERE LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
572: ) THEN
573: INTO FND_LOOKUP_TYPES
574: (
575: APPLICATION_ID ,
576: LOOKUP_TYPE ,
577: CUSTOMIZATION_LEVEL ,
598: )
599:
600: SELECT 1 FROM DUAL;
601:
602: INSERT INTO FND_LOOKUP_TYPES_TL
603: (
604: LOOKUP_TYPE,
605: SECURITY_GROUP_ID,
606: VIEW_APPLICATION_ID,
629: SYSDATE ,
630: fnd_global.user_id ,
631: SYSDATE ,
632: fnd_global.conc_login_id
633: FROM FND_LOOKUP_TYPES types,
634: FND_LANGUAGES L
635: WHERE L.INSTALLED_FLAG in ('I', 'B')
636: AND types.lookup_type in ('ZX_OUTPUT_CLASSIFICATIONS',
637: 'ZX_INPUT_CLASSIFICATIONS',
637: 'ZX_INPUT_CLASSIFICATIONS',
638: 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
639: AND not exists
640: (select null
641: from fnd_lookup_types_tl sub
642: where sub.lookup_type = types.lookup_type
643: and sub.security_group_id = 0
644: and sub.view_application_id = 0
645: and sub.language = l.language_code);