DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on OKL_IBN_SEQ

Line 165: select TO_CHAR(OKL_IBN_SEQ.NEXTVAL)

161: RETURN VARCHAR2 IS
162: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
163: -- cursor to get sequence number for asset number
164: Cursor c_instance_no_ib IS
165: select TO_CHAR(OKL_IBN_SEQ.NEXTVAL)
166: FROM dual;
167: BEGIN
168: OPEN c_instance_no_ib;
169: FETCH c_instance_no_ib INTO x_instance_number_ib;