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