423: l_rev_seq NUMBER := NULL;
424: l_new_item_key VARCHAR2(240) := NULL;
425: BEGIN
426:
427: -- Generate Item Key from ENG_WORKFLOW_REVISION_S.NEXTVAL
428: -- and return the value
429: SELECT ENG_WORKFLOW_REVISION_S.NEXTVAL
430: INTO l_rev_seq
431: FROM DUAL;
425: BEGIN
426:
427: -- Generate Item Key from ENG_WORKFLOW_REVISION_S.NEXTVAL
428: -- and return the value
429: SELECT ENG_WORKFLOW_REVISION_S.NEXTVAL
430: INTO l_rev_seq
431: FROM DUAL;
432:
433: l_new_item_key := TO_CHAR(l_rev_seq) ;