eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CREATE_KLE_PVT dependencies on OKX_ASSET_LINES_V

Line 217: /*CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

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

Line 221: FROM OKX_ASSET_LINES_V

217: /*CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
218: SELECT 1
219: --FROM DUAL
220: --WHERE EXISTS (SELECT '1'
221: FROM OKX_ASSET_LINES_V
222: WHERE asset_number = p_asset_number; --); */
223:
224: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
225: SELECT 1

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

220: --WHERE EXISTS (SELECT '1'
221: FROM OKX_ASSET_LINES_V
222: WHERE asset_number = p_asset_number; --); */
223:
224: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
225: SELECT 1
226: FROM fa_additions a
227: WHERE a.asset_number = p_asset_number
228: and exists

Line 267: OPEN c_okx_asset_lines_v(lv_asset_number);

263: ln_dummy1 := 0;
264: END IF;
265: CLOSE c_txl_asset_number;
266:
267: OPEN c_okx_asset_lines_v(lv_asset_number);
268: FETCH c_okx_asset_lines_v INTO ln_dummy2;
269: IF c_okx_asset_lines_v%NOTFOUND THEN
270: ln_dummy2 := 0;
271: END IF;

Line 268: FETCH c_okx_asset_lines_v INTO ln_dummy2;

264: END IF;
265: CLOSE c_txl_asset_number;
266:
267: OPEN c_okx_asset_lines_v(lv_asset_number);
268: FETCH c_okx_asset_lines_v INTO ln_dummy2;
269: IF c_okx_asset_lines_v%NOTFOUND THEN
270: ln_dummy2 := 0;
271: END IF;
272: CLOSE c_okx_asset_lines_v;

Line 269: IF c_okx_asset_lines_v%NOTFOUND THEN

265: CLOSE c_txl_asset_number;
266:
267: OPEN c_okx_asset_lines_v(lv_asset_number);
268: FETCH c_okx_asset_lines_v INTO ln_dummy2;
269: IF c_okx_asset_lines_v%NOTFOUND THEN
270: ln_dummy2 := 0;
271: END IF;
272: CLOSE c_okx_asset_lines_v;
273:

Line 272: CLOSE c_okx_asset_lines_v;

268: FETCH c_okx_asset_lines_v INTO ln_dummy2;
269: IF c_okx_asset_lines_v%NOTFOUND THEN
270: ln_dummy2 := 0;
271: END IF;
272: CLOSE c_okx_asset_lines_v;
273:
274: OPEN c_okx_assets_v(lv_asset_number);
275: FETCH c_okx_assets_v INTO ln_dummy3;
276: IF c_okx_assets_v%NOTFOUND THEN

Line 310: IF c_okx_asset_lines_v%ISOPEN THEN

306: END IF;
307: IF c_txl_asset_number%ISOPEN THEN
308: CLOSE c_txl_asset_number;
309: END IF;
310: IF c_okx_asset_lines_v%ISOPEN THEN
311: CLOSE c_okx_asset_lines_v;
312: END IF;
313: IF c_okx_assets_v%ISOPEN THEN
314: CLOSE c_okx_assets_v;

Line 311: CLOSE c_okx_asset_lines_v;

307: IF c_txl_asset_number%ISOPEN THEN
308: CLOSE c_txl_asset_number;
309: END IF;
310: IF c_okx_asset_lines_v%ISOPEN THEN
311: CLOSE c_okx_asset_lines_v;
312: END IF;
313: IF c_okx_assets_v%ISOPEN THEN
314: CLOSE c_okx_assets_v;
315: END IF;

Line 2495: ln_okx_asset_lines_v NUMBER := 0;

2491: p_kle_Id IN OKL_TXL_ASSETS_V.KLE_ID%TYPE,
2492: p_dnz_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
2493: ln_okl_txl_assets_v NUMBER := 0;
2494: ln_okx_assets_v NUMBER := 0;
2495: ln_okx_asset_lines_v NUMBER := 0;
2496: ln_okl_txd_assets_v NUMBER := 0;
2497: lv_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2498: lv_asset_source_code OKC_K_LINES_B.ORIG_SYSTEM_SOURCE_CODE%TYPE;
2499: lv_asset_number OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE;

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

