DBA Data[Home] [Help]

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)