DBA Data[Home] [Help]

APPS.OKL_CREATE_KLE_PVT dependencies on OKL_FAN_SEQ

Line 205: select 'OKL'||OKL_FAN_SEQ.NEXTVAL

201: ln_dummy3 NUMBER := 0;
202: lv_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE;
203: -- cursor to get sequence number for asset number
204: Cursor c_asset_no IS
205: select 'OKL'||OKL_FAN_SEQ.NEXTVAL
206: FROM dual;
207:
208: -- cursor to get check the existence of asset number
209: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)