2519: FROM OKL_TXL_ASSETS_B
2520: WHERE asset_number = p_asset_number
2521: AND kle_id <> p_kle_id; --);
2522:
2523: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2524: SELECT 1
2525: --FROM DUAL
2526: --WHERE EXISTS (SELECT '1'
2527: FROM OKX_ASSET_LINES_V

Line 2527: FROM OKX_ASSET_LINES_V

2523: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2524: SELECT 1
2525: --FROM DUAL
2526: --WHERE EXISTS (SELECT '1'
2527: FROM OKX_ASSET_LINES_V
2528: WHERE asset_number = p_asset_number; --);
2529:
2530: CURSOR c_okx_assets_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2531: SELECT 1

Line 2678: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V

2674: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2675: END IF;
2676: CLOSE c_okx_assets_v;
2677:
2678: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2679: OPEN c_okx_asset_lines_v(p_asset_number);
2680: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2681: IF c_okx_asset_lines_v%NOTFOUND THEN
2682: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2679: OPEN c_okx_asset_lines_v(p_asset_number);

2675: END IF;
2676: CLOSE c_okx_assets_v;
2677:
2678: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2679: OPEN c_okx_asset_lines_v(p_asset_number);
2680: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2681: IF c_okx_asset_lines_v%NOTFOUND THEN
2682: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2683: END IF;

Line 2680: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;

2676: CLOSE c_okx_assets_v;
2677:
2678: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2679: OPEN c_okx_asset_lines_v(p_asset_number);
2680: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2681: IF c_okx_asset_lines_v%NOTFOUND THEN
2682: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2683: END IF;
2684: CLOSE c_okx_asset_lines_v;

Line 2681: IF c_okx_asset_lines_v%NOTFOUND THEN

2677:
2678: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2679: OPEN c_okx_asset_lines_v(p_asset_number);
2680: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2681: IF c_okx_asset_lines_v%NOTFOUND THEN
2682: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2683: END IF;
2684: CLOSE c_okx_asset_lines_v;
2685:

Line 2684: CLOSE c_okx_asset_lines_v;

2680: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2681: IF c_okx_asset_lines_v%NOTFOUND THEN
2682: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2683: END IF;
2684: CLOSE c_okx_asset_lines_v;
2685:
2686: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V
2687: -- for Split Asset scenario.
2688: OPEN c_txd_assets_v(p_asset_number);

Line 2714: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V

2710: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2711: END IF;
2712: CLOSE c_okx_assets_v;
2713:
2714: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2715: OPEN c_okx_asset_lines_v(p_asset_number);
2716: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2717: IF c_okx_asset_lines_v%NOTFOUND THEN
2718: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2715: OPEN c_okx_asset_lines_v(p_asset_number);

2711: END IF;
2712: CLOSE c_okx_assets_v;
2713:
2714: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2715: OPEN c_okx_asset_lines_v(p_asset_number);
2716: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2717: IF c_okx_asset_lines_v%NOTFOUND THEN
2718: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2719: END IF;

Line 2716: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;

2712: CLOSE c_okx_assets_v;
2713:
2714: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2715: OPEN c_okx_asset_lines_v(p_asset_number);
2716: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2717: IF c_okx_asset_lines_v%NOTFOUND THEN
2718: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2719: END IF;
2720: CLOSE c_okx_asset_lines_v;

Line 2717: IF c_okx_asset_lines_v%NOTFOUND THEN

2713:
2714: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2715: OPEN c_okx_asset_lines_v(p_asset_number);
2716: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2717: IF c_okx_asset_lines_v%NOTFOUND THEN
2718: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2719: END IF;
2720: CLOSE c_okx_asset_lines_v;
2721:

Line 2720: CLOSE c_okx_asset_lines_v;

2716: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2717: IF c_okx_asset_lines_v%NOTFOUND THEN
2718: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2719: END IF;
2720: CLOSE c_okx_asset_lines_v;
2721:
2722: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V
2723: -- for Split Asset scenario.
2724: OPEN c_txd_assets_v(p_asset_number);

Line 2751: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V

2747: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2748: END IF;
2749: CLOSE c_okx_assets_v;
2750:
2751: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2752: OPEN c_okx_asset_lines_v(p_asset_number);
2753: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2754: IF c_okx_asset_lines_v%NOTFOUND THEN
2755: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2752: OPEN c_okx_asset_lines_v(p_asset_number);

2748: END IF;
2749: CLOSE c_okx_assets_v;
2750:
2751: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2752: OPEN c_okx_asset_lines_v(p_asset_number);
2753: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2754: IF c_okx_asset_lines_v%NOTFOUND THEN
2755: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2756: END IF;

Line 2753: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;

2749: CLOSE c_okx_assets_v;
2750:
2751: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2752: OPEN c_okx_asset_lines_v(p_asset_number);
2753: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2754: IF c_okx_asset_lines_v%NOTFOUND THEN
2755: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2756: END IF;
2757: CLOSE c_okx_asset_lines_v;

Line 2754: IF c_okx_asset_lines_v%NOTFOUND THEN

2750:
2751: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2752: OPEN c_okx_asset_lines_v(p_asset_number);
2753: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2754: IF c_okx_asset_lines_v%NOTFOUND THEN
2755: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2756: END IF;
2757: CLOSE c_okx_asset_lines_v;
2758:

Line 2757: CLOSE c_okx_asset_lines_v;

2753: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2754: IF c_okx_asset_lines_v%NOTFOUND THEN
2755: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2756: END IF;
2757: CLOSE c_okx_asset_lines_v;
2758:
2759: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V
2760: -- for Split Asset scenario.
2761: OPEN c_txd_assets_v(p_asset_number);

Line 2770: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN

2766: CLOSE c_txd_assets_v;
2767: END IF;
2768:
2769: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR
2770: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN
2771: -- store SQL error message on message stack
2772: OKL_API.set_message(p_app_name => G_APP_NAME,
2773: p_msg_name => G_ASSET_NUMBER);
2774: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 2776: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN

2772: OKL_API.set_message(p_app_name => G_APP_NAME,
2773: p_msg_name => G_ASSET_NUMBER);
2774: RAISE G_EXCEPTION_HALT_VALIDATION;
2775: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND
2776: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN
2777: -- store SQL error message on message stack
2778: OKL_API.set_message(p_app_name => G_APP_NAME,
2779: p_msg_name => G_ASSET_NUMBER);
2780: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 2799: IF c_okx_asset_lines_v%ISOPEN THEN

2795: END IF;
2796: IF c_okx_assets_v%ISOPEN THEN
2797: CLOSE c_okx_assets_v;
2798: END IF;
2799: IF c_okx_asset_lines_v%ISOPEN THEN
2800: CLOSE c_okx_asset_lines_v;
2801: END IF;
2802: IF c_check_release_asset%ISOPEN THEN
2803: CLOSE c_check_release_asset;

Line 2800: CLOSE c_okx_asset_lines_v;

2796: IF c_okx_assets_v%ISOPEN THEN
2797: CLOSE c_okx_assets_v;
2798: END IF;
2799: IF c_okx_asset_lines_v%ISOPEN THEN
2800: CLOSE c_okx_asset_lines_v;
2801: END IF;
2802: IF c_check_release_asset%ISOPEN THEN
2803: CLOSE c_check_release_asset;
2804: END IF;

Line 2819: IF c_okx_asset_lines_v%ISOPEN THEN

2815: END IF;
2816: IF c_okx_assets_v%ISOPEN THEN
2817: CLOSE c_okx_assets_v;
2818: END IF;
2819: IF c_okx_asset_lines_v%ISOPEN THEN
2820: CLOSE c_okx_asset_lines_v;
2821: END IF;
2822: IF c_check_release_asset%ISOPEN THEN
2823: CLOSE c_check_release_asset;

Line 2820: CLOSE c_okx_asset_lines_v;

2816: IF c_okx_assets_v%ISOPEN THEN
2817: CLOSE c_okx_assets_v;
2818: END IF;
2819: IF c_okx_asset_lines_v%ISOPEN THEN
2820: CLOSE c_okx_asset_lines_v;
2821: END IF;
2822: IF c_check_release_asset%ISOPEN THEN
2823: CLOSE c_check_release_asset;
2824: END IF;

Line 2846: IF c_okx_asset_lines_v%ISOPEN THEN

2842: END IF;
2843: IF c_okx_assets_v%ISOPEN THEN
2844: CLOSE c_okx_assets_v;
2845: END IF;
2846: IF c_okx_asset_lines_v%ISOPEN THEN
2847: CLOSE c_okx_asset_lines_v;
2848: END IF;
2849: IF c_check_release_asset%ISOPEN THEN
2850: CLOSE c_check_release_asset;

Line 2847: CLOSE c_okx_asset_lines_v;

2843: IF c_okx_assets_v%ISOPEN THEN
2844: CLOSE c_okx_assets_v;
2845: END IF;
2846: IF c_okx_asset_lines_v%ISOPEN THEN
2847: CLOSE c_okx_asset_lines_v;
2848: END IF;
2849: IF c_check_release_asset%ISOPEN THEN
2850: CLOSE c_check_release_asset;
2851: END IF;

Line 2871: ln_okx_asset_lines_v NUMBER := 0;

2867: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2868: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
2869: ln_okl_txl_assets_v NUMBER := 0;
2870: ln_okx_assets_v NUMBER := 0;
2871: ln_okx_asset_lines_v NUMBER := 0;
2872: ln_okl_txd_assets_v NUMBER := 0;
2873: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';
2874:
2875: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

Line 2881: /*CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

2877: --FROM DUAL
2878: --WHERE EXISTS (SELECT '1'
2879: FROM OKL_TXL_ASSETS_B
2880: WHERE asset_number = p_asset_number; --);
2881: /*CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2882: SELECT 1
2883: --FROM DUAL
2884: --WHERE EXISTS (SELECT '1'
2885: FROM OKX_ASSET_LINES_V

Line 2885: FROM OKX_ASSET_LINES_V

2881: /*CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2882: SELECT 1
2883: --FROM DUAL
2884: --WHERE EXISTS (SELECT '1'
2885: FROM OKX_ASSET_LINES_V
2886: WHERE asset_number = p_asset_number; --); */
2887: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2888: SELECT 1
2889: FROM fa_additions a

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

2883: --FROM DUAL
2884: --WHERE EXISTS (SELECT '1'
2885: FROM OKX_ASSET_LINES_V
2886: WHERE asset_number = p_asset_number; --); */
2887: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2888: SELECT 1
2889: FROM fa_additions a
2890: WHERE a.asset_number = p_asset_number
2891: and exists

Line 3002: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V

2998: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2999: END IF;
3000: CLOSE c_okx_assets_v;
3001:
3002: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
3003: OPEN c_okx_asset_lines_v(p_asset_number);
3004: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
3005: IF c_okx_asset_lines_v%NOTFOUND THEN
3006: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 3003: OPEN c_okx_asset_lines_v(p_asset_number);

2999: END IF;
3000: CLOSE c_okx_assets_v;
3001:
3002: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
3003: OPEN c_okx_asset_lines_v(p_asset_number);
3004: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
3005: IF c_okx_asset_lines_v%NOTFOUND THEN
3006: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3007: END IF;

Line 3004: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;

3000: CLOSE c_okx_assets_v;
3001:
3002: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
3003: OPEN c_okx_asset_lines_v(p_asset_number);
3004: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
3005: IF c_okx_asset_lines_v%NOTFOUND THEN
3006: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3007: END IF;
3008: CLOSE c_okx_asset_lines_v;

Line 3005: IF c_okx_asset_lines_v%NOTFOUND THEN

3001:
3002: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
3003: OPEN c_okx_asset_lines_v(p_asset_number);
3004: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
3005: IF c_okx_asset_lines_v%NOTFOUND THEN
3006: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3007: END IF;
3008: CLOSE c_okx_asset_lines_v;
3009:

Line 3008: CLOSE c_okx_asset_lines_v;

3004: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
3005: IF c_okx_asset_lines_v%NOTFOUND THEN
3006: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3007: END IF;
3008: CLOSE c_okx_asset_lines_v;
3009:
3010: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V
3011: -- for Split Asset scenario.
3012: OPEN c_txd_assets_v(p_asset_number);

Line 3020: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN

3016: END IF;
3017: CLOSE c_txd_assets_v;
3018:
3019: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR
3020: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN
3021: -- store SQL error message on message stack
3022: OKL_API.set_message(p_app_name => G_APP_NAME,
3023: p_msg_name => G_ASSET_NUMBER);
3024: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 3026: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN

3022: OKL_API.set_message(p_app_name => G_APP_NAME,
3023: p_msg_name => G_ASSET_NUMBER);
3024: RAISE G_EXCEPTION_HALT_VALIDATION;
3025: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND
3026: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN
3027: -- store SQL error message on message stack
3028: OKL_API.set_message(p_app_name => G_APP_NAME,
3029: p_msg_name => G_ASSET_NUMBER);
3030: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 3047: IF c_okx_asset_lines_v%ISOPEN THEN

3043: END IF;
3044: IF c_okx_assets_v%ISOPEN THEN
3045: CLOSE c_okx_assets_v;
3046: END IF;
3047: IF c_okx_asset_lines_v%ISOPEN THEN
3048: CLOSE c_okx_asset_lines_v;
3049: END IF;
3050: IF c_txd_assets_v%ISOPEN THEN
3051: CLOSE c_txd_assets_v;

Line 3048: CLOSE c_okx_asset_lines_v;

3044: IF c_okx_assets_v%ISOPEN THEN
3045: CLOSE c_okx_assets_v;
3046: END IF;
3047: IF c_okx_asset_lines_v%ISOPEN THEN
3048: CLOSE c_okx_asset_lines_v;
3049: END IF;
3050: IF c_txd_assets_v%ISOPEN THEN
3051: CLOSE c_txd_assets_v;
3052: END IF;

Line 3074: IF c_okx_asset_lines_v%ISOPEN THEN

3070: END IF;
3071: IF c_okx_assets_v%ISOPEN THEN
3072: CLOSE c_okx_assets_v;
3073: END IF;
3074: IF c_okx_asset_lines_v%ISOPEN THEN
3075: CLOSE c_okx_asset_lines_v;
3076: END IF;
3077: IF c_txd_assets_v%ISOPEN THEN
3078: CLOSE c_txd_assets_v;

Line 3075: CLOSE c_okx_asset_lines_v;

3071: IF c_okx_assets_v%ISOPEN THEN
3072: CLOSE c_okx_assets_v;
3073: END IF;
3074: IF c_okx_asset_lines_v%ISOPEN THEN
3075: CLOSE c_okx_asset_lines_v;
3076: END IF;
3077: IF c_txd_assets_v%ISOPEN THEN
3078: CLOSE c_txd_assets_v;
3079: END IF;

Line 3133: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V

3129: -- halt validation as it is a required field
3130: RAISE G_EXCEPTION_STOP_VALIDATION;
3131: END IF;
3132: -- Enforce validation
3133: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
3134: OPEN c_asset_lines_dtls_v(p_asset_number => p_asset_number,
3135: p_tax_book => p_tax_book,
3136: p_tal_id => p_tal_id);
3137: FETCH c_asset_lines_dtls_v into ln_asset_lines_dtls;

Line 5946: FROM OKX_ASSET_LINES_V

5942: IS
5943: SELECT 1
5944: --FROM DUAL
5945: --WHERE EXISTS (SELECT '1'
5946: FROM OKX_ASSET_LINES_V
5947: WHERE id1 = p_id1
5948: AND id2 = p_id2
5949: AND dnz_chr_id <> p_dnz_chr_id
5950: AND line_status NOT IN ('EXPRIED','TERMINATED','ABANDONED'); --);