APPS.OKL_COPY_CONTRACT_PVT dependencies on OKX_ASSET_LINES_V

Line 8323: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS

8319: WHERE EXISTS (SELECT '1'
8320: FROM OKL_TXL_ASSETS_B
8321: WHERE asset_number = p_asset_number);
8322:
8323: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8324: SELECT 1
8325: FROM DUAL
8326: WHERE EXISTS (SELECT '1'
8327: FROM OKX_ASSET_LINES_V

Line 8327: FROM OKX_ASSET_LINES_V

8323: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8324: SELECT 1
8325: FROM DUAL
8326: WHERE EXISTS (SELECT '1'
8327: FROM OKX_ASSET_LINES_V
8328: WHERE asset_number = p_asset_number);
8329:
8330: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) IS
8331: SELECT 1

Line 8361: OPEN c_okx_asset_lines_v(lv_asset_number);

8357: ln_dummy1 := 0;
8358: END IF;
8359: CLOSE c_txl_asset_number;
8360:
8361: OPEN c_okx_asset_lines_v(lv_asset_number);
8362: FETCH c_okx_asset_lines_v INTO ln_dummy2;
8363: IF c_okx_asset_lines_v%NOTFOUND THEN
8364: ln_dummy2 := 0;
8365: END IF;

Line 8362: FETCH c_okx_asset_lines_v INTO ln_dummy2;

8358: END IF;
8359: CLOSE c_txl_asset_number;
8360:
8361: OPEN c_okx_asset_lines_v(lv_asset_number);
8362: FETCH c_okx_asset_lines_v INTO ln_dummy2;
8363: IF c_okx_asset_lines_v%NOTFOUND THEN
8364: ln_dummy2 := 0;
8365: END IF;
8366: CLOSE c_okx_asset_lines_v;

Line 8363: IF c_okx_asset_lines_v%NOTFOUND THEN

8359: CLOSE c_txl_asset_number;
8360:
8361: OPEN c_okx_asset_lines_v(lv_asset_number);
8362: FETCH c_okx_asset_lines_v INTO ln_dummy2;
8363: IF c_okx_asset_lines_v%NOTFOUND THEN
8364: ln_dummy2 := 0;
8365: END IF;
8366: CLOSE c_okx_asset_lines_v;
8367:

Line 8366: CLOSE c_okx_asset_lines_v;

8362: FETCH c_okx_asset_lines_v INTO ln_dummy2;
8363: IF c_okx_asset_lines_v%NOTFOUND THEN
8364: ln_dummy2 := 0;
8365: END IF;
8366: CLOSE c_okx_asset_lines_v;
8367:
8368: OPEN c_okx_assets_v(lv_asset_number);
8369: FETCH c_okx_assets_v INTO ln_dummy3;
8370: IF c_okx_assets_v%NOTFOUND THEN

Line 8404: IF c_okx_asset_lines_v%ISOPEN THEN

8400: END IF;
8401: IF c_txl_asset_number%ISOPEN THEN
8402: CLOSE c_txl_asset_number;
8403: END IF;
8404: IF c_okx_asset_lines_v%ISOPEN THEN
8405: CLOSE c_okx_asset_lines_v;
8406: END IF;
8407: IF c_okx_assets_v%ISOPEN THEN
8408: CLOSE c_okx_assets_v;

Line 8405: CLOSE c_okx_asset_lines_v;

8401: IF c_txl_asset_number%ISOPEN THEN
8402: CLOSE c_txl_asset_number;
8403: END IF;
8404: IF c_okx_asset_lines_v%ISOPEN THEN
8405: CLOSE c_okx_asset_lines_v;
8406: END IF;
8407: IF c_okx_assets_v%ISOPEN THEN
8408: CLOSE c_okx_assets_v;
8409: END IF;