APPS.OKL_COPY_ASSET_PVT dependencies on OKX_ASSETS_V

Line 198: lv_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE;

194: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
195: ln_dummy1 NUMBER := 0;
196: ln_dummy2 NUMBER := 0;
197: ln_dummy3 NUMBER := 0;
198: lv_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE;
199: -- cursor to get sequence number for asset number
200: Cursor c_asset_no IS
201: select 'OKL'||OKL_FAN_SEQ.NEXTVAL
202: FROM dual;

Line 205: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)

201: select 'OKL'||OKL_FAN_SEQ.NEXTVAL
202: FROM dual;
203:
204: -- cursor to get check the existence of asset number
205: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE)
206: IS
207: SELECT 1
208: FROM DUAL
209: WHERE EXISTS (SELECT '1'

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 220: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

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
222: FROM DUAL
223: WHERE EXISTS (SELECT '1'
224: FROM OKX_ASSETS_V

Line 224: FROM OKX_ASSETS_V

220: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
221: SELECT 1
222: FROM DUAL
223: WHERE EXISTS (SELECT '1'
224: FROM OKX_ASSETS_V
225: WHERE asset_number = p_asset_number);
226:
227: BEGIN
228: OPEN c_asset_no;

Line 258: OPEN c_okx_assets_v(lv_asset_number);

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
261: ln_dummy3 := 0;
262: END IF;

Line 259: FETCH c_okx_assets_v INTO ln_dummy3;

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
261: ln_dummy3 := 0;
262: END IF;
263: CLOSE c_okx_assets_v;

Line 260: IF c_okx_assets_v%NOTFOUND THEN

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
261: ln_dummy3 := 0;
262: END IF;
263: CLOSE c_okx_assets_v;
264:

Line 263: CLOSE c_okx_assets_v;

259: FETCH c_okx_assets_v INTO ln_dummy3;
260: IF c_okx_assets_v%NOTFOUND THEN
261: ln_dummy3 := 0;
262: END IF;
263: CLOSE c_okx_assets_v;
264:
265: IF ln_dummy1 = 1 OR
266: ln_dummy2 = 1 OR
267: ln_dummy3 = 1 THEN

Line 297: IF c_okx_assets_v%ISOPEN THEN

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;
300: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
301: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

Line 298: CLOSE c_okx_assets_v;

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;
300: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
301: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
302: p_msg_name => g_unexpected_error,

Line 4150: FROM OKX_ASSETS_V

4146:
4147: CURSOR c_asset_info(p_object1_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE,
4148: p_object1_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE) IS
4149: SELECT *
4150: FROM OKX_ASSETS_V
4151: WHERE id1 = p_object1_id1
4152: AND id2 = p_object1_id2;
4153:
4154: CURSOR c_asset_loc_info(p_asset_id OKX_AST_DST_HST_V.ASSET_ID%TYPE) IS