301: IF cr.transaction_type ='CREATE' AND cr.revision_id IS NOT NULL THEN
302: /* Bug 7513461*/
303: BEGIN
304: SELECT MTL_ITEM_REVISIONS_B_S.CURRVAL
305: INTO l_revision_id FROM DUAL;
306: EXCEPTION
307: WHEN currval_not_def THEN
308: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL
309: INTO l_revision_id FROM DUAL;
305: INTO l_revision_id FROM DUAL;
306: EXCEPTION
307: WHEN currval_not_def THEN
308: SELECT MTL_ITEM_REVISIONS_B_S.NEXTVAL
309: INTO l_revision_id FROM DUAL;
310: WHEN OTHERS THEN
311: l_revision_id := cr.revision_id - 1;
312: END;
313: