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 2658: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V

2654: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2655: END IF;
2656: CLOSE c_okx_assets_v;
2657:
2658: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2659: OPEN c_okx_asset_lines_v(p_asset_number);
2660: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2661: IF c_okx_asset_lines_v%NOTFOUND THEN
2662: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2659: OPEN c_okx_asset_lines_v(p_asset_number);

2655: END IF;
2656: CLOSE c_okx_assets_v;
2657:
2658: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2659: OPEN c_okx_asset_lines_v(p_asset_number);
2660: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2661: IF c_okx_asset_lines_v%NOTFOUND THEN
2662: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2663: END IF;

Line 2660: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;

2656: CLOSE c_okx_assets_v;
2657:
2658: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2659: OPEN c_okx_asset_lines_v(p_asset_number);
2660: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2661: IF c_okx_asset_lines_v%NOTFOUND THEN
2662: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2663: END IF;
2664: CLOSE c_okx_asset_lines_v;

Line 2661: IF c_okx_asset_lines_v%NOTFOUND THEN

2657:
2658: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2659: OPEN c_okx_asset_lines_v(p_asset_number);
2660: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2661: IF c_okx_asset_lines_v%NOTFOUND THEN
2662: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2663: END IF;
2664: CLOSE c_okx_asset_lines_v;
2665:

Line 2664: CLOSE c_okx_asset_lines_v;

2660: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2661: IF c_okx_asset_lines_v%NOTFOUND THEN
2662: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2663: END IF;
2664: CLOSE c_okx_asset_lines_v;
2665:
2666: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V
2667: -- for Split Asset scenario.
2668: OPEN c_txd_assets_v(p_asset_number);

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

2690: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2691: END IF;
2692: CLOSE c_okx_assets_v;
2693:
2694: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2695: OPEN c_okx_asset_lines_v(p_asset_number);
2696: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2697: IF c_okx_asset_lines_v%NOTFOUND THEN
2698: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2695: OPEN c_okx_asset_lines_v(p_asset_number);

2691: END IF;
2692: CLOSE c_okx_assets_v;
2693:
2694: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2695: OPEN c_okx_asset_lines_v(p_asset_number);
2696: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2697: IF c_okx_asset_lines_v%NOTFOUND THEN
2698: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2699: END IF;

Line 2696: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;

2692: CLOSE c_okx_assets_v;
2693:
2694: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2695: OPEN c_okx_asset_lines_v(p_asset_number);
2696: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2697: IF c_okx_asset_lines_v%NOTFOUND THEN
2698: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2699: END IF;
2700: CLOSE c_okx_asset_lines_v;

Line 2697: IF c_okx_asset_lines_v%NOTFOUND THEN

2693:
2694: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2695: OPEN c_okx_asset_lines_v(p_asset_number);
2696: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2697: IF c_okx_asset_lines_v%NOTFOUND THEN
2698: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2699: END IF;
2700: CLOSE c_okx_asset_lines_v;
2701:

Line 2700: CLOSE c_okx_asset_lines_v;

2696: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2697: IF c_okx_asset_lines_v%NOTFOUND THEN
2698: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2699: END IF;
2700: CLOSE c_okx_asset_lines_v;
2701:
2702: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V
2703: -- for Split Asset scenario.
2704: OPEN c_txd_assets_v(p_asset_number);

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

2727: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2728: END IF;
2729: CLOSE c_okx_assets_v;
2730:
2731: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2732: OPEN c_okx_asset_lines_v(p_asset_number);
2733: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2734: IF c_okx_asset_lines_v%NOTFOUND THEN
2735: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2732: OPEN c_okx_asset_lines_v(p_asset_number);

2728: END IF;
2729: CLOSE c_okx_assets_v;
2730:
2731: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2732: OPEN c_okx_asset_lines_v(p_asset_number);
2733: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2734: IF c_okx_asset_lines_v%NOTFOUND THEN
2735: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2736: END IF;

Line 2733: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;

2729: CLOSE c_okx_assets_v;
2730:
2731: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2732: OPEN c_okx_asset_lines_v(p_asset_number);
2733: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2734: IF c_okx_asset_lines_v%NOTFOUND THEN
2735: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2736: END IF;
2737: CLOSE c_okx_asset_lines_v;

Line 2734: IF c_okx_asset_lines_v%NOTFOUND THEN

2730:
2731: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2732: OPEN c_okx_asset_lines_v(p_asset_number);
2733: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2734: IF c_okx_asset_lines_v%NOTFOUND THEN
2735: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2736: END IF;
2737: CLOSE c_okx_asset_lines_v;
2738:

Line 2737: CLOSE c_okx_asset_lines_v;

2733: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2734: IF c_okx_asset_lines_v%NOTFOUND THEN
2735: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2736: END IF;
2737: CLOSE c_okx_asset_lines_v;
2738:
2739: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V
2740: -- for Split Asset scenario.
2741: OPEN c_txd_assets_v(p_asset_number);

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

