APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKC_K_LINES_TL

Line 54: FROM okc_k_lines_tl

50:
51: --cursor for asset_number
52: CURSOR asset_num_csr (p_fin_ast_id IN NUMBER) IS
53: SELECT name
54: FROM okc_k_lines_tl
55: WHERE id = p_fin_ast_id;
56:
57: --cursor to get new asset number
58: Cursor c_asset_no IS

Line 86: l_asset_number OKC_K_LINES_TL.NAME%TYPE;

82: where kle.name = p_asset_number
83: and kle.lse_id = lse.id
84: and lse.lty_code = 'FREE_FORM1');
85:
86: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
87: l_asset_new_number OKC_K_LINES_TL.NAME%TYPE;
88: l_asset_exists Varchar2(1) default 'N';
89: l_cle_id Number;
90:

Line 87: l_asset_new_number OKC_K_LINES_TL.NAME%TYPE;

83: and kle.lse_id = lse.id
84: and lse.lty_code = 'FREE_FORM1');
85:
86: l_asset_number OKC_K_LINES_TL.NAME%TYPE;
87: l_asset_new_number OKC_K_LINES_TL.NAME%TYPE;
88: l_asset_exists Varchar2(1) default 'N';
89: l_cle_id Number;
90:
91: l_clev_rec OKL_OKC_MIGRATION_PVT.clev_rec_type;