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 OKL_TXD_ASSETS_V

Line 1157: FROM Okl_Txd_Assets_V txd

1153: last_update_date,
1154: last_update_login,
1155: split_percent,
1156: inventory_item_id
1157: FROM Okl_Txd_Assets_V txd
1158: WHERE txd.tal_id = p_tal_id;
1159: BEGIN
1160: FOR r_okl_asdv_pk_csr IN c_okl_asdv_pk_csr(p_tal_id) LOOP
1161: x_txdv_tbl(i).ID := r_okl_asdv_pk_csr.ID;

Line 2496: ln_okl_txd_assets_v NUMBER := 0;

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;
2500: lv_release_asset OKC_RULES_V.RULE_INFORMATION1%TYPE := 'N';

Line 2543: OKL_TXD_ASSETS_V TXD

2539: --FROM DUAL
2540: --WHERE EXISTS (SELECT '1'
2541: FROM OKL_TRX_ASSETS TAS,
2542: OKL_TXL_ASSETS_V TXL,
2543: OKL_TXD_ASSETS_V TXD
2544: WHERE TXD.asset_number = p_asset_number
2545: AND TXD.TAL_ID = TXL.ID
2546: AND TXL.TAL_TYPE = 'ALI'
2547: AND TXL.TAS_ID = TAS.ID

Line 2686: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V

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);
2689: FETCH c_txd_assets_v into ln_okl_txd_assets_v;
2690: IF c_txd_assets_v%NOTFOUND THEN

Line 2689: FETCH c_txd_assets_v into ln_okl_txd_assets_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);
2689: FETCH c_txd_assets_v into ln_okl_txd_assets_v;
2690: IF c_txd_assets_v%NOTFOUND THEN
2691: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2692: END IF;
2693: CLOSE c_txd_assets_v;

Line 2722: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V

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);
2725: FETCH c_txd_assets_v into ln_okl_txd_assets_v;
2726: IF c_txd_assets_v%NOTFOUND THEN

Line 2725: FETCH c_txd_assets_v into ln_okl_txd_assets_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);
2725: FETCH c_txd_assets_v into ln_okl_txd_assets_v;
2726: IF c_txd_assets_v%NOTFOUND THEN
2727: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2728: END IF;
2729: CLOSE c_txd_assets_v;

Line 2759: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V

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);
2762: FETCH c_txd_assets_v into ln_okl_txd_assets_v;
2763: IF c_txd_assets_v%NOTFOUND THEN

Line 2762: FETCH c_txd_assets_v into ln_okl_txd_assets_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);
2762: FETCH c_txd_assets_v into ln_okl_txd_assets_v;
2763: IF c_txd_assets_v%NOTFOUND THEN
2764: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2765: END IF;
2766: CLOSE c_txd_assets_v;

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 2872: ln_okl_txd_assets_v NUMBER := 0;

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
2876: SELECT 1

Line 2911: OKL_TXD_ASSETS_V TXD

2907: --FROM DUAL
2908: --WHERE EXISTS (SELECT '1'
2909: FROM OKL_TRX_ASSETS TAS,
2910: OKL_TXL_ASSETS_V TXL,
2911: OKL_TXD_ASSETS_V TXD
2912: WHERE TXD.asset_number = p_asset_number
2913: AND TXD.TAL_ID = TXL.ID
2914: AND TXL.TAL_TYPE = 'ALI'
2915: AND TXL.TAS_ID = TAS.ID

Line 3010: -- Validate if the Asset Number exists in OKL_TXD_ASSETS_V

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);
3013: FETCH c_txd_assets_v into ln_okl_txd_assets_v;
3014: IF c_txd_assets_v%NOTFOUND THEN

Line 3013: FETCH c_txd_assets_v into ln_okl_txd_assets_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);
3013: FETCH c_txd_assets_v into ln_okl_txd_assets_v;
3014: IF c_txd_assets_v%NOTFOUND THEN
3015: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3016: END IF;
3017: CLOSE c_txd_assets_v;

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;