APPS.OKL_SPLIT_ASSET_PVT dependencies on OKL_K_LINES_V

Line 7329: -- FUNCTION get_rec for: OKL_K_LINES_V

7325: BEGIN
7326: RETURN(get_cimv_rec(p_cle_id, l_row_notfound));
7327: END get_cimv_rec;
7328: ---------------------------------------------------------------------------
7329: -- FUNCTION get_rec for: OKL_K_LINES_V
7330: ---------------------------------------------------------------------------
7331: FUNCTION get_klev_rec (
7332: p_cle_id IN NUMBER,
7333: x_no_data_found OUT NOCOPY BOOLEAN

Line 7335: CURSOR okl_k_lines_v_csr (p_id IN NUMBER) IS

7331: FUNCTION get_klev_rec (
7332: p_cle_id IN NUMBER,
7333: x_no_data_found OUT NOCOPY BOOLEAN
7334: ) RETURN klev_rec_type IS
7335: CURSOR okl_k_lines_v_csr (p_id IN NUMBER) IS
7336: SELECT
7337: ID,
7338: OBJECT_VERSION_NUMBER,
7339: KLE_ID,

Line 7474: FROM OKL_K_LINES_V

7470: -- Bug#4508050 - smadhava - Added - End
7471: --Bug# 4631549
7472: ,Expected_asset_cost
7473:
7474: FROM OKL_K_LINES_V
7475: WHERE OKL_K_LINES_V.id = p_id;
7476: l_klev_rec klev_rec_type;
7477: BEGIN
7478:

Line 7475: WHERE OKL_K_LINES_V.id = p_id;

7471: --Bug# 4631549
7472: ,Expected_asset_cost
7473:
7474: FROM OKL_K_LINES_V
7475: WHERE OKL_K_LINES_V.id = p_id;
7476: l_klev_rec klev_rec_type;
7477: BEGIN
7478:
7479: x_no_data_found := TRUE;

Line 7481: OPEN okl_k_lines_v_csr (p_cle_id);

7477: BEGIN
7478:
7479: x_no_data_found := TRUE;
7480: -- Get current database values
7481: OPEN okl_k_lines_v_csr (p_cle_id);
7482: FETCH okl_k_lines_v_csr INTO
7483: l_klev_rec.ID,
7484: l_klev_rec.OBJECT_VERSION_NUMBER,
7485: l_klev_rec.KLE_ID,

Line 7482: FETCH okl_k_lines_v_csr INTO

7478:
7479: x_no_data_found := TRUE;
7480: -- Get current database values
7481: OPEN okl_k_lines_v_csr (p_cle_id);
7482: FETCH okl_k_lines_v_csr INTO
7483: l_klev_rec.ID,
7484: l_klev_rec.OBJECT_VERSION_NUMBER,
7485: l_klev_rec.KLE_ID,
7486: l_klev_rec.STY_ID,

Line 7620: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;

7616: -- Bug#4508050 - smadhava - Added - End
7617: --Bug# 4631549
7618: ,l_klev_rec.Expected_Asset_Cost
7619: ;
7620: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;
7621: CLOSE okl_k_lines_v_csr;
7622: RETURN(l_klev_rec);
7623: END get_klev_rec;
7624:

Line 7621: CLOSE okl_k_lines_v_csr;

7617: --Bug# 4631549
7618: ,l_klev_rec.Expected_Asset_Cost
7619: ;
7620: x_no_data_found := okl_k_lines_v_csr%NOTFOUND;
7621: CLOSE okl_k_lines_v_csr;
7622: RETURN(l_klev_rec);
7623: END get_klev_rec;
7624:
7625: FUNCTION get_klev_rec (