APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on OKC_K_LINES_B

Line 39: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS

35: G_TOP_LINE_STYLE CONSTANT VARCHAR2(30) := 'TLS';
36: l_api_name CONSTANT VARCHAR2(30) := 'CANCEL_ASSETS';
37:
38: --get the top line
39: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
40: SELECT cle.id top_line
41: FROM okc_line_styles_b lse,
42: okc_k_lines_b cle
43: WHERE cle.dnz_chr_id = p_dnz_chr_id

Line 42: okc_k_lines_b cle

38: --get the top line
39: CURSOR c_get_k_top_line(p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
40: SELECT cle.id top_line
41: FROM okc_line_styles_b lse,
42: okc_k_lines_b cle
43: WHERE cle.dnz_chr_id = p_dnz_chr_id
44: AND cle.cle_id IS NULL
45: AND cle.chr_id = cle.dnz_chr_id
46: AND cle.lse_id = lse.id

Line 101: OKC_K_LINES_B cle,

97: CURSOR l_txlv_csr (p_finasst_id IN NUMBER, p_asstno IN VARCHAR2) is
98: Select txlv.id,
99: txlv.asset_number
100: From OKL_TXL_ASSETS_V txlv,
101: OKC_K_LINES_B cle,
102: OKC_LINE_STYLES_B lse
103: Where txlv.kle_id = cle.id
104: And cle.lse_id = lse.id
105: And lse.lty_code = 'FIXED_ASSET'

Line 118: OKC_K_LINES_B cle,

114: Select txdv.id,
115: txdv.asset_number
116: From OKL_TXD_ASSETS_V txdv,
117: OKL_TXL_ASSETS_V txlv,
118: OKC_K_LINES_B cle,
119: OKC_LINE_STYLES_B lse
120: Where txdv.tal_id = txlv.id
121: And txlv.kle_id = cle.id
122: And cle.lse_id = lse.id

Line 792: UPDATE okc_k_lines_b

788: ) ;
789: --Bug# 7030390 End
790:
791: -- Update the status of the lines
792: UPDATE okc_k_lines_b
793: SET sts_code = 'ABANDONED'
794: WHERE dnz_chr_id = p_contract_id;
795:
796: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );