1295: comment this out - the nextval should be retrieved only if
1296: the upload process is allowed to create a NEW or PREVIEWED
1297: revaluation. Move it to after the Preview/New exists exception
1298: check
1299: Select igi_iac_revaluations_s.NEXTVAL
1300: Into l_reval_id
1301: From dual;
1302:
1303: bug 3443419, end 3 */
1315: RAISE e_preview_exists;
1316: END IF;
1317: CLOSE c_preview_exists;
1318:
1319: Select igi_iac_revaluations_s.NEXTVAL
1320: Into l_reval_id
1321: From dual;
1322: -- mh end 4
1323: