Line 25: select UMX_REG_REQUESTS_S.nextval into X_REG_REQUEST_ID from dual;
21:
22: BEGIN
23:
24: if (X_REG_REQUEST_ID is null) then 25: select UMX_REG_REQUESTS_S.nextval into X_REG_REQUEST_ID from dual; 26: end if;
27:
28: -- do we need to raise a no data found exception??
29: