APPS.OKL_DEAL_PAYMENTS_PVT dependencies on OKC_K_LINES_TL

Line 113: l_asset_number OKC_K_LINES_TL.name%TYPE;

109: p_cle_id IN NUMBER,
110: p_lse_id IN NUMBER)
111: RETURN VARCHAR2 IS
112:
113: l_asset_number OKC_K_LINES_TL.name%TYPE;
114:
115: CURSOR l_asset_num_fin_csr(p_cle_id IN NUMBER) IS
116: SELECT clet_fin.name
117: FROM okc_k_lines_tl clet_fin

Line 117: FROM okc_k_lines_tl clet_fin

113: l_asset_number OKC_K_LINES_TL.name%TYPE;
114:
115: CURSOR l_asset_num_fin_csr(p_cle_id IN NUMBER) IS
116: SELECT clet_fin.name
117: FROM okc_k_lines_tl clet_fin
118: WHERE clet_fin.id = p_cle_id
119: AND clet_fin.language = USERENV('LANG');
120:
121: CURSOR l_asset_num_cov_asset_csr(p_cle_id IN NUMBER,

Line 124: FROM okc_k_lines_tl clet_fin,

120:
121: CURSOR l_asset_num_cov_asset_csr(p_cle_id IN NUMBER,
122: p_chr_id IN NUMBER) IS
123: SELECT clet_fin.name
124: FROM okc_k_lines_tl clet_fin,
125: okc_k_items cim_cov_asset
126: WHERE cim_cov_asset.cle_id = p_cle_id
127: AND cim_cov_asset.dnz_chr_id = p_chr_id
128: AND cim_cov_asset.jtot_object1_code = 'OKX_COVASST'

Line 182: FROM okc_k_lines_tl clet_fin

178: CURSOR l_asset_num_fin_csr(p_cle_id IN NUMBER) IS
179: SELECT clet_fin.id,
180: clet_fin.name,
181: clet_fin.item_description
182: FROM okc_k_lines_tl clet_fin
183: WHERE clet_fin.id = p_cle_id
184: AND clet_fin.language = USERENV('LANG');
185:
186: CURSOR l_asset_num_cov_asset_csr(p_cle_id IN NUMBER,

Line 191: FROM okc_k_lines_tl clet_fin,

187: p_chr_id IN NUMBER) IS
188: SELECT clet_fin.id,
189: clet_fin.name,
190: clet_fin.item_description
191: FROM okc_k_lines_tl clet_fin,
192: okc_k_items cim_cov_asset
193: WHERE cim_cov_asset.cle_id = p_cle_id
194: AND cim_cov_asset.dnz_chr_id = p_chr_id
195: AND cim_cov_asset.jtot_object1_code = 'OKX_COVASST'

Line 203: l_asset_number OKC_K_LINES_TL.name%TYPE;

199:
200: l_service_fee_cle_id OKC_K_LINES_B.id%TYPE;
201: l_service_fee_name VARCHAR2(2000);
202: l_asset_cle_id OKC_K_LINES_B.id%TYPE;
203: l_asset_number OKC_K_LINES_TL.name%TYPE;
204: l_asset_description OKC_K_LINES_TL.item_description%TYPE;
205:
206: BEGIN
207: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 204: l_asset_description OKC_K_LINES_TL.item_description%TYPE;

200: l_service_fee_cle_id OKC_K_LINES_B.id%TYPE;
201: l_service_fee_name VARCHAR2(2000);
202: l_asset_cle_id OKC_K_LINES_B.id%TYPE;
203: l_asset_number OKC_K_LINES_TL.name%TYPE;
204: l_asset_description OKC_K_LINES_TL.item_description%TYPE;
205:
206: BEGIN
207: x_return_status := OKL_API.G_RET_STS_SUCCESS;
208: -- Call start_activity to create savepoint, check compatibility and initialize message list