8232: WHERE EXISTS (SELECT '1'
8233: FROM OKL_TXL_ASSETS_B
8234: WHERE asset_number = p_asset_number);
8235:
8236: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8237: SELECT 1
8238: FROM DUAL
8239: WHERE EXISTS (SELECT '1'
8240: FROM OKX_ASSET_LINES_V
8236: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8237: SELECT 1
8238: FROM DUAL
8239: WHERE EXISTS (SELECT '1'
8240: FROM OKX_ASSET_LINES_V
8241: WHERE asset_number = p_asset_number);
8242:
8243: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8244: SELECT 1
8270: ln_dummy1 := 0;
8271: END IF;
8272: CLOSE c_txl_asset_number;
8273:
8274: OPEN c_okx_asset_lines_v(lv_asset_number);
8275: FETCH c_okx_asset_lines_v INTO ln_dummy2;
8276: IF c_okx_asset_lines_v%NOTFOUND THEN
8277: ln_dummy2 := 0;
8278: END IF;
8271: END IF;
8272: CLOSE c_txl_asset_number;
8273:
8274: OPEN c_okx_asset_lines_v(lv_asset_number);
8275: FETCH c_okx_asset_lines_v INTO ln_dummy2;
8276: IF c_okx_asset_lines_v%NOTFOUND THEN
8277: ln_dummy2 := 0;
8278: END IF;
8279: CLOSE c_okx_asset_lines_v;
8272: CLOSE c_txl_asset_number;
8273:
8274: OPEN c_okx_asset_lines_v(lv_asset_number);
8275: FETCH c_okx_asset_lines_v INTO ln_dummy2;
8276: IF c_okx_asset_lines_v%NOTFOUND THEN
8277: ln_dummy2 := 0;
8278: END IF;
8279: CLOSE c_okx_asset_lines_v;
8280:
8275: FETCH c_okx_asset_lines_v INTO ln_dummy2;
8276: IF c_okx_asset_lines_v%NOTFOUND THEN
8277: ln_dummy2 := 0;
8278: END IF;
8279: CLOSE c_okx_asset_lines_v;
8280:
8281: OPEN c_okx_assets_v(lv_asset_number);
8282: FETCH c_okx_assets_v INTO ln_dummy3;
8283: IF c_okx_assets_v%NOTFOUND THEN
8313: END IF;
8314: IF c_txl_asset_number%ISOPEN THEN
8315: CLOSE c_txl_asset_number;
8316: END IF;
8317: IF c_okx_asset_lines_v%ISOPEN THEN
8318: CLOSE c_okx_asset_lines_v;
8319: END IF;
8320: IF c_okx_assets_v%ISOPEN THEN
8321: CLOSE c_okx_assets_v;
8314: IF c_txl_asset_number%ISOPEN THEN
8315: CLOSE c_txl_asset_number;
8316: END IF;
8317: IF c_okx_asset_lines_v%ISOPEN THEN
8318: CLOSE c_okx_asset_lines_v;
8319: END IF;
8320: IF c_okx_assets_v%ISOPEN THEN
8321: CLOSE c_okx_assets_v;
8322: END IF;