160: arp_util_tax.debug('ZX_UPDATE_LOOKUPS (+) ' );
161:
162: IF P_UPGRADE_MODE = 'PRE-UPGRADE' THEN
163:
164: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to System' );
165:
166: UPDATE fnd_lookup_types
167: SET customization_level = 'S'
168: WHERE lookup_type in
162: IF P_UPGRADE_MODE = 'PRE-UPGRADE' THEN
163:
164: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to System' );
165:
166: UPDATE fnd_lookup_types
167: SET customization_level = 'S'
168: WHERE lookup_type in
169: ('JLCL_AP_DOCUMENT_TYPE',
170: 'JGZZ_STATISTICAL_CODE',
176: );
177:
178: ELSE
179:
180: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to Extensible..' );
181:
182: UPDATE fnd_lookup_types
183: SET customization_level = 'U'
184: WHERE lookup_type in
178: ELSE
179:
180: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to Extensible..' );
181:
182: UPDATE fnd_lookup_types
183: SET customization_level = 'U'
184: WHERE lookup_type in
185: ('JLCL_AP_DOCUMENT_TYPE',
186: 'JGZZ_STATISTICAL_CODE',
188: -- Tax Def Lookups
189: 'JLCL_TAX_CODE_CLASS'
190: );
191:
192: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to user..' );
193:
194: UPDATE fnd_lookup_types
195: SET customization_level = 'E'
196: WHERE lookup_type in
190: );
191:
192: arp_util_tax.debug(' Updating fnd_lookup_types setting the customization level to user..' );
193:
194: UPDATE fnd_lookup_types
195: SET customization_level = 'E'
196: WHERE lookup_type in
197: ('JATW_DEDUCTIBLE_TYPE',
198: 'JATW_GUI_TYPE',