APPS.OKL_UBB_INTEGRATION_PVT dependencies on OKL_K_LINES_FULL_V

Line 47: from okl_k_lines_full_v line

43: -- Cursors
44: --Fixed Bug # 5484903
45: CURSOR usage_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
46: select *
47: from okl_k_lines_full_v line
48: where line.dnz_chr_id = p_chr_id and
49: --Bug# 6374869: subquesry was fetching multiple records as 'USAGE' line
50: --exists for OKS as well as OKL
51: line.lse_id = 56

Line 72: FROM OKL_K_LINES_FULL_V line

68: p_usage_line_id OKC_K_LINES_V.ID%TYPE) IS
69: SELECT id,
70: name ASSET_NUMBER,
71: line_number
72: FROM OKL_K_LINES_FULL_V line
73: WHERE line.dnz_chr_id = p_chr_id
74: AND line.cle_id = p_usage_line_id
75: -- added to handle abandon line
76: AND NOT EXISTS (

Line 86: FROM okl_k_lines_full_v ib_line,

82: CURSOR ib_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
83: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
84: SELECT ib_line.id,
85: ib_line.line_number
86: FROM okl_k_lines_full_v ib_line,
87: okl_k_lines_full_v inst_line,
88: okl_k_lines_full_v top_line
89: WHERE ib_line.cle_id = inst_line.id
90: AND inst_line.cle_id = top_line.id

Line 87: okl_k_lines_full_v inst_line,

83: p_top_line_id OKC_K_LINES_V.ID%TYPE) IS
84: SELECT ib_line.id,
85: ib_line.line_number
86: FROM okl_k_lines_full_v ib_line,
87: okl_k_lines_full_v inst_line,
88: okl_k_lines_full_v top_line
89: WHERE ib_line.cle_id = inst_line.id
90: AND inst_line.cle_id = top_line.id
91: AND ib_line.lse_id = (select id from okc_line_styles_v where lty_code = 'INST_ITEM')

Line 88: okl_k_lines_full_v top_line

84: SELECT ib_line.id,
85: ib_line.line_number
86: FROM okl_k_lines_full_v ib_line,
87: okl_k_lines_full_v inst_line,
88: okl_k_lines_full_v top_line
89: WHERE ib_line.cle_id = inst_line.id
90: AND inst_line.cle_id = top_line.id
91: AND ib_line.lse_id = (select id from okc_line_styles_v where lty_code = 'INST_ITEM')
92: AND inst_line.lse_id = (select id from okc_line_styles_v where lty_code = 'FREE_FORM2')

Line 1355: p_link_asset_line_id IN OKL_K_LINES_FULL_V.ID%TYPE,

1351: x_return_status OUT NOCOPY VARCHAR2,
1352: x_msg_count OUT NOCOPY NUMBER,
1353: x_msg_data OUT NOCOPY VARCHAR2,
1354: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1355: p_link_asset_line_id IN OKL_K_LINES_FULL_V.ID%TYPE,
1356: p_link_asset_line_no IN OKL_K_LINES_FULL_V.LINE_NUMBER%TYPE,
1357: x_top_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
1358: ) IS
1359:

Line 1356: p_link_asset_line_no IN OKL_K_LINES_FULL_V.LINE_NUMBER%TYPE,

1352: x_msg_count OUT NOCOPY NUMBER,
1353: x_msg_data OUT NOCOPY VARCHAR2,
1354: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1355: p_link_asset_line_id IN OKL_K_LINES_FULL_V.ID%TYPE,
1356: p_link_asset_line_no IN OKL_K_LINES_FULL_V.LINE_NUMBER%TYPE,
1357: x_top_line_id OUT NOCOPY OKC_K_LINES_V.ID%TYPE
1358: ) IS
1359:
1360: l_id OKC_K_LINES_V.ID%TYPE;

Line 1365: p_link_asset_line_id OKL_K_LINES_FULL_V.ID%TYPE) IS

1361: top_failed EXCEPTION;
1362: l_proc_name VARCHAR2(35) := 'GET_TOP_LINE_ID';
1363:
1364: CURSOR top_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1365: p_link_asset_line_id OKL_K_LINES_FULL_V.ID%TYPE) IS
1366: SELECT oki.object1_id1
1367: FROM okl_k_lines_full_v oklf,
1368: okc_k_items oki
1369: WHERE oklf.id = p_link_asset_line_id

Line 1367: FROM okl_k_lines_full_v oklf,

1363:
1364: CURSOR top_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1365: p_link_asset_line_id OKL_K_LINES_FULL_V.ID%TYPE) IS
1366: SELECT oki.object1_id1
1367: FROM okl_k_lines_full_v oklf,
1368: okc_k_items oki
1369: WHERE oklf.id = p_link_asset_line_id
1370: AND oklf.dnz_chr_id = p_chr_id
1371: AND oklf.id = oki.cle_id;