APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on OKC_K_ITEMS

Line 277: l_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;

273: l_where_clause varchar2(2000) default null;
274: l_order_by_clause varchar2(2000) default null;
275: l_query_string varchar2(2000) default null;
276:
277: l_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
278: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
279: l_name VARCHAR2(250) Default Null;
280: l_description VARCHAR2(250) Default Null;
281: l_object_code VARCHAR2(30) Default Null;

Line 278: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;

274: l_order_by_clause varchar2(2000) default null;
275: l_query_string varchar2(2000) default null;
276:
277: l_id1 OKC_K_ITEMS_V.OBJECT1_ID1%TYPE default Null;
278: l_id2 OKC_K_ITEMS_V.OBJECT1_ID2%TYPE default Null;
279: l_name VARCHAR2(250) Default Null;
280: l_description VARCHAR2(250) Default Null;
281: l_object_code VARCHAR2(30) Default Null;
282:

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 1107: l_item_id1 okc_k_items.object1_id1%type := null;

1103: l_currency_code okl_k_headers_full_v.currency_code%type := null;
1104: l_sts_code okl_k_headers_full_v.sts_code%type := null;
1105: l_lse_id okc_line_styles_b.id%type := null;
1106: l_lty_code okc_line_styles_b.lty_code%type := null;
1107: l_item_id1 okc_k_items.object1_id1%type := null;
1108: l_item_id2 okc_k_items.object1_id2%type := null;
1109: l_amount number := null;
1110:
1111: CURSOR get_link_fee_asset_csr(p_chr_id number, p_cle_id number, p_name varchar2) IS

Line 1108: l_item_id2 okc_k_items.object1_id2%type := null;

1104: l_sts_code okl_k_headers_full_v.sts_code%type := null;
1105: l_lse_id okc_line_styles_b.id%type := null;
1106: l_lty_code okc_line_styles_b.lty_code%type := null;
1107: l_item_id1 okc_k_items.object1_id1%type := null;
1108: l_item_id2 okc_k_items.object1_id2%type := null;
1109: l_amount number := null;
1110:
1111: CURSOR get_link_fee_asset_csr(p_chr_id number, p_cle_id number, p_name varchar2) IS
1112: SELECT ID1, ID2

Line 1590: l_item_id1 okc_k_items.object1_id1%type := null;

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;
1588: l_lse_id okc_line_styles_b.id%type := null;
1589: l_lty_code okc_line_styles_b.lty_code%type := null;
1590: l_item_id1 okc_k_items.object1_id1%type := null;
1591: l_item_id2 okc_k_items.object1_id2%type := null;
1592:
1593: CURSOR get_link_fee_asset_csr(p_chr_id number, p_cle_id number, p_name varchar2) IS
1594: SELECT ID1, ID2

Line 1591: l_item_id2 okc_k_items.object1_id2%type := null;

1587: l_sts_code okl_k_headers_full_v.sts_code%type := null;
1588: l_lse_id okc_line_styles_b.id%type := null;
1589: l_lty_code okc_line_styles_b.lty_code%type := null;
1590: l_item_id1 okc_k_items.object1_id1%type := null;
1591: l_item_id2 okc_k_items.object1_id2%type := null;
1592:
1593: CURSOR get_link_fee_asset_csr(p_chr_id number, p_cle_id number, p_name varchar2) IS
1594: SELECT ID1, ID2
1595: FROM OKL_LA_FEE_COVERED_ASSET_UV

Line 1651: from okc_k_items

1647:
1648: --cursor to get old asset id
1649: cursor l_old_ast_csr (p_cim_id in number) is
1650: select object1_id1, dnz_chr_id
1651: from okc_k_items
1652: where id = p_cim_id;
1653:
1654: l_fin_clev_tbl okl_okc_migration_pvt.clev_tbl_type;
1655: l_fin_klev_tbl okl_contract_pub.klev_tbl_type;

Line 2898: FROM okc_line_styles_b lse, okc_k_lines_b lines, okc_k_items items

2894: */
2895: --cursor to fetch the line style code for line style id of the record.
2896: CURSOR lty_code_csr(p_id okc_k_lines_b.id%TYPE) IS
2897: SELECT lse.lty_code lty_code, items.object1_id1 asset_id
2898: FROM okc_line_styles_b lse, okc_k_lines_b lines, okc_k_items items
2899: WHERE lines.id = p_id
2900: AND lse.id = lines.lse_id
2901: AND items.cle_id = lines.id;
2902:

Line 2946: from okc_k_items cim,

2942: cursor l_cap_fee_asst_csr (p_cle_id in number,
2943: p_cim_id in number) is
2944: select cim.object1_id1,
2945: cim.dnz_chr_id
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