2746: CLOSE c_txd_assets_v;
2747: END IF;
2748:
2749: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR
2750: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN
2751: -- store SQL error message on message stack
2752: OKL_API.set_message(p_app_name => G_APP_NAME,
2753: p_msg_name => G_ASSET_NUMBER);
2754: RAISE G_EXCEPTION_HALT_VALIDATION;

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

2752: OKL_API.set_message(p_app_name => G_APP_NAME,
2753: p_msg_name => G_ASSET_NUMBER);
2754: RAISE G_EXCEPTION_HALT_VALIDATION;
2755: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND
2756: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN
2757: -- store SQL error message on message stack
2758: OKL_API.set_message(p_app_name => G_APP_NAME,
2759: p_msg_name => G_ASSET_NUMBER);
2760: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 2779: IF c_okx_asset_lines_v%ISOPEN THEN

2775: END IF;
2776: IF c_okx_assets_v%ISOPEN THEN
2777: CLOSE c_okx_assets_v;
2778: END IF;
2779: IF c_okx_asset_lines_v%ISOPEN THEN
2780: CLOSE c_okx_asset_lines_v;
2781: END IF;
2782: IF c_check_release_asset%ISOPEN THEN
2783: CLOSE c_check_release_asset;

Line 2780: CLOSE c_okx_asset_lines_v;

2776: IF c_okx_assets_v%ISOPEN THEN
2777: CLOSE c_okx_assets_v;
2778: END IF;
2779: IF c_okx_asset_lines_v%ISOPEN THEN
2780: CLOSE c_okx_asset_lines_v;
2781: END IF;
2782: IF c_check_release_asset%ISOPEN THEN
2783: CLOSE c_check_release_asset;
2784: END IF;

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 2826: IF c_okx_asset_lines_v%ISOPEN THEN

2822: END IF;
2823: IF c_okx_assets_v%ISOPEN THEN
2824: CLOSE c_okx_assets_v;
2825: END IF;
2826: IF c_okx_asset_lines_v%ISOPEN THEN
2827: CLOSE c_okx_asset_lines_v;
2828: END IF;
2829: IF c_check_release_asset%ISOPEN THEN
2830: CLOSE c_check_release_asset;

Line 2827: CLOSE c_okx_asset_lines_v;

2823: IF c_okx_assets_v%ISOPEN THEN
2824: CLOSE c_okx_assets_v;
2825: END IF;
2826: IF c_okx_asset_lines_v%ISOPEN THEN
2827: CLOSE c_okx_asset_lines_v;
2828: END IF;
2829: IF c_check_release_asset%ISOPEN THEN
2830: CLOSE c_check_release_asset;
2831: END IF;

Line 2851: ln_okx_asset_lines_v NUMBER := 0;

