Line 121: SELECT SYSDATE INTO l_sysdate FROM dual;
117: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
118: RAISE OKL_API.G_EXCEPTION_ERROR;
119: END IF;
120: 121: SELECT SYSDATE INTO l_sysdate FROM dual; 122:
123: IF p_assets_tbl.COUNT > 0 THEN
124:
125: