APPS.OKL_COPY_ASSET_PVT dependencies on OKX_ASSET_LINES_V

Line 213: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

209: WHERE EXISTS (SELECT '1'
210: FROM OKL_TXL_ASSETS_B
211: WHERE asset_number = p_asset_number);
212:
213: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
214: SELECT 1
215: FROM DUAL
216: WHERE EXISTS (SELECT '1'
217: FROM OKX_ASSET_LINES_V

Line 217: FROM OKX_ASSET_LINES_V

213: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
214: SELECT 1
215: FROM DUAL
216: WHERE EXISTS (SELECT '1'
217: FROM OKX_ASSET_LINES_V
218: WHERE asset_number = p_asset_number);
219:
220: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
221: SELECT 1

Line 251: OPEN c_okx_asset_lines_v(lv_asset_number);

247: ln_dummy1 := 0;
248: END IF;
249: CLOSE c_txl_asset_number;
250:
251: OPEN c_okx_asset_lines_v(lv_asset_number);
252: FETCH c_okx_asset_lines_v INTO ln_dummy2;
253: IF c_okx_asset_lines_v%NOTFOUND THEN
254: ln_dummy2 := 0;
255: END IF;

Line 252: FETCH c_okx_asset_lines_v INTO ln_dummy2;

248: END IF;
249: CLOSE c_txl_asset_number;
250:
251: OPEN c_okx_asset_lines_v(lv_asset_number);
252: FETCH c_okx_asset_lines_v INTO ln_dummy2;
253: IF c_okx_asset_lines_v%NOTFOUND THEN
254: ln_dummy2 := 0;
255: END IF;
256: CLOSE c_okx_asset_lines_v;

Line 253: IF c_okx_asset_lines_v%NOTFOUND THEN

249: CLOSE c_txl_asset_number;
250:
251: OPEN c_okx_asset_lines_v(lv_asset_number);
252: FETCH c_okx_asset_lines_v INTO ln_dummy2;
253: IF c_okx_asset_lines_v%NOTFOUND THEN
254: ln_dummy2 := 0;
255: END IF;
256: CLOSE c_okx_asset_lines_v;
257:

Line 256: CLOSE c_okx_asset_lines_v;

252: FETCH c_okx_asset_lines_v INTO ln_dummy2;
253: IF c_okx_asset_lines_v%NOTFOUND THEN
254: ln_dummy2 := 0;
255: END IF;
256: CLOSE c_okx_asset_lines_v;
257:
258: OPEN c_okx_assets_v(lv_asset_number);
259: FETCH c_okx_assets_v INTO ln_dummy3;
260: IF c_okx_assets_v%NOTFOUND THEN

Line 294: IF c_okx_asset_lines_v%ISOPEN THEN

290: END IF;
291: IF c_txl_asset_number%ISOPEN THEN
292: CLOSE c_txl_asset_number;
293: END IF;
294: IF c_okx_asset_lines_v%ISOPEN THEN
295: CLOSE c_okx_asset_lines_v;
296: END IF;
297: IF c_okx_assets_v%ISOPEN THEN
298: CLOSE c_okx_assets_v;

Line 295: CLOSE c_okx_asset_lines_v;

291: IF c_txl_asset_number%ISOPEN THEN
292: CLOSE c_txl_asset_number;
293: END IF;
294: IF c_okx_asset_lines_v%ISOPEN THEN
295: CLOSE c_okx_asset_lines_v;
296: END IF;
297: IF c_okx_assets_v%ISOPEN THEN
298: CLOSE c_okx_assets_v;
299: END IF;