APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_K_LINES_V

Line 7276: -- FUNCTION get_rec for: OKL_K_LINES_V

7272: BEGIN
7273: RETURN(get_cimv_rec(p_cle_id, l_row_notfound));
7274: END get_cimv_rec;
7275: ---------------------------------------------------------------------------
7276: -- FUNCTION get_rec for: OKL_K_LINES_V
7277: ---------------------------------------------------------------------------
7278: FUNCTION get_klev_rec (
7279: p_cle_id IN NUMBER,
7280: x_no_data_found OUT NOCOPY BOOLEAN

Line 7282: CURSOR okl_k_lines_v_csr (p_id IN NUMBER) IS

7278: FUNCTION get_klev_rec (
7279: p_cle_id IN NUMBER,
7280: x_no_data_found OUT NOCOPY BOOLEAN
7281: ) RETURN klev_rec_type IS
7282: CURSOR okl_k_lines_v_csr (p_id IN NUMBER) IS
7283: SELECT
7284: ID,
7285: OBJECT_VERSION_NUMBER,
7286: KLE_ID,

Line 7421: FROM OKL_K_LINES_V

7417: -- Bug#4508050 - smadhava - Added - End
7418: --Bug# 4631549
7419: ,Expected_asset_cost
7420:
7421: FROM OKL_K_LINES_V
7422: WHERE OKL_K_LINES_V.id = p_id;
7423: l_klev_rec klev_rec_type;
7424: BEGIN
7425:

Line 7422: WHERE OKL_K_LINES_V.id = p_id;

7418: --Bug# 4631549
7419: ,Expected_asset_cost
7420:
7421: FROM OKL_K_LINES_V
7422: WHERE OKL_K_LINES_V.id = p_id;
7423: l_klev_rec klev_rec_type;
7424: BEGIN
7425:
7426: x_no_data_found := TRUE;

Line 7428: OPEN okl_k_lines_v_csr (p_cle_id);

7424: BEGIN
7425:
7426: x_no_data_found := TRUE;
7427: -- Get current database values
7428: OPEN okl_k_lines_v_csr (p_cle_id);
7429: FETCH okl_k_lines_v_csr INTO
7430: l_klev_rec.ID,
7431: l_klev_rec.OBJECT_VERSION_NUMBER,
7432: l_klev_rec.KLE_ID,

Line 7429: FETCH okl_k_lines_v_csr INTO

7425:
7426: x_no_data_found := TRUE;
7427: -- Get current database values
7428: OPEN okl_k_lines_v_csr (p_cle_id);
7429: FETCH okl_k_lines_v_csr INTO
7430: l_klev_rec.ID,
7431: l_klev_rec.OBJECT_VERSION_NUMBER,
7432: l_klev_rec.KLE_ID,
7433: l_klev_rec.STY_ID,

Line 7567: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;

7563: -- Bug#4508050 - smadhava - Added - End
7564: --Bug# 4631549
7565: ,l_klev_rec.Expected_Asset_Cost
7566: ;
7567: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;
7568: CLOSE okl_k_lines_v_csr;
7569: RETURN(l_klev_rec);
7570: END get_klev_rec;
7571:

Line 7568: CLOSE okl_k_lines_v_csr;

7564: --Bug# 4631549
7565: ,l_klev_rec.Expected_Asset_Cost
7566: ;
7567: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;
7568: CLOSE okl_k_lines_v_csr;
7569: RETURN(l_klev_rec);
7570: END get_klev_rec;
7571:
7572: FUNCTION get_klev_rec (