eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_COPY_ASSET_PVT dependencies on OKL_FAN_SEQ

Line 161: select p_old_asset_number||'_'||OKL_FAN_SEQ.NEXTVAL

157: RETURN VARCHAR2 IS
158: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
159: -- cursor to get sequence number for asset number
160: Cursor c_asset_no(p_old_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE) IS
161: select p_old_asset_number||'_'||OKL_FAN_SEQ.NEXTVAL
162: FROM dual;
163: BEGIN
164: OPEN c_asset_no(p_old_asset_number);
165: FETCH c_asset_no INTO x_asset_number;

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

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