403: End if;
404:
405: else
406: -- select table_route_id into local variable.
407: select pqh_table_route_s.nextval into l_table_route_id from dual;
408:
409: INSERT_ROW (
410: X_ROWID => l_rowid,
411: X_TABLE_ROUTE_ID => l_table_route_id ,
447:
448: exception
449: when NO_DATA_FOUND then
450: -- select table_route_id into local variable.
451: select pqh_table_route_s.nextval into l_table_route_id from dual;
452:
453: INSERT_ROW (
454: X_ROWID => l_rowid,
455: X_TABLE_ROUTE_ID => l_table_route_id ,