APPS.OKL_CONTRACT_LINE_ITEM_PVT dependencies on OKC_K_ITEMS_V

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