APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_FAN_SEQ
Line 8224: SELECT 'OKL'||OKL_FAN_SEQ.NEXTVAL
8220: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
8221:
8222: -- cursor to get sequence number for asset number
8223: CURSOR c_asset_no IS 8224: SELECT 'OKL'||OKL_FAN_SEQ.NEXTVAL 8225: FROM dual;
8226:
8227: -- cursor to get check the existence of asset number
8228: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)