APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on OKL_K_LINES

Line 292: l_parent_cle_id okl_k_lines.id%type;

288:
289: row_count Number default 0;
290:
291: l_chr_id okl_k_headers.id%type;
292: l_parent_cle_id okl_k_lines.id%type;
293: l_cle_id okl_k_lines.id%type;
294: l_lty_code okc_line_styles_b.lty_code%type;
295: l_id okl_k_lines.id%type;
296:

Line 293: l_cle_id okl_k_lines.id%type;

289: row_count Number default 0;
290:
291: l_chr_id okl_k_headers.id%type;
292: l_parent_cle_id okl_k_lines.id%type;
293: l_cle_id okl_k_lines.id%type;
294: l_lty_code okc_line_styles_b.lty_code%type;
295: l_id okl_k_lines.id%type;
296:
297: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Link_Asset';

Line 295: l_id okl_k_lines.id%type;

291: l_chr_id okl_k_headers.id%type;
292: l_parent_cle_id okl_k_lines.id%type;
293: l_cle_id okl_k_lines.id%type;
294: l_lty_code okc_line_styles_b.lty_code%type;
295: l_id okl_k_lines.id%type;
296:
297: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Link_Asset';
298: l_api_version CONSTANT NUMBER := 1.0;
299: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 303: from okl_k_lines_full_v sub_line, okc_k_items_v link_ast

299: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
300:
301: CURSOR get_item_csr(p_chr_id NUMBER, p_parent_cle_id NUMBER, p_link_ast_id1 VARCHAR2, p_link_ast_id2 VARCHAR2) IS
302: SELECT link_ast.id
303: from okl_k_lines_full_v sub_line, okc_k_items_v link_ast
304: where sub_line.id = link_ast.cle_id
305: and link_ast.object1_id1 = p_link_ast_id1
306: and link_ast.object1_id2 = p_link_ast_id2
307: and sub_line.cle_id = p_parent_cle_id

Line 1145: from okl_k_lines_full_v cle

1141: and cle.dnz_chr_id = p_chr_id;
1142:
1143: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
1144: select cle.fee_type
1145: from okl_k_lines_full_v cle
1146: where cle.id = p_cle_id
1147: and cle.dnz_chr_id = p_chr_id;
1148:
1149: lp_clev_tbl OKL_OKC_MIGRATION_PVT.clev_tbl_type;

Line 1166: --cursor to find out the fee type from okl_k_lines

1162: l_fin_klev_rec okl_contract_pub.klev_rec_type;
1163: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1164: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
1165:
1166: --cursor to find out the fee type from okl_k_lines
1167: cursor l_fee_type_csr (p_cle_id in number) is
1168: select fee_type
1169: from okl_k_lines kle
1170: where kle.id = p_cle_id;

Line 1169: from okl_k_lines kle

1165:
1166: --cursor to find out the fee type from okl_k_lines
1167: cursor l_fee_type_csr (p_cle_id in number) is
1168: select fee_type
1169: from okl_k_lines kle
1170: where kle.id = p_cle_id;
1171:
1172: l_fee_type okl_k_lines.fee_type%TYPE;
1173: --Bug#3877032

Line 1172: l_fee_type okl_k_lines.fee_type%TYPE;

1168: select fee_type
1169: from okl_k_lines kle
1170: where kle.id = p_cle_id;
1171:
1172: l_fee_type okl_k_lines.fee_type%TYPE;
1173: --Bug#3877032
1174:
1175: BEGIN
1176:

Line 1583: l_fee_type okl_k_lines_full_v.fee_type%type := null;

1579: i NUMBER;
1580: l_chr_id NUMBER;
1581: l_parent_cle_id NUMBER;
1582: l_cnt number := 0;
1583: l_fee_type okl_k_lines_full_v.fee_type%type := null;
1584: l_amount number := null;
1585:
1586: l_currency_code okl_k_headers_full_v.currency_code%type := null;
1587: l_sts_code okl_k_headers_full_v.sts_code%type := null;

Line 1642: --cursor to find out the fee type from okl_k_lines

1638: l_fin_klev_rec okl_contract_pub.klev_rec_type;
1639: lx_fin_clev_rec okl_okc_migration_pvt.clev_rec_type;
1640: lx_fin_klev_rec okl_contract_pub.klev_rec_type;
1641:
1642: --cursor to find out the fee type from okl_k_lines
1643: cursor l_fee_type_csr (p_cle_id in number) is
1644: select fee_type
1645: from okl_k_lines kle
1646: where kle.id = p_cle_id;

Line 1645: from okl_k_lines kle

1641:
1642: --cursor to find out the fee type from okl_k_lines
1643: cursor l_fee_type_csr (p_cle_id in number) is
1644: select fee_type
1645: from okl_k_lines kle
1646: where kle.id = p_cle_id;
1647:
1648: --cursor to get old asset id
1649: cursor l_old_ast_csr (p_cim_id in number) is

Line 1663: from okl_k_lines_full_v cle

1659: --Bug# 3877032
1660:
1661: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
1662: select cle.fee_type
1663: from okl_k_lines_full_v cle
1664: where cle.id = p_cle_id
1665: and cle.dnz_chr_id = p_chr_id;
1666:
1667: BEGIN

Line 2162: l_fee_type okl_k_lines_full_v.fee_type%type := null;

2158:
2159: l_start_date okc_k_lines_b.start_date%type := null;
2160: l_end_date okc_k_lines_b.end_date%type := null;
2161: l_amount number;
2162: l_fee_type okl_k_lines_full_v.fee_type%type := null;
2163:
2164: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
2165: select cle.fee_type
2166: from okl_k_lines_full_v cle

Line 2166: from okl_k_lines_full_v cle

2162: l_fee_type okl_k_lines_full_v.fee_type%type := null;
2163:
2164: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
2165: select cle.fee_type
2166: from okl_k_lines_full_v cle
2167: where cle.id = p_cle_id
2168: and cle.dnz_chr_id = p_chr_id;
2169:
2170: BEGIN

Line 2514: l_fee_type okl_k_lines.fee_type%type := null;

2510: select chr.start_date, chr.end_date
2511: from okc_k_lines_b chr
2512: where id = l_id;
2513:
2514: l_fee_type okl_k_lines.fee_type%type := null;
2515: l_amount NUMBER := null;
2516: l_start_date okc_k_lines_b.start_date%type := null;
2517: l_end_date okc_k_lines_b.end_date%type := null;
2518:

Line 2521: from okl_k_lines_full_v cle

2517: l_end_date okc_k_lines_b.end_date%type := null;
2518:
2519: CURSOR get_fee_type_csr(p_chr_id number, p_cle_id number) IS
2520: select cle.fee_type
2521: from okl_k_lines_full_v cle
2522: where cle.id = p_cle_id
2523: and cle.dnz_chr_id = p_chr_id;
2524:
2525: -- Bug# 6598350

Line 2950: okl_k_lines fee_kle

2946: from okc_k_items cim,
2947: okc_k_lines_b lnk_fee_cleb,
2948: okc_line_styles_b lnk_fee_lseb,
2949: okc_k_lines_b fee_cleb,
2950: okl_k_lines fee_kle
2951: where cim.id = p_cim_id
2952: and lnk_fee_cleb.id = p_cle_id
2953: and cim.dnz_chr_id = lnk_fee_cleb.dnz_chr_id
2954: and lnk_fee_cleb.lse_id = lnk_fee_lseb.id