2847: p_asset_number IN OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE,
2848: p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE) IS
2849: ln_okl_txl_assets_v NUMBER := 0;
2850: ln_okx_assets_v NUMBER := 0;
2851: ln_okx_asset_lines_v NUMBER := 0;
2852: ln_okl_txd_assets_v NUMBER := 0;
2853: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';
2854:
2855: CURSOR c_txl_asset_number(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is

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

2857: --FROM DUAL
2858: --WHERE EXISTS (SELECT '1'
2859: FROM OKL_TXL_ASSETS_B
2860: WHERE asset_number = p_asset_number; --);
2861: /*CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2862: SELECT 1
2863: --FROM DUAL
2864: --WHERE EXISTS (SELECT '1'
2865: FROM OKX_ASSET_LINES_V

Line 2865: FROM OKX_ASSET_LINES_V

2861: /*CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2862: SELECT 1
2863: --FROM DUAL
2864: --WHERE EXISTS (SELECT '1'
2865: FROM OKX_ASSET_LINES_V
2866: WHERE asset_number = p_asset_number; --); */
2867: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2868: SELECT 1
2869: FROM fa_additions a

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

2863: --FROM DUAL
2864: --WHERE EXISTS (SELECT '1'
2865: FROM OKX_ASSET_LINES_V
2866: WHERE asset_number = p_asset_number; --); */
2867: CURSOR c_okx_asset_lines_v(p_asset_number OKX_ASSETS_V.ASSET_NUMBER%TYPE) is
2868: SELECT 1
2869: FROM fa_additions a
2870: WHERE a.asset_number = p_asset_number
2871: and exists

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

2957: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2958: END IF;
2959: CLOSE c_okx_assets_v;
2960:
2961: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2962: OPEN c_okx_asset_lines_v(p_asset_number);
2963: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2964: IF c_okx_asset_lines_v%NOTFOUND THEN
2965: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2962: OPEN c_okx_asset_lines_v(p_asset_number);

2958: END IF;
2959: CLOSE c_okx_assets_v;
2960:
2961: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2962: OPEN c_okx_asset_lines_v(p_asset_number);
2963: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2964: IF c_okx_asset_lines_v%NOTFOUND THEN
2965: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2966: END IF;

Line 2963: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;

2959: CLOSE c_okx_assets_v;
2960:
2961: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2962: OPEN c_okx_asset_lines_v(p_asset_number);
2963: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2964: IF c_okx_asset_lines_v%NOTFOUND THEN
2965: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2966: END IF;
2967: CLOSE c_okx_asset_lines_v;

Line 2964: IF c_okx_asset_lines_v%NOTFOUND THEN

2960:
2961: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
2962: OPEN c_okx_asset_lines_v(p_asset_number);
2963: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2964: IF c_okx_asset_lines_v%NOTFOUND THEN
2965: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2966: END IF;
2967: CLOSE c_okx_asset_lines_v;
2968:

Line 2967: CLOSE c_okx_asset_lines_v;

2963: FETCH c_okx_asset_lines_v into ln_okx_asset_lines_v;
2964: IF c_okx_asset_lines_v%NOTFOUND THEN
2965: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2966: END IF;
2967: CLOSE c_okx_asset_lines_v;
2968:
2969: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V
2970: -- for Split Asset scenario.
2971: OPEN c_txd_assets_v(p_asset_number);

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

2975: END IF;
2976: CLOSE c_txd_assets_v;
2977:
2978: IF (ln_okl_txl_assets_v = 1) OR (ln_okx_assets_v = 1) OR
2979: (ln_okx_asset_lines_v = 1) OR (ln_okl_txd_assets_v = 1) THEN
2980: -- store SQL error message on message stack
2981: OKL_API.set_message(p_app_name => G_APP_NAME,
2982: p_msg_name => G_ASSET_NUMBER);
2983: RAISE G_EXCEPTION_HALT_VALIDATION;

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

2981: OKL_API.set_message(p_app_name => G_APP_NAME,
2982: p_msg_name => G_ASSET_NUMBER);
2983: RAISE G_EXCEPTION_HALT_VALIDATION;
2984: ELSIF (ln_okl_txl_assets_v = 1) AND (ln_okx_assets_v = 1) AND
2985: (ln_okx_asset_lines_v = 1) AND (ln_okl_txd_assets_v = 1) THEN
2986: -- store SQL error message on message stack
2987: OKL_API.set_message(p_app_name => G_APP_NAME,
2988: p_msg_name => G_ASSET_NUMBER);
2989: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 3006: IF c_okx_asset_lines_v%ISOPEN THEN

3002: END IF;
3003: IF c_okx_assets_v%ISOPEN THEN
3004: CLOSE c_okx_assets_v;
3005: END IF;
3006: IF c_okx_asset_lines_v%ISOPEN THEN
3007: CLOSE c_okx_asset_lines_v;
3008: END IF;
3009: IF c_txd_assets_v%ISOPEN THEN
3010: CLOSE c_txd_assets_v;

Line 3007: CLOSE c_okx_asset_lines_v;

3003: IF c_okx_assets_v%ISOPEN THEN
3004: CLOSE c_okx_assets_v;
3005: END IF;
3006: IF c_okx_asset_lines_v%ISOPEN THEN
3007: CLOSE c_okx_asset_lines_v;
3008: END IF;
3009: IF c_txd_assets_v%ISOPEN THEN
3010: CLOSE c_txd_assets_v;
3011: END IF;

Line 3033: IF c_okx_asset_lines_v%ISOPEN THEN

3029: END IF;
3030: IF c_okx_assets_v%ISOPEN THEN
3031: CLOSE c_okx_assets_v;
3032: END IF;
3033: IF c_okx_asset_lines_v%ISOPEN THEN
3034: CLOSE c_okx_asset_lines_v;
3035: END IF;
3036: IF c_txd_assets_v%ISOPEN THEN
3037: CLOSE c_txd_assets_v;

Line 3034: CLOSE c_okx_asset_lines_v;

3030: IF c_okx_assets_v%ISOPEN THEN
3031: CLOSE c_okx_assets_v;
3032: END IF;
3033: IF c_okx_asset_lines_v%ISOPEN THEN
3034: CLOSE c_okx_asset_lines_v;
3035: END IF;
3036: IF c_txd_assets_v%ISOPEN THEN
3037: CLOSE c_txd_assets_v;
3038: END IF;

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

3088: -- halt validation as it is a required field
3089: RAISE G_EXCEPTION_STOP_VALIDATION;
3090: END IF;
3091: -- Enforce validation
3092: -- Validate if the Asset Number exists in OKX_ASSET_LINES_V
3093: OPEN c_asset_lines_dtls_v(p_asset_number => p_asset_number,
3094: p_tax_book => p_tax_book,
3095: p_tal_id => p_tal_id);
3096: FETCH c_asset_lines_dtls_v into ln_asset_lines_dtls;

Line 5905: FROM OKX_ASSET_LINES_V

5901: IS
5902: SELECT 1
5903: --FROM DUAL
5904: --WHERE EXISTS (SELECT '1'
5905: FROM OKX_ASSET_LINES_V
5906: WHERE id1 = p_id1
5907: AND id2 = p_id2
5908: AND dnz_chr_id <> p_dnz_chr_id
5909: AND line_status NOT IN ('EXPRIED','TERMINATED','ABANDONED'); --);