DBA Data[Home] [Help]

APPS.INVPVALI dependencies on DUAL

Line 305: INTO l_revision_id FROM DUAL;

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;

Line